APPS.JTF_RS_CONC_GRP_DENORM_PUB dependencies on FND_API

Line 26: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

22: )
23: IS
24: l_operation_flag VARCHAR2(1);
25: l_group_id NUMBER;
26: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
27: l_return_status VARCHAR2(200);
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2(200);
30: x_return_status VARCHAR2(200);

Line 33: l_commit VARCHAR2(10) := FND_API.G_TRUE;

29: l_msg_data VARCHAR2(200);
30: x_return_status VARCHAR2(200);
31: i NUMBER;
32: halt_operation EXCEPTION;
33: l_commit VARCHAR2(10) := FND_API.G_TRUE;
34:
35:
36: CURSOR c_get_grp IS
37: SELECT group_relate_id,

Line 66: IF(l_return_status <> fnd_api.g_ret_sts_success)

62: X_RETURN_STATUS => l_return_status,
63: X_MSG_COUNT => l_msg_count,
64: X_MSG_DATA => l_msg_data);
65:
66: IF(l_return_status <> fnd_api.g_ret_sts_success)
67: THEN
68: FOR i in 1..l_msg_count
69: LOOP
70: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

Line 71: p_encoded => fnd_api.g_false)));

67: THEN
68: FOR i in 1..l_msg_count
69: LOOP
70: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
71: p_encoded => fnd_api.g_false)));
72:
73: END LOOP;
74:
75: RAISE halt_operation;

Line 93: IF(l_return_status <> fnd_api.g_ret_sts_success)

89: X_RETURN_STATUS => l_return_status,
90: X_MSG_COUNT => l_msg_count,
91: X_MSG_DATA => l_msg_data);
92:
93: IF(l_return_status <> fnd_api.g_ret_sts_success)
94: THEN
95: FOR i in 1..l_msg_count
96: LOOP
97: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

Line 98: p_encoded => fnd_api.g_false)));

94: THEN
95: FOR i in 1..l_msg_count
96: LOOP
97: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
98: p_encoded => fnd_api.g_false)));
99:
100: END LOOP;
101:
102: RAISE halt_operation;

Line 119: IF(l_return_status <> fnd_api.g_ret_sts_success)

115: X_RETURN_STATUS => l_return_status,
116: X_MSG_COUNT => l_msg_count,
117: X_MSG_DATA => l_msg_data);
118:
119: IF(l_return_status <> fnd_api.g_ret_sts_success)
120: THEN
121: FOR i in 1..l_msg_count
122: LOOP
123: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

Line 124: p_encoded => fnd_api.g_false)));

120: THEN
121: FOR i in 1..l_msg_count
122: LOOP
123: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
124: p_encoded => fnd_api.g_false)));
125:
126: END LOOP;
127:
128: RAISE halt_operation;

Line 144: IF(l_return_status <> fnd_api.g_ret_sts_success)

140: P_RELATED_GROUP_ID => l_grp.related_group_id,
141: X_RETURN_STATUS => l_return_status,
142: X_MSG_COUNT => l_msg_count,
143: X_MSG_DATA => l_msg_data);
144: IF(l_return_status <> fnd_api.g_ret_sts_success)
145: THEN
146: FOR i in 1..l_msg_count
147: LOOP
148: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

Line 149: p_encoded => fnd_api.g_false)));

145: THEN
146: FOR i in 1..l_msg_count
147: LOOP
148: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
149: p_encoded => fnd_api.g_false)));
150:
151: END LOOP;
152:
153: RAISE halt_operation;

Line 174: WHEN fnd_api.g_exc_unexpected_error

170:
171: END LOOP;
172:
173: EXCEPTION
174: WHEN fnd_api.g_exc_unexpected_error
175: THEN
176: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
177: ROLLBACK TO CONC_GROUP_SP;
178: WHEN OTHERS