DBA Data[Home] [Help]

APPS.AHL_UTILITY_PVT dependencies on AHL_DEBUG_PUB

Line 173: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

169: l_sql := l_sql || ' WHERE LOOKUP_TYPE = :b1';
170: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
171: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
172:
173: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
174: Ahl_Debug_Pub.debug( 'SQL statement'||l_sql);
175: END IF;
176: debug_message('SQL statement: '||l_sql);
177: BEGIN

Line 174: Ahl_Debug_Pub.debug( 'SQL statement'||l_sql);

170: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
171: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
172:
173: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
174: Ahl_Debug_Pub.debug( 'SQL statement'||l_sql);
175: END IF;
176: debug_message('SQL statement: '||l_sql);
177: BEGIN
178: EXECUTE IMMEDIATE l_sql INTO l_count

Line 483: Ahl_Debug_Pub.enable_debug;

479: l_dummy NUMBER;
480:
481: BEGIN
482:
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);

Line 485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

481: BEGIN
482:
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);

Line 486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);

482:
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;

Line 487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);

483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
491:

Line 488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);

484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
491:
492: -- get currant system status code

Line 489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);

485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
491:
492: -- get currant system status code
493: OPEN cur_stat_det(p_status_type,