APPS.GMF_ACTUAL_COST_ADJUSTMENT_PUB dependencies on FND_API

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138:
139: /******************************************
140: * Initialize API return status to success *
141: ******************************************/
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: l_adjust_status := NULL;
144: G_header_logged := 'N';
145:
146: IF P_OPERATION IN ('INSERT', 'UPDATE', 'DELETE', 'GET') THEN

Line 179: RAISE FND_API.G_EXC_ERROR;

175: /* bug 9005515, applied adjustments can be allowwed to updated/deleted
176: IF l_adjust_status = 1 AND P_OPERATION IN ('UPDATE', 'DELETE') THEN
177: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');
178: FND_MSG_PUB.Add;
179: RAISE FND_API.G_EXC_ERROR;
180: END IF; bug 9005515 */
181: IF (p_adjustment_rec.organization_id IS NOT NULL OR p_adjustment_rec.organization_code IS NOT NULL) AND
182: (p_adjustment_rec.cost_type_id IS NOT NULL OR p_adjustment_rec.cost_mthd_code IS NOT NULL) AND
183: (p_adjustment_rec.inventory_item_id IS NOT NULL OR p_adjustment_rec.item_number IS NOT NULL) AND

Line 191: IF (p_adjustment_rec.period_id = FND_API.G_MISS_NUM) OR (p_adjustment_rec.period_id IS NULL) THEN

187: FND_MSG_PUB.Add;
188: END IF;
189: END IF;
190: ELSE
191: IF (p_adjustment_rec.period_id = FND_API.G_MISS_NUM) OR (p_adjustment_rec.period_id IS NULL) THEN
192: /***********************
193: * Cost Type Validation *
194: ***********************/
195: IF (p_adjustment_rec.cost_type_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_type_id IS NOT NULL) THEN

Line 195: IF (p_adjustment_rec.cost_type_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_type_id IS NOT NULL) THEN

191: IF (p_adjustment_rec.period_id = FND_API.G_MISS_NUM) OR (p_adjustment_rec.period_id IS NULL) THEN
192: /***********************
193: * Cost Type Validation *
194: ***********************/
195: IF (p_adjustment_rec.cost_type_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_type_id IS NOT NULL) THEN
196: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
197: log_msg('Validating Cost Type Id : ' || p_adjustment_rec.cost_type_id);
198: END IF;
199: IF NOT gmf_validations_pvt.validate_cost_type_id (p_adjustment_rec.cost_type_id, 'A') THEN

Line 203: RAISE FND_API.G_EXC_ERROR;

199: IF NOT gmf_validations_pvt.validate_cost_type_id (p_adjustment_rec.cost_type_id, 'A') THEN
200: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
201: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
202: FND_MSG_PUB.Add;
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205: IF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL) THEN
206: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
207: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');

Line 205: IF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL) THEN

201: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', p_adjustment_rec.cost_type_id);
202: FND_MSG_PUB.Add;
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205: IF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL) THEN
206: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
207: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
208: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_adjustment_rec.cost_mthd_code);
209: FND_MSG_PUB.Add;

Line 212: ELSIF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL) THEN

208: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_adjustment_rec.cost_mthd_code);
209: FND_MSG_PUB.Add;
210: END IF;
211: END IF;
212: ELSIF (p_adjustment_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_mthd_code IS NOT NULL) THEN
213: /************************
214: * Convert Code into ID. *
215: ************************/
216: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 228: RAISE FND_API.G_EXC_ERROR;

224: IF p_adjustment_rec.cost_type_id IS NULL THEN
225: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
226: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_adjustment_rec.cost_mthd_code);
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: ELSE
231: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
232: FND_MSG_PUB.Add;

Line 233: RAISE FND_API.G_EXC_ERROR;

229: END IF;
230: ELSE
231: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
232: FND_MSG_PUB.Add;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: ELSE
236: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
237: log_msg('Skipping Cost Type validation since Period Id is passed');

Line 243: IF ((p_adjustment_rec.organization_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.organization_id IS NOT NULL)) THEN

239: END IF;
240: /**************************
241: * Organization Validation *
242: **************************/
243: IF ((p_adjustment_rec.organization_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.organization_id IS NOT NULL)) THEN
244: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
245: log_msg('Validating Organization Id : ' || p_adjustment_rec.organization_id);
246: END IF;
247: IF NOT gmf_validations_pvt.validate_organization_id(p_adjustment_rec.organization_id) THEN

Line 251: RAISE FND_API.G_EXC_ERROR;

247: IF NOT gmf_validations_pvt.validate_organization_id(p_adjustment_rec.organization_id) THEN
248: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
249: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: IF (p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL) THEN
254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
255: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');

Line 253: IF (p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL) THEN

249: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: IF (p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL) THEN
254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
255: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
256: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
257: FND_MSG_PUB.Add;

Line 260: ELSIF ((p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL)) THEN

256: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', p_adjustment_rec.organization_code);
257: FND_MSG_PUB.Add;
258: END IF;
259: END IF;
260: ELSIF ((p_adjustment_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.organization_code IS NOT NULL)) THEN
261: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
262: log_msg('Validating Organization Code : ' || p_adjustment_rec.organization_code);
263: END IF;
264: p_adjustment_rec.organization_id := gmf_validations_pvt.validate_organization_code(p_adjustment_rec.organization_code);

Line 272: RAISE FND_API.G_EXC_ERROR;

268: IF p_adjustment_rec.organization_id IS NULL THEN
269: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
270: FND_MESSAGE.SET_TOKEN('ORG_CODE', p_adjustment_rec.organization_code);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: ELSE
275: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
276: FND_MSG_PUB.Add;

Line 277: RAISE FND_API.G_EXC_ERROR;

273: END IF;
274: ELSE
275: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
276: FND_MSG_PUB.Add;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: /******************
280: * Item Validation *
281: ******************/

Line 282: IF (p_adjustment_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.inventory_item_id IS NOT NULL)

278: END IF;
279: /******************
280: * Item Validation *
281: ******************/
282: IF (p_adjustment_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.inventory_item_id IS NOT NULL)
283: THEN
284: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
285: log_msg('Validating Inventory Item Id : ' || p_adjustment_rec.inventory_item_id);
286: END IF;

Line 292: RAISE FND_API.G_EXC_ERROR;

288: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
289: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_adjustment_rec.inventory_item_id);
290: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
291: FND_MSG_PUB.Add;
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: IF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL) THEN
295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
296: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');

Line 294: IF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL) THEN

290: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
291: FND_MSG_PUB.Add;
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: IF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL) THEN
295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
296: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
297: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);
298: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);

Line 302: ELSIF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL) THEN

298: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
299: FND_MSG_PUB.Add;
300: END IF;
301: END IF;
302: ELSIF (p_adjustment_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.item_number IS NOT NULL) THEN
303: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
304: log_msg('Validating Item Number : ' || p_adjustment_rec.item_number);
305: END IF;
306: p_adjustment_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_adjustment_rec.item_number, p_adjustment_rec.organization_id);

Line 315: RAISE FND_API.G_EXC_ERROR;

311: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
312: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_adjustment_rec.item_number);
313: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_adjustment_rec.organization_id);
314: FND_MSG_PUB.Add;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317: ELSE
318: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
319: FND_MSG_PUB.Add;

Line 320: RAISE FND_API.G_EXC_ERROR;

316: END IF;
317: ELSE
318: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322: /********************
323: * Period Validation *
324: ********************/

Line 325: IF (p_adjustment_rec.period_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.period_id IS NOT NULL)

321: END IF;
322: /********************
323: * Period Validation *
324: ********************/
325: IF (p_adjustment_rec.period_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.period_id IS NOT NULL)
326: THEN
327: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
328: log_msg('Validating Period Id : ' || p_adjustment_rec.Period_id);
329: END IF;

Line 334: RAISE FND_API.G_EXC_ERROR;

330: IF NOT gmf_validations_pvt.validate_period_id(p_adjustment_rec.period_id, p_adjustment_rec.cost_type_id) THEN
331: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
332: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
333: FND_MSG_PUB.Add;
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
337: log_msg('Cost Type Id fetched based on Period Id is: '||p_adjustment_rec.cost_type_id);
338: END IF;

Line 339: IF ((p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL)) AND

335: END IF;
336: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
337: log_msg('Cost Type Id fetched based on Period Id is: '||p_adjustment_rec.cost_type_id);
338: END IF;
339: IF ((p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL)) AND
340: ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL)) THEN
341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
342: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
343: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);

Line 340: ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL)) THEN

336: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
337: log_msg('Cost Type Id fetched based on Period Id is: '||p_adjustment_rec.cost_type_id);
338: END IF;
339: IF ((p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL)) AND
340: ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL)) THEN
341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
342: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
343: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_adjustment_rec.calendar_code);
344: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);

Line 348: ELSIF (p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL) AND

344: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_adjustment_rec.period_code);
345: FND_MSG_PUB.Add;
346: END IF;
347: END IF;
348: ELSIF (p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL) AND
349: ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL)) THEN
350: /************************
351: * Convert Code into ID. *
352: ************************/

Line 349: ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL)) THEN

345: FND_MSG_PUB.Add;
346: END IF;
347: END IF;
348: ELSIF (p_adjustment_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.calendar_code IS NOT NULL) AND
349: ((p_adjustment_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.period_code IS NOT NULL)) THEN
350: /************************
351: * Convert Code into ID. *
352: ************************/
353: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 365: RAISE FND_API.G_EXC_ERROR;

361: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
362: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_adjustment_rec.calendar_code);
363: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_adjustment_rec.period_code);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367: ELSE
368: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_REQ');
369: FND_MSG_PUB.Add;

Line 370: RAISE FND_API.G_EXC_ERROR;

366: END IF;
367: ELSE
368: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_REQ');
369: FND_MSG_PUB.Add;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372: END IF;
373: /**********************************
374: * Cost Component Class Validation *

Line 376: IF (p_adjustment_rec.cost_cmpntcls_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_cmpntcls_id IS NOT NULL)

372: END IF;
373: /**********************************
374: * Cost Component Class Validation *
375: **********************************/
376: IF (p_adjustment_rec.cost_cmpntcls_id <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.cost_cmpntcls_id IS NOT NULL)
377: THEN
378: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
379: log_msg('Validating Cost Component Class ID :'|| p_adjustment_rec.cost_cmpntcls_id);
380: END IF;

Line 385: RAISE FND_API.G_EXC_ERROR;

381: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_adjustment_rec.cost_cmpntcls_id) THEN
382: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
383: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_adjustment_rec.cost_cmpntcls_id);
384: FND_MSG_PUB.Add;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387: IF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL) THEN
388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
389: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');

Line 387: IF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL) THEN

383: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_adjustment_rec.cost_cmpntcls_id);
384: FND_MSG_PUB.Add;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387: IF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL) THEN
388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
389: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
390: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
391: FND_MSG_PUB.Add;

Line 394: ELSIF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)

390: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
391: FND_MSG_PUB.Add;
392: END IF;
393: END IF;
394: ELSIF (p_adjustment_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_cmpntcls_code IS NOT NULL)
395: THEN
396: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
397: log_msg('Validating Cost Component Class Code : ' || p_adjustment_rec.cost_cmpntcls_code);
398: END IF;

Line 407: RAISE FND_API.G_EXC_ERROR;

403: IF p_adjustment_rec.cost_cmpntcls_id IS NULL THEN
404: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
405: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE', p_adjustment_rec.cost_cmpntcls_code);
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409: ELSE
410: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
411: FND_MSG_PUB.Add;

Line 412: RAISE FND_API.G_EXC_ERROR;

408: END IF;
409: ELSE
410: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
411: FND_MSG_PUB.Add;
412: RAISE FND_API.G_EXC_ERROR;
413: END IF;
414: /***************************
415: * Analysis Code Validation *
416: ***************************/

Line 417: IF (p_adjustment_rec.cost_analysis_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_analysis_code IS NOT NULL)

413: END IF;
414: /***************************
415: * Analysis Code Validation *
416: ***************************/
417: IF (p_adjustment_rec.cost_analysis_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.cost_analysis_code IS NOT NULL)
418: THEN
419: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
420: log_msg('Validating Cost Analysis code :' || p_adjustment_rec.cost_analysis_code);
421: END IF;

Line 426: RAISE FND_API.G_EXC_ERROR;

422: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_adjustment_rec.cost_analysis_code) THEN
423: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
424: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE', p_adjustment_rec.cost_analysis_code);
425: FND_MSG_PUB.Add;
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428: ELSE
429: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
430: FND_MSG_PUB.Add;

Line 431: RAISE FND_API.G_EXC_ERROR;

427: END IF;
428: ELSE
429: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
430: FND_MSG_PUB.Add;
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: /***********************************
434: * Adjustment Indicator Validation *
435: ***********************************/

Line 436: IF (p_adjustment_rec.adjustment_ind <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.adjustment_ind IS NOT NULL)

432: END IF;
433: /***********************************
434: * Adjustment Indicator Validation *
435: ***********************************/
436: IF (p_adjustment_rec.adjustment_ind <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.adjustment_ind IS NOT NULL)
437: THEN
438: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
439: log_msg('Validating Adjustment Indicator : ' || p_adjustment_rec.adjustment_ind );
440: END IF;

Line 445: RAISE FND_API.G_EXC_ERROR;

441: IF p_adjustment_rec.adjustment_ind NOT IN (0, 1, 2) THEN
442: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ADJ_IND');
443: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_IND',p_adjustment_rec.adjustment_ind);
444: FND_MSG_PUB.Add;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447: ELSE
448: FND_MESSAGE.SET_NAME('GMF','GMF_API_ADJ_IND_REQ');
449: FND_MSG_PUB.Add;

Line 450: RAISE FND_API.G_EXC_ERROR;

446: END IF;
447: ELSE
448: FND_MESSAGE.SET_NAME('GMF','GMF_API_ADJ_IND_REQ');
449: FND_MSG_PUB.Add;
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;
452: IF P_OPERATION IN ('INSERT', 'UPDATE') THEN
453: /************************
454: * Adjust UOM Validation *

Line 456: IF (p_adjustment_rec.adjust_qty_uom <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.adjust_qty_uom IS NOT NULL)

452: IF P_OPERATION IN ('INSERT', 'UPDATE') THEN
453: /************************
454: * Adjust UOM Validation *
455: ************************/
456: IF (p_adjustment_rec.adjust_qty_uom <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.adjust_qty_uom IS NOT NULL)
457: THEN
458: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
459: log_msg('Validating Adjust Qty UOM :' || p_adjustment_rec.adjust_qty_uom);
460: END IF;

Line 467: RAISE FND_API.G_EXC_ERROR;

463: THEN
464: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');
465: FND_MESSAGE.SET_TOKEN('ITEM_UOM', p_adjustment_rec.adjust_qty_uom);
466: FND_MSG_PUB.Add;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: ELSE
470: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');
471: FND_MSG_PUB.Add;

Line 472: RAISE FND_API.G_EXC_ERROR;

468: END IF;
469: ELSE
470: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474: /*****************************
475: * Adjustment Cost validation *
476: *****************************/

Line 484: RAISE FND_API.G_EXC_ERROR;

480: END IF;
481: IF p_adjustment_rec.adjust_cost IS NULL THEN
482: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_ADJ_COST');
483: FND_MSG_PUB.Add;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486: END IF;
487: /*************************
488: * Reason Code Validation *

Line 490: IF ((p_adjustment_rec.reason_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.reason_code IS NOT NULL)) THEN

486: END IF;
487: /*************************
488: * Reason Code Validation *
489: *************************/
490: IF ((p_adjustment_rec.reason_code <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.reason_code IS NOT NULL)) THEN
491: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
492: log_msg('Validating Reason Code: ' || p_adjustment_rec.reason_code );
493: END IF;
494: BEGIN

Line 507: RAISE FND_API.G_EXC_ERROR;

503: WHEN NO_DATA_FOUND THEN
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_REASON_CODE');
505: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_adjustment_rec.reason_code);
506: FND_MSG_PUB.Add;
507: RAISE FND_API.G_EXC_ERROR;
508: END;
509: ELSE
510: FND_MESSAGE.SET_NAME('GMF','GMF_API_REASON_CODE_REQ');
511: FND_MSG_PUB.Add;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: END;
509: ELSE
510: FND_MESSAGE.SET_NAME('GMF','GMF_API_REASON_CODE_REQ');
511: FND_MSG_PUB.Add;
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514: /*************************
515: * Delete mark Validation *
516: *************************/

Line 517: IF (p_adjustment_rec.delete_mark <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.delete_mark IS NOT NULL) THEN

513: END IF;
514: /*************************
515: * Delete mark Validation *
516: *************************/
517: IF (p_adjustment_rec.delete_mark <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.delete_mark IS NOT NULL) THEN
518: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
519: log_msg('Validating Delete_mark : ' || p_adjustment_rec.delete_mark);
520: END IF;
521: IF p_adjustment_rec.delete_mark NOT IN (0,1) THEN

Line 526: RAISE FND_API.G_EXC_ERROR;

522: add_record_to_error_stack(p_adjustment_rec);
523: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
524: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_adjustment_rec.delete_mark);
525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: ELSIF (p_adjustment_rec.delete_mark = FND_API.G_MISS_NUM AND p_operation IN ('UPDATE', 'INSERT')) THEN
529: add_record_to_error_stack(p_adjustment_rec);
530: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');

Line 528: ELSIF (p_adjustment_rec.delete_mark = FND_API.G_MISS_NUM AND p_operation IN ('UPDATE', 'INSERT')) THEN

524: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_adjustment_rec.delete_mark);
525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: ELSIF (p_adjustment_rec.delete_mark = FND_API.G_MISS_NUM AND p_operation IN ('UPDATE', 'INSERT')) THEN
529: add_record_to_error_stack(p_adjustment_rec);
530: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
531: FND_MSG_PUB.Add;
532: RAISE FND_API.G_EXC_ERROR;

Line 532: RAISE FND_API.G_EXC_ERROR;

528: ELSIF (p_adjustment_rec.delete_mark = FND_API.G_MISS_NUM AND p_operation IN ('UPDATE', 'INSERT')) THEN
529: add_record_to_error_stack(p_adjustment_rec);
530: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
531: FND_MSG_PUB.Add;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535: IF ((p_operation IN ('UPDATE','INSERT')) AND (p_adjustment_rec.delete_mark = 1)) THEN
536: add_record_to_error_stack(p_adjustment_rec);

Line 539: RAISE FND_API.G_EXC_ERROR;

535: IF ((p_operation IN ('UPDATE','INSERT')) AND (p_adjustment_rec.delete_mark = 1)) THEN
536: add_record_to_error_stack(p_adjustment_rec);
537: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
538: FND_MSG_PUB.Add;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: /***********************************
542: * Subledger Indicator Validation *
543: ***********************************/

Line 544: IF (p_adjustment_rec.subledger_ind <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.subledger_ind IS NOT NULL) THEN

540: END IF;
541: /***********************************
542: * Subledger Indicator Validation *
543: ***********************************/
544: IF (p_adjustment_rec.subledger_ind <> FND_API.G_MISS_NUM) AND (p_adjustment_rec.subledger_ind IS NOT NULL) THEN
545: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
546: log_msg('Validating Subledger Ind : ' || p_adjustment_rec.subledger_ind );
547: END IF;
548: IF p_adjustment_rec.subledger_ind NOT IN (0,1) THEN

Line 552: RAISE FND_API.G_EXC_ERROR;

548: IF p_adjustment_rec.subledger_ind NOT IN (0,1) THEN
549: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_SUBLEDGER_IND');
550: FND_MESSAGE.SET_TOKEN('SUBLEDGER_IND',p_adjustment_rec.subledger_ind);
551: FND_MSG_PUB.Add;
552: RAISE FND_API.G_EXC_ERROR;
553: ELSE
554: /*****************************
555: * Adjustment Date Validation *
556: *****************************/

Line 594: RAISE FND_API.G_EXC_ERROR;

590: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE',p_adjustment_rec.adjustment_date);
591: FND_MESSAGE.SET_TOKEN('START_DATE', l_start_date);
592: FND_MESSAGE.SET_TOKEN('END_DATE', l_end_date);
593: FND_MSG_PUB.Add;
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;
596: END IF;
597: END IF;
598: END IF;

Line 602: RAISE FND_API.G_EXC_ERROR;

598: END IF;
599: ELSE
600: FND_MESSAGE.SET_NAME('GMF','GMF_API_SUBLEDGER_IND_REQ');
601: FND_MSG_PUB.Add;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604: END IF;
605: /**********************
606: * Username Validation *

Line 608: IF (p_adjustment_rec.user_name <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.user_name IS NOT NULL) THEN

604: END IF;
605: /**********************
606: * Username Validation *
607: **********************/
608: IF (p_adjustment_rec.user_name <> FND_API.G_MISS_CHAR) AND (p_adjustment_rec.user_name IS NOT NULL) THEN
609: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
610: log_msg('Validating user name : ' || p_adjustment_rec.user_name);
611: END IF;
612: GMA_GLOBAL_GRP.Get_who (

Line 620: RAISE FND_API.G_EXC_ERROR;

616: IF x_user_id = -1 THEN
617: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
618: FND_MESSAGE.SET_TOKEN('USER_NAME',p_adjustment_rec.user_name);
619: FND_MSG_PUB.Add;
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622: ELSE
623: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
624: FND_MSG_PUB.Add;

Line 625: RAISE FND_API.G_EXC_ERROR;

621: END IF;
622: ELSE
623: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
624: FND_MSG_PUB.Add;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627: /***************************
628: * Adjustment ID validation *
629: ***************************/

Line 682: RAISE FND_API.G_EXC_ERROR;

678: ' for '|| p_operation || ' Does''nt Exist');
679: END IF;
680: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_ADJUST_ID_NULL');
681: FND_MSG_PUB.Add;
682: RAISE FND_API.G_EXC_ERROR;
683: END IF;
684: /* Bug 9005515, Allow to update the applied adjustments
685: IF l_adjust_status = 1 THEN
686: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');

Line 688: RAISE FND_API.G_EXC_ERROR;

684: /* Bug 9005515, Allow to update the applied adjustments
685: IF l_adjust_status = 1 THEN
686: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_APPLIED');
687: FND_MSG_PUB.Add;
688: RAISE FND_API.G_EXC_ERROR;
689: END IF; Bu 9005515 */
690: END IF;
691: /*********************************
692: * Gl posted indicator validation *

Line 703: RAISE FND_API.G_EXC_ERROR;

699:
700: IF l_gl_posted_ind = 1 THEN
701: log_msg('Can not update/delete adjustment record, which is already posted to GL for adjustment id '
702: || p_adjustment_rec.cost_adjust_id);
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705: END IF; /* end if for adjustment id val p_operation */
706: END IF;
707: END VALIDATE_INPUT_PARAMS;

Line 740: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

736: ********************************************************************/
737: PROCEDURE CREATE_ACTUAL_COST_ADJUSTMENT
738: (
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
741: p_commit IN VARCHAR2 := FND_API.G_FALSE,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,

Line 741: p_commit IN VARCHAR2 := FND_API.G_FALSE,

737: PROCEDURE CREATE_ACTUAL_COST_ADJUSTMENT
738: (
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
741: p_commit IN VARCHAR2 := FND_API.G_FALSE,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 770: IF FND_API.to_Boolean( p_init_msg_list ) THEN

766:
767: /*************************************************************
768: * Initialize message list if p_init_msg_list is set to TRUE. *
769: *************************************************************/
770: IF FND_API.to_Boolean( p_init_msg_list ) THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773:
774: /*************************************************

Line 777: IF NOT FND_API.Compatible_API_Call

773:
774: /*************************************************
775: * Standard call to check for call compatibility. *
776: *************************************************/
777: IF NOT FND_API.Compatible_API_Call
778: (
779: l_api_version,
780: p_api_version,
781: l_api_name,

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: l_api_name,
782: G_PKG_NAME
783: )
784: THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: END IF;
787:
788: /******************************************
789: * Initialize API return status to success *

Line 791: x_return_status := FND_API.G_RET_STS_SUCCESS;

787:
788: /******************************************
789: * Initialize API return status to success *
790: ******************************************/
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792: G_header_logged := 'N';
793:
794: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
795: log_msg('Beginning Public Create Actual Cost Adjustment API');

Line 812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

808:
809: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
810: log_msg('Return Status after validating : ' || l_return_status);
811: END IF;
812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
813: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
814: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
815: FND_MSG_PUB.Add;
816: RAISE FND_API.G_EXC_ERROR;

Line 816: RAISE FND_API.G_EXC_ERROR;

812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
813: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
814: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
815: FND_MSG_PUB.Add;
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
819: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
820: FND_MSG_PUB.Add;

Line 817: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

813: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
814: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
815: FND_MSG_PUB.Add;
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
819: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
820: FND_MSG_PUB.Add;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

817: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
819: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
820: FND_MSG_PUB.Add;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
824: log_msg('Calling private API to insert record...');
825: END IF;

Line 832: p_init_msg_list => FND_API.G_FALSE,

828: *************************/
829: GMF_ACTUAL_COST_ADJUSTMENT_PVT.CREATE_ACTUAL_COST_ADJUSTMENT
830: (
831: p_api_version => p_api_version,
832: p_init_msg_list => FND_API.G_FALSE,
833: x_return_status => x_return_status,
834: x_msg_count => x_msg_count,
835: x_msg_data => x_msg_data,
836: p_adjustment_rec => p_adjustment_rec

Line 838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

834: x_msg_count => x_msg_count,
835: x_msg_data => x_msg_data,
836: p_adjustment_rec => p_adjustment_rec
837: );
838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
839: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
840: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
841: FND_MSG_PUB.Add;
842: RAISE FND_API.G_EXC_ERROR;

Line 842: RAISE FND_API.G_EXC_ERROR;

838: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
839: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
840: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
841: FND_MSG_PUB.Add;
842: RAISE FND_API.G_EXC_ERROR;
843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
845: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
846: FND_MSG_PUB.Add;

Line 843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

839: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
840: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
841: FND_MSG_PUB.Add;
842: RAISE FND_API.G_EXC_ERROR;
843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
845: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
846: FND_MSG_PUB.Add;
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

843: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
845: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
846: FND_MSG_PUB.Add;
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: END IF;
849: /******************************
850: * Standard check of p_commit. *
851: ******************************/

Line 852: IF FND_API.To_Boolean( p_commit ) THEN

848: END IF;
849: /******************************
850: * Standard check of p_commit. *
851: ******************************/
852: IF FND_API.To_Boolean( p_commit ) THEN
853: COMMIT WORK;
854: END IF;
855: /**************************************************************************
856: * Standard call to get message count and if count is 1, get message info. *

Line 864: WHEN FND_API.G_EXC_ERROR

860: p_count => x_msg_count,
861: p_data => x_msg_data
862: );
863: EXCEPTION
864: WHEN FND_API.G_EXC_ERROR
865: THEN
866: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
867: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
868: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 868: x_return_status := FND_API.G_RET_STS_ERROR ;

864: WHEN FND_API.G_EXC_ERROR
865: THEN
866: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
867: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: FND_MSG_PUB.Count_And_Get
870: (
871: p_count => x_msg_count,
872: p_data => x_msg_data

Line 874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

870: (
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
875: THEN
876: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
877: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
875: THEN
876: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
877: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
879: FND_MSG_PUB.Count_And_Get
880: (
881: p_count => x_msg_count,
882: p_data => x_msg_data

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

884: WHEN OTHERS
885: THEN
886: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PUB;
887: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
890: THEN
891: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
892: END IF;

Line 931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

927: ********************************************************************/
928: PROCEDURE UPDATE_ACTUAL_COST_ADJUSTMENT
929: (
930: p_api_version IN NUMBER,
931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
932: p_commit IN VARCHAR2 := FND_API.G_FALSE,
933: x_return_status OUT NOCOPY VARCHAR2,
934: x_msg_count OUT NOCOPY NUMBER,
935: x_msg_data OUT NOCOPY VARCHAR2,

Line 932: p_commit IN VARCHAR2 := FND_API.G_FALSE,

928: PROCEDURE UPDATE_ACTUAL_COST_ADJUSTMENT
929: (
930: p_api_version IN NUMBER,
931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
932: p_commit IN VARCHAR2 := FND_API.G_FALSE,
933: x_return_status OUT NOCOPY VARCHAR2,
934: x_msg_count OUT NOCOPY NUMBER,
935: x_msg_data OUT NOCOPY VARCHAR2,
936: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 962: IF FND_API.to_Boolean( p_init_msg_list ) THEN

958:
959: /*************************************************************
960: * Initialize message list if p_init_msg_list is set to TRUE. *
961: *************************************************************/
962: IF FND_API.to_Boolean( p_init_msg_list ) THEN
963: FND_MSG_PUB.initialize;
964: END IF;
965:
966: /*************************************************

Line 969: IF NOT FND_API.Compatible_API_Call

965:
966: /*************************************************
967: * Standard call to check for call compatibility. *
968: *************************************************/
969: IF NOT FND_API.Compatible_API_Call
970: (
971: l_api_version,
972: p_api_version,
973: l_api_name,

Line 977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

973: l_api_name,
974: G_PKG_NAME
975: )
976: THEN
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978: END IF;
979:
980: /******************************************
981: * Initialize API return status to success *

Line 983: x_return_status := FND_API.G_RET_STS_SUCCESS;

979:
980: /******************************************
981: * Initialize API return status to success *
982: ******************************************/
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984: G_header_logged := 'N';
985:
986: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
987: log_msg('Beginning Public Update Actual Cost Adjustment API');

Line 1005: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1001:
1002: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1003: log_msg('Return Status after validating : ' || l_return_status);
1004: END IF;
1005: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1006: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1007: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1008: FND_MSG_PUB.Add;
1009: RAISE FND_API.G_EXC_ERROR;

Line 1009: RAISE FND_API.G_EXC_ERROR;

1005: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1006: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1007: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1008: FND_MSG_PUB.Add;
1009: RAISE FND_API.G_EXC_ERROR;
1010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1011: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1013: FND_MSG_PUB.Add;

Line 1010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1006: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1007: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1008: FND_MSG_PUB.Add;
1009: RAISE FND_API.G_EXC_ERROR;
1010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1011: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1013: FND_MSG_PUB.Add;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1011: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1013: FND_MSG_PUB.Add;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1017: log_msg('Calling private API to update record...');
1018: END IF;

Line 1025: p_init_msg_list => FND_API.G_FALSE,

1021: *************************/
1022: GMF_ACTUAL_COST_ADJUSTMENT_PVT.UPDATE_ACTUAL_COST_ADJUSTMENT
1023: (
1024: p_api_version => p_api_version,
1025: p_init_msg_list => FND_API.G_FALSE,
1026: x_return_status => x_return_status,
1027: x_msg_count => x_msg_count,
1028: x_msg_data => x_msg_data,
1029: p_adjustment_rec => p_adjustment_rec

Line 1031: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1027: x_msg_count => x_msg_count,
1028: x_msg_data => x_msg_data,
1029: p_adjustment_rec => p_adjustment_rec
1030: );
1031: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1032: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1033: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1034: FND_MSG_PUB.Add;
1035: RAISE FND_API.G_EXC_ERROR;

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1032: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1033: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1034: FND_MSG_PUB.Add;
1035: RAISE FND_API.G_EXC_ERROR;
1036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1037: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1038: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1039: FND_MSG_PUB.Add;

Line 1036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1032: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1033: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1034: FND_MSG_PUB.Add;
1035: RAISE FND_API.G_EXC_ERROR;
1036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1037: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1038: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1037: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1038: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END IF;
1042: /******************************
1043: * Standard check of p_commit. *
1044: ******************************/

Line 1045: IF FND_API.To_Boolean( p_commit ) THEN

1041: END IF;
1042: /******************************
1043: * Standard check of p_commit. *
1044: ******************************/
1045: IF FND_API.To_Boolean( p_commit ) THEN
1046: COMMIT WORK;
1047: END IF;
1048: /**************************************************************************
1049: * Standard call to get message count and if count is 1, get message info. *

Line 1057: WHEN FND_API.G_EXC_ERROR

1053: p_count => x_msg_count,
1054: p_data => x_msg_data
1055: );
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR
1058: THEN
1059: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1060: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1061: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR ;

1057: WHEN FND_API.G_EXC_ERROR
1058: THEN
1059: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1060: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1061: x_return_status := FND_API.G_RET_STS_ERROR ;
1062: FND_MSG_PUB.Count_And_Get
1063: (
1064: p_count => x_msg_count,
1065: p_data => x_msg_data

Line 1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1063: (
1064: p_count => x_msg_count,
1065: p_data => x_msg_data
1066: );
1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1068: THEN
1069: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1070: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1068: THEN
1069: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1070: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1072: FND_MSG_PUB.Count_And_Get
1073: (
1074: p_count => x_msg_count,
1075: p_data => x_msg_data

Line 1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1077: WHEN OTHERS
1078: THEN
1079: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PUB;
1080: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1083: THEN
1084: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1085: END IF;

Line 1124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1120: ********************************************************************/
1121: PROCEDURE DELETE_ACTUAL_COST_ADJUSTMENT
1122: (
1123: p_api_version IN NUMBER,
1124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,

Line 1125: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1121: PROCEDURE DELETE_ACTUAL_COST_ADJUSTMENT
1122: (
1123: p_api_version IN NUMBER,
1124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 1155: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1151:
1152: /*************************************************************
1153: * Initialize message list if p_init_msg_list is set to TRUE. *
1154: *************************************************************/
1155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: /*************************************************

Line 1162: IF NOT FND_API.Compatible_API_Call

1158:
1159: /*************************************************
1160: * Standard call to check for call compatibility. *
1161: *************************************************/
1162: IF NOT FND_API.Compatible_API_Call
1163: (
1164: l_api_version,
1165: p_api_version,
1166: l_api_name,

Line 1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1165: p_api_version,
1166: l_api_name,
1167: G_PKG_NAME
1168: ) THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;
1171:
1172: /******************************************
1173: * Initialize API return status to success *

Line 1175: x_return_status := FND_API.G_RET_STS_SUCCESS;

1171:
1172: /******************************************
1173: * Initialize API return status to success *
1174: ******************************************/
1175: x_return_status := FND_API.G_RET_STS_SUCCESS;
1176: G_header_logged := 'N';
1177:
1178: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1179: log_msg('Beginning Public Delete Actual Cost Adjustment API');

Line 1197: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1193:
1194: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1195: log_msg('Return Status after validating : ' || l_return_status);
1196: END IF;
1197: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1198: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1199: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1200: FND_MSG_PUB.Add;
1201: RAISE FND_API.G_EXC_ERROR;

Line 1201: RAISE FND_API.G_EXC_ERROR;

1197: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1198: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1199: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1200: FND_MSG_PUB.Add;
1201: RAISE FND_API.G_EXC_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1204: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1205: FND_MSG_PUB.Add;

Line 1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1198: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1199: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1200: FND_MSG_PUB.Add;
1201: RAISE FND_API.G_EXC_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1204: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1205: FND_MSG_PUB.Add;
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1204: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1205: FND_MSG_PUB.Add;
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1209: log_msg('Calling private API to delete record...');
1210: END IF;

Line 1217: p_init_msg_list => FND_API.G_FALSE,

1213: *************************/
1214: GMF_ACTUAL_COST_ADJUSTMENT_PVT.DELETE_ACTUAL_COST_ADJUSTMENT
1215: (
1216: p_api_version => p_api_version,
1217: p_init_msg_list => FND_API.G_FALSE,
1218: x_return_status => x_return_status,
1219: x_msg_count => x_msg_count,
1220: x_msg_data => x_msg_data,
1221: p_adjustment_rec => p_adjustment_rec

Line 1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1219: x_msg_count => x_msg_count,
1220: x_msg_data => x_msg_data,
1221: p_adjustment_rec => p_adjustment_rec
1222: );
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1225: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1226: FND_MSG_PUB.Add;
1227: RAISE FND_API.G_EXC_ERROR;

Line 1227: RAISE FND_API.G_EXC_ERROR;

1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1225: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1226: FND_MSG_PUB.Add;
1227: RAISE FND_API.G_EXC_ERROR;
1228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1230: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1231: FND_MSG_PUB.Add;

Line 1228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1224: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1225: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1226: FND_MSG_PUB.Add;
1227: RAISE FND_API.G_EXC_ERROR;
1228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1230: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1231: FND_MSG_PUB.Add;
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1230: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1231: FND_MSG_PUB.Add;
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234: /******************************
1235: * Standard check of p_commit. *
1236: ******************************/

Line 1237: IF FND_API.To_Boolean( p_commit ) THEN

1233: END IF;
1234: /******************************
1235: * Standard check of p_commit. *
1236: ******************************/
1237: IF FND_API.To_Boolean( p_commit ) THEN
1238: COMMIT WORK;
1239: END IF;
1240: /**************************************************************************
1241: * Standard call to get message count and if count is 1, get message info. *

Line 1249: WHEN FND_API.G_EXC_ERROR

1245: p_count => x_msg_count,
1246: p_data => x_msg_data
1247: );
1248: EXCEPTION
1249: WHEN FND_API.G_EXC_ERROR
1250: THEN
1251: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1252: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1253: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1253: x_return_status := FND_API.G_RET_STS_ERROR ;

1249: WHEN FND_API.G_EXC_ERROR
1250: THEN
1251: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1252: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1253: x_return_status := FND_API.G_RET_STS_ERROR ;
1254: FND_MSG_PUB.Count_And_Get
1255: (
1256: p_count => x_msg_count,
1257: p_data => x_msg_data

Line 1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1255: (
1256: p_count => x_msg_count,
1257: p_data => x_msg_data
1258: );
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1260: THEN
1261: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1262: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1260: THEN
1261: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1262: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Count_And_Get
1265: (
1266: p_count => x_msg_count,
1267: p_data => x_msg_data

Line 1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1269: WHEN OTHERS
1270: THEN
1271: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PUB;
1272: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1275: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1276: END IF;
1277: FND_MSG_PUB.Count_And_Get

Line 1315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1311: ********************************************************************/
1312: PROCEDURE GET_ACTUAL_COST_ADJUSTMENT
1313: (
1314: p_api_version IN NUMBER,
1315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1316: x_return_status OUT NOCOPY VARCHAR2,
1317: x_msg_count OUT NOCOPY NUMBER,
1318: x_msg_data OUT NOCOPY VARCHAR2,
1319: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 1340: IF FND_API.to_Boolean( p_init_msg_list )

1336:
1337: /*************************************************************
1338: * Initialize message list if p_init_msg_list is set to TRUE. *
1339: *************************************************************/
1340: IF FND_API.to_Boolean( p_init_msg_list )
1341: THEN
1342: FND_MSG_PUB.initialize;
1343: END IF;
1344:

Line 1348: IF NOT FND_API.Compatible_API_Call

1344:
1345: /*************************************************
1346: * Standard call to check for call compatibility. *
1347: *************************************************/
1348: IF NOT FND_API.Compatible_API_Call
1349: (
1350: l_api_version,
1351: p_api_version,
1352: l_api_name,

Line 1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1352: l_api_name,
1353: G_PKG_NAME
1354: )
1355: THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END IF;
1358:
1359: /******************************************
1360: * Initialize API return status to success *

Line 1362: x_return_status := FND_API.G_RET_STS_SUCCESS;

1358:
1359: /******************************************
1360: * Initialize API return status to success *
1361: ******************************************/
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363: G_header_logged := 'N';
1364:
1365: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1366: THEN

Line 1385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1381:
1382: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1383: log_msg('Return Status after validating : ' || l_return_status);
1384: END IF;
1385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1386: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1387: RAISE FND_API.G_EXC_ERROR;
1388: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1389: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 1387: RAISE FND_API.G_EXC_ERROR;

1383: log_msg('Return Status after validating : ' || l_return_status);
1384: END IF;
1385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1386: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1387: RAISE FND_API.G_EXC_ERROR;
1388: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1389: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;

Line 1388: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1384: END IF;
1385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1386: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1387: RAISE FND_API.G_EXC_ERROR;
1388: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1389: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392:

Line 1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1386: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1387: RAISE FND_API.G_EXC_ERROR;
1388: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1389: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392:
1393: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1394: log_msg('Calling private API to get record...');

Line 1402: p_init_msg_list => FND_API.G_FALSE,

1398: *************************/
1399: GMF_ACTUAL_COST_ADJUSTMENT_PVT.GET_ACTUAL_COST_ADJUSTMENT
1400: (
1401: p_api_version => p_api_version,
1402: p_init_msg_list => FND_API.G_FALSE,
1403: x_return_status => x_return_status,
1404: x_msg_count => x_msg_count,
1405: x_msg_data => x_msg_data,
1406: p_adjustment_rec => p_adjustment_rec

Line 1408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1404: x_msg_count => x_msg_count,
1405: x_msg_data => x_msg_data,
1406: p_adjustment_rec => p_adjustment_rec
1407: );
1408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1409: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1410: RAISE FND_API.G_EXC_ERROR;
1411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );

Line 1410: RAISE FND_API.G_EXC_ERROR;

1406: p_adjustment_rec => p_adjustment_rec
1407: );
1408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1409: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1410: RAISE FND_API.G_EXC_ERROR;
1411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;

Line 1411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1407: );
1408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1409: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1410: RAISE FND_API.G_EXC_ERROR;
1411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: /**************************************************************************

Line 1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1409: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1410: RAISE FND_API.G_EXC_ERROR;
1411: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: /**************************************************************************
1416: * Standard call to get message count and if count is 1, get message info. *
1417: **************************************************************************/

Line 1424: WHEN FND_API.G_EXC_ERROR

1420: p_count => x_msg_count,
1421: p_data => x_msg_data
1422: );
1423: EXCEPTION
1424: WHEN FND_API.G_EXC_ERROR
1425: THEN
1426: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: FND_MSG_PUB.Count_And_Get

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR ;

1423: EXCEPTION
1424: WHEN FND_API.G_EXC_ERROR
1425: THEN
1426: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: FND_MSG_PUB.Count_And_Get
1429: (
1430: p_count => x_msg_count,
1431: p_data => x_msg_data

Line 1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1429: (
1430: p_count => x_msg_count,
1431: p_data => x_msg_data
1432: );
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1434: THEN
1435: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: FND_MSG_PUB.Count_And_Get

Line 1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1432: );
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1434: THEN
1435: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: FND_MSG_PUB.Count_And_Get
1438: (
1439: p_count => x_msg_count,
1440: p_data => x_msg_data

Line 1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1441: );
1442: WHEN OTHERS
1443: THEN
1444: add_record_to_error_stack ( p_adjustment_rec => p_adjustment_rec );
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1447: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get