[Home] [Help]
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;
115: END IF;
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;
503:
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;
518: CLOSE c_partytype;
519: END check_organization;
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;
588: END IF;
589:
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.
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;
625: 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:
669: END validate_mandatory;
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:
707: END validate_mandatory;
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:
745: END validate_mandatory;
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;
788:
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;
833:
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;
878:
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:
933: END validate_start_end_date;
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:
950: END validate_cannot_update_to_null;
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:
967: END validate_cannot_update_to_null;
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:
984: END validate_cannot_update_to_null;
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;
1022:
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;
1043:
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;
1294:
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;
1604:
1605: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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;
1916: END IF;
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.
1959: l_error := FALSE;
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;
1995: END IF;
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;
2014: 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.
2364: l_error := TRUE;
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:
2459: CLOSE c_timezone;
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:
2514: CLOSE c_countrycode;
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;
2665:
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;
3101: */
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: */
3120:
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:
3271: END IF; -- profile = N
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;
3298:
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;
3312:
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:
3475: /*IF g_debug THEN
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:
3502: IF p_person_rec.date_of_death > SYSDATE then
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:
3509: /*IF g_debug THEN
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:
3906: ELSIF(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO')='N') --elsif corresonding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='Y')--
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:
3989: END IF;--end if corresponding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='YES')--
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:
4252: END IF; -- profile = N
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:
5446: IF g_debug 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:
5701: /*IF g_debug THEN
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:
5844: ELSE -- Global_location_number is not 13 digits long.
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:
5859: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
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:
6056: /*IF g_debug 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:
6148: /*IF g_debug THEN
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;
6290:
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:
6382: /*IF g_debug 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:
6425: -- IF g_debug 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:
6640: /*IF g_debug THEN
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
6768: WHEN NO_DATA_FOUND 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:
6872:
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:
7190: /*IF g_debug THEN
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:
7225: /*IF g_debug 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:
7419: /*IF g_debug THEN
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
7603: WHEN NO_DATA_FOUND THEN
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
7645: WHEN NO_DATA_FOUND THEN
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
7717: NULL;
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:
7977: /*IF g_debug 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:
8060: /*IF g_debug THEN
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
8090: WHEN NO_DATA_FOUND 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:
8252: */
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
8268: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
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
8287: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
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;
8447:
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:
8577: /*IF g_debug THEN
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;
8891:
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:
9019: /*IF g_debug 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:
9154: /*IF g_debug THEN
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:
9194: /*IF g_debug THEN
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;
9478:
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:
9607: /*IF g_debug 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
9796: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
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:
9852: /*IF g_debug 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
9909: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
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:
9963: /*IF g_debug THEN
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;
10095:
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:
10131: /*IF g_debug THEN
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:
10156: END IF;
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;
10361:
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:
10488: /*IF g_debug THEN
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;
10723:
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:
10855: /*IF g_debug THEN
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;
11387:
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:
11429: /*IF g_debug 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:
11466: /*IF g_debug 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
11755: END IF;
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
12126: WHEN NO_DATA_FOUND THEN
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
12152: 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:
12492: /*IF g_debug 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:
12575: /*IF g_debug THEN
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;
12654: */
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:
12706: /*IF g_debug THEN
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
12742: WHEN NO_DATA_FOUND THEN
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:
12774: -- if forward_rel_code and backward_rel_code are not same then direction_flag
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:
12784: /*IF g_debug THEN
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;
12861: /*IF g_debug THEN
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;
12893: /*IF g_debug THEN
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;
12924: END IF;
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;
12977: /*IF g_debug THEN
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;
13010: /*IF g_debug THEN
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;
13052:
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:
13092: EXCEPTION
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:
13138: EXCEPTION
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:
13181: EXCEPTION
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
13307: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
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:
13658: /*IF g_debug 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:
13740: /*IF g_debug 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:
13826: /*IF g_debug THEN
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:
13912: /*IF g_debug 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:
13996: /*IF g_debug 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:
14084: /*IF g_debug THEN
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
14313: -- old start_date, end_date has been selected from table
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;
14334:
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;
14378: END IF;
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:
14967: IF ( p_create_update_flag = 'C' AND
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:
14982: IF ( p_create_update_flag = 'C' AND
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:
14997: IF ( p_create_update_flag = 'C' AND
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:
15012: IF ( p_create_update_flag = 'C' AND
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:
15027: IF ( p_create_update_flag = 'C' AND
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:
15042: IF ( p_create_update_flag = 'C' AND
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:
15057: IF ( p_create_update_flag = 'C' AND
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:
15072: IF ( p_create_update_flag = 'C' AND
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:
15087: IF ( p_create_update_flag = 'C' AND
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:
15102: IF ( p_create_update_flag = 'C' AND
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:
15117: IF ( p_create_update_flag = 'C' AND
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:
15132: IF ( p_create_update_flag = 'C' AND
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:
15147: IF ( p_create_update_flag = 'C' AND
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:
15162: IF ( p_create_update_flag = 'C' AND
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:
15177: IF ( p_create_update_flag = 'C' AND
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:
15192: IF ( p_create_update_flag = 'C' AND
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:
15207: IF ( p_create_update_flag = 'C' AND
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:
15222: IF ( p_create_update_flag = 'C' AND
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:
15237: IF ( p_create_update_flag = 'C' AND
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:
15252: IF ( p_create_update_flag = 'C' AND
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:
15267: IF ( p_create_update_flag = 'C' AND
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:
15282: IF ( p_create_update_flag = 'C' AND
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:
15297: IF ( p_create_update_flag = 'C' AND
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:
15312: IF ( p_create_update_flag = 'C' AND
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:
15327: IF ( p_create_update_flag = 'C' AND
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:
15342: IF ( p_create_update_flag = 'C' AND
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:
15357: IF ( p_create_update_flag = 'C' AND
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:
15372: IF ( p_create_update_flag = 'C' AND
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:
15387: IF ( p_create_update_flag = 'C' AND
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:
15402: IF ( p_create_update_flag = 'C' AND
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:
15417: IF ( p_create_update_flag = 'C' AND
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:
15432: IF ( p_create_update_flag = 'C' AND
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:
15447: IF ( p_create_update_flag = 'C' AND
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:
15462: IF ( p_create_update_flag = 'C' AND
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:
15477: IF ( p_create_update_flag = 'C' AND
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:
15492: IF ( p_create_update_flag = 'C' AND
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:
15507: IF ( p_create_update_flag = 'C' AND
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:
15522: IF ( p_create_update_flag = 'C' AND
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:
15537: IF ( p_create_update_flag = 'C' AND
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:
15552: IF ( p_create_update_flag = 'C' AND
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:
15567: IF ( p_create_update_flag = 'C' AND
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:
15582: IF ( p_create_update_flag = 'C' AND
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:
15597: IF ( p_create_update_flag = 'C' AND
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:
15612: IF ( p_create_update_flag = 'C' AND
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:
15627: -- Debug info.
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;
15659:
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;
15667:
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;
15905:
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: */
16033: /*IF g_debug 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
16074: -- party_id has foreign key HZ_PARTIES.PARTY_ID
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;
16084: --Bug 2886268: Commented out the following call as it is throwing erroneous message
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: */
16120:
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;
16172:
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:
16198: --Bug 2888670: Modified the end_date validation as per V1 validation.
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;
16213: END IF;
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;
16231: elsif ( p_financial_report_rec.report_end_date < l_report_start_date OR
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;
16238: elsif (p_financial_report_rec.report_start_date is NOT NULL AND
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;
16246: end if;
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;
16272:
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;
16992:
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:
17075: /*IF g_debug THEN
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;
17151:
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;
17517:
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:
17618: /*IF g_debug THEN
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;
17678: |
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:
18442: /*IF g_debug THEN
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;
18530:
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;
18556: