DBA Data[Home] [Help]

APPS.ENG_TYPE_CONFIGURATION_PKG dependencies on FND_API

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

16: X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
17: X_CUSTOMIZATION_CODE IN VARCHAR2,
18: X_REGION_APPLICATION_ID IN NUMBER,
19: X_REGION_CODE IN VARCHAR2,
20: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22: X_ERRORCODE OUT NOCOPY NUMBER
23: )
24: IS

Line 31: IF FND_API.To_Boolean(x_init_msg_list) THEN

27: l_name VARCHAR2(2000);
28:
29: BEGIN
30:
31: IF FND_API.To_Boolean(x_init_msg_list) THEN
32: FND_MSG_PUB.Initialize;
33: END IF;
34:
35: SELECT

Line 78: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

74: FND_MESSAGE.Set_Name(g_app_name, 'EGO_RF_RF_EXISTS');
75: FND_MESSAGE.Set_Token('NAME', l_name);
76: FND_MSG_PUB.Add;
77:
78: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
79:
80: ELSE
81:
82: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 82: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

78: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
79:
80: ELSE
81:
82: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
83:
84: END IF;
85:
86: END Check_Configuration_delete;

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

101: X_LAST_UPDATE_LOGIN IN NUMBER,
102: X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
103: X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
104: X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
105: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
106: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107: X_ERRORCODE OUT NOCOPY NUMBER
108: )
109: IS

Line 116: IF FND_API.To_Boolean(x_init_msg_list) THEN

112: l_rowid VARCHAR2(255);
113:
114: BEGIN
115:
116: IF FND_API.To_Boolean(x_init_msg_list) THEN
117: FND_MSG_PUB.Initialize;
118: END IF;
119:
120: --first check unique constraint

Line 183: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

179: l_Sysdate,
180: g_current_user_id
181: );
182:
183: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
184:
185: /* ELSE
186:
187:

Line 191: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

187:
188: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
189: FND_MSG_PUB.Add;
190:
191: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
192:
193:
194: END IF; */
195:

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

209: X_LAST_UPDATE_LOGIN IN NUMBER,
210: X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
211: X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
212: X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
213: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
214: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
215: X_ERRORCODE OUT NOCOPY NUMBER
216: )
217: IS

Line 225: IF FND_API.To_Boolean(x_init_msg_list) THEN

221: l_data_level VARCHAR2(4000);
222:
223: BEGIN
224:
225: IF FND_API.To_Boolean(x_init_msg_list) THEN
226: FND_MSG_PUB.Initialize;
227: END IF;
228:
229: /*IF (Results_Format_Name_Exists(X_NAME

Line 256: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

252: );
253:
254:
255:
256: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
257:
258: /*ELSE
259:
260: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');

Line 263: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

259:
260: FND_MESSAGE.Set_Name(g_app_name, 'EGO_DUP_RESULTS_FORMAT');
261: FND_MSG_PUB.Add;
262:
263: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
264:
265: END IF;*/
266:
267: END update_type_Config;

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

273: X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
274: X_CUSTOMIZATION_CODE IN VARCHAR2,
275: X_REGION_APPLICATION_ID IN NUMBER,
276: X_REGION_CODE IN VARCHAR2,
277: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
278: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
279: X_ERRORCODE OUT NOCOPY NUMBER
280: )
281: IS

Line 285: IF FND_API.To_Boolean(x_init_msg_list) THEN

281: IS
282:
283: BEGIN
284:
285: IF FND_API.To_Boolean(x_init_msg_list) THEN
286: FND_MSG_PUB.Initialize;
287: END IF;
288:
289: Check_Configuration_delete

Line 295: FND_API.G_FALSE,

291: X_CUSTOMIZATION_APPLICATION_ID,
292: X_CUSTOMIZATION_CODE,
293: X_REGION_APPLICATION_ID,
294: X_REGION_CODE,
295: FND_API.G_FALSE,
296: X_RETURN_STATUS,
297: X_ERRORCODE
298: );
299:

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

296: X_RETURN_STATUS,
297: X_ERRORCODE
298: );
299:
300: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
301:
302: DELETE FROM AK_CUSTOM_REGIONS
303: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
304: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE

Line 332: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

328: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
329: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
330: AND REGION_CODE = X_REGION_CODE;
331:
332: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
333:
334: ELSE
335:
336: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 336: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

332: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
333:
334: ELSE
335:
336: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
337:
338: END IF;
339:
340: END delete_type_config;

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

358: X_CREATION_DATE IN DATE,
359: X_LAST_UPDATED_BY IN NUMBER,
360: X_LAST_UPDATE_DATE IN DATE,
361: X_LAST_UPDATE_LOGIN IN NUMBER,
362: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
363: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
364: X_ERRORCODE OUT NOCOPY NUMBER
365: )
366: IS

Line 373: IF FND_API.To_Boolean(x_init_msg_list) THEN

369: l_rowid VARCHAR2(255);
370:
371: BEGIN
372:
373: IF FND_API.To_Boolean(x_init_msg_list) THEN
374: FND_MSG_PUB.Initialize;
375: END IF;
376:
377: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

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

481: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
482: );
483: END IF;
484:
485: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
486: X_RETURN_STATUS := 'T';
487:
488:
489: END create_Primary_Attribute;

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

507: X_SHOW_TOTAL IN VARCHAR2 := NULL,
508: X_LAST_UPDATED_BY IN NUMBER,
509: X_LAST_UPDATE_DATE IN DATE,
510: X_LAST_UPDATE_LOGIN IN NUMBER,
511: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
512: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
513: X_ERRORCODE OUT NOCOPY NUMBER
514: )
515: IS

Line 523: IF FND_API.To_Boolean(x_init_msg_list) THEN

519: l_count NUMBER;
520:
521: BEGIN
522:
523: IF FND_API.To_Boolean(x_init_msg_list) THEN
524: FND_MSG_PUB.Initialize;
525: END IF;
526:
527: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

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

825:
826: END IF;
827:
828:
829: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
830: X_RETURN_STATUS := 'T';
831:
832:
833: END update_Primary_Attribute;

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

841: X_REGION_APPLICATION_ID IN NUMBER,
842: X_REGION_CODE IN VARCHAR2,
843: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
844: X_ATTRIBUTE_CODE IN VARCHAR2,
845: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
846: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
847: X_ERRORCODE OUT NOCOPY NUMBER
848: )
849: IS

Line 853: IF FND_API.To_Boolean(x_init_msg_list) THEN

849: IS
850:
851: BEGIN
852:
853: IF FND_API.To_Boolean(x_init_msg_list) THEN
854: FND_MSG_PUB.Initialize;
855: END IF;
856:
857: DELETE FROM AK_CUSTOM_REGION_ITEMS

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

869: AND REGION_CODE = X_REGION_CODE
870: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
871: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
872:
873: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
874: X_RETURN_STATUS := 'T';
875:
876:
877: END delete_Primary_Attribute;

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

892: X_CREATION_DATE IN DATE,
893: X_LAST_UPDATED_BY IN NUMBER,
894: X_LAST_UPDATE_DATE IN DATE,
895: X_LAST_UPDATE_LOGIN IN NUMBER,
896: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
897: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
898: X_ERRORCODE OUT NOCOPY NUMBER
899: )
900: IS

Line 907: IF FND_API.To_Boolean(x_init_msg_list) THEN

903: l_rowid VARCHAR2(255);
904:
905: BEGIN
906:
907: IF FND_API.To_Boolean(x_init_msg_list) THEN
908: FND_MSG_PUB.Initialize;
909: END IF;
910:
911: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

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

926: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
927: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
928: );
929:
930: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
931: X_RETURN_STATUS := 'T';
932:
933:
934: END create_config_section;

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

948: X_DISPLAY_SEQUENCE IN NUMBER,
949: X_LAST_UPDATED_BY IN NUMBER,
950: X_LAST_UPDATE_DATE IN DATE,
951: X_LAST_UPDATE_LOGIN IN NUMBER,
952: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
953: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
954: X_ERRORCODE OUT NOCOPY NUMBER
955: )
956: IS

Line 963: IF FND_API.To_Boolean(x_init_msg_list) THEN

959: l_rowid VARCHAR2(255);
960:
961: BEGIN
962:
963: IF FND_API.To_Boolean(x_init_msg_list) THEN
964: FND_MSG_PUB.Initialize;
965: END IF;
966:
967: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

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

979: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
980: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
981: );
982:
983: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
984: X_RETURN_STATUS := 'T';
985:
986:
987: END update_config_section;

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

995: X_REGION_APPLICATION_ID IN NUMBER,
996: X_REGION_CODE IN VARCHAR2,
997: X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
998: X_ATTRIBUTE_CODE IN VARCHAR2,
999: X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1000: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1001: X_ERRORCODE OUT NOCOPY NUMBER
1002: )
1003: IS

Line 1007: IF FND_API.To_Boolean(x_init_msg_list) THEN

1003: IS
1004:
1005: BEGIN
1006:
1007: IF FND_API.To_Boolean(x_init_msg_list) THEN
1008: FND_MSG_PUB.Initialize;
1009: END IF;
1010:
1011: DELETE FROM AK_CUSTOM_REGION_ITEMS

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

1023: AND REGION_CODE = X_REGION_CODE
1024: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
1025: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
1026:
1027: -- X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1028: X_RETURN_STATUS := 'T';
1029:
1030:
1031: END delete_config_section;