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_PARTY_V2PUB dependencies on FND_API

Line 417: RAISE FND_API.G_EXC_ERROR;

413: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
414: fnd_message.set_token('PARTY_ID', p_party_id);
415: fnd_message.set_token('PARTY_TYPE', l_party_type);
416: fnd_msg_pub.add;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: END party_exists;
421:

Line 529: p_person_rec.person_title <> FND_API.G_MISS_CHAR

525: -- Preserve backwards compatibility and use the original logic
526: --
527:
528: IF p_person_rec.person_title IS NOT NULL AND
529: p_person_rec.person_title <> FND_API.G_MISS_CHAR
530: THEN
531: l_person_name := p_person_rec.person_title;
532: END IF;
533:

Line 535: p_person_rec.person_first_name <> FND_API.G_MISS_CHAR

531: l_person_name := p_person_rec.person_title;
532: END IF;
533:
534: IF p_person_rec.person_first_name IS NOT NULL AND
535: p_person_rec.person_first_name <> FND_API.G_MISS_CHAR
536: THEN
537: IF l_person_name IS NOT NULL THEN
538: l_person_name := l_person_name || ' ' || p_person_rec.person_first_name;
539: ELSE

Line 545: p_person_rec.person_middle_name <> FND_API.G_MISS_CHAR

541: END IF;
542: END IF;
543:
544: IF p_person_rec.person_middle_name IS NOT NULL AND
545: p_person_rec.person_middle_name <> FND_API.G_MISS_CHAR
546: THEN
547: IF l_person_name IS NOT NULL THEN
548: l_person_name := l_person_name || ' ' || p_person_rec.person_middle_name;
549: ELSE

Line 555: p_person_rec.person_last_name <> FND_API.G_MISS_CHAR

551: END IF;
552: END IF;
553:
554: IF p_person_rec.person_last_name IS NOT NULL AND
555: p_person_rec.person_last_name <> FND_API.G_MISS_CHAR
556: THEN
557: IF l_person_name IS NOT NULL THEN
558: l_person_name := l_person_name || ' ' || p_person_rec.person_last_name;
559: ELSE

Line 565: p_person_rec.person_name_suffix <> FND_API.G_MISS_CHAR

561: END IF;
562: END IF;
563:
564: IF p_person_rec.person_name_suffix IS NOT NULL AND
565: p_person_rec.person_name_suffix <> FND_API.G_MISS_CHAR
566: THEN
567: IF l_person_name IS NOT NULL THEN
568: l_person_name := l_person_name || ' ' || p_person_rec.person_name_suffix;
569: ELSE

Line 635: p_person_first_name <> FND_API.G_MISS_CHAR

631: p_msg_level=>fnd_log.level_procedure);
632: END IF;
633:
634: IF p_person_first_name IS NOT NULL AND
635: p_person_first_name <> FND_API.G_MISS_CHAR
636: THEN
637: l_party_name := p_person_first_name;
638: END IF;
639:

Line 641: p_person_last_name <> FND_API.G_MISS_CHAR

637: l_party_name := p_person_first_name;
638: END IF;
639:
640: IF p_person_last_name IS NOT NULL AND
641: p_person_last_name <> FND_API.G_MISS_CHAR
642: THEN
643: IF l_party_name IS NOT NULL THEN
644: l_party_name := l_party_name||' '||p_person_last_name;
645: ELSE

Line 765: RAISE FND_API.G_EXC_ERROR;

761: WHEN OTHERS THEN
762: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
763: fnd_message.set_token('TABLE', 'HZ_PARTIES');
764: fnd_msg_pub.add;
765: RAISE FND_API.G_EXC_ERROR;
766: END;
767:
768: UPDATE hz_parties
769: SET party_name = l_party_name

Line 1046: IF p_old_person_rec.created_by_module = fnd_api.g_miss_char THEN

1042: IF p_party_type = 'PERSON' THEN
1043: l_party_rec := p_person_rec.party_rec;
1044: l_old_party_rec := p_old_person_rec.party_rec;
1045: --4621564
1046: IF p_old_person_rec.created_by_module = fnd_api.g_miss_char THEN
1047: l_created_by_module := 'TCA_V2_API';
1048: ELSE
1049: l_created_by_module := p_old_person_rec.created_by_module;
1050: END IF;

Line 1057: IF p_old_organization_rec.created_by_module = fnd_api.g_miss_char THEN

1053: ELSIF p_party_type = 'ORGANIZATION' THEN
1054: l_party_rec := p_organization_rec.party_rec;
1055: l_old_party_rec := p_old_organization_rec.party_rec;
1056: --4621564
1057: IF p_old_organization_rec.created_by_module = fnd_api.g_miss_char THEN
1058: l_created_by_module := 'TCA_V2_API';
1059: ELSE
1060: l_created_by_module := p_old_organization_rec.created_by_module;
1061: END IF;

Line 1068: IF p_old_group_rec.created_by_module = fnd_api.g_miss_char THEN

1064: ELSE
1065: l_party_rec := p_group_rec.party_rec;
1066: l_old_party_rec := p_old_group_rec.party_rec;
1067: --4621564
1068: IF p_old_group_rec.created_by_module = fnd_api.g_miss_char THEN
1069: l_created_by_module := 'TCA_V2_API';
1070: ELSE
1071: l_created_by_module := p_old_group_rec.created_by_module;
1072: END IF;

Line 1089: l_party_rec.category_code <> FND_API.G_MISS_CHAR) OR

1085: -- Mapping API is not populating party_rec.category_code.
1086:
1087: IF (p_create_update_flag = 'C' AND
1088: l_party_rec.category_code IS NOT NULL AND
1089: l_party_rec.category_code <> FND_API.G_MISS_CHAR) OR
1090: (p_create_update_flag = 'U'AND
1091: l_party_rec.category_code IS NOT NULL AND
1092: -- Bug 3876180.
1093: -- l_party_rec.category_code <> FND_API.G_MISS_CHAR AND

Line 1093: -- l_party_rec.category_code <> FND_API.G_MISS_CHAR AND

1089: l_party_rec.category_code <> FND_API.G_MISS_CHAR) OR
1090: (p_create_update_flag = 'U'AND
1091: l_party_rec.category_code IS NOT NULL AND
1092: -- Bug 3876180.
1093: -- l_party_rec.category_code <> FND_API.G_MISS_CHAR AND
1094: l_party_rec.category_code <> l_old_party_rec.category_code) AND
1095: l_data_source_type = G_MISS_CONTENT_SOURCE_TYPE
1096: THEN
1097: hz_classification_v2pub.set_primary_code_assignment(

Line 1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1109: x_return_status => x_return_status,
1110: x_msg_count => l_msg_count,
1111: x_msg_data => l_msg_data );
1112:
1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: END IF;
1117:

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: x_msg_count => l_msg_count,
1111: x_msg_data => l_msg_data );
1112:
1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: END IF;
1117:
1118: IF p_party_type = 'ORGANIZATION' THEN

Line 1125: l_sic_code := NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR);

1121: -- sic_code_type is required for entering sic_code and vice versa.
1122: -- That means, for both of them, we either provide values or leave
1123: -- them NULL.
1124: IF p_create_update_flag = 'C' THEN
1125: l_sic_code := NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR);
1126: l_sic_code_type := NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR);
1127: ELSE
1128: l_sic_code := NVL(p_organization_rec.sic_code, p_old_organization_rec.sic_code);
1129: l_sic_code_type := NVL(p_organization_rec.sic_code_type, p_old_organization_rec.sic_code_type);

Line 1126: l_sic_code_type := NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR);

1122: -- That means, for both of them, we either provide values or leave
1123: -- them NULL.
1124: IF p_create_update_flag = 'C' THEN
1125: l_sic_code := NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR);
1126: l_sic_code_type := NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR);
1127: ELSE
1128: l_sic_code := NVL(p_organization_rec.sic_code, p_old_organization_rec.sic_code);
1129: l_sic_code_type := NVL(p_organization_rec.sic_code_type, p_old_organization_rec.sic_code_type);
1130: END IF;

Line 1132: IF (l_sic_code_type = FND_API.G_MISS_CHAR AND

1128: l_sic_code := NVL(p_organization_rec.sic_code, p_old_organization_rec.sic_code);
1129: l_sic_code_type := NVL(p_organization_rec.sic_code_type, p_old_organization_rec.sic_code_type);
1130: END IF;
1131:
1132: IF (l_sic_code_type = FND_API.G_MISS_CHAR AND
1133: l_sic_code <> FND_API.G_MISS_CHAR) OR
1134: (l_sic_code = FND_API.G_MISS_CHAR AND
1135: l_sic_code_type <> FND_API.G_MISS_CHAR)
1136: THEN

Line 1133: l_sic_code <> FND_API.G_MISS_CHAR) OR

1129: l_sic_code_type := NVL(p_organization_rec.sic_code_type, p_old_organization_rec.sic_code_type);
1130: END IF;
1131:
1132: IF (l_sic_code_type = FND_API.G_MISS_CHAR AND
1133: l_sic_code <> FND_API.G_MISS_CHAR) OR
1134: (l_sic_code = FND_API.G_MISS_CHAR AND
1135: l_sic_code_type <> FND_API.G_MISS_CHAR)
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');

Line 1134: (l_sic_code = FND_API.G_MISS_CHAR AND

1130: END IF;
1131:
1132: IF (l_sic_code_type = FND_API.G_MISS_CHAR AND
1133: l_sic_code <> FND_API.G_MISS_CHAR) OR
1134: (l_sic_code = FND_API.G_MISS_CHAR AND
1135: l_sic_code_type <> FND_API.G_MISS_CHAR)
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');
1138: fnd_msg_pub.add;

Line 1135: l_sic_code_type <> FND_API.G_MISS_CHAR)

1131:
1132: IF (l_sic_code_type = FND_API.G_MISS_CHAR AND
1133: l_sic_code <> FND_API.G_MISS_CHAR) OR
1134: (l_sic_code = FND_API.G_MISS_CHAR AND
1135: l_sic_code_type <> FND_API.G_MISS_CHAR)
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');
1138: fnd_msg_pub.add;
1139: RAISE FND_API.G_EXC_ERROR;

Line 1139: RAISE FND_API.G_EXC_ERROR;

1135: l_sic_code_type <> FND_API.G_MISS_CHAR)
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');
1138: fnd_msg_pub.add;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;
1141:
1142: -- the sic_code_type ='OTHER' is allowed only when
1143: -- comming data source = G_MISS_CONTENT_SOURCE_TYPE

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: l_data_source_type <> G_MISS_CONTENT_SOURCE_TYPE
1147: THEN
1148: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_OTHER');
1149: fnd_msg_pub.add;
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153: -- call hz_classification_v2pub.set_primary_code_assignment.
1154: -- if sic_code_type is not 'OTHER', then make the sic_code as the primary

Line 1160: IF l_sic_code=FND_API.G_MISS_CHAR

1156: -- hz_classification_v2pub.set_primary_code_assignment.
1157: -- if local_activity_code has a value, call
1158: -- hz_classification_v2pub.set_primary_code_assignment.
1159:
1160: IF l_sic_code=FND_API.G_MISS_CHAR
1161: AND l_sic_code_type=FND_API.G_MISS_CHAR
1162: AND p_old_organization_rec.sic_code_type IS NOT NULL
1163: AND p_old_organization_rec.sic_code_type<>FND_API.G_MISS_CHAR
1164: THEN

Line 1161: AND l_sic_code_type=FND_API.G_MISS_CHAR

1157: -- if local_activity_code has a value, call
1158: -- hz_classification_v2pub.set_primary_code_assignment.
1159:
1160: IF l_sic_code=FND_API.G_MISS_CHAR
1161: AND l_sic_code_type=FND_API.G_MISS_CHAR
1162: AND p_old_organization_rec.sic_code_type IS NOT NULL
1163: AND p_old_organization_rec.sic_code_type<>FND_API.G_MISS_CHAR
1164: THEN
1165: l_sic_code_type := p_old_organization_rec.sic_code_type;

Line 1163: AND p_old_organization_rec.sic_code_type<>FND_API.G_MISS_CHAR

1159:
1160: IF l_sic_code=FND_API.G_MISS_CHAR
1161: AND l_sic_code_type=FND_API.G_MISS_CHAR
1162: AND p_old_organization_rec.sic_code_type IS NOT NULL
1163: AND p_old_organization_rec.sic_code_type<>FND_API.G_MISS_CHAR
1164: THEN
1165: l_sic_code_type := p_old_organization_rec.sic_code_type;
1166: END IF;
1167:

Line 1169: IF --l_sic_code <> FND_API.G_MISS_CHAR AND ( bug 3876180 )

1165: l_sic_code_type := p_old_organization_rec.sic_code_type;
1166: END IF;
1167:
1168:
1169: IF --l_sic_code <> FND_API.G_MISS_CHAR AND ( bug 3876180 )
1170: l_sic_code_type <> FND_API.G_MISS_CHAR AND
1171: l_sic_code_type <> 'OTHER' AND
1172: (p_create_update_flag = 'C' OR
1173: (p_create_update_flag = 'U' AND

Line 1170: l_sic_code_type <> FND_API.G_MISS_CHAR AND

1166: END IF;
1167:
1168:
1169: IF --l_sic_code <> FND_API.G_MISS_CHAR AND ( bug 3876180 )
1170: l_sic_code_type <> FND_API.G_MISS_CHAR AND
1171: l_sic_code_type <> 'OTHER' AND
1172: (p_create_update_flag = 'C' OR
1173: (p_create_update_flag = 'U' AND
1174: NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR) <>

Line 1174: NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR) <>

1170: l_sic_code_type <> FND_API.G_MISS_CHAR AND
1171: l_sic_code_type <> 'OTHER' AND
1172: (p_create_update_flag = 'C' OR
1173: (p_create_update_flag = 'U' AND
1174: NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR) <>
1175: p_old_organization_rec.sic_code
1176: OR -- Bug 4043346
1177: NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR) <>
1178: p_old_organization_rec.sic_code_type))

Line 1177: NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR) <>

1173: (p_create_update_flag = 'U' AND
1174: NVL(p_organization_rec.sic_code, FND_API.G_MISS_CHAR) <>
1175: p_old_organization_rec.sic_code
1176: OR -- Bug 4043346
1177: NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR) <>
1178: p_old_organization_rec.sic_code_type))
1179: THEN
1180: hz_classification_v2pub.set_primary_code_assignment(
1181: p_owner_table_name => 'HZ_PARTIES',

Line 1196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1192: x_return_status => x_return_status,
1193: x_msg_count => l_msg_count,
1194: x_msg_data => l_msg_data );
1195:
1196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: RAISE FND_API.G_EXC_ERROR;
1198: END IF;
1199: END IF;
1200:

Line 1197: RAISE FND_API.G_EXC_ERROR;

1193: x_msg_count => l_msg_count,
1194: x_msg_data => l_msg_data );
1195:
1196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: RAISE FND_API.G_EXC_ERROR;
1198: END IF;
1199: END IF;
1200:
1201: IF (p_create_update_flag = 'C' AND

Line 1203: p_organization_rec.local_activity_code <> FND_API.G_MISS_CHAR) OR

1199: END IF;
1200:
1201: IF (p_create_update_flag = 'C' AND
1202: p_organization_rec.local_activity_code IS NOT NULL AND
1203: p_organization_rec.local_activity_code <> FND_API.G_MISS_CHAR) OR
1204: (p_create_update_flag = 'U'AND
1205: p_organization_rec.local_activity_code IS NOT NULL AND
1206: p_organization_rec.local_activity_code <> FND_API.G_MISS_CHAR AND
1207: p_organization_rec.local_activity_code <> p_old_organization_rec.local_activity_code)

Line 1206: p_organization_rec.local_activity_code <> FND_API.G_MISS_CHAR AND

1202: p_organization_rec.local_activity_code IS NOT NULL AND
1203: p_organization_rec.local_activity_code <> FND_API.G_MISS_CHAR) OR
1204: (p_create_update_flag = 'U'AND
1205: p_organization_rec.local_activity_code IS NOT NULL AND
1206: p_organization_rec.local_activity_code <> FND_API.G_MISS_CHAR AND
1207: p_organization_rec.local_activity_code <> p_old_organization_rec.local_activity_code)
1208: THEN
1209:
1210: -- Bug 3040565 : Modified the parameter p_class_category to set_primary_code_assignment to pass

Line 1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1234: x_return_status => x_return_status,
1235: x_msg_count => l_msg_count,
1236: x_msg_data => l_msg_data );
1237:
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;
1241: END IF;
1242: END IF;

Line 1239: RAISE FND_API.G_EXC_ERROR;

1235: x_msg_count => l_msg_count,
1236: x_msg_data => l_msg_data );
1237:
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;
1241: END IF;
1242: END IF;
1243:

Line 1496: RAISE fnd_api.g_exc_error;

1492: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1493: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1494: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1495: fnd_msg_pub.add;
1496: RAISE fnd_api.g_exc_error;
1497: END IF;
1498: CLOSE c_person;
1499:
1500:

Line 1548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1544: p_new_profile_id => x_profile_id,
1545: x_return_status => l_return_status
1546: );
1547:
1548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551: END IF;
1552:

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: x_return_status => l_return_status
1546: );
1547:
1548: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551: END IF;
1552:
1553: ELSE

Line 1734: RAISE fnd_api.g_exc_error;

1730: WHEN g_resource_busy THEN
1731: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1732: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1733: fnd_msg_pub.add;
1734: RAISE fnd_api.g_exc_error;
1735:
1736: END do_update_person_profile;
1737:
1738: /**

Line 2092: RAISE fnd_api.g_exc_error;

2088: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2089: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2090: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2091: fnd_msg_pub.add;
2092: RAISE fnd_api.g_exc_error;
2093: END IF;
2094: CLOSE c_org;
2095:
2096: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN

Line 2162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2158: p_new_profile_id => x_profile_id,
2159: x_return_status => l_return_status
2160: );
2161:
2162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2163: RAISE FND_API.G_EXC_ERROR;
2164: END IF;
2165: END IF;
2166:

Line 2163: RAISE FND_API.G_EXC_ERROR;

2159: x_return_status => l_return_status
2160: );
2161:
2162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2163: RAISE FND_API.G_EXC_ERROR;
2164: END IF;
2165: END IF;
2166:
2167: ELSE

Line 2386: RAISE fnd_api.g_exc_error;

2382: WHEN g_resource_busy THEN
2383: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2384: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2385: fnd_msg_pub.add;
2386: RAISE fnd_api.g_exc_error;
2387:
2388: END do_update_org_profile;
2389:
2390: /**

Line 2439: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2435: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;
2436: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;
2437: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;
2438: l_exists VARCHAR2(1);
2439: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2440: l_msg_count NUMBER;
2441: l_msg_data VARCHAR2(2000);
2442:
2443: CURSOR c_check_party_mapping

Line 2507: l_orig_system <>fnd_api.g_miss_char

2503: * If it is already existing, the call may be due to
2504: * HZ_PROFILE_VERSION profile setup
2505: */
2506: if l_orig_system is not null and
2507: l_orig_system <>fnd_api.g_miss_char
2508: then
2509: open c_check_party_mapping;
2510: fetch c_check_party_mapping into l_exists;
2511: if c_check_party_mapping%NOTFOUND then

Line 2524: FND_API.G_FALSE,

2520: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'DQM Sync Mode '||l_orig_sys_reference_rec.dqm_sync_mode,
2521: p_msg_level=>fnd_log.level_statement);
2522: END IF;
2523: hz_orig_system_ref_pub.create_orig_system_reference(
2524: FND_API.G_FALSE,
2525: l_orig_sys_reference_rec,
2526: l_return_status,
2527: l_msg_count,
2528: l_msg_data);

Line 2530: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2526: l_return_status,
2527: l_msg_count,
2528: l_msg_data);
2529:
2530: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2531: RAISE FND_API.G_EXC_ERROR;
2532: END IF;
2533: end if;
2534: end if;

Line 2531: RAISE FND_API.G_EXC_ERROR;

2527: l_msg_count,
2528: l_msg_data);
2529:
2530: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2531: RAISE FND_API.G_EXC_ERROR;
2532: END IF;
2533: end if;
2534: end if;
2535:

Line 2661: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2657: x_person_rec OUT NOCOPY PERSON_REC_TYPE,
2658: x_organization_rec OUT NOCOPY ORGANIZATION_REC_TYPE
2659: ) IS
2660:
2661: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2662: l_msg_count NUMBER;
2663: l_msg_data VARCHAR2(2000);
2664: l_debug_prefix VARCHAR2(30) := '';
2665: BEGIN

Line 2703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2699: x_msg_data => l_msg_data);
2700:
2701: END IF;
2702:
2703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2704: RAISE FND_API.G_EXC_ERROR;
2705: END IF;
2706:
2707: -- Debug info.

Line 2704: RAISE FND_API.G_EXC_ERROR;

2700:
2701: END IF;
2702:
2703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2704: RAISE FND_API.G_EXC_ERROR;
2705: END IF;
2706:
2707: -- Debug info.
2708: /*IF g_debug THEN

Line 2780: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2776: l_party_object_version_number NUMBER;
2777: l_rowid ROWID := NULL;
2778: l_process_party_name VARCHAR2(1);
2779: l_dummy VARCHAR2(1);
2780: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2781: l_context VARCHAR2(1);
2782:
2783: l_debug_prefix VARCHAR2(30);
2784: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

Line 2836: and l_party_rec.orig_system <>fnd_api.g_miss_char)

2832:
2833: -- moved the mosr logic to update_xxx due to get_rec need party_id
2834: /* if p_create_update_flag = 'U' THEN
2835: IF (l_party_rec.orig_system is not null
2836: and l_party_rec.orig_system <>fnd_api.g_miss_char)
2837: and (l_party_rec.orig_system_reference is not null
2838: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
2839: and (l_party_rec.party_id = FND_API.G_MISS_NUM or l_party_rec.party_id is null) THEN
2840: hz_orig_system_ref_pub.get_owner_table_id

Line 2838: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)

2834: /* if p_create_update_flag = 'U' THEN
2835: IF (l_party_rec.orig_system is not null
2836: and l_party_rec.orig_system <>fnd_api.g_miss_char)
2837: and (l_party_rec.orig_system_reference is not null
2838: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
2839: and (l_party_rec.party_id = FND_API.G_MISS_NUM or l_party_rec.party_id is null) THEN
2840: hz_orig_system_ref_pub.get_owner_table_id
2841: (p_orig_system => l_party_rec.orig_system,
2842: p_orig_system_reference => l_party_rec.orig_system_reference,

Line 2839: and (l_party_rec.party_id = FND_API.G_MISS_NUM or l_party_rec.party_id is null) THEN

2835: IF (l_party_rec.orig_system is not null
2836: and l_party_rec.orig_system <>fnd_api.g_miss_char)
2837: and (l_party_rec.orig_system_reference is not null
2838: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
2839: and (l_party_rec.party_id = FND_API.G_MISS_NUM or l_party_rec.party_id is null) THEN
2840: hz_orig_system_ref_pub.get_owner_table_id
2841: (p_orig_system => l_party_rec.orig_system,
2842: p_orig_system_reference => l_party_rec.orig_system_reference,
2843: p_owner_table_name => 'HZ_PARTIES',

Line 2846: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2842: p_orig_system_reference => l_party_rec.orig_system_reference,
2843: p_owner_table_name => 'HZ_PARTIES',
2844: x_owner_table_id => l_party_rec.party_id,
2845: x_return_status => l_return_status);
2846: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2847: RAISE FND_API.G_EXC_ERROR;
2848: END IF;
2849: END IF;
2850: end if;

Line 2847: RAISE FND_API.G_EXC_ERROR;

2843: p_owner_table_name => 'HZ_PARTIES',
2844: x_owner_table_id => l_party_rec.party_id,
2845: x_return_status => l_return_status);
2846: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2847: RAISE FND_API.G_EXC_ERROR;
2848: END IF;
2849: END IF;
2850: end if;
2851: */

Line 2862: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR

2858: -- not passed or is a duplicate raise error.
2859:
2860: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2861:
2862: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2863: l_party_rec.party_number IS NULL
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2866: fnd_message.set_token('COLUMN', 'party number');

Line 2868: RAISE FND_API.G_EXC_ERROR;

2864: THEN
2865: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2866: fnd_message.set_token('COLUMN', 'party number');
2867: fnd_msg_pub.add;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870:
2871: OPEN c_party_number_exists(l_party_rec.party_number);
2872: FETCH c_party_number_exists INTO l_dummy;

Line 2878: RAISE FND_API.G_EXC_ERROR;

2874: IF NOT c_party_number_exists%NOTFOUND THEN
2875: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
2876: fnd_message.set_token('COLUMN', 'party_number');
2877: fnd_msg_pub.add;
2878: RAISE FND_API.G_EXC_ERROR;
2879: END IF;
2880: CLOSE c_party_number_exists;
2881:
2882: ELSE -- GENERATE_PARTY_NUMBER is 'Y'

Line 2884: IF l_party_rec.party_number <> FND_API.G_MISS_CHAR AND

2880: CLOSE c_party_number_exists;
2881:
2882: ELSE -- GENERATE_PARTY_NUMBER is 'Y'
2883:
2884: IF l_party_rec.party_number <> FND_API.G_MISS_CHAR AND
2885: l_party_rec.party_number IS NOT NULL
2886: THEN
2887: fnd_message.set_name('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');
2888: fnd_msg_pub.add;

Line 2889: RAISE FND_API.G_EXC_ERROR;

2885: l_party_rec.party_number IS NOT NULL
2886: THEN
2887: fnd_message.set_name('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');
2888: fnd_msg_pub.add;
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;
2891:
2892: END IF;
2893:

Line 2908: RAISE fnd_api.g_exc_error;

2904: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2905: fnd_message.set_token('RECORD', 'party');
2906: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2907: fnd_msg_pub.add;
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF p_check_object_version_number = 'Y' AND
2910: NOT ((p_party_object_version_number IS NULL AND
2911: l_party_object_version_number IS NULL) OR
2912: (p_party_object_version_number IS NOT NULL AND

Line 2919: RAISE fnd_api.g_exc_error;

2915: THEN
2916: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2917: fnd_message.set_token('TABLE', 'HZ_PARTIES');
2918: fnd_msg_pub.add;
2919: RAISE fnd_api.g_exc_error;
2920: END IF;
2921: CLOSE c_party;
2922:
2923: p_party_object_version_number := nvl(l_party_object_version_number, 1)+1;

Line 3051: l_party_name <> FND_API.G_MISS_CHAR AND

3047:
3048: -- generate customer key
3049:
3050: IF l_party_name IS NOT NULL AND
3051: l_party_name <> FND_API.G_MISS_CHAR AND
3052: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3053: THEN
3054: l_customer_key := HZ_FUZZY_PUB.generate_key (
3055: p_key_type => 'PERSON',

Line 3052: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)

3048: -- generate customer key
3049:
3050: IF l_party_name IS NOT NULL AND
3051: l_party_name <> FND_API.G_MISS_CHAR AND
3052: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3053: THEN
3054: l_customer_key := HZ_FUZZY_PUB.generate_key (
3055: p_key_type => 'PERSON',
3056: p_first_name => l_first_name,

Line 3099: l_party_name <> FND_API.G_MISS_CHAR AND

3095:
3096: -- generate customer key
3097:
3098: IF l_party_name IS NOT NULL AND
3099: l_party_name <> FND_API.G_MISS_CHAR AND
3100: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3101: THEN
3102: l_customer_key := hz_fuzzy_pub.generate_key (
3103: p_key_type => 'ORGANIZATION',

Line 3100: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)

3096: -- generate customer key
3097:
3098: IF l_party_name IS NOT NULL AND
3099: l_party_name <> FND_API.G_MISS_CHAR AND
3100: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3101: THEN
3102: l_customer_key := hz_fuzzy_pub.generate_key (
3103: p_key_type => 'ORGANIZATION',
3104: p_party_name => p_organization_rec.organization_name );

Line 3128: l_party_name <> FND_API.G_MISS_CHAR AND

3124:
3125: -- generate customer key
3126:
3127: IF l_party_name IS NOT NULL AND
3128: l_party_name <> FND_API.G_MISS_CHAR AND
3129: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3130: THEN
3131: l_customer_key := HZ_FUZZY_PUB.generate_key (
3132: p_key_type => 'GROUP',

Line 3129: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)

3125: -- generate customer key
3126:
3127: IF l_party_name IS NOT NULL AND
3128: l_party_name <> FND_API.G_MISS_CHAR AND
3129: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3130: THEN
3131: l_customer_key := HZ_FUZZY_PUB.generate_key (
3132: p_key_type => 'GROUP',
3133: p_party_name => p_group_rec.group_name );

Line 3152: NVL(db_created_by_module, fnd_api.g_miss_char), l_return_status);

3148:
3149: -- validate party record.
3150: HZ_registry_validate_v2pub.validate_party(
3151: p_create_update_flag, l_party_rec, l_old_party_rec,
3152: NVL(db_created_by_module, fnd_api.g_miss_char), l_return_status);
3153: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3154: RAISE FND_API.G_EXC_ERROR;
3155: END IF;
3156:

Line 3153: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3149: -- validate party record.
3150: HZ_registry_validate_v2pub.validate_party(
3151: p_create_update_flag, l_party_rec, l_old_party_rec,
3152: NVL(db_created_by_module, fnd_api.g_miss_char), l_return_status);
3153: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3154: RAISE FND_API.G_EXC_ERROR;
3155: END IF;
3156:
3157: -- call table handlers

Line 3154: RAISE FND_API.G_EXC_ERROR;

3150: HZ_registry_validate_v2pub.validate_party(
3151: p_create_update_flag, l_party_rec, l_old_party_rec,
3152: NVL(db_created_by_module, fnd_api.g_miss_char), l_return_status);
3153: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3154: RAISE FND_API.G_EXC_ERROR;
3155: END IF;
3156:
3157: -- call table handlers
3158:

Line 3173: IF l_party_rec.party_id = FND_API.G_MISS_NUM THEN

3169: p_msg_level=>fnd_log.level_procedure);
3170: END IF;
3171:
3172: -- this is for handling orig_system_reference defaulting
3173: IF l_party_rec.party_id = FND_API.G_MISS_NUM THEN
3174: l_party_rec.party_id := NULL;
3175: END IF;
3176:
3177: hz_parties_pkg.insert_row (

Line 3277: and l_party_rec.orig_system <>fnd_api.g_miss_char

3273: p_msg_level=>fnd_log.level_procedure);
3274: END IF;
3275:
3276: if l_party_rec.orig_system is not null
3277: and l_party_rec.orig_system <>fnd_api.g_miss_char
3278: -- Bug 4239442 : create MOSR entry only for GROUP party
3279: and p_party_type not in ('PERSON', 'ORGANIZATION')
3280: then
3281: l_orig_sys_reference_rec.orig_system := l_party_rec.orig_system;

Line 3288: FND_API.G_FALSE,

3284: l_orig_sys_reference_rec.owner_table_id := l_party_rec.party_id;
3285: l_orig_sys_reference_rec.created_by_module := l_created_by_module;
3286:
3287: hz_orig_system_ref_pub.create_orig_system_reference(
3288: FND_API.G_FALSE,
3289: l_orig_sys_reference_rec,
3290: l_return_status,
3291: l_msg_count,
3292: l_msg_data);

Line 3293: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3289: l_orig_sys_reference_rec,
3290: l_return_status,
3291: l_msg_count,
3292: l_msg_data);
3293: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3294: RAISE FND_API.G_EXC_ERROR;
3295: END IF;
3296: end if;
3297:

Line 3294: RAISE FND_API.G_EXC_ERROR;

3290: l_return_status,
3291: l_msg_count,
3292: l_msg_data);
3293: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3294: RAISE FND_API.G_EXC_ERROR;
3295: END IF;
3296: end if;
3297:
3298: x_party_id := l_party_rec.party_id;

Line 3352: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3348: X_RETURN_STATUS => l_return_status,
3349: P_REGISTRATION_TYPE_CODE => null,--4742586
3350: P_COUNTRY_CODE => null--4742586
3351: );
3352: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: END IF;
3355: END IF;
3356:

Line 3353: RAISE FND_API.G_EXC_ERROR;

3349: P_REGISTRATION_TYPE_CODE => null,--4742586
3350: P_COUNTRY_CODE => null--4742586
3351: );
3352: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3353: RAISE FND_API.G_EXC_ERROR;
3354: END IF;
3355: END IF;
3356:
3357: ELSE -- p_create_update_flag = 'U'

Line 3371: and l_party_rec.orig_system <>fnd_api.g_miss_char)

3367: p_msg_level=>fnd_log.level_procedure);
3368: END IF;
3369:
3370: if (l_party_rec.orig_system is not null
3371: and l_party_rec.orig_system <>fnd_api.g_miss_char)
3372: and (l_party_rec.orig_system_reference is not null
3373: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
3374: then
3375: l_party_rec.orig_system_reference := null;

Line 3373: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)

3369:
3370: if (l_party_rec.orig_system is not null
3371: and l_party_rec.orig_system <>fnd_api.g_miss_char)
3372: and (l_party_rec.orig_system_reference is not null
3373: and l_party_rec.orig_system_reference <>fnd_api.g_miss_char)
3374: then
3375: l_party_rec.orig_system_reference := null;
3376: -- In mosr, we have bypassed osr nonupdateable validation
3377: -- but we should not update existing osr, set it to null

Line 3472: l_party_name <> FND_API.G_MISS_CHAR AND

3468: --Bug 1417600: Update party name for parties of type RELATIONSHIP
3469: --when subject or ojbect party's name has been changed.
3470:
3471: IF l_party_name IS NOT NULL AND
3472: l_party_name <> FND_API.G_MISS_CHAR AND
3473: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3474: THEN
3475: do_update_party_rel_name(l_party_rec.party_id, l_party_name);
3476: END IF;

Line 3473: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)

3469: --when subject or ojbect party's name has been changed.
3470:
3471: IF l_party_name IS NOT NULL AND
3472: l_party_name <> FND_API.G_MISS_CHAR AND
3473: l_party_name <> NVL(db_party_name, FND_API.G_MISS_CHAR)
3474: THEN
3475: do_update_party_rel_name(l_party_rec.party_id, l_party_name);
3476: END IF;
3477:

Line 3507: RAISE FND_API.G_EXC_ERROR;

3503: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3505: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3506: fnd_msg_pub.add;
3507: RAISE FND_API.G_EXC_ERROR;
3508: END;
3509:
3510: ZX_PARTY_TAX_PROFILE_PKG.update_row (
3511: P_PARTY_TAX_PROFILE_ID => L_PARTY_TAX_PROFILE_ID,

Line 3559: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3555: X_RETURN_STATUS => l_return_status,
3556: P_REGISTRATION_TYPE_CODE => null,--4742586
3557: P_COUNTRY_CODE => null--4742586
3558: );
3559: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3560: RAISE FND_API.G_EXC_ERROR;
3561: END IF;
3562: END IF;
3563: END IF;

Line 3560: RAISE FND_API.G_EXC_ERROR;

3556: P_REGISTRATION_TYPE_CODE => null,--4742586
3557: P_COUNTRY_CODE => null--4742586
3558: );
3559: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3560: RAISE FND_API.G_EXC_ERROR;
3561: END IF;
3562: END IF;
3563: END IF;
3564: END IF;

Line 3581: P_COMMIT => FND_API.G_FALSE,

3577: IF l_temp ='Y' THEN
3578: ICX_CAT_POPULATE_ITEM_GRP.populateVendorNameChanges
3579: (
3580: P_API_VERSION => 1.0,
3581: P_COMMIT => FND_API.G_FALSE,
3582: P_INIT_MSG_LIST => FND_API.G_FALSE,
3583: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
3584: X_RETURN_STATUS => l_return_status,
3585: P_VENDOR_ID => p_party_id ,

Line 3582: P_INIT_MSG_LIST => FND_API.G_FALSE,

3578: ICX_CAT_POPULATE_ITEM_GRP.populateVendorNameChanges
3579: (
3580: P_API_VERSION => 1.0,
3581: P_COMMIT => FND_API.G_FALSE,
3582: P_INIT_MSG_LIST => FND_API.G_FALSE,
3583: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
3584: X_RETURN_STATUS => l_return_status,
3585: P_VENDOR_ID => p_party_id ,
3586: P_VENDOR_NAME => p_organization_rec.organization_name

Line 3583: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

3579: (
3580: P_API_VERSION => 1.0,
3581: P_COMMIT => FND_API.G_FALSE,
3582: P_INIT_MSG_LIST => FND_API.G_FALSE,
3583: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
3584: X_RETURN_STATUS => l_return_status,
3585: P_VENDOR_ID => p_party_id ,
3586: P_VENDOR_NAME => p_organization_rec.organization_name
3587: ) ;

Line 3618: RAISE fnd_api.g_exc_error;

3614: WHEN g_resource_busy THEN
3615: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
3616: fnd_message.set_token('TABLE', 'hz_parties');
3617: fnd_msg_pub.add;
3618: RAISE fnd_api.g_exc_error;
3619:
3620: END do_create_update_party_only;
3621:
3622: /**

Line 3732: IF (p_person_rec.deceased_flag is NULL or p_person_rec.deceased_flag = fnd_api.g_miss_char) then

3728: p_def_actual_content_source => G_SST_SOURCE_TYPE,
3729: x_data_source_from => l_data_source_from );
3730:
3731: --2794173, Setting the default value for the deceased_flag
3732: IF (p_person_rec.deceased_flag is NULL or p_person_rec.deceased_flag = fnd_api.g_miss_char) then
3733: IF (p_person_rec.date_of_death is NULL or p_person_rec.date_of_death = fnd_api.g_miss_date) then
3734: p_person_rec.deceased_flag := 'N';
3735: ELSE
3736: p_person_rec.deceased_flag := 'Y';

Line 3733: IF (p_person_rec.date_of_death is NULL or p_person_rec.date_of_death = fnd_api.g_miss_date) then

3729: x_data_source_from => l_data_source_from );
3730:
3731: --2794173, Setting the default value for the deceased_flag
3732: IF (p_person_rec.deceased_flag is NULL or p_person_rec.deceased_flag = fnd_api.g_miss_char) then
3733: IF (p_person_rec.date_of_death is NULL or p_person_rec.date_of_death = fnd_api.g_miss_date) then
3734: p_person_rec.deceased_flag := 'N';
3735: ELSE
3736: p_person_rec.deceased_flag := 'Y';
3737: END IF;

Line 3762: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3758:
3759: HZ_registry_validate_v2pub.validate_person(
3760: 'C', p_person_rec, G_MISS_PERSON_REC, x_return_status);
3761:
3762: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3763: RAISE FND_API.G_EXC_ERROR;
3764: END IF;
3765:
3766: l_mixnmatch_enabled := g_per_mixnmatch_enabled;

Line 3763: RAISE FND_API.G_EXC_ERROR;

3759: HZ_registry_validate_v2pub.validate_person(
3760: 'C', p_person_rec, G_MISS_PERSON_REC, x_return_status);
3761:
3762: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3763: RAISE FND_API.G_EXC_ERROR;
3764: END IF;
3765:
3766: l_mixnmatch_enabled := g_per_mixnmatch_enabled;
3767: l_selected_datasources := g_per_selected_datasources;

Line 3789: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3785:
3786: HZ_registry_validate_v2pub.validate_organization(
3787: 'C', p_organization_rec, G_MISS_ORGANIZATION_REC, x_return_status);
3788:
3789: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: END IF;
3792:
3793:

Line 3790: RAISE FND_API.G_EXC_ERROR;

3786: HZ_registry_validate_v2pub.validate_organization(
3787: 'C', p_organization_rec, G_MISS_ORGANIZATION_REC, x_return_status);
3788:
3789: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: END IF;
3792:
3793:
3794: -- Bug 3317806 For non user entered data ( actual_content_source <> 'USER_ENTERED' ) ,

Line 3816: p_group_rec.party_rec.party_id <> FND_API.G_MISS_NUM AND

3812: l_selected_datasources := g_org_selected_datasources;
3813:
3814: ELSIF p_party_type = 'GROUP' THEN
3815: IF p_group_rec.party_rec.party_id IS NOT NULL AND
3816: p_group_rec.party_rec.party_id <> FND_API.G_MISS_NUM AND
3817: party_exists(p_party_type, p_group_rec.party_rec.party_id, l_party_number) = 'Y'
3818: THEN
3819: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3820: fnd_message.set_token('COLUMN', 'party_id');

Line 3822: RAISE FND_API.G_EXC_ERROR;

3818: THEN
3819: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3820: fnd_message.set_token('COLUMN', 'party_id');
3821: fnd_msg_pub.add;
3822: RAISE FND_API.G_EXC_ERROR;
3823: END IF;
3824:
3825: -- Validate group record.
3826:

Line 3830: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3826:
3827: HZ_registry_validate_v2pub.validate_group(
3828: 'C', p_group_rec, G_MISS_GROUP_REC, x_return_status);
3829:
3830: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3831: RAISE FND_API.G_EXC_ERROR;
3832: END IF;
3833:
3834: -- Create group party.

Line 3831: RAISE FND_API.G_EXC_ERROR;

3827: HZ_registry_validate_v2pub.validate_group(
3828: 'C', p_group_rec, G_MISS_GROUP_REC, x_return_status);
3829:
3830: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3831: RAISE FND_API.G_EXC_ERROR;
3832: END IF;
3833:
3834: -- Create group party.
3835:

Line 3869: l_party_id <> FND_API.G_MISS_NUM AND

3865: THEN
3866: l_data_source_type := G_SST_SOURCE_TYPE;
3867:
3868: IF l_party_id IS NOT NULL AND
3869: l_party_id <> FND_API.G_MISS_NUM AND
3870: party_exists(p_party_type, l_party_id, l_party_number) = 'Y'
3871: THEN
3872: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3873: fnd_message.set_token('COLUMN', 'party_id');

Line 3875: RAISE FND_API.G_EXC_ERROR;

3871: THEN
3872: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3873: fnd_message.set_token('COLUMN', 'party_id');
3874: fnd_msg_pub.add;
3875: RAISE FND_API.G_EXC_ERROR;
3876: END IF;
3877:
3878: -- party does not exist, create new party.
3879:

Line 3939: l_party_id <> FND_API.G_MISS_NUM AND

3935:
3936: -- Error out NOCOPY if the profile with this data source already exists.
3937:
3938: IF l_party_id IS NOT NULL AND
3939: l_party_id <> FND_API.G_MISS_NUM AND
3940: party_exists(p_party_type, l_party_id, l_party_number) = 'Y'
3941: THEN
3942: IF party_profile_exists(
3943: p_party_type, l_party_id, l_data_source_type) = 'Y'

Line 3948: RAISE FND_API.G_EXC_ERROR;

3944: THEN
3945: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3946: fnd_message.set_token('COLUMN', 'party_id,'||l_data_source_from);
3947: fnd_msg_pub.add;
3948: RAISE FND_API.G_EXC_ERROR;
3949: ELSE
3950: x_party_id := l_party_id;
3951: x_party_number := l_party_number;
3952: END IF;

Line 4109: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4105: p_new_sst_organization_rec => l_new_sst_organization_rec,
4106: p_data_source_type => l_data_source_type,
4107: x_return_status => x_return_status );
4108:
4109: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4110: RAISE FND_API.G_EXC_ERROR;
4111: END IF;
4112: END IF;
4113: l_party_create_update_flag := 'U';

Line 4110: RAISE FND_API.G_EXC_ERROR;

4106: p_data_source_type => l_data_source_type,
4107: x_return_status => x_return_status );
4108:
4109: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4110: RAISE FND_API.G_EXC_ERROR;
4111: END IF;
4112: END IF;
4113: l_party_create_update_flag := 'U';
4114: -- Create SST profile.

Line 4230: p_organization_rec.party_rec.orig_system=FND_API.G_MISS_CHAR ) THEN

4226: -- DQM
4227: --Bug 4866187
4228: --Bug 5370799
4229: IF (p_organization_rec.party_rec.orig_system IS NULL OR
4230: p_organization_rec.party_rec.orig_system=FND_API.G_MISS_CHAR ) THEN
4231: HZ_DQM_SYNC.sync_org(x_party_id, l_party_create_update_flag);
4232: END IF;
4233: ELSIF p_party_type = 'PERSON' THEN
4234:

Line 4267: IF (p_person_rec.party_rec.orig_system IS NULL OR p_person_rec.party_rec.orig_system=FND_API.G_MISS_CHAR ) THEN

4263:
4264: -- DQM
4265: --Bug 4866187
4266: --Bug 5370799
4267: IF (p_person_rec.party_rec.orig_system IS NULL OR p_person_rec.party_rec.orig_system=FND_API.G_MISS_CHAR ) THEN
4268: HZ_DQM_SYNC.sync_person(x_party_id, l_party_create_update_flag);
4269: END IF;
4270:
4271: END IF;

Line 4327: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4323: x_msg_data => l_msg_data
4324: );
4325:
4326:
4327: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4328: RAISE FND_API.G_EXC_ERROR;
4329: END IF;
4330: END IF;
4331: END IF;

Line 4328: RAISE FND_API.G_EXC_ERROR;

4324: );
4325:
4326:
4327: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4328: RAISE FND_API.G_EXC_ERROR;
4329: END IF;
4330: END IF;
4331: END IF;
4332:

Line 4426: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4422: l_new_party_name HZ_PARTIES.PARTY_NAME%TYPE;
4423: l_old_tax_reference HZ_PARTIES.TAX_REFERENCE%TYPE;
4424: l_new_tax_reference HZ_PARTIES.TAX_REFERENCE%TYPE;
4425: -------------Bug 4586451
4426: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4427: -------------------------Bug No. 4586451
4428:
4429: CURSOR c_party_name(p_party_id NUMBER) IS
4430: SELECT party_name,tax_reference FROM HZ_PARTIES

Line 4461: IF p_person_rec.date_of_death= FND_API.G_MISS_DATE then

4457: CLOSE c_party_name;
4458: ------End Bug No:2771835-----------
4459: -- 2794173, Setting the default value for the deceased_flag
4460: IF (p_person_rec.deceased_flag is NULL and p_person_rec.date_of_death is not NULL) then
4461: IF p_person_rec.date_of_death= FND_API.G_MISS_DATE then
4462: p_person_rec.deceased_flag := 'N';
4463:
4464: ELSE
4465: p_person_rec.deceased_flag := 'Y';

Line 4469: IF (p_person_rec.deceased_flag = fnd_api.g_miss_char) then

4465: p_person_rec.deceased_flag := 'Y';
4466: END IF;
4467: END IF;
4468:
4469: IF (p_person_rec.deceased_flag = fnd_api.g_miss_char) then
4470: p_person_rec.deceased_flag := 'N';
4471: END IF;
4472:
4473: IF (p_person_rec.deceased_flag = 'N' and p_person_rec.date_of_death is null) then

Line 4474: p_person_rec.date_of_death := fnd_api.g_miss_date;

4470: p_person_rec.deceased_flag := 'N';
4471: END IF;
4472:
4473: IF (p_person_rec.deceased_flag = 'N' and p_person_rec.date_of_death is null) then
4474: p_person_rec.date_of_death := fnd_api.g_miss_date;
4475: end if;
4476:
4477:
4478: --Bug Number 3099624.

Line 4503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4499:
4500: HZ_registry_validate_v2pub.validate_person(
4501: 'U', p_person_rec, p_old_person_rec, x_return_status);
4502:
4503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4504: RAISE FND_API.G_EXC_ERROR;
4505: END IF;
4506:
4507: l_mixnmatch_enabled := g_per_mixnmatch_enabled;

Line 4504: RAISE FND_API.G_EXC_ERROR;

4500: HZ_registry_validate_v2pub.validate_person(
4501: 'U', p_person_rec, p_old_person_rec, x_return_status);
4502:
4503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4504: RAISE FND_API.G_EXC_ERROR;
4505: END IF;
4506:
4507: l_mixnmatch_enabled := g_per_mixnmatch_enabled;
4508: l_selected_datasources := g_per_selected_datasources;

Line 4526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4522:
4523: HZ_registry_validate_v2pub.validate_organization(
4524: 'U', p_organization_rec, p_old_organization_rec, x_return_status);
4525:
4526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4527: RAISE FND_API.G_EXC_ERROR;
4528: END IF;
4529:
4530: -- Bug 3317806 For non user entered data ( actual_content_source <> 'USER_ENTERED' ) ,

Line 4527: RAISE FND_API.G_EXC_ERROR;

4523: HZ_registry_validate_v2pub.validate_organization(
4524: 'U', p_organization_rec, p_old_organization_rec, x_return_status);
4525:
4526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4527: RAISE FND_API.G_EXC_ERROR;
4528: END IF;
4529:
4530: -- Bug 3317806 For non user entered data ( actual_content_source <> 'USER_ENTERED' ) ,
4531: -- if local_activity_code_type = 'NACE' and the local_activity_code is invalid with

Line 4536: AND p_organization_rec.local_activity_code <> fnd_api.g_miss_char

4532: -- respect to the position of the decimal point, then replace this with the valid value.
4533: IF NVL(p_organization_rec.actual_content_source,p_old_organization_rec.actual_content_source) <> 'USER_ENTERED' AND
4534: NVL(p_organization_rec.local_activity_code_type, p_old_organization_rec.local_activity_code) in ( 'NACE' ,'4', '5') AND
4535: p_organization_rec.local_activity_code IS NOT NULL
4536: AND p_organization_rec.local_activity_code <> fnd_api.g_miss_char
4537: THEN
4538: SELECT lookup_code
4539: INTO p_organization_rec.local_activity_code
4540: FROM FND_LOOKUP_VALUES

Line 4564: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4560:
4561: HZ_registry_validate_v2pub.validate_group(
4562: 'U', p_group_rec, p_old_group_rec, x_return_status);
4563:
4564: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4565: RAISE FND_API.G_EXC_ERROR;
4566: END IF;
4567:
4568: -- update group party.

Line 4565: RAISE FND_API.G_EXC_ERROR;

4561: HZ_registry_validate_v2pub.validate_group(
4562: 'U', p_group_rec, p_old_group_rec, x_return_status);
4563:
4564: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4565: RAISE FND_API.G_EXC_ERROR;
4566: END IF;
4567:
4568: -- update group party.
4569:

Line 4699: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4695: p_new_sst_organization_rec => l_new_sst_organization_rec,
4696: p_data_source_type => l_data_source_type,
4697: x_return_status => x_return_status );
4698:
4699: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4700: RAISE FND_API.G_EXC_ERROR;
4701: END IF;
4702:
4703: l_new_sst_person_rec.party_rec.party_id := l_party_id;

Line 4700: RAISE FND_API.G_EXC_ERROR;

4696: p_data_source_type => l_data_source_type,
4697: x_return_status => x_return_status );
4698:
4699: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4700: RAISE FND_API.G_EXC_ERROR;
4701: END IF;
4702:
4703: l_new_sst_person_rec.party_rec.party_id := l_party_id;
4704: l_new_sst_organization_rec.party_rec.party_id := l_party_id;

Line 4755: p_organization_rec.organization_name <>FND_API.G_MISS_CHAR AND

4751: p_msg_level=>fnd_log.level_statement);
4752: END IF;
4753: ---------------Bug 4586451
4754: IF p_party_type ='ORGANIZATION'AND
4755: p_organization_rec.organization_name <>FND_API.G_MISS_CHAR AND
4756: p_organization_rec.organization_name IS NOT NULL AND
4757: p_organization_rec.organization_name<>p_old_organization_rec.organization_name AND
4758: nvl(p_organization_rec.actual_content_source,p_old_organization_rec.actual_content_source) IN (G_SST_SOURCE_TYPE,G_MISS_CONTENT_SOURCE_TYPE) THEN
4759: validate_party_name (

Line 4765: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4761: p_party_name => p_organization_rec.organization_name,
4762: x_return_status => l_return_status);
4763: END IF;
4764:
4765: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4766: RAISE FND_API.G_EXC_ERROR;
4767: END IF;
4768:
4769: ----------------Bug4586451

Line 4766: RAISE FND_API.G_EXC_ERROR;

4762: x_return_status => l_return_status);
4763: END IF;
4764:
4765: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4766: RAISE FND_API.G_EXC_ERROR;
4767: END IF;
4768:
4769: ----------------Bug4586451
4770:

Line 4891: * FND_API.G_TRUE. Default is fnd_api.g_false.

4887: *
4888: * ARGUMENTS
4889: * IN:
4890: * p_init_msg_list Initialize message stack if it is set to
4891: * FND_API.G_TRUE. Default is fnd_api.g_false.
4892: * p_person_rec Person record.
4893: * p_party_usage_code Party Usage Code
4894: * IN/OUT:
4895: * OUT:

Line 4900: * be FND_API.G_RET_STS_SUCCESS (success),

4896: * x_party_id Party ID.
4897: * x_party_number Party number.
4898: * x_profile_id Person profile ID.
4899: * x_return_status Return status after the call. The status can
4900: * be FND_API.G_RET_STS_SUCCESS (success),
4901: * fnd_api.g_ret_sts_error (error),
4902: * fnd_api.g_ret_sts_unexp_error (unexpected error).
4903: * x_msg_count Number of messages in message stack.
4904: * x_msg_data Message text if x_msg_count is 1.

Line 4901: * fnd_api.g_ret_sts_error (error),

4897: * x_party_number Party number.
4898: * x_profile_id Person profile ID.
4899: * x_return_status Return status after the call. The status can
4900: * be FND_API.G_RET_STS_SUCCESS (success),
4901: * fnd_api.g_ret_sts_error (error),
4902: * fnd_api.g_ret_sts_unexp_error (unexpected error).
4903: * x_msg_count Number of messages in message stack.
4904: * x_msg_data Message text if x_msg_count is 1.
4905: *

Line 4902: * fnd_api.g_ret_sts_unexp_error (unexpected error).

4898: * x_profile_id Person profile ID.
4899: * x_return_status Return status after the call. The status can
4900: * be FND_API.G_RET_STS_SUCCESS (success),
4901: * fnd_api.g_ret_sts_error (error),
4902: * fnd_api.g_ret_sts_unexp_error (unexpected error).
4903: * x_msg_count Number of messages in message stack.
4904: * x_msg_data Message text if x_msg_count is 1.
4905: *
4906: * NOTES

Line 4915: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

4911: *
4912: */
4913:
4914: PROCEDURE create_person (
4915: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
4916: p_person_rec IN PERSON_REC_TYPE,
4917: p_party_usage_code IN VARCHAR2,
4918: x_party_id OUT NOCOPY NUMBER,
4919: x_party_number OUT NOCOPY VARCHAR2,

Line 4930: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4926: l_context VARCHAR2(30);
4927: l_api_name CONSTANT VARCHAR2(30) := 'create_person';
4928: l_person_rec PERSON_REC_TYPE := p_person_rec;
4929:
4930: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4931: dss_msg_count NUMBER := 0;
4932: dss_msg_data VARCHAR2(2000):= null;
4933: l_test_security VARCHAR2(1):= 'F';
4934: l_debug_prefix VARCHAR2(30) := '';

Line 4956: IF FND_API.to_Boolean(p_init_msg_list) THEN

4952: END IF;
4953:
4954:
4955: -- initialize message list if p_init_msg_list is set to TRUE.
4956: IF FND_API.to_Boolean(p_init_msg_list) THEN
4957: FND_MSG_PUB.initialize;
4958: END IF;
4959:
4960: -- initialize API return status to success.

Line 4961: x_return_status := FND_API.G_RET_STS_SUCCESS;

4957: FND_MSG_PUB.initialize;
4958: END IF;
4959:
4960: -- initialize API return status to success.
4961: x_return_status := FND_API.G_RET_STS_SUCCESS;
4962:
4963: -- enable policy function if it is disabled.
4964:
4965: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 5004: if dss_return_status <> fnd_api.g_ret_sts_success THEN

5000: x_return_status => dss_return_status,
5001: x_msg_count => dss_msg_count,
5002: x_msg_data => dss_msg_data);
5003:
5004: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: end if;
5007:
5008: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

Line 5005: RAISE FND_API.G_EXC_ERROR;

5001: x_msg_count => dss_msg_count,
5002: x_msg_data => dss_msg_data);
5003:
5004: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: end if;
5007:
5008: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5009: --

Line 5008: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

5004: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5005: RAISE FND_API.G_EXC_ERROR;
5006: end if;
5007:
5008: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5009: --
5010: -- Bug 3835601: replaced the dss message with a more user friendly message
5011: --
5012: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

Line 5016: RAISE FND_API.G_EXC_ERROR;

5012: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5013: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5014: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5015: FND_MSG_PUB.ADD;
5016: RAISE FND_API.G_EXC_ERROR;
5017: end if;
5018: END IF;
5019:
5020: -- enable policy function if it was enabled before calling

Line 5029: p_encoded => fnd_api.g_false,

5025: END IF;
5026:
5027: --Standard call to get message count and if count is 1, get message info.
5028: fnd_msg_pub.count_and_get(
5029: p_encoded => fnd_api.g_false,
5030: p_count => x_msg_count,
5031: p_data => x_msg_data);
5032:
5033: -- Debug info.

Line 5055: WHEN FND_API.G_EXC_ERROR THEN

5051: -- Check if API is called in debug mode. If yes, disable debug.
5052: --disable_debug;
5053:
5054: EXCEPTION
5055: WHEN FND_API.G_EXC_ERROR THEN
5056: ROLLBACK TO create_person;
5057:
5058: IF l_context = 'N' THEN
5059: hz_common_pub.enable_cont_source_security;

Line 5062: x_return_status := fnd_api.g_ret_sts_error;

5058: IF l_context = 'N' THEN
5059: hz_common_pub.enable_cont_source_security;
5060: END IF;
5061:
5062: x_return_status := fnd_api.g_ret_sts_error;
5063:
5064: fnd_msg_pub.count_and_get(
5065: p_encoded => fnd_api.g_false,
5066: p_count => x_msg_count,

Line 5065: p_encoded => fnd_api.g_false,

5061:
5062: x_return_status := fnd_api.g_ret_sts_error;
5063:
5064: fnd_msg_pub.count_and_get(
5065: p_encoded => fnd_api.g_false,
5066: p_count => x_msg_count,
5067: p_data => x_msg_data);
5068:
5069: -- Debug info.

Line 5091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5087:
5088: -- Check if API is called in debug mode. If yes, disable debug.
5089: --disable_debug;
5090:
5091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5092: ROLLBACK TO create_person;
5093:
5094: IF l_context = 'N' THEN
5095: hz_common_pub.enable_cont_source_security;

Line 5098: x_return_status := fnd_api.g_ret_sts_unexp_error;

5094: IF l_context = 'N' THEN
5095: hz_common_pub.enable_cont_source_security;
5096: END IF;
5097:
5098: x_return_status := fnd_api.g_ret_sts_unexp_error;
5099:
5100: fnd_msg_pub.count_and_get(
5101: p_encoded => fnd_api.g_false,
5102: p_count => x_msg_count,

Line 5101: p_encoded => fnd_api.g_false,

5097:
5098: x_return_status := fnd_api.g_ret_sts_unexp_error;
5099:
5100: fnd_msg_pub.count_and_get(
5101: p_encoded => fnd_api.g_false,
5102: p_count => x_msg_count,
5103: p_data => x_msg_data);
5104:
5105: -- Debug info.

Line 5134: x_return_status := fnd_api.g_ret_sts_unexp_error;

5130: IF l_context = 'N' THEN
5131: hz_common_pub.enable_cont_source_security;
5132: END IF;
5133:
5134: x_return_status := fnd_api.g_ret_sts_unexp_error;
5135:
5136: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5137: fnd_message.set_token('ERROR',SQLERRM);
5138: fnd_msg_pub.add;

Line 5141: p_encoded => fnd_api.g_false,

5137: fnd_message.set_token('ERROR',SQLERRM);
5138: fnd_msg_pub.add;
5139:
5140: fnd_msg_pub.count_and_get(
5141: p_encoded => fnd_api.g_false,
5142: p_count => x_msg_count,
5143: p_data => x_msg_data);
5144:
5145: -- Debug info.

Line 5182: * FND_API.G_TRUE. Default is fnd_api.g_false.

5178: *
5179: * ARGUMENTS
5180: * IN:
5181: * p_init_msg_list Initialize message stack if it is set to
5182: * FND_API.G_TRUE. Default is fnd_api.g_false.
5183: * p_person_rec Person record.
5184: * IN/OUT:
5185: * OUT:
5186: * x_party_id Party ID.

Line 5190: * be FND_API.G_RET_STS_SUCCESS (success),

5186: * x_party_id Party ID.
5187: * x_party_number Party number.
5188: * x_profile_id Person profile ID.
5189: * x_return_status Return status after the call. The status can
5190: * be FND_API.G_RET_STS_SUCCESS (success),
5191: * fnd_api.g_ret_sts_error (error),
5192: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5193: * x_msg_count Number of messages in message stack.
5194: * x_msg_data Message text if x_msg_count is 1.

Line 5191: * fnd_api.g_ret_sts_error (error),

5187: * x_party_number Party number.
5188: * x_profile_id Person profile ID.
5189: * x_return_status Return status after the call. The status can
5190: * be FND_API.G_RET_STS_SUCCESS (success),
5191: * fnd_api.g_ret_sts_error (error),
5192: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5193: * x_msg_count Number of messages in message stack.
5194: * x_msg_data Message text if x_msg_count is 1.
5195: *

Line 5192: * fnd_api.g_ret_sts_unexp_error (unexpected error).

5188: * x_profile_id Person profile ID.
5189: * x_return_status Return status after the call. The status can
5190: * be FND_API.G_RET_STS_SUCCESS (success),
5191: * fnd_api.g_ret_sts_error (error),
5192: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5193: * x_msg_count Number of messages in message stack.
5194: * x_msg_data Message text if x_msg_count is 1.
5195: *
5196: * NOTES

Line 5205: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5201: *
5202: */
5203:
5204: PROCEDURE create_person (
5205: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5206: p_person_rec IN PERSON_REC_TYPE,
5207: x_party_id OUT NOCOPY NUMBER,
5208: x_party_number OUT NOCOPY VARCHAR2,
5209: x_profile_id OUT NOCOPY NUMBER,

Line 5243: * FND_API.G_TRUE. Default is fnd_api.g_false.

5239: *
5240: * ARGUMENTS
5241: * IN:
5242: * p_init_msg_list Initialize message stack if it is set to
5243: * FND_API.G_TRUE. Default is fnd_api.g_false.
5244: * p_person_rec Person record.
5245: * IN/OUT:
5246: * p_party_object_version_number Used for locking the being updated record.
5247: * OUT:

Line 5250: * be FND_API.G_RET_STS_SUCCESS (success),

5246: * p_party_object_version_number Used for locking the being updated record.
5247: * OUT:
5248: * x_profile_id Person profile ID.
5249: * x_return_status Return status after the call. The status can
5250: * be FND_API.G_RET_STS_SUCCESS (success),
5251: * fnd_api.g_ret_sts_error (error),
5252: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5253: * x_msg_count Number of messages in message stack.
5254: * x_msg_data Message text if x_msg_count is 1.

Line 5251: * fnd_api.g_ret_sts_error (error),

5247: * OUT:
5248: * x_profile_id Person profile ID.
5249: * x_return_status Return status after the call. The status can
5250: * be FND_API.G_RET_STS_SUCCESS (success),
5251: * fnd_api.g_ret_sts_error (error),
5252: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5253: * x_msg_count Number of messages in message stack.
5254: * x_msg_data Message text if x_msg_count is 1.
5255: *

Line 5252: * fnd_api.g_ret_sts_unexp_error (unexpected error).

5248: * x_profile_id Person profile ID.
5249: * x_return_status Return status after the call. The status can
5250: * be FND_API.G_RET_STS_SUCCESS (success),
5251: * fnd_api.g_ret_sts_error (error),
5252: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5253: * x_msg_count Number of messages in message stack.
5254: * x_msg_data Message text if x_msg_count is 1.
5255: *
5256: * NOTES

Line 5267: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5263: *
5264: */
5265:
5266: PROCEDURE update_person (
5267: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5268: p_person_rec IN PERSON_REC_TYPE,
5269: p_party_object_version_number IN OUT NOCOPY NUMBER,
5270: x_profile_id OUT NOCOPY NUMBER,
5271: x_return_status OUT NOCOPY VARCHAR2,

Line 5282: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

5278: l_old_person_rec PERSON_REC_TYPE;
5279: l_data_source_from VARCHAR2(30);
5280: l_context VARCHAR2(30);
5281:
5282: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5283: dss_msg_count NUMBER := 0;
5284: dss_msg_data VARCHAR2(2000):= null;
5285: l_test_security VARCHAR2(1):= 'F';
5286: l_debug_prefix VARCHAR2(30) := '';

Line 5316: IF FND_API.to_Boolean(p_init_msg_list) THEN

5312: END IF;
5313: END IF;
5314:
5315: -- initialize message list if p_init_msg_list is set to TRUE.
5316: IF FND_API.to_Boolean(p_init_msg_list) THEN
5317: FND_MSG_PUB.initialize;
5318: END IF;
5319:
5320: -- initialize API return status to success.

Line 5321: x_return_status := FND_API.G_RET_STS_SUCCESS;

5317: FND_MSG_PUB.initialize;
5318: END IF;
5319:
5320: -- initialize API return status to success.
5321: x_return_status := FND_API.G_RET_STS_SUCCESS;
5322:
5323: -- enable policy function if it is disabled.
5324:
5325: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 5347: RAISE FND_API.G_EXC_ERROR;

5343: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5344: fnd_message.set_token('RECORD', 'person');
5345: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5346: fnd_msg_pub.add;
5347: RAISE FND_API.G_EXC_ERROR;
5348: END;
5349: **/
5350:
5351: IF (l_person_rec.party_rec.orig_system is not null

Line 5352: and l_person_rec.party_rec.orig_system <>fnd_api.g_miss_char)

5348: END;
5349: **/
5350:
5351: IF (l_person_rec.party_rec.orig_system is not null
5352: and l_person_rec.party_rec.orig_system <>fnd_api.g_miss_char)
5353: and (l_person_rec.party_rec.orig_system_reference is not null
5354: and l_person_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5355: and (l_person_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_person_rec.party_rec.party_id is null) THEN
5356:

Line 5354: and l_person_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)

5350:
5351: IF (l_person_rec.party_rec.orig_system is not null
5352: and l_person_rec.party_rec.orig_system <>fnd_api.g_miss_char)
5353: and (l_person_rec.party_rec.orig_system_reference is not null
5354: and l_person_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5355: and (l_person_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_person_rec.party_rec.party_id is null) THEN
5356:
5357: hz_orig_system_ref_pub.get_owner_table_id
5358: (p_orig_system => l_person_rec.party_rec.orig_system,

Line 5355: and (l_person_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_person_rec.party_rec.party_id is null) THEN

5351: IF (l_person_rec.party_rec.orig_system is not null
5352: and l_person_rec.party_rec.orig_system <>fnd_api.g_miss_char)
5353: and (l_person_rec.party_rec.orig_system_reference is not null
5354: and l_person_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5355: and (l_person_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_person_rec.party_rec.party_id is null) THEN
5356:
5357: hz_orig_system_ref_pub.get_owner_table_id
5358: (p_orig_system => l_person_rec.party_rec.orig_system,
5359: p_orig_system_reference => l_person_rec.party_rec.orig_system_reference,

Line 5364: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5360: p_owner_table_name => 'HZ_PARTIES',
5361: x_owner_table_id => l_person_rec.party_rec.party_id,
5362: x_return_status => x_return_status);
5363:
5364: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5365: RAISE FND_API.G_EXC_ERROR;
5366: END IF;
5367: END IF;
5368: -- cache if mix-n-match is enabled

Line 5365: RAISE FND_API.G_EXC_ERROR;

5361: x_owner_table_id => l_person_rec.party_rec.party_id,
5362: x_return_status => x_return_status);
5363:
5364: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5365: RAISE FND_API.G_EXC_ERROR;
5366: END IF;
5367: END IF;
5368: -- cache if mix-n-match is enabled
5369:

Line 5389: IF x_return_status = fnd_api.g_ret_sts_error THEN

5385: x_return_status => x_return_status,
5386: x_msg_count => x_msg_count,
5387: x_msg_data => x_msg_data);
5388:
5389: IF x_return_status = fnd_api.g_ret_sts_error THEN
5390: RAISE FND_API.G_EXC_ERROR;
5391: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5393: END IF;

Line 5390: RAISE FND_API.G_EXC_ERROR;

5386: x_msg_count => x_msg_count,
5387: x_msg_data => x_msg_data);
5388:
5389: IF x_return_status = fnd_api.g_ret_sts_error THEN
5390: RAISE FND_API.G_EXC_ERROR;
5391: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5393: END IF;
5394:

Line 5391: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5387: x_msg_data => x_msg_data);
5388:
5389: IF x_return_status = fnd_api.g_ret_sts_error THEN
5390: RAISE FND_API.G_EXC_ERROR;
5391: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5393: END IF;
5394:
5395: -- Bug 2486394 Check if the DSS security is granted to the user

Line 5392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5388:
5389: IF x_return_status = fnd_api.g_ret_sts_error THEN
5390: RAISE FND_API.G_EXC_ERROR;
5391: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5393: END IF;
5394:
5395: -- Bug 2486394 Check if the DSS security is granted to the user
5396: -- Bug 3818648: check dss profile before call test_instance.

Line 5409: if dss_return_status <> fnd_api.g_ret_sts_success THEN

5405: x_return_status => dss_return_status,
5406: x_msg_count => dss_msg_count,
5407: x_msg_data => dss_msg_data);
5408:
5409: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5410: RAISE FND_API.G_EXC_ERROR;
5411: end if;
5412:
5413: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

Line 5410: RAISE FND_API.G_EXC_ERROR;

5406: x_msg_count => dss_msg_count,
5407: x_msg_data => dss_msg_data);
5408:
5409: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5410: RAISE FND_API.G_EXC_ERROR;
5411: end if;
5412:
5413: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5414: --

Line 5413: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

5409: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5410: RAISE FND_API.G_EXC_ERROR;
5411: end if;
5412:
5413: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5414: --
5415: -- Bug 3835601: replaced the dss message with a more user friendly message
5416: --
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

Line 5421: RAISE FND_API.G_EXC_ERROR;

5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5418: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5419: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_ERROR;
5422: end if;
5423: END IF;
5424:
5425: -- call to business logic.

Line 5445: p_encoded => fnd_api.g_false,

5441: END IF;
5442:
5443: --Standard call to get message count and if count is 1, get message info.
5444: fnd_msg_pub.count_and_get(
5445: p_encoded => fnd_api.g_false,
5446: p_count => x_msg_count,
5447: p_data => x_msg_data);
5448:
5449: -- Debug info.

Line 5472: WHEN FND_API.G_EXC_ERROR THEN

5468: -- Check if API is called in debug mode. If yes, disable debug.
5469: --disable_debug;
5470:
5471: EXCEPTION
5472: WHEN FND_API.G_EXC_ERROR THEN
5473: ROLLBACK TO update_person;
5474:
5475: IF l_context = 'N' THEN
5476: hz_common_pub.enable_cont_source_security;

Line 5479: x_return_status := fnd_api.g_ret_sts_error;

5475: IF l_context = 'N' THEN
5476: hz_common_pub.enable_cont_source_security;
5477: END IF;
5478:
5479: x_return_status := fnd_api.g_ret_sts_error;
5480:
5481: fnd_msg_pub.count_and_get(
5482: p_encoded => fnd_api.g_false,
5483: p_count => x_msg_count,

Line 5482: p_encoded => fnd_api.g_false,

5478:
5479: x_return_status := fnd_api.g_ret_sts_error;
5480:
5481: fnd_msg_pub.count_and_get(
5482: p_encoded => fnd_api.g_false,
5483: p_count => x_msg_count,
5484: p_data => x_msg_data);
5485:
5486: -- Debug info.

Line 5509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5505:
5506: -- Check if API is called in debug mode. If yes, disable debug.
5507: --disable_debug;
5508:
5509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5510: ROLLBACK TO update_person;
5511:
5512: IF l_context = 'N' THEN
5513: hz_common_pub.enable_cont_source_security;

Line 5516: x_return_status := fnd_api.g_ret_sts_unexp_error;

5512: IF l_context = 'N' THEN
5513: hz_common_pub.enable_cont_source_security;
5514: END IF;
5515:
5516: x_return_status := fnd_api.g_ret_sts_unexp_error;
5517:
5518: fnd_msg_pub.count_and_get(
5519: p_encoded => fnd_api.g_false,
5520: p_count => x_msg_count,

Line 5519: p_encoded => fnd_api.g_false,

5515:
5516: x_return_status := fnd_api.g_ret_sts_unexp_error;
5517:
5518: fnd_msg_pub.count_and_get(
5519: p_encoded => fnd_api.g_false,
5520: p_count => x_msg_count,
5521: p_data => x_msg_data);
5522:
5523: -- Debug info.

Line 5551: x_return_status := fnd_api.g_ret_sts_unexp_error;

5547: IF l_context = 'N' THEN
5548: hz_common_pub.enable_cont_source_security;
5549: END IF;
5550:
5551: x_return_status := fnd_api.g_ret_sts_unexp_error;
5552:
5553: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5554: fnd_message.set_token('ERROR',SQLERRM);
5555: fnd_msg_pub.add;

Line 5558: p_encoded => fnd_api.g_false,

5554: fnd_message.set_token('ERROR',SQLERRM);
5555: fnd_msg_pub.add;
5556:
5557: fnd_msg_pub.count_and_get(
5558: p_encoded => fnd_api.g_false,
5559: p_count => x_msg_count,
5560: p_data => x_msg_data);
5561:
5562: -- Debug info.

Line 5598: * FND_API.G_TRUE. Default is fnd_api.g_false.

5594: *
5595: * ARGUMENTS
5596: * IN:
5597: * p_init_msg_list Initialize message stack if it is set to
5598: * FND_API.G_TRUE. Default is fnd_api.g_false.
5599: * p_group_rec Group record.
5600: * IN/OUT:
5601: * OUT:
5602: * x_party_id Party ID.

Line 5605: * be FND_API.G_RET_STS_SUCCESS (success),

5601: * OUT:
5602: * x_party_id Party ID.
5603: * x_party_number Party number.
5604: * x_return_status Return status after the call. The status can
5605: * be FND_API.G_RET_STS_SUCCESS (success),
5606: * fnd_api.g_ret_sts_error (error),
5607: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5608: * x_msg_count Number of messages in message stack.
5609: * x_msg_data Message text if x_msg_count is 1.

Line 5606: * fnd_api.g_ret_sts_error (error),

5602: * x_party_id Party ID.
5603: * x_party_number Party number.
5604: * x_return_status Return status after the call. The status can
5605: * be FND_API.G_RET_STS_SUCCESS (success),
5606: * fnd_api.g_ret_sts_error (error),
5607: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5608: * x_msg_count Number of messages in message stack.
5609: * x_msg_data Message text if x_msg_count is 1.
5610: *

Line 5607: * fnd_api.g_ret_sts_unexp_error (unexpected error).

5603: * x_party_number Party number.
5604: * x_return_status Return status after the call. The status can
5605: * be FND_API.G_RET_STS_SUCCESS (success),
5606: * fnd_api.g_ret_sts_error (error),
5607: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5608: * x_msg_count Number of messages in message stack.
5609: * x_msg_data Message text if x_msg_count is 1.
5610: *
5611: * NOTES

Line 5619: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5615: * 07-23-2001 Indrajit Sen o Created.
5616: *
5617: */
5618: PROCEDURE create_group (
5619: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5620: p_group_rec IN GROUP_REC_TYPE,
5621: x_party_id OUT NOCOPY NUMBER,
5622: x_party_number OUT NOCOPY VARCHAR2,
5623: x_return_status OUT NOCOPY VARCHAR2,

Line 5633: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

5629: l_api_name CONSTANT VARCHAR2(30) := 'create_group';
5630: l_profile_id NUMBER;
5631: l_group_rec GROUP_REC_TYPE := p_group_rec;
5632:
5633: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5634: dss_msg_count NUMBER := 0;
5635: dss_msg_data VARCHAR2(2000):= null;
5636: l_test_security VARCHAR2(1):= 'F';
5637: l_debug_prefix VARCHAR2(30) := '';

Line 5657: IF FND_API.to_Boolean(p_init_msg_list) THEN

5653: p_msg_level=>fnd_log.level_procedure);
5654: END IF;
5655:
5656: -- initialize message list if p_init_msg_list is set to TRUE.
5657: IF FND_API.to_Boolean(p_init_msg_list) THEN
5658: FND_MSG_PUB.initialize;
5659: END IF;
5660:
5661: -- initialize API return status to success.

Line 5662: x_return_status := FND_API.G_RET_STS_SUCCESS;

5658: FND_MSG_PUB.initialize;
5659: END IF;
5660:
5661: -- initialize API return status to success.
5662: x_return_status := FND_API.G_RET_STS_SUCCESS;
5663:
5664: -- enable policy function if it is disabled.
5665:
5666: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 5697: if dss_return_status <> fnd_api.g_ret_sts_success THEN

5693: x_return_status => dss_return_status,
5694: x_msg_count => dss_msg_count,
5695: x_msg_data => dss_msg_data);
5696:
5697: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5698: RAISE FND_API.G_EXC_ERROR;
5699: end if;
5700:
5701: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

Line 5698: RAISE FND_API.G_EXC_ERROR;

5694: x_msg_count => dss_msg_count,
5695: x_msg_data => dss_msg_data);
5696:
5697: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5698: RAISE FND_API.G_EXC_ERROR;
5699: end if;
5700:
5701: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5702: --

Line 5701: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

5697: if dss_return_status <> fnd_api.g_ret_sts_success THEN
5698: RAISE FND_API.G_EXC_ERROR;
5699: end if;
5700:
5701: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5702: --
5703: -- Bug 3835601: replaced the dss message with a more user friendly message
5704: --
5705: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

Line 5709: RAISE FND_API.G_EXC_ERROR;

5705: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5706: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5707: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5708: FND_MSG_PUB.ADD;
5709: RAISE FND_API.G_EXC_ERROR;
5710: end if;
5711: END IF;
5712:
5713: -- Invoke business event system.

Line 5727: p_encoded => fnd_api.g_false,

5723: END IF;
5724:
5725: --Standard call to get message count and if count is 1, get message info.
5726: fnd_msg_pub.count_and_get(
5727: p_encoded => fnd_api.g_false,
5728: p_count => x_msg_count,
5729: p_data => x_msg_data);
5730:
5731: -- Debug info.

Line 5754: WHEN FND_API.G_EXC_ERROR THEN

5750: -- Check if API is called in debug mode. If yes, disable debug.
5751: --disable_debug;
5752:
5753: EXCEPTION
5754: WHEN FND_API.G_EXC_ERROR THEN
5755: ROLLBACK TO create_group;
5756:
5757: IF l_context = 'N' THEN
5758: hz_common_pub.enable_cont_source_security;

Line 5761: x_return_status := fnd_api.g_ret_sts_error;

5757: IF l_context = 'N' THEN
5758: hz_common_pub.enable_cont_source_security;
5759: END IF;
5760:
5761: x_return_status := fnd_api.g_ret_sts_error;
5762:
5763: fnd_msg_pub.count_and_get(
5764: p_encoded => fnd_api.g_false,
5765: p_count => x_msg_count,

Line 5764: p_encoded => fnd_api.g_false,

5760:
5761: x_return_status := fnd_api.g_ret_sts_error;
5762:
5763: fnd_msg_pub.count_and_get(
5764: p_encoded => fnd_api.g_false,
5765: p_count => x_msg_count,
5766: p_data => x_msg_data);
5767:
5768: -- Debug info.

Line 5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5786:
5787: -- Check if API is called in debug mode. If yes, disable debug.
5788: --disable_debug;
5789:
5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: ROLLBACK TO create_group;
5792:
5793: IF l_context = 'N' THEN
5794: hz_common_pub.enable_cont_source_security;

Line 5797: x_return_status := fnd_api.g_ret_sts_unexp_error;

5793: IF l_context = 'N' THEN
5794: hz_common_pub.enable_cont_source_security;
5795: END IF;
5796:
5797: x_return_status := fnd_api.g_ret_sts_unexp_error;
5798:
5799: fnd_msg_pub.count_and_get(
5800: p_encoded => fnd_api.g_false,
5801: p_count => x_msg_count,

Line 5800: p_encoded => fnd_api.g_false,

5796:
5797: x_return_status := fnd_api.g_ret_sts_unexp_error;
5798:
5799: fnd_msg_pub.count_and_get(
5800: p_encoded => fnd_api.g_false,
5801: p_count => x_msg_count,
5802: p_data => x_msg_data);
5803:
5804: -- Debug info.

Line 5833: x_return_status := fnd_api.g_ret_sts_unexp_error;

5829: IF l_context = 'N' THEN
5830: hz_common_pub.enable_cont_source_security;
5831: END IF;
5832:
5833: x_return_status := fnd_api.g_ret_sts_unexp_error;
5834:
5835: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5836: fnd_message.set_token('ERROR',SQLERRM);
5837: fnd_msg_pub.add;

Line 5840: p_encoded => fnd_api.g_false,

5836: fnd_message.set_token('ERROR',SQLERRM);
5837: fnd_msg_pub.add;
5838:
5839: fnd_msg_pub.count_and_get(
5840: p_encoded => fnd_api.g_false,
5841: p_count => x_msg_count,
5842: p_data => x_msg_data);
5843:
5844: -- Debug info.

Line 5880: * FND_API.G_TRUE. Default is fnd_api.g_false.

5876: *
5877: * ARGUMENTS
5878: * IN:
5879: * p_init_msg_list Initialize message stack if it is set to
5880: * FND_API.G_TRUE. Default is fnd_api.g_false.
5881: * p_group_rec Group record.
5882: * IN/OUT:
5883: * p_party_object_version_number Used for locking the being updated record.
5884: * OUT:

Line 5886: * be FND_API.G_RET_STS_SUCCESS (success),

5882: * IN/OUT:
5883: * p_party_object_version_number Used for locking the being updated record.
5884: * OUT:
5885: * x_return_status Return status after the call. The status can
5886: * be FND_API.G_RET_STS_SUCCESS (success),
5887: * fnd_api.g_ret_sts_error (error),
5888: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5889: * x_msg_count Number of messages in message stack.
5890: * x_msg_data Message text if x_msg_count is 1.

Line 5887: * fnd_api.g_ret_sts_error (error),

5883: * p_party_object_version_number Used for locking the being updated record.
5884: * OUT:
5885: * x_return_status Return status after the call. The status can
5886: * be FND_API.G_RET_STS_SUCCESS (success),
5887: * fnd_api.g_ret_sts_error (error),
5888: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5889: * x_msg_count Number of messages in message stack.
5890: * x_msg_data Message text if x_msg_count is 1.
5891: *

Line 5888: * fnd_api.g_ret_sts_unexp_error (unexpected error).

5884: * OUT:
5885: * x_return_status Return status after the call. The status can
5886: * be FND_API.G_RET_STS_SUCCESS (success),
5887: * fnd_api.g_ret_sts_error (error),
5888: * fnd_api.g_ret_sts_unexp_error (unexpected error).
5889: * x_msg_count Number of messages in message stack.
5890: * x_msg_data Message text if x_msg_count is 1.
5891: *
5892: * NOTES

Line 5901: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5897: *
5898: */
5899:
5900: PROCEDURE update_group (
5901: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5902: p_group_rec IN GROUP_REC_TYPE,
5903: p_party_object_version_number IN OUT NOCOPY NUMBER,
5904: x_return_status OUT NOCOPY VARCHAR2,
5905: x_msg_count OUT NOCOPY NUMBER,

Line 5915: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

5911: l_profile_id NUMBER;
5912: l_group_rec GROUP_REC_TYPE := p_group_rec;
5913: l_old_group_rec GROUP_REC_TYPE := p_group_rec;
5914:
5915: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5916: dss_msg_count NUMBER := 0;
5917: dss_msg_data VARCHAR2(2000):= null;
5918: l_test_security VARCHAR2(1):= 'F';
5919: l_debug_prefix VARCHAR2(30) := '';

Line 5941: IF FND_API.to_Boolean(p_init_msg_list) THEN

5937: END IF;
5938:
5939:
5940: -- initialize message list if p_init_msg_list is set to TRUE.
5941: IF FND_API.to_Boolean(p_init_msg_list) THEN
5942: FND_MSG_PUB.initialize;
5943: END IF;
5944:
5945: -- initialize API return status to success.

Line 5946: x_return_status := FND_API.G_RET_STS_SUCCESS;

5942: FND_MSG_PUB.initialize;
5943: END IF;
5944:
5945: -- initialize API return status to success.
5946: x_return_status := FND_API.G_RET_STS_SUCCESS;
5947:
5948: -- enable policy function if it is disabled.
5949:
5950: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 5971: RAISE FND_API.G_EXC_ERROR;

5967: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5968: fnd_message.set_token('RECORD', 'group');
5969: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5970: fnd_msg_pub.add;
5971: RAISE FND_API.G_EXC_ERROR;
5972: END;
5973: **/
5974:
5975: IF (l_group_rec.party_rec.orig_system is not null

Line 5976: and l_group_rec.party_rec.orig_system <>fnd_api.g_miss_char)

5972: END;
5973: **/
5974:
5975: IF (l_group_rec.party_rec.orig_system is not null
5976: and l_group_rec.party_rec.orig_system <>fnd_api.g_miss_char)
5977: and (l_group_rec.party_rec.orig_system_reference is not null
5978: and l_group_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5979: and (l_group_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_group_rec.party_rec.party_id is null) THEN
5980:

Line 5978: and l_group_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)

5974:
5975: IF (l_group_rec.party_rec.orig_system is not null
5976: and l_group_rec.party_rec.orig_system <>fnd_api.g_miss_char)
5977: and (l_group_rec.party_rec.orig_system_reference is not null
5978: and l_group_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5979: and (l_group_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_group_rec.party_rec.party_id is null) THEN
5980:
5981: hz_orig_system_ref_pub.get_owner_table_id
5982: (p_orig_system => l_group_rec.party_rec.orig_system,

Line 5979: and (l_group_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_group_rec.party_rec.party_id is null) THEN

5975: IF (l_group_rec.party_rec.orig_system is not null
5976: and l_group_rec.party_rec.orig_system <>fnd_api.g_miss_char)
5977: and (l_group_rec.party_rec.orig_system_reference is not null
5978: and l_group_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
5979: and (l_group_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_group_rec.party_rec.party_id is null) THEN
5980:
5981: hz_orig_system_ref_pub.get_owner_table_id
5982: (p_orig_system => l_group_rec.party_rec.orig_system,
5983: p_orig_system_reference => l_group_rec.party_rec.orig_system_reference,

Line 5988: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5984: p_owner_table_name => 'HZ_PARTIES',
5985: x_owner_table_id => l_group_rec.party_rec.party_id,
5986: x_return_status => x_return_status);
5987:
5988: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5989: RAISE FND_API.G_EXC_ERROR;
5990: END IF;
5991: END IF;
5992:

Line 5989: RAISE FND_API.G_EXC_ERROR;

5985: x_owner_table_id => l_group_rec.party_rec.party_id,
5986: x_return_status => x_return_status);
5987:
5988: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5989: RAISE FND_API.G_EXC_ERROR;
5990: END IF;
5991: END IF;
5992:
5993: -- Get old records. Will be used by validation.

Line 6001: IF x_return_status = fnd_api.g_ret_sts_error THEN

5997: x_return_status => x_return_status,
5998: x_msg_count => x_msg_count,
5999: x_msg_data => x_msg_data);
6000:
6001: IF x_return_status = fnd_api.g_ret_sts_error THEN
6002: RAISE fnd_api.g_exc_error;
6003: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6004: RAISE fnd_api.g_exc_unexpected_error;
6005: END IF;

Line 6002: RAISE fnd_api.g_exc_error;

5998: x_msg_count => x_msg_count,
5999: x_msg_data => x_msg_data);
6000:
6001: IF x_return_status = fnd_api.g_ret_sts_error THEN
6002: RAISE fnd_api.g_exc_error;
6003: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6004: RAISE fnd_api.g_exc_unexpected_error;
6005: END IF;
6006:

Line 6003: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5999: x_msg_data => x_msg_data);
6000:
6001: IF x_return_status = fnd_api.g_ret_sts_error THEN
6002: RAISE fnd_api.g_exc_error;
6003: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6004: RAISE fnd_api.g_exc_unexpected_error;
6005: END IF;
6006:
6007: -- Bug 2486394 Check if the DSS security is granted to the user

Line 6004: RAISE fnd_api.g_exc_unexpected_error;

6000:
6001: IF x_return_status = fnd_api.g_ret_sts_error THEN
6002: RAISE fnd_api.g_exc_error;
6003: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6004: RAISE fnd_api.g_exc_unexpected_error;
6005: END IF;
6006:
6007: -- Bug 2486394 Check if the DSS security is granted to the user
6008: -- Bug 3818648: check dss profile before call test_instance.

Line 6021: if dss_return_status <> fnd_api.g_ret_sts_success THEN

6017: x_return_status => dss_return_status,
6018: x_msg_count => dss_msg_count,
6019: x_msg_data => dss_msg_data);
6020:
6021: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6022: RAISE FND_API.G_EXC_ERROR;
6023: end if;
6024:
6025: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

Line 6022: RAISE FND_API.G_EXC_ERROR;

6018: x_msg_count => dss_msg_count,
6019: x_msg_data => dss_msg_data);
6020:
6021: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6022: RAISE FND_API.G_EXC_ERROR;
6023: end if;
6024:
6025: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6026: --

Line 6025: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

6021: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6022: RAISE FND_API.G_EXC_ERROR;
6023: end if;
6024:
6025: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6026: --
6027: -- Bug 3835601: replaced the dss message with a more user friendly message
6028: --
6029: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

Line 6033: RAISE FND_API.G_EXC_ERROR;

6029: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6030: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6031: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
6032: FND_MSG_PUB.ADD;
6033: RAISE FND_API.G_EXC_ERROR;
6034: end if;
6035: END IF;
6036:
6037: -- call to business logic.

Line 6062: p_encoded => fnd_api.g_false,

6058: END IF;
6059:
6060: --Standard call to get message count and if count is 1, get message info.
6061: fnd_msg_pub.count_and_get(
6062: p_encoded => fnd_api.g_false,
6063: p_count => x_msg_count,
6064: p_data => x_msg_data);
6065:
6066: -- Debug info.

Line 6088: WHEN FND_API.G_EXC_ERROR THEN

6084: -- Check if API is called in debug mode. If yes, disable debug.
6085: --disable_debug;
6086:
6087: EXCEPTION
6088: WHEN FND_API.G_EXC_ERROR THEN
6089: ROLLBACK TO update_group;
6090:
6091: IF l_context = 'N' THEN
6092: hz_common_pub.enable_cont_source_security;

Line 6095: x_return_status := fnd_api.g_ret_sts_error;

6091: IF l_context = 'N' THEN
6092: hz_common_pub.enable_cont_source_security;
6093: END IF;
6094:
6095: x_return_status := fnd_api.g_ret_sts_error;
6096:
6097: fnd_msg_pub.count_and_get(
6098: p_encoded => fnd_api.g_false,
6099: p_count => x_msg_count,

Line 6098: p_encoded => fnd_api.g_false,

6094:
6095: x_return_status := fnd_api.g_ret_sts_error;
6096:
6097: fnd_msg_pub.count_and_get(
6098: p_encoded => fnd_api.g_false,
6099: p_count => x_msg_count,
6100: p_data => x_msg_data);
6101:
6102: -- Debug info.

Line 6124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6120:
6121: -- Check if API is called in debug mode. If yes, disable debug.
6122: --disable_debug;
6123:
6124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6125: ROLLBACK TO update_group;
6126:
6127: IF l_context = 'N' THEN
6128: hz_common_pub.enable_cont_source_security;

Line 6131: x_return_status := fnd_api.g_ret_sts_unexp_error;

6127: IF l_context = 'N' THEN
6128: hz_common_pub.enable_cont_source_security;
6129: END IF;
6130:
6131: x_return_status := fnd_api.g_ret_sts_unexp_error;
6132:
6133: fnd_msg_pub.count_and_get(
6134: p_encoded => fnd_api.g_false,
6135: p_count => x_msg_count,

Line 6134: p_encoded => fnd_api.g_false,

6130:
6131: x_return_status := fnd_api.g_ret_sts_unexp_error;
6132:
6133: fnd_msg_pub.count_and_get(
6134: p_encoded => fnd_api.g_false,
6135: p_count => x_msg_count,
6136: p_data => x_msg_data);
6137:
6138: -- Debug info.

Line 6167: x_return_status := fnd_api.g_ret_sts_unexp_error;

6163: IF l_context = 'N' THEN
6164: hz_common_pub.enable_cont_source_security;
6165: END IF;
6166:
6167: x_return_status := fnd_api.g_ret_sts_unexp_error;
6168:
6169: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6170: fnd_message.set_token('ERROR',SQLERRM);
6171: fnd_msg_pub.add;

Line 6174: p_encoded => fnd_api.g_false,

6170: fnd_message.set_token('ERROR',SQLERRM);
6171: fnd_msg_pub.add;
6172:
6173: fnd_msg_pub.count_and_get(
6174: p_encoded => fnd_api.g_false,
6175: p_count => x_msg_count,
6176: p_data => x_msg_data);
6177:
6178: -- Debug info.

Line 6215: * FND_API.G_TRUE. Default is fnd_api.g_false.

6211: *
6212: * ARGUMENTS
6213: * IN:
6214: * p_init_msg_list Initialize message stack if it is set to
6215: * FND_API.G_TRUE. Default is fnd_api.g_false.
6216: * p_organization_rec Organization record.
6217: * p_party_usage_code Party Usage Code.
6218: * IN/OUT:
6219: * OUT:

Line 6224: * be FND_API.G_RET_STS_SUCCESS (success),

6220: * x_party_id Party ID.
6221: * x_party_number Party number.
6222: * x_profile_id Organization profile ID.
6223: * x_return_status Return status after the call. The status can
6224: * be FND_API.G_RET_STS_SUCCESS (success),
6225: * fnd_api.g_ret_sts_error (error),
6226: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6227: * x_msg_count Number of messages in message stack.
6228: * x_msg_data Message text if x_msg_count is 1.

Line 6225: * fnd_api.g_ret_sts_error (error),

6221: * x_party_number Party number.
6222: * x_profile_id Organization profile ID.
6223: * x_return_status Return status after the call. The status can
6224: * be FND_API.G_RET_STS_SUCCESS (success),
6225: * fnd_api.g_ret_sts_error (error),
6226: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6227: * x_msg_count Number of messages in message stack.
6228: * x_msg_data Message text if x_msg_count is 1.
6229: *

Line 6226: * fnd_api.g_ret_sts_unexp_error (unexpected error).

6222: * x_profile_id Organization profile ID.
6223: * x_return_status Return status after the call. The status can
6224: * be FND_API.G_RET_STS_SUCCESS (success),
6225: * fnd_api.g_ret_sts_error (error),
6226: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6227: * x_msg_count Number of messages in message stack.
6228: * x_msg_data Message text if x_msg_count is 1.
6229: *
6230: * NOTES

Line 6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6238: *
6239: */
6240:
6241: PROCEDURE create_organization (
6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6243: p_organization_rec IN ORGANIZATION_REC_TYPE,
6244: p_party_usage_code IN VARCHAR2,
6245: x_return_status OUT NOCOPY VARCHAR2,
6246: x_msg_count OUT NOCOPY NUMBER,

Line 6257: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

6253: l_api_name CONSTANT VARCHAR2(30) := 'create_organization';
6254: l_organization_rec ORGANIZATION_REC_TYPE := p_organization_rec;
6255: l_context VARCHAR2(30);
6256:
6257: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6258: dss_msg_count NUMBER := 0;
6259: dss_msg_data VARCHAR2(2000):= null;
6260: l_test_security VARCHAR2(1):= 'F';
6261: l_debug_prefix VARCHAR2(30) := '';

Line 6284: IF fnd_api.to_boolean(p_init_msg_list) THEN

6280: END IF;
6281:
6282:
6283: -- initialize message list if p_init_msg_list is set to TRUE.
6284: IF fnd_api.to_boolean(p_init_msg_list) THEN
6285: fnd_msg_pub.initialize;
6286: END IF;
6287:
6288: -- initialize API return status to success.

Line 6289: x_return_status := FND_API.G_RET_STS_SUCCESS;

6285: fnd_msg_pub.initialize;
6286: END IF;
6287:
6288: -- initialize API return status to success.
6289: x_return_status := FND_API.G_RET_STS_SUCCESS;
6290:
6291: -- Debug info.
6292: /*IF g_debug THEN
6293: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'before LoadDataSources (+)');

Line 6348: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6344: p_create_update_flag => 'C',
6345: p_organization_rec => l_organization_rec,
6346: x_return_status => x_return_status );
6347:
6348: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6349: RAISE fnd_api.g_exc_error;
6350: END IF;
6351: END IF;
6352:

Line 6349: RAISE fnd_api.g_exc_error;

6345: p_organization_rec => l_organization_rec,
6346: x_return_status => x_return_status );
6347:
6348: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6349: RAISE fnd_api.g_exc_error;
6350: END IF;
6351: END IF;
6352:
6353: -- Bug 2486394 -Check if the DSS security is granted to the user

Line 6367: if dss_return_status <> fnd_api.g_ret_sts_success THEN

6363: x_return_status => dss_return_status,
6364: x_msg_count => dss_msg_count,
6365: x_msg_data => dss_msg_data);
6366:
6367: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6368: RAISE FND_API.G_EXC_ERROR;
6369: end if;
6370:
6371: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

Line 6368: RAISE FND_API.G_EXC_ERROR;

6364: x_msg_count => dss_msg_count,
6365: x_msg_data => dss_msg_data);
6366:
6367: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6368: RAISE FND_API.G_EXC_ERROR;
6369: end if;
6370:
6371: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6372: --

Line 6371: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

6367: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6368: RAISE FND_API.G_EXC_ERROR;
6369: end if;
6370:
6371: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6372: --
6373: -- Bug 3835601: replaced the dss message with a more user friendly message
6374: --
6375: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

Line 6379: RAISE FND_API.G_EXC_ERROR;

6375: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
6376: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6377: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6378: FND_MSG_PUB.ADD;
6379: RAISE FND_API.G_EXC_ERROR;
6380: end if;
6381: END IF;
6382:
6383: -- enable policy function if it was enabled before calling

Line 6392: p_encoded => fnd_api.g_false,

6388: END IF;
6389:
6390: --Standard call to get message count and if count is 1, get message info.
6391: fnd_msg_pub.count_and_get(
6392: p_encoded => fnd_api.g_false,
6393: p_count => x_msg_count,
6394: p_data => x_msg_data);
6395:
6396: -- Debug info.

Line 6419: WHEN fnd_api.g_exc_error THEN

6415: -- Check if API is called in debug mode. If yes, disable debug.
6416: --disable_debug;
6417:
6418: EXCEPTION
6419: WHEN fnd_api.g_exc_error THEN
6420: ROLLBACK TO create_organization;
6421:
6422: IF l_context = 'N' THEN
6423: hz_common_pub.enable_cont_source_security;

Line 6426: x_return_status := fnd_api.g_ret_sts_error;

6422: IF l_context = 'N' THEN
6423: hz_common_pub.enable_cont_source_security;
6424: END IF;
6425:
6426: x_return_status := fnd_api.g_ret_sts_error;
6427:
6428: fnd_msg_pub.count_and_get(
6429: p_encoded => fnd_api.g_false,
6430: p_count => x_msg_count,

Line 6429: p_encoded => fnd_api.g_false,

6425:
6426: x_return_status := fnd_api.g_ret_sts_error;
6427:
6428: fnd_msg_pub.count_and_get(
6429: p_encoded => fnd_api.g_false,
6430: p_count => x_msg_count,
6431: p_data => x_msg_data);
6432:
6433: -- Debug info.

Line 6455: WHEN fnd_api.g_exc_unexpected_error THEN

6451:
6452: -- Check if API is called in debug mode. If yes, disable debug.
6453: --disable_debug;
6454:
6455: WHEN fnd_api.g_exc_unexpected_error THEN
6456: ROLLBACK TO create_organization;
6457:
6458: IF l_context = 'N' THEN
6459: hz_common_pub.enable_cont_source_security;

Line 6462: x_return_status := fnd_api.g_ret_sts_unexp_error;

6458: IF l_context = 'N' THEN
6459: hz_common_pub.enable_cont_source_security;
6460: END IF;
6461:
6462: x_return_status := fnd_api.g_ret_sts_unexp_error;
6463:
6464: fnd_msg_pub.count_and_get(
6465: p_encoded => fnd_api.g_false,
6466: p_count => x_msg_count,

Line 6465: p_encoded => fnd_api.g_false,

6461:
6462: x_return_status := fnd_api.g_ret_sts_unexp_error;
6463:
6464: fnd_msg_pub.count_and_get(
6465: p_encoded => fnd_api.g_false,
6466: p_count => x_msg_count,
6467: p_data => x_msg_data);
6468:
6469: -- Debug info.

Line 6498: x_return_status := fnd_api.g_ret_sts_unexp_error;

6494: IF l_context = 'N' THEN
6495: hz_common_pub.enable_cont_source_security;
6496: END IF;
6497:
6498: x_return_status := fnd_api.g_ret_sts_unexp_error;
6499:
6500: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6501: fnd_message.set_token('ERROR',SQLERRM);
6502: fnd_msg_pub.add;

Line 6505: p_encoded => fnd_api.g_false,

6501: fnd_message.set_token('ERROR',SQLERRM);
6502: fnd_msg_pub.add;
6503:
6504: fnd_msg_pub.count_and_get(
6505: p_encoded => fnd_api.g_false,
6506: p_count => x_msg_count,
6507: p_data => x_msg_data);
6508:
6509: -- Debug info.

Line 6545: * FND_API.G_TRUE. Default is fnd_api.g_false.

6541: *
6542: * ARGUMENTS
6543: * IN:
6544: * p_init_msg_list Initialize message stack if it is set to
6545: * FND_API.G_TRUE. Default is fnd_api.g_false.
6546: * p_organization_rec Organization record.
6547: * IN/OUT:
6548: * OUT:
6549: * x_party_id Party ID.

Line 6553: * be FND_API.G_RET_STS_SUCCESS (success),

6549: * x_party_id Party ID.
6550: * x_party_number Party number.
6551: * x_profile_id Organization profile ID.
6552: * x_return_status Return status after the call. The status can
6553: * be FND_API.G_RET_STS_SUCCESS (success),
6554: * fnd_api.g_ret_sts_error (error),
6555: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6556: * x_msg_count Number of messages in message stack.
6557: * x_msg_data Message text if x_msg_count is 1.

Line 6554: * fnd_api.g_ret_sts_error (error),

6550: * x_party_number Party number.
6551: * x_profile_id Organization profile ID.
6552: * x_return_status Return status after the call. The status can
6553: * be FND_API.G_RET_STS_SUCCESS (success),
6554: * fnd_api.g_ret_sts_error (error),
6555: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6556: * x_msg_count Number of messages in message stack.
6557: * x_msg_data Message text if x_msg_count is 1.
6558: *

Line 6555: * fnd_api.g_ret_sts_unexp_error (unexpected error).

6551: * x_profile_id Organization profile ID.
6552: * x_return_status Return status after the call. The status can
6553: * be FND_API.G_RET_STS_SUCCESS (success),
6554: * fnd_api.g_ret_sts_error (error),
6555: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6556: * x_msg_count Number of messages in message stack.
6557: * x_msg_data Message text if x_msg_count is 1.
6558: *
6559: * NOTES

Line 6571: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6567: *
6568: */
6569:
6570: PROCEDURE create_organization (
6571: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6572: p_organization_rec IN ORGANIZATION_REC_TYPE,
6573: x_return_status OUT NOCOPY VARCHAR2,
6574: x_msg_count OUT NOCOPY NUMBER,
6575: x_msg_data OUT NOCOPY VARCHAR2,

Line 6609: * FND_API.G_TRUE. Default is fnd_api.g_false.

6605: *
6606: * ARGUMENTS
6607: * IN:
6608: * p_init_msg_list Initialize message stack if it is set to
6609: * FND_API.G_TRUE. Default is fnd_api.g_false.
6610: * p_organization_rec Organization record.
6611: * IN/OUT:
6612: * p_party_object_version_number Used for locking the being updated record.
6613: * OUT:

Line 6616: * be fnd_api.g_ret_sts_success (success),

6612: * p_party_object_version_number Used for locking the being updated record.
6613: * OUT:
6614: * x_profile_id Organization profile ID.
6615: * x_return_status Return status after the call. The status can
6616: * be fnd_api.g_ret_sts_success (success),
6617: * fnd_api.g_ret_sts_error (error),
6618: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6619: * x_msg_count Number of messages in message stack.
6620: * x_msg_data Message text if x_msg_count is 1.

Line 6617: * fnd_api.g_ret_sts_error (error),

6613: * OUT:
6614: * x_profile_id Organization profile ID.
6615: * x_return_status Return status after the call. The status can
6616: * be fnd_api.g_ret_sts_success (success),
6617: * fnd_api.g_ret_sts_error (error),
6618: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6619: * x_msg_count Number of messages in message stack.
6620: * x_msg_data Message text if x_msg_count is 1.
6621: *

Line 6618: * fnd_api.g_ret_sts_unexp_error (unexpected error).

6614: * x_profile_id Organization profile ID.
6615: * x_return_status Return status after the call. The status can
6616: * be fnd_api.g_ret_sts_success (success),
6617: * fnd_api.g_ret_sts_error (error),
6618: * fnd_api.g_ret_sts_unexp_error (unexpected error).
6619: * x_msg_count Number of messages in message stack.
6620: * x_msg_data Message text if x_msg_count is 1.
6621: *
6622: * NOTES

Line 6637: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6633: * then 'USER_ENTERED' is assigned.
6634: */
6635:
6636: PROCEDURE update_organization (
6637: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6638: p_organization_rec IN ORGANIZATION_REC_TYPE,
6639: p_party_object_version_number IN OUT NOCOPY NUMBER,
6640: x_profile_id OUT NOCOPY NUMBER,
6641: x_return_status OUT NOCOPY VARCHAR2,

Line 6694: IF fnd_api.to_boolean(p_init_msg_list) THEN

6690: END IF;
6691: END IF;
6692:
6693: -- initialize message list if p_init_msg_list is set to TRUE.
6694: IF fnd_api.to_boolean(p_init_msg_list) THEN
6695: fnd_msg_pub.initialize;
6696: END IF;
6697:
6698: -- initialize API return status to success.

Line 6699: x_return_status := fnd_api.g_ret_sts_success;

6695: fnd_msg_pub.initialize;
6696: END IF;
6697:
6698: -- initialize API return status to success.
6699: x_return_status := fnd_api.g_ret_sts_success;
6700:
6701: -- enable policy function if it is disabled.
6702:
6703: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 6721: RAISE fnd_api.g_exc_error;

6717: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6718: fnd_message.set_token('RECORD', 'organization');
6719: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6720: fnd_msg_pub.add;
6721: RAISE fnd_api.g_exc_error;
6722: END IF;
6723: CLOSE c_orgchk;
6724: **/
6725:

Line 6727: and l_organization_rec.party_rec.orig_system <>fnd_api.g_miss_char)

6723: CLOSE c_orgchk;
6724: **/
6725:
6726: IF (l_organization_rec.party_rec.orig_system is not null
6727: and l_organization_rec.party_rec.orig_system <>fnd_api.g_miss_char)
6728: and (l_organization_rec.party_rec.orig_system_reference is not null
6729: and l_organization_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
6730: and (l_organization_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_organization_rec.party_rec.party_id is null) THEN
6731:

Line 6729: and l_organization_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)

6725:
6726: IF (l_organization_rec.party_rec.orig_system is not null
6727: and l_organization_rec.party_rec.orig_system <>fnd_api.g_miss_char)
6728: and (l_organization_rec.party_rec.orig_system_reference is not null
6729: and l_organization_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
6730: and (l_organization_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_organization_rec.party_rec.party_id is null) THEN
6731:
6732: hz_orig_system_ref_pub.get_owner_table_id
6733: (p_orig_system => l_organization_rec.party_rec.orig_system,

Line 6730: and (l_organization_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_organization_rec.party_rec.party_id is null) THEN

6726: IF (l_organization_rec.party_rec.orig_system is not null
6727: and l_organization_rec.party_rec.orig_system <>fnd_api.g_miss_char)
6728: and (l_organization_rec.party_rec.orig_system_reference is not null
6729: and l_organization_rec.party_rec.orig_system_reference <>fnd_api.g_miss_char)
6730: and (l_organization_rec.party_rec.party_id = FND_API.G_MISS_NUM or l_organization_rec.party_rec.party_id is null) THEN
6731:
6732: hz_orig_system_ref_pub.get_owner_table_id
6733: (p_orig_system => l_organization_rec.party_rec.orig_system,
6734: p_orig_system_reference => l_organization_rec.party_rec.orig_system_reference,

Line 6739: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6735: p_owner_table_name => 'HZ_PARTIES',
6736: x_owner_table_id => l_organization_rec.party_rec.party_id,
6737: x_return_status => x_return_status);
6738:
6739: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6740: RAISE FND_API.G_EXC_ERROR;
6741: END IF;
6742: END IF;
6743:

Line 6740: RAISE FND_API.G_EXC_ERROR;

6736: x_owner_table_id => l_organization_rec.party_rec.party_id,
6737: x_return_status => x_return_status);
6738:
6739: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6740: RAISE FND_API.G_EXC_ERROR;
6741: END IF;
6742: END IF;
6743:
6744:

Line 6766: IF x_return_status = fnd_api.g_ret_sts_error THEN

6762: x_return_status => x_return_status,
6763: x_msg_count => x_msg_count,
6764: x_msg_data => x_msg_data);
6765:
6766: IF x_return_status = fnd_api.g_ret_sts_error THEN
6767: RAISE fnd_api.g_exc_error;
6768: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6769: RAISE fnd_api.g_exc_unexpected_error;
6770: END IF;

Line 6767: RAISE fnd_api.g_exc_error;

6763: x_msg_count => x_msg_count,
6764: x_msg_data => x_msg_data);
6765:
6766: IF x_return_status = fnd_api.g_ret_sts_error THEN
6767: RAISE fnd_api.g_exc_error;
6768: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6769: RAISE fnd_api.g_exc_unexpected_error;
6770: END IF;
6771:

Line 6768: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

6764: x_msg_data => x_msg_data);
6765:
6766: IF x_return_status = fnd_api.g_ret_sts_error THEN
6767: RAISE fnd_api.g_exc_error;
6768: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6769: RAISE fnd_api.g_exc_unexpected_error;
6770: END IF;
6771:
6772: --- Bug 2486394 Check if the DSS security is granted to the user

Line 6769: RAISE fnd_api.g_exc_unexpected_error;

6765:
6766: IF x_return_status = fnd_api.g_ret_sts_error THEN
6767: RAISE fnd_api.g_exc_error;
6768: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6769: RAISE fnd_api.g_exc_unexpected_error;
6770: END IF;
6771:
6772: --- Bug 2486394 Check if the DSS security is granted to the user
6773: -- Bug 3818648: check dss profile before call test_instance.

Line 6786: if dss_return_status <> fnd_api.g_ret_sts_success THEN

6782: x_return_status => dss_return_status,
6783: x_msg_count => dss_msg_count,
6784: x_msg_data => dss_msg_data);
6785:
6786: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6787: RAISE FND_API.G_EXC_ERROR;
6788: end if;
6789:
6790: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

Line 6787: RAISE FND_API.G_EXC_ERROR;

6783: x_msg_count => dss_msg_count,
6784: x_msg_data => dss_msg_data);
6785:
6786: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6787: RAISE FND_API.G_EXC_ERROR;
6788: end if;
6789:
6790: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6791: --

Line 6790: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

6786: if dss_return_status <> fnd_api.g_ret_sts_success THEN
6787: RAISE FND_API.G_EXC_ERROR;
6788: end if;
6789:
6790: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6791: --
6792: -- Bug 3835601: replaced the message with a more user friendly message
6793: --
6794: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

Line 6798: RAISE FND_API.G_EXC_ERROR;

6794: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6795: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6796: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6797: FND_MSG_PUB.ADD;
6798: RAISE FND_API.G_EXC_ERROR;
6799: end if;
6800: END IF;
6801:
6802: -- call to business logic.

Line 6824: IF x_return_status = fnd_api.g_ret_sts_error THEN

6820: x_msg_count => x_msg_count,
6821: x_msg_data => x_msg_data,
6822: x_party_id => l_organization_rec.party_rec.party_id);
6823:
6824: IF x_return_status = fnd_api.g_ret_sts_error THEN
6825: RAISE fnd_api.g_exc_error;
6826: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6827: RAISE fnd_api.g_exc_unexpected_error;
6828: END IF;

Line 6825: RAISE fnd_api.g_exc_error;

6821: x_msg_data => x_msg_data,
6822: x_party_id => l_organization_rec.party_rec.party_id);
6823:
6824: IF x_return_status = fnd_api.g_ret_sts_error THEN
6825: RAISE fnd_api.g_exc_error;
6826: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6827: RAISE fnd_api.g_exc_unexpected_error;
6828: END IF;
6829:

Line 6826: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

6822: x_party_id => l_organization_rec.party_rec.party_id);
6823:
6824: IF x_return_status = fnd_api.g_ret_sts_error THEN
6825: RAISE fnd_api.g_exc_error;
6826: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6827: RAISE fnd_api.g_exc_unexpected_error;
6828: END IF;
6829:
6830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6827: RAISE fnd_api.g_exc_unexpected_error;

6823:
6824: IF x_return_status = fnd_api.g_ret_sts_error THEN
6825: RAISE fnd_api.g_exc_error;
6826: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6827: RAISE fnd_api.g_exc_unexpected_error;
6828: END IF;
6829:
6830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6831: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',

Line 6857: IF x_return_status <> fnd_api.g_ret_sts_success THEN

6853: p_create_update_flag => l_create_update_flag,
6854: p_organization_rec => l_organization_rec,
6855: x_return_status => x_return_status );
6856:
6857: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6858: RAISE fnd_api.g_exc_error;
6859: END IF;
6860: END IF;
6861:

Line 6858: RAISE fnd_api.g_exc_error;

6854: p_organization_rec => l_organization_rec,
6855: x_return_status => x_return_status );
6856:
6857: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6858: RAISE fnd_api.g_exc_error;
6859: END IF;
6860: END IF;
6861:
6862:

Line 6872: p_encoded => fnd_api.g_false,

6868: END IF;
6869:
6870: --Standard call to get message count and if count is 1, get message info.
6871: fnd_msg_pub.count_and_get(
6872: p_encoded => fnd_api.g_false,
6873: p_count => x_msg_count,
6874: p_data => x_msg_data);
6875:
6876: -- Debug info.

Line 6898: WHEN fnd_api.g_exc_error THEN

6894: -- Check if API is called in debug mode. If yes, disable debug.
6895: --disable_debug;
6896:
6897: EXCEPTION
6898: WHEN fnd_api.g_exc_error THEN
6899: ROLLBACK TO update_organization;
6900:
6901: IF l_context = 'N' THEN
6902: hz_common_pub.enable_cont_source_security;

Line 6905: x_return_status := fnd_api.g_ret_sts_error;

6901: IF l_context = 'N' THEN
6902: hz_common_pub.enable_cont_source_security;
6903: END IF;
6904:
6905: x_return_status := fnd_api.g_ret_sts_error;
6906:
6907: fnd_msg_pub.count_and_get(
6908: p_encoded => fnd_api.g_false,
6909: p_count => x_msg_count,

Line 6908: p_encoded => fnd_api.g_false,

6904:
6905: x_return_status := fnd_api.g_ret_sts_error;
6906:
6907: fnd_msg_pub.count_and_get(
6908: p_encoded => fnd_api.g_false,
6909: p_count => x_msg_count,
6910: p_data => x_msg_data);
6911:
6912: -- Debug info.

Line 6934: WHEN fnd_api.g_exc_unexpected_error THEN

6930:
6931: -- Check if API is called in debug mode. If yes, disable debug.
6932: --disable_debug;
6933:
6934: WHEN fnd_api.g_exc_unexpected_error THEN
6935: ROLLBACK TO update_organization;
6936:
6937: IF l_context = 'N' THEN
6938: hz_common_pub.enable_cont_source_security;

Line 6941: x_return_status := fnd_api.g_ret_sts_unexp_error;

6937: IF l_context = 'N' THEN
6938: hz_common_pub.enable_cont_source_security;
6939: END IF;
6940:
6941: x_return_status := fnd_api.g_ret_sts_unexp_error;
6942:
6943: fnd_msg_pub.count_and_get(
6944: p_encoded => fnd_api.g_false,
6945: p_count => x_msg_count,

Line 6944: p_encoded => fnd_api.g_false,

6940:
6941: x_return_status := fnd_api.g_ret_sts_unexp_error;
6942:
6943: fnd_msg_pub.count_and_get(
6944: p_encoded => fnd_api.g_false,
6945: p_count => x_msg_count,
6946: p_data => x_msg_data);
6947:
6948: -- Debug info.

Line 6978: x_return_status := fnd_api.g_ret_sts_unexp_error;

6974: IF l_context = 'N' THEN
6975: hz_common_pub.enable_cont_source_security;
6976: END IF;
6977:
6978: x_return_status := fnd_api.g_ret_sts_unexp_error;
6979:
6980: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6981: fnd_message.set_token('ERROR',SQLERRM);
6982: fnd_msg_pub.add;

Line 6985: p_encoded => fnd_api.g_false,

6981: fnd_message.set_token('ERROR',SQLERRM);
6982: fnd_msg_pub.add;
6983:
6984: fnd_msg_pub.count_and_get(
6985: p_encoded => fnd_api.g_false,
6986: p_count => x_msg_count,
6987: p_data => x_msg_data);
6988:
6989: -- Debug info.

Line 7025: * FND_API.G_TRUE. Default is fnd_api.g_false.

7021: *
7022: * ARGUMENTS
7023: * IN:
7024: * p_init_msg_list Initialize message stack if it is set to
7025: * FND_API.G_TRUE. Default is fnd_api.g_false.
7026: * p_party_id Party ID.
7027: * p_content_source_type Content source type.
7028: * IN/OUT:
7029: * OUT:

Line 7032: * be fnd_api.g_ret_sts_success (success),

7028: * IN/OUT:
7029: * OUT:
7030: * x_organization_rec Returned organization record.
7031: * x_return_status Return status after the call. The status can
7032: * be fnd_api.g_ret_sts_success (success),
7033: * fnd_api.g_ret_sts_error (error),
7034: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7035: * x_msg_count Number of messages in message stack.
7036: * x_msg_data Message text if x_msg_count is 1.

Line 7033: * fnd_api.g_ret_sts_error (error),

7029: * OUT:
7030: * x_organization_rec Returned organization record.
7031: * x_return_status Return status after the call. The status can
7032: * be fnd_api.g_ret_sts_success (success),
7033: * fnd_api.g_ret_sts_error (error),
7034: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7035: * x_msg_count Number of messages in message stack.
7036: * x_msg_data Message text if x_msg_count is 1.
7037: *

Line 7034: * fnd_api.g_ret_sts_unexp_error (unexpected error).

7030: * x_organization_rec Returned organization record.
7031: * x_return_status Return status after the call. The status can
7032: * be fnd_api.g_ret_sts_success (success),
7033: * fnd_api.g_ret_sts_error (error),
7034: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7035: * x_msg_count Number of messages in message stack.
7036: * x_msg_data Message text if x_msg_count is 1.
7037: *
7038: * NOTES

Line 7052: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

7048: *
7049: */
7050:
7051: PROCEDURE get_organization_rec (
7052: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7053: p_party_id IN NUMBER,
7054: p_content_source_type IN VARCHAR2 := g_miss_content_source_type,
7055: x_organization_rec OUT NOCOPY ORGANIZATION_REC_TYPE,
7056: x_return_status OUT NOCOPY VARCHAR2,

Line 7101: IF fnd_api.to_boolean(p_init_msg_list) THEN

7097:
7098: BEGIN
7099:
7100: --Initialize message list if p_init_msg_list is set to TRUE.
7101: IF fnd_api.to_boolean(p_init_msg_list) THEN
7102: fnd_msg_pub.initialize;
7103: END IF;
7104:
7105: --Initialize API return status to success.

Line 7106: x_return_status := fnd_api.g_ret_sts_success;

7102: fnd_msg_pub.initialize;
7103: END IF;
7104:
7105: --Initialize API return status to success.
7106: x_return_status := fnd_api.g_ret_sts_success;
7107:
7108: -- enable policy function if it is disabled.
7109:
7110: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 7117: p_party_id = fnd_api.g_miss_num

7113: END IF;
7114:
7115: --Check whether primary key has been passed in.
7116: IF p_party_id IS NULL OR
7117: p_party_id = fnd_api.g_miss_num
7118: THEN
7119: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7120: fnd_message.set_token('COLUMN', 'p_party_id');
7121: fnd_msg_pub.add;

Line 7122: RAISE fnd_api.g_exc_error;

7118: THEN
7119: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7120: fnd_message.set_token('COLUMN', 'p_party_id');
7121: fnd_msg_pub.add;
7122: RAISE fnd_api.g_exc_error;
7123: END IF;
7124:
7125: IF p_content_source_type IS NULL OR
7126: p_content_source_type = fnd_api.g_miss_char

Line 7126: p_content_source_type = fnd_api.g_miss_char

7122: RAISE fnd_api.g_exc_error;
7123: END IF;
7124:
7125: IF p_content_source_type IS NULL OR
7126: p_content_source_type = fnd_api.g_miss_char
7127: THEN
7128: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7129: fnd_message.set_token('COLUMN', 'p_content_source_type');
7130: fnd_msg_pub.add;

Line 7131: RAISE fnd_api.g_exc_error;

7127: THEN
7128: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7129: fnd_message.set_token('COLUMN', 'p_content_source_type');
7130: fnd_msg_pub.add;
7131: RAISE fnd_api.g_exc_error;
7132: END IF;
7133:
7134: IF p_content_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN
7135: OPEN c_org_ue;

Line 7157: RAISE fnd_api.g_exc_error;

7153: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7154: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7155: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7156: fnd_msg_pub.add;
7157: RAISE fnd_api.g_exc_error;
7158: END IF;
7159:
7160:
7161: hz_organization_profiles_pkg.Select_Row (

Line 7357: p_encoded => fnd_api.g_false,

7353: END IF;
7354:
7355: --Standard call to get message count and if count is 1, get message info.
7356: fnd_msg_pub.count_and_get(
7357: p_encoded => fnd_api.g_false,
7358: p_count => x_msg_count,
7359: p_data => x_msg_data);
7360:
7361: EXCEPTION

Line 7362: WHEN fnd_api.g_exc_error THEN

7358: p_count => x_msg_count,
7359: p_data => x_msg_data);
7360:
7361: EXCEPTION
7362: WHEN fnd_api.g_exc_error THEN
7363: IF l_context = 'N' THEN
7364: hz_common_pub.enable_cont_source_security;
7365: END IF;
7366:

Line 7367: x_return_status := fnd_api.g_ret_sts_error;

7363: IF l_context = 'N' THEN
7364: hz_common_pub.enable_cont_source_security;
7365: END IF;
7366:
7367: x_return_status := fnd_api.g_ret_sts_error;
7368:
7369: fnd_msg_pub.count_and_get(
7370: p_encoded => fnd_api.g_false,
7371: p_count => x_msg_count,

Line 7370: p_encoded => fnd_api.g_false,

7366:
7367: x_return_status := fnd_api.g_ret_sts_error;
7368:
7369: fnd_msg_pub.count_and_get(
7370: p_encoded => fnd_api.g_false,
7371: p_count => x_msg_count,
7372: p_data => x_msg_data);
7373:
7374: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7374: WHEN fnd_api.g_exc_unexpected_error THEN

7370: p_encoded => fnd_api.g_false,
7371: p_count => x_msg_count,
7372: p_data => x_msg_data);
7373:
7374: WHEN fnd_api.g_exc_unexpected_error THEN
7375: IF l_context = 'N' THEN
7376: hz_common_pub.enable_cont_source_security;
7377: END IF;
7378:

Line 7379: x_return_status := fnd_api.g_ret_sts_unexp_error;

7375: IF l_context = 'N' THEN
7376: hz_common_pub.enable_cont_source_security;
7377: END IF;
7378:
7379: x_return_status := fnd_api.g_ret_sts_unexp_error;
7380:
7381: fnd_msg_pub.count_and_get(
7382: p_encoded => fnd_api.g_false,
7383: p_count => x_msg_count,

Line 7382: p_encoded => fnd_api.g_false,

7378:
7379: x_return_status := fnd_api.g_ret_sts_unexp_error;
7380:
7381: fnd_msg_pub.count_and_get(
7382: p_encoded => fnd_api.g_false,
7383: p_count => x_msg_count,
7384: p_data => x_msg_data);
7385:
7386: WHEN OTHERS THEN

Line 7391: x_return_status := fnd_api.g_ret_sts_unexp_error;

7387: IF l_context = 'N' THEN
7388: hz_common_pub.enable_cont_source_security;
7389: END IF;
7390:
7391: x_return_status := fnd_api.g_ret_sts_unexp_error;
7392:
7393: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7394: fnd_message.set_token('ERROR',SQLERRM);
7395: fnd_msg_pub.add;

Line 7398: p_encoded => fnd_api.g_false,

7394: fnd_message.set_token('ERROR',SQLERRM);
7395: fnd_msg_pub.add;
7396:
7397: fnd_msg_pub.count_and_get(
7398: p_encoded => fnd_api.g_false,
7399: p_count => x_msg_count,
7400: p_data => x_msg_data);
7401:
7402: END get_organization_rec;

Line 7416: * FND_API.G_TRUE. Default is fnd_api.g_false.

7412: *
7413: * ARGUMENTS
7414: * IN:
7415: * p_init_msg_list Initialize message stack if it is set to
7416: * FND_API.G_TRUE. Default is fnd_api.g_false.
7417: * p_party_id Party ID.
7418: * p_content_source_type Content source type.
7419: * IN/OUT:
7420: * OUT:

Line 7423: * be fnd_api.g_ret_sts_success (success),

7419: * IN/OUT:
7420: * OUT:
7421: * x_person_rec Returned person record.
7422: * x_return_status Return status after the call. The status can
7423: * be fnd_api.g_ret_sts_success (success),
7424: * fnd_api.g_ret_sts_error (error),
7425: * fnd_api.g_ret_sts_unexp_error (unexpected error)
7426: * x_msg_count Number of messages in message stack.
7427: * x_msg_data Message text if x_msg_count is 1.

Line 7424: * fnd_api.g_ret_sts_error (error),

7420: * OUT:
7421: * x_person_rec Returned person record.
7422: * x_return_status Return status after the call. The status can
7423: * be fnd_api.g_ret_sts_success (success),
7424: * fnd_api.g_ret_sts_error (error),
7425: * fnd_api.g_ret_sts_unexp_error (unexpected error)
7426: * x_msg_count Number of messages in message stack.
7427: * x_msg_data Message text if x_msg_count is 1.
7428: *

Line 7425: * fnd_api.g_ret_sts_unexp_error (unexpected error)

7421: * x_person_rec Returned person record.
7422: * x_return_status Return status after the call. The status can
7423: * be fnd_api.g_ret_sts_success (success),
7424: * fnd_api.g_ret_sts_error (error),
7425: * fnd_api.g_ret_sts_unexp_error (unexpected error)
7426: * x_msg_count Number of messages in message stack.
7427: * x_msg_data Message text if x_msg_count is 1.
7428: *
7429: * NOTES

Line 7438: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

7434: *
7435: */
7436:
7437: PROCEDURE get_person_rec (
7438: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7439: p_party_id IN NUMBER,
7440: p_content_source_type IN VARCHAR2 := G_MISS_CONTENT_SOURCE_TYPE,
7441: x_person_rec OUT NOCOPY PERSON_REC_TYPE,
7442: x_return_status OUT NOCOPY VARCHAR2,

Line 7482: IF fnd_api.to_boolean(p_init_msg_list) THEN

7478:
7479: BEGIN
7480:
7481: --Initialize message list if p_init_msg_list is set to TRUE.
7482: IF fnd_api.to_boolean(p_init_msg_list) THEN
7483: fnd_msg_pub.initialize;
7484: END IF;
7485:
7486: --Initialize API return status to success.

Line 7487: x_return_status := fnd_api.g_ret_sts_success;

7483: fnd_msg_pub.initialize;
7484: END IF;
7485:
7486: --Initialize API return status to success.
7487: x_return_status := fnd_api.g_ret_sts_success;
7488:
7489: -- enable policy function if it is disabled.
7490:
7491: l_context := NVL(SYS_CONTEXT('hz', g_apps_context), 'N');

Line 7498: p_party_id = fnd_api.g_miss_num

7494: END IF;
7495:
7496: --Check whether primary key has been passed in.
7497: IF p_party_id IS NULL OR
7498: p_party_id = fnd_api.g_miss_num
7499: THEN
7500: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7501: fnd_message.set_token('COLUMN', 'p_party_id');
7502: fnd_msg_pub.add;

Line 7503: RAISE fnd_api.g_exc_error;

7499: THEN
7500: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7501: fnd_message.set_token('COLUMN', 'p_party_id');
7502: fnd_msg_pub.add;
7503: RAISE fnd_api.g_exc_error;
7504: END IF;
7505:
7506: IF p_content_source_type IS NULL OR
7507: p_content_source_type = FND_API.G_MISS_CHAR

Line 7507: p_content_source_type = FND_API.G_MISS_CHAR

7503: RAISE fnd_api.g_exc_error;
7504: END IF;
7505:
7506: IF p_content_source_type IS NULL OR
7507: p_content_source_type = FND_API.G_MISS_CHAR
7508: THEN
7509: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7510: fnd_message.set_token('COLUMN', 'p_content_source_type');
7511: fnd_msg_pub.add;

Line 7512: RAISE fnd_api.g_exc_error;

7508: THEN
7509: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7510: fnd_message.set_token('COLUMN', 'p_content_source_type');
7511: fnd_msg_pub.add;
7512: RAISE fnd_api.g_exc_error;
7513: END IF;
7514:
7515: IF p_content_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN
7516: OPEN c_per_ue;

Line 7538: RAISE fnd_api.g_exc_error;

7534: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7535: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7536: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7537: fnd_msg_pub.add;
7538: RAISE fnd_api.g_exc_error;
7539: END IF;
7540:
7541: HZ_person_profiles_pkg.Select_Row (
7542: x_person_profile_id => l_profile_id,

Line 7627: p_encoded => fnd_api.g_false,

7623: END IF;
7624:
7625: --Standard call to get message count and if count is 1, get message info.
7626: fnd_msg_pub.count_and_get(
7627: p_encoded => fnd_api.g_false,
7628: p_count => x_msg_count,
7629: p_data => x_msg_data);
7630:
7631: EXCEPTION

Line 7632: WHEN fnd_api.g_exc_error THEN

7628: p_count => x_msg_count,
7629: p_data => x_msg_data);
7630:
7631: EXCEPTION
7632: WHEN fnd_api.g_exc_error THEN
7633: IF l_context = 'N' THEN
7634: hz_common_pub.enable_cont_source_security;
7635: END IF;
7636:

Line 7637: x_return_status := fnd_api.g_ret_sts_error;

7633: IF l_context = 'N' THEN
7634: hz_common_pub.enable_cont_source_security;
7635: END IF;
7636:
7637: x_return_status := fnd_api.g_ret_sts_error;
7638:
7639: fnd_msg_pub.count_and_get(
7640: p_encoded => fnd_api.g_false,
7641: p_count => x_msg_count,

Line 7640: p_encoded => fnd_api.g_false,

7636:
7637: x_return_status := fnd_api.g_ret_sts_error;
7638:
7639: fnd_msg_pub.count_and_get(
7640: p_encoded => fnd_api.g_false,
7641: p_count => x_msg_count,
7642: p_data => x_msg_data);
7643:
7644: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7644: WHEN fnd_api.g_exc_unexpected_error THEN

7640: p_encoded => fnd_api.g_false,
7641: p_count => x_msg_count,
7642: p_data => x_msg_data);
7643:
7644: WHEN fnd_api.g_exc_unexpected_error THEN
7645: IF l_context = 'N' THEN
7646: hz_common_pub.enable_cont_source_security;
7647: END IF;
7648:

Line 7649: x_return_status := fnd_api.g_ret_sts_unexp_error;

7645: IF l_context = 'N' THEN
7646: hz_common_pub.enable_cont_source_security;
7647: END IF;
7648:
7649: x_return_status := fnd_api.g_ret_sts_unexp_error;
7650:
7651: fnd_msg_pub.count_and_get(
7652: p_encoded => fnd_api.g_false,
7653: p_count => x_msg_count,

Line 7652: p_encoded => fnd_api.g_false,

7648:
7649: x_return_status := fnd_api.g_ret_sts_unexp_error;
7650:
7651: fnd_msg_pub.count_and_get(
7652: p_encoded => fnd_api.g_false,
7653: p_count => x_msg_count,
7654: p_data => x_msg_data);
7655:
7656: WHEN OTHERS THEN

Line 7661: x_return_status := fnd_api.g_ret_sts_unexp_error;

7657: IF l_context = 'N' THEN
7658: hz_common_pub.enable_cont_source_security;
7659: END IF;
7660:
7661: x_return_status := fnd_api.g_ret_sts_unexp_error;
7662:
7663: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7664: fnd_message.set_token('ERROR',SQLERRM);
7665: fnd_msg_pub.add;

Line 7668: p_encoded => fnd_api.g_false,

7664: fnd_message.set_token('ERROR',SQLERRM);
7665: fnd_msg_pub.add;
7666:
7667: fnd_msg_pub.count_and_get(
7668: p_encoded => fnd_api.g_false,
7669: p_count => x_msg_count,
7670: p_data => x_msg_data);
7671:
7672: END get_person_rec;

Line 7685: * FND_API.G_TRUE. Default is fnd_api.g_false.

7681: *
7682: * ARGUMENTS
7683: * IN:
7684: * p_init_msg_list Initialize message stack if it is set to
7685: * FND_API.G_TRUE. Default is fnd_api.g_false.
7686: * p_party_id Party ID.
7687: * IN/OUT:
7688: * OUT:
7689: * x_group_rec Returned group record.

Line 7691: * be fnd_api.g_ret_sts_success (success),

7687: * IN/OUT:
7688: * OUT:
7689: * x_group_rec Returned group record.
7690: * x_return_status Return status after the call. The status can
7691: * be fnd_api.g_ret_sts_success (success),
7692: * fnd_api.g_ret_sts_error (error),
7693: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7694: * x_msg_count Number of messages in message stack.
7695: * x_msg_data Message text if x_msg_count is 1.

Line 7692: * fnd_api.g_ret_sts_error (error),

7688: * OUT:
7689: * x_group_rec Returned group record.
7690: * x_return_status Return status after the call. The status can
7691: * be fnd_api.g_ret_sts_success (success),
7692: * fnd_api.g_ret_sts_error (error),
7693: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7694: * x_msg_count Number of messages in message stack.
7695: * x_msg_data Message text if x_msg_count is 1.
7696: *

Line 7693: * fnd_api.g_ret_sts_unexp_error (unexpected error).

7689: * x_group_rec Returned group record.
7690: * x_return_status Return status after the call. The status can
7691: * be fnd_api.g_ret_sts_success (success),
7692: * fnd_api.g_ret_sts_error (error),
7693: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7694: * x_msg_count Number of messages in message stack.
7695: * x_msg_data Message text if x_msg_count is 1.
7696: *
7697: * NOTES

Line 7706: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

7702: *
7703: */
7704:
7705: PROCEDURE get_group_rec (
7706: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7707: p_party_id IN NUMBER,
7708: x_group_rec OUT NOCOPY GROUP_REC_TYPE,
7709: x_return_status OUT NOCOPY VARCHAR2,
7710: x_msg_count OUT NOCOPY NUMBER,

Line 7747: IF fnd_api.to_boolean(p_init_msg_list) THEN

7743:
7744: BEGIN
7745:
7746: --Initialize message list if p_init_msg_list is set to TRUE.
7747: IF fnd_api.to_boolean(p_init_msg_list) THEN
7748: fnd_msg_pub.initialize;
7749: END IF;
7750:
7751: --Initialize API return status to success.

Line 7752: x_return_status := fnd_api.g_ret_sts_success;

7748: fnd_msg_pub.initialize;
7749: END IF;
7750:
7751: --Initialize API return status to success.
7752: x_return_status := fnd_api.g_ret_sts_success;
7753:
7754: --Check whether primary key has been passed in.
7755: IF p_party_id IS NULL OR
7756: p_party_id = fnd_api.g_miss_num

Line 7756: p_party_id = fnd_api.g_miss_num

7752: x_return_status := fnd_api.g_ret_sts_success;
7753:
7754: --Check whether primary key has been passed in.
7755: IF p_party_id IS NULL OR
7756: p_party_id = fnd_api.g_miss_num
7757: THEN
7758: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7759: fnd_message.set_token('COLUMN', 'party_id');
7760: fnd_msg_pub.add;

Line 7761: RAISE fnd_api.g_exc_error;

7757: THEN
7758: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7759: fnd_message.set_token('COLUMN', 'party_id');
7760: fnd_msg_pub.add;
7761: RAISE fnd_api.g_exc_error;
7762: END IF;
7763:
7764: OPEN c_group;
7765: FETCH c_group INTO l_dummy;

Line 7776: RAISE fnd_api.g_exc_error;

7772: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7773: fnd_message.set_token('RECORD', 'group');
7774: fnd_message.set_token('VALUE', to_char(p_party_id));
7775: fnd_msg_pub.add;
7776: RAISE fnd_api.g_exc_error;
7777: END IF;
7778:
7779: x_group_rec.party_rec.party_id := p_party_id;
7780:

Line 7870: p_encoded => fnd_api.g_false,

7866: );
7867:
7868: --Standard call to get message count and if count is 1, get message info.
7869: fnd_msg_pub.count_and_get(
7870: p_encoded => fnd_api.g_false,
7871: p_count => x_msg_count,
7872: p_data => x_msg_data);
7873:
7874: EXCEPTION

Line 7875: WHEN fnd_api.g_exc_error THEN

7871: p_count => x_msg_count,
7872: p_data => x_msg_data);
7873:
7874: EXCEPTION
7875: WHEN fnd_api.g_exc_error THEN
7876: x_return_status := fnd_api.g_ret_sts_error;
7877:
7878: fnd_msg_pub.count_and_get(
7879: p_encoded => fnd_api.g_false,

Line 7876: x_return_status := fnd_api.g_ret_sts_error;

7872: p_data => x_msg_data);
7873:
7874: EXCEPTION
7875: WHEN fnd_api.g_exc_error THEN
7876: x_return_status := fnd_api.g_ret_sts_error;
7877:
7878: fnd_msg_pub.count_and_get(
7879: p_encoded => fnd_api.g_false,
7880: p_count => x_msg_count,

Line 7879: p_encoded => fnd_api.g_false,

7875: WHEN fnd_api.g_exc_error THEN
7876: x_return_status := fnd_api.g_ret_sts_error;
7877:
7878: fnd_msg_pub.count_and_get(
7879: p_encoded => fnd_api.g_false,
7880: p_count => x_msg_count,
7881: p_data => x_msg_data);
7882:
7883: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7883: WHEN fnd_api.g_exc_unexpected_error THEN

7879: p_encoded => fnd_api.g_false,
7880: p_count => x_msg_count,
7881: p_data => x_msg_data);
7882:
7883: WHEN fnd_api.g_exc_unexpected_error THEN
7884: x_return_status := fnd_api.g_ret_sts_unexp_error;
7885:
7886: fnd_msg_pub.count_and_get(
7887: p_encoded => fnd_api.g_false,

Line 7884: x_return_status := fnd_api.g_ret_sts_unexp_error;

7880: p_count => x_msg_count,
7881: p_data => x_msg_data);
7882:
7883: WHEN fnd_api.g_exc_unexpected_error THEN
7884: x_return_status := fnd_api.g_ret_sts_unexp_error;
7885:
7886: fnd_msg_pub.count_and_get(
7887: p_encoded => fnd_api.g_false,
7888: p_count => x_msg_count,

Line 7887: p_encoded => fnd_api.g_false,

7883: WHEN fnd_api.g_exc_unexpected_error THEN
7884: x_return_status := fnd_api.g_ret_sts_unexp_error;
7885:
7886: fnd_msg_pub.count_and_get(
7887: p_encoded => fnd_api.g_false,
7888: p_count => x_msg_count,
7889: p_data => x_msg_data);
7890:
7891: WHEN OTHERS THEN

Line 7892: x_return_status := fnd_api.g_ret_sts_unexp_error;

7888: p_count => x_msg_count,
7889: p_data => x_msg_data);
7890:
7891: WHEN OTHERS THEN
7892: x_return_status := fnd_api.g_ret_sts_unexp_error;
7893:
7894: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7895: fnd_message.set_token('ERROR',SQLERRM);
7896: fnd_msg_pub.add;

Line 7899: p_encoded => fnd_api.g_false,

7895: fnd_message.set_token('ERROR',SQLERRM);
7896: fnd_msg_pub.add;
7897:
7898: fnd_msg_pub.count_and_get(
7899: p_encoded => fnd_api.g_false,
7900: p_count => x_msg_count,
7901: p_data => x_msg_data);
7902:
7903: END get_group_rec;

Line 7916: * FND_API.G_TRUE. Default is fnd_api.g_false.

7912: *
7913: * ARGUMENTS
7914: * IN:
7915: * p_init_msg_list Initialize message stack if it is set to
7916: * FND_API.G_TRUE. Default is fnd_api.g_false.
7917: * p_party_id Party ID.
7918: * IN/OUT:
7919: * OUT:
7920: * x_party_rec Returned party record.

Line 7922: * be fnd_api.g_ret_sts_success (success),

7918: * IN/OUT:
7919: * OUT:
7920: * x_party_rec Returned party record.
7921: * x_return_status Return status after the call. The status can
7922: * be fnd_api.g_ret_sts_success (success),
7923: * fnd_api.g_ret_sts_error (error),
7924: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7925: * x_msg_count Number of messages in message stack.
7926: * x_msg_data Message text if x_msg_count is 1.

Line 7923: * fnd_api.g_ret_sts_error (error),

7919: * OUT:
7920: * x_party_rec Returned party record.
7921: * x_return_status Return status after the call. The status can
7922: * be fnd_api.g_ret_sts_success (success),
7923: * fnd_api.g_ret_sts_error (error),
7924: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7925: * x_msg_count Number of messages in message stack.
7926: * x_msg_data Message text if x_msg_count is 1.
7927: *

Line 7924: * fnd_api.g_ret_sts_unexp_error (unexpected error).

7920: * x_party_rec Returned party record.
7921: * x_return_status Return status after the call. The status can
7922: * be fnd_api.g_ret_sts_success (success),
7923: * fnd_api.g_ret_sts_error (error),
7924: * fnd_api.g_ret_sts_unexp_error (unexpected error).
7925: * x_msg_count Number of messages in message stack.
7926: * x_msg_data Message text if x_msg_count is 1.
7927: *
7928: * NOTES

Line 7937: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

7933: *
7934: */
7935:
7936: PROCEDURE get_party_rec (
7937: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7938: p_party_id IN NUMBER,
7939: x_party_rec OUT NOCOPY PARTY_REC_TYPE,
7940: x_return_status OUT NOCOPY VARCHAR2,
7941: x_msg_count OUT NOCOPY NUMBER,

Line 7971: IF fnd_api.to_boolean(p_init_msg_list) THEN

7967: l_debug_prefix VARCHAR2(30) := '';
7968: BEGIN
7969:
7970: --Initialize message list if p_init_msg_list is set to TRUE.
7971: IF fnd_api.to_boolean(p_init_msg_list) THEN
7972: fnd_msg_pub.initialize;
7973: END IF;
7974:
7975: --Initialize API return status to success.

Line 7976: x_return_status := fnd_api.g_ret_sts_success;

7972: fnd_msg_pub.initialize;
7973: END IF;
7974:
7975: --Initialize API return status to success.
7976: x_return_status := fnd_api.g_ret_sts_success;
7977:
7978: --Check whether primary key has been passed in.
7979: IF p_party_id IS NULL OR
7980: p_party_id = fnd_api.g_miss_num

Line 7980: p_party_id = fnd_api.g_miss_num

7976: x_return_status := fnd_api.g_ret_sts_success;
7977:
7978: --Check whether primary key has been passed in.
7979: IF p_party_id IS NULL OR
7980: p_party_id = fnd_api.g_miss_num
7981: THEN
7982: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7983: fnd_message.set_token('COLUMN', 'party_id');
7984: fnd_msg_pub.add;

Line 7985: RAISE fnd_api.g_exc_error;

7981: THEN
7982: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7983: fnd_message.set_token('COLUMN', 'party_id');
7984: fnd_msg_pub.add;
7985: RAISE fnd_api.g_exc_error;
7986: END IF;
7987:
7988: x_party_rec.party_id := p_party_id;
7989:

Line 8078: p_encoded => fnd_api.g_false,

8074: );
8075:
8076: --Standard call to get message count and if count is 1, get message info.
8077: fnd_msg_pub.count_and_get(
8078: p_encoded => fnd_api.g_false,
8079: p_count => x_msg_count,
8080: p_data => x_msg_data);
8081:
8082: EXCEPTION

Line 8083: WHEN fnd_api.g_exc_error THEN

8079: p_count => x_msg_count,
8080: p_data => x_msg_data);
8081:
8082: EXCEPTION
8083: WHEN fnd_api.g_exc_error THEN
8084: x_return_status := fnd_api.g_ret_sts_error;
8085:
8086: fnd_msg_pub.count_and_get(
8087: p_encoded => fnd_api.g_false,

Line 8084: x_return_status := fnd_api.g_ret_sts_error;

8080: p_data => x_msg_data);
8081:
8082: EXCEPTION
8083: WHEN fnd_api.g_exc_error THEN
8084: x_return_status := fnd_api.g_ret_sts_error;
8085:
8086: fnd_msg_pub.count_and_get(
8087: p_encoded => fnd_api.g_false,
8088: p_count => x_msg_count,

Line 8087: p_encoded => fnd_api.g_false,

8083: WHEN fnd_api.g_exc_error THEN
8084: x_return_status := fnd_api.g_ret_sts_error;
8085:
8086: fnd_msg_pub.count_and_get(
8087: p_encoded => fnd_api.g_false,
8088: p_count => x_msg_count,
8089: p_data => x_msg_data);
8090:
8091: WHEN fnd_api.g_exc_unexpected_error THEN

Line 8091: WHEN fnd_api.g_exc_unexpected_error THEN

8087: p_encoded => fnd_api.g_false,
8088: p_count => x_msg_count,
8089: p_data => x_msg_data);
8090:
8091: WHEN fnd_api.g_exc_unexpected_error THEN
8092: x_return_status := fnd_api.g_ret_sts_unexp_error;
8093:
8094: fnd_msg_pub.count_and_get(
8095: p_encoded => fnd_api.g_false,

Line 8092: x_return_status := fnd_api.g_ret_sts_unexp_error;

8088: p_count => x_msg_count,
8089: p_data => x_msg_data);
8090:
8091: WHEN fnd_api.g_exc_unexpected_error THEN
8092: x_return_status := fnd_api.g_ret_sts_unexp_error;
8093:
8094: fnd_msg_pub.count_and_get(
8095: p_encoded => fnd_api.g_false,
8096: p_count => x_msg_count,

Line 8095: p_encoded => fnd_api.g_false,

8091: WHEN fnd_api.g_exc_unexpected_error THEN
8092: x_return_status := fnd_api.g_ret_sts_unexp_error;
8093:
8094: fnd_msg_pub.count_and_get(
8095: p_encoded => fnd_api.g_false,
8096: p_count => x_msg_count,
8097: p_data => x_msg_data);
8098:
8099: WHEN OTHERS THEN

Line 8100: x_return_status := fnd_api.g_ret_sts_unexp_error;

8096: p_count => x_msg_count,
8097: p_data => x_msg_data);
8098:
8099: WHEN OTHERS THEN
8100: x_return_status := fnd_api.g_ret_sts_unexp_error;
8101:
8102: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
8103: fnd_message.set_token('ERROR',SQLERRM);
8104: fnd_msg_pub.add;

Line 8107: p_encoded => fnd_api.g_false,

8103: fnd_message.set_token('ERROR',SQLERRM);
8104: fnd_msg_pub.add;
8105:
8106: fnd_msg_pub.count_and_get(
8107: p_encoded => fnd_api.g_false,
8108: p_count => x_msg_count,
8109: p_data => x_msg_data);
8110:
8111: END get_party_rec;

Line 8156: p_organization_rec.AVG_HIGH_CREDIT = FND_API.G_MISS_NUM ) AND

8152: (G_MISS_CONTENT_SOURCE_TYPE, G_SST_SOURCE_TYPE) AND
8153: ( p_create_update_flag = 'C' AND
8154: NOT(
8155: ( p_organization_rec.AVG_HIGH_CREDIT is null OR
8156: p_organization_rec.AVG_HIGH_CREDIT = FND_API.G_MISS_NUM ) AND
8157: ( p_organization_rec.CREDIT_SCORE is null OR
8158: p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR) AND
8159: ( p_organization_rec.CREDIT_SCORE_AGE is null OR
8160: p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM) AND

Line 8158: p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR) AND

8154: NOT(
8155: ( p_organization_rec.AVG_HIGH_CREDIT is null OR
8156: p_organization_rec.AVG_HIGH_CREDIT = FND_API.G_MISS_NUM ) AND
8157: ( p_organization_rec.CREDIT_SCORE is null OR
8158: p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR) AND
8159: ( p_organization_rec.CREDIT_SCORE_AGE is null OR
8160: p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM) AND
8161: ( p_organization_rec.CREDIT_SCORE_CLASS is null OR
8162: p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM) AND

Line 8160: p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM) AND

8156: p_organization_rec.AVG_HIGH_CREDIT = FND_API.G_MISS_NUM ) AND
8157: ( p_organization_rec.CREDIT_SCORE is null OR
8158: p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR) AND
8159: ( p_organization_rec.CREDIT_SCORE_AGE is null OR
8160: p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM) AND
8161: ( p_organization_rec.CREDIT_SCORE_CLASS is null OR
8162: p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8163: ( p_organization_rec.CREDIT_SCORE_COMMENTARY is null OR
8164: p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND

Line 8162: p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM) AND

8158: p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR) AND
8159: ( p_organization_rec.CREDIT_SCORE_AGE is null OR
8160: p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM) AND
8161: ( p_organization_rec.CREDIT_SCORE_CLASS is null OR
8162: p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8163: ( p_organization_rec.CREDIT_SCORE_COMMENTARY is null OR
8164: p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8165: ( p_organization_rec.CREDIT_SCORE_COMMENTARY2 is null OR
8166: p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND

Line 8164: p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND

8160: p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM) AND
8161: ( p_organization_rec.CREDIT_SCORE_CLASS is null OR
8162: p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8163: ( p_organization_rec.CREDIT_SCORE_COMMENTARY is null OR
8164: p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8165: ( p_organization_rec.CREDIT_SCORE_COMMENTARY2 is null OR
8166: p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8167: ( p_organization_rec.CREDIT_SCORE_COMMENTARY3 is null OR
8168: p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND

Line 8166: p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND

8162: p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8163: ( p_organization_rec.CREDIT_SCORE_COMMENTARY is null OR
8164: p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8165: ( p_organization_rec.CREDIT_SCORE_COMMENTARY2 is null OR
8166: p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8167: ( p_organization_rec.CREDIT_SCORE_COMMENTARY3 is null OR
8168: p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8169: ( p_organization_rec.CREDIT_SCORE_COMMENTARY4 is null OR
8170: p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND

Line 8168: p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND

8164: p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8165: ( p_organization_rec.CREDIT_SCORE_COMMENTARY2 is null OR
8166: p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8167: ( p_organization_rec.CREDIT_SCORE_COMMENTARY3 is null OR
8168: p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8169: ( p_organization_rec.CREDIT_SCORE_COMMENTARY4 is null OR
8170: p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8171: ( p_organization_rec.CREDIT_SCORE_COMMENTARY5 is null OR
8172: p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND

Line 8170: p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND

8166: p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8167: ( p_organization_rec.CREDIT_SCORE_COMMENTARY3 is null OR
8168: p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8169: ( p_organization_rec.CREDIT_SCORE_COMMENTARY4 is null OR
8170: p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8171: ( p_organization_rec.CREDIT_SCORE_COMMENTARY5 is null OR
8172: p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8173: ( p_organization_rec.CREDIT_SCORE_COMMENTARY6 is null OR
8174: p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND

Line 8172: p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND

8168: p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8169: ( p_organization_rec.CREDIT_SCORE_COMMENTARY4 is null OR
8170: p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8171: ( p_organization_rec.CREDIT_SCORE_COMMENTARY5 is null OR
8172: p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8173: ( p_organization_rec.CREDIT_SCORE_COMMENTARY6 is null OR
8174: p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8175: ( p_organization_rec.CREDIT_SCORE_COMMENTARY7 is null OR
8176: p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND

Line 8174: p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND

8170: p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8171: ( p_organization_rec.CREDIT_SCORE_COMMENTARY5 is null OR
8172: p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8173: ( p_organization_rec.CREDIT_SCORE_COMMENTARY6 is null OR
8174: p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8175: ( p_organization_rec.CREDIT_SCORE_COMMENTARY7 is null OR
8176: p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8177: ( p_organization_rec.CREDIT_SCORE_COMMENTARY8 is null OR
8178: p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND

Line 8176: p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND

8172: p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8173: ( p_organization_rec.CREDIT_SCORE_COMMENTARY6 is null OR
8174: p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8175: ( p_organization_rec.CREDIT_SCORE_COMMENTARY7 is null OR
8176: p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8177: ( p_organization_rec.CREDIT_SCORE_COMMENTARY8 is null OR
8178: p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8179: ( p_organization_rec.CREDIT_SCORE_COMMENTARY9 is null OR
8180: p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND

Line 8178: p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND

8174: p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8175: ( p_organization_rec.CREDIT_SCORE_COMMENTARY7 is null OR
8176: p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8177: ( p_organization_rec.CREDIT_SCORE_COMMENTARY8 is null OR
8178: p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8179: ( p_organization_rec.CREDIT_SCORE_COMMENTARY9 is null OR
8180: p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8181: ( p_organization_rec.CREDIT_SCORE_COMMENTARY10 is null OR
8182: p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND

Line 8180: p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND

8176: p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8177: ( p_organization_rec.CREDIT_SCORE_COMMENTARY8 is null OR
8178: p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8179: ( p_organization_rec.CREDIT_SCORE_COMMENTARY9 is null OR
8180: p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8181: ( p_organization_rec.CREDIT_SCORE_COMMENTARY10 is null OR
8182: p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8183: ( p_organization_rec.CREDIT_SCORE_DATE is null OR
8184: p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE) AND

Line 8182: p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND

8178: p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8179: ( p_organization_rec.CREDIT_SCORE_COMMENTARY9 is null OR
8180: p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8181: ( p_organization_rec.CREDIT_SCORE_COMMENTARY10 is null OR
8182: p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8183: ( p_organization_rec.CREDIT_SCORE_DATE is null OR
8184: p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE) AND
8185: ( p_organization_rec.CREDIT_SCORE_INCD_DEFAULT is null OR
8186: p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND

Line 8184: p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE) AND

8180: p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8181: ( p_organization_rec.CREDIT_SCORE_COMMENTARY10 is null OR
8182: p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8183: ( p_organization_rec.CREDIT_SCORE_DATE is null OR
8184: p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE) AND
8185: ( p_organization_rec.CREDIT_SCORE_INCD_DEFAULT is null OR
8186: p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8187: ( p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE is null OR
8188: p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM) AND

Line 8186: p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND

8182: p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8183: ( p_organization_rec.CREDIT_SCORE_DATE is null OR
8184: p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE) AND
8185: ( p_organization_rec.CREDIT_SCORE_INCD_DEFAULT is null OR
8186: p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8187: ( p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE is null OR
8188: p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM) AND
8189: ( p_organization_rec.DB_RATING is null OR
8190: p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR) AND

Line 8188: p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM) AND

8184: p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE) AND
8185: ( p_organization_rec.CREDIT_SCORE_INCD_DEFAULT is null OR
8186: p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8187: ( p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE is null OR
8188: p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM) AND
8189: ( p_organization_rec.DB_RATING is null OR
8190: p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR) AND
8191: ( p_organization_rec.DEBARMENT_IND is null OR
8192: p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR) AND

Line 8190: p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR) AND

8186: p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8187: ( p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE is null OR
8188: p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM) AND
8189: ( p_organization_rec.DB_RATING is null OR
8190: p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR) AND
8191: ( p_organization_rec.DEBARMENT_IND is null OR
8192: p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR) AND
8193: ( p_organization_rec.DEBARMENTS_COUNT is null OR
8194: p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM) AND

Line 8192: p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR) AND

8188: p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM) AND
8189: ( p_organization_rec.DB_RATING is null OR
8190: p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR) AND
8191: ( p_organization_rec.DEBARMENT_IND is null OR
8192: p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR) AND
8193: ( p_organization_rec.DEBARMENTS_COUNT is null OR
8194: p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM) AND
8195: ( p_organization_rec.DEBARMENTS_DATE is null OR
8196: p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE) AND

Line 8194: p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM) AND

8190: p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR) AND
8191: ( p_organization_rec.DEBARMENT_IND is null OR
8192: p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR) AND
8193: ( p_organization_rec.DEBARMENTS_COUNT is null OR
8194: p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM) AND
8195: ( p_organization_rec.DEBARMENTS_DATE is null OR
8196: p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE) AND
8197: ( p_organization_rec.HIGH_CREDIT is null OR
8198: p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM) AND

Line 8196: p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE) AND

8192: p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR) AND
8193: ( p_organization_rec.DEBARMENTS_COUNT is null OR
8194: p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM) AND
8195: ( p_organization_rec.DEBARMENTS_DATE is null OR
8196: p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE) AND
8197: ( p_organization_rec.HIGH_CREDIT is null OR
8198: p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM) AND
8199: ( p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE is null OR
8200: p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR) AND

Line 8198: p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM) AND

8194: p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM) AND
8195: ( p_organization_rec.DEBARMENTS_DATE is null OR
8196: p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE) AND
8197: ( p_organization_rec.HIGH_CREDIT is null OR
8198: p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM) AND
8199: ( p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE is null OR
8200: p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR) AND
8201: ( p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION is null OR
8202: p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM) AND

Line 8200: p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR) AND

8196: p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE) AND
8197: ( p_organization_rec.HIGH_CREDIT is null OR
8198: p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM) AND
8199: ( p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE is null OR
8200: p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR) AND
8201: ( p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION is null OR
8202: p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM) AND
8203: ( p_organization_rec.PAYDEX_NORM is null OR
8204: p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR) AND

Line 8202: p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM) AND

8198: p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM) AND
8199: ( p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE is null OR
8200: p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR) AND
8201: ( p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION is null OR
8202: p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM) AND
8203: ( p_organization_rec.PAYDEX_NORM is null OR
8204: p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR) AND
8205: ( p_organization_rec.PAYDEX_SCORE is null OR
8206: p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR) AND

Line 8204: p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR) AND

8200: p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR) AND
8201: ( p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION is null OR
8202: p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM) AND
8203: ( p_organization_rec.PAYDEX_NORM is null OR
8204: p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR) AND
8205: ( p_organization_rec.PAYDEX_SCORE is null OR
8206: p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR) AND
8207: ( p_organization_rec.PAYDEX_THREE_MONTHS_AGO is null OR
8208: p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR) AND

Line 8206: p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR) AND

8202: p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM) AND
8203: ( p_organization_rec.PAYDEX_NORM is null OR
8204: p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR) AND
8205: ( p_organization_rec.PAYDEX_SCORE is null OR
8206: p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR) AND
8207: ( p_organization_rec.PAYDEX_THREE_MONTHS_AGO is null OR
8208: p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR) AND
8209: ( p_organization_rec.FAILURE_SCORE is null OR
8210: p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR ) AND

Line 8208: p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR) AND

8204: p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR) AND
8205: ( p_organization_rec.PAYDEX_SCORE is null OR
8206: p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR) AND
8207: ( p_organization_rec.PAYDEX_THREE_MONTHS_AGO is null OR
8208: p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR) AND
8209: ( p_organization_rec.FAILURE_SCORE is null OR
8210: p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR ) AND
8211: ( p_organization_rec.FAILURE_SCORE_AGE is null OR
8212: p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM) AND

Line 8210: p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR ) AND

8206: p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR) AND
8207: ( p_organization_rec.PAYDEX_THREE_MONTHS_AGO is null OR
8208: p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR) AND
8209: ( p_organization_rec.FAILURE_SCORE is null OR
8210: p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR ) AND
8211: ( p_organization_rec.FAILURE_SCORE_AGE is null OR
8212: p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM) AND
8213: ( p_organization_rec.FAILURE_SCORE_CLASS is null OR
8214: p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM) AND

Line 8212: p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM) AND

8208: p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR) AND
8209: ( p_organization_rec.FAILURE_SCORE is null OR
8210: p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR ) AND
8211: ( p_organization_rec.FAILURE_SCORE_AGE is null OR
8212: p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM) AND
8213: ( p_organization_rec.FAILURE_SCORE_CLASS is null OR
8214: p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8215: ( p_organization_rec.FAILURE_SCORE_COMMENTARY is null OR
8216: p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND

Line 8214: p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM) AND

8210: p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR ) AND
8211: ( p_organization_rec.FAILURE_SCORE_AGE is null OR
8212: p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM) AND
8213: ( p_organization_rec.FAILURE_SCORE_CLASS is null OR
8214: p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8215: ( p_organization_rec.FAILURE_SCORE_COMMENTARY is null OR
8216: p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8217: ( p_organization_rec.FAILURE_SCORE_COMMENTARY2 is null OR
8218: p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND

Line 8216: p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND

8212: p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM) AND
8213: ( p_organization_rec.FAILURE_SCORE_CLASS is null OR
8214: p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8215: ( p_organization_rec.FAILURE_SCORE_COMMENTARY is null OR
8216: p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8217: ( p_organization_rec.FAILURE_SCORE_COMMENTARY2 is null OR
8218: p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8219: ( p_organization_rec.FAILURE_SCORE_COMMENTARY3 is null OR
8220: p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND

Line 8218: p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND

8214: p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM) AND
8215: ( p_organization_rec.FAILURE_SCORE_COMMENTARY is null OR
8216: p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8217: ( p_organization_rec.FAILURE_SCORE_COMMENTARY2 is null OR
8218: p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8219: ( p_organization_rec.FAILURE_SCORE_COMMENTARY3 is null OR
8220: p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8221: ( p_organization_rec.FAILURE_SCORE_COMMENTARY4 is null OR
8222: p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND

Line 8220: p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND

8216: p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR) AND
8217: ( p_organization_rec.FAILURE_SCORE_COMMENTARY2 is null OR
8218: p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8219: ( p_organization_rec.FAILURE_SCORE_COMMENTARY3 is null OR
8220: p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8221: ( p_organization_rec.FAILURE_SCORE_COMMENTARY4 is null OR
8222: p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8223: ( p_organization_rec.FAILURE_SCORE_COMMENTARY5 is null OR
8224: p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND

Line 8222: p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND

8218: p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR) AND
8219: ( p_organization_rec.FAILURE_SCORE_COMMENTARY3 is null OR
8220: p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8221: ( p_organization_rec.FAILURE_SCORE_COMMENTARY4 is null OR
8222: p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8223: ( p_organization_rec.FAILURE_SCORE_COMMENTARY5 is null OR
8224: p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8225: ( p_organization_rec.FAILURE_SCORE_COMMENTARY6 is null OR
8226: p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND

Line 8224: p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND

8220: p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR) AND
8221: ( p_organization_rec.FAILURE_SCORE_COMMENTARY4 is null OR
8222: p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8223: ( p_organization_rec.FAILURE_SCORE_COMMENTARY5 is null OR
8224: p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8225: ( p_organization_rec.FAILURE_SCORE_COMMENTARY6 is null OR
8226: p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8227: ( p_organization_rec.FAILURE_SCORE_COMMENTARY7 is null OR
8228: p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND

Line 8226: p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND

8222: p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR) AND
8223: ( p_organization_rec.FAILURE_SCORE_COMMENTARY5 is null OR
8224: p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8225: ( p_organization_rec.FAILURE_SCORE_COMMENTARY6 is null OR
8226: p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8227: ( p_organization_rec.FAILURE_SCORE_COMMENTARY7 is null OR
8228: p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8229: ( p_organization_rec.FAILURE_SCORE_COMMENTARY8 is null OR
8230: p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND

Line 8228: p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND

8224: p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR) AND
8225: ( p_organization_rec.FAILURE_SCORE_COMMENTARY6 is null OR
8226: p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8227: ( p_organization_rec.FAILURE_SCORE_COMMENTARY7 is null OR
8228: p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8229: ( p_organization_rec.FAILURE_SCORE_COMMENTARY8 is null OR
8230: p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8231: ( p_organization_rec.FAILURE_SCORE_COMMENTARY9 is null OR
8232: p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND

Line 8230: p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND

8226: p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR) AND
8227: ( p_organization_rec.FAILURE_SCORE_COMMENTARY7 is null OR
8228: p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8229: ( p_organization_rec.FAILURE_SCORE_COMMENTARY8 is null OR
8230: p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8231: ( p_organization_rec.FAILURE_SCORE_COMMENTARY9 is null OR
8232: p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8233: ( p_organization_rec.FAILURE_SCORE_COMMENTARY10 is null OR
8234: p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND

Line 8232: p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND

8228: p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR) AND
8229: ( p_organization_rec.FAILURE_SCORE_COMMENTARY8 is null OR
8230: p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8231: ( p_organization_rec.FAILURE_SCORE_COMMENTARY9 is null OR
8232: p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8233: ( p_organization_rec.FAILURE_SCORE_COMMENTARY10 is null OR
8234: p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8235: ( p_organization_rec.FAILURE_SCORE_DATE is null OR
8236: p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE) AND

Line 8234: p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND

8230: p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR) AND
8231: ( p_organization_rec.FAILURE_SCORE_COMMENTARY9 is null OR
8232: p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8233: ( p_organization_rec.FAILURE_SCORE_COMMENTARY10 is null OR
8234: p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8235: ( p_organization_rec.FAILURE_SCORE_DATE is null OR
8236: p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE) AND
8237: ( p_organization_rec.FAILURE_SCORE_INCD_DEFAULT is null OR
8238: p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND

Line 8236: p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE) AND

8232: p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR) AND
8233: ( p_organization_rec.FAILURE_SCORE_COMMENTARY10 is null OR
8234: p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8235: ( p_organization_rec.FAILURE_SCORE_DATE is null OR
8236: p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE) AND
8237: ( p_organization_rec.FAILURE_SCORE_INCD_DEFAULT is null OR
8238: p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8239: ( p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE is null OR
8240: p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM) AND

Line 8238: p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND

8234: p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR) AND
8235: ( p_organization_rec.FAILURE_SCORE_DATE is null OR
8236: p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE) AND
8237: ( p_organization_rec.FAILURE_SCORE_INCD_DEFAULT is null OR
8238: p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8239: ( p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE is null OR
8240: p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM) AND
8241: ( p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE is null OR
8242: p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR) AND

Line 8240: p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM) AND

8236: p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE) AND
8237: ( p_organization_rec.FAILURE_SCORE_INCD_DEFAULT is null OR
8238: p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8239: ( p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE is null OR
8240: p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM) AND
8241: ( p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE is null OR
8242: p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR) AND
8243: ( p_organization_rec.GLOBAL_FAILURE_SCORE is null OR
8244: p_organization_rec.GLOBAL_FAILURE_SCORE = FND_API.G_MISS_CHAR)

Line 8242: p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR) AND

8238: p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM) AND
8239: ( p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE is null OR
8240: p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM) AND
8241: ( p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE is null OR
8242: p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR) AND
8243: ( p_organization_rec.GLOBAL_FAILURE_SCORE is null OR
8244: p_organization_rec.GLOBAL_FAILURE_SCORE = FND_API.G_MISS_CHAR)
8245: ) ) OR
8246: ( p_create_update_flag = 'U' AND

Line 8244: p_organization_rec.GLOBAL_FAILURE_SCORE = FND_API.G_MISS_CHAR)

8240: p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM) AND
8241: ( p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE is null OR
8242: p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR) AND
8243: ( p_organization_rec.GLOBAL_FAILURE_SCORE is null OR
8244: p_organization_rec.GLOBAL_FAILURE_SCORE = FND_API.G_MISS_CHAR)
8245: ) ) OR
8246: ( p_create_update_flag = 'U' AND
8247: ( p_organization_rec.AVG_HIGH_CREDIT is not null OR
8248: p_organization_rec.CREDIT_SCORE is not null OR

Line 8537: IF x_return_status <> fnd_api.g_ret_sts_success THEN

8533: p_msg_level=>fnd_log.level_statement);
8534: END IF;
8535: END IF;
8536:
8537: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8538: RAISE fnd_api.g_exc_error;
8539: END IF;
8540: END IF;
8541:

Line 8538: RAISE fnd_api.g_exc_error;

8534: END IF;
8535: END IF;
8536:
8537: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8538: RAISE fnd_api.g_exc_error;
8539: END IF;
8540: END IF;
8541:
8542: END populate_credit_rating;

Line 8646: IF p_organization_rec.AVG_HIGH_CREDIT = FND_API.G_MISS_NUM THEN

8642: 'to CREDIT_RATINGS_REC_TYPE for update(+)',
8643: p_msg_level=>fnd_log.level_procedure);
8644: END IF;
8645:
8646: IF p_organization_rec.AVG_HIGH_CREDIT = FND_API.G_MISS_NUM THEN
8647: x_credit_rating_rec.AVG_HIGH_CREDIT := NULL;
8648: ELSIF p_organization_rec.AVG_HIGH_CREDIT is not null THEN
8649: x_credit_rating_rec.AVG_HIGH_CREDIT := p_organization_rec.AVG_HIGH_CREDIT;
8650: END IF;

Line 8652: IF p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR THEN

8648: ELSIF p_organization_rec.AVG_HIGH_CREDIT is not null THEN
8649: x_credit_rating_rec.AVG_HIGH_CREDIT := p_organization_rec.AVG_HIGH_CREDIT;
8650: END IF;
8651:
8652: IF p_organization_rec.CREDIT_SCORE = FND_API.G_MISS_CHAR THEN
8653: x_credit_rating_rec.CREDIT_SCORE := NULL;
8654: ELSIF p_organization_rec.CREDIT_SCORE is not null THEN
8655: x_credit_rating_rec.CREDIT_SCORE := p_organization_rec.CREDIT_SCORE;
8656: END IF;

Line 8658: IF p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM THEN

8654: ELSIF p_organization_rec.CREDIT_SCORE is not null THEN
8655: x_credit_rating_rec.CREDIT_SCORE := p_organization_rec.CREDIT_SCORE;
8656: END IF;
8657:
8658: IF p_organization_rec.CREDIT_SCORE_AGE = FND_API.G_MISS_NUM THEN
8659: x_credit_rating_rec.CREDIT_SCORE_AGE := NULL;
8660: ELSIF p_organization_rec.CREDIT_SCORE_AGE is not null THEN
8661: x_credit_rating_rec.CREDIT_SCORE_AGE := p_organization_rec.CREDIT_SCORE_AGE;
8662: END IF;

Line 8664: IF p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM THEN

8660: ELSIF p_organization_rec.CREDIT_SCORE_AGE is not null THEN
8661: x_credit_rating_rec.CREDIT_SCORE_AGE := p_organization_rec.CREDIT_SCORE_AGE;
8662: END IF;
8663:
8664: IF p_organization_rec.CREDIT_SCORE_CLASS = FND_API.G_MISS_NUM THEN
8665: x_credit_rating_rec.CREDIT_SCORE_CLASS := NULL;
8666: ELSIF p_organization_rec.CREDIT_SCORE_CLASS is not null THEN
8667: x_credit_rating_rec.CREDIT_SCORE_CLASS := p_organization_rec.CREDIT_SCORE_CLASS;
8668: END IF;

Line 8670: IF p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR THEN

8666: ELSIF p_organization_rec.CREDIT_SCORE_CLASS is not null THEN
8667: x_credit_rating_rec.CREDIT_SCORE_CLASS := p_organization_rec.CREDIT_SCORE_CLASS;
8668: END IF;
8669:
8670: IF p_organization_rec.CREDIT_SCORE_COMMENTARY = FND_API.G_MISS_CHAR THEN
8671: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY := NULL;
8672: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY is not null THEN
8673: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY := p_organization_rec.CREDIT_SCORE_COMMENTARY;
8674: END IF;

Line 8676: IF p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR THEN

8672: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY is not null THEN
8673: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY := p_organization_rec.CREDIT_SCORE_COMMENTARY;
8674: END IF;
8675:
8676: IF p_organization_rec.CREDIT_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR THEN
8677: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY2 := NULL;
8678: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY2 is not null THEN
8679: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY2 := p_organization_rec.CREDIT_SCORE_COMMENTARY2;
8680: END IF;

Line 8682: IF p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR THEN

8678: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY2 is not null THEN
8679: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY2 := p_organization_rec.CREDIT_SCORE_COMMENTARY2;
8680: END IF;
8681:
8682: IF p_organization_rec.CREDIT_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR THEN
8683: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY3 := NULL;
8684: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY3 is not null THEN
8685: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY3 := p_organization_rec.CREDIT_SCORE_COMMENTARY3;
8686: END IF;

Line 8688: IF p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR THEN

8684: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY3 is not null THEN
8685: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY3 := p_organization_rec.CREDIT_SCORE_COMMENTARY3;
8686: END IF;
8687:
8688: IF p_organization_rec.CREDIT_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR THEN
8689: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY4 := NULL;
8690: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY4 is not null THEN
8691: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY4 := p_organization_rec.CREDIT_SCORE_COMMENTARY4;
8692: END IF;

Line 8694: IF p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR THEN

8690: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY4 is not null THEN
8691: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY4 := p_organization_rec.CREDIT_SCORE_COMMENTARY4;
8692: END IF;
8693:
8694: IF p_organization_rec.CREDIT_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR THEN
8695: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY5 := NULL;
8696: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY5 is not null THEN
8697: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY5 := p_organization_rec.CREDIT_SCORE_COMMENTARY5;
8698: END IF;

Line 8700: IF p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR THEN

8696: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY5 is not null THEN
8697: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY5 := p_organization_rec.CREDIT_SCORE_COMMENTARY5;
8698: END IF;
8699:
8700: IF p_organization_rec.CREDIT_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR THEN
8701: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY6 := NULL;
8702: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY6 is not null THEN
8703: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY6 := p_organization_rec.CREDIT_SCORE_COMMENTARY6;
8704: END IF;

Line 8706: IF p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR THEN

8702: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY6 is not null THEN
8703: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY6 := p_organization_rec.CREDIT_SCORE_COMMENTARY6;
8704: END IF;
8705:
8706: IF p_organization_rec.CREDIT_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR THEN
8707: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY7 := NULL;
8708: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY7 is not null THEN
8709: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY7 := p_organization_rec.CREDIT_SCORE_COMMENTARY7;
8710: END IF;

Line 8712: IF p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR THEN

8708: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY7 is not null THEN
8709: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY7 := p_organization_rec.CREDIT_SCORE_COMMENTARY7;
8710: END IF;
8711:
8712: IF p_organization_rec.CREDIT_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR THEN
8713: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY8 := NULL;
8714: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY8 is not null THEN
8715: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY8 := p_organization_rec.CREDIT_SCORE_COMMENTARY8;
8716: END IF;

Line 8718: IF p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR THEN

8714: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY8 is not null THEN
8715: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY8 := p_organization_rec.CREDIT_SCORE_COMMENTARY8;
8716: END IF;
8717:
8718: IF p_organization_rec.CREDIT_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR THEN
8719: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY9 := NULL;
8720: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY9 is not null THEN
8721: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY9 := p_organization_rec.CREDIT_SCORE_COMMENTARY9;
8722: END IF;

Line 8724: IF p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR THEN

8720: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY9 is not null THEN
8721: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY9 := p_organization_rec.CREDIT_SCORE_COMMENTARY9;
8722: END IF;
8723:
8724: IF p_organization_rec.CREDIT_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR THEN
8725: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY10 := NULL;
8726: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY10 is not null THEN
8727: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY10 := p_organization_rec.CREDIT_SCORE_COMMENTARY10;
8728: END IF;

Line 8730: IF p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE THEN

8726: ELSIF p_organization_rec.CREDIT_SCORE_COMMENTARY10 is not null THEN
8727: x_credit_rating_rec.CREDIT_SCORE_COMMENTARY10 := p_organization_rec.CREDIT_SCORE_COMMENTARY10;
8728: END IF;
8729:
8730: IF p_organization_rec.CREDIT_SCORE_DATE = FND_API.G_MISS_DATE THEN
8731: x_credit_rating_rec.CREDIT_SCORE_DATE := NULL;
8732: ELSIF p_organization_rec.CREDIT_SCORE_DATE is not null THEN
8733: x_credit_rating_rec.CREDIT_SCORE_DATE := p_organization_rec.CREDIT_SCORE_DATE;
8734: END IF;

Line 8736: IF p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM THEN

8732: ELSIF p_organization_rec.CREDIT_SCORE_DATE is not null THEN
8733: x_credit_rating_rec.CREDIT_SCORE_DATE := p_organization_rec.CREDIT_SCORE_DATE;
8734: END IF;
8735:
8736: IF p_organization_rec.CREDIT_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM THEN
8737: x_credit_rating_rec.CREDIT_SCORE_INCD_DEFAULT := NULL;
8738: ELSIF p_organization_rec.CREDIT_SCORE_INCD_DEFAULT is not null THEN
8739: x_credit_rating_rec.CREDIT_SCORE_INCD_DEFAULT := p_organization_rec.CREDIT_SCORE_INCD_DEFAULT;
8740: END IF;

Line 8742: IF p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM THEN

8738: ELSIF p_organization_rec.CREDIT_SCORE_INCD_DEFAULT is not null THEN
8739: x_credit_rating_rec.CREDIT_SCORE_INCD_DEFAULT := p_organization_rec.CREDIT_SCORE_INCD_DEFAULT;
8740: END IF;
8741:
8742: IF p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE = FND_API.G_MISS_NUM THEN
8743: x_credit_rating_rec.CREDIT_SCORE_NATL_PERCENTILE := NULL;
8744: ELSIF p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE is not null THEN
8745: x_credit_rating_rec.CREDIT_SCORE_NATL_PERCENTILE := p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE;
8746: END IF;

Line 8748: IF p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR THEN

8744: ELSIF p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE is not null THEN
8745: x_credit_rating_rec.CREDIT_SCORE_NATL_PERCENTILE := p_organization_rec.CREDIT_SCORE_NATL_PERCENTILE;
8746: END IF;
8747:
8748: IF p_organization_rec.DB_RATING = FND_API.G_MISS_CHAR THEN
8749: x_credit_rating_rec.RATING := NULL;
8750: ELSIF p_organization_rec.DB_RATING is not null THEN
8751: x_credit_rating_rec.RATING := p_organization_rec.DB_RATING;
8752: END IF;

Line 8754: IF p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR THEN

8750: ELSIF p_organization_rec.DB_RATING is not null THEN
8751: x_credit_rating_rec.RATING := p_organization_rec.DB_RATING;
8752: END IF;
8753:
8754: IF p_organization_rec.DEBARMENT_IND = FND_API.G_MISS_CHAR THEN
8755: x_credit_rating_rec.DEBARMENT_IND := NULL;
8756: ELSIF p_organization_rec.DEBARMENT_IND is not null THEN
8757: x_credit_rating_rec.DEBARMENT_IND := p_organization_rec.DEBARMENT_IND;
8758: END IF;

Line 8760: IF p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM THEN

8756: ELSIF p_organization_rec.DEBARMENT_IND is not null THEN
8757: x_credit_rating_rec.DEBARMENT_IND := p_organization_rec.DEBARMENT_IND;
8758: END IF;
8759:
8760: IF p_organization_rec.DEBARMENTS_COUNT = FND_API.G_MISS_NUM THEN
8761: x_credit_rating_rec.DEBARMENTS_COUNT := NULL;
8762: ELSIF p_organization_rec.DEBARMENTS_COUNT is not null THEN
8763: x_credit_rating_rec.DEBARMENTS_COUNT := p_organization_rec.DEBARMENTS_COUNT;
8764: END IF;

Line 8766: IF p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE THEN

8762: ELSIF p_organization_rec.DEBARMENTS_COUNT is not null THEN
8763: x_credit_rating_rec.DEBARMENTS_COUNT := p_organization_rec.DEBARMENTS_COUNT;
8764: END IF;
8765:
8766: IF p_organization_rec.DEBARMENTS_DATE = FND_API.G_MISS_DATE THEN
8767: x_credit_rating_rec.DEBARMENTS_DATE := NULL;
8768: ELSIF p_organization_rec.DEBARMENTS_DATE is not null THEN
8769: x_credit_rating_rec.DEBARMENTS_DATE := p_organization_rec.DEBARMENTS_DATE;
8770: END IF;

Line 8772: IF p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM THEN

8768: ELSIF p_organization_rec.DEBARMENTS_DATE is not null THEN
8769: x_credit_rating_rec.DEBARMENTS_DATE := p_organization_rec.DEBARMENTS_DATE;
8770: END IF;
8771:
8772: IF p_organization_rec.HIGH_CREDIT = FND_API.G_MISS_NUM THEN
8773: x_credit_rating_rec.HIGH_CREDIT := NULL;
8774: ELSIF p_organization_rec.HIGH_CREDIT is not null THEN
8775: x_credit_rating_rec.HIGH_CREDIT := p_organization_rec.HIGH_CREDIT;
8776: END IF;

Line 8778: IF p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR THEN

8774: ELSIF p_organization_rec.HIGH_CREDIT is not null THEN
8775: x_credit_rating_rec.HIGH_CREDIT := p_organization_rec.HIGH_CREDIT;
8776: END IF;
8777:
8778: IF p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE = FND_API.G_MISS_CHAR THEN
8779: x_credit_rating_rec.MAXIMUM_CREDIT_CURRENCY_CODE := NULL;
8780: ELSIF p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE is not null THEN
8781: x_credit_rating_rec.MAXIMUM_CREDIT_CURRENCY_CODE := p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE;
8782: END IF;

Line 8784: IF p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM THEN

8780: ELSIF p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE is not null THEN
8781: x_credit_rating_rec.MAXIMUM_CREDIT_CURRENCY_CODE := p_organization_rec.MAXIMUM_CREDIT_CURRENCY_CODE;
8782: END IF;
8783:
8784: IF p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION = FND_API.G_MISS_NUM THEN
8785: x_credit_rating_rec.MAXIMUM_CREDIT_RCMD := NULL;
8786: ELSIF p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION is not null THEN
8787: x_credit_rating_rec.MAXIMUM_CREDIT_RCMD := p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION;
8788: END IF;

Line 8790: IF p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR THEN

8786: ELSIF p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION is not null THEN
8787: x_credit_rating_rec.MAXIMUM_CREDIT_RCMD := p_organization_rec.MAXIMUM_CREDIT_RECOMMENDATION;
8788: END IF;
8789:
8790: IF p_organization_rec.PAYDEX_NORM = FND_API.G_MISS_CHAR THEN
8791: x_credit_rating_rec.PAYDEX_NORM := NULL;
8792: ELSIF p_organization_rec.PAYDEX_NORM is not null THEN
8793: x_credit_rating_rec.PAYDEX_NORM := p_organization_rec.PAYDEX_NORM;
8794: END IF;

Line 8796: IF p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR THEN

8792: ELSIF p_organization_rec.PAYDEX_NORM is not null THEN
8793: x_credit_rating_rec.PAYDEX_NORM := p_organization_rec.PAYDEX_NORM;
8794: END IF;
8795:
8796: IF p_organization_rec.PAYDEX_SCORE = FND_API.G_MISS_CHAR THEN
8797: x_credit_rating_rec.PAYDEX_SCORE := NULL;
8798: ELSIF p_organization_rec.PAYDEX_SCORE is not null THEN
8799: x_credit_rating_rec.PAYDEX_SCORE := p_organization_rec.PAYDEX_SCORE;
8800: END IF;

Line 8802: IF p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR THEN

8798: ELSIF p_organization_rec.PAYDEX_SCORE is not null THEN
8799: x_credit_rating_rec.PAYDEX_SCORE := p_organization_rec.PAYDEX_SCORE;
8800: END IF;
8801:
8802: IF p_organization_rec.PAYDEX_THREE_MONTHS_AGO = FND_API.G_MISS_CHAR THEN
8803: x_credit_rating_rec.PAYDEX_THREE_MONTHS_AGO := NULL;
8804: ELSIF p_organization_rec.PAYDEX_THREE_MONTHS_AGO is not null THEN
8805: x_credit_rating_rec.PAYDEX_THREE_MONTHS_AGO := p_organization_rec.PAYDEX_THREE_MONTHS_AGO;
8806: END IF;

Line 8808: IF p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR THEN

8804: ELSIF p_organization_rec.PAYDEX_THREE_MONTHS_AGO is not null THEN
8805: x_credit_rating_rec.PAYDEX_THREE_MONTHS_AGO := p_organization_rec.PAYDEX_THREE_MONTHS_AGO;
8806: END IF;
8807:
8808: IF p_organization_rec.FAILURE_SCORE = FND_API.G_MISS_CHAR THEN
8809: x_credit_rating_rec.FAILURE_SCORE := NULL;
8810: ELSIF p_organization_rec.FAILURE_SCORE is not null THEN
8811: x_credit_rating_rec.FAILURE_SCORE := p_organization_rec.FAILURE_SCORE;
8812: END IF;

Line 8814: IF p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM THEN

8810: ELSIF p_organization_rec.FAILURE_SCORE is not null THEN
8811: x_credit_rating_rec.FAILURE_SCORE := p_organization_rec.FAILURE_SCORE;
8812: END IF;
8813:
8814: IF p_organization_rec.FAILURE_SCORE_AGE = FND_API.G_MISS_NUM THEN
8815: x_credit_rating_rec.FAILURE_SCORE_AGE := NULL;
8816: ELSIF p_organization_rec.FAILURE_SCORE_AGE is not null THEN
8817: x_credit_rating_rec.FAILURE_SCORE_AGE := p_organization_rec.FAILURE_SCORE_AGE;
8818: END IF;

Line 8820: IF p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM THEN

8816: ELSIF p_organization_rec.FAILURE_SCORE_AGE is not null THEN
8817: x_credit_rating_rec.FAILURE_SCORE_AGE := p_organization_rec.FAILURE_SCORE_AGE;
8818: END IF;
8819:
8820: IF p_organization_rec.FAILURE_SCORE_CLASS = FND_API.G_MISS_NUM THEN
8821: x_credit_rating_rec.FAILURE_SCORE_CLASS := NULL;
8822: ELSIF p_organization_rec.FAILURE_SCORE_CLASS is not null THEN
8823: x_credit_rating_rec.FAILURE_SCORE_CLASS := p_organization_rec.FAILURE_SCORE_CLASS;
8824: END IF;

Line 8826: IF p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR THEN

8822: ELSIF p_organization_rec.FAILURE_SCORE_CLASS is not null THEN
8823: x_credit_rating_rec.FAILURE_SCORE_CLASS := p_organization_rec.FAILURE_SCORE_CLASS;
8824: END IF;
8825:
8826: IF p_organization_rec.FAILURE_SCORE_COMMENTARY = FND_API.G_MISS_CHAR THEN
8827: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY := NULL;
8828: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY is not null THEN
8829: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY := p_organization_rec.FAILURE_SCORE_COMMENTARY;
8830: END IF;

Line 8832: IF p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR THEN

8828: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY is not null THEN
8829: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY := p_organization_rec.FAILURE_SCORE_COMMENTARY;
8830: END IF;
8831:
8832: IF p_organization_rec.FAILURE_SCORE_COMMENTARY2 = FND_API.G_MISS_CHAR THEN
8833: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY2 := NULL;
8834: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY2 is not null THEN
8835: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY2 := p_organization_rec.FAILURE_SCORE_COMMENTARY2;
8836: END IF;

Line 8838: IF p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR THEN

8834: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY2 is not null THEN
8835: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY2 := p_organization_rec.FAILURE_SCORE_COMMENTARY2;
8836: END IF;
8837:
8838: IF p_organization_rec.FAILURE_SCORE_COMMENTARY3 = FND_API.G_MISS_CHAR THEN
8839: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY3 := NULL;
8840: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY3 is not null THEN
8841: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY3 := p_organization_rec.FAILURE_SCORE_COMMENTARY3;
8842: END IF;

Line 8844: IF p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR THEN

8840: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY3 is not null THEN
8841: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY3 := p_organization_rec.FAILURE_SCORE_COMMENTARY3;
8842: END IF;
8843:
8844: IF p_organization_rec.FAILURE_SCORE_COMMENTARY4 = FND_API.G_MISS_CHAR THEN
8845: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY4 := NULL;
8846: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY4 is not null THEN
8847: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY4 := p_organization_rec.FAILURE_SCORE_COMMENTARY4;
8848: END IF;

Line 8850: IF p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR THEN

8846: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY4 is not null THEN
8847: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY4 := p_organization_rec.FAILURE_SCORE_COMMENTARY4;
8848: END IF;
8849:
8850: IF p_organization_rec.FAILURE_SCORE_COMMENTARY5 = FND_API.G_MISS_CHAR THEN
8851: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY5 := NULL;
8852: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY5 is not null THEN
8853: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY5 := p_organization_rec.FAILURE_SCORE_COMMENTARY5;
8854: END IF;

Line 8856: IF p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR THEN

8852: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY5 is not null THEN
8853: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY5 := p_organization_rec.FAILURE_SCORE_COMMENTARY5;
8854: END IF;
8855:
8856: IF p_organization_rec.FAILURE_SCORE_COMMENTARY6 = FND_API.G_MISS_CHAR THEN
8857: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY6 := NULL;
8858: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY6 is not null THEN
8859: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY6 := p_organization_rec.FAILURE_SCORE_COMMENTARY6;
8860: END IF;

Line 8862: IF p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR THEN

8858: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY6 is not null THEN
8859: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY6 := p_organization_rec.FAILURE_SCORE_COMMENTARY6;
8860: END IF;
8861:
8862: IF p_organization_rec.FAILURE_SCORE_COMMENTARY7 = FND_API.G_MISS_CHAR THEN
8863: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY7 := NULL;
8864: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY7 is not null THEN
8865: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY7 := p_organization_rec.FAILURE_SCORE_COMMENTARY7;
8866: END IF;

Line 8868: IF p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR THEN

8864: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY7 is not null THEN
8865: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY7 := p_organization_rec.FAILURE_SCORE_COMMENTARY7;
8866: END IF;
8867:
8868: IF p_organization_rec.FAILURE_SCORE_COMMENTARY8 = FND_API.G_MISS_CHAR THEN
8869: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY8 := NULL;
8870: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY8 is not null THEN
8871: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY8 := p_organization_rec.FAILURE_SCORE_COMMENTARY8;
8872: END IF;

Line 8874: IF p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR THEN

8870: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY8 is not null THEN
8871: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY8 := p_organization_rec.FAILURE_SCORE_COMMENTARY8;
8872: END IF;
8873:
8874: IF p_organization_rec.FAILURE_SCORE_COMMENTARY9 = FND_API.G_MISS_CHAR THEN
8875: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY9 := NULL;
8876: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY9 is not null THEN
8877: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY9 := p_organization_rec.FAILURE_SCORE_COMMENTARY9;
8878: END IF;

Line 8880: IF p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR THEN

8876: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY9 is not null THEN
8877: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY9 := p_organization_rec.FAILURE_SCORE_COMMENTARY9;
8878: END IF;
8879:
8880: IF p_organization_rec.FAILURE_SCORE_COMMENTARY10 = FND_API.G_MISS_CHAR THEN
8881: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY10 := NULL;
8882: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY10 is not null THEN
8883: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY10 := p_organization_rec.FAILURE_SCORE_COMMENTARY10;
8884: END IF;

Line 8886: IF p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE THEN

8882: ELSIF p_organization_rec.FAILURE_SCORE_COMMENTARY10 is not null THEN
8883: x_credit_rating_rec.FAILURE_SCORE_COMMENTARY10 := p_organization_rec.FAILURE_SCORE_COMMENTARY10;
8884: END IF;
8885:
8886: IF p_organization_rec.FAILURE_SCORE_DATE = FND_API.G_MISS_DATE THEN
8887: x_credit_rating_rec.FAILURE_SCORE_DATE := NULL;
8888: ELSIF p_organization_rec.FAILURE_SCORE_DATE is not null THEN
8889: x_credit_rating_rec.FAILURE_SCORE_DATE := p_organization_rec.FAILURE_SCORE_DATE;
8890: END IF;

Line 8892: IF p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM THEN

8888: ELSIF p_organization_rec.FAILURE_SCORE_DATE is not null THEN
8889: x_credit_rating_rec.FAILURE_SCORE_DATE := p_organization_rec.FAILURE_SCORE_DATE;
8890: END IF;
8891:
8892: IF p_organization_rec.FAILURE_SCORE_INCD_DEFAULT = FND_API.G_MISS_NUM THEN
8893: x_credit_rating_rec.FAILURE_SCORE_INCD_DEFAULT := NULL;
8894: ELSIF p_organization_rec.FAILURE_SCORE_INCD_DEFAULT is not null THEN
8895: x_credit_rating_rec.FAILURE_SCORE_INCD_DEFAULT := p_organization_rec.FAILURE_SCORE_INCD_DEFAULT;
8896: END IF;

Line 8898: IF p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM THEN

8894: ELSIF p_organization_rec.FAILURE_SCORE_INCD_DEFAULT is not null THEN
8895: x_credit_rating_rec.FAILURE_SCORE_INCD_DEFAULT := p_organization_rec.FAILURE_SCORE_INCD_DEFAULT;
8896: END IF;
8897:
8898: IF p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE = FND_API.G_MISS_NUM THEN
8899: x_credit_rating_rec.FAILURE_SCORE_NATNL_PERCENTILE := NULL;
8900: ELSIF p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE is not null THEN
8901: x_credit_rating_rec.FAILURE_SCORE_NATNL_PERCENTILE := p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE;
8902: END IF;

Line 8904: IF p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR THEN

8900: ELSIF p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE is not null THEN
8901: x_credit_rating_rec.FAILURE_SCORE_NATNL_PERCENTILE := p_organization_rec.FAILURE_SCORE_NATNL_PERCENTILE;
8902: END IF;
8903:
8904: IF p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE = FND_API.G_MISS_CHAR THEN
8905: x_credit_rating_rec.FAILURE_SCORE_OVERRIDE_CODE := NULL;
8906: ELSIF p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE is not null THEN
8907: x_credit_rating_rec.FAILURE_SCORE_OVERRIDE_CODE := p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE;
8908: END IF;

Line 8910: IF p_organization_rec.GLOBAL_FAILURE_SCORE = FND_API.G_MISS_CHAR THEN

8906: ELSIF p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE is not null THEN
8907: x_credit_rating_rec.FAILURE_SCORE_OVERRIDE_CODE := p_organization_rec.FAILURE_SCORE_OVERRIDE_CODE;
8908: END IF;
8909:
8910: IF p_organization_rec.GLOBAL_FAILURE_SCORE = FND_API.G_MISS_CHAR THEN
8911: x_credit_rating_rec.GLOBAL_FAILURE_SCORE := NULL;
8912: ELSIF p_organization_rec.GLOBAL_FAILURE_SCORE is not null THEN
8913: x_credit_rating_rec.GLOBAL_FAILURE_SCORE := p_organization_rec.GLOBAL_FAILURE_SCORE;
8914: END IF;

Line 9003: IF p_new_value IS NOT NULL AND p_new_value <> FND_API.G_MISS_CHAR THEN

8999:
9000: FUNCTION isModified(p_old_value IN VARCHAR2,p_new_value IN VARCHAR2) RETURN BOOLEAN
9001: IS
9002: BEGIN
9003: IF p_new_value IS NOT NULL AND p_new_value <> FND_API.G_MISS_CHAR THEN
9004: RETURN NVL(NOT (p_old_value=p_new_value),TRUE);
9005: ELSIF (p_old_value IS NOT NULL AND p_old_value <> FND_API.G_MISS_CHAR)
9006: AND p_new_value = FND_API.G_MISS_CHAR THEN
9007: RETURN TRUE;

Line 9005: ELSIF (p_old_value IS NOT NULL AND p_old_value <> FND_API.G_MISS_CHAR)

9001: IS
9002: BEGIN
9003: IF p_new_value IS NOT NULL AND p_new_value <> FND_API.G_MISS_CHAR THEN
9004: RETURN NVL(NOT (p_old_value=p_new_value),TRUE);
9005: ELSIF (p_old_value IS NOT NULL AND p_old_value <> FND_API.G_MISS_CHAR)
9006: AND p_new_value = FND_API.G_MISS_CHAR THEN
9007: RETURN TRUE;
9008: ELSE
9009: RETURN FALSE;

Line 9006: AND p_new_value = FND_API.G_MISS_CHAR THEN

9002: BEGIN
9003: IF p_new_value IS NOT NULL AND p_new_value <> FND_API.G_MISS_CHAR THEN
9004: RETURN NVL(NOT (p_old_value=p_new_value),TRUE);
9005: ELSIF (p_old_value IS NOT NULL AND p_old_value <> FND_API.G_MISS_CHAR)
9006: AND p_new_value = FND_API.G_MISS_CHAR THEN
9007: RETURN TRUE;
9008: ELSE
9009: RETURN FALSE;
9010: END IF;