DBA Data[Home] [Help]

APPS.OE_BLANKET_WF_UTIL dependencies on OE_MSG_PUB

Line 30: /* OE_MSG_PUB.set_msg_context(

26: if l_debug_level > 0 then
27: oe_debug_pub.ADD('Entering create_and_start_flow ', 1);
28: end if;
29:
30: /* OE_MSG_PUB.set_msg_context(
31: p_entity_code => 'BLANKET_HEADER_WF'
32: ,p_entity_id => p_header_id
33: ,p_header_id => p_header_id
34: ,p_line_id => null

Line 123: /* IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

119: end if;
120:
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122:
123: /* IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
124: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
125: 'create_and_start_flow');
126: END IF; */
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 124: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

120:
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122:
123: /* IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
124: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
125: 'create_and_start_flow');
126: END IF; */
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128:

Line 152: OE_MSG_PUB.initialize;

148: BEGIN
149: if l_debug_level > 0 then
150: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft ', 1);
151: end if;
152: OE_MSG_PUB.initialize;
153: OE_MSG_PUB.set_msg_context(
154: p_entity_code => 'BLANKET_HEADER'
155: ,p_entity_id => p_header_id
156: ,p_header_id => p_header_id

Line 153: OE_MSG_PUB.set_msg_context(

149: if l_debug_level > 0 then
150: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft ', 1);
151: end if;
152: OE_MSG_PUB.initialize;
153: OE_MSG_PUB.set_msg_context(
154: p_entity_code => 'BLANKET_HEADER'
155: ,p_entity_id => p_header_id
156: ,p_header_id => p_header_id
157: ,p_line_id => null

Line 215: OE_MSG_PUB.Count_And_Get(p_count => x_msg_count,

211: where header_id = p_header_id;
212: END IF;
213: -- Get message count and data
214:
215: OE_MSG_PUB.Count_And_Get(p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: if l_debug_level > 0 then
219: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft return status'||l_return_status);

Line 238: /* IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

234: end if;
235:
236: x_return_status := l_return_status;
237:
238: /* IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
240: 'Submit_Draft');
241: END IF; */
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 239: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

235:
236: x_return_status := l_return_status;
237:
238: /* IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
240: 'Submit_Draft');
241: END IF; */
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243:

Line 274: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

270: ELSE
271: oe_blanket_wf.Blanket_Date_Changed(p_header_id => p_header_id,
272: x_return_status => x_return_status);
273: END IF;
274: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
275: , p_data => x_msg_data); */
276:
277:
278: EXCEPTION

Line 286: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

282: end if;
283:
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285:
286: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
287: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
288: 'Blanket_Date_Changed');
289: END IF;
290: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 287: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

283:
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285:
286: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
287: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
288: 'Blanket_Date_Changed');
289: END IF;
290: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
291: , p_data => x_msg_data); */

Line 290: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

286: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
287: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
288: 'Blanket_Date_Changed');
289: END IF;
290: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
291: , p_data => x_msg_data); */
292:
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294:

Line 315: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: OE_NEGOTIATE_WF.Customer_Accepted(p_header_id => p_header_id,
314: x_return_status => x_return_status);
315: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
316: , p_data => x_msg_data);
317:
318:
319: EXCEPTION

Line 327: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

323: end if;
324:
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326:
327: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
328: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
329: 'Customer_Accepted');
330: END IF;
331: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 328: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

324:
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326:
327: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
328: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
329: 'Customer_Accepted');
330: END IF;
331: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
332: , p_data => x_msg_data);

Line 331: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

327: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
328: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
329: 'Customer_Accepted');
330: END IF;
331: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
332: , p_data => x_msg_data);
333:
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335:

Line 385: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);
382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);
383: end if;
384:
385: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
386: , p_data => x_msg_data);
387:
388:
389: EXCEPTION

Line 397: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

393: end if;
394:
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:
397: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
398: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
399: 'Customer_Rejected');
400: END IF;
401: OE_MSG_PUB.Count_And_Get

Line 398: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

394:
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:
397: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
398: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
399: 'Customer_Rejected');
400: END IF;
401: OE_MSG_PUB.Count_And_Get
402: ( p_count => x_msg_count

Line 401: OE_MSG_PUB.Count_And_Get

397: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
398: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
399: 'Customer_Rejected');
400: END IF;
401: OE_MSG_PUB.Count_And_Get
402: ( p_count => x_msg_count
403: , p_data => x_msg_data
404: );
405:

Line 436: oe_msg_pub.add;

432: AND ROWNUM = 1;
433: IF l_dumy = 'TRUE' THEN
434: l_return_status := FND_API.G_RET_STS_ERROR;
435: fnd_message.set_name('ONT', 'OE_BKT_NO_DATE_CHANGE');
436: oe_msg_pub.add;
437: END IF;
438:
439: IF l_dumy = 'FALSE' THEN
440: SELECT 'TRUE'

Line 449: oe_msg_pub.add;

445: AND ROWNUM = 1;
446: IF l_dumy = 'TRUE' THEN
447: l_return_status := FND_API.G_RET_STS_ERROR;
448: fnd_message.set_name('ONT', 'OE_BKT_NO_DATE_CHANGE');
449: oe_msg_pub.add;
450: END IF;
451: END IF;
452: x_return_status := l_return_status;
453: end if;

Line 467: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

463: end if;
464:
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466:
467: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
469: 'Check Release');
470: END IF;
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 468: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

464:
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466:
467: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
469: 'Check Release');
470: END IF;
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472:

Line 497: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

493: end if;
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496:
497: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
499: 'Extend');
500: END IF;
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 498: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496:
497: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
499: 'Extend');
500: END IF;
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502:

Line 520: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

516: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Close ', 1);
517: end if;
518: OE_BLANKET_WF.Close(p_header_id => p_header_id,
519: x_return_status => x_return_status);
520: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
521: , p_data => x_msg_data);
522:
523: EXCEPTION
524: WHEN OTHERS THEN

Line 531: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

527: end if;
528:
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530:
531: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
532: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
533: 'Close');
534: END IF;
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 532: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

528:
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530:
531: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
532: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
533: 'Close');
534: END IF;
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536:

Line 569: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

565: p_reason_type => l_reason_type,
566: p_reason_code => l_reason_code,
567: p_reason_comments => l_reason_comments,
568: x_return_status => x_return_status);
569: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
570: , p_data => x_msg_data);
571:
572: EXCEPTION
573: WHEN OTHERS THEN

Line 579: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

575: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
576: end if;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578:
579: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
580: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
581: 'Terminate');
582: END IF;
583: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 580: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

576: end if;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578:
579: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
580: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
581: 'Terminate');
582: END IF;
583: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
584: , p_data => x_msg_data);

Line 583: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

579: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
580: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
581: 'Terminate');
582: END IF;
583: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
584: , p_data => x_msg_data);
585:
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587:

Line 637: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);
635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);
636: end if;
637: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
638: , p_data => x_msg_data);
639:
640:
641: EXCEPTION

Line 648: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

644: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
645: end if;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647:
648: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
649: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
650: 'Lost');
651: END IF;
652: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 649: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

645: end if;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647:
648: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
649: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
650: 'Lost');
651: END IF;
652: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
653: , p_data => x_msg_data);

Line 652: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

648: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
649: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
650: 'Lost');
651: END IF;
652: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
653: , p_data => x_msg_data);
654:
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656:

Line 772: OE_MSG_PUB.set_msg_context (p_entity_code => 'BLANKET',

768: x_return_status := l_return_status;
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771: /*
772: OE_MSG_PUB.set_msg_context (p_entity_code => 'BLANKET',
773: p_entity_id => p_header_id,
774: p_header_id => p_header_id);
775: */
776: l_Last_Updated_By := Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1);

Line 844: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

840: END IF;
841: if l_debug_level > 0 then
842: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Complete_Negotiation return status'||l_return_status);
843: end if;
844: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
845: , p_data => x_msg_data);
846: */
847:
848: EXCEPTION

Line 874: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

870: end if;
871:
872: x_return_status := l_return_status;
873:
874: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
875: , p_data => x_msg_data); */
876:
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: