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 3736: FROM pa_projects_all

3732: -- get the project number
3733: BEGIN
3734: SELECT segment1
3735: INTO l_segment1
3736: FROM pa_projects_all
3737: WHERE project_id = gms_interface_rec.project_Id;
3738: EXCEPTION
3739: WHEN NO_DATA_FOUND THEN
3740: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);

Line 3741: l_table := 'PA_PROJECTS_ALL';

3737: WHERE project_id = gms_interface_rec.project_Id;
3738: EXCEPTION
3739: WHEN NO_DATA_FOUND THEN
3740: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3741: l_table := 'PA_PROJECTS_ALL';
3742: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3743: fnd_message.set_token('VALUE',l_value);
3744: fnd_message.set_token('TABLE',l_table);
3745: fnd_msg_pub.add;

Line 3755: FROM pa_projects_all

3751: -- get the org_id for the project..
3752: BEGIN
3753: SELECT org_id
3754: INTO l_org_id
3755: FROM pa_projects_all
3756: WHERE project_id = gms_interface_rec.project_Id;
3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN
3759: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);

Line 3760: l_table := 'PA_PROJECTS_ALL';

3756: WHERE project_id = gms_interface_rec.project_Id;
3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN
3759: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3760: l_table := 'PA_PROJECTS_ALL';
3761: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3762: fnd_message.set_token('VALUE',l_value);
3763: fnd_message.set_token('TABLE',l_table);
3764: fnd_msg_pub.add;