DBA Data[Home] [Help]

APPS.OE_FLEX_COGS_PUB dependencies on OE_MSG_PUB

Line 121: OE_MSG_PUB.ADD;

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;
123:
124: END IF;
125:

Line 141: OE_MSG_PUB.ADD;

137:
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:

Line 194: OE_MSG_PUB.set_msg_context(

190: FROM OE_ORDER_LINES
191: WHERE LINE_ID = l_line_id;
192:
193: -- Exception Management begin Set message context
194: OE_MSG_PUB.set_msg_context(
195: p_entity_code => 'LINE'
196: ,p_entity_id => l_line_id
197: ,p_header_id => l_header_id
198: ,p_line_id => l_line_id

Line 213: OE_MSG_PUB.set_msg_context(

209: EXCEPTION
210:
211: WHEN NO_DATA_FOUND THEN
212: -- Set message context
213: OE_MSG_PUB.set_msg_context(
214: p_entity_code => 'LINE'
215: ,p_entity_id => l_line_id
216: ,p_line_id => l_line_id
217: );

Line 221: OE_MSG_PUB.ADD;

217: );
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';

Line 238: OE_MSG_PUB.ADD;

234: IF l_ship_from_org_id IS NULL THEN
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:

Line 413: OE_MSG_PUB.ADD;

409: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
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;

Line 423: OE_MSG_PUB.ADD;

419:
420: WHEN NO_DATA_FOUND THEN
421: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);
423: OE_MSG_PUB.ADD;
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

Line 425: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

421: FND_MESSAGE.SET_NAME('ONT','OE_COGS_COA_ID_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_ship_from_org_id);
423: OE_MSG_PUB.ADD;
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

Line 427: x_msg_data := OE_MSG_PUB.Get

423: OE_MSG_PUB.ADD;
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;

Line 429: , p_msg_index => OE_MSG_PUB.G_LAST

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;
433: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end

Line 431: OE_MSG_PUB.Reset;

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;
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);

Line 439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

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
443: , p_msg_index => OE_MSG_PUB.G_LAST

Line 441: x_msg_data := OE_MSG_PUB.Get

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
443: , p_msg_index => OE_MSG_PUB.G_LAST
444: );
445: OE_MSG_PUB.Reset;

Line 443: , p_msg_index => OE_MSG_PUB.G_LAST

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;
447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end

Line 445: OE_MSG_PUB.Reset;

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;
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);

Line 456: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

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
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

Line 458: x_msg_data := OE_MSG_PUB.Get

454: -- Get message count and data
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;

Line 460: , p_msg_index => OE_MSG_PUB.G_LAST

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;
464: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end

Line 462: OE_MSG_PUB.Reset;

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;
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);

Line 471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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)
472: THEN
473: OE_MSG_PUB.Add_Exc_Msg
474: ( G_PKG_NAME
475: , 'Start_Process'

Line 473: OE_MSG_PUB.Add_Exc_Msg

469: WHEN OTHERS THEN
470:
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: OE_MSG_PUB.Add_Exc_Msg
474: ( G_PKG_NAME
475: , 'Start_Process'
476: );
477:

Line 482: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

478: END IF;
479:
480: -- Get message count and data
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

Line 484: x_msg_data := OE_MSG_PUB.Get

480: -- Get message count and data
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;

Line 486: , p_msg_index => OE_MSG_PUB.G_LAST

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;
490:

Line 488: OE_MSG_PUB.Reset;

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;
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);