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_INCIDENTLINKS_UTIL dependencies on FND_API

Line 31: x_return_status := FND_API.G_RET_STS_SUCCESS;

27: l_link_type_id NUMBER(15);
28:
29: BEGIN
30: -- Initialize API return status to success
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: open c1;
34: fetch c1 into l_link_type_id;
35:

Line 40: x_return_status := FND_API.G_RET_STS_ERROR;

36: if ( c1%NOTFOUND ) then
37: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_LINK_INVALID_LINK');
38: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
39: FND_MSG_PUB.Add;
40: x_return_status := FND_API.G_RET_STS_ERROR;
41: end if;
42:
43: close c1;
44:

Line 51: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

47: p_data => x_msg_data);
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
52: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
53: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
54: FND_MSG_PUB.ADD;
55: FND_MSG_PUB.Count_And_Get(

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76:
77: l_dummy NUMBER(15) := 0;
78: BEGIN
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: select count(*)
83: into l_dummy
84: from cs_sr_link_valid_obj

Line 97: x_return_status := FND_API.G_RET_STS_ERROR;

93: -- type combination. Please define a valid object for this combination.
94: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_VALID_OBJ');
95: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
96: FND_MSG_PUB.Add;
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: else
99: -- check for the reciprocal link valid object as well; interchange the subject and
100: -- object and use the reciprocal link_type_id
101:

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: p_data => x_msg_data);
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
132: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
133: FND_MSG_PUB.ADD;
134: FND_MSG_PUB.Count_And_Get(

Line 192: x_return_status := FND_API.G_RET_STS_SUCCESS;

188: l_count number(15);
189:
190: BEGIN
191: -- Initialize API return status to success
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: open get_jtf_details ( p_subject_type );
195: fetch get_jtf_details into
196: l_sub_select_id, l_sub_select_name, l_sub_from_table, x_subject_type_name;

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: close get_jtf_details;
202: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_OBJ_JTF_TYPE');
203: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
204: FND_MSG_PUB.Add;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206:
207: FND_MSG_PUB.Count_And_Get(
208: p_count => x_msg_count,
209: p_data => x_msg_data);

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: FND_MESSAGE.Set_Name('CS','CS_SR_LINK_NO_JTF_SEL_NAME');
218: FND_MESSAGE.Set_Token('OBJECT_CODE', p_subject_type);
219: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
220: FND_MSG_PUB.Add;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222:
223: FND_MSG_PUB.Count_And_Get(
224: p_count => x_msg_count,
225: p_data => x_msg_data);

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: close get_jtf_details;
240: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_SUB_JTF_TYPE');
241: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
242: FND_MSG_PUB.Add;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244:
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count,
247: p_data => x_msg_data);

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: FND_MESSAGE.Set_Name('CS','CS_SR_LINK_NO_JTF_SEL_NAME');
257: FND_MESSAGE.Set_Token('OBJECT_CODE', p_object_type);
258: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
259: FND_MSG_PUB.Add;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:
262: FND_MSG_PUB.Count_And_Get(
263: p_count => x_msg_count,
264: p_data => x_msg_data);

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: execute immediate l_sql_stmnt into x_subject_number using p_subject_id;
280:
281: if ( x_subject_number IS NULL ) then
282: -- No record with primary key Subject Id exists in table || l_sub_from_table.
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_INVALID_LINK_CHILD');
285: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
286: FND_MESSAGE.Set_Token('SUB_OBJ_ID', nvl(to_char(p_subject_id) ,'NULL') );
287: FND_MESSAGE.Set_Token('SUB_OBJ_TABLE_NAME', l_sub_from_table) ;

Line 305: p_object_number <> FND_API.G_MISS_CHAR ) then

301: l_sql_stmnt := 'select max(' || l_obj_select_name || ' ) from ' || l_obj_from_table
302: || ' where ' || l_obj_select_id || ' = :p1 ' ;
303:
304: if ( p_object_number IS NOT NULL AND
305: p_object_number <> FND_API.G_MISS_CHAR ) then
306: l_sql_stmnt := l_sql_stmnt || ' and ' || l_obj_select_name || ' = :p2 ';
307: execute immediate l_sql_stmnt into x_object_number using p_object_id, p_object_number;
308: l_sub_obj_id_token := nvl(to_char(p_object_id), 'NULL') || ' - ' ||
309: nvl(p_object_number, 'NULL');

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313: end if; -- if ( p_object_number IS NOT NULL
314:
315: if ( x_object_number IS NULL ) then
316: -- No record with primary key Object Id exists in table || l_obj_from_table.
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_INVALID_LINK_CHILD');
319: FND_MESSAGE.Set_Token('SUB_OBJ_ID', l_sub_obj_id_token );
320: FND_MESSAGE.Set_Token('SUB_OBJ_TABLE_NAME', l_obj_from_table);
321: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332: END IF; -- p_obj_select_name is not null
333:
334: EXCEPTION
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
338: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
339: FND_MSG_PUB.ADD;
340: FND_MSG_PUB.Count_And_Get(

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

363: l_dummy NUMBER(15) := 0;
364:
365: BEGIN
366: -- Initialize API return status to success
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: -- Perform check for link object uniquenes (only on active links and not the end dated
370: -- ones.
371: -- Rule : Two linked objects cannot have more than one link pair between them.

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: and nvl(end_date_active - 1 , SYSDATE);
382:
383: if ( l_dummy > 0 ) then
384: -- Duplicate link. Link already exists for given object and related object.
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_LINK');
387: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
388: FND_MSG_PUB.Add;
389: end if;

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

393: p_data => x_msg_data);
394:
395: EXCEPTION
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
399: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
400: FND_MSG_PUB.ADD;
401: FND_MSG_PUB.Count_And_Get(

Line 455: x_return_status := FND_API.G_RET_STS_SUCCESS;

451: c1rec C1%ROWTYPE;
452:
453: BEGIN
454: -- Initialize API return status to success
455: x_return_status := FND_API.G_RET_STS_SUCCESS;
456:
457: -- Perform check for circular dependency
458: -- Rule : Prevent creation of circular dependency
459: -- Pseudocode:

Line 499: x_return_status := FND_API.G_RET_STS_ERROR;

495: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
496: end if;
497:
498: FND_MSG_PUB.Add;
499: x_return_status := FND_API.G_RET_STS_ERROR;
500: exit;
501: end if;
502: end loop;
503:

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509:
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
515: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
516: FND_MSG_PUB.ADD;
517: FND_MSG_PUB.Count_And_Get(

Line 598: x_return_status := FND_API.G_RET_STS_SUCCESS;

594: where link_type_id = c_link_type_id;
595:
596: BEGIN
597: -- Initialize API return status to success
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599:
600: open c1 ( c_sub_obj_id => p_subject_id,
601: c_sub_obj_type => p_subject_type);
602: fetch c1 into c1rec;

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: FND_MESSAGE.Set_Token('REL_OBJ_TYPE' , l_object_type_name);
623: FND_MESSAGE.Set_Token('REL_OBJ_NUM' , c1rec.object_number);
624: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: else
628: open c1 ( c_sub_obj_id => p_object_id,
629: c_sub_obj_type => p_object_type );
630: fetch c1 into c1rec;

Line 654: x_return_status := FND_API.G_RET_STS_ERROR;

650: FND_MESSAGE.Set_Token('REL_OBJ_TYPE' , l_object_type_name);
651: FND_MESSAGE.Set_Token('REL_OBJ_NUM' , c1rec.object_number);
652: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
653: FND_MSG_PUB.Add;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: end if;
656: end if;
657:
658: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

Line 658: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

654: x_return_status := FND_API.G_RET_STS_ERROR;
655: end if;
656: end if;
657:
658: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
659: if p_link_type_id = 3 then -- Creating a 'Duplicate Of' link
660: open c2 ( c_sub_obj_id => p_subject_id,
661: c_sub_obj_type => p_subject_type );
662: fetch c2 into c2rec;

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

686: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
687: FND_MESSAGE.Set_Token('EXISTING_LINK_TYPE', l_existing_link_type_name);
688: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
689: FND_MSG_PUB.Add;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: end if;
692: elsif p_link_type_id = 4 then -- Creating a 'Original For' link
693: open c2 ( c_sub_obj_id => p_object_id,
694: c_sub_obj_type => p_object_type );

Line 723: x_return_status := FND_API.G_RET_STS_ERROR;

719: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
720: FND_MESSAGE.Set_Token('EXISTING_LINK_TYPE' , l_existing_link_type_name );
721: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: end if;
725: end if; -- if p_link_type_id = 3 then
726: end if; -- if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
727:

Line 726: end if; -- if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then

722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: end if;
725: end if; -- if p_link_type_id = 3 then
726: end if; -- if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
727:
728: FND_MSG_PUB.Count_And_Get(
729: p_count => x_msg_count,
730: p_data => x_msg_data);

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

730: p_data => x_msg_data);
731:
732: EXCEPTION
733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
736: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(

Line 779: x_return_status := FND_API.G_RET_STS_SUCCESS;

775: l_sr_number VARCHAR2(90);
776:
777: BEGIN
778: -- Initialize API return status to success
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: select count(*)
782: into l_dummy
783: from cs_incidents_b_sec

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797: open get_sr_number;
798: fetch get_sr_number into l_sr_number;
799: close get_sr_number;
800:
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: fnd_message.set_name ('CS', 'CS_SR_NO_ACCESS');
803: fnd_message.set_token('RESP_NAME', l_resp_name );
804: fnd_message.set_token('SR_NUMBER', l_sr_number );
805: fnd_message.set_token('API_NAME', l_api_name_full);

Line 815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

811: p_data => x_msg_data);
812:
813: EXCEPTION
814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
817: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
818: FND_MSG_PUB.ADD;
819: FND_MSG_PUB.Count_And_Get(