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;
3958: FND_MSG_PUB.COUNT_AND_GET
3959: ( P_COUNT => X_MSG_COUNT,
3960: P_DATA => X_MSG_DATA);
3961:
3962: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3963: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3964: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3965: FALSE);
3966: END IF;
3959: ( P_COUNT => X_MSG_COUNT,
3960: P_DATA => X_MSG_DATA);
3961:
3962: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3963: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3964: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3965: FALSE);
3966: END IF;
3967:
4173: P_COUNT => X_MSG_COUNT,
4174: P_DATA => X_MSG_DATA
4175: );
4176:
4177: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4178: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4179: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4180: FALSE);
4181: END IF;
4174: P_DATA => X_MSG_DATA
4175: );
4176:
4177: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4178: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4179: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4180: FALSE);
4181: END IF;
4182:
4201: P_COUNT => X_MSG_COUNT,
4202: P_DATA => X_MSG_DATA
4203: );
4204:
4205: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4206: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4207: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4208: FALSE);
4209: END IF;
4202: P_DATA => X_MSG_DATA
4203: );
4204:
4205: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4206: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4207: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_TASK_ACKN',
4208: FALSE);
4209: END IF;
4210:
4221: FND_MSG_PUB.COUNT_AND_GET
4222: ( P_COUNT => X_MSG_COUNT,
4223: P_DATA => X_MSG_DATA);
4224:
4225: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4226: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4227: 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_TASK_ACKN',
4228: FALSE);
4229: END IF;
4222: ( P_COUNT => X_MSG_COUNT,
4223: P_DATA => X_MSG_DATA);
4224:
4225: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4226: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4227: 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_TASK_ACKN',
4228: FALSE);
4229: END IF;
4230: END SEND_TASK_ACKN;
4286: FND_MSG_PUB.COUNT_AND_GET
4287: ( P_COUNT => X_MSG_COUNT,
4288: P_DATA => X_MSG_DATA );
4289:
4290: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4291: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4292: 'gmo.plsql.GMO_INSTRUCTION_PVT.NULLIFY_INSTR_FOR_ENTITY',
4293: FALSE);
4294: END IF;
4287: ( P_COUNT => X_MSG_COUNT,
4288: P_DATA => X_MSG_DATA );
4289:
4290: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4291: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4292: 'gmo.plsql.GMO_INSTRUCTION_PVT.NULLIFY_INSTR_FOR_ENTITY',
4293: FALSE);
4294: END IF;
4295:
4369: FND_MSG_PUB.COUNT_AND_GET
4370: ( P_COUNT => X_MSG_COUNT,
4371: P_DATA => X_MSG_DATA);
4372:
4373: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4375: 'gmo.plsql.GMO_INSTRUCTION_PVT.COMPLETE_OPTIONAL_INSTR',
4376: FALSE);
4377: END IF;
4370: ( P_COUNT => X_MSG_COUNT,
4371: P_DATA => X_MSG_DATA);
4372:
4373: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4375: 'gmo.plsql.GMO_INSTRUCTION_PVT.COMPLETE_OPTIONAL_INSTR',
4376: FALSE);
4377: END IF;
4378:
4420:
4421: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4422: P_DATA => X_MSG_DATA);
4423:
4424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4425: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4426: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_STATUS',
4427: FALSE);
4428: END IF;
4421: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4422: P_DATA => X_MSG_DATA);
4423:
4424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4425: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4426: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_STATUS',
4427: FALSE);
4428: END IF;
4429:
4441: FND_MSG_PUB.COUNT_AND_GET
4442: ( P_COUNT => X_MSG_COUNT,
4443: P_DATA => X_MSG_DATA);
4444:
4445: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4446: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4447: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_DEFN_STATUS',
4448: FALSE);
4449: END IF;
4442: ( P_COUNT => X_MSG_COUNT,
4443: P_DATA => X_MSG_DATA);
4444:
4445: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4446: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4447: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_DEFN_STATUS',
4448: FALSE);
4449: END IF;
4450:
4493:
4494: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4495: P_DATA => X_MSG_DATA);
4496:
4497: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4498: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4499: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_INSTANCE_STATUS',
4500: FALSE);
4501: END IF;
4494: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4495: P_DATA => X_MSG_DATA);
4496:
4497: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4498: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4499: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_INSTANCE_STATUS',
4500: FALSE);
4501: END IF;
4502:
4514: FND_MSG_PUB.COUNT_AND_GET
4515: ( P_COUNT => X_MSG_COUNT,
4516: P_DATA => X_MSG_DATA);
4517:
4518: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4519: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4520: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTANCE_STATUS',
4521: FALSE);
4522: END IF;
4515: ( P_COUNT => X_MSG_COUNT,
4516: P_DATA => X_MSG_DATA);
4517:
4518: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4519: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4520: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTANCE_STATUS',
4521: FALSE);
4522: END IF;
4523:
4590: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4591:
4592: L_MESG_TEXT := FND_MESSAGE.GET();
4593:
4594: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4595: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4596: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CAPTURE_OPERATOR_RESPONSE',
4597: FALSE);
4598: END IF;
4591:
4592: L_MESG_TEXT := FND_MESSAGE.GET();
4593:
4594: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4595: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
4596: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CAPTURE_OPERATOR_RESPONSE',
4597: FALSE);
4598: END IF;
4599:
4601:
4602: WHEN OTHERS THEN
4603: ROLLBACK;
4604:
4605: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4606: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4607: 'gmo.plsql.GMO_INSTRUCTION_PVT.CAPTURE_OPERATOR_RESPONSE',
4608: FALSE);
4609: END IF;
4602: WHEN OTHERS THEN
4603: ROLLBACK;
4604:
4605: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4606: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4607: 'gmo.plsql.GMO_INSTRUCTION_PVT.CAPTURE_OPERATOR_RESPONSE',
4608: FALSE);
4609: END IF;
4610:
4700: FND_MSG_PUB.COUNT_AND_GET
4701: ( P_COUNT => X_MSG_COUNT,
4702: P_DATA => X_MSG_DATA);
4703:
4704: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4705: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4706: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
4707: FALSE);
4708: END IF;
4701: ( P_COUNT => X_MSG_COUNT,
4702: P_DATA => X_MSG_DATA);
4703:
4704: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4705: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4706: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
4707: FALSE);
4708: END IF;
4709:
4946: FND_MSG_PUB.COUNT_AND_GET
4947: ( P_COUNT => X_MSG_COUNT,
4948: P_DATA => X_MSG_DATA);
4949:
4950: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4951: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4952: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_TEMPORARY_INSTANCES',
4953: FALSE);
4954: END IF;
4947: ( P_COUNT => X_MSG_COUNT,
4948: P_DATA => X_MSG_DATA);
4949:
4950: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4951: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
4952: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_TEMPORARY_INSTANCES',
4953: FALSE);
4954: END IF;
4955:
5035: P_COUNT => X_MSG_COUNT,
5036: P_DATA => X_MSG_DATA
5037: );
5038:
5039: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5040: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5041: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5042: FALSE);
5043: END IF;
5036: P_DATA => X_MSG_DATA
5037: );
5038:
5039: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5040: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5041: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5042: FALSE);
5043: END IF;
5044:
5060: FND_MSG_PUB.COUNT_AND_GET
5061: ( P_COUNT => X_MSG_COUNT,
5062: P_DATA => X_MSG_DATA);
5063:
5064: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5065: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5066: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
5067: FALSE);
5068: END IF;
5061: ( P_COUNT => X_MSG_COUNT,
5062: P_DATA => X_MSG_DATA);
5063:
5064: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5065: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5066: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
5067: FALSE);
5068: END IF;
5069:
5211: FND_MSG_PUB.COUNT_AND_GET
5212: ( P_COUNT => X_MSG_COUNT,
5213: P_DATA => X_MSG_DATA);
5214:
5215: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5216: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5217: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5218: FALSE);
5219: END IF;
5212: ( P_COUNT => X_MSG_COUNT,
5213: P_DATA => X_MSG_DATA);
5214:
5215: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5216: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5217: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5218: FALSE);
5219: END IF;
5220:
5282: P_COUNT => X_MSG_COUNT,
5283: P_DATA => X_MSG_DATA
5284: );
5285:
5286: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5287: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5288: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5289: FALSE);
5290: END IF;
5283: P_DATA => X_MSG_DATA
5284: );
5285:
5286: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5287: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
5288: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5289: FALSE);
5290: END IF;
5291:
5326: FND_MSG_PUB.COUNT_AND_GET
5327: ( P_COUNT => X_MSG_COUNT,
5328: P_DATA => X_MSG_DATA);
5329:
5330: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5331: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5332: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5333: FALSE);
5334: END IF;
5327: ( P_COUNT => X_MSG_COUNT,
5328: P_DATA => X_MSG_DATA);
5329:
5330: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5331: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5332: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5333: FALSE);
5334: END IF;
5335:
5389: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
5390: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5391: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5392:
5393: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5394: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5395: 'gmo.plsql.GMO_INSTRUCTION_PVT.UPDATE_INSTR_ATTRIBUTES',
5396: FALSE
5397: );
5390: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5391: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5392:
5393: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5394: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5395: 'gmo.plsql.GMO_INSTRUCTION_PVT.UPDATE_INSTR_ATTRIBUTES',
5396: FALSE
5397: );
5398: end if;
5452: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
5453: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5454: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5455:
5456: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5457: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5458: 'gmo.plsql.GMO_INSTRUCTION_PVT.SET_INSTR_STATUS_ATTRIBUTES',
5459: FALSE
5460: );
5453: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
5454: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5455:
5456: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5457: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5458: 'gmo.plsql.GMO_INSTRUCTION_PVT.SET_INSTR_STATUS_ATTRIBUTES',
5459: FALSE
5460: );
5461: end if;
5506: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
5507: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
5508: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_INSTR_SET_DETAILS');
5509:
5510: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5511: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5512: 'gmo.plsql.GMO_INSTRUCTION_PVT.DELETE_INSTR_SET_DETAILS',
5513: FALSE
5514: );
5507: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
5508: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_INSTR_SET_DETAILS');
5509:
5510: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5511: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5512: 'gmo.plsql.GMO_INSTRUCTION_PVT.DELETE_INSTR_SET_DETAILS',
5513: FALSE
5514: );
5515: end if;
5785: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
5786: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5787: L_MESG_TEXT := FND_MESSAGE.GET;
5788:
5789: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5790: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5791: 'gmo.plsql.GMO_INSTRUCTION_PVT.'|| L_API_NAME,
5792: FALSE
5793: );
5786: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
5787: L_MESG_TEXT := FND_MESSAGE.GET;
5788:
5789: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5790: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
5791: 'gmo.plsql.GMO_INSTRUCTION_PVT.'|| L_API_NAME,
5792: FALSE
5793: );
5794: end if;
6206: (
6207: P_COUNT => X_MSG_COUNT,
6208: P_DATA => X_MSG_DATA
6209: );
6210: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6211: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
6212: 'gmo.plsql.gmo_instructions_pvt.add_instructions',
6213: FALSE);
6214: END IF;
6207: P_COUNT => X_MSG_COUNT,
6208: P_DATA => X_MSG_DATA
6209: );
6210: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6211: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
6212: 'gmo.plsql.gmo_instructions_pvt.add_instructions',
6213: FALSE);
6214: END IF;
6215: WHEN OTHERS THEN
6219: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6220: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6221: FND_MSG_PUB.ADD;
6222: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6223: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6224: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6225: end if;
6226:
6227: END ADD_INSTRUCTIONS;
6220: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6221: FND_MSG_PUB.ADD;
6222: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6223: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6224: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6225: end if;
6226:
6227: END ADD_INSTRUCTIONS;
6228:
6314: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
6315: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6316: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
6317: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_INSTR_INSTANCE_XML');
6318: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6319: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6320: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTR_INSTANCE_XML',
6321: FALSE
6322: );
6315: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6316: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');
6317: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_INSTR_INSTANCE_XML');
6318: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6319: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6320: 'gmo.plsql.GMO_INSTRUCTION_PVT.GET_INSTR_INSTANCE_XML',
6321: FALSE
6322: );
6323: end if;
6355: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6356: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
6357: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','TERMINATE_INSTR_DEFN_PROCESS');
6358:
6359: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6360: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6361: 'gmo.plsql.GMO_INSTRUCTION_PVT.TERMINATE_INSTR_DEFN_PROCESS',
6362: FALSE
6363: );
6356: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
6357: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','TERMINATE_INSTR_DEFN_PROCESS');
6358:
6359: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6360: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
6361: 'gmo.plsql.GMO_INSTRUCTION_PVT.TERMINATE_INSTR_DEFN_PROCESS',
6362: FALSE
6363: );
6364: end if;