DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on ARP_ADJUSTMENTS_PKG

Line 353: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );

349: arp_util.debug('p_adjustment_id = ' || p_adjustment_id);
350: arp_util.debug('');
351:
352: arp_util.debug('---------- new adjustment record ----------');
353: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );
354: arp_util.debug('');
355:
356: RAISE;
357:

Line 564: arp_adjustments_pkg.display_adj_rec( p_adj_rec );

560: arp_util.debug('---------- parameters for validate_inv_line_amount()' ||
561: ' ---------',
562: pg_msg_level_debug);
563:
564: arp_adjustments_pkg.display_adj_rec( p_adj_rec );
565:
566: RAISE;
567:
568: END;

Line 778: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id

774: aul.amount_from
775: INTO l_approval_amount_to,
776: l_approval_amount_from
777: FROM ar_approval_user_limits aul
778: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id
779: AND aul.currency_code = p_ps_rec.invoice_currency_code
780: /* Bug 941429: Credit memo workflow added a new document_type column
781: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't
782: uniquely identify a row. Need to include document_type as well */

Line 811: arp_util.debug( 'User ID: ' || arp_adjustments_pkg.pg_user_id ||

807:
808: arp_util.debug( 'EXCEPTION: arp_process_adjustment.' ||
809: 'validate_update_approve_adj ()',
810: pg_msg_level_debug);
811: arp_util.debug( 'User ID: ' || arp_adjustments_pkg.pg_user_id ||
812: ' Amount: ' ||
813: p_adj_rec.amount || ' From: ' ||
814: l_approval_amount_from || ' To: ' ||
815: l_approval_amount_to,

Line 847: arp_adjustments_pkg.display_adj_rec( p_adj_rec );

843: || ' ---------',
844: pg_msg_level_debug);
845:
846: arp_util.debug('p_adjustment_code = ' || p_adjustment_code );
847: arp_adjustments_pkg.display_adj_rec( p_adj_rec );
848:
849: RAISE;
850:
851: END;

Line 1214: arp_adjustments_pkg.insert_p(p_adj_rec,

1210:
1211: /*----------------------+
1212: | call table-handler |
1213: +----------------------*/
1214: arp_adjustments_pkg.insert_p(p_adj_rec,
1215: l_ps_rec.exchange_rate,
1216: p_adjustment_number,
1217: l_adjustment_id);
1218:

Line 1622: arp_adjustments_pkg.fetch_p( l_old_adj_rec,

1618: | records and the changed columns from the record passed in as a |
1619: | parameter. |
1620: +-------------------------------------------------------------------*/
1621:
1622: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
1623: p_adjustment_id );
1624:
1625: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
1626: THEN

Line 1625: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )

1621:
1622: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
1623: p_adjustment_id );
1624:
1625: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
1626: THEN
1627:
1628: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
1629: p_adj_rec,

Line 1628: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,

1624:
1625: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
1626: THEN
1627:
1628: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
1629: p_adj_rec,
1630: l_adj_rec );
1631: ELSE
1632: l_adj_rec := p_adj_rec;

Line 1725: arp_adjustments_pkg.update_p(l_adj_rec,

1721: /*----------------------+
1722: | call table-handler |
1723: +----------------------*/
1724:
1725: arp_adjustments_pkg.update_p(l_adj_rec,
1726: p_adjustment_id,
1727: l_ps_rec.exchange_rate);
1728:
1729: /*3321021*/

Line 2071: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )

2067: | records and the changed columns from the record passed in as a |
2068: | parameter. |
2069: +-------------------------------------------------------------------*/
2070:
2071: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
2072: THEN
2073: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
2074: p_adjustment_id );
2075:

Line 2073: arp_adjustments_pkg.fetch_p( l_old_adj_rec,

2069: +-------------------------------------------------------------------*/
2070:
2071: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
2072: THEN
2073: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
2074: p_adjustment_id );
2075:
2076: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
2077: p_adj_rec,

Line 2076: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,

2072: THEN
2073: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
2074: p_adjustment_id );
2075:
2076: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
2077: p_adj_rec,
2078: l_adj_rec );
2079: ELSE
2080: l_adj_rec := p_adj_rec;

Line 2228: arp_adjustments_pkg.update_p( l_adj_rec,

2224: /*--------------------------+
2225: | Update ar_adjustments |
2226: +--------------------------*/
2227:
2228: arp_adjustments_pkg.update_p( l_adj_rec,
2229: p_adjustment_id,
2230: l_ps_rec.exchange_rate );
2231:
2232: --BUG#2750340

Line 2346: arp_adjustments_pkg.display_adj_rec( p_adj_rec );

2342: arp_util.debug('p_form_version = ' || p_form_version );
2343: arp_util.debug('p_adjustment_code = ' || p_adjustment_code );
2344: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );
2345:
2346: arp_adjustments_pkg.display_adj_rec( p_adj_rec );
2347:
2348: RAISE;
2349:
2350: END;

Line 2458: and approved_by = arp_adjustments_pkg.pg_user_id

2454: and receivables_trx_id = p_adj_rec.receivables_trx_id
2455: and created_from = p_adj_rec.created_from
2456: -- check the derived columns
2457: and postable = 'Y'
2458: and approved_by = arp_adjustments_pkg.pg_user_id
2459: and nvl(comments, '^%') = nvl(p_adj_rec.comments, '^%')
2460: and acctd_amount = p_adj_rec.acctd_amount;
2461:
2462: IF ( p_result = 'A: Fail, ' )

Line 2465: arp_adjustments_pkg.display_adj_p(p_adj_rec.adjustment_id);

2461:
2462: IF ( p_result = 'A: Fail, ' )
2463: THEN
2464: arp_util.debug('----- database adjustment record -----');
2465: arp_adjustments_pkg.display_adj_p(p_adj_rec.adjustment_id);
2466: arp_util.debug('----- parameter adjustment record -----');
2467: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
2468: END IF;
2469:

Line 2467: arp_adjustments_pkg.display_adj_rec(p_adj_rec);

2463: THEN
2464: arp_util.debug('----- database adjustment record -----');
2465: arp_adjustments_pkg.display_adj_p(p_adj_rec.adjustment_id);
2466: arp_util.debug('----- parameter adjustment record -----');
2467: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
2468: END IF;
2469:
2470:
2471: /*------------------------------------------------------------------+

Line 3487: pg_text_dummy := arp_adjustments_pkg.get_text_dummy;

3483: BEGIN
3484:
3485: pg_msg_level_debug := arp_global.MSG_LEVEL_DEBUG;
3486: pg_user_id := fnd_global.user_id;
3487: pg_text_dummy := arp_adjustments_pkg.get_text_dummy;
3488: pg_base_curr_code := arp_global.functional_currency;
3489: pg_base_precision := arp_global.base_precision;
3490: pg_base_min_acc_unit := arp_global.base_min_acc_unit;
3491: