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 2612: FND_MSG_PUB.initialize;

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

Line 2617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2613: END IF;
2614:
2615: -- Debug Message
2616: IF (AS_DEBUG_LOW_ON) THEN
2617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2618: 'PVT:' || l_api_name || ' Start');
2619: END IF;
2620:
2621: -- Initialize API return status to SUCCESS

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

2629: -- ******************************************************************
2630:
2631: IF FND_GLOBAL.User_Id IS NULL
2632: THEN
2633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2634: THEN
2635: AS_UTILITY_PVT.Set_Message(
2636: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2637: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 2636: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2632: THEN
2633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2634: THEN
2635: AS_UTILITY_PVT.Set_Message(
2636: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2637: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2638: p_token1 => 'PROFILE',
2639: p_token1_value => 'USER_ID');
2640: END IF;

Line 2789: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2785: END IF;
2786: END IF;
2787:
2788: IF (AS_DEBUG_LOW_ON) THEN
2789: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2790: 'indirect?' || L_Lead_Engines_Out_Rec.indirect_channel_flag);
2791: END IF;
2792: IF L_Lead_Engines_Out_Rec.indirect_channel_flag = 'Y' AND
2793: L_Lead_Engines_Out_Rec.qualified_flag = 'Y' AND

Line 2866: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2862: FETCH C_Get_Open_Status_Flag INTO l_open_status_flag;
2863: CLOSE C_Get_Open_Status_Flag;
2864:
2865: IF (AS_DEBUG_LOW_ON) THEN
2866: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2867: 'status_code=' || l_status_code);
2868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2869: 'open status flag=' || l_open_status_flag);
2870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2864:
2865: IF (AS_DEBUG_LOW_ON) THEN
2866: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2867: 'status_code=' || l_status_code);
2868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2869: 'open status flag=' || l_open_status_flag);
2870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2871: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
2872: END IF;

Line 2870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2866: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2867: 'status_code=' || l_status_code);
2868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2869: 'open status flag=' || l_open_status_flag);
2870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2871: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
2872: END IF;
2873:
2874: IF l_open_status_flag = 'Y' AND l_assign_to_salesforce_id IS NOT NULL

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

2920: -- record.
2921: -- DELETE FROM as_changed_accounts_all
2922: -- WHERE sales_lead_id = p_sales_lead_id;
2923: -- IF (AS_DEBUG_LOW_ON) THEN
2924: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2925: -- 'Delete as_changed_accounts_all record');
2926: -- END IF;
2927: -- UPDATE as_changed_accounts_all
2928: -- SET processed_flag = 'Y'

Line 2949: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2945: END IF;
2946:
2947: -- Debug Message
2948: IF (AS_DEBUG_LOW_ON) THEN
2949: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2950: 'PVT: ' || l_api_name || ' End');
2951: END IF;
2952:
2953: -- Standard call to get message count and IF count is 1, get message info.

Line 2956: FND_MSG_PUB.Count_And_Get

2952:
2953: -- Standard call to get message count and IF count is 1, get message info.
2954: IF x_return_status = 'W'
2955: THEN
2956: FND_MSG_PUB.Count_And_Get
2957: (
2958: p_encoded => FND_API.G_FALSE,
2959: p_count => x_msg_count,
2960: p_data => x_msg_data );

Line 2962: FND_MSG_PUB.Count_And_Get

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
2963: ( p_count => x_msg_count,
2964: p_data => x_msg_data );
2965: END IF;
2966:

Line 2976: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2977: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2978: ,X_MSG_COUNT => X_MSG_COUNT
2979: ,X_MSG_DATA => X_MSG_DATA
2980: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2986: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2987: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2988: ,X_MSG_COUNT => X_MSG_COUNT
2989: ,X_MSG_DATA => X_MSG_DATA
2990: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3117: FND_MSG_PUB.initialize;

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

Line 3122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3118: END IF;
3119:
3120: -- Debug Message
3121: IF (AS_DEBUG_LOW_ON) THEN
3122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3123: 'PVT:' || l_api_name || ' Start');
3124: END IF;
3125:
3126: -- Initialize API return status to SUCCESS

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

3134: -- ******************************************************************
3135:
3136: IF FND_GLOBAL.User_Id IS NULL
3137: THEN
3138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3139: THEN
3140: AS_UTILITY_PVT.Set_Message(
3141: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3142: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 3141: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

3137: THEN
3138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3139: THEN
3140: AS_UTILITY_PVT.Set_Message(
3141: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3142: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
3143: p_token1 => 'PROFILE',
3144: p_token1_value => 'USER_ID');
3145: END IF;

Line 3178: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3174:
3175: -- Profile OS: Auto Run Lead Engines While Update
3176: l_auto_run_lead_engines := FND_PROFILE.Value('AS_AUTO_RUN_LEAD_ENGINES');
3177: IF (AS_DEBUG_LOW_ON) THEN
3178: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3179: 'auto run engine=' || l_auto_run_lead_engines);
3180: END IF;
3181: IF NVL(l_auto_run_lead_engines, 'N') = 'Y'
3182: THEN

Line 3252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3248: FETCH c_check_owner_exists INTO l_owner_exists_flag;
3249: CLOSE c_check_owner_exists;
3250:
3251: IF (AS_DEBUG_LOW_ON) THEN
3252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3253: 'assign to=' || l_assign_to_salesforce_id);
3254: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3255: 'reject reason=' || l_reject_reason_code);
3256: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3254: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3250:
3251: IF (AS_DEBUG_LOW_ON) THEN
3252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3253: 'assign to=' || l_assign_to_salesforce_id);
3254: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3255: 'reject reason=' || l_reject_reason_code);
3256: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3257: 'owner exist?' || l_owner_exists_flag);
3258: END IF;

Line 3256: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3253: 'assign to=' || l_assign_to_salesforce_id);
3254: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3255: 'reject reason=' || l_reject_reason_code);
3256: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3257: 'owner exist?' || l_owner_exists_flag);
3258: END IF;
3259: IF l_assign_to_salesforce_id IS NULL OR
3260: l_reject_reason_code IS NOT NULL OR

Line 3365: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3361: FETCH C_Get_Open_Status_Flag INTO l_status_code, l_open_status_flag;
3362: CLOSE C_Get_Open_Status_Flag;
3363:
3364: IF (AS_DEBUG_LOW_ON) THEN
3365: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3366: 'status=' || l_status_code);
3367: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3368: 'open?' || l_open_status_flag);
3369: END IF;

Line 3367: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3363:
3364: IF (AS_DEBUG_LOW_ON) THEN
3365: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3366: 'status=' || l_status_code);
3367: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3368: 'open?' || l_open_status_flag);
3369: END IF;
3370:
3371: OPEN C_Get_Lead_Info(P_Sales_Lead_Id);

Line 3391: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3387: l_creation_date_tbl, l_resource_id_tbl, l_rank_id_tbl ;
3388: CLOSE C_Get_Log;
3389:
3390: IF (AS_DEBUG_LOW_ON) AND l_creation_date_tbl.count>=1 THEN
3391: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3392: 'count=' || l_creation_date_tbl.count);
3393: END IF;
3394: IF l_creation_date_tbl.count >= 1
3395: THEN

Line 3409: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3405: THEN
3406: -- There's no record inserted for this transaction.
3407: IF (AS_DEBUG_LOW_ON) THEN
3408: AS_UTILITY_PVT.Debug_Message(
3409: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3410: 'same owner, no change');
3411: END IF;
3412: l_owner_changed_flag := 'N';
3413: EXIT;

Line 3420: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3416: THEN
3417: -- User manually sets the owner.
3418: IF (AS_DEBUG_LOW_ON) THEN
3419: AS_UTILITY_PVT.Debug_Message(
3420: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3421: 'different owner');
3422: END IF;
3423: EXIT;
3424: END IF;

Line 3437: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3433: END IF;
3434: END IF;
3435:
3436: IF (AS_DEBUG_LOW_ON) THEN
3437: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3438: 'open status flag=' || l_open_status_flag);
3439: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3440: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
3441: END IF;

Line 3439: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3435:
3436: IF (AS_DEBUG_LOW_ON) THEN
3437: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3438: 'open status flag=' || l_open_status_flag);
3439: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3440: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
3441: END IF;
3442:
3443: -- swkhanna Jun17,03

Line 3455: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3451: l_creation_date_tbl, l_resource_id_tbl, l_rank_id_tbl;
3452: CLOSE C_Get_Log;
3453:
3454: IF (AS_DEBUG_LOW_ON) AND l_creation_date_tbl.count>=1 THEN
3455: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3456: 'count=' || l_creation_date_tbl.count);
3457: END IF;
3458: IF l_creation_date_tbl.count >= 1
3459: THEN

Line 3474: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3470: THEN
3471: -- There's no record inserted for this transaction.
3472: IF (AS_DEBUG_LOW_ON) THEN
3473: AS_UTILITY_PVT.Debug_Message(
3474: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3475: 'same rank, no change');
3476: --dbms_output.put_line('SWKHANNA same rank');
3477: END IF;
3478: l_rank_changed_flag := 'N';

Line 3486: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3482: THEN
3483: -- User manually sets the owner.
3484: IF (AS_DEBUG_LOW_ON) THEN
3485: AS_UTILITY_PVT.Debug_Message(
3486: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3487: 'different rank');
3488: --dbms_output.put_line('SWKHANNA different rank');
3489: END IF;
3490: EXIT;

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

3560: -- record.
3561: -- DELETE FROM as_changed_accounts_all
3562: -- WHERE sales_lead_id = p_sales_lead_id;
3563: -- IF (AS_DEBUG_LOW_ON) THEN
3564: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3565: -- 'Delete as_changed_accounts_all record');
3566: -- END IF;
3567: -- END IF;
3568:

Line 3586: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3582: END IF;
3583:
3584: -- Debug Message
3585: IF (AS_DEBUG_LOW_ON) THEN
3586: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3587: 'PVT: ' || l_api_name || ' End');
3588: END IF;
3589:
3590: -- Standard call to get message count and IF count is 1, get message info.

Line 3593: FND_MSG_PUB.Count_And_Get

3589:
3590: -- Standard call to get message count and IF count is 1, get message info.
3591: IF x_return_status = 'W'
3592: THEN
3593: FND_MSG_PUB.Count_And_Get
3594: (
3595: p_encoded => FND_API.G_FALSE,
3596: p_count => x_msg_count,
3597: p_data => x_msg_data );

Line 3599: FND_MSG_PUB.Count_And_Get

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
3600: ( p_count => x_msg_count,
3601: p_data => x_msg_data );
3602: END IF;
3603:

Line 3613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3614: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3615: ,X_MSG_COUNT => X_MSG_COUNT
3616: ,X_MSG_DATA => X_MSG_DATA
3617: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
3624: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3625: ,X_MSG_COUNT => X_MSG_COUNT
3626: ,X_MSG_DATA => X_MSG_DATA
3627: ,X_RETURN_STATUS => X_RETURN_STATUS);