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_RANKS_PVT dependencies on AS_UTILITY_PVT

Line 85: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

81: or (l_count > 1)
82: THEN
83: IF (AS_DEBUG_LOW_ON) THEN
84:
85: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
86: 'Score range overlay: '||
87: p_sales_lead_rank_rec.min_score || '-' ||
88: p_sales_lead_rank_rec.max_score);
89: END IF;

Line 93: AS_UTILITY_PVT.Set_Message(

89: END IF;
90:
91: IF p_is_old_engine = 'Y'
92: THEN
93: AS_UTILITY_PVT.Set_Message(
94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
95: p_msg_name => 'ASF_RANKSCORE_OVERLAP',
96: p_token1 => 'MEANING',
97: p_token1_value => p_sales_lead_rank_rec.meaning);

Line 99: AS_UTILITY_PVT.Set_Message(

95: p_msg_name => 'ASF_RANKSCORE_OVERLAP',
96: p_token1 => 'MEANING',
97: p_token1_value => p_sales_lead_rank_rec.meaning);
98: ELSE
99: AS_UTILITY_PVT.Set_Message(
100: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
101: p_msg_name => 'AS_PREC_RANKSCORE_OVERLAP',
102: p_token1 => 'MEANING',
103: p_token1_value => p_sales_lead_rank_rec.meaning);

Line 159: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

155: IF nvl(p_sales_lead_rank_rec.rank_id,0) <> l_rank_id
156: THEN
157: IF (AS_DEBUG_LOW_ON) THEN
158:
159: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
160: 'Duplicate rank : '|| p_sales_lead_rank_rec.meaning);
161: END IF;
162:
163: AS_UTILITY_PVT.Set_Message(

Line 163: AS_UTILITY_PVT.Set_Message(

159: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
160: 'Duplicate rank : '|| p_sales_lead_rank_rec.meaning);
161: END IF;
162:
163: AS_UTILITY_PVT.Set_Message(
164: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
165: p_msg_name => 'ASF_DUPLICATE_RANK',
166: p_token1 => 'MEANING',
167: p_token1_value => p_sales_lead_rank_rec.meaning);

Line 215: AS_UTILITY_PVT.Set_Message(

211:
212: -- validate NOT NULL column
213: IF(p_PRECEDENCE is NULL OR p_PRECEDENCE = FND_API.G_MISS_NUM)
214: THEN
215: AS_UTILITY_PVT.Set_Message(
216: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
217: p_msg_name => 'API_MISSING_ID',
218: p_token1 => 'PRECEDENCE',
219: p_token1_value => p_PRECEDENCE);

Line 224: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;
222:
223:
224: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
225: THEN
226: -- Hint: Validate data
227: -- IF p_PRECEDENCE is not NULL and p_PRECEDENCE <> G_MISS_CHAR
228: -- verify if data is valid

Line 236: AS_UTILITY_PVT.Set_Message(

232: FETCH C_Get_Rating INTO l_sales_lead_rank_id;
233:
234: IF C_Get_Rating%FOUND
235: THEN
236: AS_UTILITY_PVT.Set_Message(
237: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
238: p_msg_name => 'AS_DUPE_PRECEDENCE');
239:
240: x_return_status := FND_API.G_RET_STS_ERROR;

Line 244: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

240: x_return_status := FND_API.G_RET_STS_ERROR;
241: END IF;
242: CLOSE C_Get_Rating;
243:
244: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
245: THEN
246: -- Hint: Validate data
247: -- IF p_PRECEDENCE <> G_MISS_CHAR
248: -- verify if data is valid

Line 257: AS_UTILITY_PVT.Set_Message(

253:
254: IF C_Get_Rating%FOUND
255: THEN
256: IF (l_sales_lead_rank_id <> p_sales_lead_rank_id) THEN
257: AS_UTILITY_PVT.Set_Message(
258: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
259: p_msg_name => 'AS_DUPE_PRECEDENCE');
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;

Line 314: IF (p_validation_mode = AS_UTILITY_PVT.G_UPDATE) THEN

310:
311:
312: l_default_profile := to_number( nvl(fnd_profile.value('AS_DEFAULT_LEAD_ENGINE_RANK'), '-1'));
313:
314: IF (p_validation_mode = AS_UTILITY_PVT.G_UPDATE) THEN
315:
316: -- first check if profile is using this rating
317: if (p_sales_lead_rank_id = l_default_profile) then
318: AS_UTILITY_PVT.Set_Message(

Line 318: AS_UTILITY_PVT.Set_Message(

314: IF (p_validation_mode = AS_UTILITY_PVT.G_UPDATE) THEN
315:
316: -- first check if profile is using this rating
317: if (p_sales_lead_rank_id = l_default_profile) then
318: AS_UTILITY_PVT.Set_Message(
319: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
320: p_msg_name => 'AS_USED_RANK');
321:
322: --x_return_status := FND_API.G_RET_STS_ERROR;

Line 336: AS_UTILITY_PVT.Set_Message(

332:
333:
334: IF C_Get_Lead_Using_Rank%FOUND
335: THEN
336: AS_UTILITY_PVT.Set_Message(
337: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
338: p_msg_name => 'AS_USED_RANK');
339: CLOSE C_Get_Lead_Using_Rank;
340: raise FND_API.G_EXC_ERROR;

Line 356: AS_UTILITY_PVT.Set_Message(

352: CLOSE lc_rule_cursor;
353:
354: if (l_dummy = 1)
355: then
356: AS_UTILITY_PVT.Set_Message(
357: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
358: p_msg_name => 'AS_USED_RANK');
359:
360: raise FND_API.G_EXC_ERROR;

Line 476: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

472: IF l_is_old_engine = 'N'
473: THEN
474: Validate_PRECEDENCE(
475: p_init_msg_list => FND_API.G_FALSE,
476: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
477: p_PRECEDENCE => P_SALES_LEAD_RANK_Rec.MIN_SCORE,
478: p_SALES_LEAD_RANK_ID => -1,
479: x_return_status => x_return_status,
480: x_msg_count => x_msg_count,

Line 492: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

488: /*
489: -- Check score range
490: Validate_Score_Range (
491: P_Init_Msg_List => FND_API.G_FALSE,
492: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
493: p_sales_lead_rank_rec => l_sales_lead_rank_rec,
494: p_is_old_engine => l_is_old_engine,
495: X_Return_Status => x_return_status,
496: X_Msg_Count => x_msg_count,

Line 510: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

506:
507: -- Check duplicate rank
508: Validate_Rank_Meaning (
509: P_Init_Msg_List => FND_API.G_FALSE,
510: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
511: p_sales_lead_rank_rec => l_sales_lead_rank_rec,
512: X_Return_Status => x_return_status,
513: X_Msg_Count => x_msg_count,
514: X_Msg_Data => x_msg_data

Line 713: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

709: IF l_is_old_engine = 'N'
710: THEN
711: Validate_PRECEDENCE(
712: p_init_msg_list => FND_API.G_FALSE,
713: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
714: p_PRECEDENCE => P_SALES_LEAD_RANK_Rec.MIN_SCORE,
715: p_sales_lead_rank_id => P_SALES_LEAD_RANK_Rec.RANK_ID,
716: x_return_status => x_return_status,
717: x_msg_count => x_msg_count,

Line 728: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

724: /*
725: -- Check score range
726: Validate_Score_Range (
727: P_Init_Msg_List => FND_API.G_FALSE,
728: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
729: p_sales_lead_rank_rec => l_sales_lead_rank_rec,
730: p_is_old_engine => l_is_old_engine,
731: X_Return_Status => x_return_status,
732: X_Msg_Count => x_msg_count,

Line 746: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

742: -- Check duplicate rank only when meaning is passed in
743: IF p_sales_lead_rank_rec.meaning is not null THEN
744: Validate_Rank_Meaning (
745: P_Init_Msg_List => FND_API.G_FALSE,
746: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
747: p_sales_lead_rank_rec => p_sales_lead_rank_rec,
748: X_Return_Status => x_return_status,
749: X_Msg_Count => x_msg_count,
750: X_Msg_Data => x_msg_data

Line 763: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

759: -- Cannot disable a rank if used by profile or by a lead
760: IF (l_enabled_flag = 'Y' and p_sales_lead_rank_rec.enabled_flag <> 'Y') THEN
761: Validate_USED_RANK(
762: P_Init_Msg_List => FND_API.G_FALSE,
763: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
764: p_sales_lead_rank_id => p_sales_lead_rank_rec.rank_id,
765: X_Return_Status => x_return_status,
766: X_Msg_Count => x_msg_count,
767: X_Msg_Data => x_msg_data

Line 918: AS_UTILITY_PVT.Set_Message(

914: --Validate if seeded rank. If seeded, it should be locked. User delete
915: -- not allowed. A good check for seeded rank is that rank_id < 10000
916:
917: if (l_sales_lead_rank_id < 10000) then
918: AS_UTILITY_PVT.Set_Message(
919: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
920: p_msg_name => 'AS_SEEDED_RANK');
921:
922: raise FND_API.G_EXC_ERROR;

Line 935: AS_UTILITY_PVT.Set_Message(

931:
932:
933: IF C_Get_Lead_Using_Rank%FOUND
934: THEN
935: AS_UTILITY_PVT.Set_Message(
936: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
937: p_msg_name => 'AS_USED_RANK');
938:
939: CLOSE C_Get_Lead_Using_Rank;

Line 950: AS_UTILITY_PVT.Set_Message(

946: l_default_profile := to_number( nvl(fnd_profile.value('AS_DEFAULT_LEAD_ENGINE_RANK'), '-1'));
947:
948:
949: if (l_sales_lead_rank_id = l_default_profile) then
950: AS_UTILITY_PVT.Set_Message(
951: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
952: p_msg_name => 'AS_USED_RANK');
953:
954: raise FND_API.G_EXC_ERROR;

Line 969: AS_UTILITY_PVT.Set_Message(

965: CLOSE lc_rule_cursor;
966:
967: if (l_dummy2= 1)
968: then
969: AS_UTILITY_PVT.Set_Message(
970: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
971: p_msg_name => 'AS_USED_RANK');
972:
973: raise FND_API.G_EXC_ERROR;