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 ARP_STANDARD

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

77: p_ra_rec IN ar_receivable_applications%ROWTYPE
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL
84: THEN
85: SELECT ar_receivable_applications_s.nextval

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

78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL
84: THEN
85: SELECT ar_receivable_applications_s.nextval
86: INTO l_ra_id

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

84: THEN
85: SELECT ar_receivable_applications_s.nextval
86: INTO l_ra_id
87: FROM dual;
88: arp_standard.debug(' assigned l_ra_id = ' || l_ra_id);
89: ELSE
90: l_ra_id := p_ra_id;
91: END IF;
92:

Line 218: arp_standard.profile.user_id,

214: p_ra_rec.application_rule,
215: p_ra_rec.application_type,
216: p_ra_rec.apply_date,
217: p_ra_rec.code_combination_id,
218: arp_standard.profile.user_id,
219: SYSDATE,
220: p_ra_rec.display,
221: TRUNC(p_ra_rec.gl_date),
222: arp_standard.profile.user_id,

Line 222: arp_standard.profile.user_id,

218: arp_standard.profile.user_id,
219: SYSDATE,
220: p_ra_rec.display,
221: TRUNC(p_ra_rec.gl_date),
222: arp_standard.profile.user_id,
223: SYSDATE,
224: p_ra_rec.payment_schedule_id,
225: arp_global.set_of_books_id,
226: p_ra_rec.status,

Line 241: NVL( arp_standard.profile.last_update_login,

237: p_ra_rec.days_late,
238: p_ra_rec.earned_discount_taken,
239: p_ra_rec.freight_applied,
240: p_ra_rec.gl_posted_date,
241: NVL( arp_standard.profile.last_update_login,
242: p_ra_rec.last_update_login ),
243: p_ra_rec.line_applied,
244: p_ra_rec.postable,
245: p_ra_rec.posting_control_id,

Line 246: NVL( arp_standard.profile.program_application_id,

242: p_ra_rec.last_update_login ),
243: p_ra_rec.line_applied,
244: p_ra_rec.postable,
245: p_ra_rec.posting_control_id,
246: NVL( arp_standard.profile.program_application_id,
247: p_ra_rec.program_application_id ),
248: NVL(
249: decode(arp_standard.profile.program_id
250: ,-1,p_ra_rec.program_id)

Line 249: decode(arp_standard.profile.program_id

245: p_ra_rec.posting_control_id,
246: NVL( arp_standard.profile.program_application_id,
247: p_ra_rec.program_application_id ),
248: NVL(
249: decode(arp_standard.profile.program_id
250: ,-1,p_ra_rec.program_id)
251: ,p_ra_rec.program_id),
252: DECODE( arp_standard.profile.program_id,
253: NULL, NULL, SYSDATE ),

Line 252: DECODE( arp_standard.profile.program_id,

248: NVL(
249: decode(arp_standard.profile.program_id
250: ,-1,p_ra_rec.program_id)
251: ,p_ra_rec.program_id),
252: DECODE( arp_standard.profile.program_id,
253: NULL, NULL, SYSDATE ),
254: p_ra_rec.receivables_charges_applied,
255: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),
256: p_ra_rec.tax_applied,

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

251: ,p_ra_rec.program_id),
252: DECODE( arp_standard.profile.program_id,
253: NULL, NULL, SYSDATE ),
254: p_ra_rec.receivables_charges_applied,
255: NVL( arp_standard.profile.request_id, p_ra_rec.request_id ),
256: p_ra_rec.tax_applied,
257: p_ra_rec.unearned_discount_taken,
258: p_ra_rec.unearned_discount_ccid,
259: p_ra_rec.earned_discount_ccid,

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

323: p_ra_rec.application_ref_reason,
324: p_ra_rec.customer_reference,
325: p_ra_rec.customer_reason,
326: p_ra_rec.applied_rec_app_id
327: ,arp_standard.sysparm.org_id /* SSA changes anuj */
328: ,'R12'
329: );
330: p_ra_id := l_ra_id;
331:

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

328: ,'R12'
329: );
330: p_ra_id := l_ra_id;
331:
332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );

Line 335: arp_standard.debug(

331:
332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,

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

333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');

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

334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);

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

335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));

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

337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));

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

338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));

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

339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));

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

340: p_ra_rec.last_update_login) ), ''));
341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));

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

341: arp_standard.debug('---------------------------');
342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);

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

342: arp_standard.debug('ra_id = ' || l_ra_id);
343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));

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

343: arp_standard.debug('last_updated_by ' || to_char(arp_standard.profile.user_id));
344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);

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

344: arp_standard.debug('last_update_date ' || SYSDATE);
345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);

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

345: arp_standard.debug('created_by ' || to_char(arp_standard.profile.user_id));
346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);

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

346: arp_standard.debug('amount_applied ' || to_char(p_ra_rec.amount_applied));
347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);

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

347: arp_standard.debug('amount_applied_from ' || to_char(p_ra_rec.amount_applied_from));
348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));

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

348: arp_standard.debug('trans_to_receipt_rate ' || to_char(p_ra_rec.trans_to_receipt_rate));
349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);

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

349: arp_standard.debug('gl_date ' || p_ra_rec.gl_date);
350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));

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

350: arp_standard.debug('ccid ' || to_char(arp_global.set_of_books_id));
351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));

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

351: arp_standard.debug('display ' || p_ra_rec.display);
352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));

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

352: arp_standard.debug('apply_Date ' || p_ra_rec.apply_date);
353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));

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

353: arp_standard.debug('application_type ' || p_ra_rec.application_type);
354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));

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

354: arp_standard.debug('status ' || p_ra_rec.status);
355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));

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

355: arp_standard.debug('payment_schedule_id ' || to_char(p_ra_rec.payment_schedule_id));
356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));

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

356: arp_standard.debug('application_rule ' || p_ra_rec.application_rule);
357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));

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

357: arp_standard.debug('posting_control_id ' || to_char(p_ra_rec.posting_control_id));
358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));

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

358: arp_standard.debug('acctd_amount_applied_from ' || to_char(p_ra_rec.acctd_amount_applied_from));
359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));

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

359: arp_standard.debug('p_ra_rec.line_ediscounted='||to_char(p_ra_rec.line_ediscounted));
360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));

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

360: arp_standard.debug('p_ra_rec.line_uediscounted='||to_char(p_ra_rec.line_uediscounted));
361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);

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

361: arp_standard.debug('p_ra_rec.tax_ediscounted='||to_char(p_ra_rec.tax_ediscounted));
362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);

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

362: arp_standard.debug('p_ra_rec.tax_uediscounted='||to_char(p_ra_rec.tax_uediscounted));
363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);

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

363: arp_standard.debug('p_ra_rec.freight_ediscounted='||to_char(p_ra_rec.freight_ediscounted));
364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);

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

364: arp_standard.debug('p_ra_rec.freight_uediscounted='||to_char(p_ra_rec.freight_uediscounted));
365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);

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

365: arp_standard.debug('p_ra_rec.charges_ediscounted='||to_char(p_ra_rec.charges_ediscounted));
366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);

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

366: arp_standard.debug('p_ra_rec.charges_uediscounted='||to_char(p_ra_rec.charges_uediscounted));
367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));

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

367: arp_standard.debug('p_ra_rec.rule_set_id='||to_char(p_ra_rec.rule_set_id));
368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);

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

368: arp_standard.debug('tax_code=' || p_ra_rec.tax_code);
369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);

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

369: arp_standard.debug('unedisc_tax_acct_rule=' || p_ra_rec.unedisc_tax_acct_rule);
370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));

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

370: arp_standard.debug('edisc_tax_acct_rule=' || p_ra_rec.edisc_tax_acct_rule);
371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);

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

371: arp_standard.debug('application_ref_type='||p_ra_rec.application_ref_type);
372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);

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

372: arp_standard.debug('application_ref_id='||p_ra_rec.application_ref_id);
373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);

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

373: arp_standard.debug('application_ref_num='||p_ra_rec.application_ref_num);
374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));

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

374: arp_standard.debug('secondary_application_ref_id='||to_char(p_ra_rec.secondary_application_ref_id));
375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:

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

375: arp_standard.debug('secondary_application_ref_num='||p_ra_rec.secondary_application_ref_num);
376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
383:

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

376: arp_standard.debug('secondary_application_ref_type='||p_ra_rec.secondary_application_ref_type);
377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
383:
384:

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

377: arp_standard.debug('payment_set_id='||to_char(p_ra_rec.payment_set_id));
378: arp_standard.debug('application_ref_reason='||p_ra_rec.application_ref_reason);
379: arp_standard.debug('customer_reference='||p_ra_rec.customer_reference);
380: arp_standard.debug('customer_reason='||p_ra_rec.customer_reason);
381: arp_standard.debug('applied_rec_app_id='||to_char(p_ra_rec.applied_rec_app_id));
382:
383:
384:
385: RAISE;

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

441: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
442: lc_dump VARCHAR2(30000);
443:
444: BEGIN
445: arp_standard.debug( 'arp_app_pkg.update_p()+' );
446:
447: UPDATE ar_receivable_applications ra SET
448: acctd_amount_applied_from =
449: p_ra_rec.acctd_amount_applied_from,

Line 459: last_updated_by = arp_standard.profile.user_id,

455: apply_date = p_ra_rec.apply_date,
456: code_combination_id = p_ra_rec.code_combination_id,
457: display = p_ra_rec.display,
458: gl_date = p_ra_rec.gl_date,
459: last_updated_by = arp_standard.profile.user_id,
460: last_update_date = SYSDATE,
461: payment_schedule_id = p_ra_rec.payment_schedule_id,
462: set_of_books_id = p_ra_rec.set_of_books_id,
463: status = p_ra_rec.status,

Line 483: NVL( arp_standard.profile.last_update_login,

479: earned_discount_taken = p_ra_rec.earned_discount_taken,
480: freight_applied = p_ra_rec.freight_applied,
481: gl_posted_date = p_ra_rec.gl_posted_date,
482: last_update_login =
483: NVL( arp_standard.profile.last_update_login,
484: p_ra_rec.last_update_login ),
485: line_applied = p_ra_rec.line_applied,
486: postable = p_ra_rec.postable,
487: posting_control_id = p_ra_rec.posting_control_id,

Line 489: NVL( arp_standard.profile.program_application_id,

485: line_applied = p_ra_rec.line_applied,
486: postable = p_ra_rec.postable,
487: posting_control_id = p_ra_rec.posting_control_id,
488: program_application_id =
489: NVL( arp_standard.profile.program_application_id,
490: p_ra_rec.program_application_id ),
491: program_id = NVL( arp_standard.profile.program_id,
492: p_ra_rec.program_id ),
493: program_update_date = DECODE( arp_standard.profile.program_id,

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

487: posting_control_id = p_ra_rec.posting_control_id,
488: program_application_id =
489: NVL( arp_standard.profile.program_application_id,
490: p_ra_rec.program_application_id ),
491: program_id = NVL( arp_standard.profile.program_id,
492: p_ra_rec.program_id ),
493: program_update_date = DECODE( arp_standard.profile.program_id,
494: NULL, NULL,
495: SYSDATE

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

489: NVL( arp_standard.profile.program_application_id,
490: p_ra_rec.program_application_id ),
491: program_id = NVL( arp_standard.profile.program_id,
492: p_ra_rec.program_id ),
493: program_update_date = DECODE( arp_standard.profile.program_id,
494: NULL, NULL,
495: SYSDATE
496: ),
497: receivables_charges_applied =

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

495: SYSDATE
496: ),
497: receivables_charges_applied =
498: p_ra_rec.receivables_charges_applied,
499: request_id = NVL( arp_standard.profile.request_id,
500: p_ra_rec.request_id ),
501: tax_applied = p_ra_rec.tax_applied,
502: unearned_discount_taken = p_ra_rec.unearned_discount_taken,
503: unearned_discount_ccid = p_ra_rec.unearned_discount_ccid,

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

573: customer_reason = p_ra_rec.customer_reason,
574: applied_rec_app_id = p_ra_rec.applied_rec_app_id
575: WHERE ra.receivable_application_id = p_ra_rec.receivable_application_id;
576:
577: arp_standard.debug('arp_app_pkg.update_p()-' );
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );

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

577: arp_standard.debug('arp_app_pkg.update_p()-' );
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );
582:
583: -- Dump all parameter values and return them to error stack
584: -- for debugging purposes.
585: lc_dump := 'DUMP of procedure parameter values:'

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

593: ','||' p_ra_rec.apply_date'||TO_CHAR( p_ra_rec.apply_date)||
594: ','||' p_ra_rec.code_combination_id'||TO_CHAR( p_ra_rec.code_combination_id)||
595: ','||' p_ra_rec.display'||p_ra_rec.display||
596: ','||' p_ra_rec.gl_date'||TO_CHAR( p_ra_rec.gl_date)||
597: ','||' arp_standard.profile.user_id'||TO_CHAR( arp_standard.profile.user_id)||
598: ','||' SYSDATE='||TO_CHAR( SYSDATE)||
599: ','||' p_ra_rec.payment_schedule_id='||TO_CHAR( p_ra_rec.payment_schedule_id)||
600: ','||' p_ra_rec.set_of_books_id='||TO_CHAR( p_ra_rec.set_of_books_id)||
601: ','||' p_ra_rec.status='||p_ra_rec.status||

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

719: +===========================================================================*/
720: PROCEDURE delete_p(
721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
722: BEGIN
723: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
724:
725: DELETE FROM ar_receivable_applications ra
726: WHERE ra.receivable_application_id = p_ra_id;
727:

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

736: -- p_mode => 'SINGLE',
737: -- p_key_value => p_ra_id);
738: --}
739:
740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
741: EXCEPTION
742: WHEN OTHERS THEN
743: arp_standard.debug(
744: 'EXCEPTION: arp_app_pkg.delete_p' );

Line 743: arp_standard.debug(

739:
740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
741: EXCEPTION
742: WHEN OTHERS THEN
743: arp_standard.debug(
744: 'EXCEPTION: arp_app_pkg.delete_p' );
745: RAISE;
746: END;
747:

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

778:
779: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
780:
781: BEGIN
782: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
783: FOR i IN c_ra_rec LOOP
784:
785: DELETE FROM ar_receivable_applications ra
786: WHERE ra.receivable_application_id = i.receivable_application_id;

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

814: -- p_mode => 'BATCH',
815: -- p_key_value_list => l_ar_dist_key_value_list);
816: --}
817: END LOOP;
818: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );
819: EXCEPTION
820: WHEN OTHERS THEN
821: NULL;
822: END;

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

846: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
847: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
848: BEGIN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_standard.debug( 'arp_app_pkg.lock_p()+');
851: END IF;
852:
853: SELECT ra.receivable_application_id
854: INTO l_ra_id

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

856: WHERE ra.receivable_application_id = p_ra_id
857: FOR UPDATE OF STATUS NOWAIT;
858:
859: IF PG_DEBUG in ('Y', 'C') THEN
860: arp_standard.debug( 'arp_app_pkg.lock_p()-');
861: END IF;
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF PG_DEBUG in ('Y', 'C') THEN

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

861: END IF;
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF PG_DEBUG in ('Y', 'C') THEN
865: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );
866: END IF;
867: RAISE;
868: END lock_p;
869:

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

894: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
895: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
896: BEGIN
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
899: END IF;
900:
901: SELECT ra.receivable_application_id
902: INTO l_ra_id

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

904: WHERE ra.receivable_application_id = p_ra_id
905: FOR UPDATE OF STATUS NOWAIT;
906:
907: IF PG_DEBUG in ('Y', 'C') THEN
908: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');
909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF PG_DEBUG in ('Y', 'C') THEN

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

909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF PG_DEBUG in ('Y', 'C') THEN
913: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );
914: END IF;
915: RAISE;
916: END nowaitlock_p;
917:

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

942: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
943: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
947: END IF;
948:
949: SELECT *
950: INTO p_ra_rec

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

951: FROM ar_receivable_applications
952: WHERE receivable_application_id = p_ra_id;
953:
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );
956: END IF;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN

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

956: END IF;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN
960: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );
961: END IF;
962: RAISE;
963:
964: END fetch_p;