eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_VBATCH_PVT dependencies on FND_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 303: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

299: else
300: l_material_available := GMO_CONSTANTS_GRP.YES;
301: end if;
302:
303: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
304:
305: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');
306: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
307: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);

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

304:
305: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');
306: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
307: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
308: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
309: end if;
310:
311: X_MATERIAL_AVAILABLE := l_material_available;
312:

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

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;
328:
329: WHEN OTHERS THEN

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

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;
328:
329: WHEN OTHERS THEN
330:

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

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

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

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;
340:
341:

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

392: VALUES (l_batch_id, P_BATCHSTEP_ID, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
393:
394: commit;
395:
396: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
397: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
398: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
399: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
400: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');

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

397: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
398: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
399: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
400: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
401: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
402: end if;
403:
404: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
405:

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

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
417: rollback;

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

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
417: rollback;
418: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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
428: rollback;

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

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
428: rollback;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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;
439:
440: --This procdeure would lock the (array) step and do an autonomous commit..

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

474:
475: 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)
476: VALUES (l_batch_id, l_batchstep_id, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
477:
478: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
479: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
480: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
481: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
482: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');

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

479: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
480: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
481: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
482: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
483: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
484: end if;
485:
486:
487: end loop;

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

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
504: rollback;

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

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
504: rollback;
505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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
515: rollback;

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

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
515: rollback;
516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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;
526:
527: --This procdeure would unlock the step.

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

561: DELETE FROM GMO_BATCH_STEP_LOCK_DETAILS WHERE BATCHSTEP_ID = P_BATCHSTEP_ID;
562:
563: commit;
564:
565: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
566: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
567: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
568: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
569: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');

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

566: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
567: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
568: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
569: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
571: end if;
572:
573:
574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
587: rollback;

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

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
587: rollback;
588: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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;
598:
599: --This procdeure would unlock the step.

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

637: 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);
638:
639: DELETE FROM GMO_BATCH_STEP_LOCK_DETAILS WHERE BATCHSTEP_ID = l_batchstep_id;
640:
641: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
642: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
643: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
644: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
645: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');

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

642: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
643: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
644: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
645: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
646: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
647: end if;
648:
649:
650: end loop;

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

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
667: rollback;

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

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
667: rollback;
668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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;
678:
679: -- this procedure returns the batch id for the entity

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

723: IF (l_batch_id is null) THEN
724: RAISE NO_BATCH_FOUND_ERR;
725: END IF;
726:
727: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
729: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
730: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
731: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);

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

728: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
729: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
730: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
731: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
732: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
733: end if;
734:
735: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
736: X_BATCH_ID := l_batch_id;

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

743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
747: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
748: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
749: end if;
750: WHEN GMO_INVALID_ENTITY_ERR THEN
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
747: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
748: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
749: end if;
750: WHEN GMO_INVALID_ENTITY_ERR THEN
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

753: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
757: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
758: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
759: end if;
760: WHEN OTHERS THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
757: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
758: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
759: end if;
760: WHEN OTHERS THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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

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

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;
771:
772: procedure GET_BATCHSTEP_ID_FOR_ENTITY (P_ENTITY_NAME IN VARCHAR2,

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

810: IF (l_batchstep_id is null) THEN
811: RAISE NO_BATCHSTEP_FOUND_ERR;
812: END IF;
813:
814: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
816: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
817: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
818: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);

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

815: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
816: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
817: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
818: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
820: end if;
821:
822:
823: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
837: end if;
838: WHEN GMO_INVALID_ENTITY_ERR THEN
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
837: end if;
838: WHEN GMO_INVALID_ENTITY_ERR THEN
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

841: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
845: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
846: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
847: end if;
848: WHEN OTHERS THEN
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
845: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
846: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
847: end if;
848: WHEN OTHERS THEN
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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

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

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;
859:
860: -- this function is internally used by the apis to

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

1254: l_invalid_entity_master.extend;
1255: l_invalid_entity_master (k) := l_entity_display_name;
1256: end if;
1257:
1258: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1259: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1260: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1261: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1262: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');

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

1260: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1261: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1262: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
1263: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
1264: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1265: end if;
1266:
1267: end loop;
1268: close c_get_steps;

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

1307: l_invalid_entity_master.extend;
1308: l_invalid_entity_master (k) := l_entity_display_name;
1309: end if;
1310:
1311: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1312: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1313: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1314: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1315: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');

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

1313: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1314: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1315: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
1316: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
1317: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1318: end if;
1319:
1320: end loop;
1321: close c_get_activities;

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

1360: l_invalid_entity_master.extend;
1361: l_invalid_entity_master (k) := l_entity_display_name;
1362: end if;
1363:
1364: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1365: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1366: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1367: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1368: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');

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

1366: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1367: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1368: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
1369: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
1370: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1371: end if;
1372:
1373: end loop;
1374: close c_get_resources;

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

1413: l_invalid_entity_master.extend;
1414: l_invalid_entity_master (k) := l_entity_display_name;
1415: end if;
1416:
1417: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1418: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1419: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1420: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1421: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');

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

1419: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1420: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1421: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');
1422: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);
1423: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1424: end if;
1425:
1426: end loop;
1427: close c_get_materials;

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

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
1445: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
1445: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1446: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

Line 1449: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
1453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
1453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1454: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_RECIPE');

Line 1457: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
1461: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
1461: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1462: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

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

1461: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1462: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1463: FND_MSG_PUB.ADD;
1464: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1465: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1466: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1467: end if;
1468: WHEN GMO_INVALID_ENTITY_ERR THEN
1469: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

1462: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1463: FND_MSG_PUB.ADD;
1464: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1465: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1466: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1467: end if;
1468: WHEN GMO_INVALID_ENTITY_ERR THEN
1469: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1470: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

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
1479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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
1479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1480: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');

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

1479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1480: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1481: FND_MSG_PUB.ADD;
1482: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1483: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1485: end if;
1486: WHEN OTHERS THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

1480: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');
1481: FND_MSG_PUB.ADD;
1482: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1483: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1485: end if;
1486: WHEN OTHERS THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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:
1497: END INSTANTIATE_ADVANCED_PI;

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

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:
1497: END INSTANTIATE_ADVANCED_PI;
1498:

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

1882: ELSE
1883: RAISE GMO_INVALID_TASK_ERR;
1884: END IF;
1885:
1886: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1887: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');
1888: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1896: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);
1897: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1899: end if;
1900:
1901: if (l_batch_id is null) then
1902: get_batch_id_for_entity

Line 1976: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
1980: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
1980: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1981: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;

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

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:
1989: WHEN GMO_INVALID_MODULE_ERR THEN

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

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:
1989: WHEN GMO_INVALID_MODULE_ERR THEN
1990: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1994: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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:
1998: WHEN GMO_INSTR_TASK_PARAM_ERR THEN

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

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:
1998: WHEN GMO_INSTR_TASK_PARAM_ERR THEN
1999: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 2003: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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:
2007: WHEN GMO_INVALID_TASK_ERR THEN

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

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:
2007: WHEN GMO_INVALID_TASK_ERR THEN
2008: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2015: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2016: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2017: end if;
2018: WHEN GMO_INVALID_ENTITY_ERR THEN
2019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2015: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2016: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2017: end if;
2018: WHEN GMO_INVALID_ENTITY_ERR THEN
2019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2020: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

2021: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2025: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2026: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2027: end if;
2028: WHEN OTHERS THEN
2029: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2025: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2026: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2027: end if;
2028: WHEN OTHERS THEN
2029: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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

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

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;
2039:
2040:

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

2094: 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
2095: RAISE GMO_INVALID_ENTITY_ERR;
2096: END IF;
2097:
2098: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

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

2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2103: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2104: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2105: end if;
2106:
2107:
2108: IF (P_ENTITY_NAME = GMO_CONSTANTS_GRP.ENTITY_BATCH) THEN

Line 2528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
2532: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
2532: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

Line 2536: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
2540: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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
2546: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

2544: end if;
2545: WHEN instruction_create_err then
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2548: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2549: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2550: end if;
2551: WHEN GMO_INVALID_ENTITY_ERR THEN
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2545: WHEN instruction_create_err then
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2548: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2549: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2550: end if;
2551: WHEN GMO_INVALID_ENTITY_ERR THEN
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

2554: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2558: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2560: end if;
2561: WHEN OTHERS THEN
2562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2558: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2560: end if;
2561: WHEN OTHERS THEN
2562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2563: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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

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

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;
2572:
2573:

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

2604: IF (NOT IS_BATCH_ENHANCED_PI (P_ENTITY_NAME => P_ENTITY_NAME, P_ENTITY_KEY => P_ENTITY_KEY) ) THEN
2605: RAISE GMO_NOT_ENHANCED_PI_ERR;
2606: END IF;
2607:
2608: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2609: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');
2610: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
2611: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2612: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

2611: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2612: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2613: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2614: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2616: end if;
2617:
2618:
2619: IF (P_FROM_MODULE = GMO_CONSTANTS_GRP.FROM_MODULE_PI) THEN

Line 2650: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
2654: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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
2660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
2660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2661: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

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

2660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2661: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2662: FND_MSG_PUB.ADD;
2663: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2664: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2665: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2666: end if;
2667: WHEN OTHERS THEN
2668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2661: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2662: FND_MSG_PUB.ADD;
2663: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2664: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2665: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2666: end if;
2667: WHEN OTHERS THEN
2668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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:
2678: END ON_TASK_SAVE;

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

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:
2678: END ON_TASK_SAVE;
2679:

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

2767: ELSE
2768: X_LOCK_ALLOWED := GMO_CONSTANTS_GRP.NO;
2769: END IF;
2770:
2771: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2772: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');
2773: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2774: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2776: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2777: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
2778: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);
2779: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2780: end if;
2781:
2782: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2783:

Line 2790: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
2794: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

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
2794: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2795: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

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

2794: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2795: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2796: FND_MSG_PUB.ADD;
2797: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2798: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2799: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2800: end if;
2801: WHEN NO_STEP_FOUND_ERR THEN
2802: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2795: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2796: FND_MSG_PUB.ADD;
2797: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2798: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2799: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2800: end if;
2801: WHEN NO_STEP_FOUND_ERR THEN
2802: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2803: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

2804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2808: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2809: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2810: end if;
2811: WHEN GMO_INVALID_ENTITY_ERR THEN
2812: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2808: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2809: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2810: end if;
2811: WHEN GMO_INVALID_ENTITY_ERR THEN
2812: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2813: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

2814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2818: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2820: end if;
2821: WHEN OTHERS THEN
2822: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2818: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2820: end if;
2821: WHEN OTHERS THEN
2822: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2823: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

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

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

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;
2832:
2833: --Bug 5224634: start

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

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

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

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;
3013:
3014: --Bug 5224634: end

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

3126: l_invalid_entity_master.extend;
3127: l_invalid_entity_master (k) := l_entity_display_name;
3128: end if;
3129:
3130: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3131: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3132: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3133: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3134: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');

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

3132: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3133: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3134: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
3135: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
3136: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3137: end if;
3138:
3139: end loop;
3140: close c_get_steps;

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

3179: l_invalid_entity_master.extend;
3180: l_invalid_entity_master (k) := l_entity_display_name;
3181: end if;
3182:
3183: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3184: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3185: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3186: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3187: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');

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

3185: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3186: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3187: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
3188: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3190: end if;
3191:
3192: end loop;
3193: close c_get_activities;

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

3232: l_invalid_entity_master.extend;
3233: l_invalid_entity_master (k) := l_entity_display_name;
3234: end if;
3235:
3236: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3238: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3239: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3240: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');

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

3238: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3239: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3240: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
3241: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
3242: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3243: end if;
3244:
3245: end loop;
3246: close c_get_resources;