68: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
69: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
70: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
71: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_ENTITY_KEY');
72: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
73: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
74: 'edr.plsql.GMO_INSTRUCTION_PVT.UPDATE_ENTITY_KEY',
75: FALSE
76: );
69: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
70: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
71: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_ENTITY_KEY');
72: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
73: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
74: 'edr.plsql.GMO_INSTRUCTION_PVT.UPDATE_ENTITY_KEY',
75: FALSE
76: );
77: end if;
687: P_COUNT => X_MSG_COUNT,
688: P_DATA => X_MSG_DATA
689: );
690:
691: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
693: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_CONTEXT',
694: FALSE);
695: END IF;
688: P_DATA => X_MSG_DATA
689: );
690:
691: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
693: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_CONTEXT',
694: FALSE);
695: END IF;
696:
709: ( P_COUNT => X_MSG_COUNT,
710: P_DATA => X_MSG_DATA
711: );
712:
713: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
715: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
716: FALSE);
717: END IF;
710: P_DATA => X_MSG_DATA
711: );
712:
713: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
715: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
716: FALSE);
717: END IF;
718:
976: FND_MSG_PUB.ADD;
977:
978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
979:
980: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
981:
982: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
983: 'gmo.plsql.GMO_INSTRUCTION_PVT.DELETE_ENTITY_FOR_PROCESS',FALSE);
984:
978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
979:
980: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
981:
982: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
983: 'gmo.plsql.GMO_INSTRUCTION_PVT.DELETE_ENTITY_FOR_PROCESS',FALSE);
984:
985: END IF;
986:
1327: P_COUNT => X_MSG_COUNT,
1328: P_DATA => X_MSG_DATA
1329: );
1330:
1331: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1332: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1333: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_FROM_DEFN',
1334: FALSE);
1335: END IF;
1328: P_DATA => X_MSG_DATA
1329: );
1330:
1331: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1332: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1333: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_FROM_DEFN',
1334: FALSE);
1335: END IF;
1336:
1355: P_COUNT => X_MSG_COUNT,
1356: P_DATA => X_MSG_DATA
1357: );
1358:
1359: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1361: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_FROM_DEFN',
1362: FALSE);
1363: END IF;
1356: P_DATA => X_MSG_DATA
1357: );
1358:
1359: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1361: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_FROM_DEFN',
1362: FALSE);
1363: END IF;
1364:
1376: FND_MSG_PUB.COUNT_AND_GET
1377: ( P_COUNT => X_MSG_COUNT,
1378: P_DATA => X_MSG_DATA);
1379:
1380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1382: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_FROM_DEFN',
1383: FALSE);
1384: END IF;
1377: ( P_COUNT => X_MSG_COUNT,
1378: P_DATA => X_MSG_DATA);
1379:
1380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1382: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_FROM_DEFN',
1383: FALSE);
1384: END IF;
1385:
2140: L_MESG_TEXT := FND_MESSAGE.GET();
2141:
2142: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME,L_MESG_TEXT );
2143: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
2144: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_DEFN_ACKN',FALSE);
2146: END IF;
2147:
2148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2141:
2142: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME,L_MESG_TEXT );
2143: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
2144: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_DEFN_ACKN',FALSE);
2146: END IF;
2147:
2148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2149:
2152: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
2153: END IF;
2154:
2155: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2156: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_DEFN_ACKN',FALSE);
2158: END IF;
2159:
2160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2153: END IF;
2154:
2155: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2156: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_DEFN_ACKN',FALSE);
2158: END IF;
2159:
2160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2161: END SEND_DEFN_ACKN;
2364: P_COUNT => X_MSG_COUNT,
2365: P_DATA => X_MSG_DATA
2366: );
2367:
2368: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2369: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2370: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_FROM_DEFN',
2371: FALSE);
2372: END IF;
2365: P_DATA => X_MSG_DATA
2366: );
2367:
2368: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2369: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2370: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_FROM_DEFN',
2371: FALSE);
2372: END IF;
2373:
2642: P_COUNT => X_MSG_COUNT,
2643: P_DATA => X_MSG_DATA
2644: );
2645:
2646: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2647: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2648: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_FROM_DEFIN',
2649: FALSE);
2650: END IF;
2643: P_DATA => X_MSG_DATA
2644: );
2645:
2646: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2647: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2648: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_FROM_DEFIN',
2649: FALSE);
2650: END IF;
2651:
2672: FND_MSG_PUB.COUNT_AND_GET
2673: ( P_COUNT => X_MSG_COUNT,
2674: P_DATA => X_MSG_DATA);
2675:
2676: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2677: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
2678: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_FROM_DEFN',
2679: FALSE);
2680: END IF;
2673: ( P_COUNT => X_MSG_COUNT,
2674: P_DATA => X_MSG_DATA);
2675:
2676: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2677: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
2678: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_FROM_DEFN',
2679: FALSE);
2680: END IF;
2681:
2811: P_COUNT => X_MSG_COUNT,
2812: P_DATA => X_MSG_DATA
2813: );
2814:
2815: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2816: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2817: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_CONTEXT',
2818: FALSE);
2819: END IF;
2812: P_DATA => X_MSG_DATA
2813: );
2814:
2815: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2816: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2817: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_CONTEXT',
2818: FALSE);
2819: END IF;
2820:
3069: FND_MSG_PUB.COUNT_AND_GET
3070: ( P_COUNT => X_MSG_COUNT,
3071: P_DATA => X_MSG_DATA);
3072:
3073: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.MESSAGE ( FND_LOG.LEVEL_UNEXPECTED,
3075: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_FROM_INSTANCE',
3076: FALSE );
3077: END IF;
3070: ( P_COUNT => X_MSG_COUNT,
3071: P_DATA => X_MSG_DATA);
3072:
3073: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.MESSAGE ( FND_LOG.LEVEL_UNEXPECTED,
3075: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_FROM_INSTANCE',
3076: FALSE );
3077: END IF;
3078:
3168: P_COUNT => X_MSG_COUNT,
3169: P_DATA => X_MSG_DATA
3170: );
3171:
3172: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3173: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3174: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_MODE_FOR_ENTITY',
3175: FALSE);
3176: END IF;
3169: P_DATA => X_MSG_DATA
3170: );
3171:
3172: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3173: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3174: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_MODE_FOR_ENTITY',
3175: FALSE);
3176: END IF;
3177:
3188: FND_MSG_PUB.COUNT_AND_GET
3189: ( P_COUNT => X_MSG_COUNT,
3190: P_DATA => X_MSG_DATA);
3191:
3192: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3193: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3194: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_MODE_FOR_ENTITY',
3195: FALSE);
3196: END IF;
3189: ( P_COUNT => X_MSG_COUNT,
3190: P_DATA => X_MSG_DATA);
3191:
3192: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3193: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3194: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_MODE_FOR_ENTITY',
3195: FALSE);
3196: END IF;
3197:
3296: P_COUNT => X_MSG_COUNT,
3297: P_DATA => X_MSG_DATA
3298: );
3299:
3300: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3302: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_INSTRUCTIONS',
3303: FALSE);
3304: END IF;
3297: P_DATA => X_MSG_DATA
3298: );
3299:
3300: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3302: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_INSTRUCTIONS',
3303: FALSE);
3304: END IF;
3305:
3323: P_COUNT => X_MSG_COUNT,
3324: P_DATA => X_MSG_DATA
3325: );
3326:
3327: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3328: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3329: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_INSTRUCTIONS',
3330: FALSE);
3331: END IF;
3324: P_DATA => X_MSG_DATA
3325: );
3326:
3327: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3328: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3329: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_INSTRUCTIONS',
3330: FALSE);
3331: END IF;
3332:
3343: FND_MSG_PUB.COUNT_AND_GET
3344: ( P_COUNT => X_MSG_COUNT,
3345: P_DATA => X_MSG_DATA);
3346:
3347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3348: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3349: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3350: FALSE);
3351: END IF;
3344: ( P_COUNT => X_MSG_COUNT,
3345: P_DATA => X_MSG_DATA);
3346:
3347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3348: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3349: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3350: FALSE);
3351: END IF;
3352:
3469: P_COUNT => X_MSG_COUNT,
3470: P_DATA => X_MSG_DATA
3471: );
3472:
3473: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3474: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3475: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.HAS_PENDING_INSTRUCTIONS',
3476: FALSE);
3477: END IF;
3470: P_DATA => X_MSG_DATA
3471: );
3472:
3473: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3474: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3475: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.HAS_PENDING_INSTRUCTIONS',
3476: FALSE);
3477: END IF;
3478:
3493: ( P_COUNT => X_MSG_COUNT,
3494: P_DATA => X_MSG_DATA
3495: );
3496:
3497: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3498: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3499: 'gmo.plsql.GMO_INSTRUCTION_PVT.HAS_PENDING_INSTRUCTIONS',
3500: FALSE);
3501: END IF;
3494: P_DATA => X_MSG_DATA
3495: );
3496:
3497: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3498: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3499: 'gmo.plsql.GMO_INSTRUCTION_PVT.HAS_PENDING_INSTRUCTIONS',
3500: FALSE);
3501: END IF;
3502:
3605: P_COUNT => X_MSG_COUNT,
3606: P_DATA => X_MSG_DATA
3607: );
3608:
3609: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3610: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3611: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.HAS_PENDING_INSTR_FOR_PROCESS',
3612: FALSE);
3613: END IF;
3606: P_DATA => X_MSG_DATA
3607: );
3608:
3609: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3610: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3611: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.HAS_PENDING_INSTR_FOR_PROCESS',
3612: FALSE);
3613: END IF;
3614: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3627: FND_MSG_PUB.COUNT_AND_GET
3628: ( P_COUNT => X_MSG_COUNT,
3629: P_DATA => X_MSG_DATA );
3630:
3631: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3632: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3633: 'gmo.plsql.GMO_INSTRUCTION_PVT.HAS_PENDING_INSTR_FOR_PROCESS',
3634: FALSE);
3635: END IF;
3628: ( P_COUNT => X_MSG_COUNT,
3629: P_DATA => X_MSG_DATA );
3630:
3631: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3632: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3633: 'gmo.plsql.GMO_INSTRUCTION_PVT.HAS_PENDING_INSTR_FOR_PROCESS',
3634: FALSE);
3635: END IF;
3636: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3980: FND_MSG_PUB.COUNT_AND_GET
3981: ( P_COUNT => X_MSG_COUNT,
3982: P_DATA => X_MSG_DATA);
3983:
3984: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3985: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3986: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3987: FALSE);
3988: END IF;
3981: ( P_COUNT => X_MSG_COUNT,
3982: P_DATA => X_MSG_DATA);
3983:
3984: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3985: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3986: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3987: FALSE);
3988: END IF;
3989:
4195: P_COUNT => X_MSG_COUNT,
4196: P_DATA => X_MSG_DATA
4197: );
4198:
4199: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4200: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4201: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4202: FALSE);
4203: END IF;
4196: P_DATA => X_MSG_DATA
4197: );
4198:
4199: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4200: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4201: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4202: FALSE);
4203: END IF;
4204:
4223: P_COUNT => X_MSG_COUNT,
4224: P_DATA => X_MSG_DATA
4225: );
4226:
4227: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4228: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4229: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4230: FALSE);
4231: END IF;
4224: P_DATA => X_MSG_DATA
4225: );
4226:
4227: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4228: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4229: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4230: FALSE);
4231: END IF;
4232:
4243: FND_MSG_PUB.COUNT_AND_GET
4244: ( P_COUNT => X_MSG_COUNT,
4245: P_DATA => X_MSG_DATA);
4246:
4247: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4248: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4249: 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_TASK_ACKN',
4250: FALSE);
4251: END IF;
4244: ( P_COUNT => X_MSG_COUNT,
4245: P_DATA => X_MSG_DATA);
4246:
4247: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4248: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4249: 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_TASK_ACKN',
4250: FALSE);
4251: END IF;
4252: END SEND_TASK_ACKN;
4308: FND_MSG_PUB.COUNT_AND_GET
4309: ( P_COUNT => X_MSG_COUNT,
4310: P_DATA => X_MSG_DATA );
4311:
4312: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4313: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4314: 'gmo.plsql.GMO_INSTRUCTION_PVT.NULLIFY_INSTR_FOR_ENTITY',
4315: FALSE);
4316: END IF;
4309: ( P_COUNT => X_MSG_COUNT,
4310: P_DATA => X_MSG_DATA );
4311:
4312: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4313: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4314: 'gmo.plsql.GMO_INSTRUCTION_PVT.NULLIFY_INSTR_FOR_ENTITY',
4315: FALSE);
4316: END IF;
4317:
4391: FND_MSG_PUB.COUNT_AND_GET
4392: ( P_COUNT => X_MSG_COUNT,
4393: P_DATA => X_MSG_DATA);
4394:
4395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4396: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4397: 'gmo.plsql.GMO_INSTRUCTION_PVT.COMPLETE_OPTIONAL_INSTR',
4398: FALSE);
4399: END IF;
4392: ( P_COUNT => X_MSG_COUNT,
4393: P_DATA => X_MSG_DATA);
4394:
4395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4396: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4397: 'gmo.plsql.GMO_INSTRUCTION_PVT.COMPLETE_OPTIONAL_INSTR',
4398: FALSE);
4399: END IF;
4400:
4442:
4443: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4444: P_DATA => X_MSG_DATA);
4445:
4446: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4447: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4448: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_STATUS',
4449: FALSE);
4450: END IF;
4443: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4444: P_DATA => X_MSG_DATA);
4445:
4446: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4447: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4448: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_STATUS',
4449: FALSE);
4450: END IF;
4451:
4463: FND_MSG_PUB.COUNT_AND_GET
4464: ( P_COUNT => X_MSG_COUNT,
4465: P_DATA => X_MSG_DATA);
4466:
4467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4468: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4469: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_DEFN_STATUS',
4470: FALSE);
4471: END IF;
4464: ( P_COUNT => X_MSG_COUNT,
4465: P_DATA => X_MSG_DATA);
4466:
4467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4468: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4469: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_DEFN_STATUS',
4470: FALSE);
4471: END IF;
4472:
4515:
4516: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4517: P_DATA => X_MSG_DATA);
4518:
4519: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4520: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4521: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_INSTANCE_STATUS',
4522: FALSE);
4523: END IF;
4516: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4517: P_DATA => X_MSG_DATA);
4518:
4519: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4520: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4521: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_INSTANCE_STATUS',
4522: FALSE);
4523: END IF;
4524:
4536: FND_MSG_PUB.COUNT_AND_GET
4537: ( P_COUNT => X_MSG_COUNT,
4538: P_DATA => X_MSG_DATA);
4539:
4540: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4541: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4542: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTANCE_STATUS',
4543: FALSE);
4544: END IF;
4537: ( P_COUNT => X_MSG_COUNT,
4538: P_DATA => X_MSG_DATA);
4539:
4540: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4541: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4542: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTANCE_STATUS',
4543: FALSE);
4544: END IF;
4545:
4612: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4613:
4614: L_MESG_TEXT := FND_MESSAGE.GET();
4615:
4616: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4617: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4618: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CAPTURE_OPERATOR_RESPONSE',
4619: FALSE);
4620: END IF;
4613:
4614: L_MESG_TEXT := FND_MESSAGE.GET();
4615:
4616: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4617: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4618: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CAPTURE_OPERATOR_RESPONSE',
4619: FALSE);
4620: END IF;
4621:
4623:
4624: WHEN OTHERS THEN
4625: ROLLBACK;
4626:
4627: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4628: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4629: 'gmo.plsql.GMO_INSTRUCTION_PVT.CAPTURE_OPERATOR_RESPONSE',
4630: FALSE);
4631: END IF;
4624: WHEN OTHERS THEN
4625: ROLLBACK;
4626:
4627: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4628: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4629: 'gmo.plsql.GMO_INSTRUCTION_PVT.CAPTURE_OPERATOR_RESPONSE',
4630: FALSE);
4631: END IF;
4632:
4722: FND_MSG_PUB.COUNT_AND_GET
4723: ( P_COUNT => X_MSG_COUNT,
4724: P_DATA => X_MSG_DATA);
4725:
4726: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4727: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4728: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
4729: FALSE);
4730: END IF;
4723: ( P_COUNT => X_MSG_COUNT,
4724: P_DATA => X_MSG_DATA);
4725:
4726: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4727: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4728: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
4729: FALSE);
4730: END IF;
4731:
4968: FND_MSG_PUB.COUNT_AND_GET
4969: ( P_COUNT => X_MSG_COUNT,
4970: P_DATA => X_MSG_DATA);
4971:
4972: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4973: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4974: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_TEMPORARY_INSTANCES',
4975: FALSE);
4976: END IF;
4969: ( P_COUNT => X_MSG_COUNT,
4970: P_DATA => X_MSG_DATA);
4971:
4972: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4973: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4974: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_TEMPORARY_INSTANCES',
4975: FALSE);
4976: END IF;
4977:
5057: P_COUNT => X_MSG_COUNT,
5058: P_DATA => X_MSG_DATA
5059: );
5060:
5061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5062: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5063: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5064: FALSE);
5065: END IF;
5058: P_DATA => X_MSG_DATA
5059: );
5060:
5061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5062: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5063: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5064: FALSE);
5065: END IF;
5066:
5082: FND_MSG_PUB.COUNT_AND_GET
5083: ( P_COUNT => X_MSG_COUNT,
5084: P_DATA => X_MSG_DATA);
5085:
5086: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5087: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5088: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
5089: FALSE);
5090: END IF;
5083: ( P_COUNT => X_MSG_COUNT,
5084: P_DATA => X_MSG_DATA);
5085:
5086: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5087: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5088: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
5089: FALSE);
5090: END IF;
5091:
5233: FND_MSG_PUB.COUNT_AND_GET
5234: ( P_COUNT => X_MSG_COUNT,
5235: P_DATA => X_MSG_DATA);
5236:
5237: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5239: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5240: FALSE);
5241: END IF;
5234: ( P_COUNT => X_MSG_COUNT,
5235: P_DATA => X_MSG_DATA);
5236:
5237: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5239: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5240: FALSE);
5241: END IF;
5242:
5304: P_COUNT => X_MSG_COUNT,
5305: P_DATA => X_MSG_DATA
5306: );
5307:
5308: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5309: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5310: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5311: FALSE);
5312: END IF;
5305: P_DATA => X_MSG_DATA
5306: );
5307:
5308: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5309: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5310: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5311: FALSE);
5312: END IF;
5313:
5348: FND_MSG_PUB.COUNT_AND_GET
5349: ( P_COUNT => X_MSG_COUNT,
5350: P_DATA => X_MSG_DATA);
5351:
5352: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5353: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5354: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5355: FALSE);
5356: END IF;
5349: ( P_COUNT => X_MSG_COUNT,
5350: P_DATA => X_MSG_DATA);
5351:
5352: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5353: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5354: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5355: FALSE);
5356: END IF;
5357:
5411: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
5412: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5413: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5414:
5415: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5416: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5417: 'gmo.plsql.GMO_INSTRUCTION_PVT.UPDATE_INSTR_ATTRIBUTES',
5418: FALSE
5419: );
5412: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5413: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5414:
5415: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5416: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5417: 'gmo.plsql.GMO_INSTRUCTION_PVT.UPDATE_INSTR_ATTRIBUTES',
5418: FALSE
5419: );
5420: end if;
5474: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
5475: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5476: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5477:
5478: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5479: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5480: 'gmo.plsql.GMO_INSTRUCTION_PVT.SET_INSTR_STATUS_ATTRIBUTES',
5481: FALSE
5482: );
5475: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5476: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5477:
5478: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5479: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5480: 'gmo.plsql.GMO_INSTRUCTION_PVT.SET_INSTR_STATUS_ATTRIBUTES',
5481: FALSE
5482: );
5483: end if;
5528: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
5529: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
5530: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_INSTR_SET_DETAILS');
5531:
5532: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5533: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5534: 'gmo.plsql.GMO_INSTRUCTION_PVT.DELETE_INSTR_SET_DETAILS',
5535: FALSE
5536: );
5529: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
5530: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_INSTR_SET_DETAILS');
5531:
5532: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5533: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5534: 'gmo.plsql.GMO_INSTRUCTION_PVT.DELETE_INSTR_SET_DETAILS',
5535: FALSE
5536: );
5537: end if;
5807: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
5808: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5809: L_MESG_TEXT := FND_MESSAGE.GET;
5810:
5811: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5812: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5813: 'gmo.plsql.GMO_INSTRUCTION_PVT.'|| L_API_NAME,
5814: FALSE
5815: );
5808: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5809: L_MESG_TEXT := FND_MESSAGE.GET;
5810:
5811: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5812: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5813: 'gmo.plsql.GMO_INSTRUCTION_PVT.'|| L_API_NAME,
5814: FALSE
5815: );
5816: end if;
6229: (
6230: P_COUNT => X_MSG_COUNT,
6231: P_DATA => X_MSG_DATA
6232: );
6233: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6234: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
6235: 'gmo.plsql.gmo_instructions_pvt.add_instructions',
6236: FALSE);
6237: END IF;
6230: P_COUNT => X_MSG_COUNT,
6231: P_DATA => X_MSG_DATA
6232: );
6233: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6234: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
6235: 'gmo.plsql.gmo_instructions_pvt.add_instructions',
6236: FALSE);
6237: END IF;
6238: WHEN OTHERS THEN
6242: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6243: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6244: FND_MSG_PUB.ADD;
6245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6246: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6247: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6248: end if;
6249:
6250: END ADD_INSTRUCTIONS;
6243: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6244: FND_MSG_PUB.ADD;
6245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6246: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6247: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6248: end if;
6249:
6250: END ADD_INSTRUCTIONS;
6251:
6337: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
6338: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6339: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
6340: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_INSTR_INSTANCE_XML');
6341: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6342: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6343: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTR_INSTANCE_XML',
6344: FALSE
6345: );
6338: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6339: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
6340: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_INSTR_INSTANCE_XML');
6341: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6342: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6343: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTR_INSTANCE_XML',
6344: FALSE
6345: );
6346: end if;
6378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6379: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
6380: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','TERMINATE_INSTR_DEFN_PROCESS');
6381:
6382: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6383: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6384: 'gmo.plsql.GMO_INSTRUCTION_PVT.TERMINATE_INSTR_DEFN_PROCESS',
6385: FALSE
6386: );
6379: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
6380: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','TERMINATE_INSTR_DEFN_PROCESS');
6381:
6382: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6383: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6384: 'gmo.plsql.GMO_INSTRUCTION_PVT.TERMINATE_INSTR_DEFN_PROCESS',
6385: FALSE
6386: );
6387: end if;