APPS.AHL_STATUS_ORDER_RULES_PVT dependencies on AHL_DEBUG_PUB

Line 6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

2: /* $Header: AHLVSORB.pls 115.1 2003/10/20 19:37:12 sikumar noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_STATUS_ORDER_RULES_PVT';
5: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7:
8: --
9: -----------------------------------------------------------
10: -- PACKAGE

Line 80: AHL_DEBUG_PUB.enable_debug;

76:
77: -- Check if API is called in debug mode. If yes, enable debug.
78: IF G_DEBUG='Y' THEN
79: --FND_PROFILE.put('AHL_API_FILE_DEBUG_NAME','ahlsdevakidebug.log');
80: AHL_DEBUG_PUB.enable_debug;
81: END IF;
82: -- Debug info.
83: IF G_DEBUG='Y' THEN
84: AHL_DEBUG_PUB.debug( 'enter ahl_status_order_rules_pvt.get_status_order_rules','+STORULE+');

Line 84: AHL_DEBUG_PUB.debug( 'enter ahl_status_order_rules_pvt.get_status_order_rules','+STORULE+');

80: AHL_DEBUG_PUB.enable_debug;
81: END IF;
82: -- Debug info.
83: IF G_DEBUG='Y' THEN
84: AHL_DEBUG_PUB.debug( 'enter ahl_status_order_rules_pvt.get_status_order_rules','+STORULE+');
85: END IF;
86: -- Standard call to check for call compatibility.
87: IF FND_API.to_boolean(p_init_msg_list)
88: THEN

Line 103: AHL_DEBUG_PUB.debug( 'p_current_status_code ' || p_current_status_code);

99: END IF;
100:
101: IF G_DEBUG='Y'
102: THEN
103: AHL_DEBUG_PUB.debug( 'p_current_status_code ' || p_current_status_code);
104: AHL_DEBUG_PUB.debug( 'p_system_status_type ' || p_system_status_type);
105: END IF;
106:
107: OPEN status_order_rules_cur( p_current_status_code, p_system_status_type );

Line 104: AHL_DEBUG_PUB.debug( 'p_system_status_type ' || p_system_status_type);

100:
101: IF G_DEBUG='Y'
102: THEN
103: AHL_DEBUG_PUB.debug( 'p_current_status_code ' || p_current_status_code);
104: AHL_DEBUG_PUB.debug( 'p_system_status_type ' || p_system_status_type);
105: END IF;
106:
107: OPEN status_order_rules_cur( p_current_status_code, p_system_status_type );
108:

Line 119: AHL_DEBUG_PUB.debug( 'next_status_code ' || v_status_order_rules_rec.next_status_code );

115: x_status_order_rules_tbl(l_index).next_status_meaning := v_status_order_rules_rec.meaning;
116:
117: IF G_DEBUG='Y'
118: THEN
119: AHL_DEBUG_PUB.debug( 'next_status_code ' || v_status_order_rules_rec.next_status_code );
120: AHL_DEBUG_PUB.debug( 'meaning ' || v_status_order_rules_rec.meaning );
121: AHL_DEBUG_PUB.debug( 'l_index ' || l_index );
122: END IF;
123:

Line 120: AHL_DEBUG_PUB.debug( 'meaning ' || v_status_order_rules_rec.meaning );

116:
117: IF G_DEBUG='Y'
118: THEN
119: AHL_DEBUG_PUB.debug( 'next_status_code ' || v_status_order_rules_rec.next_status_code );
120: AHL_DEBUG_PUB.debug( 'meaning ' || v_status_order_rules_rec.meaning );
121: AHL_DEBUG_PUB.debug( 'l_index ' || l_index );
122: END IF;
123:
124: l_index := l_index + 1;

Line 121: AHL_DEBUG_PUB.debug( 'l_index ' || l_index );

117: IF G_DEBUG='Y'
118: THEN
119: AHL_DEBUG_PUB.debug( 'next_status_code ' || v_status_order_rules_rec.next_status_code );
120: AHL_DEBUG_PUB.debug( 'meaning ' || v_status_order_rules_rec.meaning );
121: AHL_DEBUG_PUB.debug( 'l_index ' || l_index );
122: END IF;
123:
124: l_index := l_index + 1;
125:

Line 130: AHL_DEBUG_PUB.debug( 'Number of Status Order Rules is : ' || status_order_rules_cur%ROWCOUNT );

126: END LOOP;
127:
128: IF G_DEBUG='Y'
129: THEN
130: AHL_DEBUG_PUB.debug( 'Number of Status Order Rules is : ' || status_order_rules_cur%ROWCOUNT );
131: END IF;
132:
133: CLOSE status_order_rules_cur;
134:

Line 142: AHL_DEBUG_PUB.disable_debug;

138: EXCEPTION
139: WHEN NO_DATA_FOUND THEN
140: x_return_status := Fnd_Api.G_RET_STS_ERROR;
141: IF G_DEBUG='Y' THEN
142: AHL_DEBUG_PUB.disable_debug;
143: END IF;
144:
145: WHEN TOO_MANY_ROWS THEN
146: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 148: AHL_DEBUG_PUB.disable_debug;

144:
145: WHEN TOO_MANY_ROWS THEN
146: x_return_status := Fnd_Api.G_RET_STS_ERROR;
147: IF G_DEBUG='Y' THEN
148: AHL_DEBUG_PUB.disable_debug;
149: END IF;
150:
151: WHEN OTHERS THEN
152: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 154: AHL_DEBUG_PUB.disable_debug;

150:
151: WHEN OTHERS THEN
152: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
153: IF G_DEBUG='Y' THEN
154: AHL_DEBUG_PUB.disable_debug;
155: END IF;
156: RAISE;
157: END Get_Status_Order_Rules;
158: