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

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

68: l_header_txt VARCHAR2(2000);
69: l_descriptor VARCHAR2(2000);
70: --
71: --
72: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
73: --
74: l_salesrep VARCHAR2(240) := NULL;
75: l_salesrep_id NUMBER;
76: l_org_id NUMBER;

Line 169: oe_debug_pub.add('Entering purge_error_flow for itemtype/itemkey:' || p_item_type || '/' || p_item_key);

165: BEGIN
166:
167: -- There could be multiple error flows associated with this item key so
168: -- we want to purge all of them.
169: oe_debug_pub.add('Entering purge_error_flow for itemtype/itemkey:' || p_item_type || '/' || p_item_key);
170: open err_flow;
171: loop
172: fetch err_flow into l_item_type, l_item_key, l_process_name;
173: exit when err_flow%NOTFOUND;

Line 174: OE_Debug_PUB.Add('Purge Error Flow for: ' || p_item_type || '/' || p_item_key);

170: open err_flow;
171: loop
172: fetch err_flow into l_item_type, l_item_key, l_process_name;
173: exit when err_flow%NOTFOUND;
174: OE_Debug_PUB.Add('Purge Error Flow for: ' || p_item_type || '/' || p_item_key);
175:
176: /* Abort the process before it can be purged */
177: wf_engine.abortprocess(itemtype => l_item_type,
178: itemkey => l_item_key,

Line 188: oe_debug_pub.add('Exiting purge_error_flow' );

184: docommit => false);
185: end loop;
186:
187:
188: oe_debug_pub.add('Exiting purge_error_flow' );
189: end purge_error_flow;
190:
191: PROCEDURE Initialize_Errors( itemtype VARCHAR2,
192: itemkey VARCHAR2,

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

273: l_activity_id number;
274:
275: l_conc_msg varchar2(2000);
276:
277: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
278: --
279: l_conc_req_url varchar2(2000);
280: l_mgr_log varchar2(2000);
281: l_result boolean;

Line 372: -- oe_debug_pub.add ('l_result:' || l_result);

368:
369: --wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
370: -- l_conc_req_url);
371:
372: -- oe_debug_pub.add ('l_result:' || l_result);
373: -- oe_debug_pub.add ('URL:' || l_conc_req_url);
374: -- oe_debug_pub.add ('l_mgr_log:' || l_mgr_log);
375:
376:

Line 373: -- oe_debug_pub.add ('URL:' || l_conc_req_url);

369: --wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
370: -- l_conc_req_url);
371:
372: -- oe_debug_pub.add ('l_result:' || l_result);
373: -- oe_debug_pub.add ('URL:' || l_conc_req_url);
374: -- oe_debug_pub.add ('l_mgr_log:' || l_mgr_log);
375:
376:
377: resultout := 'COMPLETE';

Line 374: -- oe_debug_pub.add ('l_mgr_log:' || l_mgr_log);

370: -- l_conc_req_url);
371:
372: -- oe_debug_pub.add ('l_result:' || l_result);
373: -- oe_debug_pub.add ('URL:' || l_conc_req_url);
374: -- oe_debug_pub.add ('l_mgr_log:' || l_mgr_log);
375:
376:
377: resultout := 'COMPLETE';
378: return;

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

421: l_itemkey varchar2(240);
422: err_itemtype varchar2(8);
423: err_itemkey varchar2(240);
424: --
425: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
426: --
427: l_salesrep VARCHAR2(240) := NULL;
428: l_salesrep_id NUMBER;
429: l_org_id NUMBER;

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

1137: p_itemkey IN VARCHAR2,
1138: x_order_source_id OUT NOCOPY NUMBER,
1139: x_orig_sys_document_ref OUT NOCOPY VARCHAR2)
1140: IS
1141: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1142: BEGIN
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('Entering Get_EM_Key_Info');
1145: END IF;

Line 1144: oe_debug_pub.add('Entering Get_EM_Key_Info');

1140: IS
1141: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1142: BEGIN
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('Entering Get_EM_Key_Info');
1145: END IF;
1146:
1147: If p_itemtype IN ('OEOI','OEOA','OESO') Then
1148:

Line 1169: oe_debug_pub.add('Exiting Get_EM_Key_Info with order_source_id: ' || x_order_source_id || ' and orig_sys_document_ref: ' || x_orig_sys_document_ref);

1165: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARTNER_DOCUMENT_NO');
1166:
1167: END IF;
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add('Exiting Get_EM_Key_Info with order_source_id: ' || x_order_source_id || ' and orig_sys_document_ref: ' || x_orig_sys_document_ref);
1170: END IF;
1171: END Get_EM_Key_Info;
1172:
1173: FUNCTION Get_Activity_Display_Name (p_activity_item_type IN VARCHAR2,

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

1174: p_activity_name IN VARCHAR2)
1175: RETURN VARCHAR2
1176: IS
1177: l_activity_display_name VARCHAR2(80);
1178: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1179: BEGIN
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add('Entering Get_Activity_Display_Name');
1182: END IF;

Line 1181: oe_debug_pub.add('Entering Get_Activity_Display_Name');

1177: l_activity_display_name VARCHAR2(80);
1178: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1179: BEGIN
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add('Entering Get_Activity_Display_Name');
1182: END IF;
1183: SELECT display_name
1184: INTO l_activity_display_name
1185: FROM WF_Activities_VL

Line 1193: oe_debug_pub.add('Exiting Get_Activity_Display_Name with result: ' ||l_activity_display_name);

1189: FROM WF_Activities_VL
1190: WHERE Name = p_activity_name
1191: AND Item_Type = p_activity_item_type);
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add('Exiting Get_Activity_Display_Name with result: ' ||l_activity_display_name);
1194: END IF;
1195: RETURN l_activity_display_name;
1196: EXCEPTION
1197: WHEN OTHERS THEN

Line 1199: oe_debug_pub.add('Exception in Get_Activity_Display_Name, returning Activity Name instead: '||p_activity_name);

1195: RETURN l_activity_display_name;
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: IF l_debug_level > 0 THEN
1199: oe_debug_pub.add('Exception in Get_Activity_Display_Name, returning Activity Name instead: '||p_activity_name);
1200: END IF;
1201: RETURN p_activity_name;
1202: END Get_Activity_Display_Name;
1203:

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

1214: l_hash_value NUMBER;
1215: l_initial_count NUMBER;
1216: l_final_count NUMBER;
1217: l_activity_display_name VARCHAR2(80);
1218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1219: BEGIN
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add('Entering Put');
1222: END IF;

Line 1221: oe_debug_pub.add('Entering Put');

1217: l_activity_display_name VARCHAR2(80);
1218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1219: BEGIN
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add('Entering Put');
1222: END IF;
1223:
1224: l_initial_count := nvl(p_initial_count, 0);
1225: l_final_count := nvl(p_final_count, 0);

Line 1229: oe_debug_pub.add('Put:hash_value:'||l_tab_index,1);

1225: l_final_count := nvl(p_final_count, 0);
1226:
1227: l_tab_index := dbms_utility.get_hash_value(p_concat_segment,1,TABLE_SIZE);
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add('Put:hash_value:'||l_tab_index,1);
1230: END IF;
1231: IF Count_Tbl.EXISTS(l_tab_index) THEN
1232: IF Count_Tbl(l_tab_index).concat_segment = p_concat_segment THEN
1233: Count_Tbl(l_tab_index).initial_count := Count_Tbl(l_tab_index).initial_count + l_initial_count;

Line 1238: oe_debug_pub.add(p_concat_segment || ' Initial ' || Count_Tbl(l_tab_index).initial_count);

1234: Count_Tbl(l_tab_index).final_count := Count_Tbl(l_tab_index).final_count + l_final_count;
1235: l_activity_display_name := Count_Tbl(l_tab_index).activity_display_name;
1236: l_stored := TRUE;
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add(p_concat_segment || ' Initial ' || Count_Tbl(l_tab_index).initial_count);
1239: oe_debug_pub.add(p_concat_segment || ' Final ' || Count_Tbl(l_tab_index).final_count);
1240: END IF;
1241:
1242: ELSE

Line 1239: oe_debug_pub.add(p_concat_segment || ' Final ' || Count_Tbl(l_tab_index).final_count);

1235: l_activity_display_name := Count_Tbl(l_tab_index).activity_display_name;
1236: l_stored := TRUE;
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add(p_concat_segment || ' Initial ' || Count_Tbl(l_tab_index).initial_count);
1239: oe_debug_pub.add(p_concat_segment || ' Final ' || Count_Tbl(l_tab_index).final_count);
1240: END IF;
1241:
1242: ELSE
1243: l_hash_value := l_tab_index;

Line 1253: oe_debug_pub.add(p_concat_segment || ' 1Initial ' || Count_Tbl(l_tab_index).initial_count);

1249: Count_Tbl(l_tab_index).final_count := Count_Tbl(l_tab_index).final_count + l_final_count;
1250: l_activity_display_name := Count_Tbl(l_tab_index).activity_display_name;
1251: l_stored := TRUE;
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add(p_concat_segment || ' 1Initial ' || Count_Tbl(l_tab_index).initial_count);
1254: oe_debug_pub.add(p_concat_segment || ' 1Final ' || Count_Tbl(l_tab_index).final_count);
1255: END IF;
1256: ELSE
1257: l_tab_index := l_tab_index +1;

Line 1254: oe_debug_pub.add(p_concat_segment || ' 1Final ' || Count_Tbl(l_tab_index).final_count);

1250: l_activity_display_name := Count_Tbl(l_tab_index).activity_display_name;
1251: l_stored := TRUE;
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add(p_concat_segment || ' 1Initial ' || Count_Tbl(l_tab_index).initial_count);
1254: oe_debug_pub.add(p_concat_segment || ' 1Final ' || Count_Tbl(l_tab_index).final_count);
1255: END IF;
1256: ELSE
1257: l_tab_index := l_tab_index +1;
1258: END IF;

Line 1268: oe_debug_pub.add(p_concat_segment || ' 2Initial ' || Count_Tbl(l_tab_index).initial_count);

1264: Count_Tbl(l_tab_index).activity_name := p_activity_name;
1265: Count_Tbl(l_tab_index).process_item_type := p_process_item_type;
1266: Count_Tbl(l_tab_index).concat_segment := p_concat_segment;
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add(p_concat_segment || ' 2Initial ' || Count_Tbl(l_tab_index).initial_count);
1269: oe_debug_pub.add(p_concat_segment || ' 2Final ' || Count_Tbl(l_tab_index).final_count);
1270: END IF;
1271: l_stored := TRUE;
1272: END IF;

Line 1269: oe_debug_pub.add(p_concat_segment || ' 2Final ' || Count_Tbl(l_tab_index).final_count);

1265: Count_Tbl(l_tab_index).process_item_type := p_process_item_type;
1266: Count_Tbl(l_tab_index).concat_segment := p_concat_segment;
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add(p_concat_segment || ' 2Initial ' || Count_Tbl(l_tab_index).initial_count);
1269: oe_debug_pub.add(p_concat_segment || ' 2Final ' || Count_Tbl(l_tab_index).final_count);
1270: END IF;
1271: l_stored := TRUE;
1272: END IF;
1273: END LOOP;

Line 1285: oe_debug_pub.add(p_concat_segment || ' 3Initial ' || Count_Tbl(l_tab_index).initial_count);

1281: Count_Tbl(l_tab_index).final_count := Count_Tbl(l_tab_index).final_count + l_final_count;
1282: l_activity_display_name := Count_Tbl(l_tab_index).activity_display_name;
1283: l_stored := TRUE;
1284: IF l_debug_level > 0 THEN
1285: oe_debug_pub.add(p_concat_segment || ' 3Initial ' || Count_Tbl(l_tab_index).initial_count);
1286: oe_debug_pub.add(p_concat_segment || ' 3Final ' || Count_Tbl(l_tab_index).final_count);
1287: END IF;
1288: ELSE
1289: l_tab_index := l_tab_index +1;

Line 1286: oe_debug_pub.add(p_concat_segment || ' 3Final ' || Count_Tbl(l_tab_index).final_count);

1282: l_activity_display_name := Count_Tbl(l_tab_index).activity_display_name;
1283: l_stored := TRUE;
1284: IF l_debug_level > 0 THEN
1285: oe_debug_pub.add(p_concat_segment || ' 3Initial ' || Count_Tbl(l_tab_index).initial_count);
1286: oe_debug_pub.add(p_concat_segment || ' 3Final ' || Count_Tbl(l_tab_index).final_count);
1287: END IF;
1288: ELSE
1289: l_tab_index := l_tab_index +1;
1290: END IF;

Line 1300: oe_debug_pub.add(p_concat_segment || ' 4Initial ' || Count_Tbl(l_tab_index).initial_count);

1296: Count_Tbl(l_tab_index).activity_name := p_activity_name;
1297: Count_Tbl(l_tab_index).process_item_type := p_process_item_type;
1298: Count_Tbl(l_tab_index).concat_segment := p_concat_segment;
1299: IF l_debug_level > 0 THEN
1300: oe_debug_pub.add(p_concat_segment || ' 4Initial ' || Count_Tbl(l_tab_index).initial_count);
1301: oe_debug_pub.add(p_concat_segment || ' 4Final ' || Count_Tbl(l_tab_index).final_count);
1302: END IF;
1303: l_stored := TRUE;
1304: END IF;

Line 1301: oe_debug_pub.add(p_concat_segment || ' 4Final ' || Count_Tbl(l_tab_index).final_count);

1297: Count_Tbl(l_tab_index).process_item_type := p_process_item_type;
1298: Count_Tbl(l_tab_index).concat_segment := p_concat_segment;
1299: IF l_debug_level > 0 THEN
1300: oe_debug_pub.add(p_concat_segment || ' 4Initial ' || Count_Tbl(l_tab_index).initial_count);
1301: oe_debug_pub.add(p_concat_segment || ' 4Final ' || Count_Tbl(l_tab_index).final_count);
1302: END IF;
1303: l_stored := TRUE;
1304: END IF;
1305: END LOOP;

Line 1318: oe_debug_pub.add(p_concat_segment || ' 5Initial ' || Count_Tbl(l_tab_index).initial_count);

1314: Count_Tbl(l_tab_index).activity_name := p_activity_name;
1315: Count_Tbl(l_tab_index).process_item_type := p_process_item_type;
1316: Count_Tbl(l_tab_index).concat_segment := p_concat_segment;
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add(p_concat_segment || ' 5Initial ' || Count_Tbl(l_tab_index).initial_count);
1319: oe_debug_pub.add(p_concat_segment || ' 5Final ' || Count_Tbl(l_tab_index).final_count);
1320: END IF;
1321: l_stored := TRUE;
1322: END IF;

Line 1319: oe_debug_pub.add(p_concat_segment || ' 5Final ' || Count_Tbl(l_tab_index).final_count);

1315: Count_Tbl(l_tab_index).process_item_type := p_process_item_type;
1316: Count_Tbl(l_tab_index).concat_segment := p_concat_segment;
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add(p_concat_segment || ' 5Initial ' || Count_Tbl(l_tab_index).initial_count);
1319: oe_debug_pub.add(p_concat_segment || ' 5Final ' || Count_Tbl(l_tab_index).final_count);
1320: END IF;
1321: l_stored := TRUE;
1322: END IF;
1323: x_activity_display_name := l_activity_display_name;

Line 1325: oe_debug_pub.add('Exiting Put with activity display name: ' || l_activity_display_name);

1321: l_stored := TRUE;
1322: END IF;
1323: x_activity_display_name := l_activity_display_name;
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add('Exiting Put with activity display name: ' || l_activity_display_name);
1326: END IF;
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: IF l_debug_level > 0 THEN

Line 1330: oe_debug_pub.add('Exiting Put with unexpected error: ' || SQLERRM);

1326: END IF;
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add('Exiting Put with unexpected error: ' || SQLERRM);
1331: END IF;
1332: NULL;
1333: END put;
1334:

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

1339: IS
1340: l_count NUMBER;
1341: l_source_code_oe CONSTANT VARCHAR2(2) := 'OE';
1342: l_released_status_closed CONSTANT VARCHAR2(1) := 'C';
1343: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1344: BEGIN
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add('Entering Check_Closed_Delivery_Detail');
1347: END IF;

Line 1346: oe_debug_pub.add('Entering Check_Closed_Delivery_Detail');

1342: l_released_status_closed CONSTANT VARCHAR2(1) := 'C';
1343: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1344: BEGIN
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add('Entering Check_Closed_Delivery_Detail');
1347: END IF;
1348: SELECT 1
1349: INTO l_count
1350: FROM wsh_delivery_details

Line 1356: oe_debug_pub.add('Closed delivery detail exists');

1352: AND source_code = l_source_code_oe
1353: AND released_status = l_released_status_closed
1354: AND rownum < 2;
1355: IF l_debug_level > 0 THEN
1356: oe_debug_pub.add('Closed delivery detail exists');
1357: END IF;
1358:
1359: BEGIN
1360: Wf_Item_Activity_Status.Create_Status (itemtype => 'OEOL',

Line 1370: oe_debug_pub.add('Unexpected error: Cound not create notified status '|| SQLERRM);

1366: ending => null);
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: IF l_debug_level > 0 THEN
1370: oe_debug_pub.add('Unexpected error: Cound not create notified status '|| SQLERRM);
1371: END IF;
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- cause rollback in caller
1373: END;
1374:

Line 1376: oe_debug_pub.add('Exiting Check_Closed_Delivery_Detail, Return True');

1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- cause rollback in caller
1373: END;
1374:
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add('Exiting Check_Closed_Delivery_Detail, Return True');
1377: END IF;
1378: RETURN TRUE;
1379: EXCEPTION
1380: WHEN NO_DATA_FOUND THEN

Line 1382: oe_debug_pub.add('Exiting Check_Closed_Delivery_Detail, Return False');

1378: RETURN TRUE;
1379: EXCEPTION
1380: WHEN NO_DATA_FOUND THEN
1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add('Exiting Check_Closed_Delivery_Detail, Return False');
1383: END IF;
1384: RETURN FALSE;
1385: WHEN OTHERS THEN
1386: IF l_debug_level > 0 THEN

Line 1387: oe_debug_pub.add('Exiting Check_Closed_Delivery_Detail, Return False and unexpected error '|| SQLERRM);

1383: END IF;
1384: RETURN FALSE;
1385: WHEN OTHERS THEN
1386: IF l_debug_level > 0 THEN
1387: oe_debug_pub.add('Exiting Check_Closed_Delivery_Detail, Return False and unexpected error '|| SQLERRM);
1388: END IF;
1389: RAISE;
1390: END Check_Closed_Delivery_Detail;
1391:

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

1394: p_activity_id IN NUMBER,
1395: p_mode IN VARCHAR2,
1396: p_x_result IN OUT NOCOPY VARCHAR2)
1397: IS
1398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1399: BEGIN
1400: IF l_debug_level > 0 THEN
1401: oe_debug_pub.add('Entering Call_OM_Selector');
1402: oe_debug_pub.add('Calling selector function for item type: '|| p_item_type || ' item key: ' || p_item_key || ' activity_id: ' || p_activity_id || ' mode: ' || p_mode);

Line 1401: oe_debug_pub.add('Entering Call_OM_Selector');

1397: IS
1398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1399: BEGIN
1400: IF l_debug_level > 0 THEN
1401: oe_debug_pub.add('Entering Call_OM_Selector');
1402: oe_debug_pub.add('Calling selector function for item type: '|| p_item_type || ' item key: ' || p_item_key || ' activity_id: ' || p_activity_id || ' mode: ' || p_mode);
1403: END IF;
1404:
1405: p_x_result := NULL;

Line 1402: oe_debug_pub.add('Calling selector function for item type: '|| p_item_type || ' item key: ' || p_item_key || ' activity_id: ' || p_activity_id || ' mode: ' || p_mode);

1398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1399: BEGIN
1400: IF l_debug_level > 0 THEN
1401: oe_debug_pub.add('Entering Call_OM_Selector');
1402: oe_debug_pub.add('Calling selector function for item type: '|| p_item_type || ' item key: ' || p_item_key || ' activity_id: ' || p_activity_id || ' mode: ' || p_mode);
1403: END IF;
1404:
1405: p_x_result := NULL;
1406:

Line 1454: oe_debug_pub.add('Exiting Call_OM_Selector with result: ' || p_x_result);

1450: p_activity_id,
1451: p_mode, p_x_result);
1452: END IF;
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add('Exiting Call_OM_Selector with result: ' || p_x_result);
1455: END IF;
1456:
1457: END;
1458:

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

1461: p_activity_id IN VARCHAR2)
1462: RETURN BOOLEAN
1463: IS
1464: l_count NUMBER;
1465: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1466: l_error_status CONSTANT VARCHAR2(5) := 'ERROR';
1467: BEGIN
1468: l_count := 0;
1469:

Line 1485: oe_debug_pub.add ('Error count of ' || l_count);

1481: l_count := 0;
1482: END;
1483:
1484: IF l_debug_level > 0 THEN
1485: oe_debug_pub.add ('Error count of ' || l_count);
1486: END IF;
1487:
1488: RETURN (l_count <> 0);
1489:

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

1498: IS
1499: l_pos NUMBER;
1500: l_pos2 NUMBER;
1501: l_pos3 NUMBER;
1502: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1503: BEGIN
1504: IF l_debug_level > 0 THEN
1505: oe_debug_pub.add('Entering Parse_User_Key');
1506: END IF;

Line 1505: oe_debug_pub.add('Entering Parse_User_Key');

1501: l_pos3 NUMBER;
1502: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1503: BEGIN
1504: IF l_debug_level > 0 THEN
1505: oe_debug_pub.add('Entering Parse_User_Key');
1506: END IF;
1507: IF p_item_type IN ('OEOI', 'OESO', 'OEOA') THEN
1508: x_order_source_id := 20;
1509: l_pos := instr (p_user_key, ',');

Line 1533: oe_debug_pub.add('Exiting Parse_User_Key with order_source_id: '|| x_order_source_id ||

1529:
1530: END IF;
1531:
1532: IF l_debug_level > 0 THEN
1533: oe_debug_pub.add('Exiting Parse_User_Key with order_source_id: '|| x_order_source_id ||
1534: ' and orig_sys_document_ref : ' || x_orig_sys_document_ref);
1535: END IF;
1536: EXCEPTION
1537: WHEN OTHERS THEN

Line 1540: oe_debug_pub.add('Exiting Parse_User_Key with order_source_id: '|| x_order_source_id ||

1536: EXCEPTION
1537: WHEN OTHERS THEN
1538: NULL; -- don't completely bail as we can still check the WF item attrs
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add('Exiting Parse_User_Key with order_source_id: '|| x_order_source_id ||
1541: ' and orig_sys_document_ref : ' || x_orig_sys_document_ref || ' and unexpected error: ' || SQLERRM);
1542: END IF;
1543: END Parse_User_Key;
1544:

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

1552: l_msg_rec Msg_Rec_Type;
1553: l_open CONSTANT VARCHAR2(4) := 'OPEN';
1554: l_closed CONSTANT VARCHAR2(6) := 'CLOSED';
1555: l_entity_code VARCHAR2(30);
1556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1557:
1558: CURSOR l_msg_cursor_1 IS
1559: SELECT tl.message_text
1560: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl

Line 1605: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 1 for item type ' ||p_item_type);

1601: OPEN l_msg_cursor_1;
1602: FETCH l_msg_cursor_1 BULK COLLECT INTO
1603: l_msg_rec.message_text LIMIT 1000;
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 1 for item type ' ||p_item_type);
1606: END IF;
1607: FOR i in 1..l_msg_rec.message_text.count LOOP
1608: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));
1609: END LOOP;

Line 1616: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 2 for item type ' ||p_item_type);

1612: OPEN l_msg_cursor_2;
1613: FETCH l_msg_cursor_2 BULK COLLECT INTO
1614: l_msg_rec.message_text LIMIT 1000;
1615: IF l_debug_level > 0 THEN
1616: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 2 for item type ' ||p_item_type);
1617: END IF;
1618: FOR i in 1..l_msg_rec.message_text.count LOOP
1619: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));
1620: END LOOP;

Line 1629: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 3 for item type ' ||p_item_type);

1625: OPEN l_msg_cursor_3;
1626: FETCH l_msg_cursor_3 BULK COLLECT INTO
1627: l_msg_rec.message_text LIMIT 1000;
1628: IF l_debug_level > 0 THEN
1629: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 3 for item type ' ||p_item_type);
1630: END IF;
1631: FOR i in 1..l_msg_rec.message_text.count LOOP
1632: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));
1633: END LOOP;

Line 1642: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 4 for item type ' ||p_item_type);

1638: OPEN l_msg_cursor_4;
1639: FETCH l_msg_cursor_4 BULK COLLECT INTO
1640: l_msg_rec.message_text LIMIT 1000;
1641: IF l_debug_level > 0 THEN
1642: oe_debug_pub.add('Fetched ' || l_msg_rec.message_text.count || ' records from msg cursor 4 for item type ' ||p_item_type);
1643: END IF;
1644: FOR i in 1..l_msg_rec.message_text.count LOOP
1645: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));
1646: END LOOP;

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

1664: RETURN BOOLEAN IS
1665:
1666: l_ord_num NUMBER;
1667: l_hdr_id NUMBER;
1668: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1669: BEGIN
1670:
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('Entering oe_error_wf.get_lock ');

Line 1672: oe_debug_pub.add('Entering oe_error_wf.get_lock ');

1668: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1669: BEGIN
1670:
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('Entering oe_error_wf.get_lock ');
1673: END IF;
1674:
1675: IF p_item_type in ('OEOH','OENH') THEN
1676:

Line 1709: oe_debug_pub.add('TIMEOUT_ON_RESOURCE Exception while locking the record in oe_errors_wf.get_lock for item ' ||p_item_type||' with key '||p_item_key);

1705: EXCEPTION
1706: /*
1707: WHEN TIMEOUT_ON_RESOURCE THEN
1708: IF l_debug_level > 0 THEN
1709: oe_debug_pub.add('TIMEOUT_ON_RESOURCE Exception while locking the record in oe_errors_wf.get_lock for item ' ||p_item_type||' with key '||p_item_key);
1710: oe_debug_pub.add('The SQL ERROR is '||substr(SQLERRM, 1, 512));
1711: END IF;
1712: return false;
1713: */

Line 1710: oe_debug_pub.add('The SQL ERROR is '||substr(SQLERRM, 1, 512));

1706: /*
1707: WHEN TIMEOUT_ON_RESOURCE THEN
1708: IF l_debug_level > 0 THEN
1709: oe_debug_pub.add('TIMEOUT_ON_RESOURCE Exception while locking the record in oe_errors_wf.get_lock for item ' ||p_item_type||' with key '||p_item_key);
1710: oe_debug_pub.add('The SQL ERROR is '||substr(SQLERRM, 1, 512));
1711: END IF;
1712: return false;
1713: */
1714: WHEN OTHERS THEN

Line 1716: oe_debug_pub.add('Exception while locking the record in oe_errors_wf.get_lock for item ' ||p_item_type||' with key '||p_item_key);

1712: return false;
1713: */
1714: WHEN OTHERS THEN
1715: IF l_debug_level > 0 THEN
1716: oe_debug_pub.add('Exception while locking the record in oe_errors_wf.get_lock for item ' ||p_item_type||' with key '||p_item_key);
1717: oe_debug_pub.add('The SQL ERROR is '||substr(SQLERRM, 1, 512));
1718: END IF;
1719: return false;
1720: -- raise;

Line 1717: oe_debug_pub.add('The SQL ERROR is '||substr(SQLERRM, 1, 512));

1713: */
1714: WHEN OTHERS THEN
1715: IF l_debug_level > 0 THEN
1716: oe_debug_pub.add('Exception while locking the record in oe_errors_wf.get_lock for item ' ||p_item_type||' with key '||p_item_key);
1717: oe_debug_pub.add('The SQL ERROR is '||substr(SQLERRM, 1, 512));
1718: END IF;
1719: return false;
1720: -- raise;
1721: END get_lock;

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

1804: l_org_id CONSTANT VARCHAR2(6) := 'ORG_ID';
1805: l_retry_count NUMBER;
1806: l_commit_count NUMBER;
1807: p_x_result VARCHAR2(10);
1808: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1809: l_ignore_error_check BOOLEAN;
1810: l_header_id NUMBER;
1811: l_order_source_id NUMBER;
1812: l_orig_sys_document_ref VARCHAR2(50);

Line 1981: oe_debug_pub.add('Entering Retry_Flows');

1977: l_retry_rec Retry_Rec_Type;
1978:
1979: BEGIN
1980: IF l_debug_level > 0 THEN
1981: oe_debug_pub.add('Entering Retry_Flows');
1982: END IF;
1983: G_BATCH_RETRY_FLAG := 'Y';
1984: l_commit_count := 0;
1985:

Line 2011: oe_debug_pub.add ('fetching from cursor 1');

2007:
2008: LOOP
2009: IF l_retry_cursor_1%ISOPEN THEN
2010: IF l_debug_level > 0 THEN
2011: oe_debug_pub.add ('fetching from cursor 1');
2012: END IF;
2013: FETCH l_retry_cursor_1 BULK COLLECT INTO
2014: l_retry_rec.item_key,
2015: l_retry_rec.activity_label,

Line 2028: oe_debug_pub.add ('fetching from cursor 2');

2024: LIMIT 1000;
2025:
2026: ELSIF l_retry_cursor_2%ISOPEN THEN
2027: IF l_debug_level > 0 THEN
2028: oe_debug_pub.add ('fetching from cursor 2');
2029: END IF;
2030: FETCH l_retry_cursor_2 BULK COLLECT INTO
2031: l_retry_rec.item_key,
2032: l_retry_rec.activity_label,

Line 2045: oe_debug_pub.add ('fetching from cursor 3');

2041: LIMIT 1000;
2042:
2043: ELSIF l_retry_cursor_3%ISOPEN THEN
2044: IF l_debug_level > 0 THEN
2045: oe_debug_pub.add ('fetching from cursor 3');
2046: END IF;
2047: FETCH l_retry_cursor_3 BULK COLLECT INTO
2048: l_retry_rec.item_key,
2049: l_retry_rec.activity_label,

Line 2062: oe_debug_pub.add ('fetching from cursor 4');

2058: LIMIT 1000;
2059:
2060: ELSIF l_retry_cursor_4%ISOPEN THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add ('fetching from cursor 4');
2063: END IF;
2064: FETCH l_retry_cursor_4 BULK COLLECT INTO
2065: l_retry_rec.item_key,
2066: l_retry_rec.activity_label,

Line 2079: oe_debug_pub.add ('fetching from cursor 5');

2075: LIMIT 1000;
2076:
2077: ELSIF l_retry_cursor_5%ISOPEN THEN
2078: IF l_debug_level > 0 THEN
2079: oe_debug_pub.add ('fetching from cursor 5');
2080: END IF;
2081: FETCH l_retry_cursor_5 BULK COLLECT INTO
2082: l_retry_rec.item_key,
2083: l_retry_rec.activity_label,

Line 2096: oe_debug_pub.add ('fetching from cursor 6');

2092: LIMIT 1000;
2093:
2094: ELSIF l_retry_cursor_6%ISOPEN THEN
2095: IF l_debug_level > 0 THEN
2096: oe_debug_pub.add ('fetching from cursor 6');
2097: END IF;
2098: FETCH l_retry_cursor_6 BULK COLLECT INTO
2099: l_retry_rec.item_key,
2100: l_retry_rec.activity_label,

Line 2115: oe_debug_pub.add('Number of records in this fetch: '|| l_retry_count);

2111: END IF;
2112:
2113: l_retry_count := l_retry_rec.item_key.count;
2114: IF l_debug_level > 0 THEN
2115: oe_debug_pub.add('Number of records in this fetch: '|| l_retry_count);
2116: END IF;
2117:
2118: FOR i IN 1..l_retry_count LOOP
2119: BEGIN

Line 2122: oe_debug_pub.add(' ');

2118: FOR i IN 1..l_retry_count LOOP
2119: BEGIN
2120: SAVEPOINT RETRY_FLOW_SAVEPOINT;
2121: IF l_debug_level > 0 THEN
2122: oe_debug_pub.add(' ');
2123: oe_debug_pub.add('Set savepoint for ' ||l_retry_rec.item_key(i));
2124: END IF;
2125:
2126: ----------------------------------------------------------------------------

Line 2123: oe_debug_pub.add('Set savepoint for ' ||l_retry_rec.item_key(i));

2119: BEGIN
2120: SAVEPOINT RETRY_FLOW_SAVEPOINT;
2121: IF l_debug_level > 0 THEN
2122: oe_debug_pub.add(' ');
2123: oe_debug_pub.add('Set savepoint for ' ||l_retry_rec.item_key(i));
2124: END IF;
2125:
2126: ----------------------------------------------------------------------------
2127: -- Print User Key Info

Line 2155: oe_debug_pub.add('Fetched header id ' || l_header_id);

2151: FROM OE_Order_Lines_All
2152: WHERE line_id = to_number(l_retry_rec.item_key(i));
2153:
2154: IF l_debug_level > 0 THEN
2155: oe_debug_pub.add('Fetched header id ' || l_header_id);
2156: END IF;
2157: END IF;
2158:
2159: IF p_mode = 'EXECUTE' THEN

Line 2205: oe_debug_pub.add('Reset last org id to: ' || l_retry_rec.org_id(i));

2201: END IF;
2202: END IF;
2203: l_last_org_id := l_retry_rec.org_id(i);
2204: IF l_debug_level > 0 THEN
2205: oe_debug_pub.add('Reset last org id to: ' || l_retry_rec.org_id(i));
2206: END IF;
2207: ELSE
2208: IF l_debug_level > 0 THEN
2209: oe_debug_pub.add('Org context unchanged, not calling selector function for org id: ' || l_retry_rec.org_id(i));

Line 2209: oe_debug_pub.add('Org context unchanged, not calling selector function for org id: ' || l_retry_rec.org_id(i));

2205: oe_debug_pub.add('Reset last org id to: ' || l_retry_rec.org_id(i));
2206: END IF;
2207: ELSE
2208: IF l_debug_level > 0 THEN
2209: oe_debug_pub.add('Org context unchanged, not calling selector function for org id: ' || l_retry_rec.org_id(i));
2210: END IF;
2211: END IF;
2212:
2213: IF Activity_In_Error ( p_item_type => p_item_type,

Line 2217: oe_debug_pub.add('Activity still in error');

2213: IF Activity_In_Error ( p_item_type => p_item_type,
2214: p_item_key => l_retry_rec.item_key(i),
2215: p_activity_id => l_retry_rec.activity_id(i)) THEN
2216: IF l_debug_level > 0 THEN
2217: oe_debug_pub.add('Activity still in error');
2218: END IF;
2219: IF NOT (p_item_type = 'OEOL' AND l_retry_rec.activity_name(i) = 'SHIP_LINE'
2220: AND Check_Closed_Delivery_Detail (l_retry_rec.item_key(i), l_retry_rec.activity_id(i))) THEN
2221: IF get_lock(p_item_type,l_retry_rec.item_key(i)) THEN

Line 2225: oe_debug_pub.add('Calling Handleerror with item key '||l_retry_rec.item_key(i) ||

2221: IF get_lock(p_item_type,l_retry_rec.item_key(i)) THEN
2222: l_get_lock_failed := false;
2223: IF l_debug_level > 0 THEN
2224: SELECT hsecs INTO l_start_total_time from v$timer;
2225: oe_debug_pub.add('Calling Handleerror with item key '||l_retry_rec.item_key(i) ||
2226: ' and activity ' || l_retry_rec.process_name(i)||':'||l_retry_rec.activity_label(i));
2227: END IF;
2228: ----------------------------------------------------------------------------
2229: -- Close Open Messages

Line 2263: oe_debug_pub.add('Total time taken to retry above item is (sec) '

2259: END IF;
2260: l_commit_count := l_commit_count + 1;
2261: IF l_debug_level > 0 THEN
2262: SELECT hsecs INTO l_end_total_time from v$timer;
2263: oe_debug_pub.add('Total time taken to retry above item is (sec) '
2264: ||((l_end_total_time-l_start_total_time)/100));
2265: oe_debug_pub.add('Commit count '|| l_commit_count);
2266: END IF;
2267: IF l_commit_count > 500 THEN

Line 2265: oe_debug_pub.add('Commit count '|| l_commit_count);

2261: IF l_debug_level > 0 THEN
2262: SELECT hsecs INTO l_end_total_time from v$timer;
2263: oe_debug_pub.add('Total time taken to retry above item is (sec) '
2264: ||((l_end_total_time-l_start_total_time)/100));
2265: oe_debug_pub.add('Commit count '|| l_commit_count);
2266: END IF;
2267: IF l_commit_count > 500 THEN
2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add('Committed '|| l_commit_count || ' records');

Line 2269: oe_debug_pub.add('Committed '|| l_commit_count || ' records');

2265: oe_debug_pub.add('Commit count '|| l_commit_count);
2266: END IF;
2267: IF l_commit_count > 500 THEN
2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add('Committed '|| l_commit_count || ' records');
2270: END IF;
2271: COMMIT;
2272: l_commit_count := 0;
2273: END IF;

Line 2276: oe_debug_pub.add('Activity no longer in error, no retry');

2272: l_commit_count := 0;
2273: END IF;
2274: ELSE
2275: IF l_debug_level > 0 THEN
2276: oe_debug_pub.add('Activity no longer in error, no retry');
2277: END IF;
2278: l_ignore_error_check := TRUE; -- this enables us to avoid an extra SQL
2279: END IF;
2280: END IF; -- end EXECUTE mode

Line 2286: oe_debug_pub.add('Activity still in error, log as failure');

2282: IF (NOT l_ignore_error_check) AND Activity_In_Error ( p_item_type => p_item_type,
2283: p_item_key => l_retry_rec.item_key(i),
2284: p_activity_id => l_retry_rec.activity_id(i)) THEN
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add('Activity still in error, log as failure');
2287: END IF;
2288: Put (p_item_type || l_retry_rec.activity_name(i),l_retry_rec.activity_item_type(i), l_retry_rec.activity_name(i),p_item_type,0, 1, l_activity_display_name);
2289: IF p_mode = 'EXECUTE' THEN
2290: IF l_get_lock_failed THEN

Line 2305: oe_debug_pub.add('Activity no longer in error, log as success');

2301: p_order_source_id => l_order_source_id,
2302: p_orig_sys_document_ref => l_orig_sys_document_ref);
2303: ELSE
2304: IF l_debug_level > 0 THEN
2305: oe_debug_pub.add('Activity no longer in error, log as success');
2306: END IF;
2307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' succeeded');
2308:
2309: END IF;

Line 2316: oe_debug_pub.add ('Error during retry, log as failure and continue with next record ' || l_error_msg);

2312: WHEN OTHERS THEN
2313: ROLLBACK TO RETRY_FLOW_SAVEPOINT;
2314: l_error_msg := substr(SQLERRM, 1, 512);
2315: IF l_debug_level > 0 THEN
2316: oe_debug_pub.add ('Error during retry, log as failure and continue with next record ' || l_error_msg);
2317: END IF;
2318: Put (p_item_type || l_retry_rec.activity_name(i),l_retry_rec.activity_item_type(i), l_retry_rec.activity_name(i),p_item_type,0, 1, l_activity_display_name);
2319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' failed with unexpected error ' || l_error_msg);
2320: END;

Line 2355: oe_debug_pub.add('Exiting Retry_Flows');

2351: CLOSE l_retry_cursor_6;
2352: END IF;
2353:
2354: IF l_debug_level > 0 THEN
2355: oe_debug_pub.add('Exiting Retry_Flows');
2356: END IF;
2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: IF l_debug_level > 0 THEN

Line 2360: oe_debug_pub.add('Entering Retry_Flows with unexpected error '|| SQLERRM);

2356: END IF;
2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: IF l_debug_level > 0 THEN
2360: oe_debug_pub.add('Entering Retry_Flows with unexpected error '|| SQLERRM);
2361: END IF;
2362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2363: IF l_retry_cursor_1%ISOPEN THEN
2364: CLOSE l_retry_cursor_1;

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

2378:
2379: PROCEDURE Print_Results (p_mode IN VARCHAR2, p_item_type_display_name IN VARCHAR2, p_item_type_display_name2 IN VARCHAR2)
2380: IS
2381: l_count_tbl Count_Tbl_Type;
2382: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2383: l_total NUMBER;
2384: l_item_type_display_name VARCHAR2(80);
2385: i NUMBER;
2386: BEGIN

Line 2388: oe_debug_pub.add('Entering Print_Results');

2384: l_item_type_display_name VARCHAR2(80);
2385: i NUMBER;
2386: BEGIN
2387: IF l_debug_level > 0 THEN
2388: oe_debug_pub.add('Entering Print_Results');
2389: END IF;
2390: l_count_tbl := Count_Tbl;
2391: fnd_file.put_line(FND_FILE.OUTPUT, '');
2392: fnd_file.put_line(FND_FILE.OUTPUT, 'SUMMARY');

Line 2441: oe_debug_pub.add('Exiting Print_Results');

2437: fnd_file.put_line(FND_FILE.OUTPUT, '');
2438: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Activities in Error after completion of request: ' || l_total);
2439:
2440: IF l_debug_level > 0 THEN
2441: oe_debug_pub.add('Exiting Print_Results');
2442: END IF;
2443:
2444: END Print_Results;
2445:

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

2453: p_activity_error_date_from IN VARCHAR2,
2454: p_activity_error_date_to IN VARCHAR2,
2455: p_mode IN VARCHAR2)
2456: IS
2457: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2458: l_return_status VARCHAR2(1);
2459: l_activity_error_date_from DATE;
2460: l_activity_error_date_to DATE;
2461: l_item_type_display_name VARCHAR2(80);

Line 2469: oe_debug_pub.add('Entering EM_Batch_Retry_Conc_Pgm');

2465: l_act_display_name VARCHAR2(80);
2466:
2467: BEGIN
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add('Entering EM_Batch_Retry_Conc_Pgm');
2470: END IF;
2471: retcode := 0;
2472: l_activity_error_date_from := fnd_date.canonical_to_date(p_activity_error_date_from);
2473: l_activity_error_date_to := fnd_date.canonical_to_date(p_activity_error_date_to) + 1 - 1/(24*60*60);

Line 2537: oe_debug_pub.add( 'Exiting with retcode '||retcode || ' and errbuf ' || errbuf ) ;

2533: fnd_file.put_line(FND_FILE.OUTPUT, '');
2534: fnd_file.put_line(FND_FILE.OUTPUT, errbuf);
2535: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
2536: IF l_debug_level > 0 THEN
2537: oe_debug_pub.add( 'Exiting with retcode '||retcode || ' and errbuf ' || errbuf ) ;
2538: END IF;
2539: RETURN;
2540: END IF;
2541:

Line 2554: oe_debug_pub.add('Item Type Display Name: ' || l_item_type_display_name);

2550: WHERE name = OE_GLOBALS.G_WFI_LIN;
2551: END IF;
2552:
2553: IF l_debug_level > 0 THEN
2554: oe_debug_pub.add('Item Type Display Name: ' || l_item_type_display_name);
2555: oe_debug_pub.add('Item Type Display Name2: ' || l_item_type_display_name2);
2556: END IF;
2557:
2558: -----------------------------------------------------------

Line 2555: oe_debug_pub.add('Item Type Display Name2: ' || l_item_type_display_name2);

2551: END IF;
2552:
2553: IF l_debug_level > 0 THEN
2554: oe_debug_pub.add('Item Type Display Name: ' || l_item_type_display_name);
2555: oe_debug_pub.add('Item Type Display Name2: ' || l_item_type_display_name2);
2556: END IF;
2557:
2558: -----------------------------------------------------------
2559: -- Retry

Line 2600: oe_debug_pub.add('Program exited normally');

2596:
2597: G_BATCH_RETRY_FLAG := 'N';
2598: retcode := 0;
2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add('Program exited normally');
2601: END IF;
2602: fnd_file.put_line(FND_FILE.OUTPUT, '');
2603: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
2604: IF l_debug_level > 0 THEN

Line 2605: oe_debug_pub.add('Exiting EM_Batch_Retry_Conc_Pgm');

2601: END IF;
2602: fnd_file.put_line(FND_FILE.OUTPUT, '');
2603: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
2604: IF l_debug_level > 0 THEN
2605: oe_debug_pub.add('Exiting EM_Batch_Retry_Conc_Pgm');
2606: END IF;
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: retcode := 2;

Line 2613: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;

2609: retcode := 2;
2610: errbuf := SQLERRM;
2611: G_BATCH_RETRY_FLAG := 'N';
2612: IF l_debug_level > 0 THEN
2613: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
2614: END IF;
2615: fnd_file.put_line(FND_FILE.OUTPUT, '');
2616: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
2617: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );