DBA Data[Home] [Help]

APPS.GMF_VIB dependencies on FND_MESSAGE

Line 93: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_REQ_EXISTS');

89:
90: IF l_count > 0 THEN
91: dbms_output.put_line ('Batch requirement already exist for the batch');
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_REQ_EXISTS');
94: FND_MSG_PUB.Add;
95: RETURN;
96: END IF;
97: END;

Line 178: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
178: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
179: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
180: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
181: FND_MSG_PUB.Add;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 179: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

175: EXCEPTION
176: WHEN OTHERS THEN
177: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
178: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
179: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
180: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
181: FND_MSG_PUB.Add;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: END Create_Batch_Requirements;

Line 180: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

176: WHEN OTHERS THEN
177: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
178: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
179: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
180: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
181: FND_MSG_PUB.Add;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: END Create_Batch_Requirements;
184:

Line 307: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

303:
304: EXCEPTION
305: WHEN OTHERS THEN
306: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
307: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
308: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
309: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
310: FND_MSG_PUB.Add;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 308: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

304: EXCEPTION
305: WHEN OTHERS THEN
306: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
307: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
308: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
309: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
310: FND_MSG_PUB.Add;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
312: END Update_Batch_Requirements;

Line 309: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

305: WHEN OTHERS THEN
306: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
307: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
308: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
309: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
310: FND_MSG_PUB.Add;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
312: END Update_Batch_Requirements;
313:

Line 363: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_PENDING');

359:
360: IF l_batch_status <> 1 THEN
361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: dbms_output.put_line ('Batch is not in PENDING Status');
363: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_PENDING');
364: FND_MSG_PUB.Add;
365: RETURN;
366: END IF;
367: EXCEPTION

Line 370: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');

366: END IF;
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
371: FND_MSG_PUB.Add;
372: RAISE;
373: END;
374:

Line 398: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

394:
395: EXCEPTION
396: WHEN OTHERS THEN
397: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
398: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
399: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
400: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
401: FND_MSG_PUB.Add;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 399: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

395: EXCEPTION
396: WHEN OTHERS THEN
397: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
398: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
399: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
400: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
401: FND_MSG_PUB.Add;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: END;

Line 400: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

396: WHEN OTHERS THEN
397: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
398: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
399: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
400: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
401: FND_MSG_PUB.Add;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: END;
404:

Line 503: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_WIP');

499: /* Bug 9441550 . Added status -1. */
500: IF l_batch_status not in (-1,2, 3, 4) THEN
501: -- x_return_status := FND_API.G_RET_STS_ERROR ;
502: dbms_output.put_line ('Batch is not in WIP/Cert/Close Status');
503: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_WIP');
504: -- FND_MSG_PUB.Add;
505: x_return_status := FND_API.G_RET_STS_SUCCESS ;
506: RETURN;
507: END IF;

Line 521: FND_MESSAGE.SET_NAME('GMF', 'GMF_INVALID_BATCH');

517: nvl(m.cost_alloc,0) <> 0;
518:
519: IF l_count = 0 THEN
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MESSAGE.SET_NAME('GMF', 'GMF_INVALID_BATCH');
522: FND_MSG_PUB.Add;
523: RETURN;
524: END IF;
525: /* Bug 6125370 - End */

Line 530: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');

526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: dbms_output.put_line ('Invalid Batch ID');
530: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
531: FND_MSG_PUB.Add;
532: RAISE;
533: END;
534:

Line 955: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

951:
952: EXCEPTION
953: WHEN OTHERS THEN
954: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
955: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
956: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
957: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
958: FND_MSG_PUB.Add;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 956: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

952: EXCEPTION
953: WHEN OTHERS THEN
954: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
955: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
956: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
957: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
958: FND_MSG_PUB.Add;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
960: End Create_Temp_Batch_Requirements;

Line 957: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

953: WHEN OTHERS THEN
954: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
955: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
956: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
957: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
958: FND_MSG_PUB.Add;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
960: End Create_Temp_Batch_Requirements;
961:

Line 1180: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_VIB_EXIST');

1176: IF l_count > 0 THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR ;
1178: x_msg_data := 'VIB Details already exist';
1179: dbms_output.put_line ('VIB Details already exist');
1180: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_VIB_EXIST');
1181: FND_MSG_PUB.Add;
1182: RETURN;
1183: END IF;
1184:

Line 1817: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

1813:
1814: EXCEPTION
1815: WHEN OTHERS THEN
1816: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
1817: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
1818: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1819: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
1820: FND_MSG_PUB.Add;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1818: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

1814: EXCEPTION
1815: WHEN OTHERS THEN
1816: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
1817: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
1818: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1819: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
1820: FND_MSG_PUB.Add;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: END;

Line 1819: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

1815: WHEN OTHERS THEN
1816: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
1817: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
1818: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1819: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
1820: FND_MSG_PUB.Add;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: END;
1823:

Line 1991: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_CLOSE');

1987:
1988: IF l_batch_status <> 4 THEN
1989: x_return_status := FND_API.G_RET_STS_ERROR ;
1990: --dbms_output.put_line ('Batch is not in CLOSE Status');
1991: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_CLOSE');
1992: FND_MSG_PUB.Add;
1993: RETURN;
1994: END IF;
1995: EXCEPTION

Line 1998: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');

1994: END IF;
1995: EXCEPTION
1996: WHEN OTHERS THEN
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1998: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
1999: FND_MSG_PUB.Add;
2000: RAISE;
2001: END;
2002:

Line 2017: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_FINAL_VIB_EXIST');

2013:
2014: IF l_count > 0 THEN
2015: x_return_status := FND_API.G_RET_STS_ERROR ;
2016: --dbms_output.put_line ('VIB details already exist for this batch');
2017: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_FINAL_VIB_EXIST');
2018: FND_MSG_PUB.Add;
2019: RETURN;
2020: END IF;
2021: EXCEPTION

Line 2024: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');

2020: END IF;
2021: EXCEPTION
2022: WHEN OTHERS THEN
2023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2024: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
2025: FND_MSG_PUB.Add;
2026: RAISE;
2027: END;
2028:

Line 2564: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

2560:
2561: EXCEPTION
2562: WHEN OTHERS THEN
2563: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2564: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2565: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2566: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2567: FND_MSG_PUB.Add;
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2565: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

2561: EXCEPTION
2562: WHEN OTHERS THEN
2563: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2564: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2565: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2566: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2567: FND_MSG_PUB.Add;
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2569: END;

Line 2566: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

2562: WHEN OTHERS THEN
2563: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2564: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2565: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2566: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2567: FND_MSG_PUB.Add;
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2569: END;
2570:

Line 2651: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');

2647:
2648: IF l_batch_status = 4 THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR ;
2650: --dbms_output.put_line ('Cannot revert finalization of a closed batch ');
2651: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');
2652: FND_MSG_PUB.Add;
2653: RETURN;
2654: END IF;
2655: -- Bug 11839588

Line 2670: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');

2666: p_message => l_posted_count||' Posted events exist. Batch Can not be Reopened.',
2667: p_error_type => 'E');
2668:
2669: x_return_status := FND_API.G_RET_STS_ERROR ;
2670: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');
2671: FND_MSG_PUB.Add;
2672: RETURN;
2673: END IF;
2674:

Line 2679: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');

2675:
2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2679: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
2680: FND_MSG_PUB.Add;
2681: RAISE;
2682: END;
2683: -- Parag Kanetkar Bug 11839588

Line 2833: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');

2829:
2830: EXCEPTION
2831: WHEN OTHERS THEN
2832: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2833: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2834: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2835: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2836: FND_MSG_PUB.Add;
2837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2834: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

2830: EXCEPTION
2831: WHEN OTHERS THEN
2832: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2833: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2834: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2835: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2836: FND_MSG_PUB.Add;
2837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2838: END;

Line 2835: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

2831: WHEN OTHERS THEN
2832: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2833: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2834: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2835: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2836: FND_MSG_PUB.Add;
2837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2838: END;
2839: