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 ZX_TRL_ALLOCATIONS_PKG

Line 1: PACKAGE BODY ZX_TRL_ALLOCATIONS_PKG AS

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;

Line 60: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.BEGIN',

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:
64: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 66: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.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:
70: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 72: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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',
76: 'Input Parameters :- Summary Tax Line Id: '|| to_char(p_summary_tax_line_id)||

Line 75: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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||
79: ', Event Class Code: '|| p_event_class_code||

Line 89: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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:
93: l_trx_line_exist := NULL;

Line 113: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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');
117: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Transaction Line does not exist. System cannot create tax line without transaction line.');

Line 122: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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;
126: -- End : Added a prevetive check to make the trx line exists --

Line 456: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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:
460: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 462: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.END',

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
466: WHEN NO_DATA_FOUND THEN

Line 502: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.BEGIN',

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:
506: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 508: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.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||
512: ', Event Class Code: '|| p_event_class_code||

Line 534: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_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:
538: SELECT SUM(LINE_AMT)

Line 550: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',

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:
554: IF l_total_trx_line_amt <> 0 THEN

Line 577: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',

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:
581: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 583: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.END',

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

Line 626: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.BEGIN',

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:
630: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 632: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.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||
636: ', Event_Class_Code:'||p_event_class_code||

Line 643: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation',

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:
647: OPEN ALLOC FOR p_statement;

Line 705: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation',

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)||
709: ', Allocated_to_R2R_Flag:'||l_alloc_to_r2r);

Line 733: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.END',

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:
737: EXCEPTION

Line 878: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.BEGIN',

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:
882: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 884: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.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||
888: ', Event_class_code='||p_event_class_code||

Line 930: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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
934: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 936: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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;
940: ELSE

Line 949: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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;
953: BEGIN

Line 972: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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');
976: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Transaction Line does not exist. System cannot create tax line without transaction line.');

Line 981: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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;
985: -- End : Added a prevetive check to make the trx line exists --

Line 999: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1003: SELECT tax_regime_id

Line 1010: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1014: IF l_regime_id IS NULL THEN

Line 1024: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1028: IF l_tax_id IS NULL THEN

Line 1038: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1042: IF l_status_id IS NULL THEN

Line 1052: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1056: BEGIN

Line 1073: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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

Line 1098: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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||
1102: ', Establishment_id='||l_establishment_id||

Line 1425: ZX_TRL_ALLOCATIONS_PKG.Update_Tax_Amt

1421: END LOOP;
1422:
1423: CLOSE ALLOC;
1424:
1425: ZX_TRL_ALLOCATIONS_PKG.Update_Tax_Amt
1426: (p_summary_tax_line_id => p_summary_tax_line_id,
1427: p_application_id => p_application_id,
1428: p_entity_code => p_entity_code,
1429: p_event_class_code => p_event_class_code,

Line 1433: ZX_TRL_ALLOCATIONS_PKG.Delete_alloc_tbl;

1429: p_event_class_code => p_event_class_code,
1430: p_trx_id => v_trx_id,
1431: p_tax_amt => p_tax_amt);
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',

Line 1437: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.END',

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:
1441: EXCEPTION

Line 1445: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG. Insert_All_Allocation.EXCEPTION',

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

Line 1546: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',

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:
1550: l_tax_line_number :=1;

Line 1576: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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',
1580: 'legal entity id' || to_char(p_legal_entity_id)) ;

Line 1579: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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',
1583: 'ledger id' || to_char(p_ledger_id)) ;

Line 1582: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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',
1586: 'trx_currency_code ' || p_trx_currency_code) ;

Line 1585: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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',
1589: 'content owner id ' || p_content_owner_id) ;

Line 1588: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1592: BEGIN

Line 1620: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',

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',
1624: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

Line 1623: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

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:
1627: RETURN;

Line 1624: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

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:
1627: RETURN;
1628:

Line 1632: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1636: BEGIN

Line 1647: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',

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',
1651: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

Line 1650: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

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:
1654: RETURN;

Line 1651: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

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:
1654: RETURN;
1655:

Line 1671: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',

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',
1675: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

Line 1674: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

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:
1678: RETURN;

Line 1675: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

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:
1678: RETURN;
1679:

Line 1704: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',

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',
1708: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

Line 1707: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

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:
1711: RETURN;

Line 1708: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');

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:
1711: RETURN;
1712:

Line 1721: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

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:
1725:

Line 1728: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.',

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:
1732: BEGIN

Line 2132: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',

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:
2136: EXCEPTION

Line 2146: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_alloc_tbl',

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';
2150: EXCEPTION

Line 2159: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Delete_alloc_tbl',

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;
2163: EXCEPTION

Line 2167: END ZX_TRL_ALLOCATIONS_PKG;

2163: EXCEPTION
2164: WHEN others THEN
2165: NULL;
2166: END;
2167: END ZX_TRL_ALLOCATIONS_PKG;