eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_MFAR_RECEIPTS dependencies on PSA_MFAR_RECEIPTS

Line 1: PACKAGE BODY PSA_MFAR_RECEIPTS AS

1: PACKAGE BODY PSA_MFAR_RECEIPTS AS
2: /* $Header: PSAMFRTB.pls 120.29 2006/09/13 13:45:49 agovil ship $ */
3:
4: g_set_of_books_id gl_sets_of_books.set_of_books_id%type;
5: g_cust_trx_id ar_receivable_applications.applied_customer_trx_id%type;

Line 22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';

18: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
19: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
20: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
21: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
22: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFRTB.PSA_MFAR_RECEIPTS.';
23: --===========================FND_LOG.END=======================================
24:
25:
26: -- Variables for currency code

Line 1253: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');

1249: END IF;
1250: END IF;
1251:
1252: -- ========================= FND LOG ===========================
1253: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1254: -- ========================= FND LOG ===========================
1255:
1256: --
1257: -- Insert into psa_mf_rct_dist_all

Line 1260: PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW

1256: --
1257: -- Insert into psa_mf_rct_dist_all
1258: --
1259:
1260: PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW
1261: (
1262: x_rowid => l_rowid,
1263: x_receivable_application_id => p_rcv_app_id,
1264: x_cust_trx_line_gl_dist_id => l_accrual_rec.trx_line_dist_id,

Line 1316: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');

1312: -- Bug 3672756
1313: WHEN INVALID_DISTRIBUTION THEN
1314: -- ========================= FND LOG ===========================
1315: psa_utils.debug_other_string(g_excep_level,l_full_path,
1316: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1317: psa_utils.debug_other_string(g_excep_level,l_full_path,
1318: ' --> p_error_message --> ' || l_exception_message);
1319: -- ========================= FND LOG ===========================
1320: p_error_message := l_exception_message;

Line 1328: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');

1324: WHEN FLEX_BUILD_ERROR THEN
1325: l_exception_message := fnd_message.get;
1326: -- ========================= FND LOG ===========================
1327: psa_utils.debug_other_string(g_excep_level,l_full_path,
1328: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1329: psa_utils.debug_other_string(g_excep_level,l_full_path,
1330: ' --> p_error_message --> ' || l_exception_message);
1331: -- ========================= FND LOG ===========================
1332: p_error_message := l_exception_message;

Line 1340: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');

1336: WHEN OTHERS THEN
1337: l_exception_message := l_exception_message || SQLCODE || ' - ' || SQLERRM;
1338: -- ========================= FND LOG ===========================
1339: psa_utils.debug_other_string(g_excep_level,l_full_path,
1340: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1341: psa_utils.debug_other_string(g_excep_level,l_full_path,
1342: ' --> p_error_message --> ' || l_exception_message);
1343: psa_utils.debug_unexpected_msg(l_full_path);
1344: -- ========================= FND LOG ===========================

Line 1907: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');

1903: END IF;
1904: END IF;
1905:
1906: -- ========================= FND LOG ===========================
1907: psa_utils.debug_other_string(g_state_level,l_full_path,' calling PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW');
1908: -- ========================= FND LOG ===========================
1909:
1910: --
1911: -- Insert into psa_mf_rct_dist_all

Line 1925: PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW

1921: -- ========================= FND LOG ===========================
1922: END IF;
1923:
1924: IF nvl(l_amount, 0) <> 0 THEN
1925: PSA_MFAR_RECEIPTS_COVER_PKG.INSERT_ROW
1926: (
1927: x_rowid => l_rowid,
1928: x_receivable_application_id => p_rcv_app_id,
1929: x_cust_trx_line_gl_dist_id => l_accrual_rec.trx_line_dist_id,

Line 1985: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');

1981: -- Bug 3672756
1982: WHEN INVALID_DISTRIBUTION THEN
1983: -- ========================= FND LOG ===========================
1984: psa_utils.debug_other_string(g_excep_level,l_full_path,
1985: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1986: psa_utils.debug_other_string(g_excep_level,l_full_path,
1987: ' --> p_error_message --> ' || l_exception_message);
1988: -- ========================= FND LOG ===========================
1989: p_error_message := l_exception_message;

Line 1997: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');

1993: WHEN FLEX_BUILD_ERROR THEN
1994: l_exception_message := fnd_message.get;
1995: -- ========================= FND LOG ===========================
1996: psa_utils.debug_other_string(g_excep_level,l_full_path,
1997: ' --> EXCEPTION - FLEX_BUILD_ERROR raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
1998: psa_utils.debug_other_string(g_excep_level,l_full_path,
1999: ' --> p_error_message --> ' || l_exception_message);
2000: -- ========================= FND LOG ===========================
2001: p_error_message := l_exception_message;

Line 2009: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');

2005: WHEN OTHERS THEN
2006: l_exception_message := l_exception_message || SQLCODE || ' - ' || SQLERRM;
2007: -- ========================= FND LOG ===========================
2008: psa_utils.debug_other_string(g_excep_level,l_full_path,
2009: ' --> EXCEPTION - OTHERS raised during PSA_MFAR_RECEIPTS.generate_rct_dist ');
2010: psa_utils.debug_other_string(g_excep_level,l_full_path,
2011: ' --> p_error_message --> ' || l_exception_message);
2012: psa_utils.debug_unexpected_msg(l_full_path);
2013: -- ========================= FND LOG ===========================

Line 2073: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.PURGE_ORPHAN_DISTRIBUTIONS: '||sqlerrm;

2069: -- ========================= FND LOG ===========================
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);

Line 2150: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.POPULATE_DISCOUNT_LINES_CACHE: '||sqlerrm;

2146: END IF;
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);

Line 2209: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.MANUAL_TRANSACTION: '||sqlerrm;

2205: -- ========================= FND LOG ===========================
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);

Line 2275: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.INCLUDE_MANUAL_LINE: '|| sqlerrm;

2271: RETURN 'Y';
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);

Line 2339: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.IMPORTED_TRANSACTION: '|| sqlerrm;

2335: CLOSE c_imported_trx;
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);

Line 2434: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.INCLUDE_IMPORTED_LINE: '|| sqlerrm;

2430: RETURN 'Y';
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);

Line 2462: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.LINE_IN_DISCOUNT_CACHE: '|| sqlerrm;

2458: END LOOP;
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);

Line 2489: l_exception_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_RECEIPTS.RESET_DISCOUNT_CACHE: '|| sqlerrm;

2485: END LOOP;
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);

Line 2500: END psa_mfar_receipts;

2496:
2497: END reset_discount_cache;
2498:
2499:
2500: END psa_mfar_receipts;