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
2597: -- Standard Start of API savepoint
2598: SAVEPOINT LEAD_PROCESS_AFTER_CREATE_PVT;
2599:
2600: -- Standard call to check for call compatibility.
2601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2602: p_api_version_number,
2603: l_api_name,
2604: G_PKG_NAME)
2605: THEN
2602: p_api_version_number,
2603: l_api_name,
2604: G_PKG_NAME)
2605: THEN
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: END IF;
2608:
2609: -- Initialize message list IF p_init_msg_list is set to TRUE.
2610: IF FND_API.to_Boolean( p_init_msg_list )
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: END IF;
2608:
2609: -- Initialize message list IF p_init_msg_list is set to TRUE.
2610: IF FND_API.to_Boolean( p_init_msg_list )
2611: THEN
2612: FND_MSG_PUB.initialize;
2613: END IF;
2614:
2618: 'PVT:' || l_api_name || ' Start');
2619: END IF;
2620:
2621: -- Initialize API return status to SUCCESS
2622: x_return_status := FND_API.G_RET_STS_SUCCESS;
2623:
2624: --
2625: -- Api body
2626: --
2637: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2638: p_token1 => 'PROFILE',
2639: p_token1_value => 'USER_ID');
2640: END IF;
2641: RAISE FND_API.G_EXC_ERROR;
2642: END IF;
2643:
2644: IF (p_validation_level = fnd_api.g_valid_level_full)
2645: THEN
2640: END IF;
2641: RAISE FND_API.G_EXC_ERROR;
2642: END IF;
2643:
2644: IF (p_validation_level = fnd_api.g_valid_level_full)
2645: THEN
2646: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
2647: p_api_version_number => 2.0
2648: ,p_init_msg_list => p_init_msg_list
2652: ,x_msg_count => x_msg_count
2653: ,x_msg_data => x_msg_data
2654: ,x_sales_member_rec => l_identity_sales_member_rec);
2655:
2656: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2657: RAISE FND_API.G_EXC_ERROR;
2658: END IF;
2659: END IF;
2660:
2653: ,x_msg_data => x_msg_data
2654: ,x_sales_member_rec => l_identity_sales_member_rec);
2655:
2656: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2657: RAISE FND_API.G_EXC_ERROR;
2658: END IF;
2659: END IF;
2660:
2661: Run_Lead_Engines(
2659: END IF;
2660:
2661: Run_Lead_Engines(
2662: P_Api_Version_Number => 2.0,
2663: P_Init_Msg_List => FND_API.G_FALSE,
2664: P_Commit => FND_API.G_FALSE,
2665: P_Validation_Level => P_Validation_Level,
2666: P_Admin_Group_Id => P_Admin_Group_Id,
2667: P_identity_salesforce_id => P_identity_salesforce_id,
2660:
2661: Run_Lead_Engines(
2662: P_Api_Version_Number => 2.0,
2663: P_Init_Msg_List => FND_API.G_FALSE,
2664: P_Commit => FND_API.G_FALSE,
2665: P_Validation_Level => P_Validation_Level,
2666: P_Admin_Group_Id => P_Admin_Group_Id,
2667: P_identity_salesforce_id => P_identity_salesforce_id,
2668: P_Salesgroup_id => P_Salesgroup_id,
2674: X_Return_Status => x_return_status,
2675: X_Msg_Count => x_msg_count,
2676: X_Msg_Data => x_msg_data);
2677:
2678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681:
2682: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
2675: X_Msg_Count => x_msg_count,
2676: X_Msg_Data => x_msg_data);
2677:
2678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681:
2682: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
2683: FETCH C_Get_Lead_Info INTO l_customer_id, l_address_id, l_referral_type,
2688: THEN
2689: -- not incubation lead
2690: As_Sales_Lead_Assign_PVT.Build_Lead_Sales_Team(
2691: P_Api_Version_Number => 2.0,
2692: P_Init_Msg_List => FND_API.G_FALSE,
2693: P_Commit => FND_API.G_FALSE,
2694: P_Validation_Level => P_Validation_Level,
2695: P_Admin_Group_Id => P_Admin_Group_Id,
2696: P_identity_salesforce_id => P_identity_salesforce_id,
2689: -- not incubation lead
2690: As_Sales_Lead_Assign_PVT.Build_Lead_Sales_Team(
2691: P_Api_Version_Number => 2.0,
2692: P_Init_Msg_List => FND_API.G_FALSE,
2693: P_Commit => FND_API.G_FALSE,
2694: P_Validation_Level => P_Validation_Level,
2695: P_Admin_Group_Id => P_Admin_Group_Id,
2696: P_identity_salesforce_id => P_identity_salesforce_id,
2697: P_Salesgroup_id => P_Salesgroup_id,
2700: X_Return_Status => x_return_status,
2701: X_Msg_Count => x_msg_count,
2702: X_Msg_Data => x_msg_data);
2703:
2704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2707:
2708: IF l_assign_to_salesforce_id IS NULL
2701: X_Msg_Count => x_msg_count,
2702: X_Msg_Data => x_msg_data);
2703:
2704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2707:
2708: IF l_assign_to_salesforce_id IS NULL
2709: THEN
2710: As_Sales_Lead_Assign_PVT.Find_Lead_Owner(
2711: p_sales_lead_id, p_salesgroup_id, l_request_id,
2712: l_return_status, x_msg_count, x_msg_data);
2713:
2714: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2715: RAISE fnd_api.g_exc_error;
2716: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE fnd_api.g_exc_unexpected_error;
2718: END IF;
2711: p_sales_lead_id, p_salesgroup_id, l_request_id,
2712: l_return_status, x_msg_count, x_msg_data);
2713:
2714: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2715: RAISE fnd_api.g_exc_error;
2716: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE fnd_api.g_exc_unexpected_error;
2718: END IF;
2719: ELSE
2712: l_return_status, x_msg_count, x_msg_data);
2713:
2714: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2715: RAISE fnd_api.g_exc_error;
2716: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE fnd_api.g_exc_unexpected_error;
2718: END IF;
2719: ELSE
2720: As_Sales_Lead_Assign_PVT.Process_Access_Record(
2713:
2714: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2715: RAISE fnd_api.g_exc_error;
2716: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE fnd_api.g_exc_unexpected_error;
2718: END IF;
2719: ELSE
2720: As_Sales_Lead_Assign_PVT.Process_Access_Record(
2721: p_sales_lead_id, l_request_id);
2726: IF l_assign_to_salesforce_id IS NULL
2727: THEN
2728: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
2729: P_Api_Version_Number => 2.0,
2730: P_Init_Msg_List => FND_API.G_FALSE,
2731: P_Commit => FND_API.G_FALSE,
2732: P_Validation_Level => P_Validation_Level,
2733: P_Admin_Group_Id => P_Admin_Group_Id,
2734: P_identity_salesforce_id => P_identity_salesforce_id,
2727: THEN
2728: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
2729: P_Api_Version_Number => 2.0,
2730: P_Init_Msg_List => FND_API.G_FALSE,
2731: P_Commit => FND_API.G_FALSE,
2732: P_Validation_Level => P_Validation_Level,
2733: P_Admin_Group_Id => P_Admin_Group_Id,
2734: P_identity_salesforce_id => P_identity_salesforce_id,
2735: P_Sales_Lead_id => P_Sales_Lead_id,
2736: X_Return_Status => x_return_status,
2737: X_Msg_Count => x_msg_count,
2738: X_Msg_Data => x_msg_data);
2739:
2740: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743: END IF;
2744:
2737: X_Msg_Count => x_msg_count,
2738: X_Msg_Data => x_msg_data);
2739:
2740: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743: END IF;
2744:
2745: OPEN C_Get_Person(P_identity_salesforce_id);
2765: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
2766:
2767: As_Access_PVT.Create_SalesTeam( -- for creator
2768: P_Api_Version_Number => 2.0,
2769: P_Init_Msg_List => FND_API.G_FALSE,
2770: P_Commit => FND_API.G_FALSE,
2771: P_Validation_Level => P_Validation_Level,
2772: P_Access_Profile_Rec => NULL,
2773: P_Check_Access_Flag => 'N',
2766:
2767: As_Access_PVT.Create_SalesTeam( -- for creator
2768: P_Api_Version_Number => 2.0,
2769: P_Init_Msg_List => FND_API.G_FALSE,
2770: P_Commit => FND_API.G_FALSE,
2771: P_Validation_Level => P_Validation_Level,
2772: P_Access_Profile_Rec => NULL,
2773: P_Check_Access_Flag => 'N',
2774: P_Admin_Flag => P_Admin_Flag,
2779: X_Msg_Count => x_msg_count,
2780: X_Msg_Data => x_msg_data,
2781: X_Access_Id => l_access_id);
2782:
2783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786: END IF;
2787:
2780: X_Msg_Data => x_msg_data,
2781: X_Access_Id => l_access_id);
2782:
2783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786: END IF;
2787:
2788: IF (AS_DEBUG_LOW_ON) THEN
2794: FND_PROFILE.Value('AS_AUTO_CONVERT_LEAD_OPP') = 'Y'
2795: THEN
2796: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
2797: P_Api_Version_Number => 2.0,
2798: P_Init_Msg_List => FND_API.G_FALSE,
2799: P_Commit => FND_API.G_FALSE,
2800: P_Validation_Level => P_Validation_Level,
2801: P_Check_Access_Flag => P_Check_Access_Flag,
2802: P_Admin_Flag => P_Admin_Flag,
2795: THEN
2796: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
2797: P_Api_Version_Number => 2.0,
2798: P_Init_Msg_List => FND_API.G_FALSE,
2799: P_Commit => FND_API.G_FALSE,
2800: P_Validation_Level => P_Validation_Level,
2801: P_Check_Access_Flag => P_Check_Access_Flag,
2802: P_Admin_Flag => P_Admin_Flag,
2803: P_Admin_Group_Id => P_Admin_Group_Id,
2810: X_Msg_Count => x_msg_count,
2811: X_Msg_Data => x_msg_data,
2812: X_Opportunity_Id => l_opportunity_id);
2813:
2814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2815: RAISE FND_API.G_EXC_ERROR;
2816: END IF;
2817:
2818: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2811: X_Msg_Data => x_msg_data,
2812: X_Opportunity_Id => l_opportunity_id);
2813:
2814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2815: RAISE FND_API.G_EXC_ERROR;
2816: END IF;
2817:
2818: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2819: P_Api_Version_Number => 2.0,
2816: END IF;
2817:
2818: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2819: P_Api_Version_Number => 2.0,
2820: P_Init_Msg_List => FND_API.G_FALSE,
2821: P_Commit => FND_API.G_FALSE,
2822: P_Validation_Level => P_Validation_Level,
2823: P_Admin_Group_Id => P_Admin_Group_Id,
2824: P_identity_salesforce_id => P_identity_salesforce_id,
2817:
2818: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
2819: P_Api_Version_Number => 2.0,
2820: P_Init_Msg_List => FND_API.G_FALSE,
2821: P_Commit => FND_API.G_FALSE,
2822: P_Validation_Level => P_Validation_Level,
2823: P_Admin_Group_Id => P_Admin_Group_Id,
2824: P_identity_salesforce_id => P_identity_salesforce_id,
2825: P_Salesgroup_id => P_Salesgroup_id,
2827: X_Return_Status => x_return_status,
2828: X_Msg_Count => x_msg_count,
2829: X_Msg_Data => x_msg_data);
2830:
2831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834: END IF;
2835:
2828: X_Msg_Count => x_msg_count,
2829: X_Msg_Data => x_msg_data);
2830:
2831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834: END IF;
2835:
2836: -- IF l_referral_type IS NOT NULL
2836: -- IF l_referral_type IS NOT NULL
2837: -- THEN
2838: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
2839: -- P_Api_Version => 2.0,
2840: -- P_Init_Msg_List => FND_API.G_FALSE,
2841: -- P_Commit => FND_API.G_FALSE,
2842: -- P_Validation_Level => P_Validation_Level,
2843: -- P_Lead_Id => p_sales_lead_id,
2844: -- P_Lead_Status => NULL,
2837: -- THEN
2838: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
2839: -- P_Api_Version => 2.0,
2840: -- P_Init_Msg_List => FND_API.G_FALSE,
2841: -- P_Commit => FND_API.G_FALSE,
2842: -- P_Validation_Level => P_Validation_Level,
2843: -- P_Lead_Id => p_sales_lead_id,
2844: -- P_Lead_Status => NULL,
2845: -- P_salesforce_id => P_identity_salesforce_id,
2847: -- X_Return_Status => x_return_status,
2848: -- X_Msg_Count => x_msg_count,
2849: -- X_Msg_Data => x_msg_data);
2850:
2851: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2852: -- RAISE FND_API.G_EXC_ERROR;
2853: -- END IF;
2854: -- END IF;
2855:
2848: -- X_Msg_Count => x_msg_count,
2849: -- X_Msg_Data => x_msg_data);
2850:
2851: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2852: -- RAISE FND_API.G_EXC_ERROR;
2853: -- END IF;
2854: -- END IF;
2855:
2856: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
2875: AND l_lead_engines_out_rec.qualified_flag = 'Y'
2876: THEN
2877: aml_monitor_wf.launch_monitor(
2878: P_Api_Version_Number => 2.0,
2879: P_Init_Msg_List => FND_API.G_FALSE,
2880: p_commit => FND_API.G_FALSE,
2881: P_Sales_Lead_Id => p_sales_lead_id,
2882: P_Changed_From_stage => 'CREATION_DATE',
2883: P_Lead_Action => 'CREATE',
2876: THEN
2877: aml_monitor_wf.launch_monitor(
2878: P_Api_Version_Number => 2.0,
2879: P_Init_Msg_List => FND_API.G_FALSE,
2880: p_commit => FND_API.G_FALSE,
2881: P_Sales_Lead_Id => p_sales_lead_id,
2882: P_Changed_From_stage => 'CREATION_DATE',
2883: P_Lead_Action => 'CREATE',
2884: -- 9/9/03 SWKHANNA -- Added for Lead Upgrade/Downgrade Functionality
2886: X_Return_Status => x_return_status,
2887: X_Msg_Count => x_msg_count,
2888: X_Msg_Data => x_msg_data);
2889:
2890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893: END IF;
2894:
2887: X_Msg_Count => x_msg_count,
2888: X_Msg_Data => x_msg_data);
2889:
2890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893: END IF;
2894:
2895: -- ER 3052066
2938: -- END of API body
2939: --
2940:
2941: -- Standard check for p_commit
2942: IF FND_API.to_Boolean( p_commit )
2943: THEN
2944: COMMIT WORK;
2945: END IF;
2946:
2954: IF x_return_status = 'W'
2955: THEN
2956: FND_MSG_PUB.Count_And_Get
2957: (
2958: p_encoded => FND_API.G_FALSE,
2959: p_count => x_msg_count,
2960: p_data => x_msg_data );
2961: ELSE
2962: FND_MSG_PUB.Count_And_Get
2968:
2969: -- WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
2970: -- RAISE AS_SALES_LEADS_PUB.Filter_Exception;
2971:
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2974: P_API_NAME => L_API_NAME
2975: ,P_PKG_NAME => G_PKG_NAME
2976: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2978: ,X_MSG_COUNT => X_MSG_COUNT
2979: ,X_MSG_DATA => X_MSG_DATA
2980: ,X_RETURN_STATUS => X_RETURN_STATUS);
2981:
2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2983: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2984: P_API_NAME => L_API_NAME
2985: ,P_PKG_NAME => G_PKG_NAME
2986: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3102: -- Standard Start of API savepoint
3103: SAVEPOINT LEAD_PROCESS_AFTER_UPDATE_PVT;
3104:
3105: -- Standard call to check for call compatibility.
3106: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3107: p_api_version_number,
3108: l_api_name,
3109: G_PKG_NAME)
3110: THEN
3107: p_api_version_number,
3108: l_api_name,
3109: G_PKG_NAME)
3110: THEN
3111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3112: END IF;
3113:
3114: -- Initialize message list IF p_init_msg_list is set to TRUE.
3115: IF FND_API.to_Boolean( p_init_msg_list )
3111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3112: END IF;
3113:
3114: -- Initialize message list IF p_init_msg_list is set to TRUE.
3115: IF FND_API.to_Boolean( p_init_msg_list )
3116: THEN
3117: FND_MSG_PUB.initialize;
3118: END IF;
3119:
3123: 'PVT:' || l_api_name || ' Start');
3124: END IF;
3125:
3126: -- Initialize API return status to SUCCESS
3127: x_return_status := FND_API.G_RET_STS_SUCCESS;
3128:
3129: --
3130: -- Api body
3131: --
3142: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
3143: p_token1 => 'PROFILE',
3144: p_token1_value => 'USER_ID');
3145: END IF;
3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148:
3149: IF (p_validation_level = fnd_api.g_valid_level_full)
3150: THEN
3145: END IF;
3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148:
3149: IF (p_validation_level = fnd_api.g_valid_level_full)
3150: THEN
3151: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
3152: p_api_version_number => 2.0
3153: ,p_init_msg_list => p_init_msg_list
3157: ,x_msg_count => x_msg_count
3158: ,x_msg_data => x_msg_data
3159: ,x_sales_member_rec => l_identity_sales_member_rec);
3160:
3161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3162: RAISE FND_API.G_EXC_ERROR;
3163: END IF;
3164: END IF;
3165:
3158: ,x_msg_data => x_msg_data
3159: ,x_sales_member_rec => l_identity_sales_member_rec);
3160:
3161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3162: RAISE FND_API.G_EXC_ERROR;
3163: END IF;
3164: END IF;
3165:
3166: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);
3181: IF NVL(l_auto_run_lead_engines, 'N') = 'Y'
3182: THEN
3183: Run_Lead_Engines(
3184: P_Api_Version_Number => 2.0,
3185: P_Init_Msg_List => FND_API.G_FALSE,
3186: P_Commit => FND_API.G_FALSE,
3187: P_Validation_Level => P_Validation_Level,
3188: P_Admin_Group_Id => P_Admin_Group_Id,
3189: P_identity_salesforce_id => P_identity_salesforce_id,
3182: THEN
3183: Run_Lead_Engines(
3184: P_Api_Version_Number => 2.0,
3185: P_Init_Msg_List => FND_API.G_FALSE,
3186: P_Commit => FND_API.G_FALSE,
3187: P_Validation_Level => P_Validation_Level,
3188: P_Admin_Group_Id => P_Admin_Group_Id,
3189: P_identity_salesforce_id => P_identity_salesforce_id,
3190: P_Salesgroup_id => P_Salesgroup_id,
3196: X_Return_Status => x_return_status,
3197: X_Msg_Count => x_msg_count,
3198: X_Msg_Data => x_msg_data);
3199:
3200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3201: RAISE FND_API.G_EXC_ERROR;
3202: END IF;
3203:
3204: ELSE
3197: X_Msg_Count => x_msg_count,
3198: X_Msg_Data => x_msg_data);
3199:
3200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3201: RAISE FND_API.G_EXC_ERROR;
3202: END IF;
3203:
3204: ELSE
3205: OPEN c_get_indirect_channel_flag(l_lead_engines_out_rec.channel_code);
3224: THEN
3225: -- not incubation lead
3226: As_Sales_Lead_Assign_PVT.Rebuild_Lead_Sales_Team(
3227: P_Api_Version_Number => 2.0,
3228: P_Init_Msg_List => FND_API.G_FALSE,
3229: P_Commit => FND_API.G_FALSE,
3230: P_Validation_Level => P_Validation_Level,
3231: P_Admin_Group_Id => P_Admin_Group_Id,
3232: P_identity_salesforce_id => P_identity_salesforce_id,
3225: -- not incubation lead
3226: As_Sales_Lead_Assign_PVT.Rebuild_Lead_Sales_Team(
3227: P_Api_Version_Number => 2.0,
3228: P_Init_Msg_List => FND_API.G_FALSE,
3229: P_Commit => FND_API.G_FALSE,
3230: P_Validation_Level => P_Validation_Level,
3231: P_Admin_Group_Id => P_Admin_Group_Id,
3232: P_identity_salesforce_id => P_identity_salesforce_id,
3233: P_Salesgroup_id => P_Salesgroup_id,
3236: X_Return_Status => x_return_status,
3237: X_Msg_Count => x_msg_count,
3238: X_Msg_Data => x_msg_data);
3239:
3240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243:
3244: -- Check owner again here because Rebuild_Lead_Sales_Team may
3237: X_Msg_Count => x_msg_count,
3238: X_Msg_Data => x_msg_data);
3239:
3240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243:
3244: -- Check owner again here because Rebuild_Lead_Sales_Team may
3245: -- remove owner in as_accesses_all
3263: As_Sales_Lead_Assign_PVT.Find_Lead_Owner(
3264: p_sales_lead_id, p_salesgroup_id, l_request_id,
3265: l_return_status, x_msg_count, x_msg_data);
3266:
3267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3268: RAISE fnd_api.g_exc_error;
3269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE fnd_api.g_exc_unexpected_error;
3271: END IF;
3264: p_sales_lead_id, p_salesgroup_id, l_request_id,
3265: l_return_status, x_msg_count, x_msg_data);
3266:
3267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3268: RAISE fnd_api.g_exc_error;
3269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE fnd_api.g_exc_unexpected_error;
3271: END IF;
3272: l_owner_changed_flag := 'Y';
3265: l_return_status, x_msg_count, x_msg_data);
3266:
3267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3268: RAISE fnd_api.g_exc_error;
3269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE fnd_api.g_exc_unexpected_error;
3271: END IF;
3272: l_owner_changed_flag := 'Y';
3273: ELSE
3266:
3267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3268: RAISE fnd_api.g_exc_error;
3269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE fnd_api.g_exc_unexpected_error;
3271: END IF;
3272: l_owner_changed_flag := 'Y';
3273: ELSE
3274: As_Sales_Lead_Assign_PVT.Process_Access_Record(
3277: ELSE
3278: -- lead with incubation channel
3279: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
3280: P_Api_Version_Number => 2.0,
3281: P_Init_Msg_List => FND_API.G_FALSE,
3282: P_Commit => FND_API.G_FALSE,
3283: P_Validation_Level => P_Validation_Level,
3284: P_Admin_Group_Id => P_Admin_Group_Id,
3285: P_identity_salesforce_id => P_identity_salesforce_id,
3278: -- lead with incubation channel
3279: AS_SALES_LEADS_PUB.ROUTE_LEAD_TO_MARKETING(
3280: P_Api_Version_Number => 2.0,
3281: P_Init_Msg_List => FND_API.G_FALSE,
3282: P_Commit => FND_API.G_FALSE,
3283: P_Validation_Level => P_Validation_Level,
3284: P_Admin_Group_Id => P_Admin_Group_Id,
3285: P_identity_salesforce_id => P_identity_salesforce_id,
3286: P_Sales_Lead_id => P_Sales_Lead_id,
3287: X_Return_Status => x_return_status,
3288: X_Msg_Count => x_msg_count,
3289: X_Msg_Data => x_msg_data);
3290:
3291: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3292: RAISE FND_API.G_EXC_ERROR;
3293: END IF;
3294: END IF;
3295:
3288: X_Msg_Count => x_msg_count,
3289: X_Msg_Data => x_msg_data);
3290:
3291: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3292: RAISE FND_API.G_EXC_ERROR;
3293: END IF;
3294: END IF;
3295:
3296: IF L_Lead_Engines_Out_Rec.indirect_channel_flag = 'Y' AND
3298: l_status_code <> 'CONVERTED_TO_OPPORTUNITY'
3299: THEN
3300: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
3301: P_Api_Version_Number => 2.0,
3302: P_Init_Msg_List => FND_API.G_FALSE,
3303: P_Commit => FND_API.G_FALSE,
3304: P_Validation_Level => P_Validation_Level,
3305: P_Check_Access_Flag => P_Check_Access_Flag,
3306: P_Admin_Flag => P_Admin_Flag,
3299: THEN
3300: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
3301: P_Api_Version_Number => 2.0,
3302: P_Init_Msg_List => FND_API.G_FALSE,
3303: P_Commit => FND_API.G_FALSE,
3304: P_Validation_Level => P_Validation_Level,
3305: P_Check_Access_Flag => P_Check_Access_Flag,
3306: P_Admin_Flag => P_Admin_Flag,
3307: P_Admin_Group_Id => P_Admin_Group_Id,
3314: X_Msg_Count => x_msg_count,
3315: X_Msg_Data => x_msg_data,
3316: X_Opportunity_Id => l_opportunity_id);
3317:
3318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3319: RAISE FND_API.G_EXC_ERROR;
3320: END IF;
3321:
3322: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3315: X_Msg_Data => x_msg_data,
3316: X_Opportunity_Id => l_opportunity_id);
3317:
3318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3319: RAISE FND_API.G_EXC_ERROR;
3320: END IF;
3321:
3322: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3323: P_Api_Version_Number => 2.0,
3320: END IF;
3321:
3322: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3323: P_Api_Version_Number => 2.0,
3324: P_Init_Msg_List => FND_API.G_FALSE,
3325: P_Commit => FND_API.G_FALSE,
3326: P_Validation_Level => P_Validation_Level,
3327: P_Admin_Group_Id => P_Admin_Group_Id,
3328: P_identity_salesforce_id => P_identity_salesforce_id,
3321:
3322: PV_BG_PARTNER_MATCHING_PUB.Start_Partner_Matching(
3323: P_Api_Version_Number => 2.0,
3324: P_Init_Msg_List => FND_API.G_FALSE,
3325: P_Commit => FND_API.G_FALSE,
3326: P_Validation_Level => P_Validation_Level,
3327: P_Admin_Group_Id => P_Admin_Group_Id,
3328: P_identity_salesforce_id => P_identity_salesforce_id,
3329: P_Salesgroup_id => P_Salesgroup_id,
3331: X_Return_Status => x_return_status,
3332: X_Msg_Count => x_msg_count,
3333: X_Msg_Data => x_msg_data);
3334:
3335: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3336: RAISE FND_API.G_EXC_ERROR;
3337: END IF;
3338: END IF;
3339:
3332: X_Msg_Count => x_msg_count,
3333: X_Msg_Data => x_msg_data);
3334:
3335: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3336: RAISE FND_API.G_EXC_ERROR;
3337: END IF;
3338: END IF;
3339:
3340: -- IF l_referral_type IS NOT NULL
3340: -- IF l_referral_type IS NOT NULL
3341: -- THEN
3342: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
3343: -- P_Api_Version => 2.0,
3344: -- P_Init_Msg_List => FND_API.G_FALSE,
3345: -- P_Commit => FND_API.G_FALSE,
3346: -- P_Validation_Level => P_Validation_Level,
3347: -- P_Lead_Id => p_sales_lead_id,
3348: -- P_Lead_Status => NULL,
3341: -- THEN
3342: -- AS_SALES_LEAD_REFERRAL.Notify_Party(
3343: -- P_Api_Version => 2.0,
3344: -- P_Init_Msg_List => FND_API.G_FALSE,
3345: -- P_Commit => FND_API.G_FALSE,
3346: -- P_Validation_Level => P_Validation_Level,
3347: -- P_Lead_Id => p_sales_lead_id,
3348: -- P_Lead_Status => NULL,
3349: -- P_salesforce_id => P_identity_salesforce_id,
3351: -- X_Return_Status => x_return_status,
3352: -- X_Msg_Count => x_msg_count,
3353: -- X_Msg_Data => x_msg_data);
3354:
3355: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3356: -- RAISE FND_API.G_EXC_ERROR;
3357: -- END IF;
3358: -- END IF;
3359:
3352: -- X_Msg_Count => x_msg_count,
3353: -- X_Msg_Data => x_msg_data);
3354:
3355: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3356: -- RAISE FND_API.G_EXC_ERROR;
3357: -- END IF;
3358: -- END IF;
3359:
3360: OPEN C_Get_Open_Status_Flag(p_sales_lead_id);
3515: l_lead_engines_out_rec.qualified_flag = 'Y'
3516: THEN
3517: aml_monitor_wf.launch_monitor(
3518: P_Api_Version_Number => 2.0,
3519: P_Init_Msg_List => FND_API.G_FALSE,
3520: p_commit => FND_API.G_FALSE,
3521: P_Sales_Lead_Id => p_sales_lead_id,
3522: P_Changed_From_stage => 'ASSIGNED_DATE',
3523: P_Lead_Action => 'UPDATE',
3516: THEN
3517: aml_monitor_wf.launch_monitor(
3518: P_Api_Version_Number => 2.0,
3519: P_Init_Msg_List => FND_API.G_FALSE,
3520: p_commit => FND_API.G_FALSE,
3521: P_Sales_Lead_Id => p_sales_lead_id,
3522: P_Changed_From_stage => 'ASSIGNED_DATE',
3523: P_Lead_Action => 'UPDATE',
3524: -- 9/9/03 SWKHANNA -- added for Lead Upgrade/Downgrade
3526: X_Return_Status => x_return_status,
3527: X_Msg_Count => x_msg_count,
3528: X_Msg_Data => x_msg_data);
3529:
3530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3531: RAISE FND_API.G_EXC_ERROR;
3532: END IF;
3533: END IF;
3534:
3527: X_Msg_Count => x_msg_count,
3528: X_Msg_Data => x_msg_data);
3529:
3530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3531: RAISE FND_API.G_EXC_ERROR;
3532: END IF;
3533: END IF;
3534:
3535: -- ER 3052066
3575: -- END of API body
3576: --
3577:
3578: -- Standard check for p_commit
3579: IF FND_API.to_Boolean( p_commit )
3580: THEN
3581: COMMIT WORK;
3582: END IF;
3583:
3591: IF x_return_status = 'W'
3592: THEN
3593: FND_MSG_PUB.Count_And_Get
3594: (
3595: p_encoded => FND_API.G_FALSE,
3596: p_count => x_msg_count,
3597: p_data => x_msg_data );
3598: ELSE
3599: FND_MSG_PUB.Count_And_Get
3605:
3606: -- WHEN AS_SALES_LEADS_PUB.Filter_Exception THEN
3607: -- RAISE AS_SALES_LEADS_PUB.Filter_Exception;
3608:
3609: WHEN FND_API.G_EXC_ERROR THEN
3610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3611: P_API_NAME => L_API_NAME
3612: ,P_PKG_NAME => G_PKG_NAME
3613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3615: ,X_MSG_COUNT => X_MSG_COUNT
3616: ,X_MSG_DATA => X_MSG_DATA
3617: ,X_RETURN_STATUS => X_RETURN_STATUS);
3618:
3619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3621: P_API_NAME => L_API_NAME
3622: ,P_PKG_NAME => G_PKG_NAME
3623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR