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.

[Home] [Help]

APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on FND_LOG

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

5: --Global Variables
6: -------------------------------------------------------------------------------
7:
8: g_current_runtime_level NUMBER;
9: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: -- Variables for processing
13:

Line 10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

6: -------------------------------------------------------------------------------
7:
8: g_current_runtime_level NUMBER;
9: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: -- Variables for processing
13:
14: l_start_date_max DATE;

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

7:
8: g_current_runtime_level NUMBER;
9: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: -- Variables for processing
13:
14: l_start_date_max DATE;
15: l_start_date_sec_max DATE;

Line 90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','JL_AR_UPDATE_CUST_SITE_TAX(+)');

86:
87:
88: BEGIN
89: IF g_level_statement >= g_current_runtime_level THEN
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','JL_AR_UPDATE_CUST_SITE_TAX(+)');
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
92: 'I/P - Taxpayer ID: '||P_TAXPAYER_ID
93: ||',Tax Type: '||P_TAX_TYPE
94: ||',Category: '||P_CATEG

Line 91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

87:
88: BEGIN
89: IF g_level_statement >= g_current_runtime_level THEN
90: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','JL_AR_UPDATE_CUST_SITE_TAX(+)');
91: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
92: 'I/P - Taxpayer ID: '||P_TAXPAYER_ID
93: ||',Tax Type: '||P_TAX_TYPE
94: ||',Category: '||P_CATEG
95: ||',Org ID: '||P_ORG_ID

Line 120: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

116: RAISE;
117: END;
118:
119: IF g_level_statement >= g_current_runtime_level THEN
120: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
121: 'Exists in Current Month: '||l_exist_in_tmp);
122: END IF;
123:
124: IF l_exist_in_tmp = 'Y' THEN

Line 196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

192: RAISE;
193: END;
194:
195: IF g_level_statement >= g_current_runtime_level THEN
196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
197: 'Max Start Date in All table: '||l_start_date_sec_max
198: ||',Max End Date in All table: '||l_end_date_sec_max
199: ||',Tax Payer ID Exists in Previous Month?: '||l_exist_in_all
200: ||',Tax Rate and Group Info is proper?: '||l_proper_tax_rate_code);

Line 271: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

267: RAISE_APPLICATION_ERROR(- 20999,'Failed when fetching the Default Tax Code - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
268: END;
269:
270: IF g_level_statement >= g_current_runtime_level THEN
271: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
272: 'Default Tax Code: '||l_def_tax_code);
273: END IF;
274:
275: l_def_tax_flag := 'Y';

Line 286: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

282: l_taxpayer_id := P_TAXPAYER_ID;
283: l_perception_group_num := SubStr(l_def_tax_code,(Length(P_TAX_TYPE)+5));
284:
285: IF g_level_statement >= g_current_runtime_level THEN
286: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
287: 'Perception Group Number: '||l_perception_group_num);
288: END IF;
289:
290: BEGIN

Line 347: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

343: EXCEPTION
344: WHEN OTHERS THEN
345: IF SQLCODE = 0 THEN
346: IF g_level_statement >= g_current_runtime_level THEN
347: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
348: 'Normal Completion Exception');
349: END IF;
350: ELSE
351: X_RETURN_STATUS := 'E';

Line 357: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

353: ||l_taxpayer_id||' - '||SQLCODE||'- ERROR - '||SQLERRM);
354: END IF;
355: END;
356: IF g_level_statement >= g_current_runtime_level THEN
357: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
358: 'Data Change Flag: '||l_data_change_flag);
359: END IF;
360: IF l_data_change_flag = 'Y' THEN
361: -- UPDATE THE TAX CODE AT SITE LEVEL.

Line 366: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

362: OPEN FIND_CT_FOR_TAXPAYER(l_taxpayer_id);
363: LOOP
364: FETCH FIND_CT_FOR_TAXPAYER INTO l_customer_id;
365: IF g_level_statement >= g_current_runtime_level THEN
366: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
367: 'Customer Account ID for given Taxpayer ID: '||l_customer_id);
368: END IF;
369: EXIT WHEN FIND_CT_FOR_TAXPAYER%NOTFOUND;
370:

Line 376: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

372: LOOP
373: FETCH GET_SITES_FOR_CT INTO l_site_use_id;
374: EXIT WHEN GET_SITES_FOR_CT%NOTFOUND;
375: IF g_level_statement >= g_current_runtime_level THEN
376: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
377: 'Updated Site Use Ids:'||l_site_use_id);
378: END IF;
379: -- UPDATE THE TAX CODE AT SITE LEVELS.
380: HZ_CUST_ACCOUNT_SITE_V2PUB.get_cust_site_use_rec (

Line 389: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data);
387:
388: IF g_level_statement >= g_current_runtime_level THEN
389: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
390: 'Return Status after getting the site use info:'||x_return_status);
391: END IF;
392: IF x_return_status = 'S' THEN
393: BEGIN

Line 396: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

392: IF x_return_status = 'S' THEN
393: BEGIN
394: l_cust_site_use_rec.tax_code := P_TAX_TYPE||'_GRP'||l_perception_group_num;
395: IF g_level_statement >= g_current_runtime_level THEN
396: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
397: 'Updating the Site with Tax Code: '||l_cust_site_use_rec.tax_code);
398: END IF;
399:
400: BEGIN

Line 410: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',

406: WHEN OTHERS THEN
407: l_obj_version := NULL;
408: END;
409: IF g_level_statement >= g_current_runtime_level THEN
410: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES',
411: 'Object Version for this Site: '||l_obj_version);
412: END IF;
413:
414: HZ_CUST_ACCOUNT_SITE_V2PUB.update_cust_site_use (

Line 439: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','JL_AR_UPDATE_CUST_SITE_TAX(-)');

435: CLOSE FIND_CT_FOR_TAXPAYER;
436: END IF;
437: -- COMMIT;
438: IF g_level_statement >= g_current_runtime_level THEN
439: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','JL_AR_UPDATE_CUST_SITE_TAX(-)');
440: END IF;
441: END JL_AR_UPDATE_CUST_SITE_TAX;
442:
443: PROCEDURE INITIALIZE IS

Line 446: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','Initialize(+)');

442:
443: PROCEDURE INITIALIZE IS
444: BEGIN
445: IF g_level_statement >= g_current_runtime_level THEN
446: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','Initialize(+)');
447: END IF;
448: l_start_date_max := NULL;
449: l_start_date_sec_max := NULL;
450: l_end_date_sec_max := NULL;

Line 460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','Initialize(-)');

456: l_exist_in_tmp := NULL;
457: l_data_change_flag := NULL;
458: l_def_tax_flag := NULL;
459: IF g_level_statement >= g_current_runtime_level THEN
460: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_APPLICABLE_TAXES','Initialize(-)');
461: END IF;
462: END INITIALIZE;
463:
464: END JL_ZZ_AR_UPLOAD_TAXES;