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 GMO_VBATCH_PVT

Line 1: PACKAGE BODY GMO_VBATCH_PVT AS

1: PACKAGE BODY GMO_VBATCH_PVT AS
2: /* $Header: GMOVVBTB.pls 120.27.12020000.2 2012/07/17 09:16:14 maychen ship $ */
3:
4: GMO_INVALID_ENTITY_ERR exception;
5: GMO_DISABLED_ERR EXCEPTION;

Line 170: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_material_reservation_qty', FALSE);

166: FND_MESSAGE.SET_TOKEN('BATCH_ID',P_BATCH_ID);
167: FND_MESSAGE.SET_TOKEN('MATERIAL_DETAIL_ID',P_MATERIAL_DETAIL_ID);
168: FND_MESSAGE.SET_TOKEN('RESERVED_QUANTITY',l_reserved_quantity);
169:
170: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_material_reservation_qty', FALSE);
171: end if;
172:
173: return l_reserved_quantity;
174:

Line 185: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_material_reservation_qty', FALSE);

181: FND_MESSAGE.SET_TOKEN('MATERIAL_DETAIL_ID',P_MATERIAL_DETAIL_ID);
182: FND_MESSAGE.SET_TOKEN('RESERVED_QUANTITY',l_reserved_quantity);
183: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
184: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
185: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_material_reservation_qty', FALSE);
186: end if;
187: APP_EXCEPTION.RAISE_EXCEPTION;
188: WHEN OTHERS THEN
189: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 193: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_material_reservation_qty', FALSE);

189: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
190: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
191: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
192: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
193: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_material_reservation_qty', FALSE);
194: end if;
195: APP_EXCEPTION.RAISE_EXCEPTION;
196: END GET_MATERIAL_RESERVATION_QTY;
197:

Line 353: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);

349:
350: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');
351: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
352: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
353: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
354: end if;
355:
356: X_MATERIAL_AVAILABLE := l_material_available;
357:

Line 371: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);

367: FND_MSG_PUB.ADD;
368: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
369:
370: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
371: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
372: end if;
373:
374: WHEN OTHERS THEN
375:

Line 382: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);

378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
379: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
380: FND_MSG_PUB.ADD;
381: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
382: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
383: end if;
384: END GET_STEP_MATERIAL_AVAILABILITY;
385:
386:

Line 446: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

442: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
443: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
444: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
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:

Line 459: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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
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;

Line 470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

466: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
467: FND_MSG_PUB.ADD;
468: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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;

Line 481: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

477: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
478: FND_MSG_PUB.ADD;
479: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
480: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
481: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
482: end if;
483: END LOCK_STEP;
484:
485: --This procdeure would lock the (array) step and do an autonomous commit..

Line 528: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

524: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
525: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
526: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
527: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
528: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
529: end if;
530:
531:
532: end loop;

Line 546: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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
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;

Line 557: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

553: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
554: FND_MSG_PUB.ADD;
555: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
556: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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;

Line 568: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

564: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
565: FND_MSG_PUB.ADD;
566: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
567: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
568: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
569: end if;
570: END LOCK_STEP;
571:
572: --This procdeure would unlock the step.

Line 615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

611: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
612: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
613: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
614: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
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;

Line 629: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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
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;

Line 640: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

636: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
637: FND_MSG_PUB.ADD;
638: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
639: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
640: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
641: end if;
642: END UNLOCK_STEP;
643:
644: --This procdeure would unlock the step.

Line 691: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

687: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
688: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
689: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
690: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
691: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
692: end if;
693:
694:
695: end loop;

Line 709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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
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;

Line 720: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
717: FND_MSG_PUB.ADD;
718: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
719: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
720: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
721: end if;
722: END UNLOCK_STEP;
723:
724: -- this procedure returns the batch id for the entity

Line 777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

773: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
774: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
775: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
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;

Line 793: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

789: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
790: FND_MSG_PUB.ADD;
791: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 803: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

799: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
800: FND_MSG_PUB.ADD;
801: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 813: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

809: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
810: FND_MSG_PUB.ADD;
811: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
812: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
813: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
814: end if;
815: END GET_BATCH_ID_FOR_ENTITY;
816:
817: procedure GET_BATCHSTEP_ID_FOR_ENTITY (P_ENTITY_NAME IN VARCHAR2,

Line 864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

860: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
861: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
862: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
863: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
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;

Line 881: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

877: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
878: FND_MSG_PUB.ADD;
879: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 891: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

887: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
888: FND_MSG_PUB.ADD;
889: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 901: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

897: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
898: FND_MSG_PUB.ADD;
899: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
900: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
901: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
902: end if;
903: END GET_BATCHSTEP_ID_FOR_ENTITY;
904:
905: -- this function is internally used by the apis to

Line 1309: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

1305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1306: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1307: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
1308: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
1309: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1310: end if;
1311:
1312: end loop;
1313: close c_get_steps;

Line 1362: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

1358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1359: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1360: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
1361: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
1362: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1363: end if;
1364:
1365: end loop;
1366: close c_get_activities;

Line 1415: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

1411: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1412: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1413: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
1414: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
1415: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1416: end if;
1417:
1418: end loop;
1419: close c_get_resources;

Line 1468: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

1464: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1465: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1466: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');
1467: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);
1468: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1469: end if;
1470:
1471: end loop;
1472: close c_get_materials;

Line 1487: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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;
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');

Line 1495: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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
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');

Line 1503: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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
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');

Line 1511: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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
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');

Line 1521: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

1517: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1518: FND_MSG_PUB.ADD;
1519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 1529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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
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');

Line 1539: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

1535: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1536: FND_MSG_PUB.ADD;
1537: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1538: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1539: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1540: end if;
1541:
1542: END INSTANTIATE_ADVANCED_PI;
1543:

Line 1712: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);

1708:
1709: IF (P_TASK = 'VIEW_OPERATION') THEN
1710: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1711: ELSE
1712: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1713:
1714: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1715: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1716: ELSE

Line 1748: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);

1744: IF (P_TASK = 'VIEW_ACTIVITY') THEN
1745: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1746: ELSE
1747:
1748: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1749:
1750: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1751: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1752: ELSE

Line 1795: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);

1791: IF (P_TASK = 'VIEW_RESOURCE') THEN
1792: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_YES;
1793: ELSE
1794:
1795: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1796:
1797: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1798: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1799: ELSE

Line 1830: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);

1826: X_TASK_ENTITY_KEY := l_batchstep_resource_id;
1827: X_TASK_NAME := GMO_CONSTANTS_GRP.TASK_PROCESS_PARAMETER;
1828: X_TASK_KEY := l_process_param_id;
1829:
1830: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1831:
1832: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1833: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1834: ELSE

Line 1917: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);

1913: ELSIF (X_TASK_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH or l_batchstep_id is null ) THEN
1914: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1915: ELSE
1916:
1917: l_step_locked := GMO_VBATCH_PVT.IS_STEP_LOCKED (P_VBATCH_MODE => l_vbatch_mode, P_BATCHSTEP_ID => l_batchstep_id, P_REQUESTER => l_requester);
1918:
1919: IF (not l_advanced_pi or l_step_locked = GMO_CONSTANTS_GRP.YES) THEN
1920: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1921: ELSE

Line 1943: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

1939: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1940: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1941: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);
1942: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);
1943: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1944: end if;
1945:
1946: if (l_batch_id is null) then
1947: get_batch_id_for_entity

Line 2022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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
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;

Line 2031: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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);
2030: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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;

Line 2040: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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
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;

Line 2049: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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
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;

Line 2061: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

2057: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2058: FND_MSG_PUB.ADD;
2059: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 2071: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

2067: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 2081: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

2077: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2078: FND_MSG_PUB.ADD;
2079: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2080: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2081: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2082: end if;
2083: END ON_TASK_LOAD;
2084:
2085:

Line 2149: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

2145: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2146: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2147: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2148: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2149: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2150: end if;
2151:
2152:
2153: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN

Line 2574: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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
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');

Line 2582: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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
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);

Line 2588: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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;
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);

Line 2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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;
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');

Line 2604: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

2600: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2601: FND_MSG_PUB.ADD;
2602: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 2614: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

2610: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2613: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2614: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2615: end if;
2616: END ON_TASK_ACTION;
2617:
2618:

Line 2660: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

2656: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2657: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2658: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2659: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2660: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2661: end if;
2662:
2663:
2664: IF (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) THEN

Line 2696: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

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
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);

Line 2702: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

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;
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');

Line 2710: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

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
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');

Line 2720: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

2716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2717: FND_MSG_PUB.ADD;
2718: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2719: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2720: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2721: end if;
2722:
2723: END ON_TASK_SAVE;
2724:

Line 2824: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

2820: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2821: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2822: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
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:

Line 2836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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
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');

Line 2844: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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
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');

Line 2854: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

2850: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2851: FND_MSG_PUB.ADD;
2852: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 2864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

2860: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2861: FND_MSG_PUB.ADD;
2862: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
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');

Line 2874: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

2870: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2871: FND_MSG_PUB.ADD;
2872: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2873: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2874: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2875: end if;
2876: END GET_ENTITY_LOCK_STATUS;
2877:
2878: --Bug 5224634: start

Line 3055: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_nodes', FALSE);

3051: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3052: FND_MSG_PUB.ADD;
3053: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
3054: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3055: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_nodes', FALSE);
3056: end if;
3057: END GET_BATCHSTEP_NODES;
3058:
3059: --Bug 5224634: end

Line 3181: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

3177: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3178: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3179: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
3180: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
3181: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3182: end if;
3183:
3184: end loop;
3185: close c_get_steps;

Line 3234: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

3230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3231: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3232: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
3233: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
3234: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3235: end if;
3236:
3237: end loop;
3238: close c_get_activities;

Line 3287: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

3283: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3284: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3285: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
3286: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
3287: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3288: end if;
3289:
3290: end loop;
3291: close c_get_resources;

Line 3302: END GMO_VBATCH_PVT;

3298:
3299: END INSTANTIATE_INSTR_FOR_LCF;
3300:
3301:
3302: END GMO_VBATCH_PVT;