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

424: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
425: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.create_set_link', SQLERRM );
426: end if;
427: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
428: FND_MSG_PUB.Add;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data);

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

426: end if;
427: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
428: FND_MSG_PUB.Add;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data);
433: end Create_Set_Link;
434:

Line 760: fnd_msg_pub.Add;

756: OR P_SET_ID is NULL
757: OR P_OTHER_ID is null
758: OR p_link_type is null ) THEN
759: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
760: fnd_msg_pub.Add;
761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
762: p_count => X_MSG_COUNT,
763: p_data => X_MSG_DATA);
764: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

757: OR P_OTHER_ID is null
758: OR p_link_type is null ) THEN
759: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
760: fnd_msg_pub.Add;
761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
762: p_count => X_MSG_COUNT,
763: p_data => X_MSG_DATA);
764: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
765: return;

Line 771: FND_MSG_PUB.ADD;

767:
768: -- validate the link type
769: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
770: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
773: p_count => X_MSG_COUNT,
774: p_data => X_MSG_DATA);
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

768: -- validate the link type
769: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
770: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
773: p_count => X_MSG_COUNT,
774: p_data => X_MSG_DATA);
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: return;

Line 787: FND_MSG_PUB.ADD;

783: l_orig_soln_number, l_orig_soln_status;
784: IF ( Validate_Link%NOTFOUND ) THEN
785: CLOSE Validate_Link;
786: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
787: FND_MSG_PUB.ADD;
788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
789: p_count => X_MSG_COUNT,
790: p_data => X_MSG_DATA);
791: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

784: IF ( Validate_Link%NOTFOUND ) THEN
785: CLOSE Validate_Link;
786: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
787: FND_MSG_PUB.ADD;
788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
789: p_count => X_MSG_COUNT,
790: p_data => X_MSG_DATA);
791: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
792: return;

Line 805: FND_MSG_PUB.ADD;

801: IF ( l_orig_set_id <> P_SET_ID
802: OR l_orig_object_code <> P_OBJECT_CODE
803: OR l_orig_other_id <> P_OTHER_ID ) THEN
804: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');
805: FND_MSG_PUB.ADD;
806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
807: p_count => X_MSG_COUNT,
808: p_data => X_MSG_DATA);
809: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

802: OR l_orig_object_code <> P_OBJECT_CODE
803: OR l_orig_other_id <> P_OTHER_ID ) THEN
804: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');
805: FND_MSG_PUB.ADD;
806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
807: p_count => X_MSG_COUNT,
808: p_data => X_MSG_DATA);
809: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
810: return;

Line 913: FND_MSG_PUB.Add;

909: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
910: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );
911: end if;
912: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
913: FND_MSG_PUB.Add;
914: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
915:
916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,

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

912: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
913: FND_MSG_PUB.Add;
914: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
915:
916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data);
919: END Update_Set_Link;
920:

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

994: l_ret_val NUMBER;
995: begin
996: if(P_SET_ID is null or
997: P_OBJECT_CODE is null OR P_OTHER_ID is NULL ) then
998: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
999: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1000: fnd_msg_pub.Add;
1001: end if;
1002: return ERROR_STATUS;

Line 1000: fnd_msg_pub.Add;

996: if(P_SET_ID is null or
997: P_OBJECT_CODE is null OR P_OTHER_ID is NULL ) then
998: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
999: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1000: fnd_msg_pub.Add;
1001: end if;
1002: return ERROR_STATUS;
1003: end if;
1004:

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

1053: -- Begin Validation
1054:
1055: -- validate parameter
1056: if (P_LINK_ID is null ) then
1057: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1058: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1059: fnd_msg_pub.Add;
1060: end if;
1061: return ERROR_STATUS;

Line 1059: fnd_msg_pub.Add;

1055: -- validate parameter
1056: if (P_LINK_ID is null ) then
1057: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1058: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1059: fnd_msg_pub.Add;
1060: end if;
1061: return ERROR_STATUS;
1062: end if;
1063:

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

1067: FETCH Valid_Link into l_soln_number, l_soln_status, l_link_object_code,
1068: l_link_other_id;
1069: IF( Valid_Link%NOTFOUND ) THEN
1070: CLOSE Valid_Link;
1071: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1072: fnd_message.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
1073: fnd_msg_pub.Add;
1074: end if;
1075: return ERROR_STATUS;

Line 1073: fnd_msg_pub.Add;

1069: IF( Valid_Link%NOTFOUND ) THEN
1070: CLOSE Valid_Link;
1071: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1072: fnd_message.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
1073: fnd_msg_pub.Add;
1074: end if;
1075: return ERROR_STATUS;
1076: END IF;
1077: CLOSE Valid_Link;

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

1107: ROLLBACK TO Delete_Link_SP;
1108: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1109: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1110: end if;
1111: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1112: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1113: FND_MSG_PUB.Add;
1114: END IF;
1115: return ERROR_STATUS;

Line 1113: FND_MSG_PUB.Add;

1109: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1110: end if;
1111: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1112: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1113: FND_MSG_PUB.Add;
1114: END IF;
1115: return ERROR_STATUS;
1116: end Delete_Set_Link;
1117: