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_OTA_UTIL dependencies on FND_API

Line 4: G_OTA_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;

1: Package body OE_OTA_UTIL As
2: /* $Header: OEXUOTAB.pls 120.0 2005/06/01 01:01:32 appldev noship $ */
3:
4: G_OTA_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
5:
6: Function Get_Product_Status(p_application_id NUMBER)
7: RETURN VARCHAR2 IS
8: l_ret_val BOOLEAN;

Line 17: AND G_OTA_STATUS = FND_API.G_MISS_CHAR)

13: --
14: BEGIN
15:
16: if (p_application_id = 810
17: AND G_OTA_STATUS = FND_API.G_MISS_CHAR)
18: then
19: IF l_debug_level > 0 THEN
20: oe_debug_pub.add( 'GET OTA PROD. STATUS' ) ;
21: END IF;

Line 103: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'JPN: OTA RETURN STATUS IS: ' || L_RETURN_STATUS ) ;
101: END IF;
102:
103: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'NOTIFY_OTA API - UNEXPECTED ERROR' ) ;
106: END IF;
107: IF l_debug_level > 0 THEN

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;
109: END IF;
110: /* OE_DEBUG_PUB.ADD('Notify OC error msg is: ' || substr(x_msg_data, 1,200)); */
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'NOTIFY_OTA API - ERROR' ) ;
115: END IF;

Line 112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

108: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;
109: END IF;
110: /* OE_DEBUG_PUB.ADD('Notify OC error msg is: ' || substr(x_msg_data, 1,200)); */
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'NOTIFY_OTA API - ERROR' ) ;
115: END IF;
116: IF l_debug_level > 0 THEN

Line 119: RAISE FND_API.G_EXC_ERROR;

115: END IF;
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;
118: END IF;
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:
122: END IF; -- API exists
123:

Line 127: WHEN FND_API.G_EXC_ERROR THEN

123:
124: EXCEPTION
125:
126:
127: WHEN FND_API.G_EXC_ERROR THEN
128:
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125:
126:
127: WHEN FND_API.G_EXC_ERROR THEN
128:
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: WHEN FND_API.G_EXC_ERROR THEN
128:
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134:
135: WHEN OTHERS THEN

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

129: x_return_status := FND_API.G_RET_STS_ERROR;
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134:
135: WHEN OTHERS THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134:
135: WHEN OTHERS THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: OE_MSG_PUB.Add_Exc_Msg

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: ( G_PKG_NAME
143: , 'NOTIFY_OTA'
144: );
145: END IF;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147:
148: END Notify_OTA;
149:
150:

Line 199: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

195:
196: x_return_status := l_return_status;
197: x_valid := l_valid;
198:
199: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( 'GET_ENROLLMENT_STATUS API - UNEXPECTED ERROR' ) ;
202: END IF;
203: IF l_debug_level > 0 THEN

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202: END IF;
203: IF l_debug_level > 0 THEN
204: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;
205: END IF;
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
208: IF l_debug_level > 0 THEN
209: oe_debug_pub.add( 'GET_ENROLLMENT_STATUS API - ERROR' ) ;
210: END IF;

Line 207: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

203: IF l_debug_level > 0 THEN
204: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;
205: END IF;
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
208: IF l_debug_level > 0 THEN
209: oe_debug_pub.add( 'GET_ENROLLMENT_STATUS API - ERROR' ) ;
210: END IF;
211: IF l_debug_level > 0 THEN

Line 214: RAISE FND_API.G_EXC_ERROR;

210: END IF;
211: IF l_debug_level > 0 THEN
212: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;
213: END IF;
214: RAISE FND_API.G_EXC_ERROR;
215:
216: END IF;
217:
218: END IF;

Line 273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

269:
270: x_return_status := l_return_status;
271: x_valid := l_valid;
272:
273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add( 'GET_EVENT_STATUS API - UNEXPECTED ERROR' ) ;
276: END IF;
277: IF l_debug_level > 0 THEN

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: END IF;
277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;
279: END IF;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GET_EVENT_STATUS API - ERROR' ) ;
284: END IF;

Line 281: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;
279: END IF;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GET_EVENT_STATUS API - ERROR' ) ;
284: END IF;
285: IF l_debug_level > 0 THEN

Line 288: RAISE FND_API.G_EXC_ERROR;

284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR;
289:
290: END IF;
291:
292: END IF;

Line 359: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

355:
356: IF l_debug_level > 0 THEN
357: oe_debug_pub.add( 'EXITING GET_OTA DESCRIPTION'|| L_DESCRIPTION , 1 ) ;
358: END IF;
359: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
360: IF l_debug_level > 0 THEN
361: oe_debug_pub.add( 'GET_OTA_DESCRIPTION API - UNEXPECTED ERROR' ) ;
362: END IF;
363: IF l_debug_level > 0 THEN

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

362: END IF;
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;
365: END IF;
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add( 'GET_OTA_DESCRIPTION API - ERROR' ) ;
370: END IF;

Line 367: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;
365: END IF;
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add( 'GET_OTA_DESCRIPTION API - ERROR' ) ;
370: END IF;
371: IF l_debug_level > 0 THEN

Line 374: RAISE FND_API.G_EXC_ERROR;

370: END IF;
371: IF l_debug_level > 0 THEN
372: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;
373: END IF;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376:
377: END IF;
378:

Line 421: (p_order_quantity_uom VARCHAR2 := FND_API.G_MISS_CHAR)

417:
418: /* Function: Is_OTA_Line */
419:
420: FUNCTION Is_OTA_Line
421: (p_order_quantity_uom VARCHAR2 := FND_API.G_MISS_CHAR)
422: RETURN BOOLEAN
423: IS
424:
425: --

Line 433: IF p_order_quantity_uom <> FND_API.G_MISS_CHAR THEN

429:
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'ENTERING IS_OTA_LINE FUNCTION ' , 1 ) ;
432: END IF;
433: IF p_order_quantity_uom <> FND_API.G_MISS_CHAR THEN
434: -- check the uom value
435: IF p_order_quantity_uom IN ('ENR','EVT') THEN
436: RETURN TRUE;
437: ELSE

Line 441: RAISE FND_API.G_EXC_ERROR;

437: ELSE
438: RETURN FALSE;
439: END IF;
440: ELSE
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( 'EXITING IS_OTA_LINE FUNCTION ' , 1 ) ;
445: END IF;

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: , 'Get_OTA_Event_End_Date'
631: );
632: END IF;
633:
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635:
636:
637: End Get_OTA_Event_End_Date;
638: