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 305: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');

301: end if;
302:
303: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
304:
305: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_MSG');
306: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
307: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
308: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
309: end if;

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

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

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

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

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

314: EXCEPTION
315: WHEN BATCH_SHORTAGE_ERR THEN
316: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
319: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
320: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
321: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
322: FND_MSG_PUB.ADD;

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

315: WHEN BATCH_SHORTAGE_ERR THEN
316: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
319: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
320: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
321: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
322: FND_MSG_PUB.ADD;
323: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

316: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
319: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
320: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
321: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
322: FND_MSG_PUB.ADD;
323: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
324:

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

317:
318: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_MAT_AVBL_ERR');
319: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
320: FND_MESSAGE.SET_TOKEN('MATERIAL_AVAILABLE',l_material_available);
321: FND_MESSAGE.SET_TOKEN('GME_RETURN_STATUS', L_RETURN_STATUS);
322: FND_MSG_PUB.ADD;
323: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
324:
325: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

328:
329: WHEN OTHERS THEN
330:
331: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
335: FND_MSG_PUB.ADD;
336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

329: WHEN OTHERS THEN
330:
331: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
335: FND_MSG_PUB.ADD;
336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
337: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);

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

330:
331: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
335: FND_MSG_PUB.ADD;
336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
337: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.batchstep_material_available', FALSE);
338: end if;

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

393:
394: commit;
395:
396: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
397: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
398: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
399: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
400: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
401: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

394: commit;
395:
396: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
397: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
398: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
399: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
400: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
401: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
402: end if;

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

395:
396: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
397: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
398: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
399: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
400: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
401: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
402: end if;
403:

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

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

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

406: EXCEPTION
407: WHEN STEP_ALREADY_LOCKED_ERR THEN
408: rollback;
409: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
410: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
411: FND_MSG_PUB.ADD;
412: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
413: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

415: end if;
416: WHEN NO_BATCH_FOUND_ERR THEN
417: rollback;
418: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
420: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
421: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
422: FND_MSG_PUB.ADD;
423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

416: WHEN NO_BATCH_FOUND_ERR THEN
417: rollback;
418: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
420: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
421: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
422: FND_MSG_PUB.ADD;
423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
424: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

417: rollback;
418: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
420: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
421: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_BATCHSTEP_ID);
422: FND_MSG_PUB.ADD;
423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
424: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
425: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

426: end if;
427: WHEN OTHERS THEN
428: rollback;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
430: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

427: WHEN OTHERS THEN
428: rollback;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
430: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

428: rollback;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
430: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

475: INSERT into GMO_BATCH_STEP_LOCK_DETAILS (BATCH_ID, BATCHSTEP_ID, LOCK_REQUESTER, LOCK_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
476: VALUES (l_batch_id, l_batchstep_id, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
477:
478: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
479: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
480: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
481: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
482: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
483: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

476: VALUES (l_batch_id, l_batchstep_id, P_REQUESTER, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.LOGIN_ID);
477:
478: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
479: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
480: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
481: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
482: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
483: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
484: end if;

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

477:
478: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
479: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCKSTEP_REQ_MSG');
480: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
481: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
482: FND_MESSAGE.SET_TOKEN('REQUEST','LOCK');
483: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);
484: end if;
485:

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

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

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

493: EXCEPTION
494: WHEN STEP_ALREADY_LOCKED_ERR THEN
495: rollback;
496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
497: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_LOCK_ERR');
498: FND_MSG_PUB.ADD;
499: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
500: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
501: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

502: end if;
503: WHEN NO_BATCH_FOUND_ERR THEN
504: rollback;
505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
506: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
507: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
508: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
509: FND_MSG_PUB.ADD;
510: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

503: WHEN NO_BATCH_FOUND_ERR THEN
504: rollback;
505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
506: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
507: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
508: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
509: FND_MSG_PUB.ADD;
510: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
511: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

504: rollback;
505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
506: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
507: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','OPERATION');
508: FND_MESSAGE.SET_TOKEN('ENTITY_KEY', l_batchstep_id);
509: FND_MSG_PUB.ADD;
510: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
511: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
512: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

513: end if;
514: WHEN OTHERS THEN
515: rollback;
516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
518: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
519: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
520: FND_MSG_PUB.ADD;
521: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

514: WHEN OTHERS THEN
515: rollback;
516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
518: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
519: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
520: FND_MSG_PUB.ADD;
521: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

515: rollback;
516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
518: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
519: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
520: FND_MSG_PUB.ADD;
521: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
523: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.lock_step', FALSE);

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

562:
563: commit;
564:
565: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
566: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
567: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
568: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
569: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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

563: commit;
564:
565: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
566: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
567: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
568: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
569: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
571: end if;

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

564:
565: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
566: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCKSTEP_REQ_MSG');
567: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',P_BATCHSTEP_ID);
568: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
569: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
571: end if;
572:

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

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

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

576: EXCEPTION
577: WHEN STEP_NOT_LOCKED_ERR THEN
578: rollback;
579: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
580: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
581: FND_MSG_PUB.ADD;
582: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
583: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
584: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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

585: end if;
586: WHEN OTHERS THEN
587: rollback;
588: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
590: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
591: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
592: FND_MSG_PUB.ADD;
593: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

586: WHEN OTHERS THEN
587: rollback;
588: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
590: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
591: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
592: FND_MSG_PUB.ADD;
593: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
594: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

587: rollback;
588: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
590: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
591: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
592: FND_MSG_PUB.ADD;
593: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
594: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
595: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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

638:
639: DELETE FROM GMO_BATCH_STEP_LOCK_DETAILS WHERE BATCHSTEP_ID = l_batchstep_id;
640:
641: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
642: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
643: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
644: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
645: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
646: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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

639: DELETE FROM GMO_BATCH_STEP_LOCK_DETAILS WHERE BATCHSTEP_ID = l_batchstep_id;
640:
641: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
642: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
643: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
644: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
645: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
646: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
647: end if;

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

640:
641: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
642: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_STEP_REQ_MSG');
643: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
644: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
645: FND_MESSAGE.SET_TOKEN('REQUEST','UNLOCK');
646: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);
647: end if;
648:

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

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

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

656: EXCEPTION
657: WHEN STEP_NOT_LOCKED_ERR THEN
658: rollback;
659: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
660: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNLOCK_ERR');
661: FND_MSG_PUB.ADD;
662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
663: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
664: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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

665: end if;
666: WHEN OTHERS THEN
667: rollback;
668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

666: WHEN OTHERS THEN
667: rollback;
668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

667: rollback;
668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
675: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.unlock_step', FALSE);

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

724: RAISE NO_BATCH_FOUND_ERR;
725: END IF;
726:
727: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
729: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
730: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
731: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
732: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

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

725: END IF;
726:
727: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
729: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
730: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
731: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
732: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
733: end if;

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

726:
727: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
729: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
730: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
731: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
732: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
733: end if;
734:

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

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

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

737:
738: EXCEPTION
739: WHEN NO_BATCH_FOUND_ERR THEN
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
742: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;

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

738: EXCEPTION
739: WHEN NO_BATCH_FOUND_ERR THEN
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
742: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

739: WHEN NO_BATCH_FOUND_ERR THEN
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
742: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
747: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
742: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
743: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
744: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCH_ID');
745: FND_MSG_PUB.ADD;
746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
747: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
748: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

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

748: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
749: end if;
750: WHEN GMO_INVALID_ENTITY_ERR THEN
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
753: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

749: end if;
750: WHEN GMO_INVALID_ENTITY_ERR THEN
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
753: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
757: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

750: WHEN GMO_INVALID_ENTITY_ERR THEN
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
753: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
754: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
757: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
758: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

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

758: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);
759: end if;
760: WHEN OTHERS THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
763: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
764: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
765: FND_MSG_PUB.ADD;
766: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

759: end if;
760: WHEN OTHERS THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
763: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
764: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
765: FND_MSG_PUB.ADD;
766: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
767: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

760: WHEN OTHERS THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
763: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
764: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
765: FND_MSG_PUB.ADD;
766: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
767: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
768: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batch_id_for_entity', FALSE);

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

811: RAISE NO_BATCHSTEP_FOUND_ERR;
812: END IF;
813:
814: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
816: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
817: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
818: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

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

812: END IF;
813:
814: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
816: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
817: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
818: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
820: end if;

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

813:
814: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_BATCH_MSG');
816: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
817: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
818: FND_MESSAGE.SET_TOKEN('BATCHSTEP_ID',l_batchstep_id);
819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
820: end if;
821:

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

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

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

825:
826: EXCEPTION
827: WHEN NO_BATCHSTEP_FOUND_ERR THEN
828: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
830: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;

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

826: EXCEPTION
827: WHEN NO_BATCHSTEP_FOUND_ERR THEN
828: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
830: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

827: WHEN NO_BATCHSTEP_FOUND_ERR THEN
828: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
830: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

828: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY_OPRN');
830: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
831: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
832: FND_MESSAGE.SET_TOKEN('OPRN','GET_BATCHSTEP_ID');
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
835: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

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

836: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
837: end if;
838: WHEN GMO_INVALID_ENTITY_ERR THEN
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
841: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

837: end if;
838: WHEN GMO_INVALID_ENTITY_ERR THEN
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
841: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
845: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

838: WHEN GMO_INVALID_ENTITY_ERR THEN
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
841: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
842: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
843: FND_MSG_PUB.ADD;
844: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
845: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
846: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

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

846: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);
847: end if;
848: WHEN OTHERS THEN
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
851: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
853: FND_MSG_PUB.ADD;
854: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

847: end if;
848: WHEN OTHERS THEN
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
851: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
853: FND_MSG_PUB.ADD;
854: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
855: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

848: WHEN OTHERS THEN
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
851: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
853: FND_MSG_PUB.ADD;
854: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
855: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
856: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_id_for_entity', FALSE);

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

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

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

1256: end if;
1257:
1258: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1259: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1260: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1261: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1262: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
1263: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
1264: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

1257:
1258: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1259: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1260: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1261: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1262: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
1263: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
1264: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1265: end if;

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

1258: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1259: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1260: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1261: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1262: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
1263: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
1264: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1265: end if;
1266:

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

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

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

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

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

1309: end if;
1310:
1311: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1312: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1313: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1314: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1315: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
1316: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
1317: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

1310:
1311: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1312: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1313: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1314: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1315: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
1316: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
1317: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1318: end if;

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

1311: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1312: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1313: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1314: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1315: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
1316: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
1317: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1318: end if;
1319:

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

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

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

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

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

1362: end if;
1363:
1364: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1365: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1366: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1367: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1368: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
1369: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
1370: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

1363:
1364: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1365: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1366: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1367: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1368: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
1369: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
1370: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1371: end if;

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

1364: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1365: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1366: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1367: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1368: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
1369: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
1370: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1371: end if;
1372:

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

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

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

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

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

1415: end if;
1416:
1417: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1418: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1419: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1420: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1421: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');
1422: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);
1423: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

1416:
1417: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1418: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1419: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1420: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1421: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');
1422: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);
1423: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1424: end if;

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

1417: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1418: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
1419: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1420: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1421: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','MATERIAL');
1422: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_material_detail_id);
1423: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1424: end if;
1425:

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

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

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

1442: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1443: end if;
1444: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1445: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1446: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1447: FND_MSG_PUB.ADD;
1448: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1449: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1450: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

1450: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1451: end if;
1452: WHEN GMO_INVALID_RECIPE_ERR THEN
1453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1454: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_RECIPE');
1455: FND_MSG_PUB.ADD;
1456: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1457: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1458: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

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

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

1466: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1467: end if;
1468: WHEN GMO_INVALID_ENTITY_ERR THEN
1469: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1470: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
1471: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1472: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

1467: end if;
1468: WHEN GMO_INVALID_ENTITY_ERR THEN
1469: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1470: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
1471: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1472: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1475: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

1468: WHEN GMO_INVALID_ENTITY_ERR THEN
1469: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1470: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
1471: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1472: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1475: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1476: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

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

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

1484: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
1485: end if;
1486: WHEN OTHERS THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1489: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1490: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1491: FND_MSG_PUB.ADD;
1492: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

1485: end if;
1486: WHEN OTHERS THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1489: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1490: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1491: FND_MSG_PUB.ADD;
1492: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

1486: WHEN OTHERS THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1489: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1490: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1491: FND_MSG_PUB.ADD;
1492: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

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

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

1884: END IF;
1885:
1886: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1887: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');
1888: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

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

1885:
1886: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1887: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');
1888: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);

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

1886: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1887: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');
1888: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);

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

1887: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_LOAD_MSG');
1888: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);

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

1888: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1896: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);

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

1889: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1896: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);
1897: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);

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

1890: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1896: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);
1897: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

1891: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1896: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);
1897: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1899: end if;

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

1892: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
1893: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_NAME',X_TASK_ENTITY_NAME);
1894: FND_MESSAGE.SET_TOKEN('TASK_ENTITY_KEY',X_TASK_ENTITY_KEY);
1895: FND_MESSAGE.SET_TOKEN('TASK_NAME',X_TASK_NAME);
1896: FND_MESSAGE.SET_TOKEN('TASK_KEY',X_TASK_KEY);
1897: FND_MESSAGE.SET_TOKEN('READ_ONLY',X_READ_ONLY);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
1899: end if;
1900:

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

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

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

1969:
1970: EXCEPTION
1971: WHEN GMO_DISABLED_ERR THEN
1972: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1973: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
1974: FND_MSG_PUB.ADD;
1975: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1976: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1977: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

1978: end if;
1979: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
1980: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1981: X_READ_ONLY := GMO_CONSTANTS_GRP.READ_ONLY_NO;
1982: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
1983: FND_MSG_PUB.ADD;
1984: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1985: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1986: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

1987: end if;
1988:
1989: WHEN GMO_INVALID_MODULE_ERR THEN
1990: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1991: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_MODULE');
1992: FND_MSG_PUB.ADD;
1993: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1994: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1995: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

1996: end if;
1997:
1998: WHEN GMO_INSTR_TASK_PARAM_ERR THEN
1999: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2000: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_PARAM_ERR');
2001: FND_MSG_PUB.ADD;
2002: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2003: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

2005: end if;
2006:
2007: WHEN GMO_INVALID_TASK_ERR THEN
2008: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2009: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2010: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;

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

2006:
2007: WHEN GMO_INVALID_TASK_ERR THEN
2008: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2009: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2010: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2007: WHEN GMO_INVALID_TASK_ERR THEN
2008: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2009: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2010: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2015: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2008: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2009: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_TASK');
2010: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2011: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2012: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2013: FND_MSG_PUB.ADD;
2014: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2015: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2016: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

2016: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2017: end if;
2018: WHEN GMO_INVALID_ENTITY_ERR THEN
2019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2020: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2021: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2017: end if;
2018: WHEN GMO_INVALID_ENTITY_ERR THEN
2019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2020: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2021: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2025: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2018: WHEN GMO_INVALID_ENTITY_ERR THEN
2019: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2020: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2021: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2022: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2023: FND_MSG_PUB.ADD;
2024: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2025: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2026: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

2026: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);
2027: end if;
2028: WHEN OTHERS THEN
2029: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2033: FND_MSG_PUB.ADD;
2034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2027: end if;
2028: WHEN OTHERS THEN
2029: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2033: FND_MSG_PUB.ADD;
2034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2035: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2028: WHEN OTHERS THEN
2029: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2033: FND_MSG_PUB.ADD;
2034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2035: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2036: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_load', FALSE);

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

2095: RAISE GMO_INVALID_ENTITY_ERR;
2096: END IF;
2097:
2098: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2103: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

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

2096: END IF;
2097:
2098: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2103: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2104: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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

2097:
2098: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2103: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2104: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2105: end if;

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

2098: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2099: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2103: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2104: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2105: end if;
2106:

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

2099: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_ACTION_MSG');
2100: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2101: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2102: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2103: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2104: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2105: end if;
2106:
2107:

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

2521:
2522: EXCEPTION
2523: WHEN GMO_DISABLED_ERR THEN
2524: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2525: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_DISABLED_ERR');
2526: FND_MSG_PUB.ADD;
2527: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2528: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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

2529: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2530: end if;
2531: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2532: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2533: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2534: FND_MSG_PUB.ADD;
2535: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2536: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2537: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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

2549: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2550: end if;
2551: WHEN GMO_INVALID_ENTITY_ERR THEN
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2554: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2550: end if;
2551: WHEN GMO_INVALID_ENTITY_ERR THEN
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2554: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2558: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2551: WHEN GMO_INVALID_ENTITY_ERR THEN
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2554: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2555: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2556: FND_MSG_PUB.ADD;
2557: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2558: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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

2559: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);
2560: end if;
2561: WHEN OTHERS THEN
2562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2563: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2564: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2565: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2566: FND_MSG_PUB.ADD;
2567: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2560: end if;
2561: WHEN OTHERS THEN
2562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2563: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2564: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2565: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2566: FND_MSG_PUB.ADD;
2567: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2568: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2561: WHEN OTHERS THEN
2562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2563: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2564: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2565: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2566: FND_MSG_PUB.ADD;
2567: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2568: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2569: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_action', FALSE);

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

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

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

2606: END IF;
2607:
2608: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2609: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');
2610: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
2611: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2612: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2613: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2614: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);

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

2607:
2608: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2609: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');
2610: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
2611: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2612: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2613: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2614: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

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

2608: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2609: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');
2610: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
2611: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2612: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2613: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2614: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2616: end if;

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

2609: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ON_TASK_SAVE_MSG');
2610: FND_MESSAGE.SET_TOKEN('FROM_MODULE',P_FROM_MODULE);
2611: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2612: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2613: FND_MESSAGE.SET_TOKEN('TASK',P_TASK);
2614: FND_MESSAGE.SET_TOKEN('TASK_ATTRIBUTE',P_TASK_ATTRIBUTE);
2615: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2616: end if;
2617:

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

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

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

2643:
2644: EXCEPTION
2645: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2646: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2647: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2648: FND_MSG_PUB.ADD;
2649: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2650: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2651: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

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

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

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

2665: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);
2666: end if;
2667: WHEN OTHERS THEN
2668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2672: FND_MSG_PUB.ADD;
2673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2666: end if;
2667: WHEN OTHERS THEN
2668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2672: FND_MSG_PUB.ADD;
2673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2667: WHEN OTHERS THEN
2668: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2669: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2670: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2671: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2672: FND_MSG_PUB.ADD;
2673: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2675: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.on_task_save', FALSE);

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

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

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

2769: END IF;
2770:
2771: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2772: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');
2773: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2774: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2776: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2777: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);

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

2770:
2771: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2772: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');
2773: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2774: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2776: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2777: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
2778: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);

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

2771: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2772: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');
2773: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2774: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2776: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2777: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
2778: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);
2779: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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

2772: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_ENTITY_LOCK_MSG');
2773: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2774: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2776: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2777: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
2778: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);
2779: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2780: end if;

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

2773: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2774: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2775: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
2776: FND_MESSAGE.SET_TOKEN('LOCK_STATUS',X_LOCK_STATUS);
2777: FND_MESSAGE.SET_TOKEN('LOCKED_BY_STATUS',X_LOCKED_BY_STATUS);
2778: FND_MESSAGE.SET_TOKEN('LOCK_ALLOWED',X_LOCK_ALLOWED);
2779: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2780: end if;
2781:

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

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

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

2783:
2784: EXCEPTION
2785: WHEN GMO_NOT_ENHANCED_PI_ERR THEN
2786: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2787: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_NOT_ENHANCED_PI_ERR');
2788: FND_MSG_PUB.ADD;
2789: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2790: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2791: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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

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

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

2799: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2800: end if;
2801: WHEN NO_STEP_FOUND_ERR THEN
2802: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2803: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2800: end if;
2801: WHEN NO_STEP_FOUND_ERR THEN
2802: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2803: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2808: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2801: WHEN NO_STEP_FOUND_ERR THEN
2802: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2803: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2804: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2805: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2806: FND_MSG_PUB.ADD;
2807: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2808: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2809: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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

2809: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2810: end if;
2811: WHEN GMO_INVALID_ENTITY_ERR THEN
2812: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2813: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2810: end if;
2811: WHEN GMO_INVALID_ENTITY_ERR THEN
2812: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2813: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2818: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2811: WHEN GMO_INVALID_ENTITY_ERR THEN
2812: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2813: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INVALID_ENTITY');
2814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
2815: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
2816: FND_MSG_PUB.ADD;
2817: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2818: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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

2819: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);
2820: end if;
2821: WHEN OTHERS THEN
2822: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2823: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2824: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2825: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2826: FND_MSG_PUB.ADD;
2827: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

2820: end if;
2821: WHEN OTHERS THEN
2822: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2823: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2824: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2825: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2826: FND_MSG_PUB.ADD;
2827: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2828: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

2821: WHEN OTHERS THEN
2822: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2823: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
2824: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2825: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
2826: FND_MSG_PUB.ADD;
2827: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2828: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2829: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_entity_lock_status', FALSE);

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

3000:
3001: EXCEPTION
3002: WHEN OTHERS THEN
3003: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3004: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
3005: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3006: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3007: FND_MSG_PUB.ADD;
3008: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

3001: EXCEPTION
3002: WHEN OTHERS THEN
3003: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3004: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
3005: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3006: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3007: FND_MSG_PUB.ADD;
3008: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
3009: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

3002: WHEN OTHERS THEN
3003: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3004: FND_MESSAGE.SET_NAME('GMO','GET_BATCHSTEP_NODES');
3005: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
3006: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
3007: FND_MSG_PUB.ADD;
3008: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
3009: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3010: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_pvt.get_batchstep_nodes', FALSE);

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

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

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

3128: end if;
3129:
3130: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3131: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3132: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3133: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3134: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
3135: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
3136: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

3129:
3130: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3131: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3132: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3133: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3134: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
3135: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
3136: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3137: end if;

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

3130: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3131: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3132: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3133: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3134: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','STEP');
3135: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_id);
3136: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3137: end if;
3138:

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

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

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

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

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

3181: end if;
3182:
3183: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3184: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3185: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3186: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3187: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
3188: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

3182:
3183: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3184: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3185: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3186: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3187: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
3188: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3190: end if;

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

3183: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3184: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3185: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3186: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3187: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','ACTIVITY');
3188: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_activity_id);
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3190: end if;
3191:

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

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

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

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

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

3234: end if;
3235:
3236: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3238: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3239: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3240: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
3241: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
3242: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);

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

3235:
3236: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3238: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3239: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3240: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
3241: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
3242: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3243: end if;

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

3236: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_INSTR_CREATE_MSG');
3238: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',P_ENTITY_NAME);
3239: FND_MESSAGE.SET_TOKEN('ENTITY_KEY',P_ENTITY_KEY);
3240: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_NAME','RESOURCE');
3241: FND_MESSAGE.SET_TOKEN('INSTR_ENTITY_KEY',l_batchstep_resource_id);
3242: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_vbatch_pvt.instantiate_advanced_pi', FALSE);
3243: end if;
3244:

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

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