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

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58: i_analyze := 0;
59: analyze_counter := 1000;
60:
61:
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: open GET_GRPDENORM;
64: loop
65: begin
66: savepoint RM_GRPDENORM;

Line 78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

74: X_MSG_COUNT => x_msg_count,
75: X_MSG_DATA => x_msg_data
76: );
77:
78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: for i in 1..x_msg_count
80: loop
81: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
82: p_encoded => fnd_api.g_false)));

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

78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: for i in 1..x_msg_count
80: loop
81: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
82: p_encoded => fnd_api.g_false)));
83:
84:
85: end loop;
86: END IF;

Line 106: WHEN fnd_api.g_exc_unexpected_error

102:
103: commit;
104:
105: EXCEPTION
106: WHEN fnd_api.g_exc_unexpected_error
107: THEN
108: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
109: ROLLBACK TO TERMINATE_EMPLOYEE_SP;
110:

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

120: (ERRBUF OUT NOCOPY VARCHAR2,
121: RETCODE OUT NOCOPY VARCHAR2)
122: IS
123: l_operation_flag VARCHAR2(1);
124: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
125: l_return_status VARCHAR2(200);
126: l_msg_count NUMBER;
127: l_msg_data VARCHAR2(200);
128: x_return_status VARCHAR2(200);

Line 155: P_COMMIT => FND_API.G_TRUE,

151: IF l_role.operation_flag = 'I' THEN
152: JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER
153: ( P_API_VERSION => 1.0,
154: P_INIT_MSG_LIST => l_init_msg_list,
155: P_COMMIT => FND_API.G_TRUE,
156: P_ROLE_RELATE_ID => l_role.role_relate_id,
157: X_RETURN_STATUS => l_return_status,
158: X_MSG_COUNT => l_msg_count,
159: X_MSG_DATA => l_msg_data);

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

157: X_RETURN_STATUS => l_return_status,
158: X_MSG_COUNT => l_msg_count,
159: X_MSG_DATA => l_msg_data);
160:
161: IF(l_return_status <> fnd_api.g_ret_sts_success)
162: THEN
163: FOR i in 1..l_msg_count
164: LOOP
165: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));

Line 165: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));

161: IF(l_return_status <> fnd_api.g_ret_sts_success)
162: THEN
163: FOR i in 1..l_msg_count
164: LOOP
165: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));
166: END LOOP;
167: RAISE halt_operation;
168: END IF;
169: END IF;

Line 177: P_COMMIT => FND_API.G_TRUE,

173: --call to UPDATE records in jtf_rs_rep_managers
174: JTF_RS_REP_MGR_DENORM_PVT.UPDATE_REP_MANAGER
175: ( P_API_VERSION => 1.0,
176: P_INIT_MSG_LIST => l_init_msg_list,
177: P_COMMIT => FND_API.G_TRUE,
178: P_ROLE_RELATE_ID => l_role.role_relate_id,
179: X_RETURN_STATUS => l_return_status,
180: X_MSG_COUNT => l_msg_count,
181: X_MSG_DATA => l_msg_data);

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

179: X_RETURN_STATUS => l_return_status,
180: X_MSG_COUNT => l_msg_count,
181: X_MSG_DATA => l_msg_data);
182:
183: IF(l_return_status <> fnd_api.g_ret_sts_success)
184: THEN
185: FOR i in 1..l_msg_count
186: LOOP
187: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));

Line 187: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));

183: IF(l_return_status <> fnd_api.g_ret_sts_success)
184: THEN
185: FOR i in 1..l_msg_count
186: LOOP
187: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));
188: END LOOP;
189: RAISE halt_operation;
190: END IF;
191: END IF;

Line 198: P_COMMIT => FND_API.G_TRUE,

194:
195: JTF_RS_REP_MGR_DENORM_PVT.DELETE_MEMBERS
196: ( P_API_VERSION => 1.0,
197: P_INIT_MSG_LIST => l_init_msg_list,
198: P_COMMIT => FND_API.G_TRUE,
199: P_ROLE_RELATE_ID => l_role.role_relate_id,
200: X_RETURN_STATUS => l_return_status,
201: X_MSG_COUNT => l_msg_count,
202: X_MSG_DATA => l_msg_data);

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

200: X_RETURN_STATUS => l_return_status,
201: X_MSG_COUNT => l_msg_count,
202: X_MSG_DATA => l_msg_data);
203:
204: IF(l_return_status <> fnd_api.g_ret_sts_success)
205: THEN
206: FOR i in 1..l_msg_count
207: LOOP
208: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));

Line 208: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));

204: IF(l_return_status <> fnd_api.g_ret_sts_success)
205: THEN
206: FOR i in 1..l_msg_count
207: LOOP
208: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i, p_encoded => fnd_api.g_false)));
209: END LOOP;
210: RAISE halt_operation;
211: END IF;
212: END IF;

Line 230: WHEN fnd_api.g_exc_unexpected_error THEN

226:
227: END LOOP;
228:
229: EXCEPTION
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
232: ROLLBACK TO CONC_SP;
233: WHEN OTHERS THEN
234: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);