APPS.ARP_PROCESS_ADJUSTMENT dependencies on ARP_PS_UTIL

Line 1008: -- This is to make arp_ps_util.update_adj_related_columns work OK

1004:
1005: IF p_adj_rec.status = 'A'
1006: THEN
1007: -- ------------------------------------------------------------------
1008: -- This is to make arp_ps_util.update_adj_related_columns work OK
1009: -- CB means that we are adjusting chargeback amount to applied
1010: -- transaction.
1011: -- This does not work the same way as normal invoice adjustment
1012: -- because normal invoice adjustment assumes that the whole

Line 1020: arp_ps_util.update_adj_related_columns(

1016:
1017: IF (p_adj_rec.type = 'CB')
1018: THEN
1019: /* VAT changes */
1020: arp_ps_util.update_adj_related_columns(
1021: null,
1022: p_adj_rec.type,
1023: p_adj_rec.amount,
1024: null,

Line 1053: | arp_ps_util.update_adj_related_columns procedure. |

1049: | If the flag p_check_amount has the value of 'F' ie it is |
1050: | an adjustment reversal, then adjustment_type is set to |
1051: | 'REVERSE' so that the values for line_adjusted, tax_adjusted|
1052: | freight_adjusted and amount_adjusted are not calculated in |
1053: | arp_ps_util.update_adj_related_columns procedure. |
1054: +-------------------------------------------------------------*/
1055: /*-------------------------------------------------------------+
1056: | Bug 1290698 - For partial adjustment, p_check_amount is 'F'.|
1057: | So set the type = 'REVERSE' only when it is actual reversal |

Line 1076: arp_ps_util.update_adj_related_columns(

1072: --Bug 1395396.Update PS record only if Amount is not 0
1073: IF p_adj_rec.amount <> 0 THEN
1074:
1075: IF l_adj_type <> 'REVERSE' THEN
1076: arp_ps_util.update_adj_related_columns(
1077: null,
1078: l_adj_type,
1079: p_adj_rec.amount,
1080: null,

Line 1145: arp_ps_util.populate_closed_dates(p_adj_rec.gl_date,

1141: p_adj_rec.freight_adjusted;
1142:
1143: END IF;
1144:
1145: arp_ps_util.populate_closed_dates(p_adj_rec.gl_date,
1146: p_adj_rec.apply_date, 'ADJ', l_ps_rec );
1147: arp_ps_pkg.update_p(l_ps_rec );
1148:
1149: END IF; -- Close for Reverse block

Line 1163: arp_ps_util.update_adj_related_columns(

1159:
1160: /*3869570 Replaced p_adj_rec.apply_date and
1161: p_adj_rec.gl_Date with l_ps_rec.actual_date_closed and
1162: l_ps_rec.gl_date_closed*/
1163: arp_ps_util.update_adj_related_columns(
1164: null,
1165: null,
1166: null,
1167: p_adj_rec.amount,

Line 1674: arp_ps_util.update_adj_related_columns(

1670: IF l_status_changed_flag
1671: THEN
1672: IF l_adj_rec.status = 'A'
1673: THEN
1674: arp_ps_util.update_adj_related_columns(
1675: null, -- payment_schedule_id
1676: l_adj_rec.type, -- p_type
1677: l_adj_rec.amount, -- p_amount_adjusted
1678: l_adj_rec.amount * -1, -- p_amount_adjusted_pending

Line 1703: arp_ps_util.update_adj_related_columns(

1699: /*3869570 Replaced p_adj_rec.apply_date and
1700: p_adj_rec.gl_Date with l_ps_rec.actual_date_closed and
1701: l_ps_rec.gl_date_closed*/
1702:
1703: arp_ps_util.update_adj_related_columns(
1704: null, -- paymenty schedule id
1705: l_adj_rec.type, -- p_type
1706: null, -- p_amount_adjusted
1707: -1 * l_adj_rec.amount,-- p_amount_adjusted_pending

Line 1746: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );

1742: EXCEPTION
1743: WHEN OTHERS THEN
1744: IF PG_DEBUG in ('Y', 'C') THEN
1745: arp_util.debug('Problem in Amount adjusted pending calculation ' ||
1746: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );
1747: END IF;
1748: RAISE;
1749: END;
1750:

Line 1769: arp_util.debug('EXCEPTION: arp_ps_util.update_adjustment '|| SQLERRM);

1765: WHEN OTHERS THEN
1766:
1767: IF PG_DEBUG in ('Y', 'C') THEN
1768: arp_util.debug('Unable to get post to gl flag for adjustment' );
1769: arp_util.debug('EXCEPTION: arp_ps_util.update_adjustment '|| SQLERRM);
1770: END IF;
1771: RAISE;
1772: END;
1773:

Line 1814: 'EXCEPTION: arp_ps_util.update_adjustment' );

1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: IF PG_DEBUG in ('Y', 'C') THEN
1813: arp_util.debug('Unable to get the XLA Entites Data ' ||
1814: 'EXCEPTION: arp_ps_util.update_adjustment' );
1815: END IF;
1816: RAISE;
1817: END;
1818:

Line 2184: arp_ps_util.update_adj_related_columns(

2180:
2181: IF ( p_adjustment_code = 'A' )
2182: THEN
2183:
2184: arp_ps_util.update_adj_related_columns(
2185: null,
2186: l_adj_rec.type,
2187: l_adj_rec.amount,
2188: l_adj_rec.amount * -1,

Line 2205: arp_ps_util.update_adj_related_columns(

2201: THEN
2202: /*3869570 Replaced p_adj_rec.apply_date and
2203: p_adj_rec.gl_Date with l_ps_rec.actual_date_closed and
2204: l_ps_rec.gl_date_closed*/
2205: arp_ps_util.update_adj_related_columns(
2206: null,
2207: l_adj_rec.type,
2208: null,
2209: -1 *