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_MESSAGE

Line 49: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

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;
53: RETURN;

Line 50: fnd_message.set_token('COLUMN', p_col_name);

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;
53: RETURN;
54: END IF;

Line 60: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

56: IF (create_update_flag = 'C') THEN
57: IF ((NOT p_miss_allowed_in_c) AND
58: p_col_val IS NULL )
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;

Line 61: fnd_message.set_token('COLUMN', p_col_name);

57: IF ((NOT p_miss_allowed_in_c) AND
58: p_col_val IS NULL )
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

Line 69: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

65: ELSE
66: IF ((NOT p_miss_allowed_in_u) AND
67: p_col_val IS NULL )
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;

Line 70: fnd_message.set_token('COLUMN', p_col_name);

66: IF ((NOT p_miss_allowed_in_u) AND
67: p_col_val IS NULL )
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;

Line 95: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

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;
99: RETURN;

Line 96: fnd_message.set_token('COLUMN', p_col_name);

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;
99: RETURN;
100: END IF;

Line 106: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

102: IF (create_update_flag = 'C') THEN
103: IF ((NOT p_miss_allowed_in_c) AND
104: p_col_val IS NULL )
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;

Line 107: fnd_message.set_token('COLUMN', p_col_name);

103: IF ((NOT p_miss_allowed_in_c) AND
104: p_col_val IS NULL )
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

Line 115: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

111: ELSE
112: IF ((NOT p_miss_allowed_in_u) AND
113: p_col_val IS NULL )
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;

Line 116: fnd_message.set_token('COLUMN', p_col_name);

112: IF ((NOT p_miss_allowed_in_u) AND
113: p_col_val IS NULL )
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;

Line 141: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

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;
145: RETURN;

Line 142: fnd_message.set_token('COLUMN', p_col_name);

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;
145: RETURN;
146: END IF;

Line 152: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

148: IF (create_update_flag = 'C') THEN
149: IF ((NOT p_miss_allowed_in_c) AND
150: p_col_val IS NULL )
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;

Line 153: fnd_message.set_token('COLUMN', p_col_name);

149: IF ((NOT p_miss_allowed_in_c) AND
150: p_col_val IS NULL )
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

Line 161: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

157: ELSE
158: IF ((NOT p_miss_allowed_in_u) AND
159: p_col_val IS NULL )
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;

Line 162: fnd_message.set_token('COLUMN', p_col_name);

158: IF ((NOT p_miss_allowed_in_u) AND
159: p_col_val IS NULL )
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;

Line 257: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');

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');
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;

Line 258: fnd_message.set_token('COLUMN',p_column);

254: OPEN c1;
255: FETCH c1 INTO l_exist;
256: IF c1%NOTFOUND THEN
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;

Line 259: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);

255: FETCH c1 INTO l_exist;
256: IF c1%NOTFOUND THEN
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;

Line 299: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');

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');
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;

Line 300: fnd_message.set_token('COLUMN',p_column);

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');
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;

Line 301: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);

297: FETCH c_nace INTO l_exist;
298: IF c_nace%NOTFOUND THEN
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;

Line 379: fnd_message.set_name('AR','HZ_API_INVALID_FK');

375: BEGIN
376: OPEN c_exist_class_category(p_class_category);
377: FETCH c_exist_class_category INTO l_exist;
378: IF c_exist_class_category%NOTFOUND THEN
379: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 380: fnd_message.set_token('FK','class_category');

376: OPEN c_exist_class_category(p_class_category);
377: FETCH c_exist_class_category INTO l_exist;
378: IF c_exist_class_category%NOTFOUND THEN
379: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 381: fnd_message.set_token('COLUMN','class_category');

377: FETCH c_exist_class_category INTO l_exist;
378: IF c_exist_class_category%NOTFOUND THEN
379: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 382: fnd_message.set_token('TABLE','hz_class_categories');

378: IF c_exist_class_category%NOTFOUND THEN
379: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 538: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');

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;
540: x_return_status := fnd_api.g_ret_sts_error;
541: END IF;
542: END IF;

Line 882: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

878: END IF;
879:
880: IF l_error THEN
881: IF p_raise_error = 'Y' THEN
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;

Line 883: fnd_message.set_token('COLUMN', p_column);

879:
880: IF l_error THEN
881: IF p_raise_error = 'Y' THEN
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;

Line 929: fnd_message.set_name('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

925: END IF;
926:
927: IF l_error THEN
928: IF p_raise_error = 'Y' THEN
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;

Line 930: fnd_message.set_token('COLUMN', p_column);

926:
927: IF l_error THEN
928: IF p_raise_error = 'Y' THEN
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;

Line 1011: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');

1007: --Check for lookup type validations.
1008: OPEN cu_lookup_type;
1009: FETCH cu_lookup_type INTO l_count;
1010: IF cu_lookup_type%NOTFOUND THEN
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;

Line 1012: fnd_message.set_token('COLUMN', 'class_category');

1008: OPEN cu_lookup_type;
1009: FETCH cu_lookup_type INTO l_count;
1010: IF cu_lookup_type%NOTFOUND THEN
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;

Line 1013: fnd_message.set_token('LOOKUP_TYPE', p_class_cat_rec.class_category);

1009: FETCH cu_lookup_type INTO l_count;
1010: IF cu_lookup_type%NOTFOUND THEN
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;

Line 1040: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

1036:
1037: -- Check PK
1038: IF create_update_flag = 'C' THEN
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;

Line 1041: fnd_message.set_token('COLUMN', p_class_cat_rec.class_category);

1037: -- Check PK
1038: IF create_update_flag = 'C' THEN
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;

Line 1054: fnd_message.set_name('AR', 'HZ_API_LEAF_ONLY_NOT_ALLOWED');

1050:
1051: IF ( (p_class_cat_rec.allow_leaf_node_only_flag = 'Y' )
1052: AND (exist_code_ass_not_node(p_class_cat_rec.class_category) = 'Y' ) )
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;

Line 1055: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);

1051: IF ( (p_class_cat_rec.allow_leaf_node_only_flag = 'Y' )
1052: AND (exist_code_ass_not_node(p_class_cat_rec.class_category) = 'Y' ) )
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:

Line 1086: fnd_message.set_name('AR', 'HZ_API_SIN_PAR_NOT_ALLOWED');

1082: ELSE
1083: l_end2 := TO_CHAR(l_end_date_active2, 'DD-MON-RRRR');
1084: END IF;
1085:
1086: fnd_message.set_name('AR', 'HZ_API_SIN_PAR_NOT_ALLOWED');
1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);

Line 1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);

1083: l_end2 := TO_CHAR(l_end_date_active2, 'DD-MON-RRRR');
1084: END IF;
1085:
1086: fnd_message.set_name('AR', 'HZ_API_SIN_PAR_NOT_ALLOWED');
1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);

Line 1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);

1084: END IF;
1085:
1086: fnd_message.set_name('AR', 'HZ_API_SIN_PAR_NOT_ALLOWED');
1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
1092: fnd_message.set_token('END1' , l_end);

Line 1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);

1085:
1086: fnd_message.set_name('AR', 'HZ_API_SIN_PAR_NOT_ALLOWED');
1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
1092: fnd_message.set_token('END1' , l_end);
1093: fnd_message.set_token('START2' , l_start2);

Line 1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);

1086: fnd_message.set_name('AR', 'HZ_API_SIN_PAR_NOT_ALLOWED');
1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
1092: fnd_message.set_token('END1' , l_end);
1093: fnd_message.set_token('START2' , l_start2);
1094: fnd_message.set_token('END2' , l_end2);

Line 1091: fnd_message.set_token('START1' , l_start);

1087: fnd_message.set_token('CLASS_CATEGORY', p_class_cat_rec.class_category);
1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
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;

Line 1092: fnd_message.set_token('END1' , l_end);

1088: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
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;

Line 1093: fnd_message.set_token('START2' , l_start2);

1089: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
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;

Line 1094: fnd_message.set_token('END2' , l_end2);

1090: fnd_message.set_token('CLASS_CODE3' , l_class_code3);
1091: fnd_message.set_token('START1' , l_start);
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:

Line 1125: fnd_message.set_name('AR', 'HZ_API_SIN_ASS_NOT_ALLOWED');

1121: ELSE
1122: l_end2 := TO_CHAR(l_end_date_active2, 'DD-MON-RRRR');
1123: END IF;
1124:
1125: fnd_message.set_name('AR', 'HZ_API_SIN_ASS_NOT_ALLOWED');
1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);
1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);

Line 1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);

1122: l_end2 := TO_CHAR(l_end_date_active2, 'DD-MON-RRRR');
1123: END IF;
1124:
1125: fnd_message.set_name('AR', 'HZ_API_SIN_ASS_NOT_ALLOWED');
1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);
1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);

Line 1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);

1123: END IF;
1124:
1125: fnd_message.set_name('AR', 'HZ_API_SIN_ASS_NOT_ALLOWED');
1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);
1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);

Line 1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);

1124:
1125: fnd_message.set_name('AR', 'HZ_API_SIN_ASS_NOT_ALLOWED');
1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);
1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);

Line 1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);

1125: fnd_message.set_name('AR', 'HZ_API_SIN_ASS_NOT_ALLOWED');
1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);
1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
1133: fnd_message.set_token('END1' , l_end_date_active);

Line 1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);

1126: fnd_message.set_token('CLASS_CATEGORY' , p_class_cat_rec.class_category);
1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
1133: fnd_message.set_token('END1' , l_end_date_active);
1134: fnd_message.set_token('START2' , l_start_date_active2);

Line 1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);

1127: fnd_message.set_token('OWNER_TABLE' , l_owner_table_name);
1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
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);

Line 1132: fnd_message.set_token('START1' , l_start_date_active);

1128: fnd_message.set_token('OWNER_TABLE_ID' , l_owner_table_id);
1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
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;

Line 1133: fnd_message.set_token('END1' , l_end_date_active);

1129: fnd_message.set_token('CONTENT_SOURCE_TYPE', l_content_source_type);
1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
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;

Line 1134: fnd_message.set_token('START2' , l_start_date_active2);

1130: fnd_message.set_token('CLASS_CODE1' , l_class_code);
1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
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;

Line 1135: fnd_message.set_token('END2' , l_end_date_active2);

1131: fnd_message.set_token('CLASS_CODE2' , l_class_code2);
1132: fnd_message.set_token('START1' , l_start_date_active);
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:

Line 1146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1142: --}
1143: /* -- Bug 3962783
1144: EXCEPTION
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: */

Line 1147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1143: /* -- Bug 3962783
1144: EXCEPTION
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;

Line 1289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_OBJ_NAME');

1285: exception
1286: when no_data_found then
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;

Line 1309: fnd_message.set_name('AR','HZ_API_USE_ONCE_OWNER_TABLE');

1305: --HYU
1306: IF ( existence_couple_clacat_owntab( create_update_flag,
1307: p_in_rec.class_category,
1308: p_in_rec.owner_table) = 'Y' ) THEN
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;

Line 1310: fnd_message.set_token('CLASS_CATEGORY',p_in_rec.class_category);

1306: IF ( existence_couple_clacat_owntab( create_update_flag,
1307: p_in_rec.class_category,
1308: p_in_rec.owner_table) = 'Y' ) THEN
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;

Line 1311: fnd_message.set_token('OWNER_TABLE' ,p_in_rec.owner_table);

1307: p_in_rec.class_category,
1308: p_in_rec.owner_table) = 'Y' ) THEN
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:

Line 1320: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1316: --check_err(x_return_status);
1317: /* -- Bug 3962783
1318: EXCEPTION
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: */

Line 1321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1317: /* -- Bug 3962783
1318: EXCEPTION
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;

Line 1873: fnd_message.set_name('AR' , 'HZ_API_DUP_COL_PRIM');

1869: l_class_code ,
1870: l_start_date ,
1871: l_end_date ) = 'Y' then
1872:
1873: fnd_message.set_name('AR' , 'HZ_API_DUP_COL_PRIM');
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;

Line 1874: fnd_message.set_token('CLASS_CODE', l_class_code);

1870: l_start_date ,
1871: l_end_date ) = 'Y' then
1872:
1873: fnd_message.set_name('AR' , 'HZ_API_DUP_COL_PRIM');
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;

Line 1875: fnd_message.set_token('START_DATE_ACTIVE', l_start_date);

1871: l_end_date ) = 'Y' then
1872:
1873: fnd_message.set_name('AR' , 'HZ_API_DUP_COL_PRIM');
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:

Line 1876: fnd_message.set_token('END_DATE_ACTIVE' , l_end_date);

1872:
1873: fnd_message.set_name('AR' , 'HZ_API_DUP_COL_PRIM');
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)

Line 1895: fnd_message.set_name('AR', 'HZ_API_DUP_COD_PRIM_SECOND');

1891: l_class_code ,
1892: l_start_date ,
1893: l_end_date ) = 'Y'
1894: then
1895: fnd_message.set_name('AR', 'HZ_API_DUP_COD_PRIM_SECOND');
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;

Line 1896: fnd_message.set_token('CLASS_CODE', l_class_code);

1892: l_start_date ,
1893: l_end_date ) = 'Y'
1894: then
1895: fnd_message.set_name('AR', 'HZ_API_DUP_COD_PRIM_SECOND');
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;

Line 1897: fnd_message.set_token('START_DATE_ACTIVE', l_start_date);

1893: l_end_date ) = 'Y'
1894: then
1895: fnd_message.set_name('AR', 'HZ_API_DUP_COD_PRIM_SECOND');
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;

Line 1898: fnd_message.set_token('END_DATE_ACTIVE' , l_end_date);

1894: then
1895: fnd_message.set_name('AR', 'HZ_API_DUP_COD_PRIM_SECOND');
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:

Line 1919: fnd_message.set_name('AR', 'HZ_API_DUP_COD_SECOND');

1915: l_start_date ,
1916: l_end_date ) = 'Y'
1917: then
1918:
1919: fnd_message.set_name('AR', 'HZ_API_DUP_COD_SECOND');
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;

Line 1920: fnd_message.set_token('CLASS_CODE', l_class_code);

1916: l_end_date ) = 'Y'
1917: then
1918:
1919: fnd_message.set_name('AR', 'HZ_API_DUP_COD_SECOND');
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;

Line 1921: fnd_message.set_token('START_DATE_ACTIVE', l_start_date);

1917: then
1918:
1919: fnd_message.set_name('AR', 'HZ_API_DUP_COD_SECOND');
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;

Line 1922: fnd_message.set_token('END_DATE_ACTIVE' , l_end_date);

1918:
1919: fnd_message.set_name('AR', 'HZ_API_DUP_COD_SECOND');
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:

Line 2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

2309: FROM hz_class_categories
2310: WHERE class_category = p_in_rec.class_category;
2311:
2312: IF l_count = 0 THEN
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 2314: FND_MESSAGE.SET_TOKEN('FK', 'class_category');

2310: WHERE class_category = p_in_rec.class_category;
2311:
2312: IF l_count = 0 THEN
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 2315: FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category');

2311:
2312: IF l_count = 0 THEN
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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:

Line 2316: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_class_categories');

2312: IF l_count = 0 THEN
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 2339: fnd_message.set_name('AR','HZ_API_INVALID_FK');

2335: class_category = nvl(p_in_rec.class_category,l_class_category);
2336:
2337: Exception
2338: When no_data_found then
2339: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 2340: fnd_message.set_token('FK','class_category');

2336:
2337: Exception
2338: When no_data_found then
2339: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 2341: fnd_message.set_token('COLUMN','class_category');

2337: Exception
2338: When no_data_found then
2339: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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;

Line 2342: fnd_message.set_token('TABLE','hz_class_categories');

2338: When no_data_found then
2339: fnd_message.set_name('AR','HZ_API_INVALID_FK');
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:

Line 2449: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ALLOW_MUL_ASSIGN_FG');

2445: ;
2446: end if;
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;

Line 2470: -- FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

2466: -- FROM hz_parties
2467: -- WHERE party_id = p_in_rec.owner_table_id;
2468: --
2469: -- IF l_count = 0 THEN
2470: -- FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 2471: -- FND_MESSAGE.SET_TOKEN('FK', p_in_rec.owner_table_name);

2467: -- WHERE party_id = p_in_rec.owner_table_id;
2468: --
2469: -- IF l_count = 0 THEN
2470: -- FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 2472: -- FND_MESSAGE.SET_TOKEN('COLUMN', p_in_rec.owner_table_id);

2468: --
2469: -- IF l_count = 0 THEN
2470: -- FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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: --

Line 2473: -- FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

2469: -- IF l_count = 0 THEN
2470: -- FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 2537: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

2533: )
2534: );
2535: if allow_leaf_error = 'Y' THEN
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;

Line 2538: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_assignment_id');

2534: );
2535: if allow_leaf_error = 'Y' THEN
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;

Line 2566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_LEAFNODE_FLAG');

2562: nvl(p_in_rec.start_date_active, l_start_date_active) between start_date_active and nvl(end_date_active, to_date('4712/12/31','YYYY/MM/DD'))
2563: ) and
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;

Line 2618: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2614: OR
2615: create_update_flag='C'
2616: );
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

Line 2619: FND_MESSAGE.SET_TOKEN('COLUMN', 'owner_table_name-owner_table_id-class_category-class_code-actual_content_source-start_date_active');

2615: create_update_flag='C'
2616: );
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;

Line 2632: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2628: --Bug 2977428 : Changed the condition for unique combination columns
2629: --to check only when create_update_flag = 'C'.
2630: IF create_update_flag = 'C'
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;

Line 2633: FND_MESSAGE.SET_TOKEN('COLUMN', 'owner_table_name-owner_table_id-class_category-class_code-content_source_type-start_date_active');

2629: --to check only when create_update_flag = 'C'.
2630: IF create_update_flag = 'C'
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

Line 2640: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

2636: RAISE G_EX_INVALID_PARAM;
2637: ELSIF l_id <>p_in_rec.code_assignment_id
2638: THEN
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;

Line 2641: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_assignment_id');

2637: ELSIF l_id <>p_in_rec.code_assignment_id
2638: THEN
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;*/

Line 2699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

2695: /* IF ( l_count>0 ) AND (l_end_date IS NOT NULL)
2696: AND (l_end_date <> p_in_rec.end_date_active)
2697: THEN
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;

Line 2700: FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');

2696: AND (l_end_date <> p_in_rec.end_date_active)
2697: THEN
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;

Line 2738: --FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

2734: THEN
2735: -- AN overlapping ONE EXISTS
2736:
2737: -- Bug 3021505.
2738: --FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
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;

Line 2739: --FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');

2735: -- AN overlapping ONE EXISTS
2736:
2737: -- Bug 3021505.
2738: --FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
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;

Line 2740: FND_MESSAGE.SET_NAME('AR','HZ_API_PRI_CODE_OVERLAP');

2736:
2737: -- Bug 3021505.
2738: --FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
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

Line 2768: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');

2764: nvl(l_date, l_end_date_active),
2765: v_rec.start_date_active,
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;

Line 2791: * FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

2787: * -- reviving?
2788: * IF (v_rec.end_date_active <= v_rec.start_date_active ) OR
2789: * (v_rec.end_date_active <= l_now )
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;

Line 2792: * FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');

2788: * IF (v_rec.end_date_active <= v_rec.start_date_active ) OR
2789: * (v_rec.end_date_active <= l_now )
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;

Line 2801: * FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

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 )
2799: * THEN
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;

Line 2802: * FND_MESSAGE.SET_TOKEN('COLUMN', 'end_date_active');

2798: * is_between(p_in_rec.start_date_active, v_rec.start_date_active, v_rec.end_date_active )
2799: * THEN
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;

Line 2832: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2828: THEN
2829: -- AN overlapping ONE EXISTS
2830:
2831: /* Bug 3289620.
2832: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2833: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');
2834: */
2835: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2836:

Line 2833: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');

2829: -- AN overlapping ONE EXISTS
2830:
2831: /* Bug 3289620.
2832: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2833: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');
2834: */
2835: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2836:
2837: FND_MSG_PUB.ADD;

Line 2835: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');

2831: /* Bug 3289620.
2832: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2833: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');
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

Line 2902: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2898: THEN
2899: -- overlaps with this existing one
2900:
2901: /* Bug 3289620.
2902: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2903: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');
2904: */
2905: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2906:

Line 2903: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');

2899: -- overlaps with this existing one
2900:
2901: /* Bug 3289620.
2902: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2903: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');
2904: */
2905: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');
2906:
2907:

Line 2905: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_CODE_ASSG_DATE_OVERLAP');

2901: /* Bug 3289620.
2902: | FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2903: | FND_MESSAGE.SET_TOKEN('COLUMN', 'class_category-class_code');
2904: */
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;

Line 2932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION2');

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');
2935: FND_MSG_PUB.ADD;
2936: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2933: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_id');

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');
2935: FND_MSG_PUB.ADD;
2936: x_return_status := FND_API.G_RET_STS_ERROR;
2937: --Bug 3962783

Line 2934: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_1');

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');
2935: FND_MSG_PUB.ADD;
2936: x_return_status := FND_API.G_RET_STS_ERROR;
2937: --Bug 3962783
2938: --RAISE G_EX_INVALID_PARAM;

Line 2946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

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');
2949: FND_MSG_PUB.ADD;
2950: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2947: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_1');

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');
2949: FND_MSG_PUB.ADD;
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: --Bug 3962783

Line 2948: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_2');

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');
2949: FND_MSG_PUB.ADD;
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: --Bug 3962783
2952: --RAISE G_EX_INVALID_PARAM;

Line 2961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

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');
2964: FND_MSG_PUB.ADD;
2965: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2962: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_2');

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');
2964: FND_MSG_PUB.ADD;
2965: x_return_status := FND_API.G_RET_STS_ERROR;
2966: --Bug 3962783

Line 2963: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_3');

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');
2964: FND_MSG_PUB.ADD;
2965: x_return_status := FND_API.G_RET_STS_ERROR;
2966: --Bug 3962783
2967: --RAISE G_EX_INVALID_PARAM;

Line 2976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

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');
2979: FND_MSG_PUB.ADD;
2980: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2977: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_3');

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');
2979: FND_MSG_PUB.ADD;
2980: x_return_status := FND_API.G_RET_STS_ERROR;
2981: --Bug 3962783

Line 2978: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_4');

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');
2979: FND_MSG_PUB.ADD;
2980: x_return_status := FND_API.G_RET_STS_ERROR;
2981: --Bug 3962783
2982: --RAISE G_EX_INVALID_PARAM;

Line 2991: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_COMBINATION1');

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');
2994: FND_MSG_PUB.ADD;
2995: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2992: FND_MESSAGE.SET_TOKEN('COLUMN1', 'owner_table_key_4');

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');
2994: FND_MSG_PUB.ADD;
2995: x_return_status := FND_API.G_RET_STS_ERROR;
2996: --Bug 3962783

Line 2993: FND_MESSAGE.SET_TOKEN('COLUMN2', 'owner_table_key_5');

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');
2994: FND_MSG_PUB.ADD;
2995: x_return_status := FND_API.G_RET_STS_ERROR;
2996: --Bug 3962783
2997: --RAISE G_EX_INVALID_PARAM;

Line 3015: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PRIMARY_KEY');

3011: p_key_5 => p_in_rec.owner_table_key_5
3012: );
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;

Line 3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

3021: END IF;
3022: /* -- Bug 3962783
3023: EXCEPTION
3024: WHEN OTHERS THEN
3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3026: -- Loop through to put the other error messages in fnd stack
3027: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
3028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3029: FND_MSG_PUB.ADD;

Line 3028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3024: WHEN OTHERS THEN
3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3026: -- Loop through to put the other error messages in fnd stack
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: */

Line 3723: fnd_message.set_name('AR', 'HZ_API_CLASS_CODE_VAL');

3719: ------------------------------------------------------
3720: ---- Validation for class code and sub clas code ----
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;

Line 3756: -- fnd_message.set_string( p_in_rec.sub_class_code ||

3752: l_end := 'Unspecified';
3753: ELSE
3754: l_end := to_char(p_in_rec.end_date_active,'DD-MON-RRRR');
3755: END IF;
3756: -- fnd_message.set_string( p_in_rec.sub_class_code ||
3757: -- ' has already been defined as ascendant of ' || p_in_rec.class_code ||
3758: -- ' for a period that overlaps the period started from ' || to_char(p_in_rec.start_date_active,'DD-MON-RRRR') ||
3759: -- ' to ' || l_end);
3760: -- fnd_msg_pub.add;

Line 3762: fnd_message.set_name('AR', 'HZ_API_CIRCULAR_CODE_RELATION');

3758: -- ' for a period that overlaps the period started from ' || to_char(p_in_rec.start_date_active,'DD-MON-RRRR') ||
3759: -- ' to ' || l_end);
3760: -- fnd_msg_pub.add;
3761: --Bug 4897711 : Added error message
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;

Line 3763: fnd_message.set_token('CLASS_CODE1', p_in_rec.class_code);

3759: -- ' to ' || l_end);
3760: -- fnd_msg_pub.add;
3761: --Bug 4897711 : Added error message
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

Line 3764: fnd_message.set_token('CLASS_CODE2', p_in_rec.sub_class_code);

3760: -- fnd_msg_pub.add;
3761: --Bug 4897711 : Added error message
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;

Line 3780: -- fnd_message.set_string( p_in_rec.class_code ||

3776: l_end := 'Unspecified';
3777: ELSE
3778: l_end := to_char(p_in_rec.end_date_active,'DD-MON-RRRR');
3779: END IF;
3780: -- fnd_message.set_string( p_in_rec.class_code ||
3781: -- ' has already been defined as descendant of ' || p_in_rec.sub_class_code ||
3782: -- ' for a period that overlaps the period started from ' || to_char(p_in_rec.start_date_active,'DD-MON-RRRR') ||
3783: -- ' to ' || l_end);
3784: -- fnd_msg_pub.add;

Line 3786: fnd_message.set_name('AR', 'HZ_API_CIRCULAR_CODE_RELATION');

3782: -- ' for a period that overlaps the period started from ' || to_char(p_in_rec.start_date_active,'DD-MON-RRRR') ||
3783: -- ' to ' || l_end);
3784: -- fnd_msg_pub.add;
3785: --Bug 4897711 : Added error message
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;

Line 3787: fnd_message.set_token('CLASS_CODE1', p_in_rec.class_code);

3783: -- ' to ' || l_end);
3784: -- fnd_msg_pub.add;
3785: --Bug 4897711 : Added error message
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

Line 3788: fnd_message.set_token('CLASS_CODE2', p_in_rec.sub_class_code);

3784: -- fnd_msg_pub.add;
3785: --Bug 4897711 : Added error message
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;

Line 3803: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

3799: p_in_rec.class_code ,
3800: p_in_rec.sub_class_code,
3801: p_in_rec.start_date_active,
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

Line 3804: fnd_message.set_token('COLUMN', 'class_category-class_code-sub_class_code-start_date_active');

3800: p_in_rec.sub_class_code,
3801: p_in_rec.start_date_active,
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;

Line 3828: fnd_message.set_name('AR', 'HZ_API_CLASS_REL_OVERLAP');

3824: p_in_rec.end_date_active ,
3825: -- Bug 4897711
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;

Line 3850: fnd_message.set_name('AR', 'HZ_API_MULTI_PARENT_FORBID');

3846: l_end := 'Unspecified';
3847: ELSE
3848: l_end := TO_CHAR(l_end_date_active, 'DD-MON-RRRR');
3849: END IF;
3850: fnd_message.set_name('AR', 'HZ_API_MULTI_PARENT_FORBID');
3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);
3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
3854: fnd_message.set_token('CLASS_CODE1' , l_class_code);

Line 3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);

3847: ELSE
3848: l_end := TO_CHAR(l_end_date_active, 'DD-MON-RRRR');
3849: END IF;
3850: fnd_message.set_name('AR', 'HZ_API_MULTI_PARENT_FORBID');
3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);
3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
3854: fnd_message.set_token('CLASS_CODE1' , l_class_code);
3855: fnd_message.set_token('START1' , l_start_date_active);

Line 3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);

3848: l_end := TO_CHAR(l_end_date_active, 'DD-MON-RRRR');
3849: END IF;
3850: fnd_message.set_name('AR', 'HZ_API_MULTI_PARENT_FORBID');
3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);
3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
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 );

Line 3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);

3849: END IF;
3850: fnd_message.set_name('AR', 'HZ_API_MULTI_PARENT_FORBID');
3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);
3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
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;

Line 3854: fnd_message.set_token('CLASS_CODE1' , l_class_code);

3850: fnd_message.set_name('AR', 'HZ_API_MULTI_PARENT_FORBID');
3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);
3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
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;

Line 3855: fnd_message.set_token('START1' , l_start_date_active);

3851: fnd_message.set_token('CLASS_CATEGORY', p_in_rec.class_category);
3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
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

Line 3856: fnd_message.set_token('END1' , l_end_date_active );

3852: fnd_message.set_token('CLASS_CODE3' , p_in_rec.sub_class_code);
3853: fnd_message.set_token('CLASS_CODE2' , p_in_rec.class_code);
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;

Line 3874: fnd_message.set_name('AR', 'HZ_API_REL_NOT_EXIST');

3870: p_in_rec.sub_class_code,
3871: p_in_rec.start_date_active,
3872: l_end) = 'N') then
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

Line 3875: fnd_message.set_token('COLUMN', 'start_date_active-end_date_active');

3871: p_in_rec.start_date_active,
3872: l_end) = 'N') then
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;

Line 3900: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

3896: -- Bug 4897711
3897: la_start,
3898: la_end ) = 'Y') then
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

Line 3901: fnd_message.set_token('COLUMN', 'class_category-class_code-sub_class_code-start_date_active');

3897: la_start,
3898: la_end ) = 'Y') then
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;

Line 3911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

3907: end if;
3908: /* -- Bug 3962783
3909: EXCEPTION
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: */

Line 3912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3908: /* -- Bug 3962783
3909: EXCEPTION
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;

Line 3972: fnd_message.set_name('AR','HZ_API_DUP_CLASS');

3968:
3969: OPEN c_exist_class_catgry_type_code(p_class_category_type, p_class_category_code, p_security_group_id, p_view_application_id);
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;

Line 4035: fnd_message.set_name('AR','HZ_API_DUP_CLASS_TYPE_MEANING');

4031:
4032: OPEN c_exist_clas_catgry_typ_mng(p_class_category_type, p_class_category_meaning, p_security_group_id, p_view_application_id);
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;