DBA Data[Home] [Help]

APPS.INV_LOT_ATTR_PUB dependencies on FND_MESSAGE

Line 55: fnd_message.set_name('INV', 'INV_MISSING_GRADE');

51: END IF;
52:
53: IF l_grade_control_flag = 'Y' AND p_grade_code IS NULL
54: THEN
55: fnd_message.set_name('INV', 'INV_MISSING_GRADE');
56: fnd_msg_pub.ADD;
57: RAISE fnd_api.g_exc_error;
58: RETURN FALSE;
59: END IF;

Line 68: fnd_message.set_name('INV', 'INV_INVALID_GRADE_CODE_EXP');

64: FETCH c_get_grade_code INTO l_grade_code;
65:
66: IF c_get_grade_code%NOTFOUND THEN
67: CLOSE c_get_grade_code;
68: fnd_message.set_name('INV', 'INV_INVALID_GRADE_CODE_EXP');
69: fnd_message.set_token('GRADE_CODE', p_grade_code);
70: fnd_msg_pub.ADD;
71: RAISE fnd_api.g_exc_error;
72: RETURN FALSE;

Line 69: fnd_message.set_token('GRADE_CODE', p_grade_code);

65:
66: IF c_get_grade_code%NOTFOUND THEN
67: CLOSE c_get_grade_code;
68: fnd_message.set_name('INV', 'INV_INVALID_GRADE_CODE_EXP');
69: fnd_message.set_token('GRADE_CODE', p_grade_code);
70: fnd_msg_pub.ADD;
71: RAISE fnd_api.g_exc_error;
72: RETURN FALSE;
73: END IF;

Line 132: fnd_message.set_name ('INV','INV_LOT_MATURITY_DATE_INVALID');

128: x_return_status := fnd_api.g_ret_sts_success;
129: IF (p_maturity_date IS NOT NULL AND p_origination_date IS NOT NULL)
130: THEN
131: IF (p_maturity_date < p_origination_date) THEN
132: fnd_message.set_name ('INV','INV_LOT_MATURITY_DATE_INVALID');
133: fnd_msg_pub.ADD;
134: RAISE fnd_api.g_exc_error;
135: RETURN TRUE;
136: END IF;

Line 182: fnd_message.set_name ('INV','INV_LOT_HOLD_DATE_INVALID');

178: x_return_status := fnd_api.g_ret_sts_success;
179: IF (p_hold_date IS NOT NULL AND p_origination_date IS NOT NULL)
180: THEN
181: IF (p_hold_date < p_origination_date) THEN
182: fnd_message.set_name ('INV','INV_LOT_HOLD_DATE_INVALID');
183: fnd_msg_pub.ADD;
184: RAISE fnd_api.g_exc_error;
185: RETURN TRUE;
186: END IF;

Line 228: fnd_message.set_name ('INV','INV_LOT_EXP_ACT_DATE_INVALID');

224: IF (p_expiration_date IS NOT NULL) THEN
225: -- fabdi bug 4168662, removed validations
226: /*
227: IF (p_expiration_action_date <= p_expiration_date) THEN
228: fnd_message.set_name ('INV','INV_LOT_EXP_ACT_DATE_INVALID');
229: fnd_msg_pub.ADD;
230: RAISE fnd_api.g_exc_error;
231: RETURN FALSE;
232: END IF;

Line 237: fnd_message.set_name ('INV', 'INV_LOT_EXPIRE_DATE_REQ_EXP');

233:
234: */
235: RETURN TRUE;
236: ELSE
237: fnd_message.set_name ('INV', 'INV_LOT_EXPIRE_DATE_REQ_EXP');
238: fnd_msg_pub.ADD;
239: RAISE fnd_api.g_exc_error;
240: RETURN FALSE;
241: END IF;

Line 285: fnd_message.set_name ('INV','INV_LOT_RETEST_DATE_INVALID');

281: x_return_status := fnd_api.g_ret_sts_success;
282: IF (p_retest_date IS NOT NULL AND p_origination_date IS NOT NULL)
283: THEN
284: IF (p_retest_date < p_origination_date) THEN
285: fnd_message.set_name ('INV','INV_LOT_RETEST_DATE_INVALID');
286: fnd_msg_pub.ADD;
287: RAISE fnd_api.g_exc_error;
288: RETURN TRUE;
289: END IF;

Line 362: fnd_message.set_name('INV', 'INV_EXP_ACTION_CD_EXP');

358: FETCH c_get_exp_action_code INTO l_expiration_action_code;
359:
360: IF c_get_exp_action_code%NOTFOUND THEN
361: CLOSE c_get_exp_action_code;
362: fnd_message.set_name('INV', 'INV_EXP_ACTION_CD_EXP');
363: fnd_message.set_token('EXP_ACTION_CD', p_expiration_action_code);
364: fnd_msg_pub.ADD;
365: RAISE fnd_api.g_exc_error;
366: RETURN FALSE;

Line 363: fnd_message.set_token('EXP_ACTION_CD', p_expiration_action_code);

359:
360: IF c_get_exp_action_code%NOTFOUND THEN
361: CLOSE c_get_exp_action_code;
362: fnd_message.set_name('INV', 'INV_EXP_ACTION_CD_EXP');
363: fnd_message.set_token('EXP_ACTION_CD', p_expiration_action_code);
364: fnd_msg_pub.ADD;
365: RAISE fnd_api.g_exc_error;
366: RETURN FALSE;
367: END IF;

Line 441: fnd_message.set_name('INV', 'INV_INT_REAEXP');

437: OPEN c_get_reason_code;
438: FETCH c_get_reason_code INTO l_reason_code;
439: IF c_get_reason_code%NOTFOUND THEN
440: CLOSE c_get_reason_code;
441: fnd_message.set_name('INV', 'INV_INT_REAEXP');
442: fnd_msg_pub.ADD;
443: RAISE fnd_api.g_exc_error;
444: RETURN FALSE;
445: END IF;

Line 455: fnd_message.set_name('INV', 'INV_INT_REAEXP');

451: OPEN c_get_reason_id;
452: FETCH c_get_reason_id INTO l_reason_code;
453: IF c_get_reason_id%NOTFOUND THEN
454: CLOSE c_get_reason_id;
455: fnd_message.set_name('INV', 'INV_INT_REAEXP');
456: fnd_msg_pub.ADD;
457: RAISE fnd_api.g_exc_error;
458: RETURN FALSE;
459: END IF;

Line 522: fnd_message.set_name('INV', 'INV_ORIGINATION_TYPE_EXP');

518: OPEN c_get_origination_type;
519: FETCH c_get_origination_type into l_origination_type;
520: IF c_get_origination_type%NOTFOUND THEN
521: CLOSE c_get_origination_type;
522: fnd_message.set_name('INV', 'INV_ORIGINATION_TYPE_EXP');
523: fnd_message.set_token('ORIGINATION_TYPE', p_origination_type);
524: fnd_msg_pub.ADD;
525: RAISE fnd_api.g_exc_error;
526: RETURN FALSE;

Line 523: fnd_message.set_token('ORIGINATION_TYPE', p_origination_type);

519: FETCH c_get_origination_type into l_origination_type;
520: IF c_get_origination_type%NOTFOUND THEN
521: CLOSE c_get_origination_type;
522: fnd_message.set_name('INV', 'INV_ORIGINATION_TYPE_EXP');
523: fnd_message.set_token('ORIGINATION_TYPE', p_origination_type);
524: fnd_msg_pub.ADD;
525: RAISE fnd_api.g_exc_error;
526: RETURN FALSE;
527: END IF;

Line 641: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

637: , p_parent_lot_number => p_parent_lot_number
638: , p_child_lot_number => p_lot_number
639: ) ;
640: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
641: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
642: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CHILD_LOT_GRP.VALIDATE_CHILD_LOT');
643: fnd_msg_pub.ADD;
644: RAISE fnd_api.g_exc_unexpected_error;
645: RETURN FALSE;

Line 642: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CHILD_LOT_GRP.VALIDATE_CHILD_LOT');

638: , p_child_lot_number => p_lot_number
639: ) ;
640: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
641: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
642: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CHILD_LOT_GRP.VALIDATE_CHILD_LOT');
643: fnd_msg_pub.ADD;
644: RAISE fnd_api.g_exc_unexpected_error;
645: RETURN FALSE;
646: END IF;

Line 648: fnd_message.set_name('INV', 'INV_INVALID_CHILD_LOT_EXP') ;

644: RAISE fnd_api.g_exc_unexpected_error;
645: RETURN FALSE;
646: END IF;
647: IF l_return_status = fnd_api.g_ret_sts_error THEN
648: fnd_message.set_name('INV', 'INV_INVALID_CHILD_LOT_EXP') ;
649: fnd_msg_pub.ADD;
650: RAISE fnd_api.g_exc_error;
651: RETURN FALSE;
652: END IF;

Line 659: fnd_message.set_name('INV', 'INV_INVALID_PARENT_LOT_EXP') ;

655: CLOSE c_get_lot_record;
656: /* Check Parent Lot is correct */
657: IF l_lot_record.parent_lot_number IS NOT NULL THEN
658: IF l_lot_record.parent_lot_number <> p_parent_lot_number THEN
659: fnd_message.set_name('INV', 'INV_INVALID_PARENT_LOT_EXP') ;
660: fnd_msg_pub.ADD;
661: RAISE fnd_api.g_exc_error;
662: RETURN FALSE;
663: END IF;