DBA Data[Home] [Help]

APPS.GME_REOPEN_BATCH_PVT dependencies on GME_COMMON_PVT

Line 73: l_phantom_ids gme_common_pvt.number_tab;

69: l_row_count NUMBER;
70: l_ins_history gme_batch_history%ROWTYPE;
71: l_material_details gme_material_details%ROWTYPE;
72: l_material_details_tab gme_reopen_batch_pvt.material_details_tab;
73: l_phantom_ids gme_common_pvt.number_tab;
74: l_batch_header gme_batch_header%ROWTYPE;
75: l_in_batch_header gme_batch_header%ROWTYPE;
76: l_dummy NUMBER;
77: l_message_count NUMBER;

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

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

Line 270: IF NOT gme_common_pvt.create_history

266: END IF;
267:
268: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
269: /* Insert the event into the batch history table */
270: IF NOT gme_common_pvt.create_history
271: (x_batch_header_rec
272: ,x_batch_header_rec.batch_status) THEN
273: RAISE batch_hist_insert_err;
274: END IF;

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

280: END IF;
281: END IF; */
282:
283: /* Update the row who columns */
284: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
285: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
286: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
287:
288:

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

281: END IF; */
282:
283: /* Update the row who columns */
284: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
285: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
286: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
287:
288:
289: --

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

282:
283: /* Update the row who columns */
284: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
285: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
286: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
287:
288:
289: --
290: -- Bug 5903208 - Make call to GMF to revert finalization layers for this batch

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

319: WHEN batch_cost_err THEN
320: x_return_status := fnd_api.g_ret_sts_error;
321: /* WHEN batch_header_locked_err THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: WHEN cant_reopen_migrated_batch THEN
327: x_return_status := fnd_api.g_ret_sts_error;

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

324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: WHEN cant_reopen_migrated_batch THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
329: WHEN invalid_batch_type THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
332: WHEN invalid_batch_status THEN

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

327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
329: WHEN invalid_batch_type THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
332: WHEN invalid_batch_status THEN
333: x_return_status := fnd_api.g_ret_sts_error;
334: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
335: ,'PROCESS'

Line 334: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'

330: x_return_status := fnd_api.g_ret_sts_error;
331: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
332: WHEN invalid_batch_status THEN
333: x_return_status := fnd_api.g_ret_sts_error;
334: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
335: ,'PROCESS'
336: ,'Reopen');
337: /* WHEN batch_already_purged THEN
338: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

338: x_return_status := fnd_api.g_ret_sts_error;
339: gme_common_pvt.log_message ('GME_API_TRANSACTIONS_PURGED');*/
340: WHEN batch_already_posted THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342: gme_common_pvt.log_message ('GME_API_GL_POSTED');
343: WHEN batch_costed_and_period_closed THEN
344: x_return_status := fnd_api.g_ret_sts_error;
345: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
346: /* WHEN marked_for_deletion THEN

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

341: x_return_status := fnd_api.g_ret_sts_error;
342: gme_common_pvt.log_message ('GME_API_GL_POSTED');
343: WHEN batch_costed_and_period_closed THEN
344: x_return_status := fnd_api.g_ret_sts_error;
345: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
346: /* WHEN marked_for_deletion THEN
347: x_return_status := fnd_api.g_ret_sts_error;
348: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
349: WHEN batch_step_reopen_err THEN

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

344: x_return_status := fnd_api.g_ret_sts_error;
345: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
346: /* WHEN marked_for_deletion THEN
347: x_return_status := fnd_api.g_ret_sts_error;
348: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
349: WHEN batch_step_reopen_err THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
352: WHEN batch_header_upd_err THEN

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

347: x_return_status := fnd_api.g_ret_sts_error;
348: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
349: WHEN batch_step_reopen_err THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
352: WHEN batch_header_upd_err THEN
353: x_return_status := fnd_api.g_ret_sts_error;
354: WHEN batch_hist_insert_err THEN
355: x_return_status := fnd_api.g_ret_sts_error;

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

482: || ':'
483: || 'period Open, so Warning if the batch has been costed' );
484: END IF;
485:
486: gme_common_pvt.log_message ('GME_API_COST_PERIOD_OPEN');
487: RETURN TRUE;
488: EXCEPTION
489: WHEN period_not_found THEN
490: RETURN FALSE;