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_API

Line 43: x_return_status := fnd_api.g_ret_sts_success;

39: AND organization_id = p_org_id;
40:
41:
42: BEGIN
43: x_return_status := fnd_api.g_ret_sts_success;
44: l_grade_control_flag := p_grade_control_flag;
45: /* get grade controlled flag */
46: IF p_grade_control_flag IS NULL
47: THEN

Line 57: RAISE fnd_api.g_exc_error;

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 */
61: IF l_grade_control_flag = 'Y'

Line 71: RAISE fnd_api.g_exc_error;

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

Line 80: x_return_status := fnd_api.g_ret_sts_error;

76:
77: RETURN TRUE;
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);

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 91: x_return_status := fnd_api.g_ret_sts_error;

87: end if;
88: RETURN 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);

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 128: x_return_status := fnd_api.g_ret_sts_success;

124: , x_msg_data OUT NOCOPY VARCHAR2)
125: RETURN BOOLEAN
126: IS
127: BEGIN
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');

Line 134: RAISE fnd_api.g_exc_error;

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;
138: RETURN TRUE;

Line 141: x_return_status := fnd_api.g_ret_sts_error;

137: END IF;
138: RETURN TRUE;
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);

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 178: x_return_status := fnd_api.g_ret_sts_success;

174: , x_msg_data OUT NOCOPY VARCHAR2)
175: RETURN BOOLEAN
176: IS
177: BEGIN
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');

Line 184: RAISE fnd_api.g_exc_error;

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;
188: RETURN TRUE;

Line 191: x_return_status := fnd_api.g_ret_sts_error;

187: END IF;
188: RETURN TRUE;
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);

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 222: x_return_status := fnd_api.g_ret_sts_success;

218: , x_msg_data OUT NOCOPY VARCHAR2)
219: RETURN BOOLEAN
220: IS
221: BEGIN
222: x_return_status := fnd_api.g_ret_sts_success;
223: IF (p_expiration_action_date IS NOT NULL) THEN
224: IF (p_expiration_date IS NOT NULL) THEN
225: -- fabdi bug 4168662, removed validations
226: /*

Line 230: RAISE fnd_api.g_exc_error;

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:
234: */

Line 239: RAISE fnd_api.g_exc_error;

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;
243: RETURN TRUE;

Line 246: x_return_status := fnd_api.g_ret_sts_error;

242: END IF;
243: RETURN TRUE;
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);

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 281: x_return_status := fnd_api.g_ret_sts_success;

277: , x_msg_data OUT NOCOPY VARCHAR2)
278: RETURN BOOLEAN
279: IS
280: BEGIN
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');

Line 287: RAISE fnd_api.g_exc_error;

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;
291: RETURN TRUE;

Line 294: x_return_status := fnd_api.g_ret_sts_error;

290: END IF;
291: RETURN TRUE;
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);

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 344: x_return_status := fnd_api.g_ret_sts_success;

340: AND organization_id = p_org_id;
341:
342:
343: BEGIN
344: x_return_status := fnd_api.g_ret_sts_success;
345: l_shelf_life_code := p_shelf_life_code;
346: /* get shelf life code flag */
347: IF p_shelf_life_code IS NULL
348: THEN

Line 365: RAISE fnd_api.g_exc_error;

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

Line 374: x_return_status := fnd_api.g_ret_sts_error;

370:
371: RETURN TRUE;
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);

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 385: x_return_status := fnd_api.g_ret_sts_error;

381: end if;
382: RETURN 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);

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 431: x_return_status := fnd_api.g_ret_sts_success;

427: WHERE MTR.REASON_NAME = p_reason_code
428: AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE;
429:
430: BEGIN
431: x_return_status := fnd_api.g_ret_sts_success;
432: l_reason_code := p_reason_code;
433: l_reason_id := p_reason_id;
434:
435: IF p_reason_code IS NOT NULL

Line 443: RAISE fnd_api.g_exc_error;

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;
447: Else

Line 457: RAISE fnd_api.g_exc_error;

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

Line 467: x_return_status := fnd_api.g_ret_sts_error;

463:
464: RETURN TRUE;
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);

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 478: x_return_status := fnd_api.g_ret_sts_error;

474: end if;
475: RETURN 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);

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 515: x_return_status := fnd_api.g_ret_sts_success;

511: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
512: AND lookup_code = p_origination_type;
513:
514: BEGIN
515: x_return_status := fnd_api.g_ret_sts_success;
516: IF p_origination_type IS NOT NULL
517: THEN
518: OPEN c_get_origination_type;
519: FETCH c_get_origination_type into l_origination_type;

Line 525: RAISE fnd_api.g_exc_error;

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

Line 534: x_return_status := fnd_api.g_ret_sts_error;

530:
531: RETURN TRUE;
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);

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 545: x_return_status := fnd_api.g_ret_sts_error;

541: end if;
542: RETURN 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);

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 610: x_return_status := fnd_api.g_ret_sts_success;

606: l_msg_data VARCHAR2(3000);
607:
608: l_lot_record c_get_lot_record%ROWTYPE;
609: BEGIN
610: x_return_status := fnd_api.g_ret_sts_success;
611: l_api_version := 1.0;
612: l_init_msg_list := fnd_api.g_false;
613: l_commit := fnd_api.g_false;
614:

Line 612: l_init_msg_list := fnd_api.g_false;

608: l_lot_record c_get_lot_record%ROWTYPE;
609: BEGIN
610: x_return_status := fnd_api.g_ret_sts_success;
611: l_api_version := 1.0;
612: l_init_msg_list := fnd_api.g_false;
613: l_commit := fnd_api.g_false;
614:
615: IF l_child_lot_flag IS NULL
616: THEN

Line 613: l_commit := fnd_api.g_false;

609: BEGIN
610: x_return_status := fnd_api.g_ret_sts_success;
611: l_api_version := 1.0;
612: l_init_msg_list := fnd_api.g_false;
613: l_commit := fnd_api.g_false;
614:
615: IF l_child_lot_flag IS NULL
616: THEN
617: OPEN c_child_lot_flag;

Line 640: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

636: , p_inventory_item_id => p_inventory_item_id
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;

Line 644: RAISE fnd_api.g_exc_unexpected_error;

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
648: fnd_message.set_name('INV', 'INV_INVALID_CHILD_LOT_EXP') ;

Line 647: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 650: RAISE fnd_api.g_exc_error;

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
654: /* existing lot */

Line 661: RAISE fnd_api.g_exc_error;

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

Line 673: x_return_status := fnd_api.g_ret_sts_error;

669:
670: RETURN TRUE;
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);

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 684: x_return_status := fnd_api.g_ret_sts_error;

680: end if;
681: RETURN 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);

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 749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

745: );
746:
747: IF ( l_rtn = 0) THEN
748: -- dbms_output.put_line('Error: validate_lot_conversion_rules ' || l_msg_data);
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750: END IF;
751: --dbms_output.put_line('Ok: validate_lot_conversion_rules ');
752:
753: l_conv_rec.lot_number := p_lot_number;

Line 790: , p_init_msg_list => FND_API.G_TRUE

786:
787:
788: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion
789: ( p_api_version => 1.0
790: , p_init_msg_list => FND_API.G_TRUE
791: , p_commit => FND_API.G_FALSE
792: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
793: , p_action_type => l_action_type
794: , p_update_type_indicator => '5'

Line 791: , p_commit => FND_API.G_FALSE

787:
788: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion
789: ( p_api_version => 1.0
790: , p_init_msg_list => FND_API.G_TRUE
791: , p_commit => FND_API.G_FALSE
792: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
793: , p_action_type => l_action_type
794: , p_update_type_indicator => '5'
795: , p_reason_id => NULL

Line 792: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

788: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion
789: ( p_api_version => 1.0
790: , p_init_msg_list => FND_API.G_TRUE
791: , p_commit => FND_API.G_FALSE
792: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
793: , p_action_type => l_action_type
794: , p_update_type_indicator => '5'
795: , p_reason_id => NULL
796: , p_batch_id => NULL

Line 797: , p_process_data => FND_API.G_TRUE

793: , p_action_type => l_action_type
794: , p_update_type_indicator => '5'
795: , p_reason_id => NULL
796: , p_batch_id => NULL
797: , p_process_data => FND_API.G_TRUE
798: , p_lot_uom_conv_rec => l_conv_rec
799: , p_qty_update_tbl => l_qty_tbl
800: , x_return_status => l_return_status
801: , x_msg_count => l_msg_count

Line 805: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

801: , x_msg_count => l_msg_count
802: , x_msg_data => l_msg_data
803: , x_sequence => l_sequence);
804:
805: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809:

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: , x_msg_data => l_msg_data
803: , x_sequence => l_sequence);
804:
805: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809:
810: -- dbms_output.put_line('Every thing is OK : create_lot_uom_conv_wrapper ');

Line 815: WHEN FND_API.G_EXC_ERROR THEN

811:
812:
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 );

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 );

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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