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

Line 41: x_return_status := FND_API.G_RET_STS_ERROR;

37: x_return_status := FND_PROFILE.VALUE_SPECIFIC ('CS_CSI_ENABLED', l_user_id, l_resp_id, l_app_id);
38:
39: exception
40: when others then
41: x_return_status := FND_API.G_RET_STS_ERROR;
42: end is_system_enabled;
43:
44: procedure is_system_valid(
45: p_api_version_number IN NUMBER,

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72: l_result := -1;
73: end if;
74:
75: if (l_result < 0) then
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: else
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: end if;
80:

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74:
75: if (l_result < 0) then
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: else
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: end if;
80:
81: exception
82: WHEN NO_DATA_FOUND THEN

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79: end if;
80:
81: exception
82: WHEN NO_DATA_FOUND THEN
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: -- dbms_output.put_line ('No data found');
85:
86: WHEN OTHERS THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

83: x_return_status := FND_API.G_RET_STS_ERROR;
84: -- dbms_output.put_line ('No data found');
85:
86: WHEN OTHERS THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
88: -- dbms_output.put_line ('Unexpected error');
89: FND_MSG_PUB.Count_And_Get
90: (p_count => x_msg_count ,
91: p_data => x_msg_data

Line 147: if (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

143: x_msg_count => x_msg_count,
144: x_msg_data => x_msg_data
145: );
146:
147: if (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
148: for l_curr_row in 1..l_pd_attrib_tbl.count
149: loop
150: if l_pd_attrib_tbl(l_curr_row).ATTRIBUTE_NAME = 'system_name' then
151: l_system_name := l_pd_attrib_tbl(l_curr_row).ATTRIBUTE_VALUE;

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: exception
162: WHEN NO_DATA_FOUND THEN
163: x_system_id := -1;
164: x_system_name := null;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166:
167: WHEN OTHERS THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
169: FND_MSG_PUB.Count_And_Get

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

164: x_system_name := null;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166:
167: WHEN OTHERS THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count ,
171: p_data => x_msg_data
172: );

Line 192: x_return_status := FND_API.G_RET_STS_SUCCESS;

188: begin
189: l_party_id := get_party_id (p_user_id);
190: l_curr_date := sysdate;
191: open x_system_data for SELECT DISTINCT system_id, name FROM cs_system_party_links_v WHERE party_id = l_party_id AND (end_date_active IS null OR (end_date_active > l_curr_date)) ORDER BY system_id;
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: exception
194: WHEN NO_DATA_FOUND THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: open x_system_data for SELECT DISTINCT system_id, name FROM cs_system_party_links_v WHERE party_id = l_party_id AND (end_date_active IS null OR (end_date_active > l_curr_date)) ORDER BY system_id;
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: exception
194: WHEN NO_DATA_FOUND THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: FND_MSG_PUB.Count_And_Get

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

194: WHEN NO_DATA_FOUND THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: FND_MSG_PUB.Count_And_Get
200: (p_count => x_msg_count ,
201: p_data => x_msg_data
202: );

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: begin
219: if (p_system_name is not null) then
220: l_system_id := get_system_id (p_system_name);
221: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = l_system_id ORDER BY system_id;
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: elsif (p_system_id > 0) then
225: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;
226: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: elsif (p_system_id > 0) then
225: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: else
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: end if;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: else
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: end if;
231: exception
232: WHEN NO_DATA_FOUND THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: x_return_status := FND_API.G_RET_STS_ERROR;
230: end if;
231: exception
232: WHEN NO_DATA_FOUND THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234:
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: FND_MSG_PUB.Count_And_Get

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: WHEN NO_DATA_FOUND THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234:
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: FND_MSG_PUB.Count_And_Get
238: (p_count => x_msg_count ,
239: p_data => x_msg_data
240: );

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264:
265: if (p_system_name is not null) then
266: l_system_id := get_system_id (p_system_name);
267: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = l_system_id AND party_id = l_party_id and (end_date is null or end_date < l_curr_date);
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: elsif (p_system_id > 0) then
271: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id AND party_id = l_party_id and (end_date is null or end_date < l_curr_date);
272: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: elsif (p_system_id > 0) then
271: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id AND party_id = l_party_id and (end_date is null or end_date < l_curr_date);
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: else
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: end if;
276: exception

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: elsif (p_system_id > 0) then
271: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id AND party_id = l_party_id and (end_date is null or end_date < l_curr_date);
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: else
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: end if;
276: exception
277: WHEN NO_DATA_FOUND THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: x_return_status := FND_API.G_RET_STS_ERROR;
275: end if;
276: exception
277: WHEN NO_DATA_FOUND THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282: FND_MSG_PUB.Count_And_Get

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

277: WHEN NO_DATA_FOUND THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282: FND_MSG_PUB.Count_And_Get
283: (p_count => x_msg_count ,
284: p_data => x_msg_data
285: );

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

308: if (p_system_name is not null) then
309: l_system_id := get_system_id (p_system_name);
310: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = l_system_id and (end_date is null or end_date < l_curr_date);
311: if (l_system_count > 0) then
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313: else
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: end if;
316:

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = l_system_id and (end_date is null or end_date < l_curr_date);
311: if (l_system_count > 0) then
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313: else
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: end if;
316:
317: elsif (p_system_id > 0) then
318: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id and (end_date is null or end_date < l_curr_date);

Line 320: x_return_status := FND_API.G_RET_STS_SUCCESS;

316:
317: elsif (p_system_id > 0) then
318: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id and (end_date is null or end_date < l_curr_date);
319: if (l_system_count > 0) then
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: else
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: end if;
324: end if;

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id and (end_date is null or end_date < l_curr_date);
319: if (l_system_count > 0) then
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: else
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: end if;
324: end if;
325: exception
326: WHEN NO_DATA_FOUND THEN

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: end if;
324: end if;
325: exception
326: WHEN NO_DATA_FOUND THEN
327: x_return_status := FND_API.G_RET_STS_ERROR;
328:
329: WHEN OTHERS THEN
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331: FND_MSG_PUB.Count_And_Get

Line 330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

326: WHEN NO_DATA_FOUND THEN
327: x_return_status := FND_API.G_RET_STS_ERROR;
328:
329: WHEN OTHERS THEN
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331: FND_MSG_PUB.Count_And_Get
332: (p_count => x_msg_count ,
333: p_data => x_msg_data
334: );

Line 368: x_return_status := FND_API.G_RET_STS_SUCCESS;

364: c.party_type='PERSON' AND
365: c.party_id=d.customer_id;
366:
367: if (l_system_count > 0) then
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369: else
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: end if;
372:

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366:
367: if (l_system_count > 0) then
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369: else
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: end if;
372:
373: elsif (p_system_id > 0) then
374: SELECT count(*) INTO l_system_count FROM

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: c.party_type='PERSON' AND
381: c.party_id=d.customer_id;
382:
383: if (l_system_count > 0) then
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: else
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: end if;
388: end if;

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

382:
383: if (l_system_count > 0) then
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: else
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: end if;
388: end if;
389: exception
390: WHEN NO_DATA_FOUND THEN

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

387: end if;
388: end if;
389: exception
390: WHEN NO_DATA_FOUND THEN
391: x_return_status := FND_API.G_RET_STS_ERROR;
392:
393: WHEN OTHERS THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: FND_MSG_PUB.Count_And_Get

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

390: WHEN NO_DATA_FOUND THEN
391: x_return_status := FND_API.G_RET_STS_ERROR;
392:
393: WHEN OTHERS THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: FND_MSG_PUB.Count_And_Get
396: (p_count => x_msg_count ,
397: p_data => x_msg_data
398: );