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.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on FND_MSG_PUB

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

151: AND Nvl(p_end_date, l_end_of_time) <=
152: Nvl(end_date, l_end_of_time);
153:
154: IF l_count = 0 THEN
155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
156: THEN
157: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');
158: FND_MSG_PUB.Add;
159: END IF;

Line 158: FND_MSG_PUB.Add;

154: IF l_count = 0 THEN
155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
156: THEN
157: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');
158: FND_MSG_PUB.Add;
159: END IF;
160: x_loading_status := 'CN_PAYEE_DATE_INVALID';
161: RAISE FND_API.G_EXC_ERROR ;
162: END IF;

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

172: AND Nvl(p_end_date, l_end_of_time) <=
173: Nvl(end_date, l_end_of_time);
174:
175: IF l_count = 0 THEN
176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
177: THEN
178: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');
179: FND_MSG_PUB.Add;
180: END IF;

Line 179: FND_MSG_PUB.Add;

175: IF l_count = 0 THEN
176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
177: THEN
178: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');
179: FND_MSG_PUB.Add;
180: END IF;
181: x_loading_status := 'CN_PAYEE_DATE_INVALID';
182: RAISE FND_API.G_EXC_ERROR ;
183: END IF;

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

195: Nvl(p_end_date, l_end_of_time));
196:
197: IF l_count > 0 then
198: --payee dates overlap
199: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
200: THEN
201: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_OVERLAP');
202: FND_MSG_PUB.Add;
203: END IF;

Line 202: FND_MSG_PUB.Add;

198: --payee dates overlap
199: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
200: THEN
201: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_OVERLAP');
202: FND_MSG_PUB.Add;
203: END IF;
204: x_loading_status := 'CN_PAYEE_DATE_OVERLAP';
205: RAISE FND_API.G_EXC_ERROR ;
206: end if;

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

276: (end_date_active IS NULL AND p_end_date IS NOT NULL ) OR
277: (end_date_active >= p_end_date));
278:
279: IF l_count = 0 THEN
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_NOT_ACTIVE' );
283: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
284: FND_MESSAGE.SET_TOKEN('PAYEE_NUMBER',l_emp_num);

Line 285: FND_MSG_PUB.Add;

281: THEN
282: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_NOT_ACTIVE' );
283: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
284: FND_MESSAGE.SET_TOKEN('PAYEE_NUMBER',l_emp_num);
285: FND_MSG_PUB.Add;
286: END IF;
287: x_loading_status := 'CN_PAYEE_NOT_ACTIVE';
288: RAISE FND_API.G_EXC_ERROR ;
289: END IF;

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

292: -- Check salesrep and Payee are different, if not error
293: --+
294: IF p_payee_id = p_salesrep_id THEN
295:
296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
297: THEN
298: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAYEE_CANNOT_BE_SAME' );
299: FND_MSG_PUB.Add;
300: END IF;

Line 299: FND_MSG_PUB.Add;

295:
296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
297: THEN
298: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAYEE_CANNOT_BE_SAME' );
299: FND_MSG_PUB.Add;
300: END IF;
301: x_loading_status := 'CN_SRP_PAYEE_CANNOT_BE_SAME';
302: RAISE FND_API.G_EXC_ERROR ;
303: END IF;

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

305: --+
306: -- Validate End Date must be greater than Start Date
307: --+
308: IF p_end_date IS NOT NULL AND p_end_date < p_start_date THEN
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
310: THEN
311: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');
312: FND_MSG_PUB.Add;
313: END IF;

Line 312: FND_MSG_PUB.Add;

308: IF p_end_date IS NOT NULL AND p_end_date < p_start_date THEN
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
310: THEN
311: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');
312: FND_MSG_PUB.Add;
313: END IF;
314: x_loading_status := 'CN_INVALID_DATE_RANGE';
315: RAISE FND_API.G_EXC_ERROR ;
316: END IF;

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

