DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PUB dependencies on FND_API

Line 17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

13:
14:
15: PROCEDURE Copy_Quote(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type

Line 18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

14:
15: PROCEDURE Copy_Quote(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,

Line 41: IF NOT FND_API.Compatible_API_Call ( l_api_version,

37:
38: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version,
42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
45: THEN

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49:
50: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 51: IF FND_API.to_Boolean( p_init_msg_list )

47: END IF;
48:
49:
50: -- Initialize message list if p_init_msg_list is set to TRUE.
51: IF FND_API.to_Boolean( p_init_msg_list )
52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: -- Initialize API return status to SUCCESS
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: --
60: -- API body
61: --

Line 75: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

71: X_Return_Status => X_Return_Status,
72: X_Msg_Count => X_Msg_Count,
73: X_Msg_Data => X_Msg_Data );
74:
75: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: X_Msg_Count => X_Msg_Count,
73: X_Msg_Data => X_Msg_Data );
74:
75: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80:

Line 77: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

73: X_Msg_Data => X_Msg_Data );
74:
75: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80:
81: --

Line 78: RAISE FND_API.G_EXC_ERROR;

74:
75: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80:
81: --
82: -- End of API body.

Line 86: IF FND_API.to_Boolean( p_commit )

82: -- End of API body.
83: --
84:
85: -- Standard check for p_commit
86: IF FND_API.to_Boolean( p_commit )
87: THEN
88: COMMIT WORK;
89: END IF;
90:

Line 103: WHEN FND_API.G_EXC_ERROR THEN

99: p_data => x_msg_data
100: );
101:
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
105: P_API_NAME => L_API_NAME
106: ,P_PKG_NAME => G_PKG_NAME
107: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

109: ,X_MSG_COUNT => X_MSG_COUNT
110: ,X_MSG_DATA => X_MSG_DATA
111: ,X_RETURN_STATUS => X_RETURN_STATUS);
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
115: P_API_NAME => L_API_NAME
116: ,P_PKG_NAME => G_PKG_NAME
117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

134:
135:
136: PROCEDURE Copy_Line(
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: P_Qte_Header_Id IN NUMBER,
141: P_Qte_Line_Id IN NUMBER := NULL,
142: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

Line 139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

135:
136: PROCEDURE Copy_Line(
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: P_Qte_Header_Id IN NUMBER,
141: P_Qte_Line_Id IN NUMBER := NULL,
142: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
143: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 166: IF NOT FND_API.Compatible_API_Call ( l_api_version,

162:
163: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
164:
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call ( l_api_version,
167: p_api_version_number,
168: l_api_name,
169: G_PKG_NAME)
170: THEN

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: p_api_version_number,
168: l_api_name,
169: G_PKG_NAME)
170: THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 176: IF FND_API.to_Boolean( p_init_msg_list )

172: END IF;
173:
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean( p_init_msg_list )
177: THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180:

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS;

178: FND_MSG_PUB.initialize;
179: END IF;
180:
181: -- Initialize API return status to SUCCESS
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183:
184: --
185: -- API body
186: --

Line 188: IF ( P_Qte_Line_Id IS NULL OR P_Qte_Line_Id = FND_API.G_MISS_NUM ) THEN

184: --
185: -- API body
186: --
187:
188: IF ( P_Qte_Line_Id IS NULL OR P_Qte_Line_Id = FND_API.G_MISS_NUM ) THEN
189: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
190: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
191: FND_MESSAGE.Set_Token('COLUMN', 'P_Qte_Line_Id', FALSE);
192: FND_MSG_PUB.ADD;

Line 194: raise FND_API.G_EXC_ERROR;

190: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
191: FND_MESSAGE.Set_Token('COLUMN', 'P_Qte_Line_Id', FALSE);
192: FND_MSG_PUB.ADD;
193: END IF;
194: raise FND_API.G_EXC_ERROR;
195: End if;
196:
197: IF aso_debug_pub.g_debug_flag = 'Y' THEN
198: aso_debug_pub.ADD ( ' Calling Copy_Line_Rows API ' , 1 , 'N' );

Line 203: l_qte_header_rec.batch_price_flag := FND_API.G_TRUE;

199: END IF;
200:
201: l_qte_header_rec := P_Qte_Header_Rec;
202:
203: l_qte_header_rec.batch_price_flag := FND_API.G_TRUE;
204:
205: l_Copy_Quote_Control_Rec := P_Copy_Quote_Control_Rec;
206:
207: -- change for sales supp enhancement as per bug 2940126

Line 208: l_Copy_Quote_Control_Rec.New_Version := FND_API.G_TRUE;

204:
205: l_Copy_Quote_Control_Rec := P_Copy_Quote_Control_Rec;
206:
207: -- change for sales supp enhancement as per bug 2940126
208: l_Copy_Quote_Control_Rec.New_Version := FND_API.G_TRUE;
209:
210:
211: ASO_COPY_QUOTE_PVT.Copy_Line_Rows (
212: P_Api_Version_Number => P_Api_Version_Number,

Line 232: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

228: aso_debug_pub.ADD ( ' After calling Copy_Line_rows API ' , 1 , 'N' );
229: END IF;
230:
231:
232: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: END IF;
230:
231:
232: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:

Line 234: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

230:
231:
232: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:
238: --

Line 235: RAISE FND_API.G_EXC_ERROR;

231:
232: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:
238: --
239: -- End of API body.

Line 243: IF FND_API.to_Boolean( p_commit )

239: -- End of API body.
240: --
241:
242: -- Standard check for p_commit
243: IF FND_API.to_Boolean( p_commit )
244: THEN
245: COMMIT WORK;
246: END IF;
247:

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: p_data => x_msg_data
257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

290: END Copy_Line;
291:
292: PROCEDURE Copy_Line(
293: P_Api_Version_Number IN NUMBER,
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Id IN NUMBER,
297: P_Qte_Line_Id IN NUMBER := NULL,
298: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

Line 295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

291:
292: PROCEDURE Copy_Line(
293: P_Api_Version_Number IN NUMBER,
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Id IN NUMBER,
297: P_Qte_Line_Id IN NUMBER := NULL,
298: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
299: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 330: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

326: X_Return_Status => X_Return_Status,
327: X_Msg_Count => X_Msg_Count,
328: X_Msg_Data => X_Msg_Data );
329:
330: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
331: OPEN c_get_header_id(X_Qte_Line_Id);
332: Fetch c_get_header_id INTO l_header_id;
333: Close c_get_header_id;
334: