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 600: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Inside MARK_CUST_REV_DIST_LINES');

596: -- Convert the Bill Transaction Curreny to IPC
597:
598: -- Get the Project level defaults
599: IF g1_debug_mode = 'Y' THEN
600: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Inside MARK_CUST_REV_DIST_LINES');
601: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
602: END IF;
603:
604: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

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

597:
598: -- Get the Project level defaults
599: IF g1_debug_mode = 'Y' THEN
600: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Inside MARK_CUST_REV_DIST_LINES');
601: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
602: END IF;
603:
604: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
605: p_project_id => p_project_id,

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

628:
629: IF l_funding_currency_code IS NULL THEN
630:
631: IF g1_debug_mode = 'Y' THEN
632: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Get Funding Currency Code ');
633: END IF;
634:
635: BEGIN
636: PA_MCB_INVOICE_PKG.log_message('INVOICE DATE : ' || 'P_invoice_date : ' || TO_DATE(P_invoice_date,'YYYY/MM/DD'));

Line 636: PA_MCB_INVOICE_PKG.log_message('INVOICE DATE : ' || 'P_invoice_date : ' || TO_DATE(P_invoice_date,'YYYY/MM/DD'));

632: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Get Funding Currency Code ');
633: END IF;
634:
635: BEGIN
636: PA_MCB_INVOICE_PKG.log_message('INVOICE DATE : ' || 'P_invoice_date : ' || TO_DATE(P_invoice_date,'YYYY/MM/DD'));
637:
638: /* Federal Changes : Added start date and expiry date */
639: /* Modified the expiration_date to use Invoice date, instead of sysdate for Bug#14116344 */
640: SELECT agreement_currency_code,

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

645: FROM PA_AGREEMENTS_ALL
646: WHERE agreement_id = p_agreement_id;
647:
648: IF g1_debug_mode = 'Y' THEN
649: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Funding Currency Code : ' || l_funding_currency_code);
650: END IF;
651:
652: EXCEPTION
653:

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

652: EXCEPTION
653:
654: WHEN NO_DATA_FOUND THEN
655: IF g1_debug_mode = 'Y' THEN
656: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Oracle Error NO DATA FOUND');
657: END IF;
658: RAISE ;
659: END ;
660:

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

661: END IF;
662:
663:
664: IF g1_debug_mode = 'Y' THEN
665: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Loop Begins for ' || P_No_of_rec);
666: END IF;
667:
668: FOR loop_index in 1..P_No_of_rec LOOP
669:

Line 673: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' G_NET_INVOICE_ENABLED= ' || G_NET_INVOICE_ENABLED);

669:
670: /* Added for Payroll Billing ER #11847630 - Start */
671:
672: IF g1_debug_mode = 'Y' THEN
673: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' G_NET_INVOICE_ENABLED= ' || G_NET_INVOICE_ENABLED);
674: END IF;
675:
676: l_reversal_flag := 'N';
677: If ( NVL(G_NET_INVOICE_ENABLED,'N') = 'Y' ) THEN /* Specs global variable */

Line 687: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' P_Expenditure_item_id(' || loop_index || ')=' || P_Expenditure_item_id(loop_index) || ' P_Line_num(' || loop_index || ')=' || P_Line_num(loop_index));

683:
684: l_exp_item_id := null;
685:
686: IF g1_debug_mode = 'Y' THEN
687: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' P_Expenditure_item_id(' || loop_index || ')=' || P_Expenditure_item_id(loop_index) || ' P_Line_num(' || loop_index || ')=' || P_Line_num(loop_index));
688: END IF;
689:
690: OPEN c_reversal_rdl(P_Expenditure_item_id(loop_index),
691: P_Line_num(loop_index));

Line 697: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_exp_item_id=' || l_exp_item_id || ' l_line_num=' || l_line_num);

693: INTO l_exp_item_id, l_line_num;
694: CLOSE c_reversal_rdl;
695:
696: IF g1_debug_mode = 'Y' THEN
697: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_exp_item_id=' || l_exp_item_id || ' l_line_num=' || l_line_num);
698: END IF;
699:
700: IF (l_exp_item_id is null) THEN
701:

Line 708: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_exp_item_id=' || l_exp_item_id || ' l_line_num=' || l_line_num);

704: INTO l_exp_item_id, l_line_num;
705: CLOSE c_reversal_ei;
706:
707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_exp_item_id=' || l_exp_item_id || ' l_line_num=' || l_line_num);
709: END IF;
710:
711: END IF;
712:

Line 718: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Opeinign cursor c_orig_amount with l_exp_item_id=' || l_exp_item_id || ' l_line_num=' || l_line_num);

714:
715: tmp_status_tab(loop_index) := 'N';
716:
717: IF g1_debug_mode = 'Y' THEN
718: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Opeinign cursor c_orig_amount with l_exp_item_id=' || l_exp_item_id || ' l_line_num=' || l_line_num);
719: END IF;
720:
721: OPEN c_orig_amount(l_exp_item_id, l_line_num);
722:

Line 763: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_type(' || loop_index || ')=' || tmp_project_rate_type(loop_index));

759: tmp_expenditure_item_date(loop_index) := TO_DATE(p_expenditure_item_date(loop_index),'YYYY/MM/DD'); /* Federal Changes */
760:
761:
762: IF g1_debug_mode = 'Y' THEN
763: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_type(' || loop_index || ')=' || tmp_project_rate_type(loop_index));
764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));
765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));

Line 764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));

760:
761:
762: IF g1_debug_mode = 'Y' THEN
763: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_type(' || loop_index || ')=' || tmp_project_rate_type(loop_index));
764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));
765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));

Line 765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));

761:
762: IF g1_debug_mode = 'Y' THEN
763: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_type(' || loop_index || ')=' || tmp_project_rate_type(loop_index));
764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));
765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));

Line 766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));

762: IF g1_debug_mode = 'Y' THEN
763: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_type(' || loop_index || ')=' || tmp_project_rate_type(loop_index));
764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));
765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));

Line 767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));

763: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_type(' || loop_index || ')=' || tmp_project_rate_type(loop_index));
764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));
765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));

Line 768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));

764: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_rate_date(' || loop_index || ')=' || tmp_project_rate_date(loop_index));
765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));

Line 769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));

765: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_exchange_rate(' || loop_index || ')=' || tmp_project_exchange_rate(loop_index));
766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));

Line 770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));

766: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_bill_amount(' || loop_index || ')=' || tmp_project_bill_amount(loop_index));
767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));

Line 771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));

767: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_type(' || loop_index || ')=' || tmp_projfunc_rate_type(loop_index));
768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));

Line 772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));

768: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_rate_date(' || loop_index || ')=' || tmp_projfunc_rate_date(loop_index));
769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));

Line 773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));

769: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_exchange_rate(' || loop_index || ')=' || tmp_projfunc_exchange_rate(loop_index));
770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));

Line 774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));

770: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_bill_amount(' || loop_index || ')=' || tmp_projfunc_bill_amount(loop_index));
771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));

Line 775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));

771: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_type(' || loop_index || ')=' || tmp_invproc_rate_type(loop_index));
772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));

Line 776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));

772: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_rate_date(' || loop_index || ')=' || tmp_invproc_rate_date(loop_index));
773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));

Line 777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));

773: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_exchange_rate(' || loop_index || ')=' || tmp_invproc_exchange_rate(loop_index));
774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));

Line 778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));

774: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_bill_amount(' || loop_index || ')=' || tmp_invproc_bill_amount(loop_index));
775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));

Line 779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));

775: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_type(' || loop_index || ')=' || tmp_funding_rate_type(loop_index));
776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);

Line 780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));

776: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_rate_date(' || loop_index || ')=' || tmp_funding_rate_date(loop_index));
777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);

Line 781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));

777: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_exchange_rate(' || loop_index || ')=' || tmp_funding_exchange_rate(loop_index));
778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);
785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);

Line 782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));

778: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_bill_amount(' || loop_index || ')=' || tmp_funding_bill_amount(loop_index));
779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);
785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);
786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);

Line 783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);

779: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_project_currency_code(' || loop_index || ')=' || tmp_project_currency_code(loop_index));
780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);
785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);
786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);
787: END IF;

Line 784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);

780: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_projfunc_currency_code(' || loop_index || ')=' || tmp_projfunc_currency_code(loop_index));
781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);
785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);
786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);
787: END IF;
788:

Line 785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);

781: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_invproc_currency_code(' || loop_index || ')=' || tmp_invproc_currency_code(loop_index));
782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);
785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);
786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);
787: END IF;
788:
789: l_reversal_flag := 'Y';

Line 786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);

782: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' tmp_funding_currency_code(' || loop_index || ')=' || tmp_funding_currency_code(loop_index));
783: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_output_tax_code=' || l_output_tax_code);
784: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_flag=' || l_Output_tax_exempt_flag);
785: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_exempt_reason_code=' || l_Output_exempt_reason_code);
786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);
787: END IF;
788:
789: l_reversal_flag := 'Y';
790: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_reversal_flag=' || l_reversal_flag);

Line 790: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_reversal_flag=' || l_reversal_flag);

786: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_Output_tax_exempt_number=' || l_Output_tax_exempt_number);
787: END IF;
788:
789: l_reversal_flag := 'Y';
790: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_reversal_flag=' || l_reversal_flag);
791: END IF;
792:
793: End If; /* G_NET_INVOICE_ENABLED */
794:

Line 796: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_reversal_flag=' || l_reversal_flag);

792:
793: End If; /* G_NET_INVOICE_ENABLED */
794:
795: IF g1_debug_mode = 'Y' THEN
796: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' l_reversal_flag=' || l_reversal_flag);
797: END IF;
798:
799: /* Added for Payroll Billing ER #11847630 - End */
800:

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

895: IF p_bill_trans_currency_code.COUNT <> 0 THEN
896:
897: -- Convert the bill transaction currecy to PFC
898: IF g1_debug_mode = 'Y' THEN
899: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to PF ');
900: END IF;
901:
902: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
903: p_from_currency_tab => p_bill_trans_currency_code,

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

916:
917: IF l_project_currency_code = l_projfunc_currency_code then
918:
919: IF g1_debug_mode = 'Y' THEN
920: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Proj curr = Proj func currency ..Copy ' );
921: END IF;
922:
923: FOR i IN tmp_status_projfunc_tab.FIRST..tmp_status_projfunc_tab.LAST LOOP
924:

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

933: else
934:
935: -- Convert the bill transaction currecy to PC
936: IF g1_debug_mode = 'Y' THEN
937: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to PC ');
938: END IF;
939:
940: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
941: p_from_currency_tab => p_bill_trans_currency_code,

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

955:
956: IF l_funding_currency_code = l_projfunc_currency_code then
957:
958: IF g1_debug_mode = 'Y' THEN
959: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Fund curr = Proj func currency ..Copy ' );
960: END IF;
961:
962: FOR i IN tmp_status_projfunc_tab.FIRST..tmp_status_projfunc_tab.LAST LOOP
963:

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

971:
972: elsif l_funding_currency_code = l_project_currency_code then
973:
974: IF g1_debug_mode = 'Y' THEN
975: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding curr = Proj currency ..Copy ' );
976: END IF;
977:
978: FOR i IN tmp_status_project_tab.FIRST..tmp_status_project_tab.LAST LOOP
979:

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

987:
988: else
989:
990: IF g1_debug_mode = 'Y' THEN
991: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Conversion CALL for BTC to FC ');
992: END IF;
993:
994: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
995: p_from_currency_tab => p_bill_trans_currency_code,

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

1015: IF tmp_invproc_currency_type = 'FUNDING_CURRENCY' THEN
1016:
1017:
1018: IF g1_debug_mode = 'Y' THEN
1019: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = fund curr');
1020: END IF;
1021: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
1022:
1023: tmp_invproc_bill_amount(i) := tmp_funding_bill_amount(i);

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

1033: -- Invoice Processing is PC
1034: -- Move the Project Currency Amount and attributes to Invoice Processing
1035:
1036: IF g1_debug_mode = 'Y' THEN
1037: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = proj curr');
1038: END IF;
1039: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
1040:
1041: tmp_invproc_bill_amount(i) := tmp_project_bill_amount(i);

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

1051: -- Invoice Processing is PFC
1052: -- Move the Project Functional Currency Amount and attributes to Invoice Processing
1053:
1054: IF g1_debug_mode = 'Y' THEN
1055: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' invcurr = projfunc curr');
1056: END IF;
1057: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
1058:
1059: tmp_invproc_bill_amount(i) := tmp_projfunc_bill_amount(i);

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

1068:
1069: -- Set the Status code array
1070:
1071: IF g1_debug_mode = 'Y' THEN
1072: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' setting status tab');
1073: END IF;
1074: FOR i IN 1..tmp_status_project_tab.COUNT LOOP
1075:
1076: tmp_status_tab(i) := 'N';

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

1083: tmp_status_tab(i):= 'BTC_FUNDING'|| tmp_status_funding_tab(i);
1084: END IF;
1085: */
1086: IF g1_debug_mode = 'Y' THEN
1087: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));
1088: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));
1089: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));
1090: END IF;
1091:

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

1084: END IF;
1085: */
1086: IF g1_debug_mode = 'Y' THEN
1087: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));
1088: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));
1089: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));
1090: END IF;
1091:
1092:

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

1085: */
1086: IF g1_debug_mode = 'Y' THEN
1087: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'proj' || tmp_status_project_tab(i));
1088: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'projfunc' || tmp_status_projfunc_tab(i));
1089: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'funding' || tmp_status_funding_tab(i));
1090: END IF;
1091:
1092:
1093: /* Federal changes : begin */

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

1114:
1115: -- End of MCB changes
1116:
1117: IF g1_debug_mode = 'Y' THEN
1118: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' calling get default tax info ');
1119: END IF;
1120:
1121: /* Added for Payroll Billing ER #11847630 - Start */
1122:

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

1166:
1167: -- Update the expenditure items
1168:
1169: IF g1_debug_mode = 'Y' THEN
1170: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
1171: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
1172: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
1173: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
1174: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );

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

1167: -- Update the expenditure items
1168:
1169: IF g1_debug_mode = 'Y' THEN
1170: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
1171: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
1172: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
1173: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
1174: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
1175: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );

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

1168:
1169: IF g1_debug_mode = 'Y' THEN
1170: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
1171: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
1172: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
1173: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
1174: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
1175: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
1176: END IF;

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

1169: IF g1_debug_mode = 'Y' THEN
1170: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
1171: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
1172: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
1173: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
1174: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
1175: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
1176: END IF;
1177:

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

1170: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Update RDL and EI');
1171: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
1172: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
1173: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
1174: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
1175: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
1176: END IF;
1177:
1178: /* Added for Payroll Billing ER #11847630 - Start */

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

1171: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Expenditure Item ID : ' || P_Expenditure_item_id(loop_index) );
1172: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Funding Amount : ' || tmp_funding_bill_amount(loop_index) );
1173: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Project Amount : ' || tmp_project_bill_amount(loop_index) );
1174: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' ProjFunc Amount : ' || tmp_projfunc_bill_amount(loop_index) );
1175: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' Status Code : ' || tmp_status_tab(loop_index) );
1176: END IF;
1177:
1178: /* Added for Payroll Billing ER #11847630 - Start */
1179: end if ; -- l_reversal_flag if statement

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

1263:
1264: l_count := l_count + 1;
1265: -- Update the EIs
1266: IF g1_debug_mode = 'Y' THEN
1267: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' updateing ei ');
1268: END IF;
1269:
1270:
1271: Update PA_EXPENDITURE_ITEMS_ALL

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

1324:
1325: End Loop;
1326:
1327: IF g1_debug_mode = 'Y' THEN
1328: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || ' equating invproc amounts ');
1329: END IF;
1330:
1331:
1332:

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

1352: EXCEPTION
1353: When Others
1354: Then
1355: IF g1_debug_mode = 'Y' THEN
1356: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || 'Error in MARK_CUST_REV_DIST_LINES ' || sqlerrm);
1357: END IF;
1358:
1359: x_return_status := sqlerrm( sqlcode );
1360: IF g1_debug_mode = 'Y' THEN

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

1357: END IF;
1358:
1359: x_return_status := sqlerrm( sqlcode );
1360: IF g1_debug_mode = 'Y' THEN
1361: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: ' || x_return_status);
1362: END IF;
1363:
1364: --Raise;
1365:

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

1584: begin
1585:
1586: IF g1_debug_mode = 'Y' THEN
1587:
1588: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1589: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1590: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1591: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1592: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );

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

1585:
1586: IF g1_debug_mode = 'Y' THEN
1587:
1588: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1589: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1590: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1591: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1592: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1593:

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

1586: IF g1_debug_mode = 'Y' THEN
1587:
1588: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1589: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1590: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1591: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1592: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1593:
1594: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');

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

1587:
1588: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1589: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1590: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1591: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1592: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1593:
1594: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1595: END IF;

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

1588: PA_MCB_INVOICE_PKG.log_message('GET_DEFAULT_TAX_INFO: in get_legal_entity_id' );
1589: PA_MCB_INVOICE_PKG.log_message('p_customer_id : ' || P_customer_id );
1590: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1591: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1592: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1593:
1594: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1595: END IF;
1596:

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

1590: PA_MCB_INVOICE_PKG.log_message('p_org_id : ' || p_org_id );
1591: PA_MCB_INVOICE_PKG.log_message('p_transaction_type_id : ' || P_transaction_type_id );
1592: PA_MCB_INVOICE_PKG.log_message('p_batch_source_id : ' || P_batch_source_id );
1593:
1594: PA_MCB_INVOICE_PKG.log_message('calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1595: END IF;
1596:
1597: XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info(
1598: x_return_status => l_return_status,

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

1605: x_otoc_Le_info => l_otoc_le_info) ;
1606:
1607: IF g1_debug_mode = 'Y' THEN
1608:
1609: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1610: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1611: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1612:
1613: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);

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

1606:
1607: IF g1_debug_mode = 'Y' THEN
1608:
1609: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1610: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1611: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1612:
1613: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);
1614:

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

1607: IF g1_debug_mode = 'Y' THEN
1608:
1609: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1610: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1611: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1612:
1613: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);
1614:
1615: END IF;

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

1609: PA_MCB_INVOICE_PKG.log_message('after calling XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info ');
1610: PA_MCB_INVOICE_PKG.log_message('legal_entity_id : ' || l_otoc_le_info.legal_entity_id );
1611: PA_MCB_INVOICE_PKG.log_message('return status : ' || l_return_status);
1612:
1613: PA_MCB_INVOICE_PKG.log_message('msg data : ' || l_msg_data);
1614:
1615: END IF;
1616:
1617: x_legal_entity_id := l_otoc_le_info.legal_entity_id;

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

1645: begin
1646:
1647: IF g1_debug_mode = 'Y' THEN
1648:
1649: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');
1650: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);
1651: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );
1652:
1653: END IF;

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

1646:
1647: IF g1_debug_mode = 'Y' THEN
1648:
1649: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');
1650: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);
1651: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );
1652:
1653: END IF;
1654:

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

1647: IF g1_debug_mode = 'Y' THEN
1648:
1649: PA_MCB_INVOICE_PKG.log_message('in get_btch_src_trans_type');
1650: PA_MCB_INVOICE_PKG.log_message('project_id : ' || p_project_id);
1651: PA_MCB_INVOICE_PKG.log_message('draft_invoice_num :' || p_draft_invoice_num );
1652:
1653: END IF;
1654:
1655: SELECT business_group_id,

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

1662:
1663:
1664: IF g1_debug_mode = 'Y' THEN
1665:
1666: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);
1667: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );
1668: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );
1669:
1670: END IF;

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

1663:
1664: IF g1_debug_mode = 'Y' THEN
1665:
1666: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);
1667: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );
1668: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );
1669:
1670: END IF;
1671:

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

1664: IF g1_debug_mode = 'Y' THEN
1665:
1666: PA_MCB_INVOICE_PKG.log_message('business group id : ' || l_business_grp_id);
1667: PA_MCB_INVOICE_PKG.log_message('proj org str vers id :' || l_org_struct_ver_id );
1668: PA_MCB_INVOICE_PKG.log_message('inv btch src id :' || l_batch_source_id );
1669:
1670: END IF;
1671:
1672: SELECT PROJ.Carrying_Out_Organization_ID

Line 1697: PA_MCB_INVOICE_PKG.log_message('l_invoice_date:=' || l_invoice_date);

1693: EXCEPTION
1694: WHEN NO_DATA_FOUND THEN
1695: l_invoice_date := pa_billing.GetInvoiceDate;
1696: IF g1_debug_mode = 'Y' THEN
1697: PA_MCB_INVOICE_PKG.log_message('l_invoice_date:=' || l_invoice_date);
1698: END IF;
1699: END ;
1700:
1701: IF g1_debug_mode = 'Y' THEN

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

1699: END ;
1700:
1701: IF g1_debug_mode = 'Y' THEN
1702:
1703: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);
1704: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );
1705: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');
1706:
1707: END IF;

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

1700:
1701: IF g1_debug_mode = 'Y' THEN
1702:
1703: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);
1704: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );
1705: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');
1706:
1707: END IF;
1708:

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

1701: IF g1_debug_mode = 'Y' THEN
1702:
1703: PA_MCB_INVOICE_PKG.log_message('carrying out org id : ' || l_carry_out_org_id);
1704: PA_MCB_INVOICE_PKG.log_message('basic lang code :' || l_basic_language_code );
1705: PA_MCB_INVOICE_PKG.log_message('calling get_trx_crmemo types');
1706:
1707: END IF;
1708:
1709: pa_invoice_xfer.get_trx_crmemo_types(

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

1718: P_error_message => l_error_message);
1719:
1720: IF g1_debug_mode = 'Y' THEN
1721:
1722: PA_MCB_INVOICE_PKG.log_message('trans type : ' || l_p_trx_type);
1723: PA_MCB_INVOICE_PKG.log_message('crmo trx type:' || l_cm_trx_type );
1724:
1725: END IF;
1726:

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

1719:
1720: IF g1_debug_mode = 'Y' THEN
1721:
1722: PA_MCB_INVOICE_PKG.log_message('trans type : ' || l_p_trx_type);
1723: PA_MCB_INVOICE_PKG.log_message('crmo trx type:' || l_cm_trx_type );
1724:
1725: END IF;
1726:
1727: IF nvl(p_draft_inv_num_credited,0) = 0 THEN