DBA Data[Home] [Help]

APPS.ASO_CFG_PUB dependencies on ASO_DEBUG_PUB

Line 82: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

78:
79: -- Standard Start of API savepoint
80: SAVEPOINT GET_CONFIG_DETAILS_PUB;
81:
82: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
83:
84: -- Standard call to check for call compatibility.
85: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
86: p_api_version_number,

Line 94: IF aso_debug_pub.g_debug_flag = 'Y' THEN

90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91:
92: END IF;
93:
94: IF aso_debug_pub.g_debug_flag = 'Y' THEN
95: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS start %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 95: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS start %%%%%%%%%%%%%%%%%%%', 1, 'Y' );

91:
92: END IF;
93:
94: IF aso_debug_pub.g_debug_flag = 'Y' THEN
95: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS start %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 140: IF aso_debug_pub.g_debug_flag = 'Y' THEN

136: -- Standard call to get message count and if count is 1, get message info.
137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data);
139:
140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
141: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS End %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
142: END IF;
143:
144: EXCEPTION

Line 141: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS End %%%%%%%%%%%%%%%%%%%', 1, 'Y' );

137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data);
139:
140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
141: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS End %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
142: END IF;
143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_ERROR THEN

Line 184: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

180: is
181:
182: Begin
183:
184: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
185:
186: ASO_CFG_INT.Pricing_Callback(p_config_session_key => p_config_session_key,
187: p_price_type => p_price_type,
188: x_total_price => x_total_price );

Line 203: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

199:
200: l_price_type VARCHAR2(10);
201:
202: Begin
203: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );

Line 205: IF aso_debug_pub.g_debug_flag = 'Y' THEN

201:
202: Begin
203: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
208: aso_debug_pub.add('pricing_callback_manual: p_config_session_key: ' || p_config_session_key);
209: aso_debug_pub.add('pricing_callback_manual: p_price_type: ' || p_price_type);

Line 207: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );

203: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
208: aso_debug_pub.add('pricing_callback_manual: p_config_session_key: ' || p_config_session_key);
209: aso_debug_pub.add('pricing_callback_manual: p_price_type: ' || p_price_type);
210:
211: END IF;

Line 208: aso_debug_pub.add('pricing_callback_manual: p_config_session_key: ' || p_config_session_key);

204:
205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
208: aso_debug_pub.add('pricing_callback_manual: p_config_session_key: ' || p_config_session_key);
209: aso_debug_pub.add('pricing_callback_manual: p_price_type: ' || p_price_type);
210:
211: END IF;
212:

Line 209: aso_debug_pub.add('pricing_callback_manual: p_price_type: ' || p_price_type);

205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
206:
207: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
208: aso_debug_pub.add('pricing_callback_manual: p_config_session_key: ' || p_config_session_key);
209: aso_debug_pub.add('pricing_callback_manual: p_price_type: ' || p_price_type);
210:
211: END IF;
212:
213: l_price_type := cz_prc_callback_util.g_prc_type_list;

Line 215: IF aso_debug_pub.g_debug_flag = 'Y' THEN

211: END IF;
212:
213: l_price_type := cz_prc_callback_util.g_prc_type_list;
214:
215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
216: aso_debug_pub.add('pricing_callback_manual: l_price_type: ' || l_price_type);
217: END IF;
218:
219: pricing_callback( p_config_session_key => p_config_session_key,

Line 216: aso_debug_pub.add('pricing_callback_manual: l_price_type: ' || l_price_type);

212:
213: l_price_type := cz_prc_callback_util.g_prc_type_list;
214:
215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
216: aso_debug_pub.add('pricing_callback_manual: l_price_type: ' || l_price_type);
217: END IF;
218:
219: pricing_callback( p_config_session_key => p_config_session_key,
220: p_price_type => l_price_type,

Line 223: IF aso_debug_pub.g_debug_flag = 'Y' THEN

219: pricing_callback( p_config_session_key => p_config_session_key,
220: p_price_type => l_price_type,
221: x_total_price => x_total_price);
222:
223: IF aso_debug_pub.g_debug_flag = 'Y' THEN
224:
225: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );
226:
227: END IF;

Line 225: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );

221: x_total_price => x_total_price);
222:
223: IF aso_debug_pub.g_debug_flag = 'Y' THEN
224:
225: aso_debug_pub.add('ASO_CFG_PUB: pricing_callback_manual End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );
226:
227: END IF;
228:
229: End pricing_callback_manual;

Line 241: l_debug_level CONSTANT NUMBER := aso_debug_pub.g_debug_level;

237: ) IS
238: l_currency_code VARCHAR2(15);
239: l_top_line_id_pos NUMBER;
240: l_top_model_line_id NUMBER;
241: l_debug_level CONSTANT NUMBER := aso_debug_pub.g_debug_level;
242: BEGIN
243: IF l_debug_level > 0 THEN
244: aso_debug_pub.add ('Entering aso_Config_Price_Items_MLS - '
245: || p_config_session_key || ' ***** ' || p_price_type);

Line 244: aso_debug_pub.add ('Entering aso_Config_Price_Items_MLS - '

240: l_top_model_line_id NUMBER;
241: l_debug_level CONSTANT NUMBER := aso_debug_pub.g_debug_level;
242: BEGIN
243: IF l_debug_level > 0 THEN
244: aso_debug_pub.add ('Entering aso_Config_Price_Items_MLS - '
245: || p_config_session_key || ' ***** ' || p_price_type);
246: END IF;
247:
248: l_top_line_id_pos := INSTR (p_config_session_key, '-' );

Line 252: aso_debug_pub.add('top_model_line_id - ' || l_top_model_line_id);

248: l_top_line_id_pos := INSTR (p_config_session_key, '-' );
249: l_top_model_line_id := TO_NUMBER (SUBSTR (p_config_session_key, 1, l_top_line_id_pos - 1));
250:
251: IF l_debug_level > 0 THEN
252: aso_debug_pub.add('top_model_line_id - ' || l_top_model_line_id);
253: END IF;
254:
255: SELECT DISTINCT h.currency_code
256: INTO x_currency_code

Line 269: aso_debug_pub.add('Exiting ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls');

265: x_total_price => x_total_price
266: );
267:
268: IF l_debug_level > 0 THEN
269: aso_debug_pub.add('Exiting ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls');
270: END IF;
271:
272: EXCEPTION
273: WHEN TOO_MANY_ROWS THEN

Line 275: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - TOO_MANY_ROWS');

271:
272: EXCEPTION
273: WHEN TOO_MANY_ROWS THEN
274: IF l_debug_level > 0 THEN
275: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - TOO_MANY_ROWS');
276: END IF;
277: WHEN OTHERS THEN
278: IF l_debug_level > 0 THEN
279: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - OTHERS');

Line 279: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - OTHERS');

275: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - TOO_MANY_ROWS');
276: END IF;
277: WHEN OTHERS THEN
278: IF l_debug_level > 0 THEN
279: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - OTHERS');
280: END IF;
281: END aso_config_price_items_mls;
282: -- end bug8278795
283:

Line 294: l_debug_level CONSTANT NUMBER := aso_debug_pub.g_debug_level;

290: ) IS
291: l_currency_code VARCHAR2(15);
292: l_top_line_id_pos NUMBER;
293: l_top_model_line_id NUMBER;
294: l_debug_level CONSTANT NUMBER := aso_debug_pub.g_debug_level;
295: BEGIN
296: IF l_debug_level > 0 THEN
297: aso_debug_pub.add ('Entering aso_Config_Price_Items_MLS - '
298: || p_config_session_key || ' ***** ' || p_price_type);

Line 297: aso_debug_pub.add ('Entering aso_Config_Price_Items_MLS - '

293: l_top_model_line_id NUMBER;
294: l_debug_level CONSTANT NUMBER := aso_debug_pub.g_debug_level;
295: BEGIN
296: IF l_debug_level > 0 THEN
297: aso_debug_pub.add ('Entering aso_Config_Price_Items_MLS - '
298: || p_config_session_key || ' ***** ' || p_price_type);
299: END IF;
300:
301: l_top_line_id_pos := INSTR (p_config_session_key, '-' );

Line 305: aso_debug_pub.add('top_model_line_id - ' || l_top_model_line_id);

301: l_top_line_id_pos := INSTR (p_config_session_key, '-' );
302: l_top_model_line_id := TO_NUMBER (SUBSTR (p_config_session_key, 1, l_top_line_id_pos - 1));
303:
304: IF l_debug_level > 0 THEN
305: aso_debug_pub.add('top_model_line_id - ' || l_top_model_line_id);
306: END IF;
307:
308: SELECT DISTINCT h.currency_code
309: INTO x_currency_code

Line 322: aso_debug_pub.add('Exiting ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls');

318: x_total_price => x_total_price
319: );
320:
321: IF l_debug_level > 0 THEN
322: aso_debug_pub.add('Exiting ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls');
323: END IF;
324:
325: EXCEPTION
326: WHEN TOO_MANY_ROWS THEN

Line 328: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - TOO_MANY_ROWS');

324:
325: EXCEPTION
326: WHEN TOO_MANY_ROWS THEN
327: IF l_debug_level > 0 THEN
328: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - TOO_MANY_ROWS');
329: END IF;
330: WHEN OTHERS THEN
331: IF l_debug_level > 0 THEN
332: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - OTHERS');

Line 332: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - OTHERS');

328: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - TOO_MANY_ROWS');
329: END IF;
330: WHEN OTHERS THEN
331: IF l_debug_level > 0 THEN
332: aso_debug_pub.add('Exception ASO_CONFIG_PRICE_UTIL.ASO_config_price_items_mls - OTHERS');
333: END IF;
334: END Aso_Config_Price_Items_MLS_Man;
335: -- end bug8278795
336: