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 FND_FILE

Line 1608: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));

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;
1610: CLOSE l_msg_cursor_1;
1611: ELSIF p_item_type = 'OEOL' THEN
1612: OPEN l_msg_cursor_2;

Line 1619: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));

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;
1621: CLOSE l_msg_cursor_2;
1622: ELSIF p_item_type = 'OEBH' THEN
1623: l_entity_code := 'BLANKET_HEADER';

Line 1632: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));

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;
1634: CLOSE l_msg_cursor_3;
1635: ELSIF p_item_type IN ('OEOI', 'OEOA', 'OESO', 'OEXWFEDI') THEN
1636: l_entity_code := 'ELECMSG_'||p_item_type;

Line 1645: FND_FILE.PUT_LINE(FND_FILE.LOG, ' '||l_msg_rec.message_text(i));

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;
1647: CLOSE l_msg_cursor_4;
1648: END IF;
1649: EXCEPTION

Line 2131: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

2127: -- Print User Key Info
2128: ----------------------------------------------------------------------------
2129: 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,1, 0, l_activity_display_name);
2130:
2131: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));
2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));

Line 2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));

2128: ----------------------------------------------------------------------------
2129: 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,1, 0, l_activity_display_name);
2130:
2131: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));
2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);

Line 2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);
2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2138:
2139: ----------------------------------------------------------------------------
2140: -- Initialize
2141: ----------------------------------------------------------------------------

Line 2291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The above activity is not retried because header and line records can not be locked for update. Please try later');

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
2291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The above activity is not retried because header and line records can not be locked for update. Please try later');
2292: ELSE
2293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' failed');
2294: END IF;--IF l_get_lock_failed
2295: END IF;

Line 2293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' failed');

2289: IF p_mode = 'EXECUTE' THEN
2290: IF l_get_lock_failed THEN
2291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The above activity is not retried because header and line records can not be locked for update. Please try later');
2292: ELSE
2293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' failed');
2294: END IF;--IF l_get_lock_failed
2295: END IF;
2296:
2297: Print_Open_Messages ( p_item_type => p_item_type,

Line 2307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' succeeded');

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;
2310:
2311: EXCEPTION

Line 2319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retry of ' || l_activity_display_name || ' failed with unexpected error ' || l_error_msg);

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;
2321: END LOOP;
2322:
2323: IF l_retry_cursor_1%ISOPEN THEN

Line 2391: fnd_file.put_line(FND_FILE.OUTPUT, '');

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');
2393: fnd_file.put_line(FND_FILE.OUTPUT, '');
2394:
2395: l_total := 0;

Line 2392: fnd_file.put_line(FND_FILE.OUTPUT, 'SUMMARY');

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');
2393: fnd_file.put_line(FND_FILE.OUTPUT, '');
2394:
2395: l_total := 0;
2396:

Line 2393: fnd_file.put_line(FND_FILE.OUTPUT, '');

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');
2393: fnd_file.put_line(FND_FILE.OUTPUT, '');
2394:
2395: l_total := 0;
2396:
2397: IF p_mode = 'EXECUTE' THEN

Line 2399: fnd_file.put_line (FND_FILE.OUTPUT, 'Activity Name Item Type Count');

2395: l_total := 0;
2396:
2397: IF p_mode = 'EXECUTE' THEN
2398: IF l_count_tbl.count > 0 THEN
2399: fnd_file.put_line (FND_FILE.OUTPUT, 'Activity Name Item Type Count');
2400: END IF;
2401:
2402: i := l_count_tbl.FIRST;
2403: WHILE i IS NOT NULL LOOP

Line 2410: fnd_file.put_line(FND_FILE.OUTPUT, rpad(l_count_tbl(i).activity_display_name,48, ' ') || ' ' || rpad(l_item_type_display_name,22, ' ') || ' ' || l_count_tbl(i).initial_count);

2406: ELSE
2407: l_item_type_display_name := p_item_type_display_name;
2408: END IF;
2409:
2410: fnd_file.put_line(FND_FILE.OUTPUT, rpad(l_count_tbl(i).activity_display_name,48, ' ') || ' ' || rpad(l_item_type_display_name,22, ' ') || ' ' || l_count_tbl(i).initial_count);
2411: l_total := l_total + l_count_tbl(i).initial_count;
2412: i:= l_count_tbl.NEXT(i);
2413: END LOOP;
2414: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 2414: fnd_file.put_line(FND_FILE.OUTPUT, '');

2410: fnd_file.put_line(FND_FILE.OUTPUT, rpad(l_count_tbl(i).activity_display_name,48, ' ') || ' ' || rpad(l_item_type_display_name,22, ' ') || ' ' || l_count_tbl(i).initial_count);
2411: l_total := l_total + l_count_tbl(i).initial_count;
2412: i:= l_count_tbl.NEXT(i);
2413: END LOOP;
2414: fnd_file.put_line(FND_FILE.OUTPUT, '');
2415: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Activities in Error prior to request: ' || l_total);
2416: fnd_file.put_line(FND_FILE.OUTPUT, '');
2417: END IF;
2418:

Line 2415: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Activities in Error prior to request: ' || l_total);

2411: l_total := l_total + l_count_tbl(i).initial_count;
2412: i:= l_count_tbl.NEXT(i);
2413: END LOOP;
2414: fnd_file.put_line(FND_FILE.OUTPUT, '');
2415: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Activities in Error prior to request: ' || l_total);
2416: fnd_file.put_line(FND_FILE.OUTPUT, '');
2417: END IF;
2418:
2419: l_total := 0;

Line 2416: fnd_file.put_line(FND_FILE.OUTPUT, '');

2412: i:= l_count_tbl.NEXT(i);
2413: END LOOP;
2414: fnd_file.put_line(FND_FILE.OUTPUT, '');
2415: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Activities in Error prior to request: ' || l_total);
2416: fnd_file.put_line(FND_FILE.OUTPUT, '');
2417: END IF;
2418:
2419: l_total := 0;
2420:

Line 2422: fnd_file.put_line (FND_FILE.OUTPUT, 'Activity Name Item Type Count');

2418:
2419: l_total := 0;
2420:
2421: IF l_count_tbl.count > 0 THEN
2422: fnd_file.put_line (FND_FILE.OUTPUT, 'Activity Name Item Type Count');
2423: END IF;
2424: i := l_count_tbl.FIRST;
2425: WHILE i IS NOT NULL LOOP
2426: IF l_count_tbl(i).process_item_type = 'OEOL' THEN

Line 2432: fnd_file.put_line(FND_FILE.OUTPUT, rpad(l_count_tbl(i).activity_display_name,48, ' ') || ' ' || rpad(l_item_type_display_name,22, ' ') || ' ' || l_count_tbl(i).final_count);

2428: ELSE
2429: l_item_type_display_name := p_item_type_display_name;
2430: END IF;
2431:
2432: fnd_file.put_line(FND_FILE.OUTPUT, rpad(l_count_tbl(i).activity_display_name,48, ' ') || ' ' || rpad(l_item_type_display_name,22, ' ') || ' ' || l_count_tbl(i).final_count);
2433: l_total := l_total + l_count_tbl(i).final_count;
2434: i:= l_count_tbl.NEXT(i);
2435: END LOOP;
2436:

Line 2437: fnd_file.put_line(FND_FILE.OUTPUT, '');

2433: l_total := l_total + l_count_tbl(i).final_count;
2434: i:= l_count_tbl.NEXT(i);
2435: END LOOP;
2436:
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');

Line 2438: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Activities in Error after completion of request: ' || l_total);

2434: i:= l_count_tbl.NEXT(i);
2435: END LOOP;
2436:
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;

Line 2514: fnd_file.put_line(FND_FILE.OUTPUT, 'Retry Activities in Error Concurrent Program');

2510: -----------------------------------------------------------
2511: -- Log Output file
2512: -----------------------------------------------------------
2513:
2514: fnd_file.put_line(FND_FILE.OUTPUT, 'Retry Activities in Error Concurrent Program');
2515: fnd_file.put_line(FND_FILE.OUTPUT, '');
2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);

Line 2515: fnd_file.put_line(FND_FILE.OUTPUT, '');

2511: -- Log Output file
2512: -----------------------------------------------------------
2513:
2514: fnd_file.put_line(FND_FILE.OUTPUT, 'Retry Activities in Error Concurrent Program');
2515: fnd_file.put_line(FND_FILE.OUTPUT, '');
2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);

Line 2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');

2512: -----------------------------------------------------------
2513:
2514: fnd_file.put_line(FND_FILE.OUTPUT, 'Retry Activities in Error Concurrent Program');
2515: fnd_file.put_line(FND_FILE.OUTPUT, '');
2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);

Line 2517: fnd_file.put_line(FND_FILE.OUTPUT, '');

2513:
2514: fnd_file.put_line(FND_FILE.OUTPUT, 'Retry Activities in Error Concurrent Program');
2515: fnd_file.put_line(FND_FILE.OUTPUT, '');
2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);

Line 2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);

2514: fnd_file.put_line(FND_FILE.OUTPUT, 'Retry Activities in Error Concurrent Program');
2515: fnd_file.put_line(FND_FILE.OUTPUT, '');
2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);

Line 2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);

2515: fnd_file.put_line(FND_FILE.OUTPUT, '');
2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);
2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);

Line 2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);

2516: fnd_file.put_line(FND_FILE.OUTPUT, 'PARAMETERS');
2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);
2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);
2524: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);

2517: fnd_file.put_line(FND_FILE.OUTPUT, '');
2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);
2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);
2524: fnd_file.put_line(FND_FILE.OUTPUT, '');
2525:

Line 2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);

2518: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number: '||l_order_num);
2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);
2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);
2524: fnd_file.put_line(FND_FILE.OUTPUT, '');
2525:
2526:

Line 2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);

2519: fnd_file.put_line(FND_FILE.OUTPUT, 'Item Type: '||l_item_type_display_name);
2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);
2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);
2524: fnd_file.put_line(FND_FILE.OUTPUT, '');
2525:
2526:
2527: -----------------------------------------------------------

Line 2524: fnd_file.put_line(FND_FILE.OUTPUT, '');

2520: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity in Error: '|| l_act_display_name);
2521: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date From: '|| l_activity_error_date_from);
2522: fnd_file.put_line(FND_FILE.OUTPUT, 'Activity Error Date To: '||l_activity_error_date_to);
2523: fnd_file.put_line(FND_FILE.OUTPUT, 'Mode: '||l_user_mode);
2524: fnd_file.put_line(FND_FILE.OUTPUT, '');
2525:
2526:
2527: -----------------------------------------------------------
2528: -- Validate Parameters

Line 2533: fnd_file.put_line(FND_FILE.OUTPUT, '');

2529: -----------------------------------------------------------
2530: IF p_mode IS NULL OR p_item_type IS NULL THEN
2531: retcode := 0;
2532: errbuf := 'Required parameters Item Type and Mode cannot be null';
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 ) ;

Line 2534: fnd_file.put_line(FND_FILE.OUTPUT, errbuf);

2530: IF p_mode IS NULL OR p_item_type IS NULL THEN
2531: retcode := 0;
2532: errbuf := 'Required parameters Item Type and Mode cannot be null';
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;

Line 2535: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);

2531: retcode := 0;
2532: errbuf := 'Required parameters Item Type and Mode cannot be null';
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;

Line 2602: fnd_file.put_line(FND_FILE.OUTPUT, '');

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
2605: oe_debug_pub.add('Exiting EM_Batch_Retry_Conc_Pgm');
2606: END IF;

Line 2603: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);

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
2605: oe_debug_pub.add('Exiting EM_Batch_Retry_Conc_Pgm');
2606: END IF;
2607: EXCEPTION

Line 2615: fnd_file.put_line(FND_FILE.OUTPUT, '');

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 );
2618: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2619: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EM_Batch_Retry_Conc_Pgm');

Line 2616: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);

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 );
2618: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2619: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EM_Batch_Retry_Conc_Pgm');
2620: End if;

Line 2617: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );

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 );
2618: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2619: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'EM_Batch_Retry_Conc_Pgm');
2620: End if;
2621: