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 119: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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