DBA Data[Home] [Help]

APPS.GMF_VIB dependencies on FND_MSG_PUB

Line 94: FND_MSG_PUB.Add;

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

Line 181: FND_MSG_PUB.Add;

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

Line 310: FND_MSG_PUB.Add;

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

Line 364: FND_MSG_PUB.Add;

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
368: WHEN OTHERS THEN

Line 371: FND_MSG_PUB.Add;

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:
375: IF g_debug <= gme_debug.g_log_statement THEN

Line 401: FND_MSG_PUB.Add;

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

Line 502: -- FND_MSG_PUB.Add;

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

Line 520: FND_MSG_PUB.Add;

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 */
524: EXCEPTION

Line 529: FND_MSG_PUB.Add;

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:
533: l_use_item_step_dep := fnd_profile.value ('GMF_USE_ITEM_STEP_DEPENDENCIES');

Line 943: FND_MSG_PUB.Add;

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

Line 1144: FND_MSG_PUB.Add;

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:
1148: l_use_vib := FND_PROFILE.VALUE ('GMF_USE_VIB_FOR_ACOST');

Line 1760: FND_MSG_PUB.Add;

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

Line 1929: FND_MSG_PUB.Add;

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
1933: WHEN OTHERS THEN

Line 1936: FND_MSG_PUB.Add;

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:
1940: -- Check if he VIB details already exist for this batch

Line 1955: FND_MSG_PUB.Add;

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
1959: WHEN OTHERS THEN

Line 1962: FND_MSG_PUB.Add;

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

Line 2504: FND_MSG_PUB.Add;

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

Line 2568: FND_MSG_PUB.Add;

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
2572: WHEN OTHERS THEN

Line 2575: FND_MSG_PUB.Add;

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:
2579: -- Delete all rows from gmf_incoming_material_layers which are used in

Line 2661: FND_MSG_PUB.Add;

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