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.GMD_RECIPE_DESIGNER_PKG dependencies on FND_MESSAGE

Line 150: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

146: X_LAST_UPDATE_LOGIN => p_user_id);
147:
148: EXCEPTION
149: WHEN OTHERS THEN
150: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
151: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
152: x_return_code := 'F';
153: x_error_msg := FND_MESSAGE.GET;
154:

Line 151: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

147:
148: EXCEPTION
149: WHEN OTHERS THEN
150: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
151: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
152: x_return_code := 'F';
153: x_error_msg := FND_MESSAGE.GET;
154:
155: END Create_Text_Row;

Line 153: x_error_msg := FND_MESSAGE.GET;

149: WHEN OTHERS THEN
150: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
151: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
152: x_return_code := 'F';
153: x_error_msg := FND_MESSAGE.GET;
154:
155: END Create_Text_Row;
156:
157:

Line 218: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

214:
215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
219: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
220: x_return_code := 'F';
221: x_error_msg := FND_MESSAGE.GET;
222:

Line 219: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
219: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
220: x_return_code := 'F';
221: x_error_msg := FND_MESSAGE.GET;
222:
223: END Update_Text_Row;

Line 221: x_error_msg := FND_MESSAGE.GET;

217: WHEN OTHERS THEN
218: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
219: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
220: x_return_code := 'F';
221: x_error_msg := FND_MESSAGE.GET;
222:
223: END Update_Text_Row;
224:
225: /* Api start of comments

Line 277: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

273:
274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
279: x_return_code := 'F';
280: x_error_msg := FND_MESSAGE.GET;
281:

Line 278: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
279: x_return_code := 'F';
280: x_error_msg := FND_MESSAGE.GET;
281:
282: END Delete_Text_Row;

Line 280: x_error_msg := FND_MESSAGE.GET;

276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
279: x_return_code := 'F';
280: x_error_msg := FND_MESSAGE.GET;
281:
282: END Delete_Text_Row;
283:
284: /* Api start of comments

Line 363: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

359:
360:
361: EXCEPTION
362: WHEN NO_DATA_FOUND THEN
363: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
364: x_return_code := 'F';
365: x_error_msg := FND_MESSAGE.GET;
366:
367: WHEN OTHERS THEN

Line 365: x_error_msg := FND_MESSAGE.GET;

361: EXCEPTION
362: WHEN NO_DATA_FOUND THEN
363: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
364: x_return_code := 'F';
365: x_error_msg := FND_MESSAGE.GET;
366:
367: WHEN OTHERS THEN
368: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
369: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 368: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

364: x_return_code := 'F';
365: x_error_msg := FND_MESSAGE.GET;
366:
367: WHEN OTHERS THEN
368: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
369: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
370: x_return_code := 'F';
371: x_error_msg := FND_MESSAGE.GET;
372:

Line 369: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

365: x_error_msg := FND_MESSAGE.GET;
366:
367: WHEN OTHERS THEN
368: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
369: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
370: x_return_code := 'F';
371: x_error_msg := FND_MESSAGE.GET;
372:
373: END Update_Recipe_Routing_Step_Row;

Line 371: x_error_msg := FND_MESSAGE.GET;

367: WHEN OTHERS THEN
368: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
369: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
370: x_return_code := 'F';
371: x_error_msg := FND_MESSAGE.GET;
372:
373: END Update_Recipe_Routing_Step_Row;
374:
375: /* Api start of comments

Line 455: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

451: p_vol_uom);
452:
453: EXCEPTION
454: WHEN DUP_VAL_ON_INDEX THEN
455: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
456: x_return_code := 'F';
457: x_error_msg := FND_MESSAGE.GET;
458:
459: WHEN OTHERS THEN

Line 457: x_error_msg := FND_MESSAGE.GET;

453: EXCEPTION
454: WHEN DUP_VAL_ON_INDEX THEN
455: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
456: x_return_code := 'F';
457: x_error_msg := FND_MESSAGE.GET;
458:
459: WHEN OTHERS THEN
460: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
461: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 460: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

456: x_return_code := 'F';
457: x_error_msg := FND_MESSAGE.GET;
458:
459: WHEN OTHERS THEN
460: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
461: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
462: x_return_code := 'F';
463: x_error_msg := FND_MESSAGE.GET;
464:

Line 461: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

457: x_error_msg := FND_MESSAGE.GET;
458:
459: WHEN OTHERS THEN
460: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
461: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
462: x_return_code := 'F';
463: x_error_msg := FND_MESSAGE.GET;
464:
465: END Create_Recipe_Routing_Step_Row;

Line 463: x_error_msg := FND_MESSAGE.GET;

459: WHEN OTHERS THEN
460: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
461: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
462: x_return_code := 'F';
463: x_error_msg := FND_MESSAGE.GET;
464:
465: END Create_Recipe_Routing_Step_Row;
466:
467: /* Api start of comments

Line 533: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

529:
530:
531: EXCEPTION
532: WHEN DUP_VAL_ON_INDEX THEN
533: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
534: x_return_code := 'F';
535: x_error_msg := FND_MESSAGE.GET;
536:
537: WHEN OTHERS THEN

Line 535: x_error_msg := FND_MESSAGE.GET;

531: EXCEPTION
532: WHEN DUP_VAL_ON_INDEX THEN
533: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
534: x_return_code := 'F';
535: x_error_msg := FND_MESSAGE.GET;
536:
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
539: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 538: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

534: x_return_code := 'F';
535: x_error_msg := FND_MESSAGE.GET;
536:
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
539: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
540: x_return_code := 'F';
541: x_error_msg := FND_MESSAGE.GET;
542:

Line 539: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

535: x_error_msg := FND_MESSAGE.GET;
536:
537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
539: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
540: x_return_code := 'F';
541: x_error_msg := FND_MESSAGE.GET;
542:
543: END Create_Step_Material_Link;

Line 541: x_error_msg := FND_MESSAGE.GET;

537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
539: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
540: x_return_code := 'F';
541: x_error_msg := FND_MESSAGE.GET;
542:
543: END Create_Step_Material_Link;
544:
545:

Line 618: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

614: --- CLOSE Get_Step;
615:
616:
617: IF SQL%NOTFOUND THEN
618: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
619: x_return_code := 'F';
620: x_error_msg := FND_MESSAGE.GET;
621: END IF;
622:

Line 620: x_error_msg := FND_MESSAGE.GET;

616:
617: IF SQL%NOTFOUND THEN
618: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
619: x_return_code := 'F';
620: x_error_msg := FND_MESSAGE.GET;
621: END IF;
622:
623: EXCEPTION
624: WHEN OTHERS THEN

Line 625: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

621: END IF;
622:
623: EXCEPTION
624: WHEN OTHERS THEN
625: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
627: x_return_code := 'F';
628: x_error_msg := FND_MESSAGE.GET;
629:

Line 626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

622:
623: EXCEPTION
624: WHEN OTHERS THEN
625: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
627: x_return_code := 'F';
628: x_error_msg := FND_MESSAGE.GET;
629:
630: END Delete_Step_Material_Link;

Line 628: x_error_msg := FND_MESSAGE.GET;

624: WHEN OTHERS THEN
625: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
627: x_return_code := 'F';
628: x_error_msg := FND_MESSAGE.GET;
629:
630: END Delete_Step_Material_Link;
631:
632:

Line 692: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

688: last_update_date = p_last_update_date_origin;
689:
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
693: x_return_code := 'F';
694: x_error_msg := FND_MESSAGE.GET;
695:
696: WHEN OTHERS THEN

Line 694: x_error_msg := FND_MESSAGE.GET;

690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
693: x_return_code := 'F';
694: x_error_msg := FND_MESSAGE.GET;
695:
696: WHEN OTHERS THEN
697: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
698: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 697: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

693: x_return_code := 'F';
694: x_error_msg := FND_MESSAGE.GET;
695:
696: WHEN OTHERS THEN
697: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
698: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
699: x_return_code := 'F';
700: x_error_msg := FND_MESSAGE.GET;
701:

Line 698: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

694: x_error_msg := FND_MESSAGE.GET;
695:
696: WHEN OTHERS THEN
697: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
698: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
699: x_return_code := 'F';
700: x_error_msg := FND_MESSAGE.GET;
701:
702: END Update_Step_Material_Link;

Line 700: x_error_msg := FND_MESSAGE.GET;

696: WHEN OTHERS THEN
697: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
698: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
699: x_return_code := 'F';
700: x_error_msg := FND_MESSAGE.GET;
701:
702: END Update_Step_Material_Link;
703:
704:

Line 1027: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1023: p_msg_index_out => l_temp);
1024: x_error_msg := l_message;
1025:
1026: WHEN OTHERS THEN
1027: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1028: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1029: x_return_code := 'F';
1030: x_error_msg := FND_MESSAGE.GET;
1031:

Line 1028: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1024: x_error_msg := l_message;
1025:
1026: WHEN OTHERS THEN
1027: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1028: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1029: x_return_code := 'F';
1030: x_error_msg := FND_MESSAGE.GET;
1031:
1032: END Calculate_Step_Quantities;

Line 1030: x_error_msg := FND_MESSAGE.GET;

1026: WHEN OTHERS THEN
1027: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1028: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1029: x_return_code := 'F';
1030: x_error_msg := FND_MESSAGE.GET;
1031:
1032: END Calculate_Step_Quantities;
1033:
1034: /* Api start of comments

Line 1112: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1108: END IF;
1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1113: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1114: x_return_code := 'F';
1115: x_error_msg := FND_MESSAGE.GET;
1116:

Line 1113: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1113: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1114: x_return_code := 'F';
1115: x_error_msg := FND_MESSAGE.GET;
1116:
1117: END Calculate_Step_Charges;

Line 1115: x_error_msg := FND_MESSAGE.GET;

1111: WHEN OTHERS THEN
1112: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1113: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1114: x_return_code := 'F';
1115: x_error_msg := FND_MESSAGE.GET;
1116:
1117: END Calculate_Step_Charges;
1118:
1119:

Line 1437: FND_MESSAGE.SET_NAME('GMD', l_message);

1433: FND_MSG_PUB.GET(p_msg_index => 1,
1434: p_data => l_message,
1435: p_encoded => 'F',
1436: p_msg_index_out => l_temp);
1437: FND_MESSAGE.SET_NAME('GMD', l_message);
1438: x_error_msg := FND_MESSAGE.GET;
1439:
1440: WHEN ROUTING_STEP_ID_NOT_FOUND THEN
1441: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1438: x_error_msg := FND_MESSAGE.GET;

1434: p_data => l_message,
1435: p_encoded => 'F',
1436: p_msg_index_out => l_temp);
1437: FND_MESSAGE.SET_NAME('GMD', l_message);
1438: x_error_msg := FND_MESSAGE.GET;
1439:
1440: WHEN ROUTING_STEP_ID_NOT_FOUND THEN
1441: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1442: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 1441: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1437: FND_MESSAGE.SET_NAME('GMD', l_message);
1438: x_error_msg := FND_MESSAGE.GET;
1439:
1440: WHEN ROUTING_STEP_ID_NOT_FOUND THEN
1441: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1442: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1443: x_return_code := 'F';
1444: x_error_msg := FND_MESSAGE.GET;
1445:

Line 1442: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1438: x_error_msg := FND_MESSAGE.GET;
1439:
1440: WHEN ROUTING_STEP_ID_NOT_FOUND THEN
1441: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1442: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1443: x_return_code := 'F';
1444: x_error_msg := FND_MESSAGE.GET;
1445:
1446: WHEN DUP_VAL_ON_INDEX THEN

Line 1444: x_error_msg := FND_MESSAGE.GET;

1440: WHEN ROUTING_STEP_ID_NOT_FOUND THEN
1441: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1442: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1443: x_return_code := 'F';
1444: x_error_msg := FND_MESSAGE.GET;
1445:
1446: WHEN DUP_VAL_ON_INDEX THEN
1447: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1448: x_return_code := 'F';

Line 1447: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

1443: x_return_code := 'F';
1444: x_error_msg := FND_MESSAGE.GET;
1445:
1446: WHEN DUP_VAL_ON_INDEX THEN
1447: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1448: x_return_code := 'F';
1449: x_error_msg := FND_MESSAGE.GET;
1450:
1451: WHEN OTHERS THEN

Line 1449: x_error_msg := FND_MESSAGE.GET;

1445:
1446: WHEN DUP_VAL_ON_INDEX THEN
1447: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1448: x_return_code := 'F';
1449: x_error_msg := FND_MESSAGE.GET;
1450:
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 1452: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1448: x_return_code := 'F';
1449: x_error_msg := FND_MESSAGE.GET;
1450:
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1454: x_return_code := 'F';
1455: x_error_msg := FND_MESSAGE.GET;
1456:

Line 1453: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1449: x_error_msg := FND_MESSAGE.GET;
1450:
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1454: x_return_code := 'F';
1455: x_error_msg := FND_MESSAGE.GET;
1456:
1457: END Update_Step_Quantities;

Line 1455: x_error_msg := FND_MESSAGE.GET;

1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1454: x_return_code := 'F';
1455: x_error_msg := FND_MESSAGE.GET;
1456:
1457: END Update_Step_Quantities;
1458: */
1459:

Line 1674: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1670:
1671:
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1675: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1676: x_return_code := 'F';
1677: x_error_msg := FND_MESSAGE.GET;
1678:

Line 1675: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1671:
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1675: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1676: x_return_code := 'F';
1677: x_error_msg := FND_MESSAGE.GET;
1678:
1679:

Line 1677: x_error_msg := FND_MESSAGE.GET;

1673: WHEN OTHERS THEN
1674: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1675: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1676: x_return_code := 'F';
1677: x_error_msg := FND_MESSAGE.GET;
1678:
1679:
1680: END Get_Routing_Step_Quantities;
1681:

Line 1986: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

1982: x_return_code := 'F';
1983: x_error_msg := l_message;
1984:
1985: WHEN RECORD_CHANGED_EXCEPTION THEN
1986: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1987: x_return_code := 'F';
1988: x_error_msg := FND_MESSAGE.GET;
1989:
1990: WHEN OTHERS THEN

Line 1988: x_error_msg := FND_MESSAGE.GET;

1984:
1985: WHEN RECORD_CHANGED_EXCEPTION THEN
1986: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1987: x_return_code := 'F';
1988: x_error_msg := FND_MESSAGE.GET;
1989:
1990: WHEN OTHERS THEN
1991: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1992: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 1991: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1987: x_return_code := 'F';
1988: x_error_msg := FND_MESSAGE.GET;
1989:
1990: WHEN OTHERS THEN
1991: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1992: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1993: x_return_code := 'F';
1994: x_error_msg := FND_MESSAGE.GET;
1995:

Line 1992: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1988: x_error_msg := FND_MESSAGE.GET;
1989:
1990: WHEN OTHERS THEN
1991: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1992: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1993: x_return_code := 'F';
1994: x_error_msg := FND_MESSAGE.GET;
1995:
1996: END Update_Recipe_Header;

Line 1994: x_error_msg := FND_MESSAGE.GET;

1990: WHEN OTHERS THEN
1991: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1992: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1993: x_return_code := 'F';
1994: x_error_msg := FND_MESSAGE.GET;
1995:
1996: END Update_Recipe_Header;
1997:
1998:

Line 2052: x_error_msg := FND_MESSAGE.GET;

2048:
2049: BEGIN
2050:
2051: x_return_code := FND_API.G_RET_STS_SUCCESS;
2052: x_error_msg := FND_MESSAGE.GET;
2053:
2054: OPEN Cur_recipe_id;
2055: FETCH Cur_recipe_id INTO x_recipe_id;
2056: CLOSE Cur_recipe_id;

Line 2203: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2199: x_return_code := 'F';
2200: x_error_msg := l_message;
2201:
2202: WHEN OTHERS THEN
2203: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2204: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2205: x_return_code := 'F';
2206: x_error_msg := FND_MESSAGE.GET;
2207:

Line 2204: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2200: x_error_msg := l_message;
2201:
2202: WHEN OTHERS THEN
2203: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2204: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2205: x_return_code := 'F';
2206: x_error_msg := FND_MESSAGE.GET;
2207:
2208: END Create_Recipe_Header;

Line 2206: x_error_msg := FND_MESSAGE.GET;

2202: WHEN OTHERS THEN
2203: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2204: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2205: x_return_code := 'F';
2206: x_error_msg := FND_MESSAGE.GET;
2207:
2208: END Create_Recipe_Header;
2209:
2210:

Line 2301: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2297: x_return_code := 'F';
2298: x_error_msg := l_message;
2299:
2300: WHEN NO_DATA_FOUND THEN
2301: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2302: x_return_code := 'F';
2303: x_error_msg := FND_MESSAGE.GET;
2304:
2305: WHEN OTHERS THEN

Line 2303: x_error_msg := FND_MESSAGE.GET;

2299:
2300: WHEN NO_DATA_FOUND THEN
2301: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2302: x_return_code := 'F';
2303: x_error_msg := FND_MESSAGE.GET;
2304:
2305: WHEN OTHERS THEN
2306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 2306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2302: x_return_code := 'F';
2303: x_error_msg := FND_MESSAGE.GET;
2304:
2305: WHEN OTHERS THEN
2306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2308: x_return_code := 'F';
2309: x_error_msg := FND_MESSAGE.GET;
2310:

Line 2307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2303: x_error_msg := FND_MESSAGE.GET;
2304:
2305: WHEN OTHERS THEN
2306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2308: x_return_code := 'F';
2309: x_error_msg := FND_MESSAGE.GET;
2310:
2311: END Add_Recipe_Customer;

Line 2309: x_error_msg := FND_MESSAGE.GET;

2305: WHEN OTHERS THEN
2306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2308: x_return_code := 'F';
2309: x_error_msg := FND_MESSAGE.GET;
2310:
2311: END Add_Recipe_Customer;
2312:
2313: /* Api start of comments

Line 2359: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2355: customer_id = p_customer_id AND
2356: last_update_date = p_last_update_date;
2357:
2358: IF SQL%NOTFOUND THEN
2359: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2360: x_return_code := 'F';
2361: x_error_msg := FND_MESSAGE.GET;
2362: END IF;
2363:

Line 2361: x_error_msg := FND_MESSAGE.GET;

2357:
2358: IF SQL%NOTFOUND THEN
2359: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2360: x_return_code := 'F';
2361: x_error_msg := FND_MESSAGE.GET;
2362: END IF;
2363:
2364: EXCEPTION
2365: WHEN OTHERS THEN

Line 2366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2362: END IF;
2363:
2364: EXCEPTION
2365: WHEN OTHERS THEN
2366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2368: x_return_code := 'F';
2369: x_error_msg := FND_MESSAGE.GET;
2370:

Line 2367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2363:
2364: EXCEPTION
2365: WHEN OTHERS THEN
2366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2368: x_return_code := 'F';
2369: x_error_msg := FND_MESSAGE.GET;
2370:
2371: End Delete_Recipe_Customer;

Line 2369: x_error_msg := FND_MESSAGE.GET;

2365: WHEN OTHERS THEN
2366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2368: x_return_code := 'F';
2369: x_error_msg := FND_MESSAGE.GET;
2370:
2371: End Delete_Recipe_Customer;
2372:
2373:

Line 2475: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2471: x_return_code := 'F';
2472: x_error_msg := l_message;
2473:
2474: WHEN NO_DATA_FOUND THEN
2475: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2476: x_return_code := 'F';
2477: x_error_msg := FND_MESSAGE.GET;
2478:
2479: WHEN OTHERS THEN

Line 2477: x_error_msg := FND_MESSAGE.GET;

2473:
2474: WHEN NO_DATA_FOUND THEN
2475: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2476: x_return_code := 'F';
2477: x_error_msg := FND_MESSAGE.GET;
2478:
2479: WHEN OTHERS THEN
2480: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2481: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 2480: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2476: x_return_code := 'F';
2477: x_error_msg := FND_MESSAGE.GET;
2478:
2479: WHEN OTHERS THEN
2480: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2481: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2482: x_return_code := 'F';
2483: x_error_msg := FND_MESSAGE.GET;
2484:

Line 2481: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2477: x_error_msg := FND_MESSAGE.GET;
2478:
2479: WHEN OTHERS THEN
2480: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2481: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2482: x_return_code := 'F';
2483: x_error_msg := FND_MESSAGE.GET;
2484:
2485: END Create_Process_Loss;

Line 2483: x_error_msg := FND_MESSAGE.GET;

2479: WHEN OTHERS THEN
2480: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2481: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2482: x_return_code := 'F';
2483: x_error_msg := FND_MESSAGE.GET;
2484:
2485: END Create_Process_Loss;
2486:
2487: /* Api start of comments

Line 2581: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2577: recipe_process_loss_id = p_loss_id AND
2578: last_update_date = p_last_update_date;
2579:
2580: IF SQL%NOTFOUND THEN
2581: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2582: x_return_code := 'F';
2583: x_error_msg := FND_MESSAGE.GET;
2584: END IF;
2585:

Line 2583: x_error_msg := FND_MESSAGE.GET;

2579:
2580: IF SQL%NOTFOUND THEN
2581: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2582: x_return_code := 'F';
2583: x_error_msg := FND_MESSAGE.GET;
2584: END IF;
2585:
2586: EXCEPTION
2587: WHEN OTHERS THEN

Line 2588: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2584: END IF;
2585:
2586: EXCEPTION
2587: WHEN OTHERS THEN
2588: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2589: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2590: x_return_code := 'F';
2591: x_error_msg := FND_MESSAGE.GET;
2592:

Line 2589: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2585:
2586: EXCEPTION
2587: WHEN OTHERS THEN
2588: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2589: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2590: x_return_code := 'F';
2591: x_error_msg := FND_MESSAGE.GET;
2592:
2593: END Delete_Org_Process_Loss;

Line 2591: x_error_msg := FND_MESSAGE.GET;

2587: WHEN OTHERS THEN
2588: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2589: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2590: x_return_code := 'F';
2591: x_error_msg := FND_MESSAGE.GET;
2592:
2593: END Delete_Org_Process_Loss;
2594:
2595: /* Api start of comments

Line 2702: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2698: x_return_code := 'F';
2699: x_error_msg := l_message;
2700:
2701: WHEN NO_DATA_FOUND THEN
2702: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2703: x_return_code := 'F';
2704: x_error_msg := FND_MESSAGE.GET;
2705:
2706: WHEN OTHERS THEN

Line 2704: x_error_msg := FND_MESSAGE.GET;

2700:
2701: WHEN NO_DATA_FOUND THEN
2702: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2703: x_return_code := 'F';
2704: x_error_msg := FND_MESSAGE.GET;
2705:
2706: WHEN OTHERS THEN
2707: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2708: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 2707: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2703: x_return_code := 'F';
2704: x_error_msg := FND_MESSAGE.GET;
2705:
2706: WHEN OTHERS THEN
2707: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2708: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2709: x_return_code := 'F';
2710: x_error_msg := FND_MESSAGE.GET;
2711:

Line 2708: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2704: x_error_msg := FND_MESSAGE.GET;
2705:
2706: WHEN OTHERS THEN
2707: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2708: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2709: x_return_code := 'F';
2710: x_error_msg := FND_MESSAGE.GET;
2711:
2712: END Update_Org_Process_Loss;

Line 2710: x_error_msg := FND_MESSAGE.GET;

2706: WHEN OTHERS THEN
2707: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2708: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2709: x_return_code := 'F';
2710: x_error_msg := FND_MESSAGE.GET;
2711:
2712: END Update_Org_Process_Loss;
2713:
2714: /* Api start of comments

Line 2851: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2847: x_return_code := 'F';
2848: x_error_msg := l_message;
2849:
2850: WHEN NO_DATA_FOUND THEN
2851: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2852: x_return_code := 'F';
2853: x_error_msg := FND_MESSAGE.GET;
2854:
2855: WHEN OTHERS THEN

Line 2853: x_error_msg := FND_MESSAGE.GET;

2849:
2850: WHEN NO_DATA_FOUND THEN
2851: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
2852: x_return_code := 'F';
2853: x_error_msg := FND_MESSAGE.GET;
2854:
2855: WHEN OTHERS THEN
2856: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2857: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 2856: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

2852: x_return_code := 'F';
2853: x_error_msg := FND_MESSAGE.GET;
2854:
2855: WHEN OTHERS THEN
2856: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2857: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2858: x_return_code := 'F';
2859: x_error_msg := FND_MESSAGE.GET;
2860:

Line 2857: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

2853: x_error_msg := FND_MESSAGE.GET;
2854:
2855: WHEN OTHERS THEN
2856: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2857: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2858: x_return_code := 'F';
2859: x_error_msg := FND_MESSAGE.GET;
2860:
2861: END Delete_Recipe;

Line 2859: x_error_msg := FND_MESSAGE.GET;

2855: WHEN OTHERS THEN
2856: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2857: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2858: x_return_code := 'F';
2859: x_error_msg := FND_MESSAGE.GET;
2860:
2861: END Delete_Recipe;
2862:
2863: /* Api start of comments

Line 2999: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

2995: x_return_code := 'F';
2996: x_error_msg := l_message;
2997:
2998: WHEN NO_DATA_FOUND THEN
2999: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
3000: x_return_code := 'F';
3001: x_error_msg := FND_MESSAGE.GET;
3002:
3003: WHEN OTHERS THEN

Line 3001: x_error_msg := FND_MESSAGE.GET;

2997:
2998: WHEN NO_DATA_FOUND THEN
2999: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
3000: x_return_code := 'F';
3001: x_error_msg := FND_MESSAGE.GET;
3002:
3003: WHEN OTHERS THEN
3004: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3005: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 3004: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

3000: x_return_code := 'F';
3001: x_error_msg := FND_MESSAGE.GET;
3002:
3003: WHEN OTHERS THEN
3004: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3005: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3006: x_return_code := 'F';
3007: x_error_msg := FND_MESSAGE.GET;
3008:

Line 3005: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

3001: x_error_msg := FND_MESSAGE.GET;
3002:
3003: WHEN OTHERS THEN
3004: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3005: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3006: x_return_code := 'F';
3007: x_error_msg := FND_MESSAGE.GET;
3008:
3009: END Undelete_Recipe;

Line 3007: x_error_msg := FND_MESSAGE.GET;

3003: WHEN OTHERS THEN
3004: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3005: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3006: x_return_code := 'F';
3007: x_error_msg := FND_MESSAGE.GET;
3008:
3009: END Undelete_Recipe;
3010:
3011:

Line 3081: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

3077: x_return_code := 'F';
3078: x_error_msg := l_message;
3079:
3080: WHEN OTHERS THEN
3081: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3082: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3083: x_return_code := 'U';
3084: x_error_msg := FND_MESSAGE.GET;
3085:

Line 3082: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

3078: x_error_msg := l_message;
3079:
3080: WHEN OTHERS THEN
3081: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3082: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3083: x_return_code := 'U';
3084: x_error_msg := FND_MESSAGE.GET;
3085:
3086: END Get_Theoretical_Process_Loss;

Line 3084: x_error_msg := FND_MESSAGE.GET;

3080: WHEN OTHERS THEN
3081: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3082: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3083: x_return_code := 'U';
3084: x_error_msg := FND_MESSAGE.GET;
3085:
3086: END Get_Theoretical_Process_Loss;
3087:
3088: /* Api start of comments

Line 3152: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

3148: p_msg_index_out => l_dummy);
3149: x_return_code := 'F';
3150:
3151: WHEN OTHERS THEN
3152: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3153: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3154: x_return_code := 'U';
3155: x_error_msg := FND_MESSAGE.GET;
3156:

Line 3153: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

3149: x_return_code := 'F';
3150:
3151: WHEN OTHERS THEN
3152: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3153: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3154: x_return_code := 'U';
3155: x_error_msg := FND_MESSAGE.GET;
3156:
3157: END Check_Step_Qty_Calculatable;

Line 3155: x_error_msg := FND_MESSAGE.GET;

3151: WHEN OTHERS THEN
3152: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
3153: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
3154: x_return_code := 'U';
3155: x_error_msg := FND_MESSAGE.GET;
3156:
3157: END Check_Step_Qty_Calculatable;
3158:
3159:

Line 5391: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_FOUND');

5387: x_return_code := 'F';
5388:
5389: WHEN RECIPE_NOT_FOUND THEN
5390: ROLLBACK TO Copy_Recipe;
5391: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_FOUND');
5392: x_return_code := 'F';
5393: x_error_msg := FND_MESSAGE.GET;
5394:
5395: WHEN ROUTING_NOT_FOUND THEN

Line 5393: x_error_msg := FND_MESSAGE.GET;

5389: WHEN RECIPE_NOT_FOUND THEN
5390: ROLLBACK TO Copy_Recipe;
5391: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_FOUND');
5392: x_return_code := 'F';
5393: x_error_msg := FND_MESSAGE.GET;
5394:
5395: WHEN ROUTING_NOT_FOUND THEN
5396: ROLLBACK TO Copy_Recipe;
5397: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

Line 5397: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

5393: x_error_msg := FND_MESSAGE.GET;
5394:
5395: WHEN ROUTING_NOT_FOUND THEN
5396: ROLLBACK TO Copy_Recipe;
5397: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
5398: x_return_code := 'F';
5399: x_error_msg := FND_MESSAGE.GET;
5400:
5401: WHEN FORMULA_NOT_FOUND THEN

Line 5399: x_error_msg := FND_MESSAGE.GET;

5395: WHEN ROUTING_NOT_FOUND THEN
5396: ROLLBACK TO Copy_Recipe;
5397: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
5398: x_return_code := 'F';
5399: x_error_msg := FND_MESSAGE.GET;
5400:
5401: WHEN FORMULA_NOT_FOUND THEN
5402: ROLLBACK TO Copy_Recipe;
5403: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_NOT_FOUND');

Line 5403: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_NOT_FOUND');

5399: x_error_msg := FND_MESSAGE.GET;
5400:
5401: WHEN FORMULA_NOT_FOUND THEN
5402: ROLLBACK TO Copy_Recipe;
5403: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_NOT_FOUND');
5404: x_return_code := 'F';
5405: x_error_msg := FND_MESSAGE.GET;
5406:
5407: WHEN GET_SURROGATE_EXCEPTION THEN

Line 5405: x_error_msg := FND_MESSAGE.GET;

5401: WHEN FORMULA_NOT_FOUND THEN
5402: ROLLBACK TO Copy_Recipe;
5403: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_NOT_FOUND');
5404: x_return_code := 'F';
5405: x_error_msg := FND_MESSAGE.GET;
5406:
5407: WHEN GET_SURROGATE_EXCEPTION THEN
5408: ROLLBACK TO Copy_Recipe;
5409: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 5409: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

5405: x_error_msg := FND_MESSAGE.GET;
5406:
5407: WHEN GET_SURROGATE_EXCEPTION THEN
5408: ROLLBACK TO Copy_Recipe;
5409: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
5410: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
5411: x_return_code := 'F';
5412: x_error_msg := FND_MESSAGE.GET;
5413:

Line 5410: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

5406:
5407: WHEN GET_SURROGATE_EXCEPTION THEN
5408: ROLLBACK TO Copy_Recipe;
5409: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
5410: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
5411: x_return_code := 'F';
5412: x_error_msg := FND_MESSAGE.GET;
5413:
5414: WHEN OTHERS THEN

Line 5412: x_error_msg := FND_MESSAGE.GET;

5408: ROLLBACK TO Copy_Recipe;
5409: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
5410: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
5411: x_return_code := 'F';
5412: x_error_msg := FND_MESSAGE.GET;
5413:
5414: WHEN OTHERS THEN
5415: ROLLBACK TO Copy_Recipe;
5416: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 5416: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

5412: x_error_msg := FND_MESSAGE.GET;
5413:
5414: WHEN OTHERS THEN
5415: ROLLBACK TO Copy_Recipe;
5416: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
5417: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
5418: x_return_code := 'U';
5419: x_error_msg := FND_MESSAGE.GET;
5420:

Line 5417: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

5413:
5414: WHEN OTHERS THEN
5415: ROLLBACK TO Copy_Recipe;
5416: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
5417: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
5418: x_return_code := 'U';
5419: x_error_msg := FND_MESSAGE.GET;
5420:
5421: END Copy_Recipe;

Line 5419: x_error_msg := FND_MESSAGE.GET;

5415: ROLLBACK TO Copy_Recipe;
5416: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
5417: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
5418: x_return_code := 'U';
5419: x_error_msg := FND_MESSAGE.GET;
5420:
5421: END Copy_Recipe;
5422:
5423: /* Api start of comments

Line 5583: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');

5579: -- Check for any experimental items when formula status is apfgu.
5580: IF (pEntity_name = 'FORMULA') THEN
5581: IF (l_entity_status.status_type = 700) THEN
5582: IF (gmdfmval_pub.check_expr_items(pEntity_id)) THEN
5583: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
5584: FND_MSG_PUB.ADD;
5585: RAISE FND_API.G_EXC_ERROR;
5586: END IF;
5587: END IF; -- IF (X_status_type = 700) THEN

Line 5592: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');

5588:
5589: --Check any inactive items in formula before changing the status
5590: IF (l_entity_status.status_type IN (400,700)) THEN
5591: IF (gmdfmval_pub.inactive_items(pEntity_id)) THEN
5592: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
5593: FND_MSG_PUB.ADD;
5594: RAISE FND_API.G_EXC_ERROR;
5595: END IF;
5596: END IF; --l_entity_status.status_type IN (400,700)