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_KB_SET_LINKS_PKG dependencies on FND_MSG_PUB

Line 26: fnd_msg_pub.Add;

22: from cs_kb_sets_b
23: where set_id = p_set_source_id;
24: if(l_count <= 0) then
25: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
26: fnd_msg_pub.Add;
27: goto error_found;
28: end if;
29:
30: -- Copying data with previous set id to new set_id.

Line 191: fnd_msg_pub.Add;

187: OR P_SET_ID is NULL
188: OR P_OTHER_ID is null
189: OR p_link_type is null ) THEN
190: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
191: fnd_msg_pub.Add;
192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
193: p_count => X_MSG_COUNT,
194: p_data => X_MSG_DATA);
195: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

188: OR P_OTHER_ID is null
189: OR p_link_type is null ) THEN
190: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
191: fnd_msg_pub.Add;
192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
193: p_count => X_MSG_COUNT,
194: p_data => X_MSG_DATA);
195: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
196: return;

Line 204: FND_MSG_PUB.ADD;

200: FETCH Validate_Solution INTO l_set_number, l_set_status;
201: IF ( Validate_Solution%NOTFOUND ) THEN
202: CLOSE Validate_Solution;
203: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SET_ID');
204: FND_MSG_PUB.ADD;
205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
206: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
207: p_count => X_MSG_COUNT,
208: p_data => X_MSG_DATA);

Line 206: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

202: CLOSE Validate_Solution;
203: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SET_ID');
204: FND_MSG_PUB.ADD;
205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
206: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
207: p_count => X_MSG_COUNT,
208: p_data => X_MSG_DATA);
209: return;
210: END IF;

Line 242: FND_MSG_PUB.ADD;

238: IF l_ext_obj_count = 0 THEN
239:
240: --dbms_output.put_line('Invalid Ext Object ');
241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_EXT_OBJ');
242: FND_MSG_PUB.ADD;
243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
245: p_count => X_MSG_COUNT,
246: p_data => X_MSG_DATA);

Line 244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

240: --dbms_output.put_line('Invalid Ext Object ');
241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_EXT_OBJ');
242: FND_MSG_PUB.ADD;
243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
245: p_count => X_MSG_COUNT,
246: p_data => X_MSG_DATA);
247: return;
248: END IF;

Line 263: FND_MSG_PUB.ADD;

259: END IF;
260:
261: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
262: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
263: FND_MSG_PUB.ADD;
264: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
266: p_count => X_MSG_COUNT,
267: p_data => X_MSG_DATA);

Line 265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

261: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
262: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
263: FND_MSG_PUB.ADD;
264: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
266: p_count => X_MSG_COUNT,
267: p_data => X_MSG_DATA);
268: return;
269: END IF;

Line 404: FND_MSG_PUB.Add;

400: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
401: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.create_set_link', SQLERRM );
402: end if;
403: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
404: FND_MSG_PUB.Add;
405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data);

Line 406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

402: end if;
403: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
404: FND_MSG_PUB.Add;
405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data);
409: end Create_Set_Link;
410:

Line 736: fnd_msg_pub.Add;

732: OR P_SET_ID is NULL
733: OR P_OTHER_ID is null
734: OR p_link_type is null ) THEN
735: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
736: fnd_msg_pub.Add;
737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
738: p_count => X_MSG_COUNT,
739: p_data => X_MSG_DATA);
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

733: OR P_OTHER_ID is null
734: OR p_link_type is null ) THEN
735: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
736: fnd_msg_pub.Add;
737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
738: p_count => X_MSG_COUNT,
739: p_data => X_MSG_DATA);
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: return;

Line 747: FND_MSG_PUB.ADD;

743:
744: -- validate the link type
745: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
746: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
747: FND_MSG_PUB.ADD;
748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
749: p_count => X_MSG_COUNT,
750: p_data => X_MSG_DATA);
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

744: -- validate the link type
745: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
746: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
747: FND_MSG_PUB.ADD;
748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
749: p_count => X_MSG_COUNT,
750: p_data => X_MSG_DATA);
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: return;

Line 763: FND_MSG_PUB.ADD;

759: l_orig_soln_number, l_orig_soln_status;
760: IF ( Validate_Link%NOTFOUND ) THEN
761: CLOSE Validate_Link;
762: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
763: FND_MSG_PUB.ADD;
764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
765: p_count => X_MSG_COUNT,
766: p_data => X_MSG_DATA);
767: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

760: IF ( Validate_Link%NOTFOUND ) THEN
761: CLOSE Validate_Link;
762: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
763: FND_MSG_PUB.ADD;
764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
765: p_count => X_MSG_COUNT,
766: p_data => X_MSG_DATA);
767: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
768: return;

Line 781: FND_MSG_PUB.ADD;

777: IF ( l_orig_set_id <> P_SET_ID
778: OR l_orig_object_code <> P_OBJECT_CODE
779: OR l_orig_other_id <> P_OTHER_ID ) THEN
780: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');
781: FND_MSG_PUB.ADD;
782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
783: p_count => X_MSG_COUNT,
784: p_data => X_MSG_DATA);
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

778: OR l_orig_object_code <> P_OBJECT_CODE
779: OR l_orig_other_id <> P_OTHER_ID ) THEN
780: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');
781: FND_MSG_PUB.ADD;
782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
783: p_count => X_MSG_COUNT,
784: p_data => X_MSG_DATA);
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: return;

Line 889: FND_MSG_PUB.Add;

885: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
886: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );
887: end if;
888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
889: FND_MSG_PUB.Add;
890: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
891:
892: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
893: p_count => x_msg_count,

Line 892: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
889: FND_MSG_PUB.Add;
890: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
891:
892: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
893: p_count => x_msg_count,
894: p_data => x_msg_data);
895: END Update_Set_Link;
896:

Line 974: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

970: l_ret_val NUMBER;
971: begin
972: if(P_SET_ID is null or
973: P_OBJECT_CODE is null OR P_OTHER_ID is NULL ) then
974: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
975: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
976: fnd_msg_pub.Add;
977: end if;
978: return ERROR_STATUS;

Line 976: fnd_msg_pub.Add;

972: if(P_SET_ID is null or
973: P_OBJECT_CODE is null OR P_OTHER_ID is NULL ) then
974: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
975: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
976: fnd_msg_pub.Add;
977: end if;
978: return ERROR_STATUS;
979: end if;
980:

Line 1033: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1029: -- Begin Validation
1030:
1031: -- validate parameter
1032: if (P_LINK_ID is null ) then
1033: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1034: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1035: fnd_msg_pub.Add;
1036: end if;
1037: return ERROR_STATUS;

Line 1035: fnd_msg_pub.Add;

1031: -- validate parameter
1032: if (P_LINK_ID is null ) then
1033: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1034: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1035: fnd_msg_pub.Add;
1036: end if;
1037: return ERROR_STATUS;
1038: end if;
1039:

Line 1047: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1043: FETCH Valid_Link into l_soln_number, l_soln_status, l_link_object_code,
1044: l_link_other_id;
1045: IF( Valid_Link%NOTFOUND ) THEN
1046: CLOSE Valid_Link;
1047: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1048: fnd_message.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
1049: fnd_msg_pub.Add;
1050: end if;
1051: return ERROR_STATUS;

Line 1049: fnd_msg_pub.Add;

1045: IF( Valid_Link%NOTFOUND ) THEN
1046: CLOSE Valid_Link;
1047: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1048: fnd_message.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
1049: fnd_msg_pub.Add;
1050: end if;
1051: return ERROR_STATUS;
1052: END IF;
1053: CLOSE Valid_Link;

Line 1087: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1083: ROLLBACK TO Delete_Link_SP;
1084: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1085: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1086: end if;
1087: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1088: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1089: FND_MSG_PUB.Add;
1090: END IF;
1091: return ERROR_STATUS;

Line 1089: FND_MSG_PUB.Add;

1085: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1086: end if;
1087: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1088: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1089: FND_MSG_PUB.Add;
1090: END IF;
1091: return ERROR_STATUS;
1092: end Delete_Set_Link;
1093: