APPS.QP_DELAYED_REQUESTS_PVT dependencies on FND_API

Line 12: return the result in p_request_search_result which is set to FND_API.G_TRUE

8: g_requesting_entities QP_QUALIFIER_RULES_PUB.Requesting_Entity_Tbl_Type;
9: G_MAX_REQUESTS NUMBER := 1000; --2502849
10: /* Local Procedures */
11: /* Local procedure to check if a request exists for a given entity, request
12: return the result in p_request_search_result which is set to FND_API.G_TRUE
13: if the request exists. The index of the request in request table is returned
14: in parameter p_request_ind
15: */
16: /* BUG 2502849-

Line 27: If the request does NOT exist, then x_result is set to FND_API.G_FALSE

23: generated sequentially). Therefore, this check would search only
24: through requests for the entity_id that resolves to the same
25: mod value.
26:
27: If the request does NOT exist, then x_result is set to FND_API.G_FALSE
28: and the parameter x_request_ind has the index value where this request
29: should be inserted.
30: */
31: Procedure Check_for_Request( p_entity_code in Varchar2

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: IS
43: l_ind pls_integer;
44: l_max_ind pls_integer;
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: x_result := FND_API.G_FALSE;
48:
49: oe_debug_pub.add('Entering Procedure Check_for_Request in Package QP_Delayed_Requests_Pvt');
50:

Line 47: x_result := FND_API.G_FALSE;

43: l_ind pls_integer;
44: l_max_ind pls_integer;
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: x_result := FND_API.G_FALSE;
48:
49: oe_debug_pub.add('Entering Procedure Check_for_Request in Package QP_Delayed_Requests_Pvt');
50:
51: -- 2502849 l_ind to l_max_ind is the range of index positions that can

Line 80: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =

76: G_Delayed_Requests(l_ind).Entity_id = p_entity_id
77: AND
78: G_Delayed_Requests(l_ind).Request_Type = p_request_type
79: AND
80: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
81: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
82: AND
83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)

Line 81: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)

77: AND
78: G_Delayed_Requests(l_ind).Request_Type = p_request_type
79: AND
80: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
81: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
82: AND
83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
85: AND

Line 83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =

79: AND
80: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
81: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
82: AND
83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
85: AND
86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)

Line 84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)

80: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
81: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
82: AND
83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
85: AND
86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
88: AND

Line 86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =

82: AND
83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
85: AND
86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
88: AND
89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)

Line 87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)

83: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
84: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
85: AND
86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
88: AND
89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
91: AND

Line 89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =

85: AND
86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
88: AND
89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
91: AND
92: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
93: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)

Line 90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)

86: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
87: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
88: AND
89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
91: AND
92: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
93: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
94: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N' -- added for 2502849

Line 92: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =

88: AND
89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
91: AND
92: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
93: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
94: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N' -- added for 2502849
95: THEN
96: x_request_ind := l_ind;

Line 93: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)

89: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
90: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
91: AND
92: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
93: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
94: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N' -- added for 2502849
95: THEN
96: x_request_ind := l_ind;
97: x_result := FND_API.G_TRUE;

Line 97: x_result := FND_API.G_TRUE;

93: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
94: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N' -- added for 2502849
95: THEN
96: x_request_ind := l_ind;
97: x_result := FND_API.G_TRUE;
98: EXIT;
99: END IF;
100:
101: l_ind := G_Delayed_Requests.Next(l_ind);

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

106:
107: IF x_request_ind > l_max_ind THEN
108: FND_MESSAGE.SET_NAME('QP','QP_MAX_REQUESTS_EXCEEDED');
109: OE_MSG_PUB.ADD;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: END IF;
112: EXCEPTION
113: WHEN OTHERS THEN
114: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

117: (G_PKG_NAME
118: ,'CheckForRequest');
119: END IF;
120:
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122:
123: End Check_For_Request;
124:
125: PROCEDURE Process_Request_Pvt

Line 127: ,p_delete IN Varchar2 default FND_API.G_FALSE

123: End Check_For_Request;
124:
125: PROCEDURE Process_Request_Pvt
126: (p_request_ind IN Number
127: ,p_delete IN Varchar2 default FND_API.G_FALSE
128: ,x_return_status OUT NOCOPY VARCHAR2)
129: IS
130: l_request_rec QP_QUALIFIER_RULES_PUB.request_rec_type;
131: l_request_type VARCHAR2(30);

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150:
151: oe_debug_pub.add('Entering Procedure Process_Request_Pvt ');
152: --dbms_output.put_line('Entering Procedure Process_Request_Pvt ');
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: oe_debug_pub.add('Request processed '||G_Delayed_Requests(p_request_ind).processed);
157:
158: -- if request has already been processed ('Y') or if the request is

Line 193: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

189:
190:
191: END IF;
192:
193: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;

Line 194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

190:
191: END IF;
192:
193: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:

Line 195: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

191: END IF;
192:
193: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: -- Start bug2091362

Line 196: RAISE FND_API.G_EXC_ERROR;

192:
193: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: -- Start bug2091362
200: IF l_request_type = 'DUPLICATE_MODIFIER_LINES'

Line 217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

213:
214:
215: END IF;
216:
217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214:
215: END IF;
216:
217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:

Line 219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

215: END IF;
216:
217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:
223: -- end bug2091362

Line 220: RAISE FND_API.G_EXC_ERROR;

216:
217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:
223: -- end bug2091362
224:

Line 242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

238:
239:
240: END IF;
241:
242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239:
240: END IF;
241:
242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:

Line 244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

240: END IF;
241:
242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248:

Line 245: RAISE FND_API.G_EXC_ERROR;

241:
242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248:
249: IF l_request_type = 'MAINTAIN_LIST_HEADER_PHASES'

Line 259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

255: , x_return_status => l_return_status);
256:
257: END IF;
258:
259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256:
257: END IF;
258:
259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:

Line 261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

257: END IF;
258:
259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265:

Line 262: RAISE FND_API.G_EXC_ERROR;

258:
259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265:
266: IF l_request_type = 'VALIDATE_LINES_FOR_CHILD'

Line 277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

273: , x_return_status => l_return_status);
274:
275: END IF;
276:
277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274:
275: END IF;
276:
277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:

Line 279: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

275: END IF;
276:
277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:
283:

Line 280: RAISE FND_API.G_EXC_ERROR;

276:
277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:
283:
284: IF l_request_type = QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS

Line 292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

288: p_parent_list_line_id => l_request_rec.param1,
289: x_return_status => l_return_status);
290: END IF;
291:
292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: x_return_status => l_return_status);
290: END IF;
291:
292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:

Line 294: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

290: END IF;
291:
292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:
298:

Line 295: RAISE FND_API.G_EXC_ERROR;

291:
292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:
298:
299: IF l_request_type = QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS

Line 307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

303: x_return_status => l_return_status,
304: p_qualifier_rule_id => l_request_rec.param1);
305: END IF;
306:
307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;

Line 308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

