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

Line 177: p_column_value <> FND_API.G_MISS_CHAR THEN

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;

Line 199: x_return_status := FND_API.G_RET_STS_ERROR;

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:

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

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

Line 230: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 506: x_return_status := fnd_api.g_ret_sts_error;

502: IF (p_col_val IS NULL) THEN
503: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
504: fnd_message.set_token('COLUMN', p_col_name);
505: fnd_msg_pub.add;
506: x_return_status := fnd_api.g_ret_sts_error;
507: RETURN;
508: END IF;
509:
510: IF (create_update_flag = 'C') THEN

Line 512: p_col_val = fnd_api.G_MISS_CHAR )

508: END IF;
509:
510: IF (create_update_flag = 'C') THEN
511: IF ((NOT p_miss_allowed_in_c) AND
512: p_col_val = fnd_api.G_MISS_CHAR )
513: THEN
514: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
515: fnd_message.set_token('COLUMN', p_col_name);
516: fnd_msg_pub.add;

Line 517: x_return_status := fnd_api.g_ret_sts_error;

513: THEN
514: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
515: fnd_message.set_token('COLUMN', p_col_name);
516: fnd_msg_pub.add;
517: x_return_status := fnd_api.g_ret_sts_error;
518: END IF;
519: ELSE
520: IF ((NOT p_miss_allowed_in_u) AND
521: p_col_val = fnd_api.G_MISS_CHAR )

Line 521: p_col_val = fnd_api.G_MISS_CHAR )

517: x_return_status := fnd_api.g_ret_sts_error;
518: END IF;
519: ELSE
520: IF ((NOT p_miss_allowed_in_u) AND
521: p_col_val = fnd_api.G_MISS_CHAR )
522: THEN
523: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
524: fnd_message.set_token('COLUMN', p_col_name);
525: fnd_msg_pub.add;

Line 526: x_return_status := fnd_api.g_ret_sts_error;

522: THEN
523: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
524: fnd_message.set_token('COLUMN', p_col_name);
525: fnd_msg_pub.add;
526: x_return_status := fnd_api.g_ret_sts_error;
527: END IF;
528: END IF;
529: END check_mandatory_str_col;
530:

Line 551: x_return_status := fnd_api.g_ret_sts_error;

547: IF (p_col_val IS NULL) THEN
548: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
549: fnd_message.set_token('COLUMN', p_col_name);
550: fnd_msg_pub.add;
551: x_return_status := fnd_api.g_ret_sts_error;
552: RETURN;
553: END IF;
554:
555: IF (create_update_flag = 'C') THEN

Line 557: p_col_val = fnd_api.G_MISS_DATE )

553: END IF;
554:
555: IF (create_update_flag = 'C') THEN
556: IF ((NOT p_miss_allowed_in_c) AND
557: p_col_val = fnd_api.G_MISS_DATE )
558: THEN
559: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
560: fnd_message.set_token('COLUMN', p_col_name);
561: fnd_msg_pub.add;

Line 562: x_return_status := fnd_api.g_ret_sts_error;

558: THEN
559: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
560: fnd_message.set_token('COLUMN', p_col_name);
561: fnd_msg_pub.add;
562: x_return_status := fnd_api.g_ret_sts_error;
563: END IF;
564: ELSE
565: IF ((NOT p_miss_allowed_in_u) AND
566: p_col_val = fnd_api.G_MISS_DATE )

Line 566: p_col_val = fnd_api.G_MISS_DATE )

562: x_return_status := fnd_api.g_ret_sts_error;
563: END IF;
564: ELSE
565: IF ((NOT p_miss_allowed_in_u) AND
566: p_col_val = fnd_api.G_MISS_DATE )
567: THEN
568: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
569: fnd_message.set_token('COLUMN', p_col_name);
570: fnd_msg_pub.add;

Line 571: x_return_status := fnd_api.g_ret_sts_error;

567: THEN
568: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
569: fnd_message.set_token('COLUMN', p_col_name);
570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END IF;
573: END IF;
574: END check_mandatory_date_col;
575:

Line 596: x_return_status := fnd_api.g_ret_sts_error;

592: IF (p_col_val IS NULL) THEN
593: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
594: fnd_message.set_token('COLUMN', p_col_name);
595: fnd_msg_pub.add;
596: x_return_status := fnd_api.g_ret_sts_error;
597: RETURN;
598: END IF;
599:
600: IF (create_update_flag = 'C') THEN

Line 602: p_col_val = fnd_api.G_MISS_NUM )

598: END IF;
599:
600: IF (create_update_flag = 'C') THEN
601: IF ((NOT p_miss_allowed_in_c) AND
602: p_col_val = fnd_api.G_MISS_NUM )
603: THEN
604: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
605: fnd_message.set_token('COLUMN', p_col_name);
606: fnd_msg_pub.add;

Line 607: x_return_status := fnd_api.g_ret_sts_error;

603: THEN
604: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
605: fnd_message.set_token('COLUMN', p_col_name);
606: fnd_msg_pub.add;
607: x_return_status := fnd_api.g_ret_sts_error;
608: END IF;
609: ELSE
610: IF ((NOT p_miss_allowed_in_u) AND
611: p_col_val = fnd_api.G_MISS_NUM )

Line 611: p_col_val = fnd_api.G_MISS_NUM )

607: x_return_status := fnd_api.g_ret_sts_error;
608: END IF;
609: ELSE
610: IF ((NOT p_miss_allowed_in_u) AND
611: p_col_val = fnd_api.G_MISS_NUM )
612: THEN
613: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
614: fnd_message.set_token('COLUMN', p_col_name);
615: fnd_msg_pub.add;

Line 616: x_return_status := fnd_api.g_ret_sts_error;

612: THEN
613: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
614: fnd_message.set_token('COLUMN', p_col_name);
615: fnd_msg_pub.add;
616: x_return_status := fnd_api.g_ret_sts_error;
617: END IF;
618: END IF;
619: END check_mandatory_num_col;
620:

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: l_return_value := fnd_installation.get_app_info(
1006: 'AR', l_status, l_industry, l_ar_schema);
1007:
1008: IF NOT l_return_value THEN
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: END IF;
1011:
1012: l_return_value := fnd_installation.get_app_info(
1013: 'FND', l_status, l_industry, l_aol_schema);

Line 1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1012: l_return_value := fnd_installation.get_app_info(
1013: 'FND', l_status, l_industry, l_aol_schema);
1014:
1015: IF NOT l_return_value THEN
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END IF;
1018:
1019: system.ad_apps_private.get_apps_schema_name(
1020: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: l_return_value := fnd_installation.get_app_info(
1084: 'AR', l_status, l_industry, l_ar_schema);
1085:
1086: IF NOT l_return_value THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: l_return_value := fnd_installation.get_app_info(
1091: 'FND', l_status, l_industry, l_aol_schema);

Line 1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1090: l_return_value := fnd_installation.get_app_info(
1091: 'FND', l_status, l_industry, l_aol_schema);
1092:
1093: IF NOT l_return_value THEN
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: END IF;
1096:
1097: system.ad_apps_private.get_apps_schema_name(
1098: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);