DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on FND_MSG_PUB

Line 98: -- FND_MSG_PUB.Add;

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

Line 106: FND_MSG_PUB.Add;

102: IF (p_tran_rec.line_type <> 1 ) THEN
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: --dbms_output.put_line ('Only Products allowed for incoming layers');
105: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PRODUCT_TRANS');
106: FND_MSG_PUB.Add;
107: RETURN;
108: END IF;
109:
110: -- If the doc_qty is not passed for the reversed layer, get it from the original layer

Line 132: FND_MSG_PUB.Add;

128: WHEN NO_DATA_FOUND THEN
129: x_return_status := FND_API.G_RET_STS_ERROR ;
130: --dbms_output.put_line ('Could not find the reversed layer');
131: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_REVERSED_LAYER');
132: FND_MSG_PUB.Add;
133: RETURN;
134: END;
135: END IF;
136:

Line 143: FND_MSG_PUB.Add;

139: gme_debug.put_line ('No doc quantity specified for the layer');
140: END IF;
141: x_return_status := FND_API.G_RET_STS_ERROR ;
142: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
143: FND_MSG_PUB.Add;
144: RETURN;
145: END IF;
146:
147:

Line 263: FND_MSG_PUB.Add;

259: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
260: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
261: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
262: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
263: FND_MSG_PUB.Add;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
265: END;
266:
267:

Line 367: -- FND_MSG_PUB.Add;

363: -- x_return_status := FND_API.G_RET_STS_ERROR ;
364: x_return_status := FND_API.G_RET_STS_SUCCESS ;
365: --dbms_output.put_line ('Only PROD document allowed for outgoing layers');
366: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');
367: -- FND_MSG_PUB.Add;
368: RETURN;
369: END IF;
370: IF (p_tran_rec.line_type <> -1 and p_tran_rec.line_type <> 2) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 374: FND_MSG_PUB.Add;

370: IF (p_tran_rec.line_type <> -1 and p_tran_rec.line_type <> 2) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR ;
372: gme_debug.put_line ('Error-GMF: Only Ingredients and By-Products allowed for outgoing layers');
373: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_ING_TRANS');
374: FND_MSG_PUB.Add;
375: RETURN;
376: END IF;
377:
378: -- If the doc_qty is not passed for the reversed layer, get it from the original layer

Line 400: FND_MSG_PUB.Add;

396: WHEN NO_DATA_FOUND THEN
397: x_return_status := FND_API.G_RET_STS_ERROR ;
398: --dbms_output.put_line ('Could not find the reversed layer');
399: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_REVERSED_LAYER');
400: FND_MSG_PUB.Add;
401: RETURN;
402: END;
403: END IF;
404:

Line 411: FND_MSG_PUB.Add;

407: IF g_debug <= gme_debug.g_log_procedure THEN
408: gme_debug.put_line ('No doc quantity specified for the layer');
409: END IF;
410: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
411: FND_MSG_PUB.Add;
412: RETURN;
413: END IF;
414:
415: SELECT gmf_layer_id_s.nextval INTO l_layer_id FROM DUAL;

Line 669: FND_MSG_PUB.Add;

665: WHEN OTHERS THEN
666: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
667: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
668: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
669: FND_MSG_PUB.Add;
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
671: END;
672:
673: /*

Line 766: -- FND_MSG_PUB.Add;

762: -- x_return_status := FND_API.G_RET_STS_ERROR ;
763: x_return_status := FND_API.G_RET_STS_SUCCESS ;
764: --dbms_output.put_line ('Only PROD document allowed for outgoing layers');
765: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_PROD_TRANS');
766: -- FND_MSG_PUB.Add;
767: RETURN;
768: END IF;
769:
770: SELECT gmf_layer_id_s.nextval INTO l_layer_id FROM DUAL;

Line 970: FND_MSG_PUB.Add;

966: WHEN OTHERS THEN
967: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
968: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
969: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
970: FND_MSG_PUB.Add;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
972: RAISE;
973: END;
974:

Line 1483: fnd_msg_pub.initialize;

1479:
1480: x_msg_count := 0;
1481: x_return_status := 0;
1482:
1483: fnd_msg_pub.initialize;
1484:
1485: FOR trans_rec in
1486: (
1487: SELECT

Line 1597: FOR i IN 1..fnd_msg_pub.count_msg

1593: p_procedure_name => 'None',
1594: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
1595: p_message => 'Error creating outgoing layer',
1596: p_error_type => 'E');
1597: FOR i IN 1..fnd_msg_pub.count_msg
1598: LOOP
1599: GMF_LAYERS.log_message (
1600: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1601: p_procedure_name => 'None',

Line 1603: p_message => fnd_msg_pub.get_detail (i, NULL),

1599: GMF_LAYERS.log_message (
1600: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1601: p_procedure_name => 'None',
1602: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
1603: p_message => fnd_msg_pub.get_detail (i, NULL),
1604: p_error_type => 'E');
1605: END LOOP;
1606: ELSE
1607: l_ol_count := l_ol_count + 1;

Line 1742: fnd_msg_pub.initialize;

1738:
1739: x_msg_count := 0;
1740: x_return_status := 0;
1741:
1742: fnd_msg_pub.initialize;
1743:
1744: SELECT * INTO rt
1745: FROM gme_resource_txns
1746: WHERE

Line 1774: FOR i IN 1..fnd_msg_pub.count_msg LOOP

1770: p_procedure_name => 'None',
1771: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1772: p_message => 'Error creating resource layer',
1773: p_error_type => 'E');
1774: FOR i IN 1..fnd_msg_pub.count_msg LOOP
1775: GMF_LAYERS.log_message (
1776: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1777: p_procedure_name => 'None',
1778: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),

Line 1779: p_message => fnd_msg_pub.get_detail (i, NULL),

1775: GMF_LAYERS.log_message (
1776: p_table_name => 'GMF_BATCH_VIB_DETAILS',
1777: p_procedure_name => 'None',
1778: p_parameters => 'POC Trans ID = '||to_char(rt.poc_trans_id),
1779: p_message => fnd_msg_pub.get_detail (i, NULL),
1780: p_error_type => 'E');
1781: END LOOP;
1782: ELSE
1783: l_rl_count := l_rl_count + 1;

Line 1932: fnd_msg_pub.initialize;

1928:
1929: x_msg_count := 0;
1930: x_return_status := 0;
1931:
1932: fnd_msg_pub.initialize;
1933:
1934: FOR trans_rec in
1935: (
1936: SELECT

Line 2069: FOR i IN 1..fnd_msg_pub.count_msg LOOP

2065: p_procedure_name => 'None',
2066: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2067: p_message => 'Error creating incoming layer',
2068: p_error_type => 'E');
2069: FOR i IN 1..fnd_msg_pub.count_msg LOOP
2070: GMF_LAYERS.log_message (
2071: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2072: p_procedure_name => 'None',
2073: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),

Line 2074: p_message => fnd_msg_pub.get_detail (i, NULL),

2070: GMF_LAYERS.log_message (
2071: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2072: p_procedure_name => 'None',
2073: p_parameters => 'Trans ID = '||to_char(trans_rec.transaction_id),
2074: p_message => fnd_msg_pub.get_detail (i, NULL),
2075: p_error_type => 'E');
2076: END LOOP;
2077: ELSE
2078: l_il_count := l_il_count + 1;

Line 2167: FOR i IN 1..fnd_msg_pub.count_msg LOOP

2163: p_parameters => 'Batch ID = '||to_char(cls.batch_id),
2164: p_message => 'Error creating finalization layers',
2165: p_error_type => 'E');
2166:
2167: FOR i IN 1..fnd_msg_pub.count_msg LOOP
2168: GMF_LAYERS.log_message (
2169: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2170: p_procedure_name => 'None',
2171: p_parameters => 'Batch ID = '||to_char(cls.batch_id),

Line 2172: p_message => fnd_msg_pub.get_detail (i, NULL),

2168: GMF_LAYERS.log_message (
2169: p_table_name => 'GMF_BATCH_VIB_DETAILS',
2170: p_procedure_name => 'None',
2171: p_parameters => 'Batch ID = '||to_char(cls.batch_id),
2172: p_message => fnd_msg_pub.get_detail (i, NULL),
2173: p_error_type => 'E');
2174: END LOOP;
2175: END IF;
2176: EXCEPTION