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.

[Home] [Help]

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 192: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);

188: )
189: );
190:
191: IF g1_debug_mode = 'Y' THEN
192: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);
193: END IF;
194:
195:
196: /* Added following code to update related item when deleting invoice associated

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

227: and Draft_Invoice_Num = L_draft_inv_num
228: );
229:
230: IF g1_debug_mode = 'Y' THEN
231: pa_ic_inv_utils.log_message('Related Items: pa_expenditure_items_all rows updated = ' || SQL%rowcount);
232: END IF;
233:
234: /*End of code changes for Bug 6651747 */
235:

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

243: Where Project_id = P_project_id
244: and Draft_Invoice_Num = L_draft_inv_num;
245:
246: IF g1_debug_mode = 'Y' THEN
247: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);
248: END IF;
249:
250: /* Commented for bug 1849569
251: pa_ic_inv_utils.commit_invoice;*/

Line 251: pa_ic_inv_utils.commit_invoice;*/

247: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);
248: END IF;
249:
250: /* Commented for bug 1849569
251: pa_ic_inv_utils.commit_invoice;*/
252: end if;
253: end loop;
254: /* Added for bug 1849569*/
255: pa_ic_inv_utils.commit_invoice;

Line 255: pa_ic_inv_utils.commit_invoice;

251: pa_ic_inv_utils.commit_invoice;*/
252: end if;
253: end loop;
254: /* Added for bug 1849569*/
255: pa_ic_inv_utils.commit_invoice;
256: close C_DEL_UNAPPROVED_INV;
257: /* End for bug 1849569*/
258: IF g1_debug_mode = 'Y' THEN
259: pa_ic_inv_utils.log_message(' Leaving delete_invoices procedure ');

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

255: pa_ic_inv_utils.commit_invoice;
256: close C_DEL_UNAPPROVED_INV;
257: /* End for bug 1849569*/
258: IF g1_debug_mode = 'Y' THEN
259: pa_ic_inv_utils.log_message(' Leaving delete_invoices procedure ');
260: END IF;
261:
262: EXCEPTION
263: when others then

Line 297: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,

293: (
294: Select dia.project_id,
295: DRAFT_INVOICE_NUM,
296: sysdate,
297: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
298: sysdate,
299: PA_IC_INV_UTILS.G_CREATED_BY,
300: PA_IC_INV_UTILS.G_REQUEST_ID,
301: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,

Line 299: PA_IC_INV_UTILS.G_CREATED_BY,

295: DRAFT_INVOICE_NUM,
296: sysdate,
297: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
298: sysdate,
299: PA_IC_INV_UTILS.G_CREATED_BY,
300: PA_IC_INV_UTILS.G_REQUEST_ID,
301: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
302: PA_IC_INV_UTILS.G_PROGRAM_ID,
303: dia.invoice_Date,

Line 300: PA_IC_INV_UTILS.G_REQUEST_ID,

296: sysdate,
297: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
298: sysdate,
299: PA_IC_INV_UTILS.G_CREATED_BY,
300: PA_IC_INV_UTILS.G_REQUEST_ID,
301: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
302: PA_IC_INV_UTILS.G_PROGRAM_ID,
303: dia.invoice_Date,
304: dia.agreement_id,

Line 301: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,

297: PA_IC_INV_UTILS.G_LAST_UPDATED_BY,
298: sysdate,
299: PA_IC_INV_UTILS.G_CREATED_BY,
300: PA_IC_INV_UTILS.G_REQUEST_ID,
301: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
302: PA_IC_INV_UTILS.G_PROGRAM_ID,
303: dia.invoice_Date,
304: dia.agreement_id,
305: dia.INV_CURRENCY_CODE,

Line 302: PA_IC_INV_UTILS.G_PROGRAM_ID,

298: sysdate,
299: PA_IC_INV_UTILS.G_CREATED_BY,
300: PA_IC_INV_UTILS.G_REQUEST_ID,
301: PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID,
302: PA_IC_INV_UTILS.G_PROGRAM_ID,
303: dia.invoice_Date,
304: dia.agreement_id,
305: dia.INV_CURRENCY_CODE,
306: (SELECT SUM(INV_AMOUNT)