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_MC_INVOICE_DETAIL_PKG dependencies on PA_IC_INV_UTILS

Line 86: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'In Compute MRC ...');

82: l_sob_id := PA_MC_INVOICE_DETAIL_PKG.G_SOB;
83: P_tot_record := 0;
84:
85: IF g1_debug_mode = 'Y' THEN
86: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'In Compute MRC ...');
87: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Set of books...'||to_char(G_No_of_SOB));
88: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Total Record...'||to_char(P_rec_counter));
89: END IF;
90: FOR I IN 1..P_rec_counter

Line 87: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Set of books...'||to_char(G_No_of_SOB));

83: P_tot_record := 0;
84:
85: IF g1_debug_mode = 'Y' THEN
86: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'In Compute MRC ...');
87: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Set of books...'||to_char(G_No_of_SOB));
88: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Total Record...'||to_char(P_rec_counter));
89: END IF;
90: FOR I IN 1..P_rec_counter
91: LOOP

Line 88: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Total Record...'||to_char(P_rec_counter));

84:
85: IF g1_debug_mode = 'Y' THEN
86: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'In Compute MRC ...');
87: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Set of books...'||to_char(G_No_of_SOB));
88: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Total Record...'||to_char(P_rec_counter));
89: END IF;
90: FOR I IN 1..P_rec_counter
91: LOOP
92: IF not( P_mrc_reqd_flag.exists(I))

Line 102: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Get EI Details....');

98:
99: if (not P_trx_date.exists(I))
100: then
101: IF g1_debug_mode = 'Y' THEN
102: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Get EI Details....');
103: END IF;
104: pa_mc_currency_pkg.eiid_details(
105: x_eiid => P_inv_rec_tab(I).EXPENDITURE_ITEM_ID,
106: x_orig_trx => orig_ref,

Line 118: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get EI Details....');

114: x_err_stack => l_err_stack,
115: x_err_stage => l_err_stage,
116: x_err_code => l_err_code );
117: IF g1_debug_mode = 'Y' THEN
118: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get EI Details....');
119: END IF;
120: else
121: ei_date := P_trx_date(I);
122: end if;

Line 125: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'In Process of Compute MRC...');

121: ei_date := P_trx_date(I);
122: end if;
123:
124: IF g1_debug_mode = 'Y' THEN
125: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'In Process of Compute MRC...');
126: END IF;
127: IF (L_mrc_reqd_flag = 'Y')
128: THEN
129: FOR J IN 1..G_No_of_SOB

Line 138: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Detail Id Rev....'||

134:
135: If (P_inv_rec_tab(I).DETAIL_ID_REVERSED IS NOT NULL)
136: Then
137: IF g1_debug_mode = 'Y' THEN
138: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Detail Id Rev....'||
139: to_char(P_inv_rec_tab(I).DETAIL_ID_REVERSED));
140: END IF;
141: get_orig_exchg_rate (P_inv_rec_tab(I).DETAIL_ID_REVERSED,
142: G_Reporting_SOB(J),l_exchange_rate,

Line 147: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Get Rate....');

143: l_exchange_date,l_exchange_rate_type,l_bill_amt );
144: L_BILL_AMOUNT(K) := l_bill_amt;
145: ELSE
146: IF g1_debug_mode = 'Y' THEN
147: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Get Rate....');
148: END IF;
149:
150: l_currency := P_inv_rec_tab(I).DENOM_CURRENCY_CODE;
151: l_exchange_rate_type := P_inv_rec_tab(I).ACCT_RATE_TYPE;

Line 156: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Calling.....');

152: l_exchange_date := ei_date;
153: l_exchange_rate := P_inv_rec_tab(I).ACCT_EXCHANGE_RATE;
154:
155: IF g1_debug_mode = 'Y' THEN
156: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Calling.....');
157: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Primary Set of Books'||
158: to_char(l_sob_id));
159: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Date'||
160: to_char(ei_date, 'YYYY/MM/DD'));

Line 157: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Primary Set of Books'||

153: l_exchange_rate := P_inv_rec_tab(I).ACCT_EXCHANGE_RATE;
154:
155: IF g1_debug_mode = 'Y' THEN
156: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Calling.....');
157: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Primary Set of Books'||
158: to_char(l_sob_id));
159: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Date'||
160: to_char(ei_date, 'YYYY/MM/DD'));
161: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Currency'||

Line 159: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Date'||

155: IF g1_debug_mode = 'Y' THEN
156: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Calling.....');
157: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Primary Set of Books'||
158: to_char(l_sob_id));
159: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Date'||
160: to_char(ei_date, 'YYYY/MM/DD'));
161: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Currency'||
162: l_currency);
163: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con Type'||

Line 161: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Currency'||

157: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Primary Set of Books'||
158: to_char(l_sob_id));
159: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Date'||
160: to_char(ei_date, 'YYYY/MM/DD'));
161: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Currency'||
162: l_currency);
163: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con Type'||
164: l_exchange_rate_type);
165: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con date'||

Line 163: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con Type'||

159: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Date'||
160: to_char(ei_date, 'YYYY/MM/DD'));
161: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Currency'||
162: l_currency);
163: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con Type'||
164: l_exchange_rate_type);
165: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con date'||
166: l_exchange_date);
167: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con rate'||

Line 165: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con date'||

161: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Currency'||
162: l_currency);
163: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con Type'||
164: l_exchange_rate_type);
165: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con date'||
166: l_exchange_date);
167: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con rate'||
168: l_exchange_rate);
169: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Ous ...'||

Line 167: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con rate'||

163: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con Type'||
164: l_exchange_rate_type);
165: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con date'||
166: l_exchange_date);
167: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con rate'||
168: l_exchange_rate);
169: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Ous ...'||
170: to_char(PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID));
171: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Reporting ...'||

Line 169: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Ous ...'||

165: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con date'||
166: l_exchange_date);
167: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con rate'||
168: l_exchange_rate);
169: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Ous ...'||
170: to_char(PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID));
171: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Reporting ...'||
172: to_char(G_Reporting_SOB(J)));
173: END IF;

Line 171: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Reporting ...'||

167: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Transaction Con rate'||
168: l_exchange_rate);
169: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Ous ...'||
170: to_char(PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID));
171: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Reporting ...'||
172: to_char(G_Reporting_SOB(J)));
173: END IF;
174: gl_mc_currency_pkg.get_rate ( p_primary_set_of_books_id => l_sob_id,
175: p_reporting_set_of_books_id =>

Line 196: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get Rate Process');

192: p_denominator_rate => l_denom,
193: p_numerator_rate => l_num );
194:
195: IF g1_debug_mode = 'Y' THEN
196: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get Rate Process');
197: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Result Code'|| l_result_code);
198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||
199: to_char(l_exchange_rate, 'YYYY/MM/DD'));
200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));

Line 197: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Result Code'|| l_result_code);

193: p_numerator_rate => l_num );
194:
195: IF g1_debug_mode = 'Y' THEN
196: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get Rate Process');
197: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Result Code'|| l_result_code);
198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||
199: to_char(l_exchange_rate, 'YYYY/MM/DD'));
200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));
201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));

Line 198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||

194:
195: IF g1_debug_mode = 'Y' THEN
196: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get Rate Process');
197: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Result Code'|| l_result_code);
198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||
199: to_char(l_exchange_rate, 'YYYY/MM/DD'));
200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));
201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));
202: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'End Printing........');

Line 200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));

196: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Get Rate Process');
197: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Result Code'|| l_result_code);
198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||
199: to_char(l_exchange_rate, 'YYYY/MM/DD'));
200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));
201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));
202: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'End Printing........');
203: END IF;
204:

Line 201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));

197: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Result Code'|| l_result_code);
198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||
199: to_char(l_exchange_rate, 'YYYY/MM/DD'));
200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));
201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));
202: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'End Printing........');
203: END IF;
204:
205: PA_IC_INV_UTILS.log_message('Bill Amt in MRC....'||

Line 202: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'End Printing........');

198: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Exchange Rate....'||
199: to_char(l_exchange_rate, 'YYYY/MM/DD'));
200: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Denominator....'|| to_char(l_denom));
201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));
202: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'End Printing........');
203: END IF;
204:
205: PA_IC_INV_UTILS.log_message('Bill Amt in MRC....'||
206: to_char((P_inv_rec_tab(I).DENOM_BILL_AMOUNT * l_num)/l_denom));

Line 205: PA_IC_INV_UTILS.log_message('Bill Amt in MRC....'||

201: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Numrator....'|| to_char(l_num));
202: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'End Printing........');
203: END IF;
204:
205: PA_IC_INV_UTILS.log_message('Bill Amt in MRC....'||
206: to_char((P_inv_rec_tab(I).DENOM_BILL_AMOUNT * l_num)/l_denom));
207:
208: L_BILL_AMOUNT(K) := pa_mc_currency_pkg.CurrRound (
209: (P_inv_rec_tab(I).DENOM_BILL_AMOUNT * l_num)/l_denom,

Line 212: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Compute...'||

208: L_BILL_AMOUNT(K) := pa_mc_currency_pkg.CurrRound (
209: (P_inv_rec_tab(I).DENOM_BILL_AMOUNT * l_num)/l_denom,
210: G_Reporting_Curr(J));
211: IF g1_debug_mode = 'Y' THEN
212: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'After Compute...'||
213: to_char(L_BILL_AMOUNT(K)));
214: END IF;
215: end if;
216: IF g1_debug_mode = 'Y' THEN

Line 217: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Insert...');

213: to_char(L_BILL_AMOUNT(K)));
214: END IF;
215: end if;
216: IF g1_debug_mode = 'Y' THEN
217: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Before Insert...');
218: END IF;
219: L_ACCT_EXCHANGE_RATE(K) := l_exchange_rate;
220:
221: /* Release 12: ATG changes : Change the date form to YYYY/MM/DD */

Line 236: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Index '|| to_char(K));

232: L_PROG_ID(K) := P_inv_rec_tab(I).PROGRAM_ID;
233: L_PROG_UPDATE_DATE(K)
234: := to_char(P_inv_rec_tab(I).PROGRAM_UPDATE_DATE,'YYYY/MM/DD');
235: IF g1_debug_mode = 'Y' THEN
236: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Index '|| to_char(K));
237: END IF;
238: END LOOP;
239: END IF;
240: END LOOP;

Line 244: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Total Record '|| to_char(l_tot_record));

240: END LOOP;
241: -- Total Number of records in Array
242: P_tot_record := l_tot_record;
243: IF g1_debug_mode = 'Y' THEN
244: PA_IC_INV_UTILS.log_message('compute_mrc: ' || 'Total Record '|| to_char(l_tot_record));
245: END IF;
246:
247: EXCEPTION
248: WHEN OTHERS

Line 267: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');

263: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;
264: BEGIN
265: c := 0;
266: IF g1_debug_mode = 'Y' THEN
267: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');
268: END IF;
269:
270: /* Compute the MRC amount and populate the global array */
271: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )

Line 277: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));

273: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,
274: l_mrc_reqd_flag,l_tot_count);
275: c := 10;
276: IF g1_debug_mode = 'Y' THEN
277: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));
278: END IF;
279:
280: /* If MRC records are created, insert in PA_MC_DRAFT_INV_DETAILS */
281: if (l_tot_count > 0)

Line 284: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Before Insert...');

280: /* If MRC records are created, insert in PA_MC_DRAFT_INV_DETAILS */
281: if (l_tot_count > 0)
282: Then
283: IF g1_debug_mode = 'Y' THEN
284: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Before Insert...');
285: END IF;
286: FOR I IN 1..l_tot_count
287: LOOP
288: c := 50;

Line 290: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));

286: FOR I IN 1..l_tot_count
287: LOOP
288: c := 50;
289: IF g1_debug_mode = 'Y' THEN
290: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));
291: END IF;
292: c := 11;
293: IF g1_debug_mode = 'Y' THEN
294: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));

