DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on ARP_UTIL

Line 613: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');

609: p_key_value_list => l_misc_cash_key_value_list);
610: EXCEPTION
611: WHEN OTHERS THEN
612: IF PG_DEBUG in ('Y', 'C') THEN
613: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');
614: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);
615: END IF;
616: APP_EXCEPTION.RAISE_EXCEPTION;
617: END;

Line 614: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);

610: EXCEPTION
611: WHEN OTHERS THEN
612: IF PG_DEBUG in ('Y', 'C') THEN
613: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');
614: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);
615: END IF;
616: APP_EXCEPTION.RAISE_EXCEPTION;
617: END;
618: */

Line 734: arp_util.debug('error deleting ar_mc_misc_cash_dists');

730: p_mode => 'BATCH',
731: p_key_value_list => l_misc_cash_key_value_list);
732: EXCEPTION
733: WHEN OTHERS THEN
734: arp_util.debug('error deleting ar_mc_misc_cash_dists');
735: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);
736: APP_EXCEPTION.RAISE_EXCEPTION;
737: END;
738: */

Line 735: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);

731: p_key_value_list => l_misc_cash_key_value_list);
732: EXCEPTION
733: WHEN OTHERS THEN
734: arp_util.debug('error deleting ar_mc_misc_cash_dists');
735: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);
736: APP_EXCEPTION.RAISE_EXCEPTION;
737: END;
738: */
739: -- check if receipt amount is zero. If yes, don't create any

Line 788: arp_util.Substitute_Ccid(

784: +--------------------------------------------------------------------*/
785: /* Bug4726219 */
786: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),
787: 'N') = 'N' AND l_type <> 'MISCCASH' THEN
788: arp_util.Substitute_Ccid(
789: p_coa_id => arp_global.chart_of_accounts_id,
790: p_original_ccid => l_trx_code_combination_id,
791: p_subs_ccid => l_crh_ccid,
792: p_actual_ccid => l_misc_cash_dist_rec.code_combination_id );

Line 1041: arp_util.debug('update_misc_dist: ' || '=====> Case 8: amount is zero -- deleting applications');

1037: --
1038: -- Handle case 8 right away:
1039: --
1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: arp_util.debug('update_misc_dist: ' || '=====> Case 8: amount is zero -- deleting applications');
1042: END IF;
1043:
1044: SELECT count(mcd.misc_cash_distribution_id)
1045: INTO l_count

Line 1226: arp_util.debug('update_misc_dist: ' || '=====> Case 1/7: updating distributions with new date(s)');

1222: IF (p_receipt_date_changed_flag = TRUE OR
1223: p_gl_date_changed_flag = TRUE) THEN
1224: --
1225: IF PG_DEBUG in ('Y', 'C') THEN
1226: arp_util.debug('update_misc_dist: ' || '=====> Case 1/7: updating distributions with new date(s)');
1227: END IF;
1228: --
1229: /*----------------------------------+
1230: | Added bulk collect of misc cash |

Line 1255: arp_util.debug('update_misc_dist: ' || '=====> Case 1/7: no update required');

1251: p_key_value_list => l_misc_cash_key_value_list);
1252: */
1253: ELSE
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug('update_misc_dist: ' || '=====> Case 1/7: no update required');
1256: END IF;
1257: END IF;
1258: --
1259: /* Bug 1792989. When only the receipt amount is changed with no change

Line 1282: arp_util.debug('update_misc_dist: ' || '=====> Case 2: updating amounts');

1278: (l_old_recs_auto_flag = FALSE AND
1279: l_new_recs_auto_flag = FALSE)) THEN
1280:
1281: IF PG_DEBUG in ('Y', 'C') THEN
1282: arp_util.debug('update_misc_dist: ' || '=====> Case 2: updating amounts');
1283: END IF;
1284: SELECT count(mcd.misc_cash_distribution_id)
1285: INTO l_count
1286: FROM ar_misc_cash_distributions mcd

Line 1355: arp_util.debug('update_misc_dist: ' || '=====> Case 2: updating amounts');

1351: -- if distribution was and still is created manually, just update
1352: -- the amounts for each record.
1353: --
1354: IF PG_DEBUG in ('Y', 'C') THEN
1355: arp_util.debug('update_misc_dist: ' || '=====> Case 2: updating amounts');
1356: END IF;
1357: --
1358: update_manual_dist( p_cash_receipt_id,
1359: p_amount,

Line 1383: arp_util.debug('update_misc_dist: ' || 'Case 3: deleting old records');

1379: ***** IF THIS EVER IS UNCOMMENTED, THEN A CALL TO THE MRC ENGINE IS
1380: REQUIRED.....
1381:
1382: IF PG_DEBUG in ('Y', 'C') THEN
1383: arp_util.debug('update_misc_dist: ' || 'Case 3: deleting old records');
1384: END IF;
1385:
1386: DELETE ar_misc_cash_distributions
1387: WHERE cash_receipt_id = p_cash_receipt_id;

Line 1391: arp_util.debug('update_misc_dist: ' || '=====> Case 3: do nothing');

1387: WHERE cash_receipt_id = p_cash_receipt_id;
1388:
1389: */
1390: IF PG_DEBUG in ('Y', 'C') THEN
1391: arp_util.debug('update_misc_dist: ' || '=====> Case 3: do nothing');
1392: END IF;
1393: NULL;
1394:
1395: ELSE

Line 1739: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));

1735: l_acctd_rounding_diff
1736: FROM ar_distribution_set_lines
1737: WHERE distribution_set_id = p_distribution_set_id;
1738:
1739: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1740: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1741:
1742:
1743: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN

Line 1740: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));

1736: FROM ar_distribution_set_lines
1737: WHERE distribution_set_id = p_distribution_set_id;
1738:
1739: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1740: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1741:
1742:
1743: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN
1744:

Line 1915: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));

1911: l_acctd_rounding_diff
1912: FROM ar_misc_cash_distributions
1913: WHERE cash_receipt_id = p_cash_receipt_id;
1914:
1915: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1916: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1917:
1918:
1919: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN

Line 1916: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));

1912: FROM ar_misc_cash_distributions
1913: WHERE cash_receipt_id = p_cash_receipt_id;
1914:
1915: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1916: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1917:
1918:
1919: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN
1920: