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_ORDER_COPY_UTIL dependencies on OE_ORDER_COPY_UTIL

Line 1: PACKAGE BODY OE_Order_Copy_Util AS

1: PACKAGE BODY OE_Order_Copy_Util AS
2: /* $Header: OEXUCPYB.pls 120.39.12020000.3 2012/10/15 10:51:19 alihussa ship $ */
3:
4: G_DOC_HEADER_ID NUMBER := NULL;
5: G_ATT_HEADER_ID NUMBER := NULL;

Line 133: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;

129: --
130: BEGIN
131:
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;
134: END IF;
135:
136: k := p_line_tbl.FIRST;
137:

Line 146: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;

142:
143: -- Return Index
144:
145: IF l_debug_level > 0 THEN
146: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;
147: END IF;
148: RETURN k;
149:
150: END IF;

Line 158: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;

154:
155: -- Line not in table
156:
157: IF l_debug_level > 0 THEN
158: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;
159: END IF;
160: RETURN FND_API.G_MISS_NUM;
161:
162: END Find_LineIndex;

Line 184: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_ORDER_CATEGORY' , 1 ) ;

180: --
181: BEGIN
182:
183: IF l_debug_level > 0 THEN
184: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_ORDER_CATEGORY' , 1 ) ;
185: END IF;
186:
187: OPEN GET_ORDER_CAT (p_order_type_id);
188: FETCH GET_ORDER_CAT

Line 194: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_ORDER_CATEGORY' , 1 ) ;

190:
191: CLOSE GET_ORDER_CAT;
192:
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_ORDER_CATEGORY' , 1 ) ;
195: END IF;
196:
197: RETURN l_category;
198: EXCEPTION

Line 233: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_LINE_CATEGORY' , 1 ) ;

229: --
230: BEGIN
231:
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_LINE_CATEGORY' , 1 ) ;
234: END IF;
235:
236: OPEN GET_LINE_CAT(p_line_type_id);
237: FETCH GET_LINE_CAT

Line 242: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_LINE_CATEGORY' , 1 ) ;

238: INTO l_category;
239: CLOSE GET_LINE_CAT;
240:
241: IF l_debug_level > 0 THEN
242: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_LINE_CATEGORY' , 1 ) ;
243: END IF;
244:
245: RETURN l_category;
246: EXCEPTION

Line 274: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_DEFAULT_LINE' , 1 ) ;

270: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
271: --
272: BEGIN
273: IF l_debug_level > 0 THEN
274: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_DEFAULT_LINE' , 1 ) ;
275: END IF;
276: l_category := get_order_category(p_order_type_id);
277:
278: BEGIN

Line 313: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_DEFAULT_LINE' , 1 ) ;

309:
310: END;
311:
312: IF l_debug_level > 0 THEN
313: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_DEFAULT_LINE' , 1 ) ;
314: END IF;
315: x_line_type_id := l_line_type_id;
316: Return l_line_type;
317:

Line 364: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_DOCUMENT_INFO' , 1 ) ;

360: --
361: BEGIN
362:
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_DOCUMENT_INFO' , 1 ) ;
365: END IF;
366:
367: IF G_DOC_HEADER_ID IS NOT NULL THEN
368: IF p_header_id = G_DOC_HEADER_ID THEN

Line 399: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_DOCUMENT_INFO' , 1 ) ;

395:
396: CLOSE GET_DOC_INFO;
397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_DOCUMENT_INFO' , 1 ) ;
400: END IF;
401:
402: EXCEPTION
403: WHEN OTHERS THEN

Line 434: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.COPY_HEADER' , 1 ) ;

430: --R12 CC Encryption
431: BEGIN
432:
433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.COPY_HEADER' , 1 ) ;
435: END IF;
436:
437: -- Query the Header to be copied
438:

Line 820: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.COPY_HEADER ' , 1 ) ;

816: END IF;
817:
818: /* Take the comment out nocopy once testing is done in omhut2 */
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.COPY_HEADER ' , 1 ) ;
821: END IF;
822:
823:
824: EXCEPTION

Line 860: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_SCREDITS' , 1 ) ;

856: --
857: BEGIN
858:
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_SCREDITS' , 1 ) ;
861: END IF;
862:
863: -- Load Header Sales Credits
864: BEGIN

Line 904: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_SCREDITS' , 1 ) ;

900: oe_debug_pub.add( 'HEADER SC IS '||TO_CHAR ( X_HEADER_SCREDIT_TBL.COUNT ) , 2 ) ;
901: END IF;
902:
903: IF l_debug_level > 0 THEN
904: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_SCREDITS' , 1 ) ;
905: END IF;
906:
907:
908:

Line 953: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_HOLDS' , 1 ) ;

949: BEGIN
950:
951:
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_HOLDS' , 1 ) ;
954: END IF;
955:
956: -- Since the action request table could already have rows in it
957: -- set the index appropriately.

Line 1048: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_HOLDS' , 1 ) ;

1044: END LOOP;
1045: END IF; -- Table has records
1046:
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_HOLDS' , 1 ) ;
1049: END IF;
1050:
1051: RETURN l_action_request_tbl;
1052:

Line 1097: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.Load_and_Init_Hdr_Payments', 3

1093:
1094: BEGIN
1095:
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.Load_and_Init_Hdr_Payments', 3
1098: ) ;
1099: END IF;
1100:
1101: x_Header_Payment_tbl.delete;

Line 1176: oe_debug_pub.add( 'Exiting OE_ORDER_COPY_UTIL.Load_and_Init_Hdr_Payments', 3) ;

1172: END LOOP;
1173: END IF;
1174:
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( 'Exiting OE_ORDER_COPY_UTIL.Load_and_Init_Hdr_Payments', 3) ;
1177: END IF;
1178: END Load_and_Init_Hdr_Payments;
1179:
1180:

Line 1199: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_HOLDS' , 1 ) ;

1195: --
1196: BEGIN
1197:
1198: IF l_debug_level > 0 THEN
1199: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_HOLDS' , 1 ) ;
1200: END IF;
1201:
1202: k := p_action_request_tbl.COUNT + 1;
1203:

Line 1275: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_HOLDS' , 1 ) ;

1271: END LOOP;
1272: END IF; -- Table has records
1273:
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_HOLDS' , 1 ) ;
1276: END IF;
1277:
1278:
1279: EXCEPTION

Line 1327: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_RETURN_LINES ' , 1 ) ;

1323: --
1324: BEGIN
1325:
1326: IF l_debug_level > 0 THEN
1327: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_RETURN_LINES ' , 1 ) ;
1328: END IF;
1329:
1330: -- Initialize local table
1331:

Line 1437: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_RETURN_LINES',1);

1433: k := l_line_tbl.NEXT(k);
1434: END LOOP;
1435:
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_RETURN_LINES',1);
1438: END IF;
1439:
1440: p_x_line_tbl := l_line_out_tbl;
1441:

Line 1490: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ' , 1 ) ;

1486: idx NUMBER;
1487: BEGIN
1488:
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ' , 1 ) ;
1491: END IF;
1492: --ER 2264774
1493: --Load PRG lines in memory, it will used
1494: --for matching during line processing.

Line 1913: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ',1);

1909: --end Bugfix 9004082
1910:
1911:
1912: IF l_debug_level > 0 THEN
1913: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ',1);
1914: END IF;
1915: p_x_line_tbl := l_line_out_tbl;
1916:
1917: --ER 2264774

Line 1975: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_LINES' , 1 ) ;

1971: l_top_container_model VARCHAR2(1);
1972:
1973: BEGIN
1974: IF l_debug_level > 0 THEN
1975: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_LINES' , 1 ) ;
1976: oe_debug_pub.add('p_all_lines is ' || p_all_lines , 1 ) ;
1977: END IF;
1978:
1979: IF p_hdr_type_id IS NOT NULL THEN

Line 2260: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_LINES' , 1 ) ;

2256:
2257: END IF; -- IF x_line_tbl.count > 0
2258:
2259: IF l_debug_level > 0 THEN
2260: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_LINES' , 1 ) ;
2261: END IF;
2262:
2263:
2264: EXCEPTION

Line 2516: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.INIT_LINES_NEW' , 1 ) ;

2512: l_operation VARCHAR2(30);
2513: BEGIN
2514:
2515: IF l_debug_level > 0 THEN
2516: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.INIT_LINES_NEW' , 1 ) ;
2517: END IF;
2518:
2519: IF p_line_type IS NOT NULL THEN -- If Returns is calling us then this is NULL.
2520: IF l_debug_level > 0 THEN

Line 3318: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.INIT_LINES_NEW' , 1 ) ;

3314:
3315: END IF; -- Table has rows;
3316:
3317: IF l_debug_level > 0 THEN
3318: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.INIT_LINES_NEW' , 1 ) ;
3319: END IF;
3320:
3321:
3322:

Line 3343: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_SCREDITS' , 1 ) ;

3339: --
3340: BEGIN
3341:
3342: IF l_debug_level > 0 THEN
3343: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_SCREDITS' , 1 ) ;
3344: END IF;
3345:
3346: -- Load Line Sales Credits
3347:

Line 3414: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_SCREDITS' , 1 ) ;

3410: oe_debug_pub.add( 'LINE SC IS '||TO_CHAR ( X_LINE_SCREDIT_TBL.COUNT ) , 2 ) ;
3411: END IF;
3412:
3413: IF l_debug_level > 0 THEN
3414: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_SCREDITS' , 1 ) ;
3415: END IF;
3416:
3417:
3418: EXCEPTION

Line 3466: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.Load_and_Init_Line_Payments.' , 1 ) ;

3462:
3463: BEGIN
3464:
3465: IF l_debug_level > 0 THEN
3466: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.Load_and_Init_Line_Payments.' , 1 ) ;
3467: END IF;
3468:
3469: IF p_line_tbl.COUNT > 0 THEN
3470: -- For every line in the line table

Line 3588: oe_debug_pub.add( 'Exiting OE_ORDER_COPY_UTIL.Load_and_Init_Line_Payments.' , 1 ) ;

3584:
3585: END IF; -- Line Table has rows
3586:
3587: IF l_debug_level > 0 THEN
3588: oe_debug_pub.add( 'Exiting OE_ORDER_COPY_UTIL.Load_and_Init_Line_Payments.' , 1 ) ;
3589: END IF;
3590:
3591: END Load_and_Init_Line_Payments;
3592:

Line 3606: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.DELETE_CONFIG ' , 1 ) ;

3602: --
3603: BEGIN
3604:
3605: IF l_debug_level > 0 THEN
3606: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.DELETE_CONFIG ' , 1 ) ;
3607: END IF;
3608:
3609: k := p_top_model_tbl.FIRST;
3610:

Line 3619: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.DELETE_CONFIG' , 1 ) ;

3615: l_return_status );
3616: k := p_top_model_tbl.NEXT(k);
3617: END LOOP;
3618: IF l_debug_level > 0 THEN
3619: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.DELETE_CONFIG' , 1 ) ;
3620: END IF;
3621: EXCEPTION
3622:
3623: WHEN OTHERS THEN

Line 3811: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.COPY_ORDER' , 1 ) ;

3807: l_copy_header_payments := p_copy_rec.hdr_payments;
3808: l_copy_line_payments := p_copy_rec.line_payments;
3809:
3810: IF l_debug_level > 0 THEN
3811: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.COPY_ORDER' , 1 ) ;
3812: oe_debug_pub.add( 'BEFORE RESETTING LEVEL : '|| TO_CHAR ( G_ORDER_LEVEL_COPY ) , 3 ) ;
3813: oe_debug_pub.add( 'REDEFAULT MISSING IS ' || P_COPY_REC.DEFAULT_NULL_VALUES ) ;
3814: END IF;
3815:

Line 4711: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.COPY_ORDER' , 1 ) ;

4707: IF l_debug_level > 0 THEN
4708: oe_debug_pub.add( 'RET STATUS SUCCESS ' || X_RETURN_STATUS , 1 ) ;
4709: END IF;
4710: IF l_debug_level > 0 THEN
4711: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.COPY_ORDER' , 1 ) ;
4712: END IF;
4713:
4714: OE_DEBUG_PUB.DumpDebug;
4715:

Line 6312: END OE_Order_Copy_Util;

6308: END COPY_LINE_SETS;
6309:
6310: -- Copy Sets ER #2830872 , #1566254 End.
6311:
6312: END OE_Order_Copy_Util;