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

Line 71: PA_IC_INV_UTILS.log_message('In Download...');

67: loop_inc NUMBER :=0;
68: local_expenditure_item_id NUMBER :=0;
69: BEGIN
70: IF g1_debug_mode = 'Y' THEN
71: PA_IC_INV_UTILS.log_message('In Download...');
72: END IF;
73: FOR I in 1..P_rec_counter
74: LOOP
75: /* Commenting for bug 5934390

Line 153: PA_IC_INV_UTILS.log_message('download: ' || 'Within Else of down function..'||to_char(I));

149: THEN
150: /* End of code change for 5934390 */
151:
152: IF g1_debug_mode = 'Y' THEN
153: PA_IC_INV_UTILS.log_message('download: ' || 'Within Else of down function..'||to_char(I));
154: END IF;
155: local_expenditure_item_id := P_inv_rec_tab(I).EXPENDITURE_ITEM_ID;
156: IF g1_debug_mode = 'Y' THEN
157: PA_IC_INV_UTILS.log_message('download: ' || 'Exp item id ..'||local_expenditure_item_id);

Line 157: PA_IC_INV_UTILS.log_message('download: ' || 'Exp item id ..'||local_expenditure_item_id);

153: PA_IC_INV_UTILS.log_message('download: ' || 'Within Else of down function..'||to_char(I));
154: END IF;
155: local_expenditure_item_id := P_inv_rec_tab(I).EXPENDITURE_ITEM_ID;
156: IF g1_debug_mode = 'Y' THEN
157: PA_IC_INV_UTILS.log_message('download: ' || 'Exp item id ..'||local_expenditure_item_id);
158: END IF;
159:
160: UPDATE PA_EXPENDITURE_ITEMS
161: SET CC_IC_PROCESSED_CODE ='X'

Line 167: PA_IC_INV_UTILS.log_message('download: ' || 'Complete Init...'||to_char(I));

163: END IF;
164: /* End of commnet for bug 1898341*/
165:
166: IF g1_debug_mode = 'Y' THEN
167: PA_IC_INV_UTILS.log_message('download: ' || 'Complete Init...'||to_char(I));
168: END IF;
169: END LOOP;
170: /*Added for bug 1898341 */
171: P_rec_counter := loop_inc;

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

183:
184: BEGIN
185:
186: IF g1_debug_mode = 'Y' THEN
187: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In Insert...');
188: PA_IC_INV_UTILS.log_message('Insert_rows: G_Ins_count '|| to_char(G_Ins_count));
189: END IF;
190:
191: temp_G_Ins_count := G_Ins_count; /* Added for bug2739218 */

Line 188: PA_IC_INV_UTILS.log_message('Insert_rows: G_Ins_count '|| to_char(G_Ins_count));

184: BEGIN
185:
186: IF g1_debug_mode = 'Y' THEN
187: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In Insert...');
188: PA_IC_INV_UTILS.log_message('Insert_rows: G_Ins_count '|| to_char(G_Ins_count));
189: END IF;
190:
191: temp_G_Ins_count := G_Ins_count; /* Added for bug2739218 */
192:

Line 197: PA_IC_INV_UTILS.log_message('Insert_rows: Before calling download G_Ins_count' || to_char(G_Ins_count));

193: If ( G_Ins_count > 0 )
194: Then
195:
196: IF g1_debug_mode = 'Y' THEN
197: PA_IC_INV_UTILS.log_message('Insert_rows: Before calling download G_Ins_count' || to_char(G_Ins_count));
198: END IF;
199:
200: download(P_inv_rec_tab,G_Ins_count,'I');
201:

Line 203: PA_IC_INV_UTILS.log_message('Insert_rows: After calling download G_Ins_count '|| to_char(G_Ins_count));

199:
200: download(P_inv_rec_tab,G_Ins_count,'I');
201:
202: IF g1_debug_mode = 'Y' THEN
203: PA_IC_INV_UTILS.log_message('Insert_rows: After calling download G_Ins_count '|| to_char(G_Ins_count));
204: END IF;
205:
206: IF g1_debug_mode = 'Y' THEN
207: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In Insert...'|| to_char(G_Ins_count));

Line 207: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In Insert...'|| to_char(G_Ins_count));

203: PA_IC_INV_UTILS.log_message('Insert_rows: After calling download G_Ins_count '|| to_char(G_Ins_count));
204: END IF;
205:
206: IF g1_debug_mode = 'Y' THEN
207: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In Insert...'|| to_char(G_Ins_count));
208: END IF;
209:
210: FORALL I IN 1..G_Ins_count
211: INSERT INTO PA_DRAFT_INVOICE_DETAILS

Line 283: PA_IC_INV_UTILS.G_REQUEST_ID,

279: L_DENOM_CURRENCY_CODE(I),
280: L_DENOM_BILL_AMOUNT(I),
281: L_ACCT_CURRENCY_CODE(I),
282: L_BILL_AMOUNT(I),
283: PA_IC_INV_UTILS.G_REQUEST_ID,
284: SYSDATE,
285: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
286: SYSDATE,
287: PA_IC_INV_UTILS.G_CREATED_BY,

Line 285: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,

281: L_ACCT_CURRENCY_CODE(I),
282: L_BILL_AMOUNT(I),
283: PA_IC_INV_UTILS.G_REQUEST_ID,
284: SYSDATE,
285: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
286: SYSDATE,
287: PA_IC_INV_UTILS.G_CREATED_BY,
288: PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,
289: L_ACCT_RATE_TYPE(I),

Line 287: PA_IC_INV_UTILS.G_CREATED_BY,

283: PA_IC_INV_UTILS.G_REQUEST_ID,
284: SYSDATE,
285: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
286: SYSDATE,
287: PA_IC_INV_UTILS.G_CREATED_BY,
288: PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,
289: L_ACCT_RATE_TYPE(I),
290: to_date(L_ACCT_RATE_DATE(I),'DD-MM-YYYY'),
291: L_ACCT_EXCHANGE_RATE(I),

Line 288: PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,

284: SYSDATE,
285: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
286: SYSDATE,
287: PA_IC_INV_UTILS.G_CREATED_BY,
288: PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,
289: L_ACCT_RATE_TYPE(I),
290: to_date(L_ACCT_RATE_DATE(I),'DD-MM-YYYY'),
291: L_ACCT_EXCHANGE_RATE(I),
292: L_CC_PROJECT_ID(I),

Line 315: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,

311: L_BASE_AMOUNT(I),
312: L_SCHEDULE_LINE_PERCENTAGE(I),
313: L_ORIG_INV_NUM(I),
314: L_ORIG_INV_LINE_NUM(I),
315: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
316: PA_IC_INV_UTILS.G_PROGRAM_ID,
317: SYSDATE,
318: L_TP_JOB_ID(I),
319: L_PROV_PROJ_BILL_JOB_ID(I),

Line 316: PA_IC_INV_UTILS.G_PROGRAM_ID,

312: L_SCHEDULE_LINE_PERCENTAGE(I),
313: L_ORIG_INV_NUM(I),
314: L_ORIG_INV_LINE_NUM(I),
315: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
316: PA_IC_INV_UTILS.G_PROGRAM_ID,
317: SYSDATE,
318: L_TP_JOB_ID(I),
319: L_PROV_PROJ_BILL_JOB_ID(I),
320: /* Added for cross proj*/

Line 345: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Error In Insert...');

341: EXCEPTION
342: WHEN OTHERS
343: THEN
344: IF g1_debug_mode = 'Y' THEN
345: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'Error In Insert...');
346: END IF;
347: Raise;
348:
349: END Insert_rows;

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

354: IS
355: BEGIN
356:
357: IF g1_debug_mode = 'Y' THEN
358: PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In Update...');
359: END IF;
360: If ( G_Upd_count > 0)
361: Then
362: download(P_inv_rec_tab,G_Upd_count,'U');

Line 371: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID,

367: DENOM_CURRENCY_CODE = L_DENOM_CURRENCY_CODE(I),
368: DENOM_BILL_AMOUNT = L_DENOM_BILL_AMOUNT(I),
369: ACCT_CURRENCY_CODE = L_ACCT_CURRENCY_CODE(I),
370: BILL_AMOUNT = L_BILL_AMOUNT(I),
371: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID,
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
374: LAST_UPDATE_LOGIN = PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,
375: ACCT_RATE_TYPE = L_ACCT_RATE_TYPE(I),

Line 373: LAST_UPDATED_BY = PA_IC_INV_UTILS.G_LAST_UPDATED_BY,

369: ACCT_CURRENCY_CODE = L_ACCT_CURRENCY_CODE(I),
370: BILL_AMOUNT = L_BILL_AMOUNT(I),
371: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID,
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
374: LAST_UPDATE_LOGIN = PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,
375: ACCT_RATE_TYPE = L_ACCT_RATE_TYPE(I),
376: ACCT_RATE_DATE = to_date(L_ACCT_RATE_DATE(I),'DD-MM-YYYY'),
377: ACCT_EXCHANGE_RATE = L_ACCT_EXCHANGE_RATE(I),

Line 374: LAST_UPDATE_LOGIN = PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,

370: BILL_AMOUNT = L_BILL_AMOUNT(I),
371: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID,
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
374: LAST_UPDATE_LOGIN = PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN,
375: ACCT_RATE_TYPE = L_ACCT_RATE_TYPE(I),
376: ACCT_RATE_DATE = to_date(L_ACCT_RATE_DATE(I),'DD-MM-YYYY'),
377: ACCT_EXCHANGE_RATE = L_ACCT_EXCHANGE_RATE(I),
378: REV_CODE_COMBINATION_ID = L_REV_CODE_COMBINATION_ID(I),

Line 396: PROGRAM_APPLICATION_ID = PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,

392: BILL_RATE = L_BILL_RATE(I),
393: BILL_MARKUP_PERCENTAGE= L_BILL_MARKUP_PERCENTAGE(I),
394: BASE_AMOUNT = L_BASE_AMOUNT(I),
395: SCHEDULE_LINE_PERCENTAGE = L_SCHEDULE_LINE_PERCENTAGE(I),
396: PROGRAM_APPLICATION_ID = PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
397: PROGRAM_ID = PA_IC_INV_UTILS.G_PROGRAM_ID,
398: PROGRAM_UPDATE_DATE = SYSDATE,
399: TP_JOB_ID = L_TP_JOB_ID(I),
400: PROV_PROJ_BILL_JOB_ID = L_PROV_PROJ_BILL_JOB_ID(I),

Line 397: PROGRAM_ID = PA_IC_INV_UTILS.G_PROGRAM_ID,

393: BILL_MARKUP_PERCENTAGE= L_BILL_MARKUP_PERCENTAGE(I),
394: BASE_AMOUNT = L_BASE_AMOUNT(I),
395: SCHEDULE_LINE_PERCENTAGE = L_SCHEDULE_LINE_PERCENTAGE(I),
396: PROGRAM_APPLICATION_ID = PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
397: PROGRAM_ID = PA_IC_INV_UTILS.G_PROGRAM_ID,
398: PROGRAM_UPDATE_DATE = SYSDATE,
399: TP_JOB_ID = L_TP_JOB_ID(I),
400: PROV_PROJ_BILL_JOB_ID = L_PROV_PROJ_BILL_JOB_ID(I),
401: /*Cross proj*/

Line 424: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID

420: FORALL I IN 1..G_Upd_count
421: Update
422: PA_DRAFT_INVOICE_DETAILS
423: Set
424: REQUEST_ID = PA_IC_INV_UTILS.G_REQUEST_ID
425: where
426: EXPENDITURE_ITEM_ID = L_EXPENDITURE_ITEM_ID(I) and
427: DETAIL_ID_REVERSED is NOT NULL and
428: INVOICED_FLAG = 'N';

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

444: IS
445: BEGIN
446:
447: IF g1_debug_mode = 'Y' THEN
448: PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In Delete...');
449: END IF;
450: If ( G_Del_count > 0)
451: Then
452: download(P_inv_rec_tab,G_Del_count,'U');