DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_GLOBAL

Line 6343: l_reqt_id number := fnd_global.conc_request_id;

6339: l_d number;
6340: l_wrk_cnt number;
6341: l_job_cnt number;
6342:
6343: l_reqt_id number := fnd_global.conc_request_id;
6344: l_prog_id number := fnd_global.conc_program_id;
6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;

Line 6344: l_prog_id number := fnd_global.conc_program_id;

6340: l_wrk_cnt number;
6341: l_job_cnt number;
6342:
6343: l_reqt_id number := fnd_global.conc_request_id;
6344: l_prog_id number := fnd_global.conc_program_id;
6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;
6348: l_resp_id number := fnd_global.resp_id;

Line 6345: l_prog_appl_id number := fnd_global.prog_appl_id;

6341: l_job_cnt number;
6342:
6343: l_reqt_id number := fnd_global.conc_request_id;
6344: l_prog_id number := fnd_global.conc_program_id;
6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;
6348: l_resp_id number := fnd_global.resp_id;
6349: l_resp_appl_id number := fnd_global.resp_appl_id;

Line 6346: l_login_id number := fnd_global.login_id;

6342:
6343: l_reqt_id number := fnd_global.conc_request_id;
6344: l_prog_id number := fnd_global.conc_program_id;
6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;
6348: l_resp_id number := fnd_global.resp_id;
6349: l_resp_appl_id number := fnd_global.resp_appl_id;
6350:

Line 6347: l_user_id number := fnd_global.user_id;

6343: l_reqt_id number := fnd_global.conc_request_id;
6344: l_prog_id number := fnd_global.conc_program_id;
6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;
6348: l_resp_id number := fnd_global.resp_id;
6349: l_resp_appl_id number := fnd_global.resp_appl_id;
6350:
6351: l_v_group_id t_number;

Line 6348: l_resp_id number := fnd_global.resp_id;

6344: l_prog_id number := fnd_global.conc_program_id;
6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;
6348: l_resp_id number := fnd_global.resp_id;
6349: l_resp_appl_id number := fnd_global.resp_appl_id;
6350:
6351: l_v_group_id t_number;
6352: l_v_job_gid t_number;

Line 6349: l_resp_appl_id number := fnd_global.resp_appl_id;

6345: l_prog_appl_id number := fnd_global.prog_appl_id;
6346: l_login_id number := fnd_global.login_id;
6347: l_user_id number := fnd_global.user_id;
6348: l_resp_id number := fnd_global.resp_id;
6349: l_resp_appl_id number := fnd_global.resp_appl_id;
6350:
6351: l_v_group_id t_number;
6352: l_v_job_gid t_number;
6353: l_v_group_no t_number;

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

6363: fnd_file.put_line(fnd_file.log, 'Processing Interface rows...');
6364: retcode := 0;
6365: -- CZHDBG: comment out this because the completion status of the
6366: -- concurrent program cannot be set properly with this call. Why ???
6367: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_resp_appl_id);
6368:
6369: l_stmt_num := 20;
6370: -- load organization PL/SQL table
6371: WSMPLCVA.load_org_table;

Line 7020: l_user number := fnd_global.user_id;

7016: l_temp_class varchar2(10);
7017: l_temp_boolean boolean;
7018: l_date_text varchar2(100);
7019: l_xst boolean := true;
7020: l_user number := fnd_global.user_id;
7021: l_h number; -- index for WLJI records
7022: l_d number; -- index for WLJDI records
7023:
7024: dummy_number number;

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

7444: g_job_released_date := null; -- ADD: bug 3423195
7445:
7446: v_wlji_err_code(v_idx) := l_error_code;
7447: v_wlji_err_msg(v_idx) := l_error_msg;
7448: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7449: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7450: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7451: v_wlji_creation_date(v_idx) := sysdate;
7452: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;

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

7445:
7446: v_wlji_err_code(v_idx) := l_error_code;
7447: v_wlji_err_msg(v_idx) := l_error_msg;
7448: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7449: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7450: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7451: v_wlji_creation_date(v_idx) := sysdate;
7452: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;
7453: v_wlji_last_updt_date(v_idx) := sysdate;

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

7446: v_wlji_err_code(v_idx) := l_error_code;
7447: v_wlji_err_msg(v_idx) := l_error_msg;
7448: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7449: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7450: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7451: v_wlji_creation_date(v_idx) := sysdate;
7452: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;
7453: v_wlji_last_updt_date(v_idx) := sysdate;
7454: v_wlji_prog_updt_date(v_idx) := sysdate;

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

7448: v_wlji_request_id(v_idx) := fnd_global.conc_request_id;
7449: v_wlji_program_id(v_idx) := fnd_global.conc_program_id;
7450: v_wlji_program_appl_id(v_idx) := fnd_global.prog_appl_id;
7451: v_wlji_creation_date(v_idx) := sysdate;
7452: v_wlji_last_updt_login(v_idx) := fnd_global.login_id;
7453: v_wlji_last_updt_date(v_idx) := sysdate;
7454: v_wlji_prog_updt_date(v_idx) := sysdate;
7455:
7456: l_mo_org_id := v_wlji_org_id(v_idx); -- Add: bug5485653

Line 12332: p_last_updt_by => fnd_global.user_id,

12328: p_job_scheduled_compl_date => null, -- p_job_scheduled_compl_date
12329: p_job_scheduled_quantity => null,
12330: p_group_id => p_group_id,
12331: p_last_updt_date => sysdate,
12332: p_last_updt_by => fnd_global.user_id,
12333: p_last_updt_login => fnd_global.login_id,
12334: p_creation_date => sysdate,
12335: p_created_by => fnd_global.user_id,
12336: p_request_id => fnd_global.conc_request_id,

Line 12333: p_last_updt_login => fnd_global.login_id,

12329: p_job_scheduled_quantity => null,
12330: p_group_id => p_group_id,
12331: p_last_updt_date => sysdate,
12332: p_last_updt_by => fnd_global.user_id,
12333: p_last_updt_login => fnd_global.login_id,
12334: p_creation_date => sysdate,
12335: p_created_by => fnd_global.user_id,
12336: p_request_id => fnd_global.conc_request_id,
12337: p_program_appl_id => fnd_global.prog_appl_id,

Line 12335: p_created_by => fnd_global.user_id,

12331: p_last_updt_date => sysdate,
12332: p_last_updt_by => fnd_global.user_id,
12333: p_last_updt_login => fnd_global.login_id,
12334: p_creation_date => sysdate,
12335: p_created_by => fnd_global.user_id,
12336: p_request_id => fnd_global.conc_request_id,
12337: p_program_appl_id => fnd_global.prog_appl_id,
12338: p_program_id => fnd_global.conc_program_id,
12339: p_prog_updt_date => sysdate,

Line 12336: p_request_id => fnd_global.conc_request_id,

12332: p_last_updt_by => fnd_global.user_id,
12333: p_last_updt_login => fnd_global.login_id,
12334: p_creation_date => sysdate,
12335: p_created_by => fnd_global.user_id,
12336: p_request_id => fnd_global.conc_request_id,
12337: p_program_appl_id => fnd_global.prog_appl_id,
12338: p_program_id => fnd_global.conc_program_id,
12339: p_prog_updt_date => sysdate,
12340: p_error_code => l_error_code,

Line 12337: p_program_appl_id => fnd_global.prog_appl_id,

12333: p_last_updt_login => fnd_global.login_id,
12334: p_creation_date => sysdate,
12335: p_created_by => fnd_global.user_id,
12336: p_request_id => fnd_global.conc_request_id,
12337: p_program_appl_id => fnd_global.prog_appl_id,
12338: p_program_id => fnd_global.conc_program_id,
12339: p_prog_updt_date => sysdate,
12340: p_error_code => l_error_code,
12341: p_error_msg => l_error_msg);

Line 12338: p_program_id => fnd_global.conc_program_id,

12334: p_creation_date => sysdate,
12335: p_created_by => fnd_global.user_id,
12336: p_request_id => fnd_global.conc_request_id,
12337: p_program_appl_id => fnd_global.prog_appl_id,
12338: p_program_id => fnd_global.conc_program_id,
12339: p_prog_updt_date => sysdate,
12340: p_error_code => l_error_code,
12341: p_error_msg => l_error_msg);
12342: if (l_error_code <> 0) then

Line 12367: request_id = fnd_global.conc_request_id,

12363: update wsm_lot_job_dtl_interface
12364: set process_status = 3,
12365: error_code = l_v_d_ecode_err(i),
12366: error_msg = l_v_d_emsg_err(i),
12367: request_id = fnd_global.conc_request_id,
12368: program_id = fnd_global.conc_program_id,
12369: program_application_id = fnd_global.prog_appl_id
12370: where parent_header_id IS NULL
12371: and process_status = WIP_CONSTANTS.RUNNING

Line 12368: program_id = fnd_global.conc_program_id,

12364: set process_status = 3,
12365: error_code = l_v_d_ecode_err(i),
12366: error_msg = l_v_d_emsg_err(i),
12367: request_id = fnd_global.conc_request_id,
12368: program_id = fnd_global.conc_program_id,
12369: program_application_id = fnd_global.prog_appl_id
12370: where parent_header_id IS NULL
12371: and process_status = WIP_CONSTANTS.RUNNING
12372: and wip_entity_id = l_v_d_we_id_err(i)

Line 12369: program_application_id = fnd_global.prog_appl_id

12365: error_code = l_v_d_ecode_err(i),
12366: error_msg = l_v_d_emsg_err(i),
12367: request_id = fnd_global.conc_request_id,
12368: program_id = fnd_global.conc_program_id,
12369: program_application_id = fnd_global.prog_appl_id
12370: where parent_header_id IS NULL
12371: and process_status = WIP_CONSTANTS.RUNNING
12372: and wip_entity_id = l_v_d_we_id_err(i)
12373: and organization_id = l_v_d_org_id_err(i);

Line 12456: fnd_global.conc_request_id,

12452: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
12453: wsmputil.WRITE_TO_WIE (
12454: 0,
12455: substr(errbuf,1,2000),
12456: fnd_global.conc_request_id,
12457: fnd_global.conc_program_id,
12458: fnd_global.prog_appl_id,
12459: 1,
12460: dummy_err_code,

Line 12457: fnd_global.conc_program_id,

12453: wsmputil.WRITE_TO_WIE (
12454: 0,
12455: substr(errbuf,1,2000),
12456: fnd_global.conc_request_id,
12457: fnd_global.conc_program_id,
12458: fnd_global.prog_appl_id,
12459: 1,
12460: dummy_err_code,
12461: dummy_err_msg );

Line 12458: fnd_global.prog_appl_id,

12454: 0,
12455: substr(errbuf,1,2000),
12456: fnd_global.conc_request_id,
12457: fnd_global.conc_program_id,
12458: fnd_global.prog_appl_id,
12459: 1,
12460: dummy_err_code,
12461: dummy_err_msg );
12462: COMMIT;

Line 12475: fnd_global.conc_request_id,

12471:
12472: wsmputil.WRITE_TO_WIE (
12473: 0,
12474: substr(errbuf,1,2000),
12475: fnd_global.conc_request_id,
12476: fnd_global.conc_program_id,
12477: fnd_global.prog_appl_id,
12478: 1,
12479: dummy_err_code,

Line 12476: fnd_global.conc_program_id,

12472: wsmputil.WRITE_TO_WIE (
12473: 0,
12474: substr(errbuf,1,2000),
12475: fnd_global.conc_request_id,
12476: fnd_global.conc_program_id,
12477: fnd_global.prog_appl_id,
12478: 1,
12479: dummy_err_code,
12480: dummy_err_msg );

Line 12477: fnd_global.prog_appl_id,

12473: 0,
12474: substr(errbuf,1,2000),
12475: fnd_global.conc_request_id,
12476: fnd_global.conc_program_id,
12477: fnd_global.prog_appl_id,
12478: 1,
12479: dummy_err_code,
12480: dummy_err_msg );
12481: COMMIT;

Line 21098: x_user_id number := fnd_global.user_id;

21094: p_release_date in date,
21095: p_error_code out nocopy number,
21096: p_err_msg out nocopy varchar2 ) is
21097:
21098: x_user_id number := fnd_global.user_id;
21099: x_login_id number := fnd_global.login_id;
21100: --l_inv_period_id number; -- BUG3126650
21101: l_cnt number; -- bug 3571360
21102:

Line 21099: x_login_id number := fnd_global.login_id;

21095: p_error_code out nocopy number,
21096: p_err_msg out nocopy varchar2 ) is
21097:
21098: x_user_id number := fnd_global.user_id;
21099: x_login_id number := fnd_global.login_id;
21100: --l_inv_period_id number; -- BUG3126650
21101: l_cnt number; -- bug 3571360
21102:
21103: BEGIN