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.

APPS.OE_ORDER_WF_UTIL dependencies on OE_MSG_PUB

Line 168: OE_MSG_PUB.Add;

164: EXCEPTION
165:
166: WHEN NO_DATA_FOUND THEN
167: fnd_message.set_name('ONT','OE_MISS_FLOW');
168: OE_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;
170:
171: WHEN OTHERS THEN
172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

168: OE_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;
170:
171: WHEN OTHERS THEN
172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: OE_MSG_PUB.Add_Exc_Msg
175: ( G_PKG_NAME
176: , 'GET_ProcessName'

Line 174: OE_MSG_PUB.Add_Exc_Msg

170:
171: WHEN OTHERS THEN
172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: OE_MSG_PUB.Add_Exc_Msg
175: ( G_PKG_NAME
176: , 'GET_ProcessName'
177: );
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 243: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

239:
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: OE_MSG_PUB.Add_Exc_Msg
246: (G_PKG_NAME
247: , 'Set_Header_Descriptor'

Line 245: OE_MSG_PUB.Add_Exc_Msg

241: EXCEPTION
242: WHEN OTHERS THEN
243: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: OE_MSG_PUB.Add_Exc_Msg
246: (G_PKG_NAME
247: , 'Set_Header_Descriptor'
248: );
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

328: document := substrb(l_order_type_txt || ', ' || l_line_txt, 1, 240);
329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: OE_MSG_PUB.Add_Exc_Msg
335: (G_PKG_NAME
336: , 'Set_Line_Descriptor'

Line 334: OE_MSG_PUB.Add_Exc_Msg

330: EXCEPTION
331: WHEN OTHERS THEN
332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: OE_MSG_PUB.Add_Exc_Msg
335: (G_PKG_NAME
336: , 'Set_Line_Descriptor'
337: );
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

357: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number));
358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: OE_MSG_PUB.Add_Exc_Msg
364: ( G_PKG_NAME
365: , 'Set_Header_User_Key'

Line 363: OE_MSG_PUB.Add_Exc_Msg

359: EXCEPTION
360: WHEN OTHERS THEN
361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: OE_MSG_PUB.Add_Exc_Msg
364: ( G_PKG_NAME
365: , 'Set_Header_User_Key'
366: );
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

399:
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
404: THEN
405: OE_MSG_PUB.Add_Exc_Msg
406: ( G_PKG_NAME
407: , 'Set_Line_User_Key'

Line 405: OE_MSG_PUB.Add_Exc_Msg

401: EXCEPTION
402: WHEN OTHERS THEN
403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
404: THEN
405: OE_MSG_PUB.Add_Exc_Msg
406: ( G_PKG_NAME
407: , 'Set_Line_User_Key'
408: );
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

434: oe_debug_pub.add( 'EXITING START_FLOW' ) ;
435: END IF;
436: EXCEPTION
437: WHEN OTHERS THEN
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'Start_Flow'

Line 440: OE_MSG_PUB.Add_Exc_Msg

436: EXCEPTION
437: WHEN OTHERS THEN
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'Start_Flow'
443: );
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 476: OE_MSG_PUB.ADD;

472:
473: WHEN OTHERS THEN
474: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR' THEN
475: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');
476: OE_MSG_PUB.ADD;
477: END IF;
478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
479: THEN
480: OE_MSG_PUB.Add_Exc_Msg

Line 478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

474: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR' THEN
475: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');
476: OE_MSG_PUB.ADD;
477: END IF;
478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
479: THEN
480: OE_MSG_PUB.Add_Exc_Msg
481: ( G_PKG_NAME
482: , 'Start_LineFork'

Line 480: OE_MSG_PUB.Add_Exc_Msg

476: OE_MSG_PUB.ADD;
477: END IF;
478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
479: THEN
480: OE_MSG_PUB.Add_Exc_Msg
481: ( G_PKG_NAME
482: , 'Start_LineFork'
483: );
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
538: RAISE;
539: WHEN OTHERS THEN
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Start_HdrProcess'

Line 542: OE_MSG_PUB.Add_Exc_Msg

538: RAISE;
539: WHEN OTHERS THEN
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Start_HdrProcess'
545: );
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
659: RAISE;
660: WHEN OTHERS THEN
661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
662: THEN
663: OE_MSG_PUB.Add_Exc_Msg
664: ( G_PKG_NAME
665: , 'Create_HdrWorkItem'

Line 663: OE_MSG_PUB.Add_Exc_Msg

659: RAISE;
660: WHEN OTHERS THEN
661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
662: THEN
663: OE_MSG_PUB.Add_Exc_Msg
664: ( G_PKG_NAME
665: , 'Create_HdrWorkItem'
666: );
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
727: RAISE;
728: WHEN OTHERS THEN
729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: OE_MSG_PUB.Add_Exc_Msg
732: ( G_PKG_NAME
733: , 'CreateStart_LineProcess'

Line 731: OE_MSG_PUB.Add_Exc_Msg

727: RAISE;
728: WHEN OTHERS THEN
729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: OE_MSG_PUB.Add_Exc_Msg
732: ( G_PKG_NAME
733: , 'CreateStart_LineProcess'
734: );
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

760:
761:
762: EXCEPTION
763: WHEN OTHERS THEN
764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: OE_MSG_PUB.Add_Exc_Msg
767: ( G_PKG_NAME
768: , 'CreateStart_LineFork'

Line 766: OE_MSG_PUB.Add_Exc_Msg

762: EXCEPTION
763: WHEN OTHERS THEN
764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: OE_MSG_PUB.Add_Exc_Msg
767: ( G_PKG_NAME
768: , 'CreateStart_LineFork'
769: );
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
870: RAISE;
871: WHEN OTHERS THEN
872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: OE_MSG_PUB.Add_Exc_Msg
875: ( G_PKG_NAME
876: , 'Create_LineWorkItem'

Line 874: OE_MSG_PUB.Add_Exc_Msg

870: RAISE;
871: WHEN OTHERS THEN
872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: OE_MSG_PUB.Add_Exc_Msg
875: ( G_PKG_NAME
876: , 'Create_LineWorkItem'
877: );
878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 921: OE_MSG_PUB.ADD;

917: EXCEPTION
918: WHEN OTHERS THEN
919: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR' THEN
920: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');
921: OE_MSG_PUB.ADD;
922: END IF;
923:
924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN

Line 924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

920: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');
921: OE_MSG_PUB.ADD;
922: END IF;
923:
924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN
926: OE_MSG_PUB.Add_Exc_Msg
927: ( G_PKG_NAME
928: , 'Create_LineFork'

Line 926: OE_MSG_PUB.Add_Exc_Msg

922: END IF;
923:
924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN
926: OE_MSG_PUB.Add_Exc_Msg
927: ( G_PKG_NAME
928: , 'Create_LineFork'
929: );
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1028: OE_MSG_PUB.ADD;

1024:
1025: ELSE
1026:
1027: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
1028: OE_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: EXCEPTION

Line 1035: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1031:
1032: EXCEPTION
1033:
1034: WHEN OTHERS THEN
1035: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1036: THEN
1037: OE_MSG_PUB.Add_Exc_Msg
1038: ( G_PKG_NAME ,
1039: 'Get_Wf_Item_Type'

Line 1037: OE_MSG_PUB.Add_Exc_Msg

1033:
1034: WHEN OTHERS THEN
1035: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1036: THEN
1037: OE_MSG_PUB.Add_Exc_Msg
1038: ( G_PKG_NAME ,
1039: 'Get_Wf_Item_Type'
1040: );
1041: END IF;

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

1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1276: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Start_All_Flows');
1277:
1278: -- Rollback to savepoint
1279: ROLLBACK TO Start_All_Flows;

Line 1276: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Start_All_Flows');

1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1276: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Start_All_Flows');
1277:
1278: -- Rollback to savepoint
1279: ROLLBACK TO Start_All_Flows;
1280: -- Clear Globals

Line 1429: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1425: ELSE
1426: IF l_debug_level > 0 THEN
1427: oe_debug_pub.add( 'OE_ORDER_WF_UTIL: DELETE TYPE NOT IN HEADER,LINE,NEGOTIATE,BLANKET' ) ;
1428: END IF;
1429: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1430: THEN
1431: OE_MSG_PUB.Add_Exc_Msg
1432: ( G_PKG_NAME
1433: , 'Delete_Row'

Line 1431: OE_MSG_PUB.Add_Exc_Msg

1427: oe_debug_pub.add( 'OE_ORDER_WF_UTIL: DELETE TYPE NOT IN HEADER,LINE,NEGOTIATE,BLANKET' ) ;
1428: END IF;
1429: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1430: THEN
1431: OE_MSG_PUB.Add_Exc_Msg
1432: ( G_PKG_NAME
1433: , 'Delete_Row'
1434: );
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1550: OE_MSG_PUB.set_msg_context

1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548:
1549: -- is entity HEADER correct?
1550: OE_MSG_PUB.set_msg_context
1551: ( p_entity_code => 'HEADER'
1552: ,p_entity_id => l_header_rec.header_id
1553: ,p_header_id => l_header_rec.header_id
1554: ,p_line_id => null

Line 1673: OE_MSG_PUB.set_msg_context

1669: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: END IF;
1672:
1673: OE_MSG_PUB.set_msg_context
1674: ( p_entity_code => 'BLANKET'
1675: ,p_entity_id => p_header_id
1676: ,p_header_id => p_header_id);
1677:

Line 1760: OE_MSG_PUB.set_msg_context

1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1759:
1760: OE_MSG_PUB.set_msg_context
1761: ( p_entity_code => 'LINE'
1762: ,p_entity_id => l_old_line_tbl(1).line_id
1763: ,p_header_id => l_old_line_tbl(1).header_id
1764: ,p_line_id => l_old_line_tbl(1).line_id

Line 1799: OE_MSG_PUB.set_msg_context

1795: FROM OE_ORDER_LINES_ALL
1796: WHERE line_id = p_line_id
1797: FOR UPDATE NOWAIT;
1798:
1799: OE_MSG_PUB.set_msg_context
1800: ( p_entity_code => 'LINE'
1801: ,p_entity_id => p_line_id
1802: ,p_header_id => l_header_id
1803: ,p_line_id => p_line_id

Line 1842: OE_MSG_PUB.set_msg_context

1838: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1840: END IF;
1841:
1842: OE_MSG_PUB.set_msg_context
1843: ( p_entity_code => 'HEADER'
1844: ,p_entity_id => l_header_rec.header_id
1845: ,p_header_id => l_header_rec.header_id
1846: ,p_line_id => null

Line 1935: OE_MSG_PUB.Reset_Msg_Context('LINE');

1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932: END IF; -- bug 4732614 ends
1933: END IF; /*ASO installed */
1934:
1935: OE_MSG_PUB.Reset_Msg_Context('LINE');
1936: /********************GENESIS********************************
1937: * Some statuses are not going through process order and *
1938: * the update_flow_status is getting called directly. So *
1939: * we need to call synch_header_line for AIA enabled order *

Line 2114: OE_MSG_PUB.Reset_Msg_Context('LINE');

2110: IF l_debug_level > 0 THEN
2111: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: NO_DATA_FOUND' ) ;
2112: END IF;
2113: IF p_line_id IS NOT NULL THEN
2114: OE_MSG_PUB.Reset_Msg_Context('LINE');
2115: ELSIF p_header_id IS NOT NULL THEN
2116: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2117: END IF;
2118: WHEN FND_API.G_EXC_ERROR THEN

Line 2116: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2112: END IF;
2113: IF p_line_id IS NOT NULL THEN
2114: OE_MSG_PUB.Reset_Msg_Context('LINE');
2115: ELSIF p_header_id IS NOT NULL THEN
2116: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2117: END IF;
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2120: IF l_debug_level > 0 THEN

Line 2125: OE_MSG_PUB.Reset_Msg_Context('LINE');

2121: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: ERROR' , 5 ) ;
2122: END IF;
2123: x_return_status := FND_API.G_RET_STS_ERROR;
2124: IF p_line_id IS NOT NULL THEN
2125: OE_MSG_PUB.Reset_Msg_Context('LINE');
2126: ELSIF p_header_id IS NOT NULL THEN
2127: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2128: END IF;
2129: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 2127: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2123: x_return_status := FND_API.G_RET_STS_ERROR;
2124: IF p_line_id IS NOT NULL THEN
2125: OE_MSG_PUB.Reset_Msg_Context('LINE');
2126: ELSIF p_header_id IS NOT NULL THEN
2127: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2128: END IF;
2129: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2130: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2131: IF l_debug_level > 0 THEN

Line 2135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2131: IF l_debug_level > 0 THEN
2132: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: LOCK EXC' , 5 ) ;
2133: END IF;
2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2136: THEN
2137: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2138: OE_MSG_PUB.Add;
2139: END IF;

Line 2138: OE_MSG_PUB.Add;

2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2136: THEN
2137: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2138: OE_MSG_PUB.Add;
2139: END IF;
2140: IF p_line_id IS NOT NULL THEN
2141: OE_MSG_PUB.Reset_Msg_Context('LINE');
2142: ELSIF p_header_id IS NOT NULL THEN

Line 2141: OE_MSG_PUB.Reset_Msg_Context('LINE');

2137: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2138: OE_MSG_PUB.Add;
2139: END IF;
2140: IF p_line_id IS NOT NULL THEN
2141: OE_MSG_PUB.Reset_Msg_Context('LINE');
2142: ELSIF p_header_id IS NOT NULL THEN
2143: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2144: END IF;
2145: WHEN OTHERS THEN

Line 2143: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2139: END IF;
2140: IF p_line_id IS NOT NULL THEN
2141: OE_MSG_PUB.Reset_Msg_Context('LINE');
2142: ELSIF p_header_id IS NOT NULL THEN
2143: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2144: END IF;
2145: WHEN OTHERS THEN
2146: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2147: IF l_debug_level > 0 THEN

Line 2154: OE_MSG_PUB.Add_Exc_Msg

2150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2151: IF FND_MSG_PUB.Check_Msg_Level
2152: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2153: THEN
2154: OE_MSG_PUB.Add_Exc_Msg
2155: ( G_PKG_NAME
2156: , 'Update_Flow_Status_Code'
2157: );
2158: END IF;

Line 2160: OE_MSG_PUB.Reset_Msg_Context('LINE');

2156: , 'Update_Flow_Status_Code'
2157: );
2158: END IF;
2159: IF p_line_id IS NOT NULL THEN
2160: OE_MSG_PUB.Reset_Msg_Context('LINE');
2161: ELSIF p_header_id IS NOT NULL THEN
2162: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2163: END IF;
2164: END Update_Flow_Status_Code;

Line 2162: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2158: END IF;
2159: IF p_line_id IS NOT NULL THEN
2160: OE_MSG_PUB.Reset_Msg_Context('LINE');
2161: ELSIF p_header_id IS NOT NULL THEN
2162: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2163: END IF;
2164: END Update_Flow_Status_Code;
2165:
2166:

Line 2363: OE_MSG_PUB.set_msg_context

2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: END IF;
2361:
2362: -- is entity HEADER correct?
2363: OE_MSG_PUB.set_msg_context
2364: ( p_entity_code => 'HEADER'
2365: ,p_entity_id => l_header_rec.header_id
2366: ,p_header_id => l_header_rec.header_id
2367: ,p_line_id => null

Line 2525: OE_MSG_PUB.set_msg_context

2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2524:
2525: OE_MSG_PUB.set_msg_context
2526: ( p_entity_code => 'BLANKET'
2527: ,p_entity_id => p_header_id
2528: ,p_header_id => p_header_id);
2529:

Line 2593: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2589: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: NO_DATA_FOUND' ) ;
2590: END IF;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: IF l_header_id IS NOT NULL THEN
2593: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2594: END IF;
2595: WHEN FND_API.G_EXC_ERROR THEN
2596: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2597: IF l_debug_level > 0 THEN

Line 2602: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2598: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: ERROR' , 5 ) ;
2599: END IF;
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: IF l_header_id IS NOT NULL THEN
2602: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2603: END IF;
2604: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2605: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2606: IF l_debug_level > 0 THEN

Line 2610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2606: IF l_debug_level > 0 THEN
2607: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: LOCK EXC' , 5 ) ;
2608: END IF;
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2611: THEN
2612: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2613: OE_MSG_PUB.Add;
2614: END IF;

Line 2613: OE_MSG_PUB.Add;

2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2611: THEN
2612: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2613: OE_MSG_PUB.Add;
2614: END IF;
2615: IF l_header_id IS NOT NULL THEN
2616: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2617: END IF;

Line 2616: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2612: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2613: OE_MSG_PUB.Add;
2614: END IF;
2615: IF l_header_id IS NOT NULL THEN
2616: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2617: END IF;
2618: WHEN OTHERS THEN
2619: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2620: IF l_debug_level > 0 THEN

Line 2627: OE_MSG_PUB.Add_Exc_Msg

2623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2624: IF FND_MSG_PUB.Check_Msg_Level
2625: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2626: THEN
2627: OE_MSG_PUB.Add_Exc_Msg
2628: ( G_PKG_NAME
2629: , 'Update_Quote_Blanket'
2630: );
2631: END IF;

Line 2633: OE_MSG_PUB.Reset_Msg_Context('HEADER');

2629: , 'Update_Quote_Blanket'
2630: );
2631: END IF;
2632: IF l_header_id IS NOT NULL THEN
2633: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2634: END IF;
2635:
2636: END Update_Quote_Blanket;
2637:

Line 2740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2736: END IF;
2737:
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2741: THEN
2742: OE_MSG_PUB.Add_Exc_Msg
2743: ( G_PKG_NAME
2744: , 'Create_WorkItem_Upgrade'

Line 2742: OE_MSG_PUB.Add_Exc_Msg

2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2741: THEN
2742: OE_MSG_PUB.Add_Exc_Msg
2743: ( G_PKG_NAME
2744: , 'Create_WorkItem_Upgrade'
2745: );
2746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2797: EXCEPTION
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: RAISE;
2800: WHEN OTHERS THEN
2801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2802: THEN
2803: OE_MSG_PUB.Add_Exc_Msg
2804: ( G_PKG_NAME
2805: , 'CreateStart_HdrInternal'

Line 2803: OE_MSG_PUB.Add_Exc_Msg

2799: RAISE;
2800: WHEN OTHERS THEN
2801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2802: THEN
2803: OE_MSG_PUB.Add_Exc_Msg
2804: ( G_PKG_NAME
2805: , 'CreateStart_HdrInternal'
2806: );
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2946: EXCEPTION
2947: WHEN FND_API.G_EXC_ERROR THEN
2948: RAISE;
2949: WHEN OTHERS THEN
2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2951: THEN
2952: OE_MSG_PUB.Add_Exc_Msg
2953: ( G_PKG_NAME
2954: , 'Create_HdrWorkItemInternal'

Line 2952: OE_MSG_PUB.Add_Exc_Msg

2948: RAISE;
2949: WHEN OTHERS THEN
2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2951: THEN
2952: OE_MSG_PUB.Add_Exc_Msg
2953: ( G_PKG_NAME
2954: , 'Create_HdrWorkItemInternal'
2955: );
2956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2979: , p_header_id
2980: , l_user_key);
2981: EXCEPTION
2982: WHEN OTHERS THEN
2983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2984: THEN
2985: OE_MSG_PUB.Add_Exc_Msg
2986: ( G_PKG_NAME
2987: , 'Set_Negotiate_Hdr_User_Key'

Line 2985: OE_MSG_PUB.Add_Exc_Msg

2981: EXCEPTION
2982: WHEN OTHERS THEN
2983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2984: THEN
2985: OE_MSG_PUB.Add_Exc_Msg
2986: ( G_PKG_NAME
2987: , 'Set_Negotiate_Hdr_User_Key'
2988: );
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3006: , p_header_id
3007: , l_user_key);
3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3011: THEN
3012: OE_MSG_PUB.Add_Exc_Msg
3013: ( G_PKG_NAME
3014: , 'Set_Blanket_Hdr_User_Key'

Line 3012: OE_MSG_PUB.Add_Exc_Msg

3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3011: THEN
3012: OE_MSG_PUB.Add_Exc_Msg
3013: ( G_PKG_NAME
3014: , 'Set_Blanket_Hdr_User_Key'
3015: );
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3881: OE_MSG_PUB.ADD;

3877: FETCH c_eligible_activity into l_activity;
3878: IF c_eligible_activity%NOTFOUND THEN
3879: oe_debug_pub.add('c_eligible_activity NOT FOUND');
3880: fnd_message.set_name('ONT','OE_NO_ELIGIBLE_ACTIVITIES');
3881: OE_MSG_PUB.ADD;
3882: ELSE
3883: close c_eligible_activity;
3884: IF l_debug_level > 0 THEN
3885: oe_debug_pub.add('ELIGIBLE Activity: ' || l_activity);

Line 3915: OE_MSG_PUB.ADD;

3911: IF l_debug_level > 0 THEN
3912: oe_debug_pub.add('BOOKING IS DEFERRED' );
3913: END IF;
3914: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_DEFERRED');
3915: OE_MSG_PUB.ADD;
3916: CLOSE book_deferred;
3917: ELSE
3918: select MEANING
3919: into l_flow_status

Line 3929: OE_MSG_PUB.ADD;

3925: AND NVL(END_DATE_ACTIVE, SYSDATE);
3926:
3927: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_NOT_BOOKED');
3928: FND_MESSAGE.SET_TOKEN('FLOW_STATUS', l_flow_status);
3929: OE_MSG_PUB.ADD;
3930: END IF; -- book_deferred%FOUND
3931: ELSE -- book_eligible%NOTFOUND
3932: IF l_debug_level > 0 THEN
3933: oe_debug_pub.add('Calling OE_Order_Book_Util.Complete_Book_Eligible' ) ;

Line 3954: OE_MSG_PUB.Count_And_Get

3950: x_return_status := FND_API.G_RET_STS_ERROR;
3951: IF (book_eligible%ISOPEN) THEN
3952: CLOSE book_eligible;
3953: END IF;
3954: OE_MSG_PUB.Count_And_Get
3955: ( p_count => x_msg_count
3956: , p_data => x_msg_data
3957: );
3958: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

Line 3958: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

3954: OE_MSG_PUB.Count_And_Get
3955: ( p_count => x_msg_count
3956: , p_data => x_msg_data
3957: );
3958: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
3959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: IF (book_eligible%ISOPEN) THEN
3962: CLOSE book_eligible;

Line 3964: OE_MSG_PUB.Count_And_Get

3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: IF (book_eligible%ISOPEN) THEN
3962: CLOSE book_eligible;
3963: END IF;
3964: OE_MSG_PUB.Count_And_Get
3965: ( p_count => x_msg_count
3966: , p_data => x_msg_data
3967: );
3968: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

Line 3968: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

3964: OE_MSG_PUB.Count_And_Get
3965: ( p_count => x_msg_count
3966: , p_data => x_msg_data
3967: );
3968: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
3969: WHEN OTHERS THEN
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971: IF (book_eligible%ISOPEN) THEN
3972: CLOSE book_eligible;

Line 3974: IF OE_MSG_PUB.Check_Msg_Level

3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971: IF (book_eligible%ISOPEN) THEN
3972: CLOSE book_eligible;
3973: END IF;
3974: IF OE_MSG_PUB.Check_Msg_Level
3975: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3976: THEN
3977: OE_MSG_PUB.Add_Exc_Msg
3978: ( G_PKG_NAME

Line 3975: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3971: IF (book_eligible%ISOPEN) THEN
3972: CLOSE book_eligible;
3973: END IF;
3974: IF OE_MSG_PUB.Check_Msg_Level
3975: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3976: THEN
3977: OE_MSG_PUB.Add_Exc_Msg
3978: ( G_PKG_NAME
3979: , l_api_name

Line 3977: OE_MSG_PUB.Add_Exc_Msg

3973: END IF;
3974: IF OE_MSG_PUB.Check_Msg_Level
3975: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3976: THEN
3977: OE_MSG_PUB.Add_Exc_Msg
3978: ( G_PKG_NAME
3979: , l_api_name
3980: );
3981: END IF;

Line 3982: OE_MSG_PUB.Count_And_Get

3978: ( G_PKG_NAME
3979: , l_api_name
3980: );
3981: END IF;
3982: OE_MSG_PUB.Count_And_Get
3983: ( p_count => x_msg_count
3984: , p_data => x_msg_data
3985: );
3986: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

Line 3986: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

3982: OE_MSG_PUB.Count_And_Get
3983: ( p_count => x_msg_count
3984: , p_data => x_msg_data
3985: );
3986: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
3987:
3988: end Complete_eligible_and_Book;
3989:
3990: