165: CLOSE c1;
166: --
167: if (pqh_psf_bus.position_control_enabled(
168: v_posn_rec.organization_id, p_action_date) = 'N') then
169: fnd_message.set_name('PQH','PQH_ORG_NOT_POS_CONTROLLED');
170: fnd_message.raise_error;
171: end if;
172: --
173: if (v_posn_rec.review_flag = 'Y') then
166: --
167: if (pqh_psf_bus.position_control_enabled(
168: v_posn_rec.organization_id, p_action_date) = 'N') then
169: fnd_message.set_name('PQH','PQH_ORG_NOT_POS_CONTROLLED');
170: fnd_message.raise_error;
171: end if;
172: --
173: if (v_posn_rec.review_flag = 'Y') then
174: fnd_message.set_name('PQH','PQH_POSITION_UNDER_REVIEW');
170: fnd_message.raise_error;
171: end if;
172: --
173: if (v_posn_rec.review_flag = 'Y') then
174: fnd_message.set_name('PQH','PQH_POSITION_UNDER_REVIEW');
175: fnd_message.raise_error;
176: end if;
177: --
178: pqh_position_transactions_api.create_position_transaction
171: end if;
172: --
173: if (v_posn_rec.review_flag = 'Y') then
174: fnd_message.set_name('PQH','PQH_POSITION_UNDER_REVIEW');
175: fnd_message.raise_error;
176: end if;
177: --
178: pqh_position_transactions_api.create_position_transaction
179: (
3498: populate_job_requirements(p_position_transaction_id, l_position_id, l_tjr_changed);
3499: create_tjr_shadow(p_position_transaction_id);
3500: --
3501: if l_tjr_changed is not null then
3502: fnd_message.set_name('PQH', 'PQH_REQUIREMENTS_LIST');
3503: fnd_message.set_token('CLASSIFICATIONS', l_tjr_changed);
3504: l_tjr_changed := fnd_message.get;
3505: end if;
3506: --
3499: create_tjr_shadow(p_position_transaction_id);
3500: --
3501: if l_tjr_changed is not null then
3502: fnd_message.set_name('PQH', 'PQH_REQUIREMENTS_LIST');
3503: fnd_message.set_token('CLASSIFICATIONS', l_tjr_changed);
3504: l_tjr_changed := fnd_message.get;
3505: end if;
3506: --
3507: p_tjr_changed := l_tjr_changed;
3500: --
3501: if l_tjr_changed is not null then
3502: fnd_message.set_name('PQH', 'PQH_REQUIREMENTS_LIST');
3503: fnd_message.set_token('CLASSIFICATIONS', l_tjr_changed);
3504: l_tjr_changed := fnd_message.get;
3505: end if;
3506: --
3507: p_tjr_changed := l_tjr_changed;
3508: end;
3576: populate_pei(p_position_transaction_id, p_position_id, l_pei_changed);
3577: create_pte_shadow(p_position_transaction_id);
3578: --
3579: if l_pei_changed is not null then
3580: fnd_message.set_name('PQH', 'PQH_EXTRA_INFO_LIST');
3581: fnd_message.set_token('INFORMATION_TYPES', l_pei_changed);
3582: p_pte_changed := fnd_message.get;
3583: end if;
3584: --
3577: create_pte_shadow(p_position_transaction_id);
3578: --
3579: if l_pei_changed is not null then
3580: fnd_message.set_name('PQH', 'PQH_EXTRA_INFO_LIST');
3581: fnd_message.set_token('INFORMATION_TYPES', l_pei_changed);
3582: p_pte_changed := fnd_message.get;
3583: end if;
3584: --
3585: --
3578: --
3579: if l_pei_changed is not null then
3580: fnd_message.set_name('PQH', 'PQH_EXTRA_INFO_LIST');
3581: fnd_message.set_token('INFORMATION_TYPES', l_pei_changed);
3582: p_pte_changed := fnd_message.get;
3583: end if;
3584: --
3585: --
3586: end;
4074: p_prd_unit2_available => l_bpr_budget_unit2_available,
4075: p_prd_unit3_available => l_bpr_budget_unit3_available);
4076: EXCEPTION
4077: when others then
4078: fnd_message.set_name('PQH','PQH_WKS_PERIOD_PROP_ERROR');
4079: fnd_message.raise_error;
4080: END;
4081: end if;
4082: end;
4075: p_prd_unit3_available => l_bpr_budget_unit3_available);
4076: EXCEPTION
4077: when others then
4078: fnd_message.set_name('PQH','PQH_WKS_PERIOD_PROP_ERROR');
4079: fnd_message.raise_error;
4080: END;
4081: end if;
4082: end;
4083: end if;