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

Line 64: pa_ic_inv_utils.log_message(' Entering delete_invoices procedure ');

60:
61: BEGIN
62:
63: IF g1_debug_mode = 'Y' THEN
64: pa_ic_inv_utils.log_message(' Entering delete_invoices procedure ');
65: END IF;
66:
67: l_user_id := pa_ic_inv_utils.g_last_update_login;
68: l_program_id := pa_ic_inv_utils.g_program_id;

Line 67: l_user_id := pa_ic_inv_utils.g_last_update_login;

63: IF g1_debug_mode = 'Y' THEN
64: pa_ic_inv_utils.log_message(' Entering delete_invoices procedure ');
65: END IF;
66:
67: l_user_id := pa_ic_inv_utils.g_last_update_login;
68: l_program_id := pa_ic_inv_utils.g_program_id;
69: l_program_application_id := pa_ic_inv_utils.g_program_application_id;
70: l_request_id := pa_ic_inv_utils.g_request_id;
71:

Line 68: l_program_id := pa_ic_inv_utils.g_program_id;

64: pa_ic_inv_utils.log_message(' Entering delete_invoices procedure ');
65: END IF;
66:
67: l_user_id := pa_ic_inv_utils.g_last_update_login;
68: l_program_id := pa_ic_inv_utils.g_program_id;
69: l_program_application_id := pa_ic_inv_utils.g_program_application_id;
70: l_request_id := pa_ic_inv_utils.g_request_id;
71:
72: /**** logic is as follows

Line 69: l_program_application_id := pa_ic_inv_utils.g_program_application_id;

65: END IF;
66:
67: l_user_id := pa_ic_inv_utils.g_last_update_login;
68: l_program_id := pa_ic_inv_utils.g_program_id;
69: l_program_application_id := pa_ic_inv_utils.g_program_application_id;
70: l_request_id := pa_ic_inv_utils.g_request_id;
71:
72: /**** logic is as follows
73:

Line 70: l_request_id := pa_ic_inv_utils.g_request_id;

66:
67: l_user_id := pa_ic_inv_utils.g_last_update_login;
68: l_program_id := pa_ic_inv_utils.g_program_id;
69: l_program_application_id := pa_ic_inv_utils.g_program_application_id;
70: l_request_id := pa_ic_inv_utils.g_request_id;
71:
72: /**** logic is as follows
73:
74: OPEN C_DEL_UNAPPROVED_INV ;

Line 100: pa_ic_inv_utils.update_spf (l_draft_inv_num,

96: EXIT;
97: END IF;
98: /* Addedd for bug 7172117 */
99: IF((p_unapproved_inv_only ='Y' and l_inv_unapproved is null) or (p_unapproved_inv_only = 'N')) then
100: pa_ic_inv_utils.update_spf (l_draft_inv_num,
101: l_agreement_id,
102: p_project_id,
103: 'DELETE' );
104:

Line 110: pa_ic_inv_utils.log_message('pa_distribution_warnings rows deleted = ' || SQL%rowcount);

106: where project_id = P_PROJECT_ID
107: and draft_invoice_num = l_draft_inv_num;
108:
109: IF g1_debug_mode = 'Y' THEN
110: pa_ic_inv_utils.log_message('pa_distribution_warnings rows deleted = ' || SQL%rowcount);
111: END IF;
112:
113: if p_mass_delete = 'Y' then /*Added for bug 7026205*/
114: insert_dist_warnings(p_project_id,

Line 123: pa_ic_inv_utils.log_message('pa_draft_invoice_items rows deleted = ' || SQL%rowcount);

119: where project_id = P_PROJECT_ID
120: and draft_invoice_num = l_draft_inv_num;
121:
122: IF g1_debug_mode = 'Y' THEN
123: pa_ic_inv_utils.log_message('pa_draft_invoice_items rows deleted = ' || SQL%rowcount);
124: END IF;
125:
126: delete from pa_draft_invoices
127: where project_id = P_PROJECT_ID

Line 131: pa_ic_inv_utils.log_message('pa_draft_invoices rows deleted = ' || SQL%rowcount);

127: where project_id = P_PROJECT_ID
128: and draft_invoice_num = l_draft_inv_num;
129:
130: IF g1_debug_mode = 'Y' THEN
131: pa_ic_inv_utils.log_message('pa_draft_invoices rows deleted = ' || SQL%rowcount);
132: END IF;
133:
134: /* Added denom transfer price and denom tp_currency code for bug 2638956 */
135: /* Added acct_tp columns for bug 5276946 */

Line 180: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);

176: )
177: );
178:
179: IF g1_debug_mode = 'Y' THEN
180: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);
181: END IF;
182:
183:
184: /* Added following code to update related item when deleting invoice associated

Line 219: pa_ic_inv_utils.log_message('Related Items: pa_expenditure_items_all rows updated = ' || SQL%rowcount);

215: and Draft_Invoice_Num = L_draft_inv_num
216: );
217:
218: IF g1_debug_mode = 'Y' THEN
219: pa_ic_inv_utils.log_message('Related Items: pa_expenditure_items_all rows updated = ' || SQL%rowcount);
220: END IF;
221:
222: /*End of code changes for Bug 6651747 */
223:

Line 235: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);

231: Where Project_id = P_project_id
232: and Draft_Invoice_Num = L_draft_inv_num;
233:
234: IF g1_debug_mode = 'Y' THEN
235: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);
236: END IF;
237:
238: /* Commented for bug 1849569
239: pa_ic_inv_utils.commit_invoice;*/

Line 239: pa_ic_inv_utils.commit_invoice;*/

235: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);
236: END IF;
237:
238: /* Commented for bug 1849569
239: pa_ic_inv_utils.commit_invoice;*/
240: end if;
241: end loop;
242: /* Added for bug 1849569*/
243: pa_ic_inv_utils.commit_invoice;

Line 243: pa_ic_inv_utils.commit_invoice;

239: pa_ic_inv_utils.commit_invoice;*/
240: end if;
241: end loop;
242: /* Added for bug 1849569*/
243: pa_ic_inv_utils.commit_invoice;
244: close C_DEL_UNAPPROVED_INV;
245: /* End for bug 1849569*/
246: IF g1_debug_mode = 'Y' THEN
247: pa_ic_inv_utils.log_message(' Leaving delete_invoices procedure ');

Line 247: pa_ic_inv_utils.log_message(' Leaving delete_invoices procedure ');

243: pa_ic_inv_utils.commit_invoice;
244: close C_DEL_UNAPPROVED_INV;
245: /* End for bug 1849569*/
246: IF g1_debug_mode = 'Y' THEN
247: pa_ic_inv_utils.log_message(' Leaving delete_invoices procedure ');
248: END IF;
249:
250: EXCEPTION
251: when others then

Line 285: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,

281: (
282: Select dia.project_id,
283: DRAFT_INVOICE_NUM,
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_REQUEST_ID,
289: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,

Line 287: PA_IC_INV_UTILS.G_CREATED_BY,

283: DRAFT_INVOICE_NUM,
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_REQUEST_ID,
289: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
290: PA_IC_INV_UTILS.G_PROGRAM_ID,
291: dia.invoice_Date,

Line 288: 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_REQUEST_ID,
289: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
290: PA_IC_INV_UTILS.G_PROGRAM_ID,
291: dia.invoice_Date,
292: dia.agreement_id,

Line 289: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,

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_REQUEST_ID,
289: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
290: PA_IC_INV_UTILS.G_PROGRAM_ID,
291: dia.invoice_Date,
292: dia.agreement_id,
293: dia.INV_CURRENCY_CODE,

Line 290: PA_IC_INV_UTILS.G_PROGRAM_ID,

286: sysdate,
287: PA_IC_INV_UTILS.G_CREATED_BY,
288: PA_IC_INV_UTILS.G_REQUEST_ID,
289: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
290: PA_IC_INV_UTILS.G_PROGRAM_ID,
291: dia.invoice_Date,
292: dia.agreement_id,
293: dia.INV_CURRENCY_CODE,
294: (SELECT SUM(INV_AMOUNT)