188: l_action_value VARCHAR2(15);
189:
190:
191: BEGIN
192: -- Standard Start of API savepoint
193: SAVEPOINT RUN_LEAD_ENGINES_PVT;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
191: BEGIN
192: -- Standard Start of API savepoint
193: SAVEPOINT RUN_LEAD_ENGINES_PVT;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
535: --
536: -- END of API body
537: --
538:
539: -- Standard check for p_commit
540: IF FND_API.to_Boolean( p_commit )
541: THEN
542: COMMIT WORK;
543: END IF;
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
548: 'PVT: ' || l_api_name || ' End');
549: END IF;
550:
551: -- Standard call to get message count and IF count is 1, get message info.
552: FND_MSG_PUB.Count_And_Get
553: ( p_count => x_msg_count,
554: p_data => x_msg_data );
555:
1219:
1220:
1221:
1222: BEGIN
1223: -- Standard Start of API savepoint
1224: SAVEPOINT RATE_SELECT_LEAD_PVT;
1225:
1226: -- Standard call to check for call compatibility.
1227: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1222: BEGIN
1223: -- Standard Start of API savepoint
1224: SAVEPOINT RATE_SELECT_LEAD_PVT;
1225:
1226: -- Standard call to check for call compatibility.
1227: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1228: p_api_version_number,
1229: l_api_name,
1230: G_PKG_NAME)
2481: --
2482: -- END of API body
2483: --
2484:
2485: -- Standard check for p_commit
2486: IF FND_API.to_Boolean( p_commit )
2487: THEN
2488: COMMIT WORK;
2489: END IF;
2494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2495: 'PVT: ' || l_api_name || ' End');
2496: END IF;
2497:
2498: -- Standard call to get message count and IF count is 1, get message info.
2499: FND_MSG_PUB.Count_And_Get
2500: ( p_count => x_msg_count,
2501: p_data => x_msg_data );
2502:
2593: FROM as_statuses_b
2594: WHERE status_code = c_status_code
2595: AND lead_flag = 'Y';
2596: BEGIN
2597: -- Standard Start of API savepoint
2598: SAVEPOINT LEAD_PROCESS_AFTER_CREATE_PVT;
2599:
2600: -- Standard call to check for call compatibility.
2601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2596: BEGIN
2597: -- Standard Start of API savepoint
2598: SAVEPOINT LEAD_PROCESS_AFTER_CREATE_PVT;
2599:
2600: -- Standard call to check for call compatibility.
2601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2602: p_api_version_number,
2603: l_api_name,
2604: G_PKG_NAME)
2937: --
2938: -- END of API body
2939: --
2940:
2941: -- Standard check for p_commit
2942: IF FND_API.to_Boolean( p_commit )
2943: THEN
2944: COMMIT WORK;
2945: END IF;
2949: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2950: 'PVT: ' || l_api_name || ' End');
2951: END IF;
2952:
2953: -- Standard call to get message count and IF count is 1, get message info.
2954: IF x_return_status = 'W'
2955: THEN
2956: FND_MSG_PUB.Count_And_Get
2957: (
3098: WHERE sales_lead_id = c_sales_lead_id
3099: ORDER BY log_id DESC;
3100:
3101: BEGIN
3102: -- Standard Start of API savepoint
3103: SAVEPOINT LEAD_PROCESS_AFTER_UPDATE_PVT;
3104:
3105: -- Standard call to check for call compatibility.
3106: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3101: BEGIN
3102: -- Standard Start of API savepoint
3103: SAVEPOINT LEAD_PROCESS_AFTER_UPDATE_PVT;
3104:
3105: -- Standard call to check for call compatibility.
3106: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3107: p_api_version_number,
3108: l_api_name,
3109: G_PKG_NAME)
3574: --
3575: -- END of API body
3576: --
3577:
3578: -- Standard check for p_commit
3579: IF FND_API.to_Boolean( p_commit )
3580: THEN
3581: COMMIT WORK;
3582: END IF;
3586: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3587: 'PVT: ' || l_api_name || ' End');
3588: END IF;
3589:
3590: -- Standard call to get message count and IF count is 1, get message info.
3591: IF x_return_status = 'W'
3592: THEN
3593: FND_MSG_PUB.Count_And_Get
3594: (