DBA Data[Home] [Help]

APPS.OE_FLEX_COGS_PUB dependencies on FND_API

Line 107: IF NOT FND_API.Compatible_API_Call

103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);
105: END IF;
106:
107: IF NOT FND_API.Compatible_API_Call
108: ( l_api_version_number
109: , p_api_version_number
110: , l_api_name
111: , G_PKG_NAME

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: , l_api_name
111: , G_PKG_NAME
112: )
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: IF p_line_id IS NULL OR
118: p_line_id = FND_API.G_MISS_NUM THEN

Line 118: p_line_id = FND_API.G_MISS_NUM THEN

114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: IF p_line_id IS NULL OR
118: p_line_id = FND_API.G_MISS_NUM THEN
119:
120: FND_MESSAGE.SET_NAME('ONT','OE_COGS_LINE_ID_MISSING');
121: OE_MSG_PUB.ADD;
122: RAISE FND_API.G_EXC_ERROR;

Line 122: RAISE FND_API.G_EXC_ERROR;

118: p_line_id = FND_API.G_MISS_NUM THEN
119:
120: FND_MESSAGE.SET_NAME('ONT','OE_COGS_LINE_ID_MISSING');
121: OE_MSG_PUB.ADD;
122: RAISE FND_API.G_EXC_ERROR;
123:
124: END IF;
125:
126: g_stmt:='5';

Line 142: RAISE FND_API.G_EXC_ERROR;

138: WHEN NO_DATA_FOUND THEN
139: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
140: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
141: OE_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143:
144: END;
145:
146: IF l_line_category_code = 'RETURN' and

Line 222: RAISE FND_API.G_EXC_ERROR;

218:
219: FND_MESSAGE.SET_NAME('ONT','OE_COGS_INVALID_LINE_ID');
220: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
221: OE_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;
223: END;
224:
225: g_stmt:='15';
226:

Line 239: RAISE FND_API.G_EXC_ERROR;

235:
236: FND_MESSAGE.SET_NAME('ONT','OE_COGS_WAREHOUSE_MISSING');
237: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
238: OE_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240:
241: END IF;
242:
243: g_stmt:='20';

Line 388: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

384:
385: Exception
386: When Others Then
387: oe_debug_pub.add(SQLERRM||':'||g_stmt);
388: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
389: End;
390:
391: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606
392: fnd_message.set_encoded(l_errmsg);

Line 406: l_return_status := FND_API.G_RET_STS_SUCCESS;

402: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
403: END IF;
404:
405: IF l_result THEN
406: l_return_status := FND_API.G_RET_STS_SUCCESS;
407: ELSE
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
410: END IF;

Line 414: RAISE FND_API.G_EXC_ERROR;

410: END IF;
411: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
412: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
413: OE_MSG_PUB.ADD;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606
417: RETURN l_return_status;
418: EXCEPTION

Line 428: ( p_encoded => FND_API.G_FALSE

424:
425: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
426: IF x_msg_count > 0 THEN
427: x_msg_data := OE_MSG_PUB.Get
428: ( p_encoded => FND_API.G_FALSE
429: , p_msg_index => OE_MSG_PUB.G_LAST
430: );
431: OE_MSG_PUB.Reset;
432: END IF;

Line 436: return FND_API.G_RET_STS_ERROR;

432: END IF;
433: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end
434:
435: oe_debug_pub.add(SQLERRM||':'||g_stmt);
436: return FND_API.G_RET_STS_ERROR;
437:
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
440: IF x_msg_count > 0 THEN

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434:
435: oe_debug_pub.add(SQLERRM||':'||g_stmt);
436: return FND_API.G_RET_STS_ERROR;
437:
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
440: IF x_msg_count > 0 THEN
441: x_msg_data := OE_MSG_PUB.Get
442: ( p_encoded => FND_API.G_FALSE

Line 442: ( p_encoded => FND_API.G_FALSE

438: WHEN FND_API.G_EXC_ERROR THEN
439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
440: IF x_msg_count > 0 THEN
441: x_msg_data := OE_MSG_PUB.Get
442: ( p_encoded => FND_API.G_FALSE
443: , p_msg_index => OE_MSG_PUB.G_LAST
444: );
445: OE_MSG_PUB.Reset;
446: END IF;

Line 450: return FND_API.G_RET_STS_ERROR;

446: END IF;
447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end
448:
449: oe_debug_pub.add(SQLERRM||':'||g_stmt);
450: return FND_API.G_RET_STS_ERROR;
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: -- Get message count and data

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448:
449: oe_debug_pub.add(SQLERRM||':'||g_stmt);
450: return FND_API.G_RET_STS_ERROR;
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: -- Get message count and data
455:
456: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

Line 459: ( p_encoded => FND_API.G_FALSE

455:
456: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
457: IF x_msg_count > 0 THEN
458: x_msg_data := OE_MSG_PUB.Get
459: ( p_encoded => FND_API.G_FALSE
460: , p_msg_index => OE_MSG_PUB.G_LAST
461: );
462: OE_MSG_PUB.Reset;
463: END IF;

Line 467: return FND_API.G_RET_STS_UNEXP_ERROR ;

463: END IF;
464: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
465:
466: oe_debug_pub.add(SQLERRM||':'||g_stmt);
467: return FND_API.G_RET_STS_UNEXP_ERROR ;
468:
469: WHEN OTHERS THEN
470:
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 485: ( p_encoded => FND_API.G_FALSE

481:
482: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start
483: IF x_msg_count > 0 THEN
484: x_msg_data := OE_MSG_PUB.Get
485: ( p_encoded => FND_API.G_FALSE
486: , p_msg_index => OE_MSG_PUB.G_LAST
487: );
488: OE_MSG_PUB.Reset;
489: END IF;

Line 493: return FND_API.G_RET_STS_UNEXP_ERROR;

489: END IF;
490:
491: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
492: oe_debug_pub.add(SQLERRM||':'||g_stmt);
493: return FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: END Start_Process; /* START_PROCESS */
496:
497: /*===========================================================================+