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.ECEPOI dependencies on EC_DEBUG

Line 25: ec_debug.enable_debug(i_debug_mode);

21: cEnabled VARCHAR2(1) := 'Y';
22: ece_transaction_disabled EXCEPTION;
23:
24: begin
25: ec_debug.enable_debug(i_debug_mode);
26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);

Line 26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);

22: ece_transaction_disabled EXCEPTION;
23:
24: begin
25: ec_debug.enable_debug(i_debug_mode);
26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);

Line 27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');

23:
24: begin
25: ec_debug.enable_debug(i_debug_mode);
26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);

Line 28: ec_debug.pl(3,'i_file_path',i_file_path);

24: begin
25: ec_debug.enable_debug(i_debug_mode);
26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

Line 29: ec_debug.pl(3,'i_file_name',i_file_name);

25: ec_debug.enable_debug(i_debug_mode);
26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
33: ec_debug.pl(3,'i_num_instances',i_num_instances);

Line 30: ec_debug.pl(3,'i_run_import',i_run_import);

26: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',i_transaction_type);
27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
33: ec_debug.pl(3,'i_num_instances',i_num_instances);
34: ec_debug.pl(3,'i_data_file_characterset',i_data_file_characterset);

Line 31: ec_debug.pl(3,'i_map_id',i_map_id);

27: ec_debug.push('ECEPOI.PROCESS_POI_INBOUND');
28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
33: ec_debug.pl(3,'i_num_instances',i_num_instances);
34: ec_debug.pl(3,'i_data_file_characterset',i_data_file_characterset);
35: /* Check to see if the transaction is enabled. If not, abort */

Line 32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);

28: ec_debug.pl(3,'i_file_path',i_file_path);
29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
33: ec_debug.pl(3,'i_num_instances',i_num_instances);
34: ec_debug.pl(3,'i_data_file_characterset',i_data_file_characterset);
35: /* Check to see if the transaction is enabled. If not, abort */
36: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);

Line 33: ec_debug.pl(3,'i_num_instances',i_num_instances);

29: ec_debug.pl(3,'i_file_name',i_file_name);
30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
33: ec_debug.pl(3,'i_num_instances',i_num_instances);
34: ec_debug.pl(3,'i_data_file_characterset',i_data_file_characterset);
35: /* Check to see if the transaction is enabled. If not, abort */
36: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
37: IF cEnabled = 'N' THEN

Line 34: ec_debug.pl(3,'i_data_file_characterset',i_data_file_characterset);

30: ec_debug.pl(3,'i_run_import',i_run_import);
31: ec_debug.pl(3,'i_map_id',i_map_id);
32: ec_debug.pl(3,'i_debug_mode',i_debug_mode);
33: ec_debug.pl(3,'i_num_instances',i_num_instances);
34: ec_debug.pl(3,'i_data_file_characterset',i_data_file_characterset);
35: /* Check to see if the transaction is enabled. If not, abort */
36: fnd_profile.get('ECE_' || i_transaction_type || '_ENABLED',cEnabled);
37: IF cEnabled = 'N' THEN
38: RAISE ece_transaction_disabled;

Line 41: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);

37: IF cEnabled = 'N' THEN
38: RAISE ece_transaction_disabled;
39: END IF;
40:
41: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',i_transaction_type);
42:
43: select map_type into i_map_type
44: from ece_mappings
45: where map_id = i_map_id

Line 67: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);

63: i_run_id
64: );
65: END IF;
66:
67: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',i_transaction_type);
68:
69: /**
70: Initialize the Stack Table
71: **/

Line 74: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

70: Initialize the Stack Table
71: **/
72: ec_utils.g_stack.DELETE;
73:
74: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
75: ece_inbound.process_run_inbound (
76: i_transaction_type => i_transaction_type,
77: i_run_id => i_run_id
78: );

Line 80: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);

76: i_transaction_type => i_transaction_type,
77: i_run_id => i_run_id
78: );
79:
80: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND','TRANSACTION_TYPE',i_transaction_type);
81:
82: IF i_Run_Import = 'Y' THEN
83: i_Submit_ID := fnd_request.submit_request (
84: application => 'ONT',

Line 95: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE',

91: argument6 => '1', -- Debug Level = 1
92: argument7 => i_num_instances -- No. of Instance to run for OIMP
93: );
94:
95: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE',
96: 'TRANSACTION_TYPE',i_transaction_type,
97: 'REQUEST_ID',i_Submit_Id);
98: END IF;
99:

Line 104: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

100: COMMIT;
101: retcode := ec_utils.i_ret_code;
102:
103: IF ec_mapping_utils.ec_get_trans_upgrade_status(i_transaction_type) = 'U' THEN
104: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
105: retcode := 1;
106: END IF;
107:
108: ec_debug.pl(3,'i_submit_id',i_submit_id);

Line 108: ec_debug.pl(3,'i_submit_id',i_submit_id);

104: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
105: retcode := 1;
106: END IF;
107:
108: ec_debug.pl(3,'i_submit_id',i_submit_id);
109: ec_debug.pl(3,'retcode',retcode);
110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:

Line 109: ec_debug.pl(3,'retcode',retcode);

105: retcode := 1;
106: END IF;
107:
108: ec_debug.pl(3,'i_submit_id',i_submit_id);
109: ec_debug.pl(3,'retcode',retcode);
110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:
113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

Line 110: ec_debug.pl(3,'errbuf',errbuf);

106: END IF;
107:
108: ec_debug.pl(3,'i_submit_id',i_submit_id);
109: ec_debug.pl(3,'retcode',retcode);
110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:
113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
114: ec_debug.disable_debug;

Line 111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');

107:
108: ec_debug.pl(3,'i_submit_id',i_submit_id);
109: ec_debug.pl(3,'retcode',retcode);
110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:
113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
114: ec_debug.disable_debug;
115:

Line 113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);

109: ec_debug.pl(3,'retcode',retcode);
110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:
113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
114: ec_debug.disable_debug;
115:
116: EXCEPTION
117: WHEN ece_transaction_disabled THEN

Line 114: ec_debug.disable_debug;

110: ec_debug.pl(3,'errbuf',errbuf);
111: ec_debug.pop('ECEPOI.PROCESS_POI_INBOUND');
112:
113: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',i_transaction_type);
114: ec_debug.disable_debug;
115:
116: EXCEPTION
117: WHEN ece_transaction_disabled THEN
118: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

Line 118: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);

114: ec_debug.disable_debug;
115:
116: EXCEPTION
117: WHEN ece_transaction_disabled THEN
118: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
119: retcode := 1;
120: ec_debug.disable_debug;
121: ROLLBACK WORK;
122:

Line 120: ec_debug.disable_debug;

116: EXCEPTION
117: WHEN ece_transaction_disabled THEN
118: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED','TRANSACTION',i_transaction_type);
119: retcode := 1;
120: ec_debug.disable_debug;
121: ROLLBACK WORK;
122:
123: WHEN EC_UTILS.PROGRAM_EXIT then
124: errbuf := ec_utils.i_errbuf;

Line 128: ec_debug.disable_debug;

124: errbuf := ec_utils.i_errbuf;
125: retcode := ec_utils.i_ret_code;
126: ece_flatfile_pvt.print_attributes;
127: rollback work;
128: ec_debug.disable_debug;
129:
130: WHEN OTHERS THEN
131: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
132: 'ECEPOI.PROCESS_POI_INBOUND');

Line 131: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

127: rollback work;
128: ec_debug.disable_debug;
129:
130: WHEN OTHERS THEN
131: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
132: 'ECEPOI.PROCESS_POI_INBOUND');
133: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
134: retcode := 2;
135: rollback work;

Line 133: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

129:
130: WHEN OTHERS THEN
131: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
132: 'ECEPOI.PROCESS_POI_INBOUND');
133: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
134: retcode := 2;
135: rollback work;
136: ece_flatfile_pvt.print_attributes;
137: ec_debug.disable_debug;

Line 137: ec_debug.disable_debug;

133: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
134: retcode := 2;
135: rollback work;
136: ece_flatfile_pvt.print_attributes;
137: ec_debug.disable_debug;
138:
139: END PROCESS_POI_INBOUND;
140:
141: Procedure Concat_Strings(

Line 484: ec_debug.pl(3,'Entering Get_Item_Description()');

480: --
481: l_item_description VARCHAR2(240) := null ;
482:
483: BEGIN
484: ec_debug.pl(3,'Entering Get_Item_Description()');
485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);
486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);

Line 485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);

481: l_item_description VARCHAR2(240) := null ;
482:
483: BEGIN
484: ec_debug.pl(3,'Entering Get_Item_Description()');
485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);
486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
489: ec_debug.pl(3,'Org ID ',p_org_id);

Line 486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);

482:
483: BEGIN
484: ec_debug.pl(3,'Entering Get_Item_Description()');
485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);
486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
489: ec_debug.pl(3,'Org ID ',p_org_id);
490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);

Line 487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);

483: BEGIN
484: ec_debug.pl(3,'Entering Get_Item_Description()');
485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);
486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
489: ec_debug.pl(3,'Org ID ',p_org_id);
490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);
491:

Line 488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);

484: ec_debug.pl(3,'Entering Get_Item_Description()');
485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);
486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
489: ec_debug.pl(3,'Org ID ',p_org_id);
490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);
491:
492: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_org_id);

Line 489: ec_debug.pl(3,'Org ID ',p_org_id);

485: ec_debug.pl(3,'Item Identifier Type ',p_item_identifier_type);
486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
489: ec_debug.pl(3,'Org ID ',p_org_id);
490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);
491:
492: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_org_id);
493: ec_debug.pl(3,'Organization ID ',l_organization_ID);

Line 490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);

486: ec_debug.pl(3,'Inventory Item ID ',p_inventory_item_id);
487: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
488: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
489: ec_debug.pl(3,'Org ID ',p_org_id);
490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);
491:
492: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_org_id);
493: ec_debug.pl(3,'Organization ID ',l_organization_ID);
494:

Line 493: ec_debug.pl(3,'Organization ID ',l_organization_ID);

489: ec_debug.pl(3,'Org ID ',p_org_id);
490: ec_debug.pl(3,'Ordered Item ',p_ordered_item);
491:
492: l_organization_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_org_id);
493: ec_debug.pl(3,'Organization ID ',l_organization_ID);
494:
495: IF (p_item_identifier_type) = 'INT' THEN
496: SELECT description
497: INTO x_item_description

Line 503: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);

499: WHERE inventory_item_id = p_inventory_item_id
500: AND organization_id = l_organization_id;
501:
502: ELSIF NVL(p_item_identifier_type,'INT') = 'CUST' THEN
503: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
504: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
505:
506: SELECT citems.customer_item_desc
507: INTO l_item_description

Line 504: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);

500: AND organization_id = l_organization_id;
501:
502: ELSIF NVL(p_item_identifier_type,'INT') = 'CUST' THEN
503: ec_debug.pl(3,'Ordered Item ID ',p_ordered_item_id);
504: ec_debug.pl(3,'Sold to Org ID ',p_sold_to_org_id);
505:
506: SELECT citems.customer_item_desc
507: INTO l_item_description
508: FROM mtl_customer_items citems

Line 544: ec_debug.pl(3,'Item Description is : ',X_ITEM_DESCRIPTION ) ;

540: AND items.cross_reference = p_ordered_item -- check that how ordered_item_id can be used
541: AND ROWNUM = 1;
542:
543: END IF;
544: ec_debug.pl(3,'Item Description is : ',X_ITEM_DESCRIPTION ) ;
545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: ec_debug.pl(3,'When no data found then get desc from system items ',SQLERRM);
548: SELECT sitems.description

Line 547: ec_debug.pl(3,'When no data found then get desc from system items ',SQLERRM);

543: END IF;
544: ec_debug.pl(3,'Item Description is : ',X_ITEM_DESCRIPTION ) ;
545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: ec_debug.pl(3,'When no data found then get desc from system items ',SQLERRM);
548: SELECT sitems.description
549: INTO x_item_description
550: FROM mtl_system_items_vl sitems
551: WHERE sitems.inventory_item_id = p_inventory_item_id