Line 294: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));

290: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));
291: END IF;
292: c := 11;
293: IF g1_debug_mode = 'Y' THEN
294: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));
295: END IF;
296: c := 12;
297: IF g1_debug_mode = 'Y' THEN
298: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));

Line 298: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));

294: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));
295: END IF;
296: c := 12;
297: IF g1_debug_mode = 'Y' THEN
298: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));
299: END IF;
300: c := 13;
301: IF g1_debug_mode = 'Y' THEN
302: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));

Line 302: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));

298: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));
299: END IF;
300: c := 13;
301: IF g1_debug_mode = 'Y' THEN
302: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));
303: END IF;
304: c := 14;
305: IF g1_debug_mode = 'Y' THEN
306: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));

Line 306: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));

302: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));
303: END IF;
304: c := 14;
305: IF g1_debug_mode = 'Y' THEN
306: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));
307: END IF;
308: c := 15;
309: IF g1_debug_mode = 'Y' THEN
310: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));

Line 310: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));

306: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));
307: END IF;
308: c := 15;
309: IF g1_debug_mode = 'Y' THEN
310: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));
311: END IF;
312: c := 16;
313: IF g1_debug_mode = 'Y' THEN
314: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));

Line 314: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));

310: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));
311: END IF;
312: c := 16;
313: IF g1_debug_mode = 'Y' THEN
314: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));
315: END IF;
316: c := 17;
317: IF g1_debug_mode = 'Y' THEN
318: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));

Line 318: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));

314: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));
315: END IF;
316: c := 17;
317: IF g1_debug_mode = 'Y' THEN
318: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));
319: END IF;
320: c := 18;
321: IF g1_debug_mode = 'Y' THEN
322: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));

Line 322: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));

318: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));
319: END IF;
320: c := 18;
321: IF g1_debug_mode = 'Y' THEN
322: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));
323: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));
324: END IF;
325: c := 19;
326: END LOOP;

Line 323: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));

319: END IF;
320: c := 18;
321: IF g1_debug_mode = 'Y' THEN
322: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));
323: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));
324: END IF;
325: c := 19;
326: END LOOP;
327:

Line 343: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'End Insert...');

339: END LOOP;
340: /* End of Changes done for bug 2739218 */
341:
342: IF g1_debug_mode = 'Y' THEN
343: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'End Insert...');
344: END IF;
345: End if;
346: End if;
347: EXCEPTION

Line 351: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert Error..'|| to_char(c));

347: EXCEPTION
348: WHEN OTHERS
349: THEN
350: IF g1_debug_mode = 'Y' THEN
351: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert Error..'|| to_char(c));
352: END IF;
353: Raise;
354:
355: END Insert_rows;

Line 369: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');

365: c number;
366: BEGIN
367: c := 0;
368: IF g1_debug_mode = 'Y' THEN
369: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');
370: END IF;
371: /* Compute the MRC amount and populate the global array */
372: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )
373: Then

Line 378: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));

374: compute_mrc(P_inv_rec_tab,P_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,
375: l_mrc_reqd_flag,l_tot_count);
376: c := 10;
377: IF g1_debug_mode = 'Y' THEN
378: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));
379: END IF;
380: /* If MRC records are created, insert in PA_MC_DRAFT_INV_DETAILS */
381: if (l_tot_count > 0)
382: Then

Line 384: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Before Insert...');

380: /* If MRC records are created, insert in PA_MC_DRAFT_INV_DETAILS */
381: if (l_tot_count > 0)
382: Then
383: IF g1_debug_mode = 'Y' THEN
384: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Before Insert...');
385: END IF;
386: FOR I IN 1..l_tot_count
387: LOOP
388: c := 50;

Line 391: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));

387: LOOP
388: c := 50;
389:
390: IF g1_debug_mode = 'Y' THEN
391: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));
392: END IF;
393: c := 11;
394: IF g1_debug_mode = 'Y' THEN
395: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));

Line 395: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));

391: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Details Id'||to_char(L_DRAFT_INV_DET_ID(I)));
392: END IF;
393: c := 11;
394: IF g1_debug_mode = 'Y' THEN
395: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));
396: END IF;
397: c := 12;
398: IF g1_debug_mode = 'Y' THEN
399: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));

Line 399: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));

395: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Project Id'||to_char(L_PROJECT_ID(I)));
396: END IF;
397: c := 12;
398: IF g1_debug_mode = 'Y' THEN
399: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));
400: END IF;
401: c := 13;
402: IF g1_debug_mode = 'Y' THEN
403: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));

Line 403: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));

399: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Invoiced Flag'||L_INVOICED_FLAG(I));
400: END IF;
401: c := 13;
402: IF g1_debug_mode = 'Y' THEN
403: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));
404: END IF;
405: c := 14;
406: IF g1_debug_mode = 'Y' THEN
407: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));

Line 407: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));

403: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Set of Books Id'||to_char(L_SETS_OF_BOOKS_ID(I)));
404: END IF;
405: c := 14;
406: IF g1_debug_mode = 'Y' THEN
407: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));
408: END IF;
409: c := 15;
410: IF g1_debug_mode = 'Y' THEN
411: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));

Line 411: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));

407: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Account Currency'||L_ACCT_CURRENCY_CODE(I));
408: END IF;
409: c := 15;
410: IF g1_debug_mode = 'Y' THEN
411: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));
412: END IF;
413: c := 16;
414: IF g1_debug_mode = 'Y' THEN
415: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));

Line 415: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));

411: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Bill Amount'||to_char(L_BILL_AMOUNT(I)));
412: END IF;
413: c := 16;
414: IF g1_debug_mode = 'Y' THEN
415: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));
416: END IF;
417: c := 17;
418: IF g1_debug_mode = 'Y' THEN
419: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));

Line 419: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));

415: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Request Id'||to_char(PA_IC_INV_UTILS.G_REQUEST_ID));
416: END IF;
417: c := 17;
418: IF g1_debug_mode = 'Y' THEN
419: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));
420: END IF;
421: c := 18;
422: IF g1_debug_mode = 'Y' THEN
423: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));

Line 423: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));

419: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Type'||L_ACCT_RATE_TYPE(I));
420: END IF;
421: c := 18;
422: IF g1_debug_mode = 'Y' THEN
423: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));
424: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));
425: END IF;
426: c := 19;
427: END LOOP;

Line 424: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));

420: END IF;
421: c := 18;
422: IF g1_debug_mode = 'Y' THEN
423: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Rate Date'||L_ACCT_RATE_DATE(I));
424: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Acct Exchg Rate '||L_ACCT_EXCHANGE_RATE(I));
425: END IF;
426: c := 19;
427: END LOOP;
428:

Line 432: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'End Insert...');

428:
429: c := 20;
430: /* Array Insert of MRC records */
431: IF g1_debug_mode = 'Y' THEN
432: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'End Insert...');
433: END IF;
434: End if;
435: End if;
436: EXCEPTION

Line 440: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert Error..'|| to_char(c));

436: EXCEPTION
437: WHEN OTHERS
438: THEN
439: IF g1_debug_mode = 'Y' THEN
440: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert Error..'|| to_char(c));
441: END IF;
442: Raise;
443:
444: END Insert_rows;

Line 455: PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In MRC Update...');

451: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;
452: BEGIN
453:
454: IF g1_debug_mode = 'Y' THEN
455: PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In MRC Update...');
456: END IF;
457: If ( PA_INVOICE_DETAIL_PKG.G_Upd_count > 0)
458: Then
459: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Upd_count,

Line 479: PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In MRC Delete...');

475: l_draft_line_id PA_PLSQL_DATATYPES.numtabtyp;
476: BEGIN
477:
478: IF g1_debug_mode = 'Y' THEN
479: PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In MRC Delete...');
480: END IF;
481: If ( PA_INVOICE_DETAIL_PKG.G_Del_count > 0)
482: Then
483: download(P_inv_rec_tab,PA_INVOICE_DETAIL_PKG.G_Del_count,l_draft_line_id);