eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_INSTRUCTION_PVT dependencies on FND_API

Line 667: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

663: -- COMMIT CHANGES
664: COMMIT;
665:
666: X_INSTRUCTION_PROCESS_ID := L_INSTRUCTION_PROCESS_ID;
667: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
668:
669: EXCEPTION
670: WHEN L_MODE_PARAM_ERR THEN
671:

Line 697: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

693: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_CONTEXT',
694: FALSE);
695: END IF;
696:
697: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
698:
699: WHEN OTHERS THEN
700:
701: ROLLBACK;

Line 719: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

715: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
716: FALSE);
717: END IF;
718:
719: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
720:
721: END CREATE_DEFN_CONTEXT;
722:
723: -- This API is called to create a definition context with multiple

Line 957: P_UPDATE_DEFN_STATUS => FND_API.G_TRUE);

953: );
954:
955: -- update the definition status as modified and process status sucess
956: SET_INSTR_STATUS_ATTRIBUTES(P_INSTRUCTION_PROCESS_ID => X_INSTRUCTION_PROCESS_ID,
957: P_UPDATE_DEFN_STATUS => FND_API.G_TRUE);
958:
959: --Delete the contents of Temp Table for the specified process ID.
960: DELETE FROM GMO_INSTR_APPR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = X_INSTRUCTION_PROCESS_ID;
961: DELETE FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = X_INSTRUCTION_PROCESS_ID;

Line 970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

966:
967: EXCEPTION
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);

Line 1098: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1094: END;
1095:
1096: IF (L_TARGET_INSTRUCTION_SET_ID > 0) THEN
1097: X_INSTRUCTION_SET_ID := L_TARGET_INSTRUCTION_SET_ID;
1098: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1099: RETURN;
1100: END IF;
1101:
1102: OPEN L_INSTR_SET_DEFN_CSR;

Line 1308: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1304:
1305: END IF;
1306:
1307:
1308: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1309:
1310: EXCEPTION
1311: WHEN L_SOURCE_ENTITY_ERR THEN
1312: X_INSTRUCTION_SET_ID := -1;

Line 1337: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1333: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_FROM_DEFN',
1334: FALSE);
1335: END IF;
1336:
1337: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1338:
1339: WHEN L_TARGET_ENTITY_ERR THEN
1340: X_INSTRUCTION_SET_ID := -1;
1341:

Line 1365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1361: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_DEFN_FROM_DEFN',
1362: FALSE);
1363: END IF;
1364:
1365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1366:
1367: WHEN OTHERS THEN
1368: X_INSTRUCTION_SET_ID := -1;
1369:

Line 1386: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1382: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_FROM_DEFN',
1383: FALSE);
1384: END IF;
1385:
1386: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1387:
1388: END CREATE_DEFN_FROM_DEFN;
1389:
1390: -- This API is called to send the acknowledegement of definition

Line 1529: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1525:
1526: -- Perform all the processing only if the definition status is
1527: -- modified.
1528: IF( L_DEFINITION_STATUS <> GMO_CONSTANTS_GRP.G_STATUS_MODIFIED) THEN
1529: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1530: RETURN;
1531: END IF;
1532:
1533: -- If P_SOURCE_ENTITY_NAME and P_SOURCE_ENTITY_KEY is null,

Line 2132: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2128:
2129: END LOOP; --Instruction Types
2130: END LOOP; --Entity Name Loop
2131:
2132: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2133:
2134: EXCEPTION
2135: WHEN L_ENTITY_INFO_NOTFOUND_ERR THEN
2136:

Line 2148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2144: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_DEFN_ACKN',FALSE);
2146: END IF;
2147:
2148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2149:
2150: WHEN OTHERS THEN
2151: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

Line 2160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2156: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_DEFN_ACKN',FALSE);
2158: END IF;
2159:
2160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2161: END SEND_DEFN_ACKN;
2162:
2163: -- This API is called to send the acknowledegement of definition
2164: -- process, and copies all the data from temporary tables

Line 2375: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2371: FALSE);
2372: END IF;
2373:
2374: X_INSTRUCTION_SET_ID := -1;
2375: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2376:
2377: RETURN;
2378:
2379: END IF;

Line 2406: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2402: -- Entity Name And Entity_key, Return The Set Id Of The Active
2403: -- Instance Instruction Set Found Above
2404: IF (L_INSTRUCTION_SET_ID > 0) THEN
2405:
2406: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2407: X_INSTRUCTION_SET_ID := L_INSTRUCTION_SET_ID;
2408:
2409: RETURN;
2410: END IF;

Line 2652: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2648: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_FROM_DEFIN',
2649: FALSE);
2650: END IF;
2651:
2652: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2653: END IF;
2654:
2655: CLOSE L_INSTR_SET_DEFN_CSR;
2656: --Bug 4730261: start

Line 2659: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2655: CLOSE L_INSTR_SET_DEFN_CSR;
2656: --Bug 4730261: start
2657: RAISE_INSTR_SET_EVENT(P_INSTRUCTION_SET_ID => X_INSTRUCTION_SET_ID);
2658: --Bug 4730261: end
2659: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2660:
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: X_INSTRUCTION_SET_ID := -1;

Line 2664: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2660:
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: X_INSTRUCTION_SET_ID := -1;
2664: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2665:
2666: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2667: FND_MSG_PUB.ADD_EXC_MSG
2668: (G_PKG_NAME,

Line 2795: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2791: IF(L_INSTR_SET_STATUS = GMO_CONSTANTS_GRP.G_PROCESS_ACTIVE) THEN
2792: -- return an error conveying source instruction
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);

Line 2827: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2823:
2824: EXCEPTION
2825: WHEN NO_DATA_FOUND THEN
2826: L_INSTRUCTION_SET_ID := -1;
2827: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2828: RETURN;
2829: END;
2830: END IF;
2831:

Line 2850: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2846:
2847: -- if the instruction instance already exist for the given
2848: -- target entity name and entity_key, return this instruction_set_id
2849: IF (L_INSTRUCTION_SET_ID > 0) THEN
2850: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2851: X_INSTRUCTION_SET_ID := L_INSTRUCTION_SET_ID;
2852: RETURN;
2853: END IF;
2854: END IF;

Line 2861: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2857: OPEN L_INSTR_SET_CSR;
2858: FETCH L_INSTR_SET_CSR INTO L_INSTR_SET_REC;
2859:
2860: IF (L_INSTR_SET_CSR%ROWCOUNT <= 0) THEN
2861: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2862: X_INSTRUCTION_SET_ID := -1;
2863: RETURN;
2864: END IF;
2865:

Line 3052: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3048: X_INSTRUCTION_SET_ID := NVL(L_NEW_INSTRUCTION_SET_ID,-1);
3049: --Bug 4730261: start
3050: RAISE_INSTR_SET_EVENT(P_INSTRUCTION_SET_ID => X_INSTRUCTION_SET_ID);
3051: --Bug 4730261: end
3052: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3053:
3054: EXCEPTION
3055: WHEN NO_DATA_FOUND THEN
3056: X_INSTRUCTION_SET_ID := -1;

Line 3057: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3053:
3054: EXCEPTION
3055: WHEN NO_DATA_FOUND THEN
3056: X_INSTRUCTION_SET_ID := -1;
3057: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3058:
3059: WHEN OTHERS THEN
3060: X_INSTRUCTION_SET_ID := -1;
3061: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 3061: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3057: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3058:
3059: WHEN OTHERS THEN
3060: X_INSTRUCTION_SET_ID := -1;
3061: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3062:
3063: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3064: FND_MSG_PUB.ADD_EXC_MSG
3065: (G_PKG_NAME,

Line 3148: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3144: X_MODE := GMO_CONSTANTS_GRP.G_INSTR_INSTANCE_MODE_READ;
3145: END IF;
3146: END IF;
3147:
3148: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3149:
3150: EXCEPTION
3151: WHEN L_ENTITY_ERR THEN
3152: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 3152: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3148: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3149:
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 );

Line 3180: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3176: END IF;
3177:
3178: WHEN OTHERS THEN
3179:
3180: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3181:
3182: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3183: FND_MSG_PUB.ADD_EXC_MSG
3184: (G_PKG_NAME,

Line 3278: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3274: END LOOP;
3275: CLOSE L_INSTR_CSR;
3276:
3277: X_INSTRUCTION_TABLE := L_INSTRUCTION_TBL;
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');

Line 3306: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3302: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_INSTRUCTIONS',
3303: FALSE);
3304: END IF;
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);

Line 3333: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3329: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_INSTRUCTIONS',
3330: FALSE);
3331: END IF;
3332:
3333: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3334:
3335: WHEN OTHERS THEN
3336:
3337: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3353: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3349: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3350: FALSE);
3351: END IF;
3352:
3353: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3354:
3355: END GET_DEFN_INSTRUCTIONS;
3356:
3357: -- This API is checks if there are any pending instructions for

Line 3438: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3434: ELSE
3435: X_INSTRUCTION_PENDING := GMO_CONSTANTS_GRP.NO;
3436: END IF;
3437:
3438: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3439:
3440: EXCEPTION
3441: WHEN NO_DATA_FOUND THEN
3442: -- If Process Id is invalid, NO_DATA_FOUND

Line 3448: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3444: -- return all values as 0, and status = S
3445: X_TOTAL_INSTRUCTIONS := 0;
3446: X_OPTIONAL_PENDING_INSTR := 0;
3447: X_MANDATORY_PENDING_INSTR := 0;
3448: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3449:
3450: WHEN L_ENTITY_ERR THEN
3451: X_TOTAL_INSTRUCTIONS := 0;
3452: X_OPTIONAL_PENDING_INSTR := 0;

Line 3479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3475: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.HAS_PENDING_INSTRUCTIONS',
3476: FALSE);
3477: END IF;
3478:
3479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3480:
3481: WHEN OTHERS THEN
3482: X_TOTAL_INSTRUCTIONS := 0;
3483: X_OPTIONAL_PENDING_INSTR := 0;

Line 3503: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3499: 'gmo.plsql.GMO_INSTRUCTION_PVT.HAS_PENDING_INSTRUCTIONS',
3500: FALSE);
3501: END IF;
3502:
3503: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3504:
3505: END HAS_PENDING_INSTRUCTIONS;
3506:
3507: -- This API is checks if there are any pending instructions for

Line 3574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3570: ELSE
3571: X_INSTRUCTION_PENDING := GMO_CONSTANTS_GRP.NO;
3572: END IF;
3573:
3574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3575:
3576: EXCEPTION
3577: WHEN NO_DATA_FOUND THEN
3578: -- If Process Id is invalid, NO_DATA_FOUND

Line 3584: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3580: -- return all values as 0, and status = S
3581: X_TOTAL_INSTRUCTIONS := 0;
3582: X_OPTIONAL_PENDING_INSTR := 0;
3583: X_MANDATORY_PENDING_INSTR := 0;
3584: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3585:
3586: WHEN L_ENTITY_ERR THEN
3587: X_TOTAL_INSTRUCTIONS := 0;
3588: X_OPTIONAL_PENDING_INSTR := 0;

Line 3614: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3610: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3611: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.HAS_PENDING_INSTR_FOR_PROCESS',
3612: FALSE);
3613: END IF;
3614: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3615:
3616: WHEN OTHERS THEN
3617: X_TOTAL_INSTRUCTIONS := 0;
3618: X_OPTIONAL_PENDING_INSTR := 0;

Line 3636: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3632: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3633: 'gmo.plsql.GMO_INSTRUCTION_PVT.HAS_PENDING_INSTR_FOR_PROCESS',
3634: FALSE);
3635: END IF;
3636: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3637:
3638: END HAS_PENDING_INSTR_FOR_PROCESS;
3639:
3640: -- This API is called to send the instance acknowledgment

Line 3946: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3942:
3943: --COMMIT CHANGES
3944: COMMIT;
3945:
3946: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3947:
3948: EXCEPTION
3949: WHEN OTHERS THEN
3950: ROLLBACK;

Line 3968: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3964: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_DEFN_CONTEXT',
3965: FALSE);
3966: END IF;
3967:
3968: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3969:
3970: END SEND_INSTANCE_ACKN;
3971:
3972: -- This API is called to send the task acknowledgment

Line 4148: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4144:
4145: -- COMMIT TASK DATA
4146: COMMIT;
4147:
4148: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4149:
4150: EXCEPTION
4151: WHEN NO_DATA_FOUND THEN
4152: ROLLBACK;

Line 4153: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4149:
4150: EXCEPTION
4151: WHEN NO_DATA_FOUND THEN
4152: ROLLBACK;
4153: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4154:
4155: WHEN L_INVALID_PARAM_ERR THEN
4156: ROLLBACK;
4157: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 4157: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

4153: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4154:
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 );

Line 4185: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

4181: END IF;
4182:
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 );

Line 4213: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4209: END IF;
4210:
4211: WHEN OTHERS THEN
4212: ROLLBACK;
4213: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4214:
4215: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4216: FND_MSG_PUB.ADD_EXC_MSG
4217: (G_PKG_NAME,

Line 4271: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4267: --Bug 4730261: start
4268: RAISE_INSTR_SET_EVENT(P_INSTRUCTION_SET_ID => L_INSTRUCTION_SET_ID);
4269: --Bug 4730261: end
4270:
4271: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4272:
4273: EXCEPTION
4274: WHEN NO_DATA_FOUND THEN
4275: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 4275: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4271: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4272:
4273: EXCEPTION
4274: WHEN NO_DATA_FOUND THEN
4275: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4276:
4277: WHEN OTHERS THEN
4278: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4279:

Line 4278: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4274: WHEN NO_DATA_FOUND THEN
4275: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4276:
4277: WHEN OTHERS THEN
4278: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4279:
4280: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4281: FND_MSG_PUB.ADD_EXC_MSG
4282: (G_PKG_NAME,

Line 4352: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4348: AND INSTR_ACKN_TYPE = GMO_CONSTANTS_GRP.G_INSTR_OPTIONAL
4349: )
4350: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4351:
4352: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4353:
4354: --Commit the changes
4355: COMMIT;
4356:

Line 4361: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4357: EXCEPTION
4358: WHEN OTHERS THEN
4359: ROLLBACK;
4360:
4361: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4362:
4363: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.ADD_EXC_MSG
4365: (G_PKG_NAME,

Line 4405: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4401: WHERE ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_DEFINITION_STATUS
4402: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4403: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL;
4404:
4405: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4406:
4407: EXCEPTION
4408: WHEN NO_DATA_FOUND THEN
4409:

Line 4430: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

4426: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_DEFN_STATUS',
4427: FALSE);
4428: END IF;
4429:
4430: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4431:
4432: WHEN OTHERS THEN
4433: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4434:

Line 4433: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4429:
4430: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4431:
4432: WHEN OTHERS THEN
4433: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4434:
4435: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4436: FND_MSG_PUB.ADD_EXC_MSG
4437: (G_PKG_NAME,

Line 4478: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4474: WHERE ATTRIBUTE_NAME = 'INSTANCE_STATUS'
4475: AND ATTRIBUTE_TYPE = 'INTERNAL'
4476: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4477:
4478: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4479:
4480: EXCEPTION
4481: WHEN NO_DATA_FOUND THEN
4482:

Line 4503: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

4499: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.GET_INSTANCE_STATUS',
4500: FALSE);
4501: END IF;
4502:
4503: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4504:
4505: WHEN OTHERS THEN
4506: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4507:

Line 4506: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4502:
4503: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4504:
4505: WHEN OTHERS THEN
4506: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4507:
4508: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4509: FND_MSG_PUB.ADD_EXC_MSG
4510: (G_PKG_NAME,

Line 4581: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4577:
4578: -- SAVE CHANGES
4579: COMMIT;
4580:
4581: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4582:
4583: EXCEPTION
4584: WHEN L_INVALID_PROCESS_ID THEN
4585: ROLLBACK;

Line 4600: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

4596: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CAPTURE_OPERATOR_RESPONSE',
4597: FALSE);
4598: END IF;
4599:
4600: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
4601:
4602: WHEN OTHERS THEN
4603: ROLLBACK;
4604:

Line 4611: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4607: 'gmo.plsql.GMO_INSTRUCTION_PVT.CAPTURE_OPERATOR_RESPONSE',
4608: FALSE);
4609: END IF;
4610:
4611: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4612:
4613: END CAPTURE_OPERATOR_RESPONSE;
4614:
4615:

Line 4686: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4682:
4683: -- SAVE CHANGES
4684: COMMIT;
4685:
4686: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4687:
4688: EXCEPTION
4689: WHEN OTHERS THEN
4690: ROLLBACK;

Line 4691: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4687:
4688: EXCEPTION
4689: WHEN OTHERS THEN
4690: ROLLBACK;
4691: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4692:
4693:
4694: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4695: FND_MSG_PUB.ADD_EXC_MSG

Line 4934: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4930:
4931: END LOOP;
4932: CLOSE L_INSTR_SET_CSR;
4933:
4934: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4935:
4936: EXCEPTION
4937: WHEN OTHERS THEN
4938: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4938: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

4934: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4935:
4936: EXCEPTION
4937: WHEN OTHERS THEN
4938: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4939:
4940: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4941: FND_MSG_PUB.ADD_EXC_MSG
4942: (G_PKG_NAME,

Line 5019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

5015: -- FOR THE PROCESS TO PROCEED FURTHER
5016: IF( RTRIM(L_INSTR_SET_STATUS) <> GMO_CONSTANTS_GRP.G_PROCESS_ACTIVE ) THEN
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 );

Line 5052: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

5048:
5049: EXCEPTION
5050: WHEN NO_DATA_FOUND THEN
5051: ROLLBACK;
5052: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5053:
5054: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5055: FND_MSG_PUB.ADD_EXC_MSG
5056: (G_PKG_NAME,

Line 5196: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

5192:
5193: X_INSTRUCTION_SET_ID := L_INSTRUCTION_SET_ID;
5194: X_INSTRUCTION_PROCESS_ID := L_INSTRUCTION_PROCESS_ID;
5195:
5196: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5197: X_MSG_COUNT := 0;
5198: X_MSG_DATA := FND_API.G_RET_STS_SUCCESS;
5199:
5200: EXCEPTION

Line 5198: X_MSG_DATA := FND_API.G_RET_STS_SUCCESS;

5194: X_INSTRUCTION_PROCESS_ID := L_INSTRUCTION_PROCESS_ID;
5195:
5196: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5197: X_MSG_COUNT := 0;
5198: X_MSG_DATA := FND_API.G_RET_STS_SUCCESS;
5199:
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: ROLLBACK;

Line 5203: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

5199:
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: ROLLBACK;
5203: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
5204:
5205: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5206: FND_MSG_PUB.ADD_EXC_MSG
5207: (G_PKG_NAME,

Line 5292: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

5288: 'gmo.plsql.GMO_INSTRUCTIONS_PVT.CREATE_INSTANCE_CONTEXT',
5289: FALSE);
5290: END IF;
5291:
5292: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5293:
5294: RETURN;
5295: END;
5296:

Line 5336: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

5332: 'gmo.plsql.GMO_INSTRUCTION_PVT.CREATE_INSTANCE_CONTEXT',
5333: FALSE);
5334: END IF;
5335:
5336: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
5337:
5338: END CREATE_INSTANCE_CONTEXT;
5339:
5340:

Line 5361: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN

5357: --Convert the instruction process ID to number.
5358: L_INSTRUCTION_PROCESS_ID := TO_NUMBER(P_INSTRUCTION_PROCESS_ID,'999999999999.999999');
5359:
5360: --Update the definition status if required based on the flag.
5361: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN
5362: UPDATE
5363: GMO_INSTR_ATTRIBUTES_T
5364: SET
5365: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_STATUS_MODIFIED

Line 5424: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN

5420: --Convert the instruction process ID to number.
5421: L_INSTRUCTION_PROCESS_ID := TO_NUMBER(P_INSTRUCTION_PROCESS_ID,'999999999999.999999');
5422:
5423: --Update the definition status if required based on the flag.
5424: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN
5425: UPDATE
5426: GMO_INSTR_ATTRIBUTES_T
5427: SET
5428: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_STATUS_MODIFIED

Line 5755: P_init_msg_list => FND_API.G_FALSE ,

5751:
5752: EDR_ERES_EVENT_PUB.VALIDATE_ERECORD
5753: (
5754: p_api_version => '1.0',
5755: P_init_msg_list => FND_API.G_FALSE ,
5756: x_return_status => L_RETURN_STATUS ,
5757: X_msg_count => L_MSG_COUNT ,
5758: x_msg_data => L_MSG_DATA,
5759: p_erecord_id => TO_NUMBER(L_ERECORD_ID,999999999999.999999)

Line 5762: IF(L_RETURN_STATUS = FND_API.G_RET_STS_ERROR) THEN

5758: x_msg_data => L_MSG_DATA,
5759: p_erecord_id => TO_NUMBER(L_ERECORD_ID,999999999999.999999)
5760: );
5761:
5762: IF(L_RETURN_STATUS = FND_API.G_RET_STS_ERROR) THEN
5763: L_INVALID_ERECORD_LIST := L_INVALID_ERECORD_LIST || ',' || L_ERECORD_ID;
5764: END IF;
5765:
5766: END LOOP;

Line 5770: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

5766: END LOOP;
5767:
5768: IF ( LENGTH(L_INVALID_ERECORD_LIST) > 0) THEN
5769: X_ERECORD_LIST_STR := SUBSTR(L_INVALID_ERECORD_LIST,2,LENGTH(L_INVALID_ERECORD_LIST));
5770: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5771: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.YES;
5772: ELSE
5773: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.NO;
5774: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 5774: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

5770: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5771: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.YES;
5772: ELSE
5773: X_ERECORD_ID_INVALID := GMO_CONSTANTS_GRP.NO;
5774: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5775: END IF;
5776:
5777: EXCEPTION
5778: WHEN OTHERS THEN

Line 5779: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

5775: END IF;
5776:
5777: EXCEPTION
5778: WHEN OTHERS THEN
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');

Line 6196: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6192: end if;
6193:
6194: commit;
6195:
6196: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6197:
6198: EXCEPTION
6199: WHEN INVALID_TASK_ERR THEN
6200: ROLLBACK;

Line 6202: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

6198: EXCEPTION
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: (

Line 6217: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

6213: FALSE);
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;