322: WHERE sqa.srp_quota_assign_id = p_srp_quota_assign_id
323: AND q.quota_id = sqa.quota_id;
324:
325: IF Nvl(l_payee_assign_flag,'N') <> 'Y' THEN
326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
327: THEN
328: -- get salesrep name
329: SELECT name
330: INTO l_srp_name

Line 338: FND_MSG_PUB.Add;

334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');
335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);
336: FND_MESSAGE.SET_TOKEN('SALESREP_NAME', l_srp_name);
337: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
338: FND_MSG_PUB.Add;
339: END IF;
340: x_loading_status := 'CN_CANNOT_HAVE_PAYEE';
341: RAISE FND_API.G_EXC_ERROR ;
342: END IF;

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

352: end if;
353: end loop;
354:
355: if l_daycount <> (l_end_date - p_start_date + 1) then
356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
357: THEN
358: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_PG_NOT_FOUND');
359: FND_MSG_PUB.Add;
360: END IF;

Line 359: FND_MSG_PUB.Add;

355: if l_daycount <> (l_end_date - p_start_date + 1) then
356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
357: THEN
358: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_PG_NOT_FOUND');
359: FND_MSG_PUB.Add;
360: END IF;
361: x_loading_status := 'CN_PAYEE_PG_NOT_FOUND';
362: RAISE FND_API.G_EXC_ERROR ;
363: end if;

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

373: end if;
374: end loop;
375:
376: if l_daycount <> (l_end_date - p_start_date + 1) then
377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_ROLE_NOT_FOUND');
380: FND_MSG_PUB.Add;
381: END IF;

Line 380: FND_MSG_PUB.Add;

376: if l_daycount <> (l_end_date - p_start_date + 1) then
377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_ROLE_NOT_FOUND');
380: FND_MSG_PUB.Add;
381: END IF;
382: x_loading_status := 'CN_PAYEE_ROLE_NOT_FOUND';
383: RAISE FND_API.G_EXC_ERROR ;
384: end if;

Line 505: FND_MSG_PUB.initialize;

501: END IF;
502: --+
503: -- Initialize message list if p_init_msg_list is set to TRUE.
504: IF FND_API.to_Boolean( p_init_msg_list ) THEN
505: FND_MSG_PUB.initialize;
506: END IF;
507: --+
508: -- Initialize API return status to success
509: --+

Line 618: FND_MSG_PUB.Count_And_Get

614: END IF;
615: --+
616: -- Standard call to get message count and if count is 1, get message info.
617: --+
618: FND_MSG_PUB.Count_And_Get
619: (
620: p_count => x_msg_count ,
621: p_data => x_msg_data ,
622: p_encoded => FND_API.G_FALSE

Line 629: FND_MSG_PUB.Count_And_Get

625:
626: WHEN FND_API.G_EXC_ERROR THEN
627: ROLLBACK TO create_srp_payee_assigns;
628: x_return_status := FND_API.G_RET_STS_ERROR ;
629: FND_MSG_PUB.Count_And_Get
630: (
631: p_count => x_msg_count ,
632: p_data => x_msg_data ,
633: p_encoded => FND_API.G_FALSE

Line 639: FND_MSG_PUB.Count_And_Get

635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO create_srp_payee_assigns;
637: x_loading_status := 'UNEXPECTED_ERR';
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: FND_MSG_PUB.Count_And_Get
640: (
641: p_count => x_msg_count ,
642: p_data => x_msg_data ,
643: p_encoded => FND_API.G_FALSE

Line 649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

645: WHEN OTHERS THEN
646: ROLLBACK TO Create_srp_payee_assigns;
647: x_loading_status := 'UNEXPECTED_ERR';
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
652: END IF;
653: FND_MSG_PUB.Count_And_Get

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

647: x_loading_status := 'UNEXPECTED_ERR';
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
652: END IF;
653: FND_MSG_PUB.Count_And_Get
654: (
655: p_count => x_msg_count ,

Line 653: FND_MSG_PUB.Count_And_Get

649: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
652: END IF;
653: FND_MSG_PUB.Count_And_Get
654: (
655: p_count => x_msg_count ,
656: p_data => x_msg_data ,
657: p_encoded => FND_API.G_FALSE

Line 739: FND_MSG_PUB.initialize;

735: END IF;
736:
737: -- Initialize message list if p_init_msg_list is set to TRUE.
738: IF FND_API.to_Boolean( p_init_msg_list ) THEN
739: FND_MSG_PUB.initialize;
740: END IF;
741:
742: -- Initialize API return status to success
743:

Line 756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

752: IF l_old_rec.object_version_number <> p_object_version_number THEN
753: --
754: --Raise an error if the object_version numbers don't match
755: --
756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
757: THEN
758: fnd_message.set_name('CN', 'CN_RECORD_UPDATED');
759: fnd_msg_pub.add;
760: END IF;

Line 759: fnd_msg_pub.add;

755: --
756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
757: THEN
758: fnd_message.set_name('CN', 'CN_RECORD_UPDATED');
759: fnd_msg_pub.add;
760: END IF;
761: x_loading_status := 'CN_RECORD_UPDATED';
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;

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

803: (l_date_range_action_tbl(d).start_date,
804: l_date_range_action_tbl(d).end_date,
805: w.start_date,
806: w.end_date) = true then
807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
808: THEN
809: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');
810: FND_MSG_PUB.Add;
811: END IF;

Line 810: FND_MSG_PUB.Add;

806: w.end_date) = true then
807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
808: THEN
809: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');
810: FND_MSG_PUB.Add;
811: END IF;
812: x_loading_status := 'CN_PAYEE_HAS_WKSHT';
813: RAISE FND_API.G_EXC_ERROR ;
814: END IF; -- ck date range overlap

Line 922: FND_MSG_PUB.Count_And_Get

918: END IF;
919: --+
920: -- Standard call to get message count and if count is 1, get message info.
921: --+
922: FND_MSG_PUB.Count_And_Get
923: (
924: p_count => x_msg_count ,
925: p_data => x_msg_data ,
926: p_encoded => FND_API.G_FALSE

Line 932: FND_MSG_PUB.Count_And_Get

928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: ROLLBACK TO update_srp_payee_assigns;
931: x_return_status := FND_API.G_RET_STS_ERROR ;
932: FND_MSG_PUB.Count_And_Get
933: (
934: p_count => x_msg_count ,
935: p_data => x_msg_data ,
936: p_encoded => FND_API.G_FALSE

Line 942: FND_MSG_PUB.Count_And_Get

938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: ROLLBACK TO update_srp_payee_assigns;
940: x_loading_status := 'UNEXPECTED_ERR';
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: FND_MSG_PUB.Count_And_Get
943: (
944: p_count => x_msg_count ,
945: p_data => x_msg_data ,
946: p_encoded => FND_API.G_FALSE

Line 952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

948: WHEN OTHERS THEN
949: ROLLBACK TO Update_srp_payee_assigns;
950: x_loading_status := 'UNEXPECTED_ERR';
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
953: THEN
954: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
955: END IF;
956: FND_MSG_PUB.Count_And_Get

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

950: x_loading_status := 'UNEXPECTED_ERR';
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
953: THEN
954: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
955: END IF;
956: FND_MSG_PUB.Count_And_Get
957: (
958: p_count => x_msg_count ,

Line 956: FND_MSG_PUB.Count_And_Get

952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
953: THEN
954: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
955: END IF;
956: FND_MSG_PUB.Count_And_Get
957: (
958: p_count => x_msg_count ,
959: p_data => x_msg_data ,
960: p_encoded => FND_API.G_FALSE

Line 1001: FND_MSG_PUB.initialize;

997:
998: BEGIN
999: -- Initialize message list if p_init_msg_list is set to TRUE.
1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: -- Initialize API return status to success
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1016: (l_start_date,
1017: l_end_date,
1018: w.start_date,
1019: w.end_date) = true THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1021: THEN
1022: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');
1023: FND_MSG_PUB.Add;
1024: END IF;

Line 1023: FND_MSG_PUB.Add;

1019: w.end_date) = true THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1021: THEN
1022: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');
1023: FND_MSG_PUB.Add;
1024: END IF;
1025: x_loading_status := 'CN_PAYEE_HAS_WKSHT';
1026: RAISE FND_API.G_EXC_ERROR ;
1027: END IF;

Line 1033: FND_MSG_PUB.Count_And_Get

1029:
1030: EXCEPTION
1031: WHEN FND_API.G_EXC_ERROR THEN
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033: FND_MSG_PUB.Count_And_Get
1034: (
1035: p_count => x_msg_count ,
1036: p_data => x_msg_data ,
1037: p_encoded => FND_API.G_FALSE

Line 1042: FND_MSG_PUB.Count_And_Get

1038: );
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: x_loading_status := 'UNEXPECTED_ERR';
1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1042: FND_MSG_PUB.Count_And_Get
1043: (
1044: p_count => x_msg_count ,
1045: p_data => x_msg_data ,
1046: p_encoded => FND_API.G_FALSE

Line 1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1047: );
1048: WHEN OTHERS THEN
1049: x_loading_status := 'UNEXPECTED_ERR';
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1054: END IF;
1055: FND_MSG_PUB.Count_And_Get

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

1049: x_loading_status := 'UNEXPECTED_ERR';
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1054: END IF;
1055: FND_MSG_PUB.Count_And_Get
1056: (
1057: p_count => x_msg_count ,

Line 1055: FND_MSG_PUB.Count_And_Get

1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1054: END IF;
1055: FND_MSG_PUB.Count_And_Get
1056: (
1057: p_count => x_msg_count ,
1058: p_data => x_msg_data ,
1059: p_encoded => FND_API.G_FALSE

Line 1111: FND_MSG_PUB.initialize;

1107: END IF;
1108:
1109: -- Initialize message list if p_init_msg_list is set to TRUE.
1110: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1111: FND_MSG_PUB.initialize;
1112: END IF;
1113:
1114: -- Initialize API return status to success
1115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1186: FND_MSG_PUB.Count_And_Get

1182: END IF;
1183: --+
1184: -- Standard call to get message count and if count is 1, get message info.
1185: --+
1186: FND_MSG_PUB.Count_And_Get
1187: (
1188: p_count => x_msg_count ,
1189: p_data => x_msg_data ,
1190: p_encoded => FND_API.G_FALSE

Line 1196: FND_MSG_PUB.Count_And_Get

1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO Delete_srp_payee_assigns;
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: FND_MSG_PUB.Count_And_Get
1197: (
1198: p_count => x_msg_count ,
1199: p_data => x_msg_data ,
1200: p_encoded => FND_API.G_FALSE

Line 1206: FND_MSG_PUB.Count_And_Get

1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO Delete_srp_payee_assigns;
1204: x_loading_status := 'UNEXPECTED_ERR';
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1206: FND_MSG_PUB.Count_And_Get
1207: (
1208: p_count => x_msg_count ,
1209: p_data => x_msg_data ,
1210: p_encoded => FND_API.G_FALSE

Line 1216: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1212: WHEN OTHERS THEN
1213: ROLLBACK TO delete_srp_payee_assigns;
1214: x_loading_status := 'UNEXPECTED_ERR';
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1216: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1219: END IF;
1220: FND_MSG_PUB.Count_And_Get

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

1214: x_loading_status := 'UNEXPECTED_ERR';
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1216: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1219: END IF;
1220: FND_MSG_PUB.Count_And_Get
1221: (
1222: p_count => x_msg_count ,

Line 1220: FND_MSG_PUB.Count_And_Get

1216: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1219: END IF;
1220: FND_MSG_PUB.Count_And_Get
1221: (
1222: p_count => x_msg_count ,
1223: p_data => x_msg_data ,
1224: p_encoded => FND_API.G_FALSE