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 261: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

257:
258: RETURN FALSE;
259: EXCEPTION
260: WHEN OTHERS THEN
261: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: OE_MSG_PUB.Add_Exc_Msg
264: ( 'OE_SET_UTIL',
265: 'Is_Service_Eligible');

Line 263: OE_MSG_PUB.Add_Exc_Msg

259: EXCEPTION
260: WHEN OTHERS THEN
261: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: OE_MSG_PUB.Add_Exc_Msg
264: ( 'OE_SET_UTIL',
265: 'Is_Service_Eligible');
266: END IF;
267: RETURN FALSE;

Line 318: oe_msg_pub.add;

314: WHEN Others THEN
315: l_set_s := 'U' ;
316: oe_debug_pub.add('Error while locking Set status : '||SQLERRM);
317: fnd_message.set_name('ONT', 'OE_SET_LOCKED');
318: oe_msg_pub.add;
319: RAISE FND_API.G_EXC_ERROR ;
320: END;
321:
322: oe_debug_pub.add('Create_Fulfillment_Set:'||OE_Set_util.g_set_rec.set_status ||' l_set_s ' || l_set_s);

Line 330: oe_msg_pub.add;

326: IF is_set_closed(p_set_id => p_set_id) THEN
327: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
328: FND_MESSAGE.SET_TOKEN('SET',
329: l_set_rec.set_name);
330: oe_msg_pub.add;
331: RAISE FND_API.G_EXC_ERROR ;
332: END IF;
333:
334: Insert into oe_line_sets(

Line 369: oe_msg_pub.count_and_get

365: WHEN FND_API.G_EXC_ERROR THEN
366:
367:
368: -- Get message count and data
369: oe_msg_pub.count_and_get
370: ( p_count => x_msg_count
371: , p_data => x_msg_data
372: );
373: IF l_debug_level > 0 THEN

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

378:
379:
380: WHEN OTHERS THEN
381:
382: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: OE_MSG_PUB.Add_Exc_Msg
385: ( G_PKG_NAME ,
386: 'Create_Fulfillment_Set'

Line 384: OE_MSG_PUB.Add_Exc_Msg

380: WHEN OTHERS THEN
381:
382: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: OE_MSG_PUB.Add_Exc_Msg
385: ( G_PKG_NAME ,
386: 'Create_Fulfillment_Set'
387: );
388: END IF;

Line 459: oe_msg_pub.add;

455: oe_line_util.query_row(p_line_id => p_line_id,
456: x_line_rec => l_line_rec);
457: IF (nvl(l_line_rec.fulfilled_flag,'N') = 'Y') THEN
458: fnd_message.set_name('ONT', 'OE_LINE_FULFILLED');
459: oe_msg_pub.add;
460: RAISE FND_API.G_EXC_ERROR ;
461: END IF;
462: 2525203 */
463:

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

500: RAISE FND_API.G_EXC_ERROR;
501:
502: WHEN OTHERS THEN
503:
504: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: OE_MSG_PUB.Add_Exc_Msg
507: ( G_PKG_NAME ,
508: 'Delete Fulfillment Set'

Line 506: OE_MSG_PUB.Add_Exc_Msg

502: WHEN OTHERS THEN
503:
504: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: OE_MSG_PUB.Add_Exc_Msg
507: ( G_PKG_NAME ,
508: 'Delete Fulfillment Set'
509: );
510: END IF;

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

726: RAISE FND_API.G_EXC_ERROR;
727:
728: WHEN OTHERS THEN
729:
730: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: OE_MSG_PUB.Add_Exc_Msg
733: ( G_PKG_NAME ,
734: 'Process Options'

Line 732: OE_MSG_PUB.Add_Exc_Msg

728: WHEN OTHERS THEN
729:
730: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: OE_MSG_PUB.Add_Exc_Msg
733: ( G_PKG_NAME ,
734: 'Process Options'
735: );
736: END IF;

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

859:
860: RAISE FND_API.G_EXC_ERROR;
861:
862: WHEN OTHERS THEN
863: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: OE_MSG_PUB.Add_Exc_Msg
866: ( G_PKG_NAME ,
867: 'Get_Options'

Line 865: OE_MSG_PUB.Add_Exc_Msg

861:
862: WHEN OTHERS THEN
863: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: OE_MSG_PUB.Add_Exc_Msg
866: ( G_PKG_NAME ,
867: 'Get_Options'
868: );
869: END IF;

Line 1378: oe_msg_pub.count_and_get

1374:
1375: -- Get message count and data
1376:
1377:
1378: oe_msg_pub.count_and_get
1379: ( p_count => x_msg_count
1380: , p_data => x_msg_data
1381: );
1382: IF l_debug_level > 0 THEN

Line 1388: oe_msg_pub.count_and_get

1384: END IF;
1385: RAISE FND_API.G_EXC_ERROR;
1386:
1387: WHEN OTHERS THEN
1388: oe_msg_pub.count_and_get
1389: ( p_count => x_msg_count
1390: , p_data => x_msg_data
1391: );
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1529: oe_msg_pub.count_and_get

1525:
1526: -- Get message count and data
1527:
1528:
1529: oe_msg_pub.count_and_get
1530: ( p_count => x_msg_count
1531: , p_data => x_msg_data
1532: );
1533: IF l_debug_level > 0 THEN

Line 1543: oe_msg_pub.count_and_get

1539:
1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1541: -- Get message count and data
1542:
1543: oe_msg_pub.count_and_get
1544: ( p_count => x_msg_count
1545: , p_data => x_msg_data
1546: );
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1548: WHEN OTHERS THEN
1549:
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1551:
1552: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1553: THEN
1554: oe_msg_pub.Add_Exc_Msg
1555: ( G_PKG_NAME
1556: , 'Insert_Into_Set'

Line 1554: oe_msg_pub.Add_Exc_Msg

1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1551:
1552: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1553: THEN
1554: oe_msg_pub.Add_Exc_Msg
1555: ( G_PKG_NAME
1556: , 'Insert_Into_Set'
1557: );
1558: END IF;

Line 1562: oe_msg_pub.count_and_get

1558: END IF;
1559:
1560: -- Get message count and data
1561:
1562: oe_msg_pub.count_and_get
1563: ( p_count => x_msg_count
1564: , p_data => x_msg_data
1565: );
1566:

Line 1660: oe_msg_pub.add;

1656: IF is_set_closed(l_set_id) THEN
1657: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
1658: FND_MESSAGE.SET_TOKEN('SET',
1659: p_set_name);
1660: oe_msg_pub.add;
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663: END IF;
1664: if (p_operation = 'REMOVE' ) THEN

Line 1703: OE_MSG_PUB.set_msg_context

1699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1700: RAISE FND_API.G_EXC_ERROR;
1701: END IF;
1702:
1703: OE_MSG_PUB.set_msg_context
1704: ( p_entity_code => 'LINE'
1705: ,p_entity_id => l_line_rec.line_id
1706: ,p_header_id => l_line_rec.header_id
1707: ,p_line_id => l_line_rec.line_id

Line 1759: OE_MSG_PUB.ADD;

1755:
1756: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
1757: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
1758: -- l_line_tbl(I).item_type_code);
1759: OE_MSG_PUB.ADD;
1760: IF l_debug_level > 0 THEN
1761: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
1762: END IF;
1763: RAISE FND_API.G_EXC_ERROR;

Line 1783: oe_msg_pub.add;

1779: END IF;
1780: /* Changed the message to fix the bug 2862565 */
1781: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
1782: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
1783: oe_msg_pub.add;
1784: /* Changed the message to fix the bug 2862565 */
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787:

Line 1887: oe_msg_pub.count_and_get

1883:
1884: -- Get message count and data
1885:
1886:
1887: oe_msg_pub.count_and_get
1888: ( p_count => x_msg_count
1889: , p_data => x_msg_data
1890: );
1891: IF l_debug_level > 0 THEN

Line 1904: oe_msg_pub.count_and_get

1900:
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1902: -- Get message count and data
1903:
1904: oe_msg_pub.count_and_get
1905: ( p_count => x_msg_count
1906: , p_data => x_msg_data
1907: );
1908: IF l_debug_level > 0 THEN

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

1916: WHEN OTHERS THEN
1917:
1918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1919:
1920: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1921: THEN
1922: oe_msg_pub.Add_Exc_Msg
1923: ( G_PKG_NAME
1924: , 'Process_Sets'

Line 1922: oe_msg_pub.Add_Exc_Msg

1918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1919:
1920: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1921: THEN
1922: oe_msg_pub.Add_Exc_Msg
1923: ( G_PKG_NAME
1924: , 'Process_Sets'
1925: );
1926: END IF;

Line 1930: oe_msg_pub.count_and_get

1926: END IF;
1927:
1928: -- Get message count and data
1929:
1930: oe_msg_pub.count_and_get
1931: ( p_count => x_msg_count
1932: , p_data => x_msg_data
1933: );
1934: ROLLBACK TO SAVEPOINT New_Process_sets;

Line 2051: oe_msg_pub.add;

2047: p_set_name IS NULL OR
2048: p_set_type IS NULL) THEN
2049: fnd_message.set_name('ONT', 'OE_SET_REQ_ARG');
2050: FND_MESSAGE.SET_TOKEN('SET',p_set_name);
2051: oe_msg_pub.add;
2052: RAISE FND_API.G_EXC_ERROR ;
2053: -- Require all three header,set name ane set type to create
2054: END IF;
2055: IF l_debug_level > 0 THEN

Line 2073: oe_msg_pub.add;

2069: --p_Freight_Carrier_Code IS NULL OR
2070: --p_Shipping_Method_Code IS NULL) THEN
2071: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
2072: FND_MESSAGE.SET_TOKEN('SET',p_set_name);
2073: oe_msg_pub.add;
2074: RAISE FND_API.G_EXC_ERROR;
2075: -- set attributes cannot be null
2076: ELSIF (p_set_type = 'ARRIVAL_SET') AND
2077: (p_Ship_to_org_id IS NULL OR

Line 2082: oe_msg_pub.add;

2078: p_Schedule_arrival_date IS NULL)THEN
2079: -- Arrival set attributes cannot be null
2080: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
2081: FND_MESSAGE.SET_TOKEN('SET',p_set_name);
2082: oe_msg_pub.add;
2083: RAISE FND_API.G_EXC_ERROR;
2084:
2085: END IF; */
2086:

Line 2171: oe_msg_pub.count_and_get

2167:
2168: -- Get message count and data
2169:
2170:
2171: oe_msg_pub.count_and_get
2172: ( p_count => x_msg_count
2173: , p_data => x_msg_data
2174: );
2175: IF l_debug_level > 0 THEN

Line 2184: oe_msg_pub.count_and_get

2180:
2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2182: -- Get message count and data
2183:
2184: oe_msg_pub.count_and_get
2185: ( p_count => x_msg_count
2186: , p_data => x_msg_data
2187: );
2188: WHEN OTHERS THEN

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

2188: WHEN OTHERS THEN
2189:
2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2191:
2192: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2193: THEN
2194: oe_msg_pub.Add_Exc_Msg
2195: ( G_PKG_NAME
2196: , 'create_Set'

Line 2194: oe_msg_pub.Add_Exc_Msg

2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2191:
2192: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2193: THEN
2194: oe_msg_pub.Add_Exc_Msg
2195: ( G_PKG_NAME
2196: , 'create_Set'
2197: );
2198: END IF;

Line 2202: oe_msg_pub.count_and_get

2198: END IF;
2199:
2200: -- Get message count and data
2201:
2202: oe_msg_pub.count_and_get
2203: ( p_count => x_msg_count
2204: , p_data => x_msg_data
2205: );
2206:

Line 2796: oe_msg_pub.count_and_get

2792:
2793: -- Get message count and data
2794:
2795:
2796: oe_msg_pub.count_and_get
2797: ( p_count => x_msg_count
2798: , p_data => x_msg_data
2799: );
2800: IF l_debug_level > 0 THEN

Line 2810: oe_msg_pub.count_and_get

2806:
2807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2808: -- Get message count and data
2809:
2810: oe_msg_pub.count_and_get
2811: ( p_count => x_msg_count
2812: , p_data => x_msg_data
2813: );
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2815: WHEN OTHERS THEN
2816:
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2818:
2819: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2820: THEN
2821: oe_msg_pub.Add_Exc_Msg
2822: ( G_PKG_NAME
2823: , 'Insert_Into_Set'

Line 2821: oe_msg_pub.Add_Exc_Msg

2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2818:
2819: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2820: THEN
2821: oe_msg_pub.Add_Exc_Msg
2822: ( G_PKG_NAME
2823: , 'Insert_Into_Set'
2824: );
2825: END IF;

Line 2829: oe_msg_pub.count_and_get

2825: END IF;
2826:
2827: -- Get message count and data
2828:
2829: oe_msg_pub.count_and_get
2830: ( p_count => x_msg_count
2831: , p_data => x_msg_data
2832: );
2833:

Line 2943: oe_msg_pub.count_and_get

2939:
2940: -- Get message count and data
2941:
2942:
2943: oe_msg_pub.count_and_get
2944: ( p_count => x_msg_count
2945: , p_data => x_msg_data
2946: );
2947:

Line 2953: oe_msg_pub.count_and_get

2949:
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: -- Get message count and data
2952:
2953: oe_msg_pub.count_and_get
2954: ( p_count => x_msg_count
2955: , p_data => x_msg_data
2956: );
2957: WHEN OTHERS THEN

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

2957: WHEN OTHERS THEN
2958:
2959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2960:
2961: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2962: THEN
2963: oe_msg_pub.Add_Exc_Msg
2964: ( G_PKG_NAME
2965: , 'Update_set'

Line 2963: oe_msg_pub.Add_Exc_Msg

2959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2960:
2961: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2962: THEN
2963: oe_msg_pub.Add_Exc_Msg
2964: ( G_PKG_NAME
2965: , 'Update_set'
2966: );
2967: END IF;

Line 2971: oe_msg_pub.count_and_get

2967: END IF;
2968:
2969: -- Get message count and data
2970:
2971: oe_msg_pub.count_and_get
2972: ( p_count => x_msg_count
2973: , p_data => x_msg_data
2974: );
2975: End Update_Set;

Line 3025: oe_msg_pub.add;

3021: (p_shipment_priority_code <> l_set_rec.shipment_priority_code) THEN
3022: --RAISE FND_API.G_EXC_ERROR;
3023: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
3024: FND_MESSAGE.SET_TOKEN('SET','SHIP');
3025: oe_msg_pub.add;
3026: -- RAISE FND_API.G_EXC_ERROR ;
3027:
3028: NULL;
3029: END IF;

Line 3035: oe_msg_pub.add;

3031: IF (p_Schedule_Arrival_Date <> l_set_rec.Schedule_Arrival_Date) OR
3032: (p_Ship_To_Org_Id <> l_Set_rec.Ship_To_Org_Id) THEN
3033: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');
3034: FND_MESSAGE.SET_TOKEN('SET','ARRIVAL');
3035: oe_msg_pub.add;
3036: --RAISE FND_API.G_EXC_ERROR ;
3037: NULL;
3038: END IF;
3039: END IF;

Line 3049: oe_msg_pub.count_and_get

3045:
3046: -- Get message count and data
3047:
3048:
3049: oe_msg_pub.count_and_get
3050: ( p_count => x_msg_count
3051: , p_data => x_msg_data
3052: );
3053:

Line 3059: oe_msg_pub.count_and_get

3055:
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- Get message count and data
3058:
3059: oe_msg_pub.count_and_get
3060: ( p_count => x_msg_count
3061: , p_data => x_msg_data
3062: );
3063: WHEN OTHERS THEN

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

3063: WHEN OTHERS THEN
3064:
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3066:
3067: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3068: THEN
3069: oe_msg_pub.Add_Exc_Msg
3070: ( G_PKG_NAME
3071: , 'Validate_Set_Attributes'

Line 3069: oe_msg_pub.Add_Exc_Msg

3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3066:
3067: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3068: THEN
3069: oe_msg_pub.Add_Exc_Msg
3070: ( G_PKG_NAME
3071: , 'Validate_Set_Attributes'
3072: );
3073: END IF;

Line 3077: oe_msg_pub.count_and_get

3073: END IF;
3074:
3075: -- Get message count and data
3076:
3077: oe_msg_pub.count_and_get
3078: ( p_count => x_msg_count
3079: , p_data => x_msg_data
3080: );
3081: NULL;

Line 3219: oe_msg_pub.add;

3215: IF is_set_closed(l_set_id) THEN
3216:
3217: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
3218: FND_MESSAGE.SET_TOKEN('SET', p_set_name);
3219: oe_msg_pub.add;
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222: END IF;
3223:

Line 3277: OE_MSG_PUB.set_msg_context

3273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;
3276:
3277: OE_MSG_PUB.set_msg_context
3278: ( p_entity_code => 'LINE'
3279: ,p_entity_id => l_line_rec.line_id
3280: ,p_header_id => l_line_rec.header_id
3281: ,p_line_id => l_line_rec.line_id

Line 3303: OE_MSG_PUB.ADD;

3299: OR (l_line_rec.line_category_code = 'RETURN' AND
3300: p_set_type <> 'FULFILLMENT') THEN
3301:
3302: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3303: OE_MSG_PUB.ADD;
3304: IF l_debug_level > 0 THEN
3305: oe_debug_pub.add( 'LINE IS NOT VALID TO ADD: ' || L_LINE_REC.LINE_ID , 1 ) ;
3306: END IF;
3307: GOTO do_not_process;

Line 3342: OE_MSG_PUB.ADD;

3338:
3339: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3340: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
3341: -- l_line_tbl(I).item_type_code);
3342: OE_MSG_PUB.ADD;
3343: IF l_debug_level > 0 THEN
3344: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
3345: END IF;
3346: RAISE FND_API.G_EXC_ERROR;

Line 3361: oe_msg_pub.add;

3357: /* Changed the message to fix the bug 2862565 */
3358: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
3359: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
3360: /* Changed the message to fix the bug 2862565 */
3361: oe_msg_pub.add;
3362: RAISE FND_API.G_EXC_ERROR;
3363: END IF;
3364:
3365: IF (l_set_id IS NULL) THEN

Line 3717: oe_msg_pub.add;

3713: IF l_debug_level > 0 THEN
3714: oe_debug_pub.add( 'BEFORE FAILING AT SET NAME' , 1 ) ;
3715: END IF;
3716: fnd_message.set_name('ONT', 'OE_SET_NAME_REQ');
3717: oe_msg_pub.add;
3718: RAISE FND_API.G_EXC_ERROR ;
3719: END IF;
3720: IF p_operation <> 'REMOVE' THEN
3721: IF p_set_type <> 'FULFILLMENT'

Line 3949: oe_msg_pub.count_and_get

3945: NULL;
3946:
3947: --x_return_status := l_return_status;
3948:
3949: oe_msg_pub.count_and_get
3950: ( p_count => x_msg_count
3951: , p_data => x_msg_data
3952: );
3953:

Line 3963: oe_msg_pub.count_and_get

3959:
3960: -- Get message count and data
3961:
3962:
3963: oe_msg_pub.count_and_get
3964: ( p_count => x_msg_count
3965: , p_data => x_msg_data
3966: );
3967: IF l_debug_level > 0 THEN

Line 3980: oe_msg_pub.count_and_get

3976:
3977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3978: -- Get message count and data
3979:
3980: oe_msg_pub.count_and_get
3981: ( p_count => x_msg_count
3982: , p_data => x_msg_data
3983: );
3984: IF l_debug_level > 0 THEN

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

3992: WHEN OTHERS THEN
3993:
3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3995:
3996: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3997: THEN
3998: oe_msg_pub.Add_Exc_Msg
3999: ( G_PKG_NAME
4000: , 'Process_Sets'

Line 3998: oe_msg_pub.Add_Exc_Msg

3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3995:
3996: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3997: THEN
3998: oe_msg_pub.Add_Exc_Msg
3999: ( G_PKG_NAME
4000: , 'Process_Sets'
4001: );
4002: END IF;

Line 4006: oe_msg_pub.count_and_get

4002: END IF;
4003:
4004: -- Get message count and data
4005:
4006: oe_msg_pub.count_and_get
4007: ( p_count => x_msg_count
4008: , p_data => x_msg_data
4009: );
4010: ROLLBACK TO SAVEPOINT Process_sets;

Line 4052: oe_msg_pub.count_and_get

4048:
4049: -- Get message count and data
4050:
4051:
4052: oe_msg_pub.count_and_get
4053: ( p_count => x_msg_count
4054: , p_data => x_msg_data
4055: );
4056:

Line 4062: oe_msg_pub.count_and_get

4058:
4059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4060: -- Get message count and data
4061:
4062: oe_msg_pub.count_and_get
4063: ( p_count => x_msg_count
4064: , p_data => x_msg_data
4065: );
4066: WHEN OTHERS THEN

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

4066: WHEN OTHERS THEN
4067:
4068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4069:
4070: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: oe_msg_pub.Add_Exc_Msg
4073: ( G_PKG_NAME
4074: , 'Split Sets'

Line 4072: oe_msg_pub.Add_Exc_Msg

4068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4069:
4070: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: oe_msg_pub.Add_Exc_Msg
4073: ( G_PKG_NAME
4074: , 'Split Sets'
4075: );
4076: END IF;

Line 4080: oe_msg_pub.count_and_get

4076: END IF;
4077:
4078: -- Get message count and data
4079:
4080: oe_msg_pub.count_and_get
4081: ( p_count => x_msg_count
4082: , p_data => x_msg_data
4083: );
4084: End Split_Set;

Line 4374: oe_msg_pub.add;

4370: /* Changed the message to fix the bug 2862565 */
4371: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
4372: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
4373: /* Changed the message to fix the bug 2862565 */
4374: oe_msg_pub.add;
4375: RAISE FND_API.G_EXC_ERROR;
4376:
4377: /*IF Set_Exist(p_set_name => p_x_line_rec.arrival_set,
4378: p_set_type => 'ARRIVAL_SET',

Line 4393: oe_msg_pub.add;

4389:
4390: IF x_arrival_set_id IS NOT NULL AND
4391: nvl(l_set_id,-99) <> x_arrival_set_id THEN
4392: FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
4393: oe_msg_pub.add;
4394: RAISE FND_API.G_EXC_ERROR;
4395: END IF; */
4396:
4397: END IF; -- If ship set id

Line 4412: oe_msg_pub.add;

4408: IF l_set_rec.set_status = 'C' THEN
4409: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
4410: FND_MESSAGE.SET_TOKEN('SET',
4411: l_set_rec.set_name);
4412: oe_msg_pub.add;
4413: RAISE FND_API.G_EXC_ERROR;
4414: END IF;
4415:
4416: -- If set exists and line is getting inserted into an existing set then

Line 4637: oe_msg_pub.add;

4633: IF l_set_rec.set_status = 'C' THEN
4634: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
4635: FND_MESSAGE.SET_TOKEN('SET',
4636: l_set_rec.set_name);
4637: oe_msg_pub.add;
4638: RAISE FND_API.G_EXC_ERROR;
4639: END IF;
4640: p_x_line_rec.ship_to_org_id := l_set_rec.ship_to_org_id;
4641: p_x_line_rec.ship_from_org_id := l_set_rec.ship_from_org_id;

Line 5055: OE_MSG_PUB.ADD;

5051: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5052: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
5053: -- p_x_line_rec.item_type_code);
5054:
5055: OE_MSG_PUB.ADD;
5056: oe_debug_pub.add('Set- not allowed for this itemtype');
5057: RAISE FND_API.G_EXC_ERROR;
5058:
5059: END IF;

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

5130:
5131:
5132: WHEN OTHERS THEN
5133:
5134: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5135: THEN
5136: OE_MSG_PUB.Add_Exc_Msg
5137: ( G_PKG_NAME
5138: , 'Get_Set_Id'

Line 5136: OE_MSG_PUB.Add_Exc_Msg

5132: WHEN OTHERS THEN
5133:
5134: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5135: THEN
5136: OE_MSG_PUB.Add_Exc_Msg
5137: ( G_PKG_NAME
5138: , 'Get_Set_Id'
5139: );
5140: END IF;

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

5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227:
5228: WHEN OTHERS THEN
5229:
5230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5231: THEN
5232: OE_MSG_PUB.Add_Exc_Msg
5233: ( G_PKG_NAME
5234: , 'Query_Set_Rows'

Line 5232: OE_MSG_PUB.Add_Exc_Msg

5228: WHEN OTHERS THEN
5229:
5230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5231: THEN
5232: OE_MSG_PUB.Add_Exc_Msg
5233: ( G_PKG_NAME
5234: , 'Query_Set_Rows'
5235: );
5236: END IF;

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

5303: RAISE FND_API.G_EXC_ERROR;
5304:
5305:
5306: WHEN OTHERS THEN
5307: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5308: THEN
5309: OE_MSG_PUB.Add_Exc_Msg
5310: ( G_PKG_NAME ,
5311: 'create_line_set'

Line 5309: OE_MSG_PUB.Add_Exc_Msg

5305:
5306: WHEN OTHERS THEN
5307: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5308: THEN
5309: OE_MSG_PUB.Add_Exc_Msg
5310: ( G_PKG_NAME ,
5311: 'create_line_set'
5312: );
5313: END IF;

Line 5452: OE_MSG_PUB.set_msg_context

5448: END;
5449:
5450: END IF;
5451:
5452: OE_MSG_PUB.set_msg_context
5453: ( p_entity_code => 'LINE'
5454: ,p_entity_id => l_line_rec.line_id
5455: ,p_header_id => l_line_rec.header_id
5456: ,p_line_id => l_line_rec.line_id

Line 5488: OE_MSG_PUB.ADD;

5484: OR (l_line_rec.line_category_code = 'RETURN' AND
5485: g_set_tbl(I).set_type <> 'FULFILLMENT_SET') THEN
5486:
5487: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5488: OE_MSG_PUB.ADD;
5489: IF l_debug_level > 0 THEN
5490: oe_debug_pub.add( 'LINE IS NOT VALID TO PROCESS: ' || L_LINE_REC.LINE_ID , 1 ) ;
5491: END IF;
5492: g_set_tbl(I).process_flag := 'Y' ;

Line 5516: OE_MSG_PUB.ADD;

5512:
5513: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5514: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
5515: -- l_line_rec.item_type_code);
5516: OE_MSG_PUB.ADD;
5517: IF l_debug_level > 0 THEN
5518: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
5519: END IF;
5520: --RAISE FND_API.G_EXC_ERROR;

Line 5634: OE_MSG_PUB.set_msg_context

5630: OR (l_line_rec.item_type_code = 'SERVICE'
5631: AND (g_set_tbl(J).set_type = 'ARRIVAL'
5632: OR g_set_tbl(J).set_type = 'SHIP')) THEN
5633:
5634: OE_MSG_PUB.set_msg_context
5635: ( p_entity_code => 'LINE'
5636: ,p_entity_id => l_line_rec.line_id
5637: ,p_header_id => l_line_rec.header_id
5638: ,p_line_id => l_line_rec.line_id

Line 5657: OE_MSG_PUB.ADD;

5653: l_line_rec.source_document_type_id);
5654: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
5655: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',
5656: -- l_line_rec.item_type_code);
5657: OE_MSG_PUB.ADD;
5658: IF l_debug_level > 0 THEN
5659: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
5660: END IF;
5661: --RAISE FND_API.G_EXC_ERROR;

Line 5725: oe_msg_pub.add;

5721: /* Changed the message to fix the bug 2862565 */
5722: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');
5723: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');
5724: /* Changed the message to fix the bug 2862565 */
5725: oe_msg_pub.add;
5726: RAISE FND_API.G_EXC_ERROR;
5727: END IF;
5728:
5729: END IF;

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

6086: RAISE FND_API.G_EXC_ERROR;
6087:
6088: WHEN OTHERS THEN
6089:
6090: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6091: THEN
6092: OE_MSG_PUB.Add_Exc_Msg
6093: ( G_PKG_NAME ,
6094: 'Process Sets'

Line 6092: OE_MSG_PUB.Add_Exc_Msg

6088: WHEN OTHERS THEN
6089:
6090: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6091: THEN
6092: OE_MSG_PUB.Add_Exc_Msg
6093: ( G_PKG_NAME ,
6094: 'Process Sets'
6095: );
6096: END IF;

Line 6326: oe_msg_pub.add;

6322: IF l_debug_level > 0 THEN
6323: oe_debug_pub.add( 'INVALID SER OPR' , 2 ) ;
6324: END IF;
6325: FND_MESSAGE.Set_Name('ONT', 'OE_SCH_NOT_IN_SHIP_ARR'); -- 2724197 New message added
6326: oe_msg_pub.add;
6327: RAISE FND_API.G_EXC_ERROR;
6328:
6329: END IF; -- not both sets populated.
6330:

Line 6613: oe_msg_pub.add;

6609: l_set_rec := get_set_rec(l_set_id);
6610: IF l_set_rec.set_status = 'C' THEN
6611: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6612: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6613: oe_msg_pub.add;
6614: GOTO NO_PROCESS;
6615: END IF; -- Set Status = 'C'
6616:
6617: IF l_debug_level > 0 THEN

Line 6662: oe_msg_pub.add;

6658: l_set_rec := get_set_rec(l_set_id);
6659: IF l_set_rec.set_status = 'C' THEN
6660: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6661: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6662: oe_msg_pub.add;
6663: GOTO NO_PROCESS;
6664:
6665: END IF; -- Set Status = 'C'
6666: p_x_line_rec.arrival_set_id := l_set_id;

Line 6718: oe_msg_pub.add;

6714: l_set_rec := get_set_rec(l_set_id);
6715: IF l_set_rec.set_status = 'C' THEN
6716: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6717: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6718: oe_msg_pub.add;
6719: GOTO NO_PROCESS;
6720: END IF; -- Set Status = 'C'
6721: p_x_line_rec.ship_set_id := l_set_id;
6722: l_set_type := 'SHIP_SET';

Line 6761: oe_msg_pub.add;

6757: l_set_rec := get_set_rec(l_set_id);
6758: IF l_set_rec.set_status = 'C' THEN
6759: fnd_message.set_name('ONT', 'OE_SET_CLOSED');
6760: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);
6761: oe_msg_pub.add;
6762: GOTO NO_PROCESS;
6763: END IF; -- Set Status = 'C'
6764: p_x_line_rec.ship_set_id := l_set_id;
6765: l_set_type := 'SHIP_SET';

Line 6853: OE_MSG_PUB.ADD;

6849:
6850: IF p_x_line_rec.ship_from_org_id IS NULL THEN
6851: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
6852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Warehouse'); --9680007 4241385
6853: OE_MSG_PUB.ADD;
6854: RAISE FND_API.G_EXC_ERROR;
6855: END IF ;
6856:
6857: IF p_x_line_rec.shipping_method_code IS NULL THEN

Line 6860: OE_MSG_PUB.ADD;

6856:
6857: IF p_x_line_rec.shipping_method_code IS NULL THEN
6858: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
6859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');
6860: OE_MSG_PUB.ADD;
6861: RAISE FND_API.G_EXC_ERROR;
6862: END IF ;
6863:
6864: END IF ;*/

Line 6877: OE_MSG_PUB.ADD;

6873:
6874: /* IF p_x_line_rec.ship_from_org_id IS NULL THEN
6875: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
6876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Warehouse');
6877: OE_MSG_PUB.ADD;
6878: RAISE FND_API.G_EXC_ERROR; --9680007 4241385
6879: END IF ;
6880:
6881: IF p_x_line_rec.shipping_method_code IS NULL THEN

Line 6884: OE_MSG_PUB.ADD;

6880:
6881: IF p_x_line_rec.shipping_method_code IS NULL THEN
6882: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
6883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');
6884: OE_MSG_PUB.ADD;
6885: RAISE FND_API.G_EXC_ERROR;
6886: END IF ; */
6887:
6888: IF l_debug_level > 0 THEN

Line 6970: OE_MSG_PUB.ADD;

6966: WHEN NO_DATA_FOUND THEN
6967: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_SET_ATTR_W');
6968: fnd_message.set_token('ATTR1',oe_order_util.GET_ATTRIBUTE_name('ITEM_ID'));
6969: fnd_message.set_token('ATTR2',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
6970: OE_MSG_PUB.ADD;
6971: RAISE FND_API.G_EXC_ERROR;
6972: END ;
6973: END LOOP ;
6974:

Line 7013: OE_MSG_PUB.ADD;

7009: ELSIF l_schedule_ship_Date IS NULL THEN
7010: FND_MESSAGE.SET_NAME('ONT','ONT_DIFF_SET_ATTR');
7011: fnd_message.set_token('SHIP_SET',l_set_name_dsp);
7012: fnd_message.set_token('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
7013: OE_MSG_PUB.ADD;
7014: RAISE FND_API.G_EXC_ERROR;
7015: END IF ;
7016: END IF ;
7017: END IF ; --9680007

Line 7056: OE_MSG_PUB.ADD;

7052: WHEN NO_DATA_FOUND THEN
7053:
7054: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_SET_ATTR_S');
7055: fnd_message.set_token('ATTR',oe_order_util.GET_ATTRIBUTE_name('SHIPPING_METHOD_CODE'));
7056: OE_MSG_PUB.ADD;
7057: RAISE FND_API.G_EXC_ERROR;
7058: END ;
7059: END LOOP ;
7060:

Line 7099: OE_MSG_PUB.ADD;

7095: ELSIF l_schedule_ship_Date IS NULL THEN
7096: FND_MESSAGE.SET_NAME('ONT','ONT_DIFF_SET_ATTR');
7097: fnd_message.set_token('SHIP_SET',l_set_name_dsp);
7098: fnd_message.set_token('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIPPING_METHOD_CODE'));
7099: OE_MSG_PUB.ADD;
7100: RAISE FND_API.G_EXC_ERROR;
7101: END IF ;
7102: END IF ;
7103: END IF ;--ship methos profile option.

Line 7399: OE_MSG_PUB.ADD;

7395: oe_debug_pub.add( 'ARRIVAL SHIP SET-' || P_OLD_LINE_REC.ARRIVAL_SET_ID ) ;
7396: END IF;
7397: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
7398: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_x_line_rec.item_type_code);
7399: OE_MSG_PUB.ADD;
7400: IF l_debug_level > 0 THEN
7401: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' ) ;
7402: END IF;
7403: RAISE FND_API.G_EXC_ERROR;

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

7536:
7537:
7538: WHEN OTHERS THEN
7539:
7540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7541: THEN
7542: OE_MSG_PUB.Add_Exc_Msg
7543: ( G_PKG_NAME
7544: , 'Default_Line_Set'

Line 7542: OE_MSG_PUB.Add_Exc_Msg

7538: WHEN OTHERS THEN
7539:
7540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7541: THEN
7542: OE_MSG_PUB.Add_Exc_Msg
7543: ( G_PKG_NAME
7544: , 'Default_Line_Set'
7545: );
7546: END IF;

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

7689:
7690: EXCEPTION
7691: WHEN OTHERS THEN
7692:
7693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7694: THEN
7695: OE_MSG_PUB.Add_Exc_Msg
7696: ( G_PKG_NAME
7697: , 'Validate_Fulfillment_Set'

Line 7695: OE_MSG_PUB.Add_Exc_Msg

7691: WHEN OTHERS THEN
7692:
7693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7694: THEN
7695: OE_MSG_PUB.Add_Exc_Msg
7696: ( G_PKG_NAME
7697: , 'Validate_Fulfillment_Set'
7698: );
7699: END IF;

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

7775:
7776: WHEN OTHERS THEN
7777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7778:
7779: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7780: THEN
7781: OE_MSG_PUB.Add_Exc_Msg
7782: ( G_PKG_NAME
7783: , 'Delete_Set'

Line 7781: OE_MSG_PUB.Add_Exc_Msg

7777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7778:
7779: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7780: THEN
7781: OE_MSG_PUB.Add_Exc_Msg
7782: ( G_PKG_NAME
7783: , 'Delete_Set'
7784: );
7785: END IF;