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.GME_CLOSE_BATCH_PVT dependencies on GME_COMMON_PVT

Line 42: l_material_detail_ids gme_common_pvt.number_tab;

38: l_batch_step gme_batch_steps%ROWTYPE;
39: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
40: l_batch_header gme_batch_header%ROWTYPE;
41: l_in_batch_header gme_batch_header%ROWTYPE;
42: l_material_detail_ids gme_common_pvt.number_tab;
43: l_message_count NUMBER;
44: l_message_list VARCHAR2 (2000);
45: l_step_count NUMBER;
46: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 196: x_batch_header_rec.batch_close_date := gme_common_pvt.g_timestamp;

192: l_gmf_cost_alloc_calc := FND_PROFILE.VALUE('GMF_COST_ALLOC_CALC');
193:
194: /* If batch close date is not provided use sysdate */
195: IF p_batch_header_rec.batch_close_date IS NULL THEN
196: x_batch_header_rec.batch_close_date := gme_common_pvt.g_timestamp;
197: ELSE
198: x_batch_header_rec.batch_close_date :=
199: p_batch_header_rec.batch_close_date;
200: END IF;

Line 225: IF NOT gme_common_pvt.create_history

221: IF g_debug <= gme_debug.g_log_procedure THEN
222: gme_debug.put_line ('Calling Create History.');
223: END IF;
224:
225: IF NOT gme_common_pvt.create_history
226: (p_batch_header_rec => x_batch_header_rec
227: ,p_original_status => 3) THEN
228: RAISE batch_hist_insert_err;
229: END IF;

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

289: END LOOP;
290: END IF;
291:
292: /* Update the row who columns */
293: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
294: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
295: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
296:
297: /*siva FPBug#4684029 BEGIN

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

290: END IF;
291:
292: /* Update the row who columns */
293: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
294: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
295: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
296:
297: /*siva FPBug#4684029 BEGIN
298: calculate costs if dynamic allocation of cost is enabled through profile*/

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

291:
292: /* Update the row who columns */
293: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
294: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
295: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
296:
297: /*siva FPBug#4684029 BEGIN
298: calculate costs if dynamic allocation of cost is enabled through profile*/
299: IF l_gmf_cost_alloc_calc = 1 THEN

Line 370: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'

366: WHEN batch_header_fetch_error THEN
367: x_return_status := fnd_api.g_ret_sts_error;
368: WHEN invalid_batch_status THEN
369: x_return_status := fnd_api.g_ret_sts_error;
370: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
371: ,'PROCESS'
372: ,'Close');
373: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
374: x_return_status := fnd_api.g_ret_sts_error;

Line 375: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');

371: ,'PROCESS'
372: ,'Close');
373: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
374: x_return_status := fnd_api.g_ret_sts_error;
375: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
376: WHEN marked_for_deletion THEN
377: x_return_status := fnd_api.g_ret_sts_error;
378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
379: WHEN steps_not_closed THEN

Line 378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');

374: x_return_status := fnd_api.g_ret_sts_error;
375: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
376: WHEN marked_for_deletion THEN
377: x_return_status := fnd_api.g_ret_sts_error;
378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
379: WHEN steps_not_closed THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
382: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception

Line 381: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');

377: x_return_status := fnd_api.g_ret_sts_error;
378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
379: WHEN steps_not_closed THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
382: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
383: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
384: x_return_status := fnd_api.g_ret_sts_error;
385: WHEN batch_hist_insert_err THEN

Line 480: x_batch_tbl gme_common_pvt.number_tab;

476: FROM gme_material_details
477: START WITH batch_id = v_batch_id
478: CONNECT BY batch_id = PRIOR phantom_id;
479:
480: x_batch_tbl gme_common_pvt.number_tab;
481: x_batch_row gme_batch_header%ROWTYPE;
482: x_mat_cnt NUMBER;
483: x_rsrc_cnt NUMBER;
484: x_status VARCHAR2 (10);

Line 489: x_material_tbl gme_common_pvt.number_tab;

485: x_date DATE;
486: l_api_name CONSTANT VARCHAR2 (30) := 'CHECK_CLOSE_DATE';
487:
488:
489: x_material_tbl gme_common_pvt.number_tab;
490:
491: CURSOR cur_rsrc_txns (v_batch_id NUMBER)
492: IS
493: SELECT trans_date

Line 564: gme_common_pvt.log_message ('GME_CLOSE_STEP_DATE_ERR'

560:
561: IF (cur_batch_steps%FOUND) THEN
562: CLOSE cur_batch_steps;
563:
564: gme_common_pvt.log_message ('GME_CLOSE_STEP_DATE_ERR'
565: ,'D1'
566: ,fnd_date.date_to_displaydt (x_date) );
567: RETURN FALSE;
568: END IF;

Line 602: gme_common_pvt.log_message

598:
599: IF (cur_rsrc_txns%FOUND) THEN
600: CLOSE cur_rsrc_txns;
601:
602: gme_common_pvt.log_message
603: ('GME_CLOSE_RSRC_DATE_ERR'
604: ,'D1'
605: ,fnd_date.date_to_displaydt (x_date) );
606: RETURN FALSE;

Line 621: OPEN cur_inventory_txns (x_material_tbl (j),x_batch_tbl (i),gme_common_pvt.g_txn_source_type, gme_common_pvt.g_pairs_reversal_type );

617: CLOSE cur_get_materials;
618:
619: FOR j IN 1 .. x_material_tbl.COUNT LOOP
620: /* Check if the batch close date is greater than all completed inventory transaction dates */
621: OPEN cur_inventory_txns (x_material_tbl (j),x_batch_tbl (i),gme_common_pvt.g_txn_source_type, gme_common_pvt.g_pairs_reversal_type );
622:
623: FETCH cur_inventory_txns
624: INTO x_date;
625: IF (cur_inventory_txns%FOUND) THEN

Line 627: gme_common_pvt.log_message('GME_CLOSE_INVEN_DATE_ERR', 'D1', fnd_date.date_to_displayDT(X_date));

623: FETCH cur_inventory_txns
624: INTO x_date;
625: IF (cur_inventory_txns%FOUND) THEN
626: CLOSE cur_inventory_txns;
627: gme_common_pvt.log_message('GME_CLOSE_INVEN_DATE_ERR', 'D1', fnd_date.date_to_displayDT(X_date));
628: RETURN FALSE;
629: END IF;
630:
631: CLOSE cur_inventory_txns;

Line 647: gme_common_pvt.log_message ('GME_CLOSE_CMPLT_DATE_ERR'

643:
644: IF (cur_batch_cmplt_date%FOUND) THEN
645: CLOSE cur_batch_cmplt_date;
646:
647: gme_common_pvt.log_message ('GME_CLOSE_CMPLT_DATE_ERR'
648: ,'D1'
649: ,fnd_date.date_to_displaydt (x_date) );
650: RETURN FALSE;
651: END IF;