eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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 696: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

692: , p_setup_action => l_request_rec.request_unique_key2
693: , x_return_status => l_return_status);
694: oe_debug_pub.ADD(' JAGAN 1 ENTITY CODE : ' || l_entity_code);
695: END IF;
696: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;

Line 697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

693: , x_return_status => l_return_status);
694: oe_debug_pub.ADD(' JAGAN 1 ENTITY CODE : ' || l_entity_code);
695: END IF;
696: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN

Line 698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

694: oe_debug_pub.ADD(' JAGAN 1 ENTITY CODE : ' || l_entity_code);
695: END IF;
696: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
702: oe_debug_pub.add('Processing req Attribute Groups');

Line 699: RAISE FND_API.G_EXC_ERROR;

695: END IF;
696: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
702: oe_debug_pub.add('Processing req Attribute Groups');
703: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(

Line 711: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

707: , p_setup_action => l_request_rec.request_unique_key3
708: , x_return_status => l_return_status);
709: oe_debug_pub.ADD(' JAGAN 2 ENTITY CODE : ' || l_entity_code);
710: END IF;
711: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;

Line 712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

708: , x_return_status => l_return_status);
709: oe_debug_pub.ADD(' JAGAN 2 ENTITY CODE : ' || l_entity_code);
710: END IF;
711: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:

Line 713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

709: oe_debug_pub.ADD(' JAGAN 2 ENTITY CODE : ' || l_entity_code);
710: END IF;
711: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN

Line 714: RAISE FND_API.G_EXC_ERROR;

710: END IF;
711: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
718: oe_debug_pub.add('Processing req Attribute Groups');

Line 726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

722: , p_setup_action => l_request_rec.request_unique_key2
723: , x_return_status => l_return_status);
724: oe_debug_pub.ADD('JAGAN 3 ENTITY CODE : ' || l_entity_code);
725: END IF;
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: oe_debug_pub.ADD('JAGAN 3 ENTITY CODE : ' || l_entity_code);
725: END IF;
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: oe_debug_pub.ADD('JAGAN 3 ENTITY CODE : ' || l_entity_code);
725: END IF;
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: END IF; --pl/sql pattern search profile on

Line 729: RAISE FND_API.G_EXC_ERROR;

725: END IF;
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: END IF; --pl/sql pattern search profile on
733: END IF; --Java Engine Installed

Line 745: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

741: p_to_currency_code => l_request_rec.param1,
742: x_return_status => l_return_status);
743: END IF;
744:
745: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;

Line 746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

742: x_return_status => l_return_status);
743: END IF;
744:
745: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750:

Line 747: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

743: END IF;
744:
745: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750:
751:

Line 748: RAISE FND_API.G_EXC_ERROR;

744:
745: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750:
751:
752: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP

Line 762: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

758: p_qualifier_grouping_no => l_request_rec.request_unique_key2,
759: x_return_status => l_return_status);
760: END IF;
761:
762: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;

Line 763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

759: x_return_status => l_return_status);
760: END IF;
761:
762: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:

Line 764: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

760: END IF;
761:
762: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL

Line 765: RAISE FND_API.G_EXC_ERROR;

761:
762: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
769: THEN

Line 777: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

773: p_list_line_id => l_request_rec.request_unique_key1,
774: x_return_status => l_return_status);
775: END IF;
776:
777: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;

Line 778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 779: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

775: END IF;
776:
777: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782:
783: -- Hierarchical Categories (sfiresto)

Line 780: RAISE FND_API.G_EXC_ERROR;

776:
777: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782:
783: -- Hierarchical Categories (sfiresto)
784: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN

Line 791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

787: p_pte_source_system_id => l_entity_id,
788: x_return_status => l_return_status);
789: END IF;
790:
791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: x_return_status => l_return_status);
789: END IF;
790:
791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:

Line 793: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

789: END IF;
790:
791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797:

Line 794: RAISE FND_API.G_EXC_ERROR;

790:
791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797:
798: --hw

Line 840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

836: --hvop
837: end if;
838: end if;
839:
840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: end if;
838: end if;
839:
840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:

Line 842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

838: end if;
839:
840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:
846:

Line 843: RAISE FND_API.G_EXC_ERROR;

839:
840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:
846:
847: IF (p_delete = FND_API.G_TRUE) then

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

843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:
846:
847: IF (p_delete = FND_API.G_TRUE) then
848:
849: G_Delayed_Requests.Delete(p_request_ind);
850: /*
851: BUG 2502849- do not delete from req entities table

Line 880: WHEN FND_API.G_EXC_ERROR THEN

876:
877:
878: EXCEPTION
879:
880: WHEN FND_API.G_EXC_ERROR THEN
881: G_Delayed_Requests(p_request_ind).processed := 'N';
882: x_return_status := FND_API.G_RET_STS_ERROR;
883:
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 882: x_return_status := FND_API.G_RET_STS_ERROR;

878: EXCEPTION
879:
880: WHEN FND_API.G_EXC_ERROR THEN
881: G_Delayed_Requests(p_request_ind).processed := 'N';
882: x_return_status := FND_API.G_RET_STS_ERROR;
883:
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: G_Delayed_Requests(p_request_ind).processed := 'N';
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

880: WHEN FND_API.G_EXC_ERROR THEN
881: G_Delayed_Requests(p_request_ind).processed := 'N';
882: x_return_status := FND_API.G_RET_STS_ERROR;
883:
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: G_Delayed_Requests(p_request_ind).processed := 'N';
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
887:
888: WHEN NO_DATA_FOUND THEN

Line 886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

882: x_return_status := FND_API.G_RET_STS_ERROR;
883:
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: G_Delayed_Requests(p_request_ind).processed := 'N';
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
887:
888: WHEN NO_DATA_FOUND THEN
889: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
890: G_Delayed_Requests(p_request_ind).processed := 'N';

Line 891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

887:
888: WHEN NO_DATA_FOUND THEN
889: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
890: G_Delayed_Requests(p_request_ind).processed := 'N';
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892:
893:
894: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN

Line 904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

900: END IF;
901:
902: WHEN OTHERS THEN
903: G_Delayed_Requests(p_request_ind).processed := 'N';
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
905:
906: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: OE_MSG_PUB.Add_Exc_Msg

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: l_request.param25 := p_param25;
1006: l_request.long_param1 := p_long_param1;
1007:
1008: -- Initialize the return variable
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: IF p_entity_id IS NOT NULL THEN --2650093
1011: Check_For_Request(p_entity_code,
1012: p_entity_id,
1013: p_request_type,

Line 1023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1019: l_request_ind,
1020: l_request_search_rslt,
1021: l_return_status);
1022:
1023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1020: l_request_search_rslt,
1021: l_return_status);
1022:
1023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:

Line 1025: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1021: l_return_status);
1022:
1023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:
1029: l_request.processed := 'N';

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022:
1023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:
1029: l_request.processed := 'N';
1030: IF l_request_search_rslt = FND_API.g_true -- replace the request

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

1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:
1029: l_request.processed := 'N';
1030: IF l_request_search_rslt = FND_API.g_true -- replace the request
1031: THEN
1032: OE_Debug_PUB.ADD('Request replaced');
1033: g_delayed_requests(l_request_ind) := l_request;
1034:

Line 1054: WHEN FND_API.G_EXC_ERROR THEN

1050: oe_debug_pub.add('end of log request');
1051:
1052: EXCEPTION
1053:
1054: WHEN FND_API.G_EXC_ERROR THEN
1055:
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: EXCEPTION
1053:
1054: WHEN FND_API.G_EXC_ERROR THEN
1055:
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059:
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1054: WHEN FND_API.G_EXC_ERROR THEN
1055:
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059:
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1061:
1062: WHEN OTHERS THEN

Line 1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059:
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1061:
1062: WHEN OTHERS THEN
1063: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1064: THEN

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: OE_MSG_PUB.Add_Exc_Msg
1066: (G_PKG_NAME
1067: ,'LOGREQUEST');
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: End Log_Request;
1072:
1073:

Line 1102: if x_result = FND_API.G_TRUE then

1098: ,x_request_ind => l_ind
1099: ,x_result => x_result
1100: ,x_return_status => x_return_status);
1101:
1102: if x_result = FND_API.G_TRUE then
1103: return(TRUE);
1104: else
1105: return(FALSE);
1106: end if;

Line 1132: x_return_status := FND_API.G_RET_STS_SUCCESS;

1128: BEGIN
1129:
1130: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');
1131:
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133: IF p_entity_id IS NOT NULL THEN --2650093
1134: Check_for_Request( p_entity_code => p_entity_code
1135: ,p_entity_id => p_entity_id
1136: ,p_request_type => p_request_type

Line 1147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1143: ,x_result => l_request_search_rslt
1144: ,x_return_status => l_return_status);
1145:
1146:
1147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1144: ,x_return_status => l_return_status);
1145:
1146:
1147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:

Line 1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1145:
1146:
1147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153: if l_request_search_rslt = FND_API.G_TRUE -- delete the request

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146:
1147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
1154: then

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

1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
1154: then
1155: G_Delayed_Requests.Delete(l_request_ind);
1156:
1157: /* BUG 2502849- do not delete from req entities table

Line 1177: WHEN FND_API.G_EXC_ERROR THEN

1173: end if;
1174: END IF; --2650093
1175: EXCEPTION
1176:
1177: WHEN FND_API.G_EXC_ERROR THEN
1178:
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1179: x_return_status := FND_API.G_RET_STS_ERROR;

1175: EXCEPTION
1176:
1177: WHEN FND_API.G_EXC_ERROR THEN
1178:
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1182:
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1177: WHEN FND_API.G_EXC_ERROR THEN
1178:
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1182:
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1184:
1185: when others THEN

Line 1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1182:
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1184:
1185: when others THEN
1186:
1187: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

1189: (G_PKG_NAME
1190: ,'DeleteRequest');
1191: END IF;
1192:
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: End Delete_Request;
1196:
1197: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)

Line 1203: x_return_status := FND_API.G_RET_STS_SUCCESS;

1199: BEGIN
1200:
1201: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');
1202:
1203: x_return_status := FND_API.G_RET_STS_SUCCESS;
1204:
1205: G_Delayed_Requests.DELETE;
1206: g_requesting_entities.DELETE;
1207:

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

1214: (G_PKG_NAME
1215: ,'Clear_Request');
1216: END IF;
1217:
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219:
1220: End Clear_Request;
1221:
1222: Procedure Process_Request( p_entity_code IN VARCHAR2

Line 1231: FND_API.G_TRUE

1227: ,p_request_unique_key3 IN VARCHAR2 := NULL
1228: ,p_request_unique_key4 IN VARCHAR2 := NULL
1229: ,p_request_unique_key5 IN VARCHAR2 := NULL
1230: ,p_delete IN Varchar2 Default
1231: FND_API.G_TRUE
1232: ,x_return_status OUT NOCOPY Varchar2)
1233: IS
1234: l_request_ind Number;
1235: l_request_search_rslt Varchar2(30);

Line 1238: x_return_status := FND_API.G_RET_STS_SUCCESS;

1234: l_request_ind Number;
1235: l_request_search_rslt Varchar2(30);
1236: l_return_status Varchar2(30);
1237: Begin
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;
1239:
1240: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');
1241: IF p_entity_id IS NOT NULL THEN --2650093
1242: Check_for_Request( p_entity_code => p_entity_code

Line 1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1250: ,x_request_ind => l_request_ind
1251: ,x_result => l_request_search_rslt
1252: ,x_return_status => l_return_status);
1253:
1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;

Line 1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1251: ,x_result => l_request_search_rslt
1252: ,x_return_status => l_return_status);
1253:
1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:

Line 1256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1252: ,x_return_status => l_return_status);
1253:
1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260: if l_request_search_rslt = FND_API.G_TRUE then

Line 1257: RAISE FND_API.G_EXC_ERROR;

1253:
1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260: if l_request_search_rslt = FND_API.G_TRUE then
1261: Process_Request_Pvt

Line 1260: if l_request_search_rslt = FND_API.G_TRUE then

1256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260: if l_request_search_rslt = FND_API.G_TRUE then
1261: Process_Request_Pvt
1262: (p_request_ind => l_request_ind
1263: ,p_delete => p_delete
1264: ,x_return_status => l_return_status

Line 1268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1265: );
1266: end if;
1267:
1268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273: END IF; --2650093

Line 1270: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1266: end if;
1267:
1268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273: END IF; --2650093
1274: EXCEPTION

Line 1271: RAISE FND_API.G_EXC_ERROR;

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

Line 1276: WHEN FND_API.G_EXC_ERROR THEN

1272: END IF;
1273: END IF; --2650093
1274: EXCEPTION
1275:
1276: WHEN FND_API.G_EXC_ERROR THEN
1277:
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1278: x_return_status := FND_API.G_RET_STS_ERROR;

1274: EXCEPTION
1275:
1276: WHEN FND_API.G_EXC_ERROR THEN
1277:
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281:
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1276: WHEN FND_API.G_EXC_ERROR THEN
1277:
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281:
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1283:
1284: WHEN OTHERS THEN

Line 1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281:
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1283:
1284: WHEN OTHERS THEN
1285:
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1283:
1284: WHEN OTHERS THEN
1285:
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1287:
1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1289: THEN
1290: OE_MSG_PUB.Add_Exc_Msg

Line 1301: ,p_delete in Varchar2 Default FND_API.G_TRUE

1297:
1298:
1299: Procedure Process_Request_for_Entity
1300: ( p_entity_code in Varchar2
1301: ,p_delete in Varchar2 Default FND_API.G_TRUE
1302: ,x_return_status OUT NOCOPY Varchar2) IS
1303: l_return_status Varchar2(30);
1304: l_ind Number;
1305: Begin

Line 1306: x_return_status := FND_API.G_RET_STS_SUCCESS;

1302: ,x_return_status OUT NOCOPY Varchar2) IS
1303: l_return_status Varchar2(30);
1304: l_ind Number;
1305: Begin
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:
1308: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1309: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1310: --dbms_output.put_line('entity id is ' ||p_entity_code);

Line 1334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1330: ,p_delete => p_delete
1331: ,x_return_status => l_return_status
1332: );
1333:
1334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;

Line 1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1331: ,x_return_status => l_return_status
1332: );
1333:
1334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;
1339: --EXIT;

Line 1336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1332: );
1333:
1334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;
1339: --EXIT;
1340: END IF;

Line 1337: RAISE FND_API.G_EXC_ERROR;

1333:
1334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;
1339: --EXIT;
1340: END IF;
1341: l_ind := G_Delayed_Requests.Next(l_ind);

Line 1348: WHEN FND_API.G_EXC_ERROR THEN

1344: --dbms_output.put_line('Exiting Process_Request_for_Entity ');
1345:
1346: EXCEPTION
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349:
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1350: x_return_status := FND_API.G_RET_STS_ERROR;

1346: EXCEPTION
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349:
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1348: WHEN FND_API.G_EXC_ERROR THEN
1349:
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1355:
1356: WHEN OTHERS THEN

Line 1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1355:
1356: WHEN OTHERS THEN
1357:
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1355:
1356: WHEN OTHERS THEN
1357:
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1359:
1360: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1361: THEN
1362: OE_MSG_PUB.Add_Exc_Msg

Line 1374: ,p_delete in Varchar2 Default FND_API.G_TRUE

1370: End Process_Request_for_Entity;
1371:
1372: Procedure Process_Request_for_ReqType
1373: ( p_request_type in Varchar2
1374: ,p_delete in Varchar2 Default FND_API.G_TRUE
1375: ,x_return_status OUT NOCOPY Varchar2
1376: ) IS
1377: l_return_status Varchar2(30);
1378: l_ind Number;

Line 1380: x_return_status := FND_API.G_RET_STS_SUCCESS;

1376: ) IS
1377: l_return_status Varchar2(30);
1378: l_ind Number;
1379: Begin
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');
1383:
1384: l_ind := G_Delayed_Requests.first;

Line 1394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1390: ,p_delete => p_delete
1391: ,x_return_status => l_return_status
1392: );
1393:
1394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;

Line 1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1392: );
1393:
1394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;
1399: END IF;
1400: l_ind := G_Delayed_Requests.Next(l_ind);

Line 1397: RAISE FND_API.G_EXC_ERROR;

1393:
1394: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;
1399: END IF;
1400: l_ind := G_Delayed_Requests.Next(l_ind);
1401: END LOOP;

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401: END LOOP;
1402:
1403: EXCEPTION
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1407: x_return_status := FND_API.G_RET_STS_ERROR;

1403: EXCEPTION
1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410:
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1405: WHEN FND_API.G_EXC_ERROR THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410:
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412:
1413: WHEN OTHERS THEN

Line 1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410:
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412:
1413: WHEN OTHERS THEN
1414:
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412:
1413: WHEN OTHERS THEN
1414:
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1416:
1417: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1418: THEN
1419: OE_MSG_PUB.Add_Exc_Msg

Line 1444: ,p_delete => FND_API.G_TRUE

1440:
1441: -- start bug2091362
1442: Process_Request_for_ReqType
1443: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1444: ,p_delete => FND_API.G_TRUE
1445: ,x_return_status => l_return_status
1446: );
1447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1443: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1444: ,p_delete => FND_API.G_TRUE
1445: ,x_return_status => l_return_status
1446: );
1447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;

Line 1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1445: ,x_return_status => l_return_status
1446: );
1447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1452:
1453: -- end bug2091362

Line 1450: RAISE FND_API.G_EXC_ERROR;

1446: );
1447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1452:
1453: -- end bug2091362
1454:

Line 1458: ,p_delete => FND_API.G_TRUE

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

Line 1461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1463: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1464: RAISE FND_API.G_EXC_ERROR;

1460: );
1461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1463: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;
1466:
1467:
1468: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/

Line 1472: ,p_delete => FND_API.G_TRUE

1468: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/
1469:
1470: Process_Request_for_ReqType
1471: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
1472: ,p_delete => FND_API.G_TRUE
1473: ,x_return_status => l_return_status
1474: );
1475: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1475: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1478: RAISE FND_API.G_EXC_ERROR;

1474: );
1475: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: END IF;
1480:
1481:
1482: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/

Line 1486: ,p_delete => FND_API.G_TRUE

1482: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
1483:
1484: Process_Request_for_ReqType
1485: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1486: ,p_delete => FND_API.G_TRUE
1487: ,x_return_status => l_return_status
1488: );
1489: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1489: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1491: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1487: ,x_return_status => l_return_status
1488: );
1489: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495: /*fix for bug 1501138*/

Line 1492: RAISE FND_API.G_EXC_ERROR;

1488: );
1489: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495: /*fix for bug 1501138*/
1496: /*

Line 1499: ,p_delete => FND_API.G_TRUE

1495: /*fix for bug 1501138*/
1496: /*
1497: Process_Request_for_ReqType
1498: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1499: ,p_delete => FND_API.G_TRUE
1500: ,x_return_status => l_return_status
1501: );
1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1498: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1499: ,p_delete => FND_API.G_TRUE
1500: ,x_return_status => l_return_status
1501: );
1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1505: RAISE FND_API.G_EXC_ERROR;
1506: END IF;

Line 1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1499: ,p_delete => FND_API.G_TRUE
1500: ,x_return_status => l_return_status
1501: );
1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1505: RAISE FND_API.G_EXC_ERROR;
1506: END IF;
1507:

Line 1504: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1500: ,x_return_status => l_return_status
1501: );
1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1505: RAISE FND_API.G_EXC_ERROR;
1506: END IF;
1507:
1508: */

Line 1505: RAISE FND_API.G_EXC_ERROR;

1501: );
1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1505: RAISE FND_API.G_EXC_ERROR;
1506: END IF;
1507:
1508: */
1509:

Line 1512: ,p_delete => FND_API.G_TRUE

1508: */
1509:
1510: Process_Request_for_ReqType
1511: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1511: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;

Line 1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520:

Line 1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520:
1521:

Line 1518: RAISE FND_API.G_EXC_ERROR;

1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520:
1521:
1522: Process_Request_for_ReqType

Line 1524: ,p_delete => FND_API.G_TRUE

1520:
1521:
1522: Process_Request_for_ReqType
1523: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
1524: ,p_delete => FND_API.G_TRUE
1525: ,x_return_status => l_return_status
1526: );
1527: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1527: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1529: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1530: RAISE FND_API.G_EXC_ERROR;

1526: );
1527: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:
1533:
1534: Process_Request_for_ReqType

Line 1536: ,p_delete => FND_API.G_TRUE

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

Line 1539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1542: RAISE FND_API.G_EXC_ERROR;

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

Line 1548: ,p_delete => FND_API.G_TRUE

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

Line 1551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1554: RAISE FND_API.G_EXC_ERROR;

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

Line 1559: ,p_delete => FND_API.G_TRUE

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

Line 1562: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1564: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1565: RAISE FND_API.G_EXC_ERROR;

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

Line 1570: ,p_delete => FND_API.G_TRUE

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

Line 1573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1576: RAISE FND_API.G_EXC_ERROR;

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

Line 1581: ,p_delete => FND_API.G_TRUE

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

Line 1584: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1586: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1587: RAISE FND_API.G_EXC_ERROR;

1583: );
1584: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1586: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1587: RAISE FND_API.G_EXC_ERROR;
1588: END IF;
1589:
1590: Process_Request_for_ReqType
1591: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS

Line 1592: ,p_delete => FND_API.G_TRUE

1588: END IF;
1589:
1590: Process_Request_for_ReqType
1591: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
1592: ,p_delete => FND_API.G_TRUE
1593: ,x_return_status => l_return_status
1594: );
1595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1598: RAISE FND_API.G_EXC_ERROR;

1594: );
1595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600:
1601: Process_Request_for_ReqType
1602: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE

Line 1603: ,p_delete => FND_API.G_TRUE

1599: END IF;
1600:
1601: Process_Request_for_ReqType
1602: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
1603: ,p_delete => FND_API.G_TRUE
1604: ,x_return_status => l_return_status
1605: );
1606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1602: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
1603: ,p_delete => FND_API.G_TRUE
1604: ,x_return_status => l_return_status
1605: );
1606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;

Line 1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1604: ,x_return_status => l_return_status
1605: );
1606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611:
1612: Process_Request_for_ReqType

Line 1609: RAISE FND_API.G_EXC_ERROR;

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

Line 1614: ,p_delete => FND_API.G_TRUE

1610: END IF;
1611:
1612: Process_Request_for_ReqType
1613: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
1614: ,p_delete => FND_API.G_TRUE
1615: ,x_return_status => l_return_status
1616: );
1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1613: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
1614: ,p_delete => FND_API.G_TRUE
1615: ,x_return_status => l_return_status
1616: );
1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1620: RAISE FND_API.G_EXC_ERROR;
1621: END IF;

Line 1618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1614: ,p_delete => FND_API.G_TRUE
1615: ,x_return_status => l_return_status
1616: );
1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1620: RAISE FND_API.G_EXC_ERROR;
1621: END IF;
1622:

Line 1619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1615: ,x_return_status => l_return_status
1616: );
1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1620: RAISE FND_API.G_EXC_ERROR;
1621: END IF;
1622:
1623: Process_Request_for_ReqType

Line 1620: RAISE FND_API.G_EXC_ERROR;

1616: );
1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1620: RAISE FND_API.G_EXC_ERROR;
1621: END IF;
1622:
1623: Process_Request_for_ReqType
1624: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

Line 1625: ,p_delete => FND_API.G_TRUE

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

Line 1628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1631: RAISE FND_API.G_EXC_ERROR;

1627: );
1628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633:
1634: Process_Request_for_ReqType
1635: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES

Line 1636: ,p_delete => FND_API.G_TRUE

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

Line 1639: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1641: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1642: RAISE FND_API.G_EXC_ERROR;

1638: );
1639: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1641: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:
1645: Process_Request_for_ReqType
1646: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS

Line 1647: ,p_delete => FND_API.G_TRUE

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

Line 1650: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1648: ,x_return_status => l_return_status
1649: );
1650: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1655:
1656: -- mkarya for attribute manager

Line 1653: RAISE FND_API.G_EXC_ERROR;

1649: );
1650: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1655:
1656: -- mkarya for attribute manager
1657: Process_Request_for_ReqType

Line 1659: ,p_delete => FND_API.G_TRUE

1655:
1656: -- mkarya for attribute manager
1657: Process_Request_for_ReqType
1658: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
1659: ,p_delete => FND_API.G_TRUE
1660: ,x_return_status => l_return_status
1661: );
1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1658: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
1659: ,p_delete => FND_API.G_TRUE
1660: ,x_return_status => l_return_status
1661: );
1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1665: RAISE FND_API.G_EXC_ERROR;
1666: END IF;

Line 1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1659: ,p_delete => FND_API.G_TRUE
1660: ,x_return_status => l_return_status
1661: );
1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1665: RAISE FND_API.G_EXC_ERROR;
1666: END IF;
1667:

Line 1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1660: ,x_return_status => l_return_status
1661: );
1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1665: RAISE FND_API.G_EXC_ERROR;
1666: END IF;
1667:
1668: -- Hierarchical Categories (sfiresto)

Line 1665: RAISE FND_API.G_EXC_ERROR;

1661: );
1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1665: RAISE FND_API.G_EXC_ERROR;
1666: END IF;
1667:
1668: -- Hierarchical Categories (sfiresto)
1669: Process_Request_for_ReqType

Line 1671: ,p_delete => FND_API.G_TRUE

1667:
1668: -- Hierarchical Categories (sfiresto)
1669: Process_Request_for_ReqType
1670: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS
1671: ,p_delete => FND_API.G_TRUE
1672: ,x_return_status => l_return_status
1673: );
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1670: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS
1671: ,p_delete => FND_API.G_TRUE
1672: ,x_return_status => l_return_status
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: ,p_delete => FND_API.G_TRUE
1672: ,x_return_status => l_return_status
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: ,x_return_status => l_return_status
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:

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:
1681: --hw

Line 1687: ,p_delete => FND_API.G_TRUE

1683: -- delayed request for changed lines
1684: if QP_PERF_PVT.enabled = 'Y' then
1685: Process_Request_for_ReqType
1686: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
1687: ,p_delete => FND_API.G_TRUE
1688: ,x_return_status => l_return_status
1689: );
1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1686: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
1687: ,p_delete => FND_API.G_TRUE
1688: ,x_return_status => l_return_status
1689: );
1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;

Line 1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1687: ,p_delete => FND_API.G_TRUE
1688: ,x_return_status => l_return_status
1689: );
1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;
1695:

Line 1692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1688: ,x_return_status => l_return_status
1689: );
1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: Process_Request_for_ReqType

Line 1693: RAISE FND_API.G_EXC_ERROR;

1689: );
1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: Process_Request_for_ReqType
1697: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL

Line 1698: ,p_delete => FND_API.G_TRUE

1694: END IF;
1695:
1696: Process_Request_for_ReqType
1697: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
1698: ,p_delete => FND_API.G_TRUE
1699: ,x_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1697: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
1698: ,p_delete => FND_API.G_TRUE
1699: ,x_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;

Line 1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1698: ,p_delete => FND_API.G_TRUE
1699: ,x_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:

Line 1703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1699: ,x_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:
1707: Process_Request_for_ReqType

Line 1704: RAISE FND_API.G_EXC_ERROR;

1700: );
1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:
1707: Process_Request_for_ReqType
1708: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT

Line 1709: ,p_delete => FND_API.G_TRUE

1705: END IF;
1706:
1707: Process_Request_for_ReqType
1708: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
1709: ,p_delete => FND_API.G_TRUE
1710: ,x_return_status => l_return_status
1711: );
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1708: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
1709: ,p_delete => FND_API.G_TRUE
1710: ,x_return_status => l_return_status
1711: );
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;

Line 1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1709: ,p_delete => FND_API.G_TRUE
1710: ,x_return_status => l_return_status
1711: );
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:

Line 1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1710: ,x_return_status => l_return_status
1711: );
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:
1718: Process_Request_for_ReqType

Line 1715: RAISE FND_API.G_EXC_ERROR;

1711: );
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:
1718: Process_Request_for_ReqType
1719: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH

Line 1720: ,p_delete => FND_API.G_TRUE

1716: END IF;
1717:
1718: Process_Request_for_ReqType
1719: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
1720: ,p_delete => FND_API.G_TRUE
1721: ,x_return_status => l_return_status
1722: );
1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1719: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
1720: ,p_delete => FND_API.G_TRUE
1721: ,x_return_status => l_return_status
1722: );
1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;

Line 1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1720: ,p_delete => FND_API.G_TRUE
1721: ,x_return_status => l_return_status
1722: );
1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728: end if;

Line 1725: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1721: ,x_return_status => l_return_status
1722: );
1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728: end if;
1729: oe_debug_pub.add('Ren: in process delayed request');

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: );
1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728: end if;
1729: oe_debug_pub.add('Ren: in process delayed request');
1730:

Line 1735: ,p_delete => FND_API.G_TRUE

1731: -- mkarya for pattern delayed requests
1732: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1733: Process_Request_for_ReqType
1734: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN
1735: ,p_delete => FND_API.G_TRUE
1736: ,x_return_status => l_return_status
1737: );
1738:
1739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1735: ,p_delete => FND_API.G_TRUE
1736: ,x_return_status => l_return_status
1737: );
1738:
1739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;

Line 1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1736: ,x_return_status => l_return_status
1737: );
1738:
1739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:

Line 1741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1737: );
1738:
1739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: Process_Request_for_ReqType

Line 1742: RAISE FND_API.G_EXC_ERROR;

1738:
1739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: Process_Request_for_ReqType
1746: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN

Line 1747: ,p_delete => FND_API.G_TRUE

1743: END IF;
1744:
1745: Process_Request_for_ReqType
1746: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN
1747: ,p_delete => FND_API.G_TRUE
1748: ,x_return_status => l_return_status
1749: );
1750:
1751: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1751: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1747: ,p_delete => FND_API.G_TRUE
1748: ,x_return_status => l_return_status
1749: );
1750:
1751: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;

Line 1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1748: ,x_return_status => l_return_status
1749: );
1750:
1751: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;
1756:

Line 1753: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1749: );
1750:
1751: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;
1756:
1757: Process_Request_for_ReqType

Line 1754: RAISE FND_API.G_EXC_ERROR;

1750:
1751: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;
1756:
1757: Process_Request_for_ReqType
1758: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN

Line 1759: ,p_delete => FND_API.G_TRUE

1755: END IF;
1756:
1757: Process_Request_for_ReqType
1758: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN
1759: ,p_delete => FND_API.G_TRUE
1760: ,x_return_status => l_return_status
1761: );
1762:
1763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1759: ,p_delete => FND_API.G_TRUE
1760: ,x_return_status => l_return_status
1761: );
1762:
1763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;

Line 1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1760: ,x_return_status => l_return_status
1761: );
1762:
1763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768:

Line 1765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1761: );
1762:
1763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768:
1769: END IF; --IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y'

Line 1766: RAISE FND_API.G_EXC_ERROR;

1762:
1763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768:
1769: END IF; --IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y'
1770:

Line 1779: ,p_delete => FND_API.G_TRUE

1775: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1776:
1777: Process_Request_for_ReqType
1778: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN
1779: ,p_delete => FND_API.G_TRUE
1780: ,x_return_status => l_return_status
1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1779: ,p_delete => FND_API.G_TRUE
1780: ,x_return_status => l_return_status
1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;

Line 1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1780: ,x_return_status => l_return_status
1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:

Line 1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789: Process_Request_for_ReqType

Line 1786: RAISE FND_API.G_EXC_ERROR;

1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789: Process_Request_for_ReqType
1790: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN

Line 1791: ,p_delete => FND_API.G_TRUE

1787: END IF;
1788:
1789: Process_Request_for_ReqType
1790: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN
1791: ,p_delete => FND_API.G_TRUE
1792: ,x_return_status => l_return_status
1793: );
1794:
1795: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1795: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1791: ,p_delete => FND_API.G_TRUE
1792: ,x_return_status => l_return_status
1793: );
1794:
1795: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1797: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;

Line 1796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1792: ,x_return_status => l_return_status
1793: );
1794:
1795: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1797: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:

Line 1797: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1793: );
1794:
1795: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1797: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801: Process_Request_for_ReqType

Line 1798: RAISE FND_API.G_EXC_ERROR;

1794:
1795: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1797: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801: Process_Request_for_ReqType
1802: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN

Line 1803: ,p_delete => FND_API.G_TRUE

1799: END IF;
1800:
1801: Process_Request_for_ReqType
1802: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN
1803: ,p_delete => FND_API.G_TRUE
1804: ,x_return_status => l_return_status
1805: );
1806:
1807: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1807: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1803: ,p_delete => FND_API.G_TRUE
1804: ,x_return_status => l_return_status
1805: );
1806:
1807: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;

Line 1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1804: ,x_return_status => l_return_status
1805: );
1806:
1807: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812: END IF; --- QP pattern search set to 'Y'

Line 1809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1805: );
1806:
1807: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812: END IF; --- QP pattern search set to 'Y'
1813: END IF; --IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N'

Line 1810: RAISE FND_API.G_EXC_ERROR;

1806:
1807: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812: END IF; --- QP pattern search set to 'Y'
1813: END IF; --IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N'
1814: -- jagan's PL/SQL pattern

Line 1820: WHEN FND_API.G_EXC_ERROR THEN

1816: Clear_Request(x_return_status);
1817:
1818: EXCEPTION
1819:
1820: WHEN FND_API.G_EXC_ERROR THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823:
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1822: x_return_status := FND_API.G_RET_STS_ERROR;

1818: EXCEPTION
1819:
1820: WHEN FND_API.G_EXC_ERROR THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823:
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1820: WHEN FND_API.G_EXC_ERROR THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823:
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1827:
1828: WHEN OTHERS THEN

Line 1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823:
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1827:
1828: WHEN OTHERS THEN
1829:
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1827:
1828: WHEN OTHERS THEN
1829:
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1831:
1832: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: OE_MSG_PUB.Add_Exc_Msg

Line 1855: x_return_status := FND_API.G_RET_STS_SUCCESS;

1851: BEGIN
1852:
1853:
1854:
1855: x_return_status := FND_API.G_RET_STS_SUCCESS;
1856:
1857:
1858: -- DELETING REQUESTS LOGGED AGAINST THIS ENTITY
1859:

Line 1933: WHEN FND_API.G_EXC_ERROR THEN

1929: END LOOP;
1930:
1931: EXCEPTION
1932:
1933: WHEN FND_API.G_EXC_ERROR THEN
1934:
1935: x_return_status := FND_API.G_RET_STS_ERROR;
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1935: x_return_status := FND_API.G_RET_STS_ERROR;

1931: EXCEPTION
1932:
1933: WHEN FND_API.G_EXC_ERROR THEN
1934:
1935: x_return_status := FND_API.G_RET_STS_ERROR;
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938:
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1933: WHEN FND_API.G_EXC_ERROR THEN
1934:
1935: x_return_status := FND_API.G_RET_STS_ERROR;
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938:
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1940:
1941: when others THEN

Line 1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1935: x_return_status := FND_API.G_RET_STS_ERROR;
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938:
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1940:
1941: when others THEN
1942:
1943: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1949: x_return_status := FND_API.G_RET_STS_ERROR;

1945: (G_PKG_NAME
1946: ,'Delete_Reqs_for_Deleted_Entity');
1947: END IF;
1948:
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950:
1951: End Delete_Reqs_for_Deleted_Entity;
1952:
1953: