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_SET_UTIL dependencies on OE_MSG_PUB

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

43:
44:
45: WHEN OTHERS THEN
46:
47: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
48: THEN
49: OE_MSG_PUB.Add_Exc_Msg
50: ( G_PKG_NAME ,
51: 'Is Set Closed'

Line 49: OE_MSG_PUB.Add_Exc_Msg

45: WHEN OTHERS THEN
46:
47: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
48: THEN
49: OE_MSG_PUB.Add_Exc_Msg
50: ( G_PKG_NAME ,
51: 'Is Set Closed'
52: );
53: END IF;

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

201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202:
203: WHEN OTHERS THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: OE_MSG_PUB.Add_Exc_Msg
208: ( 'OE_SET_UTIL',
209: 'Validate_Shipset');

Line 207: OE_MSG_PUB.Add_Exc_Msg

203: WHEN OTHERS THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: OE_MSG_PUB.Add_Exc_Msg
208: ( 'OE_SET_UTIL',
209: 'Validate_Shipset');
210: END IF;
211: END Validate_Shipset;

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

247:
248: RETURN FALSE;
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: OE_MSG_PUB.Add_Exc_Msg
254: ( 'OE_SET_UTIL',
255: 'Is_Service_Eligible');

Line 253: OE_MSG_PUB.Add_Exc_Msg

249: EXCEPTION
250: WHEN OTHERS THEN
251: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: OE_MSG_PUB.Add_Exc_Msg
254: ( 'OE_SET_UTIL',
255: 'Is_Service_Eligible');
256: END IF;
257: RETURN FALSE;

Line 294: oe_msg_pub.add;

290: IF is_set_closed(p_set_id => p_set_id) THEN
291: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
292: FND_MESSAGE.SET_TOKEN('SET',
293: l_set_rec.set_name);
294: oe_msg_pub.add;
295: RAISE FND_API.G_EXC_ERROR ;
296: END IF;
297:
298: Insert into oe_line_sets(

Line 333: oe_msg_pub.count_and_get

329: WHEN FND_API.G_EXC_ERROR THEN
330:
331:
332: -- Get message count and data
333: oe_msg_pub.count_and_get
334: ( p_count => x_msg_count
335: , p_data => x_msg_data
336: );
337: IF l_debug_level > 0 THEN

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

342:
343:
344: WHEN OTHERS THEN
345:
346: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: OE_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME ,
350: 'Create_Fulfillment_Set'

Line 348: OE_MSG_PUB.Add_Exc_Msg

344: WHEN OTHERS THEN
345:
346: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: OE_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME ,
350: 'Create_Fulfillment_Set'
351: );
352: END IF;

Line 423: oe_msg_pub.add;

419: oe_line_util.query_row(p_line_id => p_line_id,
420: x_line_rec => l_line_rec);
421: IF (nvl(l_line_rec.fulfilled_flag,'N') = 'Y') THEN
422: fnd_message.set_name('ONT', 'OE_LINE_FULFILLED');
423: oe_msg_pub.add;
424: RAISE FND_API.G_EXC_ERROR ;
425: END IF;
426: 2525203 */
427:

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

464: RAISE FND_API.G_EXC_ERROR;
465:
466: WHEN OTHERS THEN
467:
468: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
469: THEN
470: OE_MSG_PUB.Add_Exc_Msg
471: ( G_PKG_NAME ,
472: 'Delete Fulfillment Set'

Line 470: OE_MSG_PUB.Add_Exc_Msg

466: WHEN OTHERS THEN
467:
468: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
469: THEN
470: OE_MSG_PUB.Add_Exc_Msg
471: ( G_PKG_NAME ,
472: 'Delete Fulfillment Set'
473: );
474: END IF;

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

690: RAISE FND_API.G_EXC_ERROR;
691:
692: WHEN OTHERS THEN
693:
694: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: OE_MSG_PUB.Add_Exc_Msg
697: ( G_PKG_NAME ,
698: 'Process Options'

Line 696: OE_MSG_PUB.Add_Exc_Msg

692: WHEN OTHERS THEN
693:
694: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: OE_MSG_PUB.Add_Exc_Msg
697: ( G_PKG_NAME ,
698: 'Process Options'
699: );
700: END IF;

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

823:
824: RAISE FND_API.G_EXC_ERROR;
825:
826: WHEN OTHERS THEN
827: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: OE_MSG_PUB.Add_Exc_Msg
830: ( G_PKG_NAME ,
831: 'Get_Options'

Line 829: OE_MSG_PUB.Add_Exc_Msg

825:
826: WHEN OTHERS THEN
827: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: OE_MSG_PUB.Add_Exc_Msg
830: ( G_PKG_NAME ,
831: 'Get_Options'
832: );
833: END IF;

Line 1342: oe_msg_pub.count_and_get

1338:
1339: -- Get message count and data
1340:
1341:
1342: oe_msg_pub.count_and_get
1343: ( p_count => x_msg_count
1344: , p_data => x_msg_data
1345: );
1346: IF l_debug_level > 0 THEN

Line 1352: oe_msg_pub.count_and_get

1348: END IF;
1349: RAISE FND_API.G_EXC_ERROR;
1350:
1351: WHEN OTHERS THEN
1352: oe_msg_pub.count_and_get
1353: ( p_count => x_msg_count
1354: , p_data => x_msg_data
1355: );
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1493: oe_msg_pub.count_and_get

1489:
1490: -- Get message count and data
1491:
1492:
1493: oe_msg_pub.count_and_get
1494: ( p_count => x_msg_count
1495: , p_data => x_msg_data
1496: );
1497: IF l_debug_level > 0 THEN

Line 1507: oe_msg_pub.count_and_get

1503:
1504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1505: -- Get message count and data
1506:
1507: oe_msg_pub.count_and_get
1508: ( p_count => x_msg_count
1509: , p_data => x_msg_data
1510: );
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1516: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1512: WHEN OTHERS THEN
1513:
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515:
1516: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1517: THEN
1518: oe_msg_pub.Add_Exc_Msg
1519: ( G_PKG_NAME
1520: , 'Insert_Into_Set'

Line 1518: oe_msg_pub.Add_Exc_Msg

1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515:
1516: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1517: THEN
1518: oe_msg_pub.Add_Exc_Msg
1519: ( G_PKG_NAME
1520: , 'Insert_Into_Set'
1521: );
1522: END IF;

Line 1526: oe_msg_pub.count_and_get

1522: END IF;
1523:
1524: -- Get message count and data
1525:
1526: oe_msg_pub.count_and_get
1527: ( p_count => x_msg_count
1528: , p_data => x_msg_data
1529: );
1530:

Line 1624: oe_msg_pub.add;

1620: IF is_set_closed(l_set_id) THEN
1621: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
1622: FND_MESSAGE.SET_TOKEN('SET',
1623: p_set_name);
1624: oe_msg_pub.add;
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627: END IF;
1628: if (p_operation = 'REMOVE' ) THEN

Line 1667: OE_MSG_PUB.set_msg_context

1663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1664: RAISE FND_API.G_EXC_ERROR;
1665: END IF;
1666:
1667: OE_MSG_PUB.set_msg_context
1668: ( p_entity_code => 'LINE'
1669: ,p_entity_id => l_line_rec.line_id
1670: ,p_header_id => l_line_rec.header_id
1671: ,p_line_id => l_line_rec.line_id

Line 1721: OE_MSG_PUB.ADD;

1717:
1718: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
1719: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
1720: -- l_line_tbl(I).item_type_code);
1721: OE_MSG_PUB.ADD;
1722: IF l_debug_level > 0 THEN
1723: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
1724: END IF;
1725: RAISE FND_API.G_EXC_ERROR;

Line 1745: oe_msg_pub.add;

1741: END IF;
1742: /* Changed the message to fix the bug 2862565 */
1743: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
1744: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
1745: oe_msg_pub.add;
1746: /* Changed the message to fix the bug 2862565 */
1747: RAISE FND_API.G_EXC_ERROR;
1748: END IF;
1749:

Line 1849: oe_msg_pub.count_and_get

1845:
1846: -- Get message count and data
1847:
1848:
1849: oe_msg_pub.count_and_get
1850: ( p_count => x_msg_count
1851: , p_data => x_msg_data
1852: );
1853: IF l_debug_level > 0 THEN

Line 1866: oe_msg_pub.count_and_get

1862:
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864: -- Get message count and data
1865:
1866: oe_msg_pub.count_and_get
1867: ( p_count => x_msg_count
1868: , p_data => x_msg_data
1869: );
1870: IF l_debug_level > 0 THEN

Line 1882: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1878: WHEN OTHERS THEN
1879:
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1881:
1882: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1883: THEN
1884: oe_msg_pub.Add_Exc_Msg
1885: ( G_PKG_NAME
1886: , 'Process_Sets'

Line 1884: oe_msg_pub.Add_Exc_Msg

1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1881:
1882: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1883: THEN
1884: oe_msg_pub.Add_Exc_Msg
1885: ( G_PKG_NAME
1886: , 'Process_Sets'
1887: );
1888: END IF;

Line 1892: oe_msg_pub.count_and_get

1888: END IF;
1889:
1890: -- Get message count and data
1891:
1892: oe_msg_pub.count_and_get
1893: ( p_count => x_msg_count
1894: , p_data => x_msg_data
1895: );
1896: ROLLBACK TO SAVEPOINT New_Process_sets;

Line 2012: oe_msg_pub.add;

2008: p_set_name IS NULL OR
2009: p_set_type IS NULL) THEN
2010: fnd_message.set_name('ONT', 'OE_SET_REQ_ARG');
2011: FND_MESSAGE.SET_TOKEN('SET',p_set_name);
2012: oe_msg_pub.add;
2013: RAISE FND_API.G_EXC_ERROR ;
2014: -- Require all three header,set name ane set type to create
2015: END IF;
2016: IF l_debug_level > 0 THEN

Line 2034: oe_msg_pub.add;

2030: --p_Freight_Carrier_Code IS NULL OR
2031: --p_Shipping_Method_Code IS NULL) THEN
2032: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
2033: FND_MESSAGE.SET_TOKEN('SET',p_set_name);
2034: oe_msg_pub.add;
2035: RAISE FND_API.G_EXC_ERROR;
2036: -- set attributes cannot be null
2037: ELSIF (p_set_type = 'ARRIVAL_SET') AND
2038: (p_Ship_to_org_id IS NULL OR

Line 2043: oe_msg_pub.add;

2039: p_Schedule_arrival_date IS NULL)THEN
2040: -- Arrival set attributes cannot be null
2041: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
2042: FND_MESSAGE.SET_TOKEN('SET',p_set_name);
2043: oe_msg_pub.add;
2044: RAISE FND_API.G_EXC_ERROR;
2045:
2046: END IF; */
2047:

Line 2118: oe_msg_pub.count_and_get

2114:
2115: -- Get message count and data
2116:
2117:
2118: oe_msg_pub.count_and_get
2119: ( p_count => x_msg_count
2120: , p_data => x_msg_data
2121: );
2122: IF l_debug_level > 0 THEN

Line 2131: oe_msg_pub.count_and_get

2127:
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2129: -- Get message count and data
2130:
2131: oe_msg_pub.count_and_get
2132: ( p_count => x_msg_count
2133: , p_data => x_msg_data
2134: );
2135: WHEN OTHERS THEN

Line 2139: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2135: WHEN OTHERS THEN
2136:
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138:
2139: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2140: THEN
2141: oe_msg_pub.Add_Exc_Msg
2142: ( G_PKG_NAME
2143: , 'create_Set'

Line 2141: oe_msg_pub.Add_Exc_Msg

2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138:
2139: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2140: THEN
2141: oe_msg_pub.Add_Exc_Msg
2142: ( G_PKG_NAME
2143: , 'create_Set'
2144: );
2145: END IF;

Line 2149: oe_msg_pub.count_and_get

2145: END IF;
2146:
2147: -- Get message count and data
2148:
2149: oe_msg_pub.count_and_get
2150: ( p_count => x_msg_count
2151: , p_data => x_msg_data
2152: );
2153:

Line 2743: oe_msg_pub.count_and_get

2739:
2740: -- Get message count and data
2741:
2742:
2743: oe_msg_pub.count_and_get
2744: ( p_count => x_msg_count
2745: , p_data => x_msg_data
2746: );
2747: IF l_debug_level > 0 THEN

Line 2757: oe_msg_pub.count_and_get

2753:
2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2755: -- Get message count and data
2756:
2757: oe_msg_pub.count_and_get
2758: ( p_count => x_msg_count
2759: , p_data => x_msg_data
2760: );
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2766: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2762: WHEN OTHERS THEN
2763:
2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2765:
2766: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2767: THEN
2768: oe_msg_pub.Add_Exc_Msg
2769: ( G_PKG_NAME
2770: , 'Insert_Into_Set'

Line 2768: oe_msg_pub.Add_Exc_Msg

2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2765:
2766: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2767: THEN
2768: oe_msg_pub.Add_Exc_Msg
2769: ( G_PKG_NAME
2770: , 'Insert_Into_Set'
2771: );
2772: END IF;

Line 2776: oe_msg_pub.count_and_get

2772: END IF;
2773:
2774: -- Get message count and data
2775:
2776: oe_msg_pub.count_and_get
2777: ( p_count => x_msg_count
2778: , p_data => x_msg_data
2779: );
2780:

Line 2890: oe_msg_pub.count_and_get

2886:
2887: -- Get message count and data
2888:
2889:
2890: oe_msg_pub.count_and_get
2891: ( p_count => x_msg_count
2892: , p_data => x_msg_data
2893: );
2894:

Line 2900: oe_msg_pub.count_and_get

2896:
2897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2898: -- Get message count and data
2899:
2900: oe_msg_pub.count_and_get
2901: ( p_count => x_msg_count
2902: , p_data => x_msg_data
2903: );
2904: WHEN OTHERS THEN

Line 2908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2904: WHEN OTHERS THEN
2905:
2906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2907:
2908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2909: THEN
2910: oe_msg_pub.Add_Exc_Msg
2911: ( G_PKG_NAME
2912: , 'Update_set'

Line 2910: oe_msg_pub.Add_Exc_Msg

2906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2907:
2908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2909: THEN
2910: oe_msg_pub.Add_Exc_Msg
2911: ( G_PKG_NAME
2912: , 'Update_set'
2913: );
2914: END IF;

Line 2918: oe_msg_pub.count_and_get

2914: END IF;
2915:
2916: -- Get message count and data
2917:
2918: oe_msg_pub.count_and_get
2919: ( p_count => x_msg_count
2920: , p_data => x_msg_data
2921: );
2922: End Update_Set;

Line 2972: oe_msg_pub.add;

2968: (p_shipment_priority_code <> l_set_rec.shipment_priority_code) THEN
2969: --RAISE FND_API.G_EXC_ERROR;
2970: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
2971: FND_MESSAGE.SET_TOKEN('SET','SHIP');
2972: oe_msg_pub.add;
2973: -- RAISE FND_API.G_EXC_ERROR ;
2974:
2975: NULL;
2976: END IF;

Line 2982: oe_msg_pub.add;

2978: IF (p_Schedule_Arrival_Date <> l_set_rec.Schedule_Arrival_Date) OR
2979: (p_Ship_To_Org_Id <> l_Set_rec.Ship_To_Org_Id) THEN
2980: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
2981: FND_MESSAGE.SET_TOKEN('SET','ARRIVAL');
2982: oe_msg_pub.add;
2983: --RAISE FND_API.G_EXC_ERROR ;
2984: NULL;
2985: END IF;
2986: END IF;

Line 2996: oe_msg_pub.count_and_get

2992:
2993: -- Get message count and data
2994:
2995:
2996: oe_msg_pub.count_and_get
2997: ( p_count => x_msg_count
2998: , p_data => x_msg_data
2999: );
3000:

Line 3006: oe_msg_pub.count_and_get

3002:
3003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3004: -- Get message count and data
3005:
3006: oe_msg_pub.count_and_get
3007: ( p_count => x_msg_count
3008: , p_data => x_msg_data
3009: );
3010: WHEN OTHERS THEN

Line 3014: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

3010: WHEN OTHERS THEN
3011:
3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3013:
3014: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3015: THEN
3016: oe_msg_pub.Add_Exc_Msg
3017: ( G_PKG_NAME
3018: , 'Validate_Set_Attributes'

Line 3016: oe_msg_pub.Add_Exc_Msg

3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3013:
3014: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3015: THEN
3016: oe_msg_pub.Add_Exc_Msg
3017: ( G_PKG_NAME
3018: , 'Validate_Set_Attributes'
3019: );
3020: END IF;

Line 3024: oe_msg_pub.count_and_get

3020: END IF;
3021:
3022: -- Get message count and data
3023:
3024: oe_msg_pub.count_and_get
3025: ( p_count => x_msg_count
3026: , p_data => x_msg_data
3027: );
3028: NULL;

Line 3162: oe_msg_pub.add;

3158: IF is_set_closed(l_set_id) THEN
3159:
3160: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
3161: FND_MESSAGE.SET_TOKEN('SET', p_set_name);
3162: oe_msg_pub.add;
3163: RAISE FND_API.G_EXC_ERROR;
3164: END IF;
3165: END IF;
3166:

Line 3220: OE_MSG_PUB.set_msg_context

3216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3217: RAISE FND_API.G_EXC_ERROR;
3218: END IF;
3219:
3220: OE_MSG_PUB.set_msg_context
3221: ( p_entity_code => 'LINE'
3222: ,p_entity_id => l_line_rec.line_id
3223: ,p_header_id => l_line_rec.header_id
3224: ,p_line_id => l_line_rec.line_id

Line 3246: OE_MSG_PUB.ADD;

3242: OR (l_line_rec.line_category_code = 'RETURN' AND
3243: p_set_type <> 'FULFILLMENT') THEN
3244:
3245: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3246: OE_MSG_PUB.ADD;
3247: IF l_debug_level > 0 THEN
3248: oe_debug_pub.add( 'LINE IS NOT VALID TO ADD: ' || L_LINE_REC.LINE_ID , 1 ) ;
3249: END IF;
3250: GOTO do_not_process;

Line 3285: OE_MSG_PUB.ADD;

3281:
3282: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3283: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
3284: -- l_line_tbl(I).item_type_code);
3285: OE_MSG_PUB.ADD;
3286: IF l_debug_level > 0 THEN
3287: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
3288: END IF;
3289: RAISE FND_API.G_EXC_ERROR;

Line 3304: oe_msg_pub.add;

3300: /* Changed the message to fix the bug 2862565 */
3301: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
3302: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
3303: /* Changed the message to fix the bug 2862565 */
3304: oe_msg_pub.add;
3305: RAISE FND_API.G_EXC_ERROR;
3306: END IF;
3307:
3308: IF (l_set_id IS NULL) THEN

Line 3660: oe_msg_pub.add;

3656: IF l_debug_level > 0 THEN
3657: oe_debug_pub.add( 'BEFORE FAILING AT SET NAME' , 1 ) ;
3658: END IF;
3659: fnd_message.set_name('ONT', 'OE_SET_NAME_REQ');
3660: oe_msg_pub.add;
3661: RAISE FND_API.G_EXC_ERROR ;
3662: END IF;
3663: IF p_operation <> 'REMOVE' THEN
3664: IF p_set_type <> 'FULFILLMENT'

Line 3892: oe_msg_pub.count_and_get

3888: NULL;
3889:
3890: --x_return_status := l_return_status;
3891:
3892: oe_msg_pub.count_and_get
3893: ( p_count => x_msg_count
3894: , p_data => x_msg_data
3895: );
3896:

Line 3906: oe_msg_pub.count_and_get

3902:
3903: -- Get message count and data
3904:
3905:
3906: oe_msg_pub.count_and_get
3907: ( p_count => x_msg_count
3908: , p_data => x_msg_data
3909: );
3910: IF l_debug_level > 0 THEN

Line 3923: oe_msg_pub.count_and_get

3919:
3920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3921: -- Get message count and data
3922:
3923: oe_msg_pub.count_and_get
3924: ( p_count => x_msg_count
3925: , p_data => x_msg_data
3926: );
3927: IF l_debug_level > 0 THEN

Line 3939: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

3935: WHEN OTHERS THEN
3936:
3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3938:
3939: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3940: THEN
3941: oe_msg_pub.Add_Exc_Msg
3942: ( G_PKG_NAME
3943: , 'Process_Sets'

Line 3941: oe_msg_pub.Add_Exc_Msg

3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3938:
3939: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3940: THEN
3941: oe_msg_pub.Add_Exc_Msg
3942: ( G_PKG_NAME
3943: , 'Process_Sets'
3944: );
3945: END IF;

Line 3949: oe_msg_pub.count_and_get

3945: END IF;
3946:
3947: -- Get message count and data
3948:
3949: oe_msg_pub.count_and_get
3950: ( p_count => x_msg_count
3951: , p_data => x_msg_data
3952: );
3953: ROLLBACK TO SAVEPOINT Process_sets;

Line 3995: oe_msg_pub.count_and_get

3991:
3992: -- Get message count and data
3993:
3994:
3995: oe_msg_pub.count_and_get
3996: ( p_count => x_msg_count
3997: , p_data => x_msg_data
3998: );
3999:

Line 4005: oe_msg_pub.count_and_get

4001:
4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4003: -- Get message count and data
4004:
4005: oe_msg_pub.count_and_get
4006: ( p_count => x_msg_count
4007: , p_data => x_msg_data
4008: );
4009: WHEN OTHERS THEN

Line 4013: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

4009: WHEN OTHERS THEN
4010:
4011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4012:
4013: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4014: THEN
4015: oe_msg_pub.Add_Exc_Msg
4016: ( G_PKG_NAME
4017: , 'Split Sets'

Line 4015: oe_msg_pub.Add_Exc_Msg

4011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4012:
4013: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4014: THEN
4015: oe_msg_pub.Add_Exc_Msg
4016: ( G_PKG_NAME
4017: , 'Split Sets'
4018: );
4019: END IF;

Line 4023: oe_msg_pub.count_and_get

4019: END IF;
4020:
4021: -- Get message count and data
4022:
4023: oe_msg_pub.count_and_get
4024: ( p_count => x_msg_count
4025: , p_data => x_msg_data
4026: );
4027: End Split_Set;

Line 4317: oe_msg_pub.add;

4313: /* Changed the message to fix the bug 2862565 */
4314: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
4315: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
4316: /* Changed the message to fix the bug 2862565 */
4317: oe_msg_pub.add;
4318: RAISE FND_API.G_EXC_ERROR;
4319:
4320: /*IF Set_Exist(p_set_name => p_x_line_rec.arrival_set,
4321: p_set_type => 'ARRIVAL_SET',

Line 4336: oe_msg_pub.add;

4332:
4333: IF x_arrival_set_id IS NOT NULL AND
4334: nvl(l_set_id,-99) <> x_arrival_set_id THEN
4335: FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
4336: oe_msg_pub.add;
4337: RAISE FND_API.G_EXC_ERROR;
4338: END IF; */
4339:
4340: END IF; -- If ship set id

Line 4355: oe_msg_pub.add;

4351: IF l_set_rec.set_status = 'C' THEN
4352: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
4353: FND_MESSAGE.SET_TOKEN('SET',
4354: l_set_rec.set_name);
4355: oe_msg_pub.add;
4356: RAISE FND_API.G_EXC_ERROR;
4357: END IF;
4358:
4359: -- If set exists and line is getting inserted into an existing set then

Line 4580: oe_msg_pub.add;

4576: IF l_set_rec.set_status = 'C' THEN
4577: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
4578: FND_MESSAGE.SET_TOKEN('SET',
4579: l_set_rec.set_name);
4580: oe_msg_pub.add;
4581: RAISE FND_API.G_EXC_ERROR;
4582: END IF;
4583: p_x_line_rec.ship_to_org_id := l_set_rec.ship_to_org_id;
4584: p_x_line_rec.ship_from_org_id := l_set_rec.ship_from_org_id;

Line 4998: OE_MSG_PUB.ADD;

4994: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
4995: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
4996: -- p_x_line_rec.item_type_code);
4997:
4998: OE_MSG_PUB.ADD;
4999: oe_debug_pub.add('Set- not allowed for this itemtype');
5000: RAISE FND_API.G_EXC_ERROR;
5001:
5002: END IF;

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

5073:
5074:
5075: WHEN OTHERS THEN
5076:
5077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5078: THEN
5079: OE_MSG_PUB.Add_Exc_Msg
5080: ( G_PKG_NAME
5081: , 'Get_Set_Id'

Line 5079: OE_MSG_PUB.Add_Exc_Msg

5075: WHEN OTHERS THEN
5076:
5077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5078: THEN
5079: OE_MSG_PUB.Add_Exc_Msg
5080: ( G_PKG_NAME
5081: , 'Get_Set_Id'
5082: );
5083: END IF;

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

5169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5170:
5171: WHEN OTHERS THEN
5172:
5173: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5174: THEN
5175: OE_MSG_PUB.Add_Exc_Msg
5176: ( G_PKG_NAME
5177: , 'Query_Set_Rows'

Line 5175: OE_MSG_PUB.Add_Exc_Msg

5171: WHEN OTHERS THEN
5172:
5173: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5174: THEN
5175: OE_MSG_PUB.Add_Exc_Msg
5176: ( G_PKG_NAME
5177: , 'Query_Set_Rows'
5178: );
5179: END IF;

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

5246: RAISE FND_API.G_EXC_ERROR;
5247:
5248:
5249: WHEN OTHERS THEN
5250: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5251: THEN
5252: OE_MSG_PUB.Add_Exc_Msg
5253: ( G_PKG_NAME ,
5254: 'create_line_set'

Line 5252: OE_MSG_PUB.Add_Exc_Msg

5248:
5249: WHEN OTHERS THEN
5250: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5251: THEN
5252: OE_MSG_PUB.Add_Exc_Msg
5253: ( G_PKG_NAME ,
5254: 'create_line_set'
5255: );
5256: END IF;

Line 5395: OE_MSG_PUB.set_msg_context

5391: END;
5392:
5393: END IF;
5394:
5395: OE_MSG_PUB.set_msg_context
5396: ( p_entity_code => 'LINE'
5397: ,p_entity_id => l_line_rec.line_id
5398: ,p_header_id => l_line_rec.header_id
5399: ,p_line_id => l_line_rec.line_id

Line 5431: OE_MSG_PUB.ADD;

5427: OR (l_line_rec.line_category_code = 'RETURN' AND
5428: g_set_tbl(I).set_type <> 'FULFILLMENT_SET') THEN
5429:
5430: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5431: OE_MSG_PUB.ADD;
5432: IF l_debug_level > 0 THEN
5433: oe_debug_pub.add( 'LINE IS NOT VALID TO PROCESS: ' || L_LINE_REC.LINE_ID , 1 ) ;
5434: END IF;
5435: g_set_tbl(I).process_flag := 'Y' ;

Line 5459: OE_MSG_PUB.ADD;

5455:
5456: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5457: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
5458: -- l_line_rec.item_type_code);
5459: OE_MSG_PUB.ADD;
5460: IF l_debug_level > 0 THEN
5461: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
5462: END IF;
5463: --RAISE FND_API.G_EXC_ERROR;

Line 5577: OE_MSG_PUB.set_msg_context

5573: OR (l_line_rec.item_type_code = 'SERVICE'
5574: AND (g_set_tbl(J).set_type = 'ARRIVAL'
5575: OR g_set_tbl(J).set_type = 'SHIP')) THEN
5576:
5577: OE_MSG_PUB.set_msg_context
5578: ( p_entity_code => 'LINE'
5579: ,p_entity_id => l_line_rec.line_id
5580: ,p_header_id => l_line_rec.header_id
5581: ,p_line_id => l_line_rec.line_id

Line 5600: OE_MSG_PUB.ADD;

5596: l_line_rec.source_document_type_id);
5597: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5598: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
5599: -- l_line_rec.item_type_code);
5600: OE_MSG_PUB.ADD;
5601: IF l_debug_level > 0 THEN
5602: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
5603: END IF;
5604: --RAISE FND_API.G_EXC_ERROR;

Line 5668: oe_msg_pub.add;

5664: /* Changed the message to fix the bug 2862565 */
5665: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
5666: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
5667: /* Changed the message to fix the bug 2862565 */
5668: oe_msg_pub.add;
5669: RAISE FND_API.G_EXC_ERROR;
5670: END IF;
5671:
5672: END IF;

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

6029: RAISE FND_API.G_EXC_ERROR;
6030:
6031: WHEN OTHERS THEN
6032:
6033: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6034: THEN
6035: OE_MSG_PUB.Add_Exc_Msg
6036: ( G_PKG_NAME ,
6037: 'Process Sets'

Line 6035: OE_MSG_PUB.Add_Exc_Msg

6031: WHEN OTHERS THEN
6032:
6033: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6034: THEN
6035: OE_MSG_PUB.Add_Exc_Msg
6036: ( G_PKG_NAME ,
6037: 'Process Sets'
6038: );
6039: END IF;

Line 6220: oe_msg_pub.add;

6216: IF l_debug_level > 0 THEN
6217: oe_debug_pub.add( 'INVALID SER OPR' , 2 ) ;
6218: END IF;
6219: FND_MESSAGE.Set_Name('ONT', 'OE_SCH_NOT_IN_SHIP_ARR'); -- 2724197 New message added
6220: oe_msg_pub.add;
6221: RAISE FND_API.G_EXC_ERROR;
6222:
6223: END IF; -- not both sets populated.
6224:

Line 6439: oe_msg_pub.add;

6435: l_set_rec := get_set_rec(l_set_id);
6436: IF l_set_rec.set_status = 'C' THEN
6437: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6438: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6439: oe_msg_pub.add;
6440: GOTO NO_PROCESS;
6441: END IF; -- Set Status = 'C'
6442:
6443: IF l_debug_level > 0 THEN

Line 6488: oe_msg_pub.add;

6484: l_set_rec := get_set_rec(l_set_id);
6485: IF l_set_rec.set_status = 'C' THEN
6486: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6487: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6488: oe_msg_pub.add;
6489: GOTO NO_PROCESS;
6490:
6491: END IF; -- Set Status = 'C'
6492: p_x_line_rec.arrival_set_id := l_set_id;

Line 6544: oe_msg_pub.add;

6540: l_set_rec := get_set_rec(l_set_id);
6541: IF l_set_rec.set_status = 'C' THEN
6542: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6543: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6544: oe_msg_pub.add;
6545: GOTO NO_PROCESS;
6546: END IF; -- Set Status = 'C'
6547: p_x_line_rec.ship_set_id := l_set_id;
6548: l_set_type := 'SHIP_SET';

Line 6587: oe_msg_pub.add;

6583: l_set_rec := get_set_rec(l_set_id);
6584: IF l_set_rec.set_status = 'C' THEN
6585: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6586: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6587: oe_msg_pub.add;
6588: GOTO NO_PROCESS;
6589: END IF; -- Set Status = 'C'
6590: p_x_line_rec.ship_set_id := l_set_id;
6591: l_set_type := 'SHIP_SET';

Line 6919: OE_MSG_PUB.ADD;

6915: oe_debug_pub.add( 'ARRIVAL SHIP SET-' || P_OLD_LINE_REC.ARRIVAL_SET_ID ) ;
6916: END IF;
6917: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
6918: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_x_line_rec.item_type_code);
6919: OE_MSG_PUB.ADD;
6920: IF l_debug_level > 0 THEN
6921: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
6922: END IF;
6923: RAISE FND_API.G_EXC_ERROR;

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

7054:
7055:
7056: WHEN OTHERS THEN
7057:
7058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7059: THEN
7060: OE_MSG_PUB.Add_Exc_Msg
7061: ( G_PKG_NAME
7062: , 'Default_Line_Set'

Line 7060: OE_MSG_PUB.Add_Exc_Msg

7056: WHEN OTHERS THEN
7057:
7058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7059: THEN
7060: OE_MSG_PUB.Add_Exc_Msg
7061: ( G_PKG_NAME
7062: , 'Default_Line_Set'
7063: );
7064: END IF;

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

7207:
7208: EXCEPTION
7209: WHEN OTHERS THEN
7210:
7211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7212: THEN
7213: OE_MSG_PUB.Add_Exc_Msg
7214: ( G_PKG_NAME
7215: , 'Validate_Fulfillment_Set'

Line 7213: OE_MSG_PUB.Add_Exc_Msg

7209: WHEN OTHERS THEN
7210:
7211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7212: THEN
7213: OE_MSG_PUB.Add_Exc_Msg
7214: ( G_PKG_NAME
7215: , 'Validate_Fulfillment_Set'
7216: );
7217: END IF;

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

7293:
7294: WHEN OTHERS THEN
7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7296:
7297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: OE_MSG_PUB.Add_Exc_Msg
7300: ( G_PKG_NAME
7301: , 'Delete_Set'

Line 7299: OE_MSG_PUB.Add_Exc_Msg

7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7296:
7297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: OE_MSG_PUB.Add_Exc_Msg
7300: ( G_PKG_NAME
7301: , 'Delete_Set'
7302: );
7303: END IF;