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.WMS_LMS_UTILS dependencies on FND_CONCURRENT

Line 287: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);

283:
284: retcode := 1;
285: fnd_message.set_name('WMS', 'WMS_LMS_PURGE_HIST_SUCCESS');
286: l_message := fnd_message.get;
287: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);
288:
289: ELSE
290:
291: IF g_debug=1 THEN

Line 300: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

296:
297: retcode := 2;
298: fnd_message.set_name('WMS', 'WMS_LMS_REQ_PARAM_NULL');
299: l_message := fnd_message.get;
300: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
301: END IF;
302:
303:
304: EXCEPTION

Line 315: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

311: ROLLBACK TO purge_lms_history;
312: retcode := 2;
313: fnd_message.set_name('WMS', 'WMS_LMS_PURGE_HIST_ERROR');
314: l_message := fnd_message.get;
315: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
316:
317: END PURGE_LMS_SETUP_HISTORY;
318:
319:

Line 465: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);

461:
462: retcode := 1;
463: fnd_message.set_name('WMS', 'WMS_LMS_PURGE_TXNS_SUCCESS');
464: l_message := fnd_message.get;
465: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);
466:
467: ELSE -- call to bucket actual timings is not a success
468:
469: IF g_debug=1 THEN

Line 478: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

474:
475: retcode := 2;
476: fnd_message.set_name('WMS', 'WMS_LMS_PURGE_TXNS_ERROR');
477: l_message := fnd_message.get;
478: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
479:
480: ROLLBACK TO purge_lms_txns;
481:
482: END IF;

Line 496: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

492:
493: retcode := 2;
494: fnd_message.set_name('WMS', 'WMS_LMS_REQ_PARAM_NULL');
495: l_message := fnd_message.get;
496: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
497:
498: END IF; -- when required parameters passed
499:
500:

Line 512: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

508: ROLLBACK TO purge_lms_txns;
509: retcode := 2;
510: fnd_message.set_name('WMS', 'WMS_LMS_PURGE_TXNS_ERROR');
511: l_message := fnd_message.get;
512: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
513:
514: END PURGE_LMS_TRANSACTIONS;
515:
516:

Line 824: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);

820: IF l_error = 0 THEN
821: retcode := 1;
822: fnd_message.set_name('WMS', 'WMS_LMS_COPY_TIMINGS_SUCCESS');
823: l_message := fnd_message.get;
824: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);
825:
826: ELSIF l_error =2 THEN
827: retcode := 2;
828: fnd_message.set_name('WMS', 'WMS_LMS_COPY_TIMINGS_ERROR');

Line 830: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

826: ELSIF l_error =2 THEN
827: retcode := 2;
828: fnd_message.set_name('WMS', 'WMS_LMS_COPY_TIMINGS_ERROR');
829: l_message := fnd_message.get;
830: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
831:
832: ELSE
833: retcode := 3;
834: fnd_message.set_name('WMS', 'WMS_LMS_COPY_TIMINGS_WARN');

Line 836: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('WARN',l_message);

832: ELSE
833: retcode := 3;
834: fnd_message.set_name('WMS', 'WMS_LMS_COPY_TIMINGS_WARN');
835: l_message := fnd_message.get;
836: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('WARN',l_message);
837: END IF;
838:
839:
840:

Line 851: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

847:
848: retcode := 2;
849: fnd_message.set_name('WMS', 'WMS_LMS_COPY_TIMINGS_ERROR');
850: l_message := fnd_message.get;
851: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
852:
853: END COPY_ACTUAL_TIMINGS;
854:
855:

Line 920: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

916:
917: retcode := 2;
918: fnd_message.set_name('WMS', 'WMS_LMS_TIME_FRAME_NULL');
919: l_message := fnd_message.get;
920: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
921: RETURN;
922: END;
923:
924: -- Set the local variable l_from_date depending on the

Line 1013: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);

1009:
1010: retcode := 1;
1011: fnd_message.set_name('WMS', 'WMS_LMS_CAL_ACTUALS_SUCCESS');
1012: l_message := fnd_message.get;
1013: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);
1014:
1015: ELSE -- if org id is not passed
1016:
1017: IF g_debug=1 THEN

Line 1024: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

1020:
1021: retcode := 2;
1022: fnd_message.set_name('WMS', 'WMS_LMS_REQ_PARAM_NULL');
1023: l_message := fnd_message.get;
1024: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
1025:
1026: END IF;
1027:
1028: EXCEPTION

Line 1040: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

1036:
1037: retcode := 2;
1038: fnd_message.set_name('WMS', 'WMS_LMS_CAL_ACTUALS_ERROR');
1039: l_message := fnd_message.get;
1040: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
1041:
1042: --close the cursor if it is open
1043:
1044: IF C_ELS_DATA_ID%isopen THEN

Line 1114: from fnd_concurrent_requests where argument1 = to_char(p_org_id)

