eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_SUM_TRANS dependencies on PA_PROJECTS_ALL

Line 3936: FROM pa_projects_all

3932: -- get the project number
3933: BEGIN
3934: SELECT segment1
3935: INTO l_segment1
3936: FROM pa_projects_all
3937: WHERE project_id = gms_interface_rec.project_Id;
3938: EXCEPTION
3939: WHEN NO_DATA_FOUND THEN
3940: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);

Line 3941: l_table := 'PA_PROJECTS_ALL';

3937: WHERE project_id = gms_interface_rec.project_Id;
3938: EXCEPTION
3939: WHEN NO_DATA_FOUND THEN
3940: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3941: l_table := 'PA_PROJECTS_ALL';
3942: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3943: fnd_message.set_token('VALUE',l_value);
3944: fnd_message.set_token('TABLE',l_table);
3945: fnd_msg_pub.add;

Line 3955: FROM pa_projects_all

3951: -- get the org_id for the project..
3952: BEGIN
3953: SELECT org_id
3954: INTO l_org_id
3955: FROM pa_projects_all
3956: WHERE project_id = gms_interface_rec.project_Id;
3957: EXCEPTION
3958: WHEN NO_DATA_FOUND THEN
3959: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);

Line 3960: l_table := 'PA_PROJECTS_ALL';

3956: WHERE project_id = gms_interface_rec.project_Id;
3957: EXCEPTION
3958: WHEN NO_DATA_FOUND THEN
3959: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3960: l_table := 'PA_PROJECTS_ALL';
3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3962: fnd_message.set_token('VALUE',l_value);
3963: fnd_message.set_token('TABLE',l_table);
3964: fnd_msg_pub.add;