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

Line 48: IF (p_col_val = FND_API.G_MISS_CHAR) THEN

44: p_miss_allowed_in_u IN BOOLEAN,
45: x_return_status IN OUT NOCOPY VARCHAR2)
46: IS
47: BEGIN
48: IF (p_col_val = FND_API.G_MISS_CHAR) THEN
49: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
50: fnd_message.set_token('COLUMN', p_col_name);
51: fnd_msg_pub.add;
52: x_return_status := fnd_api.g_ret_sts_error;

Line 52: x_return_status := fnd_api.g_ret_sts_error;

48: IF (p_col_val = FND_API.G_MISS_CHAR) THEN
49: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
50: fnd_message.set_token('COLUMN', p_col_name);
51: fnd_msg_pub.add;
52: x_return_status := fnd_api.g_ret_sts_error;
53: RETURN;
54: END IF;
55:
56: IF (create_update_flag = 'C') THEN

Line 63: x_return_status := fnd_api.g_ret_sts_error;

59: THEN
60: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
61: fnd_message.set_token('COLUMN', p_col_name);
62: fnd_msg_pub.add;
63: x_return_status := fnd_api.g_ret_sts_error;
64: END IF;
65: ELSE
66: IF ((NOT p_miss_allowed_in_u) AND
67: p_col_val IS NULL )

Line 72: x_return_status := fnd_api.g_ret_sts_error;

68: THEN
69: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
70: fnd_message.set_token('COLUMN', p_col_name);
71: fnd_msg_pub.add;
72: x_return_status := fnd_api.g_ret_sts_error;
73: END IF;
74: END IF;
75: END check_mandatory_str_col;
76:

Line 94: IF (p_col_val = FND_API.G_MISS_DATE) THEN

90: p_miss_allowed_in_u IN BOOLEAN,
91: x_return_status IN OUT NOCOPY VARCHAR2)
92: IS
93: BEGIN
94: IF (p_col_val = FND_API.G_MISS_DATE) THEN
95: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
96: fnd_message.set_token('COLUMN', p_col_name);
97: fnd_msg_pub.add;
98: x_return_status := fnd_api.g_ret_sts_error;

Line 98: x_return_status := fnd_api.g_ret_sts_error;

94: IF (p_col_val = FND_API.G_MISS_DATE) THEN
95: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
96: fnd_message.set_token('COLUMN', p_col_name);
97: fnd_msg_pub.add;
98: x_return_status := fnd_api.g_ret_sts_error;
99: RETURN;
100: END IF;
101:
102: IF (create_update_flag = 'C') THEN

Line 109: x_return_status := fnd_api.g_ret_sts_error;

105: THEN
106: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
107: fnd_message.set_token('COLUMN', p_col_name);
108: fnd_msg_pub.add;
109: x_return_status := fnd_api.g_ret_sts_error;
110: END IF;
111: ELSE
112: IF ((NOT p_miss_allowed_in_u) AND
113: p_col_val IS NULL )

Line 118: x_return_status := fnd_api.g_ret_sts_error;

114: THEN
115: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
116: fnd_message.set_token('COLUMN', p_col_name);
117: fnd_msg_pub.add;
118: x_return_status := fnd_api.g_ret_sts_error;
119: END IF;
120: END IF;
121: END check_mandatory_date_col;
122:

Line 140: IF (p_col_val = FND_API.G_MISS_NUM) THEN

136: p_miss_allowed_in_u IN BOOLEAN,
137: x_return_status IN OUT NOCOPY VARCHAR2)
138: IS
139: BEGIN
140: IF (p_col_val = FND_API.G_MISS_NUM) THEN
141: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
142: fnd_message.set_token('COLUMN', p_col_name);
143: fnd_msg_pub.add;
144: x_return_status := fnd_api.g_ret_sts_error;

Line 144: x_return_status := fnd_api.g_ret_sts_error;

140: IF (p_col_val = FND_API.G_MISS_NUM) THEN
141: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
142: fnd_message.set_token('COLUMN', p_col_name);
143: fnd_msg_pub.add;
144: x_return_status := fnd_api.g_ret_sts_error;
145: RETURN;
146: END IF;
147:
148: IF (create_update_flag = 'C') THEN

Line 155: x_return_status := fnd_api.g_ret_sts_error;

151: THEN
152: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
153: fnd_message.set_token('COLUMN', p_col_name);
154: fnd_msg_pub.add;
155: x_return_status := fnd_api.g_ret_sts_error;
156: END IF;
157: ELSE
158: IF ((NOT p_miss_allowed_in_u) AND
159: p_col_val IS NULL )

Line 164: x_return_status := fnd_api.g_ret_sts_error;

160: THEN
161: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
162: fnd_message.set_token('COLUMN', p_col_name);
163: fnd_msg_pub.add;
164: x_return_status := fnd_api.g_ret_sts_error;
165: END IF;
166: END IF;
167: END check_mandatory_num_col;
168:

Line 178: -- Also consider fnd_api.g_miss_date in comparison.

174: ldate1 date;
175: ldate2 date;
176: BEGIN
177: -- Bug 3614582 : Removed TRUNC from the date comparison.
178: -- Also consider fnd_api.g_miss_date in comparison.
179: /* ldate1 := trunc(date1);
180: ldate2 := trunc(date2);*/
181: ldate1 := date1;
182: ldate2 := date2;

Line 183: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN

179: /* ldate1 := trunc(date1);
180: ldate2 := trunc(date2);*/
181: ldate1 := date1;
182: ldate2 := date2;
183: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
184: RETURN 0;
185: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
186: RETURN -1;
187: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN

Line 185: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN

181: ldate1 := date1;
182: ldate2 := date2;
183: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
184: RETURN 0;
185: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
186: RETURN -1;
187: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN
188: RETURN 1;
189: ELSIF ( ldate1 = ldate2 ) THEN

Line 187: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN

183: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
184: RETURN 0;
185: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
186: RETURN -1;
187: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN
188: RETURN 1;
189: ELSIF ( ldate1 = ldate2 ) THEN
190: RETURN 0;
191: ELSIF ( ldate1 > ldate2 ) THEN

Line 253: AND p_column_value <> fnd_api.g_miss_char ) THEN

249:
250: l_exist VARCHAR2(1);
251: BEGIN
252: IF ( p_column_value IS NOT NULL
253: AND p_column_value <> fnd_api.g_miss_char ) THEN
254: OPEN c1;
255: FETCH c1 INTO l_exist;
256: IF c1%NOTFOUND THEN
257: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');

Line 261: x_return_status := fnd_api.g_ret_sts_error;

257: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
258: fnd_message.set_token('COLUMN',p_column);
259: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
260: fnd_msg_pub.add;
261: x_return_status := fnd_api.g_ret_sts_error;
262: END IF;
263: CLOSE c1;
264: END IF;
265: END validate_fnd_lookup;

Line 295: AND p_column_value <> fnd_api.g_miss_char ) THEN

291: l_exist VARCHAR2(1);
292: BEGIN
293:
294: IF ( p_column_value IS NOT NULL
295: AND p_column_value <> fnd_api.g_miss_char ) THEN
296: OPEN c_nace;
297: FETCH c_nace INTO l_exist;
298: IF c_nace%NOTFOUND THEN
299: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');

Line 303: x_return_status := fnd_api.g_ret_sts_error;

299: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
300: fnd_message.set_token('COLUMN',p_column);
301: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
302: fnd_msg_pub.add;
303: x_return_status := fnd_api.g_ret_sts_error;
304: END IF;
305: CLOSE c_nace;
306: END IF;
307: END validate_fnd_lookup;

Line 384: x_return_status := fnd_api.g_ret_sts_error;

380: fnd_message.set_token('FK','class_category');
381: fnd_message.set_token('COLUMN','class_category');
382: fnd_message.set_token('TABLE','hz_class_categories');
383: fnd_msg_pub.add;
384: x_return_status := fnd_api.g_ret_sts_error;
385: END IF;
386: CLOSE c_exist_class_category;
387: END check_existence_class_category;
388:

Line 532: AND p_end_date_active <> fnd_api.G_MISS_DATE )

528: IS
529: BEGIN
530: --end date must be null or greater than start date
531: IF ( p_end_date_active IS NOT NULL
532: AND p_end_date_active <> fnd_api.G_MISS_DATE )
533: THEN
534: IF ( p_start_date_active IS NOT NULL AND
535: p_start_date_active <> fnd_api.G_MISS_DATE AND
536: p_end_date_active < p_start_date_active )

Line 535: p_start_date_active <> fnd_api.G_MISS_DATE AND

531: IF ( p_end_date_active IS NOT NULL
532: AND p_end_date_active <> fnd_api.G_MISS_DATE )
533: THEN
534: IF ( p_start_date_active IS NOT NULL AND
535: p_start_date_active <> fnd_api.G_MISS_DATE AND
536: p_end_date_active < p_start_date_active )
537: THEN
538: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
539: fnd_msg_pub.add;

Line 540: x_return_status := fnd_api.g_ret_sts_error;

536: p_end_date_active < p_start_date_active )
537: THEN
538: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
539: fnd_msg_pub.add;
540: x_return_status := fnd_api.g_ret_sts_error;
541: END IF;
542: END IF;
543: END check_start_end_active_dates;
544:

Line 551: IF x_return_status = fnd_api.g_ret_sts_error

547: procedure check_err(
548: x_return_status IN VARCHAR2
549: ) IS
550: BEGIN
551: IF x_return_status = fnd_api.g_ret_sts_error
552: THEN
553: RAISE g_ex_invalid_param;
554: END IF;
555: END;

Line 861: IF (p_column_value <> fnd_api.g_miss_char OR

857: BEGIN
858:
859: IF p_column_value IS NOT NULL THEN
860: IF p_restricted = 'Y' THEN
861: IF (p_column_value <> fnd_api.g_miss_char OR
862: p_old_column_value IS NOT NULL) AND
863: (p_old_column_value IS NULL OR
864: p_column_value <> p_old_column_value)
865: THEN

Line 870: p_old_column_value <> FND_API.G_MISS_CHAR)

866: l_error := TRUE;
867: END IF;
868: ELSE
869: IF (p_old_column_value IS NOT NULL AND -- Bug 3439053.
870: p_old_column_value <> FND_API.G_MISS_CHAR)
871: AND
872: (p_column_value = fnd_api.g_miss_char OR
873: p_column_value <> p_old_column_value)
874: THEN

Line 872: (p_column_value = fnd_api.g_miss_char OR

868: ELSE
869: IF (p_old_column_value IS NOT NULL AND -- Bug 3439053.
870: p_old_column_value <> FND_API.G_MISS_CHAR)
871: AND
872: (p_column_value = fnd_api.g_miss_char OR
873: p_column_value <> p_old_column_value)
874: THEN
875: l_error := TRUE;
876: END IF;

Line 886: x_return_status := fnd_api.g_ret_sts_error;

882: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
883: fnd_message.set_token('COLUMN', p_column);
884: fnd_msg_pub.add;
885: END IF;
886: x_return_status := fnd_api.g_ret_sts_error;
887: END IF;
888:
889: END validate_nonupdateable;
890:

Line 908: IF (p_column_value <> fnd_api.g_miss_num OR

904: BEGIN
905:
906: IF p_column_value IS NOT NULL THEN
907: IF p_restricted = 'Y' THEN
908: IF (p_column_value <> fnd_api.g_miss_num OR
909: p_old_column_value IS NOT NULL) AND
910: (p_old_column_value IS NULL OR
911: p_column_value <> p_old_column_value)
912: THEN

Line 917: p_old_column_value <> FND_API.G_MISS_NUM)

913: l_error := TRUE;
914: END IF;
915: ELSE
916: IF (p_old_column_value IS NOT NULL AND -- Bug 3439053.
917: p_old_column_value <> FND_API.G_MISS_NUM)
918: AND
919: (p_column_value = fnd_api.g_miss_num OR
920: p_column_value <> p_old_column_value)
921: THEN

Line 919: (p_column_value = fnd_api.g_miss_num OR

915: ELSE
916: IF (p_old_column_value IS NOT NULL AND -- Bug 3439053.
917: p_old_column_value <> FND_API.G_MISS_NUM)
918: AND
919: (p_column_value = fnd_api.g_miss_num OR
920: p_column_value <> p_old_column_value)
921: THEN
922: l_error := TRUE;
923: END IF;

Line 933: x_return_status := fnd_api.g_ret_sts_error;

929: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
930: fnd_message.set_token('COLUMN', p_column);
931: fnd_msg_pub.add;
932: END IF;
933: x_return_status := fnd_api.g_ret_sts_error;
934: END IF;
935:
936: END validate_nonupdateable;
937:

Line 1015: x_return_status := fnd_api.g_ret_sts_error;

1011: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');
1012: fnd_message.set_token('COLUMN', 'class_category');
1013: fnd_message.set_token('LOOKUP_TYPE', p_class_cat_rec.class_category);
1014: fnd_msg_pub.add;
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: END IF;
1017: CLOSE cu_lookup_type;
1018:
1019: validate_fnd_lookup(

Line 1043: x_return_status := fnd_api.g_ret_sts_error;

1039: IF exist_class_category(p_class_cat_rec.class_category) = 'Y' THEN
1040: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
1041: fnd_message.set_token('COLUMN', p_class_cat_rec.class_category);
1042: fnd_msg_pub.add;
1043: x_return_status := fnd_api.g_ret_sts_error;
1044: END IF;
1045: END IF;
1046:
1047:

Line 1057: x_return_status := fnd_api.g_ret_sts_error;

1053: THEN
1054: fnd_message.set_name('AR', 'HZ_API_LEAF_ONLY_NOT_ALLOWED');
1055: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1056: fnd_msg_pub.add;
1057: x_return_status := fnd_api.g_ret_sts_error;
1058: END IF;
1059:
1060: IF ( (p_class_cat_rec.allow_multi_parent_flag = 'N' )
1061: AND (is_all_code_one_parent_only

Line 1096: x_return_status := fnd_api.g_ret_sts_error;

1092: fnd_message.set_token('END1' , l_end);
1093: fnd_message.set_token('START2' , l_start2);
1094: fnd_message.set_token('END2' , l_end2);
1095: fnd_msg_pub.add;
1096: x_return_status := fnd_api.g_ret_sts_error;
1097: END IF;
1098:
1099: IF ( (p_class_cat_rec.allow_multi_assign_flag = 'N' )
1100: AND (is_all_inst_less_one_code(p_class_cat_rec.class_category,

Line 1137: x_return_status := fnd_api.g_ret_sts_error;

1133: fnd_message.set_token('END1' , l_end_date_active);
1134: fnd_message.set_token('START2' , l_start_date_active2);
1135: fnd_message.set_token('END2' , l_end_date_active2);
1136: fnd_msg_pub.add;
1137: x_return_status := fnd_api.g_ret_sts_error;
1138: END IF;
1139:
1140: END IF;
1141: --check_err( x_return_status );

Line 1149: x_return_status := fnd_api.G_RET_STS_ERROR;

1145: WHEN OTHERS THEN
1146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1148: FND_MSG_PUB.ADD;
1149: x_return_status := fnd_api.G_RET_STS_ERROR;
1150: */
1151: END validate_class_category;
1152:
1153:

Line 1291: x_return_status := fnd_api.G_RET_STS_ERROR;

1287: --Bug 2861251: Changed the message name from HZ_ADMIN_SQL_VALID_ERR
1288: --to HZ_API_INVALID_OBJ_NAME.
1289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_OBJ_NAME');
1290: FND_MSG_PUB.ADD;
1291: x_return_status := fnd_api.G_RET_STS_ERROR;
1292: when others then
1293: null;
1294: end;
1295: ---------------- End of changes for HTML Admin Project ----------------

Line 1313: x_return_status := fnd_api.g_ret_sts_error;

1309: fnd_message.set_name('AR','HZ_API_USE_ONCE_OWNER_TABLE');
1310: fnd_message.set_token('CLASS_CATEGORY',p_in_rec.class_category);
1311: fnd_message.set_token('OWNER_TABLE' ,p_in_rec.owner_table);
1312: fnd_msg_pub.add;
1313: x_return_status := fnd_api.g_ret_sts_error;
1314: END IF;
1315:
1316: --check_err(x_return_status);
1317: /* -- Bug 3962783

Line 1323: x_return_status := fnd_api.G_RET_STS_ERROR;

1319: WHEN OTHERS THEN
1320: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1322: FND_MSG_PUB.ADD;
1323: x_return_status := fnd_api.G_RET_STS_ERROR;
1324: */
1325: END validate_class_category_use;
1326:
1327:

Line 1878: x_return_status := fnd_api.g_ret_sts_error;

1874: fnd_message.set_token('CLASS_CODE', l_class_code);
1875: fnd_message.set_token('START_DATE_ACTIVE', l_start_date);
1876: fnd_message.set_token('END_DATE_ACTIVE' , l_end_date);
1877: fnd_msg_pub.add;
1878: x_return_status := fnd_api.g_ret_sts_error;
1879:
1880: -- For (owner_table, table_id, source_content_type, category, code)
1881: -- the assignment cannot be primary and secondary in the same time
1882: elsif exist_second_assign_same_code

Line 1900: x_return_status := fnd_api.g_ret_sts_error;

1896: fnd_message.set_token('CLASS_CODE', l_class_code);
1897: fnd_message.set_token('START_DATE_ACTIVE', l_start_date);
1898: fnd_message.set_token('END_DATE_ACTIVE' , l_end_date);
1899: fnd_msg_pub.add;
1900: x_return_status := fnd_api.g_ret_sts_error;
1901: end if;
1902:
1903: ELSIF p_primary_flag = 'N' THEN
1904:

Line 1924: x_return_status := fnd_api.g_ret_sts_error;

1920: fnd_message.set_token('CLASS_CODE', l_class_code);
1921: fnd_message.set_token('START_DATE_ACTIVE', l_start_date);
1922: fnd_message.set_token('END_DATE_ACTIVE' , l_end_date);
1923: fnd_msg_pub.add;
1924: x_return_status := fnd_api.g_ret_sts_error;
1925: end if;
1926:
1927: END IF;
1928:

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

2263: -- Bug 4226199 : call for update and for all ACS otehr than UE
2264: IF create_update_flag = 'U' and l_actual_content_source <> 'USER_ENTERED'
2265: THEN
2266: DECLARE
2267: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2268: BEGIN
2269:
2270: validate_nonupdateable(
2271: p_column => 'CLASS_CATEGORY',

Line 2283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2279: p_column_value => p_in_rec.class_code,
2280: p_old_column_value => l_class_code,
2281: x_return_status => l_return_status,
2282: p_raise_error => 'N');
2283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2284: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
2285: p_actual_content_source => l_actual_content_source,
2286: p_new_actual_content_source => p_in_rec.actual_content_source,
2287: p_entity_name => 'HZ_CODE_ASSIGNMENTS',

Line 2318: x_return_status := FND_API.G_RET_STS_ERROR;

2314: FND_MESSAGE.SET_TOKEN('FK', 'class_category');
2315: FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category');
2316: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_class_categories');
2317: FND_MSG_PUB.ADD;
2318: x_return_status := FND_API.G_RET_STS_ERROR;
2319:
2320: RAISE G_EX_INVALID_PARAM;
2321: END IF;
2322: END IF;

Line 2344: x_return_status := fnd_api.g_ret_sts_error;

2340: fnd_message.set_token('FK','class_category');
2341: fnd_message.set_token('COLUMN','class_category');
2342: fnd_message.set_token('TABLE','hz_class_categories');
2343: fnd_msg_pub.add;
2344: x_return_status := fnd_api.g_ret_sts_error;
2345: end;
2346:
2347: -- If the flag is set to 'N", do the validation
2348:

Line 2375: AND code_Assignment_id <> nvl(p_in_rec.code_assignment_id, fnd_api.g_miss_num)

2371: select count(1) into l_count_multi
2372: from hz_code_assignments
2373: where class_category = p_in_rec.class_category
2374: AND status='A'
2375: AND code_Assignment_id <> nvl(p_in_rec.code_assignment_id, fnd_api.g_miss_num)
2376: AND owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name)
2377: /*
2378: AND ( owner_table_id = nvl(p_in_rec.owner_table_id, l_owner_table_id)
2379: OR

Line 2400: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),

2396: START_DATE_ACTIVE, END_DATE_ACTIVE) = 'Y'
2397: /*
2398: AND ((START_DATE_ACTIVE) between (nvl(p_in_rec.start_date_active, l_start_Date_active)) and
2399: (decode(p_in_rec.end_date_active,
2400: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),
2401: NULL,l_end_date_active,p_in_rec.end_date_active)) OR
2402: (END_DATE_ACTIVE) between (nvl(p_in_rec.start_date_active,l_start_Date_active)) and
2403: (decode(p_in_rec.end_date_active,
2404: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),

Line 2404: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),

2400: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),
2401: NULL,l_end_date_active,p_in_rec.end_date_active)) OR
2402: (END_DATE_ACTIVE) between (nvl(p_in_rec.start_date_active,l_start_Date_active)) and
2403: (decode(p_in_rec.end_date_active,
2404: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),
2405: NULL,l_end_date_active,p_in_rec.end_date_active)) OR
2406: (nvl(p_in_rec.start_date_active,l_start_Date_active)) between (START_DATE_ACTIVE) and
2407: (nvl(END_DATE_ACTIVE, to_date('4712/12/31','YYYY/MM/DD'))) OR
2408: (nvl(p_in_rec.end_date_active,l_end_date_Active)) between (START_DATE_ACTIVE) and

Line 2416: AND code_Assignment_id <> nvl(p_in_rec.code_assignment_id, fnd_api.g_miss_num)

2412: select count(1) into l_count_multi
2413: from hz_code_assignments
2414: where class_category = p_in_rec.class_category
2415: AND status='A'
2416: AND code_Assignment_id <> nvl(p_in_rec.code_assignment_id, fnd_api.g_miss_num)
2417: AND owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name)
2418: AND ( owner_table_id is null
2419: AND
2420: ( nvl(owner_table_key_1 || owner_table_key_2 ||

Line 2422: owner_table_key_5, fnd_api.g_miss_char) = nvl(l_owner_table_keys, fnd_api.g_miss_char)

2418: AND ( owner_table_id is null
2419: AND
2420: ( nvl(owner_table_key_1 || owner_table_key_2 ||
2421: owner_table_key_3 || owner_table_key_4 ||
2422: owner_table_key_5, fnd_api.g_miss_char) = nvl(l_owner_table_keys, fnd_api.g_miss_char)
2423: )
2424: )
2425: -- Bug 3614582 : Removed TRUNC from the date comparison.
2426: AND is_overlap(nvl(p_in_rec.start_date_active, l_start_Date_active),

Line 2432: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),

2428: START_DATE_ACTIVE, END_DATE_ACTIVE) = 'Y'
2429: /*
2430: AND ((START_DATE_ACTIVE) between (nvl(p_in_rec.start_date_active, l_start_Date_active)) and
2431: (decode(p_in_rec.end_date_active,
2432: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),
2433: NULL,l_end_date_active,p_in_rec.end_date_active))
2434: OR
2435: (END_DATE_ACTIVE) between (nvl(p_in_rec.start_date_active,l_start_Date_active)) and
2436: (decode(p_in_rec.end_date_active,

Line 2437: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),

2433: NULL,l_end_date_active,p_in_rec.end_date_active))
2434: OR
2435: (END_DATE_ACTIVE) between (nvl(p_in_rec.start_date_active,l_start_Date_active)) and
2436: (decode(p_in_rec.end_date_active,
2437: fnd_api.g_miss_date,to_date('4712/12/31','YYYY/MM/DD'),
2438: NULL,l_end_date_active,p_in_rec.end_date_active))
2439: OR
2440: (nvl(p_in_rec.start_date_active,l_start_Date_active)) between (START_DATE_ACTIVE) and
2441: (nvl(END_DATE_ACTIVE, to_date('4712/12/31','YYYY/MM/DD'))) OR

Line 2451: x_return_status := FND_API.G_RET_STS_ERROR;

2447:
2448: if l_count_multi > 0 then
2449: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ALLOW_MUL_ASSIGN_FG');
2450: FND_MSG_PUB.ADD;
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: --Bug 3962783
2453: --RAISE G_EX_INVALID_PARAM;
2454: end if;
2455: end if;

Line 2475: -- x_return_status := FND_API.G_RET_STS_ERROR;

2471: -- FND_MESSAGE.SET_TOKEN('FK', p_in_rec.owner_table_name);
2472: -- FND_MESSAGE.SET_TOKEN('COLUMN', p_in_rec.owner_table_id);
2473: -- FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
2474: -- FND_MSG_PUB.ADD;
2475: -- x_return_status := FND_API.G_RET_STS_ERROR;
2476: --
2477: -- RAISE G_EX_INVALID_PARAM;
2478: -- END IF;
2479: --END IF;

Line 2540: x_return_status := FND_API.G_RET_STS_ERROR;

2536: -- update would produce duplicate records
2537: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
2538: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_assignment_id');
2539: FND_MSG_PUB.ADD;
2540: x_return_status := FND_API.G_RET_STS_ERROR;
2541: RAISE G_EX_INVALID_PARAM;
2542: END IF;
2543: EXCEPTION
2544: WHEN TOO_MANY_ROWS THEN

Line 2568: x_return_status := FND_API.G_RET_STS_ERROR;

2564: rownum = 1;
2565: if allow_leaf_error = 'Y' THEN
2566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_LEAFNODE_FLAG');
2567: FND_MSG_PUB.ADD;
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: --Bug 3962783
2570: --RAISE G_EX_INVALID_PARAM;
2571: end if;
2572: exception

Line 2621: x_return_status := FND_API.G_RET_STS_ERROR;

2617:
2618: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2619: FND_MESSAGE.SET_TOKEN('COLUMN', 'owner_table_name-owner_table_id-class_category-class_code-actual_content_source-start_date_active');
2620: FND_MSG_PUB.ADD;
2621: x_return_status := FND_API.G_RET_STS_ERROR;
2622: --Bug 3962783
2623: --RAISE G_EX_INVALID_PARAM;
2624:
2625: --Commented the code below in the fix for Bug number 3053541

Line 2635: x_return_status := FND_API.G_RET_STS_ERROR;

2631: THEN
2632: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2633: FND_MESSAGE.SET_TOKEN('COLUMN', 'owner_table_name-owner_table_id-class_category-class_code-content_source_type-start_date_active');
2634: FND_MSG_PUB.ADD;
2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: RAISE G_EX_INVALID_PARAM;
2637: ELSIF l_id <>p_in_rec.code_assignment_id
2638: THEN
2639: -- update would produce duplicate records

Line 2643: x_return_status := FND_API.G_RET_STS_ERROR;

2639: -- update would produce duplicate records
2640: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
2641: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_assignment_id');
2642: FND_MSG_PUB.ADD;
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: RAISE G_EX_INVALID_PARAM;
2645: END IF;*/
2646: --End of code commented in the fix for Bug number 3053541.
2647:

Line 2680: IF p_in_rec.end_date_active <> FND_API.G_MISS_DATE AND

2676: nvl(p_in_rec.end_date_active, l_end_date_active),
2677: x_return_status);
2678: --check_err( x_return_status );
2679: --
2680: IF p_in_rec.end_date_active <> FND_API.G_MISS_DATE AND
2681: -- Bug 3293069 - Added bracket around the "AND" condition
2682: (
2683: (nvl(p_in_rec.end_date_active, l_end_date_active) <=
2684: nvl(p_in_rec.start_date_active, l_start_date_active) ) OR

Line 2702: x_return_status := FND_API.G_RET_STS_ERROR;

2698: -- cannot update
2699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
2700: FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');
2701: FND_MSG_PUB.ADD;
2702: x_return_status := FND_API.G_RET_STS_ERROR;
2703: RAISE G_EX_INVALID_PARAM;
2704: END IF;
2705: */
2706: -- While debugging for Bug No 3053541,found that if the API is called to

Line 2743: x_return_status := FND_API.G_RET_STS_ERROR;

2739: --FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');
2740: FND_MESSAGE.SET_NAME('AR','HZ_API_PRI_CODE_OVERLAP');
2741:
2742: FND_MSG_PUB.ADD;
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744: --Bug 3962783
2745: --RAISE G_EX_INVALID_PARAM;
2746: EXIT;
2747: END IF;

Line 2749: -- Bug 3293069 : Check if the end_date_active is fnd_api.g_miss_date.

2745: --RAISE G_EX_INVALID_PARAM;
2746: EXIT;
2747: END IF;
2748:
2749: -- Bug 3293069 : Check if the end_date_active is fnd_api.g_miss_date.
2750: -- If yes, use to_date('4712/12/31','YYYY/MM/DD') for checking overlap
2751:
2752: if(p_in_rec.end_date_active = fnd_api.g_miss_date) then
2753: l_date := to_date('4712/12/31','YYYY/MM/DD');

Line 2752: if(p_in_rec.end_date_active = fnd_api.g_miss_date) then

2748:
2749: -- Bug 3293069 : Check if the end_date_active is fnd_api.g_miss_date.
2750: -- If yes, use to_date('4712/12/31','YYYY/MM/DD') for checking overlap
2751:
2752: if(p_in_rec.end_date_active = fnd_api.g_miss_date) then
2753: l_date := to_date('4712/12/31','YYYY/MM/DD');
2754: else
2755: l_date := p_in_rec.end_date_active;
2756: end if;

Line 2770: x_return_status := FND_API.G_RET_STS_ERROR;

2766: v_rec.end_date_active)='Y'
2767: THEN
2768: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2769: FND_MSG_PUB.ADD;
2770: x_return_status := FND_API.G_RET_STS_ERROR;
2771: --Bug 3962783
2772: --RAISE G_EX_INVALID_PARAM;
2773: END IF;--Bug No 3053541.
2774: END LOOP;

Line 2794: * x_return_status := FND_API.G_RET_STS_ERROR;

2790: * THEN
2791: * FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
2792: * FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');
2793: * FND_MSG_PUB.ADD;
2794: * x_return_status := FND_API.G_RET_STS_ERROR;
2795: * RAISE G_EX_INVALID_PARAM;
2796: * END IF;
2797: * ELSIF is_between(v_rec.start_date_active, p_in_rec.start_date_active, p_in_rec.end_date_active ) OR
2798: * is_between(p_in_rec.start_date_active, v_rec.start_date_active, v_rec.end_date_active )

Line 2804: * x_return_status := FND_API.G_RET_STS_ERROR;

2800: * -- overlaps with this existing relation
2801: * FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
2802: * FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');
2803: * FND_MSG_PUB.ADD;
2804: * x_return_status := FND_API.G_RET_STS_ERROR;
2805: * RAISE G_EX_INVALID_PARAM;
2806: * END IF;
2807: * END LOOP;
2808: * */

Line 2838: x_return_status := FND_API.G_RET_STS_ERROR;

2834: */
2835: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2836:
2837: FND_MSG_PUB.ADD;
2838: x_return_status := FND_API.G_RET_STS_ERROR;
2839: --Bug 3962783
2840: --RAISE G_EX_INVALID_PARAM;
2841: EXIT;
2842: END IF;

Line 2909: x_return_status := FND_API.G_RET_STS_ERROR;

2905: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2906:
2907:
2908: FND_MSG_PUB.ADD;
2909: x_return_status := FND_API.G_RET_STS_ERROR;
2910: --Bug 3962783
2911: --RAISE G_EX_INVALID_PARAM;
2912: END IF;
2913: END IF;

Line 2924: p_in_rec.owner_table_id <> FND_API.G_MISS_NUM) AND

2920: --Bug 2825247: The following condition should be checked only when create_update_flag is 'C'
2921: IF create_update_flag = 'C'
2922: THEN
2923: IF ((p_in_rec.owner_table_id IS NOT NULL AND
2924: p_in_rec.owner_table_id <> FND_API.G_MISS_NUM) AND
2925: (p_in_rec.owner_table_key_1 IS NOT NULL AND
2926: p_in_rec.owner_table_key_1 <> FND_API.G_MISS_CHAR)) OR
2927: ((p_in_rec.owner_table_id IS NULL OR
2928: p_in_rec.owner_table_id = FND_API.G_MISS_NUM) AND

Line 2926: p_in_rec.owner_table_key_1 <> FND_API.G_MISS_CHAR)) OR

2922: THEN
2923: IF ((p_in_rec.owner_table_id IS NOT NULL AND
2924: p_in_rec.owner_table_id <> FND_API.G_MISS_NUM) AND
2925: (p_in_rec.owner_table_key_1 IS NOT NULL AND
2926: p_in_rec.owner_table_key_1 <> FND_API.G_MISS_CHAR)) OR
2927: ((p_in_rec.owner_table_id IS NULL OR
2928: p_in_rec.owner_table_id = FND_API.G_MISS_NUM) AND
2929: (p_in_rec.owner_table_key_1 IS NULL OR
2930: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR))

Line 2928: p_in_rec.owner_table_id = FND_API.G_MISS_NUM) AND

2924: p_in_rec.owner_table_id <> FND_API.G_MISS_NUM) AND
2925: (p_in_rec.owner_table_key_1 IS NOT NULL AND
2926: p_in_rec.owner_table_key_1 <> FND_API.G_MISS_CHAR)) OR
2927: ((p_in_rec.owner_table_id IS NULL OR
2928: p_in_rec.owner_table_id = FND_API.G_MISS_NUM) AND
2929: (p_in_rec.owner_table_key_1 IS NULL OR
2930: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR))
2931: THEN
2932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION2');

Line 2930: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR))

2926: p_in_rec.owner_table_key_1 <> FND_API.G_MISS_CHAR)) OR
2927: ((p_in_rec.owner_table_id IS NULL OR
2928: p_in_rec.owner_table_id = FND_API.G_MISS_NUM) AND
2929: (p_in_rec.owner_table_key_1 IS NULL OR
2930: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR))
2931: THEN
2932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION2');
2933: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_id');
2934: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_1');

Line 2936: x_return_status := FND_API.G_RET_STS_ERROR;

2932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION2');
2933: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_id');
2934: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_1');
2935: FND_MSG_PUB.ADD;
2936: x_return_status := FND_API.G_RET_STS_ERROR;
2937: --Bug 3962783
2938: --RAISE G_EX_INVALID_PARAM;
2939: END IF;
2940: --If owner_table_key_1 is not supplied, then owner_table_key_2 cannot be supplied.

Line 2942: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR) AND

2938: --RAISE G_EX_INVALID_PARAM;
2939: END IF;
2940: --If owner_table_key_1 is not supplied, then owner_table_key_2 cannot be supplied.
2941: IF ((p_in_rec.owner_table_key_1 IS NULL OR
2942: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR) AND
2943: (p_in_rec.owner_table_key_2 IS NOT NULL AND
2944: p_in_rec.owner_table_key_2 <> FND_API.G_MISS_CHAR))
2945: THEN
2946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

