[Home] [Help]
1476: x_msg_data OUT NOCOPY VARCHAR2
1477: )
1478: IS
1479: --
1480: -- Standard API information constants.
1481: --
1482: L_API_VERSION CONSTANT NUMBER := 1.0;
1483: L_API_NAME CONSTANT VARCHAR2(30) := 'Insert_Lead_Data';
1484: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
1542: -- p_msg_type => 'DEBUG'
1543: --);
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,
1652: END IF;
1653: -- 06/16/2001
1654: */
1655: --
1656: -- Standard check for commit request.
1657: --
1658: IF FND_API.To_Boolean(p_commit) THEN
1659: COMMIT WORK;
1660: END IF;
1667: -- p_msg_type => 'DEBUG'
1668: --);
1669:
1670: --
1671: -- Standard API to get message count, and if 1,
1672: -- set the message data OUT variable.
1673: --
1674: FND_MSG_PUB.Count_And_Get (
1675: p_count => x_msg_count,
1757: x_msg_data OUT NOCOPY VARCHAR2
1758: )
1759: IS
1760: --
1761: -- Standard API information constants.
1762: --
1763: L_API_VERSION CONSTANT NUMBER := 1.0;
1764: L_API_NAME CONSTANT VARCHAR2(30) := 'Insert_List_Data';
1765: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
1823: FND_MSG_PUB.Initialize;
1824: END IF;
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,
1939: END IF;
1940: -- 06/16/2001
1941: */
1942: --
1943: -- Standard check for commit request.
1944: --
1945: IF FND_API.To_Boolean(p_commit) THEN
1946: COMMIT WORK;
1947: END IF;
1953: -- p_msg_data => 'Client list importing is finished without error...',
1954: -- p_msg_type => 'DEBUG'
1955: --);
1956: --
1957: -- Standard API to get message count, and if 1,
1958: -- set the message data OUT variable.
1959: --
1960: FND_MSG_PUB.Count_And_Get (
1961: p_count => x_msg_count,
2097: )
2098: IS
2099:
2100: --
2101: -- Standard API information constants.
2102: --
2103: L_API_VERSION CONSTANT NUMBER := 1.0;
2104: L_API_NAME CONSTANT VARCHAR2(30) := 'Insert_Data';
2105: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
2352: --
2353: --END LOOP;
2354:
2355: --
2356: -- Standard check for commit request.
2357: --
2358: IF FND_API.To_Boolean (p_commit) THEN
2359: COMMIT WORK;
2360: END IF;
2359: COMMIT WORK;
2360: END IF;
2361:
2362: --
2363: -- Standard API to get message count, and if 1,
2364: -- set the message data OUT variable.
2365: --
2366: FND_MSG_PUB.Count_And_Get (
2367: p_count => x_msg_count,
2433: -- NOTES
2434: --
2435: -- HISTORY
2436: -- 05/26/1999 choang Created.
2437: -- 10/9/1999 ptendulk Modified According to new Standards
2438: -- 17-Apr-2000 tdonohoe Added columns to support 11.5.2 release.
2439: --
2440: -- End of comments
2441:
2449: x_imp_err_id OUT NOCOPY NUMBER
2450: )
2451: IS
2452: --
2453: -- Standard API information constants.
2454: --
2455: L_API_VERSION CONSTANT NUMBER := 1.0;
2456: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_LIST_IMPORT_ERROR';
2457: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
2487: FND_MSG_PUB.Initialize;
2488: END IF;
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,
2562:
2563: x_imp_err_id := l_list_imp_id;
2564:
2565: --
2566: -- Standard check for commit request.
2567: --
2568: IF FND_API.To_Boolean (p_commit) THEN
2569: COMMIT WORK;
2570: END IF;