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.OE_LINE_REPRICE dependencies on FND_API

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: IF l_debug_level > 0 THEN
37: oe_debug_pub.add( 'ENTERING OE_LINE_REPRICE.REPRICE_LINE '|| TO_CHAR ( P_LINE_REC.LINE_ID ) , 1 ) ;
38: END IF;
39:
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: -- check if repricing event is LINE level event
42: FOR l_event_rec IN check_event_cur(p_repricing_event) LOOP
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'EVENT LEVEL CODE IS: '||L_EVENT_REC.MODIFIER_LEVEL_CODE , 1 ) ;

Line 47: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'EVENT LEVEL CODE IS: '||L_EVENT_REC.MODIFIER_LEVEL_CODE , 1 ) ;
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;

Line 51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
54: END LOOP;
55:

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

74: oe_debug_pub.add( 'REPRICING DATE IS: '||P_REPRICING_DATE , 1 ) ;
75: END IF;
76:
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;

Line 84: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
86:
87: l_Price_Control_Rec.pricing_event := p_Repricing_Event;
88: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

Line 109: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

105: ,x_Line_Tbl => l_x_Line_Tbl
106: ,p_honor_price_flag => p_honor_price_flag);
107:
108:
109: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
110: oe_line_reprice.set_reprice_status('REPRICE_PRICING_ERROR', p_line_rec.line_id);
111: END IF;
112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

109: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
110: oe_line_reprice.set_reprice_status('REPRICE_PRICING_ERROR', p_line_rec.line_id);
111: END IF;
112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: oe_line_reprice.set_reprice_status('REPRICE_PRICING_ERROR', p_line_rec.line_id);
111: END IF;
112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:

Line 115: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

111: END IF;
112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: x_return_status := l_return_status;

Line 116: RAISE FND_API.G_EXC_ERROR;

112:
113: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: x_return_status := l_return_status;
120:

Line 122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

118:
119: x_return_status := l_return_status;
120:
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

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

119: x_return_status := l_return_status;
120:
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

Line 133: WHEN FND_API.G_EXC_ERROR THEN

129: 'Reprice_Line'
130: );
131: END IF;
132:
133: WHEN FND_API.G_EXC_ERROR THEN
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 ;

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: );
131: END IF;
132:
133: WHEN FND_API.G_EXC_ERROR THEN
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(

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

133: WHEN FND_API.G_EXC_ERROR THEN
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

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: l_source_document_line_id NUMBER;
198: BEGIN
199: x_attribute_value := wf_engine.GetActivityAttrText(p_item_type,p_item_key,p_activity_id,p_Reprice_attr_name);
200:
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: oe_line_reprice.set_reprice_status('REPRICE_UNEXPECTED_ERROR',to_number(p_item_key));

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
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

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

242: ( G_PKG_NAME
243: , 'Get_Activity_Attribute'
244: );
245: END IF;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: END IF;
248:
249: END Get_Activity_Attribute;
250:

Line 341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

337: x_attribute_value => l_Repricing_date,
338: x_return_status => l_return_status
339: );
340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338: x_return_status => l_return_status
339: );
340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:

Line 343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

339: );
340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: IF l_debug_level > 0 THEN

Line 344: RAISE FND_API.G_EXC_ERROR;

340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'REPRICING DATE : '|| L_REPRICING_DATE , 3 ) ;

Line 362: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

358: x_attribute_value => l_Repricing_Event,
359: x_return_status => l_return_status
360: );
361:
362: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: x_return_status => l_return_status
360: );
361:
362: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:

Line 364: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

360: );
361:
362: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: IF l_Repricing_Event IS NULL THEN

Line 365: RAISE FND_API.G_EXC_ERROR;

361:
362: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: IF l_Repricing_Event IS NULL THEN
369: l_Repricing_Event := 'REPRICE_LINE';

Line 386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

382: x_attribute_value => l_Honor_Price_Flag,
383: x_return_status => l_return_status
384: );
385:
386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: x_return_status => l_return_status
384: );
385:
386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:

Line 388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

384: );
385:
386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:
392: IF l_Honor_Price_Flag IS NULL THEN

Line 389: RAISE FND_API.G_EXC_ERROR;

385:
386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:
392: IF l_Honor_Price_Flag IS NULL THEN
393: l_Honor_Price_Flag := 'Y';

Line 413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add( 'RETURN STATUS FROM REPRICE LINE : '||L_RETURN_STATUS , 3 ) ;
411: END IF;
412:
413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: oe_debug_pub.add( 'RETURN STATUS FROM REPRICE LINE : '||L_RETURN_STATUS , 3 ) ;
411: END IF;
412:
413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:

Line 415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

411: END IF;
412:
413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:
419:

Line 416: RAISE FND_API.G_EXC_ERROR;

412:
413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:
419:
420: IF l_debug_level > 0 THEN

Line 425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

421: oe_debug_pub.add( 'EXITING FROM OE_LINE_REPRICE.PROCESS_REPRICING : '||X_RETURN_STATUS , 1 ) ;
422: END IF;
423:
424: EXCEPTION
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: IF l_debug_level > 0 THEN
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 ;

Line 429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: IF l_debug_level > 0 THEN
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

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: 'Process_Repricing'
436: );
437: END IF; */
438:
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_result_out := 'INCOMPLETE';
442: WHEN OTHERS THEN
443: IF l_debug_level > 0 THEN

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: );
437: END IF; */
438:
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_result_out := 'INCOMPLETE';
442: WHEN OTHERS THEN
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add('In others of Process_Reprice ');

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

444: oe_debug_pub.add('In others of Process_Reprice ');
445: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
446: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
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