36: p_msg_text IN VARCHAR2
37: )
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:
37: )
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
69: BEGIN
70: IF G_header_logged = 'N'
71: THEN
72: G_header_logged := 'Y';
73: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEMCOST_HEADER');
74: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
70: IF G_header_logged = 'N'
71: THEN
72: G_header_logged := 'Y';
73: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEMCOST_HEADER');
74: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
71: THEN
72: G_header_logged := 'Y';
73: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEMCOST_HEADER');
74: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
79: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header.calendar_code);
72: G_header_logged := 'Y';
73: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEMCOST_HEADER');
74: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
79: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header.calendar_code);
80: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
73: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEMCOST_HEADER');
74: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
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);
74: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
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);
75: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header.organization_code);
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
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;
76: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_header.inventory_item_id);
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
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;
77: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER',p_header.item_number);
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
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;
78: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
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:
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
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;
230: END IF;
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)
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;
245: END IF;
246: END IF;
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;
245: END IF;
246: END IF;
247: ELSE
255: x_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
256: IF x_header_rec.organization_id IS NULL
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
256: IF x_header_rec.organization_id IS NULL
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
266: END IF;
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;
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
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;
286: END IF;
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)
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;
301: END IF;
302: END IF;
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;
301: END IF;
302: END IF;
303: ELSE
310: END IF;
311: x_header_rec.cost_Type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);
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
311: x_header_rec.cost_Type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);
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
321: END IF;
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;
341: END IF;
342: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
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;
342: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
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))
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);
358: FND_MSG_PUB.Add;
359: END IF;
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);
358: FND_MSG_PUB.Add;
359: END IF;
360: END IF;
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);
358: FND_MSG_PUB.Add;
359: END IF;
360: END IF;
361: ELSE
368: THEN
369: x_header_rec.period_id := GMF_VALIDATIONS_PVT.Validate_Period_code(x_header_rec.organization_id, p_header_rec.calendar_code,p_header_rec.period_code, x_header_rec.cost_Type_id);
370: IF nvl(x_header_rec.period_id, -1) <= 0 THEN
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;
369: x_header_rec.period_id := GMF_VALIDATIONS_PVT.Validate_Period_code(x_header_rec.organization_id, p_header_rec.calendar_code,p_header_rec.period_code, x_header_rec.cost_Type_id);
370: IF nvl(x_header_rec.period_id, -1) <= 0 THEN
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
370: IF nvl(x_header_rec.period_id, -1) <= 0 THEN
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
380: END IF;
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;
399: END;
400: IF l_period_status IS NULL
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'
400: IF l_period_status IS NULL
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
408: THEN
409: IF p_operation IN ('UPDATE','DELETE')
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 ;
409: IF p_operation IN ('UPDATE','DELETE')
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'
416: END IF ;
417: ELSIF l_period_status = 'C'
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;
417: ELSIF l_period_status = 'C'
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:
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)
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;
434: END IF;
435: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, x_header_Rec.organization_id)
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;
435: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, x_header_Rec.organization_id)
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)
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;
450: END IF;
451: END IF;
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;
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)
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);
459: IF x_header_rec.inventory_item_id IS NULL
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;
458: x_header_rec.inventory_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(p_header_rec.item_number, x_header_Rec.organization_id);
459: IF x_header_rec.inventory_item_id IS NULL
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
459: IF x_header_rec.inventory_item_id IS NULL
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);
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);
487:
488: IF l_rollover_ind <> 0
489: THEN
490: add_header_to_error_stack(p_header_rec);
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_CANNT_INSERT_CMPTS');
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);
488: IF l_rollover_ind <> 0
489: THEN
490: add_header_to_error_stack(p_header_rec);
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_CANNT_INSERT_CMPTS');
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;
489: THEN
490: add_header_to_error_stack(p_header_rec);
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_CANNT_INSERT_CMPTS');
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;
490: add_header_to_error_stack(p_header_rec);
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_CANNT_INSERT_CMPTS');
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 ;
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_CANNT_INSERT_CMPTS');
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 ;
512: GMA_GLOBAL_GRP.Get_who( p_user_name => p_header_rec.user_name, x_user_id => x_user_id);
513: IF x_user_id = -1
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;
513: IF x_user_id = -1
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
519: RAISE FND_API.G_EXC_ERROR;
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);
568: AND ((p_this_level(i).cmpntcost_id <> FND_API.G_MISS_NUM)
569: OR (p_this_level(i).cmpntcost_id IS NOT NULL)))
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
569: OR (p_this_level(i).cmpntcost_id IS NOT NULL)))
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:
605: GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_this_level(i).cost_cmpntcls_id,l_cost_cmpntcls_code,l_usage_ind);
606: IF l_usage_ind IS NULL
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;
606: IF l_usage_ind IS NULL
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 ;
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);
623: FND_MSG_PUB.Add;
624: END IF;
625: END IF;
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);
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)
641: ) ;
642: IF l_cost_cmpntcls_id IS NULL
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
642: IF l_cost_cmpntcls_id IS NULL
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
652: END IF;
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:
670: THEN
671: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_this_level(i).cost_analysis_code)
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;
671: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_this_level(i).cost_analysis_code)
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
677: RAISE e_this_level;
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 ;
712: THEN
713: log_msg('before raising the error...');
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 ;
713: log_msg('before raising the error...');
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')
721: ELSIF (p_this_level(i).cmpnt_cost = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
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:
741: THEN
742: IF (p_this_level(i).burden_ind NOT IN (0,1) )
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;
742: IF (p_this_level(i).burden_ind NOT IN (0,1) )
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 )
749: END IF;
750: IF (p_this_level(i).burden_ind = 1) AND ( l_usage_ind <>2 )
751: THEN
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;
750: IF (p_this_level(i).burden_ind = 1) AND ( l_usage_ind <>2 )
751: THEN
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 ;
751: THEN
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')
759: ELSIF (p_this_level(i).burden_ind = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
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:
781: THEN
782: IF ((p_this_level(i).rmcalc_type NOT IN (1, 2, 3, 4, 5)) OR (p_this_level(i).rmcalc_type IS NULL))
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
782: IF ((p_this_level(i).rmcalc_type NOT IN (1, 2, 3, 4, 5)) OR (p_this_level(i).rmcalc_type IS NULL))
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 ;
804: THEN
805: IF p_this_level(i).delete_mark NOT IN (0,1)
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;
805: IF p_this_level(i).delete_mark NOT IN (0,1)
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')
813: ELSIF (p_this_level(i).delete_mark = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
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)
820: END IF;
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 ;
835: AND ((p_this_level(i).cmpntcost_id <> FND_API.G_MISS_NUM)
836: OR (p_this_level(i).cmpntcost_id IS NOT NULL)))
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 ;
836: OR (p_this_level(i).cmpntcost_id IS NOT NULL)))
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 ;
932: AND ((p_lower_level(i).cmpntcost_id <> FND_API.G_MISS_NUM)
933: OR (p_lower_level(i).cmpntcost_id IS NOT NULL)))
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
933: OR (p_lower_level(i).cmpntcost_id IS NOT NULL)))
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')
958: END IF;
959: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_lower_level(i).cost_cmpntcls_id)
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;
959: IF NOT GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Id (p_lower_level(i).cost_cmpntcls_id)
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 ;
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);
980: FND_MSG_PUB.Add;
981: END IF;
982: END IF;
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);
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)
989: END IF;
990: l_cost_cmpntcls_id := GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Code (p_lower_level(i).cost_cmpntcls_code);
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
990: l_cost_cmpntcls_id := GMF_VALIDATIONS_PVT.Validate_Cost_Cmpntcls_Code (p_lower_level(i).cost_cmpntcls_code);
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
1000: END IF;
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:
1019: THEN
1020: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_lower_level(i).cost_analysis_code)
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;
1020: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_lower_level(i).cost_analysis_code)
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
1026: RAISE e_lower_level;
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;
1058: THEN
1059: log_msg('before raising the error...');
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 ;
1059: log_msg('before raising the error...');
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')
1067: ELSIF (p_lower_level(i).cmpnt_cost = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
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
1081: THEN
1082: IF p_lower_level(i).delete_mark NOT IN (0,1)
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;
1082: IF p_lower_level(i).delete_mark NOT IN (0,1)
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')
1090: ELSIF (p_lower_level(i).delete_mark = FND_API.G_MISS_NUM AND p_operation = 'UPDATE')
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)
1097: END IF;
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 ;
1112: AND ((p_lower_level(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1113: OR (p_lower_level(i).cmpntcost_id IS NOT NULL)))
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 ;
1113: OR (p_lower_level(i).cmpntcost_id IS NOT NULL)))
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 ;
1289: *****************************************/
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
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);
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;
1328: ****************************************/
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);
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');
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);
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');
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);
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');
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');
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;
1349: END IF ;
1350: /******************************
1351: * Standard check of p_commit. *
1528: *****************************************/
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
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);
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;
1565: ****************************************/
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);
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');
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);
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');
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);
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');
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');
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;
1586: END IF ;
1587:
1588: /******************************
1765: *****************************************/
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
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);
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;
1804: ****************************************/
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
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);
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);
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');
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);
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');
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');
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;
1826: END IF ;
1827:
1828: /******************************
1978: AND (p_header_rec.organization_id IS NOT NULL)
1979: THEN
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;
1979: THEN
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)
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;
1994: END IF;
1995: END IF;
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;
1994: END IF;
1995: END IF;
1996: ELSE
2000: l_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
2001: IF l_header_rec.organization_id IS NULL
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;
2001: IF l_header_rec.organization_id IS NULL
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
2007: RAISE FND_API.G_EXC_ERROR;
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;
2025: AND (p_header_rec.cost_type_id IS NOT NULL)
2026: THEN
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;
2026: THEN
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)
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;
2041: END IF;
2042: END IF;
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;
2041: END IF;
2042: END IF;
2043: ELSE
2046: THEN
2047: l_header_rec.cost_type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);
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;
2047: l_header_rec.cost_type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);
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
2053: RAISE FND_API.G_EXC_ERROR;
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;
2073: THEN
2074: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
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;
2074: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)
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))
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);
2090: FND_MSG_PUB.Add;
2091: END IF;
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);
2090: FND_MSG_PUB.Add;
2091: END IF;
2092: END IF;
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);
2090: FND_MSG_PUB.Add;
2091: END IF;
2092: END IF;
2093: ELSE
2101: THEN
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;
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)
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;
2119: END IF;
2120: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, p_header_rec.organization_id)
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;
2120: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, p_header_rec.organization_id)
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)
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);
2135: FND_MSG_PUB.Add;
2136: END IF;
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);
2135: FND_MSG_PUB.Add;
2136: END IF;
2137: END IF;
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);
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)
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
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;
2148: END IF;
2149: IF l_header_rec.inventory_item_id IS NULL
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;
2149: IF l_header_rec.inventory_item_id IS NULL
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
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');
2159: FND_MSG_PUB.Add;
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2174: GMA_GLOBAL_GRP.Get_who( p_user_name => p_header_rec.user_name, x_user_id => l_user_id);
2175: IF l_user_id = -1
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;
2175: IF l_user_id = -1
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
2181: RAISE FND_API.G_EXC_ERROR;
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: