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_IMPORT_PVT dependencies on OE_DEBUG_PUB

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

121: )IS
122: l_start_time NUMBER;
123: l_end_time NUMBER;
124: --
125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
126: --
127: BEGIN
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 608: l_filename := oe_debug_pub.set_debug_mode ('CONC');

604:
605: IF nvl(p_debug_level, 0) > 0 THEN
606: FND_PROFILE.PUT('ONT_DEBUG_LEVEL',p_debug_level);
607: --moved this stmt in if loop for bug 3747791
608: l_filename := oe_debug_pub.set_debug_mode ('CONC');
609: END IF;
610:
611: -- l_filename := oe_debug_pub.set_debug_mode ('CONC');
612:

Line 611: -- l_filename := oe_debug_pub.set_debug_mode ('CONC');

607: --moved this stmt in if loop for bug 3747791
608: l_filename := oe_debug_pub.set_debug_mode ('CONC');
609: END IF;
610:
611: -- l_filename := oe_debug_pub.set_debug_mode ('CONC');
612:
613: -----------------------------------------------------------
614: -- Get Concurrent Request Id
615: -----------------------------------------------------------

Line 628: oe_debug_pub.add('Default Org Id '||l_default_org_id);

624: End If;
625: l_default_org_id := MO_UTILS.get_default_org_id;
626:
627: If p_debug_level > 0 Then
628: oe_debug_pub.add('Default Org Id '||l_default_org_id);
629: End If;
630:
631: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '|| to_char(p_operating_unit));
632: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 665: oe_debug_pub.add('process recs with no org '||p_process_recs_with_no_org);

661: END ;
662: END LOOP;
663:
664: if p_debug_level >0 then
665: oe_debug_pub.add('process recs with no org '||p_process_recs_with_no_org);
666: oe_debug_pub.add('G_CONFIG_EFFECT_DATE'||OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE);
667: end if;
668: --End bug 4685432
669:

Line 666: oe_debug_pub.add('G_CONFIG_EFFECT_DATE'||OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE);

662: END LOOP;
663:
664: if p_debug_level >0 then
665: oe_debug_pub.add('process recs with no org '||p_process_recs_with_no_org);
666: oe_debug_pub.add('G_CONFIG_EFFECT_DATE'||OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE);
667: end if;
668: --End bug 4685432
669:
670: -----------------------------------------------------------

Line 690: oe_debug_pub.add('p_process_recs_with_no_org =Y',1);

686: BEGIN
687:
688: If p_process_recs_with_no_org = 'Y' Then
689:
690: oe_debug_pub.add('p_process_recs_with_no_org =Y',1);
691:
692: SELECT count(orig_sys_document_ref)
693: INTO l_row_count
694: FROM(

Line 796: oe_debug_pub.add('the number of orders to process is '||l_row_count);

792: AND NVL(h.org_id, l_default_org_id) =
793: NVL(a.org_id, l_default_org_id)
794: AND operation_code <> 'BOOK_ORDER'));
795: if p_debug_level > 0 then
796: oe_debug_pub.add('the number of orders to process is '||l_row_count);
797: end if;
798: Else
799:
800: -- No need to select NULL org_id records.

Line 801: oe_debug_pub.add('p_process_recs_with_no_org =N',1);

797: end if;
798: Else
799:
800: -- No need to select NULL org_id records.
801: oe_debug_pub.add('p_process_recs_with_no_org =N',1);
802: SELECT /* MOAC_SQL_CHANGE */ count(*)
803: INTO l_row_count
804: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
805: oe_sys_parameters_all sys

Line 841: oe_debug_pub.add('No Data found in the IFCAE table');

837: AND a.org_id = h.org_id
838: AND operation_code <> 'BOOK_ORDER');
839: End If;
840: IF l_row_count = 0 THEN
841: oe_debug_pub.add('No Data found in the IFCAE table');
842: RAISE NO_DATA_FOUND;
843: END IF;
844:
845: EXCEPTION

Line 861: oe_debug_pub.add('Remaining Header Row Count is '||l_row_count);

857:
858:
859:
860: If p_debug_level > 0 Then
861: oe_debug_pub.add('Remaining Header Row Count is '||l_row_count);
862: end if;
863: IF l_num_instances > l_row_count THEN
864: l_num_instances := l_row_count;
865: END IF;

Line 902: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);

898: -----------------------------------------------------------
899: -- BULK Populate Orders Table - l_order_rec
900: -----------------------------------------------------------
901: If p_debug_level > 0 Then
902: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);
903: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
904: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
905: end if;
906: If p_process_recs_with_no_org = 'N' Then

Line 903: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);

899: -- BULK Populate Orders Table - l_order_rec
900: -----------------------------------------------------------
901: If p_debug_level > 0 Then
902: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);
903: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
904: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
905: end if;
906: If p_process_recs_with_no_org = 'N' Then
907: v_start := DBMS_UTILITY.GET_TIME;

Line 904: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);

900: -----------------------------------------------------------
901: If p_debug_level > 0 Then
902: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);
903: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
904: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
905: end if;
906: If p_process_recs_with_no_org = 'N' Then
907: v_start := DBMS_UTILITY.GET_TIME;
908: OPEN c_lines_per_order;

Line 923: oe_debug_pub.add('here1');

919: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
920: Elsif p_process_recs_with_no_org = 'Y' Then
921: v_start := DBMS_UTILITY.GET_TIME;
922: If p_debug_level > 0 Then
923: oe_debug_pub.add('here1');
924: End If;
925: OPEN c_lines_per_order_2;
926: FETCH c_lines_per_order_2 BULK COLLECT
927: INTO l_order_rec.order_source_id

Line 944: oe_debug_pub.add('Order Count = '||l_order_count);

940: -----------------------------------------------------------
941:
942: l_order_count := l_order_rec.orig_sys_document_ref.count;
943: If p_debug_level > 0 Then
944: oe_debug_pub.add('Order Count = '||l_order_count);
945: End If;
946: minimum := 0;
947: v_start := DBMS_UTILITY.GET_TIME;
948: l_index := 1;

Line 1029: oe_debug_pub.add(' Found the empty batch'||l_batch_tbl(l_batch_index).batch_id);

1025: AND l_order_rec.org_id(l_index) = l_batch_tbl(l_batch_index).org_id
1026: THEN
1027: -- If batch exists, assign batch number to this order
1028: If p_debug_level > 0 Then
1029: oe_debug_pub.add(' Found the empty batch'||l_batch_tbl(l_batch_index).batch_id);
1030: END IF;
1031: l_batch_tbl(l_batch_index).total_lines :=
1032: l_batch_tbl(l_batch_index).total_lines + l_num_lines;
1033: l_order_rec.batch_id(l_index) := l_batch_tbl(l_batch_index).batch_id;

Line 1047: oe_debug_pub.add('Did not find empty batch so creating a new one');

1043:
1044: IF NOT l_batch_found THEN
1045: -- Generate a new batch_id
1046: If p_debug_level > 0 Then
1047: oe_debug_pub.add('Did not find empty batch so creating a new one');
1048: oe_debug_pub.add('Org_id for this batch is '||l_order_rec.org_id(l_index));
1049: end if;
1050: SELECT oe_batch_id_s.nextval
1051: INTO l_batch_id FROM DUAL;

Line 1048: oe_debug_pub.add('Org_id for this batch is '||l_order_rec.org_id(l_index));

1044: IF NOT l_batch_found THEN
1045: -- Generate a new batch_id
1046: If p_debug_level > 0 Then
1047: oe_debug_pub.add('Did not find empty batch so creating a new one');
1048: oe_debug_pub.add('Org_id for this batch is '||l_order_rec.org_id(l_index));
1049: end if;
1050: SELECT oe_batch_id_s.nextval
1051: INTO l_batch_id FROM DUAL;
1052: l_batch_tbl(l_batch_index).batch_id := l_batch_id;

Line 1128: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);

1124: -- for orders may be skipped.
1125: FOR c IN c_headers(l_instance_tbl(l_index).request_id) LOOP
1126:
1127: If p_debug_level > 0 Then
1128: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);
1129: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);
1130: End If;
1131: UPDATE oe_headers_iface_all
1132: SET header_id = oe_order_headers_s.nextval

Line 1129: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);

1125: FOR c IN c_headers(l_instance_tbl(l_index).request_id) LOOP
1126:
1127: If p_debug_level > 0 Then
1128: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);
1129: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);
1130: End If;
1131: UPDATE oe_headers_iface_all
1132: SET header_id = oe_order_headers_s.nextval
1133: WHERE order_source_id = c.order_source_id

Line 1227: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);

1223: LOOP
1224: FETCH l_batch_cursor INTO l_batch_id,b_org_id;
1225: EXIT WHEN l_batch_cursor%NOTFOUND;
1226: If p_debug_level > 0 Then
1227: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);
1228: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);
1229: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);
1230: end if;
1231:

Line 1228: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);

1224: FETCH l_batch_cursor INTO l_batch_id,b_org_id;
1225: EXIT WHEN l_batch_cursor%NOTFOUND;
1226: If p_debug_level > 0 Then
1227: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);
1228: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);
1229: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);
1230: end if;
1231:
1232: l_entered_orders := G_ENTERED_ORDERS;

Line 1229: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);

1225: EXIT WHEN l_batch_cursor%NOTFOUND;
1226: If p_debug_level > 0 Then
1227: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);
1228: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);
1229: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);
1230: end if;
1231:
1232: l_entered_orders := G_ENTERED_ORDERS;
1233: l_booked_orders := G_BOOKED_ORDERS;

Line 1240: oe_debug_pub.add(' Setting the policy context for '||b_org_id);

1236: IF G_ORG_ID IS NULL OR
1237: (G_ORG_ID IS NOT NULL AND
1238: G_ORG_ID <> b_org_id) Then
1239: If p_debug_level > 0 Then
1240: oe_debug_pub.add(' Setting the policy context for '||b_org_id);
1241: end if;
1242: MO_GLOBAL.SET_POLICY_CONTEXT('S',b_org_id);
1243: G_ORG_ID := b_org_id;
1244:

Line 1273: oe_debug_pub.add(' Calling Process Batch with process Tax :'|| p_process_tax, 1);

1269: -----------------------------------------------------------
1270: -- Call Process_Batch procedure
1271: -----------------------------------------------------------
1272: If p_debug_level > 0 Then
1273: oe_debug_pub.add(' Calling Process Batch with process Tax :'|| p_process_tax, 1);
1274: end if;
1275:
1276: OE_BULK_ORDER_PVT.PROCESS_BATCH (
1277: p_batch_id => l_batch_id,