DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_PROFILE

Line 25: g_enable_enc_summ_gl VARCHAR2(1) DEFAULT NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'), 'N'); -- Introduced for bug 2259310

21: g_rejected_group_id integer :=null; -- 3473294
22: g_accepted_group_id integer :=null; -- 3473294
23: --g_invalid_suspense varchar2(1) DEFAULT 'N'; -- Introduced for Restart Update/Quick Update Encumbrance Lines Enh. Commented for Enh. 2768298
24: -- To Check if Encumbrance Liquidation encounters invalid suspense account
25: g_enable_enc_summ_gl VARCHAR2(1) DEFAULT NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'), 'N'); -- Introduced for bug 2259310
26:
27: /* Introduced the following for bug 2935850 */
28: g_insert_str VARCHAR2(5000);
29: /* End of Bug 2935850 */

Line 120: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then

116:
117: / * Added for Position Control Integration Enh 2505778 * /
118:
119: IF p_action_type in ('U','Q') then
120: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
121: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
122: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
123: If l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
124: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');

Line 155: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

151: -- insert into psp_stout values( 'l_phase '||l_phase_status );
152: -- insert into psp_stout values( 11 ,l_phase_status );
153:
154: -- call the user extension to populate attribute1 through attribute30
155: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
156: -- 2968684 added params to following proc
157: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_st_ext.summary_ext_encumber_liq');
158: psp_st_ext.summary_ext_encumber_liq(p_payroll_id,
159: p_action_type ,

Line 197: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

193: --insert_into_psp_stout( 'l_phase '||l_phase_status );
194: -- insert into psp_stout values( 13 ,l_phase_status );
195:
196: -- call the user extension to populate attribute1 through attribute30
197: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
198: -- 2968684 added params to following proc
199: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_st_ext.summary_ext_encumber_liq');
200: psp_st_ext.summary_ext_encumber_liq(p_payroll_id,
201: p_action_type ,

Line 263: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

259: --insert_into_psp_stout( 'l_phase '||l_phase_status );
260: -- insert into psp_stout values( 15 ,l_phase_status );
261:
262: -- call the user extension to populate attribute1 through attribute30
263: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
264: -- 2968684 added params to following proc
265: psp_st_ext.summary_ext_encumber_liq(p_payroll_id,
266: p_action_type ,
267: p_business_group_id,

Line 298: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

294: --insert_into_psp_stout( 'l_phase '||l_phase_status );
295: -- insert into psp_stout values( 17 ,l_phase_status );
296:
297: -- call the user extension to populate attribute1 through attribute30
298: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
299: -- 2968684 added params to following proc
300: psp_st_ext.summary_ext_encumber_liq(p_payroll_id,
301: p_action_type ,
302: p_business_group_id,

Line 464: IF (fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y') THEN

460: p_return_status := FND_API.G_RET_STS_SUCCESS;
461: RETURN;
462: END IF;
463:
464: IF (fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y') THEN
465: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
466: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
467:
468: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 476: IF fnd_profile.value('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

472: END IF;
473: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');
474: END IF;
475:
476: IF fnd_profile.value('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
477: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_st_ext.summary_ext_encumber_liq');
478: psp_st_ext.summary_ext_encumber_liq(p_payroll_action_id, 'U', p_business_group_id, p_set_of_books_id);
479: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After psp_st_ext.summary_ext_encumber_liq');
480: END IF;

Line 490: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
489:
490: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
491: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_st_ext.summary_ext_encumber_liq');
492: psp_st_ext.summary_ext_encumber_liq(p_payroll_action_id, 'U', p_business_group_id, p_set_of_books_id);
493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After psp_st_ext.summary_ext_encumber_liq');
494: END IF;