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 702: l_filename := oe_debug_pub.set_debug_mode ('CONC');

698:
699: IF nvl(p_debug_level, 0) > 0 THEN
700: FND_PROFILE.PUT('ONT_DEBUG_LEVEL',p_debug_level);
701: --moved this stmt in if loop for bug 3747791
702: l_filename := oe_debug_pub.set_debug_mode ('CONC');
703: END IF;
704:
705: -- l_filename := oe_debug_pub.set_debug_mode ('CONC');
706:

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

701: --moved this stmt in if loop for bug 3747791
702: l_filename := oe_debug_pub.set_debug_mode ('CONC');
703: END IF;
704:
705: -- l_filename := oe_debug_pub.set_debug_mode ('CONC');
706:
707: -----------------------------------------------------------
708: -- Get Concurrent Request Id
709: -----------------------------------------------------------

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

719: End If;
720: l_default_org_id := MO_UTILS.get_default_org_id;
721:
722: If p_debug_level > 0 Then
723: oe_debug_pub.add('Default Org Id '||l_default_org_id);
724: End If;
725:
726: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '|| to_char(p_operating_unit));
727: fnd_file.put_line(FND_FILE.OUTPUT, '');

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

756: END ;
757: END LOOP;
758:
759: if p_debug_level >0 then
760: oe_debug_pub.add('process recs with no org '||p_process_recs_with_no_org);
761: oe_debug_pub.add('G_CONFIG_EFFECT_DATE'||OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE);
762: end if;
763: --End bug 4685432
764:

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

757: END LOOP;
758:
759: if p_debug_level >0 then
760: oe_debug_pub.add('process recs with no org '||p_process_recs_with_no_org);
761: oe_debug_pub.add('G_CONFIG_EFFECT_DATE'||OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE);
762: end if;
763: --End bug 4685432
764:
765: -----------------------------------------------------------

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

781: BEGIN
782:
783: If p_process_recs_with_no_org = 'Y' Then
784:
785: oe_debug_pub.add('p_process_recs_with_no_org =Y',1);
786:
787: SELECT count(orig_sys_document_ref)
788: INTO l_row_count
789: FROM(

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

887: AND NVL(h.org_id, l_default_org_id) =
888: NVL(a.org_id, l_default_org_id)
889: AND operation_code <> 'BOOK_ORDER'));
890: if p_debug_level > 0 then
891: oe_debug_pub.add('the number of orders to process is '||l_row_count);
892: end if;
893: Else
894:
895: -- No need to select NULL org_id records.

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

892: end if;
893: Else
894:
895: -- No need to select NULL org_id records.
896: oe_debug_pub.add('p_process_recs_with_no_org =N',1);
897: SELECT /* MOAC_SQL_CHANGE */ count(*)
898: INTO l_row_count
899: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
900: oe_sys_parameters_all sys

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

932: AND a.org_id = h.org_id
933: AND operation_code <> 'BOOK_ORDER');
934: End If;
935: IF l_row_count = 0 THEN
936: oe_debug_pub.add('No Data found in the IFCAE table');
937: RAISE NO_DATA_FOUND;
938: END IF;
939:
940: EXCEPTION

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

952:
953:
954:
955: If p_debug_level > 0 Then
956: oe_debug_pub.add('Remaining Header Row Count is '||l_row_count);
957: end if;
958: IF l_num_instances > l_row_count THEN
959: l_num_instances := l_row_count;
960: END IF;

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

993: -----------------------------------------------------------
994: -- BULK Populate Orders Table - l_order_rec
995: -----------------------------------------------------------
996: If p_debug_level > 0 Then
997: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);
998: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
999: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
1000: end if;
1001: If p_process_recs_with_no_org = 'N' Then

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

994: -- BULK Populate Orders Table - l_order_rec
995: -----------------------------------------------------------
996: If p_debug_level > 0 Then
997: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);
998: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
999: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
1000: end if;
1001: If p_process_recs_with_no_org = 'N' Then
1002: v_start := DBMS_UTILITY.GET_TIME;

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

995: -----------------------------------------------------------
996: If p_debug_level > 0 Then
997: oe_debug_pub.add('p_operating_unit = '||p_operating_unit);
998: oe_debug_pub.add('p_process_recs_with_no_org = '||p_process_recs_with_no_org);
999: oe_debug_pub.add('l_default_org_id = '||l_default_org_id);
1000: end if;
1001: If p_process_recs_with_no_org = 'N' Then
1002: v_start := DBMS_UTILITY.GET_TIME;
1003: OPEN c_lines_per_order;

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

1014: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
1015: Elsif p_process_recs_with_no_org = 'Y' Then
1016: v_start := DBMS_UTILITY.GET_TIME;
1017: If p_debug_level > 0 Then
1018: oe_debug_pub.add('here1');
1019: End If;
1020: OPEN c_lines_per_order_2;
1021: FETCH c_lines_per_order_2 BULK COLLECT
1022: INTO l_order_rec.order_source_id

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

1035: -----------------------------------------------------------
1036:
1037: l_order_count := l_order_rec.orig_sys_document_ref.count;
1038: If p_debug_level > 0 Then
1039: oe_debug_pub.add('Order Count = '||l_order_count);
1040: End If;
1041: minimum := 0;
1042: v_start := DBMS_UTILITY.GET_TIME;
1043: l_index := 1;

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

1120: AND l_order_rec.org_id(l_index) = l_batch_tbl(l_batch_index).org_id
1121: THEN
1122: -- If batch exists, assign batch number to this order
1123: If p_debug_level > 0 Then
1124: oe_debug_pub.add(' Found the empty batch'||l_batch_tbl(l_batch_index).batch_id);
1125: END IF;
1126: l_batch_tbl(l_batch_index).total_lines :=
1127: l_batch_tbl(l_batch_index).total_lines + l_num_lines;
1128: l_order_rec.batch_id(l_index) := l_batch_tbl(l_batch_index).batch_id;

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

1138:
1139: IF NOT l_batch_found THEN
1140: -- Generate a new batch_id
1141: If p_debug_level > 0 Then
1142: oe_debug_pub.add('Did not find empty batch so creating a new one');
1143: oe_debug_pub.add('Org_id for this batch is '||l_order_rec.org_id(l_index));
1144: end if;
1145: SELECT oe_batch_id_s.nextval
1146: INTO l_batch_id FROM DUAL;

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

1139: IF NOT l_batch_found THEN
1140: -- Generate a new batch_id
1141: If p_debug_level > 0 Then
1142: oe_debug_pub.add('Did not find empty batch so creating a new one');
1143: oe_debug_pub.add('Org_id for this batch is '||l_order_rec.org_id(l_index));
1144: end if;
1145: SELECT oe_batch_id_s.nextval
1146: INTO l_batch_id FROM DUAL;
1147: l_batch_tbl(l_batch_index).batch_id := l_batch_id;

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

1219: -- for orders may be skipped.
1220: FOR c IN c_headers(l_instance_tbl(l_index).request_id) LOOP
1221:
1222: If p_debug_level > 0 Then
1223: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);
1224: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);
1225: End If;
1226: UPDATE oe_headers_iface_all
1227: SET header_id = oe_order_headers_s.nextval

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

1220: FOR c IN c_headers(l_instance_tbl(l_index).request_id) LOOP
1221:
1222: If p_debug_level > 0 Then
1223: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);
1224: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);
1225: End If;
1226: UPDATE oe_headers_iface_all
1227: SET header_id = oe_order_headers_s.nextval
1228: WHERE order_source_id = c.order_source_id

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

1318: LOOP
1319: FETCH l_batch_cursor INTO l_batch_id,b_org_id;
1320: EXIT WHEN l_batch_cursor%NOTFOUND;
1321: If p_debug_level > 0 Then
1322: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);
1323: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);
1324: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);
1325: end if;
1326:

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

1319: FETCH l_batch_cursor INTO l_batch_id,b_org_id;
1320: EXIT WHEN l_batch_cursor%NOTFOUND;
1321: If p_debug_level > 0 Then
1322: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);
1323: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);
1324: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);
1325: end if;
1326:
1327: l_entered_orders := G_ENTERED_ORDERS;

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

1320: EXIT WHEN l_batch_cursor%NOTFOUND;
1321: If p_debug_level > 0 Then
1322: oe_debug_pub.add(' Inside the Batch cursor for org '||b_org_id);
1323: oe_debug_pub.add(' Inside the Batch cursor for batch '||l_batch_id);
1324: oe_debug_pub.add(' The G_ORG_ID is '||G_ORG_ID);
1325: end if;
1326:
1327: l_entered_orders := G_ENTERED_ORDERS;
1328: l_booked_orders := G_BOOKED_ORDERS;

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

1331: IF G_ORG_ID IS NULL OR
1332: (G_ORG_ID IS NOT NULL AND
1333: G_ORG_ID <> b_org_id) Then
1334: If p_debug_level > 0 Then
1335: oe_debug_pub.add(' Setting the policy context for '||b_org_id);
1336: end if;
1337: MO_GLOBAL.SET_POLICY_CONTEXT('S',b_org_id);
1338: G_ORG_ID := b_org_id;
1339:

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

1364: -----------------------------------------------------------
1365: -- Call Process_Batch procedure
1366: -----------------------------------------------------------
1367: If p_debug_level > 0 Then
1368: oe_debug_pub.add(' Calling Process Batch with process Tax :'|| p_process_tax, 1);
1369: end if;
1370:
1371: OE_BULK_ORDER_PVT.PROCESS_BATCH (
1372: p_batch_id => l_batch_id,