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

Line 1: PACKAGE BODY EAM_Downtime_PUB as

1: PACKAGE BODY EAM_Downtime_PUB as
2: /* $Header: EAMPEQDB.pls 120.2 2006/01/19 18:48:17 hkarmach noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_Downtime_PUB';
5: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('EAM_DEBUG'), 'N');

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_Downtime_PUB';

1: PACKAGE BODY EAM_Downtime_PUB as
2: /* $Header: EAMPEQDB.pls 120.2 2006/01/19 18:48:17 hkarmach noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_Downtime_PUB';
5: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('EAM_DEBUG'), 'N');
6: g_reason_code varchar2(80):=null;
7:
8:

Line 272: l_err_code := 'Error: EAM_Downtime_Pub.Load_Downtime()';

268: p_msg_count => l_msg_count,
269: p_msg_data => l_msg_data,
270: x_return_status => l_msg_return_status);
271: IF p_run_option = 1 THEN
272: l_err_code := 'Error: EAM_Downtime_Pub.Load_Downtime()';
273: ELSE
274: l_err_code := 'Error: EAM_Downtime_Pub.Purge_Downtime()';
275: END IF;
276: RAISE process_error;

Line 274: l_err_code := 'Error: EAM_Downtime_Pub.Purge_Downtime()';

270: x_return_status => l_msg_return_status);
271: IF p_run_option = 1 THEN
272: l_err_code := 'Error: EAM_Downtime_Pub.Load_Downtime()';
273: ELSE
274: l_err_code := 'Error: EAM_Downtime_Pub.Purge_Downtime()';
275: END IF;
276: RAISE process_error;
277: END IF;
278:

Line 282: l_err_msg :='EAM_Downtime_PUB.Process_Production_Downtime ('

278:
279: EXCEPTION
280: WHEN process_error THEN
281: ROLLBACK to ProcessProductionDowntime_PUB;
282: l_err_msg :='EAM_Downtime_PUB.Process_Production_Downtime ('
283: || TO_CHAR(l_stmt_num)
284: || '):'
285: || l_err_code;
286: FND_FILE.put_line(FND_FILE.log,l_err_msg);

Line 294: l_err_msg := SUBSTR('EAM_Downtime_PUB.Process_Production_Downtime ('

290: WHEN OTHERS THEN
291: ROLLBACK to ProcessProductionDowntime_PUB;
292: l_err_num := SQLCODE;
293: l_err_code := NULL;
294: l_err_msg := SUBSTR('EAM_Downtime_PUB.Process_Production_Downtime ('
295: || TO_CHAR(l_stmt_num)
296: || '):'
297: || SQLERRM,1,240);
298: FND_FILE.put_line(FND_FILE.log,l_err_msg);

Line 1016: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('

1012:
1013: EXCEPTION
1014: WHEN FND_API.g_exc_error THEN
1015: x_return_status := FND_API.g_ret_sts_error;
1016: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('
1017: || l_stmt_num
1018: || '): '
1019: || x_return_status
1020: || substr(SQLERRM,1,200));

Line 1023: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('

1019: || x_return_status
1020: || substr(SQLERRM,1,200));
1021: WHEN FND_API.g_exc_unexpected_error THEN
1022: x_return_status := FND_API.g_ret_sts_unexp_error;
1023: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('
1024: || l_stmt_num
1025: || '): '
1026: || x_return_status
1027: || substr(SQLERRM,1,200));

Line 1030: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('

1026: || x_return_status
1027: || substr(SQLERRM,1,200));
1028: WHEN others THEN
1029: x_return_status := FND_API.g_ret_sts_unexp_error;
1030: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.WriteLog('
1031: || l_stmt_num
1032: || '): '
1033: || x_return_status
1034: || substr(SQLERRM,1,200));

Line 1259: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('

1255: commit;
1256: EXCEPTION
1257: WHEN FND_API.g_exc_error THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1260: || l_stmt_num
1261: || '): '
1262: || x_return_status
1263: || substr(SQLERRM,1,200));

Line 1267: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('

1263: || substr(SQLERRM,1,200));
1264: WHEN FND_API.g_exc_unexpected_error THEN
1265: Rollback to LoadDowntime_PUB; -- roll back data when unexpected errors happens
1266: x_return_status := FND_API.g_ret_sts_unexp_error;
1267: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1268: || l_stmt_num
1269: || '): '
1270: || x_return_status
1271: || substr(SQLERRM,1,200));

Line 1275: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('

1271: || substr(SQLERRM,1,200));
1272: WHEN others THEN
1273: Rollback to LoadDowntime_PUB; -- roll back data when unexpected errors happens
1274: x_return_status := FND_API.g_ret_sts_unexp_error;
1275: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1276: -- dbms_output.put_line('EAM_Downtime_PUB.LoadDowntime('
1277: || l_stmt_num
1278: || '): '
1279: || x_return_status

Line 1276: -- dbms_output.put_line('EAM_Downtime_PUB.LoadDowntime('

1272: WHEN others THEN
1273: Rollback to LoadDowntime_PUB; -- roll back data when unexpected errors happens
1274: x_return_status := FND_API.g_ret_sts_unexp_error;
1275: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.LoadDowntime('
1276: -- dbms_output.put_line('EAM_Downtime_PUB.LoadDowntime('
1277: || l_stmt_num
1278: || '): '
1279: || x_return_status
1280: || substr(SQLERRM,1,200));

Line 1350: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('

1346: EXCEPTION
1347: WHEN FND_API.g_exc_error THEN
1348: ROLLBACK to purgedowntime_pub;
1349: x_return_status := FND_API.g_ret_sts_error;
1350: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('
1351: || l_stmt_num
1352: || '): '
1353: || x_return_status
1354: || substr(SQLERRM,1,200));

Line 1358: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('

1354: || substr(SQLERRM,1,200));
1355: WHEN FND_API.g_exc_unexpected_error THEN
1356: ROLLBACK to purgedowntime_pub;
1357: x_return_status := FND_API.g_ret_sts_unexp_error;
1358: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('
1359: || l_stmt_num
1360: || '): '
1361: || x_return_status
1362: || substr(SQLERRM,1,200));

Line 1366: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('

1362: || substr(SQLERRM,1,200));
1363: WHEN others THEN
1364: ROLLBACK to purgedowntime_pub;
1365: x_return_status := FND_API.g_ret_sts_unexp_error;
1366: FND_FILE.put_line(FND_FILE.log,'EAM_Downtime_PUB.PurgeDowntime('
1367: || l_stmt_num
1368: || '): '
1369: || x_return_status
1370: || substr(SQLERRM,1,200));

Line 1374: END EAM_Downtime_PUB;

1370: || substr(SQLERRM,1,200));
1371:
1372: END Purge_Downtime;
1373:
1374: END EAM_Downtime_PUB;