APPS.AHL_WIP_JOB_PVT dependencies on FND_GLOBAL

Line 86: l_wip_job_rec.created_by := fnd_global.user_id;

82: l_wip_job_rec.maintenance_object_source := 2; -- for 'AHL'
83: l_wip_job_rec.maintenance_object_type := 3; -- for 'CII'
84: l_wip_job_rec.creation_date := SYSDATE;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;

Line 87: l_wip_job_rec.last_updated_by := fnd_global.user_id;

83: l_wip_job_rec.maintenance_object_type := 3; -- for 'CII'
84: l_wip_job_rec.creation_date := SYSDATE;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;

Line 88: l_wip_job_rec.last_update_login := fnd_global.login_id;

84: l_wip_job_rec.creation_date := SYSDATE;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;

Line 89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;

85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:

Line 90: l_wip_job_rec.request_id := fnd_global.conc_request_id;

86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
94: IF p_ahl_wo_rec.dml_type = 'I' THEN

Line 91: l_wip_job_rec.program_id := fnd_global.conc_program_id;

87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
94: IF p_ahl_wo_rec.dml_type = 'I' THEN
95: l_wip_job_rec.load_type := 7; --create job

Line 92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;

88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
94: IF p_ahl_wo_rec.dml_type = 'I' THEN
95: l_wip_job_rec.load_type := 7; --create job
96: ELSIF p_ahl_wo_rec.dml_type = 'U' THEN

Line 308: l_wip_job_op_rec.created_by := fnd_global.user_id;

304: l_wip_job_op_rec.group_id := p_group_id;
305: l_wip_job_op_rec.parent_header_id := p_parent_header_id;
306: l_wip_job_op_rec.creation_date := SYSDATE;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;

Line 309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;

305: l_wip_job_op_rec.parent_header_id := p_parent_header_id;
306: l_wip_job_op_rec.creation_date := SYSDATE;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;

Line 310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;

306: l_wip_job_op_rec.creation_date := SYSDATE;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;

Line 311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;

307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:

Line 312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;

308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
316: IF p_ahl_wo_op_rec.dml_type = 'I' THEN

Line 313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;

309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
316: IF p_ahl_wo_op_rec.dml_type = 'I' THEN
317: l_wip_job_op_rec.substitution_type := 2; --add operation

Line 314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;

310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
316: IF p_ahl_wo_op_rec.dml_type = 'I' THEN
317: l_wip_job_op_rec.substitution_type := 2; --add operation
318: ELSIF p_ahl_wo_op_rec.dml_type = 'U' THEN

Line 456: l_wip_job_res_rec.created_by := fnd_global.user_id;

452: l_wip_job_res_rec.group_id := p_group_id;
453: l_wip_job_res_rec.parent_header_id := p_parent_header_id;
454: l_wip_job_res_rec.creation_date := SYSDATE;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;

Line 457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;

453: l_wip_job_res_rec.parent_header_id := p_parent_header_id;
454: l_wip_job_res_rec.creation_date := SYSDATE;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;

Line 458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;

454: l_wip_job_res_rec.creation_date := SYSDATE;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;

Line 459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;

455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:

Line 460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;

456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
464: IF p_ahl_wo_res_rec.dml_type = 'I' THEN

Line 461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;

457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
464: IF p_ahl_wo_res_rec.dml_type = 'I' THEN
465: l_wip_job_res_rec.substitution_type := 2; --add resource

Line 462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;

458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
464: IF p_ahl_wo_res_rec.dml_type = 'I' THEN
465: l_wip_job_res_rec.substitution_type := 2; --add resource
466: ELSIF p_ahl_wo_res_rec.dml_type = 'U' THEN

Line 625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;

621: l_wip_job_mtl_rec.group_id := p_group_id;
622: l_wip_job_mtl_rec.parent_header_id := p_parent_header_id;
623: l_wip_job_mtl_rec.creation_date := SYSDATE;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;

Line 626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;

622: l_wip_job_mtl_rec.parent_header_id := p_parent_header_id;
623: l_wip_job_mtl_rec.creation_date := SYSDATE;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;

Line 627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;

623: l_wip_job_mtl_rec.creation_date := SYSDATE;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;

Line 628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;

624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:

Line 629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;

625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
633: IF p_ahl_wo_mtl_rec.dml_type = 'I' THEN

Line 630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;

626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
633: IF p_ahl_wo_mtl_rec.dml_type = 'I' THEN
634: l_wip_job_mtl_rec.substitution_type := 2; --add materila

Line 631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;

627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
633: IF p_ahl_wo_mtl_rec.dml_type = 'I' THEN
634: l_wip_job_mtl_rec.substitution_type := 2; --add materila
635: ELSIF p_ahl_wo_mtl_rec.dml_type = 'U' THEN

Line 816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));

812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;

Line 817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));

813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE

Line 818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);

814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE
822: COMMIT; --This commit is a must;

Line 819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);

815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE
822: COMMIT; --This commit is a must;
823: IF G_DEBUG='Y' THEN

Line 1275: OPEN get_user_name(fnd_global.user_id);

1271: FND_MSG_PUB.add;
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:
1275: OPEN get_user_name(fnd_global.user_id);
1276: FETCH get_user_name INTO l_user_name;
1277: IF get_user_name%NOTFOUND THEN
1278: FND_MESSAGE.set_name('AHL','AHL_PRD_USER_ID_INVALID');
1279: FND_MSG_PUB.add;

Line 1316: l_wip_cost_txn_rec.created_by := fnd_global.user_id;

1312: l_wip_cost_txn_rec.source_code := 'Service';
1313:
1314: l_wip_cost_txn_rec.creation_date := sysdate;
1315: l_wip_cost_txn_rec.last_update_date := sysdate;
1316: l_wip_cost_txn_rec.created_by := fnd_global.user_id;
1317: --created_by_name is mandatory, otherwise Cost Manager won't pick it up.
1318: l_wip_cost_txn_rec.created_by_name := l_user_name.user_name;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.

Line 1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;

1315: l_wip_cost_txn_rec.last_update_date := sysdate;
1316: l_wip_cost_txn_rec.created_by := fnd_global.user_id;
1317: --created_by_name is mandatory, otherwise Cost Manager won't pick it up.
1318: l_wip_cost_txn_rec.created_by_name := l_user_name.user_name;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;

Line 1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;

1318: l_wip_cost_txn_rec.created_by_name := l_user_name.user_name;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;

Line 1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;

1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:

Line 1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;

1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1328: l_wip_cost_txn_rec.wip_entity_id := p_ahl_res_txn_tbl(i).wip_entity_id;

Line 1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;

1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1328: l_wip_cost_txn_rec.wip_entity_id := p_ahl_res_txn_tbl(i).wip_entity_id;
1329: --wip_entity_name and entity_type are mandatory, otherwise Cost Manager won't pick it up.

Line 1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;

1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1328: l_wip_cost_txn_rec.wip_entity_id := p_ahl_res_txn_tbl(i).wip_entity_id;
1329: --wip_entity_name and entity_type are mandatory, otherwise Cost Manager won't pick it up.
1330: l_wip_cost_txn_rec.wip_entity_name := l_job_attr.wip_entity_name;