DBA Data[Home] [Help]

APPS.OE_SET_UTIL dependencies on FND_MESSAGE

Line 169: FND_MESSAGE.Set_Name ('ONT','ONT_SET_PICK_RELEASED');

165: AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
166: AND rownum = 1;
167:
168: IF l_ship_set > 0 AND l_shipset_enforce = 'Y' THEN
169: FND_MESSAGE.Set_Name ('ONT','ONT_SET_PICK_RELEASED');
170: BEGIN
171: SELECT SET_NAME
172: INTO l_set_name
173: FROM OE_SETS

Line 291: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

287: END IF;
288:
289: l_set_rec := get_set_rec(p_set_id);
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 ;

Line 292: FND_MESSAGE.SET_TOKEN('SET',

288:
289: l_set_rec := get_set_rec(p_set_id);
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;

Line 422: fnd_message.set_name('ONT', 'OE_LINE_FULFILLED');

418: -- See if this is already fulfilled . if fulfilled raise error
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 */

Line 1621: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

1617: p_header_id =>l_header_id,
1618: x_set_id => l_set_id);
1619: IF l_set_id IS NOT NULL THEN
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;

Line 1622: FND_MESSAGE.SET_TOKEN('SET',

1618: x_set_id => l_set_id);
1619: IF l_set_id IS NOT NULL THEN
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;

Line 1718: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

1714: THEN
1715: /* and
1716: p_operation <> 'REMOVE' )) THEN*/
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

Line 1719: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',

1715: /* and
1716: p_operation <> 'REMOVE' )) THEN*/
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' ) ;

Line 1743: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');

1739: oe_debug_pub.add( 'ship_set:' || l_line_tbl(I).ship_set,2 ) ;
1740: oe_debug_pub.add( 'ship_set_id:' || l_line_tbl(I).ship_set_id,2 ) ;
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;

Line 1744: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');

1740: oe_debug_pub.add( 'ship_set_id:' || l_line_tbl(I).ship_set_id,2 ) ;
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;

Line 2010: fnd_message.set_name('ONT', 'OE_SET_REQ_ARG');

2006: END IF;
2007: IF (p_header_id IS NULL OR
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

Line 2011: FND_MESSAGE.SET_TOKEN('SET',p_set_name);

2007: IF (p_header_id IS NULL OR
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;

Line 2032: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');

2028: p_Ship_to_org_id IS NULL OR
2029: p_Schedule_Ship_Date IS NULL ) THEN
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

Line 2033: FND_MESSAGE.SET_TOKEN('SET',p_set_name);

2029: p_Schedule_Ship_Date IS NULL ) THEN
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

Line 2041: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');

2037: ELSIF (p_set_type = 'ARRIVAL_SET') AND
2038: (p_Ship_to_org_id IS NULL OR
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:

Line 2042: FND_MESSAGE.SET_TOKEN('SET',p_set_name);

2038: (p_Ship_to_org_id IS NULL OR
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; */

Line 2970: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');

2966: (p_Freight_Carrier_Code <> l_set_rec.Freight_Carrier_Code) OR
2967: (p_Shipping_Method_Code <> l_set_rec.Shipping_Method_Code) OR
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:

Line 2971: FND_MESSAGE.SET_TOKEN('SET','SHIP');

2967: (p_Shipping_Method_Code <> l_set_rec.Shipping_Method_Code) OR
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;

Line 2980: fnd_message.set_name('ONT', 'OE_INVALID_SET_ATTR');

2976: END IF;
2977: ELSIF (l_set_rec.set_type = 'ARRIVAL_SET') THEN
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;

Line 2981: FND_MESSAGE.SET_TOKEN('SET','ARRIVAL');

2977: ELSIF (l_set_rec.set_type = 'ARRIVAL_SET') THEN
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;

Line 3160: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

3156: IF l_set_id IS NOT NULL THEN
3157:
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;

Line 3161: FND_MESSAGE.SET_TOKEN('SET', p_set_name);

3157:
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;

Line 3245: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

3241: OR nvl(l_line_rec.open_flag,'N') = 'N'
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;

Line 3282: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

3278: AND (p_set_type = 'ARRIVAL'
3279: OR p_set_type = 'SHIP')) THEN
3280:
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

Line 3283: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',

3279: OR p_set_type = 'SHIP')) THEN
3280:
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' ) ;

Line 3301: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');

3297:
3298: IF l_line_tbl(I).ship_set_id is not null or
3299: l_line_tbl(I).ship_set is not null THEN
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;

Line 3302: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');

3298: IF l_line_tbl(I).ship_set_id is not null or
3299: l_line_tbl(I).ship_set is not null THEN
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;

Line 3659: fnd_message.set_name('ONT', 'OE_SET_NAME_REQ');

3655: IF NOT l_exists and p_set_name IS NULL THEN
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

Line 4314: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');

4310: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR) THEN
4311:
4312:
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;

Line 4315: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');

4311:
4312:
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:

Line 4335: FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');

4331: x_arrival_set_id => x_arrival_set_id);
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:

Line 4352: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

4348:
4349: l_set_rec := get_set_rec(l_set_id);
4350:
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;

Line 4353: FND_MESSAGE.SET_TOKEN('SET',

4349: l_set_rec := get_set_rec(l_set_id);
4350:
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;

Line 4577: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

4573: oe_debug_pub.add( 'SHIP SET EXISTS' ) ;
4574: END IF;
4575: l_set_rec := get_set_rec(l_set_id);
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;

Line 4578: FND_MESSAGE.SET_TOKEN('SET',

4574: END IF;
4575: l_set_rec := get_set_rec(l_set_id);
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;

Line 4994: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

4990: (p_x_line_rec.ship_set IS NOT NULL AND
4991: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR)
4992: THEN
4993:
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;

Line 4995: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',

4991: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR)
4992: THEN
4993:
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');

Line 5430: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

5426: /* Fix Bug # 2834750 : Only Fulfillment Sets allowed for RMA Lines */
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;

Line 5456: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

5452: IF l_debug_level > 0 THEN
5453: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' || L_LINE_REC.ITEM_TYPE_CODE ) ;
5454: END IF;
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

Line 5457: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',

5453: oe_debug_pub.add( 'SET- NOT ALLOWED FOR THIS ITEMTYPE' || L_LINE_REC.ITEM_TYPE_CODE ) ;
5454: END IF;
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' ) ;

Line 5597: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

5593: ,p_order_source_id =>
5594: l_line_rec.order_source_id
5595: ,p_source_document_type_id =>
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

Line 5598: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE',

5594: l_line_rec.order_source_id
5595: ,p_source_document_type_id =>
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' ) ;

Line 5665: -- FND_MESSAGE.Set_Name('ONT', 'OE_INVALID_SET_COMB');

5661:
5662: IF x_arrival_set_id IS NOT NULL AND
5663: nvl(l_set_id,-99) <> x_arrival_set_id THEN
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;

Line 5666: FND_MESSAGE.Set_Name('ONT','OE_SCH_NOT_IN_SHIP_ARR');

5662: IF x_arrival_set_id IS NOT NULL AND
5663: nvl(l_set_id,-99) <> x_arrival_set_id THEN
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;

Line 6219: FND_MESSAGE.Set_Name('ONT', 'OE_SCH_NOT_IN_SHIP_ARR'); -- 2724197 New message added

6215:
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.

Line 6437: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

6433: x_set_id => l_set_id) THEN
6434:
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'

Line 6438: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);

6434:
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:

Line 6486: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

6482: l_Set_id := p_x_line_rec.arrival_Set_id;
6483:
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:

Line 6487: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);

6483:
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'

Line 6542: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

6538: x_set_id => l_set_id) THEN
6539:
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'

Line 6543: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);

6539:
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;

Line 6585: fnd_message.set_name('ONT', 'OE_SET_CLOSED');

6581:
6582: l_set_id := p_x_line_rec.ship_set_id;
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'

Line 6586: FND_MESSAGE.SET_TOKEN('SET', l_set_rec.set_name);

6582: l_set_id := p_x_line_rec.ship_set_id;
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;

Line 6917: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');

6913: END IF;
6914: IF l_debug_level > 0 THEN
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' ) ;

Line 6918: -- FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_x_line_rec.item_type_code);

6914: IF l_debug_level > 0 THEN
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;