DBA Data[Home] [Help]

APPS.GME_TERMINATE_BATCH_PVT dependencies on FND_API

Line 102: x_return_status := fnd_api.g_ret_sts_success;

98: || 'Entering');
99: END IF;
100:
101: /* Set the success staus to success inititally*/
102: x_return_status := fnd_api.g_ret_sts_success;
103: /* Initialize output batch header */
104: x_batch_header_rec := p_batch_header_rec;
105: -- Now Examine the ingredient material rows :
106: l_material_details.batch_id := x_batch_header_rec.batch_id;

Line 129: IF x_return_status <> fnd_api.g_ret_sts_success THEN

125: gme_trans_engine_util.load_rsrc_trans (x_batch_header_rec
126: ,l_rsrc_trans_count
127: ,x_return_status);
128:
129: IF x_return_status <> fnd_api.g_ret_sts_success THEN
130: RAISE error_load_trans;
131: END IF;
132: END IF; /* IF x_batch_header_rec.update_inventory_ind = 'Y' */
133:

Line 174: IF x_return_status <> fnd_api.g_ret_sts_success THEN

170: (p_batch_header_rec => l_in_batch_header_rec
171: ,x_batch_header_rec => l_batch_header_rec
172: ,x_return_status => x_return_status);
173:
174: IF x_return_status <> fnd_api.g_ret_sts_success THEN
175: RAISE phantom_batch_terminate_error;
176: END IF;
177: ELSIF l_in_batch_header_rec.batch_status = 1 THEN
178: -- Call to cancel batch for the phantom

Line 184: IF x_return_status <> fnd_api.g_ret_sts_success THEN

180: (p_batch_header_rec => l_in_batch_header_rec
181: ,x_batch_header_rec => l_batch_header_rec
182: ,x_return_status => x_return_status);
183:
184: IF x_return_status <> fnd_api.g_ret_sts_success THEN
185: RAISE phantom_batch_cancel_error;
186: END IF;
187: END IF; /* l_in_batch_header_rec.batch_status */
188: END IF; /* phantom_id <> 0 */

Line 200: IF x_return_status <> fnd_api.g_ret_sts_success THEN

196: ,p_delete_reservations => 'T'
197: ,p_delete_trans_pairs => 'F'
198: ,x_return_status => x_return_status);
199:
200: IF x_return_status <> fnd_api.g_ret_sts_success THEN
201: RAISE purge_exception_err;
202: END IF;
203: END IF;
204:

Line 249: P_INIT_MSG_LIST => FND_API.G_FALSE,

245: -- Pawan Kumar added for bug 5034336
246: -- before terminating the steps we need to check that they are locked
247: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
248: P_API_VERSION => 1.0,
249: P_INIT_MSG_LIST => FND_API.G_FALSE,
250: P_COMMIT => FND_API.G_FALSE,
251: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
252: X_RETURN_STATUS => x_return_status ,
253: X_MSG_COUNT => l_message_count,

Line 250: P_COMMIT => FND_API.G_FALSE,

246: -- before terminating the steps we need to check that they are locked
247: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
248: P_API_VERSION => 1.0,
249: P_INIT_MSG_LIST => FND_API.G_FALSE,
250: P_COMMIT => FND_API.G_FALSE,
251: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
252: X_RETURN_STATUS => x_return_status ,
253: X_MSG_COUNT => l_message_count,
254: X_MSG_DATA => l_message_list,

Line 251: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

247: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
248: P_API_VERSION => 1.0,
249: P_INIT_MSG_LIST => FND_API.G_FALSE,
250: P_COMMIT => FND_API.G_FALSE,
251: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
252: X_RETURN_STATUS => x_return_status ,
253: X_MSG_COUNT => l_message_count,
254: X_MSG_DATA => l_message_list,
255: P_ENTITY_NAME => 'OPERATION',

Line 262: IF x_return_status <> fnd_api.g_ret_sts_success THEN

258: X_LOCK_STATUS => l_lock_status,
259: X_LOCKED_BY_STATUS => l_locked_by_status,
260: X_LOCK_ALLOWED => l_lock_allowed);
261:
262: IF x_return_status <> fnd_api.g_ret_sts_success THEN
263: RAISE gmo_lock_error;
264: END IF;
265:
266: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 288: IF x_return_status <> fnd_api.g_ret_sts_success THEN

284: ,p_actual_cmplt_date => p_batch_header_rec.actual_cmplt_date
285: ,x_return_status => x_return_status
286: ,x_batch_step_rec => l_batch_step_rec);
287:
288: IF x_return_status <> fnd_api.g_ret_sts_success THEN
289: RAISE batch_step_terminate_error;
290: END IF;
291: END LOOP;
292:

Line 310: IF x_return_status <> fnd_api.g_ret_sts_success THEN

306: ,p_update_inventory_ind => x_batch_header_rec.update_inventory_ind
307: ,x_return_status => x_return_status
308: ,x_batch_step_rec => l_batch_step_rec);
309:
310: IF x_return_status <> fnd_api.g_ret_sts_success THEN
311: RAISE batch_step_cancel_error;
312: END IF;
313: END LOOP;
314: END IF;

Line 355: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

351: ,x_msg_count => l_message_count
352: ,x_msg_data => l_message_list
353: ,x_return_status => x_return_status);
354:
355: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: RAISE prod_supply_resv_err;
357: END IF;
358: -- 4944024 END
359:

Line 387: x_return_status := fnd_api.g_ret_sts_error;

383: || ':'
384: || ' purge_exception_err.');
385: END IF;
386:
387: x_return_status := fnd_api.g_ret_sts_error;
388: -- 4944024 BEGIN
389: WHEN prod_supply_resv_err THEN
390: IF (g_debug <= gme_debug.g_log_procedure) THEN
391: gme_debug.put_line ( g_pkg_name

Line 407: x_return_status := fnd_api.g_ret_sts_error;

403: || ':'
404: || ' MATL_DETAILS_FETCH_ERROR.');
405: END IF;
406:
407: x_return_status := fnd_api.g_ret_sts_error;
408: WHEN invalid_batch_status THEN
409: IF (g_debug <= gme_debug.g_log_procedure) THEN
410: gme_debug.put_line ( g_pkg_name
411: || '.'

Line 417: x_return_status := fnd_api.g_ret_sts_error;

413: || ':'
414: || 'INVALID_BATCH_STATUS.');
415: END IF;
416:
417: x_return_status := fnd_api.g_ret_sts_error;
418: gme_common_pvt.log_message ('GME_INVALID_BSTAT_TERM');
419: WHEN batch_header_upd_err THEN
420: IF (g_debug <= gme_debug.g_log_procedure) THEN
421: gme_debug.put_line ( g_pkg_name

Line 428: x_return_status := fnd_api.g_ret_sts_error;

424: || ':'
425: || 'BATCH_HEADER_UPD_ERR.');
426: END IF;
427:
428: x_return_status := fnd_api.g_ret_sts_error;
429: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');
430: WHEN phantom_batch_terminate_error THEN
431: IF (g_debug <= gme_debug.g_log_procedure) THEN
432: gme_debug.put_line ( g_pkg_name

Line 454: x_return_status := fnd_api.g_ret_sts_error;

450: || l_api_name
451: || ':'
452: || 'GMO_LOCK_ERROR.');
453: END IF;
454: x_return_status := fnd_api.g_ret_sts_error;
455: WHEN batch_hist_insert_err THEN
456: IF (g_debug <= gme_debug.g_log_procedure) THEN
457: gme_debug.put_line ('BATCH_HIST_INSERT_ERR.');
458: END IF;

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456: IF (g_debug <= gme_debug.g_log_procedure) THEN
457: gme_debug.put_line ('BATCH_HIST_INSERT_ERR.');
458: END IF;
459:
460: x_return_status := fnd_api.g_ret_sts_error;
461: WHEN delete_inv_txns_err THEN
462: IF (g_debug <= gme_debug.g_log_procedure) THEN
463: gme_debug.put_line ( g_pkg_name
464: || '.'

Line 496: x_return_status := fnd_api.g_ret_sts_unexp_error;

492: || SQLERRM);
493: END IF;
494:
495: ROLLBACK TO SAVEPOINT cancel_batch_step;
496: x_return_status := fnd_api.g_ret_sts_unexp_error;
497: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
498: END terminate_batch;
499:
500: /*===============================================================================