APPS.ARH_CROL_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 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
110: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
111: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
112: FND_MSG_PUB.ADD;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: ELSE
115: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
116: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
117: THEN

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

410: */
411:
412: IF x_msg_count > 1 THEN
413: FOR i IN 1..x_msg_count LOOP
414: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
415: tmp_var1 := tmp_var1 || ' '|| tmp_var;
416: END LOOP;
417: x_msg_data := tmp_var1;
418: END IF;

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

533: x_msg_data => x_msg_data );
534:
535: IF x_msg_count > 1 THEN
536: FOR i IN 1..x_msg_count LOOP
537: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
538: tmp_var1 := tmp_var1 || ' '|| tmp_var;
539: END LOOP;
540: x_msg_data := tmp_var1;
541: END IF;

Line 543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

539: END LOOP;
540: x_msg_data := tmp_var1;
541: END IF;
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: return;
545: END IF;
546:
547: END IF;

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

556: );
557:
558: IF x_msg_count > 1 THEN
559: FOR i IN 1..x_msg_count LOOP
560: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
561: tmp_var1 := tmp_var1 || ' '|| tmp_var;
562: END LOOP;
563: x_msg_data := tmp_var1;
564: END IF;

Line 566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

562: END LOOP;
563: x_msg_data := tmp_var1;
564: END IF;
565:
566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
567: return;
568: END IF;
569:
570: