APPS.ARH_PHON_PKG dependencies on FND_API

Line 41: res_date := FND_API.G_MISS_DATE;

37: res_date date;
38: BEGIN
39: IF p_switch = 'NULL_GMISS' THEN
40: IF p_date IS NULL THEN
41: res_date := FND_API.G_MISS_DATE;
42: ELSE
43: res_date := p_date;
44: END IF;
45: ELSIF p_switch = 'GMISS_NULL' THEN

Line 46: IF p_date = FND_API.G_MISS_DATE THEN

42: ELSE
43: res_date := p_date;
44: END IF;
45: ELSIF p_switch = 'GMISS_NULL' THEN
46: IF p_date = FND_API.G_MISS_DATE THEN
47: res_date := NULL;
48: ELSE
49: res_date := p_date;
50: END IF;

Line 66: return FND_API.G_MISS_CHAR;

62: res_char varchar2(2000);
63: BEGIN
64: IF p_switch = 'NULL_GMISS' THEN
65: IF p_char IS NULL THEN
66: return FND_API.G_MISS_CHAR;
67: ELSE
68: return p_char;
69: END IF;
70: ELSIF p_switch = 'GMISS_NULL' THEN

Line 71: IF p_char = FND_API.G_MISS_CHAR THEN

67: ELSE
68: return p_char;
69: END IF;
70: ELSIF p_switch = 'GMISS_NULL' THEN
71: IF p_char = FND_API.G_MISS_CHAR THEN
72: return NULL;
73: ELSE
74: return p_char;
75: END IF;

Line 89: return FND_API.G_MISS_NUM;

85: IS
86: BEGIN
87: IF p_switch = 'NULL_GMISS' THEN
88: IF p_num IS NULL THEN
89: return FND_API.G_MISS_NUM;
90: ELSE
91: return p_num;
92: END IF;
93: ELSIF p_switch = 'GMISS_NULL' THEN

Line 94: IF p_num = FND_API.G_MISS_NUM THEN

90: ELSE
91: return p_num;
92: END IF;
93: ELSIF p_switch = 'GMISS_NULL' THEN
94: IF p_num = FND_API.G_MISS_NUM THEN
95: return NULL;
96: ELSE
97: return p_num;
98: END IF;

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: ELSE
143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
144: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
145: THEN

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: THEN
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
147: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;
151: END IF;
152:
153: END;

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

487:
488:
489: IF x_msg_count > 1 THEN
490: FOR i IN 1..x_msg_count LOOP
491: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
492: tmp_var1 := tmp_var1 || ' '|| tmp_var;
493: END LOOP;
494: x_msg_data := tmp_var1;
495: END IF;

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

641: END IF;
642:
643: IF x_msg_count > 1 THEN
644: FOR i IN 1..x_msg_count LOOP
645: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
646: tmp_var1 := tmp_var1 || ' '|| tmp_var;
647: END LOOP;
648: x_msg_data := tmp_var1;
649: END IF;

Line 651: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

647: END LOOP;
648: x_msg_data := tmp_var1;
649: END IF;
650:
651: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
652: return;
653: END IF;
654:
655:

Line 669: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

665: x_msg_count => x_msg_count,
666: x_msg_data => x_msg_data
667: );
668:
669: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
670: select last_update_date,
671: object_version_number
672: into X_Last_Update_Date,
673: x_object_version

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

676: END IF;
677:
678: IF x_msg_count > 1 THEN
679: FOR i IN 1..x_msg_count LOOP
680: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
681: tmp_var1 := tmp_var1 || ' '|| tmp_var;
682: END LOOP;
683: x_msg_data := tmp_var1;
684: END IF;