APPS.IBE_QUOTE_REL_OBJ_PVT dependencies on FND_API

Line 4: l_true VARCHAR2(1) := FND_API.G_TRUE;

1: PACKAGE BODY IBE_Quote_Rel_Obj_Pvt AS
2: /* $Header: IBEVQROB.pls 115.2 2002/12/21 06:44:25 ajlee ship $ */
3:
4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:
6: FUNCTION Get_Related_Obj_Tbl(
7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,

3:
4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:
6: FUNCTION Get_Related_Obj_Tbl(
7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:
6: FUNCTION Get_Related_Obj_Tbl(
7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,

5:
6: FUNCTION Get_Related_Obj_Tbl(
7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,

Line 10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

6: FUNCTION Get_Related_Obj_Tbl(
7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,
14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE

Line 11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

7: p_related_object_id IN NUMBER := FND_API.G_MISS_NUM ,
8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,
14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE
15: )

Line 12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

8: p_quote_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,
14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE
15: )
16: RETURN ASO_Quote_Pub.Related_Obj_Tbl_Type

Line 13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,

9: p_quote_object_id IN NUMBER := FND_API.G_MISS_NUM ,
10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,
14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE
15: )
16: RETURN ASO_Quote_Pub.Related_Obj_Tbl_Type
17: IS

Line 14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE

10: p_object_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,
14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE
15: )
16: RETURN ASO_Quote_Pub.Related_Obj_Tbl_Type
17: IS
18: TYPE Csr_Type IS REF CURSOR;

Line 23: IF FND_API.To_Boolean(p_for_all_versions)

19: l_csr Csr_Type;
20: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
21: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
22: BEGIN
23: IF FND_API.To_Boolean(p_for_all_versions)
24: AND p_quote_object_type_code = 'HEADER' THEN
25: -- CREATE
26: IF p_related_object_id = FND_API.G_MISS_NUM THEN
27: l_related_obj_rec.quote_object_type_code := p_quote_object_type_code;

Line 26: IF p_related_object_id = FND_API.G_MISS_NUM THEN

22: BEGIN
23: IF FND_API.To_Boolean(p_for_all_versions)
24: AND p_quote_object_type_code = 'HEADER' THEN
25: -- CREATE
26: IF p_related_object_id = FND_API.G_MISS_NUM THEN
27: l_related_obj_rec.quote_object_type_code := p_quote_object_type_code;
28: l_related_obj_rec.object_type_code := p_object_type_code;
29: l_related_obj_rec.object_id := p_object_id;
30: l_related_obj_rec.relationship_type_code := p_relationship_type_code;

Line 32: IF FND_API.To_Boolean(p_one_to_one) THEN

28: l_related_obj_rec.object_type_code := p_object_type_code;
29: l_related_obj_rec.object_id := p_object_id;
30: l_related_obj_rec.relationship_type_code := p_relationship_type_code;
31:
32: IF FND_API.To_Boolean(p_one_to_one) THEN
33: OPEN l_csr FOR SELECT AQH1.quote_header_id
34: FROM aso_quote_headers AQH1,
35: aso_quote_headers AQH2
36: WHERE AQH1.quote_number = AQH2.quote_number

Line 82: IF p_related_object_id = FND_API.G_MISS_NUM THEN

78:
79: CLOSE l_csr;
80: END IF;
81: ELSE
82: IF p_related_object_id = FND_API.G_MISS_NUM THEN
83: l_related_obj_rec.quote_object_type_code := p_quote_object_type_code;
84: l_related_obj_rec.quote_object_id := p_quote_object_id;
85: l_related_obj_rec.object_type_code := p_object_type_code;
86: l_related_obj_rec.object_id := p_object_id;

Line 101: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

97:
98:
99: PROCEDURE Create_Relationship(
100: p_api_version IN NUMBER := 1.0 ,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2 ,
104: x_msg_count OUT NOCOPY NUMBER ,
105: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 102: p_commit IN VARCHAR2 := FND_API.G_FALSE,

98:
99: PROCEDURE Create_Relationship(
100: p_api_version IN NUMBER := 1.0 ,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2 ,
104: x_msg_count OUT NOCOPY NUMBER ,
105: x_msg_data OUT NOCOPY VARCHAR2 ,
106: p_quote_object_type_code IN VARCHAR2 ,

Line 127: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

123: -- Standard Start of API savepoint
124: SAVEPOINT Create_Relationship_Pvt;
125:
126: -- Standard call to check for call compatibility.
127: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
128: p_api_version,
129: L_API_NAME ,
130: G_PKG_NAME )
131: THEN

Line 132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

128: p_api_version,
129: L_API_NAME ,
130: G_PKG_NAME )
131: THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: -- Initialize message list if p_init_msg_list is set to TRUE.
136: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 136: IF FND_API.To_Boolean(p_init_msg_list) THEN

132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: -- Initialize message list if p_init_msg_list is set to TRUE.
136: IF FND_API.To_Boolean(p_init_msg_list) THEN
137: FND_Msg_Pub.initialize;
138: END IF;
139:
140: -- Initialize API return status to success

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137: FND_Msg_Pub.initialize;
138: END IF;
139:
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: -- API body
143: IF FND_API.To_Boolean(p_one_to_one) THEN
144: SELECT COUNT(*)
145: INTO i

Line 143: IF FND_API.To_Boolean(p_one_to_one) THEN

139:
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: -- API body
143: IF FND_API.To_Boolean(p_one_to_one) THEN
144: SELECT COUNT(*)
145: INTO i
146: FROM aso_quote_related_objects
147: WHERE quote_object_type_code = p_quote_object_type_code

Line 154: RAISE FND_API.G_EXC_ERROR;

150:
151: IF i > 0 THEN
152: FND_MESSAGE.Set_Name('IBE', 'IBE_QT_DUP_QUOTE_REL');
153: FND_MSG_PUB.Add;
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;
156: END IF;
157:
158: l_related_obj_rec.quote_object_type_code := p_quote_object_type_code;

Line 181: p_init_msg_list => FND_API.G_TRUE ,

177: END IF;
178:
179: ASO_Rltship_Pub.Create_Object_Relationship(
180: p_api_version_number => p_api_version ,
181: p_init_msg_list => FND_API.G_TRUE ,
182: p_commit => FND_API.G_FALSE ,
183: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
184: x_return_status => x_return_status ,
185: x_msg_count => x_msg_count ,

Line 182: p_commit => FND_API.G_FALSE ,

178:
179: ASO_Rltship_Pub.Create_Object_Relationship(
180: p_api_version_number => p_api_version ,
181: p_init_msg_list => FND_API.G_TRUE ,
182: p_commit => FND_API.G_FALSE ,
183: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
184: x_return_status => x_return_status ,
185: x_msg_count => x_msg_count ,
186: x_msg_data => x_msg_data ,

Line 183: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

179: ASO_Rltship_Pub.Create_Object_Relationship(
180: p_api_version_number => p_api_version ,
181: p_init_msg_list => FND_API.G_TRUE ,
182: p_commit => FND_API.G_FALSE ,
183: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
184: x_return_status => x_return_status ,
185: x_msg_count => x_msg_count ,
186: x_msg_data => x_msg_data ,
187: p_related_obj_rec => l_related_obj_tbl(i) ,

Line 194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

190: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
191: IBE_UTIL.DEBUG('Returned from ASO_Rltship_Pub.Create_Object_Relationship at'
192: || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
193: END IF;
194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 195: RAISE FND_API.G_EXC_ERROR;

191: IBE_UTIL.DEBUG('Returned from ASO_Rltship_Pub.Create_Object_Relationship at'
192: || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
193: END IF;
194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 198: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: IF l_related_obj_tbl(i).quote_object_id = p_quote_object_id THEN

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: IF l_related_obj_tbl(i).quote_object_id = p_quote_object_id THEN
203: x_related_obj_id := l_related_object_id;

Line 209: IF FND_API.To_Boolean(p_commit) THEN

205: END LOOP;
206: -- End of API body.
207:
208: -- Standard check of p_commit.
209: IF FND_API.To_Boolean(p_commit) THEN
210: COMMIT WORK;
211: END IF;
212:
213: -- Standard call to get message count and if count is 1, get message info.

Line 214: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

210: COMMIT WORK;
211: END IF;
212:
213: -- Standard call to get message count and if count is 1, get message info.
214: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count ,
216: p_data => x_msg_data);
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN

Line 218: WHEN FND_API.G_EXC_ERROR THEN

214: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count ,
216: p_data => x_msg_data);
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO Create_Relationship_Pvt;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count ,

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: p_data => x_msg_data);
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO Create_Relationship_Pvt;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count ,
223: p_data => x_msg_data);
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO Create_Relationship_Pvt;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count ,
223: p_data => x_msg_data);
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO Create_Relationship_Pvt;

Line 224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count ,
223: p_data => x_msg_data);
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO Create_Relationship_Pvt;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count ,

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

