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_TCM_CONTROL_PKG dependencies on FND_LOG

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: zxccontrolb.pls 120.93 2011/11/08 07:02:20 ssohal ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_CONTROL_PKG.';

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_CONTROL_PKG.';
13: -- Logging Infra

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_CONTROL_PKG.';
13: -- Logging Infra
14:

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_CONTROL_PKG.';
13: -- Logging Infra
14:
15: C_TAX_REGIME_CODE_DUMMY CONSTANT VARCHAR2(30) := '@#$%^&';

Line 61: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

57:
58:
59: -- Logging Infra:
60: l_procedure_name CONSTANT VARCHAR2(30) := 'get_fiscal_classification';
61: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
62:
63: l_ptp_id NUMBER;
64:
65: -- Validate if Fiscal Type has been associated to regime

Line 277: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

273: AND rownum = 1;
274:
275: BEGIN
276: -- Logging Infra: Setting up runtime level
277: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
278:
279: -- Logging Infra: Procedure level
280: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
281: l_log_msg := l_procedure_name||'(+)';

Line 282: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

278:
279: -- Logging Infra: Procedure level
280: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
281: l_log_msg := l_procedure_name||'(+)';
282: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
283: END IF;
284:
285: -- Logging Infra: YK: 3/5: Break point
286: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 288: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

284:
285: -- Logging Infra: YK: 3/5: Break point
286: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
287: l_log_msg := 'B: p_fsc_rec.classification_category='|| p_fsc_rec.classification_category;
288: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
289: END IF;
290: --Bug fix 4774215 Case 1.Return Status must be initialized.
291: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
292: --End of Bug fix 4774215 Case 1.

Line 319: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

315:
316: -- Logging Infra: YK: 3/5: Statement level
317: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
318: l_log_msg := 'E: EXC: OTHERS: select fnd_product_installations: '|| SQLCODE||': '||SQLERRM;
319: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
320: END IF;
321: END;
322:
323: IF (nvl(l_status,'N') = 'N' or nvl(l_db_status,'N') = 'N') THEN

Line 340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

336: -- Logging Infra: YK: 3/5: Statement level: "E" means "E"rror
337: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
338: l_log_msg := 'E: SEL fnd_product_installations: inventory not enabled: l_status='|| l_status ||
339: ', l_db_status=' || l_db_status;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
341: END IF;
342:
343: --return;
344: RAISE FND_API.G_EXC_ERROR;

Line 353: FND_LOG.STRING(G_LEVEL_STATEMENT,

349:
350: -- Logging Infra: YK: 3/5: Break point
351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
352: l_log_msg := 'B: CUR: c_regime_assoc: fetched: l_reg_fsctype_flag=' || l_reg_fsctype_flag;
353: FND_LOG.STRING(G_LEVEL_STATEMENT,
354: G_MODULE_NAME || l_procedure_name,
355: l_log_msg);
356: END IF;
357:

Line 368: FND_LOG.STRING(G_LEVEL_STATEMENT,

364:
365: -- Logging Infra: YK: 3/5: Break point
366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
367: l_log_msg := 'B: CUR: c_parent_regime_assoc: fetched: l_reg_fsctype_flag=' || l_reg_fsctype_flag;
368: FND_LOG.STRING(G_LEVEL_STATEMENT,
369: G_MODULE_NAME || l_procedure_name,
370: l_log_msg);
371: END IF;
372:

Line 380: FND_LOG.STRING(G_LEVEL_STATEMENT,

376: CLOSE c_parent_regime_assoc;
377:
378: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
379: l_log_msg := 'Regime for the given Fiscal Type is not valid ';
380: FND_LOG.STRING(G_LEVEL_STATEMENT,
381: G_MODULE_NAME || l_procedure_name,
382: l_log_msg);
383: END IF;
384: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 398: FND_LOG.STRING(G_LEVEL_STATEMENT,

394:
395: -- Logging Infra: YK: 3/5: Break point l_category_set_id
396: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
397: l_log_msg := 'B: CUR: c_inventory_set: fetched: l_category_set_id='||l_category_set_id;
398: FND_LOG.STRING(G_LEVEL_STATEMENT,
399: G_MODULE_NAME || l_procedure_name,
400: l_log_msg);
401: END IF;
402:

Line 412: FND_LOG.STRING(G_LEVEL_STATEMENT,

408: CLOSE c_inventory_set;
409: --return;
410: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
411: l_log_msg :='Fiscal Type Code does not exits';
412: FND_LOG.STRING(G_LEVEL_STATEMENT,
413: G_MODULE_NAME || l_procedure_name,
414: l_log_msg);
415: END IF;
416: RETURN;

Line 430: FND_LOG.STRING(G_LEVEL_STATEMENT,

426:
427: -- Logging Infra: YK: 3/5: Error l_category_set_id is null
428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
429: l_log_msg := 'E: l_category_set_id is null: classification_type_code='|| p_fsc_rec.classification_type;
430: FND_LOG.STRING(G_LEVEL_STATEMENT,
431: G_MODULE_NAME || l_procedure_name,
432: l_log_msg);
433: END IF;
434: RETURN;

Line 450: FND_LOG.STRING(G_LEVEL_STATEMENT,

446:
447: -- Logging Infra: YK: 3/5: c_inventory_structure notfound
448: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
449: l_log_msg := 'E: CUR: c_inventory_structure: notfound: category_set_id='|| l_category_set_id;
450: FND_LOG.STRING(G_LEVEL_STATEMENT,
451: G_MODULE_NAME || l_procedure_name,
452: l_log_msg);
453: END IF;
454: RETURN;

Line 469: FND_LOG.STRING(G_LEVEL_STATEMENT,

465:
466: -- Logging Infra: YK: 3/5: Break point l_category_id
467: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
468: l_log_msg := 'B: CUR: c_category: fetched: l_category_id=' || l_category_id;
469: FND_LOG.STRING(G_LEVEL_STATEMENT,
470: G_MODULE_NAME || l_procedure_name,
471: l_log_msg);
472: END IF;
473:

Line 482: FND_LOG.STRING(G_LEVEL_STATEMENT,

478: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
479: CLOSE c_category;
480: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
481: l_log_msg := 'S: CUR: c_category: notfound';
482: FND_LOG.STRING(G_LEVEL_STATEMENT,
483: G_MODULE_NAME || l_procedure_name,
484: l_log_msg);
485: END IF;
486: RETURN;

Line 510: FND_LOG.STRING(G_LEVEL_STATEMENT,

506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: l_log_msg := 'S: CUR: c_item_category: notfound: category_set_id='|| l_category_set_id ||
508: ', category_id='|| l_category_id ||
509: ', organization_id='|| p_fsc_rec.item_org_id;
510: FND_LOG.STRING(G_LEVEL_STATEMENT,
511: G_MODULE_NAME || l_procedure_name,
512: l_log_msg);
513: END IF;
514: RETURN;

Line 523: FND_LOG.STRING(G_LEVEL_STATEMENT,

519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
520: l_log_msg := 'S: CUR: c_item_category: found: category_set_id='|| l_category_set_id ||
521: ', category_id='|| l_category_id ||
522: ', organization_id='|| p_fsc_rec.item_org_id;
523: FND_LOG.STRING(G_LEVEL_STATEMENT,
524: G_MODULE_NAME || l_procedure_name,
525: l_log_msg);
526: END IF;
527: END IF; -- parent query

Line 532: FND_LOG.STRING(G_LEVEL_STATEMENT,

528: ELSE
529: -- Logging Infra: YK: 3/5: Break point l_category_id
530: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
531: l_log_msg := 'B: CUR: c_item_category: fetched: l_allocated_flag=' || l_allocated_flag;
532: FND_LOG.STRING(G_LEVEL_STATEMENT,
533: G_MODULE_NAME || l_procedure_name,
534: l_log_msg);
535: END IF;
536: --p_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 544: FND_LOG.STRING(G_LEVEL_STATEMENT,

540: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
541: l_log_msg := 'S: CUR: c_item_category: found: category_set_id='|| l_category_set_id ||
542: ', category_id='|| l_category_id ||
543: ', organization_id='|| p_fsc_rec.item_org_id;
544: FND_LOG.STRING(G_LEVEL_STATEMENT,
545: G_MODULE_NAME || l_procedure_name,
546: l_log_msg);
547: END IF;
548: END IF;

Line 569: FND_LOG.STRING(G_LEVEL_STATEMENT,

565:
566: -- Logging Infra: YK: 3/5: Break point
567: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
568: l_log_msg := 'B: CUR: c_regime_assoc: fetched: l_reg_fsctype_flag=' || l_reg_fsctype_flag;
569: FND_LOG.STRING(G_LEVEL_STATEMENT,
570: G_MODULE_NAME || l_procedure_name,
571: l_log_msg);
572: END IF;
573:

Line 584: FND_LOG.STRING(G_LEVEL_STATEMENT,

580: -- Logging Infra: YK: 3/5: Break point c_regime_assoc not found
581: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
582: l_log_msg := 'B: CUR: c_parent_regime_assoc: notfound: tax_regime=' || p_fsc_rec.tax_regime_code ||
583: ', classification_type='||p_fsc_rec.classification_type;
584: FND_LOG.STRING(G_LEVEL_STATEMENT,
585: G_MODULE_NAME || l_procedure_name,
586: l_log_msg);
587: END IF;
588:

Line 598: FND_LOG.STRING(G_LEVEL_STATEMENT,

594: close c_parent_regime_assoc;
595: --return;
596: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
597: l_log_msg :='B: CUR: c_parent_regime_assoc: notfound';
598: FND_LOG.STRING(G_LEVEL_STATEMENT,
599: G_MODULE_NAME || l_procedure_name,
600: l_log_msg);
601: END IF;
602: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 616: FND_LOG.STRING(G_LEVEL_STATEMENT,

612:
613: -- Logging Infra: YK: 3/3: Break point l_tca_class_category_code
614: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
615: l_log_msg := 'B: CUR: c_tca_class_category: fetched: l_tca_class_category_code=' || l_tca_class_category_code;
616: FND_LOG.STRING(G_LEVEL_STATEMENT,
617: G_MODULE_NAME || l_procedure_name,
618: l_log_msg);
619: END IF;
620:

Line 630: FND_LOG.STRING(G_LEVEL_STATEMENT,

626: close c_tca_class_category;
627: --return;
628: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
629: l_log_msg :='Fiscal Type Code does not exits';
630: FND_LOG.STRING(G_LEVEL_STATEMENT,
631: G_MODULE_NAME || l_procedure_name,
632: l_log_msg);
633: END IF;
634: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 649: FND_LOG.STRING(G_LEVEL_STATEMENT,

645: -- Logging Infra: YK: 3/5: Error l_tca_class_category_code is null
646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
647: l_log_msg := 'E: CUR: c_tca_class_category: l_tca_class_category_code is null: ' ||
648: 'classification_type_code='|| p_fsc_rec.classification_type;
649: FND_LOG.STRING(G_LEVEL_STATEMENT,
650: G_MODULE_NAME || l_procedure_name,
651: l_log_msg);
652: END IF;
653: return;

Line 677: FND_LOG.STRING(G_LEVEL_STATEMENT,

673: -- Logging Infra: YK: 3/5: Break point l_party_id, l_Party_Type_Code
674: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
675: l_log_msg := 'B: CUR: c_party_tax_profile_id: fetched: l_party_id=' || l_party_id ||
676: ', l_party_type_code='|| l_party_type_code;
677: FND_LOG.STRING(G_LEVEL_STATEMENT,
678: G_MODULE_NAME || l_procedure_name,
679: l_log_msg);
680: END IF;
681:

Line 702: FND_LOG.STRING(G_LEVEL_STATEMENT,

698:
699: -- Logging Infra: YK: 3/5: Break point l_class_code
700: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
701: l_log_msg := 'B: CUR: c_class_code: fetched: l_class_code=' || l_class_code;
702: FND_LOG.STRING(G_LEVEL_STATEMENT,
703: G_MODULE_NAME || l_procedure_name,
704: l_log_msg);
705: END IF;
706:

Line 733: FND_LOG.STRING(G_LEVEL_STATEMENT,

729: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
730: l_log_msg := 'B: CUR: c_party_category: fetched: l_allocated_flag_=' || l_allocated_flag ||
731: ', l_effective_from=' || l_effective_from ||
732: ', l_effective_to=' || l_effective_to;
733: FND_LOG.STRING(G_LEVEL_STATEMENT,
734: G_MODULE_NAME || l_procedure_name,
735: l_log_msg);
736: END IF;
737:

Line 749: FND_LOG.STRING(G_LEVEL_STATEMENT,

745: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
746: l_log_msg := 'B: CUR: c_party_category_multi_level: fetched: l_allocated_flag_=' || l_allocated_flag ||
747: ', l_effective_from=' || l_effective_from ||
748: ', l_effective_to=' || l_effective_to;
749: FND_LOG.STRING(G_LEVEL_STATEMENT,
750: G_MODULE_NAME || l_procedure_name,
751: l_log_msg);
752: END IF;
753:

Line 791: FND_LOG.STRING(G_LEVEL_STATEMENT,

787: ', class_code='|| l_class_code ||
788: ', owner_table_name=' || l_table_owner ||
789: ', owner_table_id=' || l_table_id ||
790: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
791: FND_LOG.STRING(G_LEVEL_STATEMENT,
792: G_MODULE_NAME || l_procedure_name,
793: l_log_msg);
794: END IF;
795: ELSE

Line 804: FND_LOG.STRING(G_LEVEL_STATEMENT,

800: ', class_code='|| l_class_code ||
801: ', owner_table_name=' || l_table_owner ||
802: ', owner_table_id=' || l_table_id ||
803: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
804: FND_LOG.STRING(G_LEVEL_STATEMENT,
805: G_MODULE_NAME || l_procedure_name,
806: l_log_msg);
807: END IF;
808: END IF;

Line 847: FND_LOG.STRING(G_LEVEL_STATEMENT,

843: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
844: l_log_msg := 'B: CUR: c_xle_activity_code: fetched: l_allocated_flag_=' || l_allocated_flag ||
845: ', l_effective_from=' || l_effective_from ||
846: ', l_effective_to=' || l_effective_to;
847: FND_LOG.STRING(G_LEVEL_STATEMENT,
848: G_MODULE_NAME || l_procedure_name,
849: l_log_msg);
850: END IF;
851:

Line 861: FND_LOG.STRING(G_LEVEL_STATEMENT,

857: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
858: l_log_msg := 'S: c_xle_activity_code: notfound: class_category=' || l_tca_class_category_code||
859: ', class_code='|| l_class_code ||
860: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
861: FND_LOG.STRING(G_LEVEL_STATEMENT,
862: G_MODULE_NAME || l_procedure_name,
863: l_log_msg);
864: END IF;
865:

Line 880: FND_LOG.STRING(G_LEVEL_STATEMENT,

876: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
877: l_log_msg := 'B: l_table_owner=' || l_table_owner ||
878: ', l_table_id=' || l_table_id ||
879: ', l_le_status=' || l_le_status;
880: FND_LOG.STRING(G_LEVEL_STATEMENT,
881: G_MODULE_NAME || l_procedure_name,
882: l_log_msg);
883: END IF;
884:

Line 898: FND_LOG.STRING(G_LEVEL_STATEMENT,

894: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
895: l_log_msg := 'B: CUR: c_party_category: fetched: l_allocated_flag=' || l_allocated_flag ||
896: ', l_effective_from=' || l_effective_from ||
897: ', l_effective_to=' || l_effective_to;
898: FND_LOG.STRING(G_LEVEL_STATEMENT,
899: G_MODULE_NAME || l_procedure_name,
900: l_log_msg);
901: END IF;
902:

Line 914: FND_LOG.STRING(G_LEVEL_STATEMENT,

910: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
911: l_log_msg := 'B: CUR: c_party_category_multi_level: fetched: l_allocated_flag_=' || l_allocated_flag ||
912: ', l_effective_from=' || l_effective_from ||
913: ', l_effective_to=' || l_effective_to;
914: FND_LOG.STRING(G_LEVEL_STATEMENT,
915: G_MODULE_NAME || l_procedure_name,
916: l_log_msg);
917: END IF;
918:

Line 966: FND_LOG.STRING(G_LEVEL_STATEMENT,

962: ', class_code='|| l_class_code ||
963: ', owner_table_name=' || l_table_owner ||
964: ', owner_table_id=' || l_table_id ||
965: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
966: FND_LOG.STRING(G_LEVEL_STATEMENT,
967: G_MODULE_NAME || l_procedure_name,
968: l_log_msg);
969: END IF;
970:

Line 986: FND_LOG.STRING(G_LEVEL_STATEMENT,

982: ', class_code='|| l_class_code ||
983: ', owner_table_name=' || l_table_owner ||
984: ', owner_table_id=' || l_table_id ||
985: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
986: FND_LOG.STRING(G_LEVEL_STATEMENT,
987: G_MODULE_NAME || l_procedure_name,
988: l_log_msg);
989: END IF;
990: ELSE

Line 1001: FND_LOG.STRING(G_LEVEL_STATEMENT,

997: ', class_code='|| l_class_code ||
998: ', owner_table_name=' || l_table_owner ||
999: ', owner_table_id=' || l_table_id ||
1000: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
1001: FND_LOG.STRING(G_LEVEL_STATEMENT,
1002: G_MODULE_NAME || l_procedure_name,
1003: l_log_msg);
1004: END IF;
1005: END IF;

Line 1026: FND_LOG.STRING(G_LEVEL_STATEMENT,

1022:
1023: -- Logging Infra: YK: 3/5: Break point: l_classification_type_code
1024: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1025: l_log_msg := 'B: CUR: c_classification_type_code: fetched: l_classification_type_code=' || l_classification_type_code;
1026: FND_LOG.STRING(G_LEVEL_STATEMENT,
1027: G_MODULE_NAME || l_procedure_name,
1028: l_log_msg);
1029: END IF;
1030:

Line 1038: FND_LOG.STRING(G_LEVEL_STATEMENT,

1034: close c_classification_type_code;
1035:
1036: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1037: l_log_msg := 'Fiscal Type Code does not exists';
1038: FND_LOG.STRING(G_LEVEL_STATEMENT,
1039: G_MODULE_NAME || l_procedure_name,
1040: l_log_msg);
1041: END IF;
1042: p_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1057: FND_LOG.STRING(G_LEVEL_STATEMENT,

1053:
1054: -- Logging Infra: YK: 3/5: Break point
1055: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1056: l_log_msg := 'B: CUR: c_regime_assoc: fetched: l_reg_fsctype_flag=' || l_reg_fsctype_flag;
1057: FND_LOG.STRING(G_LEVEL_STATEMENT,
1058: G_MODULE_NAME || l_procedure_name,
1059: l_log_msg);
1060: END IF;
1061:

Line 1070: FND_LOG.STRING(G_LEVEL_STATEMENT,

1066:
1067: -- Logging Infra: YK: 3/5: Break point
1068: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1069: l_log_msg := 'B: CUR: c_parent_regime_assoc: fetched: l_reg_fsctype_flag=' || l_reg_fsctype_flag;
1070: FND_LOG.STRING(G_LEVEL_STATEMENT,
1071: G_MODULE_NAME || l_procedure_name,
1072: l_log_msg);
1073: END IF;
1074:

Line 1082: FND_LOG.STRING(G_LEVEL_STATEMENT,

1078: --fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
1079: close c_parent_regime_assoc;
1080: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1081: l_log_msg := 'Regime for the given Fiscal Type is not valid ';
1082: FND_LOG.STRING(G_LEVEL_STATEMENT,
1083: G_MODULE_NAME || l_procedure_name,
1084: l_log_msg);
1085: END IF;
1086: p_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1103: FND_LOG.STRING(G_LEVEL_STATEMENT,

1099: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1100: l_log_msg := 'B: CUR: c_trxbizcat_fiscalclass: fetched: l_allocated_flag=' || l_allocated_flag ||
1101: ', l_effective_from=' || l_effective_from ||
1102: ', l_effective_to=' || l_effective_to;
1103: FND_LOG.STRING(G_LEVEL_STATEMENT,
1104: G_MODULE_NAME || l_procedure_name,
1105: l_log_msg);
1106: END IF;
1107:

Line 1119: FND_LOG.STRING(G_LEVEL_STATEMENT,

1115: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1116: l_log_msg := 'B: CUR: c_parent_trxbizcat_fiscalclass: fetched: l_allocated_flag=' || l_allocated_flag ||
1117: ', l_effective_from=' || l_effective_from ||
1118: ', l_effective_to=' || l_effective_to;
1119: FND_LOG.STRING(G_LEVEL_STATEMENT,
1120: G_MODULE_NAME || l_procedure_name,
1121: l_log_msg);
1122: END IF;
1123:

Line 1150: FND_LOG.STRING(G_LEVEL_STATEMENT,

1146:
1147: -- Logging Infra: YK: 3/5:
1148: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1149: l_log_msg := 'E: unspported category: p_fsc_rec.classification_category=' || p_fsc_rec.classification_category;
1150: FND_LOG.STRING(G_LEVEL_STATEMENT,
1151: G_MODULE_NAME || l_procedure_name,
1152: l_log_msg);
1153: END IF;
1154:

Line 1164: FND_LOG.STRING(G_LEVEL_STATEMENT,

1160: l_log_msg := 'R: p_fsc_rec.effective_from=' ||l_effective_from ||
1161: ', p_fsc_rec.effective_to=' ||l_effective_to ||
1162: ', p_fsc_rec.fsc_code=' || p_fsc_rec.condition_value;
1163: l_log_msg := l_log_msg || 'get_fiscal_classification(-)';
1164: FND_LOG.STRING(G_LEVEL_STATEMENT,
1165: G_MODULE_NAME || l_procedure_name,
1166: l_log_msg);
1167: END IF;
1168:

Line 1192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

1188: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1189:
1190: -- Logging Infra: YK: 3/5:
1191: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1193: END IF;
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1214: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

1210: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1211:
1212: -- Logging Infra: YK: 3/5:
1213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1215: END IF;
1216:
1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1218: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

1252: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1253:
1254: -- Logging Infra: YK: 3/5:
1255: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1257: END IF;
1258:
1259: END GET_FISCAL_CLASSIFICATION;
1260:

Line 1303: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1299: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1300:
1301: -- Logging Infra
1302: l_procedure_name CONSTANT VARCHAR2(30) := 'get_prod_trx_cate_value';
1303: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1304:
1305: BEGIN
1306: -- Logging Infra: 3/5: YK: Setting up runtime level
1307: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1307: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1303: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1304:
1305: BEGIN
1306: -- Logging Infra: 3/5: YK: Setting up runtime level
1307: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1308:
1309: -- Logging Infra: Procedure level
1310: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1311: l_log_msg := l_procedure_name||'(+)';

Line 1312: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1308:
1309: -- Logging Infra: Procedure level
1310: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1311: l_log_msg := l_procedure_name||'(+)';
1312: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1313: END IF;
1314:
1315: -- arp_util_tax.debug('in GET_PROD_TRX_CATE_VALUE');
1316: -- need to hard code return value here

Line 1329: FND_LOG.STRING(G_LEVEL_STATEMENT,

1325:
1326: -- Logging Infra: YK: 3/5: Break point
1327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1328: l_log_msg := 'B: CUR: c_delimiter: fetched: l_delimiter=' || l_delimiter;
1329: FND_LOG.STRING(G_LEVEL_STATEMENT,
1330: G_MODULE_NAME || l_procedure_name,
1331: l_log_msg);
1332: END IF;
1333:

Line 1345: FND_LOG.STRING(G_LEVEL_STATEMENT,

1341: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1342: l_log_msg := 'E: CUR: c_delimiter: notfound: Classification_Type_Categ_Code='
1343: || p_fsc_cat_rec.classification_category ||
1344: ', classification_type_code=' || p_fsc_cat_rec.classification_type;
1345: FND_LOG.STRING(G_LEVEL_STATEMENT,
1346: G_MODULE_NAME || l_procedure_name,
1347: l_log_msg);
1348: END IF;
1349: --return;

Line 1379: FND_LOG.STRING(G_LEVEL_STATEMENT,

1375: ', l_segment2=' || l_segment2 ||
1376: ', l_segment3=' || l_segment3 ||
1377: ', l_segment4=' || l_segment4 ||
1378: ', l_segment5=' || l_segment5;
1379: FND_LOG.STRING(G_LEVEL_STATEMENT,
1380: G_MODULE_NAME || l_procedure_name,
1381: l_log_msg);
1382: END IF;
1383:

Line 1398: FND_LOG.STRING(G_LEVEL_STATEMENT,

1394: || p_fsc_cat_rec.classification_category ||
1395: ', classification_type_code=' || p_fsc_cat_rec.classification_type ||
1396: ', concat_classif_code=' || p_fsc_cat_rec.parameter_value ||
1397: ', p_fsc_cat_rec.tax_determine_date=' || p_fsc_cat_rec.tax_determine_date;
1398: FND_LOG.STRING(G_LEVEL_STATEMENT,
1399: G_MODULE_NAME || l_procedure_name,
1400: l_log_msg);
1401: END IF;
1402: --return;

Line 1435: FND_LOG.STRING(G_LEVEL_STATEMENT,

1431: l_log_msg := 'B: p_fsc_cat_rec.condition_subclass=' || p_fsc_cat_rec.condition_subclass ||
1432: ', p_fsc_cat_rec.condition_value=' || p_fsc_cat_rec.condition_value ||
1433: ', p_fsc_cat_rec.effective_from=' || p_fsc_cat_rec.effective_from ||
1434: ', p_fsc_cat_rec.effective_to=' || p_fsc_cat_rec.effective_to;
1435: FND_LOG.STRING(G_LEVEL_STATEMENT,
1436: G_MODULE_NAME || l_procedure_name,
1437: l_log_msg);
1438: END IF;
1439:

Line 1460: FND_LOG.STRING(G_LEVEL_STATEMENT,

1456: -- Logging Infra: YK: 3/5:
1457: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1458: l_log_msg := 'E: unspported category: p_fsc_cat_rec.classification_category= '
1459: || p_fsc_cat_rec.classification_category;
1460: FND_LOG.STRING(G_LEVEL_STATEMENT,
1461: G_MODULE_NAME || l_procedure_name,
1462: l_log_msg);
1463: END IF;
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1473: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1469: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1470: l_log_msg := 'E: unspported category: p_fsc_cat_rec.classification_category= '
1471: || p_fsc_cat_rec.classification_category;
1472: l_log_msg := l_log_msg || ' get_prod_trx_cate_value(-)';
1473: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1474: G_MODULE_NAME || l_procedure_name, l_log_msg);
1475: END IF;
1476: EXCEPTION
1477: WHEN INVALID_CURSOR THEN

Line 1487: FND_LOG.STRING(G_LEVEL_STATEMENT,

1483: if c_delimiter%isopen then close c_delimiter; end if;
1484:
1485: -- Logging Infra: YK: 3/5:
1486: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1487: FND_LOG.STRING(G_LEVEL_STATEMENT,
1488: G_MODULE_NAME || l_procedure_name,
1489: SQLCODE || ': ' || SQLERRM);
1490: END IF;
1491:

Line 1502: FND_LOG.STRING(G_LEVEL_STATEMENT,

1498: if c_delimiter%isopen then close c_delimiter; end if;
1499:
1500: -- Logging Infra: YK: 3/5:
1501: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1502: FND_LOG.STRING(G_LEVEL_STATEMENT,
1503: G_MODULE_NAME || l_procedure_name,
1504: SQLCODE || ': ' || SQLERRM);
1505: END IF;
1506:

Line 1526: FND_LOG.STRING(G_LEVEL_STATEMENT,

1522: if c_delimiter%isopen then close c_delimiter; end if;
1523:
1524: -- Logging Infra: YK: 3/5:
1525: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1526: FND_LOG.STRING(G_LEVEL_STATEMENT,
1527: G_MODULE_NAME || l_procedure_name,
1528: SQLCODE || ': ' || SQLERRM);
1529: END IF;
1530:

Line 1648: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1644: l_ptp_type_code zx_party_tax_profile.party_type_code%type;
1645:
1646: -- Logging Infra
1647: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Tax';
1648: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1649:
1650: -----------------------------------------------------------------
1651: -- Get the Tax Registration Information
1652: -- Tax Registration should be valid on the Tax Determination Date

Line 1761: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1757:
1758: BEGIN
1759:
1760: -- Logging Infra: Setting up runtime level
1761: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1762:
1763: -- Initialize return status
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:

Line 1768: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1767: l_log_msg := l_procedure_name||'(+)';
1768: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1769: END IF;
1770:
1771:
1772: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1779: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1775: l_log_msg := l_log_msg||' p_tax_regime_code: '||p_tax_regime_code;
1776: l_log_msg := l_log_msg||' p_tax: '||p_tax;
1777: l_log_msg := l_log_msg||' p_jurisdiction_code: '||p_jurisdiction_code;
1778: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
1779: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1780: END IF;
1781:
1782: l_tax_regime_code := nvl(p_tax_regime_code, c_tax_regime_code_dummy);
1783: l_tax := nvl(p_tax, c_tax_dummy);

Line 1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'l_index = '||l_index);

1785:
1786: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||l_tax_regime_code||l_tax||l_jurisdiction_code,1,8192);
1787:
1788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'l_index = '||l_index);
1790: END IF;
1791:
1792: IF ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl.exists(l_index)
1793: AND ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index).party_tax_profile_id = p_ptp_id THEN -- found in cache

Line 1796: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Record found in cache for l_index = '||l_index||

1792: IF ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl.exists(l_index)
1793: AND ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index).party_tax_profile_id = p_ptp_id THEN -- found in cache
1794:
1795: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1796: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Record found in cache for l_index = '||l_index||
1797: ' Dummy_flag = '||ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index).dummy_flag);
1798: END IF;
1799:
1800: IF ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index).dummy_flag = 'Y' then

Line 1806: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1802: p_getone:=0;
1803:
1804: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1805: l_log_msg := 'The same combination already searched previously with an unsuccessful hit' ;
1806: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1807: END IF;
1808:
1809: ELSE
1810:

Line 1843: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Record NOT found in cache for l_index = '||l_index);

1839:
1840: ELSE -- not found in cache
1841:
1842: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1843: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Record NOT found in cache for l_index = '||l_index);
1844: END IF;
1845:
1846: p_getone := 0;
1847: -- If the parameters 'Tax' and 'Jurisdiction' are null, and 'Regime' is not null then look for Regime evel.

Line 1894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Creating a dummy Record for l_index = '||l_index);

1890: -- Bug#5520167- set flag to upper case Y
1891: DUMMY_REGISTRATION_REC.DUMMY_FLAG := 'Y';
1892:
1893: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Creating a dummy Record for l_index = '||l_index);
1895: END IF;
1896:
1897:
1898: -- This assignment statement is to mark that we already searched the database for

Line 1925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1921: l_log_msg := l_log_msg||' tax_regime_code: '||nvl(x_get_registration_rec.tax_regime_code,c_tax_regime_code_dummy);
1922: l_log_msg := l_log_msg||' p_tax: '||nvl(x_get_registration_rec.tax,c_tax_dummy);
1923: l_log_msg := l_log_msg||' p_jurisdiction_code: '||nvl(x_get_registration_rec.tax_jurisdiction_code,c_jurisdiction_code_dummy);
1924: l_log_msg := l_log_msg||' l_index: '||to_char(l_index);
1925: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1926: END IF;
1927:
1928:
1929: END IF; -- Got registrations

Line 1936: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

1932: END IF; -- found in cache
1933:
1934: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1935: l_log_msg := l_procedure_name||'(-)';
1936: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1937: END IF;
1938: -- Fails
1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN

Line 1950: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

1946:
1947: -- Logging Infra: Statement level
1948: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1949: l_log_msg := 'Error Message: '||SQLERRM;
1950: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1951: END IF;
1952: -- Logging Infra: Statement level
1953: END Do_Get_Registration_Tax;
1954:

Line 1989: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1985: l_inclusive_tax_flag ap_supplier_sites_all.amount_includes_tax_flag%TYPE;
1986:
1987: -- Logging Infra
1988: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Sup_Site';
1989: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1990:
1991: -----------------------------------------------------------------
1992: -- Get the Tax Registration Information
1993: -- Tax Registration should be valid on the Tax Determination Date

Line 2017: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2013:
2014: BEGIN
2015:
2016: -- Logging Infra: Setting up runtime level
2017: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2018:
2019: -- Initialize return status
2020: x_return_status := FND_API.G_RET_STS_SUCCESS;
2021:

Line 2025: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

2021:
2022: -- Logging Infra: Procedure level
2023: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2024: l_log_msg := l_procedure_name||'(+)';
2025: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2026: END IF;
2027:
2028: -- Logging Infra: Statement level
2029: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2034: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2030: l_log_msg := 'Parameters ';
2031: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2032: l_log_msg := l_log_msg||' p_account_site_id: '||p_account_site_id;
2033: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
2034: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2035: END IF;
2036: -- Logging Infra: Statement level
2037:
2038: IF ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl.exists(p_account_site_id) THEN

Line 2041: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,

2037:
2038: IF ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl.exists(p_account_site_id) THEN
2039:
2040: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2041: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
2042: 'Vendor site record found in cache for vendor site id:'||to_char(p_account_site_id));
2043: END IF;
2044:
2045: l_supp_site_info_rec := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id);

Line 2091: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,

2087: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).AMOUNT_INCLUDES_TAX_FLAG :=
2088: l_inclusive_tax_flag;
2089:
2090: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
2092: 'AUTO_TAX_CALC_FLAG = '||
2093: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).AUTO_TAX_CALC_FLAG||
2094: ', AMOUNT_INCLUDES_TAX_FLAG = '||
2095: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).AMOUNT_INCLUDES_TAX_FLAG);

Line 2104: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

2100: CLOSE c_supplier_ptp;
2101: -- Logging Infra: Procedure level
2102: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2103: l_log_msg := l_procedure_name||'(-)';
2104: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2105: END IF;
2106: -- Fails
2107: END IF;
2108: EXCEPTION

Line 2119: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2115:
2116: -- Logging Infra: Statement level
2117: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2118: l_log_msg := 'Error Message: '||SQLERRM;
2119: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2120: END IF;
2121: -- Logging Infra: Statement level
2122: END Do_Get_Sup_Site;
2123:

Line 2150: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2146: l_ptp_type_code VARCHAR2(30);
2147:
2148: -- Logging Infra
2149: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Reg_Site_Uses';
2150: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2151:
2152: -----------------------------------------------------------------
2153: -- Get the Tax Registration Information
2154: -- Tax Registration should be valid on the Tax Determination Date

Line 2176: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2172:
2173: BEGIN
2174:
2175: -- Logging Infra: Setting up runtime level
2176: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2177:
2178: -- Initialize return status
2179: x_return_status := FND_API.G_RET_STS_SUCCESS;
2180:

Line 2184: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

2180:
2181: -- Logging Infra: Procedure level
2182: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2183: l_log_msg := l_procedure_name||'(+)';
2184: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2185: END IF;
2186:
2187: -- Logging Infra: Statement level
2188: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2194: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2190: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2191: l_log_msg := l_log_msg||' p_account_site_id: '||p_account_site_id;
2192: l_log_msg := l_log_msg||' p_site_use_id: '||p_site_use_id;
2193: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
2194: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2195: END IF;
2196: -- Logging Infra: Statement level
2197: p_getone := 0;
2198:

Line 2216: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Site Use information found in cache');

2212:
2213: p_getone:=1;
2214:
2215: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2216: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Site Use information found in cache');
2217: END IF;
2218: ELSE
2219: For my_reg IN c_site_uses Loop
2220: -- Got registration

Line 2248: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

2244:
2245: -- Logging Infra: Procedure level
2246: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2247: l_log_msg := l_procedure_name||'(-)';
2248: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2249: END IF;
2250: -- Fails
2251: EXCEPTION
2252: WHEN NO_DATA_FOUND THEN

Line 2262: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2258:
2259: -- Logging Infra: Statement level
2260: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2261: l_log_msg := 'Error Message: '||SQLERRM;
2262: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2263: END IF;
2264: -- Logging Infra: Statement level
2265: END Do_Get_Reg_Site_Uses;
2266:

Line 2290: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2286: l_ptp_type_code VARCHAR2(30);
2287:
2288: -- Logging Infra
2289: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Accts';
2290: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2291: -----------------------------------------------------------------
2292: -- Get the Tax Registration Information
2293: -- Tax Registration should be valid on the Tax Determination Date
2294: -----------------------------------------------------------------

Line 2308: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2304:
2305: BEGIN
2306:
2307: -- Logging Infra: Setting up runtime level
2308: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2309:
2310: -- Initialize return status
2311: x_return_status := FND_API.G_RET_STS_SUCCESS;
2312:

Line 2316: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

2312:
2313: -- Logging Infra: Procedure level
2314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2315: l_log_msg := l_procedure_name||'(+)';
2316: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2317: END IF;
2318:
2319: -- Logging Infra: Statement level
2320: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2325: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2321: l_log_msg := 'Parameters ';
2322: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2323: l_log_msg := l_log_msg||' p_account_id: '||p_account_id;
2324: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
2325: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2326: END IF;
2327: -- Logging Infra: Statement level
2328: p_getone := 0;
2329:

Line 2338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Cust Account information found in cache');

2334: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag;
2335: x_get_registration_rec.tax_classification_code :=
2336: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_code;
2337: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Cust Account information found in cache');
2339: END IF;
2340: ELSE
2341: For my_reg IN c_customer_account Loop
2342: -- Got registration

Line 2361: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

2357:
2358: -- Logging Infra: Procedure level
2359: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2360: l_log_msg := l_procedure_name||'(-)';
2361: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2362: END IF;
2363: -- Fails
2364: EXCEPTION
2365: WHEN NO_DATA_FOUND THEN

Line 2375: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2371:
2372: -- Logging Infra: Statement level
2373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2374: l_log_msg := 'Error Message: '||SQLERRM;
2375: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2376: END IF;
2377: -- Logging Infra: Statement level
2378: END Do_Get_Registration_Accts;
2379:

Line 2399: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2395: l_tbl_index BINARY_INTEGER;
2396:
2397: -- Logging Infra
2398: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Party';
2399: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2400:
2401:
2402: BEGIN
2403:

Line 2405: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2401:
2402: BEGIN
2403:
2404: -- Logging Infra: Setting up runtime level
2405: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2406:
2407: -- Initialize return status
2408: x_return_status := FND_API.G_RET_STS_SUCCESS;
2409:

Line 2413: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

2409:
2410: -- Logging Infra: Procedure level
2411: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2412: l_log_msg := l_procedure_name||'(+)';
2413: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2414: END IF;
2415:
2416: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2417: l_log_msg := 'Parameters ';

Line 2420: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2416: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2417: l_log_msg := 'Parameters ';
2418: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2419: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
2420: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2421: END IF;
2422:
2423: p_getone := 0;
2424:

Line 2465: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2462:
2463: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2464: l_log_msg := 'Party Tax Profile Id is not valid: '||p_party_tax_profile_id;
2465: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2466: END IF;
2467:
2468: END IF;
2469:

Line 2473: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);

2469:
2470: -- Logging Infra: Procedure level
2471: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2472: l_log_msg := l_procedure_name||'(-)';
2473: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2474: END IF;
2475: -- Fails
2476: EXCEPTION
2477: WHEN NO_DATA_FOUND THEN

Line 2487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2483:
2484: -- Logging Infra: Statement level
2485: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2486: l_log_msg := 'Error Message: '||SQLERRM;
2487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2488: END IF;
2489: -- Logging Infra: Statement level
2490: END Do_Get_Registration_Party;
2491:

Line 2529: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2525: l_ptp_type_code VARCHAR2(30);
2526:
2527: -- Logging Infra
2528: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Tax_Registration';
2529: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2530:
2531: BEGIN
2532:
2533: -- Logging Infra: Setting up runtime level

Line 2534: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2530:
2531: BEGIN
2532:
2533: -- Logging Infra: Setting up runtime level
2534: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2535:
2536: -- Logging Infra: Procedure level
2537: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2538: l_log_msg := l_procedure_name||'(+)';

Line 2539: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

2535:
2536: -- Logging Infra: Procedure level
2537: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2538: l_log_msg := l_procedure_name||'(+)';
2539: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2540: END IF;
2541:
2542: -- Logging Infra: Statement level
2543: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2549: l_log_msg := l_log_msg||' p_tax_regime_code: '||p_tax_regime_code||', ';
2550: l_log_msg := l_log_msg||' p_jurisdiction_code: '||p_jurisdiction_code||', ';
2551: l_log_msg := l_log_msg||' p_account_site_id: '||to_char(p_account_site_id)||', ';
2552: l_log_msg := l_log_msg||' p_site_use_id: '||to_char(p_site_use_id)||', ';
2553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2554: END IF;
2555: -- Logging Infra: Statement level
2556:
2557: -- Initialize Return Status and Error Buffer

Line 2699: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

2695:
2696: -- Logging Infra: Procedure level
2697: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN -- if16
2698: l_log_msg := l_procedure_name||'Get Tax Registration did not find any record';
2699: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2700: END IF; --if16
2701: END IF; -- if15 getone
2702: END IF; -- if14 getone site level
2703: END IF; -- if13

Line 2710: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);

2706: END IF; --if1
2707: -- Logging Infra: Procedure level
2708: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2709: l_log_msg := l_procedure_name||'(-)';
2710: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);
2711: END IF;
2712:
2713: EXCEPTION
2714: WHEN NO_DATA_FOUND THEN

Line 2724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2720:
2721: -- Logging Infra: Statement level
2722: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2723: l_log_msg := 'Error Message: '||SQLERRM;
2724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2725: END IF;
2726: -- Logging Infra: Statement level
2727:
2728: END Get_Tax_Registration;

Line 2734: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2730:
2731: PROCEDURE INITIALIZE_LTE (p_return_status OUT NOCOPY VARCHAR2) IS
2732:
2733: l_procedure_name CONSTANT VARCHAR2(30) := 'Initialize LTE';
2734: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2735: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
2736: l_fc_id ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE;
2737:
2738: BEGIN

Line 2740: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2736: l_fc_id ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE;
2737:
2738: BEGIN
2739: -- Logging Infra: Setting up runtime level
2740: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2741:
2742: -- Initialize return status
2743: p_return_status := FND_API.G_RET_STS_SUCCESS;
2744:

Line 2748: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);

2744:
2745: -- Logging Infra: Procedure level
2746: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2747: l_log_msg := l_procedure_name||'(+)';
2748: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2749: END IF;
2750:
2751: -- Logging Infra: Statement level
2752: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2754: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2750:
2751: -- Logging Infra: Statement level
2752: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2753: l_log_msg := 'Parameters : None';
2754: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2755: END IF;
2756: -- Logging Infra: Statement level
2757:
2758: IF (zx_fc_migrate_pkg.Is_Country_Installed(7004, 'jlbrloc') or

Line 2830: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);

2826:
2827: -- Logging Infra: Procedure level
2828: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2829: l_log_msg := l_procedure_name||'(-)';
2830: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);
2831: END IF;
2832:
2833:
2834: EXCEPTION WHEN OTHERS THEN

Line 2842: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

2838:
2839: -- Logging Infra: Statement level
2840: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2841: l_log_msg := 'Error Message: '||SQLERRM;
2842: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2843: END IF;
2844: -- Logging Infra: Statement level
2845:
2846: END INITIALIZE_LTE;