DBA Data[Home] [Help]

APPS.GMO_VBATCH_PVT dependencies on FND_MSG_PUB

Line 322: FND_MSG_PUB.ADD;

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

Line 323: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 335: FND_MSG_PUB.ADD;

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;

Line 411: FND_MSG_PUB.ADD;

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;

Line 412: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 422: FND_MSG_PUB.ADD;

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;

Line 423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 433: FND_MSG_PUB.ADD;

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;

Line 434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 498: FND_MSG_PUB.ADD;

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;

Line 499: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 509: FND_MSG_PUB.ADD;

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;

Line 510: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 520: FND_MSG_PUB.ADD;

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;

Line 521: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 581: FND_MSG_PUB.ADD;

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;

Line 582: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 592: FND_MSG_PUB.ADD;

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;

Line 593: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 661: FND_MSG_PUB.ADD;

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;

Line 662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 672: FND_MSG_PUB.ADD;

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;

Line 673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 745: FND_MSG_PUB.ADD;

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;

Line 746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 755: FND_MSG_PUB.ADD;

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;

Line 756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 765: FND_MSG_PUB.ADD;

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;

Line 766: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 833: FND_MSG_PUB.ADD;

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;

Line 834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 843: FND_MSG_PUB.ADD;

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;

Line 844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 853: FND_MSG_PUB.ADD;

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;

Line 854: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 1440: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1447: FND_MSG_PUB.ADD;

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;

Line 1448: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1455: FND_MSG_PUB.ADD;

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;

Line 1456: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1463: FND_MSG_PUB.ADD;

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;

Line 1464: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1473: FND_MSG_PUB.ADD;

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;

Line 1474: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1481: FND_MSG_PUB.ADD;

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;

Line 1482: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1491: FND_MSG_PUB.ADD;

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;

Line 1492: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 1974: FND_MSG_PUB.ADD;

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;

Line 1975: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 1983: FND_MSG_PUB.ADD;

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;

Line 1984: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 1992: FND_MSG_PUB.ADD;

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;

Line 1993: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 2001: FND_MSG_PUB.ADD;

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;

Line 2002: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 2013: FND_MSG_PUB.ADD;

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;

Line 2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2023: FND_MSG_PUB.ADD;

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;

Line 2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2033: FND_MSG_PUB.ADD;

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;

Line 2034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 2526: FND_MSG_PUB.ADD;

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;

Line 2527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2534: FND_MSG_PUB.ADD;

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;

Line 2535: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2541: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2547: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2556: FND_MSG_PUB.ADD;

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;

Line 2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2566: FND_MSG_PUB.ADD;

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;

Line 2567: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 2648: FND_MSG_PUB.ADD;

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;

Line 2649: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2655: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2662: FND_MSG_PUB.ADD;

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;

Line 2663: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2672: FND_MSG_PUB.ADD;

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;

Line 2673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 2788: FND_MSG_PUB.ADD;

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;

Line 2789: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2796: FND_MSG_PUB.ADD;

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;

Line 2797: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2806: FND_MSG_PUB.ADD;

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;

Line 2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2816: FND_MSG_PUB.ADD;

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;

Line 2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2826: FND_MSG_PUB.ADD;

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;

Line 2827: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;

Line 3007: FND_MSG_PUB.ADD;

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;

Line 3008: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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;