222: p_count => x_msg_count ,
223: p_data => x_msg_data);
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO Create_Relationship_Pvt;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count ,
229: p_data => x_msg_data);
230: WHEN OTHERS THEN

Line 227: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

223: p_data => x_msg_data);
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO Create_Relationship_Pvt;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count ,
229: p_data => x_msg_data);
230: WHEN OTHERS THEN
231: ROLLBACK TO Create_Relationship_Pvt;

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: p_count => x_msg_count ,
229: p_data => x_msg_data);
230: WHEN OTHERS THEN
231: ROLLBACK TO Create_Relationship_Pvt;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233:
234: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
235: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
236: L_API_NAME);

Line 239: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

235: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
236: L_API_NAME);
237: END IF;
238:
239: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count ,
241: p_data => x_msg_data);
242: END Create_Relationship;
243:

Line 247: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

243:
244:
245: PROCEDURE Delete_Relationship(
246: p_api_version IN NUMBER := 1.0 ,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2 ,
250: x_msg_count OUT NOCOPY NUMBER ,
251: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 248: p_commit IN VARCHAR2 := FND_API.G_FALSE,

244:
245: PROCEDURE Delete_Relationship(
246: p_api_version IN NUMBER := 1.0 ,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2 ,
250: x_msg_count OUT NOCOPY NUMBER ,
251: x_msg_data OUT NOCOPY VARCHAR2 ,
252: p_quote_object_type_code IN VARCHAR2 ,

Line 271: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

267: -- Standard Start of API savepoint
268: SAVEPOINT Delete_Relationship_Pvt;
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
272: p_api_version,
273: L_API_NAME ,
274: G_PKG_NAME )
275: THEN

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: p_api_version,
273: L_API_NAME ,
274: G_PKG_NAME )
275: THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: -- Initialize message list if p_init_msg_list is set to TRUE.
280: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 280: IF FND_API.To_Boolean(p_init_msg_list) THEN

276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: -- Initialize message list if p_init_msg_list is set to TRUE.
280: IF FND_API.To_Boolean(p_init_msg_list) THEN
281: FND_Msg_Pub.initialize;
282: END IF;
283:
284: -- Initialize API return status to success

Line 285: x_return_status := FND_API.G_RET_STS_SUCCESS;

281: FND_Msg_Pub.initialize;
282: END IF;
283:
284: -- Initialize API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286:
287: -- API body
288: BEGIN
289: SELECT related_object_id

Line 301: RAISE FND_API.G_EXC_ERROR;

297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: FND_MESSAGE.Set_Name('IBE', 'IBE_QT_QUOTE_REL_NOT_FOUND');
300: FND_MSG_PUB.Add;
301: RAISE FND_API.G_EXC_ERROR;
302: END;
303:
304: l_related_obj_tbl :=
305: Get_Related_Obj_Tbl(p_related_object_id => l_related_obj_rec.related_object_id,

Line 317: p_init_msg_list => FND_API.G_TRUE ,

313: END IF;
314:
315: ASO_Rltship_Pub.Delete_Object_Relationship(
316: p_api_version_number => p_api_version ,
317: p_init_msg_list => FND_API.G_TRUE ,
318: p_commit => FND_API.G_FALSE ,
319: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
320: x_return_status => x_return_status ,
321: x_msg_count => x_msg_count ,

Line 318: p_commit => FND_API.G_FALSE ,

314:
315: ASO_Rltship_Pub.Delete_Object_Relationship(
316: p_api_version_number => p_api_version ,
317: p_init_msg_list => FND_API.G_TRUE ,
318: p_commit => FND_API.G_FALSE ,
319: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
320: x_return_status => x_return_status ,
321: x_msg_count => x_msg_count ,
322: x_msg_data => x_msg_data ,

Line 319: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

315: ASO_Rltship_Pub.Delete_Object_Relationship(
316: p_api_version_number => p_api_version ,
317: p_init_msg_list => FND_API.G_TRUE ,
318: p_commit => FND_API.G_FALSE ,
319: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
320: x_return_status => x_return_status ,
321: x_msg_count => x_msg_count ,
322: x_msg_data => x_msg_data ,
323: p_related_obj_rec => l_related_obj_tbl(i));

Line 325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

321: x_msg_count => x_msg_count ,
322: x_msg_data => x_msg_data ,
323: p_related_obj_rec => l_related_obj_tbl(i));
324:
325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 326: RAISE FND_API.G_EXC_ERROR;

322: x_msg_data => x_msg_data ,
323: p_related_obj_rec => l_related_obj_tbl(i));
324:
325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
333: IBE_UTIL.DEBUG('Returned from ASO_Rltship_Pub.Delete_Object_Relationship at'

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
333: IBE_UTIL.DEBUG('Returned from ASO_Rltship_Pub.Delete_Object_Relationship at'
334: || TO_CHAR(SYSDATE, 'MM/DD/RRRR:HH24:MI:SS'));

Line 341: IF FND_API.To_Boolean(p_commit) THEN

337: END LOOP;
338: -- End of API body.
339:
340: -- Standard check of p_commit.
341: IF FND_API.To_Boolean(p_commit) THEN
342: COMMIT WORK;
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.

Line 346: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

342: COMMIT WORK;
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count ,
348: p_data => x_msg_data);
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN

Line 350: WHEN FND_API.G_EXC_ERROR THEN

346: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count ,
348: p_data => x_msg_data);
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: ROLLBACK TO Delete_Relationship_Pvt;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
354: p_count => x_msg_count ,

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348: p_data => x_msg_data);
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: ROLLBACK TO Delete_Relationship_Pvt;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
354: p_count => x_msg_count ,
355: p_data => x_msg_data);
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 353: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: ROLLBACK TO Delete_Relationship_Pvt;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
354: p_count => x_msg_count ,
355: p_data => x_msg_data);
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: ROLLBACK TO Delete_Relationship_Pvt;

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
354: p_count => x_msg_count ,
355: p_data => x_msg_data);
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: ROLLBACK TO Delete_Relationship_Pvt;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
359: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count ,

Line 358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

354: p_count => x_msg_count ,
355: p_data => x_msg_data);
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: ROLLBACK TO Delete_Relationship_Pvt;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
359: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count ,
361: p_data => x_msg_data);
362: WHEN OTHERS THEN

Line 359: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

355: p_data => x_msg_data);
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: ROLLBACK TO Delete_Relationship_Pvt;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
359: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count ,
361: p_data => x_msg_data);
362: WHEN OTHERS THEN
363: ROLLBACK TO Delete_Relationship_Pvt;

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: p_count => x_msg_count ,
361: p_data => x_msg_data);
362: WHEN OTHERS THEN
363: ROLLBACK TO Delete_Relationship_Pvt;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365:
366: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
367: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
368: L_API_NAME);

Line 371: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

367: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
368: L_API_NAME);
369: END IF;
370:
371: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count ,
373: p_data => x_msg_data);
374: END Delete_Relationship;
375: