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

Line 1: PACKAGE BODY WSMPLBJI AS

1: PACKAGE BODY WSMPLBJI AS
2: /* $Header: WSMLBJIB.pls 120.11 2006/09/06 06:21:58 mprathap noship $ */
3:
4: -- the following declarations are global to WSMPLBJI
5: -- PS: Although they have been declared as private to the package,

Line 4: -- the following declarations are global to WSMPLBJI

1: PACKAGE BODY WSMPLBJI AS
2: /* $Header: WSMLBJIB.pls 120.11 2006/09/06 06:21:58 mprathap noship $ */
3:
4: -- the following declarations are global to WSMPLBJI
5: -- PS: Although they have been declared as private to the package,
6: -- please note that each concurrent request submitted has it's own
7: -- session, hence each submission of launch worker will have it's
8: -- own set of "global" variables and tables.

Line 412: '++++++ Start calling WSMPLBJI.process_lbji_rows_1159 ++++++');

408:
409: if(l_profile = 2) then
410: g_create_job_copy := 'N';
411: fnd_file.put_line(fnd_file.log,
412: '++++++ Start calling WSMPLBJI.process_lbji_rows_1159 ++++++');
413: process_lbji_rows_1159 (retcode, errbuf, p_group_id);
414: fnd_file.put_line(fnd_file.log,
415: '++++++ End calling WSMPLBJI.process_lbji_rows_1159 ++++++');
416: else

Line 415: '++++++ End calling WSMPLBJI.process_lbji_rows_1159 ++++++');

411: fnd_file.put_line(fnd_file.log,
412: '++++++ Start calling WSMPLBJI.process_lbji_rows_1159 ++++++');
413: process_lbji_rows_1159 (retcode, errbuf, p_group_id);
414: fnd_file.put_line(fnd_file.log,
415: '++++++ End calling WSMPLBJI.process_lbji_rows_1159 ++++++');
416: else
417: g_create_job_copy := 'Y';
418: fnd_file.put_line(fnd_file.log,
419: '++++++ Start calling WSM_LBJ_INTERFACE_PVT.process_lbji_rows ++++++');

Line 460: fnd_file.put_line(fnd_file.log, '++++++ Calling WSMPLBJI.launch_worker_1159 ++++++');

456: END IF;
457:
458: if(l_profile = 2) then
459: g_create_job_copy := 'N';
460: fnd_file.put_line(fnd_file.log, '++++++ Calling WSMPLBJI.launch_worker_1159 ++++++');
461: WSMPLBJI.launch_worker_1159(retcode, errbuf, l_group_id, alotted_rows);
462: else
463: g_create_job_copy := 'Y';
464: fnd_file.put_line(fnd_file.log, '++++++ Calling WSM_LBJ_INTERFACE_PVT.launch_worker ++++++');

Line 461: WSMPLBJI.launch_worker_1159(retcode, errbuf, l_group_id, alotted_rows);

457:
458: if(l_profile = 2) then
459: g_create_job_copy := 'N';
460: fnd_file.put_line(fnd_file.log, '++++++ Calling WSMPLBJI.launch_worker_1159 ++++++');
461: WSMPLBJI.launch_worker_1159(retcode, errbuf, l_group_id, alotted_rows);
462: else
463: g_create_job_copy := 'Y';
464: fnd_file.put_line(fnd_file.log, '++++++ Calling WSM_LBJ_INTERFACE_PVT.launch_worker ++++++');
465: WSM_LBJ_INTERFACE_PVT.launch_worker(retcode, errbuf, l_group_id, alotted_rows);

Line 895: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||l_error_msg, 1, 2000);

891: Exception
892:
893: when build_job_exception then
894: p_error_code := l_error_code;
895: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||l_error_msg, 1, 2000);
896: return;
897:
898: End;
899:

Line 953: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);

949: and params.organization_id = p_org;
950: EXCEPTION
951: when others then
952: p_error_code := SQLCODE;
953: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);
954: return;
955: END;
956:
957:

Line 1154: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);

1150:
1151: Exception
1152: when others then
1153: p_error_code := SQLCODE;
1154: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);
1155: return;
1156: End;
1157:
1158: if lbji_debug = 'Y' then

Line 1206: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);

1202:
1203: exception
1204: when others then
1205: p_error_code := SQLCODE;
1206: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);
1207: return;
1208: end;
1209:
1210: if lbji_debug = 'Y' then

Line 1307: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);

1303:
1304: EXCEPTION
1305: when others then
1306: p_error_code := SQLCODE;
1307: p_error_msg := substr('wsmplbji.build_lbji_info: stmt no: '||l_stmt_num||' '||SQLERRM, 1, 2000);
1308: return;
1309:
1310:
1311: END build_lbji_info;

Line 1624: x_err_msg := 'WSMPLBJI.check_errored_mmtt_records' ||

1620: EXCEPTION
1621:
1622: when others then
1623: x_err_code := SQLCODE;
1624: x_err_msg := 'WSMPLBJI.check_errored_mmtt_records' ||
1625: '(stmt_num='||l_stmt_num||') : '||
1626: '(Header_Id=' ||l_wlji_header_id||') : '||
1627: SUBSTRB(SQLERRM,1,1000);
1628: END check_errored_mmtt_records;

Line 2065: p_error_msg := 'WSMPLBJI.insert_procedure('||l_stat_num||'): No Data Found';

2061: end if;
2062:
2063: EXCEPTION
2064: WHEN NO_DATA_FOUND THEN
2065: p_error_msg := 'WSMPLBJI.insert_procedure('||l_stat_num||'): No Data Found';
2066: p_error_code := -1;
2067: if (lbji_debug = 'Y') then
2068: fnd_file.put_line(fnd_file.log,p_error_msg);
2069: end if;

Line 2072: p_error_msg := 'WSMPLBJI.insert_procedure('||l_stat_num||'): '||p_error_msg;

2068: fnd_file.put_line(fnd_file.log,p_error_msg);
2069: end if;
2070:
2071: WHEN e_proc_error THEN
2072: p_error_msg := 'WSMPLBJI.insert_procedure('||l_stat_num||'): '||p_error_msg;
2073: p_error_code := -1;
2074: if (lbji_debug = 'Y') then
2075: fnd_file.put_line(fnd_file.log,p_error_msg);
2076: end if;

Line 2086: p_error_msg := 'WSMPLBJI.insert_procedure('||l_stat_num||')'|| substr(SQLERRM,1,200);

2082: p_error_code := -1;
2083:
2084: when others then
2085: p_error_code := SQLCODE;
2086: p_error_msg := 'WSMPLBJI.insert_procedure('||l_stat_num||')'|| substr(SQLERRM,1,200);
2087: if (lbji_debug = 'Y') then
2088: fnd_file.put_line(fnd_file.log,p_error_msg);
2089: end if;
2090:

Line 2400: p_err_msg := 'WSMPLBJI.insert_into_period_balances: '|| substr(SQLERRM,1,200);

2396: end if;
2397:
2398: exception
2399: when others then
2400: p_err_msg := 'WSMPLBJI.insert_into_period_balances: '|| substr(SQLERRM,1,200);
2401: p_error_code := SQLCODE;
2402:
2403: end insert_into_period_balances;
2404:

Line 7585: fnd_file.put_line(fnd_file.log, 'WSMPLBJI.launch_worker: '||dummy_err_msg);

7581: dummy_err_msg );
7582:
7583: if dummy_err_code <> 0 then
7584: fnd_file.put_line(fnd_file.log, '*** WARNING ***');
7585: fnd_file.put_line(fnd_file.log, 'WSMPLBJI.launch_worker: '||dummy_err_msg);
7586: l_error_count := l_error_count + 1;
7587: end if;
7588: end if;
7589:

Line 7649: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||

7645:
7646: if l_inv_worker_req_id = 0 then
7647:
7648: retcode := 1;
7649: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7650: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7651: fnd_file.put_line(fnd_file.log,errbuf);
7652: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7653: update wsm_lot_job_interface

Line 7680: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||

7676: ||req_message);
7677:
7678: if req_devphase <> 'COMPLETE' OR req_devstatus <> 'NORMAL' THEN
7679: retcode := 1;
7680: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7681: '(Transaction_header_id=' ||txn_header_id||') : '||
7682: SUBSTRB(SQLERRM,1,1000);
7683: fnd_file.put_line(fnd_file.log,errbuf);
7684: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

Line 7691: errbuf:= 'WSMPLBJI. Errored Records in mmtt ' ||

7687: check_errored_mmtt_records(txn_header_id, l_error_code, l_error_msg);
7688:
7689: if (l_error_code <> 0) or (l_error_msg is not null ) then
7690: retcode := 1;
7691: errbuf:= 'WSMPLBJI. Errored Records in mmtt ' ||
7692: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7693: fnd_file.put_line(fnd_file.log,errbuf);
7694: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7695: end if;

Line 7807: END WSMPLBJI;

7803: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
7804:
7805: END launch_worker_1159;
7806:
7807: END WSMPLBJI;