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

Line 4448: pv_concurrent_status := fnd_concurrent.set_completion_status('NORMAL',null);

4444: FEM_ENGINES_PKG.USER_MESSAGE
4445: (P_APP_NAME => 'FEM'
4446: ,P_MSG_NAME => 'FEM_EXEC_SUCCESS');
4447:
4448: pv_concurrent_status := fnd_concurrent.set_completion_status('NORMAL',null);
4449:
4450: FEM_ENGINES_PKG.Tech_Message
4451: (p_severity => pc_log_level_unexpected,
4452: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

Line 4459: pv_concurrent_status := fnd_concurrent.set_completion_status('ERROR',null);

4455: FEM_ENGINES_PKG.USER_MESSAGE
4456: (P_APP_NAME => 'FEM'
4457: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
4458:
4459: pv_concurrent_status := fnd_concurrent.set_completion_status('ERROR',null);
4460:
4461: FEM_ENGINES_PKG.Tech_Message
4462: (p_severity => pc_log_level_unexpected,
4463: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

Line 5157: FROM fnd_concurrent_requests c

5153: AND (u.exec_status_code IS NULL OR u.exec_status_code NOT IN ('RUNNING','SUCCESS'));
5154:
5155: CURSOR c2 IS
5156: SELECT c.request_id
5157: FROM fnd_concurrent_requests c
5158: WHERE c.parent_request_id = pv_request_id
5159: ORDER BY c.request_id;
5160:
5161: BEGIN

Line 5216: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5212:
5213: -- ============================================================================
5214: -- SET STATUS
5215: -- ============================================================================
5216: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5217: (status => v_prg_stat, message => NULL);
5218:
5219: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5220: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

Line 5252: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5248: fem_engines_pkg.user_message
5249: (p_app_name => 'FEM'
5250: ,p_msg_name => 'FEM_EXEC_RERUN');
5251:
5252: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5253: (status => 'ERROR', message => NULL);
5254:
5255: END submit_undo_lists;
5256: -- *****************************************************************************

Line 5519: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5515: FEM_ENGINES_PKG.USER_MESSAGE
5516: (P_APP_NAME => 'FEM'
5517: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5518:
5519: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5520: (status => 'ERROR', message => NULL);
5521:
5522: WHEN e_cannot_read_object THEN
5523: ROLLBACK;

Line 5535: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5531: FEM_ENGINES_PKG.USER_MESSAGE
5532: (P_APP_NAME => 'FEM'
5533: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5534:
5535: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5536: (status => 'ERROR', message => NULL);
5537:
5538: WHEN e_invalid_folder THEN
5539: fem_engines_pkg.user_message(p_app_name =>'FEM',

Line 5556: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5552: FEM_ENGINES_PKG.USER_MESSAGE
5553: (P_APP_NAME => 'FEM'
5554: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5555:
5556: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5557: (status => 'ERROR', message => NULL);
5558:
5559: WHEN e_objexec_is_running THEN
5560: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',

Line 5571: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5567: FEM_ENGINES_PKG.USER_MESSAGE
5568: (P_APP_NAME => 'FEM'
5569: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5570:
5571: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5572: (status => 'ERROR', message => NULL);
5573:
5574: WHEN e_cannot_create_undo_list THEN
5575: fem_engines_pkg.user_message(p_app_name =>'FEM',

Line 5586: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5582: FEM_ENGINES_PKG.USER_MESSAGE
5583: (P_APP_NAME => 'FEM'
5584: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5585:
5586: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5587: (status => 'ERROR', message => NULL);
5588:
5589: WHEN e_cannot_add_candidate THEN
5590: fem_engines_pkg.user_message(p_app_name =>'FEM',

Line 5601: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5597: FEM_ENGINES_PKG.USER_MESSAGE
5598: (P_APP_NAME => 'FEM'
5599: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5600:
5601: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5602: (status => 'ERROR', message => NULL);
5603:
5604: WHEN OTHERS THEN
5605: -- Unexpected exceptions

Line 5629: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5625: FEM_ENGINES_PKG.USER_MESSAGE
5626: (P_APP_NAME => 'FEM'
5627: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5628:
5629: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5630: (status => 'ERROR', message => NULL);
5631:
5632: END undo_object_execution;
5633: -- *****************************************************************************

Line 5721: v_check_status := fnd_concurrent.get_request_status (

5717:
5718: -- ============================================================================
5719: -- V03: Check to make sure request is not running.
5720: -- ============================================================================
5721: v_check_status := fnd_concurrent.get_request_status (
5722: request_id => v_request_id,
5723: phase => v_req_phase,
5724: status => v_req_status,
5725: dev_phase => v_dev_phase,

Line 5775: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5771: FEM_ENGINES_PKG.USER_MESSAGE
5772: (P_APP_NAME => 'FEM'
5773: ,P_MSG_NAME => 'FEM_EXEC_SUCCESS');
5774:
5775: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5776: (status => 'NORMAL', message => NULL);
5777:
5778: ELSE
5779: FEM_ENGINES_PKG.USER_MESSAGE

Line 5783: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5779: FEM_ENGINES_PKG.USER_MESSAGE
5780: (P_APP_NAME => 'FEM'
5781: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5782:
5783: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5784: (status => 'ERROR', message => NULL);
5785: END IF;
5786:
5787: ELSE

Line 5954: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5950: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5951: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5952: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5953:
5954: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5955: (status => 'ERROR', message => NULL);
5956:
5957: WHEN e_invalid_folder THEN
5958: fem_engines_pkg.user_message(p_app_name =>'FEM',

Line 5972: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5968: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5969: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5970: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR');
5971:
5972: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5973: (status => 'ERROR', message => NULL);
5974:
5975: WHEN e_request_is_running THEN
5976: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',

Line 5990: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

5986: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5987: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5988: p_msg_name =>'FEM_UD_REQUEST_IS_RUNNING_ERR');
5989:
5990: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5991: (status => 'ERROR', message => NULL);
5992:
5993: WHEN e_cannot_read_object THEN
5994:

Line 6010: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

6006: FEM_ENGINES_PKG.USER_MESSAGE
6007: (P_APP_NAME => 'FEM'
6008: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6009:
6010: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6011: (status => 'ERROR', message => NULL);
6012:
6013: WHEN e_cannot_create_undo_list THEN
6014: fem_engines_pkg.user_message(p_app_name =>'FEM',

Line 6025: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

6021: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6022: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6023: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6024:
6025: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6026: (status => 'ERROR', message => NULL);
6027:
6028: WHEN e_cannot_add_candidate THEN
6029: fem_engines_pkg.user_message(p_app_name =>'FEM',

Line 6043: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

6039: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6040: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6041: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6042:
6043: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6044: (status => 'ERROR', message => NULL);
6045:
6046: WHEN e_list_has_no_candidates THEN
6047: retcode := pc_ret_sts_error;

Line 6060: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

6056: FEM_ENGINES_PKG.USER_MESSAGE
6057: (P_APP_NAME => 'FEM'
6058: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6059:
6060: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6061: (status => 'ERROR', message => NULL);
6062:
6063: WHEN OTHERS THEN
6064: -- Unexpected exceptions

Line 6089: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status

6085: FEM_ENGINES_PKG.USER_MESSAGE
6086: (P_APP_NAME => 'FEM'
6087: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6088:
6089: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6090: (status => 'ERROR', message => NULL);
6091: END undo_all_obj_execs_in_request;
6092: -- *****************************************************************************
6093: PROCEDURE create_and_submit_prview_list (x_request_id OUT NOCOPY NUMBER,

Line 7703: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status('ERROR',null);

7699: p_user_msg => 'N',
7700: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
7701: );
7702:
7703: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status('ERROR',null);
7704:
7705:
7706: FEM_ENGINES_PKG.Tech_Message (
7707: p_severity => pc_log_level_unexpected

Line 7752: CURSOR c_fnd_concurrent (p_request_id IN NUMBER) IS

7748: x_return_status OUT NOCOPY VARCHAR2
7749: )
7750: IS
7751:
7752: CURSOR c_fnd_concurrent (p_request_id IN NUMBER) IS
7753: SELECT STATUS_CODE, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4,
7754: ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, requested_by,
7755: conc_login_id, CONCURRENT_PROGRAM_ID, PROGRAM_APPLICATION_ID
7756: FROM FND_CONCURRENT_REQUESTS

Line 7756: FROM FND_CONCURRENT_REQUESTS

7752: CURSOR c_fnd_concurrent (p_request_id IN NUMBER) IS
7753: SELECT STATUS_CODE, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4,
7754: ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, requested_by,
7755: conc_login_id, CONCURRENT_PROGRAM_ID, PROGRAM_APPLICATION_ID
7756: FROM FND_CONCURRENT_REQUESTS
7757: WHERE request_id = p_request_id;
7758:
7759:
7760: CURSOR c_get_output_ds_obj_def_id IS

Line 7767: l_fnd_concurrent_rec c_fnd_concurrent%ROWTYPE;

7763: where output_dataset_code = x_pl_register_record.output_dataset_code
7764: and rownum = 1;
7765:
7766:
7767: l_fnd_concurrent_rec c_fnd_concurrent%ROWTYPE;
7768:
7769: l_dummy VARCHAR2(30);
7770: l_api_name constant varchar2(30) := 'Prepare_PL_Register_Record';
7771: l_prg_msg VARCHAR2(2000);

Line 7777: OPEN c_fnd_concurrent (x_pl_register_record.request_id);

7773: l_prepare_pl_register_rc_err exception;
7774:
7775: BEGIN
7776: x_return_status := pc_ret_sts_success;
7777: OPEN c_fnd_concurrent (x_pl_register_record.request_id);
7778: FETCH c_fnd_concurrent INTO l_fnd_concurrent_rec;
7779:
7780: --FEM_ENGINES_PKG.Tech_Message (
7781: -- p_severity => pc_log_level_procedure

Line 7778: FETCH c_fnd_concurrent INTO l_fnd_concurrent_rec;

7774:
7775: BEGIN
7776: x_return_status := pc_ret_sts_success;
7777: OPEN c_fnd_concurrent (x_pl_register_record.request_id);
7778: FETCH c_fnd_concurrent INTO l_fnd_concurrent_rec;
7779:
7780: --FEM_ENGINES_PKG.Tech_Message (
7781: -- p_severity => pc_log_level_procedure
7782: -- ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name

Line 7794: -- the request is wiped out from the FND_CONCURRENT_REQUESTS

7790: p_user_msg => 'N',
7791: p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7792: );
7793:
7794: -- the request is wiped out from the FND_CONCURRENT_REQUESTS
7795: IF (c_fnd_concurrent%notfound) THEN
7796:
7797: --FEM_ENGINES_PKG.Tech_Message (
7798: -- p_severity => pc_log_level_procedure

Line 7795: IF (c_fnd_concurrent%notfound) THEN

7791: p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7792: );
7793:
7794: -- the request is wiped out from the FND_CONCURRENT_REQUESTS
7795: IF (c_fnd_concurrent%notfound) THEN
7796:
7797: --FEM_ENGINES_PKG.Tech_Message (
7798: -- p_severity => pc_log_level_procedure
7799: -- ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name

Line 7801: -- || ' wiped out from the FND_CONCURRENT_REQUESTS'

7797: --FEM_ENGINES_PKG.Tech_Message (
7798: -- p_severity => pc_log_level_procedure
7799: -- ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7800: -- ,p_msg_text => 'request_id:' || x_pl_register_record.request_id
7801: -- || ' wiped out from the FND_CONCURRENT_REQUESTS'
7802: --);
7803:
7804: write_debug(
7805: p_msg_data => 'request_id:' || x_pl_register_record.request_id

Line 7806: || ' wiped out from the FND_CONCURRENT_REQUESTS',

7802: --);
7803:
7804: write_debug(
7805: p_msg_data => 'request_id:' || x_pl_register_record.request_id
7806: || ' wiped out from the FND_CONCURRENT_REQUESTS',
7807: p_user_msg => 'N',
7808: p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7809: );
7810:

Line 7873: x_pl_register_record.cal_period_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT4);

7869: x_pl_register_record.login_id := FND_GLOBAL.login_id;
7870: x_pl_register_record.program_id := FND_GLOBAL.conc_program_id;
7871: x_pl_register_record.program_application_id := FND_GLOBAL.prog_appl_id;
7872: ELSE
7873: x_pl_register_record.cal_period_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT4);
7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);
7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;

Line 7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);

7870: x_pl_register_record.program_id := FND_GLOBAL.conc_program_id;
7871: x_pl_register_record.program_application_id := FND_GLOBAL.prog_appl_id;
7872: ELSE
7873: x_pl_register_record.cal_period_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT4);
7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);
7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;

Line 7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);

7871: x_pl_register_record.program_application_id := FND_GLOBAL.prog_appl_id;
7872: ELSE
7873: x_pl_register_record.cal_period_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT4);
7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);
7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;
7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;

Line 7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;

7872: ELSE
7873: x_pl_register_record.cal_period_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT4);
7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);
7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;
7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;

Line 7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;

7873: x_pl_register_record.cal_period_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT4);
7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);
7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;
7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7881: x_pl_register_record.accurate_eff_dt_flg := G_YES;

Line 7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;

7874: x_pl_register_record.effective_date := FND_DATE.Canonical_To_Date(l_fnd_concurrent_rec.ARGUMENT2);
7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;
7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7881: x_pl_register_record.accurate_eff_dt_flg := G_YES;
7882: END IF;

Line 7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;

7875: x_pl_register_record.dataset_io_obj_def_id := TO_NUMBER(l_fnd_concurrent_rec.ARGUMENT5);
7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;
7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7881: x_pl_register_record.accurate_eff_dt_flg := G_YES;
7882: END IF;
7883:

Line 7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;

7876: x_pl_register_record.user_id := l_fnd_concurrent_rec.requested_by;
7877: x_pl_register_record.login_id := l_fnd_concurrent_rec.conc_login_id;
7878: x_pl_register_record.program_id := l_fnd_concurrent_rec.CONCURRENT_PROGRAM_ID;
7879: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7881: x_pl_register_record.accurate_eff_dt_flg := G_YES;
7882: END IF;
7883:
7884: --FEM_ENGINES_PKG.Tech_Message (

Line 7901: CLOSE c_fnd_concurrent;

7897: p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7898: );
7899:
7900:
7901: CLOSE c_fnd_concurrent;
7902:
7903: EXCEPTION
7904:
7905: WHEN l_prepare_pl_register_rc_err THEN

Line 7906: IF (c_fnd_concurrent%ISOPEN) THEN CLOSE c_fnd_concurrent;

7902:
7903: EXCEPTION
7904:
7905: WHEN l_prepare_pl_register_rc_err THEN
7906: IF (c_fnd_concurrent%ISOPEN) THEN CLOSE c_fnd_concurrent;
7907: END IF;
7908: x_return_status := pc_ret_sts_error;
7909:
7910: WHEN OTHERS THEN

Line 7911: IF (c_fnd_concurrent%ISOPEN) THEN CLOSE c_fnd_concurrent;

7907: END IF;
7908: x_return_status := pc_ret_sts_error;
7909:
7910: WHEN OTHERS THEN
7911: IF (c_fnd_concurrent%ISOPEN) THEN CLOSE c_fnd_concurrent;
7912: END IF;
7913:
7914: l_prg_msg := SQLERRM;
7915: l_callstack := DBMS_UTILITY.Format_Call_Stack;