Line 2944: p_in_rec.owner_table_key_2 <> FND_API.G_MISS_CHAR))

2940: --If owner_table_key_1 is not supplied, then owner_table_key_2 cannot be supplied.
2941: IF ((p_in_rec.owner_table_key_1 IS NULL OR
2942: p_in_rec.owner_table_key_1 = FND_API.G_MISS_CHAR) AND
2943: (p_in_rec.owner_table_key_2 IS NOT NULL AND
2944: p_in_rec.owner_table_key_2 <> FND_API.G_MISS_CHAR))
2945: THEN
2946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2947: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_1');
2948: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_2');

Line 2950: x_return_status := FND_API.G_RET_STS_ERROR;

2946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2947: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_1');
2948: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_2');
2949: FND_MSG_PUB.ADD;
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: --Bug 3962783
2952: --RAISE G_EX_INVALID_PARAM;
2953: END IF;
2954:

Line 2957: p_in_rec.owner_table_key_2 = FND_API.G_MISS_CHAR) AND

2953: END IF;
2954:
2955: --If owner_table_key_2 is not supplied, then owner_table_key_3 cannot be supplied.
2956: IF ((p_in_rec.owner_table_key_2 IS NULL OR
2957: p_in_rec.owner_table_key_2 = FND_API.G_MISS_CHAR) AND
2958: (p_in_rec.owner_table_key_3 IS NOT NULL AND
2959: p_in_rec.owner_table_key_3 <> FND_API.G_MISS_CHAR))
2960: THEN
2961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

Line 2959: p_in_rec.owner_table_key_3 <> FND_API.G_MISS_CHAR))

2955: --If owner_table_key_2 is not supplied, then owner_table_key_3 cannot be supplied.
2956: IF ((p_in_rec.owner_table_key_2 IS NULL OR
2957: p_in_rec.owner_table_key_2 = FND_API.G_MISS_CHAR) AND
2958: (p_in_rec.owner_table_key_3 IS NOT NULL AND
2959: p_in_rec.owner_table_key_3 <> FND_API.G_MISS_CHAR))
2960: THEN
2961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2962: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_2');
2963: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_3');

Line 2965: x_return_status := FND_API.G_RET_STS_ERROR;

2961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2962: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_2');
2963: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_3');
2964: FND_MSG_PUB.ADD;
2965: x_return_status := FND_API.G_RET_STS_ERROR;
2966: --Bug 3962783
2967: --RAISE G_EX_INVALID_PARAM;
2968: END IF;
2969:

Line 2972: p_in_rec.owner_table_key_3 = FND_API.G_MISS_CHAR) AND

2968: END IF;
2969:
2970: --If owner_table_key_3 is not supplied, then owner_table_key_4 cannot be supplied.
2971: IF ((p_in_rec.owner_table_key_3 IS NULL OR
2972: p_in_rec.owner_table_key_3 = FND_API.G_MISS_CHAR) AND
2973: (p_in_rec.owner_table_key_4 IS NOT NULL AND
2974: p_in_rec.owner_table_key_4 <> FND_API.G_MISS_CHAR))
2975: THEN
2976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

Line 2974: p_in_rec.owner_table_key_4 <> FND_API.G_MISS_CHAR))

2970: --If owner_table_key_3 is not supplied, then owner_table_key_4 cannot be supplied.
2971: IF ((p_in_rec.owner_table_key_3 IS NULL OR
2972: p_in_rec.owner_table_key_3 = FND_API.G_MISS_CHAR) AND
2973: (p_in_rec.owner_table_key_4 IS NOT NULL AND
2974: p_in_rec.owner_table_key_4 <> FND_API.G_MISS_CHAR))
2975: THEN
2976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2977: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_3');
2978: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_4');

Line 2980: x_return_status := FND_API.G_RET_STS_ERROR;

2976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2977: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_3');
2978: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_4');
2979: FND_MSG_PUB.ADD;
2980: x_return_status := FND_API.G_RET_STS_ERROR;
2981: --Bug 3962783
2982: --RAISE G_EX_INVALID_PARAM;
2983: END IF;
2984:

Line 2987: p_in_rec.owner_table_key_4 = FND_API.G_MISS_CHAR) AND

2983: END IF;
2984:
2985: --If owner_table_key_4 is not supplied, then owner_table_key_5 cannot be supplied.
2986: IF ((p_in_rec.owner_table_key_4 IS NULL OR
2987: p_in_rec.owner_table_key_4 = FND_API.G_MISS_CHAR) AND
2988: (p_in_rec.owner_table_key_5 IS NOT NULL AND
2989: p_in_rec.owner_table_key_5 <> FND_API.G_MISS_CHAR))
2990: THEN
2991: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

Line 2989: p_in_rec.owner_table_key_5 <> FND_API.G_MISS_CHAR))

2985: --If owner_table_key_4 is not supplied, then owner_table_key_5 cannot be supplied.
2986: IF ((p_in_rec.owner_table_key_4 IS NULL OR
2987: p_in_rec.owner_table_key_4 = FND_API.G_MISS_CHAR) AND
2988: (p_in_rec.owner_table_key_5 IS NOT NULL AND
2989: p_in_rec.owner_table_key_5 <> FND_API.G_MISS_CHAR))
2990: THEN
2991: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2992: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_4');
2993: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_5');

Line 2995: x_return_status := FND_API.G_RET_STS_ERROR;

2991: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');
2992: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_4');
2993: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_5');
2994: FND_MSG_PUB.ADD;
2995: x_return_status := FND_API.G_RET_STS_ERROR;
2996: --Bug 3962783
2997: --RAISE G_EX_INVALID_PARAM;
2998: END IF;
2999:

Line 3017: x_return_status := FND_API.G_RET_STS_ERROR;

3013:
3014: IF bool='F' THEN
3015: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PRIMARY_KEY');
3016: FND_MSG_PUB.ADD;
3017: x_return_status := FND_API.G_RET_STS_ERROR;
3018: --Bug 3962783
3019: --RAISE G_EX_INVALID_PARAM;
3020: END IF;
3021: END IF;

Line 3031: x_return_status := fnd_api.G_RET_STS_ERROR;

3027: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
3028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3029: FND_MSG_PUB.ADD;
3030: END LOOP;
3031: x_return_status := fnd_api.G_RET_STS_ERROR;
3032: */
3033: END;
3034:
3035:

Line 3725: x_return_status := fnd_api.g_ret_sts_error;

3721: ------------------------------------------------------
3722: IF p_in_rec.class_code = p_in_rec.sub_class_code THEN
3723: fnd_message.set_name('AR', 'HZ_API_CLASS_CODE_VAL');
3724: fnd_msg_pub.add;
3725: x_return_status := fnd_api.g_ret_sts_error;
3726: --Bug 3962783
3727: --RAISE g_ex_invalid_param;
3728: END IF;
3729:

Line 3766: x_return_status := fnd_api.g_ret_sts_error;

3762: fnd_message.set_name('AR', 'HZ_API_CIRCULAR_CODE_RELATION');
3763: fnd_message.set_token('CLASS_CODE1', p_in_rec.class_code);
3764: fnd_message.set_token('CLASS_CODE2', p_in_rec.sub_class_code);
3765: fnd_msg_pub.add;
3766: x_return_status := fnd_api.g_ret_sts_error;
3767: --Bug 3962783
3768: --RAISE g_ex_invalid_param;
3769:
3770: ELSIF (is_cod1_descen_cod2( p_in_rec.class_category ,

Line 3790: x_return_status := fnd_api.g_ret_sts_error;

3786: fnd_message.set_name('AR', 'HZ_API_CIRCULAR_CODE_RELATION');
3787: fnd_message.set_token('CLASS_CODE1', p_in_rec.class_code);
3788: fnd_message.set_token('CLASS_CODE2', p_in_rec.sub_class_code);
3789: fnd_msg_pub.add;
3790: x_return_status := fnd_api.g_ret_sts_error;
3791: --Bug 3962783
3792: --RAISE g_ex_invalid_param;
3793: END IF;
3794: --}

Line 3806: x_return_status := fnd_api.g_ret_sts_error;

3802: l_end_date ) = 'Y' ) then
3803: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3804: fnd_message.set_token('COLUMN', 'class_category-class_code-sub_class_code-start_date_active');
3805: fnd_msg_pub.add;
3806: x_return_status := fnd_api.g_ret_sts_error;
3807: --Bug 3962783
3808: --RAISE g_ex_invalid_param;
3809: end if;
3810:

Line 3830: x_return_status := fnd_api.g_ret_sts_error;

3826: la_start ,
3827: la_end ) = 'Y' then
3828: fnd_message.set_name('AR', 'HZ_API_CLASS_REL_OVERLAP');
3829: fnd_msg_pub.add;
3830: x_return_status := fnd_api.g_ret_sts_error;
3831: --Bug 3962783
3832: --RAISE g_ex_invalid_param;
3833: end if;
3834:

Line 3858: x_return_status := fnd_api.g_ret_sts_error;

3854: fnd_message.set_token('CLASS_CODE1' , l_class_code);
3855: fnd_message.set_token('START1' , l_start_date_active);
3856: fnd_message.set_token('END1' , l_end_date_active );
3857: fnd_msg_pub.add;
3858: x_return_status := fnd_api.g_ret_sts_error;
3859: --Bug 3962783
3860: --RAISE g_ex_invalid_param;
3861: end if;
3862:

Line 3877: x_return_status := fnd_api.g_ret_sts_error;

3873: -- Relation does not exist
3874: fnd_message.set_name('AR', 'HZ_API_REL_NOT_EXIST');
3875: fnd_message.set_token('COLUMN', 'start_date_active-end_date_active');
3876: fnd_msg_pub.add;
3877: x_return_status := fnd_api.g_ret_sts_error;
3878: --Bug 3962783
3879: --RAISE g_ex_invalid_param;
3880: end if;
3881:

Line 3903: x_return_status := fnd_api.g_ret_sts_error;

3899: -- Overlap relations are not allowed
3900: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3901: fnd_message.set_token('COLUMN', 'class_category-class_code-sub_class_code-start_date_active');
3902: fnd_msg_pub.add;
3903: x_return_status := fnd_api.g_ret_sts_error;
3904: --Bug 3962783
3905: --RAISE g_ex_invalid_param;
3906: end if;
3907: end if;

Line 3914: x_return_status := fnd_api.G_RET_STS_ERROR;

3910: WHEN OTHERS THEN
3911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3913: FND_MSG_PUB.ADD;
3914: x_return_status := fnd_api.G_RET_STS_ERROR;
3915: */
3916: END validate_class_code_relation;
3917:
3918: -----------------------------------------------------------------

Line 3936: * be FND_API.G_RET_STS_ERROR (error)

3932: * p_view_application_id Related to application id column
3933: *
3934: * IN/OUT:
3935: * x_return_status Return status after the call. The status can
3936: * be FND_API.G_RET_STS_ERROR (error)
3937: *
3938: * NOTES
3939: *
3940: * CREATION/MODIFICATION HISTORY

Line 3974: x_return_status := fnd_api.g_ret_sts_error;

3970: FETCH c_exist_class_catgry_type_code INTO l_exist;
3971: IF c_exist_class_catgry_type_code%FOUND THEN
3972: fnd_message.set_name('AR','HZ_API_DUP_CLASS');
3973: fnd_msg_pub.add;
3974: x_return_status := fnd_api.g_ret_sts_error;
3975: END IF;
3976: CLOSE c_exist_class_catgry_type_code;
3977:
3978: END chk_exist_cls_catgry_type_code;

Line 3998: * be FND_API.G_RET_STS_ERROR (error)

3994: * p_view_application_id Related to application id column
3995: *
3996: * IN/OUT:
3997: * x_return_status Return status after the call. The status can
3998: * be FND_API.G_RET_STS_ERROR (error)
3999: *
4000: * NOTES
4001: *
4002: * CREATION/MODIFICATION HISTORY

Line 4037: x_return_status := fnd_api.g_ret_sts_error;

4033: FETCH c_exist_clas_catgry_typ_mng INTO l_exist;
4034: IF c_exist_clas_catgry_typ_mng%FOUND THEN
4035: fnd_message.set_name('AR','HZ_API_DUP_CLASS_TYPE_MEANING');
4036: fnd_msg_pub.add;
4037: x_return_status := fnd_api.g_ret_sts_error;
4038: END IF;
4039: CLOSE c_exist_clas_catgry_typ_mng;
4040:
4041: END chk_exist_clas_catgry_typ_mng;