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 4159: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');

4155: WHEN L_INVALID_PARAM_ERR THEN
4156: ROLLBACK;
4157: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4158:
4159: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4160: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4161: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4162:
4163: L_MESG_TEXT := FND_MESSAGE.GET();

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

4156: ROLLBACK;
4157: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4158:
4159: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4160: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4161: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4162:
4163: L_MESG_TEXT := FND_MESSAGE.GET();
4164:

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

4157: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4158:
4159: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4160: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4161: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4162:
4163: L_MESG_TEXT := FND_MESSAGE.GET();
4164:
4165: FND_MSG_PUB.ADD_EXC_MSG

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

4159: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4160: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4161: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4162:
4163: L_MESG_TEXT := FND_MESSAGE.GET();
4164:
4165: FND_MSG_PUB.ADD_EXC_MSG
4166: ( G_PKG_NAME,
4167: L_API_NAME,

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

4183: WHEN L_ENTITY_KEY_ERR THEN
4184: ROLLBACK;
4185: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4186:
4187: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4188: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4189: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4190:
4191: L_MESG_TEXT := FND_MESSAGE.GET();

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

4184: ROLLBACK;
4185: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4186:
4187: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4188: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4189: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4190:
4191: L_MESG_TEXT := FND_MESSAGE.GET();
4192:

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

4185: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4186:
4187: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4188: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4189: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4190:
4191: L_MESG_TEXT := FND_MESSAGE.GET();
4192:
4193: FND_MSG_PUB.ADD_EXC_MSG

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

4187: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_API_PARAM_ERR');
4188: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4189: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4190:
4191: L_MESG_TEXT := FND_MESSAGE.GET();
4192:
4193: FND_MSG_PUB.ADD_EXC_MSG
4194: ( G_PKG_NAME,
4195: L_API_NAME,

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

4406:
4407: EXCEPTION
4408: WHEN NO_DATA_FOUND THEN
4409:
4410: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4412: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4413: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4414:

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

4407: EXCEPTION
4408: WHEN NO_DATA_FOUND THEN
4409:
4410: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4412: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4413: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4414:
4415: L_MESG_TEXT := FND_MESSAGE.GET();

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

4408: WHEN NO_DATA_FOUND THEN
4409:
4410: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4412: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4413: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4414:
4415: L_MESG_TEXT := FND_MESSAGE.GET();
4416:

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

4409:
4410: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4412: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4413: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4414:
4415: L_MESG_TEXT := FND_MESSAGE.GET();
4416:
4417: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

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

4411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4412: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4413: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4414:
4415: L_MESG_TEXT := FND_MESSAGE.GET();
4416:
4417: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4418: L_API_NAME,
4419: L_MESG_TEXT);

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

4479:
4480: EXCEPTION
4481: WHEN NO_DATA_FOUND THEN
4482:
4483: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4484: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4485: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4486: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4487:

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

4480: EXCEPTION
4481: WHEN NO_DATA_FOUND THEN
4482:
4483: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4484: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4485: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4486: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4487:
4488: L_MESG_TEXT := FND_MESSAGE.GET();

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

4481: WHEN NO_DATA_FOUND THEN
4482:
4483: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4484: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4485: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4486: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4487:
4488: L_MESG_TEXT := FND_MESSAGE.GET();
4489:

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

4482:
4483: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4484: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4485: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4486: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4487:
4488: L_MESG_TEXT := FND_MESSAGE.GET();
4489:
4490: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

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

4484: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4485: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4486: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4487:
4488: L_MESG_TEXT := FND_MESSAGE.GET();
4489:
4490: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4491: L_API_NAME,
4492: L_MESG_TEXT);

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

4583: EXCEPTION
4584: WHEN L_INVALID_PROCESS_ID THEN
4585: ROLLBACK;
4586:
4587: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4589: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4590: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4591:

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

4584: WHEN L_INVALID_PROCESS_ID THEN
4585: ROLLBACK;
4586:
4587: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4589: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4590: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4591:
4592: L_MESG_TEXT := FND_MESSAGE.GET();

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

4585: ROLLBACK;
4586:
4587: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4589: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4590: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4591:
4592: L_MESG_TEXT := FND_MESSAGE.GET();
4593:

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

4586:
4587: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_INV_PROCESSID_ERR');
4588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
4589: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
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

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

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

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

5017:
5018: ROLLBACK;
5019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5020:
5021: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5022: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5023: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5024:
5025: L_MESG_TEXT := FND_MESSAGE.GET();

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

5018: ROLLBACK;
5019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5020:
5021: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5022: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5023: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5024:
5025: L_MESG_TEXT := FND_MESSAGE.GET();
5026:

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

5019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5020:
5021: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5022: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5023: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5024:
5025: L_MESG_TEXT := FND_MESSAGE.GET();
5026:
5027: FND_MSG_PUB.ADD_EXC_MSG

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

5021: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5022: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5023: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5024:
5025: L_MESG_TEXT := FND_MESSAGE.GET();
5026:
5027: FND_MSG_PUB.ADD_EXC_MSG
5028: ( G_PKG_NAME,
5029: L_API_NAME,

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

5264: X_ENTITY_NAME := NULL;
5265: X_ENTITY_KEY := NULL;
5266: X_INSTRUCTION_TYPE := NULL;
5267:
5268: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5270: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5271:
5272: L_MESG_TEXT := FND_MESSAGE.GET();

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

5265: X_ENTITY_KEY := NULL;
5266: X_INSTRUCTION_TYPE := NULL;
5267:
5268: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5270: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5271:
5272: L_MESG_TEXT := FND_MESSAGE.GET();
5273:

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

5266: X_INSTRUCTION_TYPE := NULL;
5267:
5268: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5270: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5271:
5272: L_MESG_TEXT := FND_MESSAGE.GET();
5273:
5274: FND_MSG_PUB.ADD_EXC_MSG

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

5268: FND_MESSAGE.SET_NAME('GMO', 'GMO_INSTR_SET_INACTIVE');
5269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
5270: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5271:
5272: L_MESG_TEXT := FND_MESSAGE.GET();
5273:
5274: FND_MSG_PUB.ADD_EXC_MSG
5275: ( G_PKG_NAME,
5276: L_API_NAME,

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

5384: EXCEPTION
5385: WHEN OTHERS THEN
5386: ROLLBACK;
5387:
5388: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

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

5385: WHEN OTHERS THEN
5386: ROLLBACK;
5387:
5388: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

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

5386: ROLLBACK;
5387:
5388: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

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

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

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

5447: EXCEPTION
5448: WHEN OTHERS THEN
5449: ROLLBACK;
5450:
5451: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

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

5448: WHEN OTHERS THEN
5449: ROLLBACK;
5450:
5451: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

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

5449: ROLLBACK;
5450:
5451: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

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

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

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

5501: WHEN OTHERS THEN
5502:
5503: ROLLBACK;
5504: --Diagnostics Start
5505: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

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

5502:
5503: ROLLBACK;
5504: --Diagnostics Start
5505: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

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

5503: ROLLBACK;
5504: --Diagnostics Start
5505: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

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

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

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

5779: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5780: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.YES;
5781:
5782: --Diagnostics Start
5783: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5784: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

5780: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.YES;
5781:
5782: --Diagnostics Start
5783: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5784: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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:

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

5781:
5782: --Diagnostics Start
5783: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
5784: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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

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

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

Line 5787: L_MESG_TEXT := FND_MESSAGE.GET;

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

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

5854: DECODE((SELECT COUNT(*) FROM GMO_INSTR_APPR_DEFN_T APPR
5855: WHERE
5856: APPR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
5857: AND APPR.INSTRUCTION_ID = INSTR.INSTRUCTION_ID),0,
5858: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_NOT_REQUIRED'),
5859: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_REQUIRED'))
5860: FROM DUAL)
5861: AS SIGNATURE_REQUIRED
5862: )

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

5855: WHERE
5856: APPR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
5857: AND APPR.INSTRUCTION_ID = INSTR.INSTRUCTION_ID),0,
5858: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_NOT_REQUIRED'),
5859: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_REQUIRED'))
5860: FROM DUAL)
5861: AS SIGNATURE_REQUIRED
5862: )
5863: )

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

6199: WHEN INVALID_TASK_ERR THEN
6200: ROLLBACK;
6201:
6202: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6203: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');
6204: FND_MSG_PUB.ADD;
6205: FND_MSG_PUB.COUNT_AND_GET
6206: (
6207: P_COUNT => X_MSG_COUNT,

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

6214: END IF;
6215: WHEN OTHERS THEN
6216: rollback;
6217: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6218: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
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);

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

6215: WHEN OTHERS THEN
6216: rollback;
6217: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6218: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
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

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

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

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

6310: X_OUTPUT_XML := L_INSTR_XML.GETCLOBVAL();
6311:
6312: EXCEPTION
6313: WHEN OTHERS THEN
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

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

6311:
6312: EXCEPTION
6313: WHEN OTHERS THEN
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,

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

6312: EXCEPTION
6313: WHEN OTHERS THEN
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',

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

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

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

6350: EXCEPTION WHEN OTHERS THEN
6351:
6352: ROLLBACK;
6353:
6354: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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:

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

6351:
6352: ROLLBACK;
6353:
6354: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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

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

6352: ROLLBACK;
6353:
6354: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
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,

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

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

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

6462:
6463: EXCEPTION
6464: WHEN OTHERS THEN
6465: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6466: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6467: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6468: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6469: X_MSG_DATA := fnd_message.get;
6470: END is_task_attribute_used;

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

6463: EXCEPTION
6464: WHEN OTHERS THEN
6465: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6466: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6467: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6468: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6469: X_MSG_DATA := fnd_message.get;
6470: END is_task_attribute_used;
6471:

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

6464: WHEN OTHERS THEN
6465: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6466: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6467: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6468: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6469: X_MSG_DATA := fnd_message.get;
6470: END is_task_attribute_used;
6471:
6472: --Bug 5383022: end

Line 6469: X_MSG_DATA := fnd_message.get;

6465: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
6466: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
6467: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6468: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
6469: X_MSG_DATA := fnd_message.get;
6470: END is_task_attribute_used;
6471:
6472: --Bug 5383022: end
6473: