DBA Data[Home] [Help]

APPS.OE_GRP_SCH_UTIL dependencies on FND_MESSAGE

Line 69: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');

65: p_old_line_rec.ordered_quantity = FND_API.G_MISS_NUM) AND
66: (p_line_rec.ordered_quantity is null OR
67: p_line_rec.ordered_quantity = FND_API.G_MISS_NUM)) THEN
68:
69: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
70: OE_MSG_PUB.Add;
71: l_return_status := FND_API.G_RET_STS_ERROR;
72: END IF;
73:

Line 86: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');

82: (nvl(p_line_rec.cancelled_flag,'N') = 'N')) THEN
83:
84: IF p_line_rec.schedule_action_code is not null THEN
85:
86: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');
87: OE_MSG_PUB.Add;
88:
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'E2' , 1 ) ;

Line 107: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');

103:
104: -- The line is cancelled. Cannot perform scheduling
105: -- on it.
106:
107: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');
108: OE_MSG_PUB.Add;
109:
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add( 'OE_SCH_LINE_SHIPPED' , 1 ) ;

Line 128: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');

124: -- Reserved Quantity has changed
125: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)
126: THEN
127:
128: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
129: OE_MSG_PUB.Add;
130:
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'E4' , 1 ) ;

Line 145: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');

141: p_line_rec.schedule_action_code =
142: OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE) AND
143: (p_line_rec.reserved_quantity is not null) THEN
144:
145: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
146: OE_MSG_PUB.Add;
147: l_return_status := FND_API.G_RET_STS_ERROR;
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'E5' , 1 ) ;

Line 168: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');

164: THEN
165: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)
166: THEN
167:
168: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
169: OE_MSG_PUB.Add;
170:
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: IF l_debug_level > 0 THEN

Line 186: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');

182:
183: IF (p_line_rec.order_quantity_uom is null OR
184: p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR) THEN
185:
186: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
187: OE_MSG_PUB.Add;
188:
189: l_return_status := FND_API.G_RET_STS_ERROR;
190: IF l_debug_level > 0 THEN

Line 205: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_ITEM');

201:
202: IF (p_line_rec.inventory_item_id is null OR
203: p_line_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
204:
205: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_ITEM');
206: OE_MSG_PUB.Add;
207:
208: l_return_status := FND_API.G_RET_STS_ERROR;
209: END IF;

Line 221: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');

217: END IF;
218: IF (p_line_rec.request_date is null OR
219: p_line_rec.request_date = FND_API.G_MISS_DATE) THEN
220:
221: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
222: OE_MSG_PUB.Add;
223: l_return_status := FND_API.G_RET_STS_ERROR;
224: END IF;
225:

Line 238: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

234: p_line_rec.schedule_action_code =
235: OE_ORDER_SCH_UTIL.OESCH_ACT_UNSCHEDULE))
236: THEN
237:
238: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
239: OE_MSG_PUB.Add;
240:
241: l_return_status := FND_API.G_RET_STS_ERROR;
242: END IF;

Line 296: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');

292: END IF;
293: END IF;
294:
295: IF (l_result = FND_API.G_TRUE) THEN
296: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
297: OE_MSG_PUB.Add;
298: l_return_status := FND_API.G_RET_STS_ERROR;
299: END IF;
300:

Line 329: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');

325: (p_line_rec.schedule_ship_date is NOT NULL OR
326: p_line_rec.schedule_arrival_date is NOT NULL))
327: THEN
328:
329: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
330: FND_MESSAGE.SET_TOKEN('ACTION',
331: nvl(p_line_rec.schedule_action_code,
332: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE));
333: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

Line 330: FND_MESSAGE.SET_TOKEN('ACTION',

326: p_line_rec.schedule_arrival_date is NOT NULL))
327: THEN
328:
329: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
330: FND_MESSAGE.SET_TOKEN('ACTION',
331: nvl(p_line_rec.schedule_action_code,
332: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE));
333: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
334: nvl(oe_order_sch_util.sch_cached_line_type,

Line 333: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

329: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
330: FND_MESSAGE.SET_TOKEN('ACTION',
331: nvl(p_line_rec.schedule_action_code,
332: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE));
333: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
334: nvl(oe_order_sch_util.sch_cached_line_type,
335: oe_order_sch_util.sch_cached_order_type));
336: OE_MSG_PUB.Add;
337: l_return_status := FND_API.G_RET_STS_ERROR;

Line 346: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');

342: IF p_line_rec.reserved_quantity > 0 AND
343: p_line_rec.reserved_quantity <> FND_API.G_MISS_NUM AND
344: p_line_rec.reserved_quantity IS NOT NULL THEN
345:
346: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
347: FND_MESSAGE.SET_TOKEN('ACTION',
348: nvl(p_line_rec.schedule_action_code,
349: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE));
350: IF l_debug_level > 0 THEN

Line 347: FND_MESSAGE.SET_TOKEN('ACTION',

343: p_line_rec.reserved_quantity <> FND_API.G_MISS_NUM AND
344: p_line_rec.reserved_quantity IS NOT NULL THEN
345:
346: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
347: FND_MESSAGE.SET_TOKEN('ACTION',
348: nvl(p_line_rec.schedule_action_code,
349: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE));
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add( 'RESERVED QUANTITY IS GREATER THAN ZERO' ) ;

Line 359: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');

355: END IF;
356:
357: IF p_line_rec.schedule_action_code =
358: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE THEN
359: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
360: FND_MESSAGE.SET_TOKEN('ACTION',
361: nvl(p_line_rec.schedule_action_code,
362: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE));
363: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

Line 360: FND_MESSAGE.SET_TOKEN('ACTION',

356:
357: IF p_line_rec.schedule_action_code =
358: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE THEN
359: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
360: FND_MESSAGE.SET_TOKEN('ACTION',
361: nvl(p_line_rec.schedule_action_code,
362: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE));
363: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
364: nvl(oe_order_sch_util.sch_cached_line_type,

Line 363: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

359: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
360: FND_MESSAGE.SET_TOKEN('ACTION',
361: nvl(p_line_rec.schedule_action_code,
362: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE));
363: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
364: nvl(oe_order_sch_util.sch_cached_line_type,
365: oe_order_sch_util.sch_cached_order_type));
366: OE_MSG_PUB.Add;
367: l_return_status := FND_API.G_RET_STS_ERROR;

Line 415: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_VAL_ORG');

411: WHEN NO_DATA_FOUND THEN
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add( 'NO BILL IS DEFINED' , 2 ) ;
414: END IF;
415: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_VAL_ORG');
416: FND_MESSAGE.SET_TOKEN('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
417: FND_MESSAGE.SET_TOKEN('ORG',l_org_id);
418: OE_MSG_PUB.Add;
419: l_return_status := FND_API.G_RET_STS_ERROR;

Line 416: FND_MESSAGE.SET_TOKEN('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));

412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add( 'NO BILL IS DEFINED' , 2 ) ;
414: END IF;
415: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_VAL_ORG');
416: FND_MESSAGE.SET_TOKEN('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
417: FND_MESSAGE.SET_TOKEN('ORG',l_org_id);
418: OE_MSG_PUB.Add;
419: l_return_status := FND_API.G_RET_STS_ERROR;
420:

Line 417: FND_MESSAGE.SET_TOKEN('ORG',l_org_id);

413: oe_debug_pub.add( 'NO BILL IS DEFINED' , 2 ) ;
414: END IF;
415: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_VAL_ORG');
416: FND_MESSAGE.SET_TOKEN('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
417: FND_MESSAGE.SET_TOKEN('ORG',l_org_id);
418: OE_MSG_PUB.Add;
419: l_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN OTHERS THEN

Line 1204: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');

1200:
1201: -- You cannot schedule a ATO model without a warehouse. So flag
1202: -- an error.
1203:
1204: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
1205: OE_MSG_PUB.Add;
1206: RAISE FND_API.G_EXC_ERROR;
1207:
1208: END IF;

Line 1214: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');

1210: IF (p_group_req_rec.action = OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE) OR
1211: (p_group_req_rec.action = OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE)
1212: THEN
1213: -- This action is not allowed on an ATO configuration.
1214: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
1215: OE_MSG_PUB.Add;
1216: RAISE FND_API.G_EXC_ERROR;
1217:
1218: END IF; /* If action was reserve or unreserve */

Line 1232: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');

1228: WHERE ato_line_id=l_model_line_rec.line_id
1229: AND top_model_line_id =l_model_line_rec.top_model_line_id
1230: AND item_type_code = 'CONFIG';
1231:
1232: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
1233: OE_MSG_PUB.Add;
1234: RAISE FND_API.G_EXC_ERROR;
1235:
1236: EXCEPTION

Line 1833: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');

1829: FROM OE_ORDER_LINES_ALL
1830: WHERE top_model_line_id = l_line_tbl(1).top_model_line_id
1831: AND item_type_code = 'CONFIG';
1832:
1833: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
1834: OE_MSG_PUB.Add;
1835: RAISE FND_API.G_EXC_ERROR;
1836:
1837: EXCEPTION

Line 1841: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');

1837: EXCEPTION
1838: WHEN NO_DATA_FOUND THEN
1839: null;
1840: WHEN TOO_MANY_ROWS THEN
1841: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
1842: OE_MSG_PUB.Add;
1843: RAISE FND_API.G_EXC_ERROR;
1844: END;
1845:

Line 2515: FND_MESSAGE.SET_NAME('ONT','OE_DS_SET_INS_FAILED');

2511: ELSE
2512: /* Line is a Externally sourced line. We will not included
2513: it in the set */
2514:
2515: FND_MESSAGE.SET_NAME('ONT','OE_DS_SET_INS_FAILED');
2516: FND_MESSAGE.SET_TOKEN('LINE',p_x_line_tbl(I).line_number);
2517: OE_MSG_PUB.Add;
2518:
2519: END IF;

Line 2516: FND_MESSAGE.SET_TOKEN('LINE',p_x_line_tbl(I).line_number);

2512: /* Line is a Externally sourced line. We will not included
2513: it in the set */
2514:
2515: FND_MESSAGE.SET_NAME('ONT','OE_DS_SET_INS_FAILED');
2516: FND_MESSAGE.SET_TOKEN('LINE',p_x_line_tbl(I).line_number);
2517: OE_MSG_PUB.Add;
2518:
2519: END IF;
2520:

Line 2713: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');

2709: END IF;
2710: END IF; -- l_grp_count.
2711: ELSE
2712: IF l_log_msg = 'N' THEN
2713: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
2714: OE_MSG_PUB.Add;
2715: END IF;
2716: END IF; -- Push group
2717: END IF; -- Return Status is error.

Line 2863: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');

2859: IF l_line_tbl(J).schedule_action_code =
2860: OE_ORDER_SCH_UTIL.OESCH_ACT_UNRESERVE
2861: AND nvl(l_line_tbl(J).shipping_interfaced_flag, 'N') = 'Y' THEN
2862:
2863: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
2864: OE_MSG_PUB.Add;
2865: END IF;
2866: END IF;
2867: END LOOP;

Line 3254: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_WHSE');

3250:
3251: EXCEPTION
3252: WHEN OTHERS THEN
3253: l_return_status := FND_API.G_RET_STS_ERROR;
3254: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_WHSE');
3255: OE_MSG_PUB.Add;
3256: END;
3257:
3258:

Line 3261: fnd_message.set_name('ONT', 'OE_SUBINV_NOT_ALLOWED');

3257:
3258:
3259: IF l_revision_code = 2 OR l_lot_code = 2 THEN
3260: -- 2 == YES
3261: fnd_message.set_name('ONT', 'OE_SUBINV_NOT_ALLOWED');
3262: OE_MSG_PUB.Add;
3263: IF l_line_tbl(j).schedule_action_code =
3264: OE_ORDER_SCH_UTIL.OESCH_ACT_RESERVE THEN
3265: l_return_status := FND_API.G_RET_STS_ERROR;

Line 3332: fnd_message.set_encoded(l_msg_data);

3328: l_line_tbl(j).reserved_quantity := null;
3329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3331: IF l_msg_data is not null THEN
3332: fnd_message.set_encoded(l_msg_data);
3333: l_buffer := fnd_message.get;
3334: oe_msg_pub.add_text(p_message_text => l_buffer);
3335: END IF;
3336:

Line 3333: l_buffer := fnd_message.get;

3329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3330: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3331: IF l_msg_data is not null THEN
3332: fnd_message.set_encoded(l_msg_data);
3333: l_buffer := fnd_message.get;
3334: oe_msg_pub.add_text(p_message_text => l_buffer);
3335: END IF;
3336:
3337: l_line_tbl(j).reserved_quantity := null;

Line 3451: fnd_message.set_encoded(l_msg_data);

3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3450: IF l_msg_data is not null THEN
3451: fnd_message.set_encoded(l_msg_data);
3452: l_buffer := fnd_message.get;
3453: oe_msg_pub.add_text(p_message_text => l_buffer);
3454: IF l_debug_level > 0 THEN
3455: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;

Line 3452: l_buffer := fnd_message.get;

3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3450: IF l_msg_data is not null THEN
3451: fnd_message.set_encoded(l_msg_data);
3452: l_buffer := fnd_message.get;
3453: oe_msg_pub.add_text(p_message_text => l_buffer);
3454: IF l_debug_level > 0 THEN
3455: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;
3456: END IF;

Line 3687: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');

3683: EXCEPTION
3684: WHEN FND_API.G_EXC_ERROR THEN
3685:
3686: IF p_log_msg = 'Y' THEN
3687: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
3688: OE_MSG_PUB.Add;
3689: END IF;
3690:
3691: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3845: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');

3841:
3842: -- You cannot unschedule a set. This is an invalid action on
3843: -- the group.
3844:
3845: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
3846: OE_MSG_PUB.Add;
3847: l_return_status := FND_API.G_RET_STS_ERROR;
3848:
3849: END IF;

Line 3898: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GRP_WHSE_INVALID');

3894: EXCEPTION
3895: WHEN NO_DATA_FOUND THEN
3896: x_return_status := FND_API.G_RET_STS_ERROR;
3897:
3898: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GRP_WHSE_INVALID');
3899: OE_MSG_PUB.Add;
3900:
3901: WHEN OTHERS THEN
3902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3904: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GRP_WHSE_INVALID');

3900:
3901: WHEN OTHERS THEN
3902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3903:
3904: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GRP_WHSE_INVALID');
3905: FND_MESSAGE.SET_TOKEN('LINE',l_line_number);
3906: OE_MSG_PUB.Add;
3907:
3908: END Validate_Warehouse;

Line 3905: FND_MESSAGE.SET_TOKEN('LINE',l_line_number);

3901: WHEN OTHERS THEN
3902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3903:
3904: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GRP_WHSE_INVALID');
3905: FND_MESSAGE.SET_TOKEN('LINE',l_line_number);
3906: OE_MSG_PUB.Add;
3907:
3908: END Validate_Warehouse;
3909: