eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on FND_MSG_PUB

Line 124: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

120:
121:
122: -- API Name: Run_Lead_Engines
123:
124: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
125: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
126: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
127: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
128:

Line 125: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

121:
122: -- API Name: Run_Lead_Engines
123:
124: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
125: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
126: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
127: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
128:
129:

Line 126: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

122: -- API Name: Run_Lead_Engines
123:
124: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
125: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
126: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
127: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
128:
129:
130: PROCEDURE Debug(

Line 127: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

123:
124: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
125: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
126: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
127: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
128:
129:
130: PROCEDURE Debug(
131: p_msg_string IN VARCHAR2

Line 136: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

132: )
133: IS
134:
135: BEGIN
136: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
137: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
138: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
139: FND_MSG_PUB.Add;
140: --END IF;

Line 139: FND_MSG_PUB.Add;

135: BEGIN
136: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
137: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
138: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
139: FND_MSG_PUB.Add;
140: --END IF;
141: END Debug;
142:
143:

Line 207: FND_MSG_PUB.initialize;

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:
210: -- Debug Message
211: IF (AS_DEBUG_LOW_ON) THEN

Line 212: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

208: END IF;
209:
210: -- Debug Message
211: IF (AS_DEBUG_LOW_ON) THEN
212: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
213: 'PVT:' || l_api_name || ' Start');
214: END IF;
215:
216: -- Initialize API return status to SUCCESS

Line 231: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

227: x_lead_engines_out_rec.sales_team_flag := 'N';
228:
229: IF FND_GLOBAL.User_Id IS NULL
230: THEN
231: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
232: THEN
233: AS_UTILITY_PVT.Set_Message(
234: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
235: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 234: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

230: THEN
231: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
232: THEN
233: AS_UTILITY_PVT.Set_Message(
234: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
235: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
236: p_token1 => 'PROFILE',
237: p_token1_value => 'USER_ID');
238: END IF;

Line 285: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

281: --
282: -- The above profiles are obsoleted in 11.5.9
283:
284: IF (AS_DEBUG_LOW_ON) THEN
285: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
286: 'Chinar qualified_flag=' || l_sales_lead_rec.qualified_flag);
287: END IF;
288:
289: IF l_sales_lead_rec.qualified_flag = 'N'

Line 333: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,
334: 'x_qual_flag=' || l_sales_lead_rec.qualified_flag);
335: END IF;
336: x_lead_engines_out_rec.qualified_flag :=
337: l_sales_lead_rec.qualified_flag;

Line 359: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

355: l_sales_lead_rec.qualified_flag;
356: END IF; -- run qualification engine
357:
358: IF (AS_DEBUG_LOW_ON) THEN
359: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
360: 'Chinar lead_rank_id=' || l_sales_lead_rec.lead_rank_id);
361: END IF;
362:
363: -- ckapoor. Disqualification project - give a default rating from profile

Line 371: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

367: -- so this is definitely the value after passing thru qualification engine
368: THEN
369:
370: IF (AS_DEBUG_LOW_ON) THEN
371: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
372: 'Chinar Within qualified flag is N condition');
373: END IF;
374: /*
375: -- check manually no rank is passed.

Line 380: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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'));
382: END IF;
383: l_sales_lead_rec.lead_rank_id := FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS');
384: x_lead_engines_out_rec.lead_rank_id :=

Line 449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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);
451: END IF;
452:
453: l_sales_lead_rec.lead_rank_id := TO_NUMBER(l_action_value);

Line 462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

458: l_sales_lead_rec.lead_rank_id;
459: END IF; -- run rating engine -- this now applies to IF THEN ELSE condition ckapoor
460:
461: IF (AS_DEBUG_LOW_ON) THEN
462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
463: 'channel_code=' || l_sales_lead_rec.channel_code);
464: END IF;
465:
466: -- ckapoor : since the return has been removed earlier, the code will

Line 501: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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);
503: END IF;
504:
505: x_lead_engines_out_rec.channel_code :=

Line 520: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

516:
517: IF x_lead_engines_out_rec.indirect_channel_flag IS NULL
518: THEN
519: IF (AS_DEBUG_LOW_ON) THEN
520: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
521: l_sales_lead_rec.channel_code
522: || ' not defined in Channel Types');
523: END IF;
524: x_lead_engines_out_rec.indirect_channel_flag := 'N';

Line 547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

543: END IF;
544:
545: -- Debug Message
546: IF (AS_DEBUG_LOW_ON) THEN
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
548: 'PVT: ' || l_api_name || ' End');
549: END IF;
550:
551: -- Standard call to get message count and IF count is 1, get message info.

Line 552: FND_MSG_PUB.Count_And_Get

548: 'PVT: ' || l_api_name || ' End');
549: END IF;
550:
551: -- Standard call to get message count and IF count is 1, get message info.
552: FND_MSG_PUB.Count_And_Get
553: ( p_count => x_msg_count,
554: p_data => x_msg_data );
555:
556: EXCEPTION

Line 564: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
565: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
566: ,X_MSG_COUNT => X_MSG_COUNT
567: ,X_MSG_DATA => X_MSG_DATA
568: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 574: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
575: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
576: ,X_MSG_COUNT => X_MSG_COUNT
577: ,X_MSG_DATA => X_MSG_DATA
578: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1238: FND_MSG_PUB.initialize;

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:
1241: -- Debug Message
1242: IF (AS_DEBUG_LOW_ON) THEN

Line 1243: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1239: END IF;
1240:
1241: -- Debug Message
1242: IF (AS_DEBUG_LOW_ON) THEN
1243: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1244: 'PVT:' || l_api_name || ' Start');
1245: END IF;
1246:
1247: -- Initialize API return status to SUCCESS

Line 1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1256: -- ******************************************************************
1257:
1258: IF FND_GLOBAL.User_Id IS NULL
1259: THEN
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1261: THEN
1262: AS_UTILITY_PVT.Set_Message(
1263: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1264: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 1263: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1259: THEN
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1261: THEN
1262: AS_UTILITY_PVT.Set_Message(
1263: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1264: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1265: p_token1 => 'PROFILE',
1266: p_token1_value => 'USER_ID');
1267: END IF;

Line 1340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1336:
1337:
1338:
1339: IF (AS_DEBUG_LOW_ON) THEN
1340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1341: 'Process_Type=' || p_process_type);
1342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1343: 'Sales_Lead_Id=' || p_sales_lead_id);
1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1338:
1339: IF (AS_DEBUG_LOW_ON) THEN
1340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1341: 'Process_Type=' || p_process_type);
1342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1343: 'Sales_Lead_Id=' || p_sales_lead_id);
1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1345: 'Source_promotion_id=' || l_source_promotion_id);
1346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1341: 'Process_Type=' || p_process_type);
1342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1343: 'Sales_Lead_Id=' || p_sales_lead_id);
1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1345: 'Source_promotion_id=' || l_source_promotion_id);
1346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1347: 'Status_code=' || l_status_code);
1348: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1343: 'Sales_Lead_Id=' || p_sales_lead_id);
1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1345: 'Source_promotion_id=' || l_source_promotion_id);
1346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1347: 'Status_code=' || l_status_code);
1348: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1349: 'Creation_date=' || l_creation_date);
1350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1348: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1345: 'Source_promotion_id=' || l_source_promotion_id);
1346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1347: 'Status_code=' || l_status_code);
1348: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1349: 'Creation_date=' || l_creation_date);
1350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1351: 'Country=' || l_country);
1352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1346: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1347: 'Status_code=' || l_status_code);
1348: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1349: 'Creation_date=' || l_creation_date);
1350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1351: 'Country=' || l_country);
1352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1353: 'Email=' || l_email_address);
1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1348: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1349: 'Creation_date=' || l_creation_date);
1350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1351: 'Country=' || l_country);
1352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1353: 'Email=' || l_email_address);
1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1355: 'Area_Code=' || l_area_code);
1356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1350: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1351: 'Country=' || l_country);
1352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1353: 'Email=' || l_email_address);
1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1355: 'Area_Code=' || l_area_code);
1356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1357: 'State=' || l_state);
1358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1352: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1353: 'Email=' || l_email_address);
1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1355: 'Area_Code=' || l_area_code);
1356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1357: 'State=' || l_state);
1358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1359: 'Province=' || l_province);
1360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1355: 'Area_Code=' || l_area_code);
1356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1357: 'State=' || l_state);
1358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1359: 'Province=' || l_province);
1360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1361: 'County=' || l_county);
1362: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1357: 'State=' || l_state);
1358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1359: 'Province=' || l_province);
1360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1361: 'County=' || l_county);
1362: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1363: 'City=' || l_city);
1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1362: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1359: 'Province=' || l_province);
1360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1361: 'County=' || l_county);
1362: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1363: 'City=' || l_city);
1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1365: 'Postal_Code=' || l_postal_code);
1366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1360: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1361: 'County=' || l_county);
1362: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1363: 'City=' || l_city);
1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1365: 'Postal_Code=' || l_postal_code);
1366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1367: 'Category=' || l_category_code);
1368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1362: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1363: 'City=' || l_city);
1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1365: 'Postal_Code=' || l_postal_code);
1366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1367: 'Category=' || l_category_code);
1368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1369: 'Campaign Setup type id =' || l_custom_setup_id);
1370: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1365: 'Postal_Code=' || l_postal_code);
1366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1367: 'Category=' || l_category_code);
1368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1369: 'Campaign Setup type id =' || l_custom_setup_id);
1370: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1371: -- 'Import flag =' || l_import_flag);
1372:

Line 1370: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1367: 'Category=' || l_category_code);
1368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1369: 'Campaign Setup type id =' || l_custom_setup_id);
1370: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1371: -- 'Import flag =' || l_import_flag);
1372:
1373: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1374: -- 'create flag =' || P_Is_Create_Mode);

Line 1373: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1369: 'Campaign Setup type id =' || l_custom_setup_id);
1370: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1371: -- 'Import flag =' || l_import_flag);
1372:
1373: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1374: -- 'create flag =' || P_Is_Create_Mode);
1375:
1376: END IF;
1377:

Line 1385: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1381: -- Determine if it is import mode or not
1382:
1383: -- IF ((P_Is_Create_Mode = 'Y') AND ( l_import_flag = 'Y')) THEN
1384:
1385: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1386: -- 'Chinar import case' );
1387:
1388: -- l_is_create_import_mode_val := 'Y';
1389: -- END IF;

Line 1409: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1405: -- l_action_tbl, l_action_value_tbl
1406: CLOSE C_Get_Matching_Rules;
1407:
1408: IF (AS_DEBUG_LOW_ON) THEN
1409: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1410: 'rule count=' || l_process_rule_id_tbl.count);
1411:
1412: END IF;
1413: l_match_rule_flag := 'N';

Line 1422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1418: l_rank := l_rank_tbl(l_rule_index);
1419: WHILE l_rule_index <= l_process_rule_id_tbl.last
1420: LOOP
1421: IF (AS_DEBUG_LOW_ON) THEN
1422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1423: 'pro_rule_id=' || l_process_rule_id_tbl(l_rule_index));
1424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1425: 'rank=' || l_rank_tbl(l_rule_index));
1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1420: LOOP
1421: IF (AS_DEBUG_LOW_ON) THEN
1422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1423: 'pro_rule_id=' || l_process_rule_id_tbl(l_rule_index));
1424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1425: 'rank=' || l_rank_tbl(l_rule_index));
1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1427: 'l_match_rule_flag=' || l_match_rule_flag);
1428: END IF;

Line 1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1423: 'pro_rule_id=' || l_process_rule_id_tbl(l_rule_index));
1424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1425: 'rank=' || l_rank_tbl(l_rule_index));
1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1427: 'l_match_rule_flag=' || l_match_rule_flag);
1428: END IF;
1429:
1430: IF l_rank_tbl(l_rule_index) <> l_rank AND

Line 1435: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1431: l_match_rule_flag = 'Y'
1432: THEN
1433: IF (AS_DEBUG_LOW_ON) THEN
1434: AS_UTILITY_PVT.Debug_Message(
1435: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1436: 'not same precedence/rule found');
1437: END IF;
1438: EXIT;
1439: END IF;

Line 1499: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1495:
1496: END IF;
1497:
1498: IF (AS_DEBUG_LOW_ON) THEN
1499: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1500: 'criterion rule count=' || l_criterion_rule_id_tbl.count);
1501:
1502: END IF;
1503: IF l_criterion_rule_id_tbl.count > 0

Line 1510: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1506: WHILE l_criterion_rule_index <= l_criterion_rule_id_tbl.last
1507: LOOP
1508: IF (AS_DEBUG_LOW_ON) THEN
1509: AS_UTILITY_PVT.Debug_Message(
1510: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1511: 'cri_rule_idx=' || l_criterion_rule_index);
1512: AS_UTILITY_PVT.Debug_Message(
1513: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1514: 'cri_rule_id=' ||

Line 1513: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1509: AS_UTILITY_PVT.Debug_Message(
1510: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1511: 'cri_rule_idx=' || l_criterion_rule_index);
1512: AS_UTILITY_PVT.Debug_Message(
1513: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1514: 'cri_rule_id=' ||
1515: l_criterion_rule_id_tbl(l_criterion_rule_index));
1516: END IF;
1517:

Line 1535: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1531:
1532: l_criterion_attribute_exist := TRUE;
1533: IF (AS_DEBUG_LOW_ON) THEN
1534: AS_UTILITY_PVT.Debug_Message(
1535: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1536: 'sel_cra_id=' || l_selection_criteria_id);
1537: AS_UTILITY_PVT.Debug_Message(
1538: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1539: 'attr_id=' || l_attribute_id);

Line 1538: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1534: AS_UTILITY_PVT.Debug_Message(
1535: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1536: 'sel_cra_id=' || l_selection_criteria_id);
1537: AS_UTILITY_PVT.Debug_Message(
1538: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1539: 'attr_id=' || l_attribute_id);
1540: AS_UTILITY_PVT.Debug_Message(
1541: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1542: 'op=' || l_operator);

Line 1541: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1537: AS_UTILITY_PVT.Debug_Message(
1538: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1539: 'attr_id=' || l_attribute_id);
1540: AS_UTILITY_PVT.Debug_Message(
1541: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1542: 'op=' || l_operator);
1543: END IF;
1544: IF l_selection_criteria_id <>
1545: l_prev_selection_criteria_id

Line 1551: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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,
1552: 'rul_val=' || l_rule_attr_value);
1553: AS_UTILITY_PVT.Debug_Message(
1554: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1555: 'rul_to_val=' || l_rule_attr_to_value);

Line 1554: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1550: AS_UTILITY_PVT.Debug_Message(
1551: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1552: 'rul_val=' || l_rule_attr_value);
1553: AS_UTILITY_PVT.Debug_Message(
1554: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1555: 'rul_to_val=' || l_rule_attr_to_value);
1556: AS_UTILITY_PVT.Debug_Message(
1557: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1558: 'prev_attr_id=' || l_prev_attribute_id);

Line 1557: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1553: AS_UTILITY_PVT.Debug_Message(
1554: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1555: 'rul_to_val=' || l_rule_attr_to_value);
1556: AS_UTILITY_PVT.Debug_Message(
1557: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1558: 'prev_attr_id=' || l_prev_attribute_id);
1559: AS_UTILITY_PVT.Debug_Message(
1560: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1561: 'prev_op=' || l_prev_operator);

Line 1560: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1556: AS_UTILITY_PVT.Debug_Message(
1557: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1558: 'prev_attr_id=' || l_prev_attribute_id);
1559: AS_UTILITY_PVT.Debug_Message(
1560: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1561: 'prev_op=' || l_prev_operator);
1562: END IF;
1563: l_match_attribute_flag :=
1564: pv_check_match_pub.Check_Match (

Line 1586: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1582: IF l_match_attribute_flag = FALSE
1583: THEN
1584: IF (AS_DEBUG_LOW_ON) THEN
1585: AS_UTILITY_PVT.Debug_Message(
1586: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1587: 'attr not match');
1588: END IF;
1589: EXIT; -- exit attribute loop
1590: ELSE

Line 1593: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1589: EXIT; -- exit attribute loop
1590: ELSE
1591: IF (AS_DEBUG_LOW_ON) THEN
1592: AS_UTILITY_PVT.Debug_Message(
1593: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1594: 'attr match');
1595: END IF;
1596: END IF;
1597: END IF; -- l_rule_attribute_value <> l_delimiter

Line 1617: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1613: IF l_match_attribute_flag AND l_criterion_attribute_exist
1614: THEN
1615: IF (AS_DEBUG_LOW_ON) THEN
1616: AS_UTILITY_PVT.Debug_Message(
1617: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1618: 'l attr_id=' || l_prev_attribute_id);
1619: AS_UTILITY_PVT.Debug_Message(
1620: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'rul_val=' || l_rule_attr_value);

Line 1620: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1616: AS_UTILITY_PVT.Debug_Message(
1617: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1618: 'l attr_id=' || l_prev_attribute_id);
1619: AS_UTILITY_PVT.Debug_Message(
1620: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'rul_val=' || l_rule_attr_value);
1622: AS_UTILITY_PVT.Debug_Message(
1623: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1624: 'rul_to_val=' || l_rule_attr_to_value);

Line 1623: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1619: AS_UTILITY_PVT.Debug_Message(
1620: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'rul_val=' || l_rule_attr_value);
1622: AS_UTILITY_PVT.Debug_Message(
1623: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1624: 'rul_to_val=' || l_rule_attr_to_value);
1625: AS_UTILITY_PVT.Debug_Message(
1626: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'prev_attr_id=' || l_prev_attribute_id);

Line 1626: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1622: AS_UTILITY_PVT.Debug_Message(
1623: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1624: 'rul_to_val=' || l_rule_attr_to_value);
1625: AS_UTILITY_PVT.Debug_Message(
1626: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'prev_attr_id=' || l_prev_attribute_id);
1628: AS_UTILITY_PVT.Debug_Message(
1629: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1630: 'prev_op=' || l_prev_operator);

Line 1629: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1625: AS_UTILITY_PVT.Debug_Message(
1626: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'prev_attr_id=' || l_prev_attribute_id);
1628: AS_UTILITY_PVT.Debug_Message(
1629: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1630: 'prev_op=' || l_prev_operator);
1631: END IF;
1632: l_match_attribute_flag :=
1633: pv_check_match_pub.Check_Match (

Line 1652: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1648: IF l_match_attribute_flag AND l_criterion_attribute_exist
1649: THEN
1650: IF (AS_DEBUG_LOW_ON) THEN
1651: AS_UTILITY_PVT.Debug_Message(
1652: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1653: 'cr_ru=' ||
1654: l_criterion_rule_id_tbl(l_criterion_rule_index));
1655: AS_UTILITY_PVT.Debug_Message(
1656: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1656: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1652: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1653: 'cr_ru=' ||
1654: l_criterion_rule_id_tbl(l_criterion_rule_index));
1655: AS_UTILITY_PVT.Debug_Message(
1656: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1657: 'l_min_score_tbl=' ||
1658: l_min_score_tbl(l_criterion_rule_index));
1659: AS_UTILITY_PVT.Debug_Message(
1660: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1660: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1656: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1657: 'l_min_score_tbl=' ||
1658: l_min_score_tbl(l_criterion_rule_index));
1659: AS_UTILITY_PVT.Debug_Message(
1660: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1661: 'l_min_score=' || l_min_score);
1662: END IF;
1663: l_match_rule_flag := 'Y';
1664: l_matched_rule_index_tbl(l_rule_index) :=

Line 1680: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1676: l_final_cron_rule_id :=
1677: l_criterion_rule_id_tbl(l_criterion_rule_index);
1678: IF (AS_DEBUG_LOW_ON) THEN
1679: AS_UTILITY_PVT.Debug_Message(
1680: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1681: 'l_final_cron_rule_id=' ||
1682: l_final_cron_rule_id);
1683: END IF;
1684: END IF;

Line 1735: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1731: EXIT; -- exit criterion rule
1732: ELSE
1733: IF (AS_DEBUG_LOW_ON) THEN
1734: AS_UTILITY_PVT.Debug_Message(
1735: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1736: 'rule not match');
1737: END IF;
1738: l_entity_rule_applied_id := NULL;
1739: l_matched_rule_index_tbl(l_rule_index) :=

Line 1793: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1789: IF NOT l_match_attribute_flag
1790: THEN
1791: IF (AS_DEBUG_LOW_ON) THEN
1792: AS_UTILITY_PVT.Debug_Message(
1793: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1794: 'no criterion rule match');
1795: END IF;
1796: l_entity_rule_applied_id := NULL;
1797: PV_ENTITY_RULES_APPLIED_PKG.Insert_Row(

Line 1842: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1838: l_rule_index := l_rule_index + 1;
1839: END LOOP; -- for each matched rule
1840: ELSE
1841: IF (AS_DEBUG_LOW_ON) THEN
1842: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1843: 'no rule input filter match');
1844: END IF;
1845: END IF; -- l_process_rule_id_tbl.count > 0
1846:

Line 1848: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1844: END IF;
1845: END IF; -- l_process_rule_id_tbl.count > 0
1846:
1847: IF (AS_DEBUG_LOW_ON) THEN
1848: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1849: 'l_match_rule_flag:' || l_match_rule_flag);
1850: END IF;
1851: IF l_match_rule_flag = 'Y'
1852: THEN

Line 1854: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1850: END IF;
1851: IF l_match_rule_flag = 'Y'
1852: THEN
1853: IF (AS_DEBUG_LOW_ON) THEN
1854: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1855: 'l_final_index:' || l_final_index);
1856: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1857: 'l_final_cron_rule_id:' || l_final_cron_rule_id);
1858: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1856: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1852: THEN
1853: IF (AS_DEBUG_LOW_ON) THEN
1854: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1855: 'l_final_index:' || l_final_index);
1856: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1857: 'l_final_cron_rule_id:' || l_final_cron_rule_id);
1858: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1859: 'final rule id:' || l_process_rule_id_tbl(l_final_index));
1860: END IF;

Line 1858: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1854: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1855: 'l_final_index:' || l_final_index);
1856: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1857: 'l_final_cron_rule_id:' || l_final_cron_rule_id);
1858: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1859: 'final rule id:' || l_process_rule_id_tbl(l_final_index));
1860: END IF;
1861:
1862:

Line 1894: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1890: -- if (p_process_type = 'LEAD_QUALIFICATION') then
1891:
1892: -- l_filter_unqual_leads := FND_PROFILE.value('AS_FILTER_UNQUALIFIED_LEADS');
1893:
1894: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1895: -- 'filterprofile'||l_filter_unqual_leads);
1896:
1897:
1898: -- if ((l_filter_unqual_leads = 'Y') and (l_is_create_import_mode_val='Y') and (l_action_value = 'N')) -- then

Line 1899: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1895: -- 'filterprofile'||l_filter_unqual_leads);
1896:
1897:
1898: -- if ((l_filter_unqual_leads = 'Y') and (l_is_create_import_mode_val='Y') and (l_action_value = 'N')) -- then
1899: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1900: -- 'Match qual case');
1901:
1902: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1903: -- 'Filtering error raised from API');

Line 1902: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1898: -- if ((l_filter_unqual_leads = 'Y') and (l_is_create_import_mode_val='Y') and (l_action_value = 'N')) -- then
1899: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1900: -- 'Match qual case');
1901:
1902: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1903: -- 'Filtering error raised from API');
1904: -- raise AS_SALES_LEADS_PUB.Filter_Exception;
1905: -- end if;
1906: -- end if;

Line 1921: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Just before the outerloop for winning rule value logging');

1917:
1918: l_concat_attribute_value := NULL;
1919: l_concat_attribute_to_value := NULL;
1920:
1921: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Just before the outerloop for winning rule value logging');
1922:
1923: FOR l_enty_select_criteria_val in c_get_enty_select_criteria(l_final_cron_rule_id) LOOP
1924:
1925: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the outerloop for winning rule value logging');

Line 1925: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the outerloop for winning rule value logging');

1921: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Just before the outerloop for winning rule value logging');
1922:
1923: FOR l_enty_select_criteria_val in c_get_enty_select_criteria(l_final_cron_rule_id) LOOP
1924:
1925: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the outerloop for winning rule value logging');
1926:
1927: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'selection_criteria_id ::'||l_enty_select_criteria_val.selection_criteria_id);
1928:
1929: l_concat_attribute_value := NULL;

Line 1927: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'selection_criteria_id ::'||l_enty_select_criteria_val.selection_criteria_id);

1923: FOR l_enty_select_criteria_val in c_get_enty_select_criteria(l_final_cron_rule_id) LOOP
1924:
1925: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the outerloop for winning rule value logging');
1926:
1927: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'selection_criteria_id ::'||l_enty_select_criteria_val.selection_criteria_id);
1928:
1929: l_concat_attribute_value := NULL;
1930: l_concat_attribute_to_value := NULL;
1931:

Line 1933: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the innerloop for winning rule value logging');

1929: l_concat_attribute_value := NULL;
1930: l_concat_attribute_to_value := NULL;
1931:
1932: FOR l_selected_attr_values_val in c_get_selected_attr_values(l_enty_select_criteria_val.selection_criteria_id) LOOP
1933: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the innerloop for winning rule value logging');
1934: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'attr_value_id ::'||l_selected_attr_values_val.attr_value_id);
1935: --if (l_concat_attribute_value IS NULL) then
1936: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'first time');
1937: -- l_concat_attribute_value := l_selected_attr_values_val.attribute_value;

Line 1934: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'attr_value_id ::'||l_selected_attr_values_val.attr_value_id);

1930: l_concat_attribute_to_value := NULL;
1931:
1932: FOR l_selected_attr_values_val in c_get_selected_attr_values(l_enty_select_criteria_val.selection_criteria_id) LOOP
1933: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the innerloop for winning rule value logging');
1934: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'attr_value_id ::'||l_selected_attr_values_val.attr_value_id);
1935: --if (l_concat_attribute_value IS NULL) then
1936: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'first time');
1937: -- l_concat_attribute_value := l_selected_attr_values_val.attribute_value;
1938: --els

Line 1936: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'first time');

1932: FOR l_selected_attr_values_val in c_get_selected_attr_values(l_enty_select_criteria_val.selection_criteria_id) LOOP
1933: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Within the innerloop for winning rule value logging');
1934: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'attr_value_id ::'||l_selected_attr_values_val.attr_value_id);
1935: --if (l_concat_attribute_value IS NULL) then
1936: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'first time');
1937: -- l_concat_attribute_value := l_selected_attr_values_val.attribute_value;
1938: --els
1939:
1940: if (l_selected_attr_values_val.attribute_value IS NOT NULL) then

Line 1951: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'again first time');

1947: end if;
1948:
1949: --next one is relevant only if it is a BETWEEN operator
1950: -- if (l_concat_attribute_value IS NULL) then
1951: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'again first time');
1952:
1953: -- l_concat_attribute_to_value := l_selected_attr_values_val.attribute_to_value;
1954: -- els
1955:

Line 1981: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1977:
1978:
1979: -- at the end of this loop, we have the right values constructed
1980:
1981: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1982: 'These values will be logged : ');
1983: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'entity_rule_applied_id :: ' || l_winning_rule_ent_rule_app_id);
1985: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1983: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1979: -- at the end of this loop, we have the right values constructed
1980:
1981: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1982: 'These values will be logged : ');
1983: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'entity_rule_applied_id :: ' || l_winning_rule_ent_rule_app_id);
1985: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1986: 'attribute_id ::' || l_enty_select_criteria_val.attribute_id);
1987: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1985: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1981: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1982: 'These values will be logged : ');
1983: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'entity_rule_applied_id :: ' || l_winning_rule_ent_rule_app_id);
1985: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1986: 'attribute_id ::' || l_enty_select_criteria_val.attribute_id);
1987: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1988: 'operator :: ' || l_enty_select_criteria_val.operator);
1989: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1987: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1983: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'entity_rule_applied_id :: ' || l_winning_rule_ent_rule_app_id);
1985: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1986: 'attribute_id ::' || l_enty_select_criteria_val.attribute_id);
1987: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1988: 'operator :: ' || l_enty_select_criteria_val.operator);
1989: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1990: 'a_v::' || l_concat_attribute_value);
1991:

Line 1989: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1985: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1986: 'attribute_id ::' || l_enty_select_criteria_val.attribute_id);
1987: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1988: 'operator :: ' || l_enty_select_criteria_val.operator);
1989: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1990: 'a_v::' || l_concat_attribute_value);
1991:
1992: Debug('a_v2::' || l_concat_attribute_value);
1993:

Line 1995: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1991:
1992: Debug('a_v2::' || l_concat_attribute_value);
1993:
1994:
1995: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1996: 'a_t_v::' || l_concat_attribute_to_value);
1997:
1998: Debug('a_t_v2::' || l_concat_attribute_to_value);
1999:

Line 2005: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2001: -- As we are looping through the attributes, we will refer to the
2002: -- l_entity_attr_value_tbl returned by pv_check_match_pub.check_match(,,)
2003: -- This contains the cached attribute value
2004:
2005: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2006: 'PV :: ' || l_entity_attr_value_tbl(l_enty_select_criteria_val.attribute_id).attribute_value);
2007:
2008: Debug('PV again:: ' || l_entity_attr_value_tbl(l_enty_select_criteria_val.attribute_id).attribute_value);
2009:

Line 2036: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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);
2038:
2039: Debug('PV again 510:: ' || l_entity_attr_value_tbl(l_enty_select_criteria_val.attribute_id).attribute_value);
2040:

Line 2158: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2154:
2155: -- Use l_action(l_rule_index) and l_action_value(l_rule_index)
2156: -- to update value
2157: IF (AS_DEBUG_LOW_ON) THEN
2158: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2159: 'act:' || l_action);
2160: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2161: 'act_val:' || l_action_value);
2162: END IF;

Line 2160: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2156: -- to update value
2157: IF (AS_DEBUG_LOW_ON) THEN
2158: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2159: 'act:' || l_action);
2160: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2161: 'act_val:' || l_action_value);
2162: END IF;
2163:
2164: l_cursor := dbms_sql.open_cursor;

Line 2196: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2192: l_default_lead_rank_id :=
2193: TO_NUMBER(FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_RANK'));
2194: l_lead_rank_id := l_default_lead_rank_id;
2195: IF (AS_DEBUG_LOW_ON) THEN
2196: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2197: 'Default rank:' || l_default_lead_rank_id);
2198: END IF;
2199:
2200: IF l_default_lead_rank_id IS NULL

Line 2203: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2199:
2200: IF l_default_lead_rank_id IS NULL
2201: THEN
2202: AS_UTILITY_PVT.Set_Message(
2203: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2204: p_msg_name => 'AS_NO_DEFAULT_RATING');
2205: END IF;
2206:
2207: AS_SALES_LEADS_LOG_PKG.Insert_Row(

Line 2243: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2239: THEN
2240: l_default_channel_code :=
2241: FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_CHANNEL');
2242: IF (AS_DEBUG_LOW_ON) THEN
2243: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2244: 'Default channel:' || l_default_channel_code);
2245: END IF;
2246:
2247: IF l_default_channel_code IS NULL

Line 2250: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2246:
2247: IF l_default_channel_code IS NULL
2248: THEN
2249: AS_UTILITY_PVT.Set_Message(
2250: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2251: p_msg_name => 'AS_NO_DEFAULT_CHANNEL');
2252: END IF;
2253:
2254: UPDATE as_sales_leads

Line 2265: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2261: ELSIF p_process_type = G_LEAD_QUALIFICATION -- qualification case
2262: THEN
2263: l_default_qualified_flag := FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_QUALIFIED_FLAG');
2264: IF (AS_DEBUG_LOW_ON) THEN
2265: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2266: 'Default qualified flag:' || l_default_qualified_flag);
2267: END IF;
2268: IF l_default_qualified_flag IS NULL
2269: THEN

Line 2271: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2267: END IF;
2268: IF l_default_qualified_flag IS NULL
2269: THEN
2270: AS_UTILITY_PVT.Set_Message(
2271: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2272: p_msg_name => 'AS_NO_DEFAULT_QUALIFIED_FLAG');
2273:
2274: l_default_qualified_flag := 'N';
2275: END IF;

Line 2338: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2334: -- l_filter_unqual_leads := FND_PROFILE.value('AS_FILTER_UNQUALIFIED_LEADS');
2335:
2336: -- if ((l_filter_unqual_leads = 'Y') and (l_is_create_import_mode_val='Y') and
2337: -- (l_default_qualified_flag = 'N')) then
2338: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2339: -- 'Default qual case');
2340: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2341: -- 'Filtering error raised from API');
2342: -- raise AS_SALES_LEADS_PUB.Filter_Exception;

Line 2340: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2336: -- if ((l_filter_unqual_leads = 'Y') and (l_is_create_import_mode_val='Y') and
2337: -- (l_default_qualified_flag = 'N')) then
2338: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2339: -- 'Default qual case');
2340: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2341: -- 'Filtering error raised from API');
2342: -- raise AS_SALES_LEADS_PUB.Filter_Exception;
2343: -- end if;
2344: -- end if;

Line 2494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2490:
2491:
2492: -- Debug Message
2493: IF (AS_DEBUG_LOW_ON) THEN
2494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2495: 'PVT: ' || l_api_name || ' End');
2496: END IF;
2497:
2498: -- Standard call to get message count and IF count is 1, get message info.

Line 2499: FND_MSG_PUB.Count_And_Get

2495: 'PVT: ' || l_api_name || ' End');
2496: END IF;
2497:
2498: -- Standard call to get message count and IF count is 1, get message info.
2499: FND_MSG_PUB.Count_And_Get
2500: ( p_count => x_msg_count,
2501: p_data => x_msg_data );
2502:
2503: EXCEPTION

Line 2513: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2514: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2515: ,X_MSG_COUNT => X_MSG_COUNT
2516: ,X_MSG_DATA => X_MSG_DATA
2517: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2523: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2524: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2525: ,X_MSG_COUNT => X_MSG_COUNT
2526: ,X_MSG_DATA => X_MSG_DATA
2527: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2629: FND_MSG_PUB.initialize;

2625:
2626: -- Initialize message list IF p_init_msg_list is set to TRUE.
2627: IF FND_API.to_Boolean( p_init_msg_list )
2628: THEN
2629: FND_MSG_PUB.initialize;
2630: END IF;
2631:
2632: -- Debug Message
2633: IF (AS_DEBUG_LOW_ON) THEN

Line 2634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2630: END IF;
2631:
2632: -- Debug Message
2633: IF (AS_DEBUG_LOW_ON) THEN
2634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2635: 'PVT:' || l_api_name || ' Start');
2636: END IF;
2637:
2638: -- Initialize API return status to SUCCESS

Line 2650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2646: -- ******************************************************************
2647:
2648: IF FND_GLOBAL.User_Id IS NULL
2649: THEN
2650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2651: THEN
2652: AS_UTILITY_PVT.Set_Message(
2653: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2654: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 2653: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2649: THEN
2650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2651: THEN
2652: AS_UTILITY_PVT.Set_Message(
2653: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2654: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2655: p_token1 => 'PROFILE',
2656: p_token1_value => 'USER_ID');
2657: END IF;

Line 2843: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2839: END IF;
2840: END IF;
2841:
2842: IF (AS_DEBUG_LOW_ON) THEN
2843: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2844: 'indirect?' || L_Lead_Engines_Out_Rec.indirect_channel_flag);
2845: END IF;
2846: IF L_Lead_Engines_Out_Rec.indirect_channel_flag = 'Y' AND
2847: L_Lead_Engines_Out_Rec.qualified_flag = 'Y' AND

Line 2920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2916: FETCH C_Get_Open_Status_Flag INTO l_open_status_flag;
2917: CLOSE C_Get_Open_Status_Flag;
2918:
2919: IF (AS_DEBUG_LOW_ON) THEN
2920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2921: 'status_code=' || l_status_code);
2922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2923: 'open status flag=' || l_open_status_flag);
2924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2918:
2919: IF (AS_DEBUG_LOW_ON) THEN
2920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2921: 'status_code=' || l_status_code);
2922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2923: 'open status flag=' || l_open_status_flag);
2924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2925: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
2926: END IF;

Line 2924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2921: 'status_code=' || l_status_code);
2922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2923: 'open status flag=' || l_open_status_flag);
2924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2925: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
2926: END IF;
2927:
2928: IF l_open_status_flag = 'Y' AND l_assign_to_salesforce_id IS NOT NULL

Line 2978: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2974: -- record.
2975: -- DELETE FROM as_changed_accounts_all
2976: -- WHERE sales_lead_id = p_sales_lead_id;
2977: -- IF (AS_DEBUG_LOW_ON) THEN
2978: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2979: -- 'Delete as_changed_accounts_all record');
2980: -- END IF;
2981: -- UPDATE as_changed_accounts_all
2982: -- SET processed_flag = 'Y'

Line 3003: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2999: END IF;
3000:
3001: -- Debug Message
3002: IF (AS_DEBUG_LOW_ON) THEN
3003: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3004: 'PVT: ' || l_api_name || ' End');
3005: END IF;
3006:
3007: -- Standard call to get message count and IF count is 1, get message info.

Line 3010: FND_MSG_PUB.Count_And_Get

3006:
3007: -- Standard call to get message count and IF count is 1, get message info.
3008: IF x_return_status = 'W'
3009: THEN
3010: FND_MSG_PUB.Count_And_Get
3011: (
3012: p_encoded => FND_API.G_FALSE,
3013: p_count => x_msg_count,
3014: p_data => x_msg_data );

Line 3016: FND_MSG_PUB.Count_And_Get

3012: p_encoded => FND_API.G_FALSE,
3013: p_count => x_msg_count,
3014: p_data => x_msg_data );
3015: ELSE
3016: FND_MSG_PUB.Count_And_Get
3017: ( p_count => x_msg_count,
3018: p_data => x_msg_data );
3019: END IF;
3020:

Line 3030: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3026: WHEN FND_API.G_EXC_ERROR THEN
3027: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3028: P_API_NAME => L_API_NAME
3029: ,P_PKG_NAME => G_PKG_NAME
3030: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3031: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3032: ,X_MSG_COUNT => X_MSG_COUNT
3033: ,X_MSG_DATA => X_MSG_DATA
3034: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3040: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3037: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3038: P_API_NAME => L_API_NAME
3039: ,P_PKG_NAME => G_PKG_NAME
3040: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3041: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3042: ,X_MSG_COUNT => X_MSG_COUNT
3043: ,X_MSG_DATA => X_MSG_DATA
3044: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3171: FND_MSG_PUB.initialize;

3167:
3168: -- Initialize message list IF p_init_msg_list is set to TRUE.
3169: IF FND_API.to_Boolean( p_init_msg_list )
3170: THEN
3171: FND_MSG_PUB.initialize;
3172: END IF;
3173:
3174: -- Debug Message
3175: IF (AS_DEBUG_LOW_ON) THEN

Line 3176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3172: END IF;
3173:
3174: -- Debug Message
3175: IF (AS_DEBUG_LOW_ON) THEN
3176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3177: 'PVT:' || l_api_name || ' Start');
3178: END IF;
3179:
3180: -- Initialize API return status to SUCCESS

Line 3192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3188: -- ******************************************************************
3189:
3190: IF FND_GLOBAL.User_Id IS NULL
3191: THEN
3192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3193: THEN
3194: AS_UTILITY_PVT.Set_Message(
3195: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3196: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 3195: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

3191: THEN
3192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3193: THEN
3194: AS_UTILITY_PVT.Set_Message(
3195: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3196: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
3197: p_token1 => 'PROFILE',
3198: p_token1_value => 'USER_ID');
3199: END IF;

Line 3232: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3228:
3229: -- Profile OS: Auto Run Lead Engines While Update
3230: l_auto_run_lead_engines := FND_PROFILE.Value('AS_AUTO_RUN_LEAD_ENGINES');
3231: IF (AS_DEBUG_LOW_ON) THEN
3232: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3233: 'auto run engine=' || l_auto_run_lead_engines);
3234: END IF;
3235: IF NVL(l_auto_run_lead_engines, 'N') = 'Y'
3236: THEN

Line 3306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3302: FETCH c_check_owner_exists INTO l_owner_exists_flag;
3303: CLOSE c_check_owner_exists;
3304:
3305: IF (AS_DEBUG_LOW_ON) THEN
3306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3307: 'assign to=' || l_assign_to_salesforce_id);
3308: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3309: 'reject reason=' || l_reject_reason_code);
3310: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3308: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3304:
3305: IF (AS_DEBUG_LOW_ON) THEN
3306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3307: 'assign to=' || l_assign_to_salesforce_id);
3308: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3309: 'reject reason=' || l_reject_reason_code);
3310: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3311: 'owner exist?' || l_owner_exists_flag);
3312: END IF;

Line 3310: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3307: 'assign to=' || l_assign_to_salesforce_id);
3308: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3309: 'reject reason=' || l_reject_reason_code);
3310: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3311: 'owner exist?' || l_owner_exists_flag);
3312: END IF;
3313: IF l_assign_to_salesforce_id IS NULL OR
3314: l_reject_reason_code IS NOT NULL OR

Line 3419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3415: FETCH C_Get_Open_Status_Flag INTO l_status_code, l_open_status_flag;
3416: CLOSE C_Get_Open_Status_Flag;
3417:
3418: IF (AS_DEBUG_LOW_ON) THEN
3419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3420: 'status=' || l_status_code);
3421: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3422: 'open?' || l_open_status_flag);
3423: END IF;

Line 3421: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3417:
3418: IF (AS_DEBUG_LOW_ON) THEN
3419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3420: 'status=' || l_status_code);
3421: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3422: 'open?' || l_open_status_flag);
3423: END IF;
3424:
3425: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);

Line 3445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3441: l_creation_date_tbl, l_resource_id_tbl, l_rank_id_tbl ;
3442: CLOSE C_Get_Log;
3443:
3444: IF (AS_DEBUG_LOW_ON) AND l_creation_date_tbl.count>=1 THEN
3445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3446: 'count=' || l_creation_date_tbl.count);
3447: END IF;
3448: IF l_creation_date_tbl.count >= 1
3449: THEN

Line 3463: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3459: THEN
3460: -- There's no record inserted for this transaction.
3461: IF (AS_DEBUG_LOW_ON) THEN
3462: AS_UTILITY_PVT.Debug_Message(
3463: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3464: 'same owner, no change');
3465: END IF;
3466: l_owner_changed_flag := 'N';
3467: EXIT;

Line 3474: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3470: THEN
3471: -- User manually sets the owner.
3472: IF (AS_DEBUG_LOW_ON) THEN
3473: AS_UTILITY_PVT.Debug_Message(
3474: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3475: 'different owner');
3476: END IF;
3477: EXIT;
3478: END IF;

Line 3491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3487: END IF;
3488: END IF;
3489:
3490: IF (AS_DEBUG_LOW_ON) THEN
3491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3492: 'open status flag=' || l_open_status_flag);
3493: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3494: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
3495: END IF;

Line 3493: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3489:
3490: IF (AS_DEBUG_LOW_ON) THEN
3491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3492: 'open status flag=' || l_open_status_flag);
3493: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3494: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
3495: END IF;
3496:
3497: -- swkhanna Jun17,03

Line 3509: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3505: l_creation_date_tbl, l_resource_id_tbl, l_rank_id_tbl;
3506: CLOSE C_Get_Log;
3507:
3508: IF (AS_DEBUG_LOW_ON) AND l_creation_date_tbl.count>=1 THEN
3509: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3510: 'count=' || l_creation_date_tbl.count);
3511: END IF;
3512: IF l_creation_date_tbl.count >= 1
3513: THEN

Line 3528: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3524: THEN
3525: -- There's no record inserted for this transaction.
3526: IF (AS_DEBUG_LOW_ON) THEN
3527: AS_UTILITY_PVT.Debug_Message(
3528: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3529: 'same rank, no change');
3530: --dbms_output.put_line('SWKHANNA same rank');
3531: END IF;
3532: l_rank_changed_flag := 'N';

Line 3540: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3536: THEN
3537: -- User manually sets the owner.
3538: IF (AS_DEBUG_LOW_ON) THEN
3539: AS_UTILITY_PVT.Debug_Message(
3540: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3541: 'different rank');
3542: --dbms_output.put_line('SWKHANNA different rank');
3543: END IF;
3544: EXIT;

Line 3618: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3614: -- record.
3615: -- DELETE FROM as_changed_accounts_all
3616: -- WHERE sales_lead_id = p_sales_lead_id;
3617: -- IF (AS_DEBUG_LOW_ON) THEN
3618: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3619: -- 'Delete as_changed_accounts_all record');
3620: -- END IF;
3621: -- END IF;
3622:

Line 3640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3636: END IF;
3637:
3638: -- Debug Message
3639: IF (AS_DEBUG_LOW_ON) THEN
3640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3641: 'PVT: ' || l_api_name || ' End');
3642: END IF;
3643:
3644: -- Standard call to get message count and IF count is 1, get message info.

Line 3647: FND_MSG_PUB.Count_And_Get

3643:
3644: -- Standard call to get message count and IF count is 1, get message info.
3645: IF x_return_status = 'W'
3646: THEN
3647: FND_MSG_PUB.Count_And_Get
3648: (
3649: p_encoded => FND_API.G_FALSE,
3650: p_count => x_msg_count,
3651: p_data => x_msg_data );

Line 3653: FND_MSG_PUB.Count_And_Get

3649: p_encoded => FND_API.G_FALSE,
3650: p_count => x_msg_count,
3651: p_data => x_msg_data );
3652: ELSE
3653: FND_MSG_PUB.Count_And_Get
3654: ( p_count => x_msg_count,
3655: p_data => x_msg_data );
3656: END IF;
3657:

Line 3667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3663: WHEN FND_API.G_EXC_ERROR THEN
3664: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3665: P_API_NAME => L_API_NAME
3666: ,P_PKG_NAME => G_PKG_NAME
3667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3668: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3669: ,X_MSG_COUNT => X_MSG_COUNT
3670: ,X_MSG_DATA => X_MSG_DATA
3671: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3677: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3674: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3675: P_API_NAME => L_API_NAME
3676: ,P_PKG_NAME => G_PKG_NAME
3677: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3678: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3679: ,X_MSG_COUNT => X_MSG_COUNT
3680: ,X_MSG_DATA => X_MSG_DATA
3681: ,X_RETURN_STATUS => X_RETURN_STATUS);