DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on FND_MESSAGE

Line 92: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');

88: -- Bug 5586577. Return with Success.
89: -- x_return_status := FND_API.G_RET_STS_ERROR ;
90: x_return_status := FND_API.G_RET_STS_SUCCESS ;
91: --dbms_output.put_line ('Only PROD document allowed for incoming layers');
92: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');
93: -- FND_MSG_PUB.Add;
94: RETURN;
95: END IF;
96:

Line 100: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PRODUCT_TRANS');

96:
97: IF (p_tran_rec.line_type <> 1 ) THEN
98: x_return_status := FND_API.G_RET_STS_ERROR ;
99: --dbms_output.put_line ('Only Products allowed for incoming layers');
100: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PRODUCT_TRANS');
101: FND_MSG_PUB.Add;
102: RETURN;
103: END IF;
104:

Line 125: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_REVERSED_LAYER');

121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: --dbms_output.put_line ('Could not find the reversed layer');
125: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_REVERSED_LAYER');
126: FND_MSG_PUB.Add;
127: RETURN;
128: END;
129: END IF;

Line 136: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');

132: IF g_debug <= gme_debug.g_log_procedure THEN
133: gme_debug.put_line ('No doc quantity specified for the layer');
134: END IF;
135: x_return_status := FND_API.G_RET_STS_ERROR ;
136: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
137: FND_MSG_PUB.Add;
138: RETURN;
139: END IF;
140:

Line 247: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
247: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
248: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
249: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
250: FND_MSG_PUB.Add;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

244: EXCEPTION
245: WHEN OTHERS THEN
246: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
247: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
248: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
249: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
250: FND_MSG_PUB.Add;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: END;

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

245: WHEN OTHERS THEN
246: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
247: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
248: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
249: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
250: FND_MSG_PUB.Add;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: END;
253:

Line 349: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');

345: -- Bug 5586577. Return with Success.
346: -- x_return_status := FND_API.G_RET_STS_ERROR ;
347: x_return_status := FND_API.G_RET_STS_SUCCESS ;
348: --dbms_output.put_line ('Only PROD document allowed for outgoing layers');
349: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');
350: -- FND_MSG_PUB.Add;
351: RETURN;
352: END IF;
353: IF (p_tran_rec.line_type <> -1 and p_tran_rec.line_type <> 2) THEN

Line 356: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_ING_TRANS');

352: END IF;
353: IF (p_tran_rec.line_type <> -1 and p_tran_rec.line_type <> 2) THEN
354: x_return_status := FND_API.G_RET_STS_ERROR ;
355: gme_debug.put_line ('Error-GMF: Only Ingredients and By-Products allowed for outgoing layers');
356: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_ING_TRANS');
357: FND_MSG_PUB.Add;
358: RETURN;
359: END IF;
360:

Line 381: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_REVERSED_LAYER');

377: EXCEPTION
378: WHEN NO_DATA_FOUND THEN
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: --dbms_output.put_line ('Could not find the reversed layer');
381: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_REVERSED_LAYER');
382: FND_MSG_PUB.Add;
383: RETURN;
384: END;
385: END IF;

Line 392: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');

388: x_return_status := FND_API.G_RET_STS_ERROR ;
389: IF g_debug <= gme_debug.g_log_procedure THEN
390: gme_debug.put_line ('No doc quantity specified for the layer');
391: END IF;
392: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
393: FND_MSG_PUB.Add;
394: RETURN;
395: END IF;
396:

Line 645: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

641: END IF;
642:
643: EXCEPTION
644: WHEN OTHERS THEN
645: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
646: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
647: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

642:
643: EXCEPTION
644: WHEN OTHERS THEN
645: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
646: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
647: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
650: END;

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

643: EXCEPTION
644: WHEN OTHERS THEN
645: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
646: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
647: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
650: END;
651:

Line 740: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');

736: -- Bug 5586577. Return with Success.
737: -- x_return_status := FND_API.G_RET_STS_ERROR ;
738: x_return_status := FND_API.G_RET_STS_SUCCESS ;
739: --dbms_output.put_line ('Only PROD document allowed for outgoing layers');
740: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');
741: -- FND_MSG_PUB.Add;
742: RETURN;
743: END IF;
744:

Line 937: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

933: END IF;
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
938: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
939: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
940: FND_MSG_PUB.Add;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
938: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
939: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
940: FND_MSG_PUB.Add;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: RAISE;

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

935: EXCEPTION
936: WHEN OTHERS THEN
937: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
938: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
939: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
940: FND_MSG_PUB.Add;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: RAISE;
943: END;