APPS.GMO_VBATCH_PVT dependencies on FND_LOG

Line 162: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

158: l_reserved_quantity := l_reserved_quantity + l_reserved_quantity_t;
159: --Bug 4609365: end
160: end loop;
161:
162: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
163:
164: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_MSG');
165: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
166: FND_MESSAGE.SET_TOKEN('BATCH_ID',P_BATCH_ID);

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

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

Line 184: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 192: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 348: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

344: else
345: l_material_available := GMO_CONSTANTS_GRP.YES;
346: end if;
347:
348: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
349:
350: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');
351: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
352: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);

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

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

Line 370: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 381: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 441: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

437: VALUES (l_batch_id, P_BATCHSTEP_ID, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
438:
439: commit;
440:
441: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
442: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
443: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
444: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
445: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');

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

442: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
443: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
444: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
445: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
446: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
447: end if;
448:
449: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
450:

Line 458: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

454: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
455: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
456: FND_MSG_PUB.ADD;
457: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
458: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
459: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
460: end if;
461: WHEN NO_BATCH_FOUND_ERR THEN
462: rollback;

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

455: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
456: FND_MSG_PUB.ADD;
457: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
458: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
459: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
460: end if;
461: WHEN NO_BATCH_FOUND_ERR THEN
462: rollback;
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

465: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
466: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
467: FND_MSG_PUB.ADD;
468: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
471: end if;
472: WHEN OTHERS THEN
473: rollback;

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

466: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
467: FND_MSG_PUB.ADD;
468: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
471: end if;
472: WHEN OTHERS THEN
473: rollback;
474: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 480: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

476: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
478: FND_MSG_PUB.ADD;
479: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
480: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
481: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
482: end if;
483: END LOCK_STEP;
484:

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

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

Line 523: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

519:
520: INSERT into GMO_BATCH_STEP_LOCK_DETAILS (BATCH_ID, BATCHSTEP_ID, LOCK_REQUESTER, LOCK_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
521: VALUES (l_batch_id, l_batchstep_id, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
522:
523: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
524: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
525: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
526: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
527: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');

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

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

Line 545: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
542: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
543: FND_MSG_PUB.ADD;
544: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
545: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
546: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
547: end if;
548: WHEN NO_BATCH_FOUND_ERR THEN
549: rollback;

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

542: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
543: FND_MSG_PUB.ADD;
544: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
545: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
546: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
547: end if;
548: WHEN NO_BATCH_FOUND_ERR THEN
549: rollback;
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 556: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

552: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
553: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
554: FND_MSG_PUB.ADD;
555: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
556: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
557: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
558: end if;
559: WHEN OTHERS THEN
560: rollback;

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

553: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
554: FND_MSG_PUB.ADD;
555: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
556: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
557: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
558: end if;
559: WHEN OTHERS THEN
560: rollback;
561: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 567: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

563: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
564: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
565: FND_MSG_PUB.ADD;
566: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
567: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
568: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
569: end if;
570: END LOCK_STEP;
571:

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

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

Line 610: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

606: DELETE FROM GMO_BATCH_STEP_LOCK_DETAILS WHERE BATCHSTEP_ID = P_BATCHSTEP_ID;
607:
608: commit;
609:
610: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
611: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
612: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
613: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
614: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');

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

611: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
612: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
613: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
614: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
616: end if;
617:
618:
619: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 628: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

624: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
625: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
626: FND_MSG_PUB.ADD;
627: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
628: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
629: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
630: end if;
631: WHEN OTHERS THEN
632: rollback;

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

625: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
626: FND_MSG_PUB.ADD;
627: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
628: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
629: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
630: end if;
631: WHEN OTHERS THEN
632: rollback;
633: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 639: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

635: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
636: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
637: FND_MSG_PUB.ADD;
638: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
639: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
640: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
641: end if;
642: END UNLOCK_STEP;
643:

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

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

Line 686: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

682: VALUES (GMO_BATCH_STEP_LOCK_HIST_S.NEXTVAL, l_batch_id, l_batchstep_id, l_lock_requester, l_lock_date, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
683:
684: DELETE FROM GMO_BATCH_STEP_LOCK_DETAILS WHERE BATCHSTEP_ID = l_batchstep_id;
685:
686: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
687: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
688: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
689: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
690: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');

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

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

Line 708: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

704: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
705: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
708: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
710: end if;
711: WHEN OTHERS THEN
712: rollback;

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

705: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
708: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
710: end if;
711: WHEN OTHERS THEN
712: rollback;
713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 719: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

715: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
717: FND_MSG_PUB.ADD;
718: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
719: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
720: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
721: end if;
722: END UNLOCK_STEP;
723:

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

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

Line 772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

768: IF (l_batch_id is null) THEN
769: RAISE NO_BATCH_FOUND_ERR;
770: END IF;
771:
772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
773: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
774: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
775: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
776: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);

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

773: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
774: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
775: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
776: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
778: end if;
779:
780: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
781: X_BATCH_ID := l_batch_id;

Line 792: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

788: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
789: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
790: FND_MSG_PUB.ADD;
791: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
792: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
793: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
794: end if;
795: WHEN GMO_INVALID_ENTITY_ERR THEN
796: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

789: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
790: FND_MSG_PUB.ADD;
791: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
792: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
793: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
794: end if;
795: WHEN GMO_INVALID_ENTITY_ERR THEN
796: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
797: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 802: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

798: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
799: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
800: FND_MSG_PUB.ADD;
801: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
802: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
803: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
804: end if;
805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

799: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
800: FND_MSG_PUB.ADD;
801: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
802: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
803: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
804: end if;
805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 812: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 859: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

855: IF (l_batchstep_id is null) THEN
856: RAISE NO_BATCHSTEP_FOUND_ERR;
857: END IF;
858:
859: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
860: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
861: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
862: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
863: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);

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

860: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
861: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
862: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
863: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
865: end if;
866:
867:
868: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 880: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

876: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
877: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
878: FND_MSG_PUB.ADD;
879: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
880: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
881: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
882: end if;
883: WHEN GMO_INVALID_ENTITY_ERR THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

877: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
878: FND_MSG_PUB.ADD;
879: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
880: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
881: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
882: end if;
883: WHEN GMO_INVALID_ENTITY_ERR THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
885: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 890: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

886: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
887: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
888: FND_MSG_PUB.ADD;
889: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
890: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
891: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
892: end if;
893: WHEN OTHERS THEN
894: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

887: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
888: FND_MSG_PUB.ADD;
889: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
890: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
891: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
892: end if;
893: WHEN OTHERS THEN
894: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
895: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 900: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
897: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
898: FND_MSG_PUB.ADD;
899: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
900: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
901: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
902: end if;
903: END GET_BATCHSTEP_ID_FOR_ENTITY;
904:

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

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

Line 1303: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1299: l_invalid_entity_master.extend;
1300: l_invalid_entity_master (k) := l_entity_display_name;
1301: end if;
1302:
1303: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1304: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1306: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1307: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');

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

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

Line 1356: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1352: l_invalid_entity_master.extend;
1353: l_invalid_entity_master (k) := l_entity_display_name;
1354: end if;
1355:
1356: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1357: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1359: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1360: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');

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

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

Line 1409: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1405: l_invalid_entity_master.extend;
1406: l_invalid_entity_master (k) := l_entity_display_name;
1407: end if;
1408:
1409: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1410: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1411: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1412: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1413: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');

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

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

Line 1462: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1458: l_invalid_entity_master.extend;
1459: l_invalid_entity_master (k) := l_entity_display_name;
1460: end if;
1461:
1462: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1463: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1464: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1465: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1466: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');

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

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

Line 1486: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 1494: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 1502: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 1510: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1506: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1507: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1508: FND_MSG_PUB.ADD;
1509: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1510: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1511: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1512: end if;
1513: WHEN GMO_INVALID_ENTITY_ERR THEN
1514: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

1507: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1508: FND_MSG_PUB.ADD;
1509: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1510: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1511: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1512: end if;
1513: WHEN GMO_INVALID_ENTITY_ERR THEN
1514: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1515: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 1520: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1517: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1518: FND_MSG_PUB.ADD;
1519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1520: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1521: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1522: end if;
1523: WHEN INVALID_ATTRIBUTE_ASSOC_ERR THEN
1524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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

Line 1528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1526: FND_MSG_PUB.ADD;
1527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1530: end if;
1531: WHEN OTHERS THEN
1532: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

1525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1526: FND_MSG_PUB.ADD;
1527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1530: end if;
1531: WHEN OTHERS THEN
1532: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 1538: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 1931: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1927: ELSE
1928: RAISE GMO_INVALID_TASK_ERR;
1929: END IF;
1930:
1931: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1932: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');
1933: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1934: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1935: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

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

Line 2021: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2017: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2018: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2019: FND_MSG_PUB.ADD;
2020: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2021: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2023: end if;
2024: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2025: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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

Line 2030: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2026: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
2027: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2028: FND_MSG_PUB.ADD;
2029: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2030: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2031: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2032: end if;
2033:
2034: WHEN GMO_INVALID_MODULE_ERR THEN

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

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

Line 2039: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2048: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

2045: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_PARAM_ERR');
2046: FND_MSG_PUB.ADD;
2047: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2048: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2049: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2050: end if;
2051:
2052: WHEN GMO_INVALID_TASK_ERR THEN
2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 2060: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2056: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2057: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2058: FND_MSG_PUB.ADD;
2059: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2060: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2061: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2062: end if;
2063: WHEN GMO_INVALID_ENTITY_ERR THEN
2064: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2057: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2058: FND_MSG_PUB.ADD;
2059: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2060: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2061: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2062: end if;
2063: WHEN GMO_INVALID_ENTITY_ERR THEN
2064: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2065: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 2070: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2066: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2067: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2070: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2071: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2072: end if;
2073: WHEN OTHERS THEN
2074: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2067: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2070: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2071: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2072: end if;
2073: WHEN OTHERS THEN
2074: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 2080: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2143: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2139: IF (P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_BATCH AND P_ENTITY_NAME <> GMO_CONSTANTS_GRP.ENTITY_OPERATION OR p_entity_key is null) THEN
2140: RAISE GMO_INVALID_ENTITY_ERR;
2141: END IF;
2142:
2143: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2144: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2145: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2146: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2147: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

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

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

Line 2573: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2581: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2577: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2578: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2579: FND_MSG_PUB.ADD;
2580: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2581: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2582: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2583: end if;
2584: WHEN instruction_nullify_err then
2585: x_return_status := FND_API.G_RET_STS_ERROR;

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

2578: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2579: FND_MSG_PUB.ADD;
2580: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2581: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2582: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2583: end if;
2584: WHEN instruction_nullify_err then
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 2587: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2593: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

2590: WHEN instruction_create_err then
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2593: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2595: end if;
2596: WHEN GMO_INVALID_ENTITY_ERR THEN
2597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2598: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 2603: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2599: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2600: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2601: FND_MSG_PUB.ADD;
2602: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2603: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2604: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2605: end if;
2606: WHEN OTHERS THEN
2607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2600: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2601: FND_MSG_PUB.ADD;
2602: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2603: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2604: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2605: end if;
2606: WHEN OTHERS THEN
2607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2608: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 2613: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2653: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2649: IF (NOT IS_BATCH_ENHANCED_PI (P_ENTITY_NAME => P_ENTITY_NAME, P_ENTITY_KEY => P_ENTITY_KEY) ) THEN
2650: RAISE GMO_NOT_ENHANCED_PI_ERR;
2651: END IF;
2652:
2653: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2654: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');
2655: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
2656: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2657: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

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

Line 2695: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2691: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2692: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2693: FND_MSG_PUB.ADD;
2694: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2695: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2696: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2697: end if;
2698: WHEN task_Acknowledgement_err then
2699: x_return_status := FND_API.G_RET_STS_ERROR;

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

2692: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2693: FND_MSG_PUB.ADD;
2694: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2695: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2696: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2697: end if;
2698: WHEN task_Acknowledgement_err then
2699: x_return_status := FND_API.G_RET_STS_ERROR;
2700: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 2701: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2709: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2705: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2706: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2707: FND_MSG_PUB.ADD;
2708: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2709: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2710: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2711: end if;
2712: WHEN OTHERS THEN
2713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2706: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2707: FND_MSG_PUB.ADD;
2708: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2709: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2710: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2711: end if;
2712: WHEN OTHERS THEN
2713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 2719: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2816: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2812: ELSE
2813: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.NO;
2814: END IF;
2815:
2816: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2817: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');
2818: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2819: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2820: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

2820: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2821: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2822: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
2823: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);
2824: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2825: end if;
2826:
2827: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2828:

Line 2835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 2843: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2839: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2841: FND_MSG_PUB.ADD;
2842: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2843: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2844: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2845: end if;
2846: WHEN NO_STEP_FOUND_ERR THEN
2847: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2841: FND_MSG_PUB.ADD;
2842: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2843: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2844: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2845: end if;
2846: WHEN NO_STEP_FOUND_ERR THEN
2847: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2848: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 2853: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2849: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2850: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2851: FND_MSG_PUB.ADD;
2852: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2853: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2854: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2855: end if;
2856: WHEN GMO_INVALID_ENTITY_ERR THEN
2857: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2850: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2851: FND_MSG_PUB.ADD;
2852: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2853: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2854: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2855: end if;
2856: WHEN GMO_INVALID_ENTITY_ERR THEN
2857: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2858: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

Line 2863: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2859: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2860: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2861: FND_MSG_PUB.ADD;
2862: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2863: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2865: end if;
2866: WHEN OTHERS THEN
2867: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2860: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2861: FND_MSG_PUB.ADD;
2862: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2863: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2865: end if;
2866: WHEN OTHERS THEN
2867: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2868: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 2873: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 3054: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

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

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

Line 3175: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3171: l_invalid_entity_master.extend;
3172: l_invalid_entity_master (k) := l_entity_display_name;
3173: end if;
3174:
3175: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3176: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3177: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3178: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3179: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');

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

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

Line 3228: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3224: l_invalid_entity_master.extend;
3225: l_invalid_entity_master (k) := l_entity_display_name;
3226: end if;
3227:
3228: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3229: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3231: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3232: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');

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

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

Line 3281: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3277: l_invalid_entity_master.extend;
3278: l_invalid_entity_master (k) := l_entity_display_name;
3279: end if;
3280:
3281: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3282: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3283: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3284: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3285: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');

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

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