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.13.12010000.14 2009/01/23 11:49:38 nshah ship $ */
3:
4: G_DOC_HEADER_ID NUMBER := NULL;
5: G_ATT_HEADER_ID NUMBER := NULL;

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

90: --
91: BEGIN
92:
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;
95: END IF;
96:
97: k := p_line_tbl.FIRST;
98:

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

103:
104: -- Return Index
105:
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;
108: END IF;
109: RETURN k;
110:
111: END IF;

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

115:
116: -- Line not in table
117:
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.FIND_LINEINDEX ' , 1 ) ;
120: END IF;
121: RETURN FND_API.G_MISS_NUM;
122:
123: END Find_LineIndex;

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

141: --
142: BEGIN
143:
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_ORDER_CATEGORY' , 1 ) ;
146: END IF;
147:
148: OPEN GET_ORDER_CAT (p_order_type_id);
149: FETCH GET_ORDER_CAT

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

151:
152: CLOSE GET_ORDER_CAT;
153:
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_ORDER_CATEGORY' , 1 ) ;
156: END IF;
157:
158: RETURN l_category;
159: EXCEPTION

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

190: --
191: BEGIN
192:
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_LINE_CATEGORY' , 1 ) ;
195: END IF;
196:
197: OPEN GET_LINE_CAT(p_line_type_id);
198: FETCH GET_LINE_CAT

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

199: INTO l_category;
200: CLOSE GET_LINE_CAT;
201:
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_LINE_CATEGORY' , 1 ) ;
204: END IF;
205:
206: RETURN l_category;
207: EXCEPTION

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

231: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
232: --
233: BEGIN
234: IF l_debug_level > 0 THEN
235: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_DEFAULT_LINE' , 1 ) ;
236: END IF;
237: l_category := get_order_category(p_order_type_id);
238:
239: BEGIN

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

270:
271: END;
272:
273: IF l_debug_level > 0 THEN
274: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_DEFAULT_LINE' , 1 ) ;
275: END IF;
276: x_line_type_id := l_line_type_id;
277: Return l_line_type;
278:

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

321: --
322: BEGIN
323:
324: IF l_debug_level > 0 THEN
325: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.GET_DOCUMENT_INFO' , 1 ) ;
326: END IF;
327:
328: IF G_DOC_HEADER_ID IS NOT NULL THEN
329: IF p_header_id = G_DOC_HEADER_ID THEN

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

356:
357: CLOSE GET_DOC_INFO;
358:
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.GET_DOCUMENT_INFO' , 1 ) ;
361: END IF;
362:
363: EXCEPTION
364: WHEN OTHERS THEN

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

391: --R12 CC Encryption
392: BEGIN
393:
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.COPY_HEADER' , 1 ) ;
396: END IF;
397:
398: -- Query the Header to be copied
399:

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

744: END IF;
745:
746: /* Take the comment out nocopy once testing is done in omhut2 */
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.COPY_HEADER ' , 1 ) ;
749: END IF;
750:
751:
752: EXCEPTION

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

784: --
785: BEGIN
786:
787: IF l_debug_level > 0 THEN
788: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_SCREDITS' , 1 ) ;
789: END IF;
790:
791: -- Load Header Sales Credits
792: BEGIN

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

828: oe_debug_pub.add( 'HEADER SC IS '||TO_CHAR ( X_HEADER_SCREDIT_TBL.COUNT ) , 2 ) ;
829: END IF;
830:
831: IF l_debug_level > 0 THEN
832: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_SCREDITS' , 1 ) ;
833: END IF;
834:
835:
836:

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

877: BEGIN
878:
879:
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_HOLDS' , 1 ) ;
882: END IF;
883:
884: -- Since the action request table could already have rows in it
885: -- set the index appropriately.

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

972: END LOOP;
973: END IF; -- Table has records
974:
975: IF l_debug_level > 0 THEN
976: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_HDR_HOLDS' , 1 ) ;
977: END IF;
978:
979: RETURN l_action_request_tbl;
980:

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

1021:
1022: BEGIN
1023:
1024: IF l_debug_level > 0 THEN
1025: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.Load_and_Init_Hdr_Payments', 3
1026: ) ;
1027: END IF;
1028:
1029: x_Header_Payment_tbl.delete;

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

1100: END LOOP;
1101: END IF;
1102:
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'Exiting OE_ORDER_COPY_UTIL.Load_and_Init_Hdr_Payments', 3) ;
1105: END IF;
1106: END Load_and_Init_Hdr_Payments;
1107:
1108:

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

1123: --
1124: BEGIN
1125:
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_HOLDS' , 1 ) ;
1128: END IF;
1129:
1130: k := p_action_request_tbl.COUNT + 1;
1131:

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

1199: END LOOP;
1200: END IF; -- Table has records
1201:
1202: IF l_debug_level > 0 THEN
1203: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_HOLDS' , 1 ) ;
1204: END IF;
1205:
1206:
1207: EXCEPTION

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

1251: --
1252: BEGIN
1253:
1254: IF l_debug_level > 0 THEN
1255: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_RETURN_LINES ' , 1 ) ;
1256: END IF;
1257:
1258: -- Initialize local table
1259:

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

1361: k := l_line_tbl.NEXT(k);
1362: END LOOP;
1363:
1364: IF l_debug_level > 0 THEN
1365: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_RETURN_LINES',1);
1366: END IF;
1367:
1368: p_x_line_tbl := l_line_out_tbl;
1369:

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

1414: idx NUMBER;
1415: BEGIN
1416:
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ' , 1 ) ;
1419: END IF;
1420: --ER 2264774
1421: --Load PRG lines in memory, it will used
1422: --for matching during line processing.

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

1799: k := l_line_tbl.NEXT(k);
1800: END LOOP;
1801:
1802: IF l_debug_level > 0 THEN
1803: oe_debug_pub.add('Exiting OE_ORDER_COPY_UTIL.HANDLE_NONSTANDARD_LINES ',1);
1804: END IF;
1805: p_x_line_tbl := l_line_out_tbl;
1806:
1807: --ER 2264774

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

1861: l_top_container_model VARCHAR2(1);
1862:
1863: BEGIN
1864: IF l_debug_level > 0 THEN
1865: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_LINES' , 1 ) ;
1866: oe_debug_pub.add('p_all_lines is ' || p_all_lines , 1 ) ;
1867: END IF;
1868:
1869: IF p_hdr_type_id IS NOT NULL THEN

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

2137:
2138: END IF; -- IF x_line_tbl.count > 0
2139:
2140: IF l_debug_level > 0 THEN
2141: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_LINES' , 1 ) ;
2142: END IF;
2143:
2144:
2145: EXCEPTION

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

2393: l_operation VARCHAR2(30);
2394: BEGIN
2395:
2396: IF l_debug_level > 0 THEN
2397: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.INIT_LINES_NEW' , 1 ) ;
2398: END IF;
2399:
2400: IF p_line_type IS NOT NULL THEN -- If Returns is calling us then this is NULL.
2401: IF l_debug_level > 0 THEN

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

3164:
3165: END IF; -- Table has rows;
3166:
3167: IF l_debug_level > 0 THEN
3168: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.INIT_LINES_NEW' , 1 ) ;
3169: END IF;
3170:
3171:
3172:

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

3189: --
3190: BEGIN
3191:
3192: IF l_debug_level > 0 THEN
3193: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_SCREDITS' , 1 ) ;
3194: END IF;
3195:
3196: -- Load Line Sales Credits
3197:

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

3260: oe_debug_pub.add( 'LINE SC IS '||TO_CHAR ( X_LINE_SCREDIT_TBL.COUNT ) , 2 ) ;
3261: END IF;
3262:
3263: IF l_debug_level > 0 THEN
3264: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.LOAD_AND_INIT_LINE_SCREDITS' , 1 ) ;
3265: END IF;
3266:
3267:
3268: EXCEPTION

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

3312:
3313: BEGIN
3314:
3315: IF l_debug_level > 0 THEN
3316: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.Load_and_Init_Line_Payments.' , 1 ) ;
3317: END IF;
3318:
3319: IF p_line_tbl.COUNT > 0 THEN
3320: -- For every line in the line table

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

3434:
3435: END IF; -- Line Table has rows
3436:
3437: IF l_debug_level > 0 THEN
3438: oe_debug_pub.add( 'Exiting OE_ORDER_COPY_UTIL.Load_and_Init_Line_Payments.' , 1 ) ;
3439: END IF;
3440:
3441: END Load_and_Init_Line_Payments;
3442:

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

3452: --
3453: BEGIN
3454:
3455: IF l_debug_level > 0 THEN
3456: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.DELETE_CONFIG ' , 1 ) ;
3457: END IF;
3458:
3459: k := p_top_model_tbl.FIRST;
3460:

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

3465: l_return_status );
3466: k := p_top_model_tbl.NEXT(k);
3467: END LOOP;
3468: IF l_debug_level > 0 THEN
3469: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.DELETE_CONFIG' , 1 ) ;
3470: END IF;
3471: EXCEPTION
3472:
3473: WHEN OTHERS THEN

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

3657: l_copy_header_payments := p_copy_rec.hdr_payments;
3658: l_copy_line_payments := p_copy_rec.line_payments;
3659:
3660: IF l_debug_level > 0 THEN
3661: oe_debug_pub.add( 'ENTERING OE_ORDER_COPY_UTIL.COPY_ORDER' , 1 ) ;
3662: oe_debug_pub.add( 'BEFORE RESETTING LEVEL : '|| TO_CHAR ( G_ORDER_LEVEL_COPY ) , 3 ) ;
3663: oe_debug_pub.add( 'REDEFAULT MISSING IS ' || P_COPY_REC.DEFAULT_NULL_VALUES ) ;
3664: END IF;
3665:

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

4557: IF l_debug_level > 0 THEN
4558: oe_debug_pub.add( 'RET STATUS SUCCESS ' || X_RETURN_STATUS , 1 ) ;
4559: END IF;
4560: IF l_debug_level > 0 THEN
4561: oe_debug_pub.add( 'EXITING OE_ORDER_COPY_UTIL.COPY_ORDER' , 1 ) ;
4562: END IF;
4563:
4564: OE_DEBUG_PUB.DumpDebug;
4565:

Line 6120: END OE_Order_Copy_Util;

6116: END COPY_LINE_SETS;
6117:
6118: -- Copy Sets ER #2830872 , #1566254 End.
6119:
6120: END OE_Order_Copy_Util;