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.ZX_AR_ACTG_POPULATE_PKG dependencies on ZX_AR_ACTG_POPULATE_PKG

Line 1: PACKAGE BODY ZX_AR_ACTG_POPULATE_PKG AS

1: PACKAGE BODY ZX_AR_ACTG_POPULATE_PKG AS
2: /* $Header: zxriractgpoppvtb.pls 120.7 2006/02/08 14:34:09 rjreddy ship $ */
3:
4:
5: --Populate party info into global variables

Line 385: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.BEGIN',

381:
382: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
383:
384: IF (g_level_procedure >= g_current_runtime_level ) THEN
385: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.BEGIN',
386: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');
387: END IF;
388: l_ledger_id := NVL(P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID, P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID);
389: -- L_MATRIX_REPORT := P_MATRIX_REPORT;

Line 386: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');

382: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
383:
384: IF (g_level_procedure >= g_current_runtime_level ) THEN
385: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.BEGIN',
386: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(+)');
387: END IF;
388: l_ledger_id := NVL(P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID, P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID);
389: -- L_MATRIX_REPORT := P_MATRIX_REPORT;
390: -- l_request_id is global param, assigned value in initialize

Line 525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',

521: P_TRL_GLOBAL_VARIABLES_REC.request_id);
522: */
523:
524: IF (g_level_procedure >= g_current_runtime_level ) THEN
525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
526: 'G_REP_CONTEXT_ID :' ||to_char(G_REP_CONTEXT_ID)||'---'
527: ||to_char(GT_INTERNAL_ORGANIZATION_ID(i)));
528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
529: 'GT_TRX_ID :' ||to_char(GT_TRX_ID(i)));

Line 528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',

524: IF (g_level_procedure >= g_current_runtime_level ) THEN
525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
526: 'G_REP_CONTEXT_ID :' ||to_char(G_REP_CONTEXT_ID)||'---'
527: ||to_char(GT_INTERNAL_ORGANIZATION_ID(i)));
528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
529: 'GT_TRX_ID :' ||to_char(GT_TRX_ID(i)));
530: END IF;
531:
532: -- Replacement to populate_inv()

Line 620: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.END',

616:
617: CLOSE detail_t_cur;
618:
619: IF (g_level_procedure >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.END',
621: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(-)');
622: END IF;
623:
624: EXCEPTION

Line 621: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(-)');

617: CLOSE detail_t_cur;
618:
619: IF (g_level_procedure >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO.END',
621: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_ADDITIONAL_INFO(-)');
622: END IF;
623:
624: EXCEPTION
625: WHEN OTHERS THEN

Line 632: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',

628: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
629: FND_MSG_PUB.Add;
630: IF (g_level_unexpected >= g_current_runtime_level ) THEN
631: FND_LOG.STRING(g_level_unexpected,
632: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_ADDITIONAL_INFO',
633: g_error_buffer);
634: END IF;
635:
636: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := G_RETCODE;

Line 706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.BEGIN',

702:
703: BEGIN
704:
705: IF (g_level_procedure >= g_current_runtime_level ) THEN
706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.BEGIN',
707: 'ZX_AR_ACTG_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(+)');
708: END IF;
709:
710: -- L_ORG_ID := P_RA_SUB_ITF_TABLE_REC.org_id;

Line 707: 'ZX_AR_ACTG_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(+)');

703: BEGIN
704:
705: IF (g_level_procedure >= g_current_runtime_level ) THEN
706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.BEGIN',
707: 'ZX_AR_ACTG_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(+)');
708: END IF;
709:
710: -- L_ORG_ID := P_RA_SUB_ITF_TABLE_REC.org_id;
711: -- L_CONTROL_ACCOUNT_CCID := P_RA_SUB_ITF_TABLE_REC.al_account_ccid;

Line 843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.END',

839:
840: END IF; -- P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION'
841:
842: IF (g_level_procedure >= g_current_runtime_level ) THEN
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.END',
844: 'ZX_AR_ACTG_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(-)');
845: END IF;
846:
847: EXCEPTION

Line 844: 'ZX_AR_ACTG_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(-)');

840: END IF; -- P_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION'
841:
842: IF (g_level_procedure >= g_current_runtime_level ) THEN
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS.END',
844: 'ZX_AR_ACTG_POPULATE_PKG: APP_FUNCTIONAL_AMOUNTS(-)');
845: END IF;
846:
847: EXCEPTION
848: WHEN OTHERS THEN

Line 855: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',

851: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
852: FND_MSG_PUB.Add;
853: IF (g_level_unexpected >= g_current_runtime_level ) THEN
854: FND_LOG.STRING(g_level_unexpected,
855: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.APP_FUNCTIONAL_AMOUNTS',
856: g_error_buffer);
857: END IF;
858:
859: G_RETCODE := 2;

Line 2047: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts.BEGIN',

2043: l_TAX_ACCOUNTED_AMOUNT number;
2044: BEGIN
2045:
2046: IF (g_level_procedure >= g_current_runtime_level ) THEN
2047: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts.BEGIN',
2048: 'ZX_AR_ACTG_POPULATE_PKG: convert_amounts(+)');
2049: END IF;
2050: /*
2051: IF P_INPUT_EXEMPT_AMOUNT IS NOT NULL THEN

Line 2048: 'ZX_AR_ACTG_POPULATE_PKG: convert_amounts(+)');

2044: BEGIN
2045:
2046: IF (g_level_procedure >= g_current_runtime_level ) THEN
2047: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts.BEGIN',
2048: 'ZX_AR_ACTG_POPULATE_PKG: convert_amounts(+)');
2049: END IF;
2050: /*
2051: IF P_INPUT_EXEMPT_AMOUNT IS NOT NULL THEN
2052: P_EXEMPT_ENTERED_AMOUNT := P_INPUT_EXEMPT_AMOUNT;

Line 2108: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts.END',

2104: GT_TAXABLE_AMT_FUNCL_CURR(i) := l_TAXABLE_ACCOUNTED_AMOUNT;
2105:
2106:
2107: IF (g_level_procedure >= g_current_runtime_level ) THEN
2108: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts.END',
2109: 'ZX_AR_ACTG_POPULATE_PKG: convert_amounts(-)');
2110: END IF;
2111:
2112: EXCEPTION

Line 2109: 'ZX_AR_ACTG_POPULATE_PKG: convert_amounts(-)');

2105:
2106:
2107: IF (g_level_procedure >= g_current_runtime_level ) THEN
2108: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts.END',
2109: 'ZX_AR_ACTG_POPULATE_PKG: convert_amounts(-)');
2110: END IF;
2111:
2112: EXCEPTION
2113: WHEN OTHERS THEN

Line 2120: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts',

2116: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2117: FND_MSG_PUB.Add;
2118: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2119: FND_LOG.STRING(g_level_unexpected,
2120: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.convert_amounts',
2121: g_error_buffer);
2122: END IF;
2123:
2124: G_RETCODE := 2;

Line 2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',

2248: BEGIN
2249:
2250:
2251: IF (g_level_procedure >= g_current_runtime_level ) THEN
2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2253: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2255: 'gt_historical_flag :' ||gt_historical_flag(i));
2256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 2253: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');

2249:
2250:
2251: IF (g_level_procedure >= g_current_runtime_level ) THEN
2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2253: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2255: 'gt_historical_flag :' ||gt_historical_flag(i));
2256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2257: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));

Line 2254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2250:
2251: IF (g_level_procedure >= g_current_runtime_level ) THEN
2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2253: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2255: 'gt_historical_flag :' ||gt_historical_flag(i));
2256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2257: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
2258: END IF;

Line 2256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2253: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2255: 'gt_historical_flag :' ||gt_historical_flag(i));
2256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2257: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
2258: END IF;
2259:
2260: IF gt_historical_flag(i) IS NULL AND GT_BILL_TO_PARTY_TAX_PROF_ID(i) IS NOT NULL THEN

Line 2279: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2275: CLOSE migrated_party_cur;
2276:
2277: IF (g_level_procedure >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_procedure,
2279: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2280: 'migrated_party_cur'||to_char(GT_BILL_TO_PARTY_ID(i))||'-'||to_char(GT_BILLING_TP_ID(i)));
2281: END IF;
2282:
2283:

Line 2298: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2294: CLOSE site_profile_id_cur;
2295:
2296: IF (g_level_procedure >= g_current_runtime_level ) THEN
2297: FND_LOG.STRING(g_level_procedure,
2298: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2299: 'migrated_party_site_cur :'||to_char(GT_BILL_TO_PARTY_SITE_ID(i))||'-'||to_char(GT_BILLING_TP_ADDRESS_ID(i)));
2300: END IF;
2301:
2302: l_bill_to_party_id := GT_BILL_TO_PARTY_ID(i);

Line 2316: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2312: l_bill_ship, 1,8192);
2313:
2314: IF (g_level_procedure >= g_current_runtime_level ) THEN
2315: FND_LOG.STRING(g_level_procedure,
2316: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2317: 'Before Open cust_acct_cur :'||to_char(l_bill_to_party_id)||'-'||to_char(l_bill_to_site_id));
2318: END IF;
2319:
2320: IF g_cust_bill_ar_tbl.EXISTS(l_tbl_index_cust) THEN

Line 2342: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2338: GT_BILLING_TP_TAX_REG_NUM(i);
2339:
2340: IF (g_level_procedure >= g_current_runtime_level ) THEN
2341: FND_LOG.STRING(g_level_procedure,
2342: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2343: 'After fetch of cust_acct_cur'||GT_BILLING_TP_NUMBER(i)||'-'||GT_BILLING_TP_TAX_REG_NUM(i));
2344: END IF;
2345:
2346: g_cust_bill_ar_tbl(l_tbl_index_cust).BILLING_TP_NUMBER := GT_BILLING_TP_NUMBER(i);

Line 2359: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2355: END IF;
2356:
2357: IF (g_level_procedure >= g_current_runtime_level ) THEN
2358: FND_LOG.STRING(g_level_procedure,
2359: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2360: 'After assign to g_cust_bill_ar_tbl ');
2361: END IF;
2362:
2363: l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_to_party_id)||

Line 2389: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2385:
2386:
2387: IF (g_level_procedure >= g_current_runtime_level ) THEN
2388: FND_LOG.STRING(g_level_procedure,
2389: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2390: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
2391: END IF;
2392: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||
2393: l_bill_ship, 1,8192);

Line 2436: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2432:
2433:
2434: IF (g_level_procedure >= g_current_runtime_level ) THEN
2435: FND_LOG.STRING(g_level_procedure,
2436: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2437: 'After assign to g_site_bill_ar_tbl '||g_site_bill_ar_tbl(l_tbl_index_site).BILLING_TP_CITY);
2438: END IF;
2439: END IF;
2440:

Line 2581: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.END',

2577: END IF;
2578:
2579:
2580: IF (g_level_procedure >= g_current_runtime_level ) THEN
2581: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.END',
2582: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');
2583: END IF;
2584:
2585: EXCEPTION

Line 2582: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');

2578:
2579:
2580: IF (g_level_procedure >= g_current_runtime_level ) THEN
2581: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO.END',
2582: 'ZX_AR_ACTG_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');
2583: END IF;
2584:
2585: EXCEPTION
2586: WHEN OTHERS THEN

Line 2593: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',

2589: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2590: FND_MSG_PUB.Add;
2591: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2592: FND_LOG.STRING(g_level_unexpected,
2593: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2594: g_error_buffer);
2595: END IF;
2596:
2597: G_RETCODE := 2;

Line 3177: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T.BEGIN',

3173: i number;
3174: BEGIN
3175:
3176: IF (g_level_procedure >= g_current_runtime_level ) THEN
3177: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T.BEGIN',
3178: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
3179: END IF;
3180:
3181: FORALL i in 1..p_count

Line 3178: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');

3174: BEGIN
3175:
3176: IF (g_level_procedure >= g_current_runtime_level ) THEN
3177: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T.BEGIN',
3178: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
3179: END IF;
3180:
3181: FORALL i in 1..p_count
3182: UPDATE ZX_REP_TRX_DETAIL_T SET

Line 3250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T.END',

3246: TAX_AMT_FUNCL_CURR = GT_TAX_AMT_FUNCL_CURR(i)
3247: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
3248:
3249: IF (g_level_procedure >= g_current_runtime_level ) THEN
3250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T.END',
3251: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(-)');
3252: END IF;
3253:
3254:

Line 3251: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(-)');

3247: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
3248:
3249: IF (g_level_procedure >= g_current_runtime_level ) THEN
3250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T.END',
3251: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(-)');
3252: END IF;
3253:
3254:
3255: EXCEPTION

Line 3263: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T',

3259: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3260: FND_MSG_PUB.Add;
3261: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3262: FND_LOG.STRING(g_level_unexpected,
3263: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_DETAIL_T',
3264: g_error_buffer);
3265: END IF;
3266:
3267: G_RETCODE := 2;

Line 3276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG_T.BEGIN',

3272: i number;
3273: BEGIN
3274:
3275: IF (g_level_procedure >= g_current_runtime_level ) THEN
3276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG_T.BEGIN',
3277: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(+)');
3278: END IF;
3279:
3280: FORALL i in 1..p_count

Line 3277: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(+)');

3273: BEGIN
3274:
3275: IF (g_level_procedure >= g_current_runtime_level ) THEN
3276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG_T.BEGIN',
3277: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(+)');
3278: END IF;
3279:
3280: FORALL i in 1..p_count
3281: UPDATE zx_rep_actg_ext_t SET

Line 3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG__T.END',

3287: TRX_TAX_NATURAL_ACCOUNT = GT_TRX_TAX_NATURAL_ACCOUNT(i)
3288: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
3289:
3290: IF (g_level_procedure >= g_current_runtime_level ) THEN
3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG__T.END',
3292: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(-)');
3293: END IF;
3294:
3295:

Line 3292: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(-)');

3288: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
3289:
3290: IF (g_level_procedure >= g_current_runtime_level ) THEN
3291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG__T.END',
3292: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(-)');
3293: END IF;
3294:
3295:
3296: EXCEPTION

Line 3304: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG_T',

3300: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3301: FND_MSG_PUB.Add;
3302: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3303: FND_LOG.STRING(g_level_unexpected,
3304: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.UPDATE_REP_ACTG_T',
3305: g_error_buffer);
3306: END IF;
3307:
3308: G_RETCODE := 2;

Line 3319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.BEGIN',

3315:
3316: BEGIN
3317:
3318: IF (g_level_procedure >= g_current_runtime_level ) THEN
3319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.BEGIN',
3320: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(+)');
3321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables',
3322: 'p_count : '||to_char(p_count));
3323: END IF;

Line 3320: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(+)');

3316: BEGIN
3317:
3318: IF (g_level_procedure >= g_current_runtime_level ) THEN
3319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.BEGIN',
3320: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(+)');
3321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables',
3322: 'p_count : '||to_char(p_count));
3323: END IF;
3324:

Line 3321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables',

3317:
3318: IF (g_level_procedure >= g_current_runtime_level ) THEN
3319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.BEGIN',
3320: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(+)');
3321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables',
3322: 'p_count : '||to_char(p_count));
3323: END IF;
3324:
3325: FOR i IN 1.. p_count LOOP

Line 3433: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.END',

3429:
3430: END LOOP;
3431:
3432: IF (g_level_procedure >= g_current_runtime_level ) THEN
3433: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.END',
3434: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(-)');
3435: END IF;
3436:
3437: EXCEPTION

Line 3434: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(-)');

3430: END LOOP;
3431:
3432: IF (g_level_procedure >= g_current_runtime_level ) THEN
3433: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables.END',
3434: 'ZX_AR_ACTG_POPULATE_PKG: initialize_variables(-)');
3435: END IF;
3436:
3437: EXCEPTION
3438: WHEN OTHERS THEN

Line 3445: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables',

3441: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3442: FND_MSG_PUB.Add;
3443: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3444: FND_LOG.STRING(g_level_unexpected,
3445: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.initialize_variables',
3446: g_error_buffer);
3447: END IF;
3448:
3449: END initialize_variables ;

Line 3451: END ZX_AR_ACTG_POPULATE_PKG;

3447: END IF;
3448:
3449: END initialize_variables ;
3450:
3451: END ZX_AR_ACTG_POPULATE_PKG;