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_MSG_PUB

Line 51: fnd_msg_pub.add;

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;
55:

Line 62: fnd_msg_pub.add;

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
66: IF ((NOT p_miss_allowed_in_u) AND

Line 71: fnd_msg_pub.add;

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;
75: END check_mandatory_str_col;

Line 97: fnd_msg_pub.add;

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;
101:

Line 108: fnd_msg_pub.add;

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
112: IF ((NOT p_miss_allowed_in_u) AND

Line 117: fnd_msg_pub.add;

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;
121: END check_mandatory_date_col;

Line 143: fnd_msg_pub.add;

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;
147:

Line 154: fnd_msg_pub.add;

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
158: IF ((NOT p_miss_allowed_in_u) AND

Line 163: fnd_msg_pub.add;

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;
167: END check_mandatory_num_col;

Line 260: fnd_msg_pub.add;

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;
264: END IF;

Line 302: fnd_msg_pub.add;

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;
306: END IF;

Line 383: fnd_msg_pub.add;

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;
387: END check_existence_class_category;

Line 539: fnd_msg_pub.add;

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;
543: END check_start_end_active_dates;

Line 884: fnd_msg_pub.add;

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;
888:

Line 931: fnd_msg_pub.add;

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;
935:

Line 1014: fnd_msg_pub.add;

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;
1018:

Line 1042: fnd_msg_pub.add;

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;
1046:

Line 1056: fnd_msg_pub.add;

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:
1060: IF ( (p_class_cat_rec.allow_multi_parent_flag = 'N' )

Line 1095: fnd_msg_pub.add;

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:
1099: IF ( (p_class_cat_rec.allow_multi_assign_flag = 'N' )

Line 1136: fnd_msg_pub.add;

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:
1140: END IF;

Line 1148: FND_MSG_PUB.ADD;

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;
1152:

Line 1290: FND_MSG_PUB.ADD;

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;
1294: end;

Line 1312: fnd_msg_pub.add;

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:
1316: --check_err(x_return_status);

Line 1322: FND_MSG_PUB.ADD;

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;
1326:

Line 1877: fnd_msg_pub.add;

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)
1881: -- the assignment cannot be primary and secondary in the same time

Line 1899: fnd_msg_pub.add;

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:
1903: ELSIF p_primary_flag = 'N' THEN

Line 1923: fnd_msg_pub.add;

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:
1927: END IF;

Line 2317: FND_MSG_PUB.ADD;

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;
2321: END IF;

Line 2343: fnd_msg_pub.add;

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:
2347: -- If the flag is set to 'N", do the validation

Line 2450: FND_MSG_PUB.ADD;

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

Line 2474: -- FND_MSG_PUB.ADD;

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;
2478: -- END IF;

Line 2539: FND_MSG_PUB.ADD;

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;
2543: EXCEPTION

Line 2567: FND_MSG_PUB.ADD;

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

Line 2620: FND_MSG_PUB.ADD;

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;
2624:

Line 2634: FND_MSG_PUB.ADD;

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
2638: THEN

Line 2642: FND_MSG_PUB.ADD;

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;*/
2646: --End of code commented in the fix for Bug number 3053541.

Line 2701: FND_MSG_PUB.ADD;

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;
2705: */

Line 2742: FND_MSG_PUB.ADD;

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
2745: --RAISE G_EX_INVALID_PARAM;
2746: EXIT;

Line 2769: FND_MSG_PUB.ADD;

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;
2773: END IF;--Bug No 3053541.

Line 2793: * FND_MSG_PUB.ADD;

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;
2797: * ELSIF is_between(v_rec.start_date_active, p_in_rec.start_date_active, p_in_rec.end_date_active ) OR

Line 2803: * FND_MSG_PUB.ADD;

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;
2807: * END LOOP;

Line 2837: FND_MSG_PUB.ADD;

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
2840: --RAISE G_EX_INVALID_PARAM;
2841: EXIT;

Line 2908: FND_MSG_PUB.ADD;

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;
2910: --Bug 3962783
2911: --RAISE G_EX_INVALID_PARAM;
2912: END IF;

Line 2935: FND_MSG_PUB.ADD;

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;
2939: END IF;

Line 2949: FND_MSG_PUB.ADD;

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;
2953: END IF;

Line 2964: FND_MSG_PUB.ADD;

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;
2968: END IF;

Line 2979: FND_MSG_PUB.ADD;

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;
2983: END IF;

Line 2994: FND_MSG_PUB.ADD;

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;
2998: END IF;

Line 3016: FND_MSG_PUB.ADD;

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;
3020: END IF;

Line 3027: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

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;
3030: END LOOP;
3031: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 3029: FND_MSG_PUB.ADD;

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: */
3033: END;

Line 3724: fnd_msg_pub.add;

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;
3728: END IF;

Line 3760: -- fnd_msg_pub.add;

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

Line 3765: 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;
3769:

Line 3784: -- fnd_msg_pub.add;

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

Line 3789: 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;
3793: END IF;

Line 3805: fnd_msg_pub.add;

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

Line 3829: fnd_msg_pub.add;

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

Line 3857: fnd_msg_pub.add;

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

Line 3876: fnd_msg_pub.add;

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

Line 3902: fnd_msg_pub.add;

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

Line 3913: FND_MSG_PUB.ADD;

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;
3917:

Line 3973: fnd_msg_pub.add;

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;
3977:

Line 4036: fnd_msg_pub.add;

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;
4040: