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 FND_LOG

Line 148: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

144: C_LINES_PER_COMMIT CONSTANT NUMBER := 5000;
145: L_MSG VARCHAR2(500);
146: G_REP_CONTEXT_ID NUMBER;
147: g_current_runtime_level NUMBER;
148: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
149: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
150: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
151: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: g_error_buffer VARCHAR2(100);

Line 149: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

145: L_MSG VARCHAR2(500);
146: G_REP_CONTEXT_ID NUMBER;
147: g_current_runtime_level NUMBER;
148: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
149: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
150: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
151: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: g_error_buffer VARCHAR2(100);
153:

Line 150: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

146: G_REP_CONTEXT_ID NUMBER;
147: g_current_runtime_level NUMBER;
148: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
149: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
150: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
151: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: g_error_buffer VARCHAR2(100);
153:
154: PROCEDURE convert_amounts(P_CURRENCY_CODE IN VARCHAR2,

Line 151: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

147: g_current_runtime_level NUMBER;
148: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
149: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
150: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
151: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: g_error_buffer VARCHAR2(100);
153:
154: PROCEDURE convert_amounts(P_CURRENCY_CODE IN VARCHAR2,
155: P_EXCHANGE_RATE IN NUMBER,

Line 382: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

378: l_accounting_segment VARCHAR2(25);
379: l_ledger_id NUMBER(15);
380: 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(+)');

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 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 631: FND_LOG.STRING(g_level_unexpected,

627: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:

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 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 854: FND_LOG.STRING(g_level_unexpected,

850: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:

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 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 2119: FND_LOG.STRING(g_level_unexpected,

2115: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:

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 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 2278: FND_LOG.STRING(g_level_procedure,

2274: FETCH migrated_party_cur INTO GT_BILL_TO_PARTY_ID(i);
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:

Line 2297: FND_LOG.STRING(g_level_procedure,

2293: FETCH site_profile_id_cur INTO l_bill_to_stp_id;
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:

Line 2315: FND_LOG.STRING(g_level_procedure,

2311: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||to_char(l_bill_to_party_id)||
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:

Line 2341: FND_LOG.STRING(g_level_procedure,

2337: GT_BILLING_TP_SITE_NAME(i),
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:

Line 2358: FND_LOG.STRING(g_level_procedure,

2354: CLOSE cust_acct_cur;
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:

Line 2388: FND_LOG.STRING(g_level_procedure,

2384:
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)||

Line 2435: FND_LOG.STRING(g_level_procedure,

2431:
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;

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 2592: FND_LOG.STRING(g_level_unexpected,

2588: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:

Line 2721: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',

2717: BEGIN
2718:
2719:
2720: IF (g_level_procedure >= g_current_runtime_level ) THEN
2721: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2722: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2723: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2724: 'gt_historical_flag :' ||gt_historical_flag(i));
2725: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 2723: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

2719:
2720: IF (g_level_procedure >= g_current_runtime_level ) THEN
2721: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2722: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2723: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2724: 'gt_historical_flag :' ||gt_historical_flag(i));
2725: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2726: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

Line 2725: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

2721: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.BEGIN',
2722: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(+)');
2723: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2724: 'gt_historical_flag :' ||gt_historical_flag(i));
2725: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2726: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2728: 'GT_BILLING_TP_SITE_ID :' ||to_char(GT_BILLING_TP_SITE_ID(i)));
2729: END IF;

Line 2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',

2723: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2724: 'gt_historical_flag :' ||gt_historical_flag(i));
2725: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2726: 'GT_BILL_TO_PARTY_TAX_PROF_ID :' ||to_char(GT_BILL_TO_PARTY_TAX_PROF_ID(i)));
2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2728: 'GT_BILLING_TP_SITE_ID :' ||to_char(GT_BILLING_TP_SITE_ID(i)));
2729: END IF;
2730:
2731: IF GT_BILL_TO_PARTY_TAX_PROF_ID(i) IS NOT NULL THEN

Line 2748: FND_LOG.STRING(g_level_procedure,

2744: --l_bill_to_party_id := GT_BILLING_TP_ID(i);
2745: l_bill_to_party_id := GT_BILL_TO_PARTY_ID(i);
2746: END IF;
2747: IF (g_level_procedure >= g_current_runtime_level ) THEN
2748: FND_LOG.STRING(g_level_procedure,
2749: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2750: 'party_id_cur : l_bill_to_party_id '||to_char(l_bill_to_party_id));
2751: END IF;
2752:

Line 2770: FND_LOG.STRING(g_level_procedure,

2766: l_bill_to_site_id := GT_BILL_TO_PARTY_SITE_ID(i);
2767: END IF;
2768:
2769: IF (g_level_procedure >= g_current_runtime_level ) THEN
2770: FND_LOG.STRING(g_level_procedure,
2771: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2772: 'party_site_id_cur : l_bill_to_site_id '||to_char(l_bill_to_site_id));
2773: END IF;
2774:

Line 2785: FND_LOG.STRING(g_level_procedure,

2781: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||to_char(l_bill_to_party_id)||
2782: l_bill_ship, 1,8192);
2783:
2784: IF (g_level_procedure >= g_current_runtime_level ) THEN
2785: FND_LOG.STRING(g_level_procedure,
2786: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2787: 'Before Open cust_acct_cur :'||to_char(l_bill_to_party_id)||'-'||to_char(l_bill_to_site_id));
2788: END IF;
2789:

Line 2811: FND_LOG.STRING(g_level_procedure,

2807: GT_BILLING_TP_SITE_NAME(i),
2808: GT_BILLING_TP_TAX_REG_NUM(i);
2809:
2810: IF (g_level_procedure >= g_current_runtime_level ) THEN
2811: FND_LOG.STRING(g_level_procedure,
2812: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2813: 'After fetch of cust_acct_cur'||GT_BILLING_TP_NUMBER(i)||'-'||GT_BILLING_TP_TAX_REG_NUM(i));
2814: END IF;
2815:

Line 2828: FND_LOG.STRING(g_level_procedure,

2824: CLOSE cust_acct_cur;
2825: END IF;
2826:
2827: IF (g_level_procedure >= g_current_runtime_level ) THEN
2828: FND_LOG.STRING(g_level_procedure,
2829: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2830: 'After assign to g_cust_bill_ar_tbl ');
2831: END IF;
2832:

Line 2863: FND_LOG.STRING(g_level_procedure,

2859:
2860:
2861:
2862: IF (g_level_procedure >= g_current_runtime_level ) THEN
2863: FND_LOG.STRING(g_level_procedure,
2864: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2865: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
2866: END IF;
2867: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||

Line 2910: FND_LOG.STRING(g_level_procedure,

2906:
2907:
2908:
2909: IF (g_level_procedure >= g_current_runtime_level ) THEN
2910: FND_LOG.STRING(g_level_procedure,
2911: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2912: 'After assign to g_site_bill_ar_tbl '||g_site_bill_ar_tbl(l_tbl_index_site).BILLING_TP_CITY);
2913: END IF;
2914: END IF;

Line 2936: FND_LOG.STRING(g_level_procedure,

2932: l_ship_to_party_id := GT_SHIP_TO_PARTY_ID(i);
2933: END IF;
2934:
2935: IF (g_level_procedure >= g_current_runtime_level ) THEN
2936: FND_LOG.STRING(g_level_procedure,
2937: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2938: 'party_id_cur : l_ship_to_party_id '||to_char(l_ship_to_party_id));
2939: END IF;
2940:

Line 2959: FND_LOG.STRING(g_level_procedure,

2955: l_ship_to_site_id := GT_SHIP_TO_PARTY_SITE_ID(i);
2956: END IF;
2957:
2958: IF (g_level_procedure >= g_current_runtime_level ) THEN
2959: FND_LOG.STRING(g_level_procedure,
2960: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2961: 'party_site_id_cur : l_ship_to_site_id '||to_char(l_ship_to_site_id));
2962: END IF;
2963:

Line 2987: FND_LOG.STRING(g_level_procedure,

2983: GT_SHIPPING_TP_SITE_NAME(i) := g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_SITE_NAME;
2984: GT_SHIPPING_TP_TAX_REG_NUM(i) := g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_TAX_REG_NUM;
2985:
2986: IF (g_level_procedure >= g_current_runtime_level ) THEN
2987: FND_LOG.STRING(g_level_procedure,
2988: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2989: 'Exists in the cache g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
2990: END IF;
2991:

Line 3014: FND_LOG.STRING(g_level_procedure,

3010:
3011: CLOSE cust_acct_cur;
3012: END IF;
3013: IF (g_level_procedure >= g_current_runtime_level ) THEN
3014: FND_LOG.STRING(g_level_procedure,
3015: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3016: 'After assign to g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
3017: END IF;
3018:

Line 3046: FND_LOG.STRING(g_level_procedure,

3042:
3043: CLOSE party_cur;
3044: END IF;
3045: IF (g_level_procedure >= g_current_runtime_level ) THEN
3046: FND_LOG.STRING(g_level_procedure,
3047: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3048: 'After assign to g_party_ship_ar_tbl '||g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME);
3049: END IF;
3050:

Line 3089: FND_LOG.STRING(g_level_procedure,

3085: g_site_ship_ar_tbl(l_tbl_index_site).SHIPPING_TP_POSTAL_CODE := GT_SHIPPING_TP_POSTAL_CODE(i);
3086: CLOSE party_site_cur;
3087: END IF;
3088: IF (g_level_procedure >= g_current_runtime_level ) THEN
3089: FND_LOG.STRING(g_level_procedure,
3090: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3091: 'After assign to g_site_ship_ar_tbl '||g_site_ship_ar_tbl(l_tbl_index_site).SHIPPING_TP_CITY);
3092: END IF;
3093:

Line 3098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.END',

3094: END IF;
3095:
3096:
3097: IF (g_level_procedure >= g_current_runtime_level ) THEN
3098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO.END',
3099: 'ZX_AR_POPULATE_PKG: EXTRACT_PARTY_INFO(-)');
3100: END IF;
3101:
3102: EXCEPTION

Line 3109: FND_LOG.STRING(g_level_unexpected,

3105: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3106: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3107: FND_MSG_PUB.Add;
3108: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3109: FND_LOG.STRING(g_level_unexpected,
3110: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3111: g_error_buffer);
3112: END IF;
3113:

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 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 3262: FND_LOG.STRING(g_level_unexpected,

3258: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:

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 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 3303: FND_LOG.STRING(g_level_unexpected,

3299: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:

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 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 3444: FND_LOG.STRING(g_level_unexpected,

3440: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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: