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.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;

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:
75: FND_LOG.STRING(g_level_procedure,
76: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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

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,
80: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',

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

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:
84: IF p_enabled_record ='Y' THEN

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

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

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

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

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

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:
453: l_total_tax_amt :=0;

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

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:
466: SELECT TAX_AMT

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

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)
477: INTO l_total_trx_line_amt

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

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:
491: SELECT SUM(unrounded_tax_amt)

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

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
506: UPDATE ZX_LINES

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

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

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

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

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

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

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

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

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

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:
649: l_insert := TRUE;

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

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

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

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

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

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
705: INTO l_tax_id

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

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:
716: select tax_regime_id

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

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:
732: SELECT zx_lines_s.nextval

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

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

Line 1061: ZX_TRL_ALLOCATIONS_PKG.Update_Tax_Amt

1057: END LOOP;
1058:
1059: CLOSE ALLOC;
1060:
1061: ZX_TRL_ALLOCATIONS_PKG.Update_Tax_Amt
1062: (p_summary_tax_line_id => p_summary_tax_line_id,
1063: p_application_id => p_application_id,
1064: p_entity_code => p_entity_code,
1065: p_event_class_code => p_event_class_code,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
1257: RETURN;
1258:

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

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

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

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

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

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

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

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:
1284: RETURN;
1285:

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

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

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

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

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

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:
1308: RETURN;
1309:

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

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

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

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

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

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:
1341: RETURN;
1342:

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

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

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

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

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

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

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

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

Line 1783: END ZX_TRL_ALLOCATIONS_PKG;

1779: EXCEPTION
1780: WHEN others THEN
1781: NULL;
1782: END;
1783: END ZX_TRL_ALLOCATIONS_PKG;