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.82.12010000.2 2008/11/19 07:02:56 spasala 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 320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

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

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

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

Line 357: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 371: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 397: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 423: FND_LOG.STRING(G_LEVEL_STATEMENT,

419:
420: -- Logging Infra: YK: 3/5: Error l_category_set_id is null
421: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
422: l_log_msg := 'E: l_category_set_id is null: classification_type_code='|| p_fsc_rec.classification_type;
423: FND_LOG.STRING(G_LEVEL_STATEMENT,
424: G_MODULE_NAME || l_procedure_name,
425: l_log_msg);
426: END IF;
427: --return;

Line 444: FND_LOG.STRING(G_LEVEL_STATEMENT,

440:
441: -- Logging Infra: YK: 3/5: c_inventory_structure notfound
442: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
443: l_log_msg := 'E: CUR: c_inventory_structure: notfound: category_set_id='|| l_category_set_id;
444: FND_LOG.STRING(G_LEVEL_STATEMENT,
445: G_MODULE_NAME || l_procedure_name,
446: l_log_msg);
447: END IF;
448: --return;

Line 464: FND_LOG.STRING(G_LEVEL_STATEMENT,

460:
461: -- Logging Infra: YK: 3/5: Break point l_category_id
462: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
463: l_log_msg := 'B: CUR: c_category: fetched: l_category_id=' || l_category_id;
464: FND_LOG.STRING(G_LEVEL_STATEMENT,
465: G_MODULE_NAME || l_procedure_name,
466: l_log_msg);
467: END IF;
468:

Line 488: FND_LOG.STRING(G_LEVEL_STATEMENT,

484:
485: -- Logging Infra: YK: 3/5: Break point l_category_id
486: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
487: l_log_msg := 'B: CUR: c_item_category: fetched: l_allocated_flag=' || l_allocated_flag;
488: FND_LOG.STRING(G_LEVEL_STATEMENT,
489: G_MODULE_NAME || l_procedure_name,
490: l_log_msg);
491: END IF;
492:

Line 511: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 527: FND_LOG.STRING(G_LEVEL_STATEMENT,

523: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
524: l_log_msg := 'S: CUR: c_item_category: found: category_set_id='|| l_category_set_id ||
525: ', category_id='|| l_category_id ||
526: ', organization_id='|| p_fsc_rec.item_org_id;
527: FND_LOG.STRING(G_LEVEL_STATEMENT,
528: G_MODULE_NAME || l_procedure_name,
529: l_log_msg);
530: END IF;
531:

Line 545: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 571: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 586: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 611: FND_LOG.STRING(G_LEVEL_STATEMENT,

607:
608: -- Logging Infra: YK: 3/3: Break point l_tca_class_category_code
609: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
610: l_log_msg := 'B: CUR: c_tca_class_category: fetched: l_tca_class_category_code=' || l_tca_class_category_code;
611: FND_LOG.STRING(G_LEVEL_STATEMENT,
612: G_MODULE_NAME || l_procedure_name,
613: l_log_msg);
614: END IF;
615:

Line 638: FND_LOG.STRING(G_LEVEL_STATEMENT,

634: -- Logging Infra: YK: 3/5: Error l_tca_class_category_code is null
635: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
636: l_log_msg := 'E: CUR: c_tca_class_category: l_tca_class_category_code is null: ' ||
637: 'classification_type_code='|| p_fsc_rec.classification_type;
638: FND_LOG.STRING(G_LEVEL_STATEMENT,
639: G_MODULE_NAME || l_procedure_name,
640: l_log_msg);
641: END IF;
642: --return;

Line 666: FND_LOG.STRING(G_LEVEL_STATEMENT,

662: -- Logging Infra: YK: 3/5: Break point l_party_id, l_Party_Type_Code
663: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
664: l_log_msg := 'B: CUR: c_party_tax_profile_id: fetched: l_party_id=' || l_party_id ||
665: ', l_party_type_code='|| l_party_type_code;
666: FND_LOG.STRING(G_LEVEL_STATEMENT,
667: G_MODULE_NAME || l_procedure_name,
668: l_log_msg);
669: END IF;
670:

Line 691: FND_LOG.STRING(G_LEVEL_STATEMENT,

687:
688: -- Logging Infra: YK: 3/5: Break point l_class_code
689: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
690: l_log_msg := 'B: CUR: c_class_code: fetched: l_class_code=' || l_class_code;
691: FND_LOG.STRING(G_LEVEL_STATEMENT,
692: G_MODULE_NAME || l_procedure_name,
693: l_log_msg);
694: END IF;
695:

Line 721: FND_LOG.STRING(G_LEVEL_STATEMENT,

717: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
718: l_log_msg := 'B: CUR: c_party_category: fetched: l_allocated_flag_=' || l_allocated_flag ||
719: ', l_effective_from=' || l_effective_from ||
720: ', l_effective_to=' || l_effective_to;
721: FND_LOG.STRING(G_LEVEL_STATEMENT,
722: G_MODULE_NAME || l_procedure_name,
723: l_log_msg);
724: END IF;
725:

Line 737: FND_LOG.STRING(G_LEVEL_STATEMENT,

733: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
734: l_log_msg := 'B: CUR: c_party_category_multi_level: fetched: l_allocated_flag_=' || l_allocated_flag ||
735: ', l_effective_from=' || l_effective_from ||
736: ', l_effective_to=' || l_effective_to;
737: FND_LOG.STRING(G_LEVEL_STATEMENT,
738: G_MODULE_NAME || l_procedure_name,
739: l_log_msg);
740: END IF;
741:

Line 767: FND_LOG.STRING(G_LEVEL_STATEMENT,

763: ', class_code='|| l_class_code ||
764: ', owner_table_name=' || l_table_owner ||
765: ', owner_table_id=' || l_table_id ||
766: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
767: FND_LOG.STRING(G_LEVEL_STATEMENT,
768: G_MODULE_NAME || l_procedure_name,
769: l_log_msg);
770: END IF;
771: ELSE

Line 780: FND_LOG.STRING(G_LEVEL_STATEMENT,

776: ', class_code='|| l_class_code ||
777: ', owner_table_name=' || l_table_owner ||
778: ', owner_table_id=' || l_table_id ||
779: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
780: FND_LOG.STRING(G_LEVEL_STATEMENT,
781: G_MODULE_NAME || l_procedure_name,
782: l_log_msg);
783: END IF;
784: END IF;

Line 838: FND_LOG.STRING(G_LEVEL_STATEMENT,

834: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
835: l_log_msg := 'B: CUR: c_xle_activity_code: fetched: l_allocated_flag_=' || l_allocated_flag ||
836: ', l_effective_from=' || l_effective_from ||
837: ', l_effective_to=' || l_effective_to;
838: FND_LOG.STRING(G_LEVEL_STATEMENT,
839: G_MODULE_NAME || l_procedure_name,
840: l_log_msg);
841: END IF;
842:

Line 852: FND_LOG.STRING(G_LEVEL_STATEMENT,

848: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
849: l_log_msg := 'S: c_xle_activity_code: notfound: class_category=' || l_tca_class_category_code||
850: ', class_code='|| l_class_code ||
851: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
852: FND_LOG.STRING(G_LEVEL_STATEMENT,
853: G_MODULE_NAME || l_procedure_name,
854: l_log_msg);
855: END IF;
856:

Line 871: FND_LOG.STRING(G_LEVEL_STATEMENT,

867: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
868: l_log_msg := 'B: l_table_owner=' || l_table_owner ||
869: ', l_table_id=' || l_table_id ||
870: ', l_le_status=' || l_le_status;
871: FND_LOG.STRING(G_LEVEL_STATEMENT,
872: G_MODULE_NAME || l_procedure_name,
873: l_log_msg);
874: END IF;
875:

Line 888: FND_LOG.STRING(G_LEVEL_STATEMENT,

884: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
885: l_log_msg := 'B: CUR: c_party_category: fetched: l_allocated_flag=' || l_allocated_flag ||
886: ', l_effective_from=' || l_effective_from ||
887: ', l_effective_to=' || l_effective_to;
888: FND_LOG.STRING(G_LEVEL_STATEMENT,
889: G_MODULE_NAME || l_procedure_name,
890: l_log_msg);
891: END IF;
892:

Line 904: FND_LOG.STRING(G_LEVEL_STATEMENT,

900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
901: l_log_msg := 'B: CUR: c_party_category_multi_level: fetched: l_allocated_flag_=' || l_allocated_flag ||
902: ', l_effective_from=' || l_effective_from ||
903: ', l_effective_to=' || l_effective_to;
904: FND_LOG.STRING(G_LEVEL_STATEMENT,
905: G_MODULE_NAME || l_procedure_name,
906: l_log_msg);
907: END IF;
908:

Line 945: FND_LOG.STRING(G_LEVEL_STATEMENT,

941: ', class_code='|| l_class_code ||
942: ', owner_table_name=' || l_table_owner ||
943: ', owner_table_id=' || l_table_id ||
944: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
945: FND_LOG.STRING(G_LEVEL_STATEMENT,
946: G_MODULE_NAME || l_procedure_name,
947: l_log_msg);
948: END IF;
949:

Line 965: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 978: FND_LOG.STRING(G_LEVEL_STATEMENT,

974: ', class_code='|| l_class_code ||
975: ', owner_table_name=' || l_table_owner ||
976: ', owner_table_id=' || l_table_id ||
977: ', p_fsc_rec.tax_determine_date=' || p_fsc_rec.tax_determine_date;
978: FND_LOG.STRING(G_LEVEL_STATEMENT,
979: G_MODULE_NAME || l_procedure_name,
980: l_log_msg);
981: END IF;
982: END IF;

Line 1022: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 1046: FND_LOG.STRING(G_LEVEL_STATEMENT,

1042:
1043: -- Logging Infra: YK: 3/5: Break point
1044: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1045: l_log_msg := 'B: CUR: c_regime_assoc: fetched: l_reg_fsctype_flag=' || l_reg_fsctype_flag;
1046: FND_LOG.STRING(G_LEVEL_STATEMENT,
1047: G_MODULE_NAME || l_procedure_name,
1048: l_log_msg);
1049: END IF;
1050:

Line 1059: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 1086: FND_LOG.STRING(G_LEVEL_STATEMENT,

1082: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1083: l_log_msg := 'B: CUR: c_trxbizcat_fiscalclass: fetched: l_allocated_flag=' || l_allocated_flag ||
1084: ', l_effective_from=' || l_effective_from ||
1085: ', l_effective_to=' || l_effective_to;
1086: FND_LOG.STRING(G_LEVEL_STATEMENT,
1087: G_MODULE_NAME || l_procedure_name,
1088: l_log_msg);
1089: END IF;
1090:

Line 1102: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

Line 1135: FND_LOG.STRING(G_LEVEL_STATEMENT,

1131:
1132: -- Logging Infra: YK: 3/5:
1133: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1134: l_log_msg := 'E: unspported category: p_fsc_rec.classification_category=' || p_fsc_rec.classification_category;
1135: FND_LOG.STRING(G_LEVEL_STATEMENT,
1136: G_MODULE_NAME || l_procedure_name,
1137: l_log_msg);
1138: END IF;
1139:

Line 1149: FND_LOG.STRING(G_LEVEL_STATEMENT,

1145: l_log_msg := 'R: p_fsc_rec.effective_from=' ||l_effective_from ||
1146: ', p_fsc_rec.effective_to=' ||l_effective_to ||
1147: ', p_fsc_rec.fsc_code=' || p_fsc_rec.condition_value;
1148: l_log_msg := l_log_msg || 'get_fiscal_classification(-)';
1149: FND_LOG.STRING(G_LEVEL_STATEMENT,
1150: G_MODULE_NAME || l_procedure_name,
1151: l_log_msg);
1152: END IF;
1153:

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

1173: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1174:
1175: -- Logging Infra: YK: 3/5:
1176: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1178: END IF;
1179:
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: p_return_status := FND_API.G_RET_STS_ERROR;

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

1195: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1196:
1197: -- Logging Infra: YK: 3/5:
1198: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1199: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1200: END IF;
1201:
1202:
1203: WHEN OTHERS THEN

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

1221: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1222:
1223: -- Logging Infra: YK: 3/5:
1224: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1226: END IF;
1227:
1228: END GET_FISCAL_CLASSIFICATION;
1229:

Line 1272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1268: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1269:
1270: -- Logging Infra
1271: l_procedure_name CONSTANT VARCHAR2(30) := 'get_prod_trx_cate_value';
1272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1273:
1274: BEGIN
1275: -- Logging Infra: 3/5: YK: Setting up runtime level
1276: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1276: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1273:
1274: BEGIN
1275: -- Logging Infra: 3/5: YK: Setting up runtime level
1276: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1277:
1278: -- Logging Infra: Procedure level
1279: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1280: l_log_msg := l_procedure_name||'(+)';

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

1277:
1278: -- Logging Infra: Procedure level
1279: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1280: l_log_msg := l_procedure_name||'(+)';
1281: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1282: END IF;
1283:
1284: -- arp_util_tax.debug('in GET_PROD_TRX_CATE_VALUE');
1285: -- need to hard code return value here

Line 1298: FND_LOG.STRING(G_LEVEL_STATEMENT,

1294:
1295: -- Logging Infra: YK: 3/5: Break point
1296: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1297: l_log_msg := 'B: CUR: c_delimiter: fetched: l_delimiter=' || l_delimiter;
1298: FND_LOG.STRING(G_LEVEL_STATEMENT,
1299: G_MODULE_NAME || l_procedure_name,
1300: l_log_msg);
1301: END IF;
1302:

Line 1314: FND_LOG.STRING(G_LEVEL_STATEMENT,

1310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1311: l_log_msg := 'E: CUR: c_delimiter: notfound: Classification_Type_Categ_Code='
1312: || p_fsc_cat_rec.classification_category ||
1313: ', classification_type_code=' || p_fsc_cat_rec.classification_type;
1314: FND_LOG.STRING(G_LEVEL_STATEMENT,
1315: G_MODULE_NAME || l_procedure_name,
1316: l_log_msg);
1317: END IF;
1318: --return;

Line 1348: FND_LOG.STRING(G_LEVEL_STATEMENT,

1344: ', l_segment2=' || l_segment2 ||
1345: ', l_segment3=' || l_segment3 ||
1346: ', l_segment4=' || l_segment4 ||
1347: ', l_segment5=' || l_segment5;
1348: FND_LOG.STRING(G_LEVEL_STATEMENT,
1349: G_MODULE_NAME || l_procedure_name,
1350: l_log_msg);
1351: END IF;
1352:

Line 1367: FND_LOG.STRING(G_LEVEL_STATEMENT,

1363: || p_fsc_cat_rec.classification_category ||
1364: ', classification_type_code=' || p_fsc_cat_rec.classification_type ||
1365: ', concat_classif_code=' || p_fsc_cat_rec.parameter_value ||
1366: ', p_fsc_cat_rec.tax_determine_date=' || p_fsc_cat_rec.tax_determine_date;
1367: FND_LOG.STRING(G_LEVEL_STATEMENT,
1368: G_MODULE_NAME || l_procedure_name,
1369: l_log_msg);
1370: END IF;
1371: --return;

Line 1404: FND_LOG.STRING(G_LEVEL_STATEMENT,

1400: l_log_msg := 'B: p_fsc_cat_rec.condition_subclass=' || p_fsc_cat_rec.condition_subclass ||
1401: ', p_fsc_cat_rec.condition_value=' || p_fsc_cat_rec.condition_value ||
1402: ', p_fsc_cat_rec.effective_from=' || p_fsc_cat_rec.effective_from ||
1403: ', p_fsc_cat_rec.effective_to=' || p_fsc_cat_rec.effective_to;
1404: FND_LOG.STRING(G_LEVEL_STATEMENT,
1405: G_MODULE_NAME || l_procedure_name,
1406: l_log_msg);
1407: END IF;
1408:

Line 1430: FND_LOG.STRING(G_LEVEL_STATEMENT,

1426: -- Logging Infra: YK: 3/5:
1427: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1428: l_log_msg := 'E: unspported category: p_fsc_cat_rec.classification_category= '
1429: || p_fsc_cat_rec.classification_category;
1430: FND_LOG.STRING(G_LEVEL_STATEMENT,
1431: G_MODULE_NAME || l_procedure_name,
1432: l_log_msg);
1433: END IF;
1434: RAISE FND_API.G_EXC_ERROR;

Line 1443: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1439: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1440: l_log_msg := 'E: unspported category: p_fsc_cat_rec.classification_category= '
1441: || p_fsc_cat_rec.classification_category;
1442: l_log_msg := l_log_msg || ' get_prod_trx_cate_value(-)';
1443: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1444: G_MODULE_NAME || l_procedure_name, l_log_msg);
1445: END IF;
1446: EXCEPTION
1447: WHEN INVALID_CURSOR THEN

Line 1457: FND_LOG.STRING(G_LEVEL_STATEMENT,

1453: if c_delimiter%isopen then close c_delimiter; end if;
1454:
1455: -- Logging Infra: YK: 3/5:
1456: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1457: FND_LOG.STRING(G_LEVEL_STATEMENT,
1458: G_MODULE_NAME || l_procedure_name,
1459: SQLCODE || ': ' || SQLERRM);
1460: END IF;
1461:

Line 1472: FND_LOG.STRING(G_LEVEL_STATEMENT,

1468: if c_delimiter%isopen then close c_delimiter; end if;
1469:
1470: -- Logging Infra: YK: 3/5:
1471: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1472: FND_LOG.STRING(G_LEVEL_STATEMENT,
1473: G_MODULE_NAME || l_procedure_name,
1474: SQLCODE || ': ' || SQLERRM);
1475: END IF;
1476:

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 1609: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1605: l_ptp_type_code zx_party_tax_profile.party_type_code%type;
1606:
1607: -- Logging Infra
1608: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Tax';
1609: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1610:
1611: -----------------------------------------------------------------
1612: -- Get the Tax Registration Information
1613: -- Tax Registration should be valid on the Tax Determination Date

Line 1722: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1718:
1719: BEGIN
1720:
1721: -- Logging Infra: Setting up runtime level
1722: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1723:
1724: -- Initialize return status
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:

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

1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:
1727: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1728: l_log_msg := l_procedure_name||'(+)';
1729: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1730: END IF;
1731:
1732:
1733: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1736: l_log_msg := l_log_msg||' p_tax_regime_code: '||p_tax_regime_code;
1737: l_log_msg := l_log_msg||' p_tax: '||p_tax;
1738: l_log_msg := l_log_msg||' p_jurisdiction_code: '||p_jurisdiction_code;
1739: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
1740: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1741: END IF;
1742:
1743: l_tax_regime_code := nvl(p_tax_regime_code, c_tax_regime_code_dummy);
1744: l_tax := nvl(p_tax, c_tax_dummy);

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

1746:
1747: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||l_tax_regime_code||l_tax||l_jurisdiction_code,1,8192);
1748:
1749: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'l_index = '||l_index);
1751: END IF;
1752:
1753: IF ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl.exists(l_index) THEN -- found in cache
1754:

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

1752:
1753: IF ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl.exists(l_index) THEN -- found in cache
1754:
1755: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1756: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Record found in cache for l_index = '||l_index||
1757: ' Dummy_flag = '||ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index).dummy_flag);
1758: END IF;
1759:
1760: IF ZX_GLOBAL_STRUCTURES_PKG.g_registration_info_tbl(l_index).dummy_flag = 'Y' then

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

1762: p_getone:=0;
1763:
1764: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1765: l_log_msg := 'The same combination already searched previously with an unsuccessful hit' ;
1766: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1767: END IF;
1768:
1769: ELSE
1770:

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

1799:
1800: ELSE -- not found in cache
1801:
1802: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Record NOT found in cache for l_index = '||l_index);
1804: END IF;
1805:
1806: p_getone := 0;
1807: -- If the parameters 'Tax' and 'Jurisdiction' are null, and 'Regime' is not null then look for Regime evel.

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

1850: -- Bug#5520167- set flag to upper case Y
1851: DUMMY_REGISTRATION_REC.DUMMY_FLAG := 'Y';
1852:
1853: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1854: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Creating a dummy Record for l_index = '||l_index);
1855: END IF;
1856:
1857:
1858: -- This assignment statement is to mark that we already searched the database for

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

1881: l_log_msg := l_log_msg||' tax_regime_code: '||nvl(x_get_registration_rec.tax_regime_code,c_tax_regime_code_dummy);
1882: l_log_msg := l_log_msg||' p_tax: '||nvl(x_get_registration_rec.tax,c_tax_dummy);
1883: l_log_msg := l_log_msg||' p_jurisdiction_code: '||nvl(x_get_registration_rec.tax_jurisdiction_code,c_jurisdiction_code_dummy);
1884: l_log_msg := l_log_msg||' l_index: '||to_char(l_index);
1885: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1886: END IF;
1887:
1888:
1889: END IF; -- Got registrations

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

1892: END IF; -- found in cache
1893:
1894: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1895: l_log_msg := l_procedure_name||'(-)';
1896: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
1897: END IF;
1898: -- Fails
1899: EXCEPTION
1900: WHEN NO_DATA_FOUND THEN

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

1906:
1907: -- Logging Infra: Statement level
1908: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1909: l_log_msg := 'Error Message: '||SQLERRM;
1910: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1911: END IF;
1912: -- Logging Infra: Statement level
1913: END Do_Get_Registration_Tax;
1914:

Line 1946: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1942: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
1943:
1944: -- Logging Infra
1945: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Sup_Site';
1946: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1947:
1948: -----------------------------------------------------------------
1949: -- Get the Tax Registration Information
1950: -- Tax Registration should be valid on the Tax Determination Date

Line 1973: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1969:
1970: BEGIN
1971:
1972: -- Logging Infra: Setting up runtime level
1973: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1974:
1975: -- Initialize return status
1976: x_return_status := FND_API.G_RET_STS_SUCCESS;
1977:

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

1977:
1978: -- Logging Infra: Procedure level
1979: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1980: l_log_msg := l_procedure_name||'(+)';
1981: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1982: END IF;
1983:
1984: -- Logging Infra: Statement level
1985: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1986: l_log_msg := 'Parameters ';
1987: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
1988: l_log_msg := l_log_msg||' p_account_site_id: '||p_account_site_id;
1989: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
1990: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1991: END IF;
1992: -- Logging Infra: Statement level
1993:
1994: IF ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl.exists(p_account_site_id) THEN

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

1993:
1994: IF ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl.exists(p_account_site_id) THEN
1995:
1996: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1997: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
1998: 'Vendor site record found in cache for vendor site id:'||to_char(p_account_site_id));
1999: END IF;
2000:
2001: l_supp_site_info_rec := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id);

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

2044: CLOSE c_supplier_ptp;
2045: -- Logging Infra: Procedure level
2046: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2047: l_log_msg := l_procedure_name||'(-)';
2048: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2049: END IF;
2050: -- Fails
2051: END IF;
2052: EXCEPTION

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

2059:
2060: -- Logging Infra: Statement level
2061: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2062: l_log_msg := 'Error Message: '||SQLERRM;
2063: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2064: END IF;
2065: -- Logging Infra: Statement level
2066: END Do_Get_Sup_Site;
2067:

Line 2094: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2090: l_ptp_type_code VARCHAR2(30);
2091:
2092: -- Logging Infra
2093: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Reg_Site_Uses';
2094: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2095:
2096: -----------------------------------------------------------------
2097: -- Get the Tax Registration Information
2098: -- Tax Registration should be valid on the Tax Determination Date

Line 2120: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2116:
2117: BEGIN
2118:
2119: -- Logging Infra: Setting up runtime level
2120: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2121:
2122: -- Initialize return status
2123: x_return_status := FND_API.G_RET_STS_SUCCESS;
2124:

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

2124:
2125: -- Logging Infra: Procedure level
2126: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2127: l_log_msg := l_procedure_name||'(+)';
2128: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2129: END IF;
2130:
2131: -- Logging Infra: Statement level
2132: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2134: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2135: l_log_msg := l_log_msg||' p_account_site_id: '||p_account_site_id;
2136: l_log_msg := l_log_msg||' p_site_use_id: '||p_site_use_id;
2137: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
2138: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2139: END IF;
2140: -- Logging Infra: Statement level
2141: p_getone := 0;
2142:

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

2152:
2153: p_getone:=1;
2154:
2155: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2156: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Site Use information found in cache');
2157: END IF;
2158: ELSE
2159: For my_reg IN c_site_uses Loop
2160: -- Got registration

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

2181:
2182: -- Logging Infra: Procedure level
2183: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2184: l_log_msg := l_procedure_name||'(-)';
2185: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2186: END IF;
2187: -- Fails
2188: EXCEPTION
2189: WHEN NO_DATA_FOUND THEN

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

2195:
2196: -- Logging Infra: Statement level
2197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2198: l_log_msg := 'Error Message: '||SQLERRM;
2199: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2200: END IF;
2201: -- Logging Infra: Statement level
2202: END Do_Get_Reg_Site_Uses;
2203:

Line 2227: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2223: l_ptp_type_code VARCHAR2(30);
2224:
2225: -- Logging Infra
2226: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Accts';
2227: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2228: -----------------------------------------------------------------
2229: -- Get the Tax Registration Information
2230: -- Tax Registration should be valid on the Tax Determination Date
2231: -----------------------------------------------------------------

Line 2245: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2241:
2242: BEGIN
2243:
2244: -- Logging Infra: Setting up runtime level
2245: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2246:
2247: -- Initialize return status
2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249:

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

2249:
2250: -- Logging Infra: Procedure level
2251: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2252: l_log_msg := l_procedure_name||'(+)';
2253: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2254: END IF;
2255:
2256: -- Logging Infra: Statement level
2257: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2258: l_log_msg := 'Parameters ';
2259: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2260: l_log_msg := l_log_msg||' p_account_id: '||p_account_id;
2261: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
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: p_getone := 0;
2266:

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

2271: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag;
2272: x_get_registration_rec.tax_classification_code :=
2273: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_code;
2274: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'Cust Account information found in cache');
2276: END IF;
2277: ELSE
2278: For my_reg IN c_customer_account Loop
2279: -- Got registration

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

2294:
2295: -- Logging Infra: Procedure level
2296: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2297: l_log_msg := l_procedure_name||'(-)';
2298: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2299: END IF;
2300: -- Fails
2301: EXCEPTION
2302: WHEN NO_DATA_FOUND THEN

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

2308:
2309: -- Logging Infra: Statement level
2310: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2311: l_log_msg := 'Error Message: '||SQLERRM;
2312: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2313: END IF;
2314: -- Logging Infra: Statement level
2315: END Do_Get_Registration_Accts;
2316:

Line 2336: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2332: l_tbl_index BINARY_INTEGER;
2333:
2334: -- Logging Infra
2335: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Party';
2336: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2337:
2338:
2339: BEGIN
2340:

Line 2342: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2338:
2339: BEGIN
2340:
2341: -- Logging Infra: Setting up runtime level
2342: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2343:
2344: -- Initialize return status
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;
2346:

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

2346:
2347: -- Logging Infra: Procedure level
2348: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2349: l_log_msg := l_procedure_name||'(+)';
2350: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2351: END IF;
2352:
2353: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2354: l_log_msg := 'Parameters ';

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

2353: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2354: l_log_msg := 'Parameters ';
2355: l_log_msg := l_log_msg||' p_party_tax_profile_id: '||to_char(p_party_tax_profile_id);
2356: l_log_msg := l_log_msg||' p_tax_determine_date: '||to_char(p_tax_determine_date,'DD-MON-RRRR');
2357: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2358: END IF;
2359:
2360: p_getone := 0;
2361:

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

2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395:
2396: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2397: l_log_msg := 'Party Tax Profile Id is not valid: '||p_party_tax_profile_id;
2398: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2399: END IF;
2400:
2401: END IF;
2402:

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

2402:
2403: -- Logging Infra: Procedure level
2404: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2405: l_log_msg := l_procedure_name||'(-)';
2406: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.end', l_log_msg);
2407: END IF;
2408: -- Fails
2409: EXCEPTION
2410: WHEN NO_DATA_FOUND THEN

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

2416:
2417: -- Logging Infra: Statement level
2418: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2419: l_log_msg := 'Error Message: '||SQLERRM;
2420: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2421: END IF;
2422: -- Logging Infra: Statement level
2423: END Do_Get_Registration_Party;
2424:

Line 2462: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2458: l_ptp_type_code VARCHAR2(30);
2459:
2460: -- Logging Infra
2461: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Tax_Registration';
2462: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2463:
2464: BEGIN
2465:
2466: -- Logging Infra: Setting up runtime level

Line 2467: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2463:
2464: BEGIN
2465:
2466: -- Logging Infra: Setting up runtime level
2467: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2468:
2469: -- Logging Infra: Procedure level
2470: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2471: l_log_msg := l_procedure_name||'(+)';

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

2468:
2469: -- Logging Infra: Procedure level
2470: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2471: l_log_msg := l_procedure_name||'(+)';
2472: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2473: END IF;
2474:
2475: -- Logging Infra: Statement level
2476: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2482: l_log_msg := l_log_msg||' p_tax_regime_code: '||p_tax_regime_code||', ';
2483: l_log_msg := l_log_msg||' p_jurisdiction_code: '||p_jurisdiction_code||', ';
2484: l_log_msg := l_log_msg||' p_account_site_id: '||to_char(p_account_site_id)||', ';
2485: l_log_msg := l_log_msg||' p_site_use_id: '||to_char(p_site_use_id)||', ';
2486: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2487: END IF;
2488: -- Logging Infra: Statement level
2489:
2490: -- Initialize Return Status and Error Buffer

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

2628:
2629: -- Logging Infra: Procedure level
2630: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN -- if16
2631: l_log_msg := l_procedure_name||'Get Tax Registration did not find any record';
2632: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2633: END IF; --if16
2634: END IF; -- if15 getone
2635: END IF; -- if14 getone site level
2636: END IF; -- if13

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

2639: END IF; --if1
2640: -- Logging Infra: Procedure level
2641: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2642: l_log_msg := l_procedure_name||'(-)';
2643: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);
2644: END IF;
2645:
2646: EXCEPTION
2647: WHEN NO_DATA_FOUND THEN

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

2653:
2654: -- Logging Infra: Statement level
2655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2656: l_log_msg := 'Error Message: '||SQLERRM;
2657: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2658: END IF;
2659: -- Logging Infra: Statement level
2660:
2661: END Get_Tax_Registration;

Line 2667: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2663:
2664: PROCEDURE INITIALIZE_LTE (p_return_status OUT NOCOPY VARCHAR2) IS
2665:
2666: l_procedure_name CONSTANT VARCHAR2(30) := 'Initialize LTE';
2667: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2668: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
2669: l_fc_id ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE;
2670:
2671: BEGIN

Line 2673: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2669: l_fc_id ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE;
2670:
2671: BEGIN
2672: -- Logging Infra: Setting up runtime level
2673: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2674:
2675: -- Initialize return status
2676: p_return_status := FND_API.G_RET_STS_SUCCESS;
2677:

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

2677:
2678: -- Logging Infra: Procedure level
2679: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2680: l_log_msg := l_procedure_name||'(+)';
2681: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2682: END IF;
2683:
2684: -- Logging Infra: Statement level
2685: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2683:
2684: -- Logging Infra: Statement level
2685: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2686: l_log_msg := 'Parameters : None';
2687: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2688: END IF;
2689: -- Logging Infra: Statement level
2690:
2691: IF (zx_fc_migrate_pkg.Is_Country_Installed(7004, 'jlbrloc') or

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

2759:
2760: -- Logging Infra: Procedure level
2761: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2762: l_log_msg := l_procedure_name||'(-)';
2763: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.END', l_log_msg);
2764: END IF;
2765:
2766:
2767: EXCEPTION WHEN OTHERS THEN

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

2771:
2772: -- Logging Infra: Statement level
2773: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2774: l_log_msg := 'Error Message: '||SQLERRM;
2775: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2776: END IF;
2777: -- Logging Infra: Statement level
2778:
2779: END INITIALIZE_LTE;