304: p_qualifier_rule_id => l_request_rec.param1);
305: END IF;
306:
307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:

Line 309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

305: END IF;
306:
307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313:

Line 310: RAISE FND_API.G_EXC_ERROR;

306:
307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313:
314: IF l_request_type = 'OVERLAPPING_BREAKS'

Line 332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

328: END IF;
329:
330: END IF;
331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

329:
330: END IF;
331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:

Line 334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

330: END IF;
331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: IF l_request_type = QP_Globals.G_UPGRADE_PRICE_BREAKS

Line 335: RAISE FND_API.G_EXC_ERROR;

331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: IF l_request_type = QP_Globals.G_UPGRADE_PRICE_BREAKS
339: THEN

Line 351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

347: ,p_end_date_active => l_request_rec.param6
348: ,x_return_status => l_return_status);
349: END IF;
350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;

Line 352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

348: ,x_return_status => l_return_status);
349: END IF;
350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:

Line 353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

349: END IF;
350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: IF l_request_type = 'SINGLE_PRICE_LIST'

Line 354: RAISE FND_API.G_EXC_ERROR;

350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: IF l_request_type = 'SINGLE_PRICE_LIST'
358: THEN

Line 367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

363: ,x_return_status => l_return_status);
364:
365: END IF;
366:
367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

364:
365: END IF;
366:
367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:

Line 369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

365: END IF;
366:
367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373:

Line 370: RAISE FND_API.G_EXC_ERROR;

366:
367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373:
374: IF l_request_type = QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS

Line 381: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

377: p_list_header_id => l_entity_id,
378: x_return_status => l_return_status);
379: END IF;
380:
381: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

378: x_return_status => l_return_status);
379: END IF;
380:
381: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:

Line 383: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

379: END IF;
380:
381: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: IF l_request_type = QP_GLOBALS.G_UPDATE_LIST_QUAL_IND

Line 384: RAISE FND_API.G_EXC_ERROR;

380:
381: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: IF l_request_type = QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
388: THEN

Line 396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

392: ( p_List_header_ID => l_entity_id
393: ,x_return_status => l_return_status);
394: END IF;
395:
396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;

Line 397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

393: ,x_return_status => l_return_status);
394: END IF;
395:
396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:

Line 398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

394: END IF;
395:
396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: IF l_request_type = QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS

Line 399: RAISE FND_API.G_EXC_ERROR;

395:
396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: IF l_request_type = QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
403: THEN

Line 411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

407: ( p_Limit_Id => l_entity_id
408: ,x_return_status => l_return_status);
409: END IF;
410:
411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: ,x_return_status => l_return_status);
409: END IF;
410:
411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:

Line 413: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

409: END IF;
410:
411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: IF l_request_type = QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS

Line 414: RAISE FND_API.G_EXC_ERROR;

410:
411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: IF l_request_type = QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
418: THEN

Line 426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

422: ,p_active_flag => l_request_rec.param1
423: ,x_return_status => l_return_status);
424: END IF;
425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: ,x_return_status => l_return_status);
424: END IF;
425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:

Line 428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

424: END IF;
425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: IF l_request_type = QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE

Line 429: RAISE FND_API.G_EXC_ERROR;

425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: IF l_request_type = QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
433: THEN

Line 441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

437: ,p_list_type_code => l_request_rec.param1
438: ,x_return_status => l_return_status);
439: END IF;
440:
441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

438: ,x_return_status => l_return_status);
439: END IF;
440:
441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:

Line 443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

439: END IF;
440:
441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: IF l_request_type = QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS

Line 444: RAISE FND_API.G_EXC_ERROR;

440:
441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: IF l_request_type = QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
448: THEN

Line 459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

455: ,p_segment_mapping_column => l_request_rec.param4
456: ,x_return_status => l_return_status);
457: END IF;
458:
459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: ,x_return_status => l_return_status);
457: END IF;
458:
459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:

Line 461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

457: END IF;
458:
459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465:

Line 462: RAISE FND_API.G_EXC_ERROR;

458:
459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465:
466: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_BREAKS

Line 473: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

469: p_list_line_id => l_entity_id,
470: x_return_status => l_return_status);
471: END IF;
472:
473: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: x_return_status => l_return_status);
471: END IF;
472:
473: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:

Line 475: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

471: END IF;
472:
473: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:
479: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_PRICING_ATTR

Line 476: RAISE FND_API.G_EXC_ERROR;

472:
473: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:
479: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_PRICING_ATTR
480: THEN

Line 486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

482: x_return_status => l_return_status,
483: p_list_line_id => l_entity_id);
484: END IF;
485:
486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: p_list_line_id => l_entity_id);
484: END IF;
485:
486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:

Line 488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

484: END IF;
485:
486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/

Line 489: RAISE FND_API.G_EXC_ERROR;

485:
486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/
493:

Line 512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

508: x_return_status => l_return_status);
509: END IF;
510: END IF;
511:
512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509: END IF;
510: END IF;
511:
512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:

Line 514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

510: END IF;
511:
512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: --Added by rchellam on 29-AUG-2001. POSCO Change.

Line 515: RAISE FND_API.G_EXC_ERROR;

511:
512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: --Added by rchellam on 29-AUG-2001. POSCO Change.
519: IF l_request_type = QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS

Line 526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

522: p_list_line_id => l_entity_id,
523: x_return_status => l_return_status);
524: END IF;
525:
526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;

Line 527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

523: x_return_status => l_return_status);
524: END IF;
525:
526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:

Line 528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

524: END IF;
525:
526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:
532: /*fix for bug 1501138*/

Line 529: RAISE FND_API.G_EXC_ERROR;

525:
526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:
532: /*fix for bug 1501138*/
533: IF l_request_type = QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP

Line 551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

547: oe_debug_pub.add('after qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param3);
548: null;
549: END IF;
550:
551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;

Line 552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

548: null;
549: END IF;
550:
551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:

Line 553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

549: END IF;
550:
551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:
557:

Line 554: RAISE FND_API.G_EXC_ERROR;

550:
551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:
557:
558: IF l_request_type = QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

Line 567: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

563: ( p_List_line_ID => l_entity_id
564: ,x_return_status => l_return_status);
565: END IF;
566:
567: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;

Line 568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

564: ,x_return_status => l_return_status);
565: END IF;
566:
567: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572:

Line 569: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

565: END IF;
566:
567: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572:
573: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/

Line 570: RAISE FND_API.G_EXC_ERROR;

566:
567: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572:
573: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
574:

Line 586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

582: p_call_from => l_request_rec.param4,
583: x_return_status => l_return_status);
584: END IF;
585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;

Line 587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

583: x_return_status => l_return_status);
584: END IF;
585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:

Line 588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

584: END IF;
585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: -- Essilor Fix bug 2789138

Line 589: RAISE FND_API.G_EXC_ERROR;

585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: -- Essilor Fix bug 2789138
593: IF l_request_type = QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG

Line 602: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

598: p_automatic_flag => l_request_rec.param2,
599: x_return_status => l_return_status);
600: END IF;
601:
602: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

599: x_return_status => l_return_status);
600: END IF;
601:
602: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:

Line 604: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

600: END IF;
601:
602: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
608: --hvop

Line 605: RAISE FND_API.G_EXC_ERROR;

601:
602: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
608: --hvop
609: IF l_request_type = QP_GLOBALS.G_UPDATE_HVOP

Line 615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

611: oe_debug_pub.add('processing req UPDATE_HVOP');
612: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup (x_return_status => l_return_status);
613: END IF;
614:
615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;

Line 616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

612: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup (x_return_status => l_return_status);
613: END IF;
614:
615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: --hvop

Line 617: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

613: END IF;
614:
615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: --hvop
621:

Line 618: RAISE FND_API.G_EXC_ERROR;

614:
615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: --hvop
621:
622: --pattern

Line 633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

629: , p_qualifier_group => l_request_rec.request_unique_key1
630: , p_setup_action => l_request_rec.request_unique_key2
631: , x_return_status => l_return_status);
632: END IF;
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: , p_setup_action => l_request_rec.request_unique_key2
631: , x_return_status => l_return_status);
632: END IF;
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN

Line 635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

631: , x_return_status => l_return_status);
632: END IF;
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
639: oe_debug_pub.add('Processing req Attribute Groups');

Line 636: RAISE FND_API.G_EXC_ERROR;

632: END IF;
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
639: oe_debug_pub.add('Processing req Attribute Groups');
640: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(

Line 647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

643: , p_qualifier_group => l_request_rec.request_unique_key2
644: , p_setup_action => l_request_rec.request_unique_key3
645: , x_return_status => l_return_status);
646: END IF;
647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;

Line 648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

644: , p_setup_action => l_request_rec.request_unique_key3
645: , x_return_status => l_return_status);
646: END IF;
647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652:

Line 649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

645: , x_return_status => l_return_status);
646: END IF;
647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652:
653: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN

Line 650: RAISE FND_API.G_EXC_ERROR;

646: END IF;
647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652:
653: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
654: oe_debug_pub.add('Processing req Attribute Groups');

Line 661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

657: , p_list_line_id => l_request_rec.request_unique_key1
658: , p_setup_action => l_request_rec.request_unique_key2
659: , x_return_status => l_return_status);
660: END IF;
661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: , p_setup_action => l_request_rec.request_unique_key2
659: , x_return_status => l_return_status);
660: END IF;
661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:

Line 663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

659: , x_return_status => l_return_status);
660: END IF;
661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: END IF; --Java Engine Installed

Line 664: RAISE FND_API.G_EXC_ERROR;

660: END IF;
661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: END IF; --Java Engine Installed
668:

Line 680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

676: p_to_currency_code => l_request_rec.param1,
677: x_return_status => l_return_status);
678: END IF;
679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;

Line 681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

677: x_return_status => l_return_status);
678: END IF;
679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:

Line 682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

678: END IF;
679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686:

Line 683: RAISE FND_API.G_EXC_ERROR;

679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686:
687: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP

Line 697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

693: p_qualifier_grouping_no => l_request_rec.request_unique_key2,
694: x_return_status => l_return_status);
695: END IF;
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

694: x_return_status => l_return_status);
695: END IF;
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:

Line 699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

695: END IF;
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL

Line 700: RAISE FND_API.G_EXC_ERROR;

696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
704: THEN

Line 712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

708: p_list_line_id => l_request_rec.request_unique_key1,
709: x_return_status => l_return_status);
710: END IF;
711:
712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;

Line 713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

709: x_return_status => l_return_status);
710: END IF;
711:
712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:

Line 714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

710: END IF;
711:
712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:
718: -- Hierarchical Categories (sfiresto)

Line 715: RAISE FND_API.G_EXC_ERROR;

711:
712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:
718: -- Hierarchical Categories (sfiresto)
719: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN

Line 726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

722: p_pte_source_system_id => l_entity_id,
723: x_return_status => l_return_status);
724: END IF;
725:
726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;

Line 727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

723: x_return_status => l_return_status);
724: END IF;
725:
726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:

Line 728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

724: END IF;
725:
726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:
732:

Line 729: RAISE FND_API.G_EXC_ERROR;

725:
726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:
732:
733: --hw

Line 775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

771: --hvop
772: end if;
773: end if;
774:
775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;

Line 776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

772: end if;
773: end if;
774:
775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:

Line 777: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

773: end if;
774:
775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:
781:

Line 778: RAISE FND_API.G_EXC_ERROR;

774:
775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:
781:
782: IF (p_delete = FND_API.G_TRUE) then

Line 782: IF (p_delete = FND_API.G_TRUE) then

778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:
781:
782: IF (p_delete = FND_API.G_TRUE) then
783:
784: G_Delayed_Requests.Delete(p_request_ind);
785: /*
786: BUG 2502849- do not delete from req entities table

Line 815: WHEN FND_API.G_EXC_ERROR THEN

811:
812:
813: EXCEPTION
814:
815: WHEN FND_API.G_EXC_ERROR THEN
816: G_Delayed_Requests(p_request_ind).processed := 'N';
817: x_return_status := FND_API.G_RET_STS_ERROR;
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813: EXCEPTION
814:
815: WHEN FND_API.G_EXC_ERROR THEN
816: G_Delayed_Requests(p_request_ind).processed := 'N';
817: x_return_status := FND_API.G_RET_STS_ERROR;
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: G_Delayed_Requests(p_request_ind).processed := 'N';
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

815: WHEN FND_API.G_EXC_ERROR THEN
816: G_Delayed_Requests(p_request_ind).processed := 'N';
817: x_return_status := FND_API.G_RET_STS_ERROR;
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: G_Delayed_Requests(p_request_ind).processed := 'N';
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: WHEN NO_DATA_FOUND THEN

Line 821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

817: x_return_status := FND_API.G_RET_STS_ERROR;
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: G_Delayed_Requests(p_request_ind).processed := 'N';
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: WHEN NO_DATA_FOUND THEN
824: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
825: G_Delayed_Requests(p_request_ind).processed := 'N';

Line 826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

822:
823: WHEN NO_DATA_FOUND THEN
824: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
825: G_Delayed_Requests(p_request_ind).processed := 'N';
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
827:
828:
829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
830: THEN

Line 839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

835: END IF;
836:
837: WHEN OTHERS THEN
838: G_Delayed_Requests(p_request_ind).processed := 'N';
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840:
841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
842: THEN
843: OE_MSG_PUB.Add_Exc_Msg

Line 944: x_return_status := FND_API.G_RET_STS_SUCCESS;

940: l_request.param25 := p_param25;
941: l_request.long_param1 := p_long_param1;
942:
943: -- Initialize the return variable
944: x_return_status := FND_API.G_RET_STS_SUCCESS;
945: IF p_entity_id IS NOT NULL THEN --2650093
946: Check_For_Request(p_entity_code,
947: p_entity_id,
948: p_request_type,

Line 958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

954: l_request_ind,
955: l_request_search_rslt,
956: l_return_status);
957:
958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;

Line 959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

955: l_request_search_rslt,
956: l_return_status);
957:
958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:

Line 960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

956: l_return_status);
957:
958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: l_request.processed := 'N';

Line 961: RAISE FND_API.G_EXC_ERROR;

957:
958: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
960: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: l_request.processed := 'N';
965: IF l_request_search_rslt = FND_API.g_true -- replace the request

Line 965: IF l_request_search_rslt = FND_API.g_true -- replace the request

961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: l_request.processed := 'N';
965: IF l_request_search_rslt = FND_API.g_true -- replace the request
966: THEN
967: OE_Debug_PUB.ADD('Request replaced');
968: g_delayed_requests(l_request_ind) := l_request;
969:

Line 989: WHEN FND_API.G_EXC_ERROR THEN

985: oe_debug_pub.add('end of log request');
986:
987: EXCEPTION
988:
989: WHEN FND_API.G_EXC_ERROR THEN
990:
991: x_return_status := FND_API.G_RET_STS_ERROR;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 991: x_return_status := FND_API.G_RET_STS_ERROR;

987: EXCEPTION
988:
989: WHEN FND_API.G_EXC_ERROR THEN
990:
991: x_return_status := FND_API.G_RET_STS_ERROR;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994:
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

989: WHEN FND_API.G_EXC_ERROR THEN
990:
991: x_return_status := FND_API.G_RET_STS_ERROR;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994:
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996:
997: WHEN OTHERS THEN

Line 995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

991: x_return_status := FND_API.G_RET_STS_ERROR;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994:
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996:
997: WHEN OTHERS THEN
998: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
999: THEN

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: OE_MSG_PUB.Add_Exc_Msg
1001: (G_PKG_NAME
1002: ,'LOGREQUEST');
1003: END IF;
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: End Log_Request;
1007:
1008:

Line 1037: if x_result = FND_API.G_TRUE then

1033: ,x_request_ind => l_ind
1034: ,x_result => x_result
1035: ,x_return_status => x_return_status);
1036:
1037: if x_result = FND_API.G_TRUE then
1038: return(TRUE);
1039: else
1040: return(FALSE);
1041: end if;

Line 1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

1063: BEGIN
1064:
1065: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');
1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068: IF p_entity_id IS NOT NULL THEN --2650093
1069: Check_for_Request( p_entity_code => p_entity_code
1070: ,p_entity_id => p_entity_id
1071: ,p_request_type => p_request_type

Line 1082: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1078: ,x_result => l_request_search_rslt
1079: ,x_return_status => l_return_status);
1080:
1081:
1082: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;

Line 1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1079: ,x_return_status => l_return_status);
1080:
1081:
1082: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087:

Line 1084: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1080:
1081:
1082: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087:
1088: if l_request_search_rslt = FND_API.G_TRUE -- delete the request

Line 1085: RAISE FND_API.G_EXC_ERROR;

1081:
1082: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087:
1088: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
1089: then

Line 1088: if l_request_search_rslt = FND_API.G_TRUE -- delete the request

1084: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087:
1088: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
1089: then
1090: G_Delayed_Requests.Delete(l_request_ind);
1091:
1092: /* BUG 2502849- do not delete from req entities table

Line 1112: WHEN FND_API.G_EXC_ERROR THEN

1108: end if;
1109: END IF; --2650093
1110: EXCEPTION
1111:
1112: WHEN FND_API.G_EXC_ERROR THEN
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR;

1110: EXCEPTION
1111:
1112: WHEN FND_API.G_EXC_ERROR THEN
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1117:
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1112: WHEN FND_API.G_EXC_ERROR THEN
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1117:
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119:
1120: when others THEN

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1117:
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119:
1120: when others THEN
1121:
1122: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1128: x_return_status := FND_API.G_RET_STS_ERROR;

1124: (G_PKG_NAME
1125: ,'DeleteRequest');
1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129:
1130: End Delete_Request;
1131:
1132: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)

Line 1138: x_return_status := FND_API.G_RET_STS_SUCCESS;

1134: BEGIN
1135:
1136: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');
1137:
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139:
1140: G_Delayed_Requests.DELETE;
1141: g_requesting_entities.DELETE;
1142:

Line 1153: x_return_status := FND_API.G_RET_STS_ERROR;

1149: (G_PKG_NAME
1150: ,'Clear_Request');
1151: END IF;
1152:
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154:
1155: End Clear_Request;
1156:
1157: Procedure Process_Request( p_entity_code IN VARCHAR2

Line 1166: FND_API.G_TRUE

1162: ,p_request_unique_key3 IN VARCHAR2 := NULL
1163: ,p_request_unique_key4 IN VARCHAR2 := NULL
1164: ,p_request_unique_key5 IN VARCHAR2 := NULL
1165: ,p_delete IN Varchar2 Default
1166: FND_API.G_TRUE
1167: ,x_return_status OUT NOCOPY Varchar2)
1168: IS
1169: l_request_ind Number;
1170: l_request_search_rslt Varchar2(30);

Line 1173: x_return_status := FND_API.G_RET_STS_SUCCESS;

1169: l_request_ind Number;
1170: l_request_search_rslt Varchar2(30);
1171: l_return_status Varchar2(30);
1172: Begin
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:
1175: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');
1176: IF p_entity_id IS NOT NULL THEN --2650093
1177: Check_for_Request( p_entity_code => p_entity_code

Line 1189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1185: ,x_request_ind => l_request_ind
1186: ,x_result => l_request_search_rslt
1187: ,x_return_status => l_return_status);
1188:
1189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;

Line 1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1186: ,x_result => l_request_search_rslt
1187: ,x_return_status => l_return_status);
1188:
1189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194:

Line 1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1187: ,x_return_status => l_return_status);
1188:
1189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194:
1195: if l_request_search_rslt = FND_API.G_TRUE then

Line 1192: RAISE FND_API.G_EXC_ERROR;

1188:
1189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194:
1195: if l_request_search_rslt = FND_API.G_TRUE then
1196: Process_Request_Pvt

Line 1195: if l_request_search_rslt = FND_API.G_TRUE then

1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194:
1195: if l_request_search_rslt = FND_API.G_TRUE then
1196: Process_Request_Pvt
1197: (p_request_ind => l_request_ind
1198: ,p_delete => p_delete
1199: ,x_return_status => l_return_status

Line 1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1199: ,x_return_status => l_return_status
1200: );
1201: end if;
1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

Line 1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1200: );
1201: end if;
1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END IF; --2650093

Line 1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1201: end if;
1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END IF; --2650093
1209: EXCEPTION

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: END IF; --2650093
1209: EXCEPTION
1210:

Line 1211: WHEN FND_API.G_EXC_ERROR THEN

1207: END IF;
1208: END IF; --2650093
1209: EXCEPTION
1210:
1211: WHEN FND_API.G_EXC_ERROR THEN
1212:
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1213: x_return_status := FND_API.G_RET_STS_ERROR;

1209: EXCEPTION
1210:
1211: WHEN FND_API.G_EXC_ERROR THEN
1212:
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1211: WHEN FND_API.G_EXC_ERROR THEN
1212:
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: WHEN OTHERS THEN

Line 1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: WHEN OTHERS THEN
1220:
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: WHEN OTHERS THEN
1220:
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222:
1223: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1224: THEN
1225: OE_MSG_PUB.Add_Exc_Msg

Line 1236: ,p_delete in Varchar2 Default FND_API.G_TRUE

1232:
1233:
1234: Procedure Process_Request_for_Entity
1235: ( p_entity_code in Varchar2
1236: ,p_delete in Varchar2 Default FND_API.G_TRUE
1237: ,x_return_status OUT NOCOPY Varchar2) IS
1238: l_return_status Varchar2(30);
1239: l_ind Number;
1240: Begin

Line 1241: x_return_status := FND_API.G_RET_STS_SUCCESS;

1237: ,x_return_status OUT NOCOPY Varchar2) IS
1238: l_return_status Varchar2(30);
1239: l_ind Number;
1240: Begin
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1244: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1245: --dbms_output.put_line('entity id is ' ||p_entity_code);

Line 1269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1265: ,p_delete => p_delete
1266: ,x_return_status => l_return_status
1267: );
1268:
1269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266: ,x_return_status => l_return_status
1267: );
1268:
1269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274: --EXIT;

Line 1271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1267: );
1268:
1269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274: --EXIT;
1275: END IF;

Line 1272: RAISE FND_API.G_EXC_ERROR;

1268:
1269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274: --EXIT;
1275: END IF;
1276: l_ind := G_Delayed_Requests.Next(l_ind);

Line 1283: WHEN FND_API.G_EXC_ERROR THEN

1279: --dbms_output.put_line('Exiting Process_Request_for_Entity ');
1280:
1281: EXCEPTION
1282:
1283: WHEN FND_API.G_EXC_ERROR THEN
1284:
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1285: x_return_status := FND_API.G_RET_STS_ERROR;

1281: EXCEPTION
1282:
1283: WHEN FND_API.G_EXC_ERROR THEN
1284:
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288:
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1283: WHEN FND_API.G_EXC_ERROR THEN
1284:
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288:
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290:
1291: WHEN OTHERS THEN

Line 1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288:
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290:
1291: WHEN OTHERS THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290:
1291: WHEN OTHERS THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294:
1295: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1296: THEN
1297: OE_MSG_PUB.Add_Exc_Msg

Line 1309: ,p_delete in Varchar2 Default FND_API.G_TRUE

1305: End Process_Request_for_Entity;
1306:
1307: Procedure Process_Request_for_ReqType
1308: ( p_request_type in Varchar2
1309: ,p_delete in Varchar2 Default FND_API.G_TRUE
1310: ,x_return_status OUT NOCOPY Varchar2
1311: ) IS
1312: l_return_status Varchar2(30);
1313: l_ind Number;

Line 1315: x_return_status := FND_API.G_RET_STS_SUCCESS;

1311: ) IS
1312: l_return_status Varchar2(30);
1313: l_ind Number;
1314: Begin
1315: x_return_status := FND_API.G_RET_STS_SUCCESS;
1316:
1317: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');
1318:
1319: l_ind := G_Delayed_Requests.first;

Line 1329: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1325: ,p_delete => p_delete
1326: ,x_return_status => l_return_status
1327: );
1328:
1329: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;

Line 1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1326: ,x_return_status => l_return_status
1327: );
1328:
1329: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: END IF;

Line 1331: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1327: );
1328:
1329: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: END IF;
1335: l_ind := G_Delayed_Requests.Next(l_ind);

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328:
1329: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: END IF;
1335: l_ind := G_Delayed_Requests.Next(l_ind);
1336: END LOOP;

Line 1340: WHEN FND_API.G_EXC_ERROR THEN

1336: END LOOP;
1337:
1338: EXCEPTION
1339:
1340: WHEN FND_API.G_EXC_ERROR THEN
1341:
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343:
1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338: EXCEPTION
1339:
1340: WHEN FND_API.G_EXC_ERROR THEN
1341:
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343:
1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1345:
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1340: WHEN FND_API.G_EXC_ERROR THEN
1341:
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343:
1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1345:
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1347:
1348: WHEN OTHERS THEN

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343:
1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1345:
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1347:
1348: WHEN OTHERS THEN
1349:
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1347:
1348: WHEN OTHERS THEN
1349:
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1351:
1352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1353: THEN
1354: OE_MSG_PUB.Add_Exc_Msg

Line 1379: ,p_delete => FND_API.G_TRUE

1375:
1376: -- start bug2091362
1377: Process_Request_for_ReqType
1378: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1378: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;

Line 1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:

Line 1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: -- end bug2091362

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: -- end bug2091362
1389:

Line 1393: ,p_delete => FND_API.G_TRUE

1389:
1390:
1391: Process_Request_for_ReqType
1392: (p_request_type =>QP_GLOBALS.G_DUPLICATE_LIST_LINES
1393: ,p_delete => FND_API.G_TRUE
1394: ,x_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1392: (p_request_type =>QP_GLOBALS.G_DUPLICATE_LIST_LINES
1393: ,p_delete => FND_API.G_TRUE
1394: ,x_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1399: RAISE FND_API.G_EXC_ERROR;
1400: END IF;

Line 1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1393: ,p_delete => FND_API.G_TRUE
1394: ,x_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1399: RAISE FND_API.G_EXC_ERROR;
1400: END IF;
1401:

Line 1398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1394: ,x_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1399: RAISE FND_API.G_EXC_ERROR;
1400: END IF;
1401:
1402:

Line 1399: RAISE FND_API.G_EXC_ERROR;

1395: );
1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1399: RAISE FND_API.G_EXC_ERROR;
1400: END IF;
1401:
1402:
1403: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/

Line 1407: ,p_delete => FND_API.G_TRUE

1403: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/
1404:
1405: Process_Request_for_ReqType
1406: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
1407: ,p_delete => FND_API.G_TRUE
1408: ,x_return_status => l_return_status
1409: );
1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1406: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
1407: ,p_delete => FND_API.G_TRUE
1408: ,x_return_status => l_return_status
1409: );
1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;

Line 1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1407: ,p_delete => FND_API.G_TRUE
1408: ,x_return_status => l_return_status
1409: );
1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415:

Line 1412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1408: ,x_return_status => l_return_status
1409: );
1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415:
1416:

Line 1413: RAISE FND_API.G_EXC_ERROR;

1409: );
1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415:
1416:
1417: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/

Line 1421: ,p_delete => FND_API.G_TRUE

1417: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
1418:
1419: Process_Request_for_ReqType
1420: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1421: ,p_delete => FND_API.G_TRUE
1422: ,x_return_status => l_return_status
1423: );
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1420: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1421: ,p_delete => FND_API.G_TRUE
1422: ,x_return_status => l_return_status
1423: );
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;

Line 1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1421: ,p_delete => FND_API.G_TRUE
1422: ,x_return_status => l_return_status
1423: );
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:

Line 1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1422: ,x_return_status => l_return_status
1423: );
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:
1430: /*fix for bug 1501138*/

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423: );
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:
1430: /*fix for bug 1501138*/
1431: /*

Line 1434: ,p_delete => FND_API.G_TRUE

1430: /*fix for bug 1501138*/
1431: /*
1432: Process_Request_for_ReqType
1433: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1434: ,p_delete => FND_API.G_TRUE
1435: ,x_return_status => l_return_status
1436: );
1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1433: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1434: ,p_delete => FND_API.G_TRUE
1435: ,x_return_status => l_return_status
1436: );
1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;

Line 1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1434: ,p_delete => FND_API.G_TRUE
1435: ,x_return_status => l_return_status
1436: );
1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442:

Line 1439: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1435: ,x_return_status => l_return_status
1436: );
1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442:
1443: */

Line 1440: RAISE FND_API.G_EXC_ERROR;

1436: );
1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442:
1443: */
1444:

Line 1447: ,p_delete => FND_API.G_TRUE

1443: */
1444:
1445: Process_Request_for_ReqType
1446: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
1447: ,p_delete => FND_API.G_TRUE
1448: ,x_return_status => l_return_status
1449: );
1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1446: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
1447: ,p_delete => FND_API.G_TRUE
1448: ,x_return_status => l_return_status
1449: );
1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;

Line 1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1447: ,p_delete => FND_API.G_TRUE
1448: ,x_return_status => l_return_status
1449: );
1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455:

Line 1452: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1448: ,x_return_status => l_return_status
1449: );
1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455:
1456:

Line 1453: RAISE FND_API.G_EXC_ERROR;

1449: );
1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455:
1456:
1457: Process_Request_for_ReqType

Line 1459: ,p_delete => FND_API.G_TRUE

1455:
1456:
1457: Process_Request_for_ReqType
1458: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
1459: ,p_delete => FND_API.G_TRUE
1460: ,x_return_status => l_return_status
1461: );
1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1458: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
1459: ,p_delete => FND_API.G_TRUE
1460: ,x_return_status => l_return_status
1461: );
1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;

Line 1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1459: ,p_delete => FND_API.G_TRUE
1460: ,x_return_status => l_return_status
1461: );
1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:

Line 1464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1460: ,x_return_status => l_return_status
1461: );
1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1468:

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461: );
1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1468:
1469: Process_Request_for_ReqType

Line 1471: ,p_delete => FND_API.G_TRUE

1467:
1468:
1469: Process_Request_for_ReqType
1470: (p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1471: ,p_delete => FND_API.G_TRUE
1472: ,x_return_status => l_return_status
1473: );
1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1470: (p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1471: ,p_delete => FND_API.G_TRUE
1472: ,x_return_status => l_return_status
1473: );
1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;

Line 1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1471: ,p_delete => FND_API.G_TRUE
1472: ,x_return_status => l_return_status
1473: );
1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:

Line 1476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1472: ,x_return_status => l_return_status
1473: );
1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480:

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473: );
1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480:
1481: Process_Request_for_ReqType

Line 1483: ,p_delete => FND_API.G_TRUE

1479:
1480:
1481: Process_Request_for_ReqType
1482: (p_request_type =>QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS
1483: ,p_delete => FND_API.G_TRUE
1484: ,x_return_status => l_return_status
1485: );
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1482: (p_request_type =>QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS
1483: ,p_delete => FND_API.G_TRUE
1484: ,x_return_status => l_return_status
1485: );
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;

Line 1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1483: ,p_delete => FND_API.G_TRUE
1484: ,x_return_status => l_return_status
1485: );
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:

Line 1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1484: ,x_return_status => l_return_status
1485: );
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: Process_Request_for_ReqType

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: );
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: Process_Request_for_ReqType
1493: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND

Line 1494: ,p_delete => FND_API.G_TRUE

1490: END IF;
1491:
1492: Process_Request_for_ReqType
1493: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
1494: ,p_delete => FND_API.G_TRUE
1495: ,x_return_status => l_return_status
1496: );
1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1493: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
1494: ,p_delete => FND_API.G_TRUE
1495: ,x_return_status => l_return_status
1496: );
1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1499: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;

Line 1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1494: ,p_delete => FND_API.G_TRUE
1495: ,x_return_status => l_return_status
1496: );
1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1499: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502:

Line 1499: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1495: ,x_return_status => l_return_status
1496: );
1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1499: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502:
1503: Process_Request_for_ReqType

Line 1500: RAISE FND_API.G_EXC_ERROR;

1496: );
1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1499: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502:
1503: Process_Request_for_ReqType
1504: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

Line 1505: ,p_delete => FND_API.G_TRUE

1501: END IF;
1502:
1503: Process_Request_for_ReqType
1504: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1505: ,p_delete => FND_API.G_TRUE
1506: ,x_return_status => l_return_status
1507: );
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1504: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1505: ,p_delete => FND_API.G_TRUE
1506: ,x_return_status => l_return_status
1507: );
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;

Line 1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1505: ,p_delete => FND_API.G_TRUE
1506: ,x_return_status => l_return_status
1507: );
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:

Line 1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1506: ,x_return_status => l_return_status
1507: );
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:
1514: Process_Request_for_ReqType

Line 1511: RAISE FND_API.G_EXC_ERROR;

1507: );
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:
1514: Process_Request_for_ReqType
1515: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS

Line 1516: ,p_delete => FND_API.G_TRUE

1512: END IF;
1513:
1514: Process_Request_for_ReqType
1515: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
1516: ,p_delete => FND_API.G_TRUE
1517: ,x_return_status => l_return_status
1518: );
1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1515: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
1516: ,p_delete => FND_API.G_TRUE
1517: ,x_return_status => l_return_status
1518: );
1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;

Line 1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1516: ,p_delete => FND_API.G_TRUE
1517: ,x_return_status => l_return_status
1518: );
1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:

Line 1521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1517: ,x_return_status => l_return_status
1518: );
1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: Process_Request_for_ReqType

Line 1522: RAISE FND_API.G_EXC_ERROR;

1518: );
1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: Process_Request_for_ReqType
1526: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS

Line 1527: ,p_delete => FND_API.G_TRUE

1523: END IF;
1524:
1525: Process_Request_for_ReqType
1526: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
1527: ,p_delete => FND_API.G_TRUE
1528: ,x_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1526: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
1527: ,p_delete => FND_API.G_TRUE
1528: ,x_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;

Line 1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1527: ,p_delete => FND_API.G_TRUE
1528: ,x_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535:

Line 1532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1528: ,x_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535:
1536: Process_Request_for_ReqType

Line 1533: RAISE FND_API.G_EXC_ERROR;

1529: );
1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535:
1536: Process_Request_for_ReqType
1537: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE

Line 1538: ,p_delete => FND_API.G_TRUE

1534: END IF;
1535:
1536: Process_Request_for_ReqType
1537: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
1538: ,p_delete => FND_API.G_TRUE
1539: ,x_return_status => l_return_status
1540: );
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1537: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
1538: ,p_delete => FND_API.G_TRUE
1539: ,x_return_status => l_return_status
1540: );
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;

Line 1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1538: ,p_delete => FND_API.G_TRUE
1539: ,x_return_status => l_return_status
1540: );
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:

Line 1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1539: ,x_return_status => l_return_status
1540: );
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: Process_Request_for_ReqType

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: );
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: Process_Request_for_ReqType
1548: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS

Line 1549: ,p_delete => FND_API.G_TRUE

1545: END IF;
1546:
1547: Process_Request_for_ReqType
1548: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
1549: ,p_delete => FND_API.G_TRUE
1550: ,x_return_status => l_return_status
1551: );
1552: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1552: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1548: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
1549: ,p_delete => FND_API.G_TRUE
1550: ,x_return_status => l_return_status
1551: );
1552: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;

Line 1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1549: ,p_delete => FND_API.G_TRUE
1550: ,x_return_status => l_return_status
1551: );
1552: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:

Line 1554: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1550: ,x_return_status => l_return_status
1551: );
1552: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: Process_Request_for_ReqType

Line 1555: RAISE FND_API.G_EXC_ERROR;

1551: );
1552: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: Process_Request_for_ReqType
1559: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

Line 1560: ,p_delete => FND_API.G_TRUE

1556: END IF;
1557:
1558: Process_Request_for_ReqType
1559: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1560: ,p_delete => FND_API.G_TRUE
1561: ,x_return_status => l_return_status
1562: );
1563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1559: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1560: ,p_delete => FND_API.G_TRUE
1561: ,x_return_status => l_return_status
1562: );
1563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;

Line 1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1560: ,p_delete => FND_API.G_TRUE
1561: ,x_return_status => l_return_status
1562: );
1563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568:

Line 1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1561: ,x_return_status => l_return_status
1562: );
1563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568:
1569: Process_Request_for_ReqType

Line 1566: RAISE FND_API.G_EXC_ERROR;

1562: );
1563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568:
1569: Process_Request_for_ReqType
1570: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES

Line 1571: ,p_delete => FND_API.G_TRUE

1567: END IF;
1568:
1569: Process_Request_for_ReqType
1570: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES
1571: ,p_delete => FND_API.G_TRUE
1572: ,x_return_status => l_return_status
1573: );
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1570: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES
1571: ,p_delete => FND_API.G_TRUE
1572: ,x_return_status => l_return_status
1573: );
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;

Line 1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1571: ,p_delete => FND_API.G_TRUE
1572: ,x_return_status => l_return_status
1573: );
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:

Line 1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1572: ,x_return_status => l_return_status
1573: );
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580: Process_Request_for_ReqType

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573: );
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580: Process_Request_for_ReqType
1581: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS

Line 1582: ,p_delete => FND_API.G_TRUE

1578: END IF;
1579:
1580: Process_Request_for_ReqType
1581: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS
1582: ,p_delete => FND_API.G_TRUE
1583: ,x_return_status => l_return_status
1584: );
1585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1581: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS
1582: ,p_delete => FND_API.G_TRUE
1583: ,x_return_status => l_return_status
1584: );
1585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF;

Line 1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1582: ,p_delete => FND_API.G_TRUE
1583: ,x_return_status => l_return_status
1584: );
1585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF;
1590:

Line 1587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1583: ,x_return_status => l_return_status
1584: );
1585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF;
1590:
1591: -- mkarya for attribute manager

Line 1588: RAISE FND_API.G_EXC_ERROR;

1584: );
1585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF;
1590:
1591: -- mkarya for attribute manager
1592: Process_Request_for_ReqType

Line 1594: ,p_delete => FND_API.G_TRUE

1590:
1591: -- mkarya for attribute manager
1592: Process_Request_for_ReqType
1593: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
1594: ,p_delete => FND_API.G_TRUE
1595: ,x_return_status => l_return_status
1596: );
1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1593: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
1594: ,p_delete => FND_API.G_TRUE
1595: ,x_return_status => l_return_status
1596: );
1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;

Line 1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1594: ,p_delete => FND_API.G_TRUE
1595: ,x_return_status => l_return_status
1596: );
1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602:

Line 1599: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1595: ,x_return_status => l_return_status
1596: );
1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602:
1603: -- Hierarchical Categories (sfiresto)

Line 1600: RAISE FND_API.G_EXC_ERROR;

1596: );
1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602:
1603: -- Hierarchical Categories (sfiresto)
1604: Process_Request_for_ReqType

Line 1606: ,p_delete => FND_API.G_TRUE

1602:
1603: -- Hierarchical Categories (sfiresto)
1604: Process_Request_for_ReqType
1605: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS
1606: ,p_delete => FND_API.G_TRUE
1607: ,x_return_status => l_return_status
1608: );
1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1605: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS
1606: ,p_delete => FND_API.G_TRUE
1607: ,x_return_status => l_return_status
1608: );
1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1612: RAISE FND_API.G_EXC_ERROR;
1613: END IF;

Line 1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1606: ,p_delete => FND_API.G_TRUE
1607: ,x_return_status => l_return_status
1608: );
1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1612: RAISE FND_API.G_EXC_ERROR;
1613: END IF;
1614:

Line 1611: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1607: ,x_return_status => l_return_status
1608: );
1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1612: RAISE FND_API.G_EXC_ERROR;
1613: END IF;
1614:
1615:

Line 1612: RAISE FND_API.G_EXC_ERROR;

1608: );
1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1612: RAISE FND_API.G_EXC_ERROR;
1613: END IF;
1614:
1615:
1616: --hw

Line 1622: ,p_delete => FND_API.G_TRUE

1618: -- delayed request for changed lines
1619: if QP_PERF_PVT.enabled = 'Y' then
1620: Process_Request_for_ReqType
1621: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
1622: ,p_delete => FND_API.G_TRUE
1623: ,x_return_status => l_return_status
1624: );
1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1621: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
1622: ,p_delete => FND_API.G_TRUE
1623: ,x_return_status => l_return_status
1624: );
1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;

Line 1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1622: ,p_delete => FND_API.G_TRUE
1623: ,x_return_status => l_return_status
1624: );
1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;
1630:

Line 1627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1623: ,x_return_status => l_return_status
1624: );
1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;
1630:
1631: Process_Request_for_ReqType

Line 1628: RAISE FND_API.G_EXC_ERROR;

1624: );
1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;
1630:
1631: Process_Request_for_ReqType
1632: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL

Line 1633: ,p_delete => FND_API.G_TRUE

1629: END IF;
1630:
1631: Process_Request_for_ReqType
1632: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
1633: ,p_delete => FND_API.G_TRUE
1634: ,x_return_status => l_return_status
1635: );
1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1632: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
1633: ,p_delete => FND_API.G_TRUE
1634: ,x_return_status => l_return_status
1635: );
1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;

Line 1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1633: ,p_delete => FND_API.G_TRUE
1634: ,x_return_status => l_return_status
1635: );
1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;
1641:

Line 1638: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1634: ,x_return_status => l_return_status
1635: );
1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;
1641:
1642: Process_Request_for_ReqType

Line 1639: RAISE FND_API.G_EXC_ERROR;

1635: );
1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1638: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;
1641:
1642: Process_Request_for_ReqType
1643: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT

Line 1644: ,p_delete => FND_API.G_TRUE

1640: END IF;
1641:
1642: Process_Request_for_ReqType
1643: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
1644: ,p_delete => FND_API.G_TRUE
1645: ,x_return_status => l_return_status
1646: );
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1643: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
1644: ,p_delete => FND_API.G_TRUE
1645: ,x_return_status => l_return_status
1646: );
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;

Line 1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1644: ,p_delete => FND_API.G_TRUE
1645: ,x_return_status => l_return_status
1646: );
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:

Line 1649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1645: ,x_return_status => l_return_status
1646: );
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: Process_Request_for_ReqType

Line 1650: RAISE FND_API.G_EXC_ERROR;

1646: );
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: Process_Request_for_ReqType
1654: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH

Line 1655: ,p_delete => FND_API.G_TRUE

1651: END IF;
1652:
1653: Process_Request_for_ReqType
1654: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
1655: ,p_delete => FND_API.G_TRUE
1656: ,x_return_status => l_return_status
1657: );
1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1654: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
1655: ,p_delete => FND_API.G_TRUE
1656: ,x_return_status => l_return_status
1657: );
1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1660: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;

Line 1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1655: ,p_delete => FND_API.G_TRUE
1656: ,x_return_status => l_return_status
1657: );
1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1660: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663: end if;

Line 1660: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1656: ,x_return_status => l_return_status
1657: );
1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1660: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663: end if;
1664: oe_debug_pub.add('Ren: in process delayed request');

Line 1661: RAISE FND_API.G_EXC_ERROR;

1657: );
1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1660: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663: end if;
1664: oe_debug_pub.add('Ren: in process delayed request');
1665:

Line 1670: ,p_delete => FND_API.G_TRUE

1666: -- mkarya for pattern delayed requests
1667: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1668: Process_Request_for_ReqType
1669: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN
1670: ,p_delete => FND_API.G_TRUE
1671: ,x_return_status => l_return_status
1672: );
1673:
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1670: ,p_delete => FND_API.G_TRUE
1671: ,x_return_status => l_return_status
1672: );
1673:
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;

Line 1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1671: ,x_return_status => l_return_status
1672: );
1673:
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:

Line 1676: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1672: );
1673:
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: Process_Request_for_ReqType

Line 1677: RAISE FND_API.G_EXC_ERROR;

1673:
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: Process_Request_for_ReqType
1681: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN

Line 1682: ,p_delete => FND_API.G_TRUE

1678: END IF;
1679:
1680: Process_Request_for_ReqType
1681: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN
1682: ,p_delete => FND_API.G_TRUE
1683: ,x_return_status => l_return_status
1684: );
1685:
1686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1682: ,p_delete => FND_API.G_TRUE
1683: ,x_return_status => l_return_status
1684: );
1685:
1686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;

Line 1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1683: ,x_return_status => l_return_status
1684: );
1685:
1686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691:

Line 1688: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1684: );
1685:
1686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691:
1692: Process_Request_for_ReqType

Line 1689: RAISE FND_API.G_EXC_ERROR;

1685:
1686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691:
1692: Process_Request_for_ReqType
1693: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN

Line 1694: ,p_delete => FND_API.G_TRUE

1690: END IF;
1691:
1692: Process_Request_for_ReqType
1693: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN
1694: ,p_delete => FND_API.G_TRUE
1695: ,x_return_status => l_return_status
1696: );
1697:
1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1694: ,p_delete => FND_API.G_TRUE
1695: ,x_return_status => l_return_status
1696: );
1697:
1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;

Line 1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1695: ,x_return_status => l_return_status
1696: );
1697:
1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:

Line 1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1696: );
1697:
1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:
1704: END IF; --IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y'

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697:
1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:
1704: END IF; --IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y'
1705:

Line 1712: WHEN FND_API.G_EXC_ERROR THEN

1708: Clear_Request(x_return_status);
1709:
1710: EXCEPTION
1711:
1712: WHEN FND_API.G_EXC_ERROR THEN
1713:
1714: x_return_status := FND_API.G_RET_STS_ERROR;
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1714: x_return_status := FND_API.G_RET_STS_ERROR;

1710: EXCEPTION
1711:
1712: WHEN FND_API.G_EXC_ERROR THEN
1713:
1714: x_return_status := FND_API.G_RET_STS_ERROR;
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717:
1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1712: WHEN FND_API.G_EXC_ERROR THEN
1713:
1714: x_return_status := FND_API.G_RET_STS_ERROR;
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717:
1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1719:
1720: WHEN OTHERS THEN

Line 1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1714: x_return_status := FND_API.G_RET_STS_ERROR;
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717:
1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1719:
1720: WHEN OTHERS THEN
1721:
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1719:
1720: WHEN OTHERS THEN
1721:
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1723:
1724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1725: THEN
1726: OE_MSG_PUB.Add_Exc_Msg

Line 1747: x_return_status := FND_API.G_RET_STS_SUCCESS;

1743: BEGIN
1744:
1745:
1746:
1747: x_return_status := FND_API.G_RET_STS_SUCCESS;
1748:
1749:
1750: -- DELETING REQUESTS LOGGED AGAINST THIS ENTITY
1751:

Line 1825: WHEN FND_API.G_EXC_ERROR THEN

1821: END LOOP;
1822:
1823: EXCEPTION
1824:
1825: WHEN FND_API.G_EXC_ERROR THEN
1826:
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1827: x_return_status := FND_API.G_RET_STS_ERROR;

1823: EXCEPTION
1824:
1825: WHEN FND_API.G_EXC_ERROR THEN
1826:
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1830:
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1825: WHEN FND_API.G_EXC_ERROR THEN
1826:
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1830:
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1832:
1833: when others THEN

Line 1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1830:
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1832:
1833: when others THEN
1834:
1835: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1841: x_return_status := FND_API.G_RET_STS_ERROR;

1837: (G_PKG_NAME
1838: ,'Delete_Reqs_for_Deleted_Entity');
1839: END IF;
1840:
1841: x_return_status := FND_API.G_RET_STS_ERROR;
1842:
1843: End Delete_Reqs_for_Deleted_Entity;
1844:
1845: