APPS.GMO_INSTRUCTION_PVT dependencies on FND_MESSAGE

Line 68: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

64: COMMIT;
65: EXCEPTION
66: WHEN OTHERS THEN
67: ROLLBACK;
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

Line 69: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

65: EXCEPTION
66: WHEN OTHERS THEN
67: ROLLBACK;
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,

Line 70: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');

66: WHEN OTHERS THEN
67: ROLLBACK;
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',

Line 71: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','UPDATE_ENTITY_KEY');

67: ROLLBACK;
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

Line 673: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_MODE_PARAM_ERR');

669: EXCEPTION
670: WHEN L_MODE_PARAM_ERR THEN
671:
672: ROLLBACK;
673: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_MODE_PARAM_ERR');
674: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );
677: L_MESG_TEXT := FND_MESSAGE.GET();

Line 674: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

670: WHEN L_MODE_PARAM_ERR THEN
671:
672: ROLLBACK;
673: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_MODE_PARAM_ERR');
674: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );
677: L_MESG_TEXT := FND_MESSAGE.GET();
678:

Line 675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

671:
672: ROLLBACK;
673: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_MODE_PARAM_ERR');
674: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );
677: L_MESG_TEXT := FND_MESSAGE.GET();
678:
679: FND_MSG_PUB.ADD_EXC_MSG

Line 676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );

672: ROLLBACK;
673: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_MODE_PARAM_ERR');
674: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );
677: L_MESG_TEXT := FND_MESSAGE.GET();
678:
679: FND_MSG_PUB.ADD_EXC_MSG
680: ( G_PKG_NAME,

Line 677: L_MESG_TEXT := FND_MESSAGE.GET();

673: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_MODE_PARAM_ERR');
674: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );
677: L_MESG_TEXT := FND_MESSAGE.GET();
678:
679: FND_MSG_PUB.ADD_EXC_MSG
680: ( G_PKG_NAME,
681: L_API_NAME,

Line 972: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

968: WHEN OTHERS THEN
969: ROLLBACK;
970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
971:
972: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
976: FND_MSG_PUB.ADD;

Line 973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

969: ROLLBACK;
970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
971:
972: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
976: FND_MSG_PUB.ADD;
977:

Line 974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);

970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
971:
972: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
976: FND_MSG_PUB.ADD;
977:
978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);

971:
972: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
976: FND_MSG_PUB.ADD;
977:
978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
979:

Line 1314: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');

1310: EXCEPTION
1311: WHEN L_SOURCE_ENTITY_ERR THEN
1312: X_INSTRUCTION_SET_ID := -1;
1313:
1314: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
1315: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1316: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1317: L_MESG_TEXT := FND_MESSAGE.GET();
1318:

Line 1315: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

1311: WHEN L_SOURCE_ENTITY_ERR THEN
1312: X_INSTRUCTION_SET_ID := -1;
1313:
1314: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
1315: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1316: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1317: L_MESG_TEXT := FND_MESSAGE.GET();
1318:
1319: FND_MSG_PUB.ADD_EXC_MSG

Line 1316: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);

1312: X_INSTRUCTION_SET_ID := -1;
1313:
1314: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
1315: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1316: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1317: L_MESG_TEXT := FND_MESSAGE.GET();
1318:
1319: FND_MSG_PUB.ADD_EXC_MSG
1320: ( G_PKG_NAME,

Line 1317: L_MESG_TEXT := FND_MESSAGE.GET();

1313:
1314: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
1315: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1316: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1317: L_MESG_TEXT := FND_MESSAGE.GET();
1318:
1319: FND_MSG_PUB.ADD_EXC_MSG
1320: ( G_PKG_NAME,
1321: L_API_NAME,

Line 1342: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_TARGET_ENTITY_ER');

1338:
1339: WHEN L_TARGET_ENTITY_ERR THEN
1340: X_INSTRUCTION_SET_ID := -1;
1341:
1342: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_TARGET_ENTITY_ER');
1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1344: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1345: L_MESG_TEXT := FND_MESSAGE.GET();
1346:

Line 1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

1339: WHEN L_TARGET_ENTITY_ERR THEN
1340: X_INSTRUCTION_SET_ID := -1;
1341:
1342: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_TARGET_ENTITY_ER');
1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1344: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1345: L_MESG_TEXT := FND_MESSAGE.GET();
1346:
1347: FND_MSG_PUB.ADD_EXC_MSG

Line 1344: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);

1340: X_INSTRUCTION_SET_ID := -1;
1341:
1342: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_TARGET_ENTITY_ER');
1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1344: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1345: L_MESG_TEXT := FND_MESSAGE.GET();
1346:
1347: FND_MSG_PUB.ADD_EXC_MSG
1348: ( G_PKG_NAME,

Line 1345: L_MESG_TEXT := FND_MESSAGE.GET();

1341:
1342: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_TARGET_ENTITY_ER');
1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1344: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1345: L_MESG_TEXT := FND_MESSAGE.GET();
1346:
1347: FND_MSG_PUB.ADD_EXC_MSG
1348: ( G_PKG_NAME,
1349: L_API_NAME,

Line 2137: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');

2133:
2134: EXCEPTION
2135: WHEN L_ENTITY_INFO_NOTFOUND_ERR THEN
2136:
2137: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
2138: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2140: L_MESG_TEXT := FND_MESSAGE.GET();
2141:

Line 2138: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

2134: EXCEPTION
2135: WHEN L_ENTITY_INFO_NOTFOUND_ERR THEN
2136:
2137: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
2138: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2140: L_MESG_TEXT := FND_MESSAGE.GET();
2141:
2142: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME,L_MESG_TEXT );

Line 2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

2135: WHEN L_ENTITY_INFO_NOTFOUND_ERR THEN
2136:
2137: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
2138: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
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 );

Line 2140: L_MESG_TEXT := FND_MESSAGE.GET();

2136:
2137: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
2138: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
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

Line 2351: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_PARAM_ERR');

2347: OR P_DEFINITION_ENTITY_KEY IS NULL
2348: OR P_INSTANCE_ENTITY_NAME IS NULL
2349: OR P_INSTRUCTION_TYPE IS NULL ) THEN
2350:
2351: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_PARAM_ERR');
2352: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2353: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2354: L_MESG_TEXT := FND_MESSAGE.GET();
2355:

Line 2352: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

2348: OR P_INSTANCE_ENTITY_NAME IS NULL
2349: OR P_INSTRUCTION_TYPE IS NULL ) THEN
2350:
2351: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_PARAM_ERR');
2352: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2353: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2354: L_MESG_TEXT := FND_MESSAGE.GET();
2355:
2356: FND_MSG_PUB.ADD_EXC_MSG

Line 2353: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

2349: OR P_INSTRUCTION_TYPE IS NULL ) THEN
2350:
2351: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_PARAM_ERR');
2352: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2353: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2354: L_MESG_TEXT := FND_MESSAGE.GET();
2355:
2356: FND_MSG_PUB.ADD_EXC_MSG
2357: ( G_PKG_NAME,

Line 2354: L_MESG_TEXT := FND_MESSAGE.GET();

2350:
2351: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_PARAM_ERR');
2352: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2353: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2354: L_MESG_TEXT := FND_MESSAGE.GET();
2355:
2356: FND_MSG_PUB.ADD_EXC_MSG
2357: ( G_PKG_NAME,
2358: L_API_NAME,

Line 2628: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_DIS_NOTFOUND');

2624: -- not create instance, log the error and return ERROR status
2625:
2626: X_INSTRUCTION_SET_ID := -1;
2627:
2628: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_DIS_NOTFOUND');
2629: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2630: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2631:
2632: L_MESG_TEXT := FND_MESSAGE.GET();

Line 2629: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

2625:
2626: X_INSTRUCTION_SET_ID := -1;
2627:
2628: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_DIS_NOTFOUND');
2629: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2630: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2631:
2632: L_MESG_TEXT := FND_MESSAGE.GET();
2633:

Line 2630: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

2626: X_INSTRUCTION_SET_ID := -1;
2627:
2628: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_DIS_NOTFOUND');
2629: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2630: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2631:
2632: L_MESG_TEXT := FND_MESSAGE.GET();
2633:
2634: FND_MSG_PUB.ADD_EXC_MSG

Line 2632: L_MESG_TEXT := FND_MESSAGE.GET();

2628: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_CIFD_DIS_NOTFOUND');
2629: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2630: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2631:
2632: L_MESG_TEXT := FND_MESSAGE.GET();
2633:
2634: FND_MSG_PUB.ADD_EXC_MSG
2635: ( G_PKG_NAME,
2636: L_API_NAME,

Line 2797: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_ALREADY_ACTIVE');

2793: -- set already active
2794: X_INSTRUCTION_SET_ID := -1;
2795: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2796:
2797: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_ALREADY_ACTIVE');
2798: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2799: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
2800:
2801: L_MESG_TEXT := FND_MESSAGE.GET();

Line 2798: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

2794: X_INSTRUCTION_SET_ID := -1;
2795: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2796:
2797: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_ALREADY_ACTIVE');
2798: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2799: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
2800:
2801: L_MESG_TEXT := FND_MESSAGE.GET();
2802:

Line 2799: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);

2795: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2796:
2797: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_ALREADY_ACTIVE');
2798: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2799: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
2800:
2801: L_MESG_TEXT := FND_MESSAGE.GET();
2802:
2803: FND_MSG_PUB.ADD_EXC_MSG

Line 2801: L_MESG_TEXT := FND_MESSAGE.GET();

2797: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_ALREADY_ACTIVE');
2798: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2799: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
2800:
2801: L_MESG_TEXT := FND_MESSAGE.GET();
2802:
2803: FND_MSG_PUB.ADD_EXC_MSG
2804: ( G_PKG_NAME,
2805: L_API_NAME,

Line 3154: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');

3150: EXCEPTION
3151: WHEN L_ENTITY_ERR THEN
3152: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3153:
3154: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3155: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3156: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3157:
3158: L_MESG_TEXT := FND_MESSAGE.GET();

Line 3155: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

3151: WHEN L_ENTITY_ERR THEN
3152: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3153:
3154: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3155: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3156: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3157:
3158: L_MESG_TEXT := FND_MESSAGE.GET();
3159:

Line 3156: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

3152: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3153:
3154: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3155: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3156: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3157:
3158: L_MESG_TEXT := FND_MESSAGE.GET();
3159:
3160: FND_MSG_PUB.ADD_EXC_MSG

Line 3158: L_MESG_TEXT := FND_MESSAGE.GET();

3154: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3155: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3156: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3157:
3158: L_MESG_TEXT := FND_MESSAGE.GET();
3159:
3160: FND_MSG_PUB.ADD_EXC_MSG
3161: ( G_PKG_NAME,
3162: L_API_NAME,

Line 3282: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');

3278: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3279:
3280: EXCEPTION
3281: WHEN L_ENTITY_PARAM_ERR THEN
3282: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3283: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3284: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3285:
3286: L_MESG_TEXT := FND_MESSAGE.GET();

Line 3283: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

3279:
3280: EXCEPTION
3281: WHEN L_ENTITY_PARAM_ERR THEN
3282: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3283: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3284: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3285:
3286: L_MESG_TEXT := FND_MESSAGE.GET();
3287:

Line 3284: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

3280: EXCEPTION
3281: WHEN L_ENTITY_PARAM_ERR THEN
3282: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3283: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3284: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3285:
3286: L_MESG_TEXT := FND_MESSAGE.GET();
3287:
3288: FND_MSG_PUB.ADD_EXC_MSG

Line 3286: L_MESG_TEXT := FND_MESSAGE.GET();

3282: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3283: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3284: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3285:
3286: L_MESG_TEXT := FND_MESSAGE.GET();
3287:
3288: FND_MSG_PUB.ADD_EXC_MSG
3289: ( G_PKG_NAME,
3290: L_API_NAME,

Line 3309: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');

3305:
3306: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3307:
3308: WHEN L_INVALID_ENTITY_ERR THEN
3309: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3311: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3312:
3313: L_MESG_TEXT := FND_MESSAGE.GET();

Line 3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

3306: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3307:
3308: WHEN L_INVALID_ENTITY_ERR THEN
3309: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3311: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3312:
3313: L_MESG_TEXT := FND_MESSAGE.GET();
3314:

Line 3311: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

3307:
3308: WHEN L_INVALID_ENTITY_ERR THEN
3309: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3311: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3312:
3313: L_MESG_TEXT := FND_MESSAGE.GET();
3314:
3315: FND_MSG_PUB.ADD_EXC_MSG

Line 3313: L_MESG_TEXT := FND_MESSAGE.GET();

3309: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SOURCE_ENTITY_ER');
3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3311: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3312:
3313: L_MESG_TEXT := FND_MESSAGE.GET();
3314:
3315: FND_MSG_PUB.ADD_EXC_MSG
3316: ( G_PKG_NAME,
3317: L_API_NAME,

Line 3455: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');

3451: X_TOTAL_INSTRUCTIONS := 0;
3452: X_OPTIONAL_PENDING_INSTR := 0;
3453: X_MANDATORY_PENDING_INSTR := 0;
3454:
3455: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3456: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3457: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3458:
3459: L_MESG_TEXT := FND_MESSAGE.GET();

Line 3456: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

3452: X_OPTIONAL_PENDING_INSTR := 0;
3453: X_MANDATORY_PENDING_INSTR := 0;
3454:
3455: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3456: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3457: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3458:
3459: L_MESG_TEXT := FND_MESSAGE.GET();
3460:

Line 3457: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

3453: X_MANDATORY_PENDING_INSTR := 0;
3454:
3455: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3456: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3457: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3458:
3459: L_MESG_TEXT := FND_MESSAGE.GET();
3460:
3461: FND_MSG_PUB.ADD_EXC_MSG

Line 3459: L_MESG_TEXT := FND_MESSAGE.GET();

3455: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3456: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3457: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3458:
3459: L_MESG_TEXT := FND_MESSAGE.GET();
3460:
3461: FND_MSG_PUB.ADD_EXC_MSG
3462: ( G_PKG_NAME,
3463: L_API_NAME,

Line 3591: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');

3587: X_TOTAL_INSTRUCTIONS := 0;
3588: X_OPTIONAL_PENDING_INSTR := 0;
3589: X_MANDATORY_PENDING_INSTR := 0;
3590:
3591: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3593: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3594:
3595: L_MESG_TEXT := FND_MESSAGE.GET();

Line 3592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

3588: X_OPTIONAL_PENDING_INSTR := 0;
3589: X_MANDATORY_PENDING_INSTR := 0;
3590:
3591: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3593: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3594:
3595: L_MESG_TEXT := FND_MESSAGE.GET();
3596:

Line 3593: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

3589: X_MANDATORY_PENDING_INSTR := 0;
3590:
3591: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3593: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3594:
3595: L_MESG_TEXT := FND_MESSAGE.GET();
3596:
3597: FND_MSG_PUB.ADD_EXC_MSG

Line 3595: L_MESG_TEXT := FND_MESSAGE.GET();

3591: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
3592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
3593: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3594:
3595: L_MESG_TEXT := FND_MESSAGE.GET();
3596:
3597: FND_MSG_PUB.ADD_EXC_MSG
3598: ( G_PKG_NAME,
3599: L_API_NAME,

Line 4181: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');

4177: WHEN L_INVALID_PARAM_ERR THEN
4178: ROLLBACK;
4179: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4180:
4181: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4183: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4184:
4185: L_MESG_TEXT := FND_MESSAGE.GET();

Line 4182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

4178: ROLLBACK;
4179: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4180:
4181: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4183: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4184:
4185: L_MESG_TEXT := FND_MESSAGE.GET();
4186:

Line 4183: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

4179: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4180:
4181: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4183: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4184:
4185: L_MESG_TEXT := FND_MESSAGE.GET();
4186:
4187: FND_MSG_PUB.ADD_EXC_MSG

Line 4185: L_MESG_TEXT := FND_MESSAGE.GET();

4181: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4183: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4184:
4185: L_MESG_TEXT := FND_MESSAGE.GET();
4186:
4187: FND_MSG_PUB.ADD_EXC_MSG
4188: ( G_PKG_NAME,
4189: L_API_NAME,

Line 4209: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');

4205: WHEN L_ENTITY_KEY_ERR THEN
4206: ROLLBACK;
4207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4208:
4209: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4211: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4212:
4213: L_MESG_TEXT := FND_MESSAGE.GET();

Line 4210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

4206: ROLLBACK;
4207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4208:
4209: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4211: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4212:
4213: L_MESG_TEXT := FND_MESSAGE.GET();
4214:

Line 4211: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

4207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4208:
4209: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4211: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4212:
4213: L_MESG_TEXT := FND_MESSAGE.GET();
4214:
4215: FND_MSG_PUB.ADD_EXC_MSG

Line 4213: L_MESG_TEXT := FND_MESSAGE.GET();

4209: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4211: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4212:
4213: L_MESG_TEXT := FND_MESSAGE.GET();
4214:
4215: FND_MSG_PUB.ADD_EXC_MSG
4216: ( G_PKG_NAME,
4217: L_API_NAME,

Line 4432: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');

4428:
4429: EXCEPTION
4430: WHEN NO_DATA_FOUND THEN
4431:
4432: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4433: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4434: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4436:

Line 4433: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

4429: EXCEPTION
4430: WHEN NO_DATA_FOUND THEN
4431:
4432: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4433: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4434: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4436:
4437: L_MESG_TEXT := FND_MESSAGE.GET();

Line 4434: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

4430: WHEN NO_DATA_FOUND THEN
4431:
4432: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4433: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4434: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4436:
4437: L_MESG_TEXT := FND_MESSAGE.GET();
4438:

Line 4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );

4431:
4432: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4433: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4434: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4436:
4437: L_MESG_TEXT := FND_MESSAGE.GET();
4438:
4439: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

Line 4437: L_MESG_TEXT := FND_MESSAGE.GET();

4433: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4434: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4436:
4437: L_MESG_TEXT := FND_MESSAGE.GET();
4438:
4439: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4440: L_API_NAME,
4441: L_MESG_TEXT);

Line 4505: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');

4501:
4502: EXCEPTION
4503: WHEN NO_DATA_FOUND THEN
4504:
4505: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4506: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4507: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4509:

Line 4506: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

4502: EXCEPTION
4503: WHEN NO_DATA_FOUND THEN
4504:
4505: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4506: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4507: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4509:
4510: L_MESG_TEXT := FND_MESSAGE.GET();

Line 4507: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

4503: WHEN NO_DATA_FOUND THEN
4504:
4505: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4506: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4507: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4509:
4510: L_MESG_TEXT := FND_MESSAGE.GET();
4511:

Line 4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );

4504:
4505: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4506: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4507: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4509:
4510: L_MESG_TEXT := FND_MESSAGE.GET();
4511:
4512: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

Line 4510: L_MESG_TEXT := FND_MESSAGE.GET();

4506: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4507: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4509:
4510: L_MESG_TEXT := FND_MESSAGE.GET();
4511:
4512: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4513: L_API_NAME,
4514: L_MESG_TEXT);

Line 4609: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');

4605: EXCEPTION
4606: WHEN L_INVALID_PROCESS_ID THEN
4607: ROLLBACK;
4608:
4609: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4610: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4611: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4612: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4613:

Line 4610: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

4606: WHEN L_INVALID_PROCESS_ID THEN
4607: ROLLBACK;
4608:
4609: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4610: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4611: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4612: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4613:
4614: L_MESG_TEXT := FND_MESSAGE.GET();

Line 4611: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

4607: ROLLBACK;
4608:
4609: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4610: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4611: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4612: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4613:
4614: L_MESG_TEXT := FND_MESSAGE.GET();
4615:

Line 4612: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );

4608:
4609: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4610: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4611: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
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

Line 4614: L_MESG_TEXT := FND_MESSAGE.GET();

4610: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4611: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
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',

Line 5043: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');

5039:
5040: ROLLBACK;
5041: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5042:
5043: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5044: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5045: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5046:
5047: L_MESG_TEXT := FND_MESSAGE.GET();

Line 5044: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

5040: ROLLBACK;
5041: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5042:
5043: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5044: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5045: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5046:
5047: L_MESG_TEXT := FND_MESSAGE.GET();
5048:

Line 5045: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

5041: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5042:
5043: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5044: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5045: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5046:
5047: L_MESG_TEXT := FND_MESSAGE.GET();
5048:
5049: FND_MSG_PUB.ADD_EXC_MSG

Line 5047: L_MESG_TEXT := FND_MESSAGE.GET();

5043: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5044: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5045: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5046:
5047: L_MESG_TEXT := FND_MESSAGE.GET();
5048:
5049: FND_MSG_PUB.ADD_EXC_MSG
5050: ( G_PKG_NAME,
5051: L_API_NAME,

Line 5290: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');

5286: X_ENTITY_NAME := NULL;
5287: X_ENTITY_KEY := NULL;
5288: X_INSTRUCTION_TYPE := NULL;
5289:
5290: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5291: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5292: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5293:
5294: L_MESG_TEXT := FND_MESSAGE.GET();

Line 5291: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);

5287: X_ENTITY_KEY := NULL;
5288: X_INSTRUCTION_TYPE := NULL;
5289:
5290: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5291: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5292: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5293:
5294: L_MESG_TEXT := FND_MESSAGE.GET();
5295:

Line 5292: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );

5288: X_INSTRUCTION_TYPE := NULL;
5289:
5290: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5291: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5292: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5293:
5294: L_MESG_TEXT := FND_MESSAGE.GET();
5295:
5296: FND_MSG_PUB.ADD_EXC_MSG

Line 5294: L_MESG_TEXT := FND_MESSAGE.GET();

5290: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5291: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5292: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5293:
5294: L_MESG_TEXT := FND_MESSAGE.GET();
5295:
5296: FND_MSG_PUB.ADD_EXC_MSG
5297: ( G_PKG_NAME,
5298: L_API_NAME,

Line 5410: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

5406: EXCEPTION
5407: WHEN OTHERS THEN
5408: ROLLBACK;
5409:
5410: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

Line 5411: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

5407: WHEN OTHERS THEN
5408: ROLLBACK;
5409:
5410: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

Line 5412: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);

5408: ROLLBACK;
5409:
5410: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

Line 5413: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);

5409:
5410: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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',

Line 5473: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

5469: EXCEPTION
5470: WHEN OTHERS THEN
5471: ROLLBACK;
5472:
5473: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

Line 5474: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

5470: WHEN OTHERS THEN
5471: ROLLBACK;
5472:
5473: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

Line 5475: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);

5471: ROLLBACK;
5472:
5473: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

Line 5476: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);

5472:
5473: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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',

Line 5527: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

5523: WHEN OTHERS THEN
5524:
5525: ROLLBACK;
5526: --Diagnostics Start
5527: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

Line 5528: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

5524:
5525: ROLLBACK;
5526: --Diagnostics Start
5527: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

Line 5529: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');

5525: ROLLBACK;
5526: --Diagnostics Start
5527: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

Line 5530: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_INSTR_SET_DETAILS');

5526: --Diagnostics Start
5527: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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',

Line 5805: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

5801: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5802: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.YES;
5803:
5804: --Diagnostics Start
5805: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5806: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

Line 5806: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

5802: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.YES;
5803:
5804: --Diagnostics Start
5805: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5806: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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:

Line 5807: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');

5803:
5804: --Diagnostics Start
5805: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5806: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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

Line 5808: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);

5804: --Diagnostics Start
5805: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5806: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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,

Line 5809: L_MESG_TEXT := FND_MESSAGE.GET;

5805: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5806: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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,

Line 5880: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_NOT_REQUIRED'),

5876: DECODE((SELECT COUNT(*) FROM GMO_INSTR_APPR_DEFN_T APPR
5877: WHERE
5878: APPR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
5879: AND APPR.INSTRUCTION_ID = INSTR.INSTRUCTION_ID),0,
5880: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_NOT_REQUIRED'),
5881: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_REQUIRED'))
5882: FROM DUAL)
5883: AS SIGNATURE_REQUIRED
5884: )

Line 5881: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_REQUIRED'))

5877: WHERE
5878: APPR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
5879: AND APPR.INSTRUCTION_ID = INSTR.INSTRUCTION_ID),0,
5880: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_NOT_REQUIRED'),
5881: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_REQUIRED'))
5882: FROM DUAL)
5883: AS SIGNATURE_REQUIRED
5884: )
5885: )

Line 6226: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');

6222: WHEN INVALID_TASK_ERR THEN
6223: ROLLBACK;
6224:
6225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6226: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');
6227: FND_MSG_PUB.ADD;
6228: FND_MSG_PUB.COUNT_AND_GET
6229: (
6230: P_COUNT => X_MSG_COUNT,

Line 6241: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');

6237: END IF;
6238: WHEN OTHERS THEN
6239: rollback;
6240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6241: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
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);

Line 6242: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

6238: WHEN OTHERS THEN
6239: rollback;
6240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6241: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
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

Line 6243: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

6239: rollback;
6240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6241: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
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);

Line 6337: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

6333: X_OUTPUT_XML := L_INSTR_XML.GETCLOBVAL();
6334:
6335: EXCEPTION
6336: WHEN OTHERS THEN
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

Line 6338: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

6334:
6335: EXCEPTION
6336: WHEN OTHERS THEN
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,

Line 6339: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_INSTRUCTION_PVT');

6335: EXCEPTION
6336: WHEN OTHERS THEN
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',

Line 6340: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_INSTR_INSTANCE_XML');

6336: WHEN OTHERS THEN
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

Line 6377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

6373: EXCEPTION WHEN OTHERS THEN
6374:
6375: ROLLBACK;
6376:
6377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

Line 6378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

6374:
6375: ROLLBACK;
6376:
6377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

Line 6379: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);

6375: ROLLBACK;
6376:
6377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

Line 6380: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','TERMINATE_INSTR_DEFN_PROCESS');

6376:
6377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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',

Line 6489: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');

6485:
6486: EXCEPTION
6487: WHEN OTHERS THEN
6488: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6489: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6491: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6492: X_MSG_DATA := fnd_message.get;
6493: END is_task_attribute_used;

Line 6490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

6486: EXCEPTION
6487: WHEN OTHERS THEN
6488: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6489: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6491: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6492: X_MSG_DATA := fnd_message.get;
6493: END is_task_attribute_used;
6494:

Line 6491: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

6487: WHEN OTHERS THEN
6488: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6489: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6491: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6492: X_MSG_DATA := fnd_message.get;
6493: END is_task_attribute_used;
6494:
6495: --Bug 5383022: end

Line 6492: X_MSG_DATA := fnd_message.get;

6488: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6489: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6491: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6492: X_MSG_DATA := fnd_message.get;
6493: END is_task_attribute_used;
6494:
6495: --Bug 5383022: end
6496: