173:
174: BEGIN
175:
176: IF p_column_value IS NOT NULL AND
177: p_column_value <> FND_API.G_MISS_CHAR THEN
178:
179: IF p_lookup_type = 'YES/NO' THEN
180: IF p_column_value NOT IN ('Y', 'N') THEN
181: l_error := TRUE;
195: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
196: FND_MESSAGE.SET_TOKEN('COLUMN', p_column);
197: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', p_lookup_type);
198: FND_MSG_PUB.ADD;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: END IF;
201:
202: END IF;
203:
218: AND ROWNUM = 1;
219: l_exist VARCHAR2(1);
220: BEGIN
221: IF ( p_column_value IS NOT NULL
222: AND p_column_value <> fnd_api.g_miss_char ) THEN
223: OPEN c1;
224: FETCH c1 INTO l_exist;
225: IF c1%NOTFOUND THEN
226: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
226: fnd_message.set_name('AR','HZ_API_INVALID_LOOKUP');
227: fnd_message.set_token('COLUMN',p_column);
228: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
229: fnd_msg_pub.add;
230: x_return_status := fnd_api.g_ret_sts_error;
231: END IF;
232: CLOSE c1;
233: END IF;
234: END validate_fnd_lookup;
504: IF (p_col_val IS NULL) THEN
505: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
506: fnd_message.set_token('COLUMN', p_col_name);
507: fnd_msg_pub.add;
508: x_return_status := fnd_api.g_ret_sts_error;
509: RETURN;
510: END IF;
511:
512: IF (create_update_flag = 'C') THEN
510: END IF;
511:
512: IF (create_update_flag = 'C') THEN
513: IF ((NOT p_miss_allowed_in_c) AND
514: p_col_val = fnd_api.G_MISS_CHAR )
515: THEN
516: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
517: fnd_message.set_token('COLUMN', p_col_name);
518: fnd_msg_pub.add;
515: THEN
516: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
517: fnd_message.set_token('COLUMN', p_col_name);
518: fnd_msg_pub.add;
519: x_return_status := fnd_api.g_ret_sts_error;
520: END IF;
521: ELSE
522: IF ((NOT p_miss_allowed_in_u) AND
523: p_col_val = fnd_api.G_MISS_CHAR )
519: x_return_status := fnd_api.g_ret_sts_error;
520: END IF;
521: ELSE
522: IF ((NOT p_miss_allowed_in_u) AND
523: p_col_val = fnd_api.G_MISS_CHAR )
524: THEN
525: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
526: fnd_message.set_token('COLUMN', p_col_name);
527: fnd_msg_pub.add;
524: THEN
525: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
526: fnd_message.set_token('COLUMN', p_col_name);
527: fnd_msg_pub.add;
528: x_return_status := fnd_api.g_ret_sts_error;
529: END IF;
530: END IF;
531: END check_mandatory_str_col;
532:
549: IF (p_col_val IS NULL) THEN
550: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
551: fnd_message.set_token('COLUMN', p_col_name);
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.g_ret_sts_error;
554: RETURN;
555: END IF;
556:
557: IF (create_update_flag = 'C') THEN
555: END IF;
556:
557: IF (create_update_flag = 'C') THEN
558: IF ((NOT p_miss_allowed_in_c) AND
559: p_col_val = fnd_api.G_MISS_DATE )
560: THEN
561: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
562: fnd_message.set_token('COLUMN', p_col_name);
563: fnd_msg_pub.add;
560: THEN
561: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
562: fnd_message.set_token('COLUMN', p_col_name);
563: fnd_msg_pub.add;
564: x_return_status := fnd_api.g_ret_sts_error;
565: END IF;
566: ELSE
567: IF ((NOT p_miss_allowed_in_u) AND
568: p_col_val = fnd_api.G_MISS_DATE )
564: x_return_status := fnd_api.g_ret_sts_error;
565: END IF;
566: ELSE
567: IF ((NOT p_miss_allowed_in_u) AND
568: p_col_val = fnd_api.G_MISS_DATE )
569: THEN
570: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
571: fnd_message.set_token('COLUMN', p_col_name);
572: fnd_msg_pub.add;
569: THEN
570: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
571: fnd_message.set_token('COLUMN', p_col_name);
572: fnd_msg_pub.add;
573: x_return_status := fnd_api.g_ret_sts_error;
574: END IF;
575: END IF;
576: END check_mandatory_date_col;
577:
594: IF (p_col_val IS NULL) THEN
595: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
596: fnd_message.set_token('COLUMN', p_col_name);
597: fnd_msg_pub.add;
598: x_return_status := fnd_api.g_ret_sts_error;
599: RETURN;
600: END IF;
601:
602: IF (create_update_flag = 'C') THEN
600: END IF;
601:
602: IF (create_update_flag = 'C') THEN
603: IF ((NOT p_miss_allowed_in_c) AND
604: p_col_val = fnd_api.G_MISS_NUM )
605: THEN
606: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
607: fnd_message.set_token('COLUMN', p_col_name);
608: fnd_msg_pub.add;
605: THEN
606: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
607: fnd_message.set_token('COLUMN', p_col_name);
608: fnd_msg_pub.add;
609: x_return_status := fnd_api.g_ret_sts_error;
610: END IF;
611: ELSE
612: IF ((NOT p_miss_allowed_in_u) AND
613: p_col_val = fnd_api.G_MISS_NUM )
609: x_return_status := fnd_api.g_ret_sts_error;
610: END IF;
611: ELSE
612: IF ((NOT p_miss_allowed_in_u) AND
613: p_col_val = fnd_api.G_MISS_NUM )
614: THEN
615: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
616: fnd_message.set_token('COLUMN', p_col_name);
617: fnd_msg_pub.add;
614: THEN
615: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
616: fnd_message.set_token('COLUMN', p_col_name);
617: fnd_msg_pub.add;
618: x_return_status := fnd_api.g_ret_sts_error;
619: END IF;
620: END IF;
621: END check_mandatory_num_col;
622:
1007: l_return_value := fnd_installation.get_app_info(
1008: 'AR', l_status, l_industry, l_ar_schema);
1009:
1010: IF NOT l_return_value THEN
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: END IF;
1013:
1014: l_return_value := fnd_installation.get_app_info(
1015: 'FND', l_status, l_industry, l_aol_schema);
1014: l_return_value := fnd_installation.get_app_info(
1015: 'FND', l_status, l_industry, l_aol_schema);
1016:
1017: IF NOT l_return_value THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: system.ad_apps_private.get_apps_schema_name(
1022: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
1085: l_return_value := fnd_installation.get_app_info(
1086: 'AR', l_status, l_industry, l_ar_schema);
1087:
1088: IF NOT l_return_value THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092: l_return_value := fnd_installation.get_app_info(
1093: 'FND', l_status, l_industry, l_aol_schema);
1092: l_return_value := fnd_installation.get_app_info(
1093: 'FND', l_status, l_industry, l_aol_schema);
1094:
1095: IF NOT l_return_value THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098:
1099: system.ad_apps_private.get_apps_schema_name(
1100: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);