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_QUOTE_PUB dependencies on ASO_DEBUG_PUB

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

29: IS
30: l_party_rec ASO_PARTY_INT.Party_Rec_Type;
31: BEGIN
32:
33: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
34:
35: x_party_id := p_party_id;
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (p_party_id IS NOT NULL

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

83: l_msg_count NUMBER;
84:
85: BEGIN
86:
87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
88:
89: x_party_site_id := p_party_site_id;
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: IF (p_party_site_id IS NOT NULL

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

130: l_any_errors BOOLEAN := FALSE;
131: l_return_status VARCHAR2(1);
132: BEGIN
133:
134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
135:
136: x_qte_header_rec := p_qte_header_rec;
137: -- party_id
138: Convert_Party_To_Id (

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

205: l_any_errors BOOLEAN := FALSE;
206: l_return_status VARCHAR2(1);
207: BEGIN
208:
209: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
210:
211: x_shipment_rec := p_shipment_rec;
212: -- ship_to_party_id
213: Convert_Party_To_Id (

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

260: x_QTE_Line_rec OUT NOCOPY /* file.sql.39 change */ QTE_Line_Rec_Type
261: )
262: IS
263: BEGIN
264: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
265: x_qte_line_rec := p_qte_line_rec;
266: null;
267: END;
268:

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

319: x_ln_Sales_Credit_Tbl Sales_Credit_Tbl_Type ;
320: x_ln_Quote_Party_Tbl Quote_Party_Tbl_Type;
321:
322: BEGIN
323: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
324:
325: Create_quote(
326: P_Api_Version_Number => 1.0,
327: P_Init_Msg_List => p_init_msg_list,

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

428: x_ln_Sales_Credit_Tbl Sales_Credit_Tbl_Type ;
429: x_ln_Quote_Party_Tbl Quote_Party_Tbl_Type;
430:
431: BEGIN
432: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
433:
434: Update_quote(
435: P_Api_Version_Number => 1.0,
436: P_Init_Msg_List => p_init_msg_list,

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

504: BEGIN
505: -- Standard Start of API savepoint
506: SAVEPOINT DELETE_QUOTE_PUB;
507:
508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
509:
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
512: p_api_version_number,

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

724: BEGIN
725: -- Standard Start of API savepoint
726: SAVEPOINT GET_QUOTE_PUB;
727:
728: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
729:
730: -- Standard call to check for call compatibility.
731: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
732: p_api_version_number,

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

837: BEGIN
838: -- Standard Start of API savepoint
839: SAVEPOINT validate_QUOTE_PUB;
840:
841: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
845: p_api_version_number,

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

946: BEGIN
947: -- Standard Start of API savepoint
948: SAVEPOINT SUBMIT_QUOTE_PUB;
949:
950: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
951:
952: -- Standard call to check for call compatibility.
953: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
954: p_api_version_number,

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

1160: BEGIN
1161: -- Standard Start of API savepoint
1162: SAVEPOINT COPY_QUOTE_PUB;
1163:
1164: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: p_api_version_number,

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

1411: l_Qte_Number NUMBER;
1412: l_NEW_Qte_Header_Id NUMBER;
1413: BEGIN
1414:
1415: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1416:
1417: ASO_QUOTE_HEADERS_PVT.Copy_Quote(
1418: P_Api_Version_Number => 1.0,
1419: P_Init_Msg_List => FND_API.G_FALSE,

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

1507: X_Sales_Credit_Tbl Sales_Credit_Tbl_Type;
1508: X_Quote_Party_Tbl Quote_Party_Tbl_Type;
1509: BEGIN
1510:
1511: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1512:
1513: Create_Quote_Line(
1514: P_Api_Version_Number => p_api_version_number,
1515: P_Init_Msg_List => p_init_msg_list,

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

1622: X_Sales_Credit_Tbl Sales_Credit_Tbl_Type;
1623: X_Quote_Party_Tbl Quote_Party_Tbl_Type;
1624: BEGIN
1625:
1626: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1627:
1628: Update_Quote_Line(
1629: P_Api_Version_Number => 1.0,
1630: P_Init_Msg_List => p_init_msg_list,

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

1702: )
1703: IS
1704:
1705: BEGIN
1706: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1707: Delete_Quote_Line(
1708: P_Api_Version_Number => 1.0,
1709: P_Init_Msg_List => P_Init_Msg_List ,
1710: P_Commit => p_commit,

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

1797: x_Qte_Access_Tbl Qte_Access_Tbl_Type;
1798: x_Template_Tbl Template_Tbl_Type;
1799: X_Related_Obj_Tbl Related_Obj_Tbl_Type;
1800: BEGIN
1801: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1802:
1803: if aso_debug_pub.g_debug_flag = 'Y' then
1804: aso_debug_pub.add('Before call to the second overloaded create_quote procedure.',1, 'Y');
1805: end if;

Line 1803: if aso_debug_pub.g_debug_flag = 'Y' then

1799: X_Related_Obj_Tbl Related_Obj_Tbl_Type;
1800: BEGIN
1801: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1802:
1803: if aso_debug_pub.g_debug_flag = 'Y' then
1804: aso_debug_pub.add('Before call to the second overloaded create_quote procedure.',1, 'Y');
1805: end if;
1806:
1807: Create_quote(

Line 1804: aso_debug_pub.add('Before call to the second overloaded create_quote procedure.',1, 'Y');

1800: BEGIN
1801: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1802:
1803: if aso_debug_pub.g_debug_flag = 'Y' then
1804: aso_debug_pub.add('Before call to the second overloaded create_quote procedure.',1, 'Y');
1805: end if;
1806:
1807: Create_quote(
1808: P_Api_Version_Number => 1.0,

Line 1860: if aso_debug_pub.g_debug_flag = 'Y' then

1856: X_Return_Status => x_return_status,
1857: X_Msg_Count => x_msg_count,
1858: X_Msg_Data => x_msg_data);
1859:
1860: if aso_debug_pub.g_debug_flag = 'Y' then
1861: aso_debug_pub.add('After call to the second overloaded create_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');
1862: end if;
1863:
1864: END Create_Quote;

Line 1861: aso_debug_pub.add('After call to the second overloaded create_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');

1857: X_Msg_Count => x_msg_count,
1858: X_Msg_Data => x_msg_data);
1859:
1860: if aso_debug_pub.g_debug_flag = 'Y' then
1861: aso_debug_pub.add('After call to the second overloaded create_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');
1862: end if;
1863:
1864: END Create_Quote;
1865:

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

1936: x_Qte_Access_Tbl Qte_Access_Tbl_Type;
1937: x_Template_Tbl Template_Tbl_Type;
1938: X_Related_Obj_Tbl Related_Obj_Tbl_Type;
1939: BEGIN
1940: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1941:
1942: if aso_debug_pub.g_debug_flag = 'Y' then
1943: aso_debug_pub.add('Before call to the second overloaded update_quote procedure.',1, 'Y');
1944: end if;

Line 1942: if aso_debug_pub.g_debug_flag = 'Y' then

1938: X_Related_Obj_Tbl Related_Obj_Tbl_Type;
1939: BEGIN
1940: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1941:
1942: if aso_debug_pub.g_debug_flag = 'Y' then
1943: aso_debug_pub.add('Before call to the second overloaded update_quote procedure.',1, 'Y');
1944: end if;
1945:
1946: Update_quote(

Line 1943: aso_debug_pub.add('Before call to the second overloaded update_quote procedure.',1, 'Y');

1939: BEGIN
1940: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1941:
1942: if aso_debug_pub.g_debug_flag = 'Y' then
1943: aso_debug_pub.add('Before call to the second overloaded update_quote procedure.',1, 'Y');
1944: end if;
1945:
1946: Update_quote(
1947: P_Api_Version_Number => 1.0,

Line 2001: if aso_debug_pub.g_debug_flag = 'Y' then

1997: X_Return_Status => x_return_status,
1998: X_Msg_Count => x_msg_count,
1999: X_Msg_Data => x_msg_data);
2000:
2001: if aso_debug_pub.g_debug_flag = 'Y' then
2002: aso_debug_pub.add('After call to the second overloaded update_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');
2003: end if;
2004:
2005: End Update_quote;

Line 2002: aso_debug_pub.add('After call to the second overloaded update_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');

1998: X_Msg_Count => x_msg_count,
1999: X_Msg_Data => x_msg_data);
2000:
2001: if aso_debug_pub.g_debug_flag = 'Y' then
2002: aso_debug_pub.add('After call to the second overloaded update_quote procedure: x_return_status: '|| x_return_status, 1, 'Y');
2003: end if;
2004:
2005: End Update_quote;
2006:

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

2032: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2033: )
2034: IS
2035: BEGIN
2036: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2037: Submit_quote(
2038: P_Api_Version_Number => P_Api_Version_Number,
2039: P_Init_Msg_List => P_Init_Msg_List ,
2040: P_control_rec => P_control_rec,

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

2134:
2135: -- Standard Start of API savepoint
2136: SAVEPOINT CREATE_QUOTE_LINE_PUB;
2137:
2138: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2139:
2140: -- Standard call to check for call compatibility.
2141: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2142: p_api_version_number,

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

2370: END IF;
2371: END IF;
2372: END IF; -- customer hook
2373:
2374: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2375: aso_debug_pub.add('aso_quote_vuhk: before if create quote line post (1) '||x_return_status,1, 'N');
2376: END IF;
2377:
2378: -- vertical hook

Line 2375: aso_debug_pub.add('aso_quote_vuhk: before if create quote line post (1) '||x_return_status,1, 'N');

2371: END IF;
2372: END IF; -- customer hook
2373:
2374: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2375: aso_debug_pub.add('aso_quote_vuhk: before if create quote line post (1) '||x_return_status,1, 'N');
2376: END IF;
2377:
2378: -- vertical hook
2379: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

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

2376: END IF;
2377:
2378: -- vertical hook
2379: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
2380: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2381: aso_debug_pub.add('aso_quote_vuhk: inside if create quote line post (1)'||x_return_status,1, 'N');
2382: END IF;
2383: ASO_QUOTE_VUHK.Create_Quote_Line_POST(
2384: P_Qte_Line_Rec => x_qte_line_rec ,

Line 2381: aso_debug_pub.add('aso_quote_vuhk: inside if create quote line post (1)'||x_return_status,1, 'N');

2377:
2378: -- vertical hook
2379: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
2380: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2381: aso_debug_pub.add('aso_quote_vuhk: inside if create quote line post (1)'||x_return_status,1, 'N');
2382: END IF;
2383: ASO_QUOTE_VUHK.Create_Quote_Line_POST(
2384: P_Qte_Line_Rec => x_qte_line_rec ,
2385: P_Control_Rec => l_control_rec ,

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

2399: X_Msg_Count => x_msg_count ,
2400: X_Msg_Data => x_msg_data
2401: );
2402:
2403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2404: aso_debug_pub.add('aso_quote_vuhk: after if create quote line post (1)'||x_return_status,1, 'N');
2405: END IF;
2406:
2407:

Line 2404: aso_debug_pub.add('aso_quote_vuhk: after if create quote line post (1)'||x_return_status,1, 'N');

2400: X_Msg_Data => x_msg_data
2401: );
2402:
2403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2404: aso_debug_pub.add('aso_quote_vuhk: after if create quote line post (1)'||x_return_status,1, 'N');
2405: END IF;
2406:
2407:
2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2554: BEGIN
2555: -- Standard Start of API savepoint
2556: SAVEPOINT UPDATE_QUOTE_LINE_PUB;
2557:
2558: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2559:
2560: -- Standard call to check for call compatibility.
2561: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2562: p_api_version_number,

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

2792: END IF;
2793: END IF;
2794: END IF; -- customer hook
2795:
2796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2797: aso_debug_pub.add('aso_quote_vuhk: before if update quote line post (1)'||x_return_status,1, 'N');
2798: END IF;
2799:
2800: -- vertical hook

Line 2797: aso_debug_pub.add('aso_quote_vuhk: before if update quote line post (1)'||x_return_status,1, 'N');

2793: END IF;
2794: END IF; -- customer hook
2795:
2796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2797: aso_debug_pub.add('aso_quote_vuhk: before if update quote line post (1)'||x_return_status,1, 'N');
2798: END IF;
2799:
2800: -- vertical hook
2801: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

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

2798: END IF;
2799:
2800: -- vertical hook
2801: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
2802: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2803: aso_debug_pub.add('aso_quote_vuhk: inside if update quote line post (1)'||x_return_status,1, 'N');
2804: END IF;
2805: ASO_QUOTE_VUHK.Update_Quote_Line_POST(
2806: P_Qte_Line_Rec => x_qte_line_rec ,

Line 2803: aso_debug_pub.add('aso_quote_vuhk: inside if update quote line post (1)'||x_return_status,1, 'N');

2799:
2800: -- vertical hook
2801: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
2802: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2803: aso_debug_pub.add('aso_quote_vuhk: inside if update quote line post (1)'||x_return_status,1, 'N');
2804: END IF;
2805: ASO_QUOTE_VUHK.Update_Quote_Line_POST(
2806: P_Qte_Line_Rec => x_qte_line_rec ,
2807: P_Control_Rec => l_control_rec ,

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

2821: X_Msg_Count => x_msg_count ,
2822: X_Msg_Data => x_msg_data
2823: );
2824:
2825: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2826: aso_debug_pub.add('aso_quote_vuhk: after if update quote line post (1)'||x_return_status,1, 'N');
2827: END IF;
2828:
2829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2826: aso_debug_pub.add('aso_quote_vuhk: after if update quote line post (1)'||x_return_status,1, 'N');

2822: X_Msg_Data => x_msg_data
2823: );
2824:
2825: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2826: aso_debug_pub.add('aso_quote_vuhk: after if update quote line post (1)'||x_return_status,1, 'N');
2827: END IF;
2828:
2829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2830: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

2919: BEGIN
2920: -- Standard Start of API savepoint
2921: SAVEPOINT DELETE_QUOTE_LINE_PUB;
2922:
2923: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2924:
2925: -- Standard call to check for call compatibility.
2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2927: p_api_version_number,

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

3056: END IF;
3057: END IF;
3058: END IF; -- customer hook
3059:
3060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3061: aso_debug_pub.add('aso_quote_vuhk: before if delete quote line post (1)'||x_return_status,1, 'N');
3062: END IF;
3063:
3064: -- vertical hook

Line 3061: aso_debug_pub.add('aso_quote_vuhk: before if delete quote line post (1)'||x_return_status,1, 'N');

3057: END IF;
3058: END IF; -- customer hook
3059:
3060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3061: aso_debug_pub.add('aso_quote_vuhk: before if delete quote line post (1)'||x_return_status,1, 'N');
3062: END IF;
3063:
3064: -- vertical hook
3065: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

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

3062: END IF;
3063:
3064: -- vertical hook
3065: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
3066: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3067: aso_debug_pub.add('aso_quote_vuhk: inside if delete quote line post (1)'||x_return_status,1, 'N');
3068: END IF;
3069: ASO_QUOTE_VUHK.Delete_Quote_Line_POST(
3070: P_qte_line_Rec => l_qte_line_rec,

Line 3067: aso_debug_pub.add('aso_quote_vuhk: inside if delete quote line post (1)'||x_return_status,1, 'N');

3063:
3064: -- vertical hook
3065: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
3066: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3067: aso_debug_pub.add('aso_quote_vuhk: inside if delete quote line post (1)'||x_return_status,1, 'N');
3068: END IF;
3069: ASO_QUOTE_VUHK.Delete_Quote_Line_POST(
3070: P_qte_line_Rec => l_qte_line_rec,
3071: P_Control_Rec => l_control_rec,

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

3072: X_Return_Status => x_return_status,
3073: X_Msg_Count => x_msg_count ,
3074: X_Msg_Data => x_msg_data
3075: );
3076: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3077: aso_debug_pub.add('aso_quote_vuhk: after if delete quote line post (1)'||x_return_status,1, 'N');
3078: END IF;
3079:
3080:

Line 3077: aso_debug_pub.add('aso_quote_vuhk: after if delete quote line post (1)'||x_return_status,1, 'N');

3073: X_Msg_Count => x_msg_count ,
3074: X_Msg_Data => x_msg_data
3075: );
3076: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3077: aso_debug_pub.add('aso_quote_vuhk: after if delete quote line post (1)'||x_return_status,1, 'N');
3078: END IF;
3079:
3080:
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

3164: IS
3165:
3166: BEGIN
3167:
3168: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3169: ASO_QUOTE_HEADERS_PVT.Quote_Security_Check(
3170: P_Api_Version_Number => P_Api_Version_Number,
3171: P_Init_Msg_List => P_Init_Msg_List,
3172: P_User_Id => P_User_Id,

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

3176: X_Msg_Count => X_Msg_Count,
3177: X_Msg_Data => X_Msg_Data
3178: );
3179:
3180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');
3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
3183: END IF;
3184:

Line 3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');

3177: X_Msg_Data => X_Msg_Data
3178: );
3179:
3180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');
3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
3183: END IF;
3184:
3185: End Quote_Security_Check;

Line 3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');

3178: );
3179:
3180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');
3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
3183: END IF;
3184:
3185: End Quote_Security_Check;
3186:

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

3217:
3218: -- Standard Start of API savepoint
3219: SAVEPOINT SUBMIT_QUOTE_PUB;
3220:
3221: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3222:
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3225: p_api_version_number,

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

3426: l_api_version_number CONSTANT NUMBER := 1.0;
3427:
3428: BEGIN
3429:
3430: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3431:
3432: -- Standard Start of API savepoint
3433: SAVEPOINT ALLOCATE_SALES_CREDITS_PUB;
3434:

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

3518: X_Msg_Count => x_msg_count,
3519: X_Msg_Data => x_msg_data
3520: );
3521:
3522: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3523: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.Assign_Sales_Team: '||x_return_status,1,'Y');
3524: END IF;
3525:
3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3523: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.Assign_Sales_Team: '||x_return_status,1,'Y');

3519: X_Msg_Data => x_msg_data
3520: );
3521:
3522: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3523: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.Assign_Sales_Team: '||x_return_status,1,'Y');
3524: END IF;
3525:
3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3527: RAISE FND_API.G_EXC_ERROR;

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

3872: BEGIN
3873: -- Standard Start of API savepoint
3874: SAVEPOINT CREATE_QUOTE_PUB;
3875:
3876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3877:
3878: -- Standard call to check for call compatibility.
3879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3880: p_api_version_number,

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

4133: X_Return_Status => x_return_status,
4134: X_Msg_Count => x_msg_count,
4135: X_Msg_Data => x_msg_data);
4136:
4137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4138: aso_debug_pub.add('create_quote_pub: after create quote, starting user hooks (1)'||x_return_status,1, 'N');
4139: END IF;
4140:
4141: -- Check return status from the above procedure call

Line 4138: aso_debug_pub.add('create_quote_pub: after create quote, starting user hooks (1)'||x_return_status,1, 'N');

4134: X_Msg_Count => x_msg_count,
4135: X_Msg_Data => x_msg_data);
4136:
4137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4138: aso_debug_pub.add('create_quote_pub: after create quote, starting user hooks (1)'||x_return_status,1, 'N');
4139: END IF;
4140:
4141: -- Check return status from the above procedure call
4142: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

4207:
4208: END IF; -- customer hook
4209:
4210:
4211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4212: aso_debug_pub.add('aso_quote_vuhk: before if create quote post (1)'||x_return_status,1, 'N');
4213: END IF;
4214:
4215: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

Line 4212: aso_debug_pub.add('aso_quote_vuhk: before if create quote post (1)'||x_return_status,1, 'N');

4208: END IF; -- customer hook
4209:
4210:
4211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4212: aso_debug_pub.add('aso_quote_vuhk: before if create quote post (1)'||x_return_status,1, 'N');
4213: END IF;
4214:
4215: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
4216:

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

4213: END IF;
4214:
4215: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
4216:
4217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4218: aso_debug_pub.add('aso_quote_vuhk: inside if create quote post (1)'||x_return_status,1, 'N');
4219: END IF;
4220:
4221: ASO_QUOTE_VUHK.Create_quote_POST(

Line 4218: aso_debug_pub.add('aso_quote_vuhk: inside if create quote post (1)'||x_return_status,1, 'N');

4214:
4215: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
4216:
4217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4218: aso_debug_pub.add('aso_quote_vuhk: inside if create quote post (1)'||x_return_status,1, 'N');
4219: END IF;
4220:
4221: ASO_QUOTE_VUHK.Create_quote_POST(
4222: P_Validation_Level => l_validation_level ,

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

4253: X_Msg_Count => X_Msg_Count,
4254: X_Msg_Data => X_Msg_Data
4255: );
4256:
4257: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4258: aso_debug_pub.add('create_quote_pub: after hooks (2)'||x_return_status,1, 'N');
4259: END IF;
4260:
4261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4258: aso_debug_pub.add('create_quote_pub: after hooks (2)'||x_return_status,1, 'N');

4254: X_Msg_Data => X_Msg_Data
4255: );
4256:
4257: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4258: aso_debug_pub.add('create_quote_pub: after hooks (2)'||x_return_status,1, 'N');
4259: END IF;
4260:
4261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4262:

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

4486: BEGIN
4487: -- Standard Start of API savepoint
4488: SAVEPOINT CREATE_QUOTE_SERVICE_PUB;
4489:
4490: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4491:
4492: -- Standard call to check for call compatibility.
4493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4494: p_api_version_number,

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

4641: X_MSG_COUNT => x_msg_count,
4642: X_MSG_DATA => x_msg_data
4643: );
4644:
4645: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4646: aso_debug_pub.add('create_quote_service: after call default header entity '||lx_return_status,1, 'N');
4647: END IF;
4648: /*
4649: DBMS_OUTPUT.PUT_LINE('header default entity call return= ' || x_return_status);

Line 4646: aso_debug_pub.add('create_quote_service: after call default header entity '||lx_return_status,1, 'N');

4642: X_MSG_DATA => x_msg_data
4643: );
4644:
4645: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4646: aso_debug_pub.add('create_quote_service: after call default header entity '||lx_return_status,1, 'N');
4647: END IF;
4648: /*
4649: DBMS_OUTPUT.PUT_LINE('header default entity call return= ' || x_return_status);
4650: DBMS_OUTPUT.PUT_LINE('status id = ' || lx_qte_header_rec.quote_status_id);

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

4690: X_RETURN_STATUS => x_return_Status,
4691: X_MSG_DATA => x_msg_data,
4692: X_MSG_COUNT => x_msg_count);
4693:
4694: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4695: aso_debug_pub.add('create_quote_service: after call default header entity validation)'||lx_return_status,1, 'N');
4696: END IF;
4697: DBMS_OUTPUT.PUT_LINE('header default validaton return=' || x_return_status);
4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then

Line 4695: aso_debug_pub.add('create_quote_service: after call default header entity validation)'||lx_return_status,1, 'N');

4691: X_MSG_DATA => x_msg_data,
4692: X_MSG_COUNT => x_msg_count);
4693:
4694: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4695: aso_debug_pub.add('create_quote_service: after call default header entity validation)'||lx_return_status,1, 'N');
4696: END IF;
4697: DBMS_OUTPUT.PUT_LINE('header default validaton return=' || x_return_status);
4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then
4699: raise FND_API.G_EXC_ERROR;

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

4749: l_qte_line_tbl(i).item_type_code := 'STD';
4750: END IF;
4751: END IF;
4752:
4753: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4754: ASO_QUOTE_UTIL_PVT.debug('Create_Quote_Service: line '|| i);
4755: ASO_QUOTE_UTIL_PVT.debug('inventory_item_id '|| l_qte_line_tbl(i).inventory_item_id);
4756: ASO_QUOTE_UTIL_PVT.debug('l_inv_org_id '|| l_inv_org_id);
4757: ASO_QUOTE_UTIL_PVT.debug('uom_code '|| l_qte_line_tbl(i).uom_code);

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

4767: l_qte_line_tbl(i).uom_code,
4768: l_output_qty,
4769: l_primary_qty,
4770: x_valid_quantity);
4771: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4772: ASO_QUOTE_UTIL_PVT.debug('Returning from INV_DECIMALS_PUB.validate_quantity ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
4773: END IF;
4774:
4775: -- Prepare l_trigger_attribute_tbl

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

4852: X_MSG_COUNT => x_msg_count,
4853: X_MSG_DATA => x_msg_data
4854: );
4855:
4856: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4857: aso_debug_pub.add('create_quote_service: after call default line entity '||k||lx_return_status,1, 'N');
4858: END IF;
4859: -- Check return status from the above procedure call
4860: IF x_return_status = FND_API.G_RET_STS_ERROR then

Line 4857: aso_debug_pub.add('create_quote_service: after call default line entity '||k||lx_return_status,1, 'N');

4853: X_MSG_DATA => x_msg_data
4854: );
4855:
4856: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4857: aso_debug_pub.add('create_quote_service: after call default line entity '||k||lx_return_status,1, 'N');
4858: END IF;
4859: -- Check return status from the above procedure call
4860: IF x_return_status = FND_API.G_RET_STS_ERROR then
4861: raise FND_API.G_EXC_ERROR;

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

4877: -- Prepare control record to call create_quote
4878: -- call create_quote api
4879:
4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;

Line 4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');

4878: -- call create_quote api
4879:
4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:

Line 4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');

4879:
4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:
4887: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_PRICE'), 'A')='M' THEN

Line 4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');

4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:
4887: IF NVL(FND_PROFILE.VALUE('ASO_CALCULATE_PRICE'), 'A')='M' THEN
4888: l_control_rec.pricing_request_type := 'ASO';

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

4958: X_Return_Status => x_return_status,
4959: X_Msg_Count => x_msg_count,
4960: X_Msg_Data => x_msg_data);
4961:
4962: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4963: aso_debug_pub.add('create_quote_service_pub: after create_quote'||x_return_status,1, 'N');
4964: END IF;
4965:
4966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4963: aso_debug_pub.add('create_quote_service_pub: after create_quote'||x_return_status,1, 'N');

4959: X_Msg_Count => x_msg_count,
4960: X_Msg_Data => x_msg_data);
4961:
4962: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4963: aso_debug_pub.add('create_quote_service_pub: after create_quote'||x_return_status,1, 'N');
4964: END IF;
4965:
4966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4967:

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

5148: BEGIN
5149: -- Standard Start of API savepoint
5150: SAVEPOINT UPDATE_QUOTE_PUB;
5151:
5152: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5153:
5154: -- Standard call to check for call compatibility.
5155: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5156: p_api_version_number,

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

5423: X_Return_Status => x_return_status,
5424: X_Msg_Count => x_msg_count,
5425: X_Msg_Data => x_msg_data);
5426:
5427: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5428: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');
5429: END IF;
5430:
5431: -- Check return status from the above procedure call

Line 5428: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');

5424: X_Msg_Count => x_msg_count,
5425: X_Msg_Data => x_msg_data);
5426:
5427: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5428: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');
5429: END IF;
5430:
5431: -- Check return status from the above procedure call
5432: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

5490: END IF;
5491:
5492: END IF; -- customer hook
5493:
5494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5495: aso_debug_pub.add('aso_quote_vuhk: before if update quote post (1)'||x_return_status,1, 'N');
5496: END IF;
5497:
5498: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

Line 5495: aso_debug_pub.add('aso_quote_vuhk: before if update quote post (1)'||x_return_status,1, 'N');

5491:
5492: END IF; -- customer hook
5493:
5494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5495: aso_debug_pub.add('aso_quote_vuhk: before if update quote post (1)'||x_return_status,1, 'N');
5496: END IF;
5497:
5498: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
5499:

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

5496: END IF;
5497:
5498: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
5499:
5500: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5501: aso_debug_pub.add('aso_quote_vuhk: inside if update quote post (1)'||x_return_status,1, 'N');
5502: END IF;
5503:
5504: ASO_QUOTE_VUHK.Update_quote_POST(

Line 5501: aso_debug_pub.add('aso_quote_vuhk: inside if update quote post (1)'||x_return_status,1, 'N');

5497:
5498: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
5499:
5500: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5501: aso_debug_pub.add('aso_quote_vuhk: inside if update quote post (1)'||x_return_status,1, 'N');
5502: END IF;
5503:
5504: ASO_QUOTE_VUHK.Update_quote_POST(
5505: P_Validation_Level => l_validation_level ,

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

5536: X_Msg_Count => X_Msg_Count,
5537: X_Msg_Data => X_Msg_Data
5538: );
5539:
5540: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5541: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');
5542: END IF;
5543:
5544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 5541: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');

5537: X_Msg_Data => X_Msg_Data
5538: );
5539:
5540: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5541: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');
5542: END IF;
5543:
5544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5545:

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

5673: Begin
5674:
5675: SAVEPOINT validate_model_cfg_pub;
5676:
5677: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5678:
5679: --dbms_output.put_line('Testing in Progress');
5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681:

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

5679: --dbms_output.put_line('Testing in Progress');
5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681:
5682:
5683: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');
5686: END IF;
5687:

Line 5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');

5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681:
5682:
5683: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');
5686: END IF;
5687:
5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');

5681:
5682:
5683: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');
5686: END IF;
5687:
5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5689: p_api_version_number,

Line 5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');

5694:
5695: l_api_name := 'VALIDATE_MODEL_CFG'; -- Added for Bug 12679929
5696:
5697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');
5699: FND_MSG_PUB.initialize;
5700: END IF;
5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');
5699: FND_MSG_PUB.initialize;
5700: END IF;
5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');
5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');
5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');
5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');

Line 5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');

5699: FND_MSG_PUB.initialize;
5700: END IF;
5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');
5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');
5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');
5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');
5707: aso_debug_pub.add('Begin p_commit'||p_commit, 1, 'Y');

Line 5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');

5700: END IF;
5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');
5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');
5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');
5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');
5707: aso_debug_pub.add('Begin p_commit'||p_commit, 1, 'Y');
5708: end if;

Line 5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');

5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');
5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');
5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');
5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');
5707: aso_debug_pub.add('Begin p_commit'||p_commit, 1, 'Y');
5708: end if;
5709:

Line 5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');

5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');
5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');
5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');
5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');
5707: aso_debug_pub.add('Begin p_commit'||p_commit, 1, 'Y');
5708: end if;
5709:
5710: -- dbms_output.put_line('Entered quote line id in Progress'||p_Quote_line_id);

Line 5707: aso_debug_pub.add('Begin p_commit'||p_commit, 1, 'Y');

5703: aso_debug_pub.add('Begin Validate_model_configuration pvt', 1, 'Y');
5704: aso_debug_pub.add('Begin quote_header_id'||P_Quote_header_id, 1, 'Y');
5705: aso_debug_pub.add('Begin quote_line_id'||P_Quote_line_id, 1, 'Y');
5706: aso_debug_pub.add('Begin p_update_quote'||p_update_quote, 1, 'Y');
5707: aso_debug_pub.add('Begin p_commit'||p_commit, 1, 'Y');
5708: end if;
5709:
5710: -- dbms_output.put_line('Entered quote line id in Progress'||p_Quote_line_id);
5711:

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

5722: for i in 1..l_qte_line_tbl.count loop
5723: -- query the quote for all the models and populate the model line id and details table
5724: if l_qte_line_tbl(i).item_type_code='MDL' then
5725: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
5726: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5727: aso_debug_pub.add('Validate_model_configuration detail table count l_qte_line_dtl_tbl'||l_qte_line_dtl_tbl.count, 1, 'Y');
5728: End if;
5729:
5730: If l_qte_line_dtl_tbl.count = 0 then

Line 5727: aso_debug_pub.add('Validate_model_configuration detail table count l_qte_line_dtl_tbl'||l_qte_line_dtl_tbl.count, 1, 'Y');

5723: -- query the quote for all the models and populate the model line id and details table
5724: if l_qte_line_tbl(i).item_type_code='MDL' then
5725: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
5726: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5727: aso_debug_pub.add('Validate_model_configuration detail table count l_qte_line_dtl_tbl'||l_qte_line_dtl_tbl.count, 1, 'Y');
5728: End if;
5729:
5730: If l_qte_line_dtl_tbl.count = 0 then
5731: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

5727: aso_debug_pub.add('Validate_model_configuration detail table count l_qte_line_dtl_tbl'||l_qte_line_dtl_tbl.count, 1, 'Y');
5728: End if;
5729:
5730: If l_qte_line_dtl_tbl.count = 0 then
5731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5732: aso_debug_pub.add('Set config header_id and config_rev_num to null if there is no model details ', 1, 'Y');
5733: End if;
5734: l_qte_line_dtl_tbl(1).config_header_id := Null;
5735: l_qte_line_dtl_tbl(1).config_revision_num := Null;

Line 5732: aso_debug_pub.add('Set config header_id and config_rev_num to null if there is no model details ', 1, 'Y');

5728: End if;
5729:
5730: If l_qte_line_dtl_tbl.count = 0 then
5731: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5732: aso_debug_pub.add('Set config header_id and config_rev_num to null if there is no model details ', 1, 'Y');
5733: End if;
5734: l_qte_line_dtl_tbl(1).config_header_id := Null;
5735: l_qte_line_dtl_tbl(1).config_revision_num := Null;
5736: End if;

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

5756: ELSE
5757: */
5758:
5759: FOR i IN 1..l_model_qte_line_tbl.count LOOP
5760: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5761: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id,1,'N');
5762: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id,1,'N');
5763: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5764: END IF;

Line 5761: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id,1,'N');

5757: */
5758:
5759: FOR i IN 1..l_model_qte_line_tbl.count LOOP
5760: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5761: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id,1,'N');
5762: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id,1,'N');
5763: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5764: END IF;
5765: --dbms_output.put_line('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id);

Line 5762: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id,1,'N');

5758:
5759: FOR i IN 1..l_model_qte_line_tbl.count LOOP
5760: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5761: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id,1,'N');
5762: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id,1,'N');
5763: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5764: END IF;
5765: --dbms_output.put_line('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id);
5766: --dbms_output.put_line('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id);

Line 5763: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num,1,'N');

5759: FOR i IN 1..l_model_qte_line_tbl.count LOOP
5760: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5761: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id,1,'N');
5762: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id,1,'N');
5763: aso_debug_pub.add('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5764: END IF;
5765: --dbms_output.put_line('Validate_model_configuration: l_model_qte_line_tbl('||i||').quote_line_id: '||l_model_qte_line_tbl(i).quote_line_id);
5766: --dbms_output.put_line('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_header_id: '||l_model_qte_line_dtl_tbl(i).config_header_id);
5767: --dbms_output.put_line('Validate_model_configuration: l_model_qte_line_dtl_tbl('||i||').config_revision_num: '||l_model_qte_line_dtl_tbl(i).config_revision_num);

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

5781: l_control_rec_bv.defaulting_fwk_flag := 'N';
5782:
5783:
5784: -- Call Batch Validation procedure
5785: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5786: aso_debug_pub.add('ASO_QUOTE_PUB : Before call to ASO_BATCH_VALIDATE_CFG_PVT.Validate_Configuration'|| l_model_qte_line_tbl(i).quote_line_id,1,'N');
5787: END IF;
5788:
5789: /*FND_MSG_PUB.Count_And_Get

Line 5786: aso_debug_pub.add('ASO_QUOTE_PUB : Before call to ASO_BATCH_VALIDATE_CFG_PVT.Validate_Configuration'|| l_model_qte_line_tbl(i).quote_line_id,1,'N');

5782:
5783:
5784: -- Call Batch Validation procedure
5785: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5786: aso_debug_pub.add('ASO_QUOTE_PUB : Before call to ASO_BATCH_VALIDATE_CFG_PVT.Validate_Configuration'|| l_model_qte_line_tbl(i).quote_line_id,1,'N');
5787: END IF;
5788:
5789: /*FND_MSG_PUB.Count_And_Get
5790: ( p_encoded => 'F',

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

5792: p_data => x_msg_data
5793: );
5794: x_msg_data := fnd_msg_pub.get( p_msg_index => 1, p_encoded => 'F');
5795: */
5796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');
5799: --aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_data, 1, 'Y');
5800: END IF;

Line 5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');

5793: );
5794: x_msg_data := fnd_msg_pub.get( p_msg_index => 1, p_encoded => 'F');
5795: */
5796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');
5799: --aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_data, 1, 'Y');
5800: END IF;
5801:

Line 5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');

5794: x_msg_data := fnd_msg_pub.get( p_msg_index => 1, p_encoded => 'F');
5795: */
5796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');
5799: --aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_data, 1, 'Y');
5800: END IF;
5801:
5802: -- Added condition for unconfigured items

Line 5799: --aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_data, 1, 'Y');

5795: */
5796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');
5799: --aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_data, 1, 'Y');
5800: END IF;
5801:
5802: -- Added condition for unconfigured items
5803: if (l_model_qte_line_dtl_tbl(i).config_header_id is not null) and ( l_model_qte_line_dtl_tbl(i).config_revision_num is not null) then

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

5833: l_config_changed:=NULL;
5834: l_return_status := FND_API.G_RET_STS_SUCCESS;
5835: end if;
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');

Line 5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');

5834: l_return_status := FND_API.G_RET_STS_SUCCESS;
5835: end if;
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');

Line 5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');

5835: end if;
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');

Line 5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');

5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;

Line 5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');

5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);

Line 5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');

5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);

Line 5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');

5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);

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

5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');
5855: END IF;
5856: -- code populate the cz rec type and set the changed flag
5857: l_config_index:=l_config_index+1;

Line 5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');

5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');
5855: END IF;
5856: -- code populate the cz rec type and set the changed flag
5857: l_config_index:=l_config_index+1;
5858: X_Config_tbl(l_config_index).quote_line_id:= l_model_qte_line_tbl(i).quote_line_id;

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

5869: if c_config_exist_in_cz%found then
5870:
5871: close c_config_exist_in_cz;
5872:
5873: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5874: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');
5875: END IF;
5876:
5877: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,

Line 5874: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');

5870:
5871: close c_config_exist_in_cz;
5872:
5873: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5874: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');
5875: END IF;
5876:
5877: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
5878: P_INIT_MSG_LIST => FND_API.G_FALSE,

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

5881: X_RETURN_STATUS => x_return_status,
5882: X_MSG_COUNT => x_msg_count,
5883: X_MSG_DATA => x_msg_data);
5884:
5885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5886: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);
5887: END IF;
5888:
5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 5886: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);

5882: X_MSG_COUNT => x_msg_count,
5883: X_MSG_DATA => x_msg_data);
5884:
5885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5886: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);
5887: END IF;
5888:
5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5890:

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

5917:
5918: --End if;
5919:
5920: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);
5923: END IF;
5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP

Line 5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);

5918: --End if;
5919:
5920: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);
5923: END IF;
5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);
5923: END IF;
5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);

Line 5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);

5923: END IF;
5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;

Line 5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);

5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;
5932:

Line 5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);

5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;
5932:
5933: If X_Config_tbl(i).IS_CFG_CHANGED_FLAG = 'Y' then

Line 5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);

5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;
5932:
5933: If X_Config_tbl(i).IS_CFG_CHANGED_FLAG = 'Y' then
5934: /* L_In_Line_Number_Tbl(1).Quote_Line_Id := X_Config_tbl(i).QUOTE_LINE_ID;

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

5950: );
5951:
5952: L_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID);
5953:
5954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5955: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);
5956: end if;
5957: If l_changed_model_line_num is Null then
5958: l_changed_model_line_num := l_line_number;

Line 5955: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);

5951:
5952: L_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID);
5953:
5954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5955: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);
5956: end if;
5957: If l_changed_model_line_num is Null then
5958: l_changed_model_line_num := l_line_number;
5959: Else

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

5974: );
5975:
5976: L_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID);
5977:
5978: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5979: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);
5980: end if;
5981: If l_invalid_model_line_num is Null then
5982: l_invalid_model_line_num := l_line_number;

Line 5979: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);

5975:
5976: L_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID);
5977:
5978: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5979: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);
5980: end if;
5981: If l_invalid_model_line_num is Null then
5982: l_invalid_model_line_num := l_line_number;
5983: Else

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

5992: FND_MSG_PUB.ADD;
5993: End if;
5994: */
5995:
5996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5997: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success after X_Config_tbl loop');
5998: END IF;
5999:
6000: If l_changed_model_line_num is Not Null OR l_invalid_model_line_num is Not Null then

Line 5997: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success after X_Config_tbl loop');

5993: End if;
5994: */
5995:
5996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5997: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success after X_Config_tbl loop');
5998: END IF;
5999:
6000: If l_changed_model_line_num is Not Null OR l_invalid_model_line_num is Not Null then
6001: FND_MESSAGE.Set_Name('ASO', 'ASO_MODEL_LINES_VALID_NOCHANGE');

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

6027: End if;
6028:
6029: x_return_status := l_return_status;
6030:
6031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);
6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:

Line 6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);

6028:
6029: x_return_status := l_return_status;
6030:
6031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);
6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:
6036: -- Standard check for p_commit

Line 6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);

6029: x_return_status := l_return_status;
6030:
6031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);
6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:
6036: -- Standard check for p_commit
6037: IF FND_API.to_Boolean( p_commit ) THEN

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

6040:
6041: /* Added this Function to return the x_msg_data */
6042: --L_Return_X_Msg_data := Return_X_Msg_data;
6043:
6044: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');
6046: End if;
6047:
6048: -- Standard call to get message count and if count is 1, get message info.

Line 6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');

6041: /* Added this Function to return the x_msg_data */
6042: --L_Return_X_Msg_data := Return_X_Msg_data;
6043:
6044: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');
6046: End if;
6047:
6048: -- Standard call to get message count and if count is 1, get message info.
6049: FND_MSG_PUB.Count_And_Get

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

6053:
6054: /* Assign the L_Return_X_Msg_data to the x_msg_data that can be shown in UI directly */
6055: -- x_msg_data := L_Return_X_Msg_data;
6056:
6057: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6058: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_msg_count '||x_msg_count, 1, 'Y');
6059: End if;
6060:
6061:

Line 6058: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_msg_count '||x_msg_count, 1, 'Y');

6054: /* Assign the L_Return_X_Msg_data to the x_msg_data that can be shown in UI directly */
6055: -- x_msg_data := L_Return_X_Msg_data;
6056:
6057: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6058: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_msg_count '||x_msg_count, 1, 'Y');
6059: End if;
6060:
6061:
6062: EXCEPTION