DBA Data[Home] [Help]

APPS.GME_TERMINATE_BATCH_PVT dependencies on FND_API

Line 98: x_return_status := fnd_api.g_ret_sts_success;

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

Line 125: IF x_return_status <> fnd_api.g_ret_sts_success THEN

121: gme_trans_engine_util.load_rsrc_trans (x_batch_header_rec
122: ,l_rsrc_trans_count
123: ,x_return_status);
124:
125: IF x_return_status <> fnd_api.g_ret_sts_success THEN
126: RAISE error_load_trans;
127: END IF;
128: END IF; /* IF x_batch_header_rec.update_inventory_ind = 'Y' */
129:

Line 170: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 180: IF x_return_status <> fnd_api.g_ret_sts_success THEN

176: (p_batch_header_rec => l_in_batch_header_rec
177: ,x_batch_header_rec => l_batch_header_rec
178: ,x_return_status => x_return_status);
179:
180: IF x_return_status <> fnd_api.g_ret_sts_success THEN
181: RAISE phantom_batch_cancel_error;
182: END IF;
183: END IF; /* l_in_batch_header_rec.batch_status */
184: END IF; /* phantom_id <> 0 */

Line 196: IF x_return_status <> fnd_api.g_ret_sts_success THEN

192: ,p_delete_reservations => 'T'
193: ,p_delete_trans_pairs => 'F'
194: ,x_return_status => x_return_status);
195:
196: IF x_return_status <> fnd_api.g_ret_sts_success THEN
197: RAISE purge_exception_err;
198: END IF;
199: END IF;
200:

Line 241: P_INIT_MSG_LIST => FND_API.G_FALSE,

237: -- Pawan Kumar added for bug 5034336
238: -- before terminating the steps we need to check that they are locked
239: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
240: P_API_VERSION => 1.0,
241: P_INIT_MSG_LIST => FND_API.G_FALSE,
242: P_COMMIT => FND_API.G_FALSE,
243: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
244: X_RETURN_STATUS => x_return_status ,
245: X_MSG_COUNT => l_message_count,

Line 242: P_COMMIT => FND_API.G_FALSE,

238: -- before terminating the steps we need to check that they are locked
239: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
240: P_API_VERSION => 1.0,
241: P_INIT_MSG_LIST => FND_API.G_FALSE,
242: P_COMMIT => FND_API.G_FALSE,
243: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
244: X_RETURN_STATUS => x_return_status ,
245: X_MSG_COUNT => l_message_count,
246: X_MSG_DATA => l_message_list,

Line 243: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

239: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
240: P_API_VERSION => 1.0,
241: P_INIT_MSG_LIST => FND_API.G_FALSE,
242: P_COMMIT => FND_API.G_FALSE,
243: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
244: X_RETURN_STATUS => x_return_status ,
245: X_MSG_COUNT => l_message_count,
246: X_MSG_DATA => l_message_list,
247: P_ENTITY_NAME => 'OPERATION',

Line 254: IF x_return_status <> fnd_api.g_ret_sts_success THEN

250: X_LOCK_STATUS => l_lock_status,
251: X_LOCKED_BY_STATUS => l_locked_by_status,
252: X_LOCK_ALLOWED => l_lock_allowed);
253:
254: IF x_return_status <> fnd_api.g_ret_sts_success THEN
255: RAISE gmo_lock_error;
256: END IF;
257: IF (g_debug <= gme_debug.g_log_procedure) THEN
258: gme_debug.put_line ( g_pkg_name

Line 277: IF x_return_status <> fnd_api.g_ret_sts_success THEN

273: ,p_actual_cmplt_date => p_batch_header_rec.actual_cmplt_date
274: ,x_return_status => x_return_status
275: ,x_batch_step_rec => l_batch_step_rec);
276:
277: IF x_return_status <> fnd_api.g_ret_sts_success THEN
278: RAISE batch_step_terminate_error;
279: END IF;
280: END LOOP;
281:

Line 299: IF x_return_status <> fnd_api.g_ret_sts_success THEN

295: ,p_update_inventory_ind => x_batch_header_rec.update_inventory_ind
296: ,x_return_status => x_return_status
297: ,x_batch_step_rec => l_batch_step_rec);
298:
299: IF x_return_status <> fnd_api.g_ret_sts_success THEN
300: RAISE batch_step_cancel_error;
301: END IF;
302: END LOOP;
303: END IF;

Line 344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

340: ,x_msg_count => l_message_count
341: ,x_msg_data => l_message_list
342: ,x_return_status => x_return_status);
343:
344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
345: RAISE prod_supply_resv_err;
346: END IF;
347: -- 4944024 END
348:

Line 376: x_return_status := fnd_api.g_ret_sts_error;

372: || ':'
373: || ' purge_exception_err.');
374: END IF;
375:
376: x_return_status := fnd_api.g_ret_sts_error;
377: -- 4944024 BEGIN
378: WHEN prod_supply_resv_err THEN
379: IF (g_debug <= gme_debug.g_log_procedure) THEN
380: gme_debug.put_line ( g_pkg_name

Line 396: x_return_status := fnd_api.g_ret_sts_error;

392: || ':'
393: || ' MATL_DETAILS_FETCH_ERROR.');
394: END IF;
395:
396: x_return_status := fnd_api.g_ret_sts_error;
397: WHEN invalid_batch_status THEN
398: IF (g_debug <= gme_debug.g_log_procedure) THEN
399: gme_debug.put_line ( g_pkg_name
400: || '.'

Line 406: x_return_status := fnd_api.g_ret_sts_error;

402: || ':'
403: || 'INVALID_BATCH_STATUS.');
404: END IF;
405:
406: x_return_status := fnd_api.g_ret_sts_error;
407: gme_common_pvt.log_message ('GME_INVALID_BSTAT_TERM');
408: WHEN batch_header_upd_err THEN
409: IF (g_debug <= gme_debug.g_log_procedure) THEN
410: gme_debug.put_line ( g_pkg_name

Line 417: x_return_status := fnd_api.g_ret_sts_error;

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

Line 443: x_return_status := fnd_api.g_ret_sts_error;

439: || l_api_name
440: || ':'
441: || 'GMO_LOCK_ERROR.');
442: END IF;
443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN batch_hist_insert_err THEN
445: IF (g_debug <= gme_debug.g_log_procedure) THEN
446: gme_debug.put_line ('BATCH_HIST_INSERT_ERR.');
447: END IF;

Line 449: x_return_status := fnd_api.g_ret_sts_error;

445: IF (g_debug <= gme_debug.g_log_procedure) THEN
446: gme_debug.put_line ('BATCH_HIST_INSERT_ERR.');
447: END IF;
448:
449: x_return_status := fnd_api.g_ret_sts_error;
450: WHEN delete_inv_txns_err THEN
451: IF (g_debug <= gme_debug.g_log_procedure) THEN
452: gme_debug.put_line ( g_pkg_name
453: || '.'

Line 485: x_return_status := fnd_api.g_ret_sts_unexp_error;

481: || SQLERRM);
482: END IF;
483:
484: ROLLBACK TO SAVEPOINT cancel_batch_step;
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
487: END terminate_batch;
488:
489: /*===============================================================================