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

Line 39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

35:
36:
37: PROCEDURE Create_collab_Assoc(
38: p_api_version_number IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42:
43: x_return_status OUT NOCOPY VARCHAR2,

Line 40: p_commit IN VARCHAR2 := FND_API.G_FALSE,

36:
37: PROCEDURE Create_collab_Assoc(
38: p_api_version_number IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42:
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,

Line 41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

37: PROCEDURE Create_collab_Assoc(
38: p_api_version_number IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42:
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2,

Line 57: l_org_id NUMBER := FND_API.G_MISS_NUM;

53: l_full_name Constant varchar2(60) := g_pkg_name||'.'||l_api_name;
54: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
55: l_return_status_full VARCHAR2(1);
56: l_object_version_number NUMBER := 1;
57: l_org_id NUMBER := FND_API.G_MISS_NUM;
58: l_CONTACT_POINT_ID NUMBER;
59: l_dummy NUMBER;
60:
61: l_cnt_point_rec_type AMS_Cnt_Point_PVT.cnt_point_rec_type ;

Line 98: IF NOT FND_API.Compatible_API_Call ( L_API_VERSION_NUMBER,

94: AMS_UTILITY_PVT.debug_message('Save point : Create_collab_Assoc_PVT created');
95: END IF;
96:
97: -- Standard call to check for call compatibility.
98: IF NOT FND_API.Compatible_API_Call ( L_API_VERSION_NUMBER,
99: p_api_version_number,
100: l_api_name,
101: G_PKG_NAME)
102: THEN

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: p_api_version_number,
100: l_api_name,
101: G_PKG_NAME)
102: THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- Initialize message list if p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean( p_init_msg_list )

Line 107: IF FND_API.to_Boolean( p_init_msg_list )

103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- Initialize message list if p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean( p_init_msg_list )
108: THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111:

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: 'p_collab_assoc_rec_type.Collab_type'||p_collab_assoc_rec_type.Collab_type);
117: END IF;
118:
119: -- Initialize API return status to SUCCESS
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: IF p_collab_assoc_rec_type.Collab_type is NOT null
123: THEN
124: IF p_collab_assoc_rec_type.Collab_type = 'AMS_CONTENT'

Line 129: p_commit => FND_API.G_FALSE,

125: THEN
126:
127: IBC_ASSOCIATIONS_GRP.Create_Association (
128: p_api_version => 1.0,
129: p_commit => FND_API.G_FALSE,
130: p_assoc_type_code => 'AMS_COLB',
131: p_assoc_object1 => p_collab_assoc_rec_type.obj_id,
132: p_assoc_object2 => p_collab_assoc_rec_type.obj_type, -- bug:4384746 created for midtab
133: p_content_item_id => p_collab_assoc_rec_type.collab_assoc_id,

Line 149: OR p_collab_assoc_rec_type.collab_assoc_value = FND_API.g_miss_char)

145: l_cnt_point_rec_type.contact_point_value := p_collab_assoc_rec_type.collab_assoc_value;
146: l_cnt_point_rec_type.contact_point_value_id := p_collab_assoc_rec_type.collab_assoc_id;
147:
148: IF (p_collab_assoc_rec_type.collab_assoc_value IS NULL
149: OR p_collab_assoc_rec_type.collab_assoc_value = FND_API.g_miss_char)
150: THEN
151:
152: IF p_collab_assoc_rec_type.Collab_type = 'INBOUND_SCRIPT'
153: THEN

Line 168: p_init_msg_list => FND_API.G_FALSE,

164: END IF;
165:
166: AMS_Cnt_Point_PVT.Create_Cnt_Point(
167: p_api_version_number => 1.0,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_commit => FND_API.G_FALSE,
170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,

Line 169: p_commit => FND_API.G_FALSE,

165:
166: AMS_Cnt_Point_PVT.Create_Cnt_Point(
167: p_api_version_number => 1.0,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_commit => FND_API.G_FALSE,
170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,

Line 170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

166: AMS_Cnt_Point_PVT.Create_Cnt_Point(
167: p_api_version_number => 1.0,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_commit => FND_API.G_FALSE,
170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,
174: p_cnt_point_rec => l_cnt_point_rec_type,

Line 179: IF x_return_status = FND_API.g_ret_sts_error THEN

175: x_contact_point_id =>x_collab_item_id
176: );
177: END IF;
178:
179: IF x_return_status = FND_API.g_ret_sts_error THEN
180: RAISE FND_API.g_exc_error;
181: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
182: RAISE FND_API.g_exc_unexpected_error;
183: END IF;

Line 180: RAISE FND_API.g_exc_error;

176: );
177: END IF;
178:
179: IF x_return_status = FND_API.g_ret_sts_error THEN
180: RAISE FND_API.g_exc_error;
181: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
182: RAISE FND_API.g_exc_unexpected_error;
183: END IF;
184:

Line 181: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

177: END IF;
178:
179: IF x_return_status = FND_API.g_ret_sts_error THEN
180: RAISE FND_API.g_exc_error;
181: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
182: RAISE FND_API.g_exc_unexpected_error;
183: END IF;
184:
185: IF p_collab_assoc_rec_type.Collab_type = 'AMS_CONTENT'

Line 182: RAISE FND_API.g_exc_unexpected_error;

178:
179: IF x_return_status = FND_API.g_ret_sts_error THEN
180: RAISE FND_API.g_exc_error;
181: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
182: RAISE FND_API.g_exc_unexpected_error;
183: END IF;
184:
185: IF p_collab_assoc_rec_type.Collab_type = 'AMS_CONTENT'
186: THEN

Line 197: IF FND_API.to_Boolean( p_commit )

193: --
194: -- End of API body
195: --
196: -- Standard check for p_commit
197: IF FND_API.to_Boolean( p_commit )
198: THEN
199: COMMIT WORK;
200: END IF;
201:

Line 219: x_return_status := FND_API.g_ret_sts_error;

215:
216: EXCEPTION
217:
218: WHEN AMS_Utility_PVT.resource_locked THEN
219: x_return_status := FND_API.g_ret_sts_error;
220: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Create_collab_Assoc_PVT;

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218: WHEN AMS_Utility_PVT.resource_locked THEN
219: x_return_status := FND_API.g_ret_sts_error;
220: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Create_collab_Assoc_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Create_collab_Assoc_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (
227: p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count,

Line 227: p_encoded => FND_API.G_FALSE,

223: ROLLBACK TO Create_collab_Assoc_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (
227: p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231:

Line 232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

228: p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO Create_collab_Assoc_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: );
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO Create_collab_Assoc_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,

Line 237: p_encoded => FND_API.G_FALSE,

233: ROLLBACK TO Create_collab_Assoc_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: );
241:
242: WHEN OTHERS THEN
243: ROLLBACK TO Create_collab_Assoc_PVT;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;

Line 251: p_encoded => FND_API.G_FALSE,

247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255: End Create_collab_Assoc;