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 FND_MSG_PUB

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

17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
18: G_VERSION_NUM NUMBER := 1.0;
19: */
20:
21: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
25:

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

18: G_VERSION_NUM NUMBER := 1.0;
19: */
20:
21: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
25:
26: PROCEDURE Validate_Score_Range (

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

19: */
20:
21: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
25:
26: PROCEDURE Validate_Score_Range (
27: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

20:
21: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
25:
26: PROCEDURE Validate_Score_Range (
27: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
28: P_Validation_mode IN VARCHAR2,

Line 57: FND_MSG_PUB.initialize;

53: BEGIN
54: -- Initialize message list IF p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list )
56: THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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);
98: ELSE

Line 100: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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);
104: END IF;

Line 112: FND_MSG_PUB.Count_And_Get

108: CLOSE C_Get_Ranks;
109: END IF;
110:
111: -- Standard call to get message count and IF count is 1, get message info.
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data );
115:
116: END Validate_Score_Range;

Line 141: FND_MSG_PUB.initialize;

137: BEGIN
138: -- Initialize message list IF p_init_msg_list is set to TRUE.
139: IF FND_API.to_Boolean( p_init_msg_list )
140: THEN
141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: -- Initialize API return status to SUCCESS
145: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 164: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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);
168:

Line 175: FND_MSG_PUB.Count_And_Get

171: END IF;
172: CLOSE C_Get_Meaning;
173: END IF;
174: -- Standard call to get message count and IF count is 1, get message info.
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
177: p_data => x_msg_data );
178:
179: END Validate_Rank_Meaning;

Line 205: FND_MSG_PUB.initialize;

201:
202: -- Initialize message list if p_init_msg_list is set to TRUE.
203: IF FND_API.to_Boolean( p_init_msg_list )
204: THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207:
208:
209: -- Initialize API return status to SUCCESS

Line 216: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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);
220: x_return_status := FND_API.G_RET_STS_ERROR;

Line 237: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
241: END IF;

Line 258: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
262:

Line 271: FND_MSG_PUB.Count_And_Get

267:
268: END IF;
269:
270: -- Standard call to get message count and if count is 1, get message info.
271: FND_MSG_PUB.Count_And_Get
272: ( p_count => x_msg_count,
273: p_data => x_msg_data
274: );
275:

Line 304: FND_MSG_PUB.initialize;

300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.to_Boolean( p_init_msg_list )
303: THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306:
307:
308: -- Initialize API return status to SUCCESS

Line 319: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
323: raise FND_API.G_EXC_ERROR;

Line 337: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
341: END IF;

Line 357: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
361: end if;

Line 368: FND_MSG_PUB.Count_And_Get

364: END IF;
365:
366:
367: -- Standard call to get message count and if count is 1, get message info.
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,
370: p_data => x_msg_data
371: );
372:

Line 423: FND_MSG_PUB.initialize;

419: END IF;
420:
421: -- Initialize message list if p_init_msg_list is set to TRUE
422: IF FND_API.To_Boolean(p_init_msg_list) THEN
423: FND_MSG_PUB.initialize;
424: END IF;
425:
426: -- Initialize API return status to success
427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 437: FND_MSG_PUB.Add;

433: CLOSE c1;
434: --dbms_output.put_line('duplicate found ');
435: FND_MESSAGE.SET_NAME('AS', 'AS_DUPE_RANK');
436: -- Add message to API message list
437: FND_MSG_PUB.Add;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: CLOSE c1;
441:

Line 557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

553: COMMIT WORK;
554: END IF;
555:
556: -- Standard call to get message count and if count is 1, get message info
557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
558:
559: EXCEPTION
560:
561: WHEN FND_API.G_EXC_ERROR THEN

Line 564: FND_MSG_PUB.Count_And_Get(

560:
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO Create_Rank_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: FND_MSG_PUB.Count_And_Get(
565: p_count => x_msg_count,
566: p_data => x_msg_data);
567:
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 571: FND_MSG_PUB.Count_And_Get(

567:
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: ROLLBACK TO Create_Rank_PVT;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get(
572: p_count => x_msg_count,
573: p_data => x_msg_data);
574:
575: WHEN OTHERS THEN

Line 578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

574:
575: WHEN OTHERS THEN
576: ROLLBACK TO Create_Rank_PVT;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
579: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
580: END IF;
581: FND_MSG_PUB.Count_And_Get(
582: p_count => x_msg_count,

Line 579: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

575: WHEN OTHERS THEN
576: ROLLBACK TO Create_Rank_PVT;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
579: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
580: END IF;
581: FND_MSG_PUB.Count_And_Get(
582: p_count => x_msg_count,
583: p_data => x_msg_data);

Line 581: FND_MSG_PUB.Count_And_Get(

577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
579: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
580: END IF;
581: FND_MSG_PUB.Count_And_Get(
582: p_count => x_msg_count,
583: p_data => x_msg_data);
584: END Create_Rank;
585:

Line 633: FND_MSG_PUB.initialize;

629: END IF;
630:
631: -- Initialize message list if p_init_msg_list is set to TRUE
632: IF FND_API.To_Boolean(p_init_msg_list) THEN
633: FND_MSG_PUB.initialize;
634: END IF;
635:
636: l_sales_lead_rank_rec := p_sales_lead_rank_rec;
637:

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

650: -- 120400 ffang, Check Whether record has been changed by someone else
651: IF (p_sales_lead_rank_rec.last_update_date is NULL or
652: p_sales_lead_rank_rec.last_update_date = FND_API.G_MISS_Date )
653: THEN
654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN
656: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
657: FND_MESSAGE.Set_Token('COLUMN', 'LAST_UPDATE_DATE', FALSE);
658: FND_MSG_PUB.ADD;

Line 658: FND_MSG_PUB.ADD;

654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN
656: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
657: FND_MESSAGE.Set_Token('COLUMN', 'LAST_UPDATE_DATE', FALSE);
658: FND_MSG_PUB.ADD;
659: END IF;
660: raise FND_API.G_EXC_ERROR;
661: END IF;
662:

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

662:
663: OPEN c_get_last_update;
664: FETCH c_get_last_update into l_last_update_date;
665: IF (c_get_last_update%NOTFOUND) THEN
666: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
667: THEN
668: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
669: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_RANK', FALSE);
670: FND_MSG_PUB.Add;

Line 670: FND_MSG_PUB.Add;

666: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
667: THEN
668: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
669: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_RANK', FALSE);
670: FND_MSG_PUB.Add;
671: END IF;
672: CLOSE c_get_last_update;
673:
674: raise FND_API.G_EXC_ERROR;

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

676: CLOSE c_get_last_update;
677:
678: IF (p_sales_lead_rank_rec.last_update_date <> l_last_update_date)
679: THEN
680: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
681: THEN
682: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
683: FND_MESSAGE.Set_Token('INFO', 'SALES_LEAD', FALSE);
684: FND_MSG_PUB.ADD;

Line 684: FND_MSG_PUB.ADD;

680: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
681: THEN
682: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
683: FND_MESSAGE.Set_Token('INFO', 'SALES_LEAD', FALSE);
684: FND_MSG_PUB.ADD;
685: END IF;
686: raise FND_API.G_EXC_ERROR;
687: END IF;
688:

Line 812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

808: COMMIT WORK;
809: END IF;
810:
811: -- Standard call to get message count and if count is 1, get message info
812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
813:
814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO Update_Rank_PVT;

Line 818: FND_MSG_PUB.Count_And_Get(

814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO Update_Rank_PVT;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get(
819: p_count => x_msg_count,
820: p_data => x_msg_data);
821:
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 825: FND_MSG_PUB.Count_And_Get(

821:
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: ROLLBACK TO Update_Rank_PVT;
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: FND_MSG_PUB.Count_And_Get(
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:
829: WHEN OTHERS THEN

Line 832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

828:
829: WHEN OTHERS THEN
830: ROLLBACK TO Update_Rank_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: END IF;
835: FND_MSG_PUB.Count_And_Get(
836: p_count => x_msg_count,

Line 833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

829: WHEN OTHERS THEN
830: ROLLBACK TO Update_Rank_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: END IF;
835: FND_MSG_PUB.Count_And_Get(
836: p_count => x_msg_count,
837: p_data => x_msg_data);

Line 835: FND_MSG_PUB.Count_And_Get(

831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: END IF;
835: FND_MSG_PUB.Count_And_Get(
836: p_count => x_msg_count,
837: p_data => x_msg_data);
838: END Update_Rank;
839:

Line 889: FND_MSG_PUB.initialize;

885: END IF;
886:
887: -- Initialize message list if p_init_msg_list is set to TRUE
888: IF FND_API.To_Boolean(p_init_msg_list) THEN
889: FND_MSG_PUB.initialize;
890: END IF;
891:
892: l_sales_lead_rank_id := p_sales_lead_rank_id;
893:

Line 894: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

890: END IF;
891:
892: l_sales_lead_rank_id := p_sales_lead_rank_id;
893:
894: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
895:
896:
897:
898: -- Initialize API return status to success

Line 919: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
923: end if;

Line 936: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
940: raise FND_API.G_EXC_ERROR;

Line 951: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
955:

Line 970: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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;
974: end if;

Line 990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

986: COMMIT WORK;
987: END IF;
988:
989: -- Standard call to get message count and if count is 1, get message info
990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
991:
992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO Delete_Rank_PVT;

Line 996: FND_MSG_PUB.Count_And_Get(

992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO Delete_Rank_PVT;
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: FND_MSG_PUB.Count_And_Get(
997: p_count => x_msg_count,
998: p_data => x_msg_data);
999:
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1003: FND_MSG_PUB.Count_And_Get(

999:
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1001: ROLLBACK TO Delete_Rank_PVT;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get(
1004: p_count => x_msg_count,
1005: p_data => x_msg_data);
1006:
1007: WHEN OTHERS THEN

Line 1010: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1006:
1007: WHEN OTHERS THEN
1008: ROLLBACK TO Delete_Rank_PVT;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get(
1014: p_count => x_msg_count,

Line 1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1007: WHEN OTHERS THEN
1008: ROLLBACK TO Delete_Rank_PVT;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get(
1014: p_count => x_msg_count,
1015: p_data => x_msg_data);

Line 1013: FND_MSG_PUB.Count_And_Get(

1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get(
1014: p_count => x_msg_count,
1015: p_data => x_msg_data);
1016: END DELETE_RANK;
1017: