APPS.PSP_ENC_LIQ_TRAN dependencies on PA_PROJECTS_ALL

Line 5062: pa_projects_all ppa,

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,
5066: psp_enc_controls pec

Line 5412: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');

5408:
5409: IF r_interface.operating_unit(recno) IS NULL THEN
5410: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5411: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5412: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5413: fnd_msg_pub.add;
5414: l_raise_error := TRUE;
5415: END IF;
5416:

Line 5420: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');

5416:
5417: IF r_interface.project_number(recno) IS NULL THEN
5418: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5419: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5420: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5421: fnd_msg_pub.add;
5422: l_raise_error := TRUE;
5423: END IF;
5424:

Line 5627: FROM pa_projects_all

5623:
5624: BEGIN
5625: SELECT org_id
5626: INTO l_org_id
5627: FROM pa_projects_all
5628: WHERE project_id = int_rec.project_id;
5629: EXCEPTION
5630: WHEN NO_DATA_FOUND THEN
5631: l_value := 'Project id ='||to_char(int_rec.project_id);

Line 5632: l_table := 'PA_PROJECTS_ALL';

5628: WHERE project_id = int_rec.project_id;
5629: EXCEPTION
5630: WHEN NO_DATA_FOUND THEN
5631: l_value := 'Project id ='||to_char(int_rec.project_id);
5632: l_table := 'PA_PROJECTS_ALL';
5633: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5634: fnd_message.set_token('VALUE',l_value);
5635: fnd_message.set_token('TABLE',l_table);
5636: fnd_msg_pub.add;

Line 5643: FROM pa_projects_all

5639:
5640: BEGIN
5641: SELECT segment1
5642: INTO l_seg1
5643: FROM pa_projects_all
5644: WHERE project_id = int_rec.project_id;
5645: EXCEPTION
5646: WHEN NO_DATA_FOUND THEN
5647: l_value := 'Project id ='||to_char(int_rec.project_id);

Line 5648: l_table := 'PA_PROJECTS_ALL';

5644: WHERE project_id = int_rec.project_id;
5645: EXCEPTION
5646: WHEN NO_DATA_FOUND THEN
5647: l_value := 'Project id ='||to_char(int_rec.project_id);
5648: l_table := 'PA_PROJECTS_ALL';
5649: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5650: fnd_message.set_token('VALUE',l_value);
5651: fnd_message.set_token('TABLE',l_table);
5652: fnd_msg_pub.add;