DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on ARP_ADJUSTMENTS_PKG

Line 402: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );

398: arp_util.debug('p_adjustment_id = ' || p_adjustment_id);
399: arp_util.debug('');
400:
401: arp_util.debug('---------- new adjustment record ----------');
402: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );
403: arp_util.debug('');
404:
405: RAISE;
406:

Line 785: arp_adjustments_pkg.display_adj_rec( p_adj_rec );

781: arp_util.debug('---------- parameters for validate_inv_line_amount()' ||
782: ' ---------',
783: pg_msg_level_debug);
784:
785: arp_adjustments_pkg.display_adj_rec( p_adj_rec );
786:
787: RAISE;
788:
789: END;

Line 1000: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id

996: aul.amount_from
997: INTO l_approval_amount_to,
998: l_approval_amount_from
999: FROM ar_approval_user_limits aul
1000: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id
1001: AND aul.currency_code = p_ps_rec.invoice_currency_code
1002: /* Bug 941429: Credit memo workflow added a new document_type column
1003: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't
1004: uniquely identify a row. Need to include document_type as well */

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

1029:
1030: arp_util.debug( 'EXCEPTION: arp_process_adjustment.' ||
1031: 'validate_update_approve_adj ()',
1032: pg_msg_level_debug);
1033: arp_util.debug( 'User ID: ' || arp_adjustments_pkg.pg_user_id ||
1034: ' Amount: ' ||
1035: p_adj_rec.amount || ' From: ' ||
1036: l_approval_amount_from || ' To: ' ||
1037: l_approval_amount_to,

Line 1069: arp_adjustments_pkg.display_adj_rec( p_adj_rec );

1065: || ' ---------',
1066: pg_msg_level_debug);
1067:
1068: arp_util.debug('p_adjustment_code = ' || p_adjustment_code );
1069: arp_adjustments_pkg.display_adj_rec( p_adj_rec );
1070:
1071: RAISE;
1072:
1073: END;

Line 1486: arp_adjustments_pkg.insert_p(p_adj_rec,

1482:
1483: /*----------------------+
1484: | call table-handler |
1485: +----------------------*/
1486: arp_adjustments_pkg.insert_p(p_adj_rec,
1487: l_ps_rec.exchange_rate,
1488: p_adjustment_number,
1489: l_adjustment_id);
1490:

Line 1914: arp_adjustments_pkg.fetch_p( l_old_adj_rec,

1910: | records and the changed columns from the record passed in as a |
1911: | parameter. |
1912: +-------------------------------------------------------------------*/
1913:
1914: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
1915: p_adjustment_id );
1916:
1917: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
1918: THEN

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

1913:
1914: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
1915: p_adjustment_id );
1916:
1917: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
1918: THEN
1919:
1920: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
1921: p_adj_rec,

Line 1920: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,

1916:
1917: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
1918: THEN
1919:
1920: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
1921: p_adj_rec,
1922: l_adj_rec );
1923: ELSE
1924: l_adj_rec := p_adj_rec;

Line 2026: arp_adjustments_pkg.update_p(l_adj_rec,

2022: /*----------------------+
2023: | call table-handler |
2024: +----------------------*/
2025:
2026: arp_adjustments_pkg.update_p(l_adj_rec,
2027: p_adjustment_id,
2028: l_ps_rec.exchange_rate);
2029:
2030: --Bug 12959780.

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

2495: | records and the changed columns from the record passed in as a |
2496: | parameter. |
2497: +-------------------------------------------------------------------*/
2498:
2499: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
2500: THEN
2501: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
2502: p_adjustment_id );
2503:

Line 2501: arp_adjustments_pkg.fetch_p( l_old_adj_rec,

2497: +-------------------------------------------------------------------*/
2498:
2499: IF (p_adj_rec.type = arp_adjustments_pkg.get_text_dummy )
2500: THEN
2501: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
2502: p_adjustment_id );
2503:
2504: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
2505: p_adj_rec,

Line 2504: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,

2500: THEN
2501: arp_adjustments_pkg.fetch_p( l_old_adj_rec,
2502: p_adjustment_id );
2503:
2504: arp_adjustments_pkg.merge_adj_recs( l_old_adj_rec,
2505: p_adj_rec,
2506: l_adj_rec );
2507: ELSE
2508: l_adj_rec := p_adj_rec;

Line 2656: arp_adjustments_pkg.update_p( l_adj_rec,

2652: /*--------------------------+
2653: | Update ar_adjustments |
2654: +--------------------------*/
2655:
2656: arp_adjustments_pkg.update_p( l_adj_rec,
2657: p_adjustment_id,
2658: l_ps_rec.exchange_rate );
2659:
2660: --BUG#2750340

Line 2774: arp_adjustments_pkg.display_adj_rec( p_adj_rec );

2770: arp_util.debug('p_form_version = ' || p_form_version );
2771: arp_util.debug('p_adjustment_code = ' || p_adjustment_code );
2772: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );
2773:
2774: arp_adjustments_pkg.display_adj_rec( p_adj_rec );
2775:
2776: RAISE;
2777:
2778: END;

Line 2886: and approved_by = arp_adjustments_pkg.pg_user_id

2882: and receivables_trx_id = p_adj_rec.receivables_trx_id
2883: and created_from = p_adj_rec.created_from
2884: -- check the derived columns
2885: and postable = 'Y'
2886: and approved_by = arp_adjustments_pkg.pg_user_id
2887: and nvl(comments, '^%') = nvl(p_adj_rec.comments, '^%')
2888: and acctd_amount = p_adj_rec.acctd_amount;
2889:
2890: IF ( p_result = 'A: Fail, ' )

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

2889:
2890: IF ( p_result = 'A: Fail, ' )
2891: THEN
2892: arp_util.debug('----- database adjustment record -----');
2893: arp_adjustments_pkg.display_adj_p(p_adj_rec.adjustment_id);
2894: arp_util.debug('----- parameter adjustment record -----');
2895: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
2896: END IF;
2897:

Line 2895: arp_adjustments_pkg.display_adj_rec(p_adj_rec);

2891: THEN
2892: arp_util.debug('----- database adjustment record -----');
2893: arp_adjustments_pkg.display_adj_p(p_adj_rec.adjustment_id);
2894: arp_util.debug('----- parameter adjustment record -----');
2895: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
2896: END IF;
2897:
2898:
2899: /*------------------------------------------------------------------+

Line 4099: pg_text_dummy := arp_adjustments_pkg.get_text_dummy;

4095: BEGIN
4096:
4097: pg_msg_level_debug := arp_global.MSG_LEVEL_DEBUG;
4098: pg_user_id := fnd_global.user_id;
4099: pg_text_dummy := arp_adjustments_pkg.get_text_dummy;
4100: pg_base_curr_code := arp_global.functional_currency;
4101: pg_base_precision := arp_global.base_precision;
4102: pg_base_min_acc_unit := arp_global.base_min_acc_unit;
4103: