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.INV_LOT_ATTR_PUB dependencies on FND_MSG_PUB

Line 56: fnd_msg_pub.ADD;

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;
60: /* Do validation only if item is grade controlled */

Line 70: fnd_msg_pub.ADD;

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;
74: CLOSE c_get_grade_code;

Line 82: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: x_return_status := fnd_api.g_ret_sts_error;
81:
82: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
83: p_count => x_msg_count,
84: p_data => x_msg_data);
85: if( x_msg_count > 1 ) then
86: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 86: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

82: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
83: p_count => x_msg_count,
84: p_data => x_msg_data);
85: if( x_msg_count > 1 ) then
86: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
87: end if;
88: RETURN FALSE;
89:
90: WHEN OTHERS THEN

Line 93: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

89:
90: WHEN OTHERS THEN
91: x_return_status := fnd_api.g_ret_sts_error;
92:
93: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
94: p_count => x_msg_count,
95: p_data => x_msg_data);
96: if( x_msg_count > 1 ) then
97: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 97: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

93: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
94: p_count => x_msg_count,
95: p_data => x_msg_data);
96: if( x_msg_count > 1 ) then
97: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
98: end if;
99: RETURN FALSE;
100: END validate_grade_code;
101:

Line 133: fnd_msg_pub.ADD;

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

Line 143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

139: EXCEPTION
140: WHEN OTHERS THEN
141: x_return_status := fnd_api.g_ret_sts_error;
142:
143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146: if( x_msg_count > 1 ) then
147: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 147: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146: if( x_msg_count > 1 ) then
147: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
148: end if;
149: RETURN FALSE;
150: END validate_maturity_date;
151:

Line 183: fnd_msg_pub.ADD;

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

Line 193: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := fnd_api.g_ret_sts_error;
192:
193: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196: if( x_msg_count > 1 ) then
197: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 197: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

193: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196: if( x_msg_count > 1 ) then
197: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
198: end if;
199: RETURN FALSE;
200: END validate_hold_date;
201:

Line 229: fnd_msg_pub.ADD;

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

Line 238: fnd_msg_pub.ADD;

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

Line 248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

244: EXCEPTION
245: WHEN OTHERS THEN
246: x_return_status := fnd_api.g_ret_sts_error;
247:
248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: if( x_msg_count > 1 ) then
252: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 252: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: if( x_msg_count > 1 ) then
252: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
253: end if;
254: RETURN FALSE;
255: END validate_exp_action_date;
256:

Line 286: fnd_msg_pub.ADD;

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

Line 296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

292: EXCEPTION
293: WHEN OTHERS THEN
294: x_return_status := fnd_api.g_ret_sts_error;
295:
296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data);
299: if( x_msg_count > 1 ) then
300: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 300: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data);
299: if( x_msg_count > 1 ) then
300: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
301: end if;
302: RETURN FALSE;
303: END validate_retest_date;
304:

Line 364: fnd_msg_pub.ADD;

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;
368: CLOSE c_get_exp_action_code;

Line 376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: x_return_status := fnd_api.g_ret_sts_error;
375:
376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data);
379: if( x_msg_count > 1 ) then
380: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 380: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data);
379: if( x_msg_count > 1 ) then
380: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
381: end if;
382: RETURN FALSE;
383:
384: WHEN OTHERS THEN

Line 387: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_error;
386:
387: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
388: p_count => x_msg_count,
389: p_data => x_msg_data);
390: if( x_msg_count > 1 ) then
391: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 391: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

387: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
388: p_count => x_msg_count,
389: p_data => x_msg_data);
390: if( x_msg_count > 1 ) then
391: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
392: end if;
393: RETURN FALSE;
394: END validate_exp_action_code;
395:

Line 442: fnd_msg_pub.ADD;

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;
446: CLOSE c_get_reason_code;

Line 456: fnd_msg_pub.ADD;

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;
460: CLOSE c_get_reason_id;

Line 469: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

465: EXCEPTION
466: WHEN NO_DATA_FOUND THEN
467: x_return_status := fnd_api.g_ret_sts_error;
468:
469: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data);
472: if( x_msg_count > 1 ) then
473: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 473: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

469: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data);
472: if( x_msg_count > 1 ) then
473: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
474: end if;
475: RETURN FALSE;
476:
477: WHEN OTHERS THEN

Line 480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

476:
477: WHEN OTHERS THEN
478: x_return_status := fnd_api.g_ret_sts_error;
479:
480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data);
483: if( x_msg_count > 1 ) then
484: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 484: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data);
483: if( x_msg_count > 1 ) then
484: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
485: end if;
486: RETURN FALSE;
487: END validate_reason_code;
488:

Line 524: fnd_msg_pub.ADD;

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;
528: CLOSE c_get_origination_type;

Line 536: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: x_return_status := fnd_api.g_ret_sts_error;
535:
536: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539: if( x_msg_count > 1 ) then
540: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 540: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

536: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539: if( x_msg_count > 1 ) then
540: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
541: end if;
542: RETURN FALSE;
543:
544: WHEN OTHERS THEN

Line 547: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

543:
544: WHEN OTHERS THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546:
547: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550: if( x_msg_count > 1 ) then
551: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 551: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

547: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550: if( x_msg_count > 1 ) then
551: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
552: end if;
553: RETURN FALSE;
554: END validate_origination_type;
555: -----------------------------------------------------------------------

Line 643: fnd_msg_pub.ADD;

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;
647: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 649: fnd_msg_pub.ADD;

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;
653: ELSE

Line 660: fnd_msg_pub.ADD;

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

Line 675: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: x_return_status := fnd_api.g_ret_sts_error;
674:
675: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
676: p_count => x_msg_count,
677: p_data => x_msg_data);
678: if( x_msg_count > 1 ) then
679: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 679: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

675: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
676: p_count => x_msg_count,
677: p_data => x_msg_data);
678: if( x_msg_count > 1 ) then
679: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
680: end if;
681: RETURN FALSE;
682:
683: WHEN OTHERS THEN

Line 686: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

682:
683: WHEN OTHERS THEN
684: x_return_status := fnd_api.g_ret_sts_error;
685:
686: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
687: p_count => x_msg_count,
688: p_data => x_msg_data);
689: if( x_msg_count > 1 ) then
690: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 690: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

686: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
687: p_count => x_msg_count,
688: p_data => x_msg_data);
689: if( x_msg_count > 1 ) then
690: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
691: end if;
692: RETURN FALSE;
693: END validate_child_lot;
694:

Line 817: FND_MSG_PUB.Count_AND_GET

813: EXCEPTION
814:
815: WHEN FND_API.G_EXC_ERROR THEN
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: FND_MSG_PUB.Count_AND_GET
818: (p_count => x_msg_count, p_data => x_msg_data);
819: -- dbms_output.put_line('Error : '|| l_msg_data );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 823: FND_MSG_PUB.Count_AND_GET

819: -- dbms_output.put_line('Error : '|| l_msg_data );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MSG_PUB.Count_AND_GET
824: (p_count => x_msg_count, p_data => x_msg_data);
825: -- dbms_output.put_line('Error : '|| l_msg_data );
826:
827: WHEN OTHERS THEN

Line 829: FND_MSG_PUB.Count_AND_GET

825: -- dbms_output.put_line('Error : '|| l_msg_data );
826:
827: WHEN OTHERS THEN
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_AND_GET
830: (p_count => x_msg_count, p_data => x_msg_data);
831: -- dbms_output.put_line('Error : '|| l_msg_data );
832:
833: END create_lot_uom_conv_wrapper;