DBA Data[Home] [Help]

APPS.ARH_CREL_PKG dependencies on FND_API

Line 13: res_date := FND_API.G_MISS_DATE;

9: res_date date;
10: BEGIN
11: IF p_switch = 'NULL_GMISS' THEN
12: IF p_date IS NULL THEN
13: res_date := FND_API.G_MISS_DATE;
14: ELSE
15: res_date := p_date;
16: END IF;
17: ELSIF p_switch = 'GMISS_NULL' THEN

Line 18: IF p_date = FND_API.G_MISS_DATE THEN

14: ELSE
15: res_date := p_date;
16: END IF;
17: ELSIF p_switch = 'GMISS_NULL' THEN
18: IF p_date = FND_API.G_MISS_DATE THEN
19: res_date := NULL;
20: ELSE
21: res_date := p_date;
22: END IF;

Line 38: return FND_API.G_MISS_CHAR;

34: res_char varchar2(2000);
35: BEGIN
36: IF p_switch = 'NULL_GMISS' THEN
37: IF p_char IS NULL THEN
38: return FND_API.G_MISS_CHAR;
39: ELSE
40: return p_char;
41: END IF;
42: ELSIF p_switch = 'GMISS_NULL' THEN

Line 43: IF p_char = FND_API.G_MISS_CHAR THEN

39: ELSE
40: return p_char;
41: END IF;
42: ELSIF p_switch = 'GMISS_NULL' THEN
43: IF p_char = FND_API.G_MISS_CHAR THEN
44: return NULL;
45: ELSE
46: return p_char;
47: END IF;

Line 61: return FND_API.G_MISS_NUM;

57: IS
58: BEGIN
59: IF p_switch = 'NULL_GMISS' THEN
60: IF p_num IS NULL THEN
61: return FND_API.G_MISS_NUM;
62: ELSE
63: return p_num;
64: END IF;
65: ELSIF p_switch = 'GMISS_NULL' THEN

Line 66: IF p_num = FND_API.G_MISS_NUM THEN

62: ELSE
63: return p_num;
64: END IF;
65: ELSIF p_switch = 'GMISS_NULL' THEN
66: IF p_num = FND_API.G_MISS_NUM THEN
67: return NULL;
68: ELSE
69: return p_num;
70: END IF;

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: THEN
119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
120: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
121: FND_MSG_PUB.ADD;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: END IF;
124: END IF;
125: END;
126:

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

237: );
238:
239: IF x_msg_count > 1 THEN
240: FOR i IN 1..x_msg_count LOOP
241: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
242: tmp_var1 := tmp_var1 || ' '|| tmp_var;
243: END LOOP;
244: x_msg_data := tmp_var1;
245: END IF;

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

310: x_msg_data => x_msg_data );
311:
312: IF x_msg_count > 1 THEN
313: FOR i IN 1..x_msg_count LOOP
314: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
315: tmp_var1 := tmp_var1 || ' '|| tmp_var;
316: END LOOP;
317: x_msg_data := tmp_var1;
318: END IF;

Line 320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

316: END LOOP;
317: x_msg_data := tmp_var1;
318: END IF;
319:
320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
321: return;
322: END IF;
323:
324: END IF;

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

387: END IF;
388:
389: IF x_msg_count > 1 THEN
390: FOR i IN 1..x_msg_count LOOP
391: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
392: tmp_var1 := tmp_var1 || ' '|| tmp_var;
393: END LOOP;
394: x_msg_data := tmp_var1;
395: END IF;