eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_CFG_INT dependencies on ASO_CFG_INT

Line 1: PACKAGE BODY aso_cfg_int as

1: PACKAGE BODY aso_cfg_int as
2: /* $Header: asoicfgb.pls 120.7 2005/11/04 11:54:48 skulkarn ship $ */
3: -- Start of Comments
4: -- Package name : aso_cfg_int
5: -- Purpose :

Line 4: -- Package name : aso_cfg_int

1: PACKAGE BODY aso_cfg_int as
2: /* $Header: asoicfgb.pls 120.7 2005/11/04 11:54:48 skulkarn ship $ */
3: -- Start of Comments
4: -- Package name : aso_cfg_int
5: -- Purpose :
6: -- History :
7: -- NOTE : 8/21/04 skulkarn: added the MACD changes into the get_config_details API
8: -- 9/16/04 bmishra: Made changes in pricing_callback and query_qte_line_rows. Fix for bug#3850782

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_CFG_INT';

11: -- 12/06/04 skulkarn: fixed bug3938943
12: -- End of Comments
13: --private variable declaration
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_CFG_INT';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoicfgb.pls';
17:
18: Procedure Populate_output_table(
19: p_oe_line_tbl IN OE_ORDER_PUB.line_tbl_type ,

Line 222: aso_debug_pub.add('ASO_CFG_INT: Begin Copy_Configuration');

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,

Line 372: aso_debug_pub.add('ASO_CFG_INT: copy_configuration: Inside when others exception');

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,

Line 850: aso_debug_pub.add('ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');

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);

Line 892: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_diff_Config_Exists cursor open');

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 ;

Line 900: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: l_old_config_hdr_id: '||l_old_config_hdr_id, 1, 'Y');

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:

Line 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');

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');

Line 921: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_config_exists cursor open');

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);

Line 932: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside C_config_exists cursor l_quote_line_id: '||l_quote_line_id);

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');

Line 952: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);

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:

Line 971: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After C_config_exists cursor');

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

Line 987: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Revision number has changed so updating');

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,

Line 1011: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After Update config_revision_num');

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;

Line 1020: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Cursor Order_Type_C NOTFOUND');

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;

Line 1040: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Before C_config_details_ins cursor LOOP');

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

Line 1050: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');

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);

Line 1222: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: After C_config_details_ins cursor LOOP l_index: '|| l_index);

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;

Line 1224: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_upd cursor LOOP');

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,

Line 1238: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');

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);

Line 1288: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_del cursor 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:
1292: FOR row IN C_config_details_del( p_config_hdr_id, p_config_rev_nbr )

Line 1310: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);

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);

Line 1312: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);

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);

Line 1390: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,

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,
1392: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1393: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1394: X_RETURN_STATUS => lx_return_status,

Line 1399: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: 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
1403:

Line 1443: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to populate_rtln_Tbl');

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,

Line 1454: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: After call to populate_rtln_Tbl');

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);

Line 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,

Line 1515: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,

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,
1517: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1518: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1519: X_RETURN_STATUS => lx_return_status,

Line 1524: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: 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
1528:

Line 1547: aso_debug_pub.add( 'ASO_CFG_INT: GET_CONFIG_DETAILS: Finish %%%%%%%%%%%%%%%%%%%', 1, 'Y' );

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:

Line 1565: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,

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,
1567: P_CONFIG_HDR_ID => p_config_hdr_id,
1568: P_CONFIG_REV_NBR => p_config_rev_nbr,
1569: X_RETURN_STATUS => lx_return_status,

Line 1574: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: 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
1578:

Line 1616: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,

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,
1618: P_CONFIG_HDR_ID => p_config_hdr_id,
1619: P_CONFIG_REV_NBR => p_config_rev_nbr,
1620: X_RETURN_STATUS => lx_return_status,

Line 1625: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: 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
1629:

Line 1667: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,

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,
1669: P_CONFIG_HDR_ID => p_config_hdr_id,
1670: P_CONFIG_REV_NBR => p_config_rev_nbr,
1671: X_RETURN_STATUS => lx_return_status,

Line 1676: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: 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
1680:

Line 1823: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );

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;

Line 1824: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);

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:

Line 1825: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);

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

Line 1869: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: c_quote_hdr_id NOT FOUND.');

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:

Line 1884: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_config_header_id: ' || l_config_header_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
1888:

Line 1977: aso_debug_pub.add( 'ASO_CFG_INT: PRICING CALLBACK: l_root_model_config_item_id: ' || l_root_model_config_item_id);

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;

Line 1984: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_count: ' || l_count);

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:

Line 2141: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Before call to ASO_PRICING_INT.Pricing_Order');

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(

Line 2210: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_mymsg: ' || l_mymsg);

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:

Line 2271: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception for select sum(selling_price)');

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:

Line 2296: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );

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

Line 2305: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others 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
2309: UPDATE CZ_PRICING_STRUCTURES

Line 2353: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: P_Qte_Header_Id: '|| P_Qte_Header_Id);

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

Line 2354: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: p_qte_line_id : '|| p_qte_line_id );

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:

Line 2384: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: l_Qte_Line_tbl.count: '|| l_Qte_Line_tbl.count);

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:

Line 2699: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml Begin.', 1, 'Y');

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;

Line 2708: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: Before the quote line Loop.', 1, 'Y');

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:

Line 2737: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: After the quote line Loop.', 1, 'Y');

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

Line 2880: aso_debug_pub.add('ASO_CFG_INT: Parse_output_xml Begin.', 1, 'Y');

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;

Line 3099: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');

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,

Line 3138: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');

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,

Line 3198: aso_debug_pub.add('Validate_Configuration: Before Call to 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,

Line 3201: ASO_CFG_INT.Get_config_details(

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,
3203: p_init_msg_list => FND_API.G_FALSE,
3204: p_commit => FND_API.G_FALSE,
3205: p_control_rec => p_control_rec,

Line 3268: End aso_cfg_int;

3264:
3265: END Validate_Configuration;
3266:
3267:
3268: End aso_cfg_int;