APPS.PSP_ENC_LIQ_TRAN dependencies on PA_PROJECTS_ALL

Line 4997: pa_projects_all ppa,

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

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

5327:
5328: IF r_interface.operating_unit(recno) IS NULL THEN
5329: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5330: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5331: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5332: fnd_msg_pub.add;
5333: l_raise_error := TRUE;
5334: END IF;
5335:

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

5335:
5336: IF r_interface.project_number(recno) IS NULL THEN
5337: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5338: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5339: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5340: fnd_msg_pub.add;
5341: l_raise_error := TRUE;
5342: END IF;
5343:

Line 5532: FROM pa_projects_all

5528:
5529: BEGIN
5530: SELECT org_id
5531: INTO l_org_id
5532: FROM pa_projects_all
5533: WHERE project_id = int_rec.project_id;
5534: EXCEPTION
5535: WHEN NO_DATA_FOUND THEN
5536: l_value := 'Project id ='||to_char(int_rec.project_id);

Line 5537: l_table := 'PA_PROJECTS_ALL';

5533: WHERE project_id = int_rec.project_id;
5534: EXCEPTION
5535: WHEN NO_DATA_FOUND THEN
5536: l_value := 'Project id ='||to_char(int_rec.project_id);
5537: l_table := 'PA_PROJECTS_ALL';
5538: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5539: fnd_message.set_token('VALUE',l_value);
5540: fnd_message.set_token('TABLE',l_table);
5541: fnd_msg_pub.add;

Line 5548: FROM pa_projects_all

5544:
5545: BEGIN
5546: SELECT segment1
5547: INTO l_seg1
5548: FROM pa_projects_all
5549: WHERE project_id = int_rec.project_id;
5550: EXCEPTION
5551: WHEN NO_DATA_FOUND THEN
5552: l_value := 'Project id ='||to_char(int_rec.project_id);

Line 5553: l_table := 'PA_PROJECTS_ALL';

5549: WHERE project_id = int_rec.project_id;
5550: EXCEPTION
5551: WHEN NO_DATA_FOUND THEN
5552: l_value := 'Project id ='||to_char(int_rec.project_id);
5553: l_table := 'PA_PROJECTS_ALL';
5554: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5555: fnd_message.set_token('VALUE',l_value);
5556: fnd_message.set_token('TABLE',l_table);
5557: fnd_msg_pub.add;