DBA Data[Home] [Help]

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 4136: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4440: BEGIN
4441: -- Standard Start of API savepoint
4442: SAVEPOINT UPDATE_QUOTE_PUB;
4443:
4444: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4445:
4446: -- Standard call to check for call compatibility.
4447: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4448: p_api_version_number,

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

4704: X_Return_Status => x_return_status,
4705: X_Msg_Count => x_msg_count,
4706: X_Msg_Data => x_msg_data);
4707:
4708: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4709: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');
4710: END IF;
4711:
4712: -- Check return status from the above procedure call

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

4705: X_Msg_Count => x_msg_count,
4706: X_Msg_Data => x_msg_data);
4707:
4708: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4709: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');
4710: END IF;
4711:
4712: -- Check return status from the above procedure call
4713: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

4771: END IF;
4772:
4773: END IF; -- customer hook
4774:
4775: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4776: aso_debug_pub.add('aso_quote_vuhk: before if update quote post (1)'||x_return_status,1, 'N');
4777: END IF;
4778:
4779: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

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

4772:
4773: END IF; -- customer hook
4774:
4775: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4776: aso_debug_pub.add('aso_quote_vuhk: before if update quote post (1)'||x_return_status,1, 'N');
4777: END IF;
4778:
4779: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
4780:

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

4777: END IF;
4778:
4779: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
4780:
4781: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4782: aso_debug_pub.add('aso_quote_vuhk: inside if update quote post (1)'||x_return_status,1, 'N');
4783: END IF;
4784:
4785: ASO_QUOTE_VUHK.Update_quote_POST(

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

4778:
4779: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
4780:
4781: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4782: aso_debug_pub.add('aso_quote_vuhk: inside if update quote post (1)'||x_return_status,1, 'N');
4783: END IF;
4784:
4785: ASO_QUOTE_VUHK.Update_quote_POST(
4786: P_Validation_Level => l_validation_level ,

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

4817: X_Msg_Count => X_Msg_Count,
4818: X_Msg_Data => X_Msg_Data
4819: );
4820:
4821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4822: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');
4823: END IF;
4824:
4825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

4818: X_Msg_Data => X_Msg_Data
4819: );
4820:
4821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4822: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');
4823: END IF;
4824:
4825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4826: