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 FND_API

Line 69: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

65:
66: PROCEDURE Insert_Data (
67:
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71:
72: p_table_name IN VARCHAR2,
73: p_prim_key_name IN VARCHAR2,

Line 70: p_commit IN VARCHAR2 := FND_API.G_FALSE,

66: PROCEDURE Insert_Data (
67:
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71:
72: p_table_name IN VARCHAR2,
73: p_prim_key_name IN VARCHAR2,
74: p_seq_name IN VARCHAR2,

Line 81: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

77: p_num_col_names IN char_data_set_type_w,
78: p_str_data IN char_data_set_type_w,
79: p_num_data IN num_data_set_type_w,
80: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
81: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
82: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
83: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
84: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
85: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

Line 82: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

78: p_str_data IN char_data_set_type_w,
79: p_num_data IN num_data_set_type_w,
80: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
81: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
82: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
83: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
84: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
85: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
86:

Line 83: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

79: p_num_data IN num_data_set_type_w,
80: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
81: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
82: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
83: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
84: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
85: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
86:
87: p_col_names IN char_data_set_type_w,

Line 84: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

80: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
81: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
82: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
83: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
84: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
85: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
86:
87: p_col_names IN char_data_set_type_w,
88: p_data IN char_data_set_type_w,

Line 85: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

81: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
82: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
83: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
84: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
85: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
86:
87: p_col_names IN char_data_set_type_w,
88: p_data IN char_data_set_type_w,
89: p_error_rows IN num_data_set_type_w,

Line 99: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

95: );
96:
97: PROCEDURE Create_List_import_Error (
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
100: p_commit IN VARCHAR2 := FND_API.G_TRUE,
101: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,
102:
103: x_return_status OUT NOCOPY VARCHAR2,

Line 100: p_commit IN VARCHAR2 := FND_API.G_TRUE,

96:
97: PROCEDURE Create_List_import_Error (
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
100: p_commit IN VARCHAR2 := FND_API.G_TRUE,
101: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,
102:
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_imp_err_id OUT NOCOPY NUMBER

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: BEGIN
165: --
166: -- Initialize API return status to success.
167: --
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: IF p_import_list_header_id IS NULL THEN
171: l_error_msg := 'Expected error in ' || L_FULL_NAME
172: || ' list import header is null';

Line 173: RAISE FND_API.G_EXC_ERROR;

169:
170: IF p_import_list_header_id IS NULL THEN
171: l_error_msg := 'Expected error in ' || L_FULL_NAME
172: || ' list import header is null';
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: OPEN c_batch_id (p_import_list_header_id);
177: FETCH c_batch_id INTO l_batch_id;

Line 217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

213: p_api_version => 1.0,
214: x_return_status => x_return_status,
215: p_list_imp_error_rec => l_list_imp_error_rec,
216: x_imp_err_id => l_imp_err_id);
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: l_error_msg := 'Expected error in ' || L_FULL_NAME
219: || ' can not create error record';
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;

Line 220: RAISE FND_API.G_EXC_ERROR;

216: x_imp_err_id => l_imp_err_id);
217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
218: l_error_msg := 'Expected error in ' || L_FULL_NAME
219: || ' can not create error record';
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:
223: END IF;
224:

Line 226: WHEN FND_API.G_EXC_ERROR THEN

222:
223: END IF;
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: IF c_import_interface_data%ISOPEN THEN
228: CLOSE c_import_interface_data;
229: END IF;
230: IF c_batch_id%ISOPEN THEN

Line 236: RAISE FND_API.G_EXC_ERROR;

232: END IF;
233: IF c_lead_error_txt%ISOPEN THEN
234: CLOSE c_lead_error_txt;
235: END IF;
236: RAISE FND_API.G_EXC_ERROR;
237: WHEN OTHERS THEN
238: IF c_import_interface_data%ISOPEN THEN
239: CLOSE c_import_interface_data;
240: END IF;

Line 249: RAISE FND_API.G_EXC_ERROR;

245: CLOSE c_lead_error_txt;
246: END IF;
247: l_error_msg := 'Expected error in ' || L_FULL_NAME
248: || ' ' || SQLERRM;
249: RAISE FND_API.G_EXC_ERROR;
250: END;
251: END LOOP;
252: END IF;
253: CLOSE c_batch_id;

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: END IF;
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,

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: p_log_used_by_id => p_import_list_header_id,
261: p_msg_data => 'Expected error in ' || L_FULL_NAME,
262: p_msg_type => 'DEBUG'
263: );
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 (

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: p_log_used_by_id => p_import_list_header_id,
272: p_msg_data => l_error_msg,
273: p_msg_type => 'DEBUG'
274: );
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: END Mark_Insert_Lead_Errors;
277:
278: -- Start of comments
279: -- API Name Load_Lead_Data_To_Interface

Line 629: x_return_status := FND_API.G_RET_STS_SUCCESS;

625: BEGIN
626: --
627: -- Initialize API return status to success.
628: --
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630:
631: IF p_import_list_header_id IS NULL THEN
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;

Line 632: RAISE FND_API.G_EXC_ERROR;

628: --
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630:
631: IF p_import_list_header_id IS NULL THEN
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634:
635: OPEN c_get_batch_id (p_import_list_header_id);
636: FETCH c_get_batch_id INTO l_batch_id;

Line 1417: WHEN FND_API.G_EXC_ERROR THEN

1413:
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,

Line 1425: x_return_status := FND_API.G_RET_STS_ERROR;

1421: p_log_used_by_id => p_import_list_header_id,
1422: p_msg_data => 'Expected error in ' || L_FULL_NAME,
1423: p_msg_type => 'DEBUG'
1424: );
1425: x_return_status := FND_API.G_RET_STS_ERROR;
1426: WHEN OTHERS THEN
1427: IF c_lead_recs%ISOPEN THEN
1428: CLOSE c_lead_recs;
1429: END IF;

Line 1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1433: p_log_used_by_id => p_import_list_header_id,
1434: p_msg_data => 'Error in ' || L_FULL_NAME || ': '|| SQLERRM||' '||SQLCODE,
1435: p_msg_type => 'DEBUG'
1436: );
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: END Load_Lead_Data_To_Interface;
1439:
1440: -- NAME
1441: -- Insert_Lead_Data

Line 1468: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1464: --06/08/2001 huili Changed logic for setting up the "status_code" of
1465: -- the "ams_imp_list_headers_all" table.
1466: PROCEDURE Insert_Lead_Data (
1467: p_api_version IN NUMBER,
1468: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1469: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1470: p_import_list_header_id IN NUMBER,
1471: p_data IN char_data_set_type_w,
1472: p_error_rows IN num_data_set_type_w,

Line 1469: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1465: -- the "ams_imp_list_headers_all" table.
1466: PROCEDURE Insert_Lead_Data (
1467: p_api_version IN NUMBER,
1468: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1469: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1470: p_import_list_header_id IN NUMBER,
1471: p_data IN char_data_set_type_w,
1472: p_error_rows IN num_data_set_type_w,
1473: p_row_count IN NUMBER,

Line 1533: IF FND_API.To_Boolean (p_init_msg_list) THEN

1529:
1530: --
1531: -- Initialize message list if p_init_msg_list is set to TRUE.
1532: --
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 (

Line 1548: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

1544:
1545: --
1546: -- Standard check for API version compatibility.
1547: --
1548: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1549: p_api_version,
1550: L_API_NAME,
1551: G_PKG_NAME)
1552: THEN

Line 1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1549: p_api_version,
1550: L_API_NAME,
1551: G_PKG_NAME)
1552: THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: END IF;
1555:
1556: --
1557: -- Initialize API return status to success.

Line 1559: x_return_status := FND_API.G_RET_STS_SUCCESS;

1555:
1556: --
1557: -- Initialize API return status to success.
1558: --
1559: x_return_status := FND_API.G_RET_STS_SUCCESS;
1560:
1561: OPEN c_list_fields(p_import_list_header_id);
1562: LOOP
1563: FETCH c_list_fields INTO l_temp_vol_name, l_batch_id;

Line 1602: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1598: x_return_status => x_return_status,
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,

Line 1610: RAISE FND_API.G_EXC_ERROR;

1606: p_log_used_by_id => p_import_list_header_id,
1607: p_msg_data => l_msg_data,
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,

Line 1611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1607: p_msg_data => l_msg_data,
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,

Line 1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1615: p_log_used_by_id => p_import_list_header_id,
1616: p_msg_data => l_msg_data,
1617: p_msg_type => 'DEBUG'
1618: );
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: END IF;
1621:
1622: l_status_id := NULL;
1623: OPEN c_get_status_id;

Line 1658: IF FND_API.To_Boolean(p_commit) THEN

1654: */
1655: --
1656: -- Standard check for commit request.
1657: --
1658: IF FND_API.To_Boolean(p_commit) THEN
1659: COMMIT WORK;
1660: END IF;
1661:
1662: --AMS_Utility_PVT.Create_Log (

Line 1677: p_encoded => FND_API.G_FALSE

1673: --
1674: FND_MSG_PUB.Count_And_Get (
1675: p_count => x_msg_count,
1676: p_data => x_msg_data,
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');

Line 1684: WHEN FND_API.G_EXC_ERROR 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;
1686: FND_MSG_PUB.Count_And_Get (
1687: p_count => x_msg_count,
1688: p_data => x_msg_data

Line 1685: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1686: FND_MSG_PUB.Count_And_Get (
1687: p_count => x_msg_count,
1688: p_data => x_msg_data
1689: );

Line 1690: RAISE FND_API.G_EXC_ERROR;

1686: FND_MSG_PUB.Count_And_Get (
1687: p_count => x_msg_count,
1688: p_data => x_msg_data
1689: );
1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Count_And_Get (

Line 1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1688: p_data => x_msg_data
1689: );
1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Count_And_Get (
1695: p_count => x_msg_count,
1696: p_data => x_msg_data

Line 1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1689: );
1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Count_And_Get (
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );

Line 1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1694: FND_MSG_PUB.Count_And_Get (
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );
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 (

Line 1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1705: p_log_used_by_id => p_import_list_header_id,
1706: p_msg_data => FND_MESSAGE.get,
1707: p_msg_type => 'DEBUG'
1708: );
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1711: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1712: END IF;
1713: FND_MSG_PUB.Count_And_Get (

Line 1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1713: FND_MSG_PUB.Count_And_Get (
1714: p_count => x_msg_count,
1715: p_data => x_msg_data
1716: );
1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1718: END Insert_Lead_Data;
1719:
1720:
1721: -- NAME

Line 1749: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1745: -- "ams_imp_list_headers_all" table
1746: --
1747: PROCEDURE Insert_List_Data (
1748: p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1750: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1751: p_import_list_header_id IN NUMBER,
1752: p_data IN char_data_set_type_w,
1753: p_row_count IN NUMBER,

Line 1750: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1746: --
1747: PROCEDURE Insert_List_Data (
1748: p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1750: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1751: p_import_list_header_id IN NUMBER,
1752: p_data IN char_data_set_type_w,
1753: p_row_count IN NUMBER,
1754: p_error_rows IN num_data_set_type_w,

Line 1822: IF FND_API.To_Boolean (p_init_msg_list) THEN

1818:
1819: --
1820: -- Initialize message list if p_init_msg_list is set to TRUE.
1821: --
1822: IF FND_API.To_Boolean (p_init_msg_list) THEN
1823: FND_MSG_PUB.Initialize;
1824: END IF;
1825:
1826: --

Line 1829: --IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

1825:
1826: --
1827: -- Standard check for API version compatibility.
1828: --
1829: --IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1830: -- p_api_version,
1831: -- L_API_NAME,
1832: -- G_PKG_NAME)
1833: --THEN

Line 1843: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1839: -- p_log_used_by_id => p_import_list_header_id,
1840: -- p_msg_data => FND_MESSAGE.get,
1841: -- p_msg_type => 'DEBUG'
1842: -- );
1843: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: -- END IF;
1845:
1846: --
1847: -- Initialize API return status to success.

Line 1849: x_return_status := FND_API.G_RET_STS_SUCCESS;

1845:
1846: --
1847: -- Initialize API return status to success.
1848: --
1849: x_return_status := FND_API.G_RET_STS_SUCCESS;
1850:
1851: OPEN c_list_fields(p_import_list_header_id);
1852: LOOP
1853: FETCH c_list_fields INTO l_temp_vol_name, l_field_table_name, l_batch_id;

Line 1889: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1885: x_return_status => x_return_status,
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,

Line 1897: RAISE FND_API.G_EXC_ERROR;

1893: p_log_used_by_id => p_import_list_header_id,
1894: p_msg_data => l_msg_data,
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,

Line 1898: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1894: p_msg_data => l_msg_data,
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,

Line 1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1902: p_log_used_by_id => p_import_list_header_id,
1903: p_msg_data => l_msg_data,
1904: p_msg_type => 'DEBUG'
1905: );
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: END IF;
1908:
1909: l_status_id := NULL;
1910: OPEN c_get_status_id;

Line 1945: IF FND_API.To_Boolean(p_commit) THEN

1941: */
1942: --
1943: -- Standard check for commit request.
1944: --
1945: IF FND_API.To_Boolean(p_commit) THEN
1946: COMMIT WORK;
1947: END IF;
1948:
1949: --AMS_Utility_PVT.Create_Log (

Line 1963: p_encoded => FND_API.G_FALSE

1959: --
1960: FND_MSG_PUB.Count_And_Get (
1961: p_count => x_msg_count,
1962: p_data => x_msg_data,
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');

Line 1970: WHEN FND_API.G_EXC_ERROR 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;
1972: FND_MSG_PUB.Count_And_Get (
1973: p_count => x_msg_count,
1974: p_data => x_msg_data

Line 1971: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1972: FND_MSG_PUB.Count_And_Get (
1973: p_count => x_msg_count,
1974: p_data => x_msg_data
1975: );

Line 1976: RAISE FND_API.G_EXC_ERROR;

1972: FND_MSG_PUB.Count_And_Get (
1973: p_count => x_msg_count,
1974: p_data => x_msg_data
1975: );
1976: RAISE FND_API.G_EXC_ERROR;
1977:
1978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1980: FND_MSG_PUB.Count_And_Get (

Line 1978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1974: p_data => x_msg_data
1975: );
1976: RAISE FND_API.G_EXC_ERROR;
1977:
1978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1980: FND_MSG_PUB.Count_And_Get (
1981: p_count => x_msg_count,
1982: p_data => x_msg_data

Line 1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1975: );
1976: RAISE FND_API.G_EXC_ERROR;
1977:
1978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1980: FND_MSG_PUB.Count_And_Get (
1981: p_count => x_msg_count,
1982: p_data => x_msg_data
1983: );

Line 1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1980: FND_MSG_PUB.Count_And_Get (
1981: p_count => x_msg_count,
1982: p_data => x_msg_data
1983: );
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 (

Line 1995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1991: p_log_used_by_id => p_import_list_header_id,
1992: p_msg_data => FND_MESSAGE.get,
1993: p_msg_type => 'DEBUG'
1994: );
1995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1996: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1997: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1998: END IF;
1999: FND_MSG_PUB.Count_And_Get (

Line 2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1999: FND_MSG_PUB.Count_And_Get (
2000: p_count => x_msg_count,
2001: p_data => x_msg_data
2002: );
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2004: END Insert_List_Data;
2005:
2006: PROCEDURE Write_Message (
2007: x_return_status OUT NOCOPY VARCHAR2,

Line 2024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2020: p_msg_data => p_msg_data,
2021: p_msg_type => p_msg_type
2022: );
2023: EXCEPTION WHEN OTHERS THEN
2024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2026: END;
2027:
2028:

Line 2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2021: p_msg_type => p_msg_type
2022: );
2023: EXCEPTION WHEN OTHERS THEN
2024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2026: END;
2027:
2028:
2029: -- NAME

Line 2071: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2067: --
2068: PROCEDURE Insert_Data (
2069:
2070: p_api_version IN NUMBER,
2071: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2072: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2073:
2074: p_table_name IN VARCHAR2,
2075: p_prim_key_name IN VARCHAR2,

Line 2072: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2068: PROCEDURE Insert_Data (
2069:
2070: p_api_version IN NUMBER,
2071: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2072: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2073:
2074: p_table_name IN VARCHAR2,
2075: p_prim_key_name IN VARCHAR2,
2076: p_seq_name IN VARCHAR2,

Line 2083: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

2079: p_num_col_names IN char_data_set_type_w,
2080: p_str_data IN char_data_set_type_w,
2081: p_num_data IN num_data_set_type_w,
2082: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
2083: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2084: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2085: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2086: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2087: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

Line 2084: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

2080: p_str_data IN char_data_set_type_w,
2081: p_num_data IN num_data_set_type_w,
2082: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
2083: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2084: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2085: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2086: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2087: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2088:

Line 2085: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

2081: p_num_data IN num_data_set_type_w,
2082: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
2083: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2084: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2085: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2086: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2087: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2088:
2089: p_col_names IN char_data_set_type_w,

Line 2086: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

2082: p_obj_version_num IN NUMBER := NULL, -- if NULL, do not insert this column
2083: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2084: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2085: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2086: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2087: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2088:
2089: p_col_names IN char_data_set_type_w,
2090: p_data IN char_data_set_type_w,

Line 2087: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?

2083: p_last_update_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2084: p_last_update_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2085: p_creation_date_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2086: p_created_by_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2087: p_ls_update_log_flag IN VARCHAR2 := FND_API.G_TRUE,-- need this column?
2088:
2089: p_col_names IN char_data_set_type_w,
2090: p_data IN char_data_set_type_w,
2091: p_error_rows IN num_data_set_type_w,

Line 2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

2163:
2164: --
2165: -- Initialize API return status to success.
2166: --
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;
2168:
2169: l_orig_col_count := p_col_names.COUNT;
2170:
2171: IF l_orig_col_count < 1 THEN

Line 2172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2168:
2169: l_orig_col_count := p_col_names.COUNT;
2170:
2171: IF l_orig_col_count < 1 THEN
2172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2173: END IF;
2174:
2175: l_date := SYSDATE;
2176: l_user_id := FND_GLOBAL.User_ID;

Line 2323: RAISE FND_API.G_EXC_ERROR;

2319: WHEN OTHERS THEN
2320: dbms_sql.close_cursor (g_cursor);
2321: x_msg_data := 'Error at row ' || i || ' ' || SQLERRM;
2322: x_msg_data := x_msg_data || ' If you mapped the "party_id" , it should be a number.';
2323: RAISE FND_API.G_EXC_ERROR;
2324: END;
2325: END LOOP;
2326: dbms_sql.close_cursor (g_cursor);
2327:

Line 2358: IF FND_API.To_Boolean (p_commit) THEN

2354:
2355: --
2356: -- Standard check for commit request.
2357: --
2358: IF FND_API.To_Boolean (p_commit) THEN
2359: COMMIT WORK;
2360: END IF;
2361:
2362: --

Line 2369: p_encoded => FND_API.G_FALSE

2365: --
2366: FND_MSG_PUB.Count_And_Get (
2367: p_count => x_msg_count,
2368: p_data => x_msg_data,
2369: p_encoded => FND_API.G_FALSE
2370: );
2371:
2372: EXCEPTION
2373: WHEN FND_API.G_EXC_ERROR THEN

Line 2373: WHEN FND_API.G_EXC_ERROR THEN

2369: p_encoded => FND_API.G_FALSE
2370: );
2371:
2372: EXCEPTION
2373: WHEN FND_API.G_EXC_ERROR THEN
2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375: --x_msg_data := 'Error happens AT ROW ' || l_row_seq
2376: -- || '. The error message IS ' || SQLERRM;
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2374: x_return_status := FND_API.G_RET_STS_ERROR;

2370: );
2371:
2372: EXCEPTION
2373: WHEN FND_API.G_EXC_ERROR THEN
2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375: --x_msg_data := 'Error happens AT ROW ' || l_row_seq
2376: -- || '. The error message IS ' || SQLERRM;
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2373: WHEN FND_API.G_EXC_ERROR THEN
2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375: --x_msg_data := 'Error happens AT ROW ' || l_row_seq
2376: -- || '. The error message IS ' || SQLERRM;
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: x_msg_data := 'Error happens AT ROW ' || l_row_seq
2380: || '. The error message IS ' || SQLERRM;
2381:

Line 2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375: --x_msg_data := 'Error happens AT ROW ' || l_row_seq
2376: -- || '. The error message IS ' || SQLERRM;
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: x_msg_data := 'Error happens AT ROW ' || l_row_seq
2380: || '. The error message IS ' || SQLERRM;
2381:
2382: WHEN OTHERS THEN

Line 2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2379: x_msg_data := 'Error happens AT ROW ' || l_row_seq
2380: || '. The error message IS ' || SQLERRM;
2381:
2382: WHEN OTHERS THEN
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2384: x_msg_data := 'Unexpected error ' || SQLERRM;
2385: END Insert_Data;
2386:
2387:

Line 2444: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2440: -- End of comments
2441:
2442: PROCEDURE Create_List_import_Error (
2443: p_api_version IN NUMBER,
2444: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2445: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2446: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,
2447:
2448: x_return_status OUT NOCOPY VARCHAR2,

Line 2445: p_commit IN VARCHAR2 := FND_API.G_TRUE,

2441:
2442: PROCEDURE Create_List_import_Error (
2443: p_api_version IN NUMBER,
2444: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2445: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2446: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,
2447:
2448: x_return_status OUT NOCOPY VARCHAR2,
2449: x_imp_err_id OUT NOCOPY NUMBER

Line 2486: IF FND_API.To_Boolean (p_init_msg_list) THEN

2482:
2483: --
2484: -- Initialize message list if p_init_msg_list is set to TRUE.
2485: --
2486: IF FND_API.To_Boolean (p_init_msg_list) THEN
2487: FND_MSG_PUB.Initialize;
2488: END IF;
2489:
2490: --

Line 2493: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

2489:
2490: --
2491: -- Standard check for API version compatibility.
2492: --
2493: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
2494: p_api_version,
2495: L_API_NAME,
2496: G_PKG_NAME)
2497: THEN

Line 2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2494: p_api_version,
2495: L_API_NAME,
2496: G_PKG_NAME)
2497: THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: END IF;
2500:
2501: IF p_list_imp_error_rec.import_list_header_id IS NULL
2502: OR p_list_imp_error_rec.import_source_line_id IS NULL THEN

Line 2503: RAISE FND_API.G_EXC_ERROR;

2499: END IF;
2500:
2501: IF p_list_imp_error_rec.import_list_header_id IS NULL
2502: OR p_list_imp_error_rec.import_source_line_id IS NULL THEN
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;
2505:
2506: --
2507: -- Initialize API return status to success.

Line 2509: x_return_status := FND_API.G_RET_STS_SUCCESS;

2505:
2506: --
2507: -- Initialize API return status to success.
2508: --
2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510:
2511: LOOP
2512: SELECT AMS_LIST_IMPORT_ERRORS_S.NEXTVAL INTO l_list_imp_id
2513: FROM DUAL;

Line 2568: IF FND_API.To_Boolean (p_commit) THEN

2564:
2565: --
2566: -- Standard check for commit request.
2567: --
2568: IF FND_API.To_Boolean (p_commit) THEN
2569: COMMIT WORK;
2570: END IF;
2571:
2572: EXCEPTION

Line 2573: WHEN FND_API.G_EXC_ERROR THEN

2569: COMMIT WORK;
2570: END IF;
2571:
2572: EXCEPTION
2573: WHEN FND_API.G_EXC_ERROR THEN
2574: ROLLBACK TO Create_List_import_Error_pvt;
2575: x_return_status := FND_API.G_RET_STS_ERROR;
2576:
2577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2575: x_return_status := FND_API.G_RET_STS_ERROR;

2571:
2572: EXCEPTION
2573: WHEN FND_API.G_EXC_ERROR THEN
2574: ROLLBACK TO Create_List_import_Error_pvt;
2575: x_return_status := FND_API.G_RET_STS_ERROR;
2576:
2577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2578: ROLLBACK TO Create_List_import_Error_pvt;
2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2573: WHEN FND_API.G_EXC_ERROR THEN
2574: ROLLBACK TO Create_List_import_Error_pvt;
2575: x_return_status := FND_API.G_RET_STS_ERROR;
2576:
2577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2578: ROLLBACK TO Create_List_import_Error_pvt;
2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2580:
2581: WHEN OTHERS THEN

Line 2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2575: x_return_status := FND_API.G_RET_STS_ERROR;
2576:
2577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2578: ROLLBACK TO Create_List_import_Error_pvt;
2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2580:
2581: WHEN OTHERS THEN
2582: ROLLBACK TO Create_List_import_Error_pvt;
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2580:
2581: WHEN OTHERS THEN
2582: ROLLBACK TO Create_List_import_Error_pvt;
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2584:
2585: END Create_List_import_Error;
2586:
2587: END AMS_ImportClient_PVT;