DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_GLOBAL

Line 6327: l_reqt_id number := fnd_global.conc_request_id;

6323: l_d number;
6324: l_wrk_cnt number;
6325: l_job_cnt number;
6326:
6327: l_reqt_id number := fnd_global.conc_request_id;
6328: l_prog_id number := fnd_global.conc_program_id;
6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;

Line 6328: l_prog_id number := fnd_global.conc_program_id;

6324: l_wrk_cnt number;
6325: l_job_cnt number;
6326:
6327: l_reqt_id number := fnd_global.conc_request_id;
6328: l_prog_id number := fnd_global.conc_program_id;
6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;
6332: l_resp_id number := fnd_global.resp_id;

Line 6329: l_prog_appl_id number := fnd_global.prog_appl_id;

6325: l_job_cnt number;
6326:
6327: l_reqt_id number := fnd_global.conc_request_id;
6328: l_prog_id number := fnd_global.conc_program_id;
6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;
6332: l_resp_id number := fnd_global.resp_id;
6333: l_resp_appl_id number := fnd_global.resp_appl_id;

Line 6330: l_login_id number := fnd_global.login_id;

6326:
6327: l_reqt_id number := fnd_global.conc_request_id;
6328: l_prog_id number := fnd_global.conc_program_id;
6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;
6332: l_resp_id number := fnd_global.resp_id;
6333: l_resp_appl_id number := fnd_global.resp_appl_id;
6334:

Line 6331: l_user_id number := fnd_global.user_id;

6327: l_reqt_id number := fnd_global.conc_request_id;
6328: l_prog_id number := fnd_global.conc_program_id;
6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;
6332: l_resp_id number := fnd_global.resp_id;
6333: l_resp_appl_id number := fnd_global.resp_appl_id;
6334:
6335: l_v_group_id t_number;

Line 6332: l_resp_id number := fnd_global.resp_id;

6328: l_prog_id number := fnd_global.conc_program_id;
6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;
6332: l_resp_id number := fnd_global.resp_id;
6333: l_resp_appl_id number := fnd_global.resp_appl_id;
6334:
6335: l_v_group_id t_number;
6336: l_v_job_gid t_number;

Line 6333: l_resp_appl_id number := fnd_global.resp_appl_id;

6329: l_prog_appl_id number := fnd_global.prog_appl_id;
6330: l_login_id number := fnd_global.login_id;
6331: l_user_id number := fnd_global.user_id;
6332: l_resp_id number := fnd_global.resp_id;
6333: l_resp_appl_id number := fnd_global.resp_appl_id;
6334:
6335: l_v_group_id t_number;
6336: l_v_job_gid t_number;
6337: l_v_group_no t_number;

Line 6351: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_resp_appl_id);

6347: fnd_file.put_line(fnd_file.log, 'Processing Interface rows...');
6348: retcode := 0;
6349: -- CZHDBG: comment out this because the completion status of the
6350: -- concurrent program cannot be set properly with this call. Why ???
6351: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_resp_appl_id);
6352:
6353: l_stmt_num := 20;
6354: -- load organization PL/SQL table
6355: WSMPLCVA.load_org_table;

Line 7004: l_user number := fnd_global.user_id;

7000: l_temp_class varchar2(10);
7001: l_temp_boolean boolean;
7002: l_date_text varchar2(100);
7003: l_xst boolean := true;
7004: l_user number := fnd_global.user_id;
7005: l_h number; -- index for WLJI records
7006: l_d number; -- index for WLJDI records
7007:
7008: dummy_number number;

Line 7432: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;

7428: g_job_released_date := null; -- ADD: bug 3423195
7429:
7430: v_wlji_err_code(v_idx) := l_error_code;
7431: v_wlji_err_msg(v_idx) := l_error_msg;
7432: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7433: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7434: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7435: v_wlji_creation_date(v_idx) := sysdate;
7436: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;

Line 7433: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;

7429:
7430: v_wlji_err_code(v_idx) := l_error_code;
7431: v_wlji_err_msg(v_idx) := l_error_msg;
7432: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7433: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7434: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7435: v_wlji_creation_date(v_idx) := sysdate;
7436: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;
7437: v_wlji_last_updt_date(v_idx) := sysdate;

Line 7434: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;

7430: v_wlji_err_code(v_idx) := l_error_code;
7431: v_wlji_err_msg(v_idx) := l_error_msg;
7432: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7433: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7434: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7435: v_wlji_creation_date(v_idx) := sysdate;
7436: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;
7437: v_wlji_last_updt_date(v_idx) := sysdate;
7438: v_wlji_prog_updt_date(v_idx) := sysdate;

Line 7436: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;

7432: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7433: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7434: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7435: v_wlji_creation_date(v_idx) := sysdate;
7436: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;
7437: v_wlji_last_updt_date(v_idx) := sysdate;
7438: v_wlji_prog_updt_date(v_idx) := sysdate;
7439:
7440: l_mo_org_id := v_wlji_org_id(v_idx); -- Add: bug5485653

Line 12228: p_last_updt_by => fnd_global.user_id,

12224: p_job_scheduled_compl_date => null, -- p_job_scheduled_compl_date
12225: p_job_scheduled_quantity => null,
12226: p_group_id => p_group_id,
12227: p_last_updt_date => sysdate,
12228: p_last_updt_by => fnd_global.user_id,
12229: p_last_updt_login => fnd_global.login_id,
12230: p_creation_date => sysdate,
12231: p_created_by => fnd_global.user_id,
12232: p_request_id => fnd_global.conc_request_id,

Line 12229: p_last_updt_login => fnd_global.login_id,

12225: p_job_scheduled_quantity => null,
12226: p_group_id => p_group_id,
12227: p_last_updt_date => sysdate,
12228: p_last_updt_by => fnd_global.user_id,
12229: p_last_updt_login => fnd_global.login_id,
12230: p_creation_date => sysdate,
12231: p_created_by => fnd_global.user_id,
12232: p_request_id => fnd_global.conc_request_id,
12233: p_program_appl_id => fnd_global.prog_appl_id,

Line 12231: p_created_by => fnd_global.user_id,

12227: p_last_updt_date => sysdate,
12228: p_last_updt_by => fnd_global.user_id,
12229: p_last_updt_login => fnd_global.login_id,
12230: p_creation_date => sysdate,
12231: p_created_by => fnd_global.user_id,
12232: p_request_id => fnd_global.conc_request_id,
12233: p_program_appl_id => fnd_global.prog_appl_id,
12234: p_program_id => fnd_global.conc_program_id,
12235: p_prog_updt_date => sysdate,

Line 12232: p_request_id => fnd_global.conc_request_id,

12228: p_last_updt_by => fnd_global.user_id,
12229: p_last_updt_login => fnd_global.login_id,
12230: p_creation_date => sysdate,
12231: p_created_by => fnd_global.user_id,
12232: p_request_id => fnd_global.conc_request_id,
12233: p_program_appl_id => fnd_global.prog_appl_id,
12234: p_program_id => fnd_global.conc_program_id,
12235: p_prog_updt_date => sysdate,
12236: p_error_code => l_error_code,

Line 12233: p_program_appl_id => fnd_global.prog_appl_id,

12229: p_last_updt_login => fnd_global.login_id,
12230: p_creation_date => sysdate,
12231: p_created_by => fnd_global.user_id,
12232: p_request_id => fnd_global.conc_request_id,
12233: p_program_appl_id => fnd_global.prog_appl_id,
12234: p_program_id => fnd_global.conc_program_id,
12235: p_prog_updt_date => sysdate,
12236: p_error_code => l_error_code,
12237: p_error_msg => l_error_msg);

Line 12234: p_program_id => fnd_global.conc_program_id,

12230: p_creation_date => sysdate,
12231: p_created_by => fnd_global.user_id,
12232: p_request_id => fnd_global.conc_request_id,
12233: p_program_appl_id => fnd_global.prog_appl_id,
12234: p_program_id => fnd_global.conc_program_id,
12235: p_prog_updt_date => sysdate,
12236: p_error_code => l_error_code,
12237: p_error_msg => l_error_msg);
12238: if (l_error_code <> 0) then

Line 12263: request_id = fnd_global.conc_request_id,

12259: update wsm_lot_job_dtl_interface
12260: set process_status = 3,
12261: error_code = l_v_d_ecode_err(i),
12262: error_msg = l_v_d_emsg_err(i),
12263: request_id = fnd_global.conc_request_id,
12264: program_id = fnd_global.conc_program_id,
12265: program_application_id = fnd_global.prog_appl_id
12266: where parent_header_id IS NULL
12267: and process_status = WIP_CONSTANTS.RUNNING

Line 12264: program_id = fnd_global.conc_program_id,

12260: set process_status = 3,
12261: error_code = l_v_d_ecode_err(i),
12262: error_msg = l_v_d_emsg_err(i),
12263: request_id = fnd_global.conc_request_id,
12264: program_id = fnd_global.conc_program_id,
12265: program_application_id = fnd_global.prog_appl_id
12266: where parent_header_id IS NULL
12267: and process_status = WIP_CONSTANTS.RUNNING
12268: and wip_entity_id = l_v_d_we_id_err(i)

Line 12265: program_application_id = fnd_global.prog_appl_id

12261: error_code = l_v_d_ecode_err(i),
12262: error_msg = l_v_d_emsg_err(i),
12263: request_id = fnd_global.conc_request_id,
12264: program_id = fnd_global.conc_program_id,
12265: program_application_id = fnd_global.prog_appl_id
12266: where parent_header_id IS NULL
12267: and process_status = WIP_CONSTANTS.RUNNING
12268: and wip_entity_id = l_v_d_we_id_err(i)
12269: and organization_id = l_v_d_org_id_err(i);

Line 12352: fnd_global.conc_request_id,

12348: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
12349: wsmputil.WRITE_TO_WIE (
12350: 0,
12351: substr(errbuf,1,2000),
12352: fnd_global.conc_request_id,
12353: fnd_global.conc_program_id,
12354: fnd_global.prog_appl_id,
12355: 1,
12356: dummy_err_code,

Line 12353: fnd_global.conc_program_id,

12349: wsmputil.WRITE_TO_WIE (
12350: 0,
12351: substr(errbuf,1,2000),
12352: fnd_global.conc_request_id,
12353: fnd_global.conc_program_id,
12354: fnd_global.prog_appl_id,
12355: 1,
12356: dummy_err_code,
12357: dummy_err_msg );

Line 12354: fnd_global.prog_appl_id,

12350: 0,
12351: substr(errbuf,1,2000),
12352: fnd_global.conc_request_id,
12353: fnd_global.conc_program_id,
12354: fnd_global.prog_appl_id,
12355: 1,
12356: dummy_err_code,
12357: dummy_err_msg );
12358: COMMIT;

Line 12371: fnd_global.conc_request_id,

12367:
12368: wsmputil.WRITE_TO_WIE (
12369: 0,
12370: substr(errbuf,1,2000),
12371: fnd_global.conc_request_id,
12372: fnd_global.conc_program_id,
12373: fnd_global.prog_appl_id,
12374: 1,
12375: dummy_err_code,

Line 12372: fnd_global.conc_program_id,

12368: wsmputil.WRITE_TO_WIE (
12369: 0,
12370: substr(errbuf,1,2000),
12371: fnd_global.conc_request_id,
12372: fnd_global.conc_program_id,
12373: fnd_global.prog_appl_id,
12374: 1,
12375: dummy_err_code,
12376: dummy_err_msg );

Line 12373: fnd_global.prog_appl_id,

12369: 0,
12370: substr(errbuf,1,2000),
12371: fnd_global.conc_request_id,
12372: fnd_global.conc_program_id,
12373: fnd_global.prog_appl_id,
12374: 1,
12375: dummy_err_code,
12376: dummy_err_msg );
12377: COMMIT;

Line 20433: x_user_id number := fnd_global.user_id;

20429: p_release_date in date,
20430: p_error_code out nocopy number,
20431: p_err_msg out nocopy varchar2 ) is
20432:
20433: x_user_id number := fnd_global.user_id;
20434: x_login_id number := fnd_global.login_id;
20435: --l_inv_period_id number; -- BUG3126650
20436: l_cnt number; -- bug 3571360
20437:

Line 20434: x_login_id number := fnd_global.login_id;

20430: p_error_code out nocopy number,
20431: p_err_msg out nocopy varchar2 ) is
20432:
20433: x_user_id number := fnd_global.user_id;
20434: x_login_id number := fnd_global.login_id;
20435: --l_inv_period_id number; -- BUG3126650
20436: l_cnt number; -- bug 3571360
20437:
20438: BEGIN