APPS.ASG_BASE dependencies on ASG_HELPER

Line 102: IF(asg_helper.check_is_log_enabled(g_stmt_level))

98: END LOOP;
99:
100: BEGIN
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;

Line 104: asg_helper.log(sql_string_tbl(curr_index),

100: BEGIN
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

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

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

Line 636: asg_helper.log('Not checking for device switch since Olite version is '||

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

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

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

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

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

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

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

Line 661: asg_helper.log('Device switch detected. Doing complete refresh',

657: ||' ( select item_id from asg_pub_item)' ;
658: execute immediate l_qry_string;
659: update asg_user set current_device = l_curr_dev_type
660: where user_name = p_user_name;
661: asg_helper.log('Device switch detected. Doing complete refresh',
662: 'asg_base',g_stmt_level);
663: else
664: /*Device type is same.Do nothing*/
665: null;

Line 670: asg_helper.log('Exception in detect_device_switch',

666: end if;
667: end if;
668: exception
669: when others then
670: asg_helper.log('Exception in detect_device_switch',
671: 'asg_base',g_stmt_level);
672: end detect_device_switch;
673:
674: -- Returns G_YES if the user is a valid MFS user