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.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_FILE

Line 723: fnd_file.put_line(fnd_file.log, 'Starting Process Unit for item instance: '|| p_csi_item_instance_id);

719: G_SIMULATION_PLAN_ID := p_simulation_plan_id;
720: END IF;
721:
722: IF (p_concurrent_flag = 'Y') THEN
723: fnd_file.put_line(fnd_file.log, 'Starting Process Unit for item instance: '|| p_csi_item_instance_id);
724: --fnd_file.put_line(fnd_file.log, 'G_IS_PM_INSTALLED: '|| G_IS_PM_INSTALLED);
725: END IF;
726:
727: -- Initialize temporary tables.

Line 724: --fnd_file.put_line(fnd_file.log, 'G_IS_PM_INSTALLED: '|| G_IS_PM_INSTALLED);

720: END IF;
721:
722: IF (p_concurrent_flag = 'Y') THEN
723: fnd_file.put_line(fnd_file.log, 'Starting Process Unit for item instance: '|| p_csi_item_instance_id);
724: --fnd_file.put_line(fnd_file.log, 'G_IS_PM_INSTALLED: '|| G_IS_PM_INSTALLED);
725: END IF;
726:
727: -- Initialize temporary tables.
728:

Line 743: fnd_file.put_line (FND_FILE.LOG, 'Validated Instance:'||p_csi_item_instance_id);

739: END IF;
740:
741: -- Log success message if called by concurrent program.
742: IF (p_concurrent_flag = 'Y') THEN
743: fnd_file.put_line (FND_FILE.LOG, 'Validated Instance:'||p_csi_item_instance_id);
744: END IF;
745: */
746:
747: -- set instance variable.

Line 768: fnd_file.put_line (FND_FILE.LOG, 'Validated Instance:'||l_csi_item_instance_id);

764: END IF;
765:
766: -- Log success message if called by concurrent program.
767: IF (p_concurrent_flag = 'Y') THEN
768: fnd_file.put_line (FND_FILE.LOG, 'Validated Instance:'||l_csi_item_instance_id);
769: END IF;
770:
771: -- Get master and unit configuration IDs if they exist for this item instance.
772: Get_Unit_Master_ConfigIDs (l_csi_item_instance_id,

Line 799: fnd_file.put_line (FND_FILE.LOG, 'Validated Instance:'||p_csi_item_instance_id);

795: END IF;
796:
797: -- Log success message if called by concurrent program.
798: IF (p_concurrent_flag = 'Y') THEN
799: fnd_file.put_line (FND_FILE.LOG, 'Validated Instance:'||p_csi_item_instance_id);
800: END IF;
801:
802: -- Intialize config node table consisting of the input item instance.
803: G_config_node_tbl(1).csi_item_instance_id := p_csi_item_instance_id;

Line 896: fnd_file.put_line (FND_FILE.LOG, 'G Config Tbl:' || G_config_node_tbl.COUNT);

892:
893: /*
894: -- Log success message if called by concurrent program.
895: IF (p_concurrent_flag = 'Y') THEN
896: fnd_file.put_line (FND_FILE.LOG, 'G Config Tbl:' || G_config_node_tbl.COUNT);
897: fnd_file.put_line (FND_FILE.LOG, 'G_forecast_details_tbl:' || G_forecast_details_tbl.count);
898: fnd_file.put_line (FND_FILE.LOG, 'Last Day window:' || G_last_day_of_window);
899: fnd_file.put_line (FND_FILE.LOG, 'UC Header ID:' || l_uc_header_id);
900: END IF;

Line 897: fnd_file.put_line (FND_FILE.LOG, 'G_forecast_details_tbl:' || G_forecast_details_tbl.count);

893: /*
894: -- Log success message if called by concurrent program.
895: IF (p_concurrent_flag = 'Y') THEN
896: fnd_file.put_line (FND_FILE.LOG, 'G Config Tbl:' || G_config_node_tbl.COUNT);
897: fnd_file.put_line (FND_FILE.LOG, 'G_forecast_details_tbl:' || G_forecast_details_tbl.count);
898: fnd_file.put_line (FND_FILE.LOG, 'Last Day window:' || G_last_day_of_window);
899: fnd_file.put_line (FND_FILE.LOG, 'UC Header ID:' || l_uc_header_id);
900: END IF;
901: */

Line 898: fnd_file.put_line (FND_FILE.LOG, 'Last Day window:' || G_last_day_of_window);

894: -- Log success message if called by concurrent program.
895: IF (p_concurrent_flag = 'Y') THEN
896: fnd_file.put_line (FND_FILE.LOG, 'G Config Tbl:' || G_config_node_tbl.COUNT);
897: fnd_file.put_line (FND_FILE.LOG, 'G_forecast_details_tbl:' || G_forecast_details_tbl.count);
898: fnd_file.put_line (FND_FILE.LOG, 'Last Day window:' || G_last_day_of_window);
899: fnd_file.put_line (FND_FILE.LOG, 'UC Header ID:' || l_uc_header_id);
900: END IF;
901: */
902:

Line 899: fnd_file.put_line (FND_FILE.LOG, 'UC Header ID:' || l_uc_header_id);

895: IF (p_concurrent_flag = 'Y') THEN
896: fnd_file.put_line (FND_FILE.LOG, 'G Config Tbl:' || G_config_node_tbl.COUNT);
897: fnd_file.put_line (FND_FILE.LOG, 'G_forecast_details_tbl:' || G_forecast_details_tbl.count);
898: fnd_file.put_line (FND_FILE.LOG, 'Last Day window:' || G_last_day_of_window);
899: fnd_file.put_line (FND_FILE.LOG, 'UC Header ID:' || l_uc_header_id);
900: END IF;
901: */
902:
903: -- Note: Both of the procedures Process_ASO_Unit and Process_PM_Unit use global variables

Line 959: fnd_file.put_line (FND_FILE.LOG, 'Message-Successfully processed:'||p_csi_item_instance_id);

955: END IF;
956:
957: -- Log success message if called by concurrent program.
958: IF (p_concurrent_flag = 'Y') THEN
959: fnd_file.put_line (FND_FILE.LOG, 'Message-Successfully processed:'||p_csi_item_instance_id);
960: END IF;
961:
962: -- Standard call to get message count and if count is 1, get message info
963: FND_MSG_PUB.Count_And_Get

Line 980: fnd_file.put_line(fnd_file.log, 'Process Unit failed for item instance: '|| p_csi_item_instance_id);

976: p_encoded => fnd_api.g_false);
977:
978: IF (p_concurrent_flag = 'Y') THEN
979:
980: fnd_file.put_line(fnd_file.log, 'Process Unit failed for item instance: '|| p_csi_item_instance_id);
981: log_error_messages;
982: END IF;
983:
984: -- Disable debug

Line 995: fnd_file.put_line(fnd_file.log, 'Process Unit failed for item instance: '|| p_csi_item_instance_id);

991: p_data => x_msg_data,
992: p_encoded => fnd_api.g_false);
993:
994: IF (p_concurrent_flag = 'Y') THEN
995: fnd_file.put_line(fnd_file.log, 'Process Unit failed for item instance: '|| p_csi_item_instance_id);
996: log_error_messages;
997: END IF;
998:
999: -- Disable debug

Line 1017: fnd_file.put_line(fnd_file.log, 'Process Unit failed for item instance: '|| p_csi_item_instance_id);

1013: p_encoded => fnd_api.g_false);
1014:
1015:
1016: IF (p_concurrent_flag = 'Y') THEN
1017: fnd_file.put_line(fnd_file.log, 'Process Unit failed for item instance: '|| p_csi_item_instance_id);
1018: log_error_messages;
1019: END IF;
1020:
1021: -- Disable debug

Line 1153: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');

1149: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
1150: IF G_debug = 'Y' THEN
1151: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
1152: END IF;
1153: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
1154: fnd_file.new_line(FND_FILE.LOG,1);
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: EXIT; -- abort and return to calling pgm.
1157:

Line 1154: fnd_file.new_line(FND_FILE.LOG,1);

1150: IF G_debug = 'Y' THEN
1151: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
1152: END IF;
1153: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
1154: fnd_file.new_line(FND_FILE.LOG,1);
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: EXIT; -- abort and return to calling pgm.
1157:
1158: ELSE

Line 1159: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id);

1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: EXIT; -- abort and return to calling pgm.
1157:
1158: ELSE
1159: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id);
1160: IF G_debug = 'Y' THEN
1161: AHL_DEBUG_PUB.debug('Concurrent request ID:' || l_req_id );
1162: END IF;
1163: END IF; -- l_req_id = 0 OR ..

Line 1175: fnd_file.put_line(FND_FILE.LOG, 'Warning: Error from Cleanup_BUE_Worker:' || l_err_mesg);

1171: x_errbuf => l_err_mesg);
1172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1173: -- ignore error returned from this procedure
1174: -- log message in concurrent request log.
1175: fnd_file.put_line(FND_FILE.LOG, 'Warning: Error from Cleanup_BUE_Worker:' || l_err_mesg);
1176: END IF;
1177:
1178: ELSE
1179: LOOP

Line 1319: fnd_file.put_line(fnd_file.log, 'Starting processing for contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);

1315: AHL_DEBUG_PUB.debug('p_commit:' || p_commit );
1316: END IF;
1317:
1318: IF (p_concurrent_flag = 'Y') THEN
1319: fnd_file.put_line(fnd_file.log, 'Starting processing for contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1320: -- If the call is from concurrent program, then commit should default to TRUE
1321: l_commit := FND_API.G_TRUE;
1322: END IF;
1323:

Line 1375: fnd_file.put_line(fnd_file.log, 'Calling Process_Unit for instance: ' || l_ent_cont_tbl(i).coverage_level_id);

1371: LOOP
1372: IF (l_ent_cont_tbl(i).coverage_level_code = 'COVER_PROD')
1373: THEN
1374: IF (p_concurrent_flag = 'Y') THEN
1375: fnd_file.put_line(fnd_file.log, 'Calling Process_Unit for instance: ' || l_ent_cont_tbl(i).coverage_level_id);
1376: END IF;
1377: AHL_UMP_ProcessUnit_PVT.Process_Unit
1378: (
1379: p_commit => l_commit,

Line 1387: fnd_file.put_line(fnd_file.log, 'Process_Unit failed for instance: ' || l_ent_cont_tbl(i).coverage_level_id);

1383: p_csi_item_instance_id => l_ent_cont_tbl(i).coverage_level_id,
1384: p_concurrent_flag => p_concurrent_flag
1385: );
1386: IF (p_concurrent_flag = 'Y' and (FND_MSG_PUB.count_msg > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1387: fnd_file.put_line(fnd_file.log, 'Process_Unit failed for instance: ' || l_ent_cont_tbl(i).coverage_level_id);
1388: END IF;
1389: END IF;
1390: END LOOP;
1391: END IF;

Line 1406: fnd_file.put_line(fnd_file.log, 'Message-Successfully processed: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);

1402: END IF;
1403:
1404: -- Log success message if called by concurrent program.
1405: IF (p_concurrent_flag = 'Y') THEN
1406: fnd_file.put_line(fnd_file.log, 'Message-Successfully processed: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1407: END IF;
1408:
1409: -- Standard call to get message count and if count is 1, get message info
1410: FND_MSG_PUB.Count_And_Get

Line 1428: fnd_file.put_line(fnd_file.log, 'Process_PM_Contracts failed for: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);

1424: p_data => x_msg_data,
1425: p_encoded => fnd_api.g_false
1426: );
1427: IF (p_concurrent_flag = 'Y') THEN
1428: fnd_file.put_line(fnd_file.log, 'Process_PM_Contracts failed for: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1429: log_error_messages;
1430: END IF;
1431: AHL_DEBUG_PUB.disable_debug;
1432:

Line 1443: fnd_file.put_line(fnd_file.log, 'Process_PM_Contracts failed for: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);

1439: p_data => x_msg_data,
1440: p_encoded => fnd_api.g_false
1441: );
1442: IF (p_concurrent_flag = 'Y') THEN
1443: fnd_file.put_line(fnd_file.log, 'Process_PM_Contracts failed for: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1444: log_error_messages;
1445: END IF;
1446: AHL_DEBUG_PUB.disable_debug;
1447:

Line 1466: fnd_file.put_line(fnd_file.log, 'Process_PM_Contracts failed for: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);

1462: p_data => x_msg_data,
1463: p_encoded => fnd_api.g_false
1464: );
1465: IF (p_concurrent_flag = 'Y') THEN
1466: fnd_file.put_line(fnd_file.log, 'Process_PM_Contracts failed for: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1467: log_error_messages;
1468: END IF;
1469: AHL_DEBUG_PUB.disable_debug;
1470: END Process_PM_Contracts;

Line 1709: fnd_file.put_line (FND_FILE.LOG, 'Unit Config Name:' || l_name);

1705: CLOSE ahl_unit_config_header_csr;
1706: END IF;
1707:
1708: IF (G_concurrent_flag = 'Y') THEN
1709: fnd_file.put_line (FND_FILE.LOG, 'Unit Config Name:' || l_name);
1710: END IF;
1711:
1712: IF G_DEBUG = 'Y' THEN
1713: AHL_DEBUG_PUB.debug('Unit Config ID:' || x_uc_header_id);

Line 2765: fnd_file.put_line (FND_FILE.LOG, 'Found applicable MR-ID:title:' || l_appl_rec.mr_header_id || ':'

2761: END IF;
2762:
2763: /*
2764: IF (G_concurrent_flag = 'Y') THEN
2765: fnd_file.put_line (FND_FILE.LOG, 'Found applicable MR-ID:title:' || l_appl_rec.mr_header_id || ':'
2766: || l_appl_rec.title);
2767: END IF;
2768: */
2769:

Line 8146: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);

8142: p_encoded => FND_API.G_FALSE,
8143: p_data => l_msg_data,
8144: p_msg_index_out => l_msg_index_out );
8145:
8146: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);
8147: IF G_DEBUG = 'Y' THEN
8148: AHL_DEBUG_PUB.Debug('Err message-'||l_msg_index_out||':' || substr(l_msg_data,1,240));
8149: END IF;
8150:

Line 12045: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');

12041: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
12042: IF l_debug = 'Y' THEN
12043: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12044: END IF;
12045: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12046: fnd_file.new_line(FND_FILE.LOG,1);
12047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12048:
12049: ELSE

Line 12046: fnd_file.new_line(FND_FILE.LOG,1);

12042: IF l_debug = 'Y' THEN
12043: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12044: END IF;
12045: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12046: fnd_file.new_line(FND_FILE.LOG,1);
12047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12048:
12049: ELSE
12050: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id || ' launched to process instances between:' || l_start_csi_id || ' and ' || l_end_csi_id);

Line 12050: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id || ' launched to process instances between:' || l_start_csi_id || ' and ' || l_end_csi_id);

12046: fnd_file.new_line(FND_FILE.LOG,1);
12047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12048:
12049: ELSE
12050: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id || ' launched to process instances between:' || l_start_csi_id || ' and ' || l_end_csi_id);
12051:
12052: IF l_debug = 'Y' THEN
12053: AHL_DEBUG_PUB.debug('Concurrent request ID:' || l_req_id || ' launched to process instances between:' || l_start_csi_id || ' and ' || l_end_csi_id);
12054: END IF;

Line 12121: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');

12117: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
12118: IF l_debug = 'Y' THEN
12119: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12120: END IF;
12121: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12122: fnd_file.new_line(FND_FILE.LOG,1);
12123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12124:
12125: ELSE

Line 12122: fnd_file.new_line(FND_FILE.LOG,1);

12118: IF l_debug = 'Y' THEN
12119: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12120: END IF;
12121: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12122: fnd_file.new_line(FND_FILE.LOG,1);
12123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12124:
12125: ELSE
12126: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id || ' launched to process instances between:' || p_csi_min_id || ' and ' || p_csi_min_id);

Line 12126: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id || ' launched to process instances between:' || p_csi_min_id || ' and ' || p_csi_min_id);

12122: fnd_file.new_line(FND_FILE.LOG,1);
12123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12124:
12125: ELSE
12126: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id || ' launched to process instances between:' || p_csi_min_id || ' and ' || p_csi_min_id);
12127:
12128: IF l_debug = 'Y' THEN
12129: AHL_DEBUG_PUB.debug('Concurrent request ID:' || l_req_id || ' launched to process instances between:' || p_csi_min_id || ' and ' || p_csi_min_id);
12130: END IF;

Line 12201: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');

12197: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
12198: IF l_debug = 'Y' THEN
12199: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12200: END IF;
12201: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12202: fnd_file.new_line(FND_FILE.LOG,1);
12203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12204:
12205: ELSE

Line 12202: fnd_file.new_line(FND_FILE.LOG,1);

12198: IF l_debug = 'Y' THEN
12199: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12200: END IF;
12201: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12202: fnd_file.new_line(FND_FILE.LOG,1);
12203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12204:
12205: ELSE
12206: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id ||

Line 12206: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id ||

12202: fnd_file.new_line(FND_FILE.LOG,1);
12203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12204:
12205: ELSE
12206: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id ||
12207: ' launched to process instances between:' || l_begin_count_csi_id || ' and ' ||
12208: l_mid_point_inst_id);
12209:
12210: IF l_debug = 'Y' THEN

Line 12227: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');

12223: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
12224: IF l_debug = 'Y' THEN
12225: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12226: END IF;
12227: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12228: fnd_file.new_line(FND_FILE.LOG,1);
12229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12230:
12231: ELSE

Line 12228: fnd_file.new_line(FND_FILE.LOG,1);

12224: IF l_debug = 'Y' THEN
12225: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12226: END IF;
12227: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12228: fnd_file.new_line(FND_FILE.LOG,1);
12229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12230:
12231: ELSE
12232: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id ||

Line 12232: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id ||

12228: fnd_file.new_line(FND_FILE.LOG,1);
12229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12230:
12231: ELSE
12232: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id ||
12233: ' launched to process instances between:' || l_begin_count_csi_id || ' and ' ||
12234: l_mid_point_inst_id);
12235:
12236: IF l_debug = 'Y' THEN

Line 12327: fnd_file.put_line(FND_FILE.LOG,'MR Header ID = '||p_mr_header_id);

12323:
12324: BEGIN
12325:
12326: IF G_DEBUG = 'Y' THEN
12327: fnd_file.put_line(FND_FILE.LOG,'MR Header ID = '||p_mr_header_id);
12328: fnd_file.put_line(FND_FILE.LOG,'CSI Start Instance = '||p_start_instance_id);
12329: fnd_file.put_line(FND_FILE.LOG,'CSI End Instance = '||p_end_instance_id);
12330: fnd_file.put_line(FND_FILE.LOG,'Start Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12331: fnd_file.new_line(FND_FILE.LOG,1);

Line 12328: fnd_file.put_line(FND_FILE.LOG,'CSI Start Instance = '||p_start_instance_id);

12324: BEGIN
12325:
12326: IF G_DEBUG = 'Y' THEN
12327: fnd_file.put_line(FND_FILE.LOG,'MR Header ID = '||p_mr_header_id);
12328: fnd_file.put_line(FND_FILE.LOG,'CSI Start Instance = '||p_start_instance_id);
12329: fnd_file.put_line(FND_FILE.LOG,'CSI End Instance = '||p_end_instance_id);
12330: fnd_file.put_line(FND_FILE.LOG,'Start Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12331: fnd_file.new_line(FND_FILE.LOG,1);
12332: END IF;

Line 12329: fnd_file.put_line(FND_FILE.LOG,'CSI End Instance = '||p_end_instance_id);

12325:
12326: IF G_DEBUG = 'Y' THEN
12327: fnd_file.put_line(FND_FILE.LOG,'MR Header ID = '||p_mr_header_id);
12328: fnd_file.put_line(FND_FILE.LOG,'CSI Start Instance = '||p_start_instance_id);
12329: fnd_file.put_line(FND_FILE.LOG,'CSI End Instance = '||p_end_instance_id);
12330: fnd_file.put_line(FND_FILE.LOG,'Start Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12331: fnd_file.new_line(FND_FILE.LOG,1);
12332: END IF;
12333:

Line 12330: fnd_file.put_line(FND_FILE.LOG,'Start Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

12326: IF G_DEBUG = 'Y' THEN
12327: fnd_file.put_line(FND_FILE.LOG,'MR Header ID = '||p_mr_header_id);
12328: fnd_file.put_line(FND_FILE.LOG,'CSI Start Instance = '||p_start_instance_id);
12329: fnd_file.put_line(FND_FILE.LOG,'CSI End Instance = '||p_end_instance_id);
12330: fnd_file.put_line(FND_FILE.LOG,'Start Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12331: fnd_file.new_line(FND_FILE.LOG,1);
12332: END IF;
12333:
12334: -- initialize return status.

Line 12331: fnd_file.new_line(FND_FILE.LOG,1);

12327: fnd_file.put_line(FND_FILE.LOG,'MR Header ID = '||p_mr_header_id);
12328: fnd_file.put_line(FND_FILE.LOG,'CSI Start Instance = '||p_start_instance_id);
12329: fnd_file.put_line(FND_FILE.LOG,'CSI End Instance = '||p_end_instance_id);
12330: fnd_file.put_line(FND_FILE.LOG,'Start Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12331: fnd_file.new_line(FND_FILE.LOG,1);
12332: END IF;
12333:
12334: -- initialize return status.
12335: retcode := 0;

Line 12391: fnd_file.new_line(FND_FILE.LOG,1);

12387: CLOSE get_all_inst;
12388: END IF;
12389:
12390: IF G_DEBUG = 'Y' THEN
12391: fnd_file.new_line(FND_FILE.LOG,1);
12392: fnd_file.put_line(FND_FILE.LOG,'End Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12393: END IF;
12394:
12395: --

Line 12392: fnd_file.put_line(FND_FILE.LOG,'End Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

12388: END IF;
12389:
12390: IF G_DEBUG = 'Y' THEN
12391: fnd_file.new_line(FND_FILE.LOG,1);
12392: fnd_file.put_line(FND_FILE.LOG,'End Time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12393: END IF;
12394:
12395: --
12396: EXCEPTION

Line 12475: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');

12471: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
12472: IF G_debug = 'Y' THEN
12473: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12474: END IF;
12475: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12476: fnd_file.new_line(FND_FILE.LOG,1);
12477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12478:
12479: ELSE

Line 12476: fnd_file.new_line(FND_FILE.LOG,1);

12472: IF G_debug = 'Y' THEN
12473: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
12474: END IF;
12475: fnd_file.put_line(FND_FILE.LOG, 'Failed submit concurrent request');
12476: fnd_file.new_line(FND_FILE.LOG,1);
12477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12478:
12479: ELSE
12480: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id );

Line 12480: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id );

12476: fnd_file.new_line(FND_FILE.LOG,1);
12477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12478:
12479: ELSE
12480: fnd_file.put_line(FND_FILE.LOG, 'Concurrent request ID:' || l_req_id );
12481: IF G_debug = 'Y' THEN
12482: AHL_DEBUG_PUB.debug('Concurrent request ID:' || l_req_id );
12483: END IF;
12484: END IF; -- l_req_id = 0 OR ..

Line 12496: fnd_file.put_line(FND_FILE.LOG, 'Warning: Error from Cleanup_BUE_Worker:' || l_err_mesg);

12492: x_errbuf => l_err_mesg);
12493: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12494: -- ignore error returned from this procedure
12495: -- log message in concurrent request log.
12496: fnd_file.put_line(FND_FILE.LOG, 'Warning: Error from Cleanup_BUE_Worker:' || l_err_mesg);
12497: END IF;
12498: ELSE
12499:
12500: LOOP

Line 12587: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

12583: l_return_status VARCHAR2(1);
12584:
12585: BEGIN
12586:
12587: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12588:
12589: G_DEBUG_LINE_NUM := 1;
12590:
12591: -- initialize return status.

Line 12630: fnd_file.new_line(FND_FILE.LOG,1);

12626: END IF;
12627:
12628: EXIT WHEN (l_instance_id IS NULL);
12629:
12630: fnd_file.new_line(FND_FILE.LOG,1);
12631: fnd_file.put_line(FND_FILE.LOG,'Now processing..:' || l_instance_id);
12632: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12633:
12634: G_DEBUG_LINE_NUM := 20;

Line 12631: fnd_file.put_line(FND_FILE.LOG,'Now processing..:' || l_instance_id);

12627:
12628: EXIT WHEN (l_instance_id IS NULL);
12629:
12630: fnd_file.new_line(FND_FILE.LOG,1);
12631: fnd_file.put_line(FND_FILE.LOG,'Now processing..:' || l_instance_id);
12632: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12633:
12634: G_DEBUG_LINE_NUM := 20;
12635:

Line 12632: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

12628: EXIT WHEN (l_instance_id IS NULL);
12629:
12630: fnd_file.new_line(FND_FILE.LOG,1);
12631: fnd_file.put_line(FND_FILE.LOG,'Now processing..:' || l_instance_id);
12632: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12633:
12634: G_DEBUG_LINE_NUM := 20;
12635:
12636: -- Call Process Unit for the item instance.

Line 12648: fnd_file.put_line(FND_FILE.LOG,'End time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

12644: p_concurrent_flag => 'Y',
12645: -- JKJain, NR Analysis and Forecasting
12646: p_simulation_plan_id => l_simulation_plan_id);
12647:
12648: fnd_file.put_line(FND_FILE.LOG,'End time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12649:
12650: l_msg_count := FND_MSG_PUB.Count_Msg;
12651: IF (retcode <> 2 AND l_return_status <> FND_API.G_RET_STS_SUCCESS)
12652: THEN

Line 12671: fnd_file.put_line(FND_FILE.LOG, 'Warning: Error from Cleanup_BUE_Worker:' || l_msg_data);

12667: x_errbuf => l_msg_data);
12668: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12669: -- ignore error returned from this procedure
12670: -- log message in concurrent request log.
12671: fnd_file.put_line(FND_FILE.LOG, 'Warning: Error from Cleanup_BUE_Worker:' || l_msg_data);
12672: retcode := 1; -- warning based on return status
12673: END IF;
12674:
12675:

Line 12721: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

12717: l_msg_data varchar2(2000);
12718:
12719: BEGIN
12720:
12721: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12722:
12723: IF G_debug = 'Y' THEN
12724: AHL_DEBUG_PUB.debug('Start Process_Unit_Range for MR: Old ID:New ID:' || p_old_mr_header_id || ':' || p_new_mr_header_id);
12725: END IF;

Line 13185: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13181:
13182: x_return_status := 'E';
13183:
13184: IF (p_concurrent_flag = 'Y') THEN
13185: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13186: FOR j IN 1..sql%bulk_exceptions.count
13187: LOOP
13188: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13189: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 13188: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||

13184: IF (p_concurrent_flag = 'Y') THEN
13185: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13186: FOR j IN 1..sql%bulk_exceptions.count
13187: LOOP
13188: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13189: sqlerrm(-sql%bulk_exceptions(j).error_code) );
13190: END LOOP;
13191: END IF;
13192:

Line 13252: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13248:
13249: x_return_status := 'E';
13250:
13251: IF (p_concurrent_flag = 'Y') THEN
13252: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13253: FOR j IN 1..sql%bulk_exceptions.count
13254: LOOP
13255: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13256: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 13255: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||

13251: IF (p_concurrent_flag = 'Y') THEN
13252: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13253: FOR j IN 1..sql%bulk_exceptions.count
13254: LOOP
13255: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13256: sqlerrm(-sql%bulk_exceptions(j).error_code) );
13257: END LOOP;
13258: END IF;
13259:

Line 13940: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13936:
13937: x_return_status := 'E';
13938:
13939: IF (p_concurrent_flag = 'Y') THEN
13940: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13941: FOR j IN 1..sql%bulk_exceptions.count
13942: LOOP
13943: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13944: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 13943: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||

13939: IF (p_concurrent_flag = 'Y') THEN
13940: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13941: FOR j IN 1..sql%bulk_exceptions.count
13942: LOOP
13943: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13944: sqlerrm(-sql%bulk_exceptions(j).error_code) );
13945: END LOOP;
13946: END IF;
13947:

Line 14003: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13999: END IF;
14000: x_return_status := 'E';
14001:
14002: IF (p_concurrent_flag = 'Y') THEN
14003: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
14004: FOR j IN 1..sql%bulk_exceptions.count
14005: LOOP
14006: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
14007: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 14006: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||

14002: IF (p_concurrent_flag = 'Y') THEN
14003: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
14004: FOR j IN 1..sql%bulk_exceptions.count
14005: LOOP
14006: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
14007: sqlerrm(-sql%bulk_exceptions(j).error_code) );
14008: END LOOP;
14009: END IF;
14010: