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.AMS_IMPORTCLIENT_PVT dependencies on AMS_UTILITY_PVT

Line 257: AMS_Utility_PVT.Create_Log (

253: CLOSE c_batch_id;
254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: AMS_Utility_PVT.Create_Log (
258: x_return_status => x_return_status,
259: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
260: p_log_used_by_id => p_import_list_header_id,
261: p_msg_data => 'Expected error in ' || L_FULL_NAME,

Line 268: AMS_Utility_PVT.Create_Log (

264: x_return_status := FND_API.G_RET_STS_ERROR;
265: WHEN OTHERS THEN
266: l_error_msg := 'Unexpected error in '
267: || L_FULL_NAME || ': '|| SQLERRM;
268: AMS_Utility_PVT.Create_Log (
269: x_return_status => x_return_status,
270: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
271: p_log_used_by_id => p_import_list_header_id,
272: p_msg_data => l_error_msg,

Line 1418: AMS_Utility_PVT.Create_Log (

1414: COMMIT;
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: AMS_Utility_PVT.Create_Log (
1419: x_return_status => x_return_status,
1420: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1421: p_log_used_by_id => p_import_list_header_id,
1422: p_msg_data => 'Expected error in ' || L_FULL_NAME,

Line 1430: AMS_Utility_PVT.Create_Log (

1426: WHEN OTHERS THEN
1427: IF c_lead_recs%ISOPEN THEN
1428: CLOSE c_lead_recs;
1429: END IF;
1430: AMS_Utility_PVT.Create_Log (
1431: x_return_status => x_return_status,
1432: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1433: p_log_used_by_id => p_import_list_header_id,
1434: p_msg_data => 'Error in ' || L_FULL_NAME || ': '|| SQLERRM||' '||SQLCODE,

Line 1537: --AMS_Utility_PVT.Create_Log (

1533: IF FND_API.To_Boolean (p_init_msg_list) THEN
1534: FND_MSG_PUB.Initialize;
1535: END IF;
1536:
1537: --AMS_Utility_PVT.Create_Log (
1538: -- x_return_status => l_return_status,
1539: -- p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1540: -- p_log_used_by_id => p_import_list_header_id,
1541: -- p_msg_data => 'Start client lead importing.',

Line 1603: AMS_Utility_PVT.Create_Log (

1599: x_msg_count => x_msg_count,
1600: x_msg_data => l_msg_data);
1601:
1602: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1603: AMS_Utility_PVT.Create_Log (
1604: x_return_status => l_return_status,
1605: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1606: p_log_used_by_id => p_import_list_header_id,
1607: p_msg_data => l_msg_data,

Line 1612: AMS_Utility_PVT.Create_Log (

1608: p_msg_type => 'DEBUG'
1609: );
1610: RAISE FND_API.G_EXC_ERROR;
1611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1612: AMS_Utility_PVT.Create_Log (
1613: x_return_status => l_return_status,
1614: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1615: p_log_used_by_id => p_import_list_header_id,
1616: p_msg_data => l_msg_data,

Line 1662: --AMS_Utility_PVT.Create_Log (

1658: IF FND_API.To_Boolean(p_commit) THEN
1659: COMMIT WORK;
1660: END IF;
1661:
1662: --AMS_Utility_PVT.Create_Log (
1663: -- x_return_status => l_return_status,
1664: -- p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1665: -- p_log_used_by_id => p_import_list_header_id,
1666: -- p_msg_data => 'Client lead:' || l_time,

Line 1681: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1677: p_encoded => FND_API.G_FALSE
1678: );
1679: IF (AMS_DEBUG_HIGH_ON) THEN
1680:
1681: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1682: END IF;
1683: EXCEPTION
1684: WHEN FND_API.G_EXC_ERROR THEN
1685: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1702: AMS_Utility_PVT.Create_Log (

1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1699: WHEN OTHERS THEN
1700: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1701: FND_MESSAGE.Set_Token('ROW','Error in client lead import program ' || SQLERRM||' '||SQLCODE);
1702: AMS_Utility_PVT.Create_Log (
1703: x_return_status => l_return_status,
1704: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1705: p_log_used_by_id => p_import_list_header_id,
1706: p_msg_data => FND_MESSAGE.get,

Line 1811: --AMS_Utility_PVT.Create_Log (

1807: l_data_count NUMBER := p_data.COUNT;
1808: BEGIN
1809:
1810:
1811: --AMS_Utility_PVT.Create_Log (
1812: -- x_return_status => l_return_status,
1813: -- p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1814: -- p_log_used_by_id => p_import_list_header_id,
1815: -- p_msg_data => 'Starting client list importing...',

Line 1836: -- AMS_Utility_PVT.Create_Log (

1832: -- G_PKG_NAME)
1833: --THEN
1834: -- FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1835: -- FND_MESSAGE.Set_Token('ROW','API is not compatible for ' || G_PKG_NAME || '.'|| L_API_NAME);
1836: -- AMS_Utility_PVT.Create_Log (
1837: -- x_return_status => l_return_status,
1838: -- p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1839: -- p_log_used_by_id => p_import_list_header_id,
1840: -- p_msg_data => FND_MESSAGE.get,

Line 1890: AMS_Utility_PVT.Create_Log (

1886: x_msg_count => x_msg_count,
1887: x_msg_data => l_msg_data);
1888:
1889: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1890: AMS_Utility_PVT.Create_Log (
1891: x_return_status => l_return_status,
1892: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1893: p_log_used_by_id => p_import_list_header_id,
1894: p_msg_data => l_msg_data,

Line 1899: AMS_Utility_PVT.Create_Log (

1895: p_msg_type => 'DEBUG'
1896: );
1897: RAISE FND_API.G_EXC_ERROR;
1898: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1899: AMS_Utility_PVT.Create_Log (
1900: x_return_status => l_return_status,
1901: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1902: p_log_used_by_id => p_import_list_header_id,
1903: p_msg_data => l_msg_data,

Line 1949: --AMS_Utility_PVT.Create_Log (

1945: IF FND_API.To_Boolean(p_commit) THEN
1946: COMMIT WORK;
1947: END IF;
1948:
1949: --AMS_Utility_PVT.Create_Log (
1950: -- x_return_status => l_return_status,
1951: -- p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1952: -- p_log_used_by_id => p_import_list_header_id,
1953: -- p_msg_data => 'Client list importing is finished without error...',

Line 1967: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1963: p_encoded => FND_API.G_FALSE
1964: );
1965: IF (AMS_DEBUG_HIGH_ON) THEN
1966:
1967: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1968: END IF;
1969: EXCEPTION
1970: WHEN FND_API.G_EXC_ERROR THEN
1971: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1988: AMS_Utility_PVT.Create_Log (

1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1985: WHEN OTHERS THEN
1986: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1987: FND_MESSAGE.Set_Token('ROW','Error in client list import program ' || SQLERRM||' '||SQLCODE);
1988: AMS_Utility_PVT.Create_Log (
1989: x_return_status => l_return_status,
1990: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1991: p_log_used_by_id => p_import_list_header_id,
1992: p_msg_data => FND_MESSAGE.get,

Line 2016: AMS_Utility_PVT.Create_Log (

2012: IS
2013:
2014: BEGIN
2015:
2016: AMS_Utility_PVT.Create_Log (
2017: x_return_status => x_return_status,
2018: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2019: p_log_used_by_id => p_log_used_by_id,
2020: p_msg_data => p_msg_data,

Line 2479: Ams_Utility_Pvt.Debug_Message(l_full_name||': START');

2475: IF (AMS_DEBUG_HIGH_ON) THEN
2476:
2477:
2478:
2479: Ams_Utility_Pvt.Debug_Message(l_full_name||': START');
2480:
2481: END IF;
2482:
2483: --