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.ARH_CLASSIFICATION_PKG dependencies on FND_API

Line 22: res_date := FND_API.G_MISS_DATE;

18: res_date date;
19: BEGIN
20: IF p_switch = 'NULL_GMISS' THEN
21: IF p_date IS NULL THEN
22: res_date := FND_API.G_MISS_DATE;
23: ELSE
24: res_date := p_date;
25: END IF;
26: ELSIF p_switch = 'GMISS_NULL' THEN

Line 27: IF p_date = FND_API.G_MISS_DATE THEN

23: ELSE
24: res_date := p_date;
25: END IF;
26: ELSIF p_switch = 'GMISS_NULL' THEN
27: IF p_date = FND_API.G_MISS_DATE THEN
28: res_date := NULL;
29: ELSE
30: res_date := p_date;
31: END IF;

Line 47: return FND_API.G_MISS_CHAR;

43: res_char varchar2(2000);
44: BEGIN
45: IF p_switch = 'NULL_GMISS' THEN
46: IF p_char IS NULL THEN
47: return FND_API.G_MISS_CHAR;
48: ELSE
49: return p_char;
50: END IF;
51: ELSIF p_switch = 'GMISS_NULL' THEN

Line 52: IF p_char = FND_API.G_MISS_CHAR THEN

48: ELSE
49: return p_char;
50: END IF;
51: ELSIF p_switch = 'GMISS_NULL' THEN
52: IF p_char = FND_API.G_MISS_CHAR THEN
53: return NULL;
54: ELSE
55: return p_char;
56: END IF;

Line 70: return FND_API.G_MISS_NUM;

66: IS
67: BEGIN
68: IF p_switch = 'NULL_GMISS' THEN
69: IF p_num IS NULL THEN
70: return FND_API.G_MISS_NUM;
71: ELSE
72: return p_num;
73: END IF;
74: ELSIF p_switch = 'GMISS_NULL' THEN

Line 75: IF p_num = FND_API.G_MISS_NUM THEN

71: ELSE
72: return p_num;
73: END IF;
74: ELSIF p_switch = 'GMISS_NULL' THEN
75: IF p_num = FND_API.G_MISS_NUM THEN
76: return NULL;
77: ELSE
78: return p_num;
79: END IF;

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509: lyn VARCHAR2(1);
510: BEGIN
511: arp_standard.debug('Create_Code_assignment(+)');
512:
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: /*
516: -- We allow user to create code assignment prior a start date of another one
517: lyn := arh_classification_pkg.assig_after_this_date

Line 562: ( p_init_msg_list => FND_API.G_FALSE,

558: l_code_assignment_rec.application_id := p_application_id;
559:
560: -- Now call the stored program
561: hz_classification_v2pub.create_code_assignment
562: ( p_init_msg_list => FND_API.G_FALSE,
563: p_code_assignment_rec => l_code_assignment_rec,
564: x_return_status => x_return_status,
565: x_msg_count => x_msg_count,
566: x_msg_data => x_msg_data,

Line 570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

566: x_msg_data => x_msg_data,
567: x_code_assignment_id => x_code_assignment_id);
568:
569:
570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
571: IF x_msg_count > 1 THEN
572: FOR i IN 1..x_msg_count LOOP
573: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
574: tmp_var1 := tmp_var1 || ' '|| tmp_var;

Line 573: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

569:
570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
571: IF x_msg_count > 1 THEN
572: FOR i IN 1..x_msg_count LOOP
573: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
574: tmp_var1 := tmp_var1 || ' '|| tmp_var;
575: END LOOP;
576: x_msg_data := tmp_var1;
577: END IF;

Line 584: x_return_status := fnd_api.g_ret_sts_error;

580:
581: arp_standard.debug('Create_Code_assignment(-)');
582: EXCEPTION
583: WHEN lexception THEN
584: x_return_status := fnd_api.g_ret_sts_error;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_msg_count,
588: p_data => x_msg_data );

Line 586: p_encoded => FND_API.G_FALSE,

582: EXCEPTION
583: WHEN lexception THEN
584: x_return_status := fnd_api.g_ret_sts_error;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_msg_count,
588: p_data => x_msg_data );
589: IF x_msg_count > 1 THEN
590: FOR i IN 1..x_msg_count LOOP

Line 591: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

587: p_count => x_msg_count,
588: p_data => x_msg_data );
589: IF x_msg_count > 1 THEN
590: FOR i IN 1..x_msg_count LOOP
591: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
592: tmp_var1 := tmp_var1 || ' '|| tmp_var;
593: END LOOP;
594: x_msg_data := tmp_var1;
595: END IF;

Line 600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

596: arp_standard.debug
597: ('EXCEPTION lexception: arh_classification_pkg.Create_Code_assignment'||x_msg_data);
598:
599: WHEN OTHERS THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
602: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get(

Line 605: p_encoded => FND_API.G_FALSE,

601: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
602: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data );
608: arp_standard.debug
609: ('EXCEPTION: arh_classification_pkg.Create_Code_assignment'||x_msg_data);

Line 671: x_return_status := FND_API.G_RET_STS_SUCCESS;

667: l_exception EXCEPTION;
668: tca_exception EXCEPTION;
669: BEGIN
670: arp_standard.debug('Update_Code_assignment(+)');
671: x_return_status := FND_API.G_RET_STS_SUCCESS;
672:
673: OPEN cu_code_assig;
674: FETCH cu_code_assig INTO l_rowid,
675: l_start_date,

Line 731: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

727: x_return_status => x_return_status,
728: x_msg_count => x_msg_count,
729: x_msg_data => x_msg_data);
730:
731: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
732: RAISE tca_exception;
733: END IF;
734:
735: arp_standard.debug('update_code_assignment (-)');

Line 738: x_return_status := FND_API.G_RET_STS_ERROR;

734:
735: arp_standard.debug('update_code_assignment (-)');
736: EXCEPTION
737: WHEN l_exception THEN
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: fnd_msg_pub.count_and_get(
740: p_encoded => fnd_api.g_false,
741: p_count => x_msg_count,
742: p_data => x_msg_data);

Line 740: p_encoded => fnd_api.g_false,

736: EXCEPTION
737: WHEN l_exception THEN
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: fnd_msg_pub.count_and_get(
740: p_encoded => fnd_api.g_false,
741: p_count => x_msg_count,
742: p_data => x_msg_data);
743: IF x_msg_count > 1 THEN
744: FOR i IN 1..x_msg_count LOOP

Line 745: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

741: p_count => x_msg_count,
742: p_data => x_msg_data);
743: IF x_msg_count > 1 THEN
744: FOR i IN 1..x_msg_count LOOP
745: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
746: tmp_var1 := tmp_var1 || ' '|| tmp_var;
747: END LOOP;
748: x_msg_data := tmp_var1;
749: END IF;

Line 755: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

751:
752: WHEN tca_Exception THEN
753: IF x_msg_count > 1 THEN
754: FOR i IN 1..x_msg_count LOOP
755: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
756: tmp_var1 := tmp_var1 || ' '|| tmp_var;
757: END LOOP;
758: x_msg_data := tmp_var1;
759: END IF;

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759: END IF;
760: arp_standard.debug('Exception arh_classification_pkg.update_code_assignment:'||x_msg_data);
761:
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
765: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(

Line 768: p_encoded => FND_API.G_FALSE,

764: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
765: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data );
771: IF x_msg_count > 1 THEN
772: FOR i IN 1..x_msg_count LOOP

Line 773: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

769: p_count => x_msg_count,
770: p_data => x_msg_data );
771: IF x_msg_count > 1 THEN
772: FOR i IN 1..x_msg_count LOOP
773: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
774: tmp_var1 := tmp_var1 || ' '|| tmp_var;
775: END LOOP;
776: x_msg_data := tmp_var1;
777: END IF;