DBA Data[Home] [Help]

APPS.HZ_DYN_VALIDATION dependencies on FND_MESSAGE

Line 104: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 105: fnd_message.set_token('SEQUENCE', 'hz_party_val_gt_s');

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;

Line 235: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 236: fnd_message.set_token('SEQUENCE', 'hz_relationship_val_gt_s');

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;

Line 361: fnd_message.set_name('AR', 'HZ_DV_NULL_PROFILE_VALUE');

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;

Line 362: fnd_message.set_token('PROFILE', 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;
366:

Line 397: fnd_message.set_name('AR', 'HZ_DV_EXEC_ERROR');

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;

Line 398: fnd_message.set_token('PROCEDURE', l_procedure_name);

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:

Line 399: fnd_message.set_token('ERRM', SQLERRM);

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;

Line 444: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 445: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 464: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 465: fnd_message.set_token('SEQUENCE', 'hz_org_profile_val_gt_s');

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;

Line 795: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 796: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 816: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 817: fnd_message.set_token('SEQUENCE', 'hz_group_val_gt_s');

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:

Line 881: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 882: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 934: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 935: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 956: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 957: fnd_message.set_token('SEQUENCE', 'hz_contact_val_gt_s');

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;

Line 1084: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 1085: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 1102: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 1103: fnd_message.set_token('SEQUENCE', 'hz_party_site_val_gt_s');

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;

Line 1224: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 1225: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 1242: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 1243: fnd_message.set_token('SEQUENCE', 'hz_location_val_gt_s');

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;

Line 1424: fnd_message.set_name('AR', 'HZ_DV_INVALID_PROFILE_OPTION');

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;

Line 1425: fnd_message.set_token('PROFILE', x_validation_profile);

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:

Line 1442: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');

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;

Line 1443: fnd_message.set_token('SEQUENCE', 'hz_contact_point_val_gt_s');

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: