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

Line 2474: cursor c_chk_fnd_user_id(p_user_id number)

2470: is
2471: select user_name,user_id,resource_id from asg_user where
2472: enabled='Y' and nvl(DISABLE_USER_SYNCH,'N') = 'N';
2473: l_asg_user_rec c_all_asg_user%rowtype;
2474: cursor c_chk_fnd_user_id(p_user_id number)
2475: is
2476: select user_name from fnd_user where user_id = p_user_id;
2477: l_user_name varchar2(30);
2478: l_user_id number;

Line 2476: select user_name from fnd_user where user_id = p_user_id;

2472: enabled='Y' and nvl(DISABLE_USER_SYNCH,'N') = 'N';
2473: l_asg_user_rec c_all_asg_user%rowtype;
2474: cursor c_chk_fnd_user_id(p_user_id number)
2475: is
2476: select user_name from fnd_user where user_id = p_user_id;
2477: l_user_name varchar2(30);
2478: l_user_id number;
2479: l_err_msg varchar2(2000);
2480: cursor c_chk_fnd_user_name(p_user_name varchar2)

Line 2480: cursor c_chk_fnd_user_name(p_user_name varchar2)

2476: select user_name from fnd_user where user_id = p_user_id;
2477: l_user_name varchar2(30);
2478: l_user_id number;
2479: l_err_msg varchar2(2000);
2480: cursor c_chk_fnd_user_name(p_user_name varchar2)
2481: is
2482: select user_id from fnd_user where user_name = p_user_name;
2483: cursor c_chk_jtf_resource(p_res_id number)
2484: is

Line 2482: select user_id from fnd_user where user_name = p_user_name;

2478: l_user_id number;
2479: l_err_msg varchar2(2000);
2480: cursor c_chk_fnd_user_name(p_user_name varchar2)
2481: is
2482: select user_id from fnd_user where user_name = p_user_name;
2483: cursor c_chk_jtf_resource(p_res_id number)
2484: is
2485: select user_name from jtf_rs_resource_extns
2486: where resource_id = p_res_id

Line 2496: open c_chk_fnd_user_id(l_asg_user_rec.user_id);

2492: loop
2493: fetch c_all_asg_user into l_asg_user_rec;
2494: exit when c_all_asg_user%notfound;
2495: log('Processing user name : '||l_asg_user_rec.user_name);
2496: open c_chk_fnd_user_id(l_asg_user_rec.user_id);
2497: fetch c_chk_fnd_user_id into l_user_name;
2498: if (l_user_name is null) then
2499: /*check if user_id in asg_user exists in fnd_user table */
2500: l_err_msg := 'The user ID : '||l_asg_user_rec.user_id||

Line 2497: fetch c_chk_fnd_user_id into l_user_name;

2493: fetch c_all_asg_user into l_asg_user_rec;
2494: exit when c_all_asg_user%notfound;
2495: log('Processing user name : '||l_asg_user_rec.user_name);
2496: open c_chk_fnd_user_id(l_asg_user_rec.user_id);
2497: fetch c_chk_fnd_user_id into l_user_name;
2498: if (l_user_name is null) then
2499: /*check if user_id in asg_user exists in fnd_user table */
2500: l_err_msg := 'The user ID : '||l_asg_user_rec.user_id||
2501: ' in asg_user does not exist in fnd_user';

Line 2499: /check if user_id in asg_user exists in fnd_user table /

2495: log('Processing user name : '||l_asg_user_rec.user_name);
2496: open c_chk_fnd_user_id(l_asg_user_rec.user_id);
2497: fetch c_chk_fnd_user_id into l_user_name;
2498: if (l_user_name is null) then
2499: /*check if user_id in asg_user exists in fnd_user table */
2500: l_err_msg := 'The user ID : '||l_asg_user_rec.user_id||
2501: ' in asg_user does not exist in fnd_user';
2502: log(l_err_msg);
2503: update asg_user

Line 2501: ' in asg_user does not exist in fnd_user';

2497: fetch c_chk_fnd_user_id into l_user_name;
2498: if (l_user_name is null) then
2499: /*check if user_id in asg_user exists in fnd_user table */
2500: l_err_msg := 'The user ID : '||l_asg_user_rec.user_id||
2501: ' in asg_user does not exist in fnd_user';
2502: log(l_err_msg);
2503: update asg_user
2504: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2505: where user_name = l_asg_user_rec.user_name;

Line 2508: and fnd_user match*/

2504: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2505: where user_name = l_asg_user_rec.user_name;
2506: elsif(l_user_name <> l_asg_user_rec.user_name ) then
2507: /*Check for the user_id in asg_user, the user_name in asg_user
2508: and fnd_user match*/
2509: l_err_msg := 'For the user ID : '||l_asg_user_rec.user_id||
2510: ' the user names'||
2511: ' in asg_user and fnd_user do not match';
2512: log(l_err_msg);

Line 2511: ' in asg_user and fnd_user do not match';

2507: /*Check for the user_id in asg_user, the user_name in asg_user
2508: and fnd_user match*/
2509: l_err_msg := 'For the user ID : '||l_asg_user_rec.user_id||
2510: ' the user names'||
2511: ' in asg_user and fnd_user do not match';
2512: log(l_err_msg);
2513: update asg_user
2514: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2515: where user_name = l_asg_user_rec.user_name;

Line 2517: /Check for the user_name in asg_user, the user_id in fnd_user matches/

2513: update asg_user
2514: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2515: where user_name = l_asg_user_rec.user_name;
2516: else
2517: /*Check for the user_name in asg_user, the user_id in fnd_user matches*/
2518: open c_chk_fnd_user_name(l_asg_user_rec.user_name);
2519: fetch c_chk_fnd_user_name into l_user_id;
2520: close c_chk_fnd_user_name;
2521: if(l_user_id <> l_asg_user_rec.user_id ) then

Line 2518: open c_chk_fnd_user_name(l_asg_user_rec.user_name);

2514: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2515: where user_name = l_asg_user_rec.user_name;
2516: else
2517: /*Check for the user_name in asg_user, the user_id in fnd_user matches*/
2518: open c_chk_fnd_user_name(l_asg_user_rec.user_name);
2519: fetch c_chk_fnd_user_name into l_user_id;
2520: close c_chk_fnd_user_name;
2521: if(l_user_id <> l_asg_user_rec.user_id ) then
2522: l_err_msg := 'For the user name : '||l_asg_user_rec.user_name||

Line 2519: fetch c_chk_fnd_user_name into l_user_id;

2515: where user_name = l_asg_user_rec.user_name;
2516: else
2517: /*Check for the user_name in asg_user, the user_id in fnd_user matches*/
2518: open c_chk_fnd_user_name(l_asg_user_rec.user_name);
2519: fetch c_chk_fnd_user_name into l_user_id;
2520: close c_chk_fnd_user_name;
2521: if(l_user_id <> l_asg_user_rec.user_id ) then
2522: l_err_msg := 'For the user name : '||l_asg_user_rec.user_name||
2523: ' the '||' user ID''s do not match in '||

Line 2520: close c_chk_fnd_user_name;

2516: else
2517: /*Check for the user_name in asg_user, the user_id in fnd_user matches*/
2518: open c_chk_fnd_user_name(l_asg_user_rec.user_name);
2519: fetch c_chk_fnd_user_name into l_user_id;
2520: close c_chk_fnd_user_name;
2521: if(l_user_id <> l_asg_user_rec.user_id ) then
2522: l_err_msg := 'For the user name : '||l_asg_user_rec.user_name||
2523: ' the '||' user ID''s do not match in '||
2524: 'asg_user and fnd_user ';

Line 2524: 'asg_user and fnd_user ';

2520: close c_chk_fnd_user_name;
2521: if(l_user_id <> l_asg_user_rec.user_id ) then
2522: l_err_msg := 'For the user name : '||l_asg_user_rec.user_name||
2523: ' the '||' user ID''s do not match in '||
2524: 'asg_user and fnd_user ';
2525: log(l_err_msg);
2526: update asg_user set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2527: where user_name = l_asg_user_rec.user_name;
2528: end if;

Line 2530: close c_chk_fnd_user_id;

2526: update asg_user set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2527: where user_name = l_asg_user_rec.user_name;
2528: end if;
2529: end if;
2530: close c_chk_fnd_user_id;
2531:
2532: l_user_name := NULL;
2533: open c_chk_jtf_resource(l_asg_user_rec.resource_id);
2534: fetch c_chk_jtf_resource into l_user_name;