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 805: IF FND_API.To_Boolean(x_init_msg_list) THEN

801: l_count NUMBER := NULL;
802:
803: BEGIN
804:
805: IF FND_API.To_Boolean(x_init_msg_list) THEN
806: FND_MSG_PUB.Initialize;
807: END IF;
808:
809: SELECT

Line 858: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

854: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
855: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
856: AND REGION_CODE = X_REGION_CODE;
857:
858: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
859:
860: ELSE
861:
862: SELECT

Line 876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

872: FND_MESSAGE.Set_Name(g_app_name, 'EGO_CT_RF_EXISTS');
873: FND_MESSAGE.Set_Token('NAME', l_name);
874: FND_MSG_PUB.Add;
875:
876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
877:
878: END IF;
879:
880: END Delete_Criteria_Template;

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

1003: X_CREATION_DATE IN DATE,
1004: X_LAST_UPDATED_BY IN NUMBER,
1005: X_LAST_UPDATE_DATE IN DATE,
1006: X_LAST_UPDATE_LOGIN IN NUMBER,
1007: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1008: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1009: X_ERRORCODE OUT NOCOPY NUMBER
1010: )
1011: IS

Line 1017: IF FND_API.To_Boolean(x_init_msg_list) THEN

1013: l_Sysdate DATE := Sysdate;
1014:
1015: BEGIN
1016:
1017: IF FND_API.To_Boolean(x_init_msg_list) THEN
1018: FND_MSG_PUB.Initialize;
1019: END IF;
1020:
1021: IF (X_RF_CUSTOMIZATION_CODE IS NOT NULL) THEN

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

1055: X_LAST_UPDATE_LOGIN
1056: );
1057: END IF;
1058:
1059: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1060: X_RETURN_STATUS := 'T';
1061:
1062:
1063: END create_criteria_template_rf;

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

1076: X_RF_TAG IN VARCHAR2,
1077: X_LAST_UPDATED_BY IN NUMBER,
1078: X_LAST_UPDATE_DATE IN DATE,
1079: X_LAST_UPDATE_LOGIN IN NUMBER,
1080: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1081: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1082: X_ERRORCODE OUT NOCOPY NUMBER
1083: )
1084: IS

Line 1091: IF FND_API.To_Boolean(x_init_msg_list) THEN

1087: l_count NUMBER;
1088:
1089: BEGIN
1090:
1091: IF FND_API.To_Boolean(x_init_msg_list) THEN
1092: FND_MSG_PUB.Initialize;
1093: END IF;
1094:
1095: SELECT

Line 1115: ,FND_API.G_FALSE

1111: ,X_CUSTOMIZATION_CODE
1112: ,X_REGION_APPLICATION_ID
1113: ,X_REGION_CODE
1114: ,X_RF_TAG
1115: ,FND_API.G_FALSE
1116: ,X_RETURN_STATUS
1117: ,X_ERRORCODE
1118: );
1119: ELSE

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

1137: END IF;
1138:
1139: END IF;
1140:
1141: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1142: X_RETURN_STATUS := 'T';
1143:
1144: END update_criteria_template_rf;
1145:

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

1150: X_CUSTOMIZATION_CODE IN VARCHAR2,
1151: X_REGION_APPLICATION_ID IN NUMBER,
1152: X_REGION_CODE IN VARCHAR2,
1153: X_RF_TAG IN VARCHAR2,
1154: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1155: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1156: X_ERRORCODE OUT NOCOPY NUMBER
1157: )
1158: IS

Line 1165: IF FND_API.To_Boolean(x_init_msg_list) THEN

1161: l_count NUMBER;
1162:
1163: BEGIN
1164:
1165: IF FND_API.To_Boolean(x_init_msg_list) THEN
1166: FND_MSG_PUB.Initialize;
1167: END IF;
1168:
1169: SELECT

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

1188: AND RF_TAG = X_RF_TAG;
1189:
1190: END IF;
1191:
1192: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1193: X_RETURN_STATUS := 'T';
1194:
1195: END delete_criteria_template_rf;
1196:

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

1217: X_LAST_UPDATE_LOGIN IN NUMBER,
1218: X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
1219: X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
1220: X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
1221: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1222: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1223: X_ERRORCODE OUT NOCOPY NUMBER
1224: )
1225: IS

Line 1232: IF FND_API.To_Boolean(x_init_msg_list) THEN

1228: l_rowid VARCHAR2(255);
1229:
1230: BEGIN
1231:
1232: IF FND_API.To_Boolean(x_init_msg_list) THEN
1233: FND_MSG_PUB.Initialize;
1234: END IF;
1235:
1236: --first check unique constraint

Line 1459: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1455: l_Sysdate,
1456: g_current_user_id
1457: );
1458:
1459: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1460:
1461: ELSE
1462:
1463:

Line 1467: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1463:
1464: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
1465: FND_MSG_PUB.Add;
1466:
1467: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1468:
1469:
1470: END IF;
1471:

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

1493: X_LAST_UPDATE_LOGIN IN NUMBER,
1494: X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
1495: X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
1496: X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
1497: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1498: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1499: X_ERRORCODE OUT NOCOPY NUMBER
1500: )
1501: IS

Line 1526: IF FND_API.To_Boolean(x_init_msg_list) THEN

1522: and name_query.region_code = x_region_code;
1523:
1524: BEGIN
1525:
1526: IF FND_API.To_Boolean(x_init_msg_list) THEN
1527: FND_MSG_PUB.Initialize;
1528: END IF;
1529:
1530: IF (Results_Format_Name_Exists(X_NAME

Line 1781: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1777:
1778:
1779:
1780:
1781: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1782:
1783: ELSE
1784:
1785: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');

Line 1788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1784:
1785: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
1786: FND_MSG_PUB.Add;
1787:
1788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1789:
1790: END IF;
1791:
1792: END update_result_format;

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

1798: X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
1799: X_CUSTOMIZATION_CODE IN VARCHAR2,
1800: X_REGION_APPLICATION_ID IN NUMBER,
1801: X_REGION_CODE IN VARCHAR2,
1802: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1803: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1804: X_ERRORCODE OUT NOCOPY NUMBER
1805: )
1806: IS

Line 1810: IF FND_API.To_Boolean(x_init_msg_list) THEN

1806: IS
1807:
1808: BEGIN
1809:
1810: IF FND_API.To_Boolean(x_init_msg_list) THEN
1811: FND_MSG_PUB.Initialize;
1812: END IF;
1813:
1814: Check_Result_Format_Deletion

Line 1820: FND_API.G_FALSE,

1816: X_CUSTOMIZATION_APPLICATION_ID,
1817: X_CUSTOMIZATION_CODE,
1818: X_REGION_APPLICATION_ID,
1819: X_REGION_CODE,
1820: FND_API.G_FALSE,
1821: X_RETURN_STATUS,
1822: X_ERRORCODE
1823: );
1824:

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

1821: X_RETURN_STATUS,
1822: X_ERRORCODE
1823: );
1824:
1825: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
1826:
1827: DELETE FROM AK_CUSTOM_REGIONS
1828: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1829: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE

Line 1857: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1853: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1854: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1855: AND REGION_CODE = X_REGION_CODE;
1856:
1857: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1858:
1859: ELSE
1860:
1861: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1861: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1857: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1858:
1859: ELSE
1860:
1861: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1862:
1863: END IF;
1864:
1865: END delete_result_format;

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

1973: X_CREATION_DATE IN DATE,
1974: X_LAST_UPDATED_BY IN NUMBER,
1975: X_LAST_UPDATE_DATE IN DATE,
1976: X_LAST_UPDATE_LOGIN IN NUMBER,
1977: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1978: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1979: X_ERRORCODE OUT NOCOPY NUMBER
1980: )
1981: IS

Line 1988: IF FND_API.To_Boolean(x_init_msg_list) THEN

1984: l_rowid VARCHAR2(255);
1985:
1986: BEGIN
1987:
1988: IF FND_API.To_Boolean(x_init_msg_list) THEN
1989: FND_MSG_PUB.Initialize;
1990: END IF;
1991:
1992: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

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

2096: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
2097: );
2098: END IF;
2099:
2100: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2101: X_RETURN_STATUS := 'T';
2102:
2103:
2104: END create_result_column;

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

2122: X_SHOW_TOTAL IN VARCHAR2 := NULL,
2123: X_LAST_UPDATED_BY IN NUMBER,
2124: X_LAST_UPDATE_DATE IN DATE,
2125: X_LAST_UPDATE_LOGIN IN NUMBER,
2126: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2127: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2128: X_ERRORCODE OUT NOCOPY NUMBER
2129: )
2130: IS

Line 2138: IF FND_API.To_Boolean(x_init_msg_list) THEN

2134: l_count NUMBER;
2135:
2136: BEGIN
2137:
2138: IF FND_API.To_Boolean(x_init_msg_list) THEN
2139: FND_MSG_PUB.Initialize;
2140: END IF;
2141:
2142: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

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

2440:
2441: END IF;
2442:
2443:
2444: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2445: X_RETURN_STATUS := 'T';
2446:
2447:
2448: END update_result_column;

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

2456: X_REGION_APPLICATION_ID IN NUMBER,
2457: X_REGION_CODE IN VARCHAR2,
2458: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
2459: X_ATTRIBUTE_CODE IN VARCHAR2,
2460: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2461: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2462: X_ERRORCODE OUT NOCOPY NUMBER
2463: )
2464: IS

Line 2468: IF FND_API.To_Boolean(x_init_msg_list) THEN

2464: IS
2465:
2466: BEGIN
2467:
2468: IF FND_API.To_Boolean(x_init_msg_list) THEN
2469: FND_MSG_PUB.Initialize;
2470: END IF;
2471:
2472: DELETE FROM AK_CUSTOM_REGION_ITEMS

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

2484: AND REGION_CODE = X_REGION_CODE
2485: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
2486: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
2487:
2488: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2489: X_RETURN_STATUS := 'T';
2490:
2491:
2492: END delete_result_column;

Line 2524: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2520: X_MATCH_CONDITION IN VARCHAR2 := 'ALL',
2521: X_FUZZY IN VARCHAR2 := 'N',
2522: X_STEMMING IN VARCHAR2 := 'N',
2523: X_SYNONYMS IN VARCHAR2 := 'N',
2524: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2525: )
2526: IS
2527:
2528: BEGIN

Line 2530: IF FND_API.To_Boolean(x_init_msg_list) THEN

2526: IS
2527:
2528: BEGIN
2529:
2530: IF FND_API.To_Boolean(x_init_msg_list) THEN
2531: FND_MSG_PUB.Initialize;
2532: END IF;
2533:
2534: AK_CRITERIA_PKG.insert_row

Line 2655: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2651: X_MATCH_CONDITION IN VARCHAR2 := 'ALL',
2652: X_FUZZY IN VARCHAR2 := 'N',
2653: X_STEMMING IN VARCHAR2 := 'N',
2654: X_SYNONYMS IN VARCHAR2 := 'N',
2655: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2656: )
2657: IS
2658:
2659: l_count NUMBER;

Line 2663: IF FND_API.To_Boolean(x_init_msg_list) THEN

2659: l_count NUMBER;
2660:
2661: BEGIN
2662:
2663: IF FND_API.To_Boolean(x_init_msg_list) THEN
2664: FND_MSG_PUB.Initialize;
2665: END IF;
2666:
2667: AK_CRITERIA_PKG.update_row

Line 2851: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2847: X_REGION_CODE IN VARCHAR2,
2848: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
2849: X_ATTRIBUTE_CODE IN VARCHAR2,
2850: X_SEQUENCE_NUMBER IN NUMBER,
2851: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2852: )
2853: IS
2854:
2855: l_count NUMBER;

Line 2859: IF FND_API.To_Boolean(x_init_msg_list) THEN

2855: l_count NUMBER;
2856:
2857: BEGIN
2858:
2859: IF FND_API.To_Boolean(x_init_msg_list) THEN
2860: FND_MSG_PUB.Initialize;
2861: END IF;
2862:
2863: AK_CRITERIA_PKG.delete_row

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

2925: X_CREATION_DATE IN DATE,
2926: X_LAST_UPDATED_BY IN NUMBER,
2927: X_LAST_UPDATE_DATE IN DATE,
2928: X_LAST_UPDATE_LOGIN IN NUMBER,
2929: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2930: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2931: X_ERRORCODE OUT NOCOPY NUMBER
2932: )
2933: IS

Line 2940: IF FND_API.To_Boolean(x_init_msg_list) THEN

2936: l_rowid VARCHAR2(255);
2937:
2938: BEGIN
2939:
2940: IF FND_API.To_Boolean(x_init_msg_list) THEN
2941: FND_MSG_PUB.Initialize;
2942: END IF;
2943:
2944: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

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

2959: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
2960: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
2961: );
2962:
2963: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2964: X_RETURN_STATUS := 'T';
2965:
2966:
2967: END create_result_section;

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

2981: X_DISPLAY_SEQUENCE IN NUMBER,
2982: X_LAST_UPDATED_BY IN NUMBER,
2983: X_LAST_UPDATE_DATE IN DATE,
2984: X_LAST_UPDATE_LOGIN IN NUMBER,
2985: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2986: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2987: X_ERRORCODE OUT NOCOPY NUMBER
2988: )
2989: IS

Line 2996: IF FND_API.To_Boolean(x_init_msg_list) THEN

2992: l_rowid VARCHAR2(255);
2993:
2994: BEGIN
2995:
2996: IF FND_API.To_Boolean(x_init_msg_list) THEN
2997: FND_MSG_PUB.Initialize;
2998: END IF;
2999:
3000: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

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

3012: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
3013: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
3014: );
3015:
3016: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3017: X_RETURN_STATUS := 'T';
3018:
3019:
3020: END update_result_section;

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

3028: X_REGION_APPLICATION_ID IN NUMBER,
3029: X_REGION_CODE IN VARCHAR2,
3030: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
3031: X_ATTRIBUTE_CODE IN VARCHAR2,
3032: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3033: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3034: X_ERRORCODE OUT NOCOPY NUMBER
3035: )
3036: IS

Line 3040: IF FND_API.To_Boolean(x_init_msg_list) THEN

3036: IS
3037:
3038: BEGIN
3039:
3040: IF FND_API.To_Boolean(x_init_msg_list) THEN
3041: FND_MSG_PUB.Initialize;
3042: END IF;
3043:
3044: DELETE FROM AK_CUSTOM_REGION_ITEMS

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

3056: AND REGION_CODE = X_REGION_CODE
3057: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
3058: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
3059:
3060: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3061: X_RETURN_STATUS := 'T';
3062:
3063:
3064: END delete_result_section;