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)
200: THEN
197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
200: THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203:
204: -- Initialize message list IF p_init_msg_list is set to TRUE.
205: IF FND_API.to_Boolean( p_init_msg_list )
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203:
204: -- Initialize message list IF p_init_msg_list is set to TRUE.
205: IF FND_API.to_Boolean( p_init_msg_list )
206: THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209:
213: 'PVT:' || l_api_name || ' Start');
214: END IF;
215:
216: -- Initialize API return status to SUCCESS
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: --
220: -- Api body
221: --
235: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
236: p_token1 => 'PROFILE',
237: p_token1_value => 'USER_ID');
238: END IF;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242: IF (p_validation_level = fnd_api.g_valid_level_full)
243: THEN
238: END IF;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242: IF (p_validation_level = fnd_api.g_valid_level_full)
243: THEN
244: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
245: p_api_version_number => 2.0
246: ,p_init_msg_list => p_init_msg_list
250: ,x_msg_count => x_msg_count
251: ,x_msg_data => x_msg_data
252: ,x_sales_member_rec => l_identity_sales_member_rec);
253:
254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;
258:
251: ,x_msg_data => x_msg_data
252: ,x_sales_member_rec => l_identity_sales_member_rec);
253:
254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;
258:
259: OPEN C_Get_Lead_Info(p_Sales_Lead_Id);
292: -- ckapoor Disqualification project - merged procedure for qual/rating/channel sel.
293:
294: --Qualify_Lead(
295: -- P_Api_Version_Number => 2.0,
296: -- P_Init_Msg_List => FND_API.G_FALSE,
297: -- P_Commit => FND_API.G_FALSE,
298: -- P_Validation_Level => P_Validation_Level,
299: -- P_Admin_Group_Id => P_Admin_Group_Id,
300: -- P_identity_salesforce_id => P_identity_salesforce_id,
293:
294: --Qualify_Lead(
295: -- P_Api_Version_Number => 2.0,
296: -- P_Init_Msg_List => FND_API.G_FALSE,
297: -- P_Commit => FND_API.G_FALSE,
298: -- P_Validation_Level => P_Validation_Level,
299: -- P_Admin_Group_Id => P_Admin_Group_Id,
300: -- P_identity_salesforce_id => P_identity_salesforce_id,
301: -- P_Sales_Lead_id => P_Sales_Lead_id,
306: --X_Msg_Data => x_msg_data); */
307:
308: Rate_Select_Lead(
309: P_Api_Version_Number => 2.0,
310: P_Init_Msg_List => FND_API.G_FALSE,
311: P_Commit => FND_API.G_FALSE,
312: P_Validation_Level => P_Validation_Level,
313: P_Admin_Group_Id => P_Admin_Group_Id,
314: P_identity_salesforce_id => P_identity_salesforce_id,
307:
308: Rate_Select_Lead(
309: P_Api_Version_Number => 2.0,
310: P_Init_Msg_List => FND_API.G_FALSE,
311: P_Commit => FND_API.G_FALSE,
312: P_Validation_Level => P_Validation_Level,
313: P_Admin_Group_Id => P_Admin_Group_Id,
314: P_identity_salesforce_id => P_identity_salesforce_id,
315: P_Sales_Lead_id => P_Sales_Lead_id,
324: X_Msg_Data => x_msg_data);
325:
326:
327:
328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:
332: IF (AS_DEBUG_LOW_ON) THEN
325:
326:
327:
328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:
332: IF (AS_DEBUG_LOW_ON) THEN
333: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
373: END IF;
374: /*
375: -- check manually no rank is passed.
376: IF l_sales_lead_rec.lead_rank_id IS NULL OR
377: l_sales_lead_rec.lead_rank_id = FND_API.G_MISS_NUM
378: THEN
379: IF (AS_DEBUG_LOW_ON) THEN
380: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
381: 'Chinar giving default' || FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS'));
421: ELSIF -- i.e if lead is qualified already, u want to go thru rating engine
422: -- ckapoor - changed IF TO ELSIF
423:
424: l_sales_lead_rec.lead_rank_id IS NULL OR
425: l_sales_lead_rec.lead_rank_id = FND_API.G_MISS_NUM
426: THEN
427: -- new rating engine
428: Rate_Select_Lead(
429: P_Api_Version_Number => 2.0,
426: THEN
427: -- new rating engine
428: Rate_Select_Lead(
429: P_Api_Version_Number => 2.0,
430: P_Init_Msg_List => FND_API.G_FALSE,
431: P_Commit => FND_API.G_FALSE,
432: P_Validation_Level => P_Validation_Level,
433: P_Admin_Group_Id => P_Admin_Group_Id,
434: P_identity_salesforce_id => P_identity_salesforce_id,
427: -- new rating engine
428: Rate_Select_Lead(
429: P_Api_Version_Number => 2.0,
430: P_Init_Msg_List => FND_API.G_FALSE,
431: P_Commit => FND_API.G_FALSE,
432: P_Validation_Level => P_Validation_Level,
433: P_Admin_Group_Id => P_Admin_Group_Id,
434: P_identity_salesforce_id => P_identity_salesforce_id,
435: P_Sales_Lead_id => P_Sales_Lead_id,
441: X_Return_Status => x_return_status,
442: X_Msg_Count => x_msg_count,
443: X_Msg_Data => x_msg_data);
444:
445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448: IF (AS_DEBUG_LOW_ON) THEN
449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
442: X_Msg_Count => x_msg_count,
443: X_Msg_Data => x_msg_data);
444:
445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448: IF (AS_DEBUG_LOW_ON) THEN
449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
450: 'a_value=' || l_action_value);
466: -- ckapoor : since the return has been removed earlier, the code will
467: -- fall through and we will run channel selection engine for all leads
468:
469: IF(l_sales_lead_rec.channel_code IS NULL OR
470: l_sales_lead_rec.channel_code = FND_API.G_MISS_CHAR
471: -- ckapoor : making change for solin : We should make it same as rating.
472: -- Do not have special handling for channel in 11.5.10
473: --OR
474: --l_sales_lead_rec.channel_code = 'OTHER' OR
478: THEN
479: -- new channel selection engine
480: Rate_Select_Lead(
481: P_Api_Version_Number => 2.0,
482: P_Init_Msg_List => FND_API.G_FALSE,
483: P_Commit => FND_API.G_FALSE,
484: P_Validation_Level => P_Validation_Level,
485: P_Admin_Group_Id => P_Admin_Group_Id,
486: P_identity_salesforce_id => P_identity_salesforce_id,
479: -- new channel selection engine
480: Rate_Select_Lead(
481: P_Api_Version_Number => 2.0,
482: P_Init_Msg_List => FND_API.G_FALSE,
483: P_Commit => FND_API.G_FALSE,
484: P_Validation_Level => P_Validation_Level,
485: P_Admin_Group_Id => P_Admin_Group_Id,
486: P_identity_salesforce_id => P_identity_salesforce_id,
487: P_Sales_Lead_id => P_Sales_Lead_id,
493: X_Return_Status => x_return_status,
494: X_Msg_Count => x_msg_count,
495: X_Msg_Data => x_msg_data);
496:
497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
498: RAISE FND_API.G_EXC_ERROR;
499: END IF;
500: IF (AS_DEBUG_LOW_ON) THEN
501: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
494: X_Msg_Count => x_msg_count,
495: X_Msg_Data => x_msg_data);
496:
497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
498: RAISE FND_API.G_EXC_ERROR;
499: END IF;
500: IF (AS_DEBUG_LOW_ON) THEN
501: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
502: 'a_value=' || l_sales_lead_rec.channel_code);
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;
544:
556: EXCEPTION
557: -- WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
558: -- RAISE AS_SALES_LEADS_PUB.Filter_Exception;
559:
560: WHEN FND_API.G_EXC_ERROR THEN
561: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
562: P_API_NAME => L_API_NAME
563: ,P_PKG_NAME => G_PKG_NAME
564: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
566: ,X_MSG_COUNT => X_MSG_COUNT
567: ,X_MSG_DATA => X_MSG_DATA
568: ,X_RETURN_STATUS => X_RETURN_STATUS);
569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
572: P_API_NAME => L_API_NAME
573: ,P_PKG_NAME => G_PKG_NAME
574: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1177: l_final_cron_rule_id NUMBER;
1178: l_sales_lead_log_id NUMBER;
1179: l_action VARCHAR2(500);
1180: l_action_value VARCHAR2(15);
1181: l_fail_rule_selection_flag VARCHAR2(1) := FND_API.G_FALSE;
1182:
1183: l_cursor NUMBER;
1184: l_rows_inserted NUMBER;
1185:
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)
1231: THEN
1228: p_api_version_number,
1229: l_api_name,
1230: G_PKG_NAME)
1231: THEN
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234:
1235: -- Initialize message list IF p_init_msg_list is set to TRUE.
1236: IF FND_API.to_Boolean( p_init_msg_list )
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234:
1235: -- Initialize message list IF p_init_msg_list is set to TRUE.
1236: IF FND_API.to_Boolean( p_init_msg_list )
1237: THEN
1238: FND_MSG_PUB.initialize;
1239: END IF;
1240:
1244: 'PVT:' || l_api_name || ' Start');
1245: END IF;
1246:
1247: -- Initialize API return status to SUCCESS
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;
1249:
1250: --
1251: -- Api body
1252: --
1264: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1265: p_token1 => 'PROFILE',
1266: p_token1_value => 'USER_ID');
1267: END IF;
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270:
1271: IF (p_validation_level = fnd_api.g_valid_level_full)
1272: THEN
1267: END IF;
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270:
1271: IF (p_validation_level = fnd_api.g_valid_level_full)
1272: THEN
1273: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1274: p_api_version_number => 2.0
1275: ,p_init_msg_list => p_init_msg_list
1279: ,x_msg_count => x_msg_count
1280: ,x_msg_data => x_msg_data
1281: ,x_sales_member_rec => l_identity_sales_member_rec);
1282:
1283: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: END IF;
1286: END IF;
1287:
1280: ,x_msg_data => x_msg_data
1281: ,x_sales_member_rec => l_identity_sales_member_rec);
1282:
1283: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: END IF;
1286: END IF;
1287:
1288: -- Update latest_flag before rating/channel selection engine starts.
1450: x_return_status => x_return_status,
1451: x_msg_count => x_msg_count,
1452: x_msg_data => x_msg_data);
1453:
1454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1455: RAISE FND_API.G_EXC_ERROR;
1456: END IF;
1457:
1458: IF (p_process_type = G_LEAD_RATING)
1451: x_msg_count => x_msg_count,
1452: x_msg_data => x_msg_data);
1453:
1454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1455: RAISE FND_API.G_EXC_ERROR;
1456: END IF;
1457:
1458: IF (p_process_type = G_LEAD_RATING)
1459: THEN
1514: 'cri_rule_id=' ||
1515: l_criterion_rule_id_tbl(l_criterion_rule_index));
1516: END IF;
1517:
1518: l_prev_attribute_id := FND_API.G_MISS_NUM;
1519: l_prev_selection_criteria_id := FND_API.G_MISS_NUM;
1520: l_rule_attr_value := l_delimiter;
1521: l_rule_attr_to_value := l_delimiter;
1522: l_match_attribute_flag := TRUE;
1515: l_criterion_rule_id_tbl(l_criterion_rule_index));
1516: END IF;
1517:
1518: l_prev_attribute_id := FND_API.G_MISS_NUM;
1519: l_prev_selection_criteria_id := FND_API.G_MISS_NUM;
1520: l_rule_attr_value := l_delimiter;
1521: l_rule_attr_to_value := l_delimiter;
1522: l_match_attribute_flag := TRUE;
1523: l_criterion_attribute_exist := FALSE;
1543: END IF;
1544: IF l_selection_criteria_id <>
1545: l_prev_selection_criteria_id
1546: THEN
1547: IF l_prev_attribute_id <> FND_API.G_MISS_NUM
1548: THEN
1549: IF (AS_DEBUG_LOW_ON) THEN
1550: AS_UTILITY_PVT.Debug_Message(
1551: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1708: l_action_value_tbl(l_criterion_rule_index)
1709: ,p_PROCESS_TYPE => p_process_type
1710: --,p_WINNING_RULE_FLAG => 'Y'
1711: ,p_WINNING_RULE_FLAG => 'N'
1712: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1713: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1709: ,p_PROCESS_TYPE => p_process_type
1710: --,p_WINNING_RULE_FLAG => 'Y'
1711: ,p_WINNING_RULE_FLAG => 'N'
1712: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1713: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1710: --,p_WINNING_RULE_FLAG => 'Y'
1711: ,p_WINNING_RULE_FLAG => 'N'
1712: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1713: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1711: ,p_WINNING_RULE_FLAG => 'N'
1712: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1713: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1712: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1713: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1713: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1714: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1715: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1716: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1717: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1718: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1726: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1719: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1726: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1727: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1720: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1726: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1727: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1728: ,p_PROCESS_STATUS => G_PASS_RULE
1721: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1726: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1727: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1728: ,p_PROCESS_STATUS => G_PASS_RULE
1729: ,p_ENTITY_DETAIL => l_status_code);
1722: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1726: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1727: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1728: ,p_PROCESS_STATUS => G_PASS_RULE
1729: ,p_ENTITY_DETAIL => l_status_code);
1730:
1723: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1724: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1725: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1726: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1727: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1728: ,p_PROCESS_STATUS => G_PASS_RULE
1729: ,p_ENTITY_DETAIL => l_status_code);
1730:
1731: EXIT; -- exit criterion rule
1736: 'rule not match');
1737: END IF;
1738: l_entity_rule_applied_id := NULL;
1739: l_matched_rule_index_tbl(l_rule_index) :=
1740: FND_API.G_MISS_NUM;
1741: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(
1742: px_ENTITY_RULE_APPLIED_ID =>
1743: l_entity_rule_applied_id
1744: ,p_LAST_UPDATE_DATE => SYSDATE
1762: ,p_ACTION_VALUE =>
1763: l_action_value_tbl(l_criterion_rule_index)
1764: ,p_PROCESS_TYPE => p_process_type
1765: ,p_WINNING_RULE_FLAG => NULL
1766: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1767: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1763: l_action_value_tbl(l_criterion_rule_index)
1764: ,p_PROCESS_TYPE => p_process_type
1765: ,p_WINNING_RULE_FLAG => NULL
1766: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1767: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1764: ,p_PROCESS_TYPE => p_process_type
1765: ,p_WINNING_RULE_FLAG => NULL
1766: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1767: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1765: ,p_WINNING_RULE_FLAG => NULL
1766: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1767: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1766: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1767: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1767: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1768: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1769: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1770: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1771: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1772: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1780: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1773: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1780: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1781: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1774: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1780: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1781: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1782: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1775: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1780: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1781: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1782: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1783: ,p_ENTITY_DETAIL => l_status_code);
1776: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1780: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1781: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1782: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1783: ,p_ENTITY_DETAIL => l_status_code);
1784: END IF;
1777: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1778: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1779: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1780: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1781: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1782: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1783: ,p_ENTITY_DETAIL => l_status_code);
1784: END IF;
1785: l_criterion_rule_index := l_criterion_rule_index + 1;
1814: ,p_LATEST_FLAG => 'Y'
1815: ,p_ACTION_VALUE => NULL
1816: ,p_PROCESS_TYPE => p_process_type
1817: ,p_WINNING_RULE_FLAG => NULL
1818: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1819: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1815: ,p_ACTION_VALUE => NULL
1816: ,p_PROCESS_TYPE => p_process_type
1817: ,p_WINNING_RULE_FLAG => NULL
1818: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1819: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1816: ,p_PROCESS_TYPE => p_process_type
1817: ,p_WINNING_RULE_FLAG => NULL
1818: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1819: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1817: ,p_WINNING_RULE_FLAG => NULL
1818: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1819: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1818: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
1819: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1819: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1820: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1821: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1822: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1823: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1824: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1832: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1825: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1832: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1833: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1826: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1832: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1833: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1834: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1827: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1832: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1833: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1834: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1835: ,p_ENTITY_DETAIL => l_status_code);
1828: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1832: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1833: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1834: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1835: ,p_ENTITY_DETAIL => l_status_code);
1836: END IF;
1829: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
1830: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
1831: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
1832: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
1833: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
1834: ,p_PROCESS_STATUS => G_FAIL_CRITERIA
1835: ,p_ENTITY_DETAIL => l_status_code);
1836: END IF;
1837: l_rank := l_rank_tbl(l_rule_index);
2028: x_msg_count => x_msg_count,
2029: x_msg_data => x_msg_data
2030: );
2031:
2032: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035:
2036: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2029: x_msg_data => x_msg_data
2030: );
2031:
2032: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035:
2036: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2037: 'PV 510:: ' || l_entity_attr_value_tbl(l_enty_select_criteria_val.attribute_id).attribute_value);
2053: ,p_LAST_UPDATED_BY => fnd_global.user_id
2054: ,p_CREATION_DATE => SYSDATE
2055: ,p_CREATED_BY => fnd_global.user_id
2056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
2057: ,p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2058: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2059: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2060: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2061: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2302: ,p_LATEST_FLAG => 'Y'
2303: ,p_ACTION_VALUE => x_action_value
2304: ,p_PROCESS_TYPE => p_process_type
2305: ,p_WINNING_RULE_FLAG => NULL
2306: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
2307: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2303: ,p_ACTION_VALUE => x_action_value
2304: ,p_PROCESS_TYPE => p_process_type
2305: ,p_WINNING_RULE_FLAG => NULL
2306: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
2307: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2304: ,p_PROCESS_TYPE => p_process_type
2305: ,p_WINNING_RULE_FLAG => NULL
2306: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
2307: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2305: ,p_WINNING_RULE_FLAG => NULL
2306: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
2307: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2306: ,p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR
2307: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2307: ,p_ATTRIBUTE1 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2308: ,p_ATTRIBUTE2 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2309: ,p_ATTRIBUTE3 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2310: ,p_ATTRIBUTE4 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2311: ,p_ATTRIBUTE5 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2312: ,p_ATTRIBUTE6 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2320: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
2313: ,p_ATTRIBUTE7 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2320: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
2321: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
2314: ,p_ATTRIBUTE8 => FND_API.G_MISS_CHAR
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2320: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
2321: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
2322: ,p_PROCESS_STATUS => G_DEFAULT
2315: ,p_ATTRIBUTE9 => FND_API.G_MISS_CHAR
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2320: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
2321: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
2322: ,p_PROCESS_STATUS => G_DEFAULT
2323: ,p_ENTITY_DETAIL => l_status_code);
2316: ,p_ATTRIBUTE10 => FND_API.G_MISS_CHAR
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2320: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
2321: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
2322: ,p_PROCESS_STATUS => G_DEFAULT
2323: ,p_ENTITY_DETAIL => l_status_code);
2324:
2317: ,p_ATTRIBUTE11 => FND_API.G_MISS_CHAR
2318: ,p_ATTRIBUTE12 => FND_API.G_MISS_CHAR
2319: ,p_ATTRIBUTE13 => FND_API.G_MISS_CHAR
2320: ,p_ATTRIBUTE14 => FND_API.G_MISS_CHAR
2321: ,p_ATTRIBUTE15 => FND_API.G_MISS_CHAR
2322: ,p_PROCESS_STATUS => G_DEFAULT
2323: ,p_ENTITY_DETAIL => l_status_code);
2324:
2325:
2353: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
2354: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
2355: p_LAST_UPDATE_DATE => SYSDATE,
2356: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2357: p_CREATION_DATE => FND_API.G_MISS_DATE,
2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2354: p_SALES_LEAD_ID => p_SALES_LEAD_ID,
2355: p_LAST_UPDATE_DATE => SYSDATE,
2356: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2357: p_CREATION_DATE => FND_API.G_MISS_DATE,
2358: p_CREATED_BY => FND_API.G_MISS_NUM,
2359: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2360: p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2361: p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2362: p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2363: p_PROGRAM_UPDATE_DATE => SYSDATE,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2364: p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2365: p_STATUS_CODE => FND_API.G_MISS_CHAR,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2366: p_CUSTOMER_ID => FND_API.G_MISS_NUM,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2367: p_ADDRESS_ID => FND_API.G_MISS_NUM,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2368: p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2369: p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2370: p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2371: p_CONTACT_ROLE_CODE => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2372: p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2373: p_BUDGET_AMOUNT => FND_API.G_MISS_NUM,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2374: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2375: p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2376: p_CLOSE_REASON => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2377: p_LEAD_RANK_ID => FND_API.G_MISS_NUM,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2378: p_LEAD_RANK_CODE => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2379: p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2380: p_DESCRIPTION => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2381: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2382: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2383: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2384: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2385: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2386: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2387: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2388: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2389: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2390: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2391: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2392: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2393: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2394: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2395: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2396: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2397: p_ASSIGN_TO_PERSON_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2398: p_ASSIGN_TO_SALESFORCE_ID => FND_API.G_MISS_NUM,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2399: p_ASSIGN_SALES_GROUP_ID => FND_API.G_MISS_NUM,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2400: p_ASSIGN_DATE => FND_API.G_MISS_DATE,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2401: p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2402: p_ACCEPT_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2403: p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2404: p_TOTAL_SCORE => FND_API.G_MISS_NUM,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2405: p_SCORECARD_ID => FND_API.G_MISS_NUM,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2406: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2407: p_URGENT_FLAG => FND_API.G_MISS_CHAR,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2408: p_IMPORT_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2409: p_REJECT_REASON_CODE => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2410: p_DELETED_FLAG => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2411: p_OFFER_ID => FND_API.G_MISS_NUM,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2412: p_QUALIFIED_FLAG => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2413: p_ORIG_SYSTEM_CODE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2414: p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2415: p_INC_PARTNER_RESOURCE_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2416: p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2417: p_PRM_PRJ_LEAD_IN_PLACE_FLAG => FND_API.G_MISS_CHAR,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2418: p_PRM_SALES_LEAD_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2419: p_PRM_IND_CLASSIFICATION_CODE => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2420: p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2421: p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2422: p_PRIMARY_CONTACT_PARTY_ID => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2423: p_PRIMARY_CNT_PERSON_PARTY_ID => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2424: p_PRIMARY_CONTACT_PHONE_ID => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2425: p_REFERRED_BY => FND_API.G_MISS_NUM,
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2426: p_REFERRAL_TYPE => FND_API.G_MISS_CHAR,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2427: p_REFERRAL_STATUS => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2428: p_REF_DECLINE_REASON => FND_API.G_MISS_CHAR,
2429: p_REF_COMM_LTR_STATUS => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2430: p_REF_ORDER_NUMBER => FND_API.G_MISS_NUM,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2431: p_REF_ORDER_AMT => FND_API.G_MISS_NUM,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2432: p_REF_COMM_AMT => FND_API.G_MISS_NUM,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2433: -- bug No.2341515, 2368075
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2441: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
2434: p_LEAD_DATE => FND_API.G_MISS_DATE,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2441: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
2442: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
2435: p_SOURCE_SYSTEM => FND_API.G_MISS_CHAR,
2436: p_COUNTRY => FND_API.G_MISS_CHAR,
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2441: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
2442: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
2443: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM
2437: p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2441: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
2442: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
2443: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM
2444:
2445: -- 11.5.10 new columns ckapoor
2438: p_EXPIRATION_DATE => FND_API.G_MISS_DATE,
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2441: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
2442: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
2443: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM
2444:
2445: -- 11.5.10 new columns ckapoor
2446:
2439: p_LEAD_RANK_IND => FND_API.G_MISS_CHAR,
2440: p_LEAD_ENGINE_RUN_DATE => SYSDATE,
2441: p_CURRENT_REROUTES => FND_API.G_MISS_NUM,
2442: p_STATUS_OPEN_FLAG => FND_API.G_MISS_CHAR,
2443: p_LEAD_RANK_SCORE => FND_API.G_MISS_NUM
2444:
2445: -- 11.5.10 new columns ckapoor
2446:
2447:
2444:
2445: -- 11.5.10 new columns ckapoor
2446:
2447:
2448: , p_MARKETING_SCORE => FND_API.G_MISS_NUM
2449: , p_INTERACTION_SCORE => FND_API.G_MISS_NUM
2450: , p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR
2451: , p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR
2452: , p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM
2445: -- 11.5.10 new columns ckapoor
2446:
2447:
2448: , p_MARKETING_SCORE => FND_API.G_MISS_NUM
2449: , p_INTERACTION_SCORE => FND_API.G_MISS_NUM
2450: , p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR
2451: , p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR
2452: , p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM
2453: , p_SALES_STAGE_ID => FND_API.G_MISS_NUM
2446:
2447:
2448: , p_MARKETING_SCORE => FND_API.G_MISS_NUM
2449: , p_INTERACTION_SCORE => FND_API.G_MISS_NUM
2450: , p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR
2451: , p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR
2452: , p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM
2453: , p_SALES_STAGE_ID => FND_API.G_MISS_NUM
2454:
2447:
2448: , p_MARKETING_SCORE => FND_API.G_MISS_NUM
2449: , p_INTERACTION_SCORE => FND_API.G_MISS_NUM
2450: , p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR
2451: , p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR
2452: , p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM
2453: , p_SALES_STAGE_ID => FND_API.G_MISS_NUM
2454:
2455:
2448: , p_MARKETING_SCORE => FND_API.G_MISS_NUM
2449: , p_INTERACTION_SCORE => FND_API.G_MISS_NUM
2450: , p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR
2451: , p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR
2452: , p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM
2453: , p_SALES_STAGE_ID => FND_API.G_MISS_NUM
2454:
2455:
2456:
2449: , p_INTERACTION_SCORE => FND_API.G_MISS_NUM
2450: , p_SOURCE_PRIMARY_REFERENCE => FND_API.G_MISS_CHAR
2451: , p_SOURCE_SECONDARY_REFERENCE => FND_API.G_MISS_CHAR
2452: , p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM
2453: , p_SALES_STAGE_ID => FND_API.G_MISS_NUM
2454:
2455:
2456:
2457: );
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;
2490:
2505: -- WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
2506: -- RAISE AS_SALES_LEADS_PUB.Filter_Exception;
2507: -- --RAISE_APPLICATION_ERROR(-20100, 'Filter Exception'));
2508:
2509: WHEN FND_API.G_EXC_ERROR THEN
2510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2511: P_API_NAME => L_API_NAME
2512: ,P_PKG_NAME => G_PKG_NAME
2513: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2515: ,X_MSG_COUNT => X_MSG_COUNT
2516: ,X_MSG_DATA => X_MSG_DATA
2517: ,X_RETURN_STATUS => X_RETURN_STATUS);
2518:
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2521: P_API_NAME => L_API_NAME
2522: ,P_PKG_NAME => G_PKG_NAME
2523: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2614: -- Standard Start of API savepoint
2615: SAVEPOINT LEAD_PROCESS_AFTER_CREATE_PVT;
2616:
2617: -- Standard call to check for call compatibility.
2618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2619: p_api_version_number,
2620: l_api_name,
2621: G_PKG_NAME)
2622: THEN
2619: p_api_version_number,
2620: l_api_name,
2621: G_PKG_NAME)
2622: THEN
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624: END IF;
2625:
2626: -- Initialize message list IF p_init_msg_list is set to TRUE.
2627: IF FND_API.to_Boolean( p_init_msg_list )
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624: END IF;
2625:
2626: -- Initialize message list IF p_init_msg_list is set to TRUE.
2627: IF FND_API.to_Boolean( p_init_msg_list )
2628: THEN
2629: FND_MSG_PUB.initialize;
2630: END IF;
2631:
2635: 'PVT:' || l_api_name || ' Start');
2636: END IF;
2637:
2638: -- Initialize API return status to SUCCESS
2639: x_return_status := FND_API.G_RET_STS_SUCCESS;
2640:
2641: --
2642: -- Api body
2643: --
2654: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2655: p_token1 => 'PROFILE',
2656: p_token1_value => 'USER_ID');
2657: END IF;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660:
2661: IF (p_validation_level = fnd_api.g_valid_level_full)
2662: THEN
2657: END IF;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660:
2661: IF (p_validation_level = fnd_api.g_valid_level_full)
2662: THEN
2663: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
2664: p_api_version_number => 2.0
2665: ,p_init_msg_list => p_init_msg_list
2669: ,x_msg_count => x_msg_count
2670: ,x_msg_data => x_msg_data
2671: ,x_sales_member_rec => l_identity_sales_member_rec);
2672:
2673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2674: RAISE FND_API.G_EXC_ERROR;
2675: END IF;
2676: END IF;
2677:
2670: ,x_msg_data => x_msg_data
2671: ,x_sales_member_rec => l_identity_sales_member_rec);
2672:
2673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2674: RAISE FND_API.G_EXC_ERROR;
2675: END IF;
2676: END IF;
2677:
2678: Run_Lead_Engines(
2676: END IF;
2677:
2678: Run_Lead_Engines(
2679: P_Api_Version_Number => 2.0,
2680: P_Init_Msg_List => FND_API.G_FALSE,
2681: P_Commit => FND_API.G_FALSE,
2682: P_Validation_Level => P_Validation_Level,
2683: P_Admin_Group_Id => P_Admin_Group_Id,
2684: P_identity_salesforce_id => P_identity_salesforce_id,
2677:
2678: Run_Lead_Engines(
2679: P_Api_Version_Number => 2.0,
2680: P_Init_Msg_List => FND_API.G_FALSE,
2681: P_Commit => FND_API.G_FALSE,
2682: P_Validation_Level => P_Validation_Level,
2683: P_Admin_Group_Id => P_Admin_Group_Id,
2684: P_identity_salesforce_id => P_identity_salesforce_id,
2685: P_Salesgroup_id => P_Salesgroup_id,
2691: X_Return_Status => x_return_status,
2692: X_Msg_Count => x_msg_count,
2693: X_Msg_Data => x_msg_data);
2694:
2695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698:
2699: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
2692: X_Msg_Count => x_msg_count,
2693: X_Msg_Data => x_msg_data);
2694:
2695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698:
2699: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
2700: FETCH C_Get_Lead_Info INTO l_customer_id, l_address_id, l_referral_type,
2705: THEN
2706: -- not incubation lead
2707: As_Sales_Lead_Assign_PVT.Build_Lead_Sales_Team(
2708: P_Api_Version_Number => 2.0,
2709: P_Init_Msg_List => FND_API.G_FALSE,
2710: P_Commit => FND_API.G_FALSE,
2711: P_Validation_Level => P_Validation_Level,
2712: P_Admin_Group_Id => P_Admin_Group_Id,
2713: P_identity_salesforce_id => P_identity_salesforce_id,
2706: -- not incubation lead
2707: As_Sales_Lead_Assign_PVT.Build_Lead_Sales_Team(
2708: P_Api_Version_Number => 2.0,
2709: P_Init_Msg_List => FND_API.G_FALSE,
2710: P_Commit => FND_API.G_FALSE,
2711: P_Validation_Level => P_Validation_Level,
2712: P_Admin_Group_Id => P_Admin_Group_Id,
2713: P_identity_salesforce_id => P_identity_salesforce_id,
2714: P_Salesgroup_id => P_Salesgroup_id,
2717: X_Return_Status => x_return_status,
2718: X_Msg_Count => x_msg_count,
2719: X_Msg_Data => x_msg_data);
2720:
2721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:
2725: -- below code added for bug 7654339
2718: X_Msg_Count => x_msg_count,
2719: X_Msg_Data => x_msg_data);
2720:
2721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:
2725: -- below code added for bug 7654339
2726: l_freeze_flag := 'N';
2752: As_Sales_Lead_Assign_PVT.Find_Lead_Owner(
2753: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
2754: l_return_status, x_msg_count, x_msg_data);
2755:
2756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2757: RAISE fnd_api.g_exc_error;
2758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2759: RAISE fnd_api.g_exc_unexpected_error;
2760: END IF;
2753: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
2754: l_return_status, x_msg_count, x_msg_data);
2755:
2756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2757: RAISE fnd_api.g_exc_error;
2758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2759: RAISE fnd_api.g_exc_unexpected_error;
2760: END IF;
2761: --code added/modified for bug12766399
2754: l_return_status, x_msg_count, x_msg_data);
2755:
2756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2757: RAISE fnd_api.g_exc_error;
2758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2759: RAISE fnd_api.g_exc_unexpected_error;
2760: END IF;
2761: --code added/modified for bug12766399
2762: ELSIF NVL(l_freeze_flag,'N') = 'N' THEN
2755:
2756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2757: RAISE fnd_api.g_exc_error;
2758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2759: RAISE fnd_api.g_exc_unexpected_error;
2760: END IF;
2761: --code added/modified for bug12766399
2762: ELSIF NVL(l_freeze_flag,'N') = 'N' THEN
2763: As_Sales_Lead_Assign_PVT.Set_Default_Lead_Owner(
2763: As_Sales_Lead_Assign_PVT.Set_Default_Lead_Owner(
2764: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
2765: l_return_status, x_msg_count, x_msg_data);
2766:
2767: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2768: RAISE fnd_api.g_exc_error;
2769: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2770: RAISE fnd_api.g_exc_unexpected_error;
2771: END IF;
2764: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
2765: l_return_status, x_msg_count, x_msg_data);
2766:
2767: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2768: RAISE fnd_api.g_exc_error;
2769: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2770: RAISE fnd_api.g_exc_unexpected_error;
2771: END IF;
2772:
2765: l_return_status, x_msg_count, x_msg_data);
2766:
2767: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2768: RAISE fnd_api.g_exc_error;
2769: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2770: RAISE fnd_api.g_exc_unexpected_error;
2771: END IF;
2772:
2773: ELSE
2766:
2767: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2768: RAISE fnd_api.g_exc_error;
2769: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2770: RAISE fnd_api.g_exc_unexpected_error;
2771: END IF;
2772:
2773: ELSE
2774: As_Sales_Lead_Assign_PVT.Process_Access_Record(
2780: IF l_assign_to_salesforce_id IS NULL
2781: THEN
2782: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
2783: P_Api_Version_Number => 2.0,
2784: P_Init_Msg_List => FND_API.G_FALSE,
2785: P_Commit => FND_API.G_FALSE,
2786: P_Validation_Level => P_Validation_Level,
2787: P_Admin_Group_Id => P_Admin_Group_Id,
2788: P_identity_salesforce_id => P_identity_salesforce_id,
2781: THEN
2782: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
2783: P_Api_Version_Number => 2.0,
2784: P_Init_Msg_List => FND_API.G_FALSE,
2785: P_Commit => FND_API.G_FALSE,
2786: P_Validation_Level => P_Validation_Level,
2787: P_Admin_Group_Id => P_Admin_Group_Id,
2788: P_identity_salesforce_id => P_identity_salesforce_id,
2789: P_Sales_Lead_id => P_Sales_Lead_id,
2790: X_Return_Status => x_return_status,
2791: X_Msg_Count => x_msg_count,
2792: X_Msg_Data => x_msg_data);
2793:
2794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2795: RAISE FND_API.G_EXC_ERROR;
2796: END IF;
2797: END IF;
2798:
2791: X_Msg_Count => x_msg_count,
2792: X_Msg_Data => x_msg_data);
2793:
2794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2795: RAISE FND_API.G_EXC_ERROR;
2796: END IF;
2797: END IF;
2798:
2799: OPEN C_Get_Person(P_identity_salesforce_id);
2819: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
2820:
2821: As_Access_PVT.Create_SalesTeam( -- for creator
2822: P_Api_Version_Number => 2.0,
2823: P_Init_Msg_List => FND_API.G_FALSE,
2824: P_Commit => FND_API.G_FALSE,
2825: P_Validation_Level => P_Validation_Level,
2826: P_Access_Profile_Rec => NULL,
2827: P_Check_Access_Flag => 'N',
2820:
2821: As_Access_PVT.Create_SalesTeam( -- for creator
2822: P_Api_Version_Number => 2.0,
2823: P_Init_Msg_List => FND_API.G_FALSE,
2824: P_Commit => FND_API.G_FALSE,
2825: P_Validation_Level => P_Validation_Level,
2826: P_Access_Profile_Rec => NULL,
2827: P_Check_Access_Flag => 'N',
2828: P_Admin_Flag => P_Admin_Flag,
2833: X_Msg_Count => x_msg_count,
2834: X_Msg_Data => x_msg_data,
2835: X_Access_Id => l_access_id);
2836:
2837: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: END IF;
2841:
2834: X_Msg_Data => x_msg_data,
2835: X_Access_Id => l_access_id);
2836:
2837: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: END IF;
2841:
2842: IF (AS_DEBUG_LOW_ON) THEN
2848: FND_PROFILE.Value('AS_AUTO_CONVERT_LEAD_OPP') = 'Y'
2849: THEN
2850: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
2851: P_Api_Version_Number => 2.0,
2852: P_Init_Msg_List => FND_API.G_FALSE,
2853: P_Commit => FND_API.G_FALSE,
2854: P_Validation_Level => P_Validation_Level,
2855: P_Check_Access_Flag => P_Check_Access_Flag,
2856: P_Admin_Flag => P_Admin_Flag,
2849: THEN
2850: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
2851: P_Api_Version_Number => 2.0,
2852: P_Init_Msg_List => FND_API.G_FALSE,
2853: P_Commit => FND_API.G_FALSE,
2854: P_Validation_Level => P_Validation_Level,
2855: P_Check_Access_Flag => P_Check_Access_Flag,
2856: P_Admin_Flag => P_Admin_Flag,
2857: P_Admin_Group_Id => P_Admin_Group_Id,
2864: X_Msg_Count => x_msg_count,
2865: X_Msg_Data => x_msg_data,
2866: X_Opportunity_Id => l_opportunity_id);
2867:
2868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:
2872: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2865: X_Msg_Data => x_msg_data,
2866: X_Opportunity_Id => l_opportunity_id);
2867:
2868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:
2872: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2873: P_Api_Version_Number => 2.0,
2870: END IF;
2871:
2872: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2873: P_Api_Version_Number => 2.0,
2874: P_Init_Msg_List => FND_API.G_FALSE,
2875: P_Commit => FND_API.G_FALSE,
2876: P_Validation_Level => P_Validation_Level,
2877: P_Admin_Group_Id => P_Admin_Group_Id,
2878: P_identity_salesforce_id => P_identity_salesforce_id,
2871:
2872: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2873: P_Api_Version_Number => 2.0,
2874: P_Init_Msg_List => FND_API.G_FALSE,
2875: P_Commit => FND_API.G_FALSE,
2876: P_Validation_Level => P_Validation_Level,
2877: P_Admin_Group_Id => P_Admin_Group_Id,
2878: P_identity_salesforce_id => P_identity_salesforce_id,
2879: P_Salesgroup_id => P_Salesgroup_id,
2881: X_Return_Status => x_return_status,
2882: X_Msg_Count => x_msg_count,
2883: X_Msg_Data => x_msg_data);
2884:
2885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2886: RAISE FND_API.G_EXC_ERROR;
2887: END IF;
2888: END IF;
2889:
2882: X_Msg_Count => x_msg_count,
2883: X_Msg_Data => x_msg_data);
2884:
2885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2886: RAISE FND_API.G_EXC_ERROR;
2887: END IF;
2888: END IF;
2889:
2890: -- IF l_referral_type IS NOT NULL
2890: -- IF l_referral_type IS NOT NULL
2891: -- THEN
2892: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
2893: -- P_Api_Version => 2.0,
2894: -- P_Init_Msg_List => FND_API.G_FALSE,
2895: -- P_Commit => FND_API.G_FALSE,
2896: -- P_Validation_Level => P_Validation_Level,
2897: -- P_Lead_Id => p_sales_lead_id,
2898: -- P_Lead_Status => NULL,
2891: -- THEN
2892: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
2893: -- P_Api_Version => 2.0,
2894: -- P_Init_Msg_List => FND_API.G_FALSE,
2895: -- P_Commit => FND_API.G_FALSE,
2896: -- P_Validation_Level => P_Validation_Level,
2897: -- P_Lead_Id => p_sales_lead_id,
2898: -- P_Lead_Status => NULL,
2899: -- P_salesforce_id => P_identity_salesforce_id,
2901: -- X_Return_Status => x_return_status,
2902: -- X_Msg_Count => x_msg_count,
2903: -- X_Msg_Data => x_msg_data);
2904:
2905: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2906: -- RAISE FND_API.G_EXC_ERROR;
2907: -- END IF;
2908: -- END IF;
2909:
2902: -- X_Msg_Count => x_msg_count,
2903: -- X_Msg_Data => x_msg_data);
2904:
2905: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2906: -- RAISE FND_API.G_EXC_ERROR;
2907: -- END IF;
2908: -- END IF;
2909:
2910: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
2929: AND l_lead_engines_out_rec.qualified_flag = 'Y'
2930: THEN
2931: aml_monitor_wf.launch_monitor(
2932: P_Api_Version_Number => 2.0,
2933: P_Init_Msg_List => FND_API.G_FALSE,
2934: p_commit => FND_API.G_FALSE,
2935: P_Sales_Lead_Id => p_sales_lead_id,
2936: P_Changed_From_stage => 'CREATION_DATE',
2937: P_Lead_Action => 'CREATE',
2930: THEN
2931: aml_monitor_wf.launch_monitor(
2932: P_Api_Version_Number => 2.0,
2933: P_Init_Msg_List => FND_API.G_FALSE,
2934: p_commit => FND_API.G_FALSE,
2935: P_Sales_Lead_Id => p_sales_lead_id,
2936: P_Changed_From_stage => 'CREATION_DATE',
2937: P_Lead_Action => 'CREATE',
2938: -- 9/9/03 SWKHANNA -- Added for Lead Upgrade/Downgrade Functionality
2940: X_Return_Status => x_return_status,
2941: X_Msg_Count => x_msg_count,
2942: X_Msg_Data => x_msg_data);
2943:
2944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;
2947: END IF;
2948:
2941: X_Msg_Count => x_msg_count,
2942: X_Msg_Data => x_msg_data);
2943:
2944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;
2947: END IF;
2948:
2949: -- ER 3052066
2992: -- END of API body
2993: --
2994:
2995: -- Standard check for p_commit
2996: IF FND_API.to_Boolean( p_commit )
2997: THEN
2998: COMMIT WORK;
2999: END IF;
3000:
3008: IF x_return_status = 'W'
3009: THEN
3010: FND_MSG_PUB.Count_And_Get
3011: (
3012: p_encoded => FND_API.G_FALSE,
3013: p_count => x_msg_count,
3014: p_data => x_msg_data );
3015: ELSE
3016: FND_MSG_PUB.Count_And_Get
3022:
3023: -- WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
3024: -- RAISE AS_SALES_LEADS_PUB.Filter_Exception;
3025:
3026: WHEN FND_API.G_EXC_ERROR THEN
3027: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3028: P_API_NAME => L_API_NAME
3029: ,P_PKG_NAME => G_PKG_NAME
3030: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3032: ,X_MSG_COUNT => X_MSG_COUNT
3033: ,X_MSG_DATA => X_MSG_DATA
3034: ,X_RETURN_STATUS => X_RETURN_STATUS);
3035:
3036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3037: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3038: P_API_NAME => L_API_NAME
3039: ,P_PKG_NAME => G_PKG_NAME
3040: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3156: -- Standard Start of API savepoint
3157: SAVEPOINT LEAD_PROCESS_AFTER_UPDATE_PVT;
3158:
3159: -- Standard call to check for call compatibility.
3160: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3161: p_api_version_number,
3162: l_api_name,
3163: G_PKG_NAME)
3164: THEN
3161: p_api_version_number,
3162: l_api_name,
3163: G_PKG_NAME)
3164: THEN
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166: END IF;
3167:
3168: -- Initialize message list IF p_init_msg_list is set to TRUE.
3169: IF FND_API.to_Boolean( p_init_msg_list )
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166: END IF;
3167:
3168: -- Initialize message list IF p_init_msg_list is set to TRUE.
3169: IF FND_API.to_Boolean( p_init_msg_list )
3170: THEN
3171: FND_MSG_PUB.initialize;
3172: END IF;
3173:
3177: 'PVT:' || l_api_name || ' Start');
3178: END IF;
3179:
3180: -- Initialize API return status to SUCCESS
3181: x_return_status := FND_API.G_RET_STS_SUCCESS;
3182:
3183: --
3184: -- Api body
3185: --
3196: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
3197: p_token1 => 'PROFILE',
3198: p_token1_value => 'USER_ID');
3199: END IF;
3200: RAISE FND_API.G_EXC_ERROR;
3201: END IF;
3202:
3203: IF (p_validation_level = fnd_api.g_valid_level_full)
3204: THEN
3199: END IF;
3200: RAISE FND_API.G_EXC_ERROR;
3201: END IF;
3202:
3203: IF (p_validation_level = fnd_api.g_valid_level_full)
3204: THEN
3205: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
3206: p_api_version_number => 2.0
3207: ,p_init_msg_list => p_init_msg_list
3211: ,x_msg_count => x_msg_count
3212: ,x_msg_data => x_msg_data
3213: ,x_sales_member_rec => l_identity_sales_member_rec);
3214:
3215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218: END IF;
3219:
3212: ,x_msg_data => x_msg_data
3213: ,x_sales_member_rec => l_identity_sales_member_rec);
3214:
3215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218: END IF;
3219:
3220: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
3235: IF NVL(l_auto_run_lead_engines, 'N') = 'Y'
3236: THEN
3237: Run_Lead_Engines(
3238: P_Api_Version_Number => 2.0,
3239: P_Init_Msg_List => FND_API.G_FALSE,
3240: P_Commit => FND_API.G_FALSE,
3241: P_Validation_Level => P_Validation_Level,
3242: P_Admin_Group_Id => P_Admin_Group_Id,
3243: P_identity_salesforce_id => P_identity_salesforce_id,
3236: THEN
3237: Run_Lead_Engines(
3238: P_Api_Version_Number => 2.0,
3239: P_Init_Msg_List => FND_API.G_FALSE,
3240: P_Commit => FND_API.G_FALSE,
3241: P_Validation_Level => P_Validation_Level,
3242: P_Admin_Group_Id => P_Admin_Group_Id,
3243: P_identity_salesforce_id => P_identity_salesforce_id,
3244: P_Salesgroup_id => P_Salesgroup_id,
3250: X_Return_Status => x_return_status,
3251: X_Msg_Count => x_msg_count,
3252: X_Msg_Data => x_msg_data);
3253:
3254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3255: RAISE FND_API.G_EXC_ERROR;
3256: END IF;
3257:
3258: ELSE
3251: X_Msg_Count => x_msg_count,
3252: X_Msg_Data => x_msg_data);
3253:
3254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3255: RAISE FND_API.G_EXC_ERROR;
3256: END IF;
3257:
3258: ELSE
3259: OPEN c_get_indirect_channel_flag(l_lead_engines_out_rec.channel_code);
3278: THEN
3279: -- not incubation lead
3280: As_Sales_Lead_Assign_PVT.Rebuild_Lead_Sales_Team(
3281: P_Api_Version_Number => 2.0,
3282: P_Init_Msg_List => FND_API.G_FALSE,
3283: P_Commit => FND_API.G_FALSE,
3284: P_Validation_Level => P_Validation_Level,
3285: P_Admin_Group_Id => P_Admin_Group_Id,
3286: P_identity_salesforce_id => P_identity_salesforce_id,
3279: -- not incubation lead
3280: As_Sales_Lead_Assign_PVT.Rebuild_Lead_Sales_Team(
3281: P_Api_Version_Number => 2.0,
3282: P_Init_Msg_List => FND_API.G_FALSE,
3283: P_Commit => FND_API.G_FALSE,
3284: P_Validation_Level => P_Validation_Level,
3285: P_Admin_Group_Id => P_Admin_Group_Id,
3286: P_identity_salesforce_id => P_identity_salesforce_id,
3287: P_Salesgroup_id => P_Salesgroup_id,
3290: X_Return_Status => x_return_status,
3291: X_Msg_Count => x_msg_count,
3292: X_Msg_Data => x_msg_data);
3293:
3294: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3295: RAISE FND_API.G_EXC_ERROR;
3296: END IF;
3297:
3298: -- Check owner again here because Rebuild_Lead_Sales_Team may
3291: X_Msg_Count => x_msg_count,
3292: X_Msg_Data => x_msg_data);
3293:
3294: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3295: RAISE FND_API.G_EXC_ERROR;
3296: END IF;
3297:
3298: -- Check owner again here because Rebuild_Lead_Sales_Team may
3299: -- remove owner in as_accesses_all
3317: As_Sales_Lead_Assign_PVT.Find_Lead_Owner(
3318: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
3319: l_return_status, x_msg_count, x_msg_data);
3320:
3321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3322: RAISE fnd_api.g_exc_error;
3323: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3318: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
3319: l_return_status, x_msg_count, x_msg_data);
3320:
3321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3322: RAISE fnd_api.g_exc_error;
3323: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3326: l_owner_changed_flag := 'Y';
3319: l_return_status, x_msg_count, x_msg_data);
3320:
3321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3322: RAISE fnd_api.g_exc_error;
3323: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3326: l_owner_changed_flag := 'Y';
3327: ELSE
3320:
3321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3322: RAISE fnd_api.g_exc_error;
3323: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3326: l_owner_changed_flag := 'Y';
3327: ELSE
3328: As_Sales_Lead_Assign_PVT.Process_Access_Record(
3331: ELSE
3332: -- lead with incubation channel
3333: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
3334: P_Api_Version_Number => 2.0,
3335: P_Init_Msg_List => FND_API.G_FALSE,
3336: P_Commit => FND_API.G_FALSE,
3337: P_Validation_Level => P_Validation_Level,
3338: P_Admin_Group_Id => P_Admin_Group_Id,
3339: P_identity_salesforce_id => P_identity_salesforce_id,
3332: -- lead with incubation channel
3333: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
3334: P_Api_Version_Number => 2.0,
3335: P_Init_Msg_List => FND_API.G_FALSE,
3336: P_Commit => FND_API.G_FALSE,
3337: P_Validation_Level => P_Validation_Level,
3338: P_Admin_Group_Id => P_Admin_Group_Id,
3339: P_identity_salesforce_id => P_identity_salesforce_id,
3340: P_Sales_Lead_id => P_Sales_Lead_id,
3341: X_Return_Status => x_return_status,
3342: X_Msg_Count => x_msg_count,
3343: X_Msg_Data => x_msg_data);
3344:
3345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;
3348: END IF;
3349:
3342: X_Msg_Count => x_msg_count,
3343: X_Msg_Data => x_msg_data);
3344:
3345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3346: RAISE FND_API.G_EXC_ERROR;
3347: END IF;
3348: END IF;
3349:
3350: IF L_Lead_Engines_Out_Rec.indirect_channel_flag = 'Y' AND
3352: l_status_code <> 'CONVERTED_TO_OPPORTUNITY'
3353: THEN
3354: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
3355: P_Api_Version_Number => 2.0,
3356: P_Init_Msg_List => FND_API.G_FALSE,
3357: P_Commit => FND_API.G_FALSE,
3358: P_Validation_Level => P_Validation_Level,
3359: P_Check_Access_Flag => P_Check_Access_Flag,
3360: P_Admin_Flag => P_Admin_Flag,
3353: THEN
3354: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
3355: P_Api_Version_Number => 2.0,
3356: P_Init_Msg_List => FND_API.G_FALSE,
3357: P_Commit => FND_API.G_FALSE,
3358: P_Validation_Level => P_Validation_Level,
3359: P_Check_Access_Flag => P_Check_Access_Flag,
3360: P_Admin_Flag => P_Admin_Flag,
3361: P_Admin_Group_Id => P_Admin_Group_Id,
3368: X_Msg_Count => x_msg_count,
3369: X_Msg_Data => x_msg_data,
3370: X_Opportunity_Id => l_opportunity_id);
3371:
3372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375:
3376: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3369: X_Msg_Data => x_msg_data,
3370: X_Opportunity_Id => l_opportunity_id);
3371:
3372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375:
3376: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3377: P_Api_Version_Number => 2.0,
3374: END IF;
3375:
3376: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3377: P_Api_Version_Number => 2.0,
3378: P_Init_Msg_List => FND_API.G_FALSE,
3379: P_Commit => FND_API.G_FALSE,
3380: P_Validation_Level => P_Validation_Level,
3381: P_Admin_Group_Id => P_Admin_Group_Id,
3382: P_identity_salesforce_id => P_identity_salesforce_id,
3375:
3376: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3377: P_Api_Version_Number => 2.0,
3378: P_Init_Msg_List => FND_API.G_FALSE,
3379: P_Commit => FND_API.G_FALSE,
3380: P_Validation_Level => P_Validation_Level,
3381: P_Admin_Group_Id => P_Admin_Group_Id,
3382: P_identity_salesforce_id => P_identity_salesforce_id,
3383: P_Salesgroup_id => P_Salesgroup_id,
3385: X_Return_Status => x_return_status,
3386: X_Msg_Count => x_msg_count,
3387: X_Msg_Data => x_msg_data);
3388:
3389: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3390: RAISE FND_API.G_EXC_ERROR;
3391: END IF;
3392: END IF;
3393:
3386: X_Msg_Count => x_msg_count,
3387: X_Msg_Data => x_msg_data);
3388:
3389: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3390: RAISE FND_API.G_EXC_ERROR;
3391: END IF;
3392: END IF;
3393:
3394: -- IF l_referral_type IS NOT NULL
3394: -- IF l_referral_type IS NOT NULL
3395: -- THEN
3396: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
3397: -- P_Api_Version => 2.0,
3398: -- P_Init_Msg_List => FND_API.G_FALSE,
3399: -- P_Commit => FND_API.G_FALSE,
3400: -- P_Validation_Level => P_Validation_Level,
3401: -- P_Lead_Id => p_sales_lead_id,
3402: -- P_Lead_Status => NULL,
3395: -- THEN
3396: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
3397: -- P_Api_Version => 2.0,
3398: -- P_Init_Msg_List => FND_API.G_FALSE,
3399: -- P_Commit => FND_API.G_FALSE,
3400: -- P_Validation_Level => P_Validation_Level,
3401: -- P_Lead_Id => p_sales_lead_id,
3402: -- P_Lead_Status => NULL,
3403: -- P_salesforce_id => P_identity_salesforce_id,
3405: -- X_Return_Status => x_return_status,
3406: -- X_Msg_Count => x_msg_count,
3407: -- X_Msg_Data => x_msg_data);
3408:
3409: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3410: -- RAISE FND_API.G_EXC_ERROR;
3411: -- END IF;
3412: -- END IF;
3413:
3406: -- X_Msg_Count => x_msg_count,
3407: -- X_Msg_Data => x_msg_data);
3408:
3409: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3410: -- RAISE FND_API.G_EXC_ERROR;
3411: -- END IF;
3412: -- END IF;
3413:
3414: OPEN C_Get_Open_Status_Flag(p_sales_lead_id);
3569: l_lead_engines_out_rec.qualified_flag = 'Y'
3570: THEN
3571: aml_monitor_wf.launch_monitor(
3572: P_Api_Version_Number => 2.0,
3573: P_Init_Msg_List => FND_API.G_FALSE,
3574: p_commit => FND_API.G_FALSE,
3575: P_Sales_Lead_Id => p_sales_lead_id,
3576: P_Changed_From_stage => 'ASSIGNED_DATE',
3577: P_Lead_Action => 'UPDATE',
3570: THEN
3571: aml_monitor_wf.launch_monitor(
3572: P_Api_Version_Number => 2.0,
3573: P_Init_Msg_List => FND_API.G_FALSE,
3574: p_commit => FND_API.G_FALSE,
3575: P_Sales_Lead_Id => p_sales_lead_id,
3576: P_Changed_From_stage => 'ASSIGNED_DATE',
3577: P_Lead_Action => 'UPDATE',
3578: -- 9/9/03 SWKHANNA -- added for Lead Upgrade/Downgrade
3580: X_Return_Status => x_return_status,
3581: X_Msg_Count => x_msg_count,
3582: X_Msg_Data => x_msg_data);
3583:
3584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3585: RAISE FND_API.G_EXC_ERROR;
3586: END IF;
3587: END IF;
3588:
3581: X_Msg_Count => x_msg_count,
3582: X_Msg_Data => x_msg_data);
3583:
3584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3585: RAISE FND_API.G_EXC_ERROR;
3586: END IF;
3587: END IF;
3588:
3589: -- ER 3052066
3629: -- END of API body
3630: --
3631:
3632: -- Standard check for p_commit
3633: IF FND_API.to_Boolean( p_commit )
3634: THEN
3635: COMMIT WORK;
3636: END IF;
3637:
3645: IF x_return_status = 'W'
3646: THEN
3647: FND_MSG_PUB.Count_And_Get
3648: (
3649: p_encoded => FND_API.G_FALSE,
3650: p_count => x_msg_count,
3651: p_data => x_msg_data );
3652: ELSE
3653: FND_MSG_PUB.Count_And_Get
3659:
3660: -- WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
3661: -- RAISE AS_SALES_LEADS_PUB.Filter_Exception;
3662:
3663: WHEN FND_API.G_EXC_ERROR THEN
3664: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3665: P_API_NAME => L_API_NAME
3666: ,P_PKG_NAME => G_PKG_NAME
3667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3669: ,X_MSG_COUNT => X_MSG_COUNT
3670: ,X_MSG_DATA => X_MSG_DATA
3671: ,X_RETURN_STATUS => X_RETURN_STATUS);
3672:
3673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3674: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3675: P_API_NAME => L_API_NAME
3676: ,P_PKG_NAME => G_PKG_NAME
3677: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR