104: AND p_column_value <> fnd_api.g_miss_char ) THEN
105: OPEN c_nace;
106: FETCH c_nace INTO l_exist;
107: IF c_nace%NOTFOUND THEN
108: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
109: fnd_message.set_token('COLUMN',p_column);
110: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
111: fnd_msg_pub.add;
112: x_return_status := fnd_api.g_ret_sts_error;
105: OPEN c_nace;
106: FETCH c_nace INTO l_exist;
107: IF c_nace%NOTFOUND THEN
108: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
109: fnd_message.set_token('COLUMN',p_column);
110: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
111: fnd_msg_pub.add;
112: x_return_status := fnd_api.g_ret_sts_error;
113: END IF;
106: FETCH c_nace INTO l_exist;
107: IF c_nace%NOTFOUND THEN
108: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
109: fnd_message.set_token('COLUMN',p_column);
110: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
111: fnd_msg_pub.add;
112: x_return_status := fnd_api.g_ret_sts_error;
113: END IF;
114: CLOSE c_nace;
491: -- Ensure that a party record was retrieved.
492: IF c_partytype%NOTFOUND THEN
493: -- no party and organization was found for the given ID.
494: CLOSE c_partytype;
495: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
496: fnd_message.set_token('FK', 'OWNER_TABLE_ID');
497: fnd_message.set_token('COLUMN', 'PARTY_ID');
498: fnd_message.set_token('TABLE', 'HZ_PARTIES');
499: fnd_msg_pub.add;
492: IF c_partytype%NOTFOUND THEN
493: -- no party and organization was found for the given ID.
494: CLOSE c_partytype;
495: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
496: fnd_message.set_token('FK', 'OWNER_TABLE_ID');
497: fnd_message.set_token('COLUMN', 'PARTY_ID');
498: fnd_message.set_token('TABLE', 'HZ_PARTIES');
499: fnd_msg_pub.add;
500: x_return_status := fnd_api.g_ret_sts_error;
493: -- no party and organization was found for the given ID.
494: CLOSE c_partytype;
495: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
496: fnd_message.set_token('FK', 'OWNER_TABLE_ID');
497: fnd_message.set_token('COLUMN', 'PARTY_ID');
498: fnd_message.set_token('TABLE', 'HZ_PARTIES');
499: fnd_msg_pub.add;
500: x_return_status := fnd_api.g_ret_sts_error;
501: RETURN;
494: CLOSE c_partytype;
495: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
496: fnd_message.set_token('FK', 'OWNER_TABLE_ID');
497: fnd_message.set_token('COLUMN', 'PARTY_ID');
498: fnd_message.set_token('TABLE', 'HZ_PARTIES');
499: fnd_msg_pub.add;
500: x_return_status := fnd_api.g_ret_sts_error;
501: RETURN;
502: END IF;
506: -- This is not an organization. Only organizations can have EDI
507: -- contact points.
508:
509: /* Bug 2619099.
510: | fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE'); |
511: | fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id)); |
512: | fnd_message.set_token('TYPE', 'ORGANIZATION'); */
513: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
514:
507: -- contact points.
508:
509: /* Bug 2619099.
510: | fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE'); |
511: | fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id)); |
512: | fnd_message.set_token('TYPE', 'ORGANIZATION'); */
513: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
514:
515: fnd_msg_pub.add;
508:
509: /* Bug 2619099.
510: | fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE'); |
511: | fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id)); |
512: | fnd_message.set_token('TYPE', 'ORGANIZATION'); */
513: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
514:
515: fnd_msg_pub.add;
516: x_return_status := fnd_api.g_ret_sts_error;
509: /* Bug 2619099.
510: | fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE'); |
511: | fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id)); |
512: | fnd_message.set_token('TYPE', 'ORGANIZATION'); */
513: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
514:
515: fnd_msg_pub.add;
516: x_return_status := fnd_api.g_ret_sts_error;
517: END IF;
575: IF p_table_name <> 'HZ_PARTIES' THEN
576: -- This is not a party type. This procedure was called incorrectly,
577: -- return a failure.
578: /* Bug 2619099.
579: | fnd_message.set_name('AR', 'HZ_API_INVALID_FK'); |
580: | fnd_message.set_token('FK', 'OWNER_TABLE_NAME'); |
581: | fnd_message.set_token('COLUMN', 'HZ_PARTIES'); |
582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */
583: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
576: -- This is not a party type. This procedure was called incorrectly,
577: -- return a failure.
578: /* Bug 2619099.
579: | fnd_message.set_name('AR', 'HZ_API_INVALID_FK'); |
580: | fnd_message.set_token('FK', 'OWNER_TABLE_NAME'); |
581: | fnd_message.set_token('COLUMN', 'HZ_PARTIES'); |
582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */
583: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
584:
577: -- return a failure.
578: /* Bug 2619099.
579: | fnd_message.set_name('AR', 'HZ_API_INVALID_FK'); |
580: | fnd_message.set_token('FK', 'OWNER_TABLE_NAME'); |
581: | fnd_message.set_token('COLUMN', 'HZ_PARTIES'); |
582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */
583: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
584:
585: fnd_msg_pub.add;
578: /* Bug 2619099.
579: | fnd_message.set_name('AR', 'HZ_API_INVALID_FK'); |
580: | fnd_message.set_token('FK', 'OWNER_TABLE_NAME'); |
581: | fnd_message.set_token('COLUMN', 'HZ_PARTIES'); |
582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */
583: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
584:
585: fnd_msg_pub.add;
586: x_return_status := fnd_api.g_ret_sts_error;
579: | fnd_message.set_name('AR', 'HZ_API_INVALID_FK'); |
580: | fnd_message.set_token('FK', 'OWNER_TABLE_NAME'); |
581: | fnd_message.set_token('COLUMN', 'HZ_PARTIES'); |
582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */
583: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
584:
585: fnd_msg_pub.add;
586: x_return_status := fnd_api.g_ret_sts_error;
587: RETURN;
603: -- Ensure that a party record was retrieved.
604: IF c_class%NOTFOUND THEN
605: -- no party and organization was found for the given ID.
606: CLOSE c_class;
607: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
608: fnd_message.set_token('RECORD', 'Code Assignment');
609: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
610: fnd_msg_pub.add;
611: x_return_status := fnd_api.g_ret_sts_error;
604: IF c_class%NOTFOUND THEN
605: -- no party and organization was found for the given ID.
606: CLOSE c_class;
607: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
608: fnd_message.set_token('RECORD', 'Code Assignment');
609: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
610: fnd_msg_pub.add;
611: x_return_status := fnd_api.g_ret_sts_error;
612: -- END IF;
605: -- no party and organization was found for the given ID.
606: CLOSE c_class;
607: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
608: fnd_message.set_token('RECORD', 'Code Assignment');
609: fnd_message.set_token('VALUE', TO_CHAR(p_party_id));
610: fnd_msg_pub.add;
611: x_return_status := fnd_api.g_ret_sts_error;
612: -- END IF;
613: ELSE
614: -- Check that the category class is a bank.
615: IF l_class_category NOT LIKE 'BANK%' THEN
616: -- This is not a bank-type organization. Only bank-type organizations
617: -- can have EFT contact points.
618: fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE');
619: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
620: fnd_message.set_token('TYPE', 'BANK or BANK BRANCH');
621: fnd_msg_pub.add;
622: x_return_status := fnd_api.g_ret_sts_error;
615: IF l_class_category NOT LIKE 'BANK%' THEN
616: -- This is not a bank-type organization. Only bank-type organizations
617: -- can have EFT contact points.
618: fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE');
619: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
620: fnd_message.set_token('TYPE', 'BANK or BANK BRANCH');
621: fnd_msg_pub.add;
622: x_return_status := fnd_api.g_ret_sts_error;
623: END IF;
616: -- This is not a bank-type organization. Only bank-type organizations
617: -- can have EFT contact points.
618: fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE');
619: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
620: fnd_message.set_token('TYPE', 'BANK or BANK BRANCH');
621: fnd_msg_pub.add;
622: x_return_status := fnd_api.g_ret_sts_error;
623: END IF;
624: CLOSE c_class;
659: END IF;
660: END IF;
661:
662: IF l_error THEN
663: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
664: fnd_message.set_token('COLUMN', p_column);
665: fnd_msg_pub.add;
666: x_return_status := fnd_api.g_ret_sts_error;
667: END IF;
660: END IF;
661:
662: IF l_error THEN
663: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
664: fnd_message.set_token('COLUMN', p_column);
665: fnd_msg_pub.add;
666: x_return_status := fnd_api.g_ret_sts_error;
667: END IF;
668:
697: END IF;
698: END IF;
699:
700: IF l_error THEN
701: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
702: fnd_message.set_token('COLUMN', p_column);
703: fnd_msg_pub.add;
704: x_return_status := fnd_api.g_ret_sts_error;
705: END IF;
698: END IF;
699:
700: IF l_error THEN
701: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
702: fnd_message.set_token('COLUMN', p_column);
703: fnd_msg_pub.add;
704: x_return_status := fnd_api.g_ret_sts_error;
705: END IF;
706:
735: END IF;
736: END IF;
737:
738: IF l_error THEN
739: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
740: fnd_message.set_token('COLUMN', p_column);
741: fnd_msg_pub.add;
742: x_return_status := fnd_api.g_ret_sts_error;
743: END IF;
736: END IF;
737:
738: IF l_error THEN
739: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
740: fnd_message.set_token('COLUMN', p_column);
741: fnd_msg_pub.add;
742: x_return_status := fnd_api.g_ret_sts_error;
743: END IF;
744:
778: END IF;
779: END IF;
780: IF l_error THEN
781: IF p_raise_error = 'Y' THEN
782: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
783: fnd_message.set_token('COLUMN', p_column);
784: fnd_msg_pub.add;
785: END IF;
786: x_return_status := fnd_api.g_ret_sts_error;
779: END IF;
780: IF l_error THEN
781: IF p_raise_error = 'Y' THEN
782: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
783: fnd_message.set_token('COLUMN', p_column);
784: fnd_msg_pub.add;
785: END IF;
786: x_return_status := fnd_api.g_ret_sts_error;
787: END IF;
823: END IF;
824:
825: IF l_error THEN
826: IF p_raise_error = 'Y' THEN
827: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
828: fnd_message.set_token('COLUMN', p_column);
829: fnd_msg_pub.add;
830: END IF;
831: x_return_status := fnd_api.g_ret_sts_error;
824:
825: IF l_error THEN
826: IF p_raise_error = 'Y' THEN
827: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
828: fnd_message.set_token('COLUMN', p_column);
829: fnd_msg_pub.add;
830: END IF;
831: x_return_status := fnd_api.g_ret_sts_error;
832: END IF;
868: END IF;
869:
870: IF l_error THEN
871: IF p_raise_error = 'Y' THEN
872: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
873: fnd_message.set_token('COLUMN', p_column);
874: fnd_msg_pub.add;
875: END IF;
876: x_return_status := fnd_api.g_ret_sts_error;
869:
870: IF l_error THEN
871: IF p_raise_error = 'Y' THEN
872: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
873: fnd_message.set_token('COLUMN', p_column);
874: fnd_msg_pub.add;
875: END IF;
876: x_return_status := fnd_api.g_ret_sts_error;
877: END IF;
922: (l_start_date IS NULL OR
923: l_start_date = FND_API.G_MISS_DATE OR
924: l_start_date > l_end_date)
925: THEN
926: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
927: fnd_message.set_token('DATE2', p_end_date_column_name);
928: fnd_message.set_token('DATE1', p_start_date_column_name);
929: fnd_msg_pub.add;
930: x_return_status := fnd_api.g_ret_sts_error;
923: l_start_date = FND_API.G_MISS_DATE OR
924: l_start_date > l_end_date)
925: THEN
926: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
927: fnd_message.set_token('DATE2', p_end_date_column_name);
928: fnd_message.set_token('DATE1', p_start_date_column_name);
929: fnd_msg_pub.add;
930: x_return_status := fnd_api.g_ret_sts_error;
931: END IF;
924: l_start_date > l_end_date)
925: THEN
926: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
927: fnd_message.set_token('DATE2', p_end_date_column_name);
928: fnd_message.set_token('DATE1', p_start_date_column_name);
929: fnd_msg_pub.add;
930: x_return_status := fnd_api.g_ret_sts_error;
931: END IF;
932:
940:
941: BEGIN
942:
943: IF p_column_value = fnd_api.g_miss_char THEN
944: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
945: fnd_message.set_token('COLUMN', p_column);
946: fnd_msg_pub.add;
947: x_return_status := fnd_api.g_ret_sts_error;
948: END IF;
941: BEGIN
942:
943: IF p_column_value = fnd_api.g_miss_char THEN
944: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
945: fnd_message.set_token('COLUMN', p_column);
946: fnd_msg_pub.add;
947: x_return_status := fnd_api.g_ret_sts_error;
948: END IF;
949:
957:
958: BEGIN
959:
960: IF p_column_value = fnd_api.g_miss_num THEN
961: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
962: fnd_message.set_token('COLUMN', p_column);
963: fnd_msg_pub.add;
964: x_return_status := fnd_api.g_ret_sts_error;
965: END IF;
958: BEGIN
959:
960: IF p_column_value = fnd_api.g_miss_num THEN
961: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
962: fnd_message.set_token('COLUMN', p_column);
963: fnd_msg_pub.add;
964: x_return_status := fnd_api.g_ret_sts_error;
965: END IF;
966:
974:
975: BEGIN
976:
977: IF p_column_value = FND_API.G_MISS_DATE THEN
978: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
979: fnd_message.set_token('COLUMN', p_column);
980: fnd_msg_pub.add;
981: x_return_status := fnd_api.g_ret_sts_error;
982: END IF;
975: BEGIN
976:
977: IF p_column_value = FND_API.G_MISS_DATE THEN
978: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
979: fnd_message.set_token('COLUMN', p_column);
980: fnd_msg_pub.add;
981: x_return_status := fnd_api.g_ret_sts_error;
982: END IF;
983:
1011: END IF;
1012: END IF;
1013:
1014: IF l_error THEN
1015: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');
1016: fnd_message.set_token('COLUMN', p_column);
1017: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
1018: fnd_msg_pub.add;
1019: x_return_status := fnd_api.g_ret_sts_error;
1012: END IF;
1013:
1014: IF l_error THEN
1015: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');
1016: fnd_message.set_token('COLUMN', p_column);
1017: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
1018: fnd_msg_pub.add;
1019: x_return_status := fnd_api.g_ret_sts_error;
1020: END IF;
1013:
1014: IF l_error THEN
1015: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');
1016: fnd_message.set_token('COLUMN', p_column);
1017: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
1018: fnd_msg_pub.add;
1019: x_return_status := fnd_api.g_ret_sts_error;
1020: END IF;
1021: END IF;
1034: p_column_value <> FND_API.G_MISS_CHAR
1035: THEN
1036: IF NOT search(p_column_value || G_SPECIAL_STRING, 'FND_TERRITORIES')
1037: THEN
1038: fnd_message.set_name('AR', 'HZ_API_INVALID_COUNTRY_CODE');
1039: fnd_msg_pub.add;
1040: x_return_status := fnd_api.g_ret_sts_error;
1041: END IF;
1042: END IF;
1284: FETCH c_dup INTO l_dummy;
1285:
1286: -- key is not unique, push an error onto the stack.
1287: IF NVL(c_dup%FOUND, FALSE) THEN
1288: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
1289: fnd_message.set_token('COLUMN', 'contact_point_id');
1290: fnd_msg_pub.add;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: END IF;
1285:
1286: -- key is not unique, push an error onto the stack.
1287: IF NVL(c_dup%FOUND, FALSE) THEN
1288: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
1289: fnd_message.set_token('COLUMN', 'contact_point_id');
1290: fnd_msg_pub.add;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: END IF;
1293: CLOSE c_dup;
1592: l_fk_exist := 'Y';
1593: END IF;
1594:
1595: IF l_fk_exist = 'N' THEN
1596: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1597: fnd_message.set_token('FK', 'owner_table_id');
1598: fnd_message.set_token('COLUMN', l_fk_column);
1599: fnd_message.set_token('TABLE',
1600: LOWER(p_contact_point_rec.owner_table_name));
1593: END IF;
1594:
1595: IF l_fk_exist = 'N' THEN
1596: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1597: fnd_message.set_token('FK', 'owner_table_id');
1598: fnd_message.set_token('COLUMN', l_fk_column);
1599: fnd_message.set_token('TABLE',
1600: LOWER(p_contact_point_rec.owner_table_name));
1601: fnd_msg_pub.add;
1594:
1595: IF l_fk_exist = 'N' THEN
1596: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1597: fnd_message.set_token('FK', 'owner_table_id');
1598: fnd_message.set_token('COLUMN', l_fk_column);
1599: fnd_message.set_token('TABLE',
1600: LOWER(p_contact_point_rec.owner_table_name));
1601: fnd_msg_pub.add;
1602: x_return_status := fnd_api.g_ret_sts_error;
1595: IF l_fk_exist = 'N' THEN
1596: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1597: fnd_message.set_token('FK', 'owner_table_id');
1598: fnd_message.set_token('COLUMN', l_fk_column);
1599: fnd_message.set_token('TABLE',
1600: LOWER(p_contact_point_rec.owner_table_name));
1601: fnd_msg_pub.add;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: END IF;
1907: END IF;
1908: END IF;
1909:
1910: IF l_error THEN
1911: fnd_message.set_name('AR', 'HZ_API_INACTIVE_NOT_PRIMARY');
1912: fnd_msg_pub.add;
1913: x_return_status := fnd_api.g_ret_sts_error;
1914: -- reset l_error for later use.
1915: l_error := FALSE;
1950: l_error := TRUE;
1951: END IF;
1952: END IF;
1953: IF l_error THEN
1954: fnd_message.set_name('AR', 'HZ_API_INACTIVE_NOT_PREFERRED');
1955: fnd_msg_pub.add;
1956: x_return_status := fnd_api.g_ret_sts_error;
1957:
1958: -- reset l_error for later use.
1983: IF (p_contact_point_rec.contact_point_purpose IS NULL OR
1984: p_contact_point_rec.contact_point_purpose = FND_API.G_MISS_CHAR)
1985: THEN
1986: -- Error
1987: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
1988: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
1989: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
1990: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
1991: FND_MSG_PUB.ADD;
1984: p_contact_point_rec.contact_point_purpose = FND_API.G_MISS_CHAR)
1985: THEN
1986: -- Error
1987: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
1988: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
1989: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
1990: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
1991: FND_MSG_PUB.ADD;
1992: x_return_status := FND_API.G_RET_STS_ERROR;
1985: THEN
1986: -- Error
1987: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
1988: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
1989: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
1990: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
1991: FND_MSG_PUB.ADD;
1992: x_return_status := FND_API.G_RET_STS_ERROR;
1993:
1986: -- Error
1987: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
1988: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
1989: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
1990: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
1991: FND_MSG_PUB.ADD;
1992: x_return_status := FND_API.G_RET_STS_ERROR;
1993:
1994: END IF;
2002: ( p_contact_point_rec.contact_point_purpose IS NULL AND
2003: l_contact_point_purpose IS NULL))
2004: THEN
2005: -- Error
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
2008: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
2009: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
2010: FND_MSG_PUB.ADD;
2003: l_contact_point_purpose IS NULL))
2004: THEN
2005: -- Error
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
2008: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
2009: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
2010: FND_MSG_PUB.ADD;
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2004: THEN
2005: -- Error
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
2008: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
2009: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
2010: FND_MSG_PUB.ADD;
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2012: END IF;
2005: -- Error
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN1', 'primary_by_purpose');
2008: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
2009: FND_MESSAGE.SET_TOKEN('COLUMN2','contact_point_purpose');
2010: FND_MSG_PUB.ADD;
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2012: END IF;
2013: END IF;
2355: END IF;
2356: END IF;
2357:
2358: IF l_error THEN
2359: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_PARAMETER');
2360: fnd_msg_pub.add;
2361: x_return_status := fnd_api.g_ret_sts_error;
2362:
2363: -- Reset l_error for later use.
2447: OPEN c_timezone(p_phone_rec.timezone_id);
2448: FETCH c_timezone INTO l_dummy;
2449:
2450: IF c_timezone%NOTFOUND THEN--updated against bug 7046491
2451: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2452: fnd_message.set_token('FK', 'upgrade_tz_id');
2453: fnd_message.set_token('COLUMN', 'upgrade_tz_id');
2454: fnd_message.set_token('TABLE', 'fnd_timezones_vl');
2455: fnd_msg_pub.add;
2448: FETCH c_timezone INTO l_dummy;
2449:
2450: IF c_timezone%NOTFOUND THEN--updated against bug 7046491
2451: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2452: fnd_message.set_token('FK', 'upgrade_tz_id');
2453: fnd_message.set_token('COLUMN', 'upgrade_tz_id');
2454: fnd_message.set_token('TABLE', 'fnd_timezones_vl');
2455: fnd_msg_pub.add;
2456: x_return_status := fnd_api.g_ret_sts_error;
2449:
2450: IF c_timezone%NOTFOUND THEN--updated against bug 7046491
2451: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2452: fnd_message.set_token('FK', 'upgrade_tz_id');
2453: fnd_message.set_token('COLUMN', 'upgrade_tz_id');
2454: fnd_message.set_token('TABLE', 'fnd_timezones_vl');
2455: fnd_msg_pub.add;
2456: x_return_status := fnd_api.g_ret_sts_error;
2457: END IF;
2450: IF c_timezone%NOTFOUND THEN--updated against bug 7046491
2451: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2452: fnd_message.set_token('FK', 'upgrade_tz_id');
2453: fnd_message.set_token('COLUMN', 'upgrade_tz_id');
2454: fnd_message.set_token('TABLE', 'fnd_timezones_vl');
2455: fnd_msg_pub.add;
2456: x_return_status := fnd_api.g_ret_sts_error;
2457: END IF;
2458:
2505: FETCH c_countrycode INTO l_dummy;
2506:
2507: IF c_countrycode%NOTFOUND THEN
2508: --Bug 4474646
2509: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_COUNTRY_CODE');
2510: fnd_msg_pub.add;
2511: x_return_status := fnd_api.g_ret_sts_error;
2512: END IF;
2513:
2656: x_return_status => x_return_status);
2657: -- Bug 4693719 : set global variable to Y
2658: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
2659:
2660: /*FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
2661: FND_MSG_PUB.ADD;
2662: x_return_status := FND_API.G_RET_STS_ERROR;
2663: */
2664: END IF;
3092: /*IF nvl(p_old_party_rec.orig_system_reference,'X') LIKE 'PER%' THEN
3093: | IF NVL(fnd_profile.value('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API'
3094: | AND p_create_update_flag = 'U'
3095: | THEN
3096: | fnd_message.set_name('AR', 'HZ_CREATED_BY_MISMATCH');
3097: | fnd_msg_pub.add;
3098: | x_return_status := fnd_api.g_ret_sts_error;
3099: | END IF;
3100: | END IF;
3111: |IF NVL(fnd_profile.value('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API'
3112: | AND l_temp_hr_party_exist = 1
3113: | AND p_create_update_flag = 'U'
3114: |THEN
3115: | fnd_message.set_name('AR', 'HZ_CREATED_BY_MISMATCH');
3116: | fnd_msg_pub.add;
3117: | x_return_status := fnd_api.g_ret_sts_error;
3118: |END IF;
3119: */
3262: (p_person_rec.person_last_name <> p_old_person_rec.person_last_name) OR
3263: (p_person_rec.person_pre_name_adjunct <> p_old_person_rec.person_pre_name_adjunct) OR
3264: (p_person_rec.person_name_suffix <> p_old_person_rec.person_name_suffix)
3265: ) THEN
3266: fnd_message.set_name('AR', 'HZ_CUST_NAME_UPDT_NOT_ALLOWED');
3267: fnd_msg_pub.add;
3268: x_return_status := fnd_api.g_ret_sts_error;
3269: END IF;
3270:
3289: IF (p_person_rec.person_first_name = fnd_api.g_miss_char or p_person_rec.person_first_name IS NULL)
3290: AND
3291: (p_person_rec.person_last_name = fnd_api.g_miss_char or p_person_rec.person_last_name IS NULL)
3292: THEN
3293: fnd_message.set_name('AR', 'HZ_FIRST_OR_LAST_NAME_REQUIRED');
3294: fnd_msg_pub.add;
3295: x_return_status := fnd_api.g_ret_sts_error;
3296: END IF;
3297: END IF;
3303: or NVL(p_person_rec.person_first_name,p_old_person_rec.person_first_name)=fnd_api.g_miss_char)
3304: AND
3305: (p_person_rec.person_last_name = fnd_api.g_miss_char
3306: or NVL(p_person_rec.person_last_name,p_old_person_rec.person_last_name)=fnd_api.g_miss_char) THEN
3307: fnd_message.set_name('AR', 'HZ_FIRST_OR_LAST_NAME_REQUIRED');
3308: fnd_msg_pub.add;
3309: x_return_status := fnd_api.g_ret_sts_error;
3310: END IF;
3311: END IF;
3462:
3463: IF p_person_rec.deceased_flag <> 'Y'
3464: THEN
3465:
3466: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
3467: fnd_message.set_token('COLUMN1', 'DATE_OF_DEATH');
3468: fnd_message.set_token('VALUE1', 'not null');
3469: fnd_message.set_token('COLUMN2', 'DECEASED_FLAG');
3470: fnd_message.set_token('VALUE2', 'Y');
3463: IF p_person_rec.deceased_flag <> 'Y'
3464: THEN
3465:
3466: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
3467: fnd_message.set_token('COLUMN1', 'DATE_OF_DEATH');
3468: fnd_message.set_token('VALUE1', 'not null');
3469: fnd_message.set_token('COLUMN2', 'DECEASED_FLAG');
3470: fnd_message.set_token('VALUE2', 'Y');
3471: fnd_msg_pub.add;
3464: THEN
3465:
3466: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
3467: fnd_message.set_token('COLUMN1', 'DATE_OF_DEATH');
3468: fnd_message.set_token('VALUE1', 'not null');
3469: fnd_message.set_token('COLUMN2', 'DECEASED_FLAG');
3470: fnd_message.set_token('VALUE2', 'Y');
3471: fnd_msg_pub.add;
3472: x_return_status := fnd_api.g_ret_sts_error;
3465:
3466: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
3467: fnd_message.set_token('COLUMN1', 'DATE_OF_DEATH');
3468: fnd_message.set_token('VALUE1', 'not null');
3469: fnd_message.set_token('COLUMN2', 'DECEASED_FLAG');
3470: fnd_message.set_token('VALUE2', 'Y');
3471: fnd_msg_pub.add;
3472: x_return_status := fnd_api.g_ret_sts_error;
3473: END IF;
3466: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
3467: fnd_message.set_token('COLUMN1', 'DATE_OF_DEATH');
3468: fnd_message.set_token('VALUE1', 'not null');
3469: fnd_message.set_token('COLUMN2', 'DECEASED_FLAG');
3470: fnd_message.set_token('VALUE2', 'Y');
3471: fnd_msg_pub.add;
3472: x_return_status := fnd_api.g_ret_sts_error;
3473: END IF;
3474:
3492: -------------------------------------------
3493:
3494: -- date_of_birth and date_of_death should be greater than sys_date
3495: IF p_person_rec.date_of_birth > SYSDATE then
3496: fnd_message.set_name('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
3497: fnd_message.set_token('COLUMN','DATE_OF_BIRTH');
3498: fnd_msg_pub.add;
3499: x_return_status := fnd_api.g_ret_sts_error;
3500: END IF;
3493:
3494: -- date_of_birth and date_of_death should be greater than sys_date
3495: IF p_person_rec.date_of_birth > SYSDATE then
3496: fnd_message.set_name('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
3497: fnd_message.set_token('COLUMN','DATE_OF_BIRTH');
3498: fnd_msg_pub.add;
3499: x_return_status := fnd_api.g_ret_sts_error;
3500: END IF;
3501:
3499: x_return_status := fnd_api.g_ret_sts_error;
3500: END IF;
3501:
3502: IF p_person_rec.date_of_death > SYSDATE then
3503: fnd_message.set_name('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
3504: fnd_message.set_token('COLUMN','DATE_OF_DEATH');
3505: fnd_msg_pub.add;
3506: x_return_status := fnd_api.g_ret_sts_error;
3507: END IF;
3500: END IF;
3501:
3502: IF p_person_rec.date_of_death > SYSDATE then
3503: fnd_message.set_name('AR','HZ_API_NO_FUTURE_DATE_ALLOWED');
3504: fnd_message.set_token('COLUMN','DATE_OF_DEATH');
3505: fnd_msg_pub.add;
3506: x_return_status := fnd_api.g_ret_sts_error;
3507: END IF;
3508:
3896:
3897: IF(cols_updated IS NOT NULL)
3898: THEN
3899: cols_updated:=SUBSTR(cols_updated,2);
3900: FND_MESSAGE.SET_NAME('AR', 'HZ_CREATED_BY_MISMATCH');
3901: FND_MESSAGE.SET_TOKEN('COLUMN',cols_updated);
3902: FND_MSG_PUB.ADD;
3903: x_return_status := FND_API.G_RET_STS_ERROR;
3904: END IF;
3897: IF(cols_updated IS NOT NULL)
3898: THEN
3899: cols_updated:=SUBSTR(cols_updated,2);
3900: FND_MESSAGE.SET_NAME('AR', 'HZ_CREATED_BY_MISMATCH');
3901: FND_MESSAGE.SET_TOKEN('COLUMN',cols_updated);
3902: FND_MSG_PUB.ADD;
3903: x_return_status := FND_API.G_RET_STS_ERROR;
3904: END IF;
3905:
3979:
3980: IF(cols_updated IS NOT NULL)
3981: THEN
3982: cols_updated:=SUBSTR(cols_updated,2);
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_CREATED_BY_MISMATCH');
3984: FND_MESSAGE.SET_TOKEN('COLUMN',cols_updated);
3985: FND_MSG_PUB.ADD;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987: END IF;
3980: IF(cols_updated IS NOT NULL)
3981: THEN
3982: cols_updated:=SUBSTR(cols_updated,2);
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_CREATED_BY_MISMATCH');
3984: FND_MESSAGE.SET_TOKEN('COLUMN',cols_updated);
3985: FND_MSG_PUB.ADD;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987: END IF;
3988:
4243: l_change_org_name_profile := fnd_profile.VALUE('AR_CHANGE_CUST_NAME');
4244: IF (NVL(l_change_org_name_profile,'Y') = 'N') THEN -- update to party name is not allowed
4245:
4246: IF (p_organization_rec.organization_name <> p_old_organization_rec.organization_name) THEN
4247: fnd_message.set_name('AR', 'HZ_ORG_NAME_UPDT_NOT_ALLOWED');
4248: fnd_msg_pub.add;
4249: x_return_status := fnd_api.g_ret_sts_error;
4250: END IF;
4251:
5434: AND CURRENCY_FLAG = 'Y'
5435: AND ENABLED_FLAG in ('Y', 'N');
5436: EXCEPTION
5437: WHEN NO_DATA_FOUND THEN
5438: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5439: fnd_message.set_token('FK', 'maximum_credit_currency_code');
5440: fnd_message.set_token('COLUMN', 'currency_code');
5441: fnd_message.set_token('TABLE', 'fnd_currencies');
5442: fnd_msg_pub.add;
5435: AND ENABLED_FLAG in ('Y', 'N');
5436: EXCEPTION
5437: WHEN NO_DATA_FOUND THEN
5438: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5439: fnd_message.set_token('FK', 'maximum_credit_currency_code');
5440: fnd_message.set_token('COLUMN', 'currency_code');
5441: fnd_message.set_token('TABLE', 'fnd_currencies');
5442: fnd_msg_pub.add;
5443: x_return_status := fnd_api.g_ret_sts_error;
5436: EXCEPTION
5437: WHEN NO_DATA_FOUND THEN
5438: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5439: fnd_message.set_token('FK', 'maximum_credit_currency_code');
5440: fnd_message.set_token('COLUMN', 'currency_code');
5441: fnd_message.set_token('TABLE', 'fnd_currencies');
5442: fnd_msg_pub.add;
5443: x_return_status := fnd_api.g_ret_sts_error;
5444: END;
5437: WHEN NO_DATA_FOUND THEN
5438: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5439: fnd_message.set_token('FK', 'maximum_credit_currency_code');
5440: fnd_message.set_token('COLUMN', 'currency_code');
5441: fnd_message.set_token('TABLE', 'fnd_currencies');
5442: fnd_msg_pub.add;
5443: x_return_status := fnd_api.g_ret_sts_error;
5444: END;
5445:
5689: FROM HZ_PARTIES
5690: WHERE PARTY_ID = p_organization_rec.displayed_duns_party_id;
5691: EXCEPTION
5692: WHEN NO_DATA_FOUND THEN
5693: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5694: fnd_message.set_token('FK', 'displayed_duns_party_id');
5695: fnd_message.set_token('COLUMN', 'party_id');
5696: fnd_message.set_token('TABLE', 'hz_parties');
5697: fnd_msg_pub.add;
5690: WHERE PARTY_ID = p_organization_rec.displayed_duns_party_id;
5691: EXCEPTION
5692: WHEN NO_DATA_FOUND THEN
5693: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5694: fnd_message.set_token('FK', 'displayed_duns_party_id');
5695: fnd_message.set_token('COLUMN', 'party_id');
5696: fnd_message.set_token('TABLE', 'hz_parties');
5697: fnd_msg_pub.add;
5698: x_return_status := fnd_api.g_ret_sts_error;
5691: EXCEPTION
5692: WHEN NO_DATA_FOUND THEN
5693: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5694: fnd_message.set_token('FK', 'displayed_duns_party_id');
5695: fnd_message.set_token('COLUMN', 'party_id');
5696: fnd_message.set_token('TABLE', 'hz_parties');
5697: fnd_msg_pub.add;
5698: x_return_status := fnd_api.g_ret_sts_error;
5699: END;
5692: WHEN NO_DATA_FOUND THEN
5693: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
5694: fnd_message.set_token('FK', 'displayed_duns_party_id');
5695: fnd_message.set_token('COLUMN', 'party_id');
5696: fnd_message.set_token('TABLE', 'hz_parties');
5697: fnd_msg_pub.add;
5698: x_return_status := fnd_api.g_ret_sts_error;
5699: END;
5700:
5835: -- Now even_sum contains (3 times (even_sum)) + odd_sum
5836:
5837: IF ( check_digit + even_sum ) MOD 10 <> 0
5838: THEN -- Global location number did not satisfy the check digit validation.
5839: FND_MESSAGE.SET_NAME('AR','HZ_API_GLOBAL_LOC_NUM_ERRORS');
5840: FND_MSG_PUB.ADD;
5841: x_return_status := FND_API.G_RET_STS_ERROR;
5842: END IF;
5843:
5841: x_return_status := FND_API.G_RET_STS_ERROR;
5842: END IF;
5843:
5844: ELSE -- Global_location_number is not 13 digits long.
5845: FND_MESSAGE.SET_NAME('AR','HZ_API_GLOBAL_LOC_NUM_ERRORS');
5846: FND_MSG_PUB.ADD;
5847: x_return_status := FND_API.G_RET_STS_ERROR;
5848: END IF;
5849:
5850: ELSE -- corresponding to IF TRIM(TRANSLATE(global_location_number,'0123456789',' '))
5851:
5852: -- Since there are non numeric characters, therefore the expression evaluated in the if
5853: -- clause is not null.
5854: FND_MESSAGE.SET_NAME('AR','HZ_API_GLOBAL_LOC_NUM_ERRORS');
5855: FND_MSG_PUB.ADD;
5856: x_return_status := FND_API.G_RET_STS_ERROR;
5857: END IF;
5858:
6044: FROM HZ_PARTIES
6045: WHERE PARTY_ID = p_party_site_rec.party_id;
6046: EXCEPTION
6047: WHEN NO_DATA_FOUND THEN
6048: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6049: fnd_message.set_token('FK', 'party_id');
6050: fnd_message.set_token('COLUMN', 'party_id');
6051: fnd_message.set_token('TABLE', 'hz_parties');
6052: fnd_msg_pub.add;
6045: WHERE PARTY_ID = p_party_site_rec.party_id;
6046: EXCEPTION
6047: WHEN NO_DATA_FOUND THEN
6048: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6049: fnd_message.set_token('FK', 'party_id');
6050: fnd_message.set_token('COLUMN', 'party_id');
6051: fnd_message.set_token('TABLE', 'hz_parties');
6052: fnd_msg_pub.add;
6053: x_return_status := fnd_api.g_ret_sts_error;
6046: EXCEPTION
6047: WHEN NO_DATA_FOUND THEN
6048: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6049: fnd_message.set_token('FK', 'party_id');
6050: fnd_message.set_token('COLUMN', 'party_id');
6051: fnd_message.set_token('TABLE', 'hz_parties');
6052: fnd_msg_pub.add;
6053: x_return_status := fnd_api.g_ret_sts_error;
6054: END;
6047: WHEN NO_DATA_FOUND THEN
6048: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6049: fnd_message.set_token('FK', 'party_id');
6050: fnd_message.set_token('COLUMN', 'party_id');
6051: fnd_message.set_token('TABLE', 'hz_parties');
6052: fnd_msg_pub.add;
6053: x_return_status := fnd_api.g_ret_sts_error;
6054: END;
6055:
6136: FROM HZ_LOCATIONS
6137: WHERE LOCATION_ID = p_party_site_rec.location_id;
6138: EXCEPTION
6139: WHEN NO_DATA_FOUND THEN
6140: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6141: fnd_message.set_token('FK', 'location_id');
6142: fnd_message.set_token('COLUMN', 'location_id');
6143: fnd_message.set_token('TABLE', 'hz_locations');
6144: fnd_msg_pub.add;
6137: WHERE LOCATION_ID = p_party_site_rec.location_id;
6138: EXCEPTION
6139: WHEN NO_DATA_FOUND THEN
6140: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6141: fnd_message.set_token('FK', 'location_id');
6142: fnd_message.set_token('COLUMN', 'location_id');
6143: fnd_message.set_token('TABLE', 'hz_locations');
6144: fnd_msg_pub.add;
6145: x_return_status := fnd_api.g_ret_sts_error;
6138: EXCEPTION
6139: WHEN NO_DATA_FOUND THEN
6140: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6141: fnd_message.set_token('FK', 'location_id');
6142: fnd_message.set_token('COLUMN', 'location_id');
6143: fnd_message.set_token('TABLE', 'hz_locations');
6144: fnd_msg_pub.add;
6145: x_return_status := fnd_api.g_ret_sts_error;
6146: END;
6139: WHEN NO_DATA_FOUND THEN
6140: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6141: fnd_message.set_token('FK', 'location_id');
6142: fnd_message.set_token('COLUMN', 'location_id');
6143: fnd_message.set_token('TABLE', 'hz_locations');
6144: fnd_msg_pub.add;
6145: x_return_status := fnd_api.g_ret_sts_error;
6146: END;
6147:
6281: l_status = 'I' AND
6282: p_party_site_rec.status = 'A'
6283: THEN
6284: /* new message */
6285: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_CANT_ACTIVATE_SITE' );
6286: FND_MSG_PUB.ADD;
6287: x_return_status := FND_API.G_RET_STS_ERROR;
6288: END IF;
6289: END IF;
6370: INTO l_dummy
6371: FROM dual;
6372:
6373: IF l_dummy <> 'Y' THEN
6374: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
6375: fnd_message.set_token('ENTITY', 'Site');
6376: -- fnd_message.set_token('COLUMN1', 'identifying_address');
6377: -- fnd_message.set_token('COLUMN2', 'status');
6378: fnd_msg_pub.add;
6371: FROM dual;
6372:
6373: IF l_dummy <> 'Y' THEN
6374: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
6375: fnd_message.set_token('ENTITY', 'Site');
6376: -- fnd_message.set_token('COLUMN1', 'identifying_address');
6377: -- fnd_message.set_token('COLUMN2', 'status');
6378: fnd_msg_pub.add;
6379: x_return_status := FND_API.G_RET_STS_ERROR;
6372:
6373: IF l_dummy <> 'Y' THEN
6374: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
6375: fnd_message.set_token('ENTITY', 'Site');
6376: -- fnd_message.set_token('COLUMN1', 'identifying_address');
6377: -- fnd_message.set_token('COLUMN2', 'status');
6378: fnd_msg_pub.add;
6379: x_return_status := FND_API.G_RET_STS_ERROR;
6380: END IF;
6373: IF l_dummy <> 'Y' THEN
6374: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
6375: fnd_message.set_token('ENTITY', 'Site');
6376: -- fnd_message.set_token('COLUMN1', 'identifying_address');
6377: -- fnd_message.set_token('COLUMN2', 'status');
6378: fnd_msg_pub.add;
6379: x_return_status := FND_API.G_RET_STS_ERROR;
6380: END IF;
6381:
6413: WHERE LANGUAGE_CODE = p_party_site_rec.language
6414: AND INSTALLED_FLAG IN ('B', 'I');
6415: EXCEPTION
6416: WHEN NO_DATA_FOUND THEN
6417: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6418: fnd_message.set_token('FK', 'language');
6419: fnd_message.set_token('COLUMN', 'language_code');
6420: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
6421: fnd_msg_pub.add;
6414: AND INSTALLED_FLAG IN ('B', 'I');
6415: EXCEPTION
6416: WHEN NO_DATA_FOUND THEN
6417: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6418: fnd_message.set_token('FK', 'language');
6419: fnd_message.set_token('COLUMN', 'language_code');
6420: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
6421: fnd_msg_pub.add;
6422: x_return_status := fnd_api.g_ret_sts_error;
6415: EXCEPTION
6416: WHEN NO_DATA_FOUND THEN
6417: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6418: fnd_message.set_token('FK', 'language');
6419: fnd_message.set_token('COLUMN', 'language_code');
6420: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
6421: fnd_msg_pub.add;
6422: x_return_status := fnd_api.g_ret_sts_error;
6423: END;
6416: WHEN NO_DATA_FOUND THEN
6417: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6418: fnd_message.set_token('FK', 'language');
6419: fnd_message.set_token('COLUMN', 'language_code');
6420: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
6421: fnd_msg_pub.add;
6422: x_return_status := fnd_api.g_ret_sts_error;
6423: END;
6424:
6628: FROM HZ_PARTY_SITES
6629: WHERE PARTY_SITE_ID = p_party_site_use_rec.party_site_id;
6630: EXCEPTION
6631: WHEN NO_DATA_FOUND THEN
6632: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6633: fnd_message.set_token('FK', 'party_site_id');
6634: fnd_message.set_token('COLUMN', 'party_site_id');
6635: fnd_message.set_token('TABLE', 'hz_party_sites');
6636: fnd_msg_pub.add;
6629: WHERE PARTY_SITE_ID = p_party_site_use_rec.party_site_id;
6630: EXCEPTION
6631: WHEN NO_DATA_FOUND THEN
6632: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6633: fnd_message.set_token('FK', 'party_site_id');
6634: fnd_message.set_token('COLUMN', 'party_site_id');
6635: fnd_message.set_token('TABLE', 'hz_party_sites');
6636: fnd_msg_pub.add;
6637: x_return_status := fnd_api.g_ret_sts_error;
6630: EXCEPTION
6631: WHEN NO_DATA_FOUND THEN
6632: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6633: fnd_message.set_token('FK', 'party_site_id');
6634: fnd_message.set_token('COLUMN', 'party_site_id');
6635: fnd_message.set_token('TABLE', 'hz_party_sites');
6636: fnd_msg_pub.add;
6637: x_return_status := fnd_api.g_ret_sts_error;
6638: END;
6631: WHEN NO_DATA_FOUND THEN
6632: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
6633: fnd_message.set_token('FK', 'party_site_id');
6634: fnd_message.set_token('COLUMN', 'party_site_id');
6635: fnd_message.set_token('TABLE', 'hz_party_sites');
6636: fnd_msg_pub.add;
6637: x_return_status := fnd_api.g_ret_sts_error;
6638: END;
6639:
6759: AND SITE_USE_TYPE = nvl(p_party_site_use_rec.site_use_type,l_site_use_type)
6760: AND STATUS = 'A'
6761: AND PARTY_SITE_USE_ID <> NVL(p_party_site_use_rec.party_site_use_id, fnd_api.g_miss_num);
6762:
6763: fnd_message.set_name('AR', 'HZ_API_UNIQUE_SITE_USE_TYPE');
6764: fnd_msg_pub.add;
6765: x_return_status := fnd_api.g_ret_sts_error;
6766:
6767: EXCEPTION
6860:
6861: IF NVL(p_party_site_use_rec.primary_per_type,l_primary_per_type) ='Y'
6862: AND NVL(p_party_site_use_rec.status,l_status) = 'I'
6863: THEN
6864: FND_MESSAGE.SET_NAME('AR','HZ_API_INACTIVE_CANNOT_PRIM');
6865: FND_MESSAGE.SET_TOKEN('ENTITY','Party Site Use');
6866: -- FND_MESSAGE.SET_TOKEN('COLUMN1','PRIMARY_PER_TYPE');
6867: -- FND_MESSAGE.SET_TOKEN('COLUMN2','STATUS');
6868: FND_MSG_PUB.ADD;
6861: IF NVL(p_party_site_use_rec.primary_per_type,l_primary_per_type) ='Y'
6862: AND NVL(p_party_site_use_rec.status,l_status) = 'I'
6863: THEN
6864: FND_MESSAGE.SET_NAME('AR','HZ_API_INACTIVE_CANNOT_PRIM');
6865: FND_MESSAGE.SET_TOKEN('ENTITY','Party Site Use');
6866: -- FND_MESSAGE.SET_TOKEN('COLUMN1','PRIMARY_PER_TYPE');
6867: -- FND_MESSAGE.SET_TOKEN('COLUMN2','STATUS');
6868: FND_MSG_PUB.ADD;
6869: x_return_status := FND_API.G_RET_STS_ERROR;
6862: AND NVL(p_party_site_use_rec.status,l_status) = 'I'
6863: THEN
6864: FND_MESSAGE.SET_NAME('AR','HZ_API_INACTIVE_CANNOT_PRIM');
6865: FND_MESSAGE.SET_TOKEN('ENTITY','Party Site Use');
6866: -- FND_MESSAGE.SET_TOKEN('COLUMN1','PRIMARY_PER_TYPE');
6867: -- FND_MESSAGE.SET_TOKEN('COLUMN2','STATUS');
6868: FND_MSG_PUB.ADD;
6869: x_return_status := FND_API.G_RET_STS_ERROR;
6870: END IF;
6863: THEN
6864: FND_MESSAGE.SET_NAME('AR','HZ_API_INACTIVE_CANNOT_PRIM');
6865: FND_MESSAGE.SET_TOKEN('ENTITY','Party Site Use');
6866: -- FND_MESSAGE.SET_TOKEN('COLUMN1','PRIMARY_PER_TYPE');
6867: -- FND_MESSAGE.SET_TOKEN('COLUMN2','STATUS');
6868: FND_MSG_PUB.ADD;
6869: x_return_status := FND_API.G_RET_STS_ERROR;
6870: END IF;
6871:
7178: FROM HZ_PARTY_SITES
7179: WHERE PARTY_SITE_ID = p_org_contact_rec.party_site_id;
7180: EXCEPTION
7181: WHEN NO_DATA_FOUND THEN
7182: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7183: fnd_message.set_token('FK', 'party_site_id');
7184: fnd_message.set_token('COLUMN', 'party_site_id');
7185: fnd_message.set_token('TABLE', 'hz_party_sites');
7186: fnd_msg_pub.add;
7179: WHERE PARTY_SITE_ID = p_org_contact_rec.party_site_id;
7180: EXCEPTION
7181: WHEN NO_DATA_FOUND THEN
7182: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7183: fnd_message.set_token('FK', 'party_site_id');
7184: fnd_message.set_token('COLUMN', 'party_site_id');
7185: fnd_message.set_token('TABLE', 'hz_party_sites');
7186: fnd_msg_pub.add;
7187: x_return_status := fnd_api.g_ret_sts_error;
7180: EXCEPTION
7181: WHEN NO_DATA_FOUND THEN
7182: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7183: fnd_message.set_token('FK', 'party_site_id');
7184: fnd_message.set_token('COLUMN', 'party_site_id');
7185: fnd_message.set_token('TABLE', 'hz_party_sites');
7186: fnd_msg_pub.add;
7187: x_return_status := fnd_api.g_ret_sts_error;
7188: END;
7181: WHEN NO_DATA_FOUND THEN
7182: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7183: fnd_message.set_token('FK', 'party_site_id');
7184: fnd_message.set_token('COLUMN', 'party_site_id');
7185: fnd_message.set_token('TABLE', 'hz_party_sites');
7186: fnd_msg_pub.add;
7187: x_return_status := fnd_api.g_ret_sts_error;
7188: END;
7189:
7216: WHERE PARTY_SITE_ID = p_org_contact_rec.party_site_id
7217: AND PARTY_ID = p_org_contact_rec.party_rel_rec.object_id;
7218: EXCEPTION
7219: WHEN NO_DATA_FOUND THEN
7220: fnd_message.set_name('AR', 'HZ_API_PARTY_OBJECT_MISMATCH');
7221: fnd_msg_pub.add;
7222: x_return_status := fnd_api.g_ret_sts_error;
7223: END;
7224:
7407: FROM HZ_ORG_CONTACTS
7408: WHERE ORG_CONTACT_ID = p_org_contact_role_rec.org_contact_id;
7409: EXCEPTION
7410: WHEN NO_DATA_FOUND THEN
7411: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7412: fnd_message.set_token('FK', 'org_contact_id');
7413: fnd_message.set_token('COLUMN', 'org_contact_id');
7414: fnd_message.set_token('TABLE', 'hz_org_contacts');
7415: fnd_msg_pub.add;
7408: WHERE ORG_CONTACT_ID = p_org_contact_role_rec.org_contact_id;
7409: EXCEPTION
7410: WHEN NO_DATA_FOUND THEN
7411: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7412: fnd_message.set_token('FK', 'org_contact_id');
7413: fnd_message.set_token('COLUMN', 'org_contact_id');
7414: fnd_message.set_token('TABLE', 'hz_org_contacts');
7415: fnd_msg_pub.add;
7416: x_return_status := fnd_api.g_ret_sts_error;
7409: EXCEPTION
7410: WHEN NO_DATA_FOUND THEN
7411: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7412: fnd_message.set_token('FK', 'org_contact_id');
7413: fnd_message.set_token('COLUMN', 'org_contact_id');
7414: fnd_message.set_token('TABLE', 'hz_org_contacts');
7415: fnd_msg_pub.add;
7416: x_return_status := fnd_api.g_ret_sts_error;
7417: END;
7410: WHEN NO_DATA_FOUND THEN
7411: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7412: fnd_message.set_token('FK', 'org_contact_id');
7413: fnd_message.set_token('COLUMN', 'org_contact_id');
7414: fnd_message.set_token('TABLE', 'hz_org_contacts');
7415: fnd_msg_pub.add;
7416: x_return_status := fnd_api.g_ret_sts_error;
7417: END;
7418:
7594: AND ROWNUM = 1;
7595: /* Bug Fix: 3936336 */
7596: IF l_role_id <> p_org_contact_role_rec.org_contact_role_id OR
7597: p_create_update_flag = 'C' THEN
7598: fnd_message.set_name('AR', 'HZ_API_UNIQUE_PRIMARY_ROLE');
7599: fnd_msg_pub.add;
7600: x_return_status := fnd_api.g_ret_sts_error;
7601: END IF;
7602: EXCEPTION
7636: AND STATUS = 'A' -- Added: Bug#6411541
7637: AND ROWNUM = 1;
7638:
7639: IF l_role_id <> nvl(p_org_contact_role_rec.org_contact_role_id, fnd_api.g_miss_num) THEN
7640: fnd_message.set_name('AR', 'HZ_API_UNIQUE_ROLE_TYPE');
7641: fnd_msg_pub.add;
7642: x_return_status := fnd_api.g_ret_sts_error;
7643: END IF;
7644: EXCEPTION
7708: AND PR2.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7709: AND PR2.DIRECTIONAL_FLAG = 'F'
7710: and ocr.org_contact_role_id <>p_org_contact_role_rec.org_contact_role_id; --db primary role id is not same as the pass in role id
7711:
7712: fnd_message.set_name('AR', 'HZ_API_UNIQUE_PRIMARY_ORG_CONT');
7713: fnd_msg_pub.add;
7714: x_return_status := fnd_api.g_ret_sts_error;
7715: EXCEPTION
7716: WHEN NO_DATA_FOUND THEN
7965: WHERE party_id = p_person_language_rec.party_id;
7966:
7967: EXCEPTION
7968: WHEN NO_DATA_FOUND THEN
7969: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7970: fnd_message.set_token('FK', 'party_id');
7971: fnd_message.set_token('COLUMN', 'party_id');
7972: fnd_message.set_token('TABLE', 'hz_parties');
7973: fnd_msg_pub.add;
7966:
7967: EXCEPTION
7968: WHEN NO_DATA_FOUND THEN
7969: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7970: fnd_message.set_token('FK', 'party_id');
7971: fnd_message.set_token('COLUMN', 'party_id');
7972: fnd_message.set_token('TABLE', 'hz_parties');
7973: fnd_msg_pub.add;
7974: x_return_status := fnd_api.g_ret_sts_error;
7967: EXCEPTION
7968: WHEN NO_DATA_FOUND THEN
7969: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7970: fnd_message.set_token('FK', 'party_id');
7971: fnd_message.set_token('COLUMN', 'party_id');
7972: fnd_message.set_token('TABLE', 'hz_parties');
7973: fnd_msg_pub.add;
7974: x_return_status := fnd_api.g_ret_sts_error;
7975: END;
7968: WHEN NO_DATA_FOUND THEN
7969: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7970: fnd_message.set_token('FK', 'party_id');
7971: fnd_message.set_token('COLUMN', 'party_id');
7972: fnd_message.set_token('TABLE', 'hz_parties');
7973: fnd_msg_pub.add;
7974: x_return_status := fnd_api.g_ret_sts_error;
7975: END;
7976:
8048: FROM FND_LANGUAGES
8049: WHERE LANGUAGE_CODE = p_person_language_rec.language_name;
8050: EXCEPTION
8051: WHEN NO_DATA_FOUND THEN
8052: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
8053: fnd_message.set_token('FK', 'language_name');
8054: fnd_message.set_token('COLUMN', 'language_code');
8055: fnd_message.set_token('TABLE', 'fnd_languages');
8056: fnd_msg_pub.add;
8049: WHERE LANGUAGE_CODE = p_person_language_rec.language_name;
8050: EXCEPTION
8051: WHEN NO_DATA_FOUND THEN
8052: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
8053: fnd_message.set_token('FK', 'language_name');
8054: fnd_message.set_token('COLUMN', 'language_code');
8055: fnd_message.set_token('TABLE', 'fnd_languages');
8056: fnd_msg_pub.add;
8057: x_return_status := fnd_api.g_ret_sts_error;
8050: EXCEPTION
8051: WHEN NO_DATA_FOUND THEN
8052: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
8053: fnd_message.set_token('FK', 'language_name');
8054: fnd_message.set_token('COLUMN', 'language_code');
8055: fnd_message.set_token('TABLE', 'fnd_languages');
8056: fnd_msg_pub.add;
8057: x_return_status := fnd_api.g_ret_sts_error;
8058: END;
8051: WHEN NO_DATA_FOUND THEN
8052: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
8053: fnd_message.set_token('FK', 'language_name');
8054: fnd_message.set_token('COLUMN', 'language_code');
8055: fnd_message.set_token('TABLE', 'fnd_languages');
8056: fnd_msg_pub.add;
8057: x_return_status := fnd_api.g_ret_sts_error;
8058: END;
8059:
8080: WHERE PARTY_ID = l_party_id
8081: AND LANGUAGE_NAME = p_person_language_rec.language_name
8082: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
8083:
8084: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
8085: fnd_message.set_token('COLUMN', 'language_name');
8086: fnd_msg_pub.add;
8087: x_return_status := fnd_api.g_ret_sts_error;
8088:
8081: AND LANGUAGE_NAME = p_person_language_rec.language_name
8082: AND LANGUAGE_USE_REFERENCE_ID <> NVL(p_person_language_rec.language_use_reference_id, fnd_api.g_miss_num);
8083:
8084: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
8085: fnd_message.set_token('COLUMN', 'language_name');
8086: fnd_msg_pub.add;
8087: x_return_status := fnd_api.g_ret_sts_error;
8088:
8089: EXCEPTION
8240: INTO l_dummy
8241: FROM dual;
8242:
8243: IF l_dummy <> 'Y' THEN
8244: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8245: fnd_message.set_token('ENTITY', 'language');
8246: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8247: -- fnd_message.set_token('COLUMN2', 'status');
8248: fnd_msg_pub.add;
8241: FROM dual;
8242:
8243: IF l_dummy <> 'Y' THEN
8244: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8245: fnd_message.set_token('ENTITY', 'language');
8246: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8247: -- fnd_message.set_token('COLUMN2', 'status');
8248: fnd_msg_pub.add;
8249: x_return_status := FND_API.G_RET_STS_ERROR;
8242:
8243: IF l_dummy <> 'Y' THEN
8244: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8245: fnd_message.set_token('ENTITY', 'language');
8246: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8247: -- fnd_message.set_token('COLUMN2', 'status');
8248: fnd_msg_pub.add;
8249: x_return_status := FND_API.G_RET_STS_ERROR;
8250: END IF;
8243: IF l_dummy <> 'Y' THEN
8244: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8245: fnd_message.set_token('ENTITY', 'language');
8246: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8247: -- fnd_message.set_token('COLUMN2', 'status');
8248: fnd_msg_pub.add;
8249: x_return_status := FND_API.G_RET_STS_ERROR;
8250: END IF;
8251:
8256: THEN
8257: IF (p_person_language_rec.primary_language_indicator = 'Y'
8258: AND p_person_language_rec.status = 'I')
8259: THEN
8260: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8261: fnd_message.set_token('ENTITY', 'Language');
8262: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8263: -- fnd_message.set_token('COLUMN2', 'status');
8264: fnd_msg_pub.add;
8257: IF (p_person_language_rec.primary_language_indicator = 'Y'
8258: AND p_person_language_rec.status = 'I')
8259: THEN
8260: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8261: fnd_message.set_token('ENTITY', 'Language');
8262: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8263: -- fnd_message.set_token('COLUMN2', 'status');
8264: fnd_msg_pub.add;
8265: x_return_status := FND_API.G_RET_STS_ERROR;
8258: AND p_person_language_rec.status = 'I')
8259: THEN
8260: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8261: fnd_message.set_token('ENTITY', 'Language');
8262: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8263: -- fnd_message.set_token('COLUMN2', 'status');
8264: fnd_msg_pub.add;
8265: x_return_status := FND_API.G_RET_STS_ERROR;
8266:
8259: THEN
8260: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8261: fnd_message.set_token('ENTITY', 'Language');
8262: -- fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8263: -- fnd_message.set_token('COLUMN2', 'status');
8264: fnd_msg_pub.add;
8265: x_return_status := FND_API.G_RET_STS_ERROR;
8266:
8267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8275: ELSE -- p_create_update_flag = 'U'
8276: IF (NVL(p_person_language_rec.primary_language_indicator,l_primary_language_indicator)='Y'
8277: AND NVL(p_person_language_rec.status,l_status)='I')
8278: THEN
8279: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8280: fnd_message.set_token('ENTITY', 'Language');
8281: --fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8282: -- fnd_message.set_token('COLUMN2', 'status');
8283: fnd_msg_pub.add;
8276: IF (NVL(p_person_language_rec.primary_language_indicator,l_primary_language_indicator)='Y'
8277: AND NVL(p_person_language_rec.status,l_status)='I')
8278: THEN
8279: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8280: fnd_message.set_token('ENTITY', 'Language');
8281: --fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8282: -- fnd_message.set_token('COLUMN2', 'status');
8283: fnd_msg_pub.add;
8284: x_return_status := FND_API.G_RET_STS_ERROR;
8277: AND NVL(p_person_language_rec.status,l_status)='I')
8278: THEN
8279: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8280: fnd_message.set_token('ENTITY', 'Language');
8281: --fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8282: -- fnd_message.set_token('COLUMN2', 'status');
8283: fnd_msg_pub.add;
8284: x_return_status := FND_API.G_RET_STS_ERROR;
8285:
8278: THEN
8279: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8280: fnd_message.set_token('ENTITY', 'Language');
8281: --fnd_message.set_token('COLUMN1', 'primary_language_indicator');
8282: -- fnd_message.set_token('COLUMN2', 'status');
8283: fnd_msg_pub.add;
8284: x_return_status := FND_API.G_RET_STS_ERROR;
8285:
8286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8437: FETCH citizen_cur INTO l_dummy;
8438:
8439: -- key is not unique, push an error onto the stack.
8440: IF NVL(citizen_cur%FOUND, FALSE) THEN
8441: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
8442: fnd_message.set_token('COLUMN', 'citizenship_id');
8443: fnd_msg_pub.add;
8444: x_return_status := fnd_api.g_ret_sts_error;
8445: END IF;
8438:
8439: -- key is not unique, push an error onto the stack.
8440: IF NVL(citizen_cur%FOUND, FALSE) THEN
8441: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
8442: fnd_message.set_token('COLUMN', 'citizenship_id');
8443: fnd_msg_pub.add;
8444: x_return_status := fnd_api.g_ret_sts_error;
8445: END IF;
8446: CLOSE citizen_cur;
8565: p.party_id = p_citizenship_rec.party_id;
8566:
8567: EXCEPTION
8568: WHEN NO_DATA_FOUND THEN
8569: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
8570: -- fnd_message.set_token('FK', 'party_id');
8571: fnd_message.set_token('TABLE_NAME', 'HZ_CITIZENSHIP');
8572: fnd_message.set_token('PARTY_ID_COL', 'party_id');
8573: fnd_msg_pub.add;
8566:
8567: EXCEPTION
8568: WHEN NO_DATA_FOUND THEN
8569: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
8570: -- fnd_message.set_token('FK', 'party_id');
8571: fnd_message.set_token('TABLE_NAME', 'HZ_CITIZENSHIP');
8572: fnd_message.set_token('PARTY_ID_COL', 'party_id');
8573: fnd_msg_pub.add;
8574: x_return_status := fnd_api.g_ret_sts_error;
8567: EXCEPTION
8568: WHEN NO_DATA_FOUND THEN
8569: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
8570: -- fnd_message.set_token('FK', 'party_id');
8571: fnd_message.set_token('TABLE_NAME', 'HZ_CITIZENSHIP');
8572: fnd_message.set_token('PARTY_ID_COL', 'party_id');
8573: fnd_msg_pub.add;
8574: x_return_status := fnd_api.g_ret_sts_error;
8575: END;
8568: WHEN NO_DATA_FOUND THEN
8569: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
8570: -- fnd_message.set_token('FK', 'party_id');
8571: fnd_message.set_token('TABLE_NAME', 'HZ_CITIZENSHIP');
8572: fnd_message.set_token('PARTY_ID_COL', 'party_id');
8573: fnd_msg_pub.add;
8574: x_return_status := fnd_api.g_ret_sts_error;
8575: END;
8576:
8881: FETCH education_cur INTO l_dummy;
8882:
8883: -- key is not unique, push an error onto the stack.
8884: IF NVL(education_cur%FOUND, FALSE) THEN
8885: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
8886: fnd_message.set_token('COLUMN', 'education_id');
8887: fnd_msg_pub.add;
8888: x_return_status := fnd_api.g_ret_sts_error;
8889: END IF;
8882:
8883: -- key is not unique, push an error onto the stack.
8884: IF NVL(education_cur%FOUND, FALSE) THEN
8885: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
8886: fnd_message.set_token('COLUMN', 'education_id');
8887: fnd_msg_pub.add;
8888: x_return_status := fnd_api.g_ret_sts_error;
8889: END IF;
8890: CLOSE education_cur;
9008: party_type = 'PERSON';
9009:
9010: EXCEPTION
9011: WHEN NO_DATA_FOUND THEN
9012: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9013: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9014: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9015: fnd_msg_pub.add;
9016: x_return_status := fnd_api.g_ret_sts_error;
9009:
9010: EXCEPTION
9011: WHEN NO_DATA_FOUND THEN
9012: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9013: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9014: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9015: fnd_msg_pub.add;
9016: x_return_status := fnd_api.g_ret_sts_error;
9017: END;
9010: EXCEPTION
9011: WHEN NO_DATA_FOUND THEN
9012: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9013: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9014: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9015: fnd_msg_pub.add;
9016: x_return_status := fnd_api.g_ret_sts_error;
9017: END;
9018:
9143: temp_school_party_id <> fnd_api.g_miss_num and
9144: temp_school_attended_name is NOT NULL and
9145: temp_school_attended_name <> fnd_api.g_miss_char then
9146:
9147: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9148: fnd_message.set_token('COLUMN1', 'school_party_id');
9149: fnd_message.set_token('COLUMN2', 'school_attended_name');
9150: fnd_msg_pub.add;
9151: x_return_status := fnd_api.g_ret_sts_error;
9144: temp_school_attended_name is NOT NULL and
9145: temp_school_attended_name <> fnd_api.g_miss_char then
9146:
9147: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9148: fnd_message.set_token('COLUMN1', 'school_party_id');
9149: fnd_message.set_token('COLUMN2', 'school_attended_name');
9150: fnd_msg_pub.add;
9151: x_return_status := fnd_api.g_ret_sts_error;
9152: END IF;
9145: temp_school_attended_name <> fnd_api.g_miss_char then
9146:
9147: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9148: fnd_message.set_token('COLUMN1', 'school_party_id');
9149: fnd_message.set_token('COLUMN2', 'school_attended_name');
9150: fnd_msg_pub.add;
9151: x_return_status := fnd_api.g_ret_sts_error;
9152: END IF;
9153:
9183: PARTY_TYPE= 'ORGANIZATION';
9184:
9185: EXCEPTION
9186: WHEN NO_DATA_FOUND THEN
9187: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_ORG');
9188: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9189: fnd_message.set_token('PARTY_ID_COL', 'school_party_id');
9190: fnd_msg_pub.add;
9191: x_return_status := fnd_api.g_ret_sts_error;
9184:
9185: EXCEPTION
9186: WHEN NO_DATA_FOUND THEN
9187: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_ORG');
9188: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9189: fnd_message.set_token('PARTY_ID_COL', 'school_party_id');
9190: fnd_msg_pub.add;
9191: x_return_status := fnd_api.g_ret_sts_error;
9192: END;
9185: EXCEPTION
9186: WHEN NO_DATA_FOUND THEN
9187: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_ORG');
9188: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9189: fnd_message.set_token('PARTY_ID_COL', 'school_party_id');
9190: fnd_msg_pub.add;
9191: x_return_status := fnd_api.g_ret_sts_error;
9192: END;
9193:
9468: FETCH employment_history_cur INTO l_dummy;
9469:
9470: -- key is not unique, push an error onto the stack.
9471: IF NVL(employment_history_cur%FOUND, FALSE) THEN
9472: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
9473: fnd_message.set_token('COLUMN', 'employment_history_id');
9474: fnd_msg_pub.add;
9475: x_return_status := fnd_api.g_ret_sts_error;
9476: END IF;
9469:
9470: -- key is not unique, push an error onto the stack.
9471: IF NVL(employment_history_cur%FOUND, FALSE) THEN
9472: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
9473: fnd_message.set_token('COLUMN', 'employment_history_id');
9474: fnd_msg_pub.add;
9475: x_return_status := fnd_api.g_ret_sts_error;
9476: END IF;
9477: CLOSE employment_history_cur;
9596: party_type = 'PERSON';
9597:
9598: EXCEPTION
9599: WHEN NO_DATA_FOUND THEN
9600: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9601: fnd_message.set_token('TABLE_NAME', 'HZ_EMPLOYMENT_HISTORY');
9602: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9603: fnd_msg_pub.add;
9604: x_return_status := fnd_api.g_ret_sts_error;
9597:
9598: EXCEPTION
9599: WHEN NO_DATA_FOUND THEN
9600: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9601: fnd_message.set_token('TABLE_NAME', 'HZ_EMPLOYMENT_HISTORY');
9602: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9603: fnd_msg_pub.add;
9604: x_return_status := fnd_api.g_ret_sts_error;
9605: END;
9598: EXCEPTION
9599: WHEN NO_DATA_FOUND THEN
9600: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9601: fnd_message.set_token('TABLE_NAME', 'HZ_EMPLOYMENT_HISTORY');
9602: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9603: fnd_msg_pub.add;
9604: x_return_status := fnd_api.g_ret_sts_error;
9605: END;
9606:
9785: temp_employed_as_title_code <> FND_API.G_MISS_CHAR AND
9786: temp_employed_as_title IS NOT NULL AND
9787: temp_employed_as_title <> FND_API.G_MISS_CHAR) THEN
9788:
9789: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9790: fnd_message.set_token('COLUMN1', 'employed_as_title');
9791: fnd_message.set_token('COLUMN2', 'employed_as_title_code');
9792: fnd_msg_pub.add;
9793: x_return_status := fnd_api.g_ret_sts_error;
9786: temp_employed_as_title IS NOT NULL AND
9787: temp_employed_as_title <> FND_API.G_MISS_CHAR) THEN
9788:
9789: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9790: fnd_message.set_token('COLUMN1', 'employed_as_title');
9791: fnd_message.set_token('COLUMN2', 'employed_as_title_code');
9792: fnd_msg_pub.add;
9793: x_return_status := fnd_api.g_ret_sts_error;
9794:
9787: temp_employed_as_title <> FND_API.G_MISS_CHAR) THEN
9788:
9789: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9790: fnd_message.set_token('COLUMN1', 'employed_as_title');
9791: fnd_message.set_token('COLUMN2', 'employed_as_title_code');
9792: fnd_msg_pub.add;
9793: x_return_status := fnd_api.g_ret_sts_error;
9794:
9795: /*IF g_debug THEN
9840: WHERE PARTY_ID = p_employment_history_rec.employed_by_party_id;
9841:
9842: EXCEPTION
9843: WHEN NO_DATA_FOUND THEN
9844: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
9845: fnd_message.set_token('FK', 'employed_by_party_id');
9846: fnd_message.set_token('COLUMN', 'party_id');
9847: fnd_message.set_token('TABLE', 'hz_parties');
9848: fnd_msg_pub.add;
9841:
9842: EXCEPTION
9843: WHEN NO_DATA_FOUND THEN
9844: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
9845: fnd_message.set_token('FK', 'employed_by_party_id');
9846: fnd_message.set_token('COLUMN', 'party_id');
9847: fnd_message.set_token('TABLE', 'hz_parties');
9848: fnd_msg_pub.add;
9849: x_return_status := fnd_api.g_ret_sts_error;
9842: EXCEPTION
9843: WHEN NO_DATA_FOUND THEN
9844: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
9845: fnd_message.set_token('FK', 'employed_by_party_id');
9846: fnd_message.set_token('COLUMN', 'party_id');
9847: fnd_message.set_token('TABLE', 'hz_parties');
9848: fnd_msg_pub.add;
9849: x_return_status := fnd_api.g_ret_sts_error;
9850: END;
9843: WHEN NO_DATA_FOUND THEN
9844: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
9845: fnd_message.set_token('FK', 'employed_by_party_id');
9846: fnd_message.set_token('COLUMN', 'party_id');
9847: fnd_message.set_token('TABLE', 'hz_parties');
9848: fnd_msg_pub.add;
9849: x_return_status := fnd_api.g_ret_sts_error;
9850: END;
9851:
9898: temp_employed_by_party_id <> FND_API.G_MISS_NUM AND
9899: temp_employed_by_name_company IS NOT NULL AND
9900: temp_employed_by_name_company <> FND_API.G_MISS_CHAR) THEN
9901:
9902: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9903: fnd_message.set_token('COLUMN1', 'employed_by_name_company');
9904: fnd_message.set_token('COLUMN2', 'employed_by_party_id');
9905: fnd_msg_pub.add;
9906: x_return_status := fnd_api.g_ret_sts_error;
9899: temp_employed_by_name_company IS NOT NULL AND
9900: temp_employed_by_name_company <> FND_API.G_MISS_CHAR) THEN
9901:
9902: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9903: fnd_message.set_token('COLUMN1', 'employed_by_name_company');
9904: fnd_message.set_token('COLUMN2', 'employed_by_party_id');
9905: fnd_msg_pub.add;
9906: x_return_status := fnd_api.g_ret_sts_error;
9907:
9900: temp_employed_by_name_company <> FND_API.G_MISS_CHAR) THEN
9901:
9902: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
9903: fnd_message.set_token('COLUMN1', 'employed_by_name_company');
9904: fnd_message.set_token('COLUMN2', 'employed_by_party_id');
9905: fnd_msg_pub.add;
9906: x_return_status := fnd_api.g_ret_sts_error;
9907:
9908: /*IF g_debug THEN
9950:
9951: IF p_employment_history_rec.weekly_work_hours < 0 OR
9952: p_employment_history_rec.weekly_work_hours > 168 THEN
9953:
9954: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
9955: fnd_message.set_token('COLUMN', 'weekly_work_hours');
9956: -- Bug 4226199 : This should be changed for bug 3848056
9957: fnd_message.set_token('VALUE1', '0');
9958: fnd_message.set_token('VALUE2', '168');
9951: IF p_employment_history_rec.weekly_work_hours < 0 OR
9952: p_employment_history_rec.weekly_work_hours > 168 THEN
9953:
9954: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
9955: fnd_message.set_token('COLUMN', 'weekly_work_hours');
9956: -- Bug 4226199 : This should be changed for bug 3848056
9957: fnd_message.set_token('VALUE1', '0');
9958: fnd_message.set_token('VALUE2', '168');
9959: fnd_msg_pub.add;
9953:
9954: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
9955: fnd_message.set_token('COLUMN', 'weekly_work_hours');
9956: -- Bug 4226199 : This should be changed for bug 3848056
9957: fnd_message.set_token('VALUE1', '0');
9958: fnd_message.set_token('VALUE2', '168');
9959: fnd_msg_pub.add;
9960: x_return_status := fnd_api.g_ret_sts_error;
9961: END IF;
9954: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
9955: fnd_message.set_token('COLUMN', 'weekly_work_hours');
9956: -- Bug 4226199 : This should be changed for bug 3848056
9957: fnd_message.set_token('VALUE1', '0');
9958: fnd_message.set_token('VALUE2', '168');
9959: fnd_msg_pub.add;
9960: x_return_status := fnd_api.g_ret_sts_error;
9961: END IF;
9962:
10082: p_msg_level=>fnd_log.level_statement);
10083: END IF;
10084:
10085: ELSE
10086: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10087: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10088: fnd_message.set_token('COLUMN2', 'tenure_code');
10089: fnd_message.set_token('VALUE1', 'N');
10090: fnd_message.set_token('VALUE2', 'null');
10083: END IF;
10084:
10085: ELSE
10086: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10087: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10088: fnd_message.set_token('COLUMN2', 'tenure_code');
10089: fnd_message.set_token('VALUE1', 'N');
10090: fnd_message.set_token('VALUE2', 'null');
10091: fnd_msg_pub.add;
10084:
10085: ELSE
10086: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10087: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10088: fnd_message.set_token('COLUMN2', 'tenure_code');
10089: fnd_message.set_token('VALUE1', 'N');
10090: fnd_message.set_token('VALUE2', 'null');
10091: fnd_msg_pub.add;
10092: x_return_status := fnd_api.g_ret_sts_error;
10085: ELSE
10086: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10087: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10088: fnd_message.set_token('COLUMN2', 'tenure_code');
10089: fnd_message.set_token('VALUE1', 'N');
10090: fnd_message.set_token('VALUE2', 'null');
10091: fnd_msg_pub.add;
10092: x_return_status := fnd_api.g_ret_sts_error;
10093:
10086: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10087: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10088: fnd_message.set_token('COLUMN2', 'tenure_code');
10089: fnd_message.set_token('VALUE1', 'N');
10090: fnd_message.set_token('VALUE2', 'null');
10091: fnd_msg_pub.add;
10092: x_return_status := fnd_api.g_ret_sts_error;
10093:
10094: END IF;
10119: IF temp_faculty_position_flag = 'Y' then
10120: IF p_employment_history_rec.fraction_of_tenure < 0 OR
10121: p_employment_history_rec.fraction_of_tenure > 100 THEN
10122:
10123: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
10124: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10125: fnd_message.set_token('VALUE1', '0');
10126: fnd_message.set_token('VALUE2', '100');
10127: fnd_msg_pub.add;
10120: IF p_employment_history_rec.fraction_of_tenure < 0 OR
10121: p_employment_history_rec.fraction_of_tenure > 100 THEN
10122:
10123: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
10124: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10125: fnd_message.set_token('VALUE1', '0');
10126: fnd_message.set_token('VALUE2', '100');
10127: fnd_msg_pub.add;
10128: x_return_status := fnd_api.g_ret_sts_error;
10121: p_employment_history_rec.fraction_of_tenure > 100 THEN
10122:
10123: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
10124: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10125: fnd_message.set_token('VALUE1', '0');
10126: fnd_message.set_token('VALUE2', '100');
10127: fnd_msg_pub.add;
10128: x_return_status := fnd_api.g_ret_sts_error;
10129: END IF;
10122:
10123: fnd_message.set_name('AR', 'HZ_API_VALUE_BETWEEN');
10124: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10125: fnd_message.set_token('VALUE1', '0');
10126: fnd_message.set_token('VALUE2', '100');
10127: fnd_msg_pub.add;
10128: x_return_status := fnd_api.g_ret_sts_error;
10129: END IF;
10130:
10141: p_msg_level=>fnd_log.level_statement);
10142: END IF;
10143:
10144: ELSE
10145: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10146: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10147: fnd_message.set_token('COLUMN2', 'fraction_of_tenure');
10148: fnd_message.set_token('VALUE1', 'N');
10149: fnd_message.set_token('VALUE2', 'null');
10142: END IF;
10143:
10144: ELSE
10145: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10146: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10147: fnd_message.set_token('COLUMN2', 'fraction_of_tenure');
10148: fnd_message.set_token('VALUE1', 'N');
10149: fnd_message.set_token('VALUE2', 'null');
10150:
10143:
10144: ELSE
10145: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10146: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10147: fnd_message.set_token('COLUMN2', 'fraction_of_tenure');
10148: fnd_message.set_token('VALUE1', 'N');
10149: fnd_message.set_token('VALUE2', 'null');
10150:
10151: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10144: ELSE
10145: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10146: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10147: fnd_message.set_token('COLUMN2', 'fraction_of_tenure');
10148: fnd_message.set_token('VALUE1', 'N');
10149: fnd_message.set_token('VALUE2', 'null');
10150:
10151: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10152: fnd_msg_pub.add;
10145: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
10146: fnd_message.set_token('COLUMN1', 'faculty_position_flag');
10147: fnd_message.set_token('COLUMN2', 'fraction_of_tenure');
10148: fnd_message.set_token('VALUE1', 'N');
10149: fnd_message.set_token('VALUE2', 'null');
10150:
10151: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10152: fnd_msg_pub.add;
10153: x_return_status := fnd_api.g_ret_sts_error;
10147: fnd_message.set_token('COLUMN2', 'fraction_of_tenure');
10148: fnd_message.set_token('VALUE1', 'N');
10149: fnd_message.set_token('VALUE2', 'null');
10150:
10151: fnd_message.set_token('COLUMN', 'fraction_of_tenure');
10152: fnd_msg_pub.add;
10153: x_return_status := fnd_api.g_ret_sts_error;
10154: END IF;
10155:
10351: FETCH work_class_cur INTO l_dummy;
10352:
10353: -- key is not unique, push an error onto the stack.
10354: IF NVL(work_class_cur%FOUND, FALSE) THEN
10355: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
10356: fnd_message.set_token('COLUMN', 'work_class_id');
10357: fnd_msg_pub.add;
10358: x_return_status := fnd_api.g_ret_sts_error;
10359: END IF;
10352:
10353: -- key is not unique, push an error onto the stack.
10354: IF NVL(work_class_cur%FOUND, FALSE) THEN
10355: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
10356: fnd_message.set_token('COLUMN', 'work_class_id');
10357: fnd_msg_pub.add;
10358: x_return_status := fnd_api.g_ret_sts_error;
10359: END IF;
10360: CLOSE work_class_cur;
10476: WHERE p.employment_history_id = p_work_class_rec.employment_history_id;
10477:
10478: EXCEPTION
10479: WHEN NO_DATA_FOUND THEN
10480: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10481: fnd_message.set_token('FK', 'employment_history_id');
10482: fnd_message.set_token('COLUMN', 'employment_history_id');
10483: fnd_message.set_token('TABLE', 'hz_employment_history');
10484: fnd_msg_pub.add;
10477:
10478: EXCEPTION
10479: WHEN NO_DATA_FOUND THEN
10480: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10481: fnd_message.set_token('FK', 'employment_history_id');
10482: fnd_message.set_token('COLUMN', 'employment_history_id');
10483: fnd_message.set_token('TABLE', 'hz_employment_history');
10484: fnd_msg_pub.add;
10485: x_return_status := fnd_api.g_ret_sts_error;
10478: EXCEPTION
10479: WHEN NO_DATA_FOUND THEN
10480: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10481: fnd_message.set_token('FK', 'employment_history_id');
10482: fnd_message.set_token('COLUMN', 'employment_history_id');
10483: fnd_message.set_token('TABLE', 'hz_employment_history');
10484: fnd_msg_pub.add;
10485: x_return_status := fnd_api.g_ret_sts_error;
10486: END;
10479: WHEN NO_DATA_FOUND THEN
10480: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10481: fnd_message.set_token('FK', 'employment_history_id');
10482: fnd_message.set_token('COLUMN', 'employment_history_id');
10483: fnd_message.set_token('TABLE', 'hz_employment_history');
10484: fnd_msg_pub.add;
10485: x_return_status := fnd_api.g_ret_sts_error;
10486: END;
10487:
10713: FETCH person_interest_cur INTO l_dummy;
10714:
10715: -- key is not unique, push an error onto the stack.
10716: IF NVL(person_interest_cur%FOUND, FALSE) THEN
10717: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
10718: fnd_message.set_token('COLUMN', 'person_interest_id');
10719: fnd_msg_pub.add;
10720: x_return_status := fnd_api.g_ret_sts_error;
10721: END IF;
10714:
10715: -- key is not unique, push an error onto the stack.
10716: IF NVL(person_interest_cur%FOUND, FALSE) THEN
10717: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
10718: fnd_message.set_token('COLUMN', 'person_interest_id');
10719: fnd_msg_pub.add;
10720: x_return_status := fnd_api.g_ret_sts_error;
10721: END IF;
10722: CLOSE person_interest_cur;
10843: */
10844:
10845: EXCEPTION
10846: WHEN NO_DATA_FOUND THEN
10847: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10848: fnd_message.set_token('FK', 'party_id');
10849: fnd_message.set_token('COLUMN', 'party_id');
10850: fnd_message.set_token('TABLE', 'hz_parties');
10851: fnd_msg_pub.add;
10844:
10845: EXCEPTION
10846: WHEN NO_DATA_FOUND THEN
10847: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10848: fnd_message.set_token('FK', 'party_id');
10849: fnd_message.set_token('COLUMN', 'party_id');
10850: fnd_message.set_token('TABLE', 'hz_parties');
10851: fnd_msg_pub.add;
10852: x_return_status := fnd_api.g_ret_sts_error;
10845: EXCEPTION
10846: WHEN NO_DATA_FOUND THEN
10847: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10848: fnd_message.set_token('FK', 'party_id');
10849: fnd_message.set_token('COLUMN', 'party_id');
10850: fnd_message.set_token('TABLE', 'hz_parties');
10851: fnd_msg_pub.add;
10852: x_return_status := fnd_api.g_ret_sts_error;
10853: END;
10846: WHEN NO_DATA_FOUND THEN
10847: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
10848: fnd_message.set_token('FK', 'party_id');
10849: fnd_message.set_token('COLUMN', 'party_id');
10850: fnd_message.set_token('TABLE', 'hz_parties');
10851: fnd_msg_pub.add;
10852: x_return_status := fnd_api.g_ret_sts_error;
10853: END;
10854:
11378: x_return_status => x_return_status);
11379: -- Bug 4693719 : set global variable to Y
11380: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
11381: /*
11382: FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
11383: FND_MSG_PUB.ADD;
11384: x_return_status := FND_API.G_RET_STS_ERROR;
11385: */
11386: END IF;
11417: WHERE LANGUAGE_CODE = p_location_rec.language
11418: AND INSTALLED_FLAG IN ('B', 'I');
11419: EXCEPTION
11420: WHEN NO_DATA_FOUND THEN
11421: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11422: fnd_message.set_token('FK', 'language');
11423: fnd_message.set_token('COLUMN', 'language_code');
11424: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
11425: fnd_msg_pub.add;
11418: AND INSTALLED_FLAG IN ('B', 'I');
11419: EXCEPTION
11420: WHEN NO_DATA_FOUND THEN
11421: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11422: fnd_message.set_token('FK', 'language');
11423: fnd_message.set_token('COLUMN', 'language_code');
11424: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
11425: fnd_msg_pub.add;
11426: x_return_status := fnd_api.g_ret_sts_error;
11419: EXCEPTION
11420: WHEN NO_DATA_FOUND THEN
11421: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11422: fnd_message.set_token('FK', 'language');
11423: fnd_message.set_token('COLUMN', 'language_code');
11424: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
11425: fnd_msg_pub.add;
11426: x_return_status := fnd_api.g_ret_sts_error;
11427: END;
11420: WHEN NO_DATA_FOUND THEN
11421: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11422: fnd_message.set_token('FK', 'language');
11423: fnd_message.set_token('COLUMN', 'language_code');
11424: fnd_message.set_token('TABLE', 'fnd_languages(installed)');
11425: fnd_msg_pub.add;
11426: x_return_status := fnd_api.g_ret_sts_error;
11427: END;
11428:
11454: FROM HZ_TIMEZONES
11455: WHERE TIMEZONE_ID = p_location_rec.timezone_id;
11456: EXCEPTION
11457: WHEN NO_DATA_FOUND THEN
11458: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11459: fnd_message.set_token('FK', 'timezone_id');
11460: fnd_message.set_token('COLUMN', 'timezone_id');
11461: fnd_message.set_token('TABLE', 'hz_timezones');
11462: fnd_msg_pub.add;
11455: WHERE TIMEZONE_ID = p_location_rec.timezone_id;
11456: EXCEPTION
11457: WHEN NO_DATA_FOUND THEN
11458: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11459: fnd_message.set_token('FK', 'timezone_id');
11460: fnd_message.set_token('COLUMN', 'timezone_id');
11461: fnd_message.set_token('TABLE', 'hz_timezones');
11462: fnd_msg_pub.add;
11463: x_return_status := fnd_api.g_ret_sts_error;
11456: EXCEPTION
11457: WHEN NO_DATA_FOUND THEN
11458: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11459: fnd_message.set_token('FK', 'timezone_id');
11460: fnd_message.set_token('COLUMN', 'timezone_id');
11461: fnd_message.set_token('TABLE', 'hz_timezones');
11462: fnd_msg_pub.add;
11463: x_return_status := fnd_api.g_ret_sts_error;
11464: END;
11457: WHEN NO_DATA_FOUND THEN
11458: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
11459: fnd_message.set_token('FK', 'timezone_id');
11460: fnd_message.set_token('COLUMN', 'timezone_id');
11461: fnd_message.set_token('TABLE', 'hz_timezones');
11462: fnd_msg_pub.add;
11463: x_return_status := fnd_api.g_ret_sts_error;
11464: END;
11465:
11745: )
11746: THEN
11747: IF ARH_ADDR_PKG.check_tran_for_all_accts(p_location_rec.location_id)
11748: THEN
11749: fnd_message.set_name('AR', 'AR_CUST_ADDR_HAS_TRANSACTION');
11750: --Bug 2452282 fnd_message.set_token('COLUMN', 'tax related fields');
11751: fnd_msg_pub.add;
11752: x_return_status := fnd_api.g_ret_sts_error;
11753: ELSE -- non taxable components to be modified
11746: THEN
11747: IF ARH_ADDR_PKG.check_tran_for_all_accts(p_location_rec.location_id)
11748: THEN
11749: fnd_message.set_name('AR', 'AR_CUST_ADDR_HAS_TRANSACTION');
11750: --Bug 2452282 fnd_message.set_token('COLUMN', 'tax related fields');
11751: fnd_msg_pub.add;
11752: x_return_status := fnd_api.g_ret_sts_error;
11753: ELSE -- non taxable components to be modified
11754: null; -- allow updates
12117: AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE) AND TRUNC(NVL(END_DATE, SYSDATE))
12118: AND ROWNUM = 1;
12119:
12120: -- update is not allowed, raise error
12121: fnd_message.set_name('AR', 'HZ_API_CPF_NON_UPDATEABLE');
12122: fnd_msg_pub.add;
12123: x_return_status := fnd_api.g_ret_sts_error;
12124:
12125: EXCEPTION
12143: AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE) AND TRUNC(NVL(END_DATE, SYSDATE))
12144: AND ROWNUM = 1;
12145:
12146: -- update is not allowed, raise error
12147: fnd_message.set_name('AR', 'HZ_API_CPF_NON_UPDATEABLE');
12148: fnd_msg_pub.add;
12149: x_return_status := fnd_api.g_ret_sts_error;
12150:
12151: EXCEPTION
12480: FROM FND_OBJECT_INSTANCE_SETS
12481: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.subject_type;
12482: EXCEPTION
12483: WHEN NO_DATA_FOUND THEN
12484: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12485: fnd_message.set_token('FK', 'subject_type');
12486: fnd_message.set_token('COLUMN', 'instance_set_name');
12487: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12488: fnd_msg_pub.add;
12481: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.subject_type;
12482: EXCEPTION
12483: WHEN NO_DATA_FOUND THEN
12484: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12485: fnd_message.set_token('FK', 'subject_type');
12486: fnd_message.set_token('COLUMN', 'instance_set_name');
12487: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12488: fnd_msg_pub.add;
12489: x_return_status := fnd_api.g_ret_sts_error;
12482: EXCEPTION
12483: WHEN NO_DATA_FOUND THEN
12484: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12485: fnd_message.set_token('FK', 'subject_type');
12486: fnd_message.set_token('COLUMN', 'instance_set_name');
12487: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12488: fnd_msg_pub.add;
12489: x_return_status := fnd_api.g_ret_sts_error;
12490: END;
12483: WHEN NO_DATA_FOUND THEN
12484: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12485: fnd_message.set_token('FK', 'subject_type');
12486: fnd_message.set_token('COLUMN', 'instance_set_name');
12487: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12488: fnd_msg_pub.add;
12489: x_return_status := fnd_api.g_ret_sts_error;
12490: END;
12491:
12563: FROM FND_OBJECT_INSTANCE_SETS
12564: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.object_type;
12565: EXCEPTION
12566: WHEN NO_DATA_FOUND THEN
12567: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12568: fnd_message.set_token('FK', 'object_type');
12569: fnd_message.set_token('COLUMN', 'instance_set_name');
12570: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12571: fnd_msg_pub.add;
12564: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.object_type;
12565: EXCEPTION
12566: WHEN NO_DATA_FOUND THEN
12567: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12568: fnd_message.set_token('FK', 'object_type');
12569: fnd_message.set_token('COLUMN', 'instance_set_name');
12570: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12571: fnd_msg_pub.add;
12572: x_return_status := fnd_api.g_ret_sts_error;
12565: EXCEPTION
12566: WHEN NO_DATA_FOUND THEN
12567: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12568: fnd_message.set_token('FK', 'object_type');
12569: fnd_message.set_token('COLUMN', 'instance_set_name');
12570: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12571: fnd_msg_pub.add;
12572: x_return_status := fnd_api.g_ret_sts_error;
12573: END;
12566: WHEN NO_DATA_FOUND THEN
12567: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12568: fnd_message.set_token('FK', 'object_type');
12569: fnd_message.set_token('COLUMN', 'instance_set_name');
12570: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12571: fnd_msg_pub.add;
12572: x_return_status := fnd_api.g_ret_sts_error;
12573: END;
12574:
12645: | AND ROWNUM = 1;
12646: | -- if the backward_rel_code passed do not match with whatever
12647: | -- obtained from above query, error out NOCOPY
12648: | IF l_code <> p_relationship_type_rec.backward_rel_code then
12649: | fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION');
12650: | fnd_msg_pub.add;
12651: | x_return_status := FND_API.G_RET_STS_ERROR;
12652: | END IF;
12653: | END IF;
12697: );
12698:
12699: IF l_count <> 0
12700: THEN
12701: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION');
12702: fnd_msg_pub.add;
12703: x_return_status := FND_API.G_RET_STS_ERROR;
12704: END IF;
12705:
12732: AND SUBJECT_TYPE = p_relationship_type_rec.subject_type
12733: AND OBJECT_TYPE = p_relationship_type_rec.object_type
12734: AND RELATIONSHIP_TYPE_ID <> NVL(p_relationship_type_rec.relationship_type_id,-1);
12735:
12736: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
12737: fnd_message.set_token('COLUMN', 'relationship type, forward rel code, backward rel code, subject type, object type');
12738: fnd_msg_pub.add;
12739: x_return_status := fnd_api.g_ret_sts_error;
12740:
12733: AND OBJECT_TYPE = p_relationship_type_rec.object_type
12734: AND RELATIONSHIP_TYPE_ID <> NVL(p_relationship_type_rec.relationship_type_id,-1);
12735:
12736: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
12737: fnd_message.set_token('COLUMN', 'relationship type, forward rel code, backward rel code, subject type, object type');
12738: fnd_msg_pub.add;
12739: x_return_status := fnd_api.g_ret_sts_error;
12740:
12741: EXCEPTION
12765: IF p_relationship_type_rec.forward_rel_code = p_relationship_type_rec.backward_rel_code
12766: AND
12767: p_relationship_type_rec.direction_code <> 'N'
12768: THEN
12769: fnd_message.set_name('AR', 'HZ_INVALID_DIRECTION_CODE1');
12770: fnd_msg_pub.add;
12771: x_return_status := FND_API.G_RET_STS_ERROR;
12772: END IF;
12773:
12775: -- cannot be 'N'
12776: IF p_relationship_type_rec.forward_rel_code <> p_relationship_type_rec.backward_rel_code
12777: AND p_relationship_type_rec.direction_code = 'N'
12778: THEN
12779: fnd_message.set_name('AR', 'HZ_INVALID_DIRECTION_CODE2');
12780: fnd_msg_pub.add;
12781: x_return_status := FND_API.G_RET_STS_ERROR;
12782: END IF;
12783:
12848: IF p_create_update_flag = 'C' THEN
12849: -- if hierarchical_flag = 'Y', then allow_circular_relationships must be 'N'
12850: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12851: IF p_relationship_type_rec.allow_circular_relationships = 'Y' THEN
12852: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12853: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12854: fnd_message.set_token('VALUE1', 'Y(Yes)');
12855: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
12856: fnd_message.set_token('VALUE2', 'N(No)');
12849: -- if hierarchical_flag = 'Y', then allow_circular_relationships must be 'N'
12850: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12851: IF p_relationship_type_rec.allow_circular_relationships = 'Y' THEN
12852: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12853: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12854: fnd_message.set_token('VALUE1', 'Y(Yes)');
12855: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
12856: fnd_message.set_token('VALUE2', 'N(No)');
12857: fnd_msg_pub.add;
12850: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12851: IF p_relationship_type_rec.allow_circular_relationships = 'Y' THEN
12852: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12853: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12854: fnd_message.set_token('VALUE1', 'Y(Yes)');
12855: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
12856: fnd_message.set_token('VALUE2', 'N(No)');
12857: fnd_msg_pub.add;
12858: x_return_status := FND_API.G_RET_STS_ERROR;
12851: IF p_relationship_type_rec.allow_circular_relationships = 'Y' THEN
12852: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12853: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12854: fnd_message.set_token('VALUE1', 'Y(Yes)');
12855: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
12856: fnd_message.set_token('VALUE2', 'N(No)');
12857: fnd_msg_pub.add;
12858: x_return_status := FND_API.G_RET_STS_ERROR;
12859: END IF;
12852: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12853: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12854: fnd_message.set_token('VALUE1', 'Y(Yes)');
12855: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
12856: fnd_message.set_token('VALUE2', 'N(No)');
12857: fnd_msg_pub.add;
12858: x_return_status := FND_API.G_RET_STS_ERROR;
12859: END IF;
12860: END IF;
12880: IF p_create_update_flag = 'C' THEN
12881: -- if hierarchical_flag = 'Y', the direction_code must be 'P' or 'C'
12882: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12883: IF p_relationship_type_rec.direction_code = 'N' THEN
12884: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12885: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12886: fnd_message.set_token('VALUE1', 'Y(Yes)');
12887: fnd_message.set_token('COLUMN2', 'direction_code');
12888: fnd_message.set_token('VALUE2', 'P(Parent)/C(Child)');
12881: -- if hierarchical_flag = 'Y', the direction_code must be 'P' or 'C'
12882: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12883: IF p_relationship_type_rec.direction_code = 'N' THEN
12884: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12885: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12886: fnd_message.set_token('VALUE1', 'Y(Yes)');
12887: fnd_message.set_token('COLUMN2', 'direction_code');
12888: fnd_message.set_token('VALUE2', 'P(Parent)/C(Child)');
12889: fnd_msg_pub.add;
12882: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12883: IF p_relationship_type_rec.direction_code = 'N' THEN
12884: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12885: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12886: fnd_message.set_token('VALUE1', 'Y(Yes)');
12887: fnd_message.set_token('COLUMN2', 'direction_code');
12888: fnd_message.set_token('VALUE2', 'P(Parent)/C(Child)');
12889: fnd_msg_pub.add;
12890: x_return_status := FND_API.G_RET_STS_ERROR;
12883: IF p_relationship_type_rec.direction_code = 'N' THEN
12884: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12885: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12886: fnd_message.set_token('VALUE1', 'Y(Yes)');
12887: fnd_message.set_token('COLUMN2', 'direction_code');
12888: fnd_message.set_token('VALUE2', 'P(Parent)/C(Child)');
12889: fnd_msg_pub.add;
12890: x_return_status := FND_API.G_RET_STS_ERROR;
12891: END IF;
12884: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12885: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12886: fnd_message.set_token('VALUE1', 'Y(Yes)');
12887: fnd_message.set_token('COLUMN2', 'direction_code');
12888: fnd_message.set_token('VALUE2', 'P(Parent)/C(Child)');
12889: fnd_msg_pub.add;
12890: x_return_status := FND_API.G_RET_STS_ERROR;
12891: END IF;
12892: END IF;
12914: FROM HZ_RELATIONSHIP_TYPES
12915: WHERE ROLE = p_relationship_type_rec.forward_role
12916: OR ROLE = p_relationship_type_rec.backward_role;
12917: IF l_count > 0 THEN
12918: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
12919: fnd_message.set_token('COLUMN', 'role');
12920: fnd_msg_pub.add;
12921: x_return_status := fnd_api.g_ret_sts_error;
12922: END IF;
12915: WHERE ROLE = p_relationship_type_rec.forward_role
12916: OR ROLE = p_relationship_type_rec.backward_role;
12917: IF l_count > 0 THEN
12918: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
12919: fnd_message.set_token('COLUMN', 'role');
12920: fnd_msg_pub.add;
12921: x_return_status := fnd_api.g_ret_sts_error;
12922: END IF;
12923: END;
12964: IF p_create_update_flag = 'C' THEN
12965: -- if hierarchical_flag = 'Y', then allow_relate_to_self_flag must be 'N'
12966: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12967: IF p_relationship_type_rec.allow_relate_to_self_flag = 'Y' THEN
12968: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12969: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12970: fnd_message.set_token('VALUE1', 'Y(Yes)');
12971: fnd_message.set_token('COLUMN2', 'allow_relate_to_self_flag');
12972: fnd_message.set_token('VALUE2', 'N(No)');
12965: -- if hierarchical_flag = 'Y', then allow_relate_to_self_flag must be 'N'
12966: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12967: IF p_relationship_type_rec.allow_relate_to_self_flag = 'Y' THEN
12968: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12969: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12970: fnd_message.set_token('VALUE1', 'Y(Yes)');
12971: fnd_message.set_token('COLUMN2', 'allow_relate_to_self_flag');
12972: fnd_message.set_token('VALUE2', 'N(No)');
12973: fnd_msg_pub.add;
12966: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'Y' THEN
12967: IF p_relationship_type_rec.allow_relate_to_self_flag = 'Y' THEN
12968: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12969: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12970: fnd_message.set_token('VALUE1', 'Y(Yes)');
12971: fnd_message.set_token('COLUMN2', 'allow_relate_to_self_flag');
12972: fnd_message.set_token('VALUE2', 'N(No)');
12973: fnd_msg_pub.add;
12974: x_return_status := FND_API.G_RET_STS_ERROR;
12967: IF p_relationship_type_rec.allow_relate_to_self_flag = 'Y' THEN
12968: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12969: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12970: fnd_message.set_token('VALUE1', 'Y(Yes)');
12971: fnd_message.set_token('COLUMN2', 'allow_relate_to_self_flag');
12972: fnd_message.set_token('VALUE2', 'N(No)');
12973: fnd_msg_pub.add;
12974: x_return_status := FND_API.G_RET_STS_ERROR;
12975: END IF;
12968: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
12969: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
12970: fnd_message.set_token('VALUE1', 'Y(Yes)');
12971: fnd_message.set_token('COLUMN2', 'allow_relate_to_self_flag');
12972: fnd_message.set_token('VALUE2', 'N(No)');
12973: fnd_msg_pub.add;
12974: x_return_status := FND_API.G_RET_STS_ERROR;
12975: END IF;
12976: END IF;
12997: IF p_create_update_flag = 'C' THEN
12998: -- if direction_code = 'N', the allow_circular_relationships must be 'Y'
12999: IF p_relationship_type_rec.direction_code = 'N' THEN
13000: IF NVL(p_relationship_type_rec.allow_circular_relationships, 'Y') = 'N' THEN
13001: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13002: fnd_message.set_token('COLUMN1', 'direction_code');
13003: fnd_message.set_token('VALUE1', 'N(No)');
13004: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13005: fnd_message.set_token('VALUE2', 'Y(Yes)');
12998: -- if direction_code = 'N', the allow_circular_relationships must be 'Y'
12999: IF p_relationship_type_rec.direction_code = 'N' THEN
13000: IF NVL(p_relationship_type_rec.allow_circular_relationships, 'Y') = 'N' THEN
13001: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13002: fnd_message.set_token('COLUMN1', 'direction_code');
13003: fnd_message.set_token('VALUE1', 'N(No)');
13004: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13005: fnd_message.set_token('VALUE2', 'Y(Yes)');
13006: fnd_msg_pub.add;
12999: IF p_relationship_type_rec.direction_code = 'N' THEN
13000: IF NVL(p_relationship_type_rec.allow_circular_relationships, 'Y') = 'N' THEN
13001: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13002: fnd_message.set_token('COLUMN1', 'direction_code');
13003: fnd_message.set_token('VALUE1', 'N(No)');
13004: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13005: fnd_message.set_token('VALUE2', 'Y(Yes)');
13006: fnd_msg_pub.add;
13007: x_return_status := FND_API.G_RET_STS_ERROR;
13000: IF NVL(p_relationship_type_rec.allow_circular_relationships, 'Y') = 'N' THEN
13001: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13002: fnd_message.set_token('COLUMN1', 'direction_code');
13003: fnd_message.set_token('VALUE1', 'N(No)');
13004: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13005: fnd_message.set_token('VALUE2', 'Y(Yes)');
13006: fnd_msg_pub.add;
13007: x_return_status := FND_API.G_RET_STS_ERROR;
13008: END IF;
13001: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13002: fnd_message.set_token('COLUMN1', 'direction_code');
13003: fnd_message.set_token('VALUE1', 'N(No)');
13004: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13005: fnd_message.set_token('VALUE2', 'Y(Yes)');
13006: fnd_msg_pub.add;
13007: x_return_status := FND_API.G_RET_STS_ERROR;
13008: END IF;
13009: END IF;
13039: IF p_create_update_flag = 'C' THEN
13040: -- if hierarchical_flag = 'N', then multiple_parent_allowed must be 'Y'
13041: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'N' THEN
13042: IF NVL(p_relationship_type_rec.multiple_parent_allowed, 'Y') = 'N' THEN
13043: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13044: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
13045: fnd_message.set_token('VALUE1', 'N(No)');
13046: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13047: fnd_message.set_token('VALUE2', 'Y(Yes)');
13040: -- if hierarchical_flag = 'N', then multiple_parent_allowed must be 'Y'
13041: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'N' THEN
13042: IF NVL(p_relationship_type_rec.multiple_parent_allowed, 'Y') = 'N' THEN
13043: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13044: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
13045: fnd_message.set_token('VALUE1', 'N(No)');
13046: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13047: fnd_message.set_token('VALUE2', 'Y(Yes)');
13048: fnd_msg_pub.add;
13041: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N') = 'N' THEN
13042: IF NVL(p_relationship_type_rec.multiple_parent_allowed, 'Y') = 'N' THEN
13043: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13044: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
13045: fnd_message.set_token('VALUE1', 'N(No)');
13046: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13047: fnd_message.set_token('VALUE2', 'Y(Yes)');
13048: fnd_msg_pub.add;
13049: x_return_status := FND_API.G_RET_STS_ERROR;
13042: IF NVL(p_relationship_type_rec.multiple_parent_allowed, 'Y') = 'N' THEN
13043: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13044: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
13045: fnd_message.set_token('VALUE1', 'N(No)');
13046: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13047: fnd_message.set_token('VALUE2', 'Y(Yes)');
13048: fnd_msg_pub.add;
13049: x_return_status := FND_API.G_RET_STS_ERROR;
13050: END IF;
13043: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
13044: fnd_message.set_token('COLUMN1', 'hierarchical_flag');
13045: fnd_message.set_token('VALUE1', 'N(No)');
13046: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13047: fnd_message.set_token('VALUE2', 'Y(Yes)');
13048: fnd_msg_pub.add;
13049: x_return_status := FND_API.G_RET_STS_ERROR;
13050: END IF;
13051: END IF;
13080: and
13081: NVL(p_relationship_type_rec.hierarchical_flag, 'Y')
13082: <> NVL(l_hierarchical_flag, 'Y')
13083: THEN
13084: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13085: fnd_message.set_token('ENTITY', 'relationship type');
13086: fnd_message.set_token('COLUMN1', 'relationship_type');
13087: fnd_message.set_token('COLUMN2', 'hierarchical_flag');
13088: fnd_msg_pub.add;
13081: NVL(p_relationship_type_rec.hierarchical_flag, 'Y')
13082: <> NVL(l_hierarchical_flag, 'Y')
13083: THEN
13084: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13085: fnd_message.set_token('ENTITY', 'relationship type');
13086: fnd_message.set_token('COLUMN1', 'relationship_type');
13087: fnd_message.set_token('COLUMN2', 'hierarchical_flag');
13088: fnd_msg_pub.add;
13089: x_return_status := FND_API.G_RET_STS_ERROR;
13082: <> NVL(l_hierarchical_flag, 'Y')
13083: THEN
13084: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13085: fnd_message.set_token('ENTITY', 'relationship type');
13086: fnd_message.set_token('COLUMN1', 'relationship_type');
13087: fnd_message.set_token('COLUMN2', 'hierarchical_flag');
13088: fnd_msg_pub.add;
13089: x_return_status := FND_API.G_RET_STS_ERROR;
13090: END IF;
13083: THEN
13084: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13085: fnd_message.set_token('ENTITY', 'relationship type');
13086: fnd_message.set_token('COLUMN1', 'relationship_type');
13087: fnd_message.set_token('COLUMN2', 'hierarchical_flag');
13088: fnd_msg_pub.add;
13089: x_return_status := FND_API.G_RET_STS_ERROR;
13090: END IF;
13091:
13126: and
13127: NVL(p_relationship_type_rec.allow_circular_relationships, 'Y') <>
13128: NVL(l_allow_circular_relationships, 'Y')
13129: THEN
13130: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13131: fnd_message.set_token('ENTITY', 'relationship type');
13132: fnd_message.set_token('COLUMN1', 'relationship_type');
13133: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13134: fnd_msg_pub.add;
13127: NVL(p_relationship_type_rec.allow_circular_relationships, 'Y') <>
13128: NVL(l_allow_circular_relationships, 'Y')
13129: THEN
13130: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13131: fnd_message.set_token('ENTITY', 'relationship type');
13132: fnd_message.set_token('COLUMN1', 'relationship_type');
13133: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13134: fnd_msg_pub.add;
13135: x_return_status := FND_API.G_RET_STS_ERROR;
13128: NVL(l_allow_circular_relationships, 'Y')
13129: THEN
13130: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13131: fnd_message.set_token('ENTITY', 'relationship type');
13132: fnd_message.set_token('COLUMN1', 'relationship_type');
13133: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13134: fnd_msg_pub.add;
13135: x_return_status := FND_API.G_RET_STS_ERROR;
13136: END IF;
13129: THEN
13130: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13131: fnd_message.set_token('ENTITY', 'relationship type');
13132: fnd_message.set_token('COLUMN1', 'relationship_type');
13133: fnd_message.set_token('COLUMN2', 'allow_circular_relationships');
13134: fnd_msg_pub.add;
13135: x_return_status := FND_API.G_RET_STS_ERROR;
13136: END IF;
13137:
13169: and
13170: NVL(p_relationship_type_rec.multiple_parent_allowed, 'Y') <>
13171: NVL(l_multiple_parent_allowed, 'Y')
13172: THEN
13173: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13174: fnd_message.set_token('ENTITY', 'relationship type');
13175: fnd_message.set_token('COLUMN1', 'relationship_type');
13176: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13177: fnd_msg_pub.add;
13170: NVL(p_relationship_type_rec.multiple_parent_allowed, 'Y') <>
13171: NVL(l_multiple_parent_allowed, 'Y')
13172: THEN
13173: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13174: fnd_message.set_token('ENTITY', 'relationship type');
13175: fnd_message.set_token('COLUMN1', 'relationship_type');
13176: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13177: fnd_msg_pub.add;
13178: x_return_status := FND_API.G_RET_STS_ERROR;
13171: NVL(l_multiple_parent_allowed, 'Y')
13172: THEN
13173: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13174: fnd_message.set_token('ENTITY', 'relationship type');
13175: fnd_message.set_token('COLUMN1', 'relationship_type');
13176: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13177: fnd_msg_pub.add;
13178: x_return_status := FND_API.G_RET_STS_ERROR;
13179: END IF;
13172: THEN
13173: fnd_message.set_name('AR', 'HZ_DIFF_VALUE_NOT_ALLOWED');
13174: fnd_message.set_token('ENTITY', 'relationship type');
13175: fnd_message.set_token('COLUMN1', 'relationship_type');
13176: fnd_message.set_token('COLUMN2', 'multiple_parent_allowed');
13177: fnd_msg_pub.add;
13178: x_return_status := FND_API.G_RET_STS_ERROR;
13179: END IF;
13180:
13298: IF (p_create_update_flag = 'C') THEN
13299: IF((p_relationship_type_rec.forward_rel_code = p_relationship_type_rec.backward_rel_code)
13300: AND (p_relationship_type_rec.subject_type <> p_relationship_type_rec.object_type))
13301: THEN
13302: fnd_message.set_name('AR', 'HZ_API_RELTYPE_INVALID');
13303: fnd_msg_pub.add;
13304: x_return_status := fnd_api.g_ret_sts_error;
13305:
13306: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
13645: p_relationship_rec.subject_id
13646: );
13647:
13648: IF l_in = 'N' THEN
13649: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13650: fnd_message.set_token('FK', 'subject_id');
13651: fnd_message.set_token('COLUMN',
13652: lower(p_relationship_rec.subject_type)||' id');
13653: fnd_message.set_token('TABLE', p_relationship_rec.subject_table_name);
13646: );
13647:
13648: IF l_in = 'N' THEN
13649: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13650: fnd_message.set_token('FK', 'subject_id');
13651: fnd_message.set_token('COLUMN',
13652: lower(p_relationship_rec.subject_type)||' id');
13653: fnd_message.set_token('TABLE', p_relationship_rec.subject_table_name);
13654: fnd_msg_pub.add;
13647:
13648: IF l_in = 'N' THEN
13649: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13650: fnd_message.set_token('FK', 'subject_id');
13651: fnd_message.set_token('COLUMN',
13652: lower(p_relationship_rec.subject_type)||' id');
13653: fnd_message.set_token('TABLE', p_relationship_rec.subject_table_name);
13654: fnd_msg_pub.add;
13655: x_return_status := fnd_api.g_ret_sts_error;
13649: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13650: fnd_message.set_token('FK', 'subject_id');
13651: fnd_message.set_token('COLUMN',
13652: lower(p_relationship_rec.subject_type)||' id');
13653: fnd_message.set_token('TABLE', p_relationship_rec.subject_table_name);
13654: fnd_msg_pub.add;
13655: x_return_status := fnd_api.g_ret_sts_error;
13656: END IF;
13657:
13728: FROM fnd_objects fo
13729: WHERE fo.obj_name = p_relationship_rec.subject_table_name;
13730: EXCEPTION
13731: WHEN NO_DATA_FOUND THEN
13732: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13733: fnd_message.set_token('FK', 'subject_table_name');
13734: fnd_message.set_token('COLUMN', 'obj_name');
13735: fnd_message.set_token('TABLE', 'fnd_objects');
13736: fnd_msg_pub.add;
13729: WHERE fo.obj_name = p_relationship_rec.subject_table_name;
13730: EXCEPTION
13731: WHEN NO_DATA_FOUND THEN
13732: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13733: fnd_message.set_token('FK', 'subject_table_name');
13734: fnd_message.set_token('COLUMN', 'obj_name');
13735: fnd_message.set_token('TABLE', 'fnd_objects');
13736: fnd_msg_pub.add;
13737: x_return_status := fnd_api.g_ret_sts_error;
13730: EXCEPTION
13731: WHEN NO_DATA_FOUND THEN
13732: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13733: fnd_message.set_token('FK', 'subject_table_name');
13734: fnd_message.set_token('COLUMN', 'obj_name');
13735: fnd_message.set_token('TABLE', 'fnd_objects');
13736: fnd_msg_pub.add;
13737: x_return_status := fnd_api.g_ret_sts_error;
13738: END;
13731: WHEN NO_DATA_FOUND THEN
13732: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13733: fnd_message.set_token('FK', 'subject_table_name');
13734: fnd_message.set_token('COLUMN', 'obj_name');
13735: fnd_message.set_token('TABLE', 'fnd_objects');
13736: fnd_msg_pub.add;
13737: x_return_status := fnd_api.g_ret_sts_error;
13738: END;
13739:
13814: FROM fnd_object_instance_sets fois
13815: WHERE fois.instance_set_name = p_relationship_rec.subject_type;
13816: EXCEPTION
13817: WHEN NO_DATA_FOUND THEN
13818: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13819: fnd_message.set_token('FK', 'subject_type');
13820: fnd_message.set_token('COLUMN', 'instance_set_name');
13821: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
13822: fnd_msg_pub.add;
13815: WHERE fois.instance_set_name = p_relationship_rec.subject_type;
13816: EXCEPTION
13817: WHEN NO_DATA_FOUND THEN
13818: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13819: fnd_message.set_token('FK', 'subject_type');
13820: fnd_message.set_token('COLUMN', 'instance_set_name');
13821: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
13822: fnd_msg_pub.add;
13823: x_return_status := fnd_api.g_ret_sts_error;
13816: EXCEPTION
13817: WHEN NO_DATA_FOUND THEN
13818: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13819: fnd_message.set_token('FK', 'subject_type');
13820: fnd_message.set_token('COLUMN', 'instance_set_name');
13821: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
13822: fnd_msg_pub.add;
13823: x_return_status := fnd_api.g_ret_sts_error;
13824: END;
13817: WHEN NO_DATA_FOUND THEN
13818: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13819: fnd_message.set_token('FK', 'subject_type');
13820: fnd_message.set_token('COLUMN', 'instance_set_name');
13821: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
13822: fnd_msg_pub.add;
13823: x_return_status := fnd_api.g_ret_sts_error;
13824: END;
13825:
13899: p_relationship_rec.object_id
13900: );
13901:
13902: IF l_in = 'N' THEN
13903: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13904: fnd_message.set_token('FK', 'object_id');
13905: fnd_message.set_token('COLUMN',
13906: LOWER(p_relationship_rec.object_type)||' id');
13907: fnd_message.set_token('TABLE', p_relationship_rec.object_table_name);
13900: );
13901:
13902: IF l_in = 'N' THEN
13903: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13904: fnd_message.set_token('FK', 'object_id');
13905: fnd_message.set_token('COLUMN',
13906: LOWER(p_relationship_rec.object_type)||' id');
13907: fnd_message.set_token('TABLE', p_relationship_rec.object_table_name);
13908: fnd_msg_pub.add;
13901:
13902: IF l_in = 'N' THEN
13903: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13904: fnd_message.set_token('FK', 'object_id');
13905: fnd_message.set_token('COLUMN',
13906: LOWER(p_relationship_rec.object_type)||' id');
13907: fnd_message.set_token('TABLE', p_relationship_rec.object_table_name);
13908: fnd_msg_pub.add;
13909: x_return_status := fnd_api.g_ret_sts_error;
13903: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13904: fnd_message.set_token('FK', 'object_id');
13905: fnd_message.set_token('COLUMN',
13906: LOWER(p_relationship_rec.object_type)||' id');
13907: fnd_message.set_token('TABLE', p_relationship_rec.object_table_name);
13908: fnd_msg_pub.add;
13909: x_return_status := fnd_api.g_ret_sts_error;
13910: END IF;
13911:
13984: FROM fnd_objects fo
13985: WHERE fo.obj_name = p_relationship_rec.object_table_name;
13986: EXCEPTION
13987: WHEN NO_DATA_FOUND THEN
13988: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13989: fnd_message.set_token('FK', 'object_table_name');
13990: fnd_message.set_token('COLUMN', 'obj_name');
13991: fnd_message.set_token('TABLE', 'fnd_objects');
13992: fnd_msg_pub.add;
13985: WHERE fo.obj_name = p_relationship_rec.object_table_name;
13986: EXCEPTION
13987: WHEN NO_DATA_FOUND THEN
13988: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13989: fnd_message.set_token('FK', 'object_table_name');
13990: fnd_message.set_token('COLUMN', 'obj_name');
13991: fnd_message.set_token('TABLE', 'fnd_objects');
13992: fnd_msg_pub.add;
13993: x_return_status := fnd_api.g_ret_sts_error;
13986: EXCEPTION
13987: WHEN NO_DATA_FOUND THEN
13988: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13989: fnd_message.set_token('FK', 'object_table_name');
13990: fnd_message.set_token('COLUMN', 'obj_name');
13991: fnd_message.set_token('TABLE', 'fnd_objects');
13992: fnd_msg_pub.add;
13993: x_return_status := fnd_api.g_ret_sts_error;
13994: END;
13987: WHEN NO_DATA_FOUND THEN
13988: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13989: fnd_message.set_token('FK', 'object_table_name');
13990: fnd_message.set_token('COLUMN', 'obj_name');
13991: fnd_message.set_token('TABLE', 'fnd_objects');
13992: fnd_msg_pub.add;
13993: x_return_status := fnd_api.g_ret_sts_error;
13994: END;
13995:
14072: FROM fnd_object_instance_sets fois
14073: WHERE fois.instance_set_name = p_relationship_rec.object_type;
14074: EXCEPTION
14075: WHEN NO_DATA_FOUND THEN
14076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
14077: fnd_message.set_token('FK', 'object_type');
14078: fnd_message.set_token('COLUMN', 'instance_set_name');
14079: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
14080: fnd_msg_pub.add;
14073: WHERE fois.instance_set_name = p_relationship_rec.object_type;
14074: EXCEPTION
14075: WHEN NO_DATA_FOUND THEN
14076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
14077: fnd_message.set_token('FK', 'object_type');
14078: fnd_message.set_token('COLUMN', 'instance_set_name');
14079: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
14080: fnd_msg_pub.add;
14081: x_return_status := fnd_api.g_ret_sts_error;
14074: EXCEPTION
14075: WHEN NO_DATA_FOUND THEN
14076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
14077: fnd_message.set_token('FK', 'object_type');
14078: fnd_message.set_token('COLUMN', 'instance_set_name');
14079: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
14080: fnd_msg_pub.add;
14081: x_return_status := fnd_api.g_ret_sts_error;
14082: END;
14075: WHEN NO_DATA_FOUND THEN
14076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
14077: fnd_message.set_token('FK', 'object_type');
14078: fnd_message.set_token('COLUMN', 'instance_set_name');
14079: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
14080: fnd_msg_pub.add;
14081: x_return_status := fnd_api.g_ret_sts_error;
14082: END;
14083:
14304: IF p_relationship_rec.end_date IS NOT NULL AND
14305: p_relationship_rec.end_date <> fnd_api.g_miss_date AND
14306: p_relationship_rec.end_date < p_relationship_rec.start_date
14307: THEN
14308: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
14309: fnd_msg_pub.add;
14310: x_return_status := fnd_api.g_ret_sts_error;
14311: END IF;
14312: ELSIF (p_create_update_flag = 'U') THEN
14325:
14326: IF l_end_date IS NOT NULL
14327: AND l_end_date < l_start_date
14328: THEN
14329: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
14330: fnd_msg_pub.add;
14331: x_return_status := fnd_api.g_ret_sts_error;
14332: END IF;
14333: END IF;
14369: r1.start_date,
14370: r1.end_date
14371: );
14372: IF l_overlap = 'Y' THEN
14373: fnd_message.set_name('AR', 'HZ_RELATIONSHIP_DATE_OVERLAP');
14374: fnd_msg_pub.add;
14375: x_return_status := fnd_api.g_ret_sts_error;
14376: -- Bug 3294936 : Add exit to come out of loop
14377: EXIT;
14957: ( p_organization_rec.avg_high_credit = FND_API.G_MISS_NUM OR
14958: p_organization_rec.avg_high_credit IS NOT NULL
14959: ) )
14960: THEN
14961: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
14962: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'avg_high_credit' );
14963: FND_MSG_PUB.ADD;
14964: x_return_status := FND_API.G_RET_STS_ERROR;
14965: END IF;
14958: p_organization_rec.avg_high_credit IS NOT NULL
14959: ) )
14960: THEN
14961: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
14962: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'avg_high_credit' );
14963: FND_MSG_PUB.ADD;
14964: x_return_status := FND_API.G_RET_STS_ERROR;
14965: END IF;
14966:
14972: ( p_organization_rec.credit_score = FND_API.G_MISS_CHAR OR
14973: p_organization_rec.credit_score IS NOT NULL
14974: ) )
14975: THEN
14976: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
14977: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score' );
14978: FND_MSG_PUB.ADD;
14979: x_return_status := FND_API.G_RET_STS_ERROR;
14980: END IF;
14973: p_organization_rec.credit_score IS NOT NULL
14974: ) )
14975: THEN
14976: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
14977: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score' );
14978: FND_MSG_PUB.ADD;
14979: x_return_status := FND_API.G_RET_STS_ERROR;
14980: END IF;
14981:
14987: ( p_organization_rec.credit_score_age = FND_API.G_MISS_NUM OR
14988: p_organization_rec.credit_score_age IS NOT NULL
14989: ) )
14990: THEN
14991: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
14992: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_age' );
14993: FND_MSG_PUB.ADD;
14994: x_return_status := FND_API.G_RET_STS_ERROR;
14995: END IF;
14988: p_organization_rec.credit_score_age IS NOT NULL
14989: ) )
14990: THEN
14991: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
14992: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_age' );
14993: FND_MSG_PUB.ADD;
14994: x_return_status := FND_API.G_RET_STS_ERROR;
14995: END IF;
14996:
15002: ( p_organization_rec.credit_score_class = FND_API.G_MISS_NUM OR
15003: p_organization_rec.credit_score_class IS NOT NULL
15004: ) )
15005: THEN
15006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15007: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_class' );
15008: FND_MSG_PUB.ADD;
15009: x_return_status := FND_API.G_RET_STS_ERROR;
15010: END IF;
15003: p_organization_rec.credit_score_class IS NOT NULL
15004: ) )
15005: THEN
15006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15007: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_class' );
15008: FND_MSG_PUB.ADD;
15009: x_return_status := FND_API.G_RET_STS_ERROR;
15010: END IF;
15011:
15017: ( p_organization_rec.credit_score_commentary = FND_API.G_MISS_CHAR OR
15018: p_organization_rec.credit_score_commentary IS NOT NULL
15019: ) )
15020: THEN
15021: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15022: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary' );
15023: FND_MSG_PUB.ADD;
15024: x_return_status := FND_API.G_RET_STS_ERROR;
15025: END IF;
15018: p_organization_rec.credit_score_commentary IS NOT NULL
15019: ) )
15020: THEN
15021: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15022: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary' );
15023: FND_MSG_PUB.ADD;
15024: x_return_status := FND_API.G_RET_STS_ERROR;
15025: END IF;
15026:
15032: ( p_organization_rec.credit_score_commentary2 = FND_API.G_MISS_CHAR OR
15033: p_organization_rec.credit_score_commentary2 IS NOT NULL
15034: ) )
15035: THEN
15036: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15037: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary2' );
15038: FND_MSG_PUB.ADD;
15039: x_return_status := FND_API.G_RET_STS_ERROR;
15040: END IF;
15033: p_organization_rec.credit_score_commentary2 IS NOT NULL
15034: ) )
15035: THEN
15036: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15037: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary2' );
15038: FND_MSG_PUB.ADD;
15039: x_return_status := FND_API.G_RET_STS_ERROR;
15040: END IF;
15041:
15047: ( p_organization_rec.credit_score_commentary3 = FND_API.G_MISS_CHAR OR
15048: p_organization_rec.credit_score_commentary3 IS NOT NULL
15049: ) )
15050: THEN
15051: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15052: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary3' );
15053: FND_MSG_PUB.ADD;
15054: x_return_status := FND_API.G_RET_STS_ERROR;
15055: END IF;
15048: p_organization_rec.credit_score_commentary3 IS NOT NULL
15049: ) )
15050: THEN
15051: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15052: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary3' );
15053: FND_MSG_PUB.ADD;
15054: x_return_status := FND_API.G_RET_STS_ERROR;
15055: END IF;
15056:
15062: ( p_organization_rec.credit_score_commentary4 = FND_API.G_MISS_CHAR OR
15063: p_organization_rec.credit_score_commentary4 IS NOT NULL
15064: ) )
15065: THEN
15066: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15067: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary4' );
15068: FND_MSG_PUB.ADD;
15069: x_return_status := FND_API.G_RET_STS_ERROR;
15070: END IF;
15063: p_organization_rec.credit_score_commentary4 IS NOT NULL
15064: ) )
15065: THEN
15066: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15067: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary4' );
15068: FND_MSG_PUB.ADD;
15069: x_return_status := FND_API.G_RET_STS_ERROR;
15070: END IF;
15071:
15077: ( p_organization_rec.credit_score_commentary5 = FND_API.G_MISS_CHAR OR
15078: p_organization_rec.credit_score_commentary5 IS NOT NULL
15079: ) )
15080: THEN
15081: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15082: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary5' );
15083: FND_MSG_PUB.ADD;
15084: x_return_status := FND_API.G_RET_STS_ERROR;
15085: END IF;
15078: p_organization_rec.credit_score_commentary5 IS NOT NULL
15079: ) )
15080: THEN
15081: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15082: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary5' );
15083: FND_MSG_PUB.ADD;
15084: x_return_status := FND_API.G_RET_STS_ERROR;
15085: END IF;
15086:
15092: ( p_organization_rec.credit_score_commentary6 = FND_API.G_MISS_CHAR OR
15093: p_organization_rec.credit_score_commentary6 IS NOT NULL
15094: ) )
15095: THEN
15096: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15097: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary6' );
15098: FND_MSG_PUB.ADD;
15099: x_return_status := FND_API.G_RET_STS_ERROR;
15100: END IF;
15093: p_organization_rec.credit_score_commentary6 IS NOT NULL
15094: ) )
15095: THEN
15096: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15097: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary6' );
15098: FND_MSG_PUB.ADD;
15099: x_return_status := FND_API.G_RET_STS_ERROR;
15100: END IF;
15101:
15107: ( p_organization_rec.credit_score_commentary7 = FND_API.G_MISS_CHAR OR
15108: p_organization_rec.credit_score_commentary7 IS NOT NULL
15109: ) )
15110: THEN
15111: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15112: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary7' );
15113: FND_MSG_PUB.ADD;
15114: x_return_status := FND_API.G_RET_STS_ERROR;
15115: END IF;
15108: p_organization_rec.credit_score_commentary7 IS NOT NULL
15109: ) )
15110: THEN
15111: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15112: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary7' );
15113: FND_MSG_PUB.ADD;
15114: x_return_status := FND_API.G_RET_STS_ERROR;
15115: END IF;
15116:
15122: ( p_organization_rec.credit_score_commentary8 = FND_API.G_MISS_CHAR OR
15123: p_organization_rec.credit_score_commentary8 IS NOT NULL
15124: ) )
15125: THEN
15126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary8' );
15128: FND_MSG_PUB.ADD;
15129: x_return_status := FND_API.G_RET_STS_ERROR;
15130: END IF;
15123: p_organization_rec.credit_score_commentary8 IS NOT NULL
15124: ) )
15125: THEN
15126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary8' );
15128: FND_MSG_PUB.ADD;
15129: x_return_status := FND_API.G_RET_STS_ERROR;
15130: END IF;
15131:
15137: ( p_organization_rec.credit_score_commentary9 = FND_API.G_MISS_CHAR OR
15138: p_organization_rec.credit_score_commentary9 IS NOT NULL
15139: ) )
15140: THEN
15141: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15142: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary9' );
15143: FND_MSG_PUB.ADD;
15144: x_return_status := FND_API.G_RET_STS_ERROR;
15145: END IF;
15138: p_organization_rec.credit_score_commentary9 IS NOT NULL
15139: ) )
15140: THEN
15141: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15142: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary9' );
15143: FND_MSG_PUB.ADD;
15144: x_return_status := FND_API.G_RET_STS_ERROR;
15145: END IF;
15146:
15152: ( p_organization_rec.credit_score_commentary10 = FND_API.G_MISS_CHAR OR
15153: p_organization_rec.credit_score_commentary10 IS NOT NULL
15154: ) )
15155: THEN
15156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary10' );
15158: FND_MSG_PUB.ADD;
15159: x_return_status := FND_API.G_RET_STS_ERROR;
15160: END IF;
15153: p_organization_rec.credit_score_commentary10 IS NOT NULL
15154: ) )
15155: THEN
15156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_commentary10' );
15158: FND_MSG_PUB.ADD;
15159: x_return_status := FND_API.G_RET_STS_ERROR;
15160: END IF;
15161:
15167: ( p_organization_rec.credit_score_date = FND_API.G_MISS_DATE OR
15168: p_organization_rec.credit_score_date IS NOT NULL
15169: ) )
15170: THEN
15171: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15172: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_date' );
15173: FND_MSG_PUB.ADD;
15174: x_return_status := FND_API.G_RET_STS_ERROR;
15175: END IF;
15168: p_organization_rec.credit_score_date IS NOT NULL
15169: ) )
15170: THEN
15171: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15172: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_date' );
15173: FND_MSG_PUB.ADD;
15174: x_return_status := FND_API.G_RET_STS_ERROR;
15175: END IF;
15176:
15182: ( p_organization_rec.credit_score_incd_default = FND_API.G_MISS_NUM OR
15183: p_organization_rec.credit_score_incd_default IS NOT NULL
15184: ) )
15185: THEN
15186: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15187: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_incd_default' );
15188: FND_MSG_PUB.ADD;
15189: x_return_status := FND_API.G_RET_STS_ERROR;
15190: END IF;
15183: p_organization_rec.credit_score_incd_default IS NOT NULL
15184: ) )
15185: THEN
15186: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15187: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_incd_default' );
15188: FND_MSG_PUB.ADD;
15189: x_return_status := FND_API.G_RET_STS_ERROR;
15190: END IF;
15191:
15197: ( p_organization_rec.credit_score_natl_percentile = FND_API.G_MISS_NUM OR
15198: p_organization_rec.credit_score_natl_percentile IS NOT NULL
15199: ) )
15200: THEN
15201: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15202: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_natl_percentile' );
15203: FND_MSG_PUB.ADD;
15204: x_return_status := FND_API.G_RET_STS_ERROR;
15205: END IF;
15198: p_organization_rec.credit_score_natl_percentile IS NOT NULL
15199: ) )
15200: THEN
15201: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15202: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_score_natl_percentile' );
15203: FND_MSG_PUB.ADD;
15204: x_return_status := FND_API.G_RET_STS_ERROR;
15205: END IF;
15206:
15212: ( p_organization_rec.db_rating = FND_API.G_MISS_CHAR OR
15213: p_organization_rec.db_rating IS NOT NULL
15214: ) )
15215: THEN
15216: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15217: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'db_rating' );
15218: FND_MSG_PUB.ADD;
15219: x_return_status := FND_API.G_RET_STS_ERROR;
15220: END IF;
15213: p_organization_rec.db_rating IS NOT NULL
15214: ) )
15215: THEN
15216: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15217: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'db_rating' );
15218: FND_MSG_PUB.ADD;
15219: x_return_status := FND_API.G_RET_STS_ERROR;
15220: END IF;
15221:
15227: ( p_organization_rec.debarment_ind = FND_API.G_MISS_CHAR OR
15228: p_organization_rec.debarment_ind IS NOT NULL
15229: ) )
15230: THEN
15231: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15232: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'debarment_ind' );
15233: FND_MSG_PUB.ADD;
15234: x_return_status := FND_API.G_RET_STS_ERROR;
15235: END IF;
15228: p_organization_rec.debarment_ind IS NOT NULL
15229: ) )
15230: THEN
15231: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15232: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'debarment_ind' );
15233: FND_MSG_PUB.ADD;
15234: x_return_status := FND_API.G_RET_STS_ERROR;
15235: END IF;
15236:
15242: ( p_organization_rec.debarments_count = FND_API.G_MISS_NUM OR
15243: p_organization_rec.debarments_count IS NOT NULL
15244: ) )
15245: THEN
15246: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15247: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'debarments_count' );
15248: FND_MSG_PUB.ADD;
15249: x_return_status := FND_API.G_RET_STS_ERROR;
15250: END IF;
15243: p_organization_rec.debarments_count IS NOT NULL
15244: ) )
15245: THEN
15246: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15247: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'debarments_count' );
15248: FND_MSG_PUB.ADD;
15249: x_return_status := FND_API.G_RET_STS_ERROR;
15250: END IF;
15251:
15257: ( p_organization_rec.debarments_date = FND_API.G_MISS_DATE OR
15258: p_organization_rec.debarments_date IS NOT NULL
15259: ) )
15260: THEN
15261: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15262: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'debarments_date' );
15263: FND_MSG_PUB.ADD;
15264: x_return_status := FND_API.G_RET_STS_ERROR;
15265: END IF;
15258: p_organization_rec.debarments_date IS NOT NULL
15259: ) )
15260: THEN
15261: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15262: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'debarments_date' );
15263: FND_MSG_PUB.ADD;
15264: x_return_status := FND_API.G_RET_STS_ERROR;
15265: END IF;
15266:
15272: ( p_organization_rec.high_credit = FND_API.G_MISS_NUM OR
15273: p_organization_rec.high_credit IS NOT NULL
15274: ) )
15275: THEN
15276: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15277: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'high_credit' );
15278: FND_MSG_PUB.ADD;
15279: x_return_status := FND_API.G_RET_STS_ERROR;
15280: END IF;
15273: p_organization_rec.high_credit IS NOT NULL
15274: ) )
15275: THEN
15276: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15277: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'high_credit' );
15278: FND_MSG_PUB.ADD;
15279: x_return_status := FND_API.G_RET_STS_ERROR;
15280: END IF;
15281:
15287: ( p_organization_rec.maximum_credit_currency_code = FND_API.G_MISS_CHAR OR
15288: p_organization_rec.maximum_credit_currency_code IS NOT NULL
15289: ) )
15290: THEN
15291: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15292: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'maximum_credit_currency_code' );
15293: FND_MSG_PUB.ADD;
15294: x_return_status := FND_API.G_RET_STS_ERROR;
15295: END IF;
15288: p_organization_rec.maximum_credit_currency_code IS NOT NULL
15289: ) )
15290: THEN
15291: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15292: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'maximum_credit_currency_code' );
15293: FND_MSG_PUB.ADD;
15294: x_return_status := FND_API.G_RET_STS_ERROR;
15295: END IF;
15296:
15302: ( p_organization_rec.maximum_credit_recommendation = FND_API.G_MISS_NUM OR
15303: p_organization_rec.maximum_credit_recommendation IS NOT NULL
15304: ) )
15305: THEN
15306: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15307: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'maximum_credit_recommendation' );
15308: FND_MSG_PUB.ADD;
15309: x_return_status := FND_API.G_RET_STS_ERROR;
15310: END IF;
15303: p_organization_rec.maximum_credit_recommendation IS NOT NULL
15304: ) )
15305: THEN
15306: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15307: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'maximum_credit_recommendation' );
15308: FND_MSG_PUB.ADD;
15309: x_return_status := FND_API.G_RET_STS_ERROR;
15310: END IF;
15311:
15317: ( p_organization_rec.paydex_norm = FND_API.G_MISS_CHAR OR
15318: p_organization_rec.paydex_norm IS NOT NULL
15319: ) )
15320: THEN
15321: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15322: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'paydex_norm' );
15323: FND_MSG_PUB.ADD;
15324: x_return_status := FND_API.G_RET_STS_ERROR;
15325: END IF;
15318: p_organization_rec.paydex_norm IS NOT NULL
15319: ) )
15320: THEN
15321: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15322: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'paydex_norm' );
15323: FND_MSG_PUB.ADD;
15324: x_return_status := FND_API.G_RET_STS_ERROR;
15325: END IF;
15326:
15332: ( p_organization_rec.paydex_score = FND_API.G_MISS_CHAR OR
15333: p_organization_rec.paydex_score IS NOT NULL
15334: ) )
15335: THEN
15336: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15337: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'paydex_score' );
15338: FND_MSG_PUB.ADD;
15339: x_return_status := FND_API.G_RET_STS_ERROR;
15340: END IF;
15333: p_organization_rec.paydex_score IS NOT NULL
15334: ) )
15335: THEN
15336: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15337: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'paydex_score' );
15338: FND_MSG_PUB.ADD;
15339: x_return_status := FND_API.G_RET_STS_ERROR;
15340: END IF;
15341:
15347: ( p_organization_rec.paydex_three_months_ago = FND_API.G_MISS_CHAR OR
15348: p_organization_rec.paydex_three_months_ago IS NOT NULL
15349: ) )
15350: THEN
15351: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15352: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'paydex_three_months_ago' );
15353: FND_MSG_PUB.ADD;
15354: x_return_status := FND_API.G_RET_STS_ERROR;
15355: END IF;
15348: p_organization_rec.paydex_three_months_ago IS NOT NULL
15349: ) )
15350: THEN
15351: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15352: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'paydex_three_months_ago' );
15353: FND_MSG_PUB.ADD;
15354: x_return_status := FND_API.G_RET_STS_ERROR;
15355: END IF;
15356:
15362: ( p_organization_rec.failure_score = FND_API.G_MISS_CHAR OR
15363: p_organization_rec.failure_score IS NOT NULL
15364: ) )
15365: THEN
15366: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15367: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score' );
15368: FND_MSG_PUB.ADD;
15369: x_return_status := FND_API.G_RET_STS_ERROR;
15370: END IF;
15363: p_organization_rec.failure_score IS NOT NULL
15364: ) )
15365: THEN
15366: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15367: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score' );
15368: FND_MSG_PUB.ADD;
15369: x_return_status := FND_API.G_RET_STS_ERROR;
15370: END IF;
15371:
15377: ( p_organization_rec.failure_score_age = FND_API.G_MISS_NUM OR
15378: p_organization_rec.failure_score_age IS NOT NULL
15379: ) )
15380: THEN
15381: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15382: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_age' );
15383: FND_MSG_PUB.ADD;
15384: x_return_status := FND_API.G_RET_STS_ERROR;
15385: END IF;
15378: p_organization_rec.failure_score_age IS NOT NULL
15379: ) )
15380: THEN
15381: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15382: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_age' );
15383: FND_MSG_PUB.ADD;
15384: x_return_status := FND_API.G_RET_STS_ERROR;
15385: END IF;
15386:
15392: ( p_organization_rec.failure_score_class = FND_API.G_MISS_NUM OR
15393: p_organization_rec.failure_score_class IS NOT NULL
15394: ) )
15395: THEN
15396: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15397: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_class' );
15398: FND_MSG_PUB.ADD;
15399: x_return_status := FND_API.G_RET_STS_ERROR;
15400: END IF;
15393: p_organization_rec.failure_score_class IS NOT NULL
15394: ) )
15395: THEN
15396: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15397: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_class' );
15398: FND_MSG_PUB.ADD;
15399: x_return_status := FND_API.G_RET_STS_ERROR;
15400: END IF;
15401:
15407: ( p_organization_rec.failure_score_commentary = FND_API.G_MISS_CHAR OR
15408: p_organization_rec.failure_score_commentary IS NOT NULL
15409: ) )
15410: THEN
15411: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15412: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary' );
15413: FND_MSG_PUB.ADD;
15414: x_return_status := FND_API.G_RET_STS_ERROR;
15415: END IF;
15408: p_organization_rec.failure_score_commentary IS NOT NULL
15409: ) )
15410: THEN
15411: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15412: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary' );
15413: FND_MSG_PUB.ADD;
15414: x_return_status := FND_API.G_RET_STS_ERROR;
15415: END IF;
15416:
15422: ( p_organization_rec.failure_score_commentary2 = FND_API.G_MISS_CHAR OR
15423: p_organization_rec.failure_score_commentary2 IS NOT NULL
15424: ) )
15425: THEN
15426: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15427: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary2' );
15428: FND_MSG_PUB.ADD;
15429: x_return_status := FND_API.G_RET_STS_ERROR;
15430: END IF;
15423: p_organization_rec.failure_score_commentary2 IS NOT NULL
15424: ) )
15425: THEN
15426: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15427: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary2' );
15428: FND_MSG_PUB.ADD;
15429: x_return_status := FND_API.G_RET_STS_ERROR;
15430: END IF;
15431:
15437: ( p_organization_rec.failure_score_commentary3 = FND_API.G_MISS_CHAR OR
15438: p_organization_rec.failure_score_commentary3 IS NOT NULL
15439: ) )
15440: THEN
15441: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15442: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary3' );
15443: FND_MSG_PUB.ADD;
15444: x_return_status := FND_API.G_RET_STS_ERROR;
15445: END IF;
15438: p_organization_rec.failure_score_commentary3 IS NOT NULL
15439: ) )
15440: THEN
15441: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15442: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary3' );
15443: FND_MSG_PUB.ADD;
15444: x_return_status := FND_API.G_RET_STS_ERROR;
15445: END IF;
15446:
15452: ( p_organization_rec.failure_score_commentary4 = FND_API.G_MISS_CHAR OR
15453: p_organization_rec.failure_score_commentary4 IS NOT NULL
15454: ) )
15455: THEN
15456: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15457: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary4' );
15458: FND_MSG_PUB.ADD;
15459: x_return_status := FND_API.G_RET_STS_ERROR;
15460: END IF;
15453: p_organization_rec.failure_score_commentary4 IS NOT NULL
15454: ) )
15455: THEN
15456: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15457: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary4' );
15458: FND_MSG_PUB.ADD;
15459: x_return_status := FND_API.G_RET_STS_ERROR;
15460: END IF;
15461:
15467: ( p_organization_rec.failure_score_commentary5 = FND_API.G_MISS_CHAR OR
15468: p_organization_rec.failure_score_commentary5 IS NOT NULL
15469: ) )
15470: THEN
15471: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15472: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary5' );
15473: FND_MSG_PUB.ADD;
15474: x_return_status := FND_API.G_RET_STS_ERROR;
15475: END IF;
15468: p_organization_rec.failure_score_commentary5 IS NOT NULL
15469: ) )
15470: THEN
15471: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15472: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary5' );
15473: FND_MSG_PUB.ADD;
15474: x_return_status := FND_API.G_RET_STS_ERROR;
15475: END IF;
15476:
15482: ( p_organization_rec.failure_score_commentary6 = FND_API.G_MISS_CHAR OR
15483: p_organization_rec.failure_score_commentary6 IS NOT NULL
15484: ) )
15485: THEN
15486: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15487: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary6' );
15488: FND_MSG_PUB.ADD;
15489: x_return_status := FND_API.G_RET_STS_ERROR;
15490: END IF;
15483: p_organization_rec.failure_score_commentary6 IS NOT NULL
15484: ) )
15485: THEN
15486: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15487: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary6' );
15488: FND_MSG_PUB.ADD;
15489: x_return_status := FND_API.G_RET_STS_ERROR;
15490: END IF;
15491:
15497: ( p_organization_rec.failure_score_commentary7 = FND_API.G_MISS_CHAR OR
15498: p_organization_rec.failure_score_commentary7 IS NOT NULL
15499: ) )
15500: THEN
15501: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15502: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary7' );
15503: FND_MSG_PUB.ADD;
15504: x_return_status := FND_API.G_RET_STS_ERROR;
15505: END IF;
15498: p_organization_rec.failure_score_commentary7 IS NOT NULL
15499: ) )
15500: THEN
15501: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15502: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary7' );
15503: FND_MSG_PUB.ADD;
15504: x_return_status := FND_API.G_RET_STS_ERROR;
15505: END IF;
15506:
15512: ( p_organization_rec.failure_score_commentary8 = FND_API.G_MISS_CHAR OR
15513: p_organization_rec.failure_score_commentary8 IS NOT NULL
15514: ) )
15515: THEN
15516: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15517: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary8' );
15518: FND_MSG_PUB.ADD;
15519: x_return_status := FND_API.G_RET_STS_ERROR;
15520: END IF;
15513: p_organization_rec.failure_score_commentary8 IS NOT NULL
15514: ) )
15515: THEN
15516: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15517: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary8' );
15518: FND_MSG_PUB.ADD;
15519: x_return_status := FND_API.G_RET_STS_ERROR;
15520: END IF;
15521:
15527: ( p_organization_rec.failure_score_commentary9 = FND_API.G_MISS_CHAR OR
15528: p_organization_rec.failure_score_commentary9 IS NOT NULL
15529: ) )
15530: THEN
15531: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15532: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary9' );
15533: FND_MSG_PUB.ADD;
15534: x_return_status := FND_API.G_RET_STS_ERROR;
15535: END IF;
15528: p_organization_rec.failure_score_commentary9 IS NOT NULL
15529: ) )
15530: THEN
15531: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15532: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary9' );
15533: FND_MSG_PUB.ADD;
15534: x_return_status := FND_API.G_RET_STS_ERROR;
15535: END IF;
15536:
15542: ( p_organization_rec.failure_score_commentary10 = FND_API.G_MISS_CHAR OR
15543: p_organization_rec.failure_score_commentary10 IS NOT NULL
15544: ) )
15545: THEN
15546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary10' );
15548: FND_MSG_PUB.ADD;
15549: x_return_status := FND_API.G_RET_STS_ERROR;
15550: END IF;
15543: p_organization_rec.failure_score_commentary10 IS NOT NULL
15544: ) )
15545: THEN
15546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_commentary10' );
15548: FND_MSG_PUB.ADD;
15549: x_return_status := FND_API.G_RET_STS_ERROR;
15550: END IF;
15551:
15557: ( p_organization_rec.failure_score_date = FND_API.G_MISS_DATE OR
15558: p_organization_rec.failure_score_date IS NOT NULL
15559: ) )
15560: THEN
15561: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15562: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_date' );
15563: FND_MSG_PUB.ADD;
15564: x_return_status := FND_API.G_RET_STS_ERROR;
15565: END IF;
15558: p_organization_rec.failure_score_date IS NOT NULL
15559: ) )
15560: THEN
15561: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15562: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_date' );
15563: FND_MSG_PUB.ADD;
15564: x_return_status := FND_API.G_RET_STS_ERROR;
15565: END IF;
15566:
15572: ( p_organization_rec.failure_score_incd_default = FND_API.G_MISS_NUM OR
15573: p_organization_rec.failure_score_incd_default IS NOT NULL
15574: ) )
15575: THEN
15576: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15577: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_incd_default' );
15578: FND_MSG_PUB.ADD;
15579: x_return_status := FND_API.G_RET_STS_ERROR;
15580: END IF;
15573: p_organization_rec.failure_score_incd_default IS NOT NULL
15574: ) )
15575: THEN
15576: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15577: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_incd_default' );
15578: FND_MSG_PUB.ADD;
15579: x_return_status := FND_API.G_RET_STS_ERROR;
15580: END IF;
15581:
15587: ( p_organization_rec.failure_score_natnl_percentile = FND_API.G_MISS_NUM OR
15588: p_organization_rec.failure_score_natnl_percentile IS NOT NULL
15589: ) )
15590: THEN
15591: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15592: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_natnl_percentile' );
15593: FND_MSG_PUB.ADD;
15594: x_return_status := FND_API.G_RET_STS_ERROR;
15595: END IF;
15588: p_organization_rec.failure_score_natnl_percentile IS NOT NULL
15589: ) )
15590: THEN
15591: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15592: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_natnl_percentile' );
15593: FND_MSG_PUB.ADD;
15594: x_return_status := FND_API.G_RET_STS_ERROR;
15595: END IF;
15596:
15602: ( p_organization_rec.failure_score_override_code = FND_API.G_MISS_CHAR OR
15603: p_organization_rec.failure_score_override_code IS NOT NULL
15604: ) )
15605: THEN
15606: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15607: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_override_code' );
15608: FND_MSG_PUB.ADD;
15609: x_return_status := FND_API.G_RET_STS_ERROR;
15610: END IF;
15603: p_organization_rec.failure_score_override_code IS NOT NULL
15604: ) )
15605: THEN
15606: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15607: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'failure_score_override_code' );
15608: FND_MSG_PUB.ADD;
15609: x_return_status := FND_API.G_RET_STS_ERROR;
15610: END IF;
15611:
15617: ( p_organization_rec.global_failure_score = FND_API.G_MISS_CHAR OR
15618: p_organization_rec.global_failure_score IS NOT NULL
15619: ) )
15620: THEN
15621: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15622: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'global_failure_score' );
15623: FND_MSG_PUB.ADD;
15624: x_return_status := FND_API.G_RET_STS_ERROR;
15625: END IF;
15618: p_organization_rec.global_failure_score IS NOT NULL
15619: ) )
15620: THEN
15621: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DNB_MOVED_COLUMN' );
15622: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'global_failure_score' );
15623: FND_MSG_PUB.ADD;
15624: x_return_status := FND_API.G_RET_STS_ERROR;
15625: END IF;
15626:
15650: BEGIN
15651:
15652: IF p_forward_rel_code = p_backward_rel_code THEN
15653: IF p_forward_role <> p_backward_role THEN
15654: fnd_message.set_name('AR', 'HZ_INVALID_ROLE1');
15655: fnd_msg_pub.add;
15656: x_return_status := FND_API.G_RET_STS_ERROR;
15657: END IF;
15658: END IF;
15658: END IF;
15659:
15660: IF p_forward_rel_code <> p_backward_rel_code THEN
15661: IF p_forward_role = p_backward_role THEN
15662: fnd_message.set_name('AR', 'HZ_INVALID_ROLE2');
15663: fnd_msg_pub.add;
15664: x_return_status := FND_API.G_RET_STS_ERROR;
15665: END IF;
15666: END IF;
15895: FETCH c_dup_financial_report_id INTO l_dummy;
15896:
15897: -- key is not unique, push an error onto the stack.
15898: IF NVL(c_dup_financial_report_id%FOUND, FALSE) THEN
15899: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
15900: fnd_message.set_token('COLUMN', 'financial_report_id');
15901: fnd_msg_pub.add;
15902: x_return_status := fnd_api.g_ret_sts_error;
15903: END IF;
15896:
15897: -- key is not unique, push an error onto the stack.
15898: IF NVL(c_dup_financial_report_id%FOUND, FALSE) THEN
15899: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
15900: fnd_message.set_token('COLUMN', 'financial_report_id');
15901: fnd_msg_pub.add;
15902: x_return_status := fnd_api.g_ret_sts_error;
15903: END IF;
15904: CLOSE c_dup_financial_report_id;
16021: WHERE p.party_id = p_financial_report_rec.party_id;
16022:
16023: EXCEPTION
16024: WHEN NO_DATA_FOUND THEN
16025: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16026: fnd_message.set_token('FK', 'party_id');
16027: fnd_message.set_token('COLUMN', 'party_id');
16028: fnd_message.set_token('TABLE', 'hz_parties');
16029: fnd_msg_pub.add;
16022:
16023: EXCEPTION
16024: WHEN NO_DATA_FOUND THEN
16025: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16026: fnd_message.set_token('FK', 'party_id');
16027: fnd_message.set_token('COLUMN', 'party_id');
16028: fnd_message.set_token('TABLE', 'hz_parties');
16029: fnd_msg_pub.add;
16030: x_return_status := fnd_api.g_ret_sts_error;
16023: EXCEPTION
16024: WHEN NO_DATA_FOUND THEN
16025: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16026: fnd_message.set_token('FK', 'party_id');
16027: fnd_message.set_token('COLUMN', 'party_id');
16028: fnd_message.set_token('TABLE', 'hz_parties');
16029: fnd_msg_pub.add;
16030: x_return_status := fnd_api.g_ret_sts_error;
16031: END;
16024: WHEN NO_DATA_FOUND THEN
16025: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16026: fnd_message.set_token('FK', 'party_id');
16027: fnd_message.set_token('COLUMN', 'party_id');
16028: fnd_message.set_token('TABLE', 'hz_parties');
16029: fnd_msg_pub.add;
16030: x_return_status := fnd_api.g_ret_sts_error;
16031: END;
16032: */
16063: THEN
16064: IF rtrim(ltrim(l_party_type)) <> 'ORGANIZATION'
16065: THEN
16066: -- This is not an organization. Hence throw error
16067: fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE');
16068: fnd_message.set_token('PARTY_ID', TO_CHAR(p_financial_report_rec.party_id));
16069: fnd_message.set_token('TYPE', 'ORGANIZATION');
16070: fnd_msg_pub.add;
16071: x_return_status := fnd_api.g_ret_sts_error;
16064: IF rtrim(ltrim(l_party_type)) <> 'ORGANIZATION'
16065: THEN
16066: -- This is not an organization. Hence throw error
16067: fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE');
16068: fnd_message.set_token('PARTY_ID', TO_CHAR(p_financial_report_rec.party_id));
16069: fnd_message.set_token('TYPE', 'ORGANIZATION');
16070: fnd_msg_pub.add;
16071: x_return_status := fnd_api.g_ret_sts_error;
16072: END IF;
16065: THEN
16066: -- This is not an organization. Hence throw error
16067: fnd_message.set_name('AR', 'HZ_API_INVALID_PARTY_TYPE');
16068: fnd_message.set_token('PARTY_ID', TO_CHAR(p_financial_report_rec.party_id));
16069: fnd_message.set_token('TYPE', 'ORGANIZATION');
16070: fnd_msg_pub.add;
16071: x_return_status := fnd_api.g_ret_sts_error;
16072: END IF;
16073: ELSE -- 3456205
16072: END IF;
16073: ELSE -- 3456205
16074: -- party_id has foreign key HZ_PARTIES.PARTY_ID
16075: -- However since no record found in HZ_PARTIES, therefore throw error.
16076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16077: fnd_message.set_token('FK', 'party_id');
16078: fnd_message.set_token('COLUMN', 'party_id');
16079: fnd_message.set_token('TABLE', 'hz_parties');
16080: fnd_msg_pub.add;
16073: ELSE -- 3456205
16074: -- party_id has foreign key HZ_PARTIES.PARTY_ID
16075: -- However since no record found in HZ_PARTIES, therefore throw error.
16076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16077: fnd_message.set_token('FK', 'party_id');
16078: fnd_message.set_token('COLUMN', 'party_id');
16079: fnd_message.set_token('TABLE', 'hz_parties');
16080: fnd_msg_pub.add;
16081: x_return_status := fnd_api.g_ret_sts_error;
16074: -- party_id has foreign key HZ_PARTIES.PARTY_ID
16075: -- However since no record found in HZ_PARTIES, therefore throw error.
16076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16077: fnd_message.set_token('FK', 'party_id');
16078: fnd_message.set_token('COLUMN', 'party_id');
16079: fnd_message.set_token('TABLE', 'hz_parties');
16080: fnd_msg_pub.add;
16081: x_return_status := fnd_api.g_ret_sts_error;
16082: END IF;
16075: -- However since no record found in HZ_PARTIES, therefore throw error.
16076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
16077: fnd_message.set_token('FK', 'party_id');
16078: fnd_message.set_token('COLUMN', 'party_id');
16079: fnd_message.set_token('TABLE', 'hz_parties');
16080: fnd_msg_pub.add;
16081: x_return_status := fnd_api.g_ret_sts_error;
16082: END IF;
16083: CLOSE c_partytype;
16109: | nvl(p_financial_report_rec.issued_period, l_issued_period) <> fnd_api.g_miss_char) AND
16110: | (nvl(p_financial_report_rec.report_start_date, l_report_start_date) IS NOT NULL AND
16111: | nvl(p_financial_report_rec.report_start_date, l_report_start_date) <> fnd_api.g_miss_date))
16112: |THEN
16113: | fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
16114: | fnd_message.set_token('COLUMN1', 'issued_period');
16115: | fnd_message.set_token('COLUMN2', 'report_start_date');
16116: | fnd_msg_pub.add;
16117: | x_return_status := fnd_api.g_ret_sts_error;
16110: | (nvl(p_financial_report_rec.report_start_date, l_report_start_date) IS NOT NULL AND
16111: | nvl(p_financial_report_rec.report_start_date, l_report_start_date) <> fnd_api.g_miss_date))
16112: |THEN
16113: | fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
16114: | fnd_message.set_token('COLUMN1', 'issued_period');
16115: | fnd_message.set_token('COLUMN2', 'report_start_date');
16116: | fnd_msg_pub.add;
16117: | x_return_status := fnd_api.g_ret_sts_error;
16118: |END IF;
16111: | nvl(p_financial_report_rec.report_start_date, l_report_start_date) <> fnd_api.g_miss_date))
16112: |THEN
16113: | fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
16114: | fnd_message.set_token('COLUMN1', 'issued_period');
16115: | fnd_message.set_token('COLUMN2', 'report_start_date');
16116: | fnd_msg_pub.add;
16117: | x_return_status := fnd_api.g_ret_sts_error;
16118: |END IF;
16119: */
16161: )
16162: )
16163: )
16164: THEN
16165: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
16166: fnd_message.set_token('COLUMN1', 'issued_period');
16167: fnd_message.set_token('COLUMN2', 'report_start_date');
16168: fnd_msg_pub.add;
16169: x_return_status := fnd_api.g_ret_sts_error;
16162: )
16163: )
16164: THEN
16165: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
16166: fnd_message.set_token('COLUMN1', 'issued_period');
16167: fnd_message.set_token('COLUMN2', 'report_start_date');
16168: fnd_msg_pub.add;
16169: x_return_status := fnd_api.g_ret_sts_error;
16170: END IF;
16163: )
16164: THEN
16165: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION2');
16166: fnd_message.set_token('COLUMN1', 'issued_period');
16167: fnd_message.set_token('COLUMN2', 'report_start_date');
16168: fnd_msg_pub.add;
16169: x_return_status := fnd_api.g_ret_sts_error;
16170: END IF;
16171: END IF;
16187: AND (p_financial_report_rec.report_start_date IS NULL OR
16188: p_financial_report_rec.report_start_date = fnd_api.g_miss_date)
16189: ))
16190: THEN
16191: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION3');
16192: fnd_message.set_token('COLUMN1', 'report_start_date');
16193: fnd_message.set_token('COLUMN2', 'report_end_date');
16194: fnd_msg_pub.add;
16195: x_return_status := fnd_api.g_ret_sts_error;
16188: p_financial_report_rec.report_start_date = fnd_api.g_miss_date)
16189: ))
16190: THEN
16191: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION3');
16192: fnd_message.set_token('COLUMN1', 'report_start_date');
16193: fnd_message.set_token('COLUMN2', 'report_end_date');
16194: fnd_msg_pub.add;
16195: x_return_status := fnd_api.g_ret_sts_error;
16196: END IF;
16189: ))
16190: THEN
16191: fnd_message.set_name('AR', 'HZ_API_INVALID_COMBINATION3');
16192: fnd_message.set_token('COLUMN1', 'report_start_date');
16193: fnd_message.set_token('COLUMN2', 'report_end_date');
16194: fnd_msg_pub.add;
16195: x_return_status := fnd_api.g_ret_sts_error;
16196: END IF;
16197:
16204: p_financial_report_rec.report_end_date <> FND_API.G_MISS_DATE THEN
16205: if (p_financial_report_rec.report_end_date
16206: < p_financial_report_rec.report_start_date
16207: ) THEN
16208: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
16209: FND_MSG_PUB.ADD;
16210: x_return_status := FND_API.G_RET_STS_ERROR;
16211: end if;
16212: END IF;
16222: if p_financial_report_rec.report_start_date is NOT NULL AND
16223: p_financial_report_rec.report_start_date <> FND_API.G_MISS_DATE then
16224: if p_financial_report_rec.report_end_date
16225: < p_financial_report_rec.report_start_date then
16226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
16227: FND_MSG_PUB.ADD;
16228: x_return_status := FND_API.G_RET_STS_ERROR;
16229:
16230: end if;
16229:
16230: end if;
16231: elsif ( p_financial_report_rec.report_end_date < l_report_start_date OR
16232: l_report_start_date is NULL) then
16233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
16234: FND_MSG_PUB.ADD;
16235: x_return_status := FND_API.G_RET_STS_ERROR;
16236:
16237: end if;
16237: end if;
16238: elsif (p_financial_report_rec.report_start_date is NOT NULL AND
16239: p_financial_report_rec.report_start_date <> FND_API.G_MISS_DATE) THEN
16240: if l_report_end_date < p_financial_report_rec.report_start_date then
16241: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
16242: FND_MSG_PUB.ADD;
16243: x_return_status := FND_API.G_RET_STS_ERROR;
16244:
16245: end if;
16263: FETCH c_unique_financial_report_rec INTO l_dummy;
16264:
16265: -- combination key is not unique, push an error onto the stack.
16266: IF NVL(c_unique_financial_report_rec%FOUND, FALSE) THEN
16267: fnd_message.set_name('AR', 'HZ_API_DUP_FIN_REPORT_REC');
16268: fnd_msg_pub.add;
16269: x_return_status := fnd_api.g_ret_sts_error;
16270: END IF;
16271: CLOSE c_unique_financial_report_rec;
16982: FETCH c_dup_financial_number_id INTO l_dummy;
16983:
16984: -- key is not unique, push an error onto the stack.
16985: IF NVL(c_dup_financial_number_id%FOUND, FALSE) THEN
16986: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
16987: fnd_message.set_token('COLUMN', 'financial_number_id');
16988: fnd_msg_pub.add;
16989: x_return_status := fnd_api.g_ret_sts_error;
16990: END IF;
16983:
16984: -- key is not unique, push an error onto the stack.
16985: IF NVL(c_dup_financial_number_id%FOUND, FALSE) THEN
16986: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
16987: fnd_message.set_token('COLUMN', 'financial_number_id');
16988: fnd_msg_pub.add;
16989: x_return_status := fnd_api.g_ret_sts_error;
16990: END IF;
16991: CLOSE c_dup_financial_number_id;
17063: WHERE hfr.financial_report_id = p_financial_number_rec.financial_report_id;
17064:
17065: EXCEPTION
17066: WHEN NO_DATA_FOUND THEN
17067: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17068: fnd_message.set_token('FK', 'financial_report_id');
17069: fnd_message.set_token('COLUMN', 'financial_report_id');
17070: fnd_message.set_token('TABLE', 'hz_financial_reports');
17071: fnd_msg_pub.add;
17064:
17065: EXCEPTION
17066: WHEN NO_DATA_FOUND THEN
17067: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17068: fnd_message.set_token('FK', 'financial_report_id');
17069: fnd_message.set_token('COLUMN', 'financial_report_id');
17070: fnd_message.set_token('TABLE', 'hz_financial_reports');
17071: fnd_msg_pub.add;
17072: x_return_status := fnd_api.g_ret_sts_error;
17065: EXCEPTION
17066: WHEN NO_DATA_FOUND THEN
17067: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17068: fnd_message.set_token('FK', 'financial_report_id');
17069: fnd_message.set_token('COLUMN', 'financial_report_id');
17070: fnd_message.set_token('TABLE', 'hz_financial_reports');
17071: fnd_msg_pub.add;
17072: x_return_status := fnd_api.g_ret_sts_error;
17073: END;
17066: WHEN NO_DATA_FOUND THEN
17067: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17068: fnd_message.set_token('FK', 'financial_report_id');
17069: fnd_message.set_token('COLUMN', 'financial_report_id');
17070: fnd_message.set_token('TABLE', 'hz_financial_reports');
17071: fnd_msg_pub.add;
17072: x_return_status := fnd_api.g_ret_sts_error;
17073: END;
17074:
17142: FETCH c_unique_financial_number_rec INTO l_dummy;
17143:
17144: -- combination key is not unique, push an error onto the stack.
17145: IF NVL(c_unique_financial_number_rec%FOUND, FALSE) THEN
17146: fnd_message.set_name('AR', 'HZ_API_DUP_FIN_NUMBER_REC');
17147: fnd_msg_pub.add;
17148: x_return_status := fnd_api.g_ret_sts_error;
17149: END IF;
17150: CLOSE c_unique_financial_number_rec;
17507: FETCH c_dup_credit_rating_id INTO l_dummy;
17508:
17509: -- key is not unique, push an error onto the stack.
17510: IF NVL(c_dup_credit_rating_id%FOUND, FALSE) THEN
17511: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
17512: fnd_message.set_token('COLUMN', 'credit_rating_id');
17513: fnd_msg_pub.add;
17514: x_return_status := fnd_api.g_ret_sts_error;
17515: END IF;
17508:
17509: -- key is not unique, push an error onto the stack.
17510: IF NVL(c_dup_credit_rating_id%FOUND, FALSE) THEN
17511: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
17512: fnd_message.set_token('COLUMN', 'credit_rating_id');
17513: fnd_msg_pub.add;
17514: x_return_status := fnd_api.g_ret_sts_error;
17515: END IF;
17516: CLOSE c_dup_credit_rating_id;
17606: WHERE p.party_id = p_credit_rating_rec.party_id;
17607:
17608: EXCEPTION
17609: WHEN NO_DATA_FOUND THEN
17610: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17611: fnd_message.set_token('FK', 'party_id');
17612: fnd_message.set_token('COLUMN', 'party_id');
17613: fnd_message.set_token('TABLE', 'hz_parties');
17614: fnd_msg_pub.add;
17607:
17608: EXCEPTION
17609: WHEN NO_DATA_FOUND THEN
17610: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17611: fnd_message.set_token('FK', 'party_id');
17612: fnd_message.set_token('COLUMN', 'party_id');
17613: fnd_message.set_token('TABLE', 'hz_parties');
17614: fnd_msg_pub.add;
17615: x_return_status := fnd_api.g_ret_sts_error;
17608: EXCEPTION
17609: WHEN NO_DATA_FOUND THEN
17610: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17611: fnd_message.set_token('FK', 'party_id');
17612: fnd_message.set_token('COLUMN', 'party_id');
17613: fnd_message.set_token('TABLE', 'hz_parties');
17614: fnd_msg_pub.add;
17615: x_return_status := fnd_api.g_ret_sts_error;
17616: END;
17609: WHEN NO_DATA_FOUND THEN
17610: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
17611: fnd_message.set_token('FK', 'party_id');
17612: fnd_message.set_token('COLUMN', 'party_id');
17613: fnd_message.set_token('TABLE', 'hz_parties');
17614: fnd_msg_pub.add;
17615: x_return_status := fnd_api.g_ret_sts_error;
17616: END;
17617:
17669: | FETCH c_unique_credit_rating_rec INTO l_dummy;
17670: |
17671: | -- combination key is not unique, push an error onto the stack.
17672: | IF NVL(c_unique_credit_rating_rec%FOUND, FALSE) THEN
17673: | fnd_message.set_name('AR', 'HZ_API_DUP_CREDIT_RATING_REC');
17674: | fnd_msg_pub.add;
17675: | x_return_status := fnd_api.g_ret_sts_error;
17676: | END IF;
17677: | CLOSE c_unique_credit_rating_rec;
18430: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
18431: and trunc(nvl(end_date_active,sysdate));
18432: EXCEPTION
18433: WHEN NO_DATA_FOUND THEN
18434: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
18435: fnd_message.set_token('FK', 'currency_code');
18436: fnd_message.set_token('COLUMN', 'maximum_credit_currency_code');
18437: fnd_message.set_token('TABLE', 'fnd_currencies');
18438: fnd_msg_pub.add;
18431: and trunc(nvl(end_date_active,sysdate));
18432: EXCEPTION
18433: WHEN NO_DATA_FOUND THEN
18434: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
18435: fnd_message.set_token('FK', 'currency_code');
18436: fnd_message.set_token('COLUMN', 'maximum_credit_currency_code');
18437: fnd_message.set_token('TABLE', 'fnd_currencies');
18438: fnd_msg_pub.add;
18439: x_return_status := fnd_api.g_ret_sts_error;
18432: EXCEPTION
18433: WHEN NO_DATA_FOUND THEN
18434: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
18435: fnd_message.set_token('FK', 'currency_code');
18436: fnd_message.set_token('COLUMN', 'maximum_credit_currency_code');
18437: fnd_message.set_token('TABLE', 'fnd_currencies');
18438: fnd_msg_pub.add;
18439: x_return_status := fnd_api.g_ret_sts_error;
18440: END;
18433: WHEN NO_DATA_FOUND THEN
18434: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
18435: fnd_message.set_token('FK', 'currency_code');
18436: fnd_message.set_token('COLUMN', 'maximum_credit_currency_code');
18437: fnd_message.set_token('TABLE', 'fnd_currencies');
18438: fnd_msg_pub.add;
18439: x_return_status := fnd_api.g_ret_sts_error;
18440: END;
18441:
18519: THEN
18520: IF p_credit_rating_rec.credit_score_natl_percentile < 0 OR
18521: p_credit_rating_rec.credit_score_natl_percentile > 100
18522: THEN
18523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PERCENTAGE');
18524: FND_MESSAGE.SET_TOKEN('INVALIDVAL', p_credit_rating_rec.credit_score_natl_percentile);
18525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'credit_score_natl_percentile');
18526: FND_MSG_PUB.ADD;
18527: x_return_status := fnd_api.g_ret_sts_error;
18520: IF p_credit_rating_rec.credit_score_natl_percentile < 0 OR
18521: p_credit_rating_rec.credit_score_natl_percentile > 100
18522: THEN
18523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PERCENTAGE');
18524: FND_MESSAGE.SET_TOKEN('INVALIDVAL', p_credit_rating_rec.credit_score_natl_percentile);
18525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'credit_score_natl_percentile');
18526: FND_MSG_PUB.ADD;
18527: x_return_status := fnd_api.g_ret_sts_error;
18528: END IF;
18521: p_credit_rating_rec.credit_score_natl_percentile > 100
18522: THEN
18523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PERCENTAGE');
18524: FND_MESSAGE.SET_TOKEN('INVALIDVAL', p_credit_rating_rec.credit_score_natl_percentile);
18525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'credit_score_natl_percentile');
18526: FND_MSG_PUB.ADD;
18527: x_return_status := fnd_api.g_ret_sts_error;
18528: END IF;
18529: END IF;
18545: THEN
18546: IF p_credit_rating_rec.failure_score_natnl_percentile < 0 OR
18547: p_credit_rating_rec.failure_score_natnl_percentile > 100
18548: THEN
18549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PERCENTAGE');
18550: FND_MESSAGE.SET_TOKEN('INVALIDVAL', p_credit_rating_rec.failure_score_natnl_percentile);
18551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'failure_score_natnl_percentile');
18552: FND_MSG_PUB.ADD;
18553: x_return_status := fnd_api.g_ret_sts_error;
18546: IF p_credit_rating_rec.failure_score_natnl_percentile < 0 OR
18547: p_credit_rating_rec.failure_score_natnl_percentile > 100
18548: THEN
18549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PERCENTAGE');
18550: FND_MESSAGE.SET_TOKEN('INVALIDVAL', p_credit_rating_rec.failure_score_natnl_percentile);
18551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'failure_score_natnl_percentile');
18552: FND_MSG_PUB.ADD;
18553: x_return_status := fnd_api.g_ret_sts_error;
18554: END IF;
18547: p_credit_rating_rec.failure_score_natnl_percentile > 100
18548: THEN
18549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PERCENTAGE');
18550: FND_MESSAGE.SET_TOKEN('INVALIDVAL', p_credit_rating_rec.failure_score_natnl_percentile);
18551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'failure_score_natnl_percentile');
18552: FND_MSG_PUB.ADD;
18553: x_return_status := fnd_api.g_ret_sts_error;
18554: END IF;
18555: END IF;