eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_ITEMCOST_PUB dependencies on FND_MSG_PUB

Line 8: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ;

4: /*******************
5: * Global variables *
6: *******************/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ItemCost_PUB';
8: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ;
9: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold;
10: G_header_logged VARCHAR2(1);
11:
12: -- Func start of comments

Line 9: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold;

5: * Global variables *
6: *******************/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ItemCost_PUB';
8: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ;
9: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold;
10: G_header_logged VARCHAR2(1);
11:
12: -- Func start of comments
13: --+==========================================================================+

Line 42: FND_MSG_PUB.Add;

38: IS
39: BEGIN
40: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
41: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
42: FND_MSG_PUB.Add;
43: END LOG_MSG ;
44:
45: -- Func start of comments
46: --+==========================================================================+

Line 83: FND_MSG_PUB.Add;

79: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header.calendar_code);
80: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
81: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
82: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
83: FND_MSG_PUB.Add;
84: END IF;
85: END ADD_HEADER_TO_ERROR_STACK;
86:
87: -- Start of comments

Line 227: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

223: **************************/
224: IF (p_header_rec.organization_id <> FND_API.G_MISS_NUM)
225: AND (p_header_rec.organization_id IS NOT NULL)
226: THEN
227: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
228: THEN
229: log_msg('Validating Organization Id :' || p_header_rec.Organization_id);
230: END IF;
231: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id) THEN

Line 235: FND_MSG_PUB.Add;

231: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id) THEN
232: add_header_to_error_stack(p_header_rec);
233: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
234: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
235: FND_MSG_PUB.Add;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.organization_code IS NOT NULL)
239: THEN

Line 240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.organization_code IS NOT NULL)
239: THEN
240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
241: THEN
242: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
243: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
244: FND_MSG_PUB.Add;

Line 244: FND_MSG_PUB.Add;

240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
241: THEN
242: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
243: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
244: FND_MSG_PUB.Add;
245: END IF;
246: END IF;
247: ELSE
248: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR)

Line 251: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

247: ELSE
248: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR)
249: AND (p_header_rec.organization_code IS NOT NULL)
250: THEN
251: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
252: THEN
253: log_msg('Validating Organization Code :' || p_header_rec.Organization_code);
254: END IF;
255: x_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);

Line 261: FND_MSG_PUB.Add;

257: THEN
258: add_header_to_error_stack(p_header_rec);
259: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
260: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
261: FND_MSG_PUB.Add;
262: RAISE FND_API.G_EXC_ERROR;
263: ELSE
264: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada
265: log_msg('Organization Id : ' || x_header_rec.organization_id );

Line 264: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada

260: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
261: FND_MSG_PUB.Add;
262: RAISE FND_API.G_EXC_ERROR;
263: ELSE
264: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada
265: log_msg('Organization Id : ' || x_header_rec.organization_id );
266: END IF;
267: END IF;
268: ELSE

Line 271: FND_MSG_PUB.Add;

267: END IF;
268: ELSE
269: add_header_to_error_stack(p_header_rec);
270: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: END IF;
275: x_header_rec.organization_id := nvl(p_header_rec.organization_id, x_header_rec.organization_id) ;

Line 283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

279: ***********************/
280: IF (p_header_rec.cost_type_id <> FND_API.G_MISS_NUM)
281: AND (p_header_rec.cost_type_id IS NOT NULL)
282: THEN
283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
284: THEN
285: log_msg('Validating Cost type Id : ' || p_header_rec.cost_type_id);
286: END IF;
287: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_type_id(p_header_rec.cost_type_id) THEN

Line 291: FND_MSG_PUB.Add;

287: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_type_id(p_header_rec.cost_type_id) THEN
288: add_header_to_error_stack(p_header_rec);
289: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
290: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
291: FND_MSG_PUB.Add;
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL)
295: THEN

Line 296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL)
295: THEN
296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
297: THEN
298: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
299: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
300: FND_MSG_PUB.Add;

Line 300: FND_MSG_PUB.Add;

296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
297: THEN
298: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
299: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
300: FND_MSG_PUB.Add;
301: END IF;
302: END IF;
303: ELSE
304: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR)

Line 307: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

303: ELSE
304: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR)
305: AND (p_header_rec.cost_mthd_code IS NOT NULL)
306: THEN
307: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
308: THEN
309: log_msg('Validating Cost type code : ' || p_header_rec.cost_mthd_code);
310: END IF;
311: x_header_rec.cost_Type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);

Line 316: FND_MSG_PUB.Add;

312: IF x_header_rec.cost_Type_id IS NULL THEN
313: add_header_to_error_stack(p_header_rec);
314: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
315: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
316: FND_MSG_PUB.Add;
317: RAISE FND_API.G_EXC_ERROR;
318: ELSE
319: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada
320: log_msg('Cost Type Id : ' || x_header_rec.cost_Type_id );

Line 319: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada

315: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
316: FND_MSG_PUB.Add;
317: RAISE FND_API.G_EXC_ERROR;
318: ELSE
319: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada
320: log_msg('Cost Type Id : ' || x_header_rec.cost_Type_id );
321: END IF;
322: END IF;
323: ELSE

Line 326: FND_MSG_PUB.Add;

322: END IF;
323: ELSE
324: add_header_to_error_stack(p_header_rec);
325: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
326: FND_MSG_PUB.Add;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329: END IF;
330: x_header_rec.cost_type_id := nvl(p_header_rec.cost_type_id, x_header_rec.cost_type_id) ;

Line 338: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

334: ***********************/
335: IF (p_header_rec.period_id <> FND_API.G_MISS_NUM)
336: AND (p_header_rec.period_id IS NOT NULL)
337: THEN
338: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
339: THEN
340: log_msg('Validating Period Id : ' || p_header_rec.period_id);
341: END IF;
342: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)

Line 347: FND_MSG_PUB.Add;

343: THEN
344: add_header_to_error_stack(p_header_rec);
345: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
346: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
347: FND_MSG_PUB.Add;
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
351: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL))

Line 353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

349: END IF;
350: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
351: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL))
352: THEN
353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
354: THEN
355: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
356: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);

Line 358: FND_MSG_PUB.Add;

354: THEN
355: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
356: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
358: FND_MSG_PUB.Add;
359: END IF;
360: END IF;
361: ELSE
362: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

Line 362: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

358: FND_MSG_PUB.Add;
359: END IF;
360: END IF;
361: ELSE
362: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
363: THEN
364: log_msg('Validating Calendar Code : '|| p_header_rec.Calendar_code||' period_code : ' || p_header_rec.period_code);
365: END IF;
366: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))

Line 375: FND_MSG_PUB.Add;

371: add_header_to_error_stack(p_header_rec);
372: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
373: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
374: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
375: FND_MSG_PUB.Add;
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE
378: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada
379: log_msg('Period Id : ' || x_header_rec.period_id );

Line 378: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada

374: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
375: FND_MSG_PUB.Add;
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE
378: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5586406, pmarada
379: log_msg('Period Id : ' || x_header_rec.period_id );
380: END IF;
381: END IF;
382: ELSE

Line 385: FND_MSG_PUB.Add;

381: END IF;
382: ELSE
383: add_header_to_error_stack(p_header_rec);
384: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
385: FND_MSG_PUB.Add;
386: RAISE FND_API.G_EXC_ERROR;
387: END IF;
388: END IF;
389: x_header_rec.period_id := nvl(p_header_rec.period_id, x_header_rec.period_id) ;

Line 405: FND_MSG_PUB.Add;

401: THEN
402: add_header_to_error_stack(p_header_rec);
403: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_STATUS');
404: FND_MESSAGE.SET_TOKEN('PERIOD_ID',x_header_rec.period_id);
405: FND_MSG_PUB.Add;
406: RAISE FND_API.G_EXC_ERROR;
407: ELSIF l_period_status = 'F'
408: THEN
409: IF p_operation IN ('UPDATE','DELETE')

Line 414: FND_MSG_PUB.Add;

410: THEN
411: add_header_to_error_stack(p_header_rec);
412: FND_MESSAGE.SET_NAME('GMF','GMF_API_FROZEN_PERIOD_ID');
413: FND_MESSAGE.SET_TOKEN('PERIOD_ID',x_header_rec.period_id);
414: FND_MSG_PUB.Add;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF ;
417: ELSIF l_period_status = 'C'
418: THEN

Line 422: FND_MSG_PUB.Add;

418: THEN
419: add_header_to_error_stack(p_header_rec);
420: FND_MESSAGE.SET_NAME('GMF','GMF_API_CLOSED_PERIOD_ID');
421: FND_MESSAGE.SET_TOKEN('PERIOD_ID',x_header_rec.period_id);
422: FND_MSG_PUB.Add;
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: /******************

Line 431: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

427: * Item Validation *
428: ******************/
429: IF (p_header_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND (p_header_rec.inventory_item_id IS NOT NULL)
430: THEN
431: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
432: THEN
433: log_msg('Validating Inventory Item Id : ' || p_header_rec.inventory_item_id);
434: END IF;
435: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, x_header_Rec.organization_id)

Line 440: FND_MSG_PUB.Add;

436: THEN
437: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
438: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_header_rec.inventory_item_id);
439: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_Rec.organization_id);
440: FND_MSG_PUB.Add;
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
444: THEN

Line 445: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
444: THEN
445: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
446: THEN
447: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
448: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
449: FND_MSG_PUB.Add;

Line 449: FND_MSG_PUB.Add;

445: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
446: THEN
447: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
448: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
449: FND_MSG_PUB.Add;
450: END IF;
451: END IF;
452: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
453: THEN

Line 454: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

450: END IF;
451: END IF;
452: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
453: THEN
454: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
455: THEN
456: log_msg('Validating Item Number : ' || p_header_rec.item_number);
457: END IF;
458: x_header_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_header_rec.item_number, x_header_Rec.organization_id);

Line 464: FND_MSG_PUB.Add;

460: THEN
461: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
462: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
463: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_Rec.organization_id);
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_ERROR;
466: ELSE
467: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
468: log_msg('Inventory Item id : ' || x_header_rec.inventory_item_id);

Line 467: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

463: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_Rec.organization_id);
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_ERROR;
466: ELSE
467: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
468: log_msg('Inventory Item id : ' || x_header_rec.inventory_item_id);
469: END IF;
470: END IF;
471: ELSE

Line 473: FND_MSG_PUB.Add;

469: END IF;
470: END IF;
471: ELSE
472: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
473: FND_MSG_PUB.Add;
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476: x_header_rec.inventory_item_id := nvl(p_header_rec.inventory_item_id, x_header_rec.inventory_item_id);
477:

Line 496: FND_MSG_PUB.Add;

492: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',x_header_rec.inventory_item_id);
493: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);
494: FND_MESSAGE.SET_TOKEN('PERIOD_ID',x_header_rec.period_id);
495: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',x_header_rec.cost_type_id);
496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF ;
499: END IF ;
500:

Line 504: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

500:
501: /***********************
502: * User Name Validation *
503: ***********************/
504: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
505: THEN
506: log_msg('Validating user name : ' || p_header_rec.user_name);
507: END IF;
508:

Line 518: FND_MSG_PUB.Add;

514: THEN
515: add_header_to_error_stack(p_header_rec);
516: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
517: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
518: FND_MSG_PUB.Add;
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521: ELSE
522: add_header_to_error_stack(p_header_rec);

Line 524: FND_MSG_PUB.Add;

520: END IF;
521: ELSE
522: add_header_to_error_stack(p_header_rec);
523: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527: x_header_rec.inventory_item_id := nvl(p_header_rec.inventory_item_id, x_header_rec.inventory_item_id);
528: x_header_rec.period_id := nvl(p_header_rec.period_id, x_header_rec.period_id) ;

Line 538: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

534: x_header_rec.organization_code := nvl(p_header_rec.organization_code, x_header_rec.organization_code);
535: x_header_rec.item_number := nvl(p_header_rec.item_number, x_header_rec.item_number) ;
536: x_header_rec.user_name := nvl(p_header_rec.user_name, x_header_rec.user_name) ;
537:
538: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
539: THEN
540: log_msg( 'period_id : ' || x_header_rec.period_id ) ;
541: log_msg( 'cost_type_id : ' || x_header_rec.cost_type_id ) ;
542: log_msg( 'Organziation_id : ' || x_header_rec.organization_id ) ;

Line 557: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

553: l_cost_cmpntcls_id := '' ;
554: l_cost_cmpntcls_code := '' ;
555: l_cmpntcost_id := '' ;
556:
557: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
558: log_msg('This Level Record# : ' || i);
559: END IF;
560:
561: /*****************************************************************************************

Line 574: FND_MSG_PUB.Add;

570: THEN
571: add_header_to_error_stack(p_header_rec);
572: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_IC_UNIQUE_KEY');
573: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level(i).cmpntcost_id);
574: FND_MSG_PUB.Add;
575: l_cmpntcost_id := p_this_level(i).cmpntcost_id;
576: ELSE
577:
578: /*****************************************************************************

Line 597: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

593: ************************************************************************/
594: IF (p_this_level(i).cost_cmpntcls_id <> FND_API.G_MISS_NUM)
595: AND (p_this_level(i).cost_cmpntcls_id IS NOT NULL)
596: THEN
597: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
598: THEN
599: log_msg('validating this level Cmpt Cls ID('||i||') : '|| p_this_level(i).cost_cmpntcls_id);
600: END IF;
601:

Line 611: FND_MSG_PUB.Add;

607: THEN
608: add_header_to_error_stack(p_header_rec);
609: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
610: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_this_level(i).cost_cmpntcls_id);
611: FND_MSG_PUB.Add;
612: RAISE e_this_level;
613: END IF;
614: l_cost_cmpntcls_id := p_this_level(i).cost_cmpntcls_id ;
615: IF (p_this_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)

Line 618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

614: l_cost_cmpntcls_id := p_this_level(i).cost_cmpntcls_id ;
615: IF (p_this_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)
616: AND (p_this_level(i).cost_cmpntcls_code IS NOT NULL)
617: THEN
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
619: THEN
620: add_header_to_error_stack(p_header_rec); -- Bug 2659435
621: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
622: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_this_level(i).cost_cmpntcls_code);

Line 623: FND_MSG_PUB.Add;

619: THEN
620: add_header_to_error_stack(p_header_rec); -- Bug 2659435
621: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
622: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_this_level(i).cost_cmpntcls_code);
623: FND_MSG_PUB.Add;
624: END IF;
625: END IF;
626: ELSIF (p_this_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)
627: AND (p_this_level(i).cost_cmpntcls_code IS NOT NULL)

Line 630: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

626: ELSIF (p_this_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)
627: AND (p_this_level(i).cost_cmpntcls_code IS NOT NULL)
628: THEN
629: l_cost_cmpntcls_code := p_this_level(i).cost_cmpntcls_code ;
630: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
631: THEN
632: log_msg('validating this level Cmpt Cls Code('||i||') : ' ||p_this_level(i).cost_cmpntcls_code);
633: END IF;
634:

Line 647: FND_MSG_PUB.Add;

643: THEN
644: add_header_to_error_stack(p_header_rec);
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
646: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_this_level(i).cost_cmpntcls_code);
647: FND_MSG_PUB.Add;
648: RAISE e_this_level;
649: ELSE
650: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
651: log_msg('Cmpt Cls Id := ' || l_cost_cmpntcls_id);

Line 650: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

646: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_this_level(i).cost_cmpntcls_code);
647: FND_MSG_PUB.Add;
648: RAISE e_this_level;
649: ELSE
650: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
651: log_msg('Cmpt Cls Id := ' || l_cost_cmpntcls_id);
652: END IF;
653: END IF;
654: ELSE

Line 657: FND_MSG_PUB.Add;

653: END IF;
654: ELSE
655: add_header_to_error_stack(p_header_rec);
656: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
657: FND_MSG_PUB.Add;
658: RAISE e_this_level;
659: END IF;
660:
661: /****************

Line 664: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

660:
661: /****************
662: * Analysis Code *
663: ****************/
664: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
665: THEN
666: log_msg('validating this level analysis_code('||i||') : ' || p_this_level(i).cost_analysis_code);
667: END IF;
668: IF (p_this_level(i).cost_analysis_code <> FND_API.G_MISS_CHAR)

Line 676: FND_MSG_PUB.Add;

672: THEN
673: add_header_to_error_stack(p_header_rec);
674: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
675: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',p_this_level(i).cost_analysis_code);
676: FND_MSG_PUB.Add;
677: RAISE e_this_level;
678: END IF;
679: ELSE
680: add_header_to_error_stack(p_header_rec);

Line 682: FND_MSG_PUB.Add;

678: END IF;
679: ELSE
680: add_header_to_error_stack(p_header_rec);
681: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
682: FND_MSG_PUB.Add;
683: RAISE e_this_level;
684: END IF;
685: END IF ;
686: /******************************************************

Line 697: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

693: /*******************************************************************************************************
694: * Component Cost, In the form the format mask for this is : 999999999D999999999(999,999,999.999999999) *
695: * To put that check here, the cost should not be >= 1,000,000,000 *
696: *******************************************************************************************************/
697: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
698: THEN
699: log_msg('validating this level Component Cost('||i||') for format : '||p_this_level(i).cmpnt_cost);
700: END IF;
701:

Line 705: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

701:
702: IF (p_this_level(i).cmpnt_cost <> FND_API.G_MISS_NUM)
703: AND (p_this_level(i).cmpnt_cost IS NOT NULL)
704: THEN
705: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
706: THEN
707: log_msg('before cmpnt_cost check for format...');
708: END IF;
709: IF p_this_level(i).cmpnt_cost >= 1000000000

Line 711: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

707: log_msg('before cmpnt_cost check for format...');
708: END IF;
709: IF p_this_level(i).cmpnt_cost >= 1000000000
710: THEN
711: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
712: THEN
713: log_msg('before raising the error...');
714: END IF;
715: add_header_to_error_stack(p_header_rec);

Line 718: FND_MSG_PUB.Add;

714: END IF;
715: add_header_to_error_stack(p_header_rec);
716: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNT_COST') ;
717: FND_MESSAGE.SET_TOKEN('CMPNT_COST',p_this_level(i).cmpnt_cost);
718: FND_MSG_PUB.Add;
719: RAISE e_this_level;
720: END IF ;
721: ELSIF (p_this_level(i).cmpnt_cost = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
722: OR (p_operation = 'INSERT')

Line 726: FND_MSG_PUB.Add;

722: OR (p_operation = 'INSERT')
723: THEN
724: add_header_to_error_stack(p_header_rec);
725: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNT_COST_REQ');
726: FND_MSG_PUB.Add;
727: RAISE e_this_level;
728: END IF;
729:
730: /************************************************************************************

Line 734: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

730: /************************************************************************************
731: * Burden Indicator must be either 0 or 1 *
732: * If Burden Indicator is 1 then Cost Component Class must have usage indicator = 2. *
733: ************************************************************************************/
734: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
735: THEN
736: log_msg('validating this level Burden Indicator('||i||') : '||p_this_level(i).burden_ind);
737: END IF;
738:

Line 747: FND_MSG_PUB.Add;

743: THEN
744: add_header_to_error_stack(p_header_rec);
745: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_IND');
746: FND_MESSAGE.SET_TOKEN('BURDEN_IND',p_this_level(i).burden_ind);
747: FND_MSG_PUB.Add;
748: RAISE e_this_level;
749: END IF;
750: IF (p_this_level(i).burden_ind = 1) AND ( l_usage_ind <>2 )
751: THEN

Line 756: FND_MSG_PUB.Add;

752: add_header_to_error_stack(p_header_rec);
753: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_USAGE_IND');
754: FND_MESSAGE.SET_TOKEN('BURDEN_IND',p_this_level(i).burden_ind);
755: FND_MESSAGE.SET_TOKEN('CMPNT_CLS',l_cost_cmpntcls_code);
756: FND_MSG_PUB.Add;
757: RAISE e_this_level;
758: END IF ;
759: ELSIF (p_this_level(i).burden_ind = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
760: OR (p_operation = 'INSERT')

Line 764: FND_MSG_PUB.Add;

760: OR (p_operation = 'INSERT')
761: THEN
762: add_header_to_error_stack(p_header_rec); -- Bug 2659435
763: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_IND_REQ');
764: FND_MSG_PUB.Add;
765: RAISE e_this_level;
766: END IF;
767:
768: /************************************************************************************************

Line 773: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

769: * Raw Material Calculation Type *
770: * If Cost Method Code = "Actual Cost" then this field can only have either of 1, 2, 3, 4, OR 5 *
771: * otherwise it will be set to 0 *
772: ************************************************************************************************/
773: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
774: THEN
775: log_msg('validating this level Raw Material Calculation Type('||i||') :'|| p_this_level(i).rmcalc_type);
776: END IF;
777:

Line 787: FND_MSG_PUB.Add;

783: THEN
784: add_header_to_error_stack(p_header_rec);
785: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RMCALC_TYPE');
786: FND_MESSAGE.SET_TOKEN('RMCALC_TYPE',p_this_level(i).rmcalc_type);
787: FND_MSG_PUB.Add;
788: RAISE e_this_level;
789: ELSE
790: l_rmcalc_type := p_this_level(i).rmcalc_type ;
791: END IF;

Line 797: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

793: l_rmcalc_type := 0 ;
794: END IF ;
795: END IF ;
796:
797: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
798: THEN
799: log_msg('validating this level delete_mark('||i||') :' || p_this_level(i).delete_mark);
800: END IF;
801:

Line 810: FND_MSG_PUB.Add;

806: THEN
807: add_header_to_error_stack(p_header_rec);
808: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
809: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_this_level(i).delete_mark);
810: FND_MSG_PUB.Add;
811: RAISE e_this_level;
812: END IF;
813: ELSIF (p_this_level(i).delete_mark = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
814: OR (p_operation = 'INSERT')

Line 818: FND_MSG_PUB.Add;

814: OR (p_operation = 'INSERT')
815: THEN
816: add_header_to_error_stack(p_header_rec);
817: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
818: FND_MSG_PUB.Add;
819: RAISE e_this_level;
820: END IF;
821: IF (p_operation = 'UPDATE') AND (p_this_level(i).delete_mark = 1)
822: THEN

Line 825: FND_MSG_PUB.Add;

821: IF (p_operation = 'UPDATE') AND (p_this_level(i).delete_mark = 1)
822: THEN
823: add_header_to_error_stack(p_header_rec);
824: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
825: FND_MSG_PUB.Add;
826: RAISE e_this_level;
827: END IF;
828: END IF ;
829:

Line 841: FND_MSG_PUB.Add;

837: THEN
838: add_header_to_error_stack(p_header_rec);
839: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_IC_UNIQUE_KEY');
840: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level(i).cmpntcost_id);
841: FND_MSG_PUB.Add;
842: l_cmpntcost_id := p_this_level(i).cmpntcost_id;
843: END IF ;
844: END IF ;
845: l_idx := l_idx + 1 ;

Line 892: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

888: x_this_level(l_idx).attribute29 := p_this_level(i).attribute29 ;
889: x_this_level(l_idx).attribute30 := p_this_level(i).attribute30 ;
890: x_this_level(l_idx).attribute_category := p_this_level(i).attribute_category ;
891:
892: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
893: THEN
894: log_msg('x_cmpntcost_id('||l_idx||'): '||l_cmpntcost_id);
895: log_msg('x_cost_cmpntcls_id('||l_idx||'): '|| x_this_level(l_idx).cost_cmpntcls_id);
896: log_msg('x_cost_cmpntcls_code('||l_idx||'): '|| x_this_level(l_idx).cost_cmpntcls_code) ;

Line 921: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

917: BEGIN
918: l_cost_cmpntcls_id := '' ;
919: l_cost_cmpntcls_code := '' ;
920: l_cmpntcost_id := '' ;
921: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
922: THEN
923: log_msg('Lower Level Record # : ' || i);
924: END IF;
925:

Line 938: FND_MSG_PUB.Add;

934: THEN
935: add_header_to_error_stack(p_header_rec);
936: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_IC_UNIQUE_KEY');
937: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level(i).cmpntcost_id);
938: FND_MSG_PUB.Add;
939: l_cmpntcost_id := p_lower_level(i).cmpntcost_id;
940: ELSE
941: IF ((p_operation = 'UPDATE')
942: AND ((p_lower_level(i).cmpntcost_id <> FND_API.G_MISS_NUM)

Line 955: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

951: ***************************************************************************************/
952: IF (p_lower_level(i).cost_cmpntcls_id <> FND_API.G_MISS_NUM)
953: AND (p_lower_level(i).cost_cmpntcls_id IS NOT NULL)
954: THEN
955: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
956: THEN
957: log_msg('validating lower level Cmpt Cls ID('||i||') :'|| p_lower_level(i).cost_cmpntcls_id);
958: END IF;
959: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_lower_level(i).cost_cmpntcls_id)

Line 964: FND_MSG_PUB.Add;

960: THEN
961: add_header_to_error_stack(p_header_rec);
962: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
963: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_lower_level(i).cost_cmpntcls_id);
964: FND_MSG_PUB.Add;
965: RAISE e_lower_level;
966: END IF;
967: l_cost_cmpntcls_id := p_lower_level(i).cost_cmpntcls_id ;
968:

Line 975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

971: ***************************************************/
972: IF (p_lower_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)
973: AND (p_lower_level(i).cost_cmpntcls_code IS NOT NULL)
974: THEN
975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
976: THEN
977: add_header_to_error_stack(p_header_rec);
978: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
979: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_lower_level(i).cost_cmpntcls_code);

Line 980: FND_MSG_PUB.Add;

976: THEN
977: add_header_to_error_stack(p_header_rec);
978: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
979: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_lower_level(i).cost_cmpntcls_code);
980: FND_MSG_PUB.Add;
981: END IF;
982: END IF;
983: ELSIF (p_lower_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)
984: AND (p_lower_level(i).cost_cmpntcls_code IS NOT NULL)

Line 986: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

982: END IF;
983: ELSIF (p_lower_level(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR)
984: AND (p_lower_level(i).cost_cmpntcls_code IS NOT NULL)
985: THEN
986: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
987: THEN
988: log_msg('validating lower level Cmpt Cls Code('||i||') : ' ||p_lower_level(i).cost_cmpntcls_code);
989: END IF;
990: l_cost_cmpntcls_id := GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Code (p_lower_level(i).cost_cmpntcls_code);

Line 995: FND_MSG_PUB.Add;

991: IF l_cost_cmpntcls_id IS NULL THEN
992: add_header_to_error_stack(p_header_rec);
993: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
994: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_lower_level(i).cost_cmpntcls_code);
995: FND_MSG_PUB.Add;
996: RAISE e_lower_level;
997: ELSE
998: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
999: log_msg('Cmpt Cls Id := ' || l_cost_cmpntcls_id);

Line 998: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

994: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_lower_level(i).cost_cmpntcls_code);
995: FND_MSG_PUB.Add;
996: RAISE e_lower_level;
997: ELSE
998: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
999: log_msg('Cmpt Cls Id := ' || l_cost_cmpntcls_id);
1000: END IF;
1001: END IF;
1002: ELSE

Line 1005: FND_MSG_PUB.Add;

1001: END IF;
1002: ELSE
1003: add_header_to_error_stack(p_header_rec);
1004: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
1005: FND_MSG_PUB.Add;
1006: RAISE e_lower_level;
1007: END IF;
1008:
1009: /***************************

Line 1012: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1008:
1009: /***************************
1010: * Validating Analysis Code *
1011: ***************************/
1012: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1013: THEN
1014: log_msg('validating lower level analysis_code('||i||') :' || p_lower_level(i).cost_analysis_code);
1015: END IF;
1016:

Line 1025: FND_MSG_PUB.Add;

1021: THEN
1022: add_header_to_error_stack(p_header_rec);
1023: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
1024: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',p_lower_level(i).cost_analysis_code);
1025: FND_MSG_PUB.Add;
1026: RAISE e_lower_level;
1027: END IF;
1028: ELSE
1029: add_header_to_error_stack(p_header_rec);

Line 1031: FND_MSG_PUB.Add;

1027: END IF;
1028: ELSE
1029: add_header_to_error_stack(p_header_rec);
1030: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
1031: FND_MSG_PUB.Add;
1032: RAISE e_lower_level;
1033: END IF;
1034: END IF;
1035:

Line 1048: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1044: * Component Cost *
1045: * In the form the format mask for this is : 999999999D999999999(999,999,999.999999999) *
1046: * To put that check here, the cost should not be >= 1,000,000,000 *
1047: ***************************************************************************************/
1048: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1049: THEN
1050: log_msg('validating lower level Component Cost('||i||') for format : '||p_lower_level(i).cmpnt_cost);
1051: END IF;
1052: IF (p_lower_level(i).cmpnt_cost <> FND_API.G_MISS_NUM)

Line 1057: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1053: AND (p_lower_level(i).cmpnt_cost IS NOT NULL)
1054: THEN
1055: IF p_lower_level(i).cmpnt_cost >= 1000000000
1056: THEN
1057: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1058: THEN
1059: log_msg('before raising the error...');
1060: END IF;
1061: add_header_to_error_stack(p_header_rec);

Line 1064: FND_MSG_PUB.Add;

1060: END IF;
1061: add_header_to_error_stack(p_header_rec);
1062: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNT_COST') ;
1063: FND_MESSAGE.SET_TOKEN('CMPNT_COST',p_lower_level(i).cmpnt_cost);
1064: FND_MSG_PUB.Add;
1065: RAISE e_lower_level;
1066: END IF ;
1067: ELSIF (p_lower_level(i).cmpnt_cost = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
1068: OR (p_operation = 'INSERT')

Line 1072: FND_MSG_PUB.Add;

1068: OR (p_operation = 'INSERT')
1069: THEN
1070: add_header_to_error_stack(p_header_rec);
1071: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNT_COST_REQ');
1072: FND_MSG_PUB.Add;
1073: RAISE e_lower_level;
1074: END IF;
1075: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1076: THEN

Line 1075: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1071: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNT_COST_REQ');
1072: FND_MSG_PUB.Add;
1073: RAISE e_lower_level;
1074: END IF;
1075: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1076: THEN
1077: log_msg('validating lower level delete_mark('||i||') :' || p_lower_level(i).delete_mark);
1078: END IF;
1079: IF (p_lower_level(i).delete_mark <> FND_API.G_MISS_NUM)

Line 1087: FND_MSG_PUB.Add;

1083: THEN
1084: add_header_to_error_stack(p_header_rec);
1085: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
1086: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_lower_level(i).delete_mark);
1087: FND_MSG_PUB.Add;
1088: RAISE e_lower_level;
1089: END IF;
1090: ELSIF (p_lower_level(i).delete_mark = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
1091: OR (p_operation = 'INSERT')

Line 1095: FND_MSG_PUB.Add;

1091: OR (p_operation = 'INSERT')
1092: THEN
1093: add_header_to_error_stack(p_header_rec);
1094: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
1095: FND_MSG_PUB.Add;
1096: RAISE e_lower_level;
1097: END IF;
1098: IF (p_operation = 'UPDATE') AND (p_lower_level(i).delete_mark = 1)
1099: THEN

Line 1102: FND_MSG_PUB.Add;

1098: IF (p_operation = 'UPDATE') AND (p_lower_level(i).delete_mark = 1)
1099: THEN
1100: add_header_to_error_stack(p_header_rec);
1101: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
1102: FND_MSG_PUB.Add;
1103: RAISE e_lower_level;
1104: END IF;
1105: END IF ;
1106:

Line 1118: FND_MSG_PUB.Add;

1114: THEN
1115: add_header_to_error_stack(p_header_rec);
1116: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_IC_UNIQUE_KEY');
1117: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level(i).cmpntcost_id);
1118: FND_MSG_PUB.Add;
1119: l_cmpntcost_id := p_lower_level(i).cmpntcost_id;
1120: END IF ;
1121: END IF ;
1122: l_idx := l_idx + 1 ;

Line 1133: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1129: x_lower_level(l_idx).delete_mark := 1 ;
1130: ELSE
1131: x_lower_level(l_idx).delete_mark := 0 ;
1132: END IF;
1133: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1134: THEN
1135: log_msg('x_cmpntcost_id('||l_idx||'): '||l_cmpntcost_id);
1136: log_msg('x_cost_cmpntcls_id('||l_idx||'): ' || x_lower_level(l_idx).cost_cmpntcls_id);
1137: log_msg('x_cost_cmpntcls_code('||l_idx||'): ' || x_lower_level(l_idx).cost_cmpntcls_code);

Line 1230: FND_MSG_PUB.initialize;

1226: * Initialize message list if p_init_msg_list is set to TRUE. *
1227: *************************************************************/
1228: IF FND_API.to_Boolean( p_init_msg_list )
1229: THEN
1230: FND_MSG_PUB.initialize;
1231: END IF;
1232:
1233: /*************************************************
1234: * Standard call to check for call compatibility. *

Line 1246: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1242: * Initialize API return status to success *
1243: ******************************************/
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245:
1246: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1247: THEN
1248: log_msg('Beginning Create Item Cost process.');
1249: END IF;
1250:

Line 1253: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1249: END IF;
1250:
1251: G_header_logged := 'N';
1252:
1253: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1254: THEN
1255: log_msg('In public API. This level Count : ' || p_this_level_dtl_tbl.count);
1256: log_msg('In public API. Lower level Count : ' || p_lower_level_dtl_tbl.count);
1257: END IF;

Line 1261: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1257: END IF;
1258:
1259: IF ((p_this_level_dtl_tbl.count > 0) OR (p_lower_level_dtl_tbl.count > 0))
1260: THEN
1261: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1262: THEN
1263: log_msg('Validating input parameters');
1264: END IF;
1265:

Line 1282: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1278: x_user_id => l_user_id,
1279: x_return_status => l_return_status
1280: );
1281:
1282: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1283: THEN
1284: log_msg('Return Status after validating : ' || l_return_status);
1285: END IF;
1286:

Line 1294: FND_MSG_PUB.Add;

1290: IF l_return_status = FND_API.G_RET_STS_ERROR
1291: THEN
1292: add_header_to_error_stack(p_header_rec);
1293: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;
1296: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1297: THEN
1298: add_header_to_error_stack(p_header_rec);

Line 1300: FND_MSG_PUB.Add;

1296: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1297: THEN
1298: add_header_to_error_stack(p_header_rec);
1299: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1300: FND_MSG_PUB.Add;
1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1302: END IF;
1303: END IF;
1304:

Line 1307: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1303: END IF;
1304:
1305: IF ((l_this_level_dtl_tbl.count > 0) OR (l_lower_level_dtl_tbl.count > 0))
1306: THEN
1307: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1308: THEN
1309: log_msg('Calling private API to insert record...');
1310: END IF;
1311: GMF_ITEMCOST_PVT.CREATE_ITEM_COST

Line 1333: FND_MSG_PUB.Add;

1329: IF l_return_status = FND_API.G_RET_STS_ERROR
1330: THEN
1331: add_header_to_error_stack(l_header_rec);
1332: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1333: FND_MSG_PUB.Add;
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: add_header_to_error_stack(l_header_rec);
1337: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

Line 1338: FND_MSG_PUB.Add;

1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: add_header_to_error_stack(l_header_rec);
1337: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1338: FND_MSG_PUB.Add;
1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END IF;
1341: add_header_to_error_stack(l_header_rec);
1342: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');

Line 1344: FND_MSG_PUB.Add;

1340: END IF;
1341: add_header_to_error_stack(l_header_rec);
1342: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
1343: FND_MESSAGE.SET_TOKEN('NUM_ROWS',x_costcmpnt_ids.count);
1344: FND_MSG_PUB.Add;
1345: ELSE
1346: add_header_to_error_stack(l_header_rec);
1347: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1348: FND_MSG_PUB.Add;

Line 1348: FND_MSG_PUB.Add;

1344: FND_MSG_PUB.Add;
1345: ELSE
1346: add_header_to_error_stack(l_header_rec);
1347: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1348: FND_MSG_PUB.Add;
1349: END IF ;
1350: /******************************
1351: * Standard check of p_commit. *
1352: ******************************/

Line 1361: FND_MSG_PUB.Count_And_Get

1357:
1358: /**************************************************************************
1359: * Standard call to get message count and if count is 1, get message info. *
1360: **************************************************************************/
1361: FND_MSG_PUB.Count_And_Get
1362: (
1363: p_count => x_msg_count,
1364: p_data => x_msg_data
1365: );

Line 1370: FND_MSG_PUB.Count_And_Get

1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN
1368: ROLLBACK TO CREATE_ITEM_COST_PUB;
1369: x_return_status := FND_API.G_RET_STS_ERROR ;
1370: FND_MSG_PUB.Count_And_Get
1371: (
1372: p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );

Line 1378: FND_MSG_PUB.Count_And_Get

1374: );
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: ROLLBACK TO CREATE_ITEM_COST_PUB;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: FND_MSG_PUB.Count_And_Get
1379: (
1380: p_count => x_msg_count,
1381: p_data => x_msg_data
1382: );

Line 1386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1382: );
1383: WHEN OTHERS THEN
1384: ROLLBACK TO CREATE_ITEM_COST_PUB;
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1389: END IF;
1390: FND_MSG_PUB.Count_And_Get

Line 1388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);

1384: ROLLBACK TO CREATE_ITEM_COST_PUB;
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1389: END IF;
1390: FND_MSG_PUB.Count_And_Get
1391: (
1392: p_count => x_msg_count,

Line 1390: FND_MSG_PUB.Count_And_Get

1386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1389: END IF;
1390: FND_MSG_PUB.Count_And_Get
1391: (
1392: p_count => x_msg_count,
1393: p_data => x_msg_data
1394: );

Line 1470: FND_MSG_PUB.initialize;

1466: * Initialize message list if p_init_msg_list is set to TRUE. *
1467: *************************************************************/
1468: IF FND_API.to_Boolean( p_init_msg_list )
1469: THEN
1470: FND_MSG_PUB.initialize;
1471: END IF;
1472:
1473: /*************************************************
1474: * Standard call to check for call compatibility. *

Line 1486: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1482: * Initialize API return status to success *
1483: ******************************************/
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1487: THEN
1488: log_msg('Beginning Update Item Cost process.');
1489: END IF;
1490:

Line 1493: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1489: END IF;
1490:
1491: G_header_logged := 'N';
1492:
1493: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1494: THEN
1495: log_msg('In public API. This level Count : ' || p_this_level_dtl_tbl.count);
1496: log_msg('In public API. Lower level Count : ' || p_lower_level_dtl_tbl.count);
1497: END IF;

Line 1501: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1497: END IF;
1498:
1499: IF ((p_this_level_dtl_tbl.count > 0) OR (p_lower_level_dtl_tbl.count > 0))
1500: THEN
1501: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1502: THEN
1503: log_msg('Validating input parameters');
1504: END IF;
1505:

Line 1521: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1517: x_lower_level => l_lower_level_dtl_tbl,
1518: x_user_id => l_user_id,
1519: x_return_status => l_return_status
1520: );
1521: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1522: THEN
1523: log_msg('Return Status after validating : ' || l_return_status);
1524: END IF;
1525:

Line 1533: FND_MSG_PUB.Add;

1529: IF l_return_status = FND_API.G_RET_STS_ERROR
1530: THEN
1531: add_header_to_error_stack(p_header_rec);
1532: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1533: FND_MSG_PUB.Add;
1534: RAISE FND_API.G_EXC_ERROR;
1535: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1536: THEN
1537: add_header_to_error_stack(p_header_rec);

Line 1539: FND_MSG_PUB.Add;

1535: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1536: THEN
1537: add_header_to_error_stack(p_header_rec);
1538: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1539: FND_MSG_PUB.Add;
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542: END IF;
1543:

Line 1546: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1542: END IF;
1543:
1544: IF ((l_this_level_dtl_tbl.count > 0) OR (l_lower_level_dtl_tbl.count > 0))
1545: THEN
1546: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1547: THEN
1548: log_msg('Calling private API to update records...');
1549: END IF;
1550: GMF_ITEMCOST_PVT.UPDATE_ITEM_COST

Line 1570: FND_MSG_PUB.Add;

1566: IF l_return_status = FND_API.G_RET_STS_ERROR
1567: THEN
1568: add_header_to_error_stack(p_header_rec);
1569: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1570: FND_MSG_PUB.Add;
1571: RAISE FND_API.G_EXC_ERROR;
1572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1573: add_header_to_error_stack(p_header_rec);
1574: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

Line 1575: FND_MSG_PUB.Add;

1571: RAISE FND_API.G_EXC_ERROR;
1572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1573: add_header_to_error_stack(p_header_rec);
1574: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1575: FND_MSG_PUB.Add;
1576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1577: END IF;
1578: add_header_to_error_stack(p_header_rec);
1579: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');

Line 1581: FND_MSG_PUB.Add;

1577: END IF;
1578: add_header_to_error_stack(p_header_rec);
1579: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
1580: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_this_level_dtl_tbl.count+l_lower_level_dtl_tbl.count);
1581: FND_MSG_PUB.Add;
1582: ELSE
1583: add_header_to_error_stack(p_header_rec);
1584: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1585: FND_MSG_PUB.Add;

Line 1585: FND_MSG_PUB.Add;

1581: FND_MSG_PUB.Add;
1582: ELSE
1583: add_header_to_error_stack(p_header_rec);
1584: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
1585: FND_MSG_PUB.Add;
1586: END IF ;
1587:
1588: /******************************
1589: * Standard check of p_commit. *

Line 1599: FND_MSG_PUB.Count_And_Get

1595:
1596: /**************************************************************************
1597: * Standard call to get message count and if count is 1, get message info. *
1598: **************************************************************************/
1599: FND_MSG_PUB.Count_And_Get
1600: (
1601: p_count => x_msg_count,
1602: p_data => x_msg_data
1603: );

Line 1608: FND_MSG_PUB.Count_And_Get

1604: EXCEPTION
1605: WHEN FND_API.G_EXC_ERROR THEN
1606: ROLLBACK TO UPDATE_ITEM_COST_PUB;
1607: x_return_status := FND_API.G_RET_STS_ERROR ;
1608: FND_MSG_PUB.Count_And_Get
1609: (
1610: p_count => x_msg_count,
1611: p_data => x_msg_data
1612: );

Line 1616: FND_MSG_PUB.Count_And_Get

1612: );
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO UPDATE_ITEM_COST_PUB;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1616: FND_MSG_PUB.Count_And_Get
1617: (
1618: p_count => x_msg_count,
1619: p_data => x_msg_data
1620: );

Line 1624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1620: );
1621: WHEN OTHERS THEN
1622: ROLLBACK TO UPDATE_ITEM_COST_PUB;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1625: THEN
1626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1627: END IF;
1628: FND_MSG_PUB.Count_And_Get

Line 1626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);

1622: ROLLBACK TO UPDATE_ITEM_COST_PUB;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1625: THEN
1626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1627: END IF;
1628: FND_MSG_PUB.Count_And_Get
1629: (
1630: p_count => x_msg_count,

Line 1628: FND_MSG_PUB.Count_And_Get

1624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1625: THEN
1626: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1627: END IF;
1628: FND_MSG_PUB.Count_And_Get
1629: (
1630: p_count => x_msg_count,
1631: p_data => x_msg_data
1632: );

Line 1706: FND_MSG_PUB.initialize;

1702: * Initialize message list if p_init_msg_list is set to TRUE. *
1703: *************************************************************/
1704: IF FND_API.to_Boolean( p_init_msg_list )
1705: THEN
1706: FND_MSG_PUB.initialize;
1707: END IF;
1708:
1709: /*************************************************
1710: * Standard call to check for call compatibility. *

Line 1722: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1718: * Initialize API return status to success *
1719: ******************************************/
1720: x_return_status := FND_API.G_RET_STS_SUCCESS;
1721:
1722: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1723: THEN
1724: log_msg('Beginning Delete Item Cost process.');
1725: END IF;
1726:

Line 1729: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1725: END IF;
1726:
1727: G_header_logged := 'N';
1728:
1729: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1730: THEN
1731: log_msg('In public API. This level Count : ' || p_this_level_dtl_tbl.count);
1732: log_msg('In public API. Lower level Count : ' || p_lower_level_dtl_tbl.count);
1733: END IF;

Line 1737: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1733: END IF;
1734:
1735: IF ((p_this_level_dtl_tbl.count > 0) OR (p_lower_level_dtl_tbl.count > 0))
1736: THEN
1737: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1738: THEN
1739: log_msg('Validating input parameters');
1740: END IF;
1741:

Line 1758: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1754: x_user_id => l_user_id,
1755: x_return_status => l_return_status
1756: );
1757:
1758: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1759: THEN
1760: log_msg('Return Status after validating : ' || l_return_status);
1761: END IF;
1762:

Line 1770: FND_MSG_PUB.Add;

1766: IF l_return_status = FND_API.G_RET_STS_ERROR
1767: THEN
1768: add_header_to_error_stack(p_header_rec);
1769: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1770: FND_MSG_PUB.Add;
1771: RAISE FND_API.G_EXC_ERROR;
1772: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1773: THEN
1774: add_header_to_error_stack(p_header_rec);

Line 1776: FND_MSG_PUB.Add;

1772: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1773: THEN
1774: add_header_to_error_stack(p_header_rec);
1775: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1776: FND_MSG_PUB.Add;
1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: END IF;
1779: END IF;
1780:

Line 1783: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1779: END IF;
1780:
1781: IF ((l_this_level_dtl_tbl.count > 0) OR (l_lower_level_dtl_tbl.count > 0))
1782: THEN
1783: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1784: THEN
1785: log_msg('Calling private API to delete records...');
1786: END IF;
1787:

Line 1809: FND_MSG_PUB.Add;

1805: IF l_return_status = FND_API.G_RET_STS_ERROR
1806: THEN
1807: add_header_to_error_stack(p_header_rec);
1808: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1809: FND_MSG_PUB.Add;
1810: RAISE FND_API.G_EXC_ERROR;
1811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1812: THEN
1813: add_header_to_error_stack(p_header_rec);

Line 1815: FND_MSG_PUB.Add;

1811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1812: THEN
1813: add_header_to_error_stack(p_header_rec);
1814: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1815: FND_MSG_PUB.Add;
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: END IF;
1818: add_header_to_error_stack(p_header_rec);
1819: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');

Line 1821: FND_MSG_PUB.Add;

1817: END IF;
1818: add_header_to_error_stack(p_header_rec);
1819: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
1820: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_this_level_dtl_tbl.count+l_lower_level_dtl_tbl.count);
1821: FND_MSG_PUB.Add;
1822: ELSE
1823: add_header_to_error_stack(p_header_rec);
1824: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1825: FND_MSG_PUB.Add;

Line 1825: FND_MSG_PUB.Add;

1821: FND_MSG_PUB.Add;
1822: ELSE
1823: add_header_to_error_stack(p_header_rec);
1824: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
1825: FND_MSG_PUB.Add;
1826: END IF ;
1827:
1828: /******************************
1829: * Standard check of p_commit. *

Line 1839: FND_MSG_PUB.Count_And_Get

1835:
1836: /**************************************************************************
1837: * Standard call to get message count and if count is 1, get message info. *
1838: **************************************************************************/
1839: FND_MSG_PUB.Count_And_Get
1840: (
1841: p_count => x_msg_count,
1842: p_data => x_msg_data
1843: );

Line 1848: FND_MSG_PUB.Count_And_Get

1844: EXCEPTION
1845: WHEN FND_API.G_EXC_ERROR THEN
1846: ROLLBACK TO DELETE_ITEM_COST_PUB;
1847: x_return_status := FND_API.G_RET_STS_ERROR ;
1848: FND_MSG_PUB.Count_And_Get
1849: (
1850: p_count => x_msg_count,
1851: p_data => x_msg_data
1852: );

Line 1856: FND_MSG_PUB.Count_And_Get

1852: );
1853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1854: ROLLBACK TO DELETE_ITEM_COST_PUB;
1855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1856: FND_MSG_PUB.Count_And_Get
1857: (
1858: p_count => x_msg_count,
1859: p_data => x_msg_data
1860: );

Line 1864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1860: );
1861: WHEN OTHERS THEN
1862: ROLLBACK TO DELETE_ITEM_COST_PUB;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1865: THEN
1866: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1867: END IF;
1868: FND_MSG_PUB.Count_And_Get

Line 1866: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);

1862: ROLLBACK TO DELETE_ITEM_COST_PUB;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1865: THEN
1866: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1867: END IF;
1868: FND_MSG_PUB.Count_And_Get
1869: (
1870: p_count => x_msg_count,

Line 1868: FND_MSG_PUB.Count_And_Get

1864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1865: THEN
1866: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
1867: END IF;
1868: FND_MSG_PUB.Count_And_Get
1869: (
1870: p_count => x_msg_count,
1871: p_data => x_msg_data
1872: );

Line 1947: FND_MSG_PUB.initialize;

1943: * Initialize message list if p_init_msg_list is set to TRUE. *
1944: *************************************************************/
1945: IF FND_API.to_Boolean( p_init_msg_list )
1946: THEN
1947: FND_MSG_PUB.initialize;
1948: END IF;
1949:
1950: /*************************************************
1951: * Standard call to check for call compatibility. *

Line 1963: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1959: * Initialize API return status to success *
1960: ******************************************/
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962:
1963: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1964: THEN
1965: log_msg('Beginning Get Item Cost API.');
1966: END IF;
1967:

Line 1973: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1969:
1970: /**************************
1971: * Organization Validation *
1972: **************************/
1973: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1974: THEN
1975: log_msg('Validating Organization Id :' || p_header_rec.Organization_id);
1976: END IF;
1977: IF (p_header_rec.organization_id <> FND_API.G_MISS_NUM)

Line 1984: FND_MSG_PUB.Add;

1980: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id) THEN
1981: add_header_to_error_stack(p_header_rec);
1982: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1983: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
1984: FND_MSG_PUB.Add;
1985: RAISE FND_API.G_EXC_ERROR;
1986: END IF;
1987: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.organization_code IS NOT NULL)
1988: THEN

Line 1989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1985: RAISE FND_API.G_EXC_ERROR;
1986: END IF;
1987: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.organization_code IS NOT NULL)
1988: THEN
1989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1990: THEN
1991: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1992: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
1993: FND_MSG_PUB.Add;

Line 1993: FND_MSG_PUB.Add;

1989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1990: THEN
1991: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1992: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
1993: FND_MSG_PUB.Add;
1994: END IF;
1995: END IF;
1996: ELSE
1997: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR)

Line 2006: FND_MSG_PUB.Add;

2002: THEN
2003: add_header_to_error_stack(p_header_rec);
2004: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
2005: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
2006: FND_MSG_PUB.Add;
2007: RAISE FND_API.G_EXC_ERROR;
2008: END IF;
2009: ELSE
2010: add_header_to_error_stack(p_header_rec);

Line 2012: FND_MSG_PUB.Add;

2008: END IF;
2009: ELSE
2010: add_header_to_error_stack(p_header_rec);
2011: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
2012: FND_MSG_PUB.Add;
2013: RAISE FND_API.G_EXC_ERROR;
2014: END IF;
2015: END IF;
2016:

Line 2020: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2016:
2017: /***********************
2018: * Cost TYPE Validation *
2019: ***********************/
2020: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2021: THEN
2022: log_msg('Validating Cost type Id : ' || p_header_rec.cost_type_id);
2023: END IF;
2024: IF (p_header_rec.cost_type_id <> FND_API.G_MISS_NUM)

Line 2031: FND_MSG_PUB.Add;

2027: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_type_id(p_header_rec.cost_type_id) THEN
2028: add_header_to_error_stack(p_header_rec);
2029: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
2030: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
2031: FND_MSG_PUB.Add;
2032: RAISE FND_API.G_EXC_ERROR;
2033: END IF;
2034: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL)
2035: THEN

Line 2036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2032: RAISE FND_API.G_EXC_ERROR;
2033: END IF;
2034: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL)
2035: THEN
2036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2037: THEN
2038: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
2039: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.organization_code);
2040: FND_MSG_PUB.Add;

Line 2040: FND_MSG_PUB.Add;

2036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2037: THEN
2038: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
2039: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.organization_code);
2040: FND_MSG_PUB.Add;
2041: END IF;
2042: END IF;
2043: ELSE
2044: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR)

Line 2052: FND_MSG_PUB.Add;

2048: IF l_header_rec.cost_type_id IS NULL THEN
2049: add_header_to_error_stack(p_header_rec);
2050: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
2051: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
2052: FND_MSG_PUB.Add;
2053: RAISE FND_API.G_EXC_ERROR;
2054: END IF;
2055: ELSE
2056: add_header_to_error_stack(p_header_rec);

Line 2058: FND_MSG_PUB.Add;

2054: END IF;
2055: ELSE
2056: add_header_to_error_stack(p_header_rec);
2057: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
2058: FND_MSG_PUB.Add;
2059: RAISE FND_API.G_EXC_ERROR;
2060: END IF;
2061: END IF;
2062:

Line 2066: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2062:
2063: /***********************
2064: * Period Id Validation *
2065: ***********************/
2066: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2067: THEN
2068: log_msg('validating Period Id : ' || p_header_rec.period_id);
2069: END IF;
2070:

Line 2079: FND_MSG_PUB.Add;

2075: THEN
2076: add_header_to_error_stack(p_header_rec);
2077: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
2078: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
2079: FND_MSG_PUB.Add;
2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;
2082: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
2083: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL))

Line 2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2081: END IF;
2082: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
2083: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL))
2084: THEN
2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2086: THEN
2087: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
2088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
2089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);

Line 2090: FND_MSG_PUB.Add;

2086: THEN
2087: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
2088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
2089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
2090: FND_MSG_PUB.Add;
2091: END IF;
2092: END IF;
2093: ELSE
2094: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

Line 2094: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2090: FND_MSG_PUB.Add;
2091: END IF;
2092: END IF;
2093: ELSE
2094: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2095: THEN
2096: log_msg('Validating Calendar Code : '|| p_header_rec.Calendar_code||' period_code : ' || p_header_rec.period_code);
2097: END IF;
2098:

Line 2106: FND_MSG_PUB.Add;

2102: l_header_rec.period_id := GMF_VALIDATIONS_PVT.Validate_Period_code(p_header_rec.organization_id, p_header_rec.calendar_code,p_header_rec.period_code,p_header_rec.cost_type_id);
2103: ELSE
2104: add_header_to_error_stack(p_header_rec);
2105: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
2106: FND_MSG_PUB.Add;
2107: RAISE FND_API.G_EXC_ERROR;
2108: END IF;
2109: END IF;
2110:

Line 2116: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2112: * Item Validation *
2113: ******************/
2114: IF (p_header_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND (p_header_rec.inventory_item_id IS NOT NULL)
2115: THEN
2116: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2117: THEN
2118: log_msg('Validating Inventory Item Id : ' || p_header_rec.inventory_item_id);
2119: END IF;
2120: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, p_header_rec.organization_id)

Line 2125: FND_MSG_PUB.Add;

2121: THEN
2122: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
2123: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_header_rec.inventory_item_id);
2124: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
2125: FND_MSG_PUB.Add;
2126: RAISE FND_API.G_EXC_ERROR;
2127: END IF;
2128: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
2129: THEN

Line 2130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2126: RAISE FND_API.G_EXC_ERROR;
2127: END IF;
2128: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
2129: THEN
2130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2131: THEN
2132: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
2133: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
2134: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);

Line 2135: FND_MSG_PUB.Add;

2131: THEN
2132: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
2133: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
2134: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
2135: FND_MSG_PUB.Add;
2136: END IF;
2137: END IF;
2138: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
2139: THEN

Line 2140: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2136: END IF;
2137: END IF;
2138: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND (p_header_rec.item_number IS NOT NULL)
2139: THEN
2140: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2141: THEN
2142: log_msg('Validating Item Number : ' || p_header_rec.item_number);
2143: END IF;
2144: l_header_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_header_rec.item_number, p_header_Rec.organization_id);

Line 2145: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2141: THEN
2142: log_msg('Validating Item Number : ' || p_header_rec.item_number);
2143: END IF;
2144: l_header_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_header_rec.item_number, p_header_Rec.organization_id);
2145: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2146: THEN
2147: log_msg('Inventory Item id : ' || p_header_rec.inventory_item_id);
2148: END IF;
2149: IF l_header_rec.inventory_item_id IS NULL

Line 2154: FND_MSG_PUB.Add;

2150: THEN
2151: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
2152: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
2153: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
2154: FND_MSG_PUB.Add;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;
2157: ELSE
2158: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');

Line 2159: FND_MSG_PUB.Add;

2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;
2157: ELSE
2158: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
2159: FND_MSG_PUB.Add;
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2163: /***********************

Line 2166: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2162:
2163: /***********************
2164: * User Name Validation *
2165: ***********************/
2166: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2167: THEN
2168: log_msg('Validating user name : ' || p_header_rec.user_name);
2169: END IF;
2170:

Line 2180: FND_MSG_PUB.Add;

2176: THEN
2177: add_header_to_error_stack(p_header_rec);
2178: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
2179: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
2180: FND_MSG_PUB.Add;
2181: RAISE FND_API.G_EXC_ERROR;
2182: END IF;
2183: ELSE
2184: add_header_to_error_stack(p_header_rec);

Line 2186: FND_MSG_PUB.Add;

2182: END IF;
2183: ELSE
2184: add_header_to_error_stack(p_header_rec);
2185: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
2186: FND_MSG_PUB.Add;
2187: RAISE FND_API.G_EXC_ERROR;
2188: END IF;
2189:
2190: l_header_rec.period_id := nvl(p_header_rec.period_id, l_header_rec.period_id);

Line 2195: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

2191: l_header_rec.cost_type_id := nvl(p_header_rec.cost_type_id, l_header_rec.cost_type_id);
2192: l_header_rec.organization_id := nvl(p_header_rec.organization_id, l_header_rec.organization_id);
2193: l_header_rec.inventory_item_id := nvl(p_header_rec.inventory_item_id, l_header_rec.inventory_item_id);
2194:
2195: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
2196: THEN
2197: log_msg('Calling private API to fetch records...');
2198: END IF;
2199:

Line 2226: FND_MSG_PUB.Count_And_Get

2222:
2223: /**************************************************************************
2224: * Standard call to get message count and if count is 1, get message info. *
2225: **************************************************************************/
2226: FND_MSG_PUB.Count_And_Get
2227: (
2228: p_count => x_msg_count,
2229: p_data => x_msg_data
2230: );

Line 2235: FND_MSG_PUB.Count_And_Get

2231: EXCEPTION
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: ROLLBACK TO GET_ITEM_COST_PUB;
2234: x_return_status := FND_API.G_RET_STS_ERROR ;
2235: FND_MSG_PUB.Count_And_Get
2236: (
2237: p_count => x_msg_count,
2238: p_data => x_msg_data
2239: );

Line 2243: FND_MSG_PUB.Count_And_Get

2239: );
2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2241: ROLLBACK TO GET_ITEM_COST_PUB;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2243: FND_MSG_PUB.Count_And_Get
2244: (
2245: p_count => x_msg_count,
2246: p_data => x_msg_data
2247: );

Line 2251: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2247: );
2248: WHEN OTHERS THEN
2249: ROLLBACK TO GET_ITEM_COST_PUB;
2250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2251: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2252: THEN
2253: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
2254: END IF;
2255: FND_MSG_PUB.Count_And_Get

Line 2253: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);

2249: ROLLBACK TO GET_ITEM_COST_PUB;
2250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2251: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2252: THEN
2253: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
2254: END IF;
2255: FND_MSG_PUB.Count_And_Get
2256: (
2257: p_count => x_msg_count,

Line 2255: FND_MSG_PUB.Count_And_Get

2251: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2252: THEN
2253: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
2254: END IF;
2255: FND_MSG_PUB.Count_And_Get
2256: (
2257: p_count => x_msg_count,
2258: p_data => x_msg_data
2259: );