DBA Data[Home] [Help]

APPS.GML_VALIDATEDERIVE_GRP dependencies on FND_API

Line 64: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

60: | Created Preetam Bamb
61: +==========================================================================+ */
62: PROCEDURE Secondary_Qty
63: ( p_api_version IN NUMBER
64: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: , p_validate_ind IN VARCHAR2
66: , p_item_no IN VARCHAR2
67: , p_unit_of_measure IN VARCHAR2
68: , p_quantity IN NUMBER

Line 107: IF FND_API.to_boolean(p_init_msg_list) THEN

103: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name,
104: 'Entering ' || l_api_name );
105: END IF;
106:
107: IF FND_API.to_boolean(p_init_msg_list) THEN
108: FND_MSG_PUB.Initialize;
109: END IF;
110:
111: -- Standard call to check for call compatibility.

Line 112: IF NOT FND_API.Compatible_API_Call ( l_api_version,

108: FND_MSG_PUB.Initialize;
109: END IF;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version,
113: p_api_version,
114: l_api_name ,
115: G_PKG_NAME
116: ) THEN

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113: p_api_version,
114: l_api_name ,
115: G_PKG_NAME
116: ) THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: x_return_status :=FND_API.G_RET_STS_SUCCESS;
121:

Line 120: x_return_status :=FND_API.G_RET_STS_SUCCESS;

116: ) THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: x_return_status :=FND_API.G_RET_STS_SUCCESS;
121:
122: -- If validation indicator is 'N' that means its coming from Change PO API.
123: -- If the secondary attributes are NULL then return successful
124: IF (p_secondary_quantity IS NULL AND p_secondary_unit_of_measure IS NULL and p_validate_ind = 'N')

Line 140: RAISE FND_API.G_EXC_ERROR;

136: CLOSE Cr_get_opm_attr;
137: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
138: FND_MESSAGE.SET_TOKEN('ITEM',p_item_no);
139: FND_MSG_PUB.ADD;
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142: CLOSE Cr_get_opm_attr;
143: l_progress := '002';
144: --if item is not dualum control then return doing nothing.

Line 160: RAISE FND_API.G_EXC_ERROR;

156: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
157: FND_MESSAGE.SET_TOKEN('UOM','NULL');
158: FND_MESSAGE.SET_TOKEN('ITEM',p_item_no);
159: FND_MSG_PUB.ADD;
160: RAISE FND_API.G_EXC_ERROR;
161: END;
162: ELSE
163: --If unit of measure is not passed the error out.
164: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

Line 168: RAISE FND_API.G_EXC_ERROR;

164: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
165: FND_MESSAGE.SET_TOKEN('UOM','NULL');
166: FND_MESSAGE.SET_TOKEN('ITEM',p_item_no);
167: FND_MSG_PUB.ADD;
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170: l_progress := '004';
171: --Validate secondary unit of measure passed in case validate ind is 'Y' (receiving preprocessor)
172: IF p_secondary_unit_of_measure is NOT NULL and p_validate_ind = 'Y' THEN

Line 184: RAISE FND_API.G_EXC_ERROR;

180: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
181: FND_MESSAGE.SET_TOKEN('UOM',p_secondary_unit_of_measure);
182: FND_MESSAGE.SET_TOKEN('ITEM',p_item_no);
183: FND_MSG_PUB.ADD;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186: ELSIF p_secondary_unit_of_measure is NULL and p_validate_ind = 'Y' THEN
187: --in case validate ind is 'Y' then derive the secondary unit of measure.
188: --return the secondary unit of measure

Line 222: RAISE FND_API.G_EXC_ERROR;

218:
219: IF v_ret_val in (-68) THEN
220: FND_MESSAGE.SET_NAME( 'GMI','IC_DEVIATION_HI_ERR');
221: FND_MSG_PUB.Add;
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF v_ret_val in (-69) THEN
224: FND_MESSAGE.SET_NAME( 'GMI','IC_DEVIATION_LOW_ERR');
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_ERROR;

Line 226: RAISE FND_API.G_EXC_ERROR;

222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF v_ret_val in (-69) THEN
224: FND_MESSAGE.SET_NAME( 'GMI','IC_DEVIATION_LOW_ERR');
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_ERROR;
227: ELSIF ( v_ret_val < 0 ) THEN
228: FND_MESSAGE.SET_NAME( 'GMI','CONV_ERROR');
229: FND_MSG_PUB.Add;
230: RAISE FND_API.G_EXC_ERROR;

Line 230: RAISE FND_API.G_EXC_ERROR;

226: RAISE FND_API.G_EXC_ERROR;
227: ELSIF ( v_ret_val < 0 ) THEN
228: FND_MESSAGE.SET_NAME( 'GMI','CONV_ERROR');
229: FND_MSG_PUB.Add;
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: END IF; /*l_opm_dualum_ind = 1 */
233: END IF;/*p_validate_ind = 'N' or p_secondary_quantity IS NULL */
234: END IF; /*l_opm_um_code is NOT NULL and l_opm_secondary_um IS NOT NULL */

Line 247: WHEN FND_API.G_EXC_ERROR THEN

243: 'Exiting ' || l_api_name );
244: END IF;
245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: END IF;
245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: WHEN FND_API.G_EXC_ERROR THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.Count_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
256: --yannamal bug4189249 Feb 17 2005 Added check to debug level before logging
257: IF (g_fnd_debug = 'Y' and FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED,