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 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 317: fnd_message.set_name('ONT', 'OE_SET_LOCKED');

313: EXCEPTION
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:

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

323:
324: -- End changes for bug8420761
325:
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 ;

Line 328: FND_MESSAGE.SET_TOKEN('SET',

324: -- End changes for bug8420761
325:
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;

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

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

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

1653: p_header_id =>l_header_id,
1654: x_set_id => l_set_id);
1655: IF l_set_id IS NOT NULL THEN
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;

Line 1658: FND_MESSAGE.SET_TOKEN('SET',

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

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

1752: THEN
1753: /* and
1754: p_operation <> 'REMOVE' )) THEN*/
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3213: ---end bug8420761
3214:
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;

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

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

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

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

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

3335: AND (p_set_type = 'ARRIVAL'
3336: OR p_set_type = 'SHIP')) THEN
3337:
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

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

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

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

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

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

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

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

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

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

4367: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR) THEN
4368:
4369:
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;

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

4368:
4369:
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:

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

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

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

4405:
4406: l_set_rec := get_set_rec(l_set_id);
4407:
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;

Line 4410: FND_MESSAGE.SET_TOKEN('SET',

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

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

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

Line 4635: FND_MESSAGE.SET_TOKEN('SET',

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

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

5047: (p_x_line_rec.ship_set IS NOT NULL AND
5048: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR)
5049: THEN
5050:
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;

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

5048: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR)
5049: THEN
5050:
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');

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

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

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

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

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

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

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

5650: ,p_order_source_id =>
5651: l_line_rec.order_source_id
5652: ,p_source_document_type_id =>
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

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

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

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

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

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

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

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

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

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

6607: x_set_id => l_set_id) THEN
6608:
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'

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

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

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

6656: l_Set_id := p_x_line_rec.arrival_Set_id;
6657:
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:

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

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

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

6712: x_set_id => l_set_id) THEN
6713:
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'

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

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

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

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

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

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

Line 6851: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');

6847: AND p_x_line_rec.arrival_set <> FND_API.G_MISS_char ))
6848: THEN
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 ;

Line 6852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Warehouse'); --9680007 4241385

6848: THEN
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:

Line 6858: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');

6854: RAISE FND_API.G_EXC_ERROR;
6855: END IF ;
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 ;

Line 6859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');

6855: END IF ;
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:

Line 6875: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');

6871: AND p_x_line_rec.ship_set <> FND_API.G_MISS_char ))
6872: THEN
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 ;

Line 6876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Warehouse');

6872: THEN
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:

Line 6882: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');

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
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 ; */

Line 6883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');

6879: END IF ;
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:

Line 6967: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_SET_ATTR_W');

6963: AND org.organization_id=p_x_line_rec.ship_from_org_id
6964: AND rownum=1 ;
6965: EXCEPTION
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;

Line 6968: fnd_message.set_token('ATTR1',oe_order_util.GET_ATTRIBUTE_name('ITEM_ID'));

6964: AND rownum=1 ;
6965: EXCEPTION
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 ;

Line 6969: fnd_message.set_token('ATTR2',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));

6965: EXCEPTION
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 ;

Line 7010: FND_MESSAGE.SET_NAME('ONT','ONT_DIFF_SET_ATTR');

7006: This is becuase 3rd line is not part of the set yet. So we will not try to
7007: cascade the changes.*/
7008:
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;

Line 7011: fnd_message.set_token('SHIP_SET',l_set_name_dsp);

7007: cascade the changes.*/
7008:
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 ;

Line 7012: fnd_message.set_token('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));

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

Line 7054: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_SET_ATTR_S');

7050: AND ROWNUM = 1;
7051: EXCEPTION
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 ;

Line 7055: fnd_message.set_token('ATTR',oe_order_util.GET_ATTRIBUTE_name('SHIPPING_METHOD_CODE'));

7051: EXCEPTION
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 ;

Line 7096: FND_MESSAGE.SET_NAME('ONT','ONT_DIFF_SET_ATTR');

7092: This is becuase 3rd line is not part of the set yet. So we will not try to
7093: cascade the changes.*/
7094:
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;

Line 7097: fnd_message.set_token('SHIP_SET',l_set_name_dsp);

7093: cascade the changes.*/
7094:
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 ;

Line 7098: fnd_message.set_token('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIPPING_METHOD_CODE'));

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

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

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

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

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