DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on HR_ORGANIZATION_UNITS

Line 4996: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734

4992: pesl.effective_date,
4993: papf.employee_number,
4994: pesl.gms_batch_name --6146805
4995: FROM psp_enc_summary_lines pesl,
4996: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
4997: pa_projects_all ppa,
4998: pa_tasks pt,
4999: per_time_periods ptp,
5000: per_all_people_f papf,

Line 5323: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');

5319:
5320: IF r_interface.exp_org_name(recno) IS NULL THEN
5321: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5322: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5323: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5324: fnd_msg_pub.add;
5325: l_raise_error := TRUE;
5326: END IF;
5327:

Line 5520: l_table := 'HR_ORGANIZATION_UNITS';

5516: WHERE organization_id = int_rec.expenditure_organization_id;
5517: EXCEPTION
5518: WHEN NO_DATA_FOUND THEN
5519: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5520: l_table := 'HR_ORGANIZATION_UNITS';
5521: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5522: fnd_message.set_token('VALUE',l_value);
5523: fnd_message.set_token('TABLE',l_table);
5524: fnd_msg_pub.add;