217:
218: BEGIN
219: SAVEPOINT COPY_CONFIGURATION_INT;
220:
221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('ASO_CFG_INT: Begin Copy_Configuration');
223: END IF;
224:
225: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
218: BEGIN
219: SAVEPOINT COPY_CONFIGURATION_INT;
220:
221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('ASO_CFG_INT: Begin Copy_Configuration');
223: END IF;
224:
225: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
226: p_api_version_number,
231:
232:
233: END IF;
234:
235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
236: aso_debug_pub.add('copy_configuration: p_init_msg_list: '|| p_init_msg_list);
237: END IF;
238:
239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
232:
233: END IF;
234:
235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
236: aso_debug_pub.add('copy_configuration: p_init_msg_list: '|| p_init_msg_list);
237: END IF;
238:
239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
240: FND_MSG_PUB.initialize;
241: END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246:
247: aso_debug_pub.add('copy_configuration: p_config_header_id: '|| p_config_header_id);
248: aso_debug_pub.add('copy_configuration: p_config_revision_num: '|| p_config_revision_num);
249: aso_debug_pub.add('copy_configuration: p_copy_mode: '|| p_copy_mode);
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246:
247: aso_debug_pub.add('copy_configuration: p_config_header_id: '|| p_config_header_id);
248: aso_debug_pub.add('copy_configuration: p_config_revision_num: '|| p_config_revision_num);
249: aso_debug_pub.add('copy_configuration: p_copy_mode: '|| p_copy_mode);
250: aso_debug_pub.add('copy_configuration: p_autonomous_flag: '|| p_autonomous_flag);
251:
244:
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246:
247: aso_debug_pub.add('copy_configuration: p_config_header_id: '|| p_config_header_id);
248: aso_debug_pub.add('copy_configuration: p_config_revision_num: '|| p_config_revision_num);
249: aso_debug_pub.add('copy_configuration: p_copy_mode: '|| p_copy_mode);
250: aso_debug_pub.add('copy_configuration: p_autonomous_flag: '|| p_autonomous_flag);
251:
252: END IF;
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246:
247: aso_debug_pub.add('copy_configuration: p_config_header_id: '|| p_config_header_id);
248: aso_debug_pub.add('copy_configuration: p_config_revision_num: '|| p_config_revision_num);
249: aso_debug_pub.add('copy_configuration: p_copy_mode: '|| p_copy_mode);
250: aso_debug_pub.add('copy_configuration: p_autonomous_flag: '|| p_autonomous_flag);
251:
252: END IF;
253:
246:
247: aso_debug_pub.add('copy_configuration: p_config_header_id: '|| p_config_header_id);
248: aso_debug_pub.add('copy_configuration: p_config_revision_num: '|| p_config_revision_num);
249: aso_debug_pub.add('copy_configuration: p_copy_mode: '|| p_copy_mode);
250: aso_debug_pub.add('copy_configuration: p_autonomous_flag: '|| p_autonomous_flag);
251:
252: END IF;
253:
254:
254:
255: open c_config_rev_nbr;
256: fetch c_config_rev_nbr into l_config_rev_nbr;
257:
258: IF aso_debug_pub.g_debug_flag = 'Y' THEN
259: aso_debug_pub.add('After cursor c_config_rev_nbr l_config_rev_nbr: '||l_config_rev_nbr);
260: END IF;
261:
262: IF c_config_rev_nbr%NOTFOUND THEN
255: open c_config_rev_nbr;
256: fetch c_config_rev_nbr into l_config_rev_nbr;
257:
258: IF aso_debug_pub.g_debug_flag = 'Y' THEN
259: aso_debug_pub.add('After cursor c_config_rev_nbr l_config_rev_nbr: '||l_config_rev_nbr);
260: END IF;
261:
262: IF c_config_rev_nbr%NOTFOUND THEN
263:
263:
264: open c_config_max_rev_nbr;
265: fetch c_config_max_rev_nbr into l_config_rev_nbr;
266:
267: IF aso_debug_pub.g_debug_flag = 'Y' THEN
268: aso_debug_pub.add('After cursor c_config_max_rev_nbr l_config_rev_nbr: '||l_config_rev_nbr);
269: END IF;
270:
271: close c_config_max_rev_nbr;
264: open c_config_max_rev_nbr;
265: fetch c_config_max_rev_nbr into l_config_rev_nbr;
266:
267: IF aso_debug_pub.g_debug_flag = 'Y' THEN
268: aso_debug_pub.add('After cursor c_config_max_rev_nbr l_config_rev_nbr: '||l_config_rev_nbr);
269: END IF;
270:
271: close c_config_max_rev_nbr;
272:
272:
273: END IF;
274: close c_config_rev_nbr;
275:
276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
277: aso_debug_pub.add('Before call to cz_config_api_pub.copy_configuration');
278: END IF;
279:
280: IF p_autonomous_flag = fnd_api.g_true THEN
273: END IF;
274: close c_config_rev_nbr;
275:
276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
277: aso_debug_pub.add('Before call to cz_config_api_pub.copy_configuration');
278: END IF;
279:
280: IF p_autonomous_flag = fnd_api.g_true THEN
281:
293: x_msg_count => x_msg_count,
294: x_msg_data => x_msg_data
295: );
296:
297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('After call to cz_config_api_pub.copy_configuration_auto');
299: aso_debug_pub.add('copy_configuration: x_return_status: '|| x_return_status);
300: END IF;
301:
294: x_msg_data => x_msg_data
295: );
296:
297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('After call to cz_config_api_pub.copy_configuration_auto');
299: aso_debug_pub.add('copy_configuration: x_return_status: '|| x_return_status);
300: END IF;
301:
302: ELSE
295: );
296:
297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('After call to cz_config_api_pub.copy_configuration_auto');
299: aso_debug_pub.add('copy_configuration: x_return_status: '|| x_return_status);
300: END IF;
301:
302: ELSE
303:
315: x_msg_count => x_msg_count,
316: x_msg_data => x_msg_data
317: );
318:
319: IF aso_debug_pub.g_debug_flag = 'Y' THEN
320: aso_debug_pub.add('After call to cz_config_api_pub.copy_configuration');
321: aso_debug_pub.add('copy_configuration: x_return_status: '|| x_return_status);
322: END IF;
323:
316: x_msg_data => x_msg_data
317: );
318:
319: IF aso_debug_pub.g_debug_flag = 'Y' THEN
320: aso_debug_pub.add('After call to cz_config_api_pub.copy_configuration');
321: aso_debug_pub.add('copy_configuration: x_return_status: '|| x_return_status);
322: END IF;
323:
324: END IF;
317: );
318:
319: IF aso_debug_pub.g_debug_flag = 'Y' THEN
320: aso_debug_pub.add('After call to cz_config_api_pub.copy_configuration');
321: aso_debug_pub.add('copy_configuration: x_return_status: '|| x_return_status);
322: END IF;
323:
324: END IF;
325:
367:
368:
369: WHEN OTHERS THEN
370:
371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372: aso_debug_pub.add('ASO_CFG_INT: copy_configuration: Inside when others exception');
373: END IF;
374:
375: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
368:
369: WHEN OTHERS THEN
370:
371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372: aso_debug_pub.add('ASO_CFG_INT: copy_configuration: Inside when others exception');
373: END IF;
374:
375: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
376: P_PKG_NAME => G_PKG_NAME,
837: -- Standard Start of API savepoint
838: SAVEPOINT GET_CONFIG_DETAILS_INT;
839:
840: /*
841: aso_debug_pub.g_debug_flag := 'Y';
842: aso_debug_pub.SetDebugLevel(10);
843: aso_debug_pub.Initialize;
844: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
845: aso_debug_pub.debug_on;
838: SAVEPOINT GET_CONFIG_DETAILS_INT;
839:
840: /*
841: aso_debug_pub.g_debug_flag := 'Y';
842: aso_debug_pub.SetDebugLevel(10);
843: aso_debug_pub.Initialize;
844: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
845: aso_debug_pub.debug_on;
846: */
839:
840: /*
841: aso_debug_pub.g_debug_flag := 'Y';
842: aso_debug_pub.SetDebugLevel(10);
843: aso_debug_pub.Initialize;
844: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
845: aso_debug_pub.debug_on;
846: */
847:
840: /*
841: aso_debug_pub.g_debug_flag := 'Y';
842: aso_debug_pub.SetDebugLevel(10);
843: aso_debug_pub.Initialize;
844: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
845: aso_debug_pub.debug_on;
846: */
847:
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
841: aso_debug_pub.g_debug_flag := 'Y';
842: aso_debug_pub.SetDebugLevel(10);
843: aso_debug_pub.Initialize;
844: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
845: aso_debug_pub.debug_on;
846: */
847:
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849:
844: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
845: aso_debug_pub.debug_on;
846: */
847:
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849:
850: aso_debug_pub.add('ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');
851:
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
846: */
847:
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849:
850: aso_debug_pub.add('ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');
851:
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
853: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
854: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849:
850: aso_debug_pub.add('ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');
851:
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
853: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
854: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);
855: aso_debug_pub.add('p_config_rec.valid_configuration_flag: '|| p_config_rec.valid_configuration_flag);
856: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
849:
850: aso_debug_pub.add('ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');
851:
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
853: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
854: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);
855: aso_debug_pub.add('p_config_rec.valid_configuration_flag: '|| p_config_rec.valid_configuration_flag);
856: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
857: END IF;
850: aso_debug_pub.add('ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');
851:
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
853: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
854: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);
855: aso_debug_pub.add('p_config_rec.valid_configuration_flag: '|| p_config_rec.valid_configuration_flag);
856: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
857: END IF;
858:
851:
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
853: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
854: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);
855: aso_debug_pub.add('p_config_rec.valid_configuration_flag: '|| p_config_rec.valid_configuration_flag);
856: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
857: END IF;
858:
859: -- Standard call to check for call compatibility.
852: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
853: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
854: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);
855: aso_debug_pub.add('p_config_rec.valid_configuration_flag: '|| p_config_rec.valid_configuration_flag);
856: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
857: END IF;
858:
859: -- Standard call to check for call compatibility.
860: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875:
876: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
878: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
879: ASO_UTILITY_PVT.print_login_info;
880: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
881: END IF;
874:
875:
876: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
878: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
879: ASO_UTILITY_PVT.print_login_info;
880: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
881: END IF;
882:
876: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
878: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
879: ASO_UTILITY_PVT.print_login_info;
880: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
881: END IF;
882:
883: -- Change Done By Girish
884: -- Procedure added to validate the operating unit
887:
888: -- check whether a different config_header_id is already
889: -- associated with this model item. If yes raise an error.
890:
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_diff_Config_Exists cursor open');
893: END IF;
894:
895: OPEN C_diff_Config_Exists;
888: -- check whether a different config_header_id is already
889: -- associated with this model item. If yes raise an error.
890:
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_diff_Config_Exists cursor open');
893: END IF;
894:
895: OPEN C_diff_Config_Exists;
896: FETCH C_diff_Config_Exists INTO l_old_config_hdr_id ;
895: OPEN C_diff_Config_Exists;
896: FETCH C_diff_Config_Exists INTO l_old_config_hdr_id ;
897: CLOSE C_diff_Config_Exists;
898:
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: l_old_config_hdr_id: '||l_old_config_hdr_id, 1, 'Y');
901: END IF;
902:
903: IF l_old_config_hdr_id IS NOT NULL AND l_old_config_hdr_id <> p_config_hdr_id THEN
896: FETCH C_diff_Config_Exists INTO l_old_config_hdr_id ;
897: CLOSE C_diff_Config_Exists;
898:
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: l_old_config_hdr_id: '||l_old_config_hdr_id, 1, 'Y');
901: END IF;
902:
903: IF l_old_config_hdr_id IS NOT NULL AND l_old_config_hdr_id <> p_config_hdr_id THEN
904:
901: END IF;
902:
903: IF l_old_config_hdr_id IS NOT NULL AND l_old_config_hdr_id <> p_config_hdr_id THEN
904:
905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
906: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside If l_old_config_hdr_id <> p_config_hdr_id cond', 1, 'Y');
907: END IF;
908:
909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
902:
903: IF l_old_config_hdr_id IS NOT NULL AND l_old_config_hdr_id <> p_config_hdr_id THEN
904:
905: IF aso_debug_pub.g_debug_flag = 'Y' THEN
906: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside If l_old_config_hdr_id <> p_config_hdr_id cond', 1, 'Y');
907: END IF;
908:
909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
910: FND_MESSAGE.Set_Name('ASO', 'ASO_DIFFERENT_CONFIG_EXISTS');
916:
917: -- check whether the config_header_id+config_revision_num is already
918: -- associated with other model item. If yes raise an error.
919:
920: IF aso_debug_pub.g_debug_flag = 'Y' THEN
921: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_config_exists cursor open');
922: END IF;
923:
924: OPEN C_config_exists(l_config_hdr_id => p_config_hdr_id ,
917: -- check whether the config_header_id+config_revision_num is already
918: -- associated with other model item. If yes raise an error.
919:
920: IF aso_debug_pub.g_debug_flag = 'Y' THEN
921: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_config_exists cursor open');
922: END IF;
923:
924: OPEN C_config_exists(l_config_hdr_id => p_config_hdr_id ,
925: l_config_rev_nbr => p_config_rev_nbr);
927: CLOSE C_config_exists;
928:
929: IF l_quote_line_id IS NOT NULL AND l_quote_line_id <> p_config_rec.quote_line_id THEN
930:
931: IF aso_debug_pub.g_debug_flag = 'Y' THEN
932: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside C_config_exists cursor l_quote_line_id: '||l_quote_line_id);
933: END IF;
934:
935: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
928:
929: IF l_quote_line_id IS NOT NULL AND l_quote_line_id <> p_config_rec.quote_line_id THEN
930:
931: IF aso_debug_pub.g_debug_flag = 'Y' THEN
932: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside C_config_exists cursor l_quote_line_id: '||l_quote_line_id);
933: END IF;
934:
935: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
936: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CONFIG_EXISTS');
945: OPEN c_quote(p_qte_header_rec.quote_header_id);
946: FETCH c_quote INTO l_last_update_date, l_quote_type;
947: CLOSE c_quote;
948:
949: IF aso_debug_pub.g_debug_flag = 'Y' THEN
950: aso_debug_pub.add('Get_config_details: p_qte_header_rec.last_update_date: ' || to_char(p_qte_header_rec.last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
951: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
952: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
953: END IF;
946: FETCH c_quote INTO l_last_update_date, l_quote_type;
947: CLOSE c_quote;
948:
949: IF aso_debug_pub.g_debug_flag = 'Y' THEN
950: aso_debug_pub.add('Get_config_details: p_qte_header_rec.last_update_date: ' || to_char(p_qte_header_rec.last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
951: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
952: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
953: END IF;
954:
947: CLOSE c_quote;
948:
949: IF aso_debug_pub.g_debug_flag = 'Y' THEN
950: aso_debug_pub.add('Get_config_details: p_qte_header_rec.last_update_date: ' || to_char(p_qte_header_rec.last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
951: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
952: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
953: END IF;
954:
955: if (p_qte_header_rec.last_update_date is not null) and (p_qte_header_rec.last_update_date <> fnd_api.g_miss_date) then
948:
949: IF aso_debug_pub.g_debug_flag = 'Y' THEN
950: aso_debug_pub.add('Get_config_details: p_qte_header_rec.last_update_date: ' || to_char(p_qte_header_rec.last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
951: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
952: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
953: END IF;
954:
955: if (p_qte_header_rec.last_update_date is not null) and (p_qte_header_rec.last_update_date <> fnd_api.g_miss_date) then
956:
966: End if;
967:
968: end if;
969:
970: IF aso_debug_pub.g_debug_flag = 'Y' THEN
971: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After C_config_exists cursor');
972: END IF;
973:
974: --check if revision number has changed for this configuration.
967:
968: end if;
969:
970: IF aso_debug_pub.g_debug_flag = 'Y' THEN
971: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After C_config_exists cursor');
972: END IF;
973:
974: --check if revision number has changed for this configuration.
975: --if yes update all the previous selected options to the current
982: p_config_rec.config_revision_num IS NOT NULL)) AND
983: (p_config_rec.config_header_id <> p_config_hdr_id OR
984: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN
985: BEGIN
986: IF aso_debug_pub.g_debug_flag = 'Y' THEN
987: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Revision number has changed so updating');
988: END IF;
989:
990: UPDATE aso_quote_line_details
983: (p_config_rec.config_header_id <> p_config_hdr_id OR
984: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN
985: BEGIN
986: IF aso_debug_pub.g_debug_flag = 'Y' THEN
987: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Revision number has changed so updating');
988: END IF;
989:
990: UPDATE aso_quote_line_details
991: SET config_revision_num = p_config_rev_nbr,
998: EXCEPTION
999:
1000: WHEN OTHERS THEN
1001:
1002: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1003: aso_debug_pub.add('Get_config_details: Inside WHEN OTHERS Exception of Update config_revision_num');
1004: END IF;
1005: END;
1006:
999:
1000: WHEN OTHERS THEN
1001:
1002: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1003: aso_debug_pub.add('Get_config_details: Inside WHEN OTHERS Exception of Update config_revision_num');
1004: END IF;
1005: END;
1006:
1007: END IF;
1006:
1007: END IF;
1008:
1009:
1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1011: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After Update config_revision_num');
1012: END IF;
1013:
1014: OPEN Order_Type_C;
1007: END IF;
1008:
1009:
1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1011: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After Update config_revision_num');
1012: END IF;
1013:
1014: OPEN Order_Type_C;
1015: FETCH Order_Type_C INTO l_order_line_type_id, l_line_category_code, l_price_list_id, l_line_number,l_ship_model_complete_flag,l_config_model_type;
1015: FETCH Order_Type_C INTO l_order_line_type_id, l_line_category_code, l_price_list_id, l_line_number,l_ship_model_complete_flag,l_config_model_type;
1016:
1017: IF Order_Type_C%NOTFOUND THEN
1018:
1019: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1020: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Cursor Order_Type_C NOTFOUND');
1021: END IF;
1022:
1023: END IF;
1016:
1017: IF Order_Type_C%NOTFOUND THEN
1018:
1019: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1020: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Cursor Order_Type_C NOTFOUND');
1021: END IF;
1022:
1023: END IF;
1024: CLOSE Order_Type_C;
1022:
1023: END IF;
1024: CLOSE Order_Type_C;
1025:
1026: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1027:
1028: aso_debug_pub.add('Get_config_details: Model: p_config_rec.quote_line_id: '|| p_config_rec.quote_line_id);
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1024: CLOSE Order_Type_C;
1025:
1026: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1027:
1028: aso_debug_pub.add('Get_config_details: Model: p_config_rec.quote_line_id: '|| p_config_rec.quote_line_id);
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1025:
1026: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1027:
1028: aso_debug_pub.add('Get_config_details: Model: p_config_rec.quote_line_id: '|| p_config_rec.quote_line_id);
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1033: aso_debug_pub.add('Get_config_details: Model: l_ship_model_complete_flag: ' || l_ship_model_complete_flag);
1026: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1027:
1028: aso_debug_pub.add('Get_config_details: Model: p_config_rec.quote_line_id: '|| p_config_rec.quote_line_id);
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1033: aso_debug_pub.add('Get_config_details: Model: l_ship_model_complete_flag: ' || l_ship_model_complete_flag);
1034: aso_debug_pub.add('Get_config_details: Model: l_config_model_type: ' || l_config_model_type);
1027:
1028: aso_debug_pub.add('Get_config_details: Model: p_config_rec.quote_line_id: '|| p_config_rec.quote_line_id);
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1033: aso_debug_pub.add('Get_config_details: Model: l_ship_model_complete_flag: ' || l_ship_model_complete_flag);
1034: aso_debug_pub.add('Get_config_details: Model: l_config_model_type: ' || l_config_model_type);
1035: END IF;
1028: aso_debug_pub.add('Get_config_details: Model: p_config_rec.quote_line_id: '|| p_config_rec.quote_line_id);
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1033: aso_debug_pub.add('Get_config_details: Model: l_ship_model_complete_flag: ' || l_ship_model_complete_flag);
1034: aso_debug_pub.add('Get_config_details: Model: l_config_model_type: ' || l_config_model_type);
1035: END IF;
1036:
1029: aso_debug_pub.add('Get_config_details: Model: l_order_line_type_id: ' || l_order_line_type_id);
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1033: aso_debug_pub.add('Get_config_details: Model: l_ship_model_complete_flag: ' || l_ship_model_complete_flag);
1034: aso_debug_pub.add('Get_config_details: Model: l_config_model_type: ' || l_config_model_type);
1035: END IF;
1036:
1037: l_index := 0;
1030: aso_debug_pub.add('Get_config_details: Model: l_line_category_code: ' || l_line_category_code);
1031: aso_debug_pub.add('Get_config_details: Model: l_price_list_id: ' || l_price_list_id);
1032: aso_debug_pub.add('Get_config_details: Model: l_line_number: ' || l_line_number);
1033: aso_debug_pub.add('Get_config_details: Model: l_ship_model_complete_flag: ' || l_ship_model_complete_flag);
1034: aso_debug_pub.add('Get_config_details: Model: l_config_model_type: ' || l_config_model_type);
1035: END IF;
1036:
1037: l_index := 0;
1038:
1035: END IF;
1036:
1037: l_index := 0;
1038:
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Before C_config_details_ins cursor LOOP');
1041: END IF;
1042:
1043: FOR row IN C_config_details_ins(p_config_hdr_id, p_config_rev_nbr)
1036:
1037: l_index := 0;
1038:
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Before C_config_details_ins cursor LOOP');
1041: END IF;
1042:
1043: FOR row IN C_config_details_ins(p_config_hdr_id, p_config_rev_nbr)
1044: LOOP
1044: LOOP
1045:
1046: l_index := l_index + 1;
1047:
1048: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1049:
1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1046: l_index := l_index + 1;
1047:
1048: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1049:
1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1047:
1048: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1049:
1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1048: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1049:
1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1049:
1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1051: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1052: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1053: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1054: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1055: aso_debug_pub.add('Get_Config_Details: parent_config_item_id: '|| row.parent_config_item_id);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1056: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1057: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1058: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1066: aso_debug_pub.add('Get_Config_Details: ato_config_item_id: '|| row.ato_config_item_id);
1059: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1066: aso_debug_pub.add('Get_Config_Details: ato_config_item_id: '|| row.ato_config_item_id);
1067: aso_debug_pub.add('Get_Config_Details: model_config_item_id: '|| row.model_config_item_id);
1060: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1066: aso_debug_pub.add('Get_Config_Details: ato_config_item_id: '|| row.ato_config_item_id);
1067: aso_debug_pub.add('Get_Config_Details: model_config_item_id: '|| row.model_config_item_id);
1068: END IF;
1061: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1066: aso_debug_pub.add('Get_Config_Details: ato_config_item_id: '|| row.ato_config_item_id);
1067: aso_debug_pub.add('Get_Config_Details: model_config_item_id: '|| row.model_config_item_id);
1068: END IF;
1069:
1062: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1066: aso_debug_pub.add('Get_Config_Details: ato_config_item_id: '|| row.ato_config_item_id);
1067: aso_debug_pub.add('Get_Config_Details: model_config_item_id: '|| row.model_config_item_id);
1068: END IF;
1069:
1070: IF to_char( row.inventory_item_id ) = row.component_code THEN
1063: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1064: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1065: aso_debug_pub.add('Get_Config_Details: component_sequence_id: '|| row.component_sequence_id);
1066: aso_debug_pub.add('Get_Config_Details: ato_config_item_id: '|| row.ato_config_item_id);
1067: aso_debug_pub.add('Get_Config_Details: model_config_item_id: '|| row.model_config_item_id);
1068: END IF;
1069:
1070: IF to_char( row.inventory_item_id ) = row.component_code THEN
1071:
1135: l_qte_line_dtl_tbl(l_index).component_sequence_id := row.component_sequence_id;
1136: l_qte_line_dtl_tbl(l_index).top_model_line_id := p_config_rec.quote_line_id;
1137:
1138:
1139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1140:
1141: aso_debug_pub.add('Get_Config_Details: l_qte_line_dtl_search('||row.config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.config_item_id).qte_line_index);
1142:
1143: END IF;
1137:
1138:
1139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1140:
1141: aso_debug_pub.add('Get_Config_Details: l_qte_line_dtl_search('||row.config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.config_item_id).qte_line_index);
1142:
1143: END IF;
1144:
1145: --Creating the parent-child relationship
1145: --Creating the parent-child relationship
1146:
1147: IF l_qte_line_dtl_search.EXISTS(row.parent_config_item_id) THEN
1148:
1149: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1150:
1151: aso_debug_pub.add('Index of parent: l_qte_line_dtl_search('||row.parent_config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.parent_config_item_id).qte_line_index);
1152:
1153: aso_debug_pub.add('Quote_line_id of parent: l_qte_line_dtl_search('||row.parent_config_item_id||').quote_line_id: '||l_qte_line_dtl_search(row.parent_config_item_id).quote_line_id);
1147: IF l_qte_line_dtl_search.EXISTS(row.parent_config_item_id) THEN
1148:
1149: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1150:
1151: aso_debug_pub.add('Index of parent: l_qte_line_dtl_search('||row.parent_config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.parent_config_item_id).qte_line_index);
1152:
1153: aso_debug_pub.add('Quote_line_id of parent: l_qte_line_dtl_search('||row.parent_config_item_id||').quote_line_id: '||l_qte_line_dtl_search(row.parent_config_item_id).quote_line_id);
1154:
1155: END IF;
1149: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1150:
1151: aso_debug_pub.add('Index of parent: l_qte_line_dtl_search('||row.parent_config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.parent_config_item_id).qte_line_index);
1152:
1153: aso_debug_pub.add('Quote_line_id of parent: l_qte_line_dtl_search('||row.parent_config_item_id||').quote_line_id: '||l_qte_line_dtl_search(row.parent_config_item_id).quote_line_id);
1154:
1155: END IF;
1156:
1157: l_qte_line_dtl_tbl(l_index).ref_line_index := l_qte_line_dtl_search(row.parent_config_item_id).qte_line_index;
1162: OPEN C_config_all(l_qte_line_dtl_tbl(l_index).parent_config_item_id);
1163: FETCH C_config_all INTO l_qte_line_dtl_tbl(l_index).ref_line_id;
1164: CLOSE C_config_all;
1165:
1166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1167:
1168: aso_debug_pub.add('l_qte_line_dtl_tbl('||l_index||').ref_line_id: '||l_qte_line_dtl_tbl(l_index).ref_line_id);
1169:
1170: END IF;
1164: CLOSE C_config_all;
1165:
1166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1167:
1168: aso_debug_pub.add('l_qte_line_dtl_tbl('||l_index||').ref_line_id: '||l_qte_line_dtl_tbl(l_index).ref_line_id);
1169:
1170: END IF;
1171: END IF;
1172:
1173: -- Populating the ato_line_id
1174:
1175: IF l_qte_line_dtl_search.EXISTS(row.ato_config_item_id) THEN
1176:
1177: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1178:
1179: aso_debug_pub.add('Index of ato : l_qte_line_dtl_search('||row.ato_config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.ato_config_item_id).qte_line_index);
1180:
1181: aso_debug_pub.add('Quote_line_id of ato: l_qte_line_dtl_search('||row.ato_config_item_id||').quote_line_id: '||l_qte_line_dtl_search(row.ato_config_item_id).quote_line_id);
1175: IF l_qte_line_dtl_search.EXISTS(row.ato_config_item_id) THEN
1176:
1177: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1178:
1179: aso_debug_pub.add('Index of ato : l_qte_line_dtl_search('||row.ato_config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.ato_config_item_id).qte_line_index);
1180:
1181: aso_debug_pub.add('Quote_line_id of ato: l_qte_line_dtl_search('||row.ato_config_item_id||').quote_line_id: '||l_qte_line_dtl_search(row.ato_config_item_id).quote_line_id);
1182:
1183: END IF;
1177: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1178:
1179: aso_debug_pub.add('Index of ato : l_qte_line_dtl_search('||row.ato_config_item_id||').qte_line_index: '||l_qte_line_dtl_search(row.ato_config_item_id).qte_line_index);
1180:
1181: aso_debug_pub.add('Quote_line_id of ato: l_qte_line_dtl_search('||row.ato_config_item_id||').quote_line_id: '||l_qte_line_dtl_search(row.ato_config_item_id).quote_line_id);
1182:
1183: END IF;
1184:
1185: l_qte_line_dtl_tbl(l_index).ato_line_index := l_qte_line_dtl_search(row.ato_config_item_id).qte_line_index;
1190: OPEN C_config_all(row.ato_config_item_id);
1191: FETCH C_config_all INTO l_qte_line_dtl_tbl(l_index).ato_line_id;
1192: CLOSE C_config_all;
1193:
1194: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1195:
1196: aso_debug_pub.add('l_qte_line_dtl_tbl('||l_index||').ato_line_id: '||l_qte_line_dtl_tbl(l_index).ato_line_id);
1197:
1198: END IF;
1192: CLOSE C_config_all;
1193:
1194: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1195:
1196: aso_debug_pub.add('l_qte_line_dtl_tbl('||l_index||').ato_line_id: '||l_qte_line_dtl_tbl(l_index).ato_line_id);
1197:
1198: END IF;
1199: END IF;
1200:
1216:
1217: END IF;
1218: END LOOP;
1219:
1220: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1221:
1222: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: After C_config_details_ins cursor LOOP l_index: '|| l_index);
1223:
1224: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_upd cursor LOOP');
1218: END LOOP;
1219:
1220: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1221:
1222: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: After C_config_details_ins cursor LOOP l_index: '|| l_index);
1223:
1224: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_upd cursor LOOP');
1225:
1226: END IF;
1220: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1221:
1222: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: After C_config_details_ins cursor LOOP l_index: '|| l_index);
1223:
1224: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_upd cursor LOOP');
1225:
1226: END IF;
1227:
1228: FOR row IN C_config_details_upd( p_config_hdr_id,
1232: LOOP
1233:
1234: l_index := l_index + 1;
1235:
1236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1237:
1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1234: l_index := l_index + 1;
1235:
1236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1237:
1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1235:
1236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1237:
1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1237:
1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1237:
1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1239: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1240: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1241: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1249: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1242: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1249: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1250: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1243: aso_debug_pub.add('Get_Config_Details: organization_id: '|| row.organization_id);
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1249: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1250: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1251: END IF;
1244: aso_debug_pub.add('Get_Config_Details: component_code: '|| row.component_code);
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1249: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1250: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1251: END IF;
1252:
1245: aso_debug_pub.add('Get_Config_Details: quantity: '|| row.quantity);
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1249: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1250: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1251: END IF;
1252:
1253: l_Qte_Line_Tbl(l_index).quote_header_id := p_qte_header_rec.quote_header_id;
1246: aso_debug_pub.add('Get_Config_Details: uom_code: '|| row.uom_code);
1247: aso_debug_pub.add('Get_Config_Details: bom_sort_order: '|| row.bom_sort_order);
1248: aso_debug_pub.add('Get_Config_Details: config_delta: '|| row.config_delta);
1249: aso_debug_pub.add('Get_Config_Details: name: '|| row.name);
1250: aso_debug_pub.add('Get_Config_Details: line_type: '|| row.line_type);
1251: END IF;
1252:
1253: l_Qte_Line_Tbl(l_index).quote_header_id := p_qte_header_rec.quote_header_id;
1254: l_Qte_Line_Tbl(l_index).quote_line_id := row.quote_line_id;
1281:
1282:
1283: END LOOP;
1284:
1285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1286:
1287: aso_debug_pub.add( 'Get_Config_details: After C_config_details_upd cursor LOOP l_index: '|| l_index);
1288: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_del cursor LOOP');
1289:
1283: END LOOP;
1284:
1285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1286:
1287: aso_debug_pub.add( 'Get_Config_details: After C_config_details_upd cursor LOOP l_index: '|| l_index);
1288: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_del cursor LOOP');
1289:
1290: END IF;
1291:
1284:
1285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1286:
1287: aso_debug_pub.add( 'Get_Config_details: After C_config_details_upd cursor LOOP l_index: '|| l_index);
1288: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_del cursor LOOP');
1289:
1290: END IF;
1291:
1292: FOR row IN C_config_details_del( p_config_hdr_id, p_config_rev_nbr )
1293: LOOP
1294:
1295: l_index := l_index + 1;
1296:
1297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1298: aso_debug_pub.add('Get_Config_details: Inside C_config_details_del cursor LOOP');
1299: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1300: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1301: END IF;
1294:
1295: l_index := l_index + 1;
1296:
1297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1298: aso_debug_pub.add('Get_Config_details: Inside C_config_details_del cursor LOOP');
1299: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1300: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1301: END IF;
1302:
1295: l_index := l_index + 1;
1296:
1297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1298: aso_debug_pub.add('Get_Config_details: Inside C_config_details_del cursor LOOP');
1299: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1300: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1301: END IF;
1302:
1303: l_Qte_Line_Tbl(l_index).OPERATION_CODE := 'DELETE';
1296:
1297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1298: aso_debug_pub.add('Get_Config_details: Inside C_config_details_del cursor LOOP');
1299: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1300: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1301: END IF;
1302:
1303: l_Qte_Line_Tbl(l_index).OPERATION_CODE := 'DELETE';
1304: l_Qte_Line_Tbl(l_index).quote_line_id := row.quote_line_id;
1304: l_Qte_Line_Tbl(l_index).quote_line_id := row.quote_line_id;
1305:
1306: END LOOP;
1307:
1308: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1309:
1310: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1311:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1306: END LOOP;
1307:
1308: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1309:
1310: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1311:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1313: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1314: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1308: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1309:
1310: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1311:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1313: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1314: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1315: aso_debug_pub.add('Get_Config_details: p_control_rec.pricing_request_type: '|| p_control_rec.pricing_request_type);
1316: aso_debug_pub.add('Get_Config_details: p_control_rec.header_pricing_event: '|| p_control_rec.header_pricing_event);
1309:
1310: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1311:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1313: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1314: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1315: aso_debug_pub.add('Get_Config_details: p_control_rec.pricing_request_type: '|| p_control_rec.pricing_request_type);
1316: aso_debug_pub.add('Get_Config_details: p_control_rec.header_pricing_event: '|| p_control_rec.header_pricing_event);
1317:
1310: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1311:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1313: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1314: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1315: aso_debug_pub.add('Get_Config_details: p_control_rec.pricing_request_type: '|| p_control_rec.pricing_request_type);
1316: aso_debug_pub.add('Get_Config_details: p_control_rec.header_pricing_event: '|| p_control_rec.header_pricing_event);
1317:
1318: END IF;
1311:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1313: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1314: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1315: aso_debug_pub.add('Get_Config_details: p_control_rec.pricing_request_type: '|| p_control_rec.pricing_request_type);
1316: aso_debug_pub.add('Get_Config_details: p_control_rec.header_pricing_event: '|| p_control_rec.header_pricing_event);
1317:
1318: END IF;
1319:
1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1313: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1314: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1315: aso_debug_pub.add('Get_Config_details: p_control_rec.pricing_request_type: '|| p_control_rec.pricing_request_type);
1316: aso_debug_pub.add('Get_Config_details: p_control_rec.header_pricing_event: '|| p_control_rec.header_pricing_event);
1317:
1318: END IF;
1319:
1320:
1323: l_qte_header_rec := p_qte_header_rec;
1324: l_qte_header_rec.last_update_date := l_last_update_date;
1325: l_qte_header_rec.CALL_BATCH_VALIDATION_FLAG := FND_API.G_FALSE;
1326:
1327: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1328:
1329: aso_debug_pub.add( 'Get_Config_details: Before call to Update Quote table count');
1330: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Tbl.count: '||l_Qte_Line_Tbl.count);
1331: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Dtl_Tbl.count: '||l_Qte_Line_Dtl_Tbl.count);
1325: l_qte_header_rec.CALL_BATCH_VALIDATION_FLAG := FND_API.G_FALSE;
1326:
1327: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1328:
1329: aso_debug_pub.add( 'Get_Config_details: Before call to Update Quote table count');
1330: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Tbl.count: '||l_Qte_Line_Tbl.count);
1331: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Dtl_Tbl.count: '||l_Qte_Line_Dtl_Tbl.count);
1332:
1333: END IF;
1326:
1327: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1328:
1329: aso_debug_pub.add( 'Get_Config_details: Before call to Update Quote table count');
1330: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Tbl.count: '||l_Qte_Line_Tbl.count);
1331: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Dtl_Tbl.count: '||l_Qte_Line_Dtl_Tbl.count);
1332:
1333: END IF;
1334:
1327: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1328:
1329: aso_debug_pub.add( 'Get_Config_details: Before call to Update Quote table count');
1330: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Tbl.count: '||l_Qte_Line_Tbl.count);
1331: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Dtl_Tbl.count: '||l_Qte_Line_Dtl_Tbl.count);
1332:
1333: END IF;
1334:
1335: ASO_QUOTE_PUB.Update_Quote(
1365: X_Return_Status => x_Return_Status,
1366: X_Msg_Count => x_Msg_Count,
1367: X_Msg_Data => x_Msg_Data);
1368:
1369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1370: aso_debug_pub.add('Get_config_details: After call to Update_quote x_Return_Status: ' || x_Return_Status);
1371: END IF;
1372:
1373: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1366: X_Msg_Count => x_Msg_Count,
1367: X_Msg_Data => x_Msg_Data);
1368:
1369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1370: aso_debug_pub.add('Get_config_details: After call to Update_quote x_Return_Status: ' || x_Return_Status);
1371: END IF;
1372:
1373: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1374:
1371: END IF;
1372:
1373: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1374:
1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1377: END IF;
1378:
1379: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1372:
1373: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1374:
1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1377: END IF;
1378:
1379: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1380: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1382: p_config_rec.config_revision_num IS NOT NULL)) AND
1383: (p_config_rec.config_header_id <> p_config_hdr_id OR
1384: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN
1385:
1386: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1387: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1388: END IF;
1389:
1390: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1383: (p_config_rec.config_header_id <> p_config_hdr_id OR
1384: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN
1385:
1386: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1387: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1388: END IF;
1389:
1390: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1391: P_INIT_MSG_LIST => FND_API.G_FALSE,
1394: X_RETURN_STATUS => lx_return_status,
1395: X_MSG_COUNT => x_msg_count,
1396: X_MSG_DATA => x_msg_data);
1397:
1398: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1399: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1400: END IF;
1401:
1402: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1395: X_MSG_COUNT => x_msg_count,
1396: X_MSG_DATA => x_msg_data);
1397:
1398: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1399: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1400: END IF;
1401:
1402: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1403:
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:
1423: END IF;
1424:
1425: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1426: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');
1427: END IF;
1428:
1429: DELETE aso_line_relationships
1422:
1423: END IF;
1424:
1425: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1426: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');
1427: END IF;
1428:
1429: DELETE aso_line_relationships
1430: WHERE line_relationship_id IN (SELECT line_relationship_id
1432: WHERE a.relationship_type_code = 'CONFIG'
1433: START WITH a.quote_line_id = p_config_rec.quote_line_id
1434: CONNECT BY PRIOR a.related_quote_line_id = a.quote_line_id);
1435:
1436: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1437: aso_debug_pub.add('Get_config_details: After deleting records from aso_line_relationships table');
1438: END IF;
1439:
1440: G_rtln_tbl := G_MISS_rtln_tbl;
1433: START WITH a.quote_line_id = p_config_rec.quote_line_id
1434: CONNECT BY PRIOR a.related_quote_line_id = a.quote_line_id);
1435:
1436: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1437: aso_debug_pub.add('Get_config_details: After deleting records from aso_line_relationships table');
1438: END IF;
1439:
1440: G_rtln_tbl := G_MISS_rtln_tbl;
1441:
1438: END IF;
1439:
1440: G_rtln_tbl := G_MISS_rtln_tbl;
1441:
1442: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1443: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to populate_rtln_Tbl');
1444: END IF;
1445:
1446: populate_rtln_Tbl( p_quote_header_id => p_qte_header_rec.quote_header_id,
1439:
1440: G_rtln_tbl := G_MISS_rtln_tbl;
1441:
1442: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1443: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to populate_rtln_Tbl');
1444: END IF;
1445:
1446: populate_rtln_Tbl( p_quote_header_id => p_qte_header_rec.quote_header_id,
1447: p_quote_line_id => p_config_rec.quote_line_id,
1448: p_config_hdr_id => p_config_hdr_id,
1449: p_config_rev_nbr => p_config_rev_nbr );
1450:
1451:
1452: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1453:
1454: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: After call to populate_rtln_Tbl');
1455:
1456: FOR p IN G_rtln_tbl.first..G_rtln_tbl.last LOOP
1450:
1451:
1452: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1453:
1454: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: After call to populate_rtln_Tbl');
1455:
1456: FOR p IN G_rtln_tbl.first..G_rtln_tbl.last LOOP
1457:
1458: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);
1454: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: After call to populate_rtln_Tbl');
1455:
1456: FOR p IN G_rtln_tbl.first..G_rtln_tbl.last LOOP
1457:
1458: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);
1459: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').parent_config_item_id: '|| G_rtln_tbl(p).parent_config_item_id);
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1455:
1456: FOR p IN G_rtln_tbl.first..G_rtln_tbl.last LOOP
1457:
1458: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);
1459: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').parent_config_item_id: '|| G_rtln_tbl(p).parent_config_item_id);
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1456: FOR p IN G_rtln_tbl.first..G_rtln_tbl.last LOOP
1457:
1458: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);
1459: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').parent_config_item_id: '|| G_rtln_tbl(p).parent_config_item_id);
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1457:
1458: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);
1459: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').parent_config_item_id: '|| G_rtln_tbl(p).parent_config_item_id);
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1465: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').included_flag: '|| G_rtln_tbl(p).included_flag);
1458: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);
1459: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').parent_config_item_id: '|| G_rtln_tbl(p).parent_config_item_id);
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1465: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').included_flag: '|| G_rtln_tbl(p).included_flag);
1466: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1459: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').parent_config_item_id: '|| G_rtln_tbl(p).parent_config_item_id);
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1465: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').included_flag: '|| G_rtln_tbl(p).included_flag);
1466: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1467:
1460: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').config_item_id: '|| G_rtln_tbl(p).config_item_id);
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1465: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').included_flag: '|| G_rtln_tbl(p).included_flag);
1466: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1467:
1468: END LOOP;
1461: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').inventory_item_id: '|| G_rtln_tbl(p).inventory_item_id);
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1465: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').included_flag: '|| G_rtln_tbl(p).included_flag);
1466: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1467:
1468: END LOOP;
1469:
1462: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').organization_id: '|| G_rtln_tbl(p).organization_id);
1463: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').component_code: '|| G_rtln_tbl(p).component_code);
1464: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quantity: '|| G_rtln_tbl(p).quantity);
1465: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').included_flag: '|| G_rtln_tbl(p).included_flag);
1466: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1467:
1468: END LOOP;
1469:
1470: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to Create_Relationship procedure');
1466: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1467:
1468: END LOOP;
1469:
1470: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to Create_Relationship procedure');
1471:
1472: END IF;
1473:
1474: Create_Relationship( parent_quote_line_id => G_rtln_tbl(1).quote_line_id,
1476: x_return_status => x_return_status,
1477: x_msg_count => x_msg_count,
1478: x_msg_data => x_msg_data );
1479:
1480: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1481:
1482: aso_debug_pub.add('Get_config_details: After call to Create_Relationship: x_return_status: '|| x_return_status);
1483:
1484: END IF;
1478: x_msg_data => x_msg_data );
1479:
1480: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1481:
1482: aso_debug_pub.add('Get_config_details: After call to Create_Relationship: x_return_status: '|| x_return_status);
1483:
1484: END IF;
1485:
1486: -- Check return status from the above procedure call
1490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493:
1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1495: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1496: END IF;
1497:
1498: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493:
1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1495: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1496: END IF;
1497:
1498: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1499: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1507: if c_config_exist_in_cz%found then
1508:
1509: close c_config_exist_in_cz;
1510:
1511: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1512: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1513: END IF;
1514:
1515: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1508:
1509: close c_config_exist_in_cz;
1510:
1511: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1512: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1513: END IF;
1514:
1515: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1516: P_INIT_MSG_LIST => FND_API.G_FALSE,
1519: X_RETURN_STATUS => lx_return_status,
1520: X_MSG_COUNT => x_msg_count,
1521: X_MSG_DATA => x_msg_data);
1522:
1523: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1524: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1525: END IF;
1526:
1527: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1520: X_MSG_COUNT => x_msg_count,
1521: X_MSG_DATA => x_msg_data);
1522:
1523: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1524: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1525: END IF;
1526:
1527: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1528:
1542: end if;
1543:
1544: END IF;
1545:
1546: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1547: aso_debug_pub.add( 'ASO_CFG_INT: GET_CONFIG_DETAILS: Finish %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
1548: END IF;
1549:
1550: EXCEPTION
1543:
1544: END IF;
1545:
1546: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1547: aso_debug_pub.add( 'ASO_CFG_INT: GET_CONFIG_DETAILS: Finish %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
1548: END IF;
1549:
1550: EXCEPTION
1551:
1557: if c_config_exist_in_cz%found then
1558:
1559: close c_config_exist_in_cz;
1560:
1561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1562: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1563: END IF;
1564:
1565: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1558:
1559: close c_config_exist_in_cz;
1560:
1561: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1562: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1563: END IF;
1564:
1565: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1566: P_INIT_MSG_LIST => FND_API.G_FALSE,
1569: X_RETURN_STATUS => lx_return_status,
1570: X_MSG_COUNT => x_msg_count,
1571: X_MSG_DATA => x_msg_data);
1572:
1573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1574: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1575: END IF;
1576:
1577: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1570: X_MSG_COUNT => x_msg_count,
1571: X_MSG_DATA => x_msg_data);
1572:
1573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1574: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1575: END IF;
1576:
1577: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1578:
1608: if c_config_exist_in_cz%found then
1609:
1610: close c_config_exist_in_cz;
1611:
1612: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1613: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1614: END IF;
1615:
1616: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1609:
1610: close c_config_exist_in_cz;
1611:
1612: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1613: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1614: END IF;
1615:
1616: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1617: P_INIT_MSG_LIST => FND_API.G_FALSE,
1620: X_RETURN_STATUS => lx_return_status,
1621: X_MSG_COUNT => x_msg_count,
1622: X_MSG_DATA => x_msg_data);
1623:
1624: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1625: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1626: END IF;
1627:
1628: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: X_MSG_COUNT => x_msg_count,
1622: X_MSG_DATA => x_msg_data);
1623:
1624: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1625: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1626: END IF;
1627:
1628: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1629:
1659: if c_config_exist_in_cz%found then
1660:
1661: close c_config_exist_in_cz;
1662:
1663: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1664: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1665: END IF;
1666:
1667: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1660:
1661: close c_config_exist_in_cz;
1662:
1663: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1664: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1665: END IF;
1666:
1667: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1668: P_INIT_MSG_LIST => FND_API.G_FALSE,
1671: X_RETURN_STATUS => lx_return_status,
1672: X_MSG_COUNT => x_msg_count,
1673: X_MSG_DATA => x_msg_data);
1674:
1675: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1676: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1677: END IF;
1678:
1679: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: X_MSG_COUNT => x_msg_count,
1673: X_MSG_DATA => x_msg_data);
1674:
1675: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1676: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1677: END IF;
1678:
1679: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1680:
1810: l_master_organization_id NUMBER;
1811:
1812: Begin
1813: /*
1814: aso_debug_pub.g_debug_flag := 'Y';
1815: aso_debug_pub.SetDebugLevel(10);
1816: aso_debug_pub.Initialize;
1817: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
1818: aso_debug_pub.debug_on;
1811:
1812: Begin
1813: /*
1814: aso_debug_pub.g_debug_flag := 'Y';
1815: aso_debug_pub.SetDebugLevel(10);
1816: aso_debug_pub.Initialize;
1817: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
1818: aso_debug_pub.debug_on;
1819: */
1812: Begin
1813: /*
1814: aso_debug_pub.g_debug_flag := 'Y';
1815: aso_debug_pub.SetDebugLevel(10);
1816: aso_debug_pub.Initialize;
1817: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
1818: aso_debug_pub.debug_on;
1819: */
1820:
1813: /*
1814: aso_debug_pub.g_debug_flag := 'Y';
1815: aso_debug_pub.SetDebugLevel(10);
1816: aso_debug_pub.Initialize;
1817: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
1818: aso_debug_pub.debug_on;
1819: */
1820:
1821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1814: aso_debug_pub.g_debug_flag := 'Y';
1815: aso_debug_pub.SetDebugLevel(10);
1816: aso_debug_pub.Initialize;
1817: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
1818: aso_debug_pub.debug_on;
1819: */
1820:
1821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1822:
1817: l_file := ASO_DEBUG_PUB.Set_Debug_Mode('FILE');
1818: aso_debug_pub.debug_on;
1819: */
1820:
1821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1822:
1823: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
1824: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
1825: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
1819: */
1820:
1821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1822:
1823: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
1824: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
1825: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
1826:
1827: END IF;
1820:
1821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1822:
1823: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
1824: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
1825: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
1826:
1827: END IF;
1828:
1821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1822:
1823: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
1824: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
1825: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
1826:
1827: END IF;
1828:
1829: -- Store the derived model item quote_line_id from the p_config_session_key for subsequent use
1829: -- Store the derived model item quote_line_id from the p_config_session_key for subsequent use
1830:
1831: l_model_quote_line_id := to_number( substr(p_config_session_key, 1,instr( p_config_session_key, '-') - 1));
1832:
1833: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1834: aso_debug_pub.add('PRICING CALLBACK: l_model_quote_line_id: ' || l_model_quote_line_id);
1835: END IF;
1836:
1837: OPEN c_quote_hdr_id( l_model_quote_line_id );
1830:
1831: l_model_quote_line_id := to_number( substr(p_config_session_key, 1,instr( p_config_session_key, '-') - 1));
1832:
1833: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1834: aso_debug_pub.add('PRICING CALLBACK: l_model_quote_line_id: ' || l_model_quote_line_id);
1835: END IF;
1836:
1837: OPEN c_quote_hdr_id( l_model_quote_line_id );
1838: FETCH c_quote_hdr_id into l_quote_header_id, l_model_price_list_id, l_org_id;
1836:
1837: OPEN c_quote_hdr_id( l_model_quote_line_id );
1838: FETCH c_quote_hdr_id into l_quote_header_id, l_model_price_list_id, l_org_id;
1839:
1840: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1841: aso_debug_pub.add('PRICING CALLBACK: l_quote_header_id: ' || l_quote_header_id);
1842: aso_debug_pub.add('PRICING CALLBACK: l_model_price_list_id: ' || l_model_price_list_id);
1843: aso_debug_pub.add('PRICING CALLBACK: l_org_id: ' || l_org_id);
1844: END IF;
1837: OPEN c_quote_hdr_id( l_model_quote_line_id );
1838: FETCH c_quote_hdr_id into l_quote_header_id, l_model_price_list_id, l_org_id;
1839:
1840: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1841: aso_debug_pub.add('PRICING CALLBACK: l_quote_header_id: ' || l_quote_header_id);
1842: aso_debug_pub.add('PRICING CALLBACK: l_model_price_list_id: ' || l_model_price_list_id);
1843: aso_debug_pub.add('PRICING CALLBACK: l_org_id: ' || l_org_id);
1844: END IF;
1845:
1838: FETCH c_quote_hdr_id into l_quote_header_id, l_model_price_list_id, l_org_id;
1839:
1840: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1841: aso_debug_pub.add('PRICING CALLBACK: l_quote_header_id: ' || l_quote_header_id);
1842: aso_debug_pub.add('PRICING CALLBACK: l_model_price_list_id: ' || l_model_price_list_id);
1843: aso_debug_pub.add('PRICING CALLBACK: l_org_id: ' || l_org_id);
1844: END IF;
1845:
1846: IF c_quote_hdr_id%FOUND THEN
1839:
1840: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1841: aso_debug_pub.add('PRICING CALLBACK: l_quote_header_id: ' || l_quote_header_id);
1842: aso_debug_pub.add('PRICING CALLBACK: l_model_price_list_id: ' || l_model_price_list_id);
1843: aso_debug_pub.add('PRICING CALLBACK: l_org_id: ' || l_org_id);
1844: END IF;
1845:
1846: IF c_quote_hdr_id%FOUND THEN
1847:
1851: -- this configuration plus the model line itself
1852:
1853: l_qte_line_tbl := Query_Qte_Line_Rows( l_quote_header_id,l_model_quote_line_id );
1854:
1855: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1856: aso_debug_pub.add('PRICING CALLBACK: After call to Query_Qte_Line_Rows');
1857: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl.count: '|| l_qte_line_tbl.count);
1858: END IF;
1859:
1852:
1853: l_qte_line_tbl := Query_Qte_Line_Rows( l_quote_header_id,l_model_quote_line_id );
1854:
1855: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1856: aso_debug_pub.add('PRICING CALLBACK: After call to Query_Qte_Line_Rows');
1857: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl.count: '|| l_qte_line_tbl.count);
1858: END IF;
1859:
1860: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => l_org_id);
1853: l_qte_line_tbl := Query_Qte_Line_Rows( l_quote_header_id,l_model_quote_line_id );
1854:
1855: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1856: aso_debug_pub.add('PRICING CALLBACK: After call to Query_Qte_Line_Rows');
1857: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl.count: '|| l_qte_line_tbl.count);
1858: END IF;
1859:
1860: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => l_org_id);
1861:
1858: END IF;
1859:
1860: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => l_org_id);
1861:
1862: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1863: aso_debug_pub.add('PRICING CALLBACK: l_master_organization_id: ' || l_master_organization_id);
1864: END IF;
1865:
1866: ELSE
1859:
1860: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => l_org_id);
1861:
1862: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1863: aso_debug_pub.add('PRICING CALLBACK: l_master_organization_id: ' || l_master_organization_id);
1864: END IF;
1865:
1866: ELSE
1867:
1864: END IF;
1865:
1866: ELSE
1867:
1868: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1869: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: c_quote_hdr_id NOT FOUND.');
1870: END IF;
1871:
1872: END IF;
1865:
1866: ELSE
1867:
1868: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1869: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: c_quote_hdr_id NOT FOUND.');
1870: END IF;
1871:
1872: END IF;
1873:
1879: OPEN c_config_header_id( l_model_quote_line_id );
1880: FETCH c_config_header_id into l_config_header_id;
1881: CLOSE c_config_header_id;
1882:
1883: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1884: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_config_header_id: ' || l_config_header_id);
1885: END IF;
1886:
1887: IF p_price_type = cz_prc_callback_util.g_prc_type_list THEN
1880: FETCH c_config_header_id into l_config_header_id;
1881: CLOSE c_config_header_id;
1882:
1883: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1884: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_config_header_id: ' || l_config_header_id);
1885: END IF;
1886:
1887: IF p_price_type = cz_prc_callback_util.g_prc_type_list THEN
1888:
1887: IF p_price_type = cz_prc_callback_util.g_prc_type_list THEN
1888:
1889: FOR row IN C_options LOOP
1890:
1891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1892:
1893: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1889: FOR row IN C_options LOOP
1890:
1891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1892:
1893: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1896: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1897: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1890:
1891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1892:
1893: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1896: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1897: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1898: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1892:
1893: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1896: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1897: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1898: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1899:
1892:
1893: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1896: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1897: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1898: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1899:
1900: END IF;
1893: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1896: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1897: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1898: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1899:
1900: END IF;
1901:
1894: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1895: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1896: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1897: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1898: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1899:
1900: END IF;
1901:
1902: record_count1 := record_count1 + 1;
1909: open c_charge_periodicity_code(row.item_id, l_master_organization_id);
1910: fetch c_charge_periodicity_code into l_qte_line_tbl(record_count1).charge_periodicity_code;
1911: close c_charge_periodicity_code;
1912:
1913: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1914: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('|| record_count1 ||').charge_periodicity_code: '|| l_qte_line_tbl(record_count1).charge_periodicity_code);
1915: End if;
1916:
1917: IF l_config_header_id IS NOT NULL THEN
1910: fetch c_charge_periodicity_code into l_qte_line_tbl(record_count1).charge_periodicity_code;
1911: close c_charge_periodicity_code;
1912:
1913: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1914: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('|| record_count1 ||').charge_periodicity_code: '|| l_qte_line_tbl(record_count1).charge_periodicity_code);
1915: End if;
1916:
1917: IF l_config_header_id IS NOT NULL THEN
1918:
1918:
1919: OPEN c_pricelist_id(row.config_item_id, l_config_header_id);
1920: FETCH c_pricelist_id into l_line_price_list_id, l_quote_line_id;
1921:
1922: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1923: aso_debug_pub.add('PRICING CALLBACK: l_line_price_list_id: ' || l_line_price_list_id);
1924: aso_debug_pub.add('PRICING CALLBACK: l_quote_line_id: ' || l_quote_line_id);
1925: END IF;
1926:
1919: OPEN c_pricelist_id(row.config_item_id, l_config_header_id);
1920: FETCH c_pricelist_id into l_line_price_list_id, l_quote_line_id;
1921:
1922: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1923: aso_debug_pub.add('PRICING CALLBACK: l_line_price_list_id: ' || l_line_price_list_id);
1924: aso_debug_pub.add('PRICING CALLBACK: l_quote_line_id: ' || l_quote_line_id);
1925: END IF;
1926:
1927: IF c_pricelist_id%FOUND THEN
1920: FETCH c_pricelist_id into l_line_price_list_id, l_quote_line_id;
1921:
1922: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1923: aso_debug_pub.add('PRICING CALLBACK: l_line_price_list_id: ' || l_line_price_list_id);
1924: aso_debug_pub.add('PRICING CALLBACK: l_quote_line_id: ' || l_quote_line_id);
1925: END IF;
1926:
1927: IF c_pricelist_id%FOUND THEN
1928:
1925: END IF;
1926:
1927: IF c_pricelist_id%FOUND THEN
1928:
1929: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1930: aso_debug_pub.add('PRICING CALLBACK: Inside c_pricelist_id cursor FOUND');
1931: END IF;
1932:
1933: IF l_line_price_list_id IS NOT NULL THEN
1926:
1927: IF c_pricelist_id%FOUND THEN
1928:
1929: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1930: aso_debug_pub.add('PRICING CALLBACK: Inside c_pricelist_id cursor FOUND');
1931: END IF;
1932:
1933: IF l_line_price_list_id IS NOT NULL THEN
1934: l_qte_line_tbl(record_count1).price_list_id := l_line_price_list_id;
1939: l_qte_line_tbl(record_count1).quote_line_id := l_quote_line_id;
1940:
1941: ELSE
1942:
1943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1944: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE c_pricelist_id cursor FOUND');
1945: END IF;
1946:
1947: l_qte_line_tbl(record_count1).quote_line_id := 0;
1940:
1941: ELSE
1942:
1943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1944: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE c_pricelist_id cursor FOUND');
1945: END IF;
1946:
1947: l_qte_line_tbl(record_count1).quote_line_id := 0;
1948: l_qte_line_tbl(record_count1).price_list_id := l_model_price_list_id;
1952: CLOSE c_pricelist_id;
1953:
1954: ELSE
1955:
1956: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1957: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE l_config_header_id IS NOT NULL');
1958: END IF;
1959:
1960: l_qte_line_tbl(record_count1).quote_line_id := 0;
1953:
1954: ELSE
1955:
1956: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1957: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE l_config_header_id IS NOT NULL');
1958: END IF;
1959:
1960: l_qte_line_tbl(record_count1).quote_line_id := 0;
1961: l_qte_line_tbl(record_count1).price_list_id := l_model_price_list_id;
1972:
1973: -- Get the config_item_id of the root model
1974: l_root_model_config_item_id := cz_prc_callback_util.root_bom_config_item_id(p_config_session_key);
1975:
1976: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1977: aso_debug_pub.add( 'ASO_CFG_INT: PRICING CALLBACK: l_root_model_config_item_id: ' || l_root_model_config_item_id);
1978: END IF;
1979:
1980: record_count1 := l_qte_line_tbl.count;
1973: -- Get the config_item_id of the root model
1974: l_root_model_config_item_id := cz_prc_callback_util.root_bom_config_item_id(p_config_session_key);
1975:
1976: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1977: aso_debug_pub.add( 'ASO_CFG_INT: PRICING CALLBACK: l_root_model_config_item_id: ' || l_root_model_config_item_id);
1978: END IF;
1979:
1980: record_count1 := l_qte_line_tbl.count;
1981: l_count := l_qte_line_tbl.count;
1979:
1980: record_count1 := l_qte_line_tbl.count;
1981: l_count := l_qte_line_tbl.count;
1982:
1983: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1984: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_count: ' || l_count);
1985: END IF;
1986:
1987: FOR row IN C_options LOOP
1980: record_count1 := l_qte_line_tbl.count;
1981: l_count := l_qte_line_tbl.count;
1982:
1983: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1984: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_count: ' || l_count);
1985: END IF;
1986:
1987: FOR row IN C_options LOOP
1988:
1985: END IF;
1986:
1987: FOR row IN C_options LOOP
1988:
1989: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1990:
1991: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1987: FOR row IN C_options LOOP
1988:
1989: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1990:
1991: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1994: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1995: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1988:
1989: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1990:
1991: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1994: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1995: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1996: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1989: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1990:
1991: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1994: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1995: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1996: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1997:
1990:
1991: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1994: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1995: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1996: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1997:
1998: END IF;
1991: aso_debug_pub.add( 'PRICING CALLBACK: item_key: ' || row.item_key);
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1994: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1995: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1996: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1997:
1998: END IF;
1999:
1992: aso_debug_pub.add( 'PRICING CALLBACK: (inv) item_id: ' || row.item_id);
1993: aso_debug_pub.add( 'PRICING CALLBACK: quantity: ' || row.quantity);
1994: aso_debug_pub.add( 'PRICING CALLBACK: uom_code: ' || row.uom_code);
1995: aso_debug_pub.add( 'PRICING CALLBACK: component_code: ' || row.component_code);
1996: aso_debug_pub.add( 'PRICING CALLBACK: config_item_id: ' || row.config_item_id);
1997:
1998: END IF;
1999:
2000: IF row.config_item_id <> l_root_model_config_item_id THEN
1998: END IF;
1999:
2000: IF row.config_item_id <> l_root_model_config_item_id THEN
2001:
2002: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2003: aso_debug_pub.add('PRICING CALLBACK: It is a child line');
2004: END IF;
2005:
2006: record_count1 := record_count1 + 1;
1999:
2000: IF row.config_item_id <> l_root_model_config_item_id THEN
2001:
2002: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2003: aso_debug_pub.add('PRICING CALLBACK: It is a child line');
2004: END IF;
2005:
2006: record_count1 := record_count1 + 1;
2007:
2014:
2015: OPEN c_pricelist_id(row.config_item_id, l_config_header_id);
2016: FETCH c_pricelist_id into l_line_price_list_id, l_quote_line_id;
2017:
2018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2019: aso_debug_pub.add('PRICING CALLBACK: l_line_price_list_id: ' || l_line_price_list_id);
2020: aso_debug_pub.add('PRICING CALLBACK: l_quote_line_id: ' || l_quote_line_id);
2021: END IF;
2022:
2015: OPEN c_pricelist_id(row.config_item_id, l_config_header_id);
2016: FETCH c_pricelist_id into l_line_price_list_id, l_quote_line_id;
2017:
2018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2019: aso_debug_pub.add('PRICING CALLBACK: l_line_price_list_id: ' || l_line_price_list_id);
2020: aso_debug_pub.add('PRICING CALLBACK: l_quote_line_id: ' || l_quote_line_id);
2021: END IF;
2022:
2023: IF c_pricelist_id%FOUND THEN
2016: FETCH c_pricelist_id into l_line_price_list_id, l_quote_line_id;
2017:
2018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2019: aso_debug_pub.add('PRICING CALLBACK: l_line_price_list_id: ' || l_line_price_list_id);
2020: aso_debug_pub.add('PRICING CALLBACK: l_quote_line_id: ' || l_quote_line_id);
2021: END IF;
2022:
2023: IF c_pricelist_id%FOUND THEN
2024:
2021: END IF;
2022:
2023: IF c_pricelist_id%FOUND THEN
2024:
2025: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2026: aso_debug_pub.add('PRICING CALLBACK: Inside c_pricelist_id cursor FOUND');
2027: END IF;
2028:
2029: IF l_line_price_list_id IS NOT NULL THEN
2022:
2023: IF c_pricelist_id%FOUND THEN
2024:
2025: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2026: aso_debug_pub.add('PRICING CALLBACK: Inside c_pricelist_id cursor FOUND');
2027: END IF;
2028:
2029: IF l_line_price_list_id IS NOT NULL THEN
2030: l_qte_line_tbl(record_count1).price_list_id := l_line_price_list_id;
2034: l_qte_line_tbl(record_count1).quote_line_id := l_quote_line_id;
2035:
2036: ELSE
2037:
2038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2039: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE c_pricelist_id cursor FOUND');
2040: END IF;
2041:
2042: l_qte_line_tbl(record_count1).quote_line_id := 0;
2035:
2036: ELSE
2037:
2038: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2039: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE c_pricelist_id cursor FOUND');
2040: END IF;
2041:
2042: l_qte_line_tbl(record_count1).quote_line_id := 0;
2043: l_qte_line_tbl(record_count1).price_list_id := l_model_price_list_id;
2047: CLOSE c_pricelist_id;
2048:
2049: ELSE
2050:
2051: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2052: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE l_config_header_id IS NOT NULL');
2053: END IF;
2054:
2055: l_qte_line_tbl(record_count1).quote_line_id := 0;
2048:
2049: ELSE
2050:
2051: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2052: aso_debug_pub.add('PRICING CALLBACK: Inside ELSE l_config_header_id IS NOT NULL');
2053: END IF;
2054:
2055: l_qte_line_tbl(record_count1).quote_line_id := 0;
2056: l_qte_line_tbl(record_count1).price_list_id := l_model_price_list_id;
2056: l_qte_line_tbl(record_count1).price_list_id := l_model_price_list_id;
2057:
2058: END IF;
2059:
2060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2061: aso_debug_pub.add('PRICING CALLBACK: It is a child line: After populating the child line information');
2062: END IF;
2063:
2064: ELSE
2057:
2058: END IF;
2059:
2060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2061: aso_debug_pub.add('PRICING CALLBACK: It is a child line: After populating the child line information');
2062: END IF;
2063:
2064: ELSE
2065:
2063:
2064: ELSE
2065:
2066: record_count1 := record_count1 + 1;
2067: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2068: aso_debug_pub.add('PRICING CALLBACK: ELSE cond of row.config_item_id <> l_root_model_config_item_id: It is model line');
2069: END IF;
2070:
2071: l_qte_line_tbl(record_count1).inventory_item_id := row.item_id;
2064: ELSE
2065:
2066: record_count1 := record_count1 + 1;
2067: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2068: aso_debug_pub.add('PRICING CALLBACK: ELSE cond of row.config_item_id <> l_root_model_config_item_id: It is model line');
2069: END IF;
2070:
2071: l_qte_line_tbl(record_count1).inventory_item_id := row.item_id;
2072: l_qte_line_tbl(record_count1).quantity := row.quantity;
2074: l_qte_line_tbl(record_count1).price_list_id := l_model_price_list_id;
2075: l_qte_line_tbl(record_count1).quote_line_id := l_model_quote_line_id;
2076: l_qte_line_dtl_tbl(record_count1).config_item_id := row.config_item_id;
2077:
2078: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2079: aso_debug_pub.add('PRICING CALLBACK: It is model line: After populating the model information');
2080: END IF;
2081:
2082: END IF;
2075: l_qte_line_tbl(record_count1).quote_line_id := l_model_quote_line_id;
2076: l_qte_line_dtl_tbl(record_count1).config_item_id := row.config_item_id;
2077:
2078: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2079: aso_debug_pub.add('PRICING CALLBACK: It is model line: After populating the model information');
2080: END IF;
2081:
2082: END IF;
2083:
2084: open c_charge_periodicity_code(row.item_id, l_master_organization_id);
2085: fetch c_charge_periodicity_code into l_qte_line_tbl(record_count1).charge_periodicity_code;
2086: close c_charge_periodicity_code;
2087:
2088: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2089: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('|| record_count1 ||').charge_periodicity_code: '|| l_qte_line_tbl(record_count1).charge_periodicity_code);
2090: End if;
2091:
2092: END LOOP;
2085: fetch c_charge_periodicity_code into l_qte_line_tbl(record_count1).charge_periodicity_code;
2086: close c_charge_periodicity_code;
2087:
2088: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2089: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('|| record_count1 ||').charge_periodicity_code: '|| l_qte_line_tbl(record_count1).charge_periodicity_code);
2090: End if;
2091:
2092: END LOOP;
2093:
2096: l_pricing_control_rec.price_mode := 'ENTIRE_QUOTE';
2097:
2098: END IF;
2099:
2100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2101:
2102: aso_debug_pub.add('PRICING CALLBACK: After C_options cursor loop: l_qte_line_tbl.count: '||l_qte_line_tbl.count);
2103:
2104: FOR i IN 1..l_qte_line_tbl.count LOOP
2098: END IF;
2099:
2100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2101:
2102: aso_debug_pub.add('PRICING CALLBACK: After C_options cursor loop: l_qte_line_tbl.count: '||l_qte_line_tbl.count);
2103:
2104: FOR i IN 1..l_qte_line_tbl.count LOOP
2105:
2106: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
2102: aso_debug_pub.add('PRICING CALLBACK: After C_options cursor loop: l_qte_line_tbl.count: '||l_qte_line_tbl.count);
2103:
2104: FOR i IN 1..l_qte_line_tbl.count LOOP
2105:
2106: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
2107: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id);
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2103:
2104: FOR i IN 1..l_qte_line_tbl.count LOOP
2105:
2106: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
2107: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id);
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2111: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').charge_periodicity_code: '|| l_qte_line_tbl(i).charge_periodicity_code);
2104: FOR i IN 1..l_qte_line_tbl.count LOOP
2105:
2106: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
2107: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id);
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2111: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').charge_periodicity_code: '|| l_qte_line_tbl(i).charge_periodicity_code);
2112: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2105:
2106: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
2107: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id);
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2111: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').charge_periodicity_code: '|| l_qte_line_tbl(i).charge_periodicity_code);
2112: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2113:
2106: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
2107: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id);
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2111: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').charge_periodicity_code: '|| l_qte_line_tbl(i).charge_periodicity_code);
2112: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2113:
2114: END LOOP;
2107: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').inventory_item_id: '|| l_qte_line_tbl(i).inventory_item_id);
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2111: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').charge_periodicity_code: '|| l_qte_line_tbl(i).charge_periodicity_code);
2112: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2113:
2114: END LOOP;
2115:
2108: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').quantity: '|| l_qte_line_tbl(i).quantity);
2109: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').uom_code: '|| l_qte_line_tbl(i).uom_code);
2110: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').price_list_id: '|| l_qte_line_tbl(i).price_list_id);
2111: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_tbl('||i||').charge_periodicity_code: '|| l_qte_line_tbl(i).charge_periodicity_code);
2112: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2113:
2114: END LOOP;
2115:
2116: END IF;
2114: END LOOP;
2115:
2116: END IF;
2117:
2118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2119:
2120: aso_debug_pub.add('PRICING CALLBACK: After C_options cursor loop: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);
2121:
2122: FOR i IN 1..l_qte_line_dtl_tbl.count LOOP
2116: END IF;
2117:
2118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2119:
2120: aso_debug_pub.add('PRICING CALLBACK: After C_options cursor loop: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);
2121:
2122: FOR i IN 1..l_qte_line_dtl_tbl.count LOOP
2123:
2124: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2120: aso_debug_pub.add('PRICING CALLBACK: After C_options cursor loop: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);
2121:
2122: FOR i IN 1..l_qte_line_dtl_tbl.count LOOP
2123:
2124: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('||i||').config_item_id:'|| l_qte_line_dtl_tbl(i).config_item_id);
2125:
2126: END LOOP;
2127:
2128: END IF;
2130: --Set the control record parameter values
2131:
2132: l_pricing_control_rec.price_config_flag := 'Y';
2133:
2134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2135:
2136: aso_debug_pub.add('l_pricing_control_rec.request_type: '||l_pricing_control_rec.request_type);
2137: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2138: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2132: l_pricing_control_rec.price_config_flag := 'Y';
2133:
2134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2135:
2136: aso_debug_pub.add('l_pricing_control_rec.request_type: '||l_pricing_control_rec.request_type);
2137: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2138: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2139: aso_debug_pub.add('l_pricing_control_rec.price_config_flag: '||l_pricing_control_rec.price_config_flag);
2140:
2133:
2134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2135:
2136: aso_debug_pub.add('l_pricing_control_rec.request_type: '||l_pricing_control_rec.request_type);
2137: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2138: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2139: aso_debug_pub.add('l_pricing_control_rec.price_config_flag: '||l_pricing_control_rec.price_config_flag);
2140:
2141: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Before call to ASO_PRICING_INT.Pricing_Order');
2134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2135:
2136: aso_debug_pub.add('l_pricing_control_rec.request_type: '||l_pricing_control_rec.request_type);
2137: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2138: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2139: aso_debug_pub.add('l_pricing_control_rec.price_config_flag: '||l_pricing_control_rec.price_config_flag);
2140:
2141: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Before call to ASO_PRICING_INT.Pricing_Order');
2142:
2135:
2136: aso_debug_pub.add('l_pricing_control_rec.request_type: '||l_pricing_control_rec.request_type);
2137: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2138: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2139: aso_debug_pub.add('l_pricing_control_rec.price_config_flag: '||l_pricing_control_rec.price_config_flag);
2140:
2141: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Before call to ASO_PRICING_INT.Pricing_Order');
2142:
2143: END IF;
2137: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2138: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2139: aso_debug_pub.add('l_pricing_control_rec.price_config_flag: '||l_pricing_control_rec.price_config_flag);
2140:
2141: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Before call to ASO_PRICING_INT.Pricing_Order');
2142:
2143: END IF;
2144:
2145: ASO_PRICING_INT.Pricing_Order(
2166: x_msg_count => lx_msg_count,
2167: x_msg_data => lx_msg_data
2168: );
2169:
2170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2171:
2172: aso_debug_pub.add('PRICING CALLBACK: After call to ASO_PRICING_INT.Pricing_Order');
2173: aso_debug_pub.add('PRICING CALLBACK: lx_return_status: '|| lx_return_status);
2174: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2168: );
2169:
2170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2171:
2172: aso_debug_pub.add('PRICING CALLBACK: After call to ASO_PRICING_INT.Pricing_Order');
2173: aso_debug_pub.add('PRICING CALLBACK: lx_return_status: '|| lx_return_status);
2174: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2175: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2176: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2169:
2170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2171:
2172: aso_debug_pub.add('PRICING CALLBACK: After call to ASO_PRICING_INT.Pricing_Order');
2173: aso_debug_pub.add('PRICING CALLBACK: lx_return_status: '|| lx_return_status);
2174: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2175: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2176: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2177:
2170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2171:
2172: aso_debug_pub.add('PRICING CALLBACK: After call to ASO_PRICING_INT.Pricing_Order');
2173: aso_debug_pub.add('PRICING CALLBACK: lx_return_status: '|| lx_return_status);
2174: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2175: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2176: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2177:
2178: END IF;
2171:
2172: aso_debug_pub.add('PRICING CALLBACK: After call to ASO_PRICING_INT.Pricing_Order');
2173: aso_debug_pub.add('PRICING CALLBACK: lx_return_status: '|| lx_return_status);
2174: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2175: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2176: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2177:
2178: END IF;
2179:
2172: aso_debug_pub.add('PRICING CALLBACK: After call to ASO_PRICING_INT.Pricing_Order');
2173: aso_debug_pub.add('PRICING CALLBACK: lx_return_status: '|| lx_return_status);
2174: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2175: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2176: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2177:
2178: END IF;
2179:
2180: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2182: fnd_msg_pub.count_and_get( p_encoded => 'F',
2183: p_count => lx_msg_count,
2184: p_data => lx_msg_data);
2185:
2186: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2187:
2188: aso_debug_pub.add('PRICING CALLBACK: After call to fnd_msg_pub.count_and_get');
2189: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2190: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2184: p_data => lx_msg_data);
2185:
2186: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2187:
2188: aso_debug_pub.add('PRICING CALLBACK: After call to fnd_msg_pub.count_and_get');
2189: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2190: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2191:
2192: END IF;
2185:
2186: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2187:
2188: aso_debug_pub.add('PRICING CALLBACK: After call to fnd_msg_pub.count_and_get');
2189: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2190: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2191:
2192: END IF;
2193:
2186: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2187:
2188: aso_debug_pub.add('PRICING CALLBACK: After call to fnd_msg_pub.count_and_get');
2189: aso_debug_pub.add('PRICING CALLBACK: lx_msg_count: '|| lx_msg_count);
2190: aso_debug_pub.add('PRICING CALLBACK: lx_msg_data: '|| lx_msg_data);
2191:
2192: END IF;
2193:
2194: FOR k IN 1 .. lx_msg_count LOOP
2195:
2196: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,
2197: p_encoded => 'F');
2198:
2199: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2200: aso_debug_pub.add('PRICING CALLBACK: Inside Loop fnd_msg_pub.get: lx_msg_data: ' ||lx_msg_data);
2201: END IF;
2202:
2203: l_mymsg := l_mymsg || ' ' || lx_msg_data;
2196: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,
2197: p_encoded => 'F');
2198:
2199: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2200: aso_debug_pub.add('PRICING CALLBACK: Inside Loop fnd_msg_pub.get: lx_msg_data: ' ||lx_msg_data);
2201: END IF;
2202:
2203: l_mymsg := l_mymsg || ' ' || lx_msg_data;
2204:
2205: END LOOP;
2206:
2207: END IF;
2208:
2209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2210: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_mymsg: ' || l_mymsg);
2211: END IF;
2212:
2213: -- set the error message in the model line msg_data field of cz_pricing_structure
2206:
2207: END IF;
2208:
2209: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2210: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_mymsg: ' || l_mymsg);
2211: END IF;
2212:
2213: -- set the error message in the model line msg_data field of cz_pricing_structure
2214:
2213: -- set the error message in the model line msg_data field of cz_pricing_structure
2214:
2215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN
2216:
2217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2218: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2219: END IF;
2220:
2221: UPDATE CZ_PRICING_STRUCTURES
2214:
2215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN
2216:
2217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2218: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2219: END IF;
2220:
2221: UPDATE CZ_PRICING_STRUCTURES
2222: SET MSG_DATA = l_mymsg
2231:
2232: FOR i IN l_count+1..lx_qte_line_tbl.count LOOP
2233:
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236:
2237: aso_debug_pub.add('PRICING CALLBACK: Inside Loop IF quote_line_id = 0');
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2233:
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236:
2237: aso_debug_pub.add('PRICING CALLBACK: Inside Loop IF quote_line_id = 0');
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2234:
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236:
2237: aso_debug_pub.add('PRICING CALLBACK: Inside Loop IF quote_line_id = 0');
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2242: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i - l_count||').config_item_id: '|| l_qte_line_dtl_tbl(i - l_count).config_item_id);
2235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2236:
2237: aso_debug_pub.add('PRICING CALLBACK: Inside Loop IF quote_line_id = 0');
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2242: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i - l_count||').config_item_id: '|| l_qte_line_dtl_tbl(i - l_count).config_item_id);
2243: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i||').config_item_id: '|| l_qte_line_dtl_tbl(i
2236:
2237: aso_debug_pub.add('PRICING CALLBACK: Inside Loop IF quote_line_id = 0');
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2242: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i - l_count||').config_item_id: '|| l_qte_line_dtl_tbl(i - l_count).config_item_id);
2243: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i||').config_item_id: '|| l_qte_line_dtl_tbl(i
2244: - l_count).config_item_id);
2237: aso_debug_pub.add('PRICING CALLBACK: Inside Loop IF quote_line_id = 0');
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2242: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i - l_count||').config_item_id: '|| l_qte_line_dtl_tbl(i - l_count).config_item_id);
2243: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i||').config_item_id: '|| l_qte_line_dtl_tbl(i
2244: - l_count).config_item_id);
2245:
2238: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').quote_line_id: '|| lx_qte_line_tbl(i).quote_line_id);
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2242: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i - l_count||').config_item_id: '|| l_qte_line_dtl_tbl(i - l_count).config_item_id);
2243: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i||').config_item_id: '|| l_qte_line_dtl_tbl(i
2244: - l_count).config_item_id);
2245:
2246: END IF;
2239: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_list_price: '|| lx_qte_line_tbl(i).line_list_price);
2240: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl('||i||').line_quote_price: '|| lx_qte_line_tbl(i).line_quote_price);
2241: aso_debug_pub.add('PRICING CALLBACK: l_count: '|| l_count);
2242: --aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i - l_count||').config_item_id: '|| l_qte_line_dtl_tbl(i - l_count).config_item_id);
2243: aso_debug_pub.add('PRICING CALLBACK: l_qte_line_dtl_tbl('|| i||').config_item_id: '|| l_qte_line_dtl_tbl(i
2244: - l_count).config_item_id);
2245:
2246: END IF;
2247:
2250: list_price = lx_qte_line_tbl(i).line_list_price
2251: WHERE configurator_session_key = p_config_session_key
2252: AND config_item_id = l_qte_line_dtl_tbl(i - l_count).config_item_id;
2253:
2254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2255: aso_debug_pub.add('PRICING CALLBACK: After Update sql%rowcount: '|| sql%rowcount);
2256: END IF;
2257:
2258: END LOOP;
2251: WHERE configurator_session_key = p_config_session_key
2252: AND config_item_id = l_qte_line_dtl_tbl(i - l_count).config_item_id;
2253:
2254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2255: aso_debug_pub.add('PRICING CALLBACK: After Update sql%rowcount: '|| sql%rowcount);
2256: END IF;
2257:
2258: END LOOP;
2259:
2266: EXCEPTION
2267:
2268: WHEN OTHERS THEN
2269:
2270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2271: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception for select sum(selling_price)');
2272: END IF;
2273:
2274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2267:
2268: WHEN OTHERS THEN
2269:
2270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2271: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception for select sum(selling_price)');
2272: END IF;
2273:
2274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2275:
2277:
2278:
2279: -- Writing Data from CZ table to ASO Debug File
2280:
2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2282:
2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2281: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2282:
2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2282:
2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2290: END LOOP;
2283: FOR row IN c_get_pricing_structure(p_config_session_key) LOOP
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2290: END LOOP;
2291:
2284:
2285: aso_debug_pub.add('PRICING CALLBACK: Data in CZ_PRICING_STRUCTURES table after update to list and selling prices columns.');
2286: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: config_item_id: ' || row.config_item_id);
2287: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: list_price: ' || row.list_price);
2288: aso_debug_pub.add('PRICING CALLBACK: CZ_PRICING_STRUCTURES: selling_price: ' || row.selling_price);
2289:
2290: END LOOP;
2291:
2292: END IF;
2291:
2292: END IF;
2293:
2294:
2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2296: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );
2297: END IF;
2298:
2299:
2292: END IF;
2293:
2294:
2295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2296: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );
2297: END IF;
2298:
2299:
2300: EXCEPTION
2300: EXCEPTION
2301:
2302: WHEN OTHERS THEN
2303:
2304: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2305: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception');
2306: END IF;
2307:
2308: -- set the error message in the model line msg_data field of cz_pricing_structure
2301:
2302: WHEN OTHERS THEN
2303:
2304: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2305: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception');
2306: END IF;
2307:
2308: -- set the error message in the model line msg_data field of cz_pricing_structure
2309: UPDATE CZ_PRICING_STRUCTURES
2348: l_index NUMBER := 0;
2349:
2350: BEGIN
2351:
2352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2353: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: P_Qte_Header_Id: '|| P_Qte_Header_Id);
2354: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: p_qte_line_id : '|| p_qte_line_id );
2355: END IF;
2356:
2349:
2350: BEGIN
2351:
2352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2353: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: P_Qte_Header_Id: '|| P_Qte_Header_Id);
2354: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: p_qte_line_id : '|| p_qte_line_id );
2355: END IF;
2356:
2357: FOR line_rec IN c_Qte_Line LOOP
2350: BEGIN
2351:
2352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2353: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: P_Qte_Header_Id: '|| P_Qte_Header_Id);
2354: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: p_qte_line_id : '|| p_qte_line_id );
2355: END IF;
2356:
2357: FOR line_rec IN c_Qte_Line LOOP
2358:
2364: l_qte_line_rec.charge_periodicity_code := line_rec.charge_periodicity_code;
2365:
2366: l_index := l_index + 1;
2367:
2368: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2369:
2370: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUOTE_LINE_ID: '|| line_rec.QUOTE_LINE_ID);
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2366: l_index := l_index + 1;
2367:
2368: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2369:
2370: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUOTE_LINE_ID: '|| line_rec.QUOTE_LINE_ID);
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2373: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.PRICE_LIST_ID: '|| line_rec.PRICE_LIST_ID);
2374: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.INVENTORY_ITEM_ID: '|| line_rec.INVENTORY_ITEM_ID);
2367:
2368: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2369:
2370: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUOTE_LINE_ID: '|| line_rec.QUOTE_LINE_ID);
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2373: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.PRICE_LIST_ID: '|| line_rec.PRICE_LIST_ID);
2374: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.INVENTORY_ITEM_ID: '|| line_rec.INVENTORY_ITEM_ID);
2375: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.charge_periodicity_code: '|| line_rec.charge_periodicity_code);
2368: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2369:
2370: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUOTE_LINE_ID: '|| line_rec.QUOTE_LINE_ID);
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2373: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.PRICE_LIST_ID: '|| line_rec.PRICE_LIST_ID);
2374: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.INVENTORY_ITEM_ID: '|| line_rec.INVENTORY_ITEM_ID);
2375: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.charge_periodicity_code: '|| line_rec.charge_periodicity_code);
2376:
2369:
2370: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUOTE_LINE_ID: '|| line_rec.QUOTE_LINE_ID);
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2373: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.PRICE_LIST_ID: '|| line_rec.PRICE_LIST_ID);
2374: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.INVENTORY_ITEM_ID: '|| line_rec.INVENTORY_ITEM_ID);
2375: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.charge_periodicity_code: '|| line_rec.charge_periodicity_code);
2376:
2377: END IF;
2370: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUOTE_LINE_ID: '|| line_rec.QUOTE_LINE_ID);
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2373: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.PRICE_LIST_ID: '|| line_rec.PRICE_LIST_ID);
2374: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.INVENTORY_ITEM_ID: '|| line_rec.INVENTORY_ITEM_ID);
2375: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.charge_periodicity_code: '|| line_rec.charge_periodicity_code);
2376:
2377: END IF;
2378:
2371: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.QUANTITY: '|| line_rec.QUANTITY);
2372: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.UOM_CODE: '|| line_rec.UOM_CODE);
2373: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.PRICE_LIST_ID: '|| line_rec.PRICE_LIST_ID);
2374: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.INVENTORY_ITEM_ID: '|| line_rec.INVENTORY_ITEM_ID);
2375: aso_debug_pub.add('Query_Qte_Line_Rows: line_rec.charge_periodicity_code: '|| line_rec.charge_periodicity_code);
2376:
2377: END IF;
2378:
2379: l_Qte_Line_tbl(l_index) := l_Qte_Line_rec;
2379: l_Qte_Line_tbl(l_index) := l_Qte_Line_rec;
2380:
2381: END LOOP;
2382:
2383: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2384: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: l_Qte_Line_tbl.count: '|| l_Qte_Line_tbl.count);
2385: END IF;
2386:
2387: RETURN l_Qte_Line_tbl;
2380:
2381: END LOOP;
2382:
2383: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2384: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: l_Qte_Line_tbl.count: '|| l_Qte_Line_tbl.count);
2385: END IF;
2386:
2387: RETURN l_Qte_Line_tbl;
2388:
2447: l_xml_hdr VARCHAR2(2000):= '
2448: l_dummy VARCHAR2(500) := NULL;
2449:
2450: BEGIN
2451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2452: aso_debug_pub.add('Create_hdr_xml Begins.', 1, 'Y');
2453: END IF;
2454:
2455: --Initialize API return status to SUCCESS
2448: l_dummy VARCHAR2(500) := NULL;
2449:
2450: BEGIN
2451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2452: aso_debug_pub.add('Create_hdr_xml Begins.', 1, 'Y');
2453: END IF;
2454:
2455: --Initialize API return status to SUCCESS
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2459:
2460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2461: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2462: END IF;
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2457:
2458: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2459:
2460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2461: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2462: END IF;
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2465:
2462: END IF;
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
2468: END IF;
2469:
2470: /* Fix for bug 3998564 */
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
2468: END IF;
2469:
2470: /* Fix for bug 3998564 */
2471: --OPEN C_org_id( l_model_line_rec.quote_header_id);
2475: FETCH c_inv_org_id INTO l_org_id;
2476: CLOSE c_inv_org_id;
2477: /* End of fix for bug 3998564 */
2478:
2479: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2480: aso_debug_pub.add('Create_hdr_xml: After C_org_id cursor: l_org_id: '|| l_org_id, 1, 'N');
2481: END IF;
2482:
2483: IF l_org_id IS NULL THEN
2476: CLOSE c_inv_org_id;
2477: /* End of fix for bug 3998564 */
2478:
2479: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2480: aso_debug_pub.add('Create_hdr_xml: After C_org_id cursor: l_org_id: '|| l_org_id, 1, 'N');
2481: END IF;
2482:
2483: IF l_org_id IS NULL THEN
2484:
2494: L_org_id := l_model_line_rec.org_id; --New Code Yogeshwar MOAC
2495:
2496: END IF;
2497:
2498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2499: aso_debug_pub.add('Create_hdr_xml: After Defaulting from client info. l_org_id: '|| l_org_id);
2500: END IF;
2501:
2502: --Set the values from model_line_rec, model_line_dtl_tbl and org_id
2495:
2496: END IF;
2497:
2498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2499: aso_debug_pub.add('Create_hdr_xml: After Defaulting from client info. l_org_id: '|| l_org_id);
2500: END IF;
2501:
2502: --Set the values from model_line_rec, model_line_dtl_tbl and org_id
2503: l_context_org_id := to_char(l_org_id);
2506: l_config_rev_nbr := to_char(l_model_line_dtl_tbl(1).config_revision_num);
2507: l_config_creation_date := to_char(l_model_line_rec.creation_date,'MM-DD-YYYY-HH24-MI-SS');
2508: l_model_quantity := to_char(l_model_line_rec.quantity);
2509:
2510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2511:
2512: aso_debug_pub.add('Create_hdr_xml: l_context_org_id :' || l_context_org_id);
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2508: l_model_quantity := to_char(l_model_line_rec.quantity);
2509:
2510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2511:
2512: aso_debug_pub.add('Create_hdr_xml: l_context_org_id :' || l_context_org_id);
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2515: aso_debug_pub.add('Create_hdr_xml: l_config_rev_nbr :' || l_config_rev_nbr);
2516: aso_debug_pub.add('Create_hdr_xml: l_config_creation_date:' || l_config_creation_date);
2509:
2510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2511:
2512: aso_debug_pub.add('Create_hdr_xml: l_context_org_id :' || l_context_org_id);
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2515: aso_debug_pub.add('Create_hdr_xml: l_config_rev_nbr :' || l_config_rev_nbr);
2516: aso_debug_pub.add('Create_hdr_xml: l_config_creation_date:' || l_config_creation_date);
2517: aso_debug_pub.add('Create_hdr_xml: l_model_quantity :' || l_model_quantity);
2510: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2511:
2512: aso_debug_pub.add('Create_hdr_xml: l_context_org_id :' || l_context_org_id);
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2515: aso_debug_pub.add('Create_hdr_xml: l_config_rev_nbr :' || l_config_rev_nbr);
2516: aso_debug_pub.add('Create_hdr_xml: l_config_creation_date:' || l_config_creation_date);
2517: aso_debug_pub.add('Create_hdr_xml: l_model_quantity :' || l_model_quantity);
2518:
2511:
2512: aso_debug_pub.add('Create_hdr_xml: l_context_org_id :' || l_context_org_id);
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2515: aso_debug_pub.add('Create_hdr_xml: l_config_rev_nbr :' || l_config_rev_nbr);
2516: aso_debug_pub.add('Create_hdr_xml: l_config_creation_date:' || l_config_creation_date);
2517: aso_debug_pub.add('Create_hdr_xml: l_model_quantity :' || l_model_quantity);
2518:
2519: END IF;
2512: aso_debug_pub.add('Create_hdr_xml: l_context_org_id :' || l_context_org_id);
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2515: aso_debug_pub.add('Create_hdr_xml: l_config_rev_nbr :' || l_config_rev_nbr);
2516: aso_debug_pub.add('Create_hdr_xml: l_config_creation_date:' || l_config_creation_date);
2517: aso_debug_pub.add('Create_hdr_xml: l_model_quantity :' || l_model_quantity);
2518:
2519: END IF;
2520:
2513: aso_debug_pub.add('Create_hdr_xml: l_inventory_item_id :' || l_inventory_item_id);
2514: aso_debug_pub.add('Create_hdr_xml: l_config_header_id :' || l_config_header_id);
2515: aso_debug_pub.add('Create_hdr_xml: l_config_rev_nbr :' || l_config_rev_nbr);
2516: aso_debug_pub.add('Create_hdr_xml: l_config_creation_date:' || l_config_creation_date);
2517: aso_debug_pub.add('Create_hdr_xml: l_model_quantity :' || l_model_quantity);
2518:
2519: END IF;
2520:
2521: -- Set values from profiles and env. variables.
2523: l_responsibility_id := fnd_global.resp_id;
2524: l_database_id := fnd_web_config.database_id;
2525: l_icx_session_ticket := cz_cf_api.icx_session_ticket;
2526:
2527: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2528:
2529: aso_debug_pub.add('Create_hdr_xml: l_calling_application_id:' || l_calling_application_id);
2530: aso_debug_pub.add('Create_hdr_xml: l_responsibility_id :' || l_responsibility_id);
2531: aso_debug_pub.add('Create_hdr_xml: l_database_id :' || l_database_id);
2525: l_icx_session_ticket := cz_cf_api.icx_session_ticket;
2526:
2527: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2528:
2529: aso_debug_pub.add('Create_hdr_xml: l_calling_application_id:' || l_calling_application_id);
2530: aso_debug_pub.add('Create_hdr_xml: l_responsibility_id :' || l_responsibility_id);
2531: aso_debug_pub.add('Create_hdr_xml: l_database_id :' || l_database_id);
2532: aso_debug_pub.add('Create_hdr_xml: l_icx_session_ticket :' || l_icx_session_ticket);
2533:
2526:
2527: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2528:
2529: aso_debug_pub.add('Create_hdr_xml: l_calling_application_id:' || l_calling_application_id);
2530: aso_debug_pub.add('Create_hdr_xml: l_responsibility_id :' || l_responsibility_id);
2531: aso_debug_pub.add('Create_hdr_xml: l_database_id :' || l_database_id);
2532: aso_debug_pub.add('Create_hdr_xml: l_icx_session_ticket :' || l_icx_session_ticket);
2533:
2534: END IF;
2527: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2528:
2529: aso_debug_pub.add('Create_hdr_xml: l_calling_application_id:' || l_calling_application_id);
2530: aso_debug_pub.add('Create_hdr_xml: l_responsibility_id :' || l_responsibility_id);
2531: aso_debug_pub.add('Create_hdr_xml: l_database_id :' || l_database_id);
2532: aso_debug_pub.add('Create_hdr_xml: l_icx_session_ticket :' || l_icx_session_ticket);
2533:
2534: END IF;
2535:
2528:
2529: aso_debug_pub.add('Create_hdr_xml: l_calling_application_id:' || l_calling_application_id);
2530: aso_debug_pub.add('Create_hdr_xml: l_responsibility_id :' || l_responsibility_id);
2531: aso_debug_pub.add('Create_hdr_xml: l_database_id :' || l_database_id);
2532: aso_debug_pub.add('Create_hdr_xml: l_icx_session_ticket :' || l_icx_session_ticket);
2533:
2534: END IF;
2535:
2536: -- set param_names
2597:
2598: l_xml_hdr := l_xml_hdr || '';
2599: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
2600:
2601: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2602:
2603: aso_debug_pub.add('Create_hdr_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2599: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
2600:
2601: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2602:
2603: aso_debug_pub.add('Create_hdr_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2600:
2601: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2602:
2603: aso_debug_pub.add('Create_hdr_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2601: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2602:
2603: aso_debug_pub.add('Create_hdr_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2602:
2603: aso_debug_pub.add('Create_hdr_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2610: aso_debug_pub.add('Create_hdr_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
2603: aso_debug_pub.add('Create_hdr_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2610: aso_debug_pub.add('Create_hdr_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
2611: aso_debug_pub.add('Create_hdr_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
2604: aso_debug_pub.add('Create_hdr_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2610: aso_debug_pub.add('Create_hdr_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
2611: aso_debug_pub.add('Create_hdr_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
2612:
2605: aso_debug_pub.add('Create_hdr_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2610: aso_debug_pub.add('Create_hdr_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
2611: aso_debug_pub.add('Create_hdr_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
2612:
2613: END IF;
2606: aso_debug_pub.add('Create_hdr_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2610: aso_debug_pub.add('Create_hdr_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
2611: aso_debug_pub.add('Create_hdr_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
2612:
2613: END IF;
2614:
2607: aso_debug_pub.add('Create_hdr_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
2608: aso_debug_pub.add('Create_hdr_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
2609: aso_debug_pub.add('Create_hdr_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
2610: aso_debug_pub.add('Create_hdr_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
2611: aso_debug_pub.add('Create_hdr_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
2612:
2613: END IF;
2614:
2615: x_xml_hdr := l_xml_hdr;
2613: END IF;
2614:
2615: x_xml_hdr := l_xml_hdr;
2616:
2617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2618: aso_debug_pub.add('End of Create_hdr_xml.', 1, 'Y');
2619: END IF;
2620:
2621:
2614:
2615: x_xml_hdr := l_xml_hdr;
2616:
2617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2618: aso_debug_pub.add('End of Create_hdr_xml.', 1, 'Y');
2619: END IF;
2620:
2621:
2622: EXCEPTION
2624: when others then
2625:
2626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2627:
2628: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2629: aso_debug_pub.add('Create_hdr_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
2630: END IF;
2631:
2632: END Create_hdr_xml;
2625:
2626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2627:
2628: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2629: aso_debug_pub.add('Create_hdr_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
2630: END IF;
2631:
2632: END Create_hdr_xml;
2633:
2694: l_index BINARY_INTEGER;
2695: i NUMBER;
2696: l_return_status VARCHAR2(1);
2697: BEGIN
2698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2699: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml Begin.', 1, 'Y');
2700: END IF;
2701:
2702: --Initialize API return status to SUCCESS
2695: i NUMBER;
2696: l_return_status VARCHAR2(1);
2697: BEGIN
2698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2699: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml Begin.', 1, 'Y');
2700: END IF;
2701:
2702: --Initialize API return status to SUCCESS
2703: l_return_status := FND_API.G_RET_STS_SUCCESS;
2703: l_return_status := FND_API.G_RET_STS_SUCCESS;
2704:
2705: l_xml_hdr := p_xml_hdr;
2706:
2707: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2708: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: Before the quote line Loop.', 1, 'Y');
2709: END IF;
2710:
2711: FOR i IN 1..P_Qte_Line_Tbl.COUNT LOOP
2704:
2705: l_xml_hdr := p_xml_hdr;
2706:
2707: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2708: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: Before the quote line Loop.', 1, 'Y');
2709: END IF;
2710:
2711: FOR i IN 1..P_Qte_Line_Tbl.COUNT LOOP
2712:
2721: END IF;
2722:
2723: l_batch_val_tbl(i) := l_option_rec;
2724:
2725: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2726:
2727: aso_debug_pub.add('l_batch_val_tbl('||i||').input_seq: '||l_batch_val_tbl(i).input_seq);
2728: aso_debug_pub.add('l_batch_val_tbl('||i||').component_code: '||l_batch_val_tbl(i).component_code);
2729: aso_debug_pub.add('l_batch_val_tbl('||i||').quantity: '||l_batch_val_tbl(i).quantity);
2723: l_batch_val_tbl(i) := l_option_rec;
2724:
2725: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2726:
2727: aso_debug_pub.add('l_batch_val_tbl('||i||').input_seq: '||l_batch_val_tbl(i).input_seq);
2728: aso_debug_pub.add('l_batch_val_tbl('||i||').component_code: '||l_batch_val_tbl(i).component_code);
2729: aso_debug_pub.add('l_batch_val_tbl('||i||').quantity: '||l_batch_val_tbl(i).quantity);
2730: aso_debug_pub.add('l_batch_val_tbl('||i||').config_item_id: '||l_batch_val_tbl(i).config_item_id);
2731:
2724:
2725: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2726:
2727: aso_debug_pub.add('l_batch_val_tbl('||i||').input_seq: '||l_batch_val_tbl(i).input_seq);
2728: aso_debug_pub.add('l_batch_val_tbl('||i||').component_code: '||l_batch_val_tbl(i).component_code);
2729: aso_debug_pub.add('l_batch_val_tbl('||i||').quantity: '||l_batch_val_tbl(i).quantity);
2730: aso_debug_pub.add('l_batch_val_tbl('||i||').config_item_id: '||l_batch_val_tbl(i).config_item_id);
2731:
2732: END IF;
2725: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2726:
2727: aso_debug_pub.add('l_batch_val_tbl('||i||').input_seq: '||l_batch_val_tbl(i).input_seq);
2728: aso_debug_pub.add('l_batch_val_tbl('||i||').component_code: '||l_batch_val_tbl(i).component_code);
2729: aso_debug_pub.add('l_batch_val_tbl('||i||').quantity: '||l_batch_val_tbl(i).quantity);
2730: aso_debug_pub.add('l_batch_val_tbl('||i||').config_item_id: '||l_batch_val_tbl(i).config_item_id);
2731:
2732: END IF;
2733:
2726:
2727: aso_debug_pub.add('l_batch_val_tbl('||i||').input_seq: '||l_batch_val_tbl(i).input_seq);
2728: aso_debug_pub.add('l_batch_val_tbl('||i||').component_code: '||l_batch_val_tbl(i).component_code);
2729: aso_debug_pub.add('l_batch_val_tbl('||i||').quantity: '||l_batch_val_tbl(i).quantity);
2730: aso_debug_pub.add('l_batch_val_tbl('||i||').config_item_id: '||l_batch_val_tbl(i).config_item_id);
2731:
2732: END IF;
2733:
2734: END LOOP;
2732: END IF;
2733:
2734: END LOOP;
2735:
2736: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2737: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: After the quote line Loop.', 1, 'Y');
2738: END IF;
2739:
2740: -- delete previous data.
2733:
2734: END LOOP;
2735:
2736: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2737: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: After the quote line Loop.', 1, 'Y');
2738: END IF;
2739:
2740: -- delete previous data.
2741: IF (l_html_pieces.COUNT <> 0) THEN
2741: IF (l_html_pieces.COUNT <> 0) THEN
2742: l_html_pieces.DELETE;
2743: END IF;
2744:
2745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2746: aso_debug_pub.add('Send_input_xml: l_html_pieces.COUNT: '||l_html_pieces.COUNT);
2747: aso_debug_pub.add('Send_input_xml: Before call to CZ_CF_API.Validate');
2748: END IF;
2749:
2742: l_html_pieces.DELETE;
2743: END IF;
2744:
2745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2746: aso_debug_pub.add('Send_input_xml: l_html_pieces.COUNT: '||l_html_pieces.COUNT);
2747: aso_debug_pub.add('Send_input_xml: Before call to CZ_CF_API.Validate');
2748: END IF;
2749:
2750: CZ_CF_API.Validate( config_input_list => l_batch_val_tbl,
2743: END IF;
2744:
2745: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2746: aso_debug_pub.add('Send_input_xml: l_html_pieces.COUNT: '||l_html_pieces.COUNT);
2747: aso_debug_pub.add('Send_input_xml: Before call to CZ_CF_API.Validate');
2748: END IF;
2749:
2750: CZ_CF_API.Validate( config_input_list => l_batch_val_tbl,
2751: init_message => l_xml_hdr,
2752: config_messages => l_html_pieces,
2753: validation_status => l_validation_status,
2754: URL => l_url );
2755:
2756: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2757: aso_debug_pub.add('Send_input_xml: After call to CZ_CF_API.Validate: l_validation_status: '||l_validation_status);
2758: END IF;
2759:
2760: IF l_validation_status <> 0 THEN
2753: validation_status => l_validation_status,
2754: URL => l_url );
2755:
2756: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2757: aso_debug_pub.add('Send_input_xml: After call to CZ_CF_API.Validate: l_validation_status: '||l_validation_status);
2758: END IF;
2759:
2760: IF l_validation_status <> 0 THEN
2761:
2758: END IF;
2759:
2760: IF l_validation_status <> 0 THEN
2761:
2762: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2763: aso_debug_pub.add('Send_input_xml: Error returned from CZ_CF_API.Validate');
2764: END IF;
2765:
2766: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
2759:
2760: IF l_validation_status <> 0 THEN
2761:
2762: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2763: aso_debug_pub.add('Send_input_xml: Error returned from CZ_CF_API.Validate');
2764: END IF;
2765:
2766: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
2767: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from CZ_CF_API.Validate, validation_status <> 0' );
2768: FND_MSG_PUB.ADD;
2769: l_return_status := FND_API.G_RET_STS_ERROR;
2770: END IF;
2771:
2772: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2773: aso_debug_pub.add('Send_input_xml: After call to CZ_CF_API.Validate: l_html_pieces.COUNT: '||l_html_pieces.COUNT);
2774: END IF;
2775:
2776: IF (l_html_pieces.COUNT <= 0) THEN
2769: l_return_status := FND_API.G_RET_STS_ERROR;
2770: END IF;
2771:
2772: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2773: aso_debug_pub.add('Send_input_xml: After call to CZ_CF_API.Validate: l_html_pieces.COUNT: '||l_html_pieces.COUNT);
2774: END IF;
2775:
2776: IF (l_html_pieces.COUNT <= 0) THEN
2777:
2774: END IF;
2775:
2776: IF (l_html_pieces.COUNT <= 0) THEN
2777:
2778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2779: aso_debug_pub.add('Send_input_xml: No XML message returned from CZ_CF_API.Validate api', 1, 'Y');
2780: END IF;
2781:
2782: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
2775:
2776: IF (l_html_pieces.COUNT <= 0) THEN
2777:
2778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2779: aso_debug_pub.add('Send_input_xml: No XML message returned from CZ_CF_API.Validate api', 1, 'Y');
2780: END IF;
2781:
2782: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
2783: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from CZ_CF_API.Validate, config_messages: l_html_pieces.COUNT <= 0' );
2789: l_index := l_html_pieces.FIRST;
2790:
2791: LOOP
2792:
2793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2794: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_html_pieces(l_index), 1, 100));
2795: END IF;
2796:
2797: l_long_xml := l_long_xml || l_html_pieces(l_index);
2790:
2791: LOOP
2792:
2793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2794: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_html_pieces(l_index), 1, 100));
2795: END IF;
2796:
2797: l_long_xml := l_long_xml || l_html_pieces(l_index);
2798:
2800: l_index := l_html_pieces.NEXT(l_index);
2801:
2802: END LOOP;
2803:
2804: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2805:
2806: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 1, 100));
2807: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 101, 200));
2808: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 201, 300));
2802: END LOOP;
2803:
2804: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2805:
2806: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 1, 100));
2807: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 101, 200));
2808: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 201, 300));
2809: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 301, 400));
2810:
2803:
2804: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2805:
2806: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 1, 100));
2807: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 101, 200));
2808: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 201, 300));
2809: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 301, 400));
2810:
2811: END IF;
2804: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2805:
2806: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 1, 100));
2807: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 101, 200));
2808: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 201, 300));
2809: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 301, 400));
2810:
2811: END IF;
2812:
2805:
2806: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 1, 100));
2807: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 101, 200));
2808: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 201, 300));
2809: aso_debug_pub.add('Send_input_xml: Part of output_message :'|| SUBSTR(l_long_xml, 301, 400));
2810:
2811: END IF;
2812:
2813: -- Return the output XML message
2813: -- Return the output XML message
2814: x_out_xml_msg := l_long_xml;
2815: x_return_status := l_return_status;
2816:
2817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2818: aso_debug_pub.Add('End of Send_input_xml', 1, 'Y');
2819: END IF;
2820:
2821: EXCEPTION
2814: x_out_xml_msg := l_long_xml;
2815: x_return_status := l_return_status;
2816:
2817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2818: aso_debug_pub.Add('End of Send_input_xml', 1, 'Y');
2819: END IF;
2820:
2821: EXCEPTION
2822:
2823: WHEN OTHERS THEN
2824:
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826:
2827: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2828: aso_debug_pub.add('Send_input_xml: Inside When Others Exception:', 1, 'N');
2829: END IF;
2830:
2831: END Send_input_xml;
2824:
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826:
2827: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2828: aso_debug_pub.add('Send_input_xml: Inside When Others Exception:', 1, 'N');
2829: END IF;
2830:
2831: END Send_input_xml;
2832:
2875: l_msg_count NUMBER;
2876: l_msg_data VARCHAR2(2000);
2877:
2878: BEGIN
2879: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2880: aso_debug_pub.add('ASO_CFG_INT: Parse_output_xml Begin.', 1, 'Y');
2881: END IF;
2882:
2883: --Initialize API return status to SUCCESS
2876: l_msg_data VARCHAR2(2000);
2877:
2878: BEGIN
2879: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2880: aso_debug_pub.add('ASO_CFG_INT: Parse_output_xml Begin.', 1, 'Y');
2881: END IF;
2882:
2883: --Initialize API return status to SUCCESS
2884: l_return_status := FND_API.G_RET_STS_SUCCESS;
2911: (instr(p_xml_msg,'',1,1) -
2912: (instr(p_xml_msg,'
2913:
2914:
2915: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2916: aso_debug_pub.add('Parse_output_xml: l_message_type: '|| l_message_type);
2917: aso_debug_pub.add('Parse_output_xml: l_message_text: '|| substr(l_message_text,1,150));
2918: aso_debug_pub.add('Parse_output_xml: l_exit : '|| l_exit);
2919: END IF;
2912: (instr(p_xml_msg,'
2913:
2914:
2915: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2916: aso_debug_pub.add('Parse_output_xml: l_message_type: '|| l_message_type);
2917: aso_debug_pub.add('Parse_output_xml: l_message_text: '|| substr(l_message_text,1,150));
2918: aso_debug_pub.add('Parse_output_xml: l_exit : '|| l_exit);
2919: END IF;
2920:
2913:
2914:
2915: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2916: aso_debug_pub.add('Parse_output_xml: l_message_type: '|| l_message_type);
2917: aso_debug_pub.add('Parse_output_xml: l_message_text: '|| substr(l_message_text,1,150));
2918: aso_debug_pub.add('Parse_output_xml: l_exit : '|| l_exit);
2919: END IF;
2920:
2921: IF l_exit = 'error' AND l_message_type = 'error' THEN
2914:
2915: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2916: aso_debug_pub.add('Parse_output_xml: l_message_type: '|| l_message_type);
2917: aso_debug_pub.add('Parse_output_xml: l_message_text: '|| substr(l_message_text,1,150));
2918: aso_debug_pub.add('Parse_output_xml: l_exit : '|| l_exit);
2919: END IF;
2920:
2921: IF l_exit = 'error' AND l_message_type = 'error' THEN
2922:
2950: l_complete_configuration_flag := 'Y';
2951: END IF;
2952:
2953:
2954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2955: aso_debug_pub.add('Parse_output_xml: l_valid_configuration_flag: '|| l_valid_configuration_flag);
2956: aso_debug_pub.add('Parse_output_xml: l_complete_configuration_flag: '|| l_complete_configuration_flag);
2957: END IF;
2958:
2951: END IF;
2952:
2953:
2954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2955: aso_debug_pub.add('Parse_output_xml: l_valid_configuration_flag: '|| l_valid_configuration_flag);
2956: aso_debug_pub.add('Parse_output_xml: l_complete_configuration_flag: '|| l_complete_configuration_flag);
2957: END IF;
2958:
2959: IF l_config_header_id is NULL THEN
2952:
2953:
2954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2955: aso_debug_pub.add('Parse_output_xml: l_valid_configuration_flag: '|| l_valid_configuration_flag);
2956: aso_debug_pub.add('Parse_output_xml: l_complete_configuration_flag: '|| l_complete_configuration_flag);
2957: END IF;
2958:
2959: IF l_config_header_id is NULL THEN
2960:
2957: END IF;
2958:
2959: IF l_config_header_id is NULL THEN
2960:
2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('Parse_output_xml: Getting messages from cz_config_messages');
2963: END IF;
2964:
2965: OPEN c_messages(l_config_header_id, l_config_revision_num);
2958:
2959: IF l_config_header_id is NULL THEN
2960:
2961: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2962: aso_debug_pub.add('Parse_output_xml: Getting messages from cz_config_messages');
2963: END IF;
2964:
2965: OPEN c_messages(l_config_header_id, l_config_revision_num);
2966:
2965: OPEN c_messages(l_config_header_id, l_config_revision_num);
2966:
2967: LOOP
2968:
2969: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2970: aso_debug_pub.add('Parse_output_xml: CZ message: c_messages%rowcount: '||c_messages%rowcount);
2971: END IF;
2972:
2973: FETCH c_messages into l_constraint,l_msg;
2966:
2967: LOOP
2968:
2969: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2970: aso_debug_pub.add('Parse_output_xml: CZ message: c_messages%rowcount: '||c_messages%rowcount);
2971: END IF;
2972:
2973: FETCH c_messages into l_constraint,l_msg;
2974: EXIT when c_messages%notfound;
2984: FND_MSG_PUB.ADD;
2985:
2986: End Loop;
2987:
2988: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2989: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 1, 100));
2990: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 101, 200));
2991: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 201, 300));
2992: END IF;
2985:
2986: End Loop;
2987:
2988: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2989: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 1, 100));
2990: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 101, 200));
2991: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 201, 300));
2992: END IF;
2993:
2986: End Loop;
2987:
2988: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2989: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 1, 100));
2990: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 101, 200));
2991: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 201, 300));
2992: END IF;
2993:
2994: END LOOP;
2987:
2988: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2989: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 1, 100));
2990: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 101, 200));
2991: aso_debug_pub.add('Parse_output_xml: '|| substr(l_msg, 201, 300));
2992: END IF;
2993:
2994: END LOOP;
2995:
3006: x_config_revision_num := l_config_revision_num;
3007: x_msg_count := l_msg_count;
3008: x_msg_data := l_msg_data;
3009:
3010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3011: aso_debug_pub.Add('End of parse_output_xml', 1, 'Y');
3012: END IF;
3013:
3014: EXCEPTION
3007: x_msg_count := l_msg_count;
3008: x_msg_data := l_msg_data;
3009:
3010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3011: aso_debug_pub.Add('End of parse_output_xml', 1, 'Y');
3012: END IF;
3013:
3014: EXCEPTION
3015:
3016: WHEN OTHERS THEN
3017:
3018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3019:
3020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3021: aso_Debug_Pub.Add( 'Parse_Output_xml: In WHEN OTHERS exception ', 1, 'N');
3022: END IF;
3023:
3024: END Parse_output_xml;
3017:
3018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3019:
3020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3021: aso_Debug_Pub.Add( 'Parse_Output_xml: In WHEN OTHERS exception ', 1, 'N');
3022: END IF;
3023:
3024: END Parse_output_xml;
3025:
3094: -- SAVEPOINT VALIDATE_CONFIGURATION_INT;
3095:
3096: l_return_status := FND_API.G_RET_STS_SUCCESS;
3097:
3098: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3099: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3100: END IF;
3101:
3102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3095:
3096: l_return_status := FND_API.G_RET_STS_SUCCESS;
3097:
3098: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3099: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3100: END IF;
3101:
3102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3103: p_api_version_number,
3114: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);
3115: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
3116:
3117: -- Call Create_hdr_xml to create the input header XML message
3118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3119: aso_debug_pub.add('Validate_Configuration: Before call to Create_hdr_xml.');
3120: END IF;
3121:
3122: Create_hdr_xml ( P_model_line_id => P_model_line_id,
3115: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
3116:
3117: -- Call Create_hdr_xml to create the input header XML message
3118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3119: aso_debug_pub.add('Validate_Configuration: Before call to Create_hdr_xml.');
3120: END IF;
3121:
3122: Create_hdr_xml ( P_model_line_id => P_model_line_id,
3123: X_xml_hdr => l_xml_hdr,
3122: Create_hdr_xml ( P_model_line_id => P_model_line_id,
3123: X_xml_hdr => l_xml_hdr,
3124: X_return_status => l_return_status );
3125:
3126: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3127:
3128: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml l_return_status: '||l_return_status);
3129: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml Length of l_xml_hdr : '||length(l_xml_hdr));
3130:
3124: X_return_status => l_return_status );
3125:
3126: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3127:
3128: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml l_return_status: '||l_return_status);
3129: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml Length of l_xml_hdr : '||length(l_xml_hdr));
3130:
3131: END IF;
3132:
3125:
3126: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3127:
3128: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml l_return_status: '||l_return_status);
3129: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml Length of l_xml_hdr : '||length(l_xml_hdr));
3130:
3131: END IF;
3132:
3133: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3133: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3134:
3135: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
3136:
3137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3138: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');
3139: END IF;
3140:
3141: Send_input_xml( P_Qte_Line_Tbl => P_Qte_Line_Tbl,
3134:
3135: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
3136:
3137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3138: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');
3139: END IF;
3140:
3141: Send_input_xml( P_Qte_Line_Tbl => P_Qte_Line_Tbl,
3142: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,
3146: X_msg_count => l_msg_count,
3147: X_msg_data => l_msg_data
3148: );
3149:
3150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3151: aso_debug_pub.add('Validate_Configuration: After call to Send_input_xml');
3152: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3153: END IF;
3154:
3147: X_msg_data => l_msg_data
3148: );
3149:
3150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3151: aso_debug_pub.add('Validate_Configuration: After call to Send_input_xml');
3152: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3153: END IF;
3154:
3155:
3148: );
3149:
3150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3151: aso_debug_pub.add('Validate_Configuration: After call to Send_input_xml');
3152: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3153: END IF;
3154:
3155:
3156:
3159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3160: l_delete_config := fnd_api.g_true;
3161: END IF;
3162:
3163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3164: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');
3165: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3166: END IF;
3167:
3160: l_delete_config := fnd_api.g_true;
3161: END IF;
3162:
3163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3164: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');
3165: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3166: END IF;
3167:
3168: Parse_output_xml
3161: END IF;
3162:
3163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3164: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');
3165: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3166: END IF;
3167:
3168: Parse_output_xml
3169: ( p_xml_msg => l_xml_message,
3175: x_msg_count => l_msg_count,
3176: x_msg_data => l_msg_data
3177: );
3178:
3179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3180: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');
3181: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3182: END IF;
3183:
3176: x_msg_data => l_msg_data
3177: );
3178:
3179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3180: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');
3181: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3182: END IF;
3183:
3184: END IF;
3177: );
3178:
3179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3180: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');
3181: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3182: END IF;
3183:
3184: END IF;
3185:
3193:
3194: l_qte_header_rec.quote_header_id := l_model_line_rec.quote_header_id;
3195:
3196:
3197: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3198: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');
3199: END IF;
3200:
3201: ASO_CFG_INT.Get_config_details(
3194: l_qte_header_rec.quote_header_id := l_model_line_rec.quote_header_id;
3195:
3196:
3197: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3198: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');
3199: END IF;
3200:
3201: ASO_CFG_INT.Get_config_details(
3202: p_api_version_number => 1.0,
3211: x_return_status => l_return_status,
3212: x_msg_count => l_msg_count,
3213: x_msg_data => l_msg_data );
3214:
3215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3216: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');
3217: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3218: END IF;
3219:
3212: x_msg_count => l_msg_count,
3213: x_msg_data => l_msg_data );
3214:
3215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3216: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');
3217: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3218: END IF;
3219:
3220: ELSE
3213: x_msg_data => l_msg_data );
3214:
3215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3216: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');
3217: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3218: END IF;
3219:
3220: ELSE
3221: l_delete_config := fnd_api.g_true;
3218: END IF;
3219:
3220: ELSE
3221: l_delete_config := fnd_api.g_true;
3222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3223: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3224: END IF;
3225:
3226: END IF;
3219:
3220: ELSE
3221: l_delete_config := fnd_api.g_true;
3222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3223: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3224: END IF;
3225:
3226: END IF;
3227:
3224: END IF;
3225:
3226: END IF;
3227:
3228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3229:
3230: aso_debug_pub.add('End of procedure Validate_Configuration');
3231: aso_debug_pub.add('l_return_status: '|| l_return_status);
3232: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
3226: END IF;
3227:
3228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3229:
3230: aso_debug_pub.add('End of procedure Validate_Configuration');
3231: aso_debug_pub.add('l_return_status: '|| l_return_status);
3232: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
3233: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
3234:
3227:
3228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3229:
3230: aso_debug_pub.add('End of procedure Validate_Configuration');
3231: aso_debug_pub.add('l_return_status: '|| l_return_status);
3232: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
3233: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
3234:
3235: END IF;
3228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3229:
3230: aso_debug_pub.add('End of procedure Validate_Configuration');
3231: aso_debug_pub.add('l_return_status: '|| l_return_status);
3232: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
3233: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
3234:
3235: END IF;
3236:
3229:
3230: aso_debug_pub.add('End of procedure Validate_Configuration');
3231: aso_debug_pub.add('l_return_status: '|| l_return_status);
3232: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
3233: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
3234:
3235: END IF;
3236:
3237: x_config_header_id := l_config_header_id;
3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248:
3249: end if;
3250:
3251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3252: aso_debug_pub.add('End of Validate_Configuration', 1, 'N');
3253: END IF;
3254:
3255: EXCEPTION
3248:
3249: end if;
3250:
3251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3252: aso_debug_pub.add('End of Validate_Configuration', 1, 'N');
3253: END IF;
3254:
3255: EXCEPTION
3256:
3255: EXCEPTION
3256:
3257: WHEN OTHERS THEN
3258:
3259: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3260: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
3261: END IF;
3262:
3263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3256:
3257: WHEN OTHERS THEN
3258:
3259: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3260: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
3261: END IF;
3262:
3263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3264: