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_MESSAGE

Line 37: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_LINK_INVALID_LINK');

33: open c1;
34: fetch c1 into l_link_type_id;
35:
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;

Line 38: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

34: fetch c1 into l_link_type_id;
35:
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:

Line 52: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
56: p_count => x_msg_count,

Line 53: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
56: p_count => x_msg_count,
57: p_data => x_msg_data);

Line 94: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_VALID_OBJ');

90:
91: if ( l_dummy <= 0 ) then
92: -- Valid objects do not exist for the given Object, Related Object and Link
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

Line 95: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

91: if ( l_dummy <= 0 ) then
92: -- Valid objects do not exist for the given Object, Related Object and Link
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

Line 118: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_VALID_OBJ');

114:
115: if ( l_dummy <= 0 ) then
116: -- Valid objects do not exist for the given Object, Related Object and Link
117: -- type combination. Please define a valid object for this combination.
118: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_VALID_OBJ');
119: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
120: FND_MSG_PUB.Add;
121: end if;
122: end if;

Line 119: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

115: if ( l_dummy <= 0 ) then
116: -- Valid objects do not exist for the given Object, Related Object and Link
117: -- type combination. Please define a valid object for this combination.
118: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_VALID_OBJ');
119: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
120: FND_MSG_PUB.Add;
121: end if;
122: end if;
123:

Line 131: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
135: p_count => x_msg_count,

Line 132: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
135: p_count => x_msg_count,
136: p_data => x_msg_data);

Line 202: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_OBJ_JTF_TYPE');

198: if ( get_jtf_details%notfound ) then
199: -- Subject type is not valid. Please specify a valid value from JTF Objects
200: -- for Subject type.
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:

Line 203: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

199: -- Subject type is not valid. Please specify a valid value from JTF Objects
200: -- for Subject type.
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(

Line 217: FND_MESSAGE.Set_Name('CS','CS_SR_LINK_NO_JTF_SEL_NAME');

213: close get_jtf_details;
214: -- Without the select_name column filled in in jtf_objects_b, the subject number
215: -- cannot be determined.
216: -- MSG: Object OBJECT_CODE is not fully defined in JTF Objects.
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;

Line 218: FND_MESSAGE.Set_Token('OBJECT_CODE', p_subject_type);

214: -- Without the select_name column filled in in jtf_objects_b, the subject number
215: -- cannot be determined.
216: -- MSG: Object OBJECT_CODE is not fully defined in JTF Objects.
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:

Line 219: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

215: -- cannot be determined.
216: -- MSG: Object OBJECT_CODE is not fully defined in JTF Objects.
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(

Line 240: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_NO_SUB_JTF_TYPE');

236: if ( get_jtf_details%notfound ) then
237: -- Object type is not valid. Please specify a valid value from JTF Objects
238: -- for Object type.
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:

Line 241: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

237: -- Object type is not valid. Please specify a valid value from JTF Objects
238: -- for Object type.
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(

Line 256: FND_MESSAGE.Set_Name('CS','CS_SR_LINK_NO_JTF_SEL_NAME');

252: close get_jtf_details;
253: -- Without the select_name column filled in in jtf_objects_b, the object number
254: -- cannot be determined.
255: -- MSG: Object OBJECT_CODE is not fully defined in JTF Objects.
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;

Line 257: FND_MESSAGE.Set_Token('OBJECT_CODE', p_object_type);

253: -- Without the select_name column filled in in jtf_objects_b, the object number
254: -- cannot be determined.
255: -- MSG: Object OBJECT_CODE is not fully defined in JTF Objects.
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:

Line 258: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

254: -- cannot be determined.
255: -- MSG: Object OBJECT_CODE is not fully defined in JTF Objects.
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(

Line 284: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_INVALID_LINK_CHILD');

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) ;
288: FND_MSG_PUB.Add;

Line 285: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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) ;
288: FND_MSG_PUB.Add;
289:

Line 286: FND_MESSAGE.Set_Token('SUB_OBJ_ID', nvl(to_char(p_subject_id) ,'NULL') );

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) ;
288: FND_MSG_PUB.Add;
289:
290: FND_MSG_PUB.Count_And_Get(

Line 287: FND_MESSAGE.Set_Token('SUB_OBJ_TABLE_NAME', 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) ;
288: FND_MSG_PUB.Add;
289:
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count,

Line 318: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_INVALID_LINK_CHILD');

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);
322: FND_MSG_PUB.Add;

Line 319: FND_MESSAGE.Set_Token('SUB_OBJ_ID', l_sub_obj_id_token );

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);
322: FND_MSG_PUB.Add;
323:

Line 320: FND_MESSAGE.Set_Token('SUB_OBJ_TABLE_NAME', l_obj_from_table);

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);
322: FND_MSG_PUB.Add;
323:
324: FND_MSG_PUB.Count_And_Get(

Line 321: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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);
322: FND_MSG_PUB.Add;
323:
324: FND_MSG_PUB.Count_And_Get(
325: p_count => x_msg_count,

Line 337: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
341: p_count => x_msg_count,

Line 338: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
341: p_count => x_msg_count,
342: p_data => x_msg_data);

Line 386: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_LINK');

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;
390:

Line 387: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
390:
391: FND_MSG_PUB.Count_And_Get(

Line 398: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
402: p_count => x_msg_count,

Line 399: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
402: p_count => x_msg_count,
403: p_data => x_msg_data);

Line 485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');

481: from cs_sr_link_types_vl
482: where link_type_id = p_link_type_id;
483:
484: if ( p_operation_mode = 'CREATE' ) then
485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');
486: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);

Line 486: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );

482: where link_type_id = p_link_type_id;
483:
484: if ( p_operation_mode = 'CREATE' ) then
485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');
486: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else

Line 487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);

483:
484: if ( p_operation_mode = 'CREATE' ) then
485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');
486: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');

Line 488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);

484: if ( p_operation_mode = 'CREATE' ) then
485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');
486: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );

Line 489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);

485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');
486: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);

Line 491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');

487: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
494: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
495: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);

Line 492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );

488: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
494: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
495: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
496: end if;

Line 493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);

489: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
494: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
495: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
496: end if;
497:

Line 494: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);

490: else
491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
494: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
495: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);
496: end if;
497:
498: FND_MSG_PUB.Add;

Line 495: FND_MESSAGE.Set_Token('API_NAME' , l_api_name_full);

491: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK_UPD');
492: FND_MESSAGE.Set_Token('LINK_TYPE' , l_link_type_name );
493: FND_MESSAGE.Set_Token('OBJECT_TYPE', p_object_type_name);
494: FND_MESSAGE.Set_Token('OBJECT_NUM' , p_object_number);
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;

Line 514: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
518: p_count => x_msg_count,

Line 515: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
518: p_count => x_msg_count,
519: p_data => x_msg_data);

Line 619: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');

615: into l_object_type_name
616: from jtf_objects_vl
617: where object_code = c1rec.object_type;
618:
619: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);
621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
622: FND_MESSAGE.Set_Token('REL_OBJ_TYPE' , l_object_type_name);
623: FND_MESSAGE.Set_Token('REL_OBJ_NUM' , c1rec.object_number);

Line 620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);

616: from jtf_objects_vl
617: where object_code = c1rec.object_type;
618:
619: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);
621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
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);

Line 621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);

617: where object_code = c1rec.object_type;
618:
619: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);
621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
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;

Line 622: FND_MESSAGE.Set_Token('REL_OBJ_TYPE' , l_object_type_name);

618:
619: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);
621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
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;

Line 623: FND_MESSAGE.Set_Token('REL_OBJ_NUM' , c1rec.object_number);

619: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);
621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
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

Line 624: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

620: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_subject_type_name);
621: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
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,

Line 647: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');

643: into l_object_type_name
644: from jtf_objects_vl
645: where object_code = c1rec.object_type;
646:
647: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
650: FND_MESSAGE.Set_Token('REL_OBJ_TYPE' , l_object_type_name);
651: FND_MESSAGE.Set_Token('REL_OBJ_NUM' , c1rec.object_number);

Line 648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);

644: from jtf_objects_vl
645: where object_code = c1rec.object_type;
646:
647: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
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);

Line 649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);

645: where object_code = c1rec.object_type;
646:
647: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
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;

Line 650: FND_MESSAGE.Set_Token('REL_OBJ_TYPE' , l_object_type_name);

646:
647: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
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;

Line 651: FND_MESSAGE.Set_Token('REL_OBJ_NUM' , c1rec.object_number);

647: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_ORIGINAL_EXISTS');
648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
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;

Line 652: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

648: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
649: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
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;

Line 683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');

679: into l_existing_link_type_name
680: from cs_sr_link_types_vl
681: where link_type_id = c2rec.link_type_id;
682:
683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);
686: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);
687: FND_MESSAGE.Set_Token('EXISTING_LINK_TYPE', l_existing_link_type_name);

Line 684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);

680: from cs_sr_link_types_vl
681: where link_type_id = c2rec.link_type_id;
682:
683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);
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);

Line 685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);

681: where link_type_id = c2rec.link_type_id;
682:
683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);
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;

Line 686: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_subject_number);

682:
683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);
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;

Line 687: FND_MESSAGE.Set_Token('EXISTING_LINK_TYPE', l_existing_link_type_name);

683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);
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;

Line 688: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
685: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE', p_subject_type_name);
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

Line 716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');

712: into l_existing_link_type_name
713: from cs_sr_link_types_vl
714: where link_type_id = c2rec.link_type_id;
715:
716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
719: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);
720: FND_MESSAGE.Set_Token('EXISTING_LINK_TYPE' , l_existing_link_type_name );

Line 717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);

713: from cs_sr_link_types_vl
714: where link_type_id = c2rec.link_type_id;
715:
716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
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);

Line 718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);

714: where link_type_id = c2rec.link_type_id;
715:
716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
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;

Line 719: FND_MESSAGE.Set_Token('SUB_OBJ_NUM' , p_object_number);

715:
716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
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;

Line 720: FND_MESSAGE.Set_Token('EXISTING_LINK_TYPE' , l_existing_link_type_name );

716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
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;

Line 721: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);
718: FND_MESSAGE.Set_Token('SUB_OBJ_TYPE' , p_object_type_name);
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

Line 735: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
739: p_count => x_msg_count,

Line 736: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
739: p_count => x_msg_count,
740: p_data => x_msg_data);

Line 802: fnd_message.set_name ('CS', 'CS_SR_NO_ACCESS');

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);
806: fnd_msg_pub.add;

Line 803: fnd_message.set_token('RESP_NAME', l_resp_name );

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);
806: fnd_msg_pub.add;
807: end if;

Line 804: fnd_message.set_token('SR_NUMBER', l_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);
806: fnd_msg_pub.add;
807: end if;
808:

Line 805: fnd_message.set_token('API_NAME', l_api_name_full);

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);
806: fnd_msg_pub.add;
807: end if;
808:
809: FND_MSG_PUB.Count_And_Get(

Line 816: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

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(
820: p_count => x_msg_count,

Line 817: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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(
820: p_count => x_msg_count,
821: p_data => x_msg_data);