eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_SEARCH_FWK_PUB dependencies on FND_API

Line 114: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

110: X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
111: X_CUSTOMIZATION_CODE IN VARCHAR2,
112: X_REGION_APPLICATION_ID IN NUMBER,
113: X_REGION_CODE IN VARCHAR2,
114: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
115: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
116: X_ERRORCODE OUT NOCOPY NUMBER
117: )
118: IS

Line 135: IF FND_API.To_Boolean(x_init_msg_list) THEN

131: and name_query.region_code = x_region_code;
132:
133: BEGIN
134:
135: IF FND_API.To_Boolean(x_init_msg_list) THEN
136: FND_MSG_PUB.Initialize;
137: END IF;
138:
139: SELECT

Line 161: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

157: FND_MESSAGE.Set_Name(g_app_name, 'EGO_RF_RF_EXISTS');
158: FND_MESSAGE.Set_Token('NAME', l_name);
159: FND_MSG_PUB.Add;
160:
161: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
162:
163: ELSE
164:
165: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 165: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

161: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
162:
163: ELSE
164:
165: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
166:
167: END IF;
168:
169: END Check_Result_Format_Deletion;

Line 504: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

500: X_RF_CUSTOMIZATION_APPL_ID IN NUMBER DEFAULT NULL,
501: X_RF_CUSTOMIZATION_CODE IN VARCHAR2 DEFAULT NULL,
502: X_RF_REGION_APPLICATION_ID IN NUMBER DEFAULT NULL,
503: X_RF_REGION_CODE IN VARCHAR2 DEFAULT NULL,
504: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
505: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
506: X_ERRORCODE OUT NOCOPY NUMBER
507: )
508: IS

Line 516: IF (FND_API.To_Boolean(x_init_msg_list) = TRUE) THEN

512: l_current_user NUMBER;
513:
514: BEGIN
515:
516: IF (FND_API.To_Boolean(x_init_msg_list) = TRUE) THEN
517: FND_MSG_PUB.Initialize;
518: END IF;
519:
520: --first check unique constraint

Line 636: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

632: l_Sysdate,
633: l_current_user
634: );
635:
636: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
637:
638: ELSE
639:
640: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_CRITERIA_TEMPLATE');

Line 643: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

639:
640: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_CRITERIA_TEMPLATE');
641: FND_MSG_PUB.Add;
642:
643: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
644:
645: END IF;
646:
647: END Create_Criteria_Template;

Line 679: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

675: X_RF_CUSTOMIZATION_APPL_ID IN NUMBER DEFAULT NULL,
676: X_RF_CUSTOMIZATION_CODE IN VARCHAR2 DEFAULT NULL,
677: X_RF_REGION_APPLICATION_ID IN NUMBER DEFAULT NULL,
678: X_RF_REGION_CODE IN VARCHAR2 DEFAULT NULL,
679: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
680: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
681: X_ERRORCODE OUT NOCOPY NUMBER
682: )
683: IS

Line 690: IF FND_API.To_Boolean(x_init_msg_list) THEN

686: l_rowid VARCHAR2(255);
687:
688: BEGIN
689:
690: IF FND_API.To_Boolean(x_init_msg_list) THEN
691: FND_MSG_PUB.Initialize;
692: END IF;
693:
694: IF (Criteria_Template_Name_Exists(X_NAME

Line 773: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

769: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
770: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
771: AND REGION_CODE = X_REGION_CODE;
772:
773: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
774:
775: ELSE
776:
777: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_CRITERIA_TEMPLATE');

Line 780: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

776:
777: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_CRITERIA_TEMPLATE');
778: FND_MSG_PUB.Add;
779:
780: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
781:
782: END IF;
783:
784: END Update_Criteria_Template;

Line 794: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

790: X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
791: X_CUSTOMIZATION_CODE IN VARCHAR2,
792: X_REGION_APPLICATION_ID IN NUMBER,
793: X_REGION_CODE IN VARCHAR2,
794: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
795: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
796: X_ERRORCODE OUT NOCOPY NUMBER
797: )
798: IS

Line 806: IF FND_API.To_Boolean(x_init_msg_list) THEN

802: l_classification1 VARCHAR2(200);
803:
804: BEGIN
805:
806: IF FND_API.To_Boolean(x_init_msg_list) THEN
807: FND_MSG_PUB.Initialize;
808: END IF;
809:
810: --begin bug 10384119

Line 834: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

830: IF (l_count > 0) THEN
831: FND_MESSAGE.Set_Name(g_app_name, 'EGO_MR_RF_EXISTS'); --"The Match Rule \"&NAME\" cannot be deleted because it is referenced by Import Batches or Source Systems."
832: FND_MESSAGE.Set_Token('NAME', l_name);
833: FND_MSG_PUB.Add;
834: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
835: RETURN;
836: END IF;
837: END IF;
838: END IF;

Line 890: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

886: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
887: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
888: AND REGION_CODE = X_REGION_CODE;
889:
890: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
891:
892: ELSE
893:
894: SELECT

Line 908: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

904: FND_MESSAGE.Set_Name(g_app_name, 'EGO_CT_RF_EXISTS');
905: FND_MESSAGE.Set_Token('NAME', l_name);
906: FND_MSG_PUB.Add;
907:
908: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
909:
910: END IF;
911:
912: END Delete_Criteria_Template;

Line 1039: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1035: X_CREATION_DATE IN DATE,
1036: X_LAST_UPDATED_BY IN NUMBER,
1037: X_LAST_UPDATE_DATE IN DATE,
1038: X_LAST_UPDATE_LOGIN IN NUMBER,
1039: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1040: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1041: X_ERRORCODE OUT NOCOPY NUMBER
1042: )
1043: IS

Line 1049: IF FND_API.To_Boolean(x_init_msg_list) THEN

1045: l_Sysdate DATE := Sysdate;
1046:
1047: BEGIN
1048:
1049: IF FND_API.To_Boolean(x_init_msg_list) THEN
1050: FND_MSG_PUB.Initialize;
1051: END IF;
1052:
1053: IF (X_RF_CUSTOMIZATION_CODE IS NOT NULL) THEN

Line 1091: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1087: X_LAST_UPDATE_LOGIN
1088: );
1089: END IF;
1090:
1091: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1092: X_RETURN_STATUS := 'T';
1093:
1094:
1095: END create_criteria_template_rf;

Line 1112: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1108: X_RF_TAG IN VARCHAR2,
1109: X_LAST_UPDATED_BY IN NUMBER,
1110: X_LAST_UPDATE_DATE IN DATE,
1111: X_LAST_UPDATE_LOGIN IN NUMBER,
1112: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1113: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1114: X_ERRORCODE OUT NOCOPY NUMBER
1115: )
1116: IS

Line 1123: IF FND_API.To_Boolean(x_init_msg_list) THEN

1119: l_count NUMBER;
1120:
1121: BEGIN
1122:
1123: IF FND_API.To_Boolean(x_init_msg_list) THEN
1124: FND_MSG_PUB.Initialize;
1125: END IF;
1126:
1127: SELECT

Line 1147: ,FND_API.G_FALSE

1143: ,X_CUSTOMIZATION_CODE
1144: ,X_REGION_APPLICATION_ID
1145: ,X_REGION_CODE
1146: ,X_RF_TAG
1147: ,FND_API.G_FALSE
1148: ,X_RETURN_STATUS
1149: ,X_ERRORCODE
1150: );
1151: ELSE

Line 1173: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1169: END IF;
1170:
1171: END IF;
1172:
1173: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1174: X_RETURN_STATUS := 'T';
1175:
1176: END update_criteria_template_rf;
1177:

Line 1186: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1182: X_CUSTOMIZATION_CODE IN VARCHAR2,
1183: X_REGION_APPLICATION_ID IN NUMBER,
1184: X_REGION_CODE IN VARCHAR2,
1185: X_RF_TAG IN VARCHAR2,
1186: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1187: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1188: X_ERRORCODE OUT NOCOPY NUMBER
1189: )
1190: IS

Line 1197: IF FND_API.To_Boolean(x_init_msg_list) THEN

1193: l_count NUMBER;
1194:
1195: BEGIN
1196:
1197: IF FND_API.To_Boolean(x_init_msg_list) THEN
1198: FND_MSG_PUB.Initialize;
1199: END IF;
1200:
1201: SELECT

Line 1224: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1220: AND RF_TAG = X_RF_TAG;
1221:
1222: END IF;
1223:
1224: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1225: X_RETURN_STATUS := 'T';
1226:
1227: END delete_criteria_template_rf;
1228:

Line 1253: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1249: X_LAST_UPDATE_LOGIN IN NUMBER,
1250: X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
1251: X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
1252: X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
1253: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1255: X_ERRORCODE OUT NOCOPY NUMBER
1256: )
1257: IS

Line 1264: IF FND_API.To_Boolean(x_init_msg_list) THEN

1260: l_rowid VARCHAR2(255);
1261:
1262: BEGIN
1263:
1264: IF FND_API.To_Boolean(x_init_msg_list) THEN
1265: FND_MSG_PUB.Initialize;
1266: END IF;
1267:
1268: --first check unique constraint

Line 1491: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1487: l_Sysdate,
1488: g_current_user_id
1489: );
1490:
1491: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1492:
1493: ELSE
1494:
1495:

Line 1499: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1495:
1496: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
1497: FND_MSG_PUB.Add;
1498:
1499: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1500:
1501:
1502: END IF;
1503:

Line 1529: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1525: X_LAST_UPDATE_LOGIN IN NUMBER,
1526: X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
1527: X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
1528: X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
1529: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1530: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1531: X_ERRORCODE OUT NOCOPY NUMBER
1532: )
1533: IS

Line 1558: IF FND_API.To_Boolean(x_init_msg_list) THEN

1554: and name_query.region_code = x_region_code;
1555:
1556: BEGIN
1557:
1558: IF FND_API.To_Boolean(x_init_msg_list) THEN
1559: FND_MSG_PUB.Initialize;
1560: END IF;
1561:
1562: IF (Results_Format_Name_Exists(X_NAME

Line 1813: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1809:
1810:
1811:
1812:
1813: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1814:
1815: ELSE
1816:
1817: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');

Line 1820: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1816:
1817: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
1818: FND_MSG_PUB.Add;
1819:
1820: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1821:
1822: END IF;
1823:
1824: END update_result_format;

Line 1834: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1830: X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
1831: X_CUSTOMIZATION_CODE IN VARCHAR2,
1832: X_REGION_APPLICATION_ID IN NUMBER,
1833: X_REGION_CODE IN VARCHAR2,
1834: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1835: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1836: X_ERRORCODE OUT NOCOPY NUMBER
1837: )
1838: IS

Line 1842: IF FND_API.To_Boolean(x_init_msg_list) THEN

1838: IS
1839:
1840: BEGIN
1841:
1842: IF FND_API.To_Boolean(x_init_msg_list) THEN
1843: FND_MSG_PUB.Initialize;
1844: END IF;
1845:
1846: Check_Result_Format_Deletion

Line 1852: FND_API.G_FALSE,

1848: X_CUSTOMIZATION_APPLICATION_ID,
1849: X_CUSTOMIZATION_CODE,
1850: X_REGION_APPLICATION_ID,
1851: X_REGION_CODE,
1852: FND_API.G_FALSE,
1853: X_RETURN_STATUS,
1854: X_ERRORCODE
1855: );
1856:

Line 1857: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN

1853: X_RETURN_STATUS,
1854: X_ERRORCODE
1855: );
1856:
1857: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
1858:
1859: DELETE FROM AK_CUSTOM_REGIONS
1860: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1861: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE

Line 1889: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1885: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1886: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1887: AND REGION_CODE = X_REGION_CODE;
1888:
1889: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1890:
1891: ELSE
1892:
1893: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1893: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1889: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1890:
1891: ELSE
1892:
1893: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1894:
1895: END IF;
1896:
1897: END delete_result_format;

Line 2009: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

2005: X_CREATION_DATE IN DATE,
2006: X_LAST_UPDATED_BY IN NUMBER,
2007: X_LAST_UPDATE_DATE IN DATE,
2008: X_LAST_UPDATE_LOGIN IN NUMBER,
2009: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2010: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2011: X_ERRORCODE OUT NOCOPY NUMBER
2012: )
2013: IS

Line 2020: IF FND_API.To_Boolean(x_init_msg_list) THEN

2016: l_rowid VARCHAR2(255);
2017:
2018: BEGIN
2019:
2020: IF FND_API.To_Boolean(x_init_msg_list) THEN
2021: FND_MSG_PUB.Initialize;
2022: END IF;
2023:
2024: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

Line 2132: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2128: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
2129: );
2130: END IF;
2131:
2132: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2133: X_RETURN_STATUS := 'T';
2134:
2135:
2136: END create_result_column;

Line 2158: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

2154: X_SHOW_TOTAL IN VARCHAR2 := NULL,
2155: X_LAST_UPDATED_BY IN NUMBER,
2156: X_LAST_UPDATE_DATE IN DATE,
2157: X_LAST_UPDATE_LOGIN IN NUMBER,
2158: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2159: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2160: X_ERRORCODE OUT NOCOPY NUMBER
2161: )
2162: IS

Line 2170: IF FND_API.To_Boolean(x_init_msg_list) THEN

2166: l_count NUMBER;
2167:
2168: BEGIN
2169:
2170: IF FND_API.To_Boolean(x_init_msg_list) THEN
2171: FND_MSG_PUB.Initialize;
2172: END IF;
2173:
2174: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

Line 2476: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2472:
2473: END IF;
2474:
2475:
2476: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2477: X_RETURN_STATUS := 'T';
2478:
2479:
2480: END update_result_column;

Line 2492: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

2488: X_REGION_APPLICATION_ID IN NUMBER,
2489: X_REGION_CODE IN VARCHAR2,
2490: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
2491: X_ATTRIBUTE_CODE IN VARCHAR2,
2492: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2493: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2494: X_ERRORCODE OUT NOCOPY NUMBER
2495: )
2496: IS

Line 2500: IF FND_API.To_Boolean(x_init_msg_list) THEN

2496: IS
2497:
2498: BEGIN
2499:
2500: IF FND_API.To_Boolean(x_init_msg_list) THEN
2501: FND_MSG_PUB.Initialize;
2502: END IF;
2503:
2504: DELETE FROM AK_CUSTOM_REGION_ITEMS

Line 2520: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2516: AND REGION_CODE = X_REGION_CODE
2517: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
2518: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
2519:
2520: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2521: X_RETURN_STATUS := 'T';
2522:
2523:
2524: END delete_result_column;

Line 2556: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2552: X_MATCH_CONDITION IN VARCHAR2 := 'ALL',
2553: X_FUZZY IN VARCHAR2 := 'N',
2554: X_STEMMING IN VARCHAR2 := 'N',
2555: X_SYNONYMS IN VARCHAR2 := 'N',
2556: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2557: )
2558: IS
2559:
2560: BEGIN

Line 2562: IF FND_API.To_Boolean(x_init_msg_list) THEN

2558: IS
2559:
2560: BEGIN
2561:
2562: IF FND_API.To_Boolean(x_init_msg_list) THEN
2563: FND_MSG_PUB.Initialize;
2564: END IF;
2565:
2566: AK_CRITERIA_PKG.insert_row

Line 2687: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2683: X_MATCH_CONDITION IN VARCHAR2 := 'ALL',
2684: X_FUZZY IN VARCHAR2 := 'N',
2685: X_STEMMING IN VARCHAR2 := 'N',
2686: X_SYNONYMS IN VARCHAR2 := 'N',
2687: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2688: )
2689: IS
2690:
2691: l_count NUMBER;

Line 2695: IF FND_API.To_Boolean(x_init_msg_list) THEN

2691: l_count NUMBER;
2692:
2693: BEGIN
2694:
2695: IF FND_API.To_Boolean(x_init_msg_list) THEN
2696: FND_MSG_PUB.Initialize;
2697: END IF;
2698:
2699: AK_CRITERIA_PKG.update_row

Line 2883: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2879: X_REGION_CODE IN VARCHAR2,
2880: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
2881: X_ATTRIBUTE_CODE IN VARCHAR2,
2882: X_SEQUENCE_NUMBER IN NUMBER,
2883: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2884: )
2885: IS
2886:
2887: l_count NUMBER;

Line 2891: IF FND_API.To_Boolean(x_init_msg_list) THEN

2887: l_count NUMBER;
2888:
2889: BEGIN
2890:
2891: IF FND_API.To_Boolean(x_init_msg_list) THEN
2892: FND_MSG_PUB.Initialize;
2893: END IF;
2894:
2895: AK_CRITERIA_PKG.delete_row

Line 2961: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

2957: X_CREATION_DATE IN DATE,
2958: X_LAST_UPDATED_BY IN NUMBER,
2959: X_LAST_UPDATE_DATE IN DATE,
2960: X_LAST_UPDATE_LOGIN IN NUMBER,
2961: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2962: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2963: X_ERRORCODE OUT NOCOPY NUMBER
2964: )
2965: IS

Line 2972: IF FND_API.To_Boolean(x_init_msg_list) THEN

2968: l_rowid VARCHAR2(255);
2969:
2970: BEGIN
2971:
2972: IF FND_API.To_Boolean(x_init_msg_list) THEN
2973: FND_MSG_PUB.Initialize;
2974: END IF;
2975:
2976: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

Line 2995: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2991: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
2992: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
2993: );
2994:
2995: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2996: X_RETURN_STATUS := 'T';
2997:
2998:
2999: END create_result_section;

Line 3017: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

3013: X_DISPLAY_SEQUENCE IN NUMBER,
3014: X_LAST_UPDATED_BY IN NUMBER,
3015: X_LAST_UPDATE_DATE IN DATE,
3016: X_LAST_UPDATE_LOGIN IN NUMBER,
3017: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3018: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3019: X_ERRORCODE OUT NOCOPY NUMBER
3020: )
3021: IS

Line 3028: IF FND_API.To_Boolean(x_init_msg_list) THEN

3024: l_rowid VARCHAR2(255);
3025:
3026: BEGIN
3027:
3028: IF FND_API.To_Boolean(x_init_msg_list) THEN
3029: FND_MSG_PUB.Initialize;
3030: END IF;
3031:
3032: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

Line 3048: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3044: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
3045: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
3046: );
3047:
3048: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3049: X_RETURN_STATUS := 'T';
3050:
3051:
3052: END update_result_section;

Line 3064: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

3060: X_REGION_APPLICATION_ID IN NUMBER,
3061: X_REGION_CODE IN VARCHAR2,
3062: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
3063: X_ATTRIBUTE_CODE IN VARCHAR2,
3064: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3065: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3066: X_ERRORCODE OUT NOCOPY NUMBER
3067: )
3068: IS

Line 3072: IF FND_API.To_Boolean(x_init_msg_list) THEN

3068: IS
3069:
3070: BEGIN
3071:
3072: IF FND_API.To_Boolean(x_init_msg_list) THEN
3073: FND_MSG_PUB.Initialize;
3074: END IF;
3075:
3076: DELETE FROM AK_CUSTOM_REGION_ITEMS

Line 3092: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3088: AND REGION_CODE = X_REGION_CODE
3089: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
3090: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
3091:
3092: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3093: X_RETURN_STATUS := 'T';
3094:
3095:
3096: END delete_result_section;