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');
125: fnd_msg_pub.add;
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');
125: fnd_msg_pub.add;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127:
128:
129: end if;
130: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');
131: end if;
132: end if;
133:
134:
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
469: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
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
469: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
470: fnd_msg_pub.add;
469: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
470: fnd_msg_pub.add;
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');