DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on HR_ORGANIZATION_UNITS

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

5057: pesl.effective_date,
5058: papf.employee_number,
5059: pesl.gms_batch_name --6146805
5060: FROM psp_enc_summary_lines pesl,
5061: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
5062: pa_projects_all ppa,
5063: pa_tasks_expend_v pt, -- Replaced pa_tasks with pa_tasks_expend_v for Bug : 16391366
5064: per_time_periods ptp,
5065: per_all_people_f papf,

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

5400:
5401: IF r_interface.exp_org_name(recno) IS NULL THEN
5402: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5403: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5404: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5405: fnd_msg_pub.add;
5406: l_raise_error := TRUE;
5407: END IF;
5408:

Line 5615: l_table := 'HR_ORGANIZATION_UNITS';

5611: WHERE organization_id = int_rec.expenditure_organization_id;
5612: EXCEPTION
5613: WHEN NO_DATA_FOUND THEN
5614: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5615: l_table := 'HR_ORGANIZATION_UNITS';
5616: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5617: fnd_message.set_token('VALUE',l_value);
5618: fnd_message.set_token('TABLE',l_table);
5619: fnd_msg_pub.add;