[Home] [Help]
99:
100: -- clku fix for bug 3234665
101:
102: IF (new_start_date <> old_start_date) OR
103: Nvl(old_end_date,fnd_api.g_miss_date) <>
104: Nvl(new_end_date,fnd_api.g_miss_date)
105: THEN
106: cn_mark_events_pkg.mark_event_srp_payee_assign
107: ('CHANGE_SRP_QUOTA_PAYEE_DATE',
100: -- clku fix for bug 3234665
101:
102: IF (new_start_date <> old_start_date) OR
103: Nvl(old_end_date,fnd_api.g_miss_date) <>
104: Nvl(new_end_date,fnd_api.g_miss_date)
105: THEN
106: cn_mark_events_pkg.mark_event_srp_payee_assign
107: ('CHANGE_SRP_QUOTA_PAYEE_DATE',
108: x_salesrep_name,
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;
163:
164: -- make sure payee assignment falls within a valid plan assignment
165: -- fix for bug 4507995
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;
184:
185: --check whether the payee's date overlap with the dates of
186: --other payee who is already assigned
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;
207:
208: END Validate_Payee_Dates;
209:
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;
290:
291: --+
292: -- Check salesrep and Payee are different, if not error
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;
304:
305: --+
306: -- Validate End Date must be greater than Start Date
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;
317:
318: -- Check wheather the payee can be assigned to this plan Element
319: SELECT payee_assign_flag, q.name, q.quota_id
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;
343:
344: -- ** bug 3143462
345: -- check to make sure pay group is assigned over whole interval
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;
364:
365:
366: -- make sure payee isn't assigned longer than the payee has payee role
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;
385:
386: --+
387: -- Start of Payee Assigns Check
491: SAVEPOINT Create_Srp_Payee_Assigns;
492: --+
493: -- Standard call to check for call compatibility.
494: --+
495: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
496: p_api_version ,
497: l_api_name ,
498: G_PKG_NAME )
499: THEN
496: p_api_version ,
497: l_api_name ,
498: G_PKG_NAME )
499: THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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
506: END IF;
507: --+
508: -- Initialize API return status to success
509: --+
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511: x_loading_status := 'CN_INSERTED';
512:
513: --+
514: -- Start API body
570: x_msg_data => x_msg_data,
571: x_loading_status => x_loading_status
572: );
573:
574: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
575: RAISE FND_API.G_EXC_ERROR;
576: end if;
577:
578: -- add note for srp_quota_assigns
571: x_loading_status => x_loading_status
572: );
573:
574: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
575: RAISE FND_API.G_EXC_ERROR;
576: end if;
577:
578: -- add note for srp_quota_assigns
579: SELECT name INTO l_payee_name
608:
609: --+
610: -- Issue the Commit and recreate the Save Point.
611: --+
612: IF FND_API.To_Boolean( p_commit ) THEN
613: COMMIT WORK;
614: END IF;
615: --+
616: -- Standard call to get message count and if count is 1, get message info.
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
623: );
624: EXCEPTION
625:
626: WHEN FND_API.G_EXC_ERROR THEN
622: p_encoded => FND_API.G_FALSE
623: );
624: EXCEPTION
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: (
624: EXCEPTION
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 ,
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
634: );
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO create_srp_payee_assigns;
637: x_loading_status := 'UNEXPECTED_ERR';
631: p_count => x_msg_count ,
632: p_data => x_msg_data ,
633: p_encoded => FND_API.G_FALSE
634: );
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
634: );
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 ,
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
644: );
645: WHEN OTHERS THEN
646: ROLLBACK TO Create_srp_payee_assigns;
647: x_loading_status := 'UNEXPECTED_ERR';
644: );
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
654: (
655: p_count => x_msg_count ,
656: p_data => x_msg_data ,
657: p_encoded => FND_API.G_FALSE
658: );
659: END create_srp_payee_assigns;
660:
661:
725: -- Standard Start of API savepoint
726: SAVEPOINT update_srp_payee_assigns;
727:
728: -- Standard call to check for call compatibility.
729: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
730: p_api_version ,
731: l_api_name ,
732: G_PKG_NAME )
733: THEN
730: p_api_version ,
731: l_api_name ,
732: G_PKG_NAME )
733: THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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
740: END IF;
741:
742: -- Initialize API return status to success
743:
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745: x_loading_status := 'CN_UPDATED';
746:
747: -- API body
748: OPEN get_old_payee_rec(p_srp_payee_assign_id);
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;
764:
765: -- get properties from given srp_quota_assign_id
766: SELECT spa.comp_plan_id
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
815: end loop; -- get_worksheets
816: end if; -- if action = D
817: end loop; -- date range loop
873: x_msg_count => x_msg_count,
874: x_msg_data => x_msg_data,
875: x_loading_status => x_loading_status
876: );
877: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
878: RAISE FND_API.G_EXC_ERROR;
879: end if;
880:
881: -- add note for srp_payee_assigns
874: x_msg_data => x_msg_data,
875: x_loading_status => x_loading_status
876: );
877: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
878: RAISE FND_API.G_EXC_ERROR;
879: end if;
880:
881: -- add note for srp_payee_assigns
882: l_notemsg := NULL;
894: END IF;
895: IF (l_old_rec.start_date <> p_start_date) THEN
896: get_note('START_DATE', l_old_rec.start_date, p_start_date, l_notemsg);
897: END IF;
898: IF (Nvl(l_old_rec.end_date,fnd_api.g_miss_date) <>
899: Nvl(p_end_date, fnd_api.g_miss_date)) THEN
900: get_note('END_DATE', l_old_rec.end_date, p_end_date, l_notemsg);
901: END IF;
902:
895: IF (l_old_rec.start_date <> p_start_date) THEN
896: get_note('START_DATE', l_old_rec.start_date, p_start_date, l_notemsg);
897: END IF;
898: IF (Nvl(l_old_rec.end_date,fnd_api.g_miss_date) <>
899: Nvl(p_end_date, fnd_api.g_miss_date)) THEN
900: get_note('END_DATE', l_old_rec.end_date, p_end_date, l_notemsg);
901: END IF;
902:
903: IF (l_notemsg IS NOT NULL) THEN
912:
913: --+
914: -- Issue the Commit and recreate the Save Point.
915: --+
916: IF FND_API.To_Boolean( p_commit ) THEN
917: COMMIT WORK;
918: END IF;
919: --+
920: -- Standard call to get message count and if count is 1, get message info.
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
927: );
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: ROLLBACK TO update_srp_payee_assigns;
925: p_data => x_msg_data ,
926: p_encoded => FND_API.G_FALSE
927: );
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: (
927: );
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 ,
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
937: );
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: ROLLBACK TO update_srp_payee_assigns;
940: x_loading_status := 'UNEXPECTED_ERR';
934: p_count => x_msg_count ,
935: p_data => x_msg_data ,
936: p_encoded => FND_API.G_FALSE
937: );
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
937: );
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 ,
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
947: );
948: WHEN OTHERS THEN
949: ROLLBACK TO Update_srp_payee_assigns;
950: x_loading_status := 'UNEXPECTED_ERR';
947: );
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
957: (
958: p_count => x_msg_count ,
959: p_data => x_msg_data ,
960: p_encoded => FND_API.G_FALSE
961: );
962:
963: END Update_Srp_Payee_Assigns ;
964:
996: AND spa.org_id = l_org_id;
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
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;
1006: x_loading_status := 'CN_DELETED';
1007:
1008: SELECT start_date, end_date, org_id
1009: INTO l_start_date, l_end_date, l_org_id
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;
1028: END LOOP;
1029:
1030: EXCEPTION
1027: END IF;
1028: END LOOP;
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 ,
1028: END LOOP;
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 ,
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
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 ;
1035: p_count => x_msg_count ,
1036: p_data => x_msg_data ,
1037: p_encoded => FND_API.G_FALSE
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: (
1037: p_encoded => FND_API.G_FALSE
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 ,
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
1047: );
1048: WHEN OTHERS THEN
1049: x_loading_status := 'UNEXPECTED_ERR';
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1046: p_encoded => FND_API.G_FALSE
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
1056: (
1057: p_count => x_msg_count ,
1058: p_data => x_msg_data ,
1059: p_encoded => FND_API.G_FALSE
1060: );
1061:
1062: END valid_delete_srp_payee_assigns;
1063:
1097: -- Standard Start of API savepoint
1098: SAVEPOINT delete_srp_payee_assigns;
1099:
1100: -- Standard call to check for call compatibility.
1101: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1102: p_api_version ,
1103: l_api_name ,
1104: G_PKG_NAME )
1105: THEN
1102: p_api_version ,
1103: l_api_name ,
1104: G_PKG_NAME )
1105: THEN
1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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
1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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
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;
1116: x_loading_status := 'CN_DELETED';
1117:
1118: --+
1119: -- API body
1127: x_msg_data => x_msg_data,
1128: p_srp_payee_assign_id => p_srp_payee_assign_id,
1129: x_loading_status => x_loading_status);
1130:
1131: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1132: RAISE fnd_api.g_exc_error;
1133: END IF;
1134:
1135: -- get info for trigger
1128: p_srp_payee_assign_id => p_srp_payee_assign_id,
1129: x_loading_status => x_loading_status);
1130:
1131: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1132: RAISE fnd_api.g_exc_error;
1133: END IF;
1134:
1135: -- get info for trigger
1136: SELECT salesrep_id, srp_quota_assign_id, start_date, end_date, org_id, payee_id
1176:
1177: --+
1178: -- Issue the Commit and recreate the Save Point.
1179: --+
1180: IF FND_API.To_Boolean( p_commit ) THEN
1181: COMMIT WORK;
1182: END IF;
1183: --+
1184: -- Standard call to get message count and if count is 1, get message info.
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
1191: );
1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO Delete_srp_payee_assigns;
1189: p_data => x_msg_data ,
1190: p_encoded => FND_API.G_FALSE
1191: );
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: (
1191: );
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 ,
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
1201: );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO Delete_srp_payee_assigns;
1204: x_loading_status := 'UNEXPECTED_ERR';
1198: p_count => x_msg_count ,
1199: p_data => x_msg_data ,
1200: p_encoded => FND_API.G_FALSE
1201: );
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
1201: );
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 ,
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
1211: );
1212: WHEN OTHERS THEN
1213: ROLLBACK TO delete_srp_payee_assigns;
1214: x_loading_status := 'UNEXPECTED_ERR';
1211: );
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
1221: (
1222: p_count => x_msg_count ,
1223: p_data => x_msg_data ,
1224: p_encoded => FND_API.G_FALSE
1225: );
1226: END Delete_Srp_Payee_Assigns;
1227:
1228: END CN_SRP_PAYEE_ASSIGNS_PVT;