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 ASG_USER

Line 534: --select user_name into l_mobile_user from asg_user where user_id=p_userid;

530: l_qid NUMBER;
531: BEGIN
532: log ('Function mark_dirty_internal - Reject Record ');
533: --l_mobile_user := asg_base.get_user_name; ---modify this logic
534: --select user_name into l_mobile_user from asg_user where user_id=p_userid;
535: -- Mark Publication Item Dirty
536: IF (insert_sdq(p_pub_item,p_username) AND
537: is_exists(p_username,p_pub_item,p_accessid,p_dml))
538: THEN

Line 1615: FROM asg_user

1611: FUNCTION get_username_from_userid ( p_userid IN NUMBER )
1612: RETURN VARCHAR2 IS
1613: CURSOR C_USER_NAME(p_userid NUMBER) IS
1614: SELECT user_name
1615: FROM asg_user
1616: WHERE user_id = p_userid
1617: AND ENABLED ='Y';
1618: l_user_name asg_user.user_name%type;
1619: BEGIN

Line 1618: l_user_name asg_user.user_name%type;

1614: SELECT user_name
1615: FROM asg_user
1616: WHERE user_id = p_userid
1617: AND ENABLED ='Y';
1618: l_user_name asg_user.user_name%type;
1619: BEGIN
1620: OPEN C_USER_NAME(p_userid);
1621: FETCH C_USER_NAME into l_user_name;
1622: CLOSE C_USER_NAME;

Line 1637: l_user_name asg_user.user_name%type;

1633:
1634: l_username_list username_list;
1635: l_accessList access_list;
1636: l_retval BOOLEAN;
1637: l_user_name asg_user.user_name%type;
1638: l_dmlList dml_list;
1639: l_ctr NUMBER;
1640: BEGIN
1641: IF ( (p_accessList.count <> p_userid_list.count ) OR

Line 1679: l_user_name asg_user.user_name%type;

1675: p_timestamp IN DATE) RETURN BOOLEAN IS
1676: l_username_list username_list;
1677: l_retval BOOLEAN;
1678: l_accessList access_list;
1679: l_user_name asg_user.user_name%type;
1680: l_ctr NUMBER;
1681: BEGIN
1682: log ('Function markDirty - Accessid-Resourceid - 1-1 - Single DML');
1683: IF (p_accessList.count <> p_userid_list.count ) THEN

Line 1771: l_user_name asg_user.user_name%type;

1767: p_timestamp IN DATE,
1768: p_bulk_flag IN BOOLEAN) RETURN BOOLEAN IS
1769: l_username_list username_list;
1770: l_retval BOOLEAN;
1771: l_user_name asg_user.user_name%type;
1772: l_ctr NUMBER;
1773:
1774: BEGIN
1775: log ('Function markDirty - Accessid-Resourceid - Many-Many ');

Line 1894: FROM asg_user_pub_resps

1890:
1891: INSERT INTO asg_purge_sdq(user_name,pub_name,creation_date,created_by,
1892: last_update_date,last_updated_by )
1893: ( SELECT user_name,pub_name ,sysdate,1,sysdate,1
1894: FROM asg_user_pub_resps
1895: WHERE user_name = l_user_name
1896: AND pub_name IN
1897: (select name from asg_pub where nvl(custom,'N') = 'N' )
1898: );

Line 1966: FROM asg_user_pub_resps

1962: l_last_processed VARCHAR2,l_max_num NUMBER,
1963: l_last_user varchar2)
1964: IS
1965: SELECT user_name,pub_name
1966: FROM asg_user_pub_resps
1967: WHERE trunc( sysdate - NVL(synch_date,to_date('1', 'J')) )
1968: > l_dormancy_period
1969: AND pub_name IN ( SELECT NAME FROM asg_pub WHERE nvl(custom,'N') = 'N' )
1970: and user_name > l_last_processed

Line 1990: SELECT user_name FROM asg_user

1986: CURSOR c_all_users(l_last_processed VARCHAR2,l_max_num NUMBER)
1987: IS
1988: SELECT user_name FROM
1989: (
1990: SELECT user_name FROM asg_user
1991: WHERE user_name > l_last_processed
1992: and user_name not in
1993: ( select distinct user_name
1994: from asg_purge_sdq where TRANSACTION_ID IS NULL )

Line 2005: FROM asg_user_pub_resps

2001: SELECT user_name FROM (
2002: SELECT ROWNUM pos,user_name FROM
2003: (
2004: SELECT DISTINCT user_name
2005: FROM asg_user_pub_resps
2006: WHERE user_name > l_last_processed
2007: AND TRUNC( SYSDATE - NVL(synch_date,TO_DATE('1', 'J')) )
2008: > l_dormancy_period
2009: ORDER BY user_name

Line 2020: FROM asg_user_pub_resps

2016: SELECT COUNT(*) FROM (
2017: SELECT ROWNUM pos,user_name FROM
2018: (
2019: SELECT DISTINCT user_name
2020: FROM asg_user_pub_resps
2021: WHERE user_name > l_last_processed
2022: AND TRUNC( SYSDATE - NVL(synch_date,TO_DATE('1', 'J')) )
2023: > l_dormancy_period
2024: ORDER BY user_name

Line 2110: --loop thru all users in asg_user and delete duplicate records.

2106: END if;
2107: CLOSE c_all_users;
2108: END IF;
2109: --delete duplicate records to start off...
2110: --loop thru all users in asg_user and delete duplicate records.
2111: l_last_user := null;
2112: SELECT SYSDATE INTO l_date FROM dual;
2113: log_concprogram('Starting to delete duplicate records : '||
2114: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),

Line 2467: cursor c_all_asg_user

2463:
2464: procedure user_incompatibility_test(P_status OUT NOCOPY VARCHAR2,
2465: P_message OUT NOCOPY VARCHAR2)
2466: is
2467: cursor c_all_asg_user
2468: is
2469: select user_name,user_id,resource_id from asg_user where
2470: enabled='Y' and nvl(DISABLE_USER_SYNCH,'N') = 'N';
2471: l_asg_user_rec c_all_asg_user%rowtype;

Line 2469: select user_name,user_id,resource_id from asg_user where

2465: P_message OUT NOCOPY VARCHAR2)
2466: is
2467: cursor c_all_asg_user
2468: is
2469: select user_name,user_id,resource_id from asg_user where
2470: enabled='Y' and nvl(DISABLE_USER_SYNCH,'N') = 'N';
2471: l_asg_user_rec c_all_asg_user%rowtype;
2472: cursor c_chk_fnd_user_id(p_user_id number)
2473: is

Line 2471: l_asg_user_rec c_all_asg_user%rowtype;

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

Line 2489: open c_all_asg_user;

2485: and ( trunc(END_DATE_ACTIVE) is null
2486: or trunc(END_DATE_ACTIVE) > trunc(sysdate) );
2487: begin
2488: log('Starting to identify user incompatibility information');
2489: open c_all_asg_user;
2490: loop
2491: fetch c_all_asg_user into l_asg_user_rec;
2492: exit when c_all_asg_user%notfound;
2493: log('Processing user name : '||l_asg_user_rec.user_name);

Line 2491: fetch c_all_asg_user into l_asg_user_rec;

2487: begin
2488: log('Starting to identify user incompatibility information');
2489: open c_all_asg_user;
2490: loop
2491: fetch c_all_asg_user into l_asg_user_rec;
2492: exit when c_all_asg_user%notfound;
2493: log('Processing user name : '||l_asg_user_rec.user_name);
2494: open c_chk_fnd_user_id(l_asg_user_rec.user_id);
2495: fetch c_chk_fnd_user_id into l_user_name;

Line 2492: exit when c_all_asg_user%notfound;

2488: log('Starting to identify user incompatibility information');
2489: open c_all_asg_user;
2490: loop
2491: fetch c_all_asg_user into l_asg_user_rec;
2492: exit when c_all_asg_user%notfound;
2493: log('Processing user name : '||l_asg_user_rec.user_name);
2494: open c_chk_fnd_user_id(l_asg_user_rec.user_id);
2495: fetch c_chk_fnd_user_id into l_user_name;
2496: if (l_user_name is null) then

Line 2493: log('Processing user name : '||l_asg_user_rec.user_name);

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

Line 2494: open c_chk_fnd_user_id(l_asg_user_rec.user_id);

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

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

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

Line 2498: l_err_msg := 'The user ID : '||l_asg_user_rec.user_id||

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

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

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

Line 2501: update asg_user

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

Line 2503: where user_name = l_asg_user_rec.user_name;

2499: ' in asg_user does not exist in fnd_user';
2500: log(l_err_msg);
2501: update asg_user
2502: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2503: where user_name = l_asg_user_rec.user_name;
2504: elsif(l_user_name <> l_asg_user_rec.user_name ) then
2505: /*Check for the user_id in asg_user, the user_name in asg_user
2506: and fnd_user match*/
2507: l_err_msg := 'For the user ID : '||l_asg_user_rec.user_id||

Line 2504: elsif(l_user_name <> l_asg_user_rec.user_name ) then

2500: log(l_err_msg);
2501: update asg_user
2502: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2503: where user_name = l_asg_user_rec.user_name;
2504: elsif(l_user_name <> l_asg_user_rec.user_name ) then
2505: /*Check for the user_id in asg_user, the user_name in asg_user
2506: and fnd_user match*/
2507: l_err_msg := 'For the user ID : '||l_asg_user_rec.user_id||
2508: ' the user names'||

Line 2505: /*Check for the user_id in asg_user, the user_name in asg_user

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

Line 2507: l_err_msg := 'For the user ID : '||l_asg_user_rec.user_id||

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

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

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

Line 2511: update asg_user

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

Line 2513: where user_name = l_asg_user_rec.user_name;

2509: ' in asg_user and fnd_user do not match';
2510: log(l_err_msg);
2511: update asg_user
2512: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2513: where user_name = l_asg_user_rec.user_name;
2514: else
2515: /*Check for the user_name in asg_user, the user_id in fnd_user matches*/
2516: open c_chk_fnd_user_name(l_asg_user_rec.user_name);
2517: fetch c_chk_fnd_user_name into l_user_id;

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

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

Line 2516: open c_chk_fnd_user_name(l_asg_user_rec.user_name);

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

Line 2519: if(l_user_id <> l_asg_user_rec.user_id ) then

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

Line 2520: l_err_msg := 'For the user name : '||l_asg_user_rec.user_name||

2516: open c_chk_fnd_user_name(l_asg_user_rec.user_name);
2517: fetch c_chk_fnd_user_name into l_user_id;
2518: close c_chk_fnd_user_name;
2519: if(l_user_id <> l_asg_user_rec.user_id ) then
2520: l_err_msg := 'For the user name : '||l_asg_user_rec.user_name||
2521: ' the '||' user ID''s do not match in '||
2522: 'asg_user and fnd_user ';
2523: log(l_err_msg);
2524: update asg_user set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg

Line 2522: 'asg_user and fnd_user ';

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

Line 2524: update asg_user set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg

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

Line 2525: where user_name = l_asg_user_rec.user_name;

2521: ' the '||' user ID''s do not match in '||
2522: 'asg_user and fnd_user ';
2523: log(l_err_msg);
2524: update asg_user set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2525: where user_name = l_asg_user_rec.user_name;
2526: end if;
2527: end if;
2528: close c_chk_fnd_user_id;
2529:

Line 2531: open c_chk_jtf_resource(l_asg_user_rec.resource_id);

2527: end if;
2528: close c_chk_fnd_user_id;
2529:
2530: l_user_name := NULL;
2531: open c_chk_jtf_resource(l_asg_user_rec.resource_id);
2532: fetch c_chk_jtf_resource into l_user_name;
2533: if(l_user_name is null) then
2534: /* Check if a record exists in jtf_rs_res* table with the
2535: same resource_id as asg_user.resource_id*/

Line 2535: same resource_id as asg_user.resource_id*/

2531: open c_chk_jtf_resource(l_asg_user_rec.resource_id);
2532: fetch c_chk_jtf_resource into l_user_name;
2533: if(l_user_name is null) then
2534: /* Check if a record exists in jtf_rs_res* table with the
2535: same resource_id as asg_user.resource_id*/
2536: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||' no'||
2537: ' record exists in jtf_rs_resource_extns ';
2538: log(l_err_msg);
2539: update asg_user

Line 2536: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||' no'||

2532: fetch c_chk_jtf_resource into l_user_name;
2533: if(l_user_name is null) then
2534: /* Check if a record exists in jtf_rs_res* table with the
2535: same resource_id as asg_user.resource_id*/
2536: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||' no'||
2537: ' record exists in jtf_rs_resource_extns ';
2538: log(l_err_msg);
2539: update asg_user
2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg

Line 2539: update asg_user

2535: same resource_id as asg_user.resource_id*/
2536: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||' no'||
2537: ' record exists in jtf_rs_resource_extns ';
2538: log(l_err_msg);
2539: update asg_user
2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2541: where user_name = l_asg_user_rec.user_name;
2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then
2543: /*Check if the resource-name matches asg_user.user_name.*/

Line 2541: where user_name = l_asg_user_rec.user_name;

2537: ' record exists in jtf_rs_resource_extns ';
2538: log(l_err_msg);
2539: update asg_user
2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2541: where user_name = l_asg_user_rec.user_name;
2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then
2543: /*Check if the resource-name matches asg_user.user_name.*/
2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||
2545: ' the user names in asg_user and resource name do not match';

Line 2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then

2538: log(l_err_msg);
2539: update asg_user
2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2541: where user_name = l_asg_user_rec.user_name;
2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then
2543: /*Check if the resource-name matches asg_user.user_name.*/
2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||
2545: ' the user names in asg_user and resource name do not match';
2546: log(l_err_msg);

Line 2543: /Check if the resource-name matches asg_user.user_name./

2539: update asg_user
2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2541: where user_name = l_asg_user_rec.user_name;
2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then
2543: /*Check if the resource-name matches asg_user.user_name.*/
2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||
2545: ' the user names in asg_user and resource name do not match';
2546: log(l_err_msg);
2547: update asg_user

Line 2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||

2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2541: where user_name = l_asg_user_rec.user_name;
2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then
2543: /*Check if the resource-name matches asg_user.user_name.*/
2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||
2545: ' the user names in asg_user and resource name do not match';
2546: log(l_err_msg);
2547: update asg_user
2548: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg

Line 2545: ' the user names in asg_user and resource name do not match';

2541: where user_name = l_asg_user_rec.user_name;
2542: elsif( l_user_name <> l_asg_user_rec.user_name ) then
2543: /*Check if the resource-name matches asg_user.user_name.*/
2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||
2545: ' the user names in asg_user and resource name do not match';
2546: log(l_err_msg);
2547: update asg_user
2548: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2549: where user_name = l_asg_user_rec.user_name;

Line 2547: update asg_user

2543: /*Check if the resource-name matches asg_user.user_name.*/
2544: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||
2545: ' the user names in asg_user and resource name do not match';
2546: log(l_err_msg);
2547: update asg_user
2548: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2549: where user_name = l_asg_user_rec.user_name;
2550: end if;
2551: close c_chk_jtf_resource;

Line 2549: where user_name = l_asg_user_rec.user_name;

2545: ' the user names in asg_user and resource name do not match';
2546: log(l_err_msg);
2547: update asg_user
2548: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2549: where user_name = l_asg_user_rec.user_name;
2550: end if;
2551: close c_chk_jtf_resource;
2552: end loop;
2553: close c_all_asg_user;

Line 2553: close c_all_asg_user;

2549: where user_name = l_asg_user_rec.user_name;
2550: end if;
2551: close c_chk_jtf_resource;
2552: end loop;
2553: close c_all_asg_user;
2554: commit;
2555: log('Done identifying user incompatibility information');
2556:
2557: p_status := 'Fine';