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 55: l_material_detail_ids gme_common_pvt.number_tab;

51: l_batch_step gme_batch_steps%ROWTYPE;
52: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
53: l_batch_header gme_batch_header%ROWTYPE;
54: l_in_batch_header gme_batch_header%ROWTYPE;
55: l_material_detail_ids gme_common_pvt.number_tab;
56: l_message_count NUMBER;
57: l_message_list VARCHAR2 (2000);
58: l_step_count NUMBER;
59: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 96: l_material_details_tab gme_common_pvt.material_details_tab;

92: -- Bug 5903208
93: gmf_cost_failure EXCEPTION;
94:
95: -- Bug 10100973
96: l_material_details_tab gme_common_pvt.material_details_tab;
97: l_material_details_rec gme_material_details%ROWTYPE;
98: material_details_fetch_err EXCEPTION;
99:
100: -- Bug 10161288

Line 225: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type

221:
222: FOR i IN 1 .. l_material_details_tab.COUNT LOOP
223: DELETE FROM mtl_txn_request_lines l
224: WHERE organization_id = x_batch_header_rec.organization_id
225: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
226: AND txn_source_id = x_batch_header_rec.batch_id
227: AND txn_source_line_id = l_material_details_tab(i).material_detail_id
228: AND line_status = 7
229: AND NOT EXISTS (SELECT 1

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

277: l_gmf_cost_alloc_calc := FND_PROFILE.VALUE('GMF_COST_ALLOC_CALC');
278:
279: /* If batch close date is not provided use sysdate */
280: IF p_batch_header_rec.batch_close_date IS NULL THEN
281: x_batch_header_rec.batch_close_date := gme_common_pvt.g_timestamp;
282: ELSE
283: x_batch_header_rec.batch_close_date :=
284: p_batch_header_rec.batch_close_date;
285: END IF;

Line 310: IF NOT gme_common_pvt.create_history

306: IF g_debug <= gme_debug.g_log_procedure THEN
307: gme_debug.put_line ('Calling Create History.');
308: END IF;
309:
310: IF NOT gme_common_pvt.create_history
311: (p_batch_header_rec => x_batch_header_rec
312: ,p_original_status => 3) THEN
313: RAISE batch_hist_insert_err;
314: END IF;

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

374: END LOOP;
375: END IF;
376:
377: /* Update the row who columns */
378: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
379: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
380: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
381:
382: /*siva FPBug#4684029 BEGIN

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

375: END IF;
376:
377: /* Update the row who columns */
378: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
379: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
380: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
381:
382: /*siva FPBug#4684029 BEGIN
383: calculate costs if dynamic allocation of cost is enabled through profile*/

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

376:
377: /* Update the row who columns */
378: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
379: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
380: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
381:
382: /*siva FPBug#4684029 BEGIN
383: calculate costs if dynamic allocation of cost is enabled through profile*/
384: IF l_gmf_cost_alloc_calc = 1 THEN

Line 455: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'

451: WHEN batch_header_fetch_error THEN
452: x_return_status := fnd_api.g_ret_sts_error;
453: WHEN invalid_batch_status THEN
454: x_return_status := fnd_api.g_ret_sts_error;
455: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
456: ,'PROCESS'
457: ,'Close');
458: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
459: x_return_status := fnd_api.g_ret_sts_error;

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

456: ,'PROCESS'
457: ,'Close');
458: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
459: x_return_status := fnd_api.g_ret_sts_error;
460: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
461: WHEN marked_for_deletion THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
464: WHEN steps_not_closed THEN

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

459: x_return_status := fnd_api.g_ret_sts_error;
460: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
461: WHEN marked_for_deletion THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
464: WHEN steps_not_closed THEN
465: x_return_status := fnd_api.g_ret_sts_error;
466: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
467: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception

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

462: x_return_status := fnd_api.g_ret_sts_error;
463: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
464: WHEN steps_not_closed THEN
465: x_return_status := fnd_api.g_ret_sts_error;
466: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
467: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
468: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
469: x_return_status := fnd_api.g_ret_sts_error;
470: WHEN batch_hist_insert_err THEN

Line 584: x_batch_tbl gme_common_pvt.number_tab;

580: FROM gme_material_details
581: START WITH batch_id = v_batch_id
582: CONNECT BY batch_id = PRIOR phantom_id;
583:
584: x_batch_tbl gme_common_pvt.number_tab;
585: x_batch_row gme_batch_header%ROWTYPE;
586: x_mat_cnt NUMBER;
587: x_rsrc_cnt NUMBER;
588: x_status VARCHAR2 (10);

Line 593: x_material_tbl gme_common_pvt.number_tab;

589: x_date DATE;
590: l_api_name CONSTANT VARCHAR2 (30) := 'CHECK_CLOSE_DATE';
591:
592:
593: x_material_tbl gme_common_pvt.number_tab;
594:
595: CURSOR cur_rsrc_txns (v_batch_id NUMBER)
596: IS
597: SELECT trans_date

Line 668: gme_common_pvt.log_message ('GME_CLOSE_STEP_DATE_ERR'

664:
665: IF (cur_batch_steps%FOUND) THEN
666: CLOSE cur_batch_steps;
667:
668: gme_common_pvt.log_message ('GME_CLOSE_STEP_DATE_ERR'
669: ,'D1'
670: ,fnd_date.date_to_displaydt (x_date) );
671: RETURN FALSE;
672: END IF;

Line 706: gme_common_pvt.log_message

702:
703: IF (cur_rsrc_txns%FOUND) THEN
704: CLOSE cur_rsrc_txns;
705:
706: gme_common_pvt.log_message
707: ('GME_CLOSE_RSRC_DATE_ERR'
708: ,'D1'
709: ,fnd_date.date_to_displaydt (x_date) );
710: RETURN FALSE;

Line 725: 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 );

721: CLOSE cur_get_materials;
722:
723: FOR j IN 1 .. x_material_tbl.COUNT LOOP
724: /* Check if the batch close date is greater than all completed inventory transaction dates */
725: 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 );
726:
727: FETCH cur_inventory_txns
728: INTO x_date;
729: IF (cur_inventory_txns%FOUND) THEN

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

727: FETCH cur_inventory_txns
728: INTO x_date;
729: IF (cur_inventory_txns%FOUND) THEN
730: CLOSE cur_inventory_txns;
731: gme_common_pvt.log_message('GME_CLOSE_INVEN_DATE_ERR', 'D1', fnd_date.date_to_displayDT(X_date));
732: RETURN FALSE;
733: END IF;
734:
735: CLOSE cur_inventory_txns;

Line 751: gme_common_pvt.log_message ('GME_CLOSE_CMPLT_DATE_ERR'

747:
748: IF (cur_batch_cmplt_date%FOUND) THEN
749: CLOSE cur_batch_cmplt_date;
750:
751: gme_common_pvt.log_message ('GME_CLOSE_CMPLT_DATE_ERR'
752: ,'D1'
753: ,fnd_date.date_to_displaydt (x_date) );
754: RETURN FALSE;
755: END IF;