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_MESSAGE

Line 164: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_MSG');

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);
167: FND_MESSAGE.SET_TOKEN('MATERIAL_DETAIL_ID',P_MATERIAL_DETAIL_ID);
168: FND_MESSAGE.SET_TOKEN('RESERVED_QUANTITY',l_reserved_quantity);

Line 165: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);

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);
167: FND_MESSAGE.SET_TOKEN('MATERIAL_DETAIL_ID',P_MATERIAL_DETAIL_ID);
168: FND_MESSAGE.SET_TOKEN('RESERVED_QUANTITY',l_reserved_quantity);
169:

Line 166: FND_MESSAGE.SET_TOKEN('BATCH_ID',P_BATCH_ID);

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

Line 167: FND_MESSAGE.SET_TOKEN('MATERIAL_DETAIL_ID',P_MATERIAL_DETAIL_ID);

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

Line 168: FND_MESSAGE.SET_TOKEN('RESERVED_QUANTITY',l_reserved_quantity);

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

Line 178: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_ERR');

174:
175: EXCEPTION
176: WHEN MATERIAL_RESERVATION_ERR THEN
177:
178: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_ERR');
179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
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);

Line 179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);

175: EXCEPTION
176: WHEN MATERIAL_RESERVATION_ERR THEN
177:
178: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_ERR');
179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
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);

Line 180: FND_MESSAGE.SET_TOKEN('BATCH_ID',P_BATCH_ID);

176: WHEN MATERIAL_RESERVATION_ERR THEN
177:
178: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_ERR');
179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
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

Line 181: FND_MESSAGE.SET_TOKEN('MATERIAL_DETAIL_ID',P_MATERIAL_DETAIL_ID);

177:
178: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_ERR');
179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
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);

Line 182: FND_MESSAGE.SET_TOKEN('RESERVED_QUANTITY',l_reserved_quantity);

178: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_MAT_RSRV_QTY_ERR');
179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
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;

Line 183: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);

179: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
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;

Line 189: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 190: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

186: end if;
187: APP_EXCEPTION.RAISE_EXCEPTION;
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;

Line 191: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

187: APP_EXCEPTION.RAISE_EXCEPTION;
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;

Line 350: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');

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);
353: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
354: end if;

Line 351: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);

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);
353: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
354: end if;
355:

Line 352: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);

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

Line 363: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');

359: EXCEPTION
360: WHEN BATCH_SHORTAGE_ERR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362:
363: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
364: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
365: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
366: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
367: FND_MSG_PUB.ADD;

Line 364: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);

360: WHEN BATCH_SHORTAGE_ERR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362:
363: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
364: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
365: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
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);

Line 365: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);

361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362:
363: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
364: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
365: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
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:

Line 366: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);

362:
363: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
364: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
365: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
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

Line 377: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

373:
374: WHEN OTHERS THEN
375:
376: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

374: WHEN OTHERS THEN
375:
376: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 379: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

375:
376: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 442: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');

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');
446: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

Line 443: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);

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');
446: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
447: end if;

Line 444: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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');
446: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
447: end if;
448:

Line 445: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');

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

Line 455: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');

451: EXCEPTION
452: WHEN STEP_ALREADY_LOCKED_ERR THEN
453: rollback;
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);

Line 464: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

460: end if;
461: WHEN NO_BATCH_FOUND_ERR THEN
462: rollback;
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
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);

Line 465: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');

461: WHEN NO_BATCH_FOUND_ERR THEN
462: rollback;
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
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

Line 466: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);

462: rollback;
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
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);

Line 475: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

471: end if;
472: WHEN OTHERS THEN
473: rollback;
474: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 476: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

472: WHEN OTHERS THEN
473: rollback;
474: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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

Line 477: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

473: rollback;
474: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 524: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');

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');
528: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

Line 525: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);

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');
528: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
529: end if;

Line 526: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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');
528: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
529: end if;
530:

Line 527: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');

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');
528: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
529: end if;
530:
531:

Line 542: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');

538: EXCEPTION
539: WHEN STEP_ALREADY_LOCKED_ERR THEN
540: rollback;
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);

Line 551: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

547: end if;
548: WHEN NO_BATCH_FOUND_ERR THEN
549: rollback;
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
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);

Line 552: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');

548: WHEN NO_BATCH_FOUND_ERR THEN
549: rollback;
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
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

Line 553: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);

549: rollback;
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
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);

Line 562: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

558: end if;
559: WHEN OTHERS THEN
560: rollback;
561: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
562: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 563: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

559: WHEN OTHERS THEN
560: rollback;
561: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
562: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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

Line 564: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

560: rollback;
561: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
562: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 611: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');

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');
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

Line 612: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);

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');
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
616: end if;

Line 613: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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');
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
616: end if;
617:

Line 614: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');

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');
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
616: end if;
617:
618:

Line 625: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');

621: EXCEPTION
622: WHEN STEP_NOT_LOCKED_ERR THEN
623: rollback;
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);

Line 634: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

630: end if;
631: WHEN OTHERS THEN
632: rollback;
633: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 635: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

631: WHEN OTHERS THEN
632: rollback;
633: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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

Line 636: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

632: rollback;
633: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 687: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');

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');
691: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

Line 688: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);

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');
691: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
692: end if;

Line 689: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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');
691: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
692: end if;
693:

Line 690: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');

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');
691: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
692: end if;
693:
694:

Line 705: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');

701: EXCEPTION
702: WHEN STEP_NOT_LOCKED_ERR THEN
703: rollback;
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);

Line 714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

710: end if;
711: WHEN OTHERS THEN
712: rollback;
713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 715: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

711: WHEN OTHERS THEN
712: rollback;
713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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

Line 716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

712: rollback;
713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
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);

Line 773: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');

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);
777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

Line 774: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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);
777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
778: end if;

Line 775: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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);
777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
778: end if;
779:

Line 776: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);

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

Line 786: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');

782:
783: EXCEPTION
784: WHEN NO_BATCH_FOUND_ERR THEN
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
787: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
788: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
789: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
790: FND_MSG_PUB.ADD;

Line 787: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

783: EXCEPTION
784: WHEN NO_BATCH_FOUND_ERR THEN
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
787: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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);

Line 788: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

784: WHEN NO_BATCH_FOUND_ERR THEN
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
787: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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

Line 789: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');

785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
787: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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);

Line 797: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 798: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 799: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 807: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 808: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 809: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 860: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');

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);
864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

Line 861: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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);
864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
865: end if;

Line 862: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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);
864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
865: end if;
866:

Line 863: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);

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);
864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
865: end if;
866:
867:

Line 874: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');

870:
871: EXCEPTION
872: WHEN NO_BATCHSTEP_FOUND_ERR THEN
873: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
875: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
876: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
877: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
878: FND_MSG_PUB.ADD;

Line 875: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

871: EXCEPTION
872: WHEN NO_BATCHSTEP_FOUND_ERR THEN
873: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
875: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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);

Line 876: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

872: WHEN NO_BATCHSTEP_FOUND_ERR THEN
873: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
875: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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

Line 877: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');

873: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
875: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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);

Line 885: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 886: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 887: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 895: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 897: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 1304: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
1308: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);

Line 1305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 1306: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 1307: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');

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

Line 1308: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);

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

Line 1357: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
1361: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);

Line 1358: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 1359: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 1360: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');

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

Line 1361: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);

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

Line 1410: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
1414: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);

Line 1411: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 1412: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 1413: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');

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

Line 1414: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);

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

Line 1463: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
1467: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);

Line 1464: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 1465: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 1466: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');

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

Line 1467: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);

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

Line 1491: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

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

Line 1499: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_RECIPE');

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

Line 1507: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

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

Line 1515: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 1516: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 1517: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 1525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ATTR_ASSOC');

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

Line 1533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 1534: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 1535: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 1932: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');

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);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

Line 1933: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);

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);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

Line 1934: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);

Line 1935: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1939: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);

Line 1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

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);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1939: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1940: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);

Line 1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

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);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
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);

Line 1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);

1934: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1935: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
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);

Line 1939: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);

1935: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
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);

Line 1940: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);

1936: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
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;

Line 1941: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);

1937: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
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:

Line 1942: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);

1938: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
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

Line 2018: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

2014:
2015: EXCEPTION
2016: WHEN GMO_DISABLED_ERR 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);

Line 2027: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

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

Line 2036: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_MODULE');

2032: end if;
2033:
2034: WHEN GMO_INVALID_MODULE_ERR 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);

Line 2045: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_PARAM_ERR');

2041: end if;
2042:
2043: WHEN GMO_INSTR_TASK_PARAM_ERR 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);

Line 2054: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');

2050: end if;
2051:
2052: WHEN GMO_INVALID_TASK_ERR THEN
2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2054: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2055: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2056: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2057: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2058: FND_MSG_PUB.ADD;

Line 2055: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

2051:
2052: WHEN GMO_INVALID_TASK_ERR THEN
2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2054: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2055: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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);

Line 2056: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

2052: WHEN GMO_INVALID_TASK_ERR THEN
2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2054: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2055: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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

Line 2057: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

2053: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2054: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2055: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
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);

Line 2065: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 2066: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2067: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2075: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 2076: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 2077: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 2144: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');

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);
2148: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

Line 2145: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2146: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2147: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

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

Line 2148: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

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

Line 2570: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

2566:
2567: EXCEPTION
2568: WHEN GMO_DISABLED_ERR 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);

Line 2578: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

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

Line 2598: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 2599: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2600: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2608: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 2609: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 2610: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 2654: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');

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);
2658: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

Line 2655: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);

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);
2658: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2659: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

Line 2656: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2657: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2658: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);

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

Line 2659: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

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

Line 2692: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

2688:
2689: EXCEPTION
2690: WHEN GMO_NOT_ENHANCED_PI_ERR 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);

Line 2706: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

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

Line 2714: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 2715: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 2716: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 2817: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');

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);
2821: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);

Line 2818: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2819: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2820: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

Line 2821: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);

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

Line 2822: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);

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

Line 2823: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);

2819: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
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;

Line 2832: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');

2828:
2829: EXCEPTION
2830: WHEN GMO_NOT_ENHANCED_PI_ERR 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);

Line 2840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');

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

Line 2848: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 2849: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2850: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2858: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');

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

Line 2859: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);

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

Line 2860: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 2868: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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

Line 2869: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 2870: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

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

Line 3049: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');

3045:
3046: EXCEPTION
3047: WHEN OTHERS THEN
3048: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3049: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
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);

Line 3050: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

3046: EXCEPTION
3047: WHEN OTHERS THEN
3048: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3049: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
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

Line 3051: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

3047: WHEN OTHERS THEN
3048: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3049: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
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);

Line 3176: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
3180: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);

Line 3177: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 3178: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 3179: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');

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

Line 3180: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);

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

Line 3229: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
3233: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);

Line 3230: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 3231: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 3232: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');

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

Line 3233: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);

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

Line 3282: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');

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');
3286: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);

Line 3283: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_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');
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);

Line 3284: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);

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

Line 3285: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');

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

Line 3286: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);

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