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

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

1: PACKAGE BODY ZX_TRL_DISTRIBUTIONS_PKG AS
2: /* $Header: zxridistribnpkgb.pls 120.40.12010000.1 2008/07/28 13:36:06 appldev 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: zxridistribnpkgb.pls 120.40.12010000.1 2008/07/28 13:36:06 appldev 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_rec_nrec_tax_dist_id NUMBER,

Line 183: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

179: p_last_update_date DATE,
180: p_last_update_login NUMBER) IS
181:
182: BEGIN
183: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
184:
185: IF (g_level_procedure >= g_current_runtime_level ) THEN
186: FND_LOG.STRING(g_level_procedure,
187: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Insert_Row.BEGIN',

Line 186: FND_LOG.STRING(g_level_procedure,

182: BEGIN
183: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
184:
185: IF (g_level_procedure >= g_current_runtime_level ) THEN
186: FND_LOG.STRING(g_level_procedure,
187: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Insert_Row.BEGIN',
188: 'ZX_TRL_DISTRIBUTIONS_PKG: Insert_Row (+)');
189: END IF;
190:

Line 192: FND_LOG.STRING(g_level_procedure,

188: 'ZX_TRL_DISTRIBUTIONS_PKG: Insert_Row (+)');
189: END IF;
190:
191: IF (g_level_procedure >= g_current_runtime_level ) THEN
192: FND_LOG.STRING(g_level_procedure,
193: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Insert_Row.END',
194: 'ZX_TRL_DISTRIBUTIONS_PKG: Insert_Row (-)');
195: END IF;
196:

Line 547: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

543:
544: Recinfo dist_csr%ROWTYPE;
545:
546: BEGIN
547: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
548:
549: IF (g_level_procedure >= g_current_runtime_level ) THEN
550: FND_LOG.STRING(g_level_procedure,
551: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Lock_Row.BEGIN',

Line 550: FND_LOG.STRING(g_level_procedure,

546: BEGIN
547: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
548:
549: IF (g_level_procedure >= g_current_runtime_level ) THEN
550: FND_LOG.STRING(g_level_procedure,
551: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Lock_Row.BEGIN',
552: 'ZX_TRL_DISTRIBUTIONS_PKG: Lock_Row (+)');
553: END IF;
554:

Line 1035: FND_LOG.STRING(g_level_procedure,

1031: APP_EXCEPTION.Raise_Exception;
1032: END IF;
1033:
1034: IF (g_level_procedure >= g_current_runtime_level ) THEN
1035: FND_LOG.STRING(g_level_procedure,
1036: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Lock_Row.END',
1037: 'ZX_TRL_DISTRIBUTIONS_PKG: Lock_Row (-)');
1038: END IF;
1039: END Lock_Row;

Line 1215: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1211: l_rec_nrec_rate NUMBER;
1212: l_return_status VARCHAR2(1000);
1213:
1214: BEGIN
1215: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1216:
1217: IF (g_level_procedure >= g_current_runtime_level ) THEN
1218: FND_LOG.STRING(g_level_procedure,
1219: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row.BEGIN',

Line 1218: FND_LOG.STRING(g_level_procedure,

1214: BEGIN
1215: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1216:
1217: IF (g_level_procedure >= g_current_runtime_level ) THEN
1218: FND_LOG.STRING(g_level_procedure,
1219: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row.BEGIN',
1220: 'ZX_TRL_DISTRIBUTIONS_PKG: Update_Row (+)');
1221: END IF;
1222:

Line 1224: FND_LOG.STRING(g_level_procedure,

1220: 'ZX_TRL_DISTRIBUTIONS_PKG: Update_Row (+)');
1221: END IF;
1222:
1223: IF (g_level_procedure >= g_current_runtime_level ) THEN
1224: FND_LOG.STRING(g_level_procedure,
1225: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1226: 'Update for reverse dist ZX_TAX_DIST_ID_GT (+)');
1227: END IF;
1228:

Line 1238: FND_LOG.STRING(g_level_procedure,

1234:
1235: l_unrounded_rec_nrec_tax_amt := (p_trx_line_dist_tax_amt * p_rec_nrec_rate)/100;
1236:
1237: IF (g_level_procedure >= g_current_runtime_level ) THEN
1238: FND_LOG.STRING(g_level_procedure,
1239: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1240: 'l_unrounded_rec_nrec_tax_amt :'||l_unrounded_rec_nrec_tax_amt);
1241:
1242: FND_LOG.STRING(g_level_procedure,

Line 1242: FND_LOG.STRING(g_level_procedure,

1238: FND_LOG.STRING(g_level_procedure,
1239: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1240: 'l_unrounded_rec_nrec_tax_amt :'||l_unrounded_rec_nrec_tax_amt);
1241:
1242: FND_LOG.STRING(g_level_procedure,
1243: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1244: 'Update ZX_REC_NREC_DIST (+)');
1245: END IF;
1246:

Line 1279: FND_LOG.STRING(g_level_procedure,

1275: last_update_login = fnd_global.login_id
1276: WHERE REC_NREC_TAX_DIST_ID = p_rec_nrec_tax_dist_id;
1277:
1278: IF (g_level_procedure >= g_current_runtime_level ) THEN
1279: FND_LOG.STRING(g_level_procedure,
1280: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1281: 'Update ZX_REC_NREC_DIST (-)');
1282: END IF;
1283:

Line 1285: FND_LOG.STRING(g_level_procedure,

1281: 'Update ZX_REC_NREC_DIST (-)');
1282: END IF;
1283:
1284: IF (g_level_procedure >= g_current_runtime_level ) THEN
1285: FND_LOG.STRING(g_level_procedure,
1286: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1287: 'Update for Non recoverable ZX_REC_NREC_DIST (+)');
1288: END IF;
1289:

Line 1320: FND_LOG.STRING(g_level_procedure,

1316: AND NVL(FREEZE_FLAG, 'N') = 'N'
1317: AND NVL(REVERSE_FLAG, 'N') = 'N';
1318:
1319: IF (g_level_procedure >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_procedure,
1321: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1322: 'Update for Non recoverable ZX_REC_NREC_DIST (-)');
1323: END IF;
1324:

Line 1328: FND_LOG.STRING(g_level_procedure,

1324:
1325: END IF; -- reverse flag
1326:
1327: IF (g_level_procedure >= g_current_runtime_level ) THEN
1328: FND_LOG.STRING(g_level_procedure,
1329: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1330: 'Update for reverse dist ZX_TAX_DIST_ID_GT (-)');
1331: END IF;
1332:

Line 1334: FND_LOG.STRING(g_level_procedure,

1330: 'Update for reverse dist ZX_TAX_DIST_ID_GT (-)');
1331: END IF;
1332:
1333: IF (g_level_procedure >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_procedure,
1335: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row.END',
1336: 'ZX_TRL_DISTRIBUTIONS_PKG.Update_Row (-)');
1337: END IF;
1338:

Line 1350: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1346: p_last_update_date DATE,
1347: p_last_update_login NUMBER) IS
1348:
1349: BEGIN
1350: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1351:
1352: IF (g_level_procedure >= g_current_runtime_level ) THEN
1353: FND_LOG.STRING(g_level_procedure,
1354: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Delete_Row.BEGIN',

Line 1353: FND_LOG.STRING(g_level_procedure,

1349: BEGIN
1350: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1351:
1352: IF (g_level_procedure >= g_current_runtime_level ) THEN
1353: FND_LOG.STRING(g_level_procedure,
1354: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Delete_Row.BEGIN',
1355: 'ZX_TRL_DISTRIBUTIONS_PKG: Delete_Row (+)');
1356: END IF;
1357:

Line 1361: FND_LOG.STRING(g_level_procedure,

1357:
1358: NULL;
1359:
1360: IF (g_level_procedure >= g_current_runtime_level ) THEN
1361: FND_LOG.STRING(g_level_procedure,
1362: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Delete_Row.END',
1363: 'ZX_TRL_DISTRIBUTIONS_PKG: Delete_Row (-)');
1364: END IF;
1365: END Delete_Row;

Line 1383: FND_LOG.STRING(g_level_procedure,

1379:
1380: BEGIN
1381:
1382: IF (g_level_procedure >= g_current_runtime_level ) THEN
1383: FND_LOG.STRING(g_level_procedure,
1384: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Override_Recovery',
1385: 'Calling ZX_TRD_SERVICE_PUB_PKG.override_recovery (+)');
1386: END IF;
1387:

Line 1406: FND_LOG.STRING(g_level_procedure,

1402: p_transaction_rec => l_transaction_rec_type);
1403:
1404: IF (g_level_procedure >= g_current_runtime_level ) THEN
1405:
1406: FND_LOG.STRING(g_level_procedure,
1407: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Override_Recovery',
1408: 'Return Status = ' || l_return_status);
1409:
1410: FND_LOG.STRING(g_level_procedure,

Line 1410: FND_LOG.STRING(g_level_procedure,

1406: FND_LOG.STRING(g_level_procedure,
1407: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Override_Recovery',
1408: 'Return Status = ' || l_return_status);
1409:
1410: FND_LOG.STRING(g_level_procedure,
1411: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Override_Recovery',
1412: 'Message Data = ' || l_msg_data);
1413:
1414: END IF;

Line 1417: FND_LOG.STRING(g_level_procedure,

1413:
1414: END IF;
1415:
1416: IF (g_level_procedure >= g_current_runtime_level ) THEN
1417: FND_LOG.STRING(g_level_procedure,
1418: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Override_Recovery',
1419: 'Calling ZX_TRD_SERVICE_PUB_PKG.override_recovery (-)');
1420: END IF;
1421:

Line 1431: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1427: l_tax_dist NUMBER;
1428: l_return_status VARCHAR2(1000);
1429:
1430: BEGIN
1431: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1432:
1433: IF (g_level_procedure >= g_current_runtime_level ) THEN
1434: FND_LOG.STRING(g_level_procedure,
1435: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row.BEGIN',

Line 1434: FND_LOG.STRING(g_level_procedure,

1430: BEGIN
1431: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1432:
1433: IF (g_level_procedure >= g_current_runtime_level ) THEN
1434: FND_LOG.STRING(g_level_procedure,
1435: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row.BEGIN',
1436: 'ZX_TRL_DISTRIBUTIONS_PKG: Reverse_Row (+)');
1437: END IF;
1438:

Line 1447: FND_LOG.STRING(g_level_procedure,

1443: IF l_tax_dist > 0 THEN
1444: BEGIN
1445:
1446: IF (g_level_procedure >= g_current_runtime_level ) THEN
1447: FND_LOG.STRING(g_level_procedure,
1448: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1449: 'Call to zx_trd_service_pub_pkg.reverse_tax_dist (+)');
1450: END IF;
1451:

Line 1457: FND_LOG.STRING(g_level_unexpected,

1453: x_return_status => l_return_status);
1454:
1455: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1456: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1457: FND_LOG.STRING(g_level_unexpected,
1458: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1459: 'Incorrect return_status after calling ' ||
1460: 'Insert into ZX_REC_NREC_DIST');
1461: END IF;

Line 1468: FND_LOG.STRING(g_level_procedure,

1464:
1465: END IF;
1466:
1467: IF (g_level_procedure >= g_current_runtime_level ) THEN
1468: FND_LOG.STRING(g_level_procedure,
1469: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1470: 'Call to zx_trd_service_pub_pkg.reverse_tax_dist (-)');
1471: END IF;
1472:

Line 1474: FND_LOG.STRING(g_level_procedure,

1470: 'Call to zx_trd_service_pub_pkg.reverse_tax_dist (-)');
1471: END IF;
1472:
1473: IF (g_level_procedure >= g_current_runtime_level ) THEN
1474: FND_LOG.STRING(g_level_procedure,
1475: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1476: 'Delete from ZX_REC_NREC_DIST (+)');
1477: END IF;
1478:

Line 1484: FND_LOG.STRING(g_level_procedure,

1480: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID
1481: FROM ZX_TAX_DIST_ID_GT);
1482:
1483: IF (g_level_procedure >= g_current_runtime_level ) THEN
1484: FND_LOG.STRING(g_level_procedure,
1485: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1486: 'Delete from ZX_REC_NREC_DIST (-)');
1487: END IF;
1488:

Line 1490: FND_LOG.STRING(g_level_procedure,

1486: 'Delete from ZX_REC_NREC_DIST (-)');
1487: END IF;
1488:
1489: IF (g_level_procedure >= g_current_runtime_level ) THEN
1490: FND_LOG.STRING(g_level_procedure,
1491: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1492: 'Insert into ZX_REC_NREC_DIST (+)');
1493: END IF;
1494:

Line 1500: FND_LOG.STRING(g_level_procedure,

1496:
1497: INSERT INTO ZX_REC_NREC_DIST VALUES l_rec_nrec_dist_tbl(i);
1498:
1499: IF (g_level_procedure >= g_current_runtime_level ) THEN
1500: FND_LOG.STRING(g_level_procedure,
1501: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1502: 'Insert into ZX_REC_NREC_DIST (-)');
1503: END IF;
1504:

Line 1506: FND_LOG.STRING(g_level_procedure,

1502: 'Insert into ZX_REC_NREC_DIST (-)');
1503: END IF;
1504:
1505: IF (g_level_procedure >= g_current_runtime_level ) THEN
1506: FND_LOG.STRING(g_level_procedure,
1507: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row.END',
1508: 'ZX_TRL_DISTRIBUTIONS_PKG: Reverse_Row (-)');
1509: END IF;
1510: END;

Line 1520: FND_LOG.STRING(g_level_procedure,

1516: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1517: FND_MSG_PUB.Add;
1518:
1519: IF (g_level_procedure >= g_current_runtime_level ) THEN
1520: FND_LOG.STRING(g_level_procedure,
1521: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1522: 'Exception:' ||SQLCODE||';'||SQLERRM);
1523: END IF;
1524:

Line 1553: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1549:
1550: BEGIN
1551: x_return_status := FND_API.G_RET_STS_SUCCESS;
1552:
1553: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1554:
1555: IF (g_level_procedure >= g_current_runtime_level ) THEN
1556: FND_LOG.STRING(g_level_procedure,
1557: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_rec_nrec_dist_for_doc.BEGIN',

Line 1556: FND_LOG.STRING(g_level_procedure,

1552:
1553: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1554:
1555: IF (g_level_procedure >= g_current_runtime_level ) THEN
1556: FND_LOG.STRING(g_level_procedure,
1557: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_rec_nrec_dist_for_doc.BEGIN',
1558: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_rec_nrec_dist_for_doc (+)');
1559: END IF;
1560:

Line 1568: FND_LOG.STRING(g_level_procedure,

1564: p_trx_id);
1565: CLOSE lock_tax_dist_for_doc_csr;
1566:
1567: IF (g_level_procedure >= g_current_runtime_level ) THEN
1568: FND_LOG.STRING(g_level_procedure,
1569: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_rec_nrec_dist_for_doc.END',
1570: 'ZX_TRL_SUMMARY_OVERRIDE_PKG: lock_rec_nrec_dist_for_doc(-)');
1571: END IF;
1572: EXCEPTION

Line 1581: FND_LOG.STRING(g_level_procedure,

1577: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1578: FND_MSG_PUB.Add;
1579:
1580: IF (g_level_procedure >= g_current_runtime_level ) THEN
1581: FND_LOG.STRING(g_level_procedure,
1582: 'ZX.PLSQL.ZX_TRL_SUMMARY_OVERRIDE_PKG.lock_rec_nrec_dist_for_doc',
1583: 'Exception:' ||x_error_buffer);
1584: END IF;
1585: END lock_rec_nrec_dist_for_doc;