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 1377: CURSOR C_fnd_user is

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

Line 1380: from fnd_user

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

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

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

Line 1489: open c_fnd_user ;

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

Line 1490: fetch c_fnd_user into x_dummy ;

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

Line 1491: IF c_fnd_user%NOTFOUND then

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

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

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

Line 1495: close c_fnd_user ;

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

Line 3492: fnd_user u

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

Line 3543: FROM fnd_user

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

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

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

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

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