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.PA_OUTPUT_TAX dependencies on PA_MCB_INVOICE_PKG

Line 98: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' get_pa_default_classification: Org_id: '||l_org_id);

94: Fetch get_org_id into l_org_id;
95: Close get_org_id;
96:
97: IF g1_debug_mode = 'Y' THEN
98: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' get_pa_default_classification: Org_id: '||l_org_id);
99: END IF;
100:
101: IF g1_debug_mode = 'Y' THEN
102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );

Line 102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );

98: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' get_pa_default_classification: Org_id: '||l_org_id);
99: END IF;
100:
101: IF g1_debug_mode = 'Y' THEN
102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );
104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );

Line 103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );

99: END IF;
100:
101: IF g1_debug_mode = 'Y' THEN
102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );
104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );

Line 104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );

100:
101: IF g1_debug_mode = 'Y' THEN
102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );
104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );

Line 105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );

101: IF g1_debug_mode = 'Y' THEN
102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );
104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );

Line 106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );

102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );
104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );

Line 107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );

103: PA_MCB_INVOICE_PKG.log_message('p_project_id : ' || P_Project_Id );
104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );

Line 108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );

104: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id : ' || P_Bill_to_site_use_id );
105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );

Line 109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );

105: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id : ' || P_Ship_to_site_use_id );
106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );

Line 110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );

106: PA_MCB_INVOICE_PKG.log_message('p_project_customer_id : ' || P_Customer_Id );
107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );

Line 111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );

107: PA_MCB_INVOICE_PKG.log_message('p_set_of_books_id : ' || P_Sets_of_books_id );
108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );

Line 112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );

108: PA_MCB_INVOICE_PKG.log_message('p_expenditure_item_id : ' || P_Expenditure_item_id );
109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );

Line 113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );

109: PA_MCB_INVOICE_PKG.log_message('p_trx_date : ' || trunc(sysdate) );
110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );

Line 114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );

110: PA_MCB_INVOICE_PKG.log_message('p_event_id : ' || P_Event_id );
111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );
118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );

Line 115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );

111: PA_MCB_INVOICE_PKG.log_message('p_line_type : ' || l_line_type );
112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );
118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );
119: PA_MCB_INVOICE_PKG.log_message('p_draft_inv_num_credited : ' || p_draft_inv_num_credited );

Line 116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );

112: PA_MCB_INVOICE_PKG.log_message('p_request_id : ' || P_Request_id );
113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );
118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );
119: PA_MCB_INVOICE_PKG.log_message('p_draft_inv_num_credited : ' || p_draft_inv_num_credited );
120:

Line 117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );

113: PA_MCB_INVOICE_PKG.log_message('p_user_id : ' || P_User_Id );
114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );
118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );
119: PA_MCB_INVOICE_PKG.log_message('p_draft_inv_num_credited : ' || p_draft_inv_num_credited );
120:
121: END IF;

Line 118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );

114: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );
118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );
119: PA_MCB_INVOICE_PKG.log_message('p_draft_inv_num_credited : ' || p_draft_inv_num_credited );
120:
121: END IF;
122:

Line 119: PA_MCB_INVOICE_PKG.log_message('p_draft_inv_num_credited : ' || p_draft_inv_num_credited );

115: PA_MCB_INVOICE_PKG.log_message('p_bill_to_customer_id : ' || Pbill_to_customer_id );
116: PA_MCB_INVOICE_PKG.log_message('p_ship_to_customer_id : ' || Pship_to_customer_id );
117: PA_MCB_INVOICE_PKG.log_message('p_application_id : ' || 275 );
118: PA_MCB_INVOICE_PKG.log_message('p_internal_organization_id: ' || l_org_id );
119: PA_MCB_INVOICE_PKG.log_message('p_draft_inv_num_credited : ' || p_draft_inv_num_credited );
120:
121: END IF;
122:
123: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_pa_default_classification

Line 145: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );

141: p_internal_organization_id => l_org_id
142: );
143:
144: IF g1_debug_mode = 'Y' THEN
145: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
146: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
147: END IF;
148: -- If Tax_code is null , Return from the procedure
149: X_Output_tax_exempt_flag := 'S'; /* added this for bug 7229135*/

Line 146: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );

142: );
143:
144: IF g1_debug_mode = 'Y' THEN
145: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done ZX_AR_TAX_CLASSIFICATN_DEF_PKG' );
146: PA_MCB_INVOICE_PKG.log_message('p_tax_classification_code : ' || l_tax_code );
147: END IF;
148: -- If Tax_code is null , Return from the procedure
149: X_Output_tax_exempt_flag := 'S'; /* added this for bug 7229135*/
150: If l_tax_code IS NULL

Line 167: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ARP_STAX' );

163: /*Added the two parameters bill_to_customer_id and ship_to_customer_id
164: for customer account relation enhancement bug no 2760630*/
165: /*
166: IF g1_debug_mode = 'Y' THEN
167: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling ARP_STAX' );
168: END IF;
169:
170:
171:

Line 190: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' getting bill party info' );

186: tax_exemption_id => l_exemption_id);
187: */
188:
189: IF g1_debug_mode = 'Y' THEN
190: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' getting bill party info' );
191: END IF;
192:
193: select hz_c.party_id, hz_cs.party_site_id, pc.bill_to_address_id
194: into l_bill_to_party_id, l_bill_to_party_site_id, l_bill_to_address_id

Line 202: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'bill partyid :' ||

198: and hz_cs.cust_acct_site_id = pc.bill_to_address_id
199: and hz_c.cust_account_id = p_customer_id;
200:
201: IF g1_debug_mode = 'Y' THEN
202: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'bill partyid :' ||
203: l_bill_to_party_id || ';bill party site id :' ||
204: l_bill_to_party_site_id || ';bill address id :' || l_bill_to_address_id);
205:
206: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' getting ship party info' );

Line 206: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' getting ship party info' );

202: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'bill partyid :' ||
203: l_bill_to_party_id || ';bill party site id :' ||
204: l_bill_to_party_site_id || ';bill address id :' || l_bill_to_address_id);
205:
206: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' getting ship party info' );
207: END IF;
208:
209: select hz_c.party_id, hz_cs.party_site_id, pc.ship_to_address_id
210: into l_ship_to_party_id, l_ship_to_party_site_id, l_ship_to_address_id

Line 218: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'ship partyid :' ||

214: and hz_cs.cust_acct_site_id = pc.ship_to_address_id
215: and hz_c.cust_account_id = p_customer_id;
216:
217: IF g1_debug_mode = 'Y' THEN
218: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'ship partyid :' ||
219: l_ship_to_party_id || ';ship party site id :' ||
220: l_ship_to_party_site_id || ';ship address id :' || l_ship_to_address_id);
221: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling get_btch_src_trans_type' );
222: END IF;

Line 221: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling get_btch_src_trans_type' );

217: IF g1_debug_mode = 'Y' THEN
218: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'ship partyid :' ||
219: l_ship_to_party_id || ';ship party site id :' ||
220: l_ship_to_party_site_id || ';ship address id :' || l_ship_to_address_id);
221: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling get_btch_src_trans_type' );
222: END IF;
223:
224: get_btch_src_trans_type ( p_project_id => p_project_id,
225: p_draft_invoice_num => p_draft_inv_num,

Line 233: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_btch_src_trans_type' );

229: x_return_status => l_return_status);
230:
231: IF g1_debug_mode = 'Y' THEN
232:
233: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_btch_src_trans_type' );
234: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
235:
236: END IF;
237:

Line 234: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );

230:
231: IF g1_debug_mode = 'Y' THEN
232:
233: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_btch_src_trans_type' );
234: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
235:
236: END IF;
237:
238: get_legal_entity_id (p_customer_id => nvl(Pbill_to_customer_id, p_customer_id),

Line 247: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_legal_entity_id' );

243: x_return_status => l_return_status);
244:
245: IF g1_debug_mode = 'Y' THEN
246:
247: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_legal_entity_id' );
248: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
249:
250: END IF;
251:

Line 248: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );

244:
245: IF g1_debug_mode = 'Y' THEN
246:
247: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_legal_entity_id' );
248: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
249:
250: END IF;
251:
252: IF g1_debug_mode = 'Y' THEN

Line 254: PA_MCB_INVOICE_PKG.log_message('=====Parameters for get_default_exemptions====' );

250: END IF;
251:
252: IF g1_debug_mode = 'Y' THEN
253:
254: PA_MCB_INVOICE_PKG.log_message('=====Parameters for get_default_exemptions====' );
255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );
256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );

Line 255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );

251:
252: IF g1_debug_mode = 'Y' THEN
253:
254: PA_MCB_INVOICE_PKG.log_message('=====Parameters for get_default_exemptions====' );
255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );
256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );

Line 256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );

252: IF g1_debug_mode = 'Y' THEN
253:
254: PA_MCB_INVOICE_PKG.log_message('=====Parameters for get_default_exemptions====' );
255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );
256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );

Line 257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );

253:
254: PA_MCB_INVOICE_PKG.log_message('=====Parameters for get_default_exemptions====' );
255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );
256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );

Line 258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );

254: PA_MCB_INVOICE_PKG.log_message('=====Parameters for get_default_exemptions====' );
255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );
256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );

Line 259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );

255: PA_MCB_INVOICE_PKG.log_message('p_bill_to_cust_acct_id' || Pbill_to_customer_id );
256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );

Line 260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );

256: PA_MCB_INVOICE_PKG.log_message('p_ship_to_cust_acct_id' || Pship_to_customer_id );
257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );

Line 261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );

257: PA_MCB_INVOICE_PKG.log_message('p_ship_to_site_use_id' || P_ship_to_site_use_id );
258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );
265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );

Line 262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );

258: PA_MCB_INVOICE_PKG.log_message('p_bill_to_site_use_id' || P_bill_to_site_use_id );
259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );
265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );
266: PA_MCB_INVOICE_PKG.log_message('p_reason_code' || l_reason_code );

Line 263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );

259: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_id' || l_bill_to_party_id );
260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );
265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );
266: PA_MCB_INVOICE_PKG.log_message('p_reason_code' || l_reason_code );
267:

Line 264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );

260: PA_MCB_INVOICE_PKG.log_message('p_bill_to_party_site_id' || l_bill_to_party_site_id );
261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );
265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );
266: PA_MCB_INVOICE_PKG.log_message('p_reason_code' || l_reason_code );
267:
268:

Line 265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );

261: PA_MCB_INVOICE_PKG.log_message('p_ship_to_party_site_id' || l_ship_to_party_site_id );
262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );
265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );
266: PA_MCB_INVOICE_PKG.log_message('p_reason_code' || l_reason_code );
267:
268:
269: END IF;

Line 266: PA_MCB_INVOICE_PKG.log_message('p_reason_code' || l_reason_code );

262: PA_MCB_INVOICE_PKG.log_message('p_legal_entity_id' || l_legal_entity_id );
263: PA_MCB_INVOICE_PKG.log_message('p_org_id' || l_org_id );
264: PA_MCB_INVOICE_PKG.log_message('p_trx_date' || trunc(sysdate) );
265: PA_MCB_INVOICE_PKG.log_message('p_exempt_certificate_number' || l_certificate_no );
266: PA_MCB_INVOICE_PKG.log_message('p_reason_code' || l_reason_code );
267:
268:
269: END IF;
270:

Line 296: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_default_exemptions' );

292: x_exemption_rec_tbl => l1_exemption_rec_tbl);
293:
294: IF g1_debug_mode = 'Y' THEN
295:
296: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_default_exemptions' );
297: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
298: PA_MCB_INVOICE_PKG.log_message('exemption_rec_tbl count:' || l1_exemption_rec_tbl.COUNT );
299:
300: END IF;

Line 297: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );

293:
294: IF g1_debug_mode = 'Y' THEN
295:
296: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_default_exemptions' );
297: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
298: PA_MCB_INVOICE_PKG.log_message('exemption_rec_tbl count:' || l1_exemption_rec_tbl.COUNT );
299:
300: END IF;
301:

Line 298: PA_MCB_INVOICE_PKG.log_message('exemption_rec_tbl count:' || l1_exemption_rec_tbl.COUNT );

294: IF g1_debug_mode = 'Y' THEN
295:
296: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' done get_default_exemptions' );
297: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status );
298: PA_MCB_INVOICE_PKG.log_message('exemption_rec_tbl count:' || l1_exemption_rec_tbl.COUNT );
299:
300: END IF;
301:
302: IF l1_exemption_rec_tbl.COUNT > 0 THEN

Line 306: PA_MCB_INVOICE_PKG.log_message('tax exempt id :' || l1_exemption_rec_tbl(1).tax_exemption_id);

302: IF l1_exemption_rec_tbl.COUNT > 0 THEN
303:
304: IF g1_debug_mode = 'Y' THEN
305:
306: PA_MCB_INVOICE_PKG.log_message('tax exempt id :' || l1_exemption_rec_tbl(1).tax_exemption_id);
307: PA_MCB_INVOICE_PKG.log_message('exmpt cert no :' || l1_exemption_rec_tbl(1).exempt_certificate_number );
308: PA_MCB_INVOICE_PKG.log_message('exmpt reason code :' || l1_exemption_rec_tbl(1).exempt_reason_code );
309:
310: END IF;

Line 307: PA_MCB_INVOICE_PKG.log_message('exmpt cert no :' || l1_exemption_rec_tbl(1).exempt_certificate_number );

303:
304: IF g1_debug_mode = 'Y' THEN
305:
306: PA_MCB_INVOICE_PKG.log_message('tax exempt id :' || l1_exemption_rec_tbl(1).tax_exemption_id);
307: PA_MCB_INVOICE_PKG.log_message('exmpt cert no :' || l1_exemption_rec_tbl(1).exempt_certificate_number );
308: PA_MCB_INVOICE_PKG.log_message('exmpt reason code :' || l1_exemption_rec_tbl(1).exempt_reason_code );
309:
310: END IF;
311: l_exemption_id := l1_exemption_rec_tbl(1).tax_exemption_id;

Line 308: PA_MCB_INVOICE_PKG.log_message('exmpt reason code :' || l1_exemption_rec_tbl(1).exempt_reason_code );

304: IF g1_debug_mode = 'Y' THEN
305:
306: PA_MCB_INVOICE_PKG.log_message('tax exempt id :' || l1_exemption_rec_tbl(1).tax_exemption_id);
307: PA_MCB_INVOICE_PKG.log_message('exmpt cert no :' || l1_exemption_rec_tbl(1).exempt_certificate_number );
308: PA_MCB_INVOICE_PKG.log_message('exmpt reason code :' || l1_exemption_rec_tbl(1).exempt_reason_code );
309:
310: END IF;
311: l_exemption_id := l1_exemption_rec_tbl(1).tax_exemption_id;
312: l_certificate_no := l1_exemption_rec_tbl(1).exempt_certificate_number;

Line 344: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || SQLERRM );

340: X_Output_tax_exempt_flag := NULL; --NOCOPY
341: X_Output_tax_exempt_number := NULL; --NOCOPY
342: X_Output_exempt_reason_code := NULL; --NOCOPY
343: X_Output_tax_code := NULL; --NOCOPY
344: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || SQLERRM );
345: Raise;
346: END GET_DEFAULT_TAX_INFO;
347:
348: /* Overloaded procedure added for Customer Relationship Management enhancement */

Line 534: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Inside MARK_CUST_REV_DIST_LINES');

530: -- Convert the Bill Transaction Curreny to IPC
531:
532: -- Get the Project level defaults
533: IF g1_debug_mode = 'Y' THEN
534: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Inside MARK_CUST_REV_DIST_LINES');
535: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
536: END IF;
537:
538: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

Line 535: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');

531:
532: -- Get the Project level defaults
533: IF g1_debug_mode = 'Y' THEN
534: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Inside MARK_CUST_REV_DIST_LINES');
535: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
536: END IF;
537:
538: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
539: p_project_id => p_project_id,

Line 566: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Get Funding Currency Code ');

562:
563: IF l_funding_currency_code IS NULL THEN
564:
565: IF g1_debug_mode = 'Y' THEN
566: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Get Funding Currency Code ');
567: END IF;
568:
569: BEGIN
570:

Line 583: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Funding Currency Code : ' || l_funding_currency_code);

579: FROM PA_AGREEMENTS_ALL
580: WHERE agreement_id = p_agreement_id;
581:
582: IF g1_debug_mode = 'Y' THEN
583: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Funding Currency Code : ' || l_funding_currency_code);
584: END IF;
585:
586: EXCEPTION
587:

Line 590: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Oracle Error NO DATA FOUND');

586: EXCEPTION
587:
588: WHEN NO_DATA_FOUND THEN
589: IF g1_debug_mode = 'Y' THEN
590: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Oracle Error NO DATA FOUND');
591: END IF;
592: RAISE ;
593: END ;
594:

Line 599: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Loop Begins for ' || P_No_of_rec);

595: END IF;
596:
597:
598: IF g1_debug_mode = 'Y' THEN
599: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Loop Begins for ' || P_No_of_rec);
600: END IF;
601:
602: FOR loop_index in 1..P_No_of_rec LOOP
603:

Line 690: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to PF ');

686: IF p_bill_trans_currency_code.COUNT <> 0 THEN
687:
688: -- Convert the bill transaction currecy to PFC
689: IF g1_debug_mode = 'Y' THEN
690: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to PF ');
691: END IF;
692:
693: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
694: p_from_currency_tab => p_bill_trans_currency_code,

Line 711: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Proj curr = Proj func currency ..Copy ' );

707:
708: IF l_project_currency_code = l_projfunc_currency_code then
709:
710: IF g1_debug_mode = 'Y' THEN
711: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Proj curr = Proj func currency ..Copy ' );
712: END IF;
713:
714: FOR i IN tmp_status_projfunc_tab.FIRST..tmp_status_projfunc_tab.LAST LOOP
715:

Line 728: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to PC ');

724: else
725:
726: -- Convert the bill transaction currecy to PC
727: IF g1_debug_mode = 'Y' THEN
728: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to PC ');
729: END IF;
730:
731: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
732: p_from_currency_tab => p_bill_trans_currency_code,

Line 750: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Fund curr = Proj func currency ..Copy ' );

746:
747: IF l_funding_currency_code = l_projfunc_currency_code then
748:
749: IF g1_debug_mode = 'Y' THEN
750: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Fund curr = Proj func currency ..Copy ' );
751: END IF;
752:
753: FOR i IN tmp_status_projfunc_tab.FIRST..tmp_status_projfunc_tab.LAST LOOP
754:

Line 766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding curr = Proj currency ..Copy ' );

762:
763: elsif l_funding_currency_code = l_project_currency_code then
764:
765: IF g1_debug_mode = 'Y' THEN
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding curr = Proj currency ..Copy ' );
767: END IF;
768:
769: FOR i IN tmp_status_project_tab.FIRST..tmp_status_project_tab.LAST LOOP
770:

Line 782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to FC ');

778:
779: else
780:
781: IF g1_debug_mode = 'Y' THEN
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to FC ');
783: END IF;
784:
785: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
786: p_from_currency_tab => p_bill_trans_currency_code,

Line 810: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = fund curr');

806: IF tmp_invproc_currency_type = 'FUNDING_CURRENCY' THEN
807:
808:
809: IF g1_debug_mode = 'Y' THEN
810: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = fund curr');
811: END IF;
812: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
813:
814: tmp_invproc_bill_amount(i) := tmp_funding_bill_amount(i);

Line 828: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = proj curr');

824: -- Invoice Processing is PC
825: -- Move the Project Currency Amount and attributes to Invoice Processing
826:
827: IF g1_debug_mode = 'Y' THEN
828: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = proj curr');
829: END IF;
830: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
831:
832: tmp_invproc_bill_amount(i) := tmp_project_bill_amount(i);

Line 846: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = projfunc curr');

842: -- Invoice Processing is PFC
843: -- Move the Project Functional Currency Amount and attributes to Invoice Processing
844:
845: IF g1_debug_mode = 'Y' THEN
846: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = projfunc curr');
847: END IF;
848: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
849:
850: tmp_invproc_bill_amount(i) := tmp_projfunc_bill_amount(i);

Line 863: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' setting status tab');

859:
860: -- Set the Status code array
861:
862: IF g1_debug_mode = 'Y' THEN
863: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' setting status tab');
864: END IF;
865: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
866:
867: tmp_status_tab(i) := 'N';

Line 878: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));

874: tmp_status_tab(i):= 'BTC_FUNDING'|| tmp_status_funding_tab(i);
875: END IF;
876: */
877: IF g1_debug_mode = 'Y' THEN
878: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));
879: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));
880: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));
881: END IF;
882:

Line 879: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));

875: END IF;
876: */
877: IF g1_debug_mode = 'Y' THEN
878: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));
879: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));
880: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));
881: END IF;
882:
883:

Line 880: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));

876: */
877: IF g1_debug_mode = 'Y' THEN
878: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));
879: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));
880: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));
881: END IF;
882:
883:
884: /* Federal changes : begin */

Line 909: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling get default tax info ');

905:
906: -- End of MCB changes
907:
908: IF g1_debug_mode = 'Y' THEN
909: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling get default tax info ');
910: END IF;
911: FOR loop_index in 1..P_No_of_rec LOOP
912:
913: -- Call Tax API to get the tax Id and Related attribute

Line 950: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');

946:
947: -- Update the expenditure items
948:
949: IF g1_debug_mode = 'Y' THEN
950: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );

Line 951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );

947: -- Update the expenditure items
948:
949: IF g1_debug_mode = 'Y' THEN
950: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
955: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );

Line 952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );

948:
949: IF g1_debug_mode = 'Y' THEN
950: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
955: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
956: END IF;

Line 953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );

949: IF g1_debug_mode = 'Y' THEN
950: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
955: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
956: END IF;
957:

Line 954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );

950: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
955: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
956: END IF;
957:
958: Update PA_CUST_REV_DIST_LINES_ALL

Line 955: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );

951: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
952: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
953: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
954: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
955: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
956: END IF;
957:
958: Update PA_CUST_REV_DIST_LINES_ALL
959: Set

Line 1043: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' updateing ei ');

1039:
1040: l_count := l_count + 1;
1041: -- Update the EIs
1042: IF g1_debug_mode = 'Y' THEN
1043: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' updateing ei ');
1044: END IF;
1045: Update PA_EXPENDITURE_ITEMS_ALL
1046: Set
1047: invproc_rate_type =

Line 1102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' equating invproc amounts ');

1098:
1099: End Loop;
1100:
1101: IF g1_debug_mode = 'Y' THEN
1102: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' equating invproc amounts ');
1103: END IF;
1104:
1105:
1106:

Line 1130: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Error in MARK_CUST_REV_DIST_LINES ' || sqlerrm);

1126: EXCEPTION
1127: When Others
1128: Then
1129: IF g1_debug_mode = 'Y' THEN
1130: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Error in MARK_CUST_REV_DIST_LINES ' || sqlerrm);
1131: END IF;
1132:
1133: x_return_status := sqlerrm( sqlcode );
1134: IF g1_debug_mode = 'Y' THEN

Line 1135: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || x_return_status);

1131: END IF;
1132:
1133: x_return_status := sqlerrm( sqlcode );
1134: IF g1_debug_mode = 'Y' THEN
1135: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || x_return_status);
1136: END IF;
1137:
1138: --Raise;
1139:

Line 1362: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );

1358: begin
1359:
1360: IF g1_debug_mode = 'Y' THEN
1361:
1362: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1363: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );

Line 1363: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );

1359:
1360: IF g1_debug_mode = 'Y' THEN
1361:
1362: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1363: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1367:

Line 1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );

1360: IF g1_debug_mode = 'Y' THEN
1361:
1362: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1363: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1367:
1368: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');

Line 1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );

1361:
1362: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1363: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1367:
1368: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1369: END IF;

Line 1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );

1362: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1363: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1367:
1368: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1369: END IF;
1370:

Line 1368: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');

1364: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1365: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1366: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1367:
1368: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1369: END IF;
1370:
1371: XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info(
1372: x_return_status => l_return_status,

Line 1383: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');

1379: x_otoc_Le_info => l_otoc_le_info) ;
1380:
1381: IF g1_debug_mode = 'Y' THEN
1382:
1383: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1384: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1385: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1386:
1387: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);

Line 1384: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );

1380:
1381: IF g1_debug_mode = 'Y' THEN
1382:
1383: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1384: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1385: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1386:
1387: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);
1388:

Line 1385: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);

1381: IF g1_debug_mode = 'Y' THEN
1382:
1383: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1384: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1385: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1386:
1387: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);
1388:
1389: END IF;

Line 1387: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);

1383: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1384: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1385: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1386:
1387: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);
1388:
1389: END IF;
1390:
1391: x_legal_entity_id := l_otoc_le_info.legal_entity_id;

Line 1424: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');

1420: begin
1421:
1422: IF g1_debug_mode = 'Y' THEN
1423:
1424: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');
1425: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);
1426: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );
1427:
1428: END IF;

Line 1425: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);

1421:
1422: IF g1_debug_mode = 'Y' THEN
1423:
1424: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');
1425: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);
1426: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );
1427:
1428: END IF;
1429:

Line 1426: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );

1422: IF g1_debug_mode = 'Y' THEN
1423:
1424: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');
1425: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);
1426: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );
1427:
1428: END IF;
1429:
1430: SELECT business_group_id,

Line 1441: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);

1437:
1438:
1439: IF g1_debug_mode = 'Y' THEN
1440:
1441: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);
1442: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );
1443: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );
1444:
1445: END IF;

Line 1442: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );

1438:
1439: IF g1_debug_mode = 'Y' THEN
1440:
1441: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);
1442: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );
1443: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );
1444:
1445: END IF;
1446:

Line 1443: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );

1439: IF g1_debug_mode = 'Y' THEN
1440:
1441: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);
1442: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );
1443: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );
1444:
1445: END IF;
1446:
1447: SELECT PROJ.Carrying_Out_Organization_ID

Line 1461: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);

1457:
1458:
1459: IF g1_debug_mode = 'Y' THEN
1460:
1461: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);
1462: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );
1463: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');
1464:
1465: END IF;

Line 1462: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );

1458:
1459: IF g1_debug_mode = 'Y' THEN
1460:
1461: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);
1462: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );
1463: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');
1464:
1465: END IF;
1466:

Line 1463: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');

1459: IF g1_debug_mode = 'Y' THEN
1460:
1461: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);
1462: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );
1463: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');
1464:
1465: END IF;
1466:
1467: pa_invoice_xfer.get_trx_crmemo_types(

Line 1479: PA_MCB_INVOICE_PKG.log_message('trans type : ' || l_p_trx_type);

1475: P_error_message => l_error_message);
1476:
1477: IF g1_debug_mode = 'Y' THEN
1478:
1479: PA_MCB_INVOICE_PKG.log_message('trans type : ' || l_p_trx_type);
1480: PA_MCB_INVOICE_PKG.log_message('crmo trx type:' || l_cm_trx_type );
1481:
1482: END IF;
1483:

Line 1480: PA_MCB_INVOICE_PKG.log_message('crmo trx type:' || l_cm_trx_type );

1476:
1477: IF g1_debug_mode = 'Y' THEN
1478:
1479: PA_MCB_INVOICE_PKG.log_message('trans type : ' || l_p_trx_type);
1480: PA_MCB_INVOICE_PKG.log_message('crmo trx type:' || l_cm_trx_type );
1481:
1482: END IF;
1483:
1484: IF nvl(p_draft_inv_num_credited,0) = 0 THEN