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

Line 1476: FND_File.Put_Line(Fnd_File.LOG,'BEGIN OF MASS LOAD ERRORS');

1472: BEGIN
1473:
1474: x_return_status := l_fnd_success;
1475:
1476: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1477: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1478: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1479: FOR r_error in c_error LOOP
1480: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);

Line 1477: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');

1473:
1474: x_return_status := l_fnd_success;
1475:
1476: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1477: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1478: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1479: FOR r_error in c_error LOOP
1480: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);
1481: END LOOP;

Line 1478: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');

1474: x_return_status := l_fnd_success;
1475:
1476: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1477: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1478: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1479: FOR r_error in c_error LOOP
1480: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);
1481: END LOOP;
1482:

Line 1480: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);

1476: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1477: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1478: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1479: FOR r_error in c_error LOOP
1480: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);
1481: END LOOP;
1482:
1483: FND_File.Put_Line(Fnd_File.LOG,'************END OF MASS LOAD ERRORS************');
1484:

Line 1483: FND_File.Put_Line(Fnd_File.LOG,'END OF MASS LOAD ERRORS');

1479: FOR r_error in c_error LOOP
1480: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);
1481: END LOOP;
1482:
1483: FND_File.Put_Line(Fnd_File.LOG,'************END OF MASS LOAD ERRORS************');
1484:
1485: EXCEPTION
1486: WHEN others THEN
1487: l_sql_error := SQLERRM;

Line 1530: FND_File.Put_Line(Fnd_File.LOG,'BEGIN OF MASS LOAD ERRORS');

1526: BEGIN
1527:
1528: x_return_status := l_fnd_success;
1529:
1530: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1531: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1532: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1533: FOR r_error in c_error(l_txn_from_date,
1534: l_txn_to_date,

Line 1531: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');

1527:
1528: x_return_status := l_fnd_success;
1529:
1530: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1531: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1532: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1533: FOR r_error in c_error(l_txn_from_date,
1534: l_txn_to_date,
1535: p_source_system_name,

Line 1532: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');

1528: x_return_status := l_fnd_success;
1529:
1530: FND_File.Put_Line(Fnd_File.LOG,'************BEGIN OF MASS LOAD ERRORS************');
1531: FND_File.Put_Line(Fnd_File.LOG,'INST_INTERFACE_ID ERROR TEXT');
1532: FND_File.Put_Line(Fnd_File.LOG,'---------------------- ----------------------------------------------------------');
1533: FOR r_error in c_error(l_txn_from_date,
1534: l_txn_to_date,
1535: p_source_system_name,
1536: p_worker_id) LOOP

Line 1537: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);

1533: FOR r_error in c_error(l_txn_from_date,
1534: l_txn_to_date,
1535: p_source_system_name,
1536: p_worker_id) LOOP
1537: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);
1538: END LOOP;
1539:
1540: FND_File.Put_Line(Fnd_File.LOG,'************END OF MASS LOAD ERRORS************');
1541:

Line 1540: FND_File.Put_Line(Fnd_File.LOG,'END OF MASS LOAD ERRORS');

1536: p_worker_id) LOOP
1537: FND_File.Put_Line(Fnd_File.LOG,r_error.inst_interface_id||' '||r_error.error_text);
1538: END LOOP;
1539:
1540: FND_File.Put_Line(Fnd_File.LOG,'************END OF MASS LOAD ERRORS************');
1541:
1542: EXCEPTION
1543: WHEN others THEN
1544: l_sql_error := SQLERRM;

Line 1670: FND_File.Put_Line(Fnd_File.LOG,'Error is ' || l_sql_error);

1666: l_sql_error := SQLERRM;
1667: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1668: fnd_message.set_token('API_NAME',l_api_name);
1669: fnd_message.set_token('SQL_ERROR',SQLERRM);
1670: FND_File.Put_Line(Fnd_File.LOG,'Error is ' || l_sql_error);
1671: x_error_message := fnd_message.get;
1672: x_return_status := l_fnd_unexpected;
1673:
1674: END resolve_rel_ids;

Line 1945: FND_File.Put_Line(Fnd_File.LOG,'Mode p_mode is :'||p_mode);

1941: l_txn_from_date := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1942: l_txn_to_date := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
1943:
1944:
1945: FND_File.Put_Line(Fnd_File.LOG,'Mode p_mode is :'||p_mode);
1946: FND_File.Put_Line(Fnd_File.LOG,'Worker id p_worker_id is :'||p_worker_id);
1947: IF p_mode='VALIDATE'
1948: THEN
1949: FND_File.Put_Line(Fnd_File.LOG,'Inside for Validate mode');

Line 1946: FND_File.Put_Line(Fnd_File.LOG,'Worker id p_worker_id is :'||p_worker_id);

1942: l_txn_to_date := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
1943:
1944:
1945: FND_File.Put_Line(Fnd_File.LOG,'Mode p_mode is :'||p_mode);
1946: FND_File.Put_Line(Fnd_File.LOG,'Worker id p_worker_id is :'||p_worker_id);
1947: IF p_mode='VALIDATE'
1948: THEN
1949: FND_File.Put_Line(Fnd_File.LOG,'Inside for Validate mode');
1950: rel_row:=0;

Line 1949: FND_File.Put_Line(Fnd_File.LOG,'Inside for Validate mode');

1945: FND_File.Put_Line(Fnd_File.LOG,'Mode p_mode is :'||p_mode);
1946: FND_File.Put_Line(Fnd_File.LOG,'Worker id p_worker_id is :'||p_worker_id);
1947: IF p_mode='VALIDATE'
1948: THEN
1949: FND_File.Put_Line(Fnd_File.LOG,'Inside for Validate mode');
1950: rel_row:=0;
1951: FOR r_id IN c_id (p_worker_id, l_txn_from_date, l_txn_to_date ) LOOP
1952: l_iface_error_text := NULL;
1953: rel_row:=rel_row+1;

Line 2343: FND_File.Put_Line(Fnd_File.LOG,'After validation setting status E');

2339: l_status_array(rel_row) := 'V';
2340: l_rel_id_array(rel_row) := r_id.rel_interface_id;
2341: EXCEPTION
2342: WHEN SKIP_ERROR THEN
2343: FND_File.Put_Line(Fnd_File.LOG,'After validation setting status E');
2344: l_error_array(rel_row) := l_iface_error_text;
2345: l_status_array(rel_row) := 'E';
2346: l_rel_id_array(rel_row) := r_id.rel_interface_id;
2347:

Line 2349: FND_File.Put_Line(Fnd_File.LOG,'In others status E' || SQLERRM);

2345: l_status_array(rel_row) := 'E';
2346: l_rel_id_array(rel_row) := r_id.rel_interface_id;
2347:
2348: WHEN others THEN
2349: FND_File.Put_Line(Fnd_File.LOG,'In others status E' || SQLERRM);
2350: l_error_array(rel_row) := l_iface_error_text;
2351: l_status_array(rel_row) := 'E';
2352: l_rel_id_array(rel_row) := r_id.rel_interface_id;
2353: END;

Line 2356: FND_File.Put_Line(Fnd_File.LOG,'Trying to update count');

2352: l_rel_id_array(rel_row) := r_id.rel_interface_id;
2353: END;
2354: END LOOP;
2355:
2356: FND_File.Put_Line(Fnd_File.LOG,'Trying to update count');
2357: -- Update Interface Table
2358: IF l_rel_id_array.count > 0 THEN
2359: FND_File.Put_Line(Fnd_File.LOG,'Updating status in validate mode');
2360: BEGIN

Line 2359: FND_File.Put_Line(Fnd_File.LOG,'Updating status in validate mode');

2355:
2356: FND_File.Put_Line(Fnd_File.LOG,'Trying to update count');
2357: -- Update Interface Table
2358: IF l_rel_id_array.count > 0 THEN
2359: FND_File.Put_Line(Fnd_File.LOG,'Updating status in validate mode');
2360: BEGIN
2361: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2362: SET error_text = :error_text
2363: ,process_status = :status

Line 2383: FND_File.Put_Line(Fnd_File.LOG,'Inside for Update mode');

2379: -- a wait mode until the completion of all the VALIDATE mode parallel
2380: -- requests.
2381: ELSIF p_mode='UPDATE'
2382: THEN
2383: FND_File.Put_Line(Fnd_File.LOG,'Inside for Update mode');
2384: rel_row := 0;
2385: -- Get the root node and update the instance for updating the instance(subject) location
2386: FOR l_upd_ins_csr IN upd_ins_csr(p_worker_id, l_txn_from_date, l_txn_to_date)
2387: LOOP

Line 2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);

2438:
2439:
2440: l_return_status := FND_API.G_RET_STS_SUCCESS;
2441: /*
2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);
2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);

Line 2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);

2439:
2440: l_return_status := FND_API.G_RET_STS_SUCCESS;
2441: /*
2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);
2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);

Line 2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);

2440: l_return_status := FND_API.G_RET_STS_SUCCESS;
2441: /*
2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);
2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);

Line 2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);

2441: /*
2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);
2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);

Line 2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);

2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);
2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);

Line 2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);

2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);

Line 2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);

2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);
2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);

Line 2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);

2445: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_type_code := '||l_instance_rec.location_type_code);
2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);

Line 2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);

2446: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.location_id := '||l_instance_rec.location_id);
2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);

Line 2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);

2447: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_organization_id := '||l_instance_rec.inv_organization_id);
2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);
2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);

Line 2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);

2448: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_subinventory_name := '||l_instance_rec.inv_subinventory_name);
2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);
2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);
2456: */

Line 2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);

2449: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.inv_locator_id := '||l_instance_rec.inv_locator_id);
2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);
2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);
2456: */
2457: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');

Line 2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);

2450: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_id := '||l_instance_rec.pa_project_id);
2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);
2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);
2456: */
2457: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2458: l_txn_rec.transaction_date := sysdate;

Line 2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);

2451: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.pa_project_task_id := '||l_instance_rec.pa_project_task_id);
2452: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.in_transit_order_line_id := '||l_instance_rec.in_transit_order_line_id);
2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);
2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);
2456: */
2457: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2458: l_txn_rec.transaction_date := sysdate;
2459: l_txn_rec.source_transaction_date := sysdate;

Line 2482: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);

2478: ,p_oks_txn_inst_tbl => px_oks_txn_inst_tbl
2479: ,p_child_inst_tbl => px_child_inst_tbl
2480: ,p_validation_mode => 'V'
2481: );
2482: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);
2483: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);
2484:
2485:
2486:

Line 2483: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);

2479: ,p_child_inst_tbl => px_child_inst_tbl
2480: ,p_validation_mode => 'V'
2481: );
2482: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);
2483: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);
2484:
2485:
2486:
2487: IF NOT(l_return_status = fnd_api.g_ret_sts_success)

Line 2530: FND_File.Put_Line(Fnd_File.LOG,'Updating status in update mode');

2526: END LOOP;
2527:
2528: -- Update Interface Table
2529: IF l_rel_id_array.count > 0 THEN
2530: FND_File.Put_Line(Fnd_File.LOG,'Updating status in update mode');
2531: BEGIN
2532: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2533: SET error_text = :error_text
2534: ,process_status = :status

Line 2552: FND_File.Put_Line(Fnd_File.LOG,'Inside for re-update mode');

2548: END IF;
2549:
2550: ELSIF p_mode='RE-UPDATE'
2551: THEN
2552: FND_File.Put_Line(Fnd_File.LOG,'Inside for re-update mode');
2553: rel_row := 0;
2554: -- Get the root node and update the instance for updating the instance(subject) location
2555: FOR l_re_upd_csr IN re_upd_csr(p_worker_id, l_txn_from_date, l_txn_to_date)
2556: LOOP

Line 2637: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);

2633: ,p_child_inst_tbl => px_child_inst_tbl
2634: ,p_validation_mode => 'U'
2635: );
2636:
2637: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);
2638: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);
2639:
2640:
2641: IF NOT(l_return_status = fnd_api.g_ret_sts_success)

Line 2638: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);

2634: ,p_validation_mode => 'U'
2635: );
2636:
2637: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);
2638: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);
2639:
2640:
2641: IF NOT(l_return_status = fnd_api.g_ret_sts_success)
2642: THEN

Line 2681: FND_File.Put_Line(Fnd_File.LOG,'Updating status in re-update mode');

2677: END LOOP;
2678:
2679: -- Update Interface Table
2680: IF l_rel_id_array.count > 0 THEN
2681: FND_File.Put_Line(Fnd_File.LOG,'Updating status in re-update mode');
2682: BEGIN
2683: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2684: SET error_text = :error_text
2685: ,process_status = :status

Line 2703: FND_File.Put_Line(Fnd_File.LOG,'Inside for Insert mode');

2699: END IF;
2700:
2701: ELSIF p_mode='INSERT'
2702: THEN
2703: FND_File.Put_Line(Fnd_File.LOG,'Inside for Insert mode');
2704: -- This run also has to insert records into csi_ii_relationships
2705: -- ,csi_ii_relationships_h and csi_transactions
2706: l_ins:=0;
2707: l_txn_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');

Line 2916: FND_File.Put_Line(Fnd_File.LOG,'Updating status in insert mode');

2912: ,1
2913: );
2914:
2915: IF l_rel_id_array.count > 0 THEN
2916: FND_File.Put_Line(Fnd_File.LOG,'Updating status in insert mode');
2917: BEGIN
2918: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2919: SET process_status = :status
2920: WHERE rel_interface_id = :intf_id';

Line 2935: FND_File.Put_Line(Fnd_File.LOG,'End time RELATIONSHIP: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

2931: COMMIT;
2932: END IF;
2933:
2934: END IF; -- p_mode='VALIDATE'
2935: FND_File.Put_Line(Fnd_File.LOG,'End time RELATIONSHIP: '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
2936: END validate_relationship;
2937:
2938: -- Duplicate subject
2939: PROCEDURE Eliminate_dup_subject IS

Line 3158: FND_File.Put_Line(Fnd_File.LOG,'Updating status in for parent child loop ');

3154: l_rel_id_array(rel_row) := l_rel_tbl(i).rel_interface_id;
3155: END LOOP;
3156:
3157: IF l_rel_id_array.count > 0 THEN
3158: FND_File.Put_Line(Fnd_File.LOG,'Updating status in for parent child loop ');
3159: BEGIN
3160: l_upd_stmt := 'UPDATE csi_ii_relation_interface
3161: SET process_status = :status
3162: ,error_text = :error_text