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

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

53: );
54:
55: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
56: IF l_debug_level > 0 THEN
57: oe_debug_pub.add( 'ERROR IN DELETE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;
58: END IF;
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:

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

95: );
96:
97: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
98: IF l_debug_level > 0 THEN
99: oe_debug_pub.add( 'ERROR IN OE_BULK_CONFIG_UTIL.Delete_Configurations :'
100: ||L_RETURN_STATUS ) ;
101: END IF;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;

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

107:
108: END IF;
109:
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add( 'Exiting Delete_Error_Records :');
112: END IF;
113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

126: -- any invalid headers or lines that have been inserted.
127: PROCEDURE Process_Invalid_Records
128: IS
129: --
130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
131: --
132: BEGIN
133:
134: --

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

143: --
144: IF (G_ERROR_REC.order_source_id.COUNT > G_ERROR_COUNT) THEN
145:
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'COUNT :'||G_ERROR_REC.ORDER_SOURCE_ID.COUNT ) ;
148: END IF;
149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
151: END IF;

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

146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'COUNT :'||G_ERROR_REC.ORDER_SOURCE_ID.COUNT ) ;
148: END IF;
149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
151: END IF;
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
154: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);

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

149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
151: END IF;
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
154: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
155: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
156: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
157: END IF;

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

150: oe_debug_pub.add( 'ORIG SYS REF :'||G_ERROR_REC.ORIG_SYS_DOCUMENT_REF ( 1 ) ) ;
151: END IF;
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
154: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
155: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
156: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
157: END IF;
158: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT

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

151: END IF;
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
154: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
155: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
156: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
157: END IF;
158: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT
159: UPDATE OE_HEADERS_IFACE_ALL

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

152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add('Header_Id :'||G_ERROR_REC.HEADER_ID(1));
154: oe_debug_pub.add('G_ERROR_COUNT :'||G_ERROR_COUNT);
155: oe_debug_pub.add('G_REQUEST_ID :'||G_REQUEST_ID);
156: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
157: END IF;
158: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT
159: UPDATE OE_HEADERS_IFACE_ALL
160: SET ERROR_FLAG = 'Y'

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

165: G_ERROR_COUNT := G_ERROR_REC.order_source_id.COUNT;
166:
167: END IF;
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'Exiting Process_Invalid_Records ');
170: END IF;
171:
172: EXCEPTION
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

198: l_set_of_books_id NUMBER;
199: l_currency_code VARCHAR2(15);
200: l_last_update_date DATE;
201: --
202: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
203: --
204: BEGIN
205:
206: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

210: l_currency_code := l_set_of_books_rec.currency_code;
211:
212: IF (l_set_of_books_id IS NULL) OR (l_currency_code IS NULL) THEN
213: IF l_debug_level > 0 THEN
214: oe_debug_pub.add( 'SET OF BOOKS OR CURRENCY IS NULL' ) ;
215: END IF;
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:

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

264: l_start_time NUMBER;
265: l_end_time NUMBER;
266: l_header_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;
267: --
268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
269: --
270: BEGIN
271:
272:

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

295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Headers is (sec) '||((l_end_time-l_start_time)/100));
296:
297: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;
300: END IF;
301: RETURN;
302: END IF;
303:

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

337: -- Insert Messages into DB from above processing call
338: -------------------------------------------------------------------
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
342: END IF;
343:
344: -- Bug 5640601 =>
345: -- Selecting hsecs from v$times is changed to execute only when debug

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

433: l_start_time NUMBER;
434: l_end_time NUMBER;
435: l_line_scredit_rec OE_BULK_ORDER_PVT.Scredit_Rec_Type;
436: --
437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
438: --
439: BEGIN
440:
441: -- Bulk Load Lines

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

445: -- is enabled, as hsec is used for logging only when debug is enabled.
446: IF l_debug_level > 0 Then
447: SELECT hsecs INTO l_start_time from v$timer;
448: end if;
449: oe_debug_pub.add( 'Process Tax :'|| p_process_tax,1);
450:
451: OE_Bulk_Line_Util.Load_Lines
452: (p_batch_id => p_batch_id
453: ,p_process_configurations => p_process_configurations

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

452: (p_batch_id => p_batch_id
453: ,p_process_configurations => p_process_configurations
454: ,p_line_rec => G_LINE_REC);
455: IF l_debug_level > 0 THEN
456: oe_debug_pub.add( 'AFTER LOADING LINES THE COUNT IS'||G_LINE_REC.LINE_ID.COUNT ) ;
457:
458: -- Bug 5640601 =>
459: -- Selecting hsecs from v$times is changed to execute only when debug
460: -- is enabled, as hsec is used for logging only when debug is enabled.

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

464: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Lines is (sec) '||((l_end_time-l_start_time)/100));
465:
466: IF G_LINE_REC.LINE_ID.COUNT = 0 THEN
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'NO LINES IN THIS BATCH , EXIT!' ) ;
469: END IF;
470: RETURN;
471: END IF;
472:

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

503:
504:
505: -- Insert Messages
506: IF l_debug_level > 0 THEN
507: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
508: END IF;
509: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
510:
511: -- Update Headers Interface for Invalid Lines

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

580: l_credit_check_method VARCHAR2(3):='OLD';
581: -- Added for HVOP Tax project
582: l_tax_calculated BOOLEAN;
583: --
584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
585: --
586: BEGIN
587:
588: l_adjustments_exist := p_adjustments_exist; --pibadj

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

588: l_adjustments_exist := p_adjustments_exist; --pibadj
589:
590: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;
593: oe_debug_pub.add( ' Process Tax :'|| p_process_tax, 1);
594: END IF;
595: RETURN;
596: END IF;

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

589:
590: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;
593: oe_debug_pub.add( ' Process Tax :'|| p_process_tax, 1);
594: END IF;
595: RETURN;
596: END IF;
597:

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

616: );
617:
618: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add( 'ERROR IN CREATE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;
621: END IF;
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:

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

686:
687: IF G_PRICING_NEEDED = 'Y' AND QP_UTIL_PUB.Hvop_Pricing_Setup = 'Y'
688: AND NOT G_CATCHWEIGHT THEN --bug 3798477
689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add('before calling OE_BULK_PRICEORDER_PVT.Price_Orders');
691: END IF;
692: OE_BULK_PRICEORDER_PVT.Price_Orders
693: (p_header_rec => OE_BULK_ORDER_PVT.G_HEADER_REC
694: ,p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC

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

696: ,x_return_status => l_return_status
697: );
698:
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add('after OE_BULK_PRICEORDER_PVT.Price_Orders : return status : '||l_return_status);
701: END IF;
702:
703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1024:
1025: IF G_LINE_REC.shipping_eligible_flag.COUNT > 0 THEN
1026:
1027: IF l_debug_level > 0 THEN
1028: oe_debug_pub.add('eligible lines exist,call WSH', 5);
1029: END IF;
1030:
1031: OE_Shipping_Integration_Pvt.OM_To_WSH_Interface
1032: ( p_line_rec => G_LINE_REC

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

1090: l_adjustments_exist VARCHAR2(1);
1091: l_start_time NUMBER;
1092: l_end_time NUMBER;
1093: --
1094: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1095: --
1096: BEGIN
1097: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );
1098: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);

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

1093: --
1094: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1095: --
1096: BEGIN
1097: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );
1098: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);
1099: -- Initialize Return Status
1100:
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1094: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1095: --
1096: BEGIN
1097: oe_debug_pub.add( ' In Process Batch : p_process_configurations :'|| p_process_configurations );
1098: oe_debug_pub.add( ' Process Tax :'|| p_process_tax ,1);
1099: -- Initialize Return Status
1100:
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102:

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

1244: -------------------------------------------------------------------
1245:
1246:
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'p_process_configurations = '|| p_process_configurations ) ;
1249: END IF;
1250:
1251: IF (p_process_configurations = 'Y') THEN
1252:

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

1250:
1251: IF (p_process_configurations = 'Y') THEN
1252:
1253: IF l_debug_level > 0 THEN
1254: oe_debug_pub.add( 'CALLING OE_BULK_CONFIG_UTIL.Pre_Process ' ) ;
1255: END IF;
1256:
1257: SELECT hsecs INTO l_start_time from v$timer;
1258:

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

1344:
1345: EXCEPTION
1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1347: IF l_debug_level > 0 THEN
1348: oe_debug_pub.add( 'UNEXP ERROR IN PROCESS_BATCH' ) ;
1349: END IF;
1350: ROLLBACK TO SAVEPOINT Process_Batch;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352: -- Get message count and data

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

1355: , p_data => x_msg_data
1356: );
1357: WHEN OTHERS THEN
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'OTHERS ERROR IN PROCESS_BATCH' ) ;
1360: END IF;
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;
1363: END IF;

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

1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'OTHERS ERROR IN PROCESS_BATCH' ) ;
1360: END IF;
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;
1363: END IF;
1364: ROLLBACK TO SAVEPOINT Process_Batch;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1366: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1378: RETURN VARCHAR2
1379: IS
1380: l_count NUMBER;
1381: --
1382: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1383: --
1384: BEGIN
1385: SELECT count(*)
1386: INTO l_count

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

1405: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)
1406: IS
1407: error_count NUMBER := OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.COUNT;
1408: --
1409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1410: --
1411: BEGIN
1412:
1413: IF l_debug_level > 0 THEN

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

1410: --
1411: BEGIN
1412:
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1415: oe_debug_pub.add('The error count is '|| error_count);
1416: END IF;
1417:
1418: error_count := error_count + 1;

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

1411: BEGIN
1412:
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'ENTERING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1415: oe_debug_pub.add('The error count is '|| error_count);
1416: END IF;
1417:
1418: error_count := error_count + 1;
1419:

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

1429: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
1430: := p_header_rec.header_id(p_header_index);
1431:
1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add( 'EXITING OE_BULK_ORDER_PVT.MARK_HEADER_ERROR' ) ;
1434: END IF;
1435:
1436: EXCEPTION
1437: WHEN OTHERS THEN

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

1435:
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;
1440: END IF;
1441: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_BULK_MSG_PUB.add_exc_msg