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_BASE dependencies on ASG_BASE

Line 1: PACKAGE BODY asg_base AS

1: PACKAGE BODY asg_base AS
2: /*$Header: asgbaseb.pls 120.8 2011/01/10 11:14:45 saradhak ship $*/
3:
4: -- DESCRIPTION
5: -- Contains functions to retrieve information during a synch session.

Line 105: 'asg_base',g_stmt_level);

101: FOR curr_index in 1..sql_string_tbl.count LOOP
102: IF(asg_helper.check_is_log_enabled(g_stmt_level))
103: THEN
104: asg_helper.log(sql_string_tbl(curr_index),
105: 'asg_base',g_stmt_level);
106: END IF;
107: END LOOP;
108: EXCEPTION
109: WHEN OTHERS THEN

Line 629: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_config ' ||

625: l_param VARCHAR2(30) := 'VERSION';
626: begin
627: IF (g_olite_version IS NULL) THEN
628: l_qry_string := 'SELECT value ' ||
629: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_config ' ||
630: 'WHERE param = :1';
631: EXECUTE IMMEDIATE l_qry_string
632: INTO g_olite_version
633: USING l_param;

Line 636: asg_helper.log('Olite version : '||g_olite_version,'asg_base',g_stmt_level);

632: INTO g_olite_version
633: USING l_param;
634: END IF;
635: l_version := to_number(substr(g_olite_version,1,instr(g_olite_version,'.')-1));
636: asg_helper.log('Olite version : '||g_olite_version,'asg_base',g_stmt_level);
637: if(l_version < 10) then
638: asg_helper.log('Not checking for device switch since Olite version is '||
639: 'less than 10.0.0.0.0','asg_base',g_stmt_level);
640: else

Line 639: 'less than 10.0.0.0.0','asg_base',g_stmt_level);

635: l_version := to_number(substr(g_olite_version,1,instr(g_olite_version,'.')-1));
636: asg_helper.log('Olite version : '||g_olite_version,'asg_base',g_stmt_level);
637: if(l_version < 10) then
638: asg_helper.log('Not checking for device switch since Olite version is '||
639: 'less than 10.0.0.0.0','asg_base',g_stmt_level);
640: else
641: asg_helper.log('Checking for device switch','asg_base',g_stmt_level);
642: open c_get_dev_type(p_user_name);
643: fetch c_get_dev_type into l_prev_dev_type;

Line 641: asg_helper.log('Checking for device switch','asg_base',g_stmt_level);

637: if(l_version < 10) then
638: asg_helper.log('Not checking for device switch since Olite version is '||
639: 'less than 10.0.0.0.0','asg_base',g_stmt_level);
640: else
641: asg_helper.log('Checking for device switch','asg_base',g_stmt_level);
642: open c_get_dev_type(p_user_name);
643: fetch c_get_dev_type into l_prev_dev_type;
644: close c_get_dev_type;
645:

Line 648: asg_helper.log('Previous device : '||l_prev_dev_type,'asg_base',g_stmt_level);

644: close c_get_dev_type;
645:
646: l_curr_dev_type := get_device_type_name;
647: p_device_type := l_curr_dev_type;
648: asg_helper.log('Previous device : '||l_prev_dev_type,'asg_base',g_stmt_level);
649: asg_helper.log('Current device : '||l_curr_dev_type,'asg_base',g_stmt_level);
650:
651: if (l_prev_dev_type is null) then
652: /*First time synch*/

Line 649: asg_helper.log('Current device : '||l_curr_dev_type,'asg_base',g_stmt_level);

645:
646: l_curr_dev_type := get_device_type_name;
647: p_device_type := l_curr_dev_type;
648: asg_helper.log('Previous device : '||l_prev_dev_type,'asg_base',g_stmt_level);
649: asg_helper.log('Current device : '||l_curr_dev_type,'asg_base',g_stmt_level);
650:
651: if (l_prev_dev_type is null) then
652: /*First time synch*/
653: -- commented for Deadlock issue

Line 657: 'asg_base',g_stmt_level);

653: -- commented for Deadlock issue
654: -- update asg_user set current_device = l_curr_dev_type
655: -- where user_name = p_user_name;
656: asg_helper.log('First Time Synch.Device type is set only now',
657: 'asg_base',g_stmt_level);
658: elsif(l_prev_dev_type <> l_curr_dev_type ) then
659: /*device switch detected .Set to complete refresh*/
660: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '
661: ||'set comp_ref = ''Y'' '||' where name IN '

Line 660: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '

656: asg_helper.log('First Time Synch.Device type is set only now',
657: 'asg_base',g_stmt_level);
658: elsif(l_prev_dev_type <> l_curr_dev_type ) then
659: /*device switch detected .Set to complete refresh*/
660: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '
661: ||'set comp_ref = ''Y'' '||' where name IN '
662: ||' ( select item_id from asg_pub_item)' ;
663: execute immediate l_qry_string;
664: -- commented for Deadlock issue

Line 668: 'asg_base',g_stmt_level);

664: -- commented for Deadlock issue
665: -- update asg_user set current_device = l_curr_dev_type
666: -- where user_name = p_user_name;
667: asg_helper.log('Device switch detected. Doing complete refresh',
668: 'asg_base',g_stmt_level);
669: else
670: /*Device type is same.Do nothing*/
671: null;
672: end if;

Line 677: 'asg_base',g_stmt_level);

673: end if;
674: exception
675: when others then
676: asg_helper.log('Exception in detect_device_switch',
677: 'asg_base',g_stmt_level);
678: end detect_device_switch;
679:
680: -- Returns G_YES if the user is a valid MFS user
681: FUNCTION is_mobile_user(p_user_id IN NUMBER)

Line 752: 'asg_base',g_stmt_level);

748: l_autosync := 'N';
749: IF(asg_helper.check_is_log_enabled(g_err_level))
750: THEN
751: asg_helper.log('Exception in is_auto_sync: ' || sqlerrm ,
752: 'asg_base',g_stmt_level);
753: END IF;
754: END;
755:
756: IF(asg_helper.check_is_log_enabled(g_stmt_level))

Line 759: 'asg_base',g_stmt_level);

755:
756: IF(asg_helper.check_is_log_enabled(g_stmt_level))
757: THEN
758: asg_helper.log('is_auto_sync: Auto Sync is: '|| l_autosync ,
759: 'asg_base',g_stmt_level);
760: END IF;
761:
762: RETURN l_autosync;
763:

Line 798: 'asg_base',g_stmt_level);

794: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
795:
796: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
797: asg_helper.log('is_download_only_sync: is: '|| l_download_only ,
798: 'asg_base',g_stmt_level);
799: END IF;
800:
801: RETURN l_download_only;
802:

Line 805: END asg_base;

801: RETURN l_download_only;
802:
803: END is_download_only_sync;
804:
805: END asg_base;