318: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
319: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
320: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
321: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
322: FND_MSG_PUB.ADD;
323: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
324:
325: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
326: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
319: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
320: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
321: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
322: FND_MSG_PUB.ADD;
323: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
324:
325: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
326: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
327: end if;
331: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
335: FND_MSG_PUB.ADD;
336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
337: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
338: end if;
339: END GET_STEP_MATERIAL_AVAILABILITY;
407: WHEN STEP_ALREADY_LOCKED_ERR THEN
408: rollback;
409: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
410: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
411: FND_MSG_PUB.ADD;
412: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
413: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
415: end if;
408: rollback;
409: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
410: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
411: FND_MSG_PUB.ADD;
412: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
413: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
415: end if;
416: WHEN NO_BATCH_FOUND_ERR THEN
418: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
420: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
421: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
422: FND_MSG_PUB.ADD;
423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
424: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
425: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
426: end if;
419: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
420: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
421: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
422: FND_MSG_PUB.ADD;
423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
424: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
425: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
426: end if;
427: WHEN OTHERS THEN
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
430: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
437: end if;
430: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
437: end if;
438: END LOCK_STEP;
494: WHEN STEP_ALREADY_LOCKED_ERR THEN
495: rollback;
496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
497: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
498: FND_MSG_PUB.ADD;
499: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
500: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
501: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
502: end if;
495: rollback;
496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
497: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
498: FND_MSG_PUB.ADD;
499: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
500: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
501: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
502: end if;
503: WHEN NO_BATCH_FOUND_ERR THEN
505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
506: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
507: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
508: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
509: FND_MSG_PUB.ADD;
510: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
511: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
512: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
513: end if;
506: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
507: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
508: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
509: FND_MSG_PUB.ADD;
510: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
511: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
512: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
513: end if;
514: WHEN OTHERS THEN
516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
518: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
519: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
520: FND_MSG_PUB.ADD;
521: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
523: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
524: end if;
517: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
518: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
519: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
520: FND_MSG_PUB.ADD;
521: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
523: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
524: end if;
525: END LOCK_STEP;
577: WHEN STEP_NOT_LOCKED_ERR THEN
578: rollback;
579: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
580: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
581: FND_MSG_PUB.ADD;
582: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
583: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
584: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
585: end if;
578: rollback;
579: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
580: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
581: FND_MSG_PUB.ADD;
582: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
583: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
584: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
585: end if;
586: WHEN OTHERS THEN
588: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
590: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
591: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
592: FND_MSG_PUB.ADD;
593: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
594: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
595: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
596: end if;
589: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
590: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
591: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
592: FND_MSG_PUB.ADD;
593: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
594: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
595: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
596: end if;
597: END UNLOCK_STEP;
657: WHEN STEP_NOT_LOCKED_ERR THEN
658: rollback;
659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
660: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
661: FND_MSG_PUB.ADD;
662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
663: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
664: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
665: end if;
658: rollback;
659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
660: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
661: FND_MSG_PUB.ADD;
662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
663: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
664: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
665: end if;
666: WHEN OTHERS THEN
668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
675: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
676: end if;
669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
675: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
676: end if;
677: END UNLOCK_STEP;
741: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
742: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
747: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
748: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
749: end if;
742: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
747: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
748: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
749: end if;
750: WHEN GMO_INVALID_ENTITY_ERR THEN
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
753: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
757: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
758: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
759: end if;
752: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
753: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
757: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
758: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
759: end if;
760: WHEN OTHERS THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
763: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
764: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
765: FND_MSG_PUB.ADD;
766: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
767: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
768: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
769: end if;
762: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
763: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
764: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
765: FND_MSG_PUB.ADD;
766: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
767: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
768: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
769: end if;
770: END GET_BATCH_ID_FOR_ENTITY;
829: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
830: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
837: end if;
830: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
837: end if;
838: WHEN GMO_INVALID_ENTITY_ERR THEN
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
841: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
845: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
846: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
847: end if;
840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
841: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
845: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
846: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
847: end if;
848: WHEN OTHERS THEN
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
851: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
853: FND_MSG_PUB.ADD;
854: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
855: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
856: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
857: end if;
850: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
851: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
853: FND_MSG_PUB.ADD;
854: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
855: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
856: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
857: end if;
858: END GET_BATCHSTEP_ID_FOR_ENTITY;
1436:
1437: EXCEPTION
1438: WHEN instruction_create_err then
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1441: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1442: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1443: end if;
1444: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1443: end if;
1444: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1445: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1446: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1447: FND_MSG_PUB.ADD;
1448: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1449: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1450: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1451: end if;
1444: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1445: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1446: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1447: FND_MSG_PUB.ADD;
1448: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1449: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1450: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1451: end if;
1452: WHEN GMO_INVALID_RECIPE_ERR THEN
1451: end if;
1452: WHEN GMO_INVALID_RECIPE_ERR THEN
1453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1454: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_RECIPE');
1455: FND_MSG_PUB.ADD;
1456: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1457: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1458: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1459: end if;
1452: WHEN GMO_INVALID_RECIPE_ERR THEN
1453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1454: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_RECIPE');
1455: FND_MSG_PUB.ADD;
1456: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1457: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1458: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1459: end if;
1460: WHEN GMO_DISABLED_ERR THEN
1459: end if;
1460: WHEN GMO_DISABLED_ERR THEN
1461: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1462: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1463: FND_MSG_PUB.ADD;
1464: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1465: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1466: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1467: end if;
1460: WHEN GMO_DISABLED_ERR THEN
1461: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1462: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1463: FND_MSG_PUB.ADD;
1464: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1465: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1466: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1467: end if;
1468: WHEN GMO_INVALID_ENTITY_ERR THEN
1469: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1470: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
1471: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1472: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1475: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1476: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1477: end if;
1470: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
1471: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1472: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1475: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1476: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1477: end if;
1478: WHEN INVALID_ATTRIBUTE_ASSOC_ERR THEN
1477: end if;
1478: WHEN INVALID_ATTRIBUTE_ASSOC_ERR THEN
1479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1480: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1481: FND_MSG_PUB.ADD;
1482: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1483: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1485: end if;
1478: WHEN INVALID_ATTRIBUTE_ASSOC_ERR THEN
1479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1480: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1481: FND_MSG_PUB.ADD;
1482: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1483: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1485: end if;
1486: WHEN OTHERS THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1489: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1490: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1491: FND_MSG_PUB.ADD;
1492: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1495: end if;
1488: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1489: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1490: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1491: FND_MSG_PUB.ADD;
1492: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1495: end if;
1496:
1970: EXCEPTION
1971: WHEN GMO_DISABLED_ERR THEN
1972: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1973: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1974: FND_MSG_PUB.ADD;
1975: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1976: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1977: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1978: end if;
1971: WHEN GMO_DISABLED_ERR THEN
1972: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1973: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1974: FND_MSG_PUB.ADD;
1975: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1976: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1977: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1978: end if;
1979: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1979: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1980: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1981: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1982: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1983: FND_MSG_PUB.ADD;
1984: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1985: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1986: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1987: end if;
1980: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1981: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1982: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1983: FND_MSG_PUB.ADD;
1984: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1985: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1986: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1987: end if;
1988:
1988:
1989: WHEN GMO_INVALID_MODULE_ERR THEN
1990: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1991: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_MODULE');
1992: FND_MSG_PUB.ADD;
1993: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1994: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1995: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1996: end if;
1989: WHEN GMO_INVALID_MODULE_ERR THEN
1990: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1991: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_MODULE');
1992: FND_MSG_PUB.ADD;
1993: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1994: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1995: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1996: end if;
1997:
1997:
1998: WHEN GMO_INSTR_TASK_PARAM_ERR THEN
1999: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2000: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_PARAM_ERR');
2001: FND_MSG_PUB.ADD;
2002: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2003: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2005: end if;
1998: WHEN GMO_INSTR_TASK_PARAM_ERR THEN
1999: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2000: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_PARAM_ERR');
2001: FND_MSG_PUB.ADD;
2002: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2003: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2005: end if;
2006:
2009: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2010: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2015: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2016: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2017: end if;
2010: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2015: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2016: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2017: end if;
2018: WHEN GMO_INVALID_ENTITY_ERR THEN
2019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2020: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2021: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2025: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2026: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2027: end if;
2020: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2021: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2025: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2026: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2027: end if;
2028: WHEN OTHERS THEN
2029: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2033: FND_MSG_PUB.ADD;
2034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2035: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2036: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2037: end if;
2030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2033: FND_MSG_PUB.ADD;
2034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2035: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2036: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2037: end if;
2038: END ON_TASK_LOAD;
2522: EXCEPTION
2523: WHEN GMO_DISABLED_ERR THEN
2524: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2526: FND_MSG_PUB.ADD;
2527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2530: end if;
2523: WHEN GMO_DISABLED_ERR THEN
2524: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2526: FND_MSG_PUB.ADD;
2527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2530: end if;
2531: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2530: end if;
2531: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2532: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2534: FND_MSG_PUB.ADD;
2535: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2536: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2537: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2538: end if;
2531: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2532: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2534: FND_MSG_PUB.ADD;
2535: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2536: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2537: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2538: end if;
2539: WHEN instruction_nullify_err then
2537: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2538: end if;
2539: WHEN instruction_nullify_err then
2540: x_return_status := FND_API.G_RET_STS_ERROR;
2541: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2542: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2544: end if;
2545: WHEN instruction_create_err then
2543: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2544: end if;
2545: WHEN instruction_create_err then
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2548: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2549: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2550: end if;
2551: WHEN GMO_INVALID_ENTITY_ERR THEN
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2554: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2558: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2560: end if;
2553: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2554: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2558: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2560: end if;
2561: WHEN OTHERS THEN
2562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2563: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2564: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2565: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2566: FND_MSG_PUB.ADD;
2567: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2568: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2569: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2570: end if;
2563: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2564: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2565: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2566: FND_MSG_PUB.ADD;
2567: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2568: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2569: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2570: end if;
2571: END ON_TASK_ACTION;
2644: EXCEPTION
2645: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2646: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2647: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2648: FND_MSG_PUB.ADD;
2649: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2650: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2651: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2652: end if;
2645: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2646: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2647: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2648: FND_MSG_PUB.ADD;
2649: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2650: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2651: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2652: end if;
2653: WHEN task_Acknowledgement_err then
2651: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2652: end if;
2653: WHEN task_Acknowledgement_err then
2654: x_return_status := FND_API.G_RET_STS_ERROR;
2655: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2656: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2657: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2658: end if;
2659: WHEN GMO_DISABLED_ERR THEN
2658: end if;
2659: WHEN GMO_DISABLED_ERR THEN
2660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2661: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2662: FND_MSG_PUB.ADD;
2663: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2664: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2665: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2666: end if;
2659: WHEN GMO_DISABLED_ERR THEN
2660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2661: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2662: FND_MSG_PUB.ADD;
2663: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2664: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2665: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2666: end if;
2667: WHEN OTHERS THEN
2668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2672: FND_MSG_PUB.ADD;
2673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2675: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2676: end if;
2669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2672: FND_MSG_PUB.ADD;
2673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2675: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2676: end if;
2677:
2784: EXCEPTION
2785: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2786: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2787: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2788: FND_MSG_PUB.ADD;
2789: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2790: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2791: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2792: end if;
2785: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2786: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2787: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2788: FND_MSG_PUB.ADD;
2789: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2790: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2791: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2792: end if;
2793: WHEN GMO_DISABLED_ERR THEN
2792: end if;
2793: WHEN GMO_DISABLED_ERR THEN
2794: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2795: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2796: FND_MSG_PUB.ADD;
2797: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2798: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2799: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2800: end if;
2793: WHEN GMO_DISABLED_ERR THEN
2794: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2795: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2796: FND_MSG_PUB.ADD;
2797: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2798: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2799: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2800: end if;
2801: WHEN NO_STEP_FOUND_ERR THEN
2802: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2803: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2808: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2809: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2810: end if;
2803: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2808: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2809: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2810: end if;
2811: WHEN GMO_INVALID_ENTITY_ERR THEN
2812: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2813: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2818: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2820: end if;
2813: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2818: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2820: end if;
2821: WHEN OTHERS THEN
2822: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2823: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2824: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2825: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2826: FND_MSG_PUB.ADD;
2827: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2828: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2829: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2830: end if;
2823: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2824: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2825: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2826: FND_MSG_PUB.ADD;
2827: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2828: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2829: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2830: end if;
2831: END GET_ENTITY_LOCK_STATUS;
3003: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3004: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
3005: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3006: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3007: FND_MSG_PUB.ADD;
3008: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
3009: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3010: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_nodes', FALSE);
3011: end if;
3004: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
3005: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3006: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3007: FND_MSG_PUB.ADD;
3008: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
3009: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3010: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_nodes', FALSE);
3011: end if;
3012: END GET_BATCHSTEP_NODES;