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.GMS_AWARD_PVT dependencies on FND_USER

Line 1376: CURSOR C_fnd_user is

1372: FROM pa_agreement_types
1373: WHERE agreement_type = g_award_rec.type ;
1374:
1375: -- Debashis. Added exists clause. Removed rownum.
1376: CURSOR C_fnd_user is
1377: select 1 from dual where exists (
1378: select user_id
1379: from fnd_user
1380: where employee_id = g_award_rec.award_manager_id);

Line 1379: from fnd_user

1375: -- Debashis. Added exists clause. Removed rownum.
1376: CURSOR C_fnd_user is
1377: select 1 from dual where exists (
1378: select user_id
1379: from fnd_user
1380: where employee_id = g_award_rec.award_manager_id);
1381: -- and rownum = 1 ;
1382: BEGIN
1383: -- +++ Check Automatic Number validations +++

Line 1484: -- Award manager must be FND_USER for budget_wf_enabled_flag

1480: CLOSE C_awd_manager ;
1481: END IF ;
1482:
1483: -- ==================
1484: -- Award manager must be FND_USER for budget_wf_enabled_flag
1485: -- ================
1486:
1487: IF G_award_rec.budget_wf_enabled_flag = 'Y' THEN
1488: open c_fnd_user ;

Line 1488: open c_fnd_user ;

1484: -- Award manager must be FND_USER for budget_wf_enabled_flag
1485: -- ================
1486:
1487: IF G_award_rec.budget_wf_enabled_flag = 'Y' THEN
1488: open c_fnd_user ;
1489: fetch c_fnd_user into x_dummy ;
1490: IF c_fnd_user%NOTFOUND then
1491: add_message_to_stack( P_label => 'GMS_AWD_MGR_NOT_FND_USER' ) ;
1492: l_error := TRUE ;

Line 1489: fetch c_fnd_user into x_dummy ;

1485: -- ================
1486:
1487: IF G_award_rec.budget_wf_enabled_flag = 'Y' THEN
1488: open c_fnd_user ;
1489: fetch c_fnd_user into x_dummy ;
1490: IF c_fnd_user%NOTFOUND then
1491: add_message_to_stack( P_label => 'GMS_AWD_MGR_NOT_FND_USER' ) ;
1492: l_error := TRUE ;
1493: end if ;

Line 1490: IF c_fnd_user%NOTFOUND then

1486:
1487: IF G_award_rec.budget_wf_enabled_flag = 'Y' THEN
1488: open c_fnd_user ;
1489: fetch c_fnd_user into x_dummy ;
1490: IF c_fnd_user%NOTFOUND then
1491: add_message_to_stack( P_label => 'GMS_AWD_MGR_NOT_FND_USER' ) ;
1492: l_error := TRUE ;
1493: end if ;
1494: close c_fnd_user ;

Line 1491: add_message_to_stack( P_label => 'GMS_AWD_MGR_NOT_FND_USER' ) ;

1487: IF G_award_rec.budget_wf_enabled_flag = 'Y' THEN
1488: open c_fnd_user ;
1489: fetch c_fnd_user into x_dummy ;
1490: IF c_fnd_user%NOTFOUND then
1491: add_message_to_stack( P_label => 'GMS_AWD_MGR_NOT_FND_USER' ) ;
1492: l_error := TRUE ;
1493: end if ;
1494: close c_fnd_user ;
1495: END IF ;

Line 1494: close c_fnd_user ;

1490: IF c_fnd_user%NOTFOUND then
1491: add_message_to_stack( P_label => 'GMS_AWD_MGR_NOT_FND_USER' ) ;
1492: l_error := TRUE ;
1493: end if ;
1494: close c_fnd_user ;
1495: END IF ;
1496:
1497: IF G_award_rec.budget_wf_enabled_flag NOT IN ( 'Y', 'N' ) THEN
1498: add_message_to_stack( P_label => 'GMS_AWD_WORKFLOW_FLAG_INVALID') ;

Line 3491: fnd_user u

3487:
3488: CURSOR l_full_name_csr(p_person_id IN NUMBER ) IS
3489: SELECT 'X'
3490: from pa_employees p ,
3491: fnd_user u
3492: WHERE
3493: EXISTS (SELECT null FROM per_assignments_f a
3494: WHERE p.person_id = a.person_id
3495: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date

Line 3541: FROM fnd_user

3537: PROCEDURE Verify_User_Status (p_validate IN BOOLEAN , X_return_status IN OUT NOCOPY VARCHAR2 ) IS
3538:
3539: CURSOR l_valid_user_csr IS
3540: SELECT user_id
3541: FROM fnd_user
3542: WHERE employee_id = G_personnel_rec.person_id ;
3543:
3544: l_user_id NUMBER ;
3545:

Line 3557: add_message_to_stack( P_label => ('GMS_FND_USER_NOT_CREATED'));

3553: OPEN l_valid_user_csr ;
3554: FETCH l_valid_user_csr INTO l_user_id ;
3555: IF l_valid_user_csr%NOTFOUND THEN
3556: IF G_personnel_rec.award_role ='AM' then
3557: add_message_to_stack( P_label => ('GMS_FND_USER_NOT_CREATED'));
3558: set_return_status ( X_return_status, 'B') ;
3559: ELSE
3560: add_message_to_stack( P_label => ('GMS_WARN_NOT_FND_USER'));
3561: set_return_status ( X_return_status, 'B') ;

Line 3560: add_message_to_stack( P_label => ('GMS_WARN_NOT_FND_USER'));

3556: IF G_personnel_rec.award_role ='AM' then
3557: add_message_to_stack( P_label => ('GMS_FND_USER_NOT_CREATED'));
3558: set_return_status ( X_return_status, 'B') ;
3559: ELSE
3560: add_message_to_stack( P_label => ('GMS_WARN_NOT_FND_USER'));
3561: set_return_status ( X_return_status, 'B') ;
3562: END IF ;
3563: END IF ; -- End if for l_valid_user_csr
3564: