100: -- Close the cursor and raise an error if the group ID could not be
101: -- selected from the sequence.
102: CLOSE partyidcur;
103:
104: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
105: fnd_message.set_token('SEQUENCE', 'hz_party_val_gt_s');
106: fnd_msg_pub.add;
107: RAISE fnd_api.g_exc_error;
108: END IF;
101: -- selected from the sequence.
102: CLOSE partyidcur;
103:
104: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
105: fnd_message.set_token('SEQUENCE', 'hz_party_val_gt_s');
106: fnd_msg_pub.add;
107: RAISE fnd_api.g_exc_error;
108: END IF;
109: CLOSE partyidcur;
231: -- Close the cursor and raise an error if the relationship ID
232: -- could not be selected from the sequence.
233: CLOSE relidcur;
234:
235: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
236: fnd_message.set_token('SEQUENCE', 'hz_relationship_val_gt_s');
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_error;
239: END IF;
232: -- could not be selected from the sequence.
233: CLOSE relidcur;
234:
235: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
236: fnd_message.set_token('SEQUENCE', 'hz_relationship_val_gt_s');
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_error;
239: END IF;
240: CLOSE relidcur;
357: l_procedure_name := fnd_profile.value(x_profile_name);
358:
359: -- raise an error if no value is set for the profile option.
360: IF l_procedure_name IS NULL THEN
361: fnd_message.set_name('AR', 'HZ_DV_NULL_PROFILE_VALUE');
362: fnd_message.set_token('PROFILE', x_profile_name);
363: fnd_msg_pub.add;
364: RAISE hz_dyn_validation.null_profile_value;
365: END IF;
358:
359: -- raise an error if no value is set for the profile option.
360: IF l_procedure_name IS NULL THEN
361: fnd_message.set_name('AR', 'HZ_DV_NULL_PROFILE_VALUE');
362: fnd_message.set_token('PROFILE', x_profile_name);
363: fnd_msg_pub.add;
364: RAISE hz_dyn_validation.null_profile_value;
365: END IF;
366:
393: EXCEPTION
394: -- Catch instances where the procedure specified in the profile option
395: -- has not been defined in the database.
396: WHEN compile_error THEN
397: fnd_message.set_name('AR', 'HZ_DV_EXEC_ERROR');
398: fnd_message.set_token('PROCEDURE', l_procedure_name);
399: fnd_message.set_token('ERRM', SQLERRM);
400: fnd_msg_pub.add;
401: RAISE hz_dyn_validation.execution_error;
394: -- Catch instances where the procedure specified in the profile option
395: -- has not been defined in the database.
396: WHEN compile_error THEN
397: fnd_message.set_name('AR', 'HZ_DV_EXEC_ERROR');
398: fnd_message.set_token('PROCEDURE', l_procedure_name);
399: fnd_message.set_token('ERRM', SQLERRM);
400: fnd_msg_pub.add;
401: RAISE hz_dyn_validation.execution_error;
402:
395: -- has not been defined in the database.
396: WHEN compile_error THEN
397: fnd_message.set_name('AR', 'HZ_DV_EXEC_ERROR');
398: fnd_message.set_token('PROCEDURE', l_procedure_name);
399: fnd_message.set_token('ERRM', SQLERRM);
400: fnd_msg_pub.add;
401: RAISE hz_dyn_validation.execution_error;
402:
403: END exec_procedure;
440: -- Raise an error if it is not an "allowed" profile option.
441: IF x_validation_profile <> 'HZ_BANK_VALIDATION_PROCEDURE'
442: AND x_validation_profile <> 'HZ_BANK_BRANCH_VALIDATION_PROCEDURE'
443: THEN
444: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
445: fnd_message.set_token('PROFILE', x_validation_profile);
446: fnd_msg_pub.add;
447: RAISE hz_dyn_validation.invalid_profile_option;
448: END IF;
441: IF x_validation_profile <> 'HZ_BANK_VALIDATION_PROCEDURE'
442: AND x_validation_profile <> 'HZ_BANK_BRANCH_VALIDATION_PROCEDURE'
443: THEN
444: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
445: fnd_message.set_token('PROFILE', x_validation_profile);
446: fnd_msg_pub.add;
447: RAISE hz_dyn_validation.invalid_profile_option;
448: END IF;
449:
460: -- Close the cursor and raise an error if the group ID could not be
461: -- selected from the sequence.
462: CLOSE orgidcur;
463:
464: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
465: fnd_message.set_token('SEQUENCE', 'hz_org_profile_val_gt_s');
466: fnd_msg_pub.add;
467: RAISE fnd_api.g_exc_error;
468: END IF;
461: -- selected from the sequence.
462: CLOSE orgidcur;
463:
464: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
465: fnd_message.set_token('SEQUENCE', 'hz_org_profile_val_gt_s');
466: fnd_msg_pub.add;
467: RAISE fnd_api.g_exc_error;
468: END IF;
469: CLOSE orgidcur;
791: -- Check the profile option name.
792: -- Raise an error if it is not an "allowed" profile option.
793: IF x_validation_profile <> 'HZ_BANKING_GROUP_VALIDATION_PROCEDURE'
794: THEN
795: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
796: fnd_message.set_token('PROFILE', x_validation_profile);
797: fnd_msg_pub.add;
798: RAISE hz_dyn_validation.invalid_profile_option;
799: END IF;
792: -- Raise an error if it is not an "allowed" profile option.
793: IF x_validation_profile <> 'HZ_BANKING_GROUP_VALIDATION_PROCEDURE'
794: THEN
795: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
796: fnd_message.set_token('PROFILE', x_validation_profile);
797: fnd_msg_pub.add;
798: RAISE hz_dyn_validation.invalid_profile_option;
799: END IF;
800:
812: -- Close the cursor and raise an error if the group ID could not be
813: -- selected from the sequence.
814: CLOSE grpidcur;
815:
816: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
817: fnd_message.set_token('SEQUENCE', 'hz_group_val_gt_s');
818: fnd_msg_pub.add;
819: RAISE fnd_api.g_exc_error;
820: END IF;
813: -- selected from the sequence.
814: CLOSE grpidcur;
815:
816: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
817: fnd_message.set_token('SEQUENCE', 'hz_group_val_gt_s');
818: fnd_msg_pub.add;
819: RAISE fnd_api.g_exc_error;
820: END IF;
821:
877: IF x_validation_profile NOT IN
878: ('HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE',
879: 'HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE')
880: THEN
881: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
882: fnd_message.set_token('PROFILE', x_validation_profile);
883: fnd_msg_pub.add;
884: RAISE hz_dyn_validation.invalid_profile_option;
885: END IF;
878: ('HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE',
879: 'HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE')
880: THEN
881: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
882: fnd_message.set_token('PROFILE', x_validation_profile);
883: fnd_msg_pub.add;
884: RAISE hz_dyn_validation.invalid_profile_option;
885: END IF;
886:
930: -- Raise an error if it is not an "allowed" profile option.
931: IF x_validation_profile <> 'HZ_BANK_BRANCH_CONTACT_VALIDATION_PROCEDURE'
932: AND x_validation_profile <> 'HZ_BANK_CONTACT_VALIDATION_PROCEDURE'
933: THEN
934: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
935: fnd_message.set_token('PROFILE', x_validation_profile);
936: fnd_msg_pub.add;
937: RAISE hz_dyn_validation.invalid_profile_option;
938: END IF;
931: IF x_validation_profile <> 'HZ_BANK_BRANCH_CONTACT_VALIDATION_PROCEDURE'
932: AND x_validation_profile <> 'HZ_BANK_CONTACT_VALIDATION_PROCEDURE'
933: THEN
934: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
935: fnd_message.set_token('PROFILE', x_validation_profile);
936: fnd_msg_pub.add;
937: RAISE hz_dyn_validation.invalid_profile_option;
938: END IF;
939:
952: -- Close the cursor and raise an error if the org_contact ID could not
953: -- be selected from the sequence.
954: CLOSE ocidcur;
955:
956: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
957: fnd_message.set_token('SEQUENCE', 'hz_contact_val_gt_s');
958: fnd_msg_pub.add;
959: RAISE fnd_api.g_exc_error;
960: END IF;
953: -- be selected from the sequence.
954: CLOSE ocidcur;
955:
956: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
957: fnd_message.set_token('SEQUENCE', 'hz_contact_val_gt_s');
958: fnd_msg_pub.add;
959: RAISE fnd_api.g_exc_error;
960: END IF;
961: CLOSE ocidcur;
1080: -- Raise an error if it is not an "allowed" profile option.
1081: IF x_validation_profile <> 'HZ_BANK_BRANCH_SITE_VALIDATION_PROCEDURE'
1082: AND x_validation_profile <> 'HZ_BANK_SITE_VALIDATION_PROCEDURE'
1083: THEN
1084: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
1085: fnd_message.set_token('PROFILE', x_validation_profile);
1086: fnd_msg_pub.add;
1087: RAISE hz_dyn_validation.invalid_profile_option;
1088: END IF;
1081: IF x_validation_profile <> 'HZ_BANK_BRANCH_SITE_VALIDATION_PROCEDURE'
1082: AND x_validation_profile <> 'HZ_BANK_SITE_VALIDATION_PROCEDURE'
1083: THEN
1084: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
1085: fnd_message.set_token('PROFILE', x_validation_profile);
1086: fnd_msg_pub.add;
1087: RAISE hz_dyn_validation.invalid_profile_option;
1088: END IF;
1089:
1098: -- Close the cursor and raise an error if the party_site ID could not
1099: -- be selected from the sequence.
1100: CLOSE psidcur;
1101:
1102: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1103: fnd_message.set_token('SEQUENCE', 'hz_party_site_val_gt_s');
1104: fnd_msg_pub.add;
1105: RAISE fnd_api.g_exc_error;
1106: END IF;
1099: -- be selected from the sequence.
1100: CLOSE psidcur;
1101:
1102: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1103: fnd_message.set_token('SEQUENCE', 'hz_party_site_val_gt_s');
1104: fnd_msg_pub.add;
1105: RAISE fnd_api.g_exc_error;
1106: END IF;
1107: CLOSE psidcur;
1220: -- Raise an error if it is not an "allowed" profile option.
1221: IF x_validation_profile <> 'HZ_BANK_BRANCH_LOCATION_VALIDATION_PROCEDURE'
1222: AND x_validation_profile <> 'HZ_BANK_LOCATION_VALIDATION_PROCEDURE'
1223: THEN
1224: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
1225: fnd_message.set_token('PROFILE', x_validation_profile);
1226: fnd_msg_pub.add;
1227: RAISE hz_dyn_validation.invalid_profile_option;
1228: END IF;
1221: IF x_validation_profile <> 'HZ_BANK_BRANCH_LOCATION_VALIDATION_PROCEDURE'
1222: AND x_validation_profile <> 'HZ_BANK_LOCATION_VALIDATION_PROCEDURE'
1223: THEN
1224: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
1225: fnd_message.set_token('PROFILE', x_validation_profile);
1226: fnd_msg_pub.add;
1227: RAISE hz_dyn_validation.invalid_profile_option;
1228: END IF;
1229:
1238: -- Close the cursor and raise an error if the location ID could not be
1239: -- selected from the sequence.
1240: CLOSE locidcur;
1241:
1242: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1243: fnd_message.set_token('SEQUENCE', 'hz_location_val_gt_s');
1244: fnd_msg_pub.add;
1245: RAISE fnd_api.g_exc_error;
1246: END IF;
1239: -- selected from the sequence.
1240: CLOSE locidcur;
1241:
1242: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1243: fnd_message.set_token('SEQUENCE', 'hz_location_val_gt_s');
1244: fnd_msg_pub.add;
1245: RAISE fnd_api.g_exc_error;
1246: END IF;
1247: CLOSE locidcur;
1420: -- Raise an error if it is not an "allowed" profile option.
1421: IF x_validation_profile <> 'HZ_BANK_BRANCH_CONTACT_POINT_VALIDATION_PROCEDURE'
1422: AND x_validation_profile <> 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
1423: THEN
1424: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
1425: fnd_message.set_token('PROFILE', x_validation_profile);
1426: fnd_msg_pub.add;
1427: RAISE hz_dyn_validation.invalid_profile_option;
1428: END IF;
1421: IF x_validation_profile <> 'HZ_BANK_BRANCH_CONTACT_POINT_VALIDATION_PROCEDURE'
1422: AND x_validation_profile <> 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
1423: THEN
1424: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');
1425: fnd_message.set_token('PROFILE', x_validation_profile);
1426: fnd_msg_pub.add;
1427: RAISE hz_dyn_validation.invalid_profile_option;
1428: END IF;
1429:
1438: -- Close the cursor and raise an error if the contact point ID could
1439: -- not be selected from the sequence.
1440: CLOSE psidcur;
1441:
1442: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1443: fnd_message.set_token('SEQUENCE', 'hz_contact_point_val_gt_s');
1444: fnd_msg_pub.add;
1445: RAISE fnd_api.g_exc_error;
1446: END IF;
1439: -- not be selected from the sequence.
1440: CLOSE psidcur;
1441:
1442: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1443: fnd_message.set_token('SEQUENCE', 'hz_contact_point_val_gt_s');
1444: fnd_msg_pub.add;
1445: RAISE fnd_api.g_exc_error;
1446: END IF;
1447: