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.11 2011/03/01 13:12:54 rassharm 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.11 2011/03/01 13:12:54 rassharm 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 224: aso_debug_pub.add('ASO_CFG_INT: Begin Copy_Configuration');

220: BEGIN
221: SAVEPOINT COPY_CONFIGURATION_INT;
222:
223: IF aso_debug_pub.g_debug_flag = 'Y' THEN
224: aso_debug_pub.add('ASO_CFG_INT: Begin Copy_Configuration');
225: END IF;
226:
227: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
228: p_api_version_number,

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

374:
375: WHEN OTHERS THEN
376:
377: IF aso_debug_pub.g_debug_flag = 'Y' THEN
378: aso_debug_pub.add('ASO_CFG_INT: copy_configuration: Inside when others exception');
379: END IF;
380:
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
382: P_PKG_NAME => G_PKG_NAME,

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

949: */
950:
951: IF aso_debug_pub.g_debug_flag = 'Y' THEN
952:
953: aso_debug_pub.add('6661597 ASO_CFG_INT: GET_CONFIG_DETAILS: Start %%%%%%%%%%%%%%%%%%%', 1, 'Y');
954:
955: aso_debug_pub.add('GET_CONFIG_DETAILS: p_qte_header_rec.quote_header_id: '|| p_qte_header_rec.quote_header_id);
956: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_hdr_id: '|| p_config_hdr_id);
957: aso_debug_pub.add('GET_CONFIG_DETAILS: p_config_rev_nbr: '|| p_config_rev_nbr);

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

991: -- check whether a different config_header_id is already
992: -- associated with this model item. If yes raise an error.
993:
994: IF aso_debug_pub.g_debug_flag = 'Y' THEN
995: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_diff_Config_Exists cursor open');
996: END IF;
997:
998: OPEN C_diff_Config_Exists;
999: FETCH C_diff_Config_Exists INTO l_old_config_hdr_id ;

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

999: FETCH C_diff_Config_Exists INTO l_old_config_hdr_id ;
1000: CLOSE C_diff_Config_Exists;
1001:
1002: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1003: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: l_old_config_hdr_id: '||l_old_config_hdr_id, 1, 'Y');
1004: END IF;
1005:
1006: IF l_old_config_hdr_id IS NOT NULL AND l_old_config_hdr_id <> p_config_hdr_id THEN
1007:

Line 1009: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside If l_old_config_hdr_id <> p_config_hdr_id cond', 1, 'Y');

1005:
1006: IF l_old_config_hdr_id IS NOT NULL AND l_old_config_hdr_id <> p_config_hdr_id THEN
1007:
1008: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1009: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside If l_old_config_hdr_id <> p_config_hdr_id cond', 1, 'Y');
1010: END IF;
1011:
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: FND_MESSAGE.Set_Name('ASO', 'ASO_DIFFERENT_CONFIG_EXISTS');

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

1020: -- check whether the config_header_id+config_revision_num is already
1021: -- associated with other model item. If yes raise an error.
1022:
1023: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1024: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Before C_config_exists cursor open');
1025: END IF;
1026:
1027: OPEN C_config_exists(l_config_hdr_id => p_config_hdr_id ,
1028: l_config_rev_nbr => p_config_rev_nbr);

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

1031:
1032: IF l_quote_line_id IS NOT NULL AND l_quote_line_id <> p_config_rec.quote_line_id THEN
1033:
1034: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1035: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Inside C_config_exists cursor l_quote_line_id: '||l_quote_line_id);
1036: END IF;
1037:
1038: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CONFIG_EXISTS');

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

1051:
1052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1053: 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'));
1054: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
1055: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
1056: END IF;
1057:
1058: 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
1059:

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

1070:
1071: end if;
1072:
1073: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1074: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After C_config_exists cursor');
1075: END IF;
1076:
1077: --check if revision number has changed for this configuration.
1078: --if yes update all the previous selected options to the current

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

1086: (p_config_rec.config_header_id <> p_config_hdr_id OR
1087: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN
1088: BEGIN
1089: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1090: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Revision number has changed so updating');
1091: END IF;
1092:
1093: UPDATE aso_quote_line_details
1094: SET config_revision_num = p_config_rev_nbr,

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

1110: END IF;
1111:
1112:
1113: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1114: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: After Update config_revision_num');
1115: END IF;
1116:
1117: OPEN Order_Type_C;
1118: 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 1123: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Cursor Order_Type_C NOTFOUND');

1119:
1120: IF Order_Type_C%NOTFOUND THEN
1121:
1122: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1123: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Cursor Order_Type_C NOTFOUND');
1124: END IF;
1125:
1126: END IF;
1127: CLOSE Order_Type_C;

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

1139:
1140: l_index := 0;
1141:
1142: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1143: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Before C_config_details_ins cursor LOOP');
1144: END IF;
1145:
1146: FOR row IN C_config_details_ins(p_config_hdr_id, p_config_rev_nbr)
1147: LOOP

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

1149: l_index := l_index + 1;
1150:
1151: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1152:
1153: aso_debug_pub.add('6661597 ASO_CFG_INT: Get_Config_details: Inside C_config_details_ins cursor LOOP');
1154: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1155: aso_debug_pub.add('Get_Config_Details: config_header_id: '|| row.config_hdr_id);
1156: aso_debug_pub.add('Get_Config_Details: config_revision_num: '|| row.config_rev_nbr);
1157: aso_debug_pub.add('Get_Config_Details: config_item_id: '|| row.config_item_id);

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

1352: END LOOP;
1353:
1354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1355:
1356: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: After C_config_details_ins cursor LOOP l_index: '|| l_index);
1357:
1358: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_upd cursor LOOP');
1359:
1360: END IF;

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

1354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1355:
1356: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: After C_config_details_ins cursor LOOP l_index: '|| l_index);
1357:
1358: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_upd cursor LOOP');
1359:
1360: END IF;
1361:
1362: FOR row IN C_config_details_upd( p_config_hdr_id,

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

1368: l_index := l_index + 1;
1369:
1370: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1371:
1372: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: Inside C_config_details_upd cursor LOOP');
1373: aso_debug_pub.add('Get_Config_Details: l_index: '|| l_index);
1374: aso_debug_pub.add('Get_Config_Details: quote_line_id: '|| row.quote_line_id);
1375: aso_debug_pub.add('Get_Config_Details: quote_line_detail_id: '|| row.quote_line_detail_id);
1376: aso_debug_pub.add('Get_Config_Details: inventory_item_id: '|| row.inventory_item_id);

Line 1461: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_del cursor LOOP');

1457:
1458: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1459:
1460: aso_debug_pub.add( 'Get_Config_details: After C_config_details_upd cursor LOOP l_index: '|| l_index);
1461: aso_debug_pub.add( 'ASO_CFG_INT: Get_Config_details: Before C_config_details_del cursor LOOP');
1462:
1463: END IF;
1464:
1465: FOR row IN C_config_details_del( p_config_hdr_id, p_config_rev_nbr )

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

1479: END LOOP;
1480:
1481: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1482:
1483: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1484:
1485: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1486: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1487: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);

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

1481: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1482:
1483: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: After C_config_details_del cursor LOOP l_index: '|| l_index);
1484:
1485: aso_debug_pub.add('ASO_CFG_INT: Get_Config_details: l_quote_type: '|| l_quote_type);
1486: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_TAX_FLAG: '|| p_control_rec.CALCULATE_TAX_FLAG);
1487: aso_debug_pub.add('Get_Config_details: p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG: '|| p_control_rec.CALCULATE_FREIGHT_CHARGE_FLAG);
1488: aso_debug_pub.add('Get_Config_details: p_control_rec.pricing_request_type: '|| p_control_rec.pricing_request_type);
1489: aso_debug_pub.add('Get_Config_details: p_control_rec.header_pricing_event: '|| p_control_rec.header_pricing_event);

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

1559: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1560: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1561: END IF;
1562:
1563: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1564: P_INIT_MSG_LIST => FND_API.G_FALSE,
1565: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1566: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1567: X_RETURN_STATUS => lx_return_status,

Line 1572: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);

1568: X_MSG_COUNT => x_msg_count,
1569: X_MSG_DATA => x_msg_data);
1570:
1571: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1572: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1573: END IF;
1574:
1575: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1576:

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

1612:
1613: G_rtln_tbl := G_MISS_rtln_tbl;
1614:
1615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1616: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to populate_rtln_Tbl');
1617: END IF;
1618:
1619: populate_rtln_Tbl( p_quote_header_id => p_qte_header_rec.quote_header_id,
1620: p_quote_line_id => p_config_rec.quote_line_id,

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

1623:
1624:
1625: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1626:
1627: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: After call to populate_rtln_Tbl');
1628:
1629: FOR p IN G_rtln_tbl.first..G_rtln_tbl.last LOOP
1630:
1631: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').quote_line_id: '|| G_rtln_tbl(p).quote_line_id);

Line 1643: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to Create_Relationship procedure');

1639: aso_debug_pub.add( 'Get_config_details: G_rtln_tbl('||p||').created_flag: '|| G_rtln_tbl(p).created_flag);
1640:
1641: END LOOP;
1642:
1643: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: Before call to Create_Relationship procedure');
1644:
1645: END IF;
1646:
1647: Create_Relationship( parent_quote_line_id => G_rtln_tbl(1).quote_line_id,

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

1684: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1685: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1686: END IF;
1687:
1688: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1689: P_INIT_MSG_LIST => FND_API.G_FALSE,
1690: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1691: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1692: X_RETURN_STATUS => lx_return_status,

Line 1697: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);

1693: X_MSG_COUNT => x_msg_count,
1694: X_MSG_DATA => x_msg_data);
1695:
1696: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1697: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1698: END IF;
1699:
1700: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1701:

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

1716:
1717: END IF;
1718:
1719: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1720: aso_debug_pub.add( 'ASO_CFG_INT: GET_CONFIG_DETAILS: Finish %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
1721: END IF;
1722:
1723: EXCEPTION
1724:

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

1734: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1735: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1736: END IF;
1737:
1738: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1739: P_INIT_MSG_LIST => FND_API.G_FALSE,
1740: P_CONFIG_HDR_ID => p_config_hdr_id,
1741: P_CONFIG_REV_NBR => p_config_rev_nbr,
1742: X_RETURN_STATUS => lx_return_status,

Line 1747: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);

1743: X_MSG_COUNT => x_msg_count,
1744: X_MSG_DATA => x_msg_data);
1745:
1746: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1747: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1748: END IF;
1749:
1750: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1751:

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

1785: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1786: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1787: END IF;
1788:
1789: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1790: P_INIT_MSG_LIST => FND_API.G_FALSE,
1791: P_CONFIG_HDR_ID => p_config_hdr_id,
1792: P_CONFIG_REV_NBR => p_config_rev_nbr,
1793: X_RETURN_STATUS => lx_return_status,

Line 1798: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);

1794: X_MSG_COUNT => x_msg_count,
1795: X_MSG_DATA => x_msg_data);
1796:
1797: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1798: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1799: END IF;
1800:
1801: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1802:

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

1836: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1837: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1838: END IF;
1839:
1840: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1841: P_INIT_MSG_LIST => FND_API.G_FALSE,
1842: P_CONFIG_HDR_ID => p_config_hdr_id,
1843: P_CONFIG_REV_NBR => p_config_rev_nbr,
1844: X_RETURN_STATUS => lx_return_status,

Line 1849: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);

1845: X_MSG_COUNT => x_msg_count,
1846: X_MSG_DATA => x_msg_data);
1847:
1848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1849: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1850: END IF;
1851:
1852: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1853:

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

2005: */
2006:
2007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2008:
2009: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
2010: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
2011: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
2012:
2013: END IF;

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

2006:
2007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2008:
2009: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
2010: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
2011: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
2012:
2013: END IF;
2014:

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

2007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2008:
2009: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Start %%%%%%%%%%%%%%%%%%%%' , 1, 'Y' );
2010: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_config_session_key: '|| p_config_session_key);
2011: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: p_price_type: '|| p_price_type);
2012:
2013: END IF;
2014:
2015: -- Store the derived model item quote_line_id from the p_config_session_key for subsequent use

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

2051:
2052: ELSE
2053:
2054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2055: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: c_quote_hdr_id NOT FOUND.');
2056: END IF;
2057:
2058: END IF;
2059:

Line 2070: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_config_header_id: ' || l_config_header_id);

2066: FETCH c_config_header_id into l_config_header_id;
2067: CLOSE c_config_header_id;
2068:
2069: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2070: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_config_header_id: ' || l_config_header_id);
2071: END IF;
2072:
2073: IF p_price_type = cz_prc_callback_util.g_prc_type_list THEN
2074:

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

2192: -- Get the config_item_id of the root model
2193: l_root_model_config_item_id := cz_prc_callback_util.root_bom_config_item_id(p_config_session_key);
2194:
2195: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2196: aso_debug_pub.add( 'ASO_CFG_INT: PRICING CALLBACK: l_root_model_config_item_id: ' || l_root_model_config_item_id);
2197: END IF;
2198:
2199: record_count1 := l_qte_line_tbl.count;
2200: l_count := l_qte_line_tbl.count;

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

2199: record_count1 := l_qte_line_tbl.count;
2200: l_count := l_qte_line_tbl.count;
2201:
2202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2203: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_count: ' || l_count);
2204: END IF;
2205:
2206: FOR row IN C_options LOOP
2207:

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

2392: aso_debug_pub.add('l_pricing_control_rec.pricing_event: '||l_pricing_control_rec.pricing_event);
2393: aso_debug_pub.add('l_pricing_control_rec.price_mode: '||l_pricing_control_rec.price_mode);
2394: aso_debug_pub.add('l_pricing_control_rec.price_config_flag: '||l_pricing_control_rec.price_config_flag);
2395:
2396: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Before call to ASO_PRICING_INT.Pricing_Order');
2397:
2398: END IF;
2399:
2400: ASO_PRICING_INT.Pricing_Order(

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

2461:
2462: END IF;
2463:
2464: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2465: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: l_mymsg: ' || l_mymsg);
2466: END IF;
2467:
2468: -- set the error message in the model line msg_data field of cz_pricing_structure
2469:

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

2522:
2523: WHEN OTHERS THEN
2524:
2525: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2526: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception for select sum(selling_price)');
2527: END IF;
2528:
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530:

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

2547: END IF;
2548:
2549:
2550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2551: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK End %%%%%%%%%%%%%%%%%%%%', 1, 'Y' );
2552: END IF;
2553:
2554:
2555: EXCEPTION

Line 2560: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception');

2556:
2557: WHEN OTHERS THEN
2558:
2559: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2560: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception');
2561: END IF;
2562:
2563: -- set the error message in the model line msg_data field of cz_pricing_structure
2564: UPDATE CZ_PRICING_STRUCTURES

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

2604:
2605: BEGIN
2606:
2607: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2608: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: P_Qte_Header_Id: '|| P_Qte_Header_Id);
2609: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: p_qte_line_id : '|| p_qte_line_id );
2610: END IF;
2611:
2612: FOR line_rec IN c_Qte_Line LOOP

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

2605: BEGIN
2606:
2607: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2608: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: P_Qte_Header_Id: '|| P_Qte_Header_Id);
2609: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: p_qte_line_id : '|| p_qte_line_id );
2610: END IF;
2611:
2612: FOR line_rec IN c_Qte_Line LOOP
2613:

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

2635:
2636: END LOOP;
2637:
2638: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2639: aso_debug_pub.add('ASO_CFG_INT: Query_Qte_Line_Rows: l_Qte_Line_tbl.count: '|| l_Qte_Line_tbl.count);
2640: END IF;
2641:
2642: RETURN l_Qte_Line_tbl;
2643:

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

2987: i NUMBER;
2988: l_return_status VARCHAR2(1);
2989: BEGIN
2990: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2991: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml Begin.', 1, 'Y');
2992: END IF;
2993:
2994: --Initialize API return status to SUCCESS
2995: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

2996:
2997: l_xml_hdr := p_xml_hdr;
2998:
2999: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3000: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: Before the quote line Loop.', 1, 'Y');
3001: END IF;
3002:
3003: FOR i IN 1..P_Qte_Line_Tbl.COUNT LOOP
3004:

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

3025:
3026: END LOOP;
3027:
3028: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3029: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml: After the quote line Loop.', 1, 'Y');
3030: END IF;
3031:
3032: -- delete previous data.
3033: IF (l_html_pieces.COUNT <> 0) THEN

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

3171: l_msg_data VARCHAR2(2000);
3172:
3173: BEGIN
3174: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3175: aso_debug_pub.add('ASO_CFG_INT: Parse_output_xml Begin.', 1, 'Y');
3176: END IF;
3177:
3178: --Initialize API return status to SUCCESS
3179: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

3390:
3391: l_return_status := FND_API.G_RET_STS_SUCCESS;
3392:
3393: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3394: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3395: END IF;
3396:
3397: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3398: p_api_version_number,

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

3429:
3430: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
3431:
3432: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3433: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');
3434: END IF;
3435:
3436: Send_input_xml( P_Qte_Line_Tbl => P_Qte_Line_Tbl,
3437: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,

Line 3495: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');

3491: l_qte_header_rec.quote_header_id := l_model_line_rec.quote_header_id;
3492:
3493:
3494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3495: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');
3496: END IF;
3497:
3498: ASO_CFG_INT.Get_config_details(
3499: p_api_version_number => 1.0,

Line 3498: ASO_CFG_INT.Get_config_details(

3494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3495: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');
3496: END IF;
3497:
3498: ASO_CFG_INT.Get_config_details(
3499: p_api_version_number => 1.0,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_commit => FND_API.G_FALSE,
3502: p_control_rec => p_control_rec,

Line 3566: End aso_cfg_int;

3562:
3563: END Validate_Configuration;
3564:
3565:
3566: End aso_cfg_int;