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_VBATCH_PVT dependencies on FND_API

Line 31: if L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

27: x_return_status => l_return_status,
28: x_msg_count => l_msg_count,
29: x_msg_data => l_msg_data
30: );
31: if L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
32: RAISE NO_BATCH_FOUND_ERR;
33: end if;
34:
35: open is_enhanced_pi;

Line 126: if L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

122: X_RETURN_STATUS => l_return_status,
123: X_RESERVATIONS_TBL => l_reservation_tbl
124: );
125:
126: if L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
127: RAISE MATERIAL_RESERVATION_ERR;
128: end if;
129:
130: --Bug 4609365: start

Line 321: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

317: X_RETURN_STATUS => l_return_status,
318: X_EXCEPTION_TBL => l_exception_tbl
319: );
320:
321: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
322: RAISE BATCH_SHORTAGE_ERR;
323: end if;
324:
325: X_UNAVAL_MATERIAL_ID := new FND_TABLE_OF_VARCHAR2_255();

Line 358: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

354: end if;
355:
356: X_MATERIAL_AVAILABLE := l_material_available;
357:
358: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
359: EXCEPTION
360: WHEN BATCH_SHORTAGE_ERR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362:

Line 361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

357:
358: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
359: EXCEPTION
360: WHEN BATCH_SHORTAGE_ERR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362:
363: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
364: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
365: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);

Line 376: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

372: end if;
373:
374: WHEN OTHERS THEN
375:
376: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
377: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
379: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
380: FND_MSG_PUB.ADD;

Line 449: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

445: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
446: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
447: end if;
448:
449: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
450:
451: EXCEPTION
452: WHEN STEP_ALREADY_LOCKED_ERR THEN
453: rollback;

Line 454: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

450:
451: EXCEPTION
452: WHEN STEP_ALREADY_LOCKED_ERR THEN
453: rollback;
454: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
455: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
456: FND_MSG_PUB.ADD;
457: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
458: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

459: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
460: end if;
461: WHEN NO_BATCH_FOUND_ERR THEN
462: rollback;
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
465: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
466: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
467: FND_MSG_PUB.ADD;

Line 474: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
471: end if;
472: WHEN OTHERS THEN
473: rollback;
474: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
476: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
478: FND_MSG_PUB.ADD;

Line 536: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

532: end loop;
533:
534: commit;
535:
536: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION
539: WHEN STEP_ALREADY_LOCKED_ERR THEN
540: rollback;

Line 541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

537:
538: EXCEPTION
539: WHEN STEP_ALREADY_LOCKED_ERR THEN
540: rollback;
541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
542: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
543: FND_MSG_PUB.ADD;
544: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
545: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

546: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
547: end if;
548: WHEN NO_BATCH_FOUND_ERR THEN
549: rollback;
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
552: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
553: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
554: FND_MSG_PUB.ADD;

Line 561: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

557: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
558: end if;
559: WHEN OTHERS THEN
560: rollback;
561: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
562: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
563: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
564: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
565: FND_MSG_PUB.ADD;

Line 619: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
616: end if;
617:
618:
619: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
620:
621: EXCEPTION
622: WHEN STEP_NOT_LOCKED_ERR THEN
623: rollback;

Line 624: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

620:
621: EXCEPTION
622: WHEN STEP_NOT_LOCKED_ERR THEN
623: rollback;
624: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
625: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
626: FND_MSG_PUB.ADD;
627: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
628: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 633: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

629: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
630: end if;
631: WHEN OTHERS THEN
632: rollback;
633: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
635: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
636: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
637: FND_MSG_PUB.ADD;

Line 699: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

695: end loop;
696:
697: commit;
698:
699: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
700:
701: EXCEPTION
702: WHEN STEP_NOT_LOCKED_ERR THEN
703: rollback;

Line 704: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

700:
701: EXCEPTION
702: WHEN STEP_NOT_LOCKED_ERR THEN
703: rollback;
704: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
705: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
708: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
710: end if;
711: WHEN OTHERS THEN
712: rollback;
713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
715: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
717: FND_MSG_PUB.ADD;

Line 780: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

776: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
778: end if;
779:
780: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
781: X_BATCH_ID := l_batch_id;
782:
783: EXCEPTION
784: WHEN NO_BATCH_FOUND_ERR THEN

Line 785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

781: X_BATCH_ID := l_batch_id;
782:
783: EXCEPTION
784: WHEN NO_BATCH_FOUND_ERR THEN
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
787: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
788: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
789: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');

Line 796: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

792: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
793: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
794: end if;
795: WHEN GMO_INVALID_ENTITY_ERR THEN
796: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
797: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
798: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
799: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
800: FND_MSG_PUB.ADD;

Line 806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

802: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
803: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
804: end if;
805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
808: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
809: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
810: FND_MSG_PUB.ADD;

Line 868: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
865: end if;
866:
867:
868: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
869: X_BATCHSTEP_ID := l_batchstep_id;
870:
871: EXCEPTION
872: WHEN NO_BATCHSTEP_FOUND_ERR THEN

Line 873: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

869: X_BATCHSTEP_ID := l_batchstep_id;
870:
871: EXCEPTION
872: WHEN NO_BATCHSTEP_FOUND_ERR THEN
873: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
875: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
876: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
877: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');

Line 884: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

880: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
881: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
882: end if;
883: WHEN GMO_INVALID_ENTITY_ERR THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
885: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
886: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
887: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
888: FND_MSG_PUB.ADD;

Line 894: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

890: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
891: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
892: end if;
893: WHEN OTHERS THEN
894: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
895: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
897: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
898: FND_MSG_PUB.ADD;

Line 1281: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1277: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1278: X_INSTRUCTION_SET_ID => l_instruction_set_id
1279: );
1280:
1281: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1282: RAISE instruction_create_err;
1283: end if;
1284: update_task_attribute
1285: (

Line 1333: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1329: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1330: X_INSTRUCTION_SET_ID => l_instruction_set_id
1331: );
1332:
1333: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1334: RAISE instruction_create_err;
1335: end if;
1336:
1337: update_task_attribute

Line 1386: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1382: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1383: X_INSTRUCTION_SET_ID => l_instruction_set_id
1384: );
1385:
1386: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1387: RAISE instruction_create_err;
1388: end if;
1389:
1390: update_task_attribute

Line 1439: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1435: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
1436: X_INSTRUCTION_SET_ID => l_instruction_set_id
1437: );
1438:
1439: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1440: RAISE instruction_create_err;
1441: end if;
1442:
1443: update_task_attribute

Line 1480: x_return_status := FND_API.G_RET_STS_SUCCESS;

1476: end if;
1477:
1478: end if;
1479:
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: EXCEPTION
1483: WHEN instruction_create_err then
1484: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1484: x_return_status := FND_API.G_RET_STS_ERROR;

1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: EXCEPTION
1483: WHEN instruction_create_err then
1484: x_return_status := FND_API.G_RET_STS_ERROR;
1485: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1486: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1487: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1488: end if;

Line 1490: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1486: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1487: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1488: end if;
1489: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1490: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1491: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1492: FND_MSG_PUB.ADD;
1493: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1494: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1498: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1494: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1495: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1496: end if;
1497: WHEN GMO_INVALID_RECIPE_ERR THEN
1498: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1499: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_RECIPE');
1500: FND_MSG_PUB.ADD;
1501: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1502: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1506: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1502: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1503: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1504: end if;
1505: WHEN GMO_DISABLED_ERR THEN
1506: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1507: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1508: FND_MSG_PUB.ADD;
1509: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1510: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1514: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1510: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1511: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1512: end if;
1513: WHEN GMO_INVALID_ENTITY_ERR THEN
1514: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1515: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
1516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1517: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1518: FND_MSG_PUB.ADD;

Line 1524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1520: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1521: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1522: end if;
1523: WHEN INVALID_ATTRIBUTE_ASSOC_ERR THEN
1524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1526: FND_MSG_PUB.ADD;
1527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1532: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1530: end if;
1531: WHEN OTHERS THEN
1532: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1534: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1535: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1536: FND_MSG_PUB.ADD;

Line 1660: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1656: X_ATTRIBUTE_VALUE => l_vbatch_mode
1657: );
1658:
1659:
1660: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1661: RAISE gmo_instr_task_param_err;
1662: end if;
1663:
1664: end if;

Line 1956: if L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1952: x_return_status => l_return_status,
1953: x_msg_count => l_msg_count,
1954: x_msg_data => l_msg_data
1955: );
1956: if L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1957: RAISE NO_BATCH_FOUND_ERR;
1958: end if;
1959: end if;
1960:

Line 2013: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2009: l_context_params_rec_type.VALUE := l_line_no;
2010: X_CONTEXT_PARAMS_TBL(11) := l_context_params_rec_type;
2011: --Bug 4893056: end
2012:
2013: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2014:
2015: EXCEPTION
2016: WHEN GMO_DISABLED_ERR THEN
2017: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2017: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2013: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2014:
2015: EXCEPTION
2016: WHEN GMO_DISABLED_ERR THEN
2017: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2018: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2019: FND_MSG_PUB.ADD;
2020: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2021: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2025: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2021: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2023: end if;
2024: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2025: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2026: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
2027: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2028: FND_MSG_PUB.ADD;
2029: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 2035: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2031: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2032: end if;
2033:
2034: WHEN GMO_INVALID_MODULE_ERR THEN
2035: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2036: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_MODULE');
2037: FND_MSG_PUB.ADD;
2038: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2039: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2044: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2040: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2041: end if;
2042:
2043: WHEN GMO_INSTR_TASK_PARAM_ERR THEN
2044: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2045: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_PARAM_ERR');
2046: FND_MSG_PUB.ADD;
2047: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2048: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2049: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2050: end if;
2051:
2052: WHEN GMO_INVALID_TASK_ERR THEN
2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2054: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2055: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2056: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2057: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

Line 2064: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2060: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2061: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2062: end if;
2063: WHEN GMO_INVALID_ENTITY_ERR THEN
2064: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2065: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2066: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2067: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2068: FND_MSG_PUB.ADD;

Line 2074: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2070: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2071: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2072: end if;
2073: WHEN OTHERS THEN
2074: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2076: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2077: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2078: FND_MSG_PUB.ADD;

Line 2171: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2167: P_ENTITY_KEY => l_batchstep_id,
2168: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2169: );
2170:
2171: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2172: RAISE instruction_nullify_err;
2173: end if;
2174:
2175: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2189: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2185: P_TARGET_ENTITY_KEY => l_batchstep_id,
2186: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2187: X_INSTRUCTION_SET_ID => l_instruction_set_id
2188: );
2189: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2190: RAISE instruction_create_err;
2191: end if;
2192: end if;
2193: end loop;

Line 2211: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2207: P_ENTITY_KEY => l_batchstep_activity_id,
2208: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2209: );
2210:
2211: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2212: RAISE instruction_nullify_err;
2213: end if;
2214:
2215: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2227: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2223: P_TARGET_ENTITY_KEY => l_batchstep_activity_id,
2224: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2225: X_INSTRUCTION_SET_ID => l_instruction_set_id
2226: );
2227: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2228: RAISE instruction_create_err;
2229: end if;
2230: end if;
2231:

Line 2250: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2246: P_ENTITY_KEY => l_batchstep_resource_id,
2247: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2248: );
2249:
2250: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2251: RAISE instruction_nullify_err;
2252: end if;
2253:
2254: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2266: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2262: P_TARGET_ENTITY_KEY => l_batchstep_resource_id,
2263: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2264: X_INSTRUCTION_SET_ID => l_instruction_set_id
2265: );
2266: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2267: RAISE instruction_create_err;
2268: end if;
2269: end if;
2270:

Line 2289: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2285: P_ENTITY_KEY => l_material_detail_id,
2286: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2287: );
2288:
2289: if X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2290: RAISE instruction_nullify_err;
2291: end if;
2292:
2293: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2305: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2301: P_TARGET_ENTITY_KEY => l_material_detail_id,
2302: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2303: X_INSTRUCTION_SET_ID => l_instruction_set_id
2304: );
2305: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2306: RAISE instruction_create_err;
2307: end if;
2308: end if;
2309: end loop;

Line 2325: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2321: P_ENTITY_KEY => l_material_detail_id,
2322: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2323: );
2324:
2325: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2326: RAISE instruction_nullify_err;
2327: end if;
2328:
2329: END IF; -- end IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_TERMINATE OR P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2346: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2342: P_ENTITY_KEY => l_batchstep_id,
2343: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2344: );
2345:
2346: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2347: RAISE instruction_nullify_err;
2348: end if;
2349:
2350: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2364: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2360: P_TARGET_ENTITY_KEY => l_batchstep_id,
2361: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2362: X_INSTRUCTION_SET_ID => l_instruction_set_id
2363: );
2364: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2365: RAISE instruction_create_err;
2366: end if;
2367: end if;
2368:

Line 2385: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2381: P_ENTITY_KEY => l_material_detail_id,
2382: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2383: );
2384:
2385: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2386: RAISE instruction_nullify_err;
2387: end if;
2388:
2389: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2401: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2397: P_TARGET_ENTITY_KEY => l_material_detail_id,
2398: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2399: X_INSTRUCTION_SET_ID => l_instruction_set_id
2400: );
2401: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2402: RAISE instruction_create_err;
2403: end if;
2404: end if;
2405:

Line 2425: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2421: P_ENTITY_KEY => l_batchstep_activity_id,
2422: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2423: );
2424:
2425: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2426: RAISE instruction_nullify_err;
2427: end if;
2428:
2429: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2441: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2437: P_TARGET_ENTITY_KEY => l_batchstep_activity_id,
2438: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2439: X_INSTRUCTION_SET_ID => l_instruction_set_id
2440: );
2441: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2442: RAISE instruction_create_err;
2443: end if;
2444: end if;
2445:

Line 2464: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2460: P_ENTITY_KEY => l_batchstep_resource_id,
2461: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2462: );
2463:
2464: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2465: RAISE instruction_nullify_err;
2466: end if;
2467:
2468: IF (P_TASK = GMO_CONSTANTS_GRP.ACTION_UNRELEASE) THEN

Line 2480: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2476: P_TARGET_ENTITY_KEY => l_batchstep_resource_id,
2477: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
2478: X_INSTRUCTION_SET_ID => l_instruction_set_id
2479: );
2480: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2481: RAISE instruction_create_err;
2482: end if;
2483: end if;
2484:

Line 2501: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2497: P_ENTITY_KEY => l_batchstep_activity_id,
2498: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2499: );
2500:
2501: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2502: RAISE instruction_nullify_err;
2503: end if;
2504:
2505: open c_get_activity_resources;

Line 2520: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2516: P_ENTITY_KEY => l_batchstep_resource_id,
2517: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2518: );
2519:
2520: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2521: RAISE instruction_nullify_err;
2522: end if;
2523:
2524: end loop;

Line 2540: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2536: P_ENTITY_KEY => l_batchstep_resource_id,
2537: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2538: );
2539:
2540: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2541: RAISE instruction_nullify_err;
2542: end if;
2543:
2544: ELSIF (P_TASK = GMO_CONSTANTS_GRP.ACTION_DELETE_MATERIAL) THEN

Line 2557: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2553: P_ENTITY_KEY => l_material_detail_id,
2554: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE
2555: );
2556:
2557: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2558: RAISE instruction_nullify_err;
2559: end if;
2560: END IF;
2561:

Line 2565: x_return_status := FND_API.G_RET_STS_SUCCESS;

2561:
2562:
2563: END IF;
2564:
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: EXCEPTION
2568: WHEN GMO_DISABLED_ERR THEN
2569: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2569: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: EXCEPTION
2568: WHEN GMO_DISABLED_ERR THEN
2569: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2570: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2571: FND_MSG_PUB.ADD;
2572: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2573: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2577: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2573: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2574: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2575: end if;
2576: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2577: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2578: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2579: FND_MSG_PUB.ADD;
2580: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2581: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2585: x_return_status := FND_API.G_RET_STS_ERROR;

2581: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2582: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2583: end if;
2584: WHEN instruction_nullify_err then
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2587: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2588: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2589: end if;

Line 2591: x_return_status := FND_API.G_RET_STS_ERROR;

2587: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2588: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2589: end if;
2590: WHEN instruction_create_err then
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2593: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2595: end if;

Line 2597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2593: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2595: end if;
2596: WHEN GMO_INVALID_ENTITY_ERR THEN
2597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2598: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2599: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2600: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2601: FND_MSG_PUB.ADD;

Line 2607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2603: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2604: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2605: end if;
2606: WHEN OTHERS THEN
2607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2608: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2609: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2610: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2611: FND_MSG_PUB.ADD;

Line 2681: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2677: P_DISABLE_TASK => GMO_CONSTANTS_GRP.DISABLE_TASK_NO
2678: );
2679:
2680:
2681: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2682: RAISE task_Acknowledgement_err;
2683: end if;
2684:
2685: END IF;

Line 2687: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2683: end if;
2684:
2685: END IF;
2686:
2687: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2688:
2689: EXCEPTION
2690: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2691: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2691: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2687: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2688:
2689: EXCEPTION
2690: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2691: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2692: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2693: FND_MSG_PUB.ADD;
2694: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2695: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2699: x_return_status := FND_API.G_RET_STS_ERROR;

2695: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2696: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2697: end if;
2698: WHEN task_Acknowledgement_err then
2699: x_return_status := FND_API.G_RET_STS_ERROR;
2700: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2701: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2702: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2703: end if;

Line 2705: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2701: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2702: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2703: end if;
2704: WHEN GMO_DISABLED_ERR THEN
2705: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2706: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2707: FND_MSG_PUB.ADD;
2708: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2709: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2709: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2710: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2711: end if;
2712: WHEN OTHERS THEN
2713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2715: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2717: FND_MSG_PUB.ADD;

Line 2827: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2823: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);
2824: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2825: end if;
2826:
2827: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2828:
2829: EXCEPTION
2830: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2831: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2831: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2827: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2828:
2829: EXCEPTION
2830: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2831: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2832: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2833: FND_MSG_PUB.ADD;
2834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2839: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2837: end if;
2838: WHEN GMO_DISABLED_ERR THEN
2839: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2841: FND_MSG_PUB.ADD;
2842: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2843: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2847: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2843: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2844: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2845: end if;
2846: WHEN NO_STEP_FOUND_ERR THEN
2847: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2848: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2849: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2850: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2851: FND_MSG_PUB.ADD;

Line 2857: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2853: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2854: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2855: end if;
2856: WHEN GMO_INVALID_ENTITY_ERR THEN
2857: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2858: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2859: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2860: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2861: FND_MSG_PUB.ADD;

Line 2867: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2863: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2865: end if;
2866: WHEN OTHERS THEN
2867: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2868: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2869: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2870: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2871: FND_MSG_PUB.ADD;

Line 3044: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3040: x_entity_level(l_counter) := t_entity_level(i);
3041:
3042: end loop;
3043:
3044: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3045:
3046: EXCEPTION
3047: WHEN OTHERS THEN
3048: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3048: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3044: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3045:
3046: EXCEPTION
3047: WHEN OTHERS THEN
3048: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3049: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
3050: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3051: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3052: FND_MSG_PUB.ADD;

Line 3153: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3149: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3150: X_INSTRUCTION_SET_ID => l_instruction_set_id
3151: );
3152:
3153: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3154: RAISE instruction_create_err;
3155: end if;
3156: update_task_attribute
3157: (

Line 3205: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3201: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3202: X_INSTRUCTION_SET_ID => l_instruction_set_id
3203: );
3204:
3205: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3206: RAISE instruction_create_err;
3207: end if;
3208:
3209: update_task_attribute

Line 3258: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3254: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
3255: X_INSTRUCTION_SET_ID => l_instruction_set_id
3256: );
3257:
3258: if l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3259: RAISE instruction_create_err;
3260: end if;
3261:
3262: update_task_attribute

Line 3297: x_return_status := FND_API.G_RET_STS_SUCCESS;

3293: if (l_invalid_entity_master.count > 0) then
3294: RAISE INVALID_ATTRIBUTE_ASSOC_ERR;
3295: end if;
3296:
3297: x_return_status := FND_API.G_RET_STS_SUCCESS;
3298:
3299: END INSTANTIATE_INSTR_FOR_LCF;
3300:
3301: