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 508: x_return_status := fnd_api.g_ret_sts_error;

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

Line 514: p_col_val = fnd_api.G_MISS_CHAR )

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;

Line 519: x_return_status := fnd_api.g_ret_sts_error;

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 )

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

Line 528: x_return_status := fnd_api.g_ret_sts_error;

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:

Line 553: x_return_status := fnd_api.g_ret_sts_error;

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

Line 559: p_col_val = fnd_api.G_MISS_DATE )

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;

Line 564: x_return_status := fnd_api.g_ret_sts_error;

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 )

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

Line 573: x_return_status := fnd_api.g_ret_sts_error;

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:

Line 598: x_return_status := fnd_api.g_ret_sts_error;

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

Line 604: p_col_val = fnd_api.G_MISS_NUM )

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;

Line 609: x_return_status := fnd_api.g_ret_sts_error;

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 )

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

Line 618: x_return_status := fnd_api.g_ret_sts_error;

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:

Line 1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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