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.AHL_WIP_JOB_PVT dependencies on AHL_WIP_JOB_PVT

Line 1: PACKAGE BODY ahl_wip_job_pvt AS

1: PACKAGE BODY ahl_wip_job_pvt AS
2: /* $Header: AHLVWIPB.pls 120.1.12000000.2 2007/08/09 10:42:13 adivenka ship $ */
3:
4: -- Define Global Type --
5: TYPE num_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WIP_JOB_PVT';

4: -- Define Global Type --
5: TYPE num_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6:
7: -- Define Global Variable --
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WIP_JOB_PVT';
9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
10:
11: -- Define Global Cursors --
12: CURSOR job_header_exists(c_group_id NUMBER, c_parent_header_id NUMBER) IS

Line 911: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

907: --Savepoint here is not necessary, because we have a commit statement in its called
908: --procedure submit_wip_load and it will make this savepoint invalid.
909: IF G_DEBUG='Y' THEN
910: AHL_DEBUG_PUB.enable_debug;
911: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
912: END IF;
913: IF FND_API.to_boolean(p_init_msg_list) THEN
914: FND_MSG_PUB.initialize;
915: END IF;

Line 1105: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1101:
1102: COMMIT; --Autonomous Transaction Required
1103:
1104: IF G_DEBUG='Y' THEN
1105: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1106: AHL_DEBUG_PUB.disable_debug;
1107: END IF;
1108: EXCEPTION
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1118: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1114: p_data => x_msg_data);
1115: IF G_DEBUG='Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1117: 'UNEXPECTED ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK;

Line 1130: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1126: p_data => x_msg_data);
1127: IF G_DEBUG='Y' THEN
1128: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1129: 'ERROR IN PRIVATE:' );
1130: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1131: AHL_DEBUG_PUB.disable_debug;
1132: END IF;
1133: WHEN OTHERS THEN
1134: ROLLBACK;

Line 1137: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_WIP_JOB_PVT',

1133: WHEN OTHERS THEN
1134: ROLLBACK;
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1137: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_WIP_JOB_PVT',
1138: p_procedure_name => 'LOAD_WIP_JOB');
1139: END IF;
1140: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,

Line 1146: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1142: p_data => x_msg_data);
1143: IF G_DEBUG='Y' THEN
1144: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1145: 'OTHER ERROR IN PRIVATE:' );
1146: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;
1149:
1150: END load_wip_job;

Line 1255: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1251: BEGIN
1252: SAVEPOINT INSERT_RESOURCE_TXN_PVT;
1253: IF G_DEBUG='Y' THEN
1254: AHL_DEBUG_PUB.enable_debug;
1255: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1256: END IF;
1257: IF FND_API.to_boolean(p_init_msg_list) THEN
1258: FND_MSG_PUB.initialize;
1259: END IF;

Line 1508: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1504: IF FND_API.TO_BOOLEAN(p_commit) THEN
1505: COMMIT;
1506: END IF;
1507: IF G_DEBUG='Y' THEN
1508: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1509: AHL_DEBUG_PUB.disable_debug;
1510: END IF;
1511:
1512: EXCEPTION

Line 1522: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1518: p_data => x_msg_data);
1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1521: 'UNEXPECTED ERROR IN PRIVATE:' );
1522: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1523: AHL_DEBUG_PUB.disable_debug;
1524: END IF;
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;

Line 1534: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1530: p_data => x_msg_data);
1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1533: 'ERROR IN PRIVATE:' );
1534: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1535: AHL_DEBUG_PUB.disable_debug;
1536: END IF;
1537: WHEN OTHERS THEN
1538: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;

Line 1541: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_WIP_JOB_PVT',

1537: WHEN OTHERS THEN
1538: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1541: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_WIP_JOB_PVT',
1542: p_procedure_name => 'INSERT_RESOURCE_TXN');
1543: END IF;
1544: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1545: p_count => x_msg_count,

Line 1550: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1546: p_data => x_msg_data);
1547: IF G_DEBUG='Y' THEN
1548: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1549: 'OTHER ERROR IN PRIVATE:' );
1550: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1551: AHL_DEBUG_PUB.disable_debug;
1552: END IF;
1553:
1554: END insert_resource_txn;

Line 1647: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1643: --Savepoint here is not necessary, because we have a commit statement in its called
1644: --procedure submit_wip_load and it will make this savepoint invalid.
1645: IF G_DEBUG='Y' THEN
1646: AHL_DEBUG_PUB.enable_debug;
1647: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1648: END IF;
1649: IF FND_API.to_boolean(p_init_msg_list) THEN
1650: FND_MSG_PUB.initialize;
1651: END IF;

Line 1867: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1863:
1864: COMMIT; --Autonomous Transaction Required
1865:
1866: IF G_DEBUG='Y' THEN
1867: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1868: AHL_DEBUG_PUB.disable_debug;
1869: END IF;
1870: EXCEPTION
1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1880: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1876: p_data => x_msg_data);
1877: IF G_DEBUG='Y' THEN
1878: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1879: 'UNEXPECTED ERROR IN PRIVATE:' );
1880: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1881: AHL_DEBUG_PUB.disable_debug;
1882: END IF;
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: ROLLBACK;

Line 1892: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1888: p_data => x_msg_data);
1889: IF G_DEBUG='Y' THEN
1890: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1891: 'ERROR IN PRIVATE:' );
1892: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1893: AHL_DEBUG_PUB.disable_debug;
1894: END IF;
1895: WHEN OTHERS THEN
1896: ROLLBACK;

Line 1899: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_WIP_JOB_PVT',

1895: WHEN OTHERS THEN
1896: ROLLBACK;
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1899: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_WIP_JOB_PVT',
1900: p_procedure_name => 'LOAD_WIP_BATCH_JOBS');
1901: END IF;
1902: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1903: p_count => x_msg_count,

Line 1908: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1904: p_data => x_msg_data);
1905: IF G_DEBUG='Y' THEN
1906: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1907: 'OTHER ERROR IN PRIVATE:' );
1908: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1909: AHL_DEBUG_PUB.disable_debug;
1910: END IF;
1911:
1912: END load_wip_batch_jobs;

Line 1914: END AHL_WIP_JOB_PVT; -- Package Body

1910: END IF;
1911:
1912: END load_wip_batch_jobs;
1913:
1914: END AHL_WIP_JOB_PVT; -- Package Body