DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on ARP_UTIL

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

594: p_key_value_list => l_misc_cash_key_value_list);
595: EXCEPTION
596: WHEN OTHERS THEN
597: IF PG_DEBUG in ('Y', 'C') THEN
598: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');
599: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);
600: END IF;
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;

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

595: EXCEPTION
596: WHEN OTHERS THEN
597: IF PG_DEBUG in ('Y', 'C') THEN
598: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');
599: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);
600: END IF;
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;
603: */

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

715: p_mode => 'BATCH',
716: p_key_value_list => l_misc_cash_key_value_list);
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_util.debug('error deleting ar_mc_misc_cash_dists');
720: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);
721: APP_EXCEPTION.RAISE_EXCEPTION;
722: END;
723: */

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

716: p_key_value_list => l_misc_cash_key_value_list);
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_util.debug('error deleting ar_mc_misc_cash_dists');
720: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);
721: APP_EXCEPTION.RAISE_EXCEPTION;
722: END;
723: */
724: -- check if receipt amount is zero. If yes, don't create any

Line 773: arp_util.Substitute_Ccid(

769: +--------------------------------------------------------------------*/
770: /* Bug4726219 */
771: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),
772: 'N') = 'N' AND l_type <> 'MISCCASH' THEN
773: arp_util.Substitute_Ccid(
774: p_coa_id => arp_global.chart_of_accounts_id,
775: p_original_ccid => l_trx_code_combination_id,
776: p_subs_ccid => l_crh_ccid,
777: p_actual_ccid => l_misc_cash_dist_rec.code_combination_id );

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

1022: --
1023: -- Handle case 8 right away:
1024: --
1025: IF PG_DEBUG in ('Y', 'C') THEN
1026: arp_util.debug('update_misc_dist: ' || '=====> Case 8: amount is zero -- deleting applications');
1027: END IF;
1028:
1029: SELECT count(mcd.misc_cash_distribution_id)
1030: INTO l_count

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

1207: IF (p_receipt_date_changed_flag = TRUE OR
1208: p_gl_date_changed_flag = TRUE) THEN
1209: --
1210: IF PG_DEBUG in ('Y', 'C') THEN
1211: arp_util.debug('update_misc_dist: ' || '=====> Case 1/7: updating distributions with new date(s)');
1212: END IF;
1213: --
1214: /*----------------------------------+
1215: | Added bulk collect of misc cash |

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

1236: p_key_value_list => l_misc_cash_key_value_list);
1237: */
1238: ELSE
1239: IF PG_DEBUG in ('Y', 'C') THEN
1240: arp_util.debug('update_misc_dist: ' || '=====> Case 1/7: no update required');
1241: END IF;
1242: END IF;
1243: --
1244: /* Bug 1792989. When only the receipt amount is changed with no change

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

1263: (l_old_recs_auto_flag = FALSE AND
1264: l_new_recs_auto_flag = FALSE)) THEN
1265:
1266: IF PG_DEBUG in ('Y', 'C') THEN
1267: arp_util.debug('update_misc_dist: ' || '=====> Case 2: updating amounts');
1268: END IF;
1269: SELECT count(mcd.misc_cash_distribution_id)
1270: INTO l_count
1271: FROM ar_misc_cash_distributions mcd

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

1336: -- if distribution was and still is created manually, just update
1337: -- the amounts for each record.
1338: --
1339: IF PG_DEBUG in ('Y', 'C') THEN
1340: arp_util.debug('update_misc_dist: ' || '=====> Case 2: updating amounts');
1341: END IF;
1342: --
1343: update_manual_dist( p_cash_receipt_id,
1344: p_amount,

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

1364: ***** IF THIS EVER IS UNCOMMENTED, THEN A CALL TO THE MRC ENGINE IS
1365: REQUIRED.....
1366:
1367: IF PG_DEBUG in ('Y', 'C') THEN
1368: arp_util.debug('update_misc_dist: ' || 'Case 3: deleting old records');
1369: END IF;
1370:
1371: DELETE ar_misc_cash_distributions
1372: WHERE cash_receipt_id = p_cash_receipt_id;

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

1372: WHERE cash_receipt_id = p_cash_receipt_id;
1373:
1374: */
1375: IF PG_DEBUG in ('Y', 'C') THEN
1376: arp_util.debug('update_misc_dist: ' || '=====> Case 3: do nothing');
1377: END IF;
1378: NULL;
1379:
1380: ELSE

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

1720: l_acctd_rounding_diff
1721: FROM ar_distribution_set_lines
1722: WHERE distribution_set_id = p_distribution_set_id;
1723:
1724: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1725: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1726:
1727:
1728: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN

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

1721: FROM ar_distribution_set_lines
1722: WHERE distribution_set_id = p_distribution_set_id;
1723:
1724: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1725: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1726:
1727:
1728: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN
1729:

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

1896: l_acctd_rounding_diff
1897: FROM ar_misc_cash_distributions
1898: WHERE cash_receipt_id = p_cash_receipt_id;
1899:
1900: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1901: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1902:
1903:
1904: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN

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

1897: FROM ar_misc_cash_distributions
1898: WHERE cash_receipt_id = p_cash_receipt_id;
1899:
1900: arp_util.debug('Rounding error = ' || to_char(l_rounding_diff));
1901: arp_util.debug('Rounding error (acctd) = ' || to_char(l_acctd_rounding_diff));
1902:
1903:
1904: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN
1905: