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 501: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_WIP');

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

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

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

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

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

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

936:
937: EXCEPTION
938: WHEN OTHERS THEN
939: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
940: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
941: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
942: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
943: FND_MSG_PUB.Add;
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

937: EXCEPTION
938: WHEN OTHERS THEN
939: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
940: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
941: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
942: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
943: FND_MSG_PUB.Add;
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945: End Create_Temp_Batch_Requirements;

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

938: WHEN OTHERS THEN
939: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
940: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
941: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
942: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
943: FND_MSG_PUB.Add;
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
945: End Create_Temp_Batch_Requirements;
946:

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

1139: IF l_count > 0 THEN
1140: x_return_status := FND_API.G_RET_STS_ERROR ;
1141: x_msg_data := 'VIB Details already exist';
1142: dbms_output.put_line ('VIB Details already exist');
1143: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_VIB_EXIST');
1144: FND_MSG_PUB.Add;
1145: RETURN;
1146: END IF;
1147:

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

1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
1757: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
1758: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1759: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
1760: FND_MSG_PUB.Add;
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
1757: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
1758: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1759: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
1760: FND_MSG_PUB.Add;
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1762: END;

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

1755: WHEN OTHERS THEN
1756: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
1757: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
1758: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1759: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
1760: FND_MSG_PUB.Add;
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1762: END;
1763:

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

1924:
1925: IF l_batch_status <> 4 THEN
1926: x_return_status := FND_API.G_RET_STS_ERROR ;
1927: --dbms_output.put_line ('Batch is not in CLOSE Status');
1928: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_CLOSE');
1929: FND_MSG_PUB.Add;
1930: RETURN;
1931: END IF;
1932: EXCEPTION

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

1931: END IF;
1932: EXCEPTION
1933: WHEN OTHERS THEN
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1935: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
1936: FND_MSG_PUB.Add;
1937: RAISE;
1938: END;
1939:

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

1950:
1951: IF l_count > 0 THEN
1952: x_return_status := FND_API.G_RET_STS_ERROR ;
1953: --dbms_output.put_line ('VIB details already exist for this batch');
1954: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_FINAL_VIB_EXIST');
1955: FND_MSG_PUB.Add;
1956: RETURN;
1957: END IF;
1958: EXCEPTION

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

1957: END IF;
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1961: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
1962: FND_MSG_PUB.Add;
1963: RAISE;
1964: END;
1965:

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

2497:
2498: EXCEPTION
2499: WHEN OTHERS THEN
2500: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2501: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2502: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2503: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2504: FND_MSG_PUB.Add;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2498: EXCEPTION
2499: WHEN OTHERS THEN
2500: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2501: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2502: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2503: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2504: FND_MSG_PUB.Add;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2506: END;

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

2499: WHEN OTHERS THEN
2500: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2501: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2502: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2503: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2504: FND_MSG_PUB.Add;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2506: END;
2507:

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

2563:
2564: IF l_batch_status = 4 THEN
2565: x_return_status := FND_API.G_RET_STS_ERROR ;
2566: --dbms_output.put_line ('Cannot revert finalization of a closed batch ');
2567: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');
2568: FND_MSG_PUB.Add;
2569: RETURN;
2570: END IF;
2571: EXCEPTION

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

2570: END IF;
2571: EXCEPTION
2572: WHEN OTHERS THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2574: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
2575: FND_MSG_PUB.Add;
2576: RAISE;
2577: END;
2578:

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

2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2658: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2659: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2660: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2661: FND_MSG_PUB.Add;
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2658: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2659: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2660: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2661: FND_MSG_PUB.Add;
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2663: END;

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

2656: WHEN OTHERS THEN
2657: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
2658: FND_MESSAGE.SET_NAME('GMI','GMF_SQL_ERROR');
2659: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
2660: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
2661: FND_MSG_PUB.Add;
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2663: END;
2664: