eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MOSR_VALIDATE_PKG dependencies on FND_API

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: then
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
147: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+owner_table_name');
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: end if;
151: else
152: if p_create_update_flag = 'U'
153: then

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
155: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');
156: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
157: FND_MSG_PUB.ADD;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: end if;
160: end if;
161:
162: -- SST SSM Integration and Extension

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: FND_MESSAGE.SET_TOKEN('FK','orig_system');
177: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
178: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: end if;
182:
183: HZ_UTILITY_V2PUB.validate_lookup (
184: p_column => 'status',

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209: fnd_message.set_token('VALUE1', 'N(No)');
210: fnd_message.set_token('COLUMN2', 'multiple_flag');
211: fnd_message.set_token('VALUE2', 'Y(Yes)');
212: fnd_msg_pub.add;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: end if;
215: else -- other tables
216: open seed_orig_system_exist_csr;
217: fetch seed_orig_system_exist_csr into l_exist;

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: fnd_message.set_token('VALUE1', 'Y(Yes)');
224: fnd_message.set_token('COLUMN2', 'multiple_flag');
225: fnd_message.set_token('VALUE2', 'N(No)');
226: fnd_msg_pub.add;
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: end if;
229: end if;
230:
231: END IF;

Line 267: x_return_status := FND_API.G_RET_STS_ERROR;

263: IF mosr_rec_exists%FOUND then
264: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_MULTIPLE_FLAG');
265: FND_MESSAGE.SET_TOKEN('ENTITY', p_orig_sys_entity_map_rec.owner_table_name);
266: FND_MSG_PUB.ADD;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: END IF;
269: CLOSE mosr_rec_exists;
270: END IF;
271: END IF;

Line 373: p_orig_sys_reference_rec.orig_system_reference = fnd_api.g_miss_char)

369: l_debug_prefix := '';
370: IF p_create_update_flag = 'C'
371: and
372: (p_orig_sys_reference_rec.orig_system_reference is null or
373: p_orig_sys_reference_rec.orig_system_reference = fnd_api.g_miss_char)
374: THEN
375: HZ_UTILITY_V2PUB.validate_mandatory (
376: p_create_update_flag => p_create_update_flag,
377: p_column => 'orig_system_reference',

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
398: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');
399: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
400: FND_MSG_PUB.ADD;
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: end if;
403: */
404:
405: -- Validate orig_system

Line 416: x_return_status := fnd_api.g_ret_sts_error;

412: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
413: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
414: FND_MSG_PUB.ADD;
415: -- Bug 5104024
416: x_return_status := fnd_api.g_ret_sts_error;
417: END IF;
418: CLOSE c_active_orig_system_exists;
419:
420: -- validate owner_table_name.

Line 435: p_orig_sys_reference_rec.owner_table_id = fnd_api.g_miss_num)

