APPS.ARP_PROCESS_ADJUSTMENT dependencies on ARP_PS_UTIL

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

1276:
1277: IF p_adj_rec.status = 'A'
1278: THEN
1279: -- ------------------------------------------------------------------
1280: -- This is to make arp_ps_util.update_adj_related_columns work OK
1281: -- CB means that we are adjusting chargeback amount to applied
1282: -- transaction.
1283: -- This does not work the same way as normal invoice adjustment
1284: -- because normal invoice adjustment assumes that the whole

Line 1292: arp_ps_util.update_adj_related_columns(

1288:
1289: IF (p_adj_rec.type = 'CB')
1290: THEN
1291: /* VAT changes */
1292: arp_ps_util.update_adj_related_columns(
1293: null,
1294: p_adj_rec.type,
1295: p_adj_rec.amount,
1296: null,

Line 1325: | arp_ps_util.update_adj_related_columns procedure. |

1321: | If the flag p_check_amount has the value of 'F' ie it is |
1322: | an adjustment reversal, then adjustment_type is set to |
1323: | 'REVERSE' so that the values for line_adjusted, tax_adjusted|
1324: | freight_adjusted and amount_adjusted are not calculated in |
1325: | arp_ps_util.update_adj_related_columns procedure. |
1326: +-------------------------------------------------------------*/
1327: /*-------------------------------------------------------------+
1328: | Bug 1290698 - For partial adjustment, p_check_amount is 'F'.|
1329: | So set the type = 'REVERSE' only when it is actual reversal |

Line 1348: arp_ps_util.update_adj_related_columns(

1344: --Bug 1395396.Update PS record only if Amount is not 0
1345: IF p_adj_rec.amount <> 0 THEN
1346:
1347: IF l_adj_type <> 'REVERSE' THEN
1348: arp_ps_util.update_adj_related_columns(
1349: null,
1350: l_adj_type,
1351: p_adj_rec.amount,
1352: null,

Line 1417: arp_ps_util.populate_closed_dates(p_adj_rec.gl_date,

1413: p_adj_rec.freight_adjusted;
1414:
1415: END IF;
1416:
1417: arp_ps_util.populate_closed_dates(p_adj_rec.gl_date,
1418: p_adj_rec.apply_date, 'ADJ', l_ps_rec );
1419: arp_ps_pkg.update_p(l_ps_rec );
1420:
1421: END IF; -- Close for Reverse block

Line 1435: arp_ps_util.update_adj_related_columns(

1431:
1432: /*3869570 Replaced p_adj_rec.apply_date and
1433: p_adj_rec.gl_Date with l_ps_rec.actual_date_closed and
1434: l_ps_rec.gl_date_closed*/
1435: arp_ps_util.update_adj_related_columns(
1436: null,
1437: null,
1438: null,
1439: p_adj_rec.amount,

Line 1975: arp_ps_util.update_adj_related_columns(

1971: IF l_status_changed_flag
1972: THEN
1973: IF l_adj_rec.status = 'A'
1974: THEN
1975: arp_ps_util.update_adj_related_columns(
1976: null, -- payment_schedule_id
1977: l_adj_rec.type, -- p_type
1978: l_adj_rec.amount, -- p_amount_adjusted
1979: l_adj_rec.amount * -1, -- p_amount_adjusted_pending

Line 2004: arp_ps_util.update_adj_related_columns(

2000: /*3869570 Replaced p_adj_rec.apply_date and
2001: p_adj_rec.gl_Date with l_ps_rec.actual_date_closed and
2002: l_ps_rec.gl_date_closed*/
2003:
2004: arp_ps_util.update_adj_related_columns(
2005: null, -- paymenty schedule id
2006: l_adj_rec.type, -- p_type
2007: null, -- p_amount_adjusted
2008: -1 * l_adj_rec.amount,-- p_amount_adjusted_pending

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

2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: IF PG_DEBUG in ('Y', 'C') THEN
2168: arp_util.debug('Problem in Amount adjusted pending calculation ' ||
2169: 'EXCEPTION: arp_ps_util.update_adj_related_columns' );
2170: END IF;
2171: RAISE;
2172: END;
2173:

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

2188: WHEN OTHERS THEN
2189:
2190: IF PG_DEBUG in ('Y', 'C') THEN
2191: arp_util.debug('Unable to get post to gl flag for adjustment' );
2192: arp_util.debug('EXCEPTION: arp_ps_util.update_adjustment '|| SQLERRM);
2193: END IF;
2194: RAISE;
2195: END;
2196:

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

2234: EXCEPTION
2235: WHEN OTHERS THEN
2236: IF PG_DEBUG in ('Y', 'C') THEN
2237: arp_util.debug('Unable to get the XLA Entites Data ' ||
2238: 'EXCEPTION: arp_ps_util.update_adjustment' );
2239: END IF;
2240: RAISE;
2241: END;
2242:

Line 2612: arp_ps_util.update_adj_related_columns(

2608:
2609: IF ( p_adjustment_code = 'A' )
2610: THEN
2611:
2612: arp_ps_util.update_adj_related_columns(
2613: null,
2614: l_adj_rec.type,
2615: l_adj_rec.amount,
2616: l_adj_rec.amount * -1,

Line 2633: arp_ps_util.update_adj_related_columns(

2629: THEN
2630: /*3869570 Replaced p_adj_rec.apply_date and
2631: p_adj_rec.gl_Date with l_ps_rec.actual_date_closed and
2632: l_ps_rec.gl_date_closed*/
2633: arp_ps_util.update_adj_related_columns(
2634: null,
2635: l_adj_rec.type,
2636: null,
2637: -1 *