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

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

1: PACKAGE BODY ZX_TRL_ALLOCATIONS_PKG AS
2: /* $Header: zxriallocatnpkgb.pls 120.42 2011/08/16 09:46:37 snoothi ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

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

2: /* $Header: zxriallocatnpkgb.pls 120.42 2011/08/16 09:46:37 snoothi ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE Insert_Row

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

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE Insert_Row
11: (X_Rowid IN OUT NOCOPY VARCHAR2,

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

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE Insert_Row
11: (X_Rowid IN OUT NOCOPY VARCHAR2,
12: p_summary_tax_line_id NUMBER,

Line 56: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

52: l_trx_currency_code VARCHAR2(20);
53: l_trx_line_exist VARCHAR2(1);
54: BEGIN
55:
56: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
57:
58: IF (g_level_procedure >= g_current_runtime_level ) THEN
59: FND_LOG.STRING(g_level_procedure,
60: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.BEGIN',

Line 59: FND_LOG.STRING(g_level_procedure,

55:
56: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
57:
58: IF (g_level_procedure >= g_current_runtime_level ) THEN
59: FND_LOG.STRING(g_level_procedure,
60: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.BEGIN',
61: 'Insert_Row (+)');
62: END IF;
63:

Line 65: FND_LOG.STRING(g_level_procedure,

61: 'Insert_Row (+)');
62: END IF;
63:
64: IF (g_level_procedure >= g_current_runtime_level ) THEN
65: FND_LOG.STRING(g_level_procedure,
66: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
67: 'Insert into zx_lines for allocation of lines. (+)');
68: END IF;
69:

Line 71: FND_LOG.STRING(g_level_procedure,

67: 'Insert into zx_lines for allocation of lines. (+)');
68: END IF;
69:
70: IF (g_level_procedure >= g_current_runtime_level ) THEN
71: FND_LOG.STRING(g_level_procedure,
72: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
73: 'Is Record enabled: '|| p_enabled_record);
74: FND_LOG.STRING(g_level_procedure,
75: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

Line 74: FND_LOG.STRING(g_level_procedure,

70: IF (g_level_procedure >= g_current_runtime_level ) THEN
71: FND_LOG.STRING(g_level_procedure,
72: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
73: 'Is Record enabled: '|| p_enabled_record);
74: FND_LOG.STRING(g_level_procedure,
75: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
76: 'Input Parameters :- Summary Tax Line Id: '|| to_char(p_summary_tax_line_id)||
77: ', Application Id: '|| to_char(p_application_id)||
78: ', Entity Code: '|| p_entity_code||

Line 88: FND_LOG.STRING(g_level_procedure,

84: IF p_enabled_record ='Y' THEN
85:
86: -- Start : Added a prevetive check to make the trx line exists --
87: IF (g_level_procedure >= g_current_runtime_level ) THEN
88: FND_LOG.STRING(g_level_procedure,
89: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
90: 'Executing Trx Line Exists Validation - '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MM:SS'));
91: END IF;
92:

Line 112: FND_LOG.STRING(g_level_procedure,

108: END;
109:
110: IF l_trx_line_exist = 'N' THEN
111: IF (g_level_procedure >= g_current_runtime_level ) THEN
112: FND_LOG.STRING(g_level_procedure,
113: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
114: 'Trx Line Exists Validation : FAILED');
115: END IF;
116: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');

Line 121: FND_LOG.STRING(g_level_procedure,

117: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Transaction Line does not exist. System cannot create tax line without transaction line.');
118: APP_EXCEPTION.RAISE_EXCEPTION;
119: ELSE
120: IF (g_level_procedure >= g_current_runtime_level ) THEN
121: FND_LOG.STRING(g_level_procedure,
122: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
123: 'Trx Line Exists Validation : PASSED - '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MM:SS'));
124: END IF;
125: END IF;

Line 455: FND_LOG.STRING(g_level_procedure,

451:
452: END IF;
453:
454: IF (g_level_procedure >= g_current_runtime_level ) THEN
455: FND_LOG.STRING(g_level_procedure,
456: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
457: 'Insert into zx_lines for allocation of lines. (-)');
458: END IF;
459:

Line 461: FND_LOG.STRING(g_level_procedure,

457: 'Insert into zx_lines for allocation of lines. (-)');
458: END IF;
459:
460: IF (g_level_procedure >= g_current_runtime_level ) THEN
461: FND_LOG.STRING(g_level_procedure,
462: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.END',
463: 'Insert_Row (-)');
464: END IF;
465: EXCEPTION

Line 498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

494: l_unrounded_tax_amt NUMBER;
495:
496: BEGIN
497:
498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
499:
500: IF (g_level_procedure >= g_current_runtime_level ) THEN
501: FND_LOG.STRING(g_level_procedure,
502: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.BEGIN',

Line 501: FND_LOG.STRING(g_level_procedure,

497:
498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
499:
500: IF (g_level_procedure >= g_current_runtime_level ) THEN
501: FND_LOG.STRING(g_level_procedure,
502: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.BEGIN',
503: 'Update_tax_amt (+)');
504: END IF;
505:

Line 507: FND_LOG.STRING(g_level_procedure,

503: 'Update_tax_amt (+)');
504: END IF;
505:
506: IF (g_level_procedure >= g_current_runtime_level ) THEN
507: FND_LOG.STRING(g_level_procedure,
508: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
509: 'Input Parameters :- Summary Tax Line Id: '|| to_char(p_summary_tax_line_id)||
510: ', Application Id: '|| to_char(p_application_id)||
511: ', Entity Code: '|| p_entity_code||

Line 533: FND_LOG.STRING(g_level_statement,

529: l_summary_tax_amt := p_tax_amt;
530: END IF;
531:
532: IF (g_level_statement >= g_current_runtime_level ) THEN
533: FND_LOG.STRING(g_level_statement,
534: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
535: 'Summary_Tax_Amount : '||to_char(l_summary_tax_amt));
536: END IF;
537:

Line 549: FND_LOG.STRING(g_level_statement,

545: AND TRX_ID = p_trx_id
546: AND NVL(CANCEL_FLAG,'N') <> 'Y';
547:
548: IF (g_level_statement >= g_current_runtime_level ) THEN
549: FND_LOG.STRING(g_level_statement,
550: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
551: 'Total_Trx_Line_Amount : '||to_char(l_total_trx_line_amt));
552: END IF;
553:

Line 576: FND_LOG.STRING(g_level_statement,

572: AND TRX_ID = p_trx_id
573: AND NVL(CANCEL_FLAG,'N') <> 'Y';
574:
575: IF (g_level_statement >= g_current_runtime_level ) THEN
576: FND_LOG.STRING(g_level_statement,
577: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
578: 'Total_Unrounded_Tax_Amt '||to_char(l_unrounded_tax_amt));
579: END IF;
580:

Line 582: FND_LOG.STRING(g_level_procedure,

578: 'Total_Unrounded_Tax_Amt '||to_char(l_unrounded_tax_amt));
579: END IF;
580:
581: IF (g_level_procedure >= g_current_runtime_level ) THEN
582: FND_LOG.STRING(g_level_procedure,
583: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.END',
584: 'Update_tax_amt (-)');
585: END IF;
586: END Update_tax_amt;

Line 619: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

615: j NUMBER;
616:
617: BEGIN
618:
619: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
620:
621: i := 0;
622: j := 0;
623:

Line 625: FND_LOG.STRING(g_level_procedure,

621: i := 0;
622: j := 0;
623:
624: IF (g_level_procedure >= g_current_runtime_level ) THEN
625: FND_LOG.STRING(g_level_procedure,
626: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.BEGIN',
627: 'Populate_Allocation (+)');
628: END IF;
629:

Line 631: FND_LOG.STRING(g_level_statement,

627: 'Populate_Allocation (+)');
628: END IF;
629:
630: IF (g_level_statement >= g_current_runtime_level ) THEN
631: FND_LOG.STRING(g_level_statement,
632: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation',
633: 'Input Parameters :- Summary_Tax_Line_Id:'||p_summary_tax_line_id||
634: ', Application_id:'||p_application_id||
635: ', Entity_Code:'||p_entity_code||

Line 642: FND_LOG.STRING(g_level_statement,

638: ', Tax:'||p_tax);
639: END IF;
640:
641: IF (g_level_statement >= g_current_runtime_level ) THEN
642: FND_LOG.STRING(g_level_statement,
643: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation',
644: 'Cursor Statement : '||p_statement);
645: END IF;
646:

Line 704: FND_LOG.STRING(g_level_statement,

700: l_alloc_to_r2r := 'N';
701: END IF;
702:
703: IF (g_level_statement >= g_current_runtime_level ) THEN
704: FND_LOG.STRING(g_level_statement,
705: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation',
706: 'Trx_Id:'||l_trx_record.p_trx_id(i)||
707: ', Trx_Line_Id:'||l_trx_record.p_trx_line_id(i)||
708: ', Alloc_Exist_Flag:'||l_trx_record.p_alloc_exist_flag(i)||

Line 732: FND_LOG.STRING(g_level_procedure,

728:
729: CLOSE ALLOC;
730:
731: IF (g_level_procedure >= g_current_runtime_level ) THEN
732: FND_LOG.STRING(g_level_procedure,
733: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.END',
734: 'Populate_Allocation (-)');
735: END IF;
736:

Line 874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

870: WHERE summary_tax_line_id = c_summary_tax_line_id;
871:
872: BEGIN
873:
874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875:
876: IF (g_level_procedure >= g_current_runtime_level ) THEN
877: FND_LOG.STRING(g_level_procedure,
878: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.BEGIN',

Line 877: FND_LOG.STRING(g_level_procedure,

873:
874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
875:
876: IF (g_level_procedure >= g_current_runtime_level ) THEN
877: FND_LOG.STRING(g_level_procedure,
878: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.BEGIN',
879: 'Insert_All_Allocation (+)');
880: END IF;
881:

Line 883: FND_LOG.STRING(g_level_procedure,

879: 'Insert_All_Allocation (+)');
880: END IF;
881:
882: IF (g_level_procedure >= g_current_runtime_level ) THEN
883: FND_LOG.STRING(g_level_procedure,
884: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
885: 'Input Parameters : Summary_Tax_line_id='||p_summary_tax_line_id||
886: ', Application_id='||p_application_id||
887: ', Entity_code='||p_entity_code||

Line 929: FND_LOG.STRING(g_level_statement,

925:
926: IF p_allocate_flag = 'Y' THEN
927: l_key := to_char(p_summary_tax_line_id)||to_char(v_trx_id)||to_char(v_trx_line_id);
928: IF (g_level_statement >= g_current_runtime_level ) THEN
929: FND_LOG.STRING(g_level_statement,
930: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
931: 'key : ' || l_key) ;
932: END IF;
933: IF g_trx_allocate_tbl.exists(l_key) THEN

Line 935: FND_LOG.STRING(g_level_statement,

931: 'key : ' || l_key) ;
932: END IF;
933: IF g_trx_allocate_tbl.exists(l_key) THEN
934: IF (g_level_statement >= g_current_runtime_level ) THEN
935: FND_LOG.STRING(g_level_statement,
936: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
937: 'Allocate TRUE') ;
938: END IF;
939: l_insert := TRUE;

Line 948: FND_LOG.STRING(g_level_procedure,

944:
945: IF l_insert THEN
946: -- Start : Added a prevetive check to make the trx line exists --
947: IF (g_level_procedure >= g_current_runtime_level ) THEN
948: FND_LOG.STRING(g_level_procedure,
949: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
950: 'Executing Trx Line Exists Validation - '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MM:SS'));
951: END IF;
952: l_trx_line_exist := NULL;

Line 971: FND_LOG.STRING(g_level_procedure,

967: END;
968:
969: IF l_trx_line_exist = 'N' THEN
970: IF (g_level_procedure >= g_current_runtime_level ) THEN
971: FND_LOG.STRING(g_level_procedure,
972: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
973: 'Trx Line Exists Validation : FAILED');
974: END IF;
975: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');

Line 980: FND_LOG.STRING(g_level_procedure,

976: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Transaction Line does not exist. System cannot create tax line without transaction line.');
977: APP_EXCEPTION.RAISE_EXCEPTION;
978: ELSE
979: IF (g_level_procedure >= g_current_runtime_level ) THEN
980: FND_LOG.STRING(g_level_procedure,
981: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
982: 'Trx Line Exists Validation : PASSED - '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MM:SS'));
983: END IF;
984: END IF;

Line 998: FND_LOG.STRING(g_level_procedure,

994: AND TRX_LINE_ID = v_trx_line_id
995: AND TRX_LEVEL_TYPE = v_trx_level_type;
996:
997: IF (g_level_procedure >= g_current_runtime_level ) THEN
998: FND_LOG.STRING(g_level_procedure,
999: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1000: 'Tax_Line_Number : ' || to_char(l_tax_line_number)) ;
1001: END IF;
1002:

Line 1009: FND_LOG.STRING(g_level_procedure,

1005: FROM zx_regimes_b
1006: WHERE TAX_REGIME_CODE = p_tax_regime_code;
1007:
1008: IF (g_level_procedure >= g_current_runtime_level ) THEN
1009: FND_LOG.STRING(g_level_procedure,
1010: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1011: 'Tax_Regime_Id : ' || to_char(l_regime_id)) ;
1012: END IF;
1013:

Line 1023: FND_LOG.STRING(g_level_procedure,

1019: FETCH get_tax_id INTO l_tax_id,l_Place_Of_Supply_Type_Code; --Bug 12688194;
1020: CLOSE get_tax_id;
1021:
1022: IF (g_level_procedure >= g_current_runtime_level ) THEN
1023: FND_LOG.STRING(g_level_procedure,
1024: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1025: 'Tax_Id : ' || to_char(l_tax_id)) ;
1026: END IF;
1027:

Line 1037: FND_LOG.STRING(g_level_procedure,

1033: FETCH get_tax_status_id INTO l_status_id;
1034: CLOSE get_tax_status_id;
1035:
1036: IF (g_level_procedure >= g_current_runtime_level ) THEN
1037: FND_LOG.STRING(g_level_procedure,
1038: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1039: 'Tax_Status_Id : ' || to_char(l_status_id)) ;
1040: END IF;
1041:

Line 1051: FND_LOG.STRING(g_level_procedure,

1047: INTO l_tax_line_id
1048: FROM dual;
1049:
1050: IF (g_level_procedure >= g_current_runtime_level ) THEN
1051: FND_LOG.STRING(g_level_procedure,
1052: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1053: 'Line_Amt : ' || to_char(v_line_amt)) ;
1054: END IF;
1055:

Line 1072: FND_LOG.STRING(g_level_procedure,

1068: AND rownum = 1;
1069: EXCEPTION
1070: WHEN OTHERS THEN NULL;
1071: IF (g_level_procedure >= g_current_runtime_level ) THEN
1072: FND_LOG.STRING(g_level_procedure,
1073: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1074: 'exception : ' || sqlerrm);
1075: END IF;
1076: END ;

Line 1097: FND_LOG.STRING(g_level_statement,

1093: l_tax_provider_id;
1094: CLOSE get_summary_columns;
1095:
1096: IF (g_level_statement >= g_current_runtime_level ) THEN
1097: FND_LOG.STRING(g_level_statement,
1098: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1099: 'Summarization Columns Values: '||
1100: 'Ledger_id='||l_ledger_id||
1101: ', Legal_entity_id='||l_legal_entity_id||

Line 1436: FND_LOG.STRING(g_level_procedure,

1432:
1433: ZX_TRL_ALLOCATIONS_PKG.Delete_alloc_tbl;
1434:
1435: IF (g_level_procedure >= g_current_runtime_level ) THEN
1436: FND_LOG.STRING(g_level_procedure,
1437: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.END',
1438: 'Insert_All_Allocation (-)');
1439: END IF;
1440:

Line 1444: FND_LOG.STRING(g_level_procedure,

1440:
1441: EXCEPTION
1442: WHEN NO_DATA_FOUND THEN
1443: IF (g_level_procedure >= g_current_runtime_level ) THEN
1444: FND_LOG.STRING(g_level_procedure,
1445: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG. Insert_All_Allocation.EXCEPTION',
1446: 'NO_DATA_FOUND Excpetion raised.');
1447: END IF;
1448: NULL;

Line 1542: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1538:
1539:
1540: BEGIN
1541:
1542: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1543:
1544: IF (g_level_procedure >= g_current_runtime_level ) THEN
1545: FND_LOG.STRING(g_level_procedure,
1546: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',

Line 1545: FND_LOG.STRING(g_level_procedure,

1541:
1542: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1543:
1544: IF (g_level_procedure >= g_current_runtime_level ) THEN
1545: FND_LOG.STRING(g_level_procedure,
1546: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',
1547: 'Insert_Tax_Line (+)');
1548: END IF;
1549:

Line 1575: FND_LOG.STRING(g_level_statement,

1571:
1572: END IF;
1573:
1574: IF (g_level_statement >= g_current_runtime_level ) THEN
1575: FND_LOG.STRING(g_level_statement,
1576: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1577: 'event type code ' || p_event_type_code) ;
1578: FND_LOG.STRING(g_level_statement,
1579: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1578: FND_LOG.STRING(g_level_statement,

1574: IF (g_level_statement >= g_current_runtime_level ) THEN
1575: FND_LOG.STRING(g_level_statement,
1576: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1577: 'event type code ' || p_event_type_code) ;
1578: FND_LOG.STRING(g_level_statement,
1579: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1580: 'legal entity id' || to_char(p_legal_entity_id)) ;
1581: FND_LOG.STRING(g_level_statement,
1582: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1581: FND_LOG.STRING(g_level_statement,

1577: 'event type code ' || p_event_type_code) ;
1578: FND_LOG.STRING(g_level_statement,
1579: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1580: 'legal entity id' || to_char(p_legal_entity_id)) ;
1581: FND_LOG.STRING(g_level_statement,
1582: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1583: 'ledger id' || to_char(p_ledger_id)) ;
1584: FND_LOG.STRING(g_level_statement,
1585: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1584: FND_LOG.STRING(g_level_statement,

1580: 'legal entity id' || to_char(p_legal_entity_id)) ;
1581: FND_LOG.STRING(g_level_statement,
1582: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1583: 'ledger id' || to_char(p_ledger_id)) ;
1584: FND_LOG.STRING(g_level_statement,
1585: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1586: 'trx_currency_code ' || p_trx_currency_code) ;
1587: FND_LOG.STRING(g_level_statement,
1588: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1587: FND_LOG.STRING(g_level_statement,

1583: 'ledger id' || to_char(p_ledger_id)) ;
1584: FND_LOG.STRING(g_level_statement,
1585: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1586: 'trx_currency_code ' || p_trx_currency_code) ;
1587: FND_LOG.STRING(g_level_statement,
1588: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1589: 'content owner id ' || p_content_owner_id) ;
1590: END IF;
1591:

Line 1619: FND_LOG.STRING(g_level_unexpected,

1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1619: FND_LOG.STRING(g_level_unexpected,
1620: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1621: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1622: FND_LOG.STRING(g_level_unexpected,
1623: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1622: FND_LOG.STRING(g_level_unexpected,

1618: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1619: FND_LOG.STRING(g_level_unexpected,
1620: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1621: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1622: FND_LOG.STRING(g_level_unexpected,
1623: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1624: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1625: END IF;
1626:

Line 1631: FND_LOG.STRING(g_level_procedure,

1627: RETURN;
1628:
1629: END;
1630: IF (g_level_procedure >= g_current_runtime_level ) THEN
1631: FND_LOG.STRING(g_level_procedure,
1632: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1633: 'tax id : ' || to_char(l_tax_id)) ;
1634: END IF;
1635:

Line 1646: FND_LOG.STRING(g_level_unexpected,

1642:
1643: EXCEPTION
1644: WHEN OTHERS THEN
1645: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1646: FND_LOG.STRING(g_level_unexpected,
1647: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1648: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1649: FND_LOG.STRING(g_level_unexpected,
1650: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1649: FND_LOG.STRING(g_level_unexpected,

1645: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1646: FND_LOG.STRING(g_level_unexpected,
1647: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1648: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1649: FND_LOG.STRING(g_level_unexpected,
1650: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1651: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1652: END IF;
1653:

Line 1670: FND_LOG.STRING(g_level_unexpected,

1666:
1667: EXCEPTION
1668: WHEN OTHERS THEN
1669: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_unexpected,
1671: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1672: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1673: FND_LOG.STRING(g_level_unexpected,
1674: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1673: FND_LOG.STRING(g_level_unexpected,

1669: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_unexpected,
1671: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1672: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1673: FND_LOG.STRING(g_level_unexpected,
1674: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1675: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1676: END IF;
1677:

Line 1703: FND_LOG.STRING(g_level_unexpected,

1699:
1700: EXCEPTION
1701: WHEN OTHERS THEN
1702: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1703: FND_LOG.STRING(g_level_unexpected,
1704: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1705: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1706: FND_LOG.STRING(g_level_unexpected,
1707: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1706: FND_LOG.STRING(g_level_unexpected,

1702: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1703: FND_LOG.STRING(g_level_unexpected,
1704: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1705: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1706: FND_LOG.STRING(g_level_unexpected,
1707: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1708: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1709: END IF;
1710:

Line 1720: FND_LOG.STRING(g_level_procedure,

1716: INTO l_tax_line_id
1717: FROM dual;
1718:
1719: IF (g_level_procedure >= g_current_runtime_level ) THEN
1720: FND_LOG.STRING(g_level_procedure,
1721: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1722: 'status id : ' || to_char(l_status_id)) ;
1723: END IF;
1724:

Line 1727: FND_LOG.STRING(g_level_procedure,

1723: END IF;
1724:
1725:
1726: IF (g_level_procedure >= g_current_runtime_level ) THEN
1727: FND_LOG.STRING(g_level_procedure,
1728: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.',
1729: 'Trx Line Id: '||to_char(l_trx_line_id));
1730: END IF;
1731:

Line 2131: FND_LOG.STRING(g_level_procedure,

2127: );
2128: END IF;
2129:
2130: IF (g_level_procedure >= g_current_runtime_level ) THEN
2131: FND_LOG.STRING(g_level_procedure,
2132: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',
2133: 'Insert_Tax_Line (-)');
2134: END IF;
2135:

Line 2145: FND_LOG.STRING(g_level_statement,

2141:
2142: PROCEDURE Populate_alloc_tbl(p_key IN VARCHAR2) IS
2143: BEGIN
2144: IF (g_level_statement >= g_current_runtime_level ) THEN
2145: FND_LOG.STRING(g_level_statement,
2146: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_alloc_tbl',
2147: 'key : ' || p_key) ;
2148: END IF;
2149: g_trx_allocate_tbl(p_key) := 'Y';

Line 2158: FND_LOG.STRING(g_level_statement,

2154:
2155: PROCEDURE Delete_alloc_tbl IS
2156: BEGIN
2157: IF (g_level_statement >= g_current_runtime_level ) THEN
2158: FND_LOG.STRING(g_level_statement,
2159: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Delete_alloc_tbl',
2160: 'Plsql Cache Structure flushed') ;
2161: END IF;
2162: g_trx_allocate_tbl.DELETE;