18: IS
19: l_reason_id Number;
20: BEGIN
21: oe_debug_pub.add('Entering Apply Reason');
22: OE_MSG_PUB.initialize;
23: IF p_reason_type IN ('OFFER_LOST','OFFER_LOST_REASON') THEN
24: OE_NEGOTIATE_WF.Lost
25: (
26: p_header_id =>p_entity_id,
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: -- Get message count and data
82:
83: OE_MSG_PUB.Count_And_Get
84: ( p_count => x_msg_count
85: , p_data => x_msg_data
86: );
87:
95: x_return_status := FND_API.G_RET_STS_ERROR;
96:
97: -- Get message count and data
98:
99: OE_MSG_PUB.Count_And_Get
100: ( p_count => x_msg_count
101: , p_data => x_msg_data
102: );
103:
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
108:
109: -- Get message count and data
110:
111: OE_MSG_PUB.Count_And_Get
112: ( p_count => x_msg_count
113: , p_data => x_msg_data
114: );
115:
117:
118: OE_GLOBALS.G_UI_FLAG := FALSE;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120:
121: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
122: THEN
123: OE_MSG_PUB.Add_Exc_Msg
124: ( G_PKG_NAME
125: , 'Apply_Reasons'
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120:
121: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
122: THEN
123: OE_MSG_PUB.Add_Exc_Msg
124: ( G_PKG_NAME
125: , 'Apply_Reasons'
126: );
127: END IF;
127: END IF;
128:
129: -- Get message count and data
130:
131: OE_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count
133: , p_data => x_msg_data
134: );
135:
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- Get message count and data
164:
165: OE_MSG_PUB.Count_And_Get
166: ( p_count => x_msg_count
167: , p_data => x_msg_data
168: );
169:
176: x_return_status := FND_API.G_RET_STS_ERROR;
177:
178: -- Get message count and data
179:
180: OE_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count
182: , p_data => x_msg_data
183: );
184:
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189:
190: -- Get message count and data
191:
192: OE_MSG_PUB.Count_And_Get
193: ( p_count => x_msg_count
194: , p_data => x_msg_data
195: );
196:
198:
199: OE_GLOBALS.G_UI_FLAG := FALSE;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201:
202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: OE_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME
206: , 'Submit_Draft'
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201:
202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: OE_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME
206: , 'Submit_Draft'
207: );
208: END IF;
208: END IF;
209:
210: -- Get message count and data
211:
212: OE_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count
214: , p_data => x_msg_data
215: );
216:
269:
270: OE_GLOBALS.G_UI_FLAG := FALSE;
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273: OE_MSG_PUB.Count_And_Get
274: ( p_count => x_msg_count
275: , p_data => x_msg_data
276: );
277:
284: x_return_status := FND_API.G_RET_STS_ERROR;
285:
286: -- Get message count and data
287:
288: OE_MSG_PUB.Count_And_Get
289: ( p_count => x_msg_count
290: , p_data => x_msg_data
291: );
292:
296:
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
298: -- Get message count and data
299:
300: OE_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count
302: , p_data => x_msg_data
303: );
304:
307: OE_GLOBALS.G_UI_FLAG := FALSE;
308:
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310:
311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
312: THEN
313: OE_MSG_PUB.Add_Exc_Msg
314: ( G_PKG_NAME
315: , 'Populate_Version_Number'
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310:
311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
312: THEN
313: OE_MSG_PUB.Add_Exc_Msg
314: ( G_PKG_NAME
315: , 'Populate_Version_Number'
316: );
317: END IF;
317: END IF;
318:
319: -- Get message count and data
320:
321: OE_MSG_PUB.Count_And_Get
322: ( p_count => x_msg_count
323: , p_data => x_msg_data
324: );
325:
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: OE_MSG_PUB.Count_And_Get
366: ( p_count => x_msg_count
367: , p_data => x_msg_data
368: );
369:
375: x_return_status := FND_API.G_RET_STS_ERROR;
376:
377: -- Get message count and data
378:
379: OE_MSG_PUB.Count_And_Get
380: ( p_count => x_msg_count
381: , p_data => x_msg_data
382: );
383:
387:
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: -- Get message count and data
390:
391: OE_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count
393: , p_data => x_msg_data
394: );
395:
397:
398:
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400:
401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: OE_MSG_PUB.Add_Exc_Msg
404: ( G_PKG_NAME
405: , 'Get_Reason_Rqd_Info'
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400:
401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: OE_MSG_PUB.Add_Exc_Msg
404: ( G_PKG_NAME
405: , 'Get_Reason_Rqd_Info'
406: );
407: END IF;
407: END IF;
408:
409: -- Get message count and data
410:
411: OE_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count
413: , p_data => x_msg_data
414: );
415: