DBA Data[Home] [Help]

APPS.GME_REOPEN_BATCH_PVT dependencies on GME_COMMON_PVT

Line 78: l_phantom_ids gme_common_pvt.number_tab;

74: l_row_count NUMBER;
75: l_ins_history gme_batch_history%ROWTYPE;
76: l_material_details gme_material_details%ROWTYPE;
77: l_material_details_tab gme_reopen_batch_pvt.material_details_tab;
78: l_phantom_ids gme_common_pvt.number_tab;
79: l_batch_header gme_batch_header%ROWTYPE;
80: l_in_batch_header gme_batch_header%ROWTYPE;
81: l_dummy NUMBER;
82: l_message_count NUMBER;

Line 168: gme_common_pvt.log_message ('GME_API_ACTUAL_COST_DONE_ERROR');

164: -- Return an ERROR if the period is already closed
165:
166: -- STEP-5b: Validate the Actual Cost Indicator (2/2)
167: IF (is_period_open (p_batch_id => x_batch_header_rec.batch_id) ) THEN
168: gme_common_pvt.log_message ('GME_API_ACTUAL_COST_DONE_ERROR');
169: ELSE
170: RAISE batch_costed_and_period_closed;
171: END IF;
172:

Line 275: IF NOT gme_common_pvt.create_history

271: END IF;
272:
273: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
274: /* Insert the event into the batch history table */
275: IF NOT gme_common_pvt.create_history
276: (x_batch_header_rec
277: ,x_batch_header_rec.batch_status) THEN
278: RAISE batch_hist_insert_err;
279: END IF;

Line 289: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;

285: END IF;
286: END IF; */
287:
288: /* Update the row who columns */
289: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
290: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
291: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
292:
293:

Line 290: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;

286: END IF; */
287:
288: /* Update the row who columns */
289: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
290: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
291: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
292:
293:
294: --

Line 291: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;

287:
288: /* Update the row who columns */
289: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
290: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
291: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
292:
293:
294: --
295: -- Bug 5903208 - Make call to GMF to revert finalization layers for this batch

Line 328: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/

324: WHEN batch_cost_err THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: /* WHEN batch_header_locked_err THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
329: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: WHEN cant_reopen_migrated_batch THEN
332: x_return_status := fnd_api.g_ret_sts_error;

Line 333: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');

329: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: WHEN cant_reopen_migrated_batch THEN
332: x_return_status := fnd_api.g_ret_sts_error;
333: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
334: WHEN invalid_batch_type THEN
335: x_return_status := fnd_api.g_ret_sts_error;
336: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
337: WHEN invalid_batch_status THEN

Line 336: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');

332: x_return_status := fnd_api.g_ret_sts_error;
333: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
334: WHEN invalid_batch_type THEN
335: x_return_status := fnd_api.g_ret_sts_error;
336: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
337: WHEN invalid_batch_status THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
340: ,'PROCESS'

Line 339: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'

335: x_return_status := fnd_api.g_ret_sts_error;
336: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
337: WHEN invalid_batch_status THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
340: ,'PROCESS'
341: ,'Reopen');
342: /* WHEN batch_already_purged THEN
343: x_return_status := fnd_api.g_ret_sts_error;

Line 344: gme_common_pvt.log_message ('GME_API_TRANSACTIONS_PURGED');*/

340: ,'PROCESS'
341: ,'Reopen');
342: /* WHEN batch_already_purged THEN
343: x_return_status := fnd_api.g_ret_sts_error;
344: gme_common_pvt.log_message ('GME_API_TRANSACTIONS_PURGED');*/
345: WHEN batch_already_posted THEN
346: x_return_status := fnd_api.g_ret_sts_error;
347: gme_common_pvt.log_message ('GME_API_GL_POSTED');
348: WHEN batch_costed_and_period_closed THEN

Line 347: gme_common_pvt.log_message ('GME_API_GL_POSTED');

343: x_return_status := fnd_api.g_ret_sts_error;
344: gme_common_pvt.log_message ('GME_API_TRANSACTIONS_PURGED');*/
345: WHEN batch_already_posted THEN
346: x_return_status := fnd_api.g_ret_sts_error;
347: gme_common_pvt.log_message ('GME_API_GL_POSTED');
348: WHEN batch_costed_and_period_closed THEN
349: x_return_status := fnd_api.g_ret_sts_error;
350: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
351: /* WHEN marked_for_deletion THEN

Line 350: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');

346: x_return_status := fnd_api.g_ret_sts_error;
347: gme_common_pvt.log_message ('GME_API_GL_POSTED');
348: WHEN batch_costed_and_period_closed THEN
349: x_return_status := fnd_api.g_ret_sts_error;
350: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
351: /* WHEN marked_for_deletion THEN
352: x_return_status := fnd_api.g_ret_sts_error;
353: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
354: WHEN batch_step_reopen_err THEN

Line 353: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/

349: x_return_status := fnd_api.g_ret_sts_error;
350: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
351: /* WHEN marked_for_deletion THEN
352: x_return_status := fnd_api.g_ret_sts_error;
353: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
354: WHEN batch_step_reopen_err THEN
355: x_return_status := fnd_api.g_ret_sts_error;
356: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
357: WHEN batch_header_upd_err THEN

Line 356: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');

352: x_return_status := fnd_api.g_ret_sts_error;
353: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
354: WHEN batch_step_reopen_err THEN
355: x_return_status := fnd_api.g_ret_sts_error;
356: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
357: WHEN batch_header_upd_err THEN
358: x_return_status := fnd_api.g_ret_sts_error;
359: WHEN batch_hist_insert_err THEN
360: x_return_status := fnd_api.g_ret_sts_error;

Line 508: gme_common_pvt.log_message ('GME_API_COST_PERIOD_OPEN');

504: || ':'
505: || 'period Open, so Warning if the batch has been costed' );
506: END IF;
507:
508: gme_common_pvt.log_message ('GME_API_COST_PERIOD_OPEN');
509: RETURN TRUE;
510: EXCEPTION
511: WHEN period_not_found THEN
512: RETURN FALSE;