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.ARP_APP_PKG dependencies on STANDARD

Line 87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );

83: p_ra_rec IN ar_receivable_applications%ROWTYPE
84: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
86: BEGIN
87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
88: arp_standard.debug(' p_ra_id = ' || p_ra_id);
89: IF p_ra_id IS NULL
90: THEN
91: SELECT ar_receivable_applications_s.nextval

Line 88: arp_standard.debug(' p_ra_id = ' || p_ra_id);

84: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
86: BEGIN
87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
88: arp_standard.debug(' p_ra_id = ' || p_ra_id);
89: IF p_ra_id IS NULL
90: THEN
91: SELECT ar_receivable_applications_s.nextval
92: INTO l_ra_id

Line 94: arp_standard.debug(' assigned l_ra_id = ' || l_ra_id);

90: THEN
91: SELECT ar_receivable_applications_s.nextval
92: INTO l_ra_id
93: FROM dual;
94: arp_standard.debug(' assigned l_ra_id = ' || l_ra_id);
95: ELSE
96: l_ra_id := p_ra_id;
97: END IF;
98:

Line 228: arp_standard.profile.user_id,

224: p_ra_rec.application_rule,
225: p_ra_rec.application_type,
226: p_ra_rec.apply_date,
227: p_ra_rec.code_combination_id,
228: arp_standard.profile.user_id,
229: SYSDATE,
230: p_ra_rec.display,
231: TRUNC(p_ra_rec.gl_date),
232: arp_standard.profile.user_id,

Line 232: arp_standard.profile.user_id,

228: arp_standard.profile.user_id,
229: SYSDATE,
230: p_ra_rec.display,
231: TRUNC(p_ra_rec.gl_date),
232: arp_standard.profile.user_id,
233: SYSDATE,
234: p_ra_rec.payment_schedule_id,
235: arp_global.set_of_books_id,
236: p_ra_rec.status,

Line 251: NVL( arp_standard.profile.last_update_login,

247: p_ra_rec.days_late,
248: p_ra_rec.earned_discount_taken,
249: p_ra_rec.freight_applied,
250: p_ra_rec.gl_posted_date,
251: NVL( arp_standard.profile.last_update_login,
252: p_ra_rec.last_update_login ),
253: p_ra_rec.line_applied,
254: p_ra_rec.postable,
255: p_ra_rec.posting_control_id,

Line 256: NVL( arp_standard.profile.program_application_id,

252: p_ra_rec.last_update_login ),
253: p_ra_rec.line_applied,
254: p_ra_rec.postable,
255: p_ra_rec.posting_control_id,
256: NVL( arp_standard.profile.program_application_id,
257: p_ra_rec.program_application_id ),
258: NVL(
259: decode(arp_standard.profile.program_id
260: ,-1,p_ra_rec.program_id)

Line 259: decode(arp_standard.profile.program_id

255: p_ra_rec.posting_control_id,
256: NVL( arp_standard.profile.program_application_id,
257: p_ra_rec.program_application_id ),
258: NVL(
259: decode(arp_standard.profile.program_id
260: ,-1,p_ra_rec.program_id)
261: ,p_ra_rec.program_id),
262: DECODE( arp_standard.profile.program_id,
263: NULL, NULL, SYSDATE ),

Line 262: DECODE( arp_standard.profile.program_id,

258: NVL(
259: decode(arp_standard.profile.program_id
260: ,-1,p_ra_rec.program_id)
261: ,p_ra_rec.program_id),
262: DECODE( arp_standard.profile.program_id,
263: NULL, NULL, SYSDATE ),
264: p_ra_rec.receivables_charges_applied,
265: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),
266: p_ra_rec.tax_applied,

Line 265: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),

261: ,p_ra_rec.program_id),
262: DECODE( arp_standard.profile.program_id,
263: NULL, NULL, SYSDATE ),
264: p_ra_rec.receivables_charges_applied,
265: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),
266: p_ra_rec.tax_applied,
267: p_ra_rec.unearned_discount_taken,
268: p_ra_rec.unearned_discount_ccid,
269: p_ra_rec.earned_discount_ccid,

Line 337: ,arp_standard.sysparm.org_id /* SSA changes anuj */

333: p_ra_rec.application_ref_reason,
334: p_ra_rec.customer_reference,
335: p_ra_rec.customer_reason,
336: p_ra_rec.applied_rec_app_id
337: ,arp_standard.sysparm.org_id /* SSA changes anuj */
338: ,'R12'
339: ,p_ra_rec.include_in_accumulation -- Bug 6924942
340: ,p_ra_rec.on_acct_cust_id
341: ,p_ra_rec.on_acct_cust_site_use_id

Line 346: arp_standard.debug( 'arp_app_pkg.insert_p()-' );

342: ,p_ra_rec.on_acct_po_num
343: );
344: p_ra_id := l_ra_id;
345:
346: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
347: EXCEPTION
348: WHEN OTHERS THEN
349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );

Line 349: arp_standard.debug(

345:
346: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
347: EXCEPTION
348: WHEN OTHERS THEN
349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );
351: arp_standard.debug('SYSDATE = ' || SYSDATE);
352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,

Line 351: arp_standard.debug('SYSDATE = ' || SYSDATE);

347: EXCEPTION
348: WHEN OTHERS THEN
349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );
351: arp_standard.debug('SYSDATE = ' || SYSDATE);
352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');

Line 352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));

348: WHEN OTHERS THEN
349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );
351: arp_standard.debug('SYSDATE = ' || SYSDATE);
352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);

Line 353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,

349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );
351: arp_standard.debug('SYSDATE = ' || SYSDATE);
352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));

Line 355: arp_standard.debug('---------------------------');

351: arp_standard.debug('SYSDATE = ' || SYSDATE);
352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));

Line 356: arp_standard.debug('ra_id = ' || l_ra_id);

352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));

Line 357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));

353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));

Line 358: arp_standard.debug('last_update_date ' || SYSDATE);

354: p_ra_rec.last_update_login) ), ''));
355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));

Line 359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));

355: arp_standard.debug('---------------------------');
356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);

Line 360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));

356: arp_standard.debug('ra_id = ' || l_ra_id);
357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));

Line 361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));

357: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);

Line 362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));

358: arp_standard.debug('last_update_date ' || SYSDATE);
359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);

Line 363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);

359: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);

Line 364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));

360: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);

Line 365: arp_standard.debug('display ' || p_ra_rec.display);

361: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));

Line 366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);

362: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);

Line 367: arp_standard.debug('application_type ' || p_ra_rec.application_type);

363: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));

Line 368: arp_standard.debug('status ' || p_ra_rec.status);

364: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));

Line 369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));

365: arp_standard.debug('display ' || p_ra_rec.display);
366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));

Line 370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);

366: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));

Line 371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));

367: arp_standard.debug('application_type ' || p_ra_rec.application_type);
368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));

Line 372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));

368: arp_standard.debug('status ' || p_ra_rec.status);
369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));

Line 373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));

369: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));

Line 374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));

370: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));

Line 375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));

371: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));

Line 376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));

372: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));

Line 377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));

373: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));

Line 378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));

374: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);

Line 379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));

375: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);

Line 380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));

376: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);

Line 381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));

377: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);

Line 382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);

378: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);

Line 383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);

379: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);

Line 384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);

380: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));

Line 385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);

381: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);

Line 386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);

382: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);

Line 387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);

383: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));

Line 388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));

384: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);

Line 389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);

385: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);

Line 390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);

386: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);

Line 391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));

387: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));

Line 392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);

388: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));

Line 393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);

389: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));
397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));

Line 394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);

390: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));
397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));
398: arp_standard.debug('on_acct_po_num='||to_char(p_ra_rec.on_acct_po_num));

Line 395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));

391: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));
397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));
398: arp_standard.debug('on_acct_po_num='||to_char(p_ra_rec.on_acct_po_num));
399:

Line 396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));

392: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));
397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));
398: arp_standard.debug('on_acct_po_num='||to_char(p_ra_rec.on_acct_po_num));
399:
400:

Line 397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));

393: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));
397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));
398: arp_standard.debug('on_acct_po_num='||to_char(p_ra_rec.on_acct_po_num));
399:
400:
401:

Line 398: arp_standard.debug('on_acct_po_num='||to_char(p_ra_rec.on_acct_po_num));

394: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
395: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
396: arp_standard.debug('on_acct_cust_id='||to_char(p_ra_rec.on_acct_cust_id));
397: arp_standard.debug('on_acct_cust_site_use_id='||to_char(p_ra_rec.on_acct_cust_site_use_id));
398: arp_standard.debug('on_acct_po_num='||to_char(p_ra_rec.on_acct_po_num));
399:
400:
401:
402:

Line 463: arp_standard.debug( 'arp_app_pkg.update_p()+' );

459: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
460: lc_dump VARCHAR2(30000);
461:
462: BEGIN
463: arp_standard.debug( 'arp_app_pkg.update_p()+' );
464:
465: UPDATE ar_receivable_applications ra SET
466: acctd_amount_applied_from =
467: p_ra_rec.acctd_amount_applied_from,

Line 477: last_updated_by = arp_standard.profile.user_id,

473: apply_date = p_ra_rec.apply_date,
474: code_combination_id = p_ra_rec.code_combination_id,
475: display = p_ra_rec.display,
476: gl_date = p_ra_rec.gl_date,
477: last_updated_by = arp_standard.profile.user_id,
478: last_update_date = SYSDATE,
479: payment_schedule_id = p_ra_rec.payment_schedule_id,
480: set_of_books_id = p_ra_rec.set_of_books_id,
481: status = p_ra_rec.status,

Line 501: NVL( arp_standard.profile.last_update_login,

497: earned_discount_taken = p_ra_rec.earned_discount_taken,
498: freight_applied = p_ra_rec.freight_applied,
499: gl_posted_date = p_ra_rec.gl_posted_date,
500: last_update_login =
501: NVL( arp_standard.profile.last_update_login,
502: p_ra_rec.last_update_login ),
503: line_applied = p_ra_rec.line_applied,
504: postable = p_ra_rec.postable,
505: posting_control_id = p_ra_rec.posting_control_id,

Line 507: NVL( arp_standard.profile.program_application_id,

503: line_applied = p_ra_rec.line_applied,
504: postable = p_ra_rec.postable,
505: posting_control_id = p_ra_rec.posting_control_id,
506: program_application_id =
507: NVL( arp_standard.profile.program_application_id,
508: p_ra_rec.program_application_id ),
509: program_id = NVL( arp_standard.profile.program_id,
510: p_ra_rec.program_id ),
511: program_update_date = DECODE( arp_standard.profile.program_id,

Line 509: program_id = NVL( arp_standard.profile.program_id,

505: posting_control_id = p_ra_rec.posting_control_id,
506: program_application_id =
507: NVL( arp_standard.profile.program_application_id,
508: p_ra_rec.program_application_id ),
509: program_id = NVL( arp_standard.profile.program_id,
510: p_ra_rec.program_id ),
511: program_update_date = DECODE( arp_standard.profile.program_id,
512: NULL, NULL,
513: SYSDATE

Line 511: program_update_date = DECODE( arp_standard.profile.program_id,

507: NVL( arp_standard.profile.program_application_id,
508: p_ra_rec.program_application_id ),
509: program_id = NVL( arp_standard.profile.program_id,
510: p_ra_rec.program_id ),
511: program_update_date = DECODE( arp_standard.profile.program_id,
512: NULL, NULL,
513: SYSDATE
514: ),
515: receivables_charges_applied =

Line 517: request_id = NVL( arp_standard.profile.request_id,

513: SYSDATE
514: ),
515: receivables_charges_applied =
516: p_ra_rec.receivables_charges_applied,
517: request_id = NVL( arp_standard.profile.request_id,
518: p_ra_rec.request_id ),
519: tax_applied = p_ra_rec.tax_applied,
520: unearned_discount_taken = p_ra_rec.unearned_discount_taken,
521: unearned_discount_ccid = p_ra_rec.unearned_discount_ccid,

Line 599: arp_standard.debug('arp_app_pkg.update_p()-' );

595: on_acct_cust_site_use_id = p_ra_rec.on_acct_cust_site_use_id,
596: on_acct_po_num = p_ra_rec.on_acct_po_num
597: WHERE ra.receivable_application_id = p_ra_rec.receivable_application_id;
598:
599: arp_standard.debug('arp_app_pkg.update_p()-' );
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );

Line 603: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );

599: arp_standard.debug('arp_app_pkg.update_p()-' );
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );
604:
605: -- Dump all parameter values and return them to error stack
606: -- for debugging purposes.
607: lc_dump := 'DUMP of procedure parameter values:'

Line 619: ','||' arp_standard.profile.user_id'||TO_CHAR( arp_standard.profile.user_id)||

615: ','||' p_ra_rec.apply_date'||TO_CHAR( p_ra_rec.apply_date)||
616: ','||' p_ra_rec.code_combination_id'||TO_CHAR( p_ra_rec.code_combination_id)||
617: ','||' p_ra_rec.display'||p_ra_rec.display||
618: ','||' p_ra_rec.gl_date'||TO_CHAR( p_ra_rec.gl_date)||
619: ','||' arp_standard.profile.user_id'||TO_CHAR( arp_standard.profile.user_id)||
620: ','||' SYSDATE='||TO_CHAR( SYSDATE)||
621: ','||' p_ra_rec.payment_schedule_id='||TO_CHAR( p_ra_rec.payment_schedule_id)||
622: ','||' p_ra_rec.set_of_books_id='||TO_CHAR( p_ra_rec.set_of_books_id)||
623: ','||' p_ra_rec.status='||p_ra_rec.status||

Line 748: arp_standard.debug( 'arp_app_pkg.delete_p()+' );

744: +===========================================================================*/
745: PROCEDURE delete_p(
746: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
747: BEGIN
748: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
749:
750: DELETE FROM ar_receivable_applications ra
751: WHERE ra.receivable_application_id = p_ra_id;
752:

Line 765: arp_standard.debug( 'arp_app_pkg.delete_p()-' );

761: -- p_mode => 'SINGLE',
762: -- p_key_value => p_ra_id);
763: --}
764:
765: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
766: EXCEPTION
767: WHEN OTHERS THEN
768: arp_standard.debug(
769: 'EXCEPTION: arp_app_pkg.delete_p' );

Line 768: arp_standard.debug(

764:
765: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
766: EXCEPTION
767: WHEN OTHERS THEN
768: arp_standard.debug(
769: 'EXCEPTION: arp_app_pkg.delete_p' );
770: RAISE;
771: END;
772:

Line 807: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );

803:
804: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
805:
806: BEGIN
807: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
808: FOR i IN c_ra_rec LOOP
809:
810: DELETE FROM ar_receivable_applications ra
811: WHERE ra.receivable_application_id = i.receivable_application_id;

Line 843: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );

839: -- p_mode => 'BATCH',
840: -- p_key_value_list => l_ar_dist_key_value_list);
841: --}
842: END LOOP;
843: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );
844: EXCEPTION
845: WHEN OTHERS THEN
846: NULL;
847: END;

Line 876: arp_standard.debug( 'arp_app_pkg.lock_p()+');

872: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
873: l_event_id xla_events.event_id%TYPE;
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_standard.debug( 'arp_app_pkg.lock_p()+');
877: END IF;
878:
879: SAVEPOINT lock_p_savepoint;
880:

Line 903: arp_standard.debug( 'arp_app_pkg.lock_p()-');

899: WHERE ra.receivable_application_id = p_ra_id
900: FOR UPDATE OF STATUS NOWAIT;
901:
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_standard.debug( 'arp_app_pkg.lock_p()-');
904: END IF;
905: EXCEPTION
906: WHEN OTHERS THEN
907: ROLLBACK TO lock_p_savepoint;

Line 909: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );

905: EXCEPTION
906: WHEN OTHERS THEN
907: ROLLBACK TO lock_p_savepoint;
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );
910: END IF;
911: RAISE;
912: END lock_p;
913:

Line 943: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');

939: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
940: l_event_id xla_events.event_id%TYPE;
941: BEGIN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
944: END IF;
945:
946: SAVEPOINT nowaitlock_p_savepoint;
947:

Line 970: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');

966: WHERE ra.receivable_application_id = p_ra_id
967: FOR UPDATE OF STATUS NOWAIT;
968:
969: IF PG_DEBUG in ('Y', 'C') THEN
970: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');
971: END IF;
972: EXCEPTION
973: WHEN OTHERS THEN
974: ROLLBACK TO nowaitlock_p_savepoint;

Line 976: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );

972: EXCEPTION
973: WHEN OTHERS THEN
974: ROLLBACK TO nowaitlock_p_savepoint;
975: IF PG_DEBUG in ('Y', 'C') THEN
976: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );
977: END IF;
978: RAISE;
979: END nowaitlock_p;
980:

Line 1009: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );

1005: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
1006: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
1007: BEGIN
1008: IF PG_DEBUG in ('Y', 'C') THEN
1009: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
1010: END IF;
1011:
1012: SELECT *
1013: INTO p_ra_rec

Line 1018: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );

1014: FROM ar_receivable_applications
1015: WHERE receivable_application_id = p_ra_id;
1016:
1017: IF PG_DEBUG in ('Y', 'C') THEN
1018: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );
1019: END IF;
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: IF PG_DEBUG in ('Y', 'C') THEN

Line 1023: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );

1019: END IF;
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: IF PG_DEBUG in ('Y', 'C') THEN
1023: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );
1024: END IF;
1025: RAISE;
1026:
1027: END fetch_p;