431:
432: IF p_create_update_flag = 'C'
433: and
434: (p_orig_sys_reference_rec.owner_table_id is null or
435: p_orig_sys_reference_rec.owner_table_id = fnd_api.g_miss_num)
436: THEN
437: HZ_UTILITY_V2PUB.validate_mandatory (
438: p_create_update_flag => p_create_update_flag,
439: p_column => 'owner_table_id',

Line 454: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

450: -- Do not need to check during update because party_id is
451: -- non-updateable.
452: IF p_create_update_flag = 'C'
453: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
454: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
455: AND p_orig_sys_reference_rec.owner_table_id <> -1
456: THEN
457: BEGIN
458: SELECT 'Y'

Line 469: x_return_status := fnd_api.g_ret_sts_error;

465: fnd_message.set_token('FK', 'owner_table_id');
466: fnd_message.set_token('COLUMN', 'party_id');
467: fnd_message.set_token('TABLE', 'hz_parties');
468: fnd_msg_pub.add;
469: x_return_status := fnd_api.g_ret_sts_error;
470: END;
471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
473: p_message=>'owner_table_id is foreign key of hz_parties. ' ||

Line 488: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

484: -- Do not need to check during update because party_site_id is
485: -- non-updateable.
486: IF p_create_update_flag = 'C'
487: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
488: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
489: AND p_orig_sys_reference_rec.owner_table_id <> -1
490: THEN
491: BEGIN
492: SELECT 'Y'

Line 503: x_return_status := fnd_api.g_ret_sts_error;

499: fnd_message.set_token('FK', 'owner_table_id');
500: fnd_message.set_token('COLUMN', 'party_site_id');
501: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
502: fnd_msg_pub.add;
503: x_return_status := fnd_api.g_ret_sts_error;
504: END;
505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
506: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
507: p_message=>'owner_table_id is foreign key of HZ_PARTY_SITES. ' ||

Line 523: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

519: -- Do not need to check during update because contact_point_id is
520: -- non-updateable.
521: IF p_create_update_flag = 'C'
522: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
523: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
524: AND p_orig_sys_reference_rec.owner_table_id <> -1
525: THEN
526: BEGIN
527: SELECT 'Y'

Line 538: x_return_status := fnd_api.g_ret_sts_error;

534: fnd_message.set_token('FK', 'owner_table_id');
535: fnd_message.set_token('COLUMN', 'contact_point_id');
536: fnd_message.set_token('TABLE', 'HZ_CONTACT_POINTS');
537: fnd_msg_pub.add;
538: x_return_status := fnd_api.g_ret_sts_error;
539: END;
540: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
542: p_message=>'owner_table_id is foreign key of HZ_CONTACT_POINTS. ' ||

Line 556: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

552: -- Do not need to check during update because cust_account_id is
553: -- non-updateable.
554: IF p_create_update_flag = 'C'
555: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
556: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
557: AND p_orig_sys_reference_rec.owner_table_id <> -1
558: THEN
559: BEGIN
560: SELECT 'Y'

Line 571: x_return_status := fnd_api.g_ret_sts_error;

567: fnd_message.set_token('FK', 'owner_table_id');
568: fnd_message.set_token('COLUMN', 'cust_account_id');
569: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNTS');
570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END;
573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
575: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNTS. ' ||

Line 589: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

585: -- Do not need to check during update because cust_account_role_id is
586: -- non-updateable.
587: IF p_create_update_flag = 'C'
588: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
589: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
590: AND p_orig_sys_reference_rec.owner_table_id <> -1
591: THEN
592: BEGIN
593: SELECT 'Y'

Line 604: x_return_status := fnd_api.g_ret_sts_error;

600: fnd_message.set_token('FK', 'owner_table_id');
601: fnd_message.set_token('COLUMN', 'cust_account_role_id');
602: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNT_ROLES');
603: fnd_msg_pub.add;
604: x_return_status := fnd_api.g_ret_sts_error;
605: END;
606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
607: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
608: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNT_ROLES. ' ||

Line 623: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

619: -- Do not need to check during update because cust_acct_site_id is
620: -- non-updateable.
621: IF p_create_update_flag = 'C'
622: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
623: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
624: AND p_orig_sys_reference_rec.owner_table_id <> -1
625: THEN
626: BEGIN
627: SELECT 'Y'

Line 638: x_return_status := fnd_api.g_ret_sts_error;

634: fnd_message.set_token('FK', 'owner_table_id');
635: fnd_message.set_token('COLUMN', 'cust_acct_site_id');
636: fnd_message.set_token('TABLE', 'HZ_CUST_ACCT_SITES_ALL');
637: fnd_msg_pub.add;
638: x_return_status := fnd_api.g_ret_sts_error;
639: END;
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
642: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCT_SITES_ALL. ' ||

Line 657: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

653: -- Do not need to check during update because site_use_id is
654: -- non-updateable.
655: IF p_create_update_flag = 'C'
656: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
657: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
658: AND p_orig_sys_reference_rec.owner_table_id <> -1
659: THEN
660: BEGIN
661: SELECT 'Y'

Line 672: x_return_status := fnd_api.g_ret_sts_error;

668: fnd_message.set_token('FK', 'owner_table_id');
669: fnd_message.set_token('COLUMN', 'site_use_id');
670: fnd_message.set_token('TABLE', 'HZ_CUST_SITE_USES_ALL');
671: fnd_msg_pub.add;
672: x_return_status := fnd_api.g_ret_sts_error;
673: END;
674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
676: p_message=>'owner_table_id is foreign key of HZ_CUST_SITE_USES_ALL. ' ||

Line 691: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

687: -- Do not need to check during update because location_id is
688: -- non-updateable.
689: IF p_create_update_flag = 'C'
690: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
691: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
692: AND p_orig_sys_reference_rec.owner_table_id <> -1
693: THEN
694: BEGIN
695: SELECT 'Y'

Line 706: x_return_status := fnd_api.g_ret_sts_error;

702: fnd_message.set_token('FK', 'owner_table_id');
703: fnd_message.set_token('COLUMN', 'location_id');
704: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
705: fnd_msg_pub.add;
706: x_return_status := fnd_api.g_ret_sts_error;
707: END;
708: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
710: p_message=>'owner_table_id is foreign key of HZ_LOCATIONS. ' ||

Line 725: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

721: -- Do not need to check during update because org_contact_id is
722: -- non-updateable.
723: IF p_create_update_flag = 'C'
724: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
725: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
726: AND p_orig_sys_reference_rec.owner_table_id <> -1
727: THEN
728: BEGIN
729: SELECT 'Y'

Line 740: x_return_status := fnd_api.g_ret_sts_error;

736: fnd_message.set_token('FK', 'owner_table_id');
737: fnd_message.set_token('COLUMN', 'org_contact_id');
738: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACTS');
739: fnd_msg_pub.add;
740: x_return_status := fnd_api.g_ret_sts_error;
741: END;
742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
744: p_message=>'owner_table_id is foreign key of HZ_ORG_CONTACTS. ' ||

Line 759: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num

755: -- Do not need to check during update because org_contact_role_id is
756: -- non-updateable.
757: IF p_create_update_flag = 'C'
758: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL
759: AND p_orig_sys_reference_rec.owner_table_id <> fnd_api.g_miss_num
760: AND p_orig_sys_reference_rec.owner_table_id <> -1
761: THEN
762: BEGIN
763: SELECT 'Y'

Line 774: x_return_status := fnd_api.g_ret_sts_error;

770: fnd_message.set_token('FK', 'owner_table_id');
771: fnd_message.set_token('COLUMN', 'org_contact_role_id');
772: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACT_ROLES');
773: fnd_msg_pub.add;
774: x_return_status := fnd_api.g_ret_sts_error;
775: END;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
778: p_message=>'owner_table_id is foreign key of HZ_ORG_CONTACT_ROLES. ' ||

Line 800: x_return_status := FND_API.G_RET_STS_ERROR;

796: then
797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
798: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_name+owner_table_id');
799: FND_MSG_PUB.ADD;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: end if;
802: end if;
803:
804: l_dup_exist := orig_sys_reference_exist_cre(p_orig_sys_reference_rec.orig_system,

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

810: then
811: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
812: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_name');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: end if;
816:
817: if p_create_update_flag = 'U'
818: and orig_sys_reference_exist(p_orig_sys_reference_rec.orig_system,

Line 823: or p_orig_sys_reference_rec.old_orig_system_reference = fnd_api.g_miss_char)

819: p_orig_sys_reference_rec.orig_system_reference,
820: p_orig_sys_reference_rec.owner_table_name) = 'N'
821: and
822: (p_orig_sys_reference_rec.old_orig_system_reference is null
823: or p_orig_sys_reference_rec.old_orig_system_reference = fnd_api.g_miss_char)
824: then
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
826: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
827: FND_MSG_PUB.ADD;

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824: then
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
826: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
827: FND_MSG_PUB.ADD;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: end if;
830:
831: if (p_orig_sys_reference_rec.old_orig_system_reference is not null
832: and p_orig_sys_reference_rec.old_orig_system_reference<> fnd_api.g_miss_char)

Line 832: and p_orig_sys_reference_rec.old_orig_system_reference<> fnd_api.g_miss_char)

828: x_return_status := FND_API.G_RET_STS_ERROR;
829: end if;
830:
831: if (p_orig_sys_reference_rec.old_orig_system_reference is not null
832: and p_orig_sys_reference_rec.old_orig_system_reference<> fnd_api.g_miss_char)
833: then
834: if orig_sys_reference_exist(p_orig_sys_reference_rec.orig_system,
835: p_orig_sys_reference_rec.old_orig_system_reference,
836: p_orig_sys_reference_rec.owner_table_name) = 'N'

Line 841: x_return_status := FND_API.G_RET_STS_ERROR;

837: then
838: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
839: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+old_orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
840: FND_MSG_PUB.ADD;
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: end if;
843: end if;
844:
845: if (p_orig_sys_reference_rec.start_date_active is not null

Line 846: and p_orig_sys_reference_rec.start_date_active <>fnd_api.g_miss_date

842: end if;
843: end if;
844:
845: if (p_orig_sys_reference_rec.start_date_active is not null
846: and p_orig_sys_reference_rec.start_date_active <>fnd_api.g_miss_date
847: and trunc(p_orig_sys_reference_rec.start_date_active) > trunc(sysdate)) /* Bug 3298896 */
848: then
849: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');
850: FND_MESSAGE.SET_TOKEN('COLUMN','start_date_active');

Line 852: x_return_status := FND_API.G_RET_STS_ERROR;

848: then
849: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');
850: FND_MESSAGE.SET_TOKEN('COLUMN','start_date_active');
851: FND_MSG_PUB.ADD;
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: end if;
854:
855: if (p_orig_sys_reference_rec.end_date_active is not null
856: and p_orig_sys_reference_rec.end_date_active <>fnd_api.g_miss_date

Line 856: and p_orig_sys_reference_rec.end_date_active <>fnd_api.g_miss_date

852: x_return_status := FND_API.G_RET_STS_ERROR;
853: end if;
854:
855: if (p_orig_sys_reference_rec.end_date_active is not null
856: and p_orig_sys_reference_rec.end_date_active <>fnd_api.g_miss_date
857: and trunc(p_orig_sys_reference_rec.end_date_active) > trunc(sysdate)) /* Bug 3298896 */
858: then
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');
860: FND_MESSAGE.SET_TOKEN('COLUMN','end_date_active');

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: then
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');
860: FND_MESSAGE.SET_TOKEN('COLUMN','end_date_active');
861: FND_MSG_PUB.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: end if;
864:
865:
866: HZ_UTILITY_V2PUB.validate_lookup (

Line 885: p_orig_sys_reference_rec.owner_table_id<>fnd_api.g_miss_num)

881: fetch get_orig_sys_reference_csr into l_start_date,l_end_date;
882: close get_orig_sys_reference_csr;
883:
884: if (p_orig_sys_reference_rec.owner_table_id is not null and
885: p_orig_sys_reference_rec.owner_table_id<>fnd_api.g_miss_num)
886: then
887: open get_nonupdateable_columns1;
888: fetch get_nonupdateable_columns1 into l_created_by_module, l_application_id;
889: close get_nonupdateable_columns1;

Line 891: p_orig_sys_reference_rec.orig_system_ref_id<>fnd_api.g_miss_num)

887: open get_nonupdateable_columns1;
888: fetch get_nonupdateable_columns1 into l_created_by_module, l_application_id;
889: close get_nonupdateable_columns1;
890: elsif (p_orig_sys_reference_rec.orig_system_ref_id is not null and
891: p_orig_sys_reference_rec.orig_system_ref_id<>fnd_api.g_miss_num)
892: then
893: open get_nonupdateable_columns2;
894: fetch get_nonupdateable_columns2 into l_created_by_module, l_application_id;
895: close get_nonupdateable_columns2;

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964: from dual;
965: if l_check_orig_system is not null then
966: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_SOURCE_SYSTEM');
967: FND_MSG_PUB.ADD;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: end if;
970:
971: IF p_create_update_flag = 'C' THEN
972: open source_system_exist;

Line 979: x_return_status := FND_API.G_RET_STS_ERROR;

975: if source_system_exist%FOUND then
976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
977: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system');
978: FND_MSG_PUB.ADD;
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: end if;
981:
982: HZ_UTILITY_V2PUB.validate_mandatory (
983: p_create_update_flag => p_create_update_flag,

Line 1036: x_return_status := FND_API.G_RET_STS_ERROR;

1032: END IF; */
1033: IF l_sst_flag = 'Y' and p_orig_sys_rec.sst_flag = 'N' THEN
1034: FND_MESSAGE.SET_NAME('AR','HZ_SST_N_TO_Y_ONLY');
1035: FND_MSG_PUB.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: END IF;
1038:
1039: IF p_orig_sys_rec.orig_system IS NOT NULL THEN
1040: HZ_UTILITY_V2PUB.validate_nonupdateable (