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 OE_DEBUG_PUB

Line 12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

8: l_ret_val BOOLEAN;
9: l_status VARCHAR2(1);
10: l_industry VARCHAR2(1);
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: BEGIN
15:
16: if (p_application_id = 810

Line 20: oe_debug_pub.add( 'GET OTA PROD. STATUS' ) ;

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;
22:
23: -- Make a call to fnd_installation.get function to check for the
24: -- installation status of the CRM products and return the status.

Line 36: oe_debug_pub.add( 'OTA RET PROD. STATUS :'||G_OTA_STATUS ) ;

32: end if;
33:
34: if p_application_id = 810 then
35: IF l_debug_level > 0 THEN
36: oe_debug_pub.add( 'OTA RET PROD. STATUS :'||G_OTA_STATUS ) ;
37: END IF;
38: return (G_OTA_STATUS);
39: end if;
40:

Line 57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

53: l_return_status VARCHAR2(1);
54: l_sql_stat VARCHAR2(3000);
55:
56: --
57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
58: --
59: BEGIN
60:
61: IF l_debug_level > 0 THEN

Line 62: oe_debug_pub.add( 'ENTERING NOTIFY_OTA API' ) ;

58: --
59: BEGIN
60:
61: IF l_debug_level > 0 THEN
62: oe_debug_pub.add( 'ENTERING NOTIFY_OTA API' ) ;
63: END IF;
64:
65:
66: /* The application id for Order Capture is 697 */

Line 100: oe_debug_pub.add( 'JPN: OTA RETURN STATUS IS: ' || L_RETURN_STATUS ) ;

96:
97: x_return_status := l_return_status;
98:
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

Line 105: oe_debug_pub.add( 'NOTIFY_OTA API - UNEXPECTED ERROR' ) ;

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
108: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;
109: END IF;

Line 108: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;

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

Line 110: /* OE_DEBUG_PUB.ADD('Notify OC error msg is: ' || substr(x_msg_data, 1,200)); */

106: END IF;
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' ) ;

Line 114: oe_debug_pub.add( 'NOTIFY_OTA API - ERROR' ) ;

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
117: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;
118: END IF;

Line 117: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;

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
117: oe_debug_pub.add( 'EXITING NOTIFY_OTA API' ) ;
118: END IF;
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:

Line 162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

158: l_valid VARCHAR2(1);
159: l_return_status VARCHAR2(1);
160:
161: --
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: --
164: BEGIN
165:
166: IF l_debug_level > 0 THEN

Line 167: oe_debug_pub.add( 'ENTERING GET OTA ENROLLMENT' , 1 ) ;

163: --
164: BEGIN
165:
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add( 'ENTERING GET OTA ENROLLMENT' , 1 ) ;
168: END IF;
169: -- IF Get_Product_Status(810) IN ('I','S') THEN
170:
171: -- lkxu, for bug 1701377

Line 201: oe_debug_pub.add( 'GET_ENROLLMENT_STATUS API - UNEXPECTED ERROR' ) ;

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
204: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;
205: END IF;

Line 204: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;

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

Line 209: oe_debug_pub.add( 'GET_ENROLLMENT_STATUS API - ERROR' ) ;

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
212: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;
213: END IF;

Line 212: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;

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
212: oe_debug_pub.add( 'EXITING GET_ENROLLMENT_STATUS API' ) ;
213: END IF;
214: RAISE FND_API.G_EXC_ERROR;
215:
216: END IF;

Line 236: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

232: l_valid VARCHAR2(1);
233: l_return_status VARCHAR2(1);
234:
235: --
236: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
237: --
238: BEGIN
239:
240: IF l_debug_level > 0 THEN

Line 241: oe_debug_pub.add( 'ENTERING GET OTA ENROLLMENT' , 1 ) ;

237: --
238: BEGIN
239:
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add( 'ENTERING GET OTA ENROLLMENT' , 1 ) ;
242: END IF;
243: -- IF Get_Product_Status(810) IN ('I','S') THEN
244:
245: -- lkxu, for bug 1701377

Line 275: oe_debug_pub.add( 'GET_EVENT_STATUS API - UNEXPECTED ERROR' ) ;

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
278: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;
279: END IF;

Line 278: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;

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

Line 283: oe_debug_pub.add( 'GET_EVENT_STATUS API - ERROR' ) ;

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
286: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;
287: END IF;

Line 286: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;

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
286: oe_debug_pub.add( 'EXITING GET_EVENT_STATUS API' ) ;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR;
289:
290: END IF;

Line 314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

310: l_sql_stat VARCHAR2(3000);
311: l_description VARCHAR2(2000);
312:
313: --
314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
315: --
316: BEGIN
317:
318: IF l_debug_level > 0 THEN

Line 319: oe_debug_pub.add( 'ENTERING GET_OTA DESCRIPTION' , 1 ) ;

315: --
316: BEGIN
317:
318: IF l_debug_level > 0 THEN
319: oe_debug_pub.add( 'ENTERING GET_OTA DESCRIPTION' , 1 ) ;
320: END IF;
321: -- IF Get_Product_Status(810) IN ('I','S') THEN
322:
323: -- lkxu, for bug 1701377

Line 357: oe_debug_pub.add( 'EXITING GET_OTA DESCRIPTION'|| L_DESCRIPTION , 1 ) ;

353:
354: x_description := l_description;
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' ) ;

Line 361: oe_debug_pub.add( 'GET_OTA_DESCRIPTION API - UNEXPECTED ERROR' ) ;

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
364: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;
365: END IF;

Line 364: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;

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

Line 369: oe_debug_pub.add( 'GET_OTA_DESCRIPTION API - ERROR' ) ;

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
372: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;
373: END IF;

Line 372: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;

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
372: oe_debug_pub.add( 'EXITING GET_OTA_DESCRIPTION API' ) ;
373: END IF;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376:

Line 398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

394: l_line_id NUMBER := oe_line_security.g_record.line_id;
395: l_quantity_uom VARCHAR2(3);
396:
397: --
398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
399: --
400: BEGIN
401:
402: select order_quantity_uom into l_quantity_uom

Line 426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

422: RETURN BOOLEAN
423: IS
424:
425: --
426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
427: --
428: BEGIN
429:
430: IF l_debug_level > 0 THEN

Line 431: oe_debug_pub.add( 'ENTERING IS_OTA_LINE FUNCTION ' , 1 ) ;

427: --
428: BEGIN
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

Line 444: oe_debug_pub.add( 'EXITING IS_OTA_LINE FUNCTION ' , 1 ) ;

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;
446:
447: EXCEPTION
448: when others then

Line 450: oe_debug_pub.add( 'EXCEPTION IN IS_OTA_LINE FUNCTION ' , 1 ) ;

446:
447: EXCEPTION
448: when others then
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add( 'EXCEPTION IN IS_OTA_LINE FUNCTION ' , 1 ) ;
451: END IF;
452: RETURN FALSE;
453: END Is_OTA_Line;
454:

Line 482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

478: l_enrollment_status VARCHAR2(30);
479:
480:
481: --
482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
483: --
484: BEGIN
485:
486:

Line 488: oe_debug_pub.add( 'ENTERING CREATE_OTA_ENROLL' , 1 ) ;

484: BEGIN
485:
486:
487: IF l_debug_level > 0 THEN
488: oe_debug_pub.add( 'ENTERING CREATE_OTA_ENROLL' , 1 ) ;
489: END IF;
490: -- IF Get_Product_Status(810) IN ('I','S') THEN
491:
492: -- lkxu, for bug 1701377

Line 539: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_RETURN_STATUS , 1 ) ;

535: x_enrollment_status := l_enrollment_status;
536:
537:
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_RETURN_STATUS , 1 ) ;
540: END IF;
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_ENROLLMENT_STATUS , 1 ) ;
543: END IF;

Line 542: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_ENROLLMENT_STATUS , 1 ) ;

538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_RETURN_STATUS , 1 ) ;
540: END IF;
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_ENROLLMENT_STATUS , 1 ) ;
543: END IF;
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_RETURN_STATUS , 1 ) ;
546: END IF;

Line 545: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_RETURN_STATUS , 1 ) ;

541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_ENROLLMENT_STATUS , 1 ) ;
543: END IF;
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'EXITING CREATE OTA ENROLL '|| L_RETURN_STATUS , 1 ) ;
546: END IF;
547:
548: END IF;
549: END Create_OTA_Enroll;

Line 572: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

568: l_course_start_date DATE;
569: l_course_end_date DATE;
570:
571: --
572: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
573: --
574: BEGIN
575:
576: IF l_debug_level > 0 THEN

Line 577: oe_debug_pub.add( 'ENTERING GET_OTA_EVENT_END_DATE' , 1 ) ;

573: --
574: BEGIN
575:
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add( 'ENTERING GET_OTA_EVENT_END_DATE' , 1 ) ;
578: END IF;
579:
580: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
581: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);

Line 610: oe_debug_pub.add( 'EXITING GET_OTA_EVENT_END_DATE WITH EVENT END DATE' , 1 ) ;

606: , OUT l_course_end_date;
607:
608:
609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add( 'EXITING GET_OTA_EVENT_END_DATE WITH EVENT END DATE' , 1 ) ;
611: END IF;
612: RETURN l_course_end_date;
613:
614: END IF;

Line 617: oe_debug_pub.add( 'EXITING GET_OTA_EVENT_END_DATE WITH NULL' , 1 ) ;

613:
614: END IF;
615:
616: IF l_debug_level > 0 THEN
617: oe_debug_pub.add( 'EXITING GET_OTA_EVENT_END_DATE WITH NULL' , 1 ) ;
618: END IF;
619: RETURN NULL;
620:
621: