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.

[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on OE_DEBUG_PUB

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

16: l_return_status VARCHAR2(1);
17: l_msg_count NUMBER;
18: l_msg_data VARCHAR2(2000);
19: --
20: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21: --
22: BEGIN
23:
24: IF G_ERROR_REC.order_source_id.COUNT > 0 THEN

Line 29: oe_debug_pub.add( 'ORDER SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID ( I ) ) ;

25:
26: for i in 1..G_ERROR_REC.order_source_id.COUNT loop
27:
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add( 'ORDER SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID ( I ) ) ;
30: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( I ) ) ;
31: oe_debug_pub.add( 'Header_Id :'||G_ERROR_REC.HEADER_ID(I));
32: END IF;
33:

Line 30: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( I ) ) ;

26: for i in 1..G_ERROR_REC.order_source_id.COUNT loop
27:
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add( 'ORDER SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID ( I ) ) ;
30: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( I ) ) ;
31: oe_debug_pub.add( 'Header_Id :'||G_ERROR_REC.HEADER_ID(I));
32: END IF;
33:
34: end loop;

Line 31: oe_debug_pub.add( 'Header_Id :'||G_ERROR_REC.HEADER_ID(I));

27:
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add( 'ORDER SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID ( I ) ) ;
30: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( I ) ) ;
31: oe_debug_pub.add( 'Header_Id :'||G_ERROR_REC.HEADER_ID(I));
32: END IF;
33:
34: end loop;
35: -- Delete Holds Records

Line 56: oe_debug_pub.add( 'ERROR IN DELETE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;

52: );
53:
54: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add( 'ERROR IN DELETE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;
57: END IF;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

Line 115: oe_debug_pub.add( 'ERROR IN OE_BULK_CONFIG_UTIL.Delete_Configurations :'

111: );
112:
113: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add( 'ERROR IN OE_BULK_CONFIG_UTIL.Delete_Configurations :'
116: ||L_RETURN_STATUS ) ;
117: END IF;
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;

Line 127: oe_debug_pub.add( 'Exiting Delete_Error_Records :');

123:
124: END IF;
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'Exiting Delete_Error_Records :');
128: END IF;
129:
130: EXCEPTION
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

142: -- any invalid headers or lines that have been inserted.
143: PROCEDURE Process_Invalid_Records
144: IS
145: --
146: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
147: --
148: BEGIN
149:
150: --

Line 163: oe_debug_pub.add( 'COUNT :'||G_ERROR_REC.ORDER_SOURCE_ID.COUNT ) ;

159: --
160: IF (G_ERROR_REC.order_source_id.COUNT > G_ERROR_COUNT) THEN
161:
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'COUNT :'||G_ERROR_REC.ORDER_SOURCE_ID.COUNT ) ;
164: END IF;
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
167: END IF;

Line 166: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;

162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'COUNT :'||G_ERROR_REC.ORDER_SOURCE_ID.COUNT ) ;
164: END IF;
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
167: END IF;
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
170: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);

Line 169: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));

165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
167: END IF;
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
170: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
171: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
172: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
173: END IF;

Line 170: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);

166: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
167: END IF;
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
170: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
171: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
172: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
173: END IF;
174:

Line 171: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);

167: END IF;
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
170: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
171: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
172: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
173: END IF;
174:
175: --ER 9060917

Line 172: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));

168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
170: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
171: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
172: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
173: END IF;
174:
175: --ER 9060917
176: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

Line 209: oe_debug_pub.add( 'Exiting Process_Invalid_Records ');

205: --End of ER 9060917
206:
207: END IF;
208: IF l_debug_level > 0 THEN
209: oe_debug_pub.add( 'Exiting Process_Invalid_Records ');
210: END IF;
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

238: l_set_of_books_id NUMBER;
239: l_currency_code VARCHAR2(15);
240: l_last_update_date DATE;
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: oe_debug_pub.add( 'SET OF BOOKS OR CURRENCY IS NULL' ) ;

250: l_currency_code := l_set_of_books_rec.currency_code;
251:
252: IF (l_set_of_books_id IS NULL) OR (l_currency_code IS NULL) THEN
253: IF l_debug_level > 0 THEN
254: oe_debug_pub.add( 'SET OF BOOKS OR CURRENCY IS NULL' ) ;
255: END IF;
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:

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

304: l_start_time NUMBER;
305: l_end_time NUMBER;
306: l_header_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;
307: --
308: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
309: --
310: BEGIN
311:
312:

Line 339: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;

335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Headers is (sec) '||((l_end_time-l_start_time)/100));
336:
337: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;
340: END IF;
341: RETURN;
342: END IF;
343:

Line 381: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;

377: -- Insert Messages into DB from above processing call
378: -------------------------------------------------------------------
379:
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
382: END IF;
383:
384: -- Bug 5640601 =>
385: -- Selecting hsecs from v$times is changed to execute only when debug

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

473: l_start_time NUMBER;
474: l_end_time NUMBER;
475: l_line_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;
476: --
477: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
478: --
479: BEGIN
480:
481: -- Bulk Load Lines

Line 489: oe_debug_pub.add( 'Process Tax :'|| p_process_tax,1);

485: -- is enabled, as hsec is used for logging only when debug is enabled.
486: IF l_debug_level > 0 Then
487: SELECT hsecs INTO l_start_time from v$timer;
488: end if;
489: oe_debug_pub.add( 'Process Tax :'|| p_process_tax,1);
490:
491: OE_Bulk_Line_Util.Load_Lines
492: (p_batch_id => p_batch_id
493: ,p_process_configurations => p_process_configurations

Line 496: oe_debug_pub.add( 'AFTER LOADING LINES THE COUNT IS'||G_LINE_REC.LINE_ID.COUNT ) ;

492: (p_batch_id => p_batch_id
493: ,p_process_configurations => p_process_configurations
494: ,p_line_rec => G_LINE_REC);
495: IF l_debug_level > 0 THEN
496: oe_debug_pub.add( 'AFTER LOADING LINES THE COUNT IS'||G_LINE_REC.LINE_ID.COUNT ) ;
497:
498: -- Bug 5640601 =>
499: -- Selecting hsecs from v$times is changed to execute only when debug
500: -- is enabled, as hsec is used for logging only when debug is enabled.

Line 508: oe_debug_pub.add( 'NO LINES IN THIS BATCH , EXIT!' ) ;

504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Lines is (sec) '||((l_end_time-l_start_time)/100));
505:
506: IF G_LINE_REC.LINE_ID.COUNT = 0 THEN
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'NO LINES IN THIS BATCH , EXIT!' ) ;
509: END IF;
510: RETURN;
511: END IF;
512:

Line 547: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;

543:
544:
545: -- Insert Messages
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
548: END IF;
549: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
550:
551: -- Update Headers Interface for Invalid Lines

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

620: l_credit_check_method VARCHAR2(3):='OLD';
621: -- Added for HVOP Tax project
622: l_tax_calculated BOOLEAN;
623: --
624: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
625: --
626: BEGIN
627:
628: l_adjustments_exist := p_adjustments_exist; --pibadj

Line 632: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;

628: l_adjustments_exist := p_adjustments_exist; --pibadj
629:
630: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;
633: oe_debug_pub.add( ' Process Tax :'|| p_process_tax, 1);
634: END IF;
635: RETURN;
636: END IF;

Line 633: oe_debug_pub.add( ' Process Tax :'|| p_process_tax, 1);

629:
630: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;
633: oe_debug_pub.add( ' Process Tax :'|| p_process_tax, 1);
634: END IF;
635: RETURN;
636: END IF;
637:

Line 660: oe_debug_pub.add( 'ERROR IN CREATE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;

656: );
657:
658: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add( 'ERROR IN CREATE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;
661: END IF;
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664:

Line 730: oe_debug_pub.add('before calling OE_BULK_PRICEORDER_PVT.Price_Orders');

726:
727: IF G_PRICING_NEEDED = 'Y' AND QP_UTIL_PUB.Hvop_Pricing_Setup = 'Y'
728: AND NOT G_CATCHWEIGHT THEN --bug 3798477
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add('before calling OE_BULK_PRICEORDER_PVT.Price_Orders');
731: END IF;
732: OE_BULK_PRICEORDER_PVT.Price_Orders
733: (p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC
734: ,p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC

Line 740: oe_debug_pub.add('after OE_BULK_PRICEORDER_PVT.Price_Orders : return status : '||l_return_status);

736: ,x_return_status => l_return_status
737: );
738:
739: IF l_debug_level > 0 THEN
740: oe_debug_pub.add('after OE_BULK_PRICEORDER_PVT.Price_Orders : return status : '||l_return_status);
741: END IF;
742:
743: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1069: oe_debug_pub.add('eligible lines exist,call WSH', 5);

1065:
1066: IF G_LINE_REC.shipping_eligible_flag.COUNT > 0 THEN
1067:
1068: IF l_debug_level > 0 THEN
1069: oe_debug_pub.add('eligible lines exist,call WSH', 5);
1070: END IF;
1071:
1072: OE_Shipping_Integration_Pvt.OM_To_WSH_Interface
1073: ( p_line_rec => G_LINE_REC

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

1131: l_adjustments_exist VARCHAR2(1);
1132: l_start_time NUMBER;
1133: l_end_time NUMBER;
1134: --
1135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1136: --
1137: BEGIN
1138: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );
1139: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);

Line 1138: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );

1134: --
1135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1136: --
1137: BEGIN
1138: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );
1139: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);
1140: -- Initialize Return Status
1141:
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1139: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);

1135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1136: --
1137: BEGIN
1138: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );
1139: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);
1140: -- Initialize Return Status
1141:
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143:

Line 1289: oe_debug_pub.add( 'p_process_configurations = '|| p_process_configurations ) ;

1285: -------------------------------------------------------------------
1286:
1287:
1288: IF l_debug_level > 0 THEN
1289: oe_debug_pub.add( 'p_process_configurations = '|| p_process_configurations ) ;
1290: END IF;
1291:
1292: IF (p_process_configurations = 'Y') THEN
1293:

Line 1295: oe_debug_pub.add( 'CALLING OE_BULK_CONFIG_UTIL.Pre_Process ' ) ;

1291:
1292: IF (p_process_configurations = 'Y') THEN
1293:
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.add( 'CALLING OE_BULK_CONFIG_UTIL.Pre_Process ' ) ;
1296: END IF;
1297:
1298: SELECT hsecs INTO l_start_time from v$timer;
1299:

Line 1389: oe_debug_pub.add( 'UNEXP ERROR IN PROCESS_BATCH' ) ;

1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'UNEXP ERROR IN PROCESS_BATCH' ) ;
1390: END IF;
1391: ROLLBACK TO SAVEPOINT Process_Batch;
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1393: -- Get message count and data

Line 1400: oe_debug_pub.add( 'OTHERS ERROR IN PROCESS_BATCH' ) ;

1396: , p_data => x_msg_data
1397: );
1398: WHEN OTHERS THEN
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'OTHERS ERROR IN PROCESS_BATCH' ) ;
1401: END IF;
1402: IF l_debug_level > 0 THEN
1403: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;
1404: END IF;

Line 1403: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;

1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'OTHERS ERROR IN PROCESS_BATCH' ) ;
1401: END IF;
1402: IF l_debug_level > 0 THEN
1403: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;
1404: END IF;
1405: ROLLBACK TO SAVEPOINT Process_Batch;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1407: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1419: RETURN VARCHAR2
1420: IS
1421: l_count NUMBER;
1422: --
1423: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1424: --
1425: BEGIN
1426: SELECT count(*)
1427: INTO l_count

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

1446: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)
1447: IS
1448: error_count NUMBER := OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.COUNT;
1449: --
1450: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1451: --
1452: BEGIN
1453:
1454: IF l_debug_level > 0 THEN

Line 1455: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;

1451: --
1452: BEGIN
1453:
1454: IF l_debug_level > 0 THEN
1455: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1456: oe_debug_pub.add('The error count is '|| error_count);
1457: END IF;
1458:
1459: error_count := error_count + 1;

Line 1456: oe_debug_pub.add('The error count is '|| error_count);

1452: BEGIN
1453:
1454: IF l_debug_level > 0 THEN
1455: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1456: oe_debug_pub.add('The error count is '|| error_count);
1457: END IF;
1458:
1459: error_count := error_count + 1;
1460:

Line 1474: oe_debug_pub.add( 'EXITING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;

1470: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
1471: := p_header_rec.header_id(p_header_index);
1472:
1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'EXITING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1475: END IF;
1476:
1477: EXCEPTION
1478: WHEN OTHERS THEN

Line 1480: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;

1476:
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: IF l_debug_level > 0 THEN
1480: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;
1481: END IF;
1482: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: OE_BULK_MSG_PUB.add_exc_msg