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_AVF_PRIM_VSTS_PVT dependencies on FND_FILE

Line 1242: fnd_file.put_line(fnd_file.log, 'List of Visit Numbers created ');

1238: CLOSE get_dates;
1239: END IF;
1240:
1241: -- Added for logging visit numbers :: SATRAJEN
1242: fnd_file.put_line(fnd_file.log, 'List of Visit Numbers created ');
1243:
1244:
1245: FOR l_prog_typ_rec IN get_program_type_code( p_snapshot_id ) LOOP
1246: OPEN get_count_prog_subtyp ( p_snapshot_id, l_prog_typ_rec.PROGRAM_TYPE_CODE );

Line 1434: fnd_file.put_line(fnd_file.log, l_visit_number);

1430: l_visit_number := NULL;
1431: OPEN get_visit_number(l_visit_rec.visit_id);
1432: FETCH get_visit_number INTO l_visit_number;
1433: CLOSE get_visit_number;
1434: fnd_file.put_line(fnd_file.log, l_visit_number);
1435: -- End of logging
1436: END IF; -- Return Status is not Success
1437:
1438:

Line 1705: fnd_file.put_line(fnd_file.log, l_visit_number);

1701: l_visit_number := NULL;
1702: OPEN get_visit_number(l_visit_rec.visit_id);
1703: FETCH get_visit_number INTO l_visit_number;
1704: CLOSE get_visit_number;
1705: fnd_file.put_line(fnd_file.log, l_visit_number);
1706: -- End of logging
1707: END IF; -- Return Status is not Success
1708:
1709: IF (l_log_statement >= l_log_current_level) THEN

Line 1797: fnd_file.put_line(fnd_file.log, ' END of Visits Created ');

1793: END LOOP; --loop for MC
1794: END IF; -- IF l_count > 0
1795: END LOOP; -- loop for program type
1796: -- Added for logging visit numbers :: SATRAJEN
1797: fnd_file.put_line(fnd_file.log, '** END of Visits Created ** ');
1798:
1799:
1800: ---------------------------End of Body-------------------------------------
1801: -- END of API body.

Line 1906: fnd_file.put_line(fnd_file.log, '*API input parameters**');

1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: END IF;
1904:
1905: -- 2. Dump all input parameters
1906: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);
1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

Line 1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);

1903: END IF;
1904:
1905: -- 2. Dump all input parameters
1906: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);
1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

Line 1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

1904:
1905: -- 2. Dump all input parameters
1906: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);
1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
1912:

Line 1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

1905: -- 2. Dump all input parameters
1906: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);
1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
1912:
1913: SELECT create_visit_flag, add_planned_reqs_flag, cancel_visit_flag

Line 1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

1906: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);
1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
1912:
1913: SELECT create_visit_flag, add_planned_reqs_flag, cancel_visit_flag
1914: INTO l_create_visit_flag, l_add_planned_reqs_flag, l_cancel_visit_flag

Line 1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

1907: fnd_file.put_line(fnd_file.log, 'p_snapshot_id -> '|| p_snapshot_id);
1908: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
1909: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
1910: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
1911: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
1912:
1913: SELECT create_visit_flag, add_planned_reqs_flag, cancel_visit_flag
1914: INTO l_create_visit_flag, l_add_planned_reqs_flag, l_cancel_visit_flag
1915: FROM ahl_autovst_snpsht_hdr WHERE snapshot_id = p_snapshot_id;

Line 1917: fnd_file.put_line(fnd_file.log, 'l_create_visit_flag -> '|| l_create_visit_flag);

1913: SELECT create_visit_flag, add_planned_reqs_flag, cancel_visit_flag
1914: INTO l_create_visit_flag, l_add_planned_reqs_flag, l_cancel_visit_flag
1915: FROM ahl_autovst_snpsht_hdr WHERE snapshot_id = p_snapshot_id;
1916:
1917: fnd_file.put_line(fnd_file.log, 'l_create_visit_flag -> '|| l_create_visit_flag);
1918: fnd_file.put_line(fnd_file.log, 'l_add_planned_reqs_flag -> '|| l_add_planned_reqs_flag);
1919: fnd_file.put_line(fnd_file.log, 'l_cancel_visit_flag -> '|| l_cancel_visit_flag);
1920:
1921:

Line 1918: fnd_file.put_line(fnd_file.log, 'l_add_planned_reqs_flag -> '|| l_add_planned_reqs_flag);

1914: INTO l_create_visit_flag, l_add_planned_reqs_flag, l_cancel_visit_flag
1915: FROM ahl_autovst_snpsht_hdr WHERE snapshot_id = p_snapshot_id;
1916:
1917: fnd_file.put_line(fnd_file.log, 'l_create_visit_flag -> '|| l_create_visit_flag);
1918: fnd_file.put_line(fnd_file.log, 'l_add_planned_reqs_flag -> '|| l_add_planned_reqs_flag);
1919: fnd_file.put_line(fnd_file.log, 'l_cancel_visit_flag -> '|| l_cancel_visit_flag);
1920:
1921:
1922: IF NVL(l_cancel_visit_flag,'N') = 'Y' THEN

Line 1919: fnd_file.put_line(fnd_file.log, 'l_cancel_visit_flag -> '|| l_cancel_visit_flag);

1915: FROM ahl_autovst_snpsht_hdr WHERE snapshot_id = p_snapshot_id;
1916:
1917: fnd_file.put_line(fnd_file.log, 'l_create_visit_flag -> '|| l_create_visit_flag);
1918: fnd_file.put_line(fnd_file.log, 'l_add_planned_reqs_flag -> '|| l_add_planned_reqs_flag);
1919: fnd_file.put_line(fnd_file.log, 'l_cancel_visit_flag -> '|| l_cancel_visit_flag);
1920:
1921:
1922: IF NVL(l_cancel_visit_flag,'N') = 'Y' THEN
1923: fnd_file.put_line(fnd_file.log, 'before calling Cancel_Visits');

Line 1923: fnd_file.put_line(fnd_file.log, 'before calling Cancel_Visits');

1919: fnd_file.put_line(fnd_file.log, 'l_cancel_visit_flag -> '|| l_cancel_visit_flag);
1920:
1921:
1922: IF NVL(l_cancel_visit_flag,'N') = 'Y' THEN
1923: fnd_file.put_line(fnd_file.log, 'before calling Cancel_Visits');
1924: Cancel_Visits (
1925: p_api_version => 1.0,
1926: p_init_msg_list => FND_API.G_FALSE,
1927: p_commit => FND_API.G_FALSE,

Line 1937: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Cancel_Visits..');

1933: );
1934:
1935: l_msg_count := FND_MSG_PUB.Count_Msg;
1936: IF (l_msg_count > 0) THEN
1937: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Cancel_Visits..');
1938: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1939: RAISE FND_API.G_EXC_ERROR;
1940: ELSE
1941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1951: fnd_file.put_line(fnd_file.log, 'before calling Create_Primary_Visits');

1947: END IF;
1948:
1949: -- SATRAJEN : Bug 16048246 : Procedure Call based on the number of options selected.:: Added p_add_plan_flag parameter. :: 28-12-2012
1950: IF NVL(l_create_visit_flag,'N') = 'Y' THEN
1951: fnd_file.put_line(fnd_file.log, 'before calling Create_Primary_Visits');
1952: Create_Primary_Visits (
1953: p_api_version => 1.0,
1954: p_init_msg_list => FND_API.G_FALSE,
1955: p_commit => FND_API.G_FALSE,

Line 1966: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Create_Primary_Visits..');

1962: );
1963:
1964: l_msg_count := FND_MSG_PUB.Count_Msg;
1965: IF (l_msg_count > 0) THEN
1966: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Create_Primary_Visits..');
1967: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1968: RAISE FND_API.G_EXC_ERROR;
1969: ELSE
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1980: fnd_file.put_line(fnd_file.log, 'before calling Add_Planned_MRs');

1976:
1977: -- SATRAJEN : Bug 16048246 : Procedure Call based on the number of options selected. :: 28-12-2012
1978: -- IF NVL(l_add_planned_reqs_flag,'N') = 'Y' THEN
1979: IF ((NVL(l_add_planned_reqs_flag,'N') = 'Y') AND (NVL(l_create_visit_flag,'N') = 'N')) THEN
1980: fnd_file.put_line(fnd_file.log, 'before calling Add_Planned_MRs');
1981: Add_Planned_MRs (
1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_FALSE,
1984: p_commit => FND_API.G_FALSE,

Line 1994: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Add_Planned_MRs..');

1990: );
1991:
1992: l_msg_count := FND_MSG_PUB.Count_Msg;
1993: IF (l_msg_count > 0) THEN
1994: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Add_Planned_MRs..');
1995: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1996: RAISE FND_API.G_EXC_ERROR;
1997: ELSE
1998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2012: p_encoded => FND_API.G_FALSE,
2013: p_data => l_err_msg,
2014: p_msg_index_out => l_msg_index_out);
2015:
2016: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
2017: END LOOP;
2018:
2019:
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2027: p_encoded => FND_API.G_FALSE,
2028: p_data => l_err_msg,
2029: p_msg_index_out => l_msg_index_out);
2030:
2031: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
2032: END LOOP;
2033:
2034:
2035: WHEN OTHERS THEN

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

2047: p_encoded => FND_API.G_FALSE,
2048: p_data => l_err_msg,
2049: p_msg_index_out => l_msg_index_out);
2050:
2051: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
2052: END LOOP;
2053:
2054:
2055: END Process_Primary_visits;