DBA Data[Home] [Help]

APPS.PSA_MFAR_RECEIPTS dependencies on PSA_MFAR_UTILS

Line 507: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id, l_exception_message);

503:
504: EXCEPTION
505: WHEN generate_rct_dist_excep THEN
506: retcode := 'F';
507: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id, l_exception_message);
508: p_error_message := l_exception_message;
509: -- ========================= FND LOG ===========================
510: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
511: -- ========================= FND LOG ===========================

Line 517: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

513:
514: WHEN OTHERS THEN
515: retcode := 'F';
516: p_error_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_TRANSACTIONS.CREATE_DISTRIBUTIONS - ' || SQLERRM;
517: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
518: p_error_message);
519: -- ========================= FND LOG ===========================
520: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
521: psa_utils.debug_unexpected_msg(l_full_path);

Line 1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');

1023: psa_utils.debug_other_string(g_state_level,l_full_path,' if cond - document type is CM --> ' || p_ccid);
1024: -- ========================= FND LOG ===========================
1025: ELSE
1026: -- ========================= FND LOG ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
1028: -- ========================= FND LOG ===========================
1029:
1030: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_cash_ccid,
1031: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,

Line 1030: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_cash_ccid,

1026: -- ========================= FND LOG ===========================
1027: psa_utils.debug_other_string(g_state_level,l_full_path,' else cond - calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
1028: -- ========================= FND LOG ===========================
1029:
1030: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_cash_ccid,
1031: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,
1032: P_SET_OF_BOOKS_ID => g_set_of_books_id,
1033: P_TRX_TYPE => 'RCT',
1034: P_CCID => p_ccid)) -- OUT

Line 1037: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');

1033: P_TRX_TYPE => 'RCT',
1034: P_CCID => p_ccid)) -- OUT
1035: THEN
1036: -- ========================= FND LOG ===========================
1037: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1038: -- ========================= FND LOG ===========================
1039: RAISE FLEX_BUILD_ERROR;
1040: ELSE
1041: -- ========================= FND LOG ===========================

Line 1193: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for earned discount');

1189:
1190: IF p_earned_discount_ccid IS NOT NULL THEN
1191: -- ========================= FND LOG ===========================
1192: psa_utils.debug_other_string(g_state_level,l_full_path,
1193: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for earned discount');
1194: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NOT NULL ');
1195: psa_utils.debug_other_string(g_state_level,l_full_path,
1196: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1197: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||

Line 1202: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (p_earned_discount_ccid,

1198: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1199: ' ##p_mf_earned_discount_ccid --> ' || p_mf_earned_discount_ccid);
1200: -- ========================= FND LOG ===========================
1201:
1202: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (p_earned_discount_ccid,
1203: l_accrual_rec.rcv_ccid,
1204: g_set_of_books_id,'RCT',
1205: p_mf_earned_discount_ccid) ) THEN
1206:

Line 1208: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');

1204: g_set_of_books_id,'RCT',
1205: p_mf_earned_discount_ccid) ) THEN
1206:
1207: -- ========================= FND LOG ===========================
1208: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');
1209: -- ========================= FND LOG ===========================
1210: RAISE FLEX_BUILD_ERROR;
1211: END IF;
1212: ELSE

Line 1221: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for unearned discount');

1217:
1218: IF p_unearned_discount_ccid IS NOT NULL THEN
1219: -- ========================= FND LOG ===========================
1220: psa_utils.debug_other_string(g_state_level,l_full_path,
1221: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for unearned discount');
1222: psa_utils.debug_other_string(g_state_level,l_full_path,
1223: ' p_earned_discount_ccid IS NOT NULL ');
1224: psa_utils.debug_other_string(g_state_level,l_full_path,
1225: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||

Line 1231: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_unearned_discount_ccid,

1227: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1228: ' ##p_mf_unearned_discount_ccid --> ' || p_mf_unearned_discount_ccid);
1229: -- ========================= FND LOG ===========================
1230:
1231: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_unearned_discount_ccid,
1232: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,
1233: P_SET_OF_BOOKS_ID => g_set_of_books_id,
1234: P_TRX_TYPE => 'RCT',
1235: P_CCID => p_mf_unearned_discount_ccid)) -- OUT

Line 1238: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');

1234: P_TRX_TYPE => 'RCT',
1235: P_CCID => p_mf_unearned_discount_ccid)) -- OUT
1236: THEN
1237: -- ========================= FND LOG ===========================
1238: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1239: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1240: -- ========================= FND LOG ===========================
1241: RAISE FLEX_BUILD_ERROR;
1242: ELSE

Line 1847: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for earned discount');

1843:
1844: IF p_earned_discount_ccid IS NOT NULL THEN
1845: -- ========================= FND LOG ===========================
1846: psa_utils.debug_other_string(g_state_level,l_full_path,
1847: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for earned discount');
1848: psa_utils.debug_other_string(g_state_level,l_full_path,' p_earned_discount_ccid IS NOT NULL ');
1849: psa_utils.debug_other_string(g_state_level,l_full_path,
1850: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||
1851: ' ##rcv_ccid --> ' || l_accrual_rec.rcv_ccid ||

Line 1856: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (p_earned_discount_ccid,

1852: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1853: ' ##p_mf_earned_discount_ccid --> ' || p_mf_earned_discount_ccid);
1854: -- ========================= FND LOG ===========================
1855:
1856: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (p_earned_discount_ccid,
1857: l_accrual_rec.rcv_ccid,
1858: g_set_of_books_id,'RCT',
1859: p_mf_earned_discount_ccid) ) THEN
1860:

Line 1862: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');

1858: g_set_of_books_id,'RCT',
1859: p_mf_earned_discount_ccid) ) THEN
1860:
1861: -- ========================= FND LOG ===========================
1862: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE');
1863: -- ========================= FND LOG ===========================
1864: RAISE FLEX_BUILD_ERROR;
1865: END IF;
1866: ELSE

Line 1875: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for unearned discount');

1871:
1872: IF p_unearned_discount_ccid IS NOT NULL THEN
1873: -- ========================= FND LOG ===========================
1874: psa_utils.debug_other_string(g_state_level,l_full_path,
1875: ' calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS for unearned discount');
1876: psa_utils.debug_other_string(g_state_level,l_full_path,
1877: ' p_earned_discount_ccid IS NOT NULL ');
1878: psa_utils.debug_other_string(g_state_level,l_full_path,
1879: ' ##p_unearned_discount_ccid --> ' || p_unearned_discount_ccid ||

Line 1885: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_unearned_discount_ccid,

1881: ' ##g_set_of_books_id --> ' || g_set_of_books_id ||
1882: ' ##p_mf_unearned_discount_ccid --> ' || p_mf_unearned_discount_ccid);
1883: -- ========================= FND LOG ===========================
1884:
1885: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => p_unearned_discount_ccid,
1886: P_OVERRIDE_CCID => l_accrual_rec.rcv_ccid,
1887: P_SET_OF_BOOKS_ID => g_set_of_books_id,
1888: P_TRX_TYPE => 'RCT',
1889: P_CCID => p_mf_unearned_discount_ccid)) -- OUT

Line 1892: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');

1888: P_TRX_TYPE => 'RCT',
1889: P_CCID => p_mf_unearned_discount_ccid)) -- OUT
1890: THEN
1891: -- ========================= FND LOG ===========================
1892: psa_utils.debug_other_string(g_state_level,l_full_path,' PSA_MFAR_UTILS.OVERRIDE_SEGMENTS -> FALSE ');
1893: psa_utils.debug_other_string(g_state_level,l_full_path,' Raising flex_build_error ');
1894: -- ========================= FND LOG ===========================
1895: RAISE FLEX_BUILD_ERROR;
1896: ELSE

Line 2074: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2070:
2071: EXCEPTION
2072: WHEN OTHERS THEN
2073: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS: '||sqlerrm;
2074: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2075: l_exception_message);
2076: -- ========================= FND LOG ===========================
2077: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2078: psa_utils.debug_unexpected_msg(l_full_path);

Line 2151: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2147:
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.POPULATE_DISCOUNT_LINES_CACHE: '||sqlerrm;
2151: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2152: l_exception_message);
2153: -- ========================= FND LOG ===========================
2154: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2155: psa_utils.debug_unexpected_msg(l_full_path);

Line 2210: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.MANUAL_TRANSACTION: '||sqlerrm;
2210: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2211: l_exception_message);
2212: -- ========================= FND LOG ===========================
2213: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2214: psa_utils.debug_unexpected_msg(l_full_path);

Line 2276: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2272:
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.INCLUDE_MANUAL_LINE: '|| sqlerrm;
2276: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2277: l_exception_message);
2278: -- ========================= FND LOG ===========================
2279: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2280: psa_utils.debug_unexpected_msg(l_full_path);

Line 2340: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2336:
2337: EXCEPTION
2338: WHEN OTHERS THEN
2339: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.IMPORTED_TRANSACTION: '|| sqlerrm;
2340: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2341: l_exception_message);
2342: -- ========================= FND LOG ===========================
2343: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2344: psa_utils.debug_unexpected_msg(l_full_path);

Line 2435: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2431:
2432: EXCEPTION
2433: WHEN OTHERS THEN
2434: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.INCLUDE_IMPORTED_LINE: '|| sqlerrm;
2435: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2436: l_exception_message);
2437: -- ========================= FND LOG ===========================
2438: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2439: psa_utils.debug_unexpected_msg(l_full_path);

Line 2463: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2459:
2460: EXCEPTION
2461: WHEN OTHERS THEN
2462: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.LINE_IN_DISCOUNT_CACHE: '|| sqlerrm;
2463: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2464: l_exception_message);
2465: -- ========================= FND LOG ===========================
2466: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2467: psa_utils.debug_unexpected_msg(l_full_path);

Line 2490: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,

2486:
2487: EXCEPTION
2488: WHEN OTHERS THEN
2489: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.RESET_DISCOUNT_CACHE: '|| sqlerrm;
2490: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'RECEIPT', g_cust_trx_id, g_receivable_application_id,
2491: l_exception_message);
2492: -- ========================= FND LOG ===========================
2493: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_message);
2494: psa_utils.debug_unexpected_msg(l_full_path);