1110: select ARGUMENT2,ARGUMENT3,
1111: ARGUMENT4,ARGUMENT5
1112: into l_argument2,l_argument3,
1113: l_argument4,l_argument5
1114: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1115: and request_id = (select Max(Request_ID)
1116: From Fnd_Concurrent_Requests
1117: Where Concurrent_Program_ID = p_concurrent_program_id
1118: AND PHASE_CODE = 'C' and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746

Line 1116: From Fnd_Concurrent_Requests

1112: into l_argument2,l_argument3,
1113: l_argument4,l_argument5
1114: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1115: and request_id = (select Max(Request_ID)
1116: From Fnd_Concurrent_Requests
1117: Where Concurrent_Program_ID = p_concurrent_program_id
1118: AND PHASE_CODE = 'C' and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746
1119:
1120: IF g_debug=1 THEN

Line 1181: from fnd_concurrent_requests

1177:
1178: l_next_scheduled_date:= NULL;
1179:
1180: select min(requested_start_date) into l_next_scheduled_date
1181: from fnd_concurrent_requests
1182: where concurrent_program_id = p_concurrent_program_id
1183: and program_application_id = p_application_id
1184: and phase_code = 'P'
1185: and STATUS_CODE IN ( 'I','Q')

Line 1231: from fnd_concurrent_requests where argument1 = to_char(p_org_id)

1227:
1228:
1229: select actual_completion_date
1230: into l_actual_completion_date
1231: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1232: and request_id = (select Max(Request_ID)
1233: From Fnd_Concurrent_Requests
1234: Where Concurrent_Program_ID = p_concurrent_program_id
1235: AND PHASE_CODE = 'C'

Line 1233: From Fnd_Concurrent_Requests

1229: select actual_completion_date
1230: into l_actual_completion_date
1231: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1232: and request_id = (select Max(Request_ID)
1233: From Fnd_Concurrent_Requests
1234: Where Concurrent_Program_ID = p_concurrent_program_id
1235: AND PHASE_CODE = 'C'
1236: and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746
1237:

Line 1277: from fnd_concurrent_requests where argument1 = to_char(p_org_id)

1273:
1274:
1275: select actual_completion_date
1276: into l_actual_completion_date
1277: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1278: and request_id = (select Max(Request_ID)
1279: From Fnd_Concurrent_Requests
1280: Where Concurrent_Program_ID = p_concurrent_program_id
1281: AND PHASE_CODE = 'C'

Line 1279: From Fnd_Concurrent_Requests

1275: select actual_completion_date
1276: into l_actual_completion_date
1277: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1278: and request_id = (select Max(Request_ID)
1279: From Fnd_Concurrent_Requests
1280: Where Concurrent_Program_ID = p_concurrent_program_id
1281: AND PHASE_CODE = 'C'
1282: AND STATUS_CODE = 'C'
1283: and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746

Line 1321: from fnd_concurrent_requests fcr, fnd_lookups fl

1317:
1318:
1319: select fl.meaning
1320: into l_last_run_status
1321: from fnd_concurrent_requests fcr, fnd_lookups fl
1322: where argument1 = to_char(p_org_id)
1323: and fl.lookup_code = fcr.status_code
1324: and fl.Lookup_type = 'CP_STATUS_CODE'
1325: and request_id = (select Max(Request_ID)

Line 1326: from Fnd_Concurrent_Requests

1322: where argument1 = to_char(p_org_id)
1323: and fl.lookup_code = fcr.status_code
1324: and fl.Lookup_type = 'CP_STATUS_CODE'
1325: and request_id = (select Max(Request_ID)
1326: from Fnd_Concurrent_Requests
1327: where Concurrent_Program_ID = p_concurrent_program_id
1328: AND PHASE_CODE = 'C'
1329: and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746
1330:

Line 2429: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

2425: ROLLBACK TO standardize_lines_cp;
2426: retcode := 2;
2427: fnd_message.set_name('WMS', 'WMS_LMS_STANDARDIZE_ERROR');
2428: l_message := fnd_message.get;
2429: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
2430: RETURN;
2431:
2432: END IF;
2433:

Line 2483: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

2479:
2480: retcode := 2;
2481: fnd_message.set_name('WMS', 'WMS_STANDARDIZE_LINES_ERROR');
2482: l_message := fnd_message.get;
2483: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
2484: RETURN;
2485:
2486: END;
2487:

Line 2613: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

2609:
2610: retcode := 2;
2611: fnd_message.set_name('WMS', 'WMS_STANDARDIZE_LINES_ERROR');
2612: l_message := fnd_message.get;
2613: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
2614: RETURN;
2615:
2616: END;
2617:

Line 2663: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

2659:
2660: retcode := 2;
2661: fnd_message.set_name('WMS', 'WMS_STANDARDIZE_LINES_ERROR');
2662: l_message := fnd_message.get;
2663: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
2664: RETURN;
2665:
2666:
2667: END;

Line 2688: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);

2684: COMMIT;
2685: retcode := 1;
2686: fnd_message.set_name('WMS', 'WMS_STANDARDIZE_LINES_SUCCESS');
2687: l_message := fnd_message.get;
2688: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',l_message);
2689:
2690: ELSE
2691:
2692: COMMIT;

Line 2696: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);

2692: COMMIT;
2693: retcode := 3;
2694: fnd_message.set_name('WMS', 'WMS_STANDARDIZE_LINES_WARN');
2695: l_message := fnd_message.get;
2696: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
2697:
2698: END IF;
2699:
2700: ELSE -- When required parameters are not passed

Line 2711: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

2707:
2708: retcode := 2;
2709: fnd_message.set_name('WMS', 'WMS_LMS_REQ_PARAM_NULL');
2710: l_message := fnd_message.get;
2711: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
2712:
2713: END IF; -- when required parameters passed
2714:
2715:

Line 2729: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

2725:
2726: retcode := 2;
2727: fnd_message.set_name('WMS', 'WMS_STANDARDIZE_LINES_ERROR');
2728: l_message := fnd_message.get;
2729: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
2730:
2731: END STANDARDIZE_LINES_CP;
2732:
2733: