DBA Data[Home] [Help]

APPS.OE_LINE_REPRICE dependencies on OE_MSG_PUB

Line 49: OE_MSG_PUB.Add;

45: END IF;
46: IF NVL(l_event_rec.modifier_level_code, 'ORDER') <> 'LINE' THEN
47: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
48: FND_MESSAGE.SET_NAME('ONT','ONT_REPRICE_INVALID_EVENT');
49: OE_MSG_PUB.Add;
50: oe_line_reprice.set_reprice_status('REPRICE_INVALID_SETUP', p_line_rec.line_id);
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: EXIT;
53: END IF;

Line 81: OE_MSG_PUB.Add;

77: IF l_line_rec.Pricing_Date IS NULL THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: FND_MESSAGE.SET_NAME('ONT','ONT_REPRICE_INVALID_DATE');
80: oe_line_reprice.set_reprice_status('REPRICE_INVALID_SETUP', p_line_rec.line_id);
81: OE_MSG_PUB.Add;
82: return;
83: -- do not raise error, instead, exit out of Reprice activity.
84: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;

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

121: EXCEPTION
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124:
125: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
126: THEN
127: OE_MSG_PUB.Add_Exc_Msg
128: ( G_PKG_NAME,
129: 'Reprice_Line'

Line 127: OE_MSG_PUB.Add_Exc_Msg

123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124:
125: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
126: THEN
127: OE_MSG_PUB.Add_Exc_Msg
128: ( G_PKG_NAME,
129: 'Reprice_Line'
130: );
131: END IF;

Line 138: OE_MSG_PUB.set_msg_context(

134: x_return_status := FND_API.G_RET_STS_ERROR;
135: WHEN OTHERS THEN
136: oe_line_reprice.set_reprice_status('REPRICE_UNEXPECTED_ERROR',p_line_rec.line_id);
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: OE_MSG_PUB.set_msg_context(
139: p_entity_code => 'LINE'
140: ,p_entity_id => l_line_rec.line_id
141: ,p_header_id => l_line_rec.header_id
142: ,p_line_id => l_line_rec.line_id

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

153: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
154: oe_debug_pub.add('In others of Reprice line');
155: END IF;
156:
157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
158: THEN
159: OE_MSG_PUB.Add_Exc_Msg
160: ( G_PKG_NAME,
161: 'Reprice_Line'

Line 159: OE_MSG_PUB.Add_Exc_Msg

155: END IF;
156:
157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
158: THEN
159: OE_MSG_PUB.Add_Exc_Msg
160: ( G_PKG_NAME,
161: 'Reprice_Line'
162: );
163: END IF;

Line 214: OE_MSG_PUB.set_msg_context(

210: l_orig_sys_line_ref, l_orig_sys_shipment_ref, l_change_sequence,
211: l_source_document_type_id, l_source_document_id, l_source_document_line_id
212: from oe_order_lines_all
213: where line_id = to_number(p_item_key);
214: OE_MSG_PUB.set_msg_context(
215: p_entity_code => 'LINE'
216: ,p_entity_id => to_number(p_item_key)
217: ,p_header_id => l_header_id
218: ,p_line_id => to_number(p_item_key)

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

235: END IF;
236: x_attribute_value := 'NONE';
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: ELSE
239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: OE_MSG_PUB.Add_Exc_Msg
242: ( G_PKG_NAME
243: , 'Get_Activity_Attribute'

Line 241: OE_MSG_PUB.Add_Exc_Msg

237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: ELSE
239: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: OE_MSG_PUB.Add_Exc_Msg
242: ( G_PKG_NAME
243: , 'Get_Activity_Attribute'
244: );
245: END IF;

Line 293: OE_MSG_PUB.set_msg_context(

289:
290: OE_Line_Util.Query_Row(p_line_id => p_line_id,
291: x_line_rec => l_line_rec);
292:
293: OE_MSG_PUB.set_msg_context(
294: p_entity_code => 'LINE'
295: ,p_entity_id => l_line_rec.line_id
296: ,p_header_id => l_line_rec.header_id
297: ,p_line_id => l_line_rec.line_id

Line 431: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

427: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
428: END IF;
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
430: x_result_out := 'INCOMPLETE';
431: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: OE_MSG_PUB.Add_Exc_Msg
434: ( G_PKG_NAME,
435: 'Process_Repricing'

Line 433: OE_MSG_PUB.Add_Exc_Msg

429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
430: x_result_out := 'INCOMPLETE';
431: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: OE_MSG_PUB.Add_Exc_Msg
434: ( G_PKG_NAME,
435: 'Process_Repricing'
436: );
437: END IF; */

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

447: END IF;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: x_result_out := 'INCOMPLETE';
450: oe_line_reprice.set_reprice_status('REPRICE_UNEXPECTED_ERROR', p_line_id);
451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: OE_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME
455: , 'Process_Repricing'

Line 453: OE_MSG_PUB.Add_Exc_Msg

449: x_result_out := 'INCOMPLETE';
450: oe_line_reprice.set_reprice_status('REPRICE_UNEXPECTED_ERROR', p_line_id);
451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
452: THEN
453: OE_MSG_PUB.Add_Exc_Msg
454: ( G_PKG_NAME
455: , 'Process_Repricing'
456: );
457: END IF;

Line 461: OE_MSG_PUB.Count_And_Get

457: END IF;
458:
459: -- Get message count and data
460:
461: OE_MSG_PUB.Count_And_Get
462: ( p_count => x_msg_count
463: , p_data => x_msg_data
464: );
465: