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.23.12010000.3 2008/12/11 23:28:33 appradha 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.23.12010000.3 2008/12/11 23:28:33 appradha 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:
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:
75: FND_LOG.STRING(g_level_procedure,

Line 75: FND_LOG.STRING(g_level_procedure,

71: FND_LOG.STRING(g_level_procedure,
72: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
73: 'Is Record enabled: '|| p_enabled_record);
74:
75: FND_LOG.STRING(g_level_procedure,
76: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
77: 'Summary Tax Line Id: '|| to_char(p_summary_tax_line_id));
78:
79: FND_LOG.STRING(g_level_procedure,

Line 79: FND_LOG.STRING(g_level_procedure,

75: FND_LOG.STRING(g_level_procedure,
76: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
77: 'Summary Tax Line Id: '|| to_char(p_summary_tax_line_id));
78:
79: FND_LOG.STRING(g_level_procedure,
80: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
81: 'Trx Id: '|| to_char(p_trx_id));
82: END IF;
83:

Line 413: FND_LOG.STRING(g_level_procedure,

409:
410: END IF;
411:
412: IF (g_level_procedure >= g_current_runtime_level ) THEN
413: FND_LOG.STRING(g_level_procedure,
414: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
415: 'Insert into zx_lines for allocation of lines. (-)');
416: END IF;
417:

Line 419: FND_LOG.STRING(g_level_procedure,

415: 'Insert into zx_lines for allocation of lines. (-)');
416: END IF;
417:
418: IF (g_level_procedure >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_procedure,
420: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row.END',
421: 'Insert_Row (-)');
422: END IF;
423: EXCEPTION

Line 445: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

441: l_unrounded_tax_amt NUMBER;
442:
443: BEGIN
444:
445: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
446:
447: IF (g_level_procedure >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_procedure,
449: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.BEGIN',

Line 448: FND_LOG.STRING(g_level_procedure,

444:
445: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
446:
447: IF (g_level_procedure >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_procedure,
449: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.BEGIN',
450: 'Update_tax_amt (+)');
451: END IF;
452:

Line 461: FND_LOG.STRING(g_level_procedure,

457: l_unrounded_tax_amt :=0;
458:
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.Update_tax_amt',
463: 'Update tax_amount in zx_lines for allocation of lines. (+)');
464: END IF;
465:

Line 472: FND_LOG.STRING(g_level_statement,

468: FROM ZX_LINES_SUMMARY
469: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
470:
471: IF (g_level_statement >= g_current_runtime_level ) THEN
472: FND_LOG.STRING(g_level_statement,
473: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
474: 'Summary tax amount '||to_char(l_summary_tax_amt));
475: END IF;
476: SELECT SUM(LINE_AMT)

Line 486: FND_LOG.STRING(g_level_statement,

482: AND EVENT_CLASS_CODE = p_event_class_code
483: AND TRX_ID = p_trx_id;
484:
485: IF (g_level_statement >= g_current_runtime_level ) THEN
486: FND_LOG.STRING(g_level_statement,
487: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
488: 'total trx line amount '||to_char(l_total_trx_line_amt));
489: END IF;
490:

Line 501: FND_LOG.STRING(g_level_statement,

497: AND EVENT_CLASS_CODE = p_event_class_code
498: AND TRX_ID = p_trx_id;
499:
500: IF (g_level_statement >= g_current_runtime_level ) THEN
501: FND_LOG.STRING(g_level_statement,
502: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
503: 'total trxline amt'||to_char(l_total_trx_line_amt)||' unrounded amt '||to_char(l_unrounded_tax_amt)||'summary tax amount '||to_char(l_summary_tax_amt));
504: END IF;
505: IF l_total_trx_line_amt <> 0 THEN

Line 518: FND_LOG.STRING(g_level_procedure,

514: END IF;
515:
516:
517: IF (g_level_procedure >= g_current_runtime_level ) THEN
518: FND_LOG.STRING(g_level_procedure,
519: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
520: 'Update tax_amount in zx_lines for allocation of lines. (-)');
521: END IF;
522:

Line 524: FND_LOG.STRING(g_level_procedure,

520: 'Update tax_amount in zx_lines for allocation of lines. (-)');
521: END IF;
522:
523: IF (g_level_procedure >= g_current_runtime_level ) THEN
524: FND_LOG.STRING(g_level_procedure,
525: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt.END',
526: 'Update_tax_amt (-)');
527: END IF;
528: END Update_tax_amt;

Line 541: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

537: ALLOC EmpCurTyp;
538:
539: BEGIN
540:
541: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
542:
543: i := 0;
544:
545: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 546: FND_LOG.STRING(g_level_procedure,

542:
543: i := 0;
544:
545: IF (g_level_procedure >= g_current_runtime_level ) THEN
546: FND_LOG.STRING(g_level_procedure,
547: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.BEGIN',
548: 'Populate_Allocation (+)');
549: END IF;
550:

Line 569: FND_LOG.STRING(g_level_procedure,

565:
566: CLOSE ALLOC;
567:
568: IF (g_level_procedure >= g_current_runtime_level ) THEN
569: FND_LOG.STRING(g_level_procedure,
570: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Populate_Allocation.END',
571: 'Populate_Allocation (-)');
572: END IF;
573:

Line 641: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

637: l_insert BOOLEAN ;
638:
639: BEGIN
640:
641: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
642:
643: IF (g_level_procedure >= g_current_runtime_level ) THEN
644: FND_LOG.STRING(g_level_procedure,
645: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.BEGIN',

Line 644: FND_LOG.STRING(g_level_procedure,

640:
641: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
642:
643: IF (g_level_procedure >= g_current_runtime_level ) THEN
644: FND_LOG.STRING(g_level_procedure,
645: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.BEGIN',
646: 'Insert_All_Allocation (+)');
647: END IF;
648:

Line 671: FND_LOG.STRING(g_level_statement,

667:
668: IF p_allocate_flag = 'Y' THEN
669: l_key := to_char(p_summary_tax_line_id)||to_char(v_trx_id)||to_char(v_trx_line_id);
670: IF (g_level_statement >= g_current_runtime_level ) THEN
671: FND_LOG.STRING(g_level_statement,
672: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
673: 'key : ' || l_key) ;
674: END IF;
675: IF g_trx_allocate_tbl.exists(l_key) THEN

Line 677: FND_LOG.STRING(g_level_statement,

673: 'key : ' || l_key) ;
674: END IF;
675: IF g_trx_allocate_tbl.exists(l_key) THEN
676: IF (g_level_statement >= g_current_runtime_level ) THEN
677: FND_LOG.STRING(g_level_statement,
678: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
679: 'allocate true : ') ;
680: END IF;
681: l_insert := TRUE;

Line 700: FND_LOG.STRING(g_level_procedure,

696: AND TRX_LINE_ID = v_trx_line_id
697: AND TRX_LEVEL_TYPE = v_trx_level_type;
698:
699: IF (g_level_procedure >= g_current_runtime_level ) THEN
700: FND_LOG.STRING(g_level_procedure,
701: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
702: 'line amt : ' || to_char(v_line_amt)) ;
703: END IF;
704: select tax_id

Line 711: FND_LOG.STRING(g_level_procedure,

707: WHERE TAX_REGIME_CODE = p_tax_regime_code
708: AND TAX=p_tax;
709:
710: IF (g_level_procedure >= g_current_runtime_level ) THEN
711: FND_LOG.STRING(g_level_procedure,
712: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
713: 'tax id : ' || to_char(l_tax_id)) ;
714: END IF;
715:

Line 727: FND_LOG.STRING(g_level_procedure,

723: WHERE tax_regime_code = p_tax_regime_code and tax = p_tax and
724: tax_status_code = p_tax_status_code ;
725:
726: IF (g_level_procedure >= g_current_runtime_level ) THEN
727: FND_LOG.STRING(g_level_procedure,
728: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
729: 'status id : ' || to_char(l_status_id)) ;
730: END IF;
731:

Line 737: FND_LOG.STRING(g_level_procedure,

733: INTO l_tax_line_id
734: FROM dual;
735:
736: IF (g_level_procedure >= g_current_runtime_level ) THEN
737: FND_LOG.STRING(g_level_procedure,
738: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
739: 'line amt : ' || to_char(v_line_amt)) ;
740: END IF;
741:

Line 1071: FND_LOG.STRING(g_level_procedure,

1067:
1068:
1069:
1070: IF (g_level_procedure >= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_procedure,
1072: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG. Insert_All_Allocation.END',
1073: 'Insert_All_Allocation (-)');
1074: END IF;
1075:

Line 1172: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1168:
1169:
1170: BEGIN
1171:
1172: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1173:
1174: IF (g_level_procedure >= g_current_runtime_level ) THEN
1175: FND_LOG.STRING(g_level_procedure,
1176: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',

Line 1175: FND_LOG.STRING(g_level_procedure,

1171:
1172: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1173:
1174: IF (g_level_procedure >= g_current_runtime_level ) THEN
1175: FND_LOG.STRING(g_level_procedure,
1176: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',
1177: 'Insert_Tax_Line (+)');
1178: END IF;
1179:

Line 1205: FND_LOG.STRING(g_level_statement,

1201:
1202: END IF;
1203:
1204: IF (g_level_statement >= g_current_runtime_level ) THEN
1205: FND_LOG.STRING(g_level_statement,
1206: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1207: 'event type code ' || p_event_type_code) ;
1208: FND_LOG.STRING(g_level_statement,
1209: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1208: FND_LOG.STRING(g_level_statement,

1204: IF (g_level_statement >= g_current_runtime_level ) THEN
1205: FND_LOG.STRING(g_level_statement,
1206: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1207: 'event type code ' || p_event_type_code) ;
1208: FND_LOG.STRING(g_level_statement,
1209: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1210: 'legal entity id' || to_char(p_legal_entity_id)) ;
1211: FND_LOG.STRING(g_level_statement,
1212: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1211: FND_LOG.STRING(g_level_statement,

1207: 'event type code ' || p_event_type_code) ;
1208: FND_LOG.STRING(g_level_statement,
1209: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1210: 'legal entity id' || to_char(p_legal_entity_id)) ;
1211: FND_LOG.STRING(g_level_statement,
1212: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1213: 'ledger id' || to_char(p_ledger_id)) ;
1214: FND_LOG.STRING(g_level_statement,
1215: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1214: FND_LOG.STRING(g_level_statement,

1210: 'legal entity id' || to_char(p_legal_entity_id)) ;
1211: FND_LOG.STRING(g_level_statement,
1212: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1213: 'ledger id' || to_char(p_ledger_id)) ;
1214: FND_LOG.STRING(g_level_statement,
1215: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1216: 'trx_currency_code ' || p_trx_currency_code) ;
1217: FND_LOG.STRING(g_level_statement,
1218: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',

Line 1217: FND_LOG.STRING(g_level_statement,

1213: 'ledger id' || to_char(p_ledger_id)) ;
1214: FND_LOG.STRING(g_level_statement,
1215: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1216: 'trx_currency_code ' || p_trx_currency_code) ;
1217: FND_LOG.STRING(g_level_statement,
1218: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1219: 'content owner id ' || p_content_owner_id) ;
1220: END IF;
1221:

Line 1249: FND_LOG.STRING(g_level_unexpected,

1245:
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1249: FND_LOG.STRING(g_level_unexpected,
1250: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1251: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1252: FND_LOG.STRING(g_level_unexpected,
1253: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1252: FND_LOG.STRING(g_level_unexpected,

1248: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1249: FND_LOG.STRING(g_level_unexpected,
1250: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1251: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1252: FND_LOG.STRING(g_level_unexpected,
1253: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1254: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1255: END IF;
1256:

Line 1261: FND_LOG.STRING(g_level_procedure,

1257: RETURN;
1258:
1259: END;
1260: IF (g_level_procedure >= g_current_runtime_level ) THEN
1261: FND_LOG.STRING(g_level_procedure,
1262: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1263: 'tax id : ' || to_char(l_tax_id)) ;
1264: END IF;
1265:

Line 1276: FND_LOG.STRING(g_level_unexpected,

1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1276: FND_LOG.STRING(g_level_unexpected,
1277: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1278: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1279: FND_LOG.STRING(g_level_unexpected,
1280: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1279: FND_LOG.STRING(g_level_unexpected,

1275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1276: FND_LOG.STRING(g_level_unexpected,
1277: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1278: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1279: FND_LOG.STRING(g_level_unexpected,
1280: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1281: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1282: END IF;
1283:

Line 1300: FND_LOG.STRING(g_level_unexpected,

1296:
1297: EXCEPTION
1298: WHEN OTHERS THEN
1299: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1300: FND_LOG.STRING(g_level_unexpected,
1301: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1302: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1303: FND_LOG.STRING(g_level_unexpected,
1304: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1303: FND_LOG.STRING(g_level_unexpected,

1299: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1300: FND_LOG.STRING(g_level_unexpected,
1301: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1302: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1303: FND_LOG.STRING(g_level_unexpected,
1304: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1305: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1306: END IF;
1307:

Line 1333: FND_LOG.STRING(g_level_unexpected,

1329:
1330: EXCEPTION
1331: WHEN OTHERS THEN
1332: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1333: FND_LOG.STRING(g_level_unexpected,
1334: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1335: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1336: FND_LOG.STRING(g_level_unexpected,
1337: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',

Line 1336: FND_LOG.STRING(g_level_unexpected,

1332: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1333: FND_LOG.STRING(g_level_unexpected,
1334: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line',
1335: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1336: FND_LOG.STRING(g_level_unexpected,
1337: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.insert_tax_line.END',
1338: 'ZX_TRL_ALLOCATIONS_PKG.insert_tax_line(-)');
1339: END IF;
1340:

Line 1350: FND_LOG.STRING(g_level_procedure,

1346: INTO l_tax_line_id
1347: FROM dual;
1348:
1349: IF (g_level_procedure >= g_current_runtime_level ) THEN
1350: FND_LOG.STRING(g_level_procedure,
1351: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1352: 'status id : ' || to_char(l_status_id)) ;
1353: END IF;
1354:

Line 1357: FND_LOG.STRING(g_level_procedure,

1353: END IF;
1354:
1355:
1356: IF (g_level_procedure >= g_current_runtime_level ) THEN
1357: FND_LOG.STRING(g_level_procedure,
1358: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation.',
1359: 'Trx Line Id: '||to_char(l_trx_line_id));
1360: END IF;
1361:

Line 1760: FND_LOG.STRING(g_level_procedure,

1756:
1757: END IF;
1758:
1759: IF (g_level_procedure >= g_current_runtime_level ) THEN
1760: FND_LOG.STRING(g_level_procedure,
1761: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Tax_Line.BEGIN',
1762: 'Insert_Tax_Line (-)');
1763: END IF;
1764:

Line 1774: FND_LOG.STRING(g_level_statement,

1770:
1771: PROCEDURE Populate_alloc_tbl(p_key IN VARCHAR2) IS
1772: BEGIN
1773: IF (g_level_statement >= g_current_runtime_level ) THEN
1774: FND_LOG.STRING(g_level_statement,
1775: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
1776: 'key : ' || p_key) ;
1777: END IF;
1778: g_trx_allocate_tbl(p_key) := 'Y';