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

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110: END;
111:
112: UTL_HTTP.End_Response ( r => l_response );
113:
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116:
117: FND_MSG_PUB.Count_And_Get
118: ( p_count => x_msg_count,

Line 145: WHEN FND_API.G_EXC_ERROR THEN

141: when UTL_HTTP.Http_Client_Error THEN
142: mdebug ( 'Http_Client_Error: ' || Utl_Http.Get_Detailed_Sqlerrm );
143: /* code for all the other defined exceptions you can recover from */
144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
147: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get

Line 147: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');

143: /* code for all the other defined exceptions you can recover from */
144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
147: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count,
151: p_data => x_msg_data

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
147: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count,
151: p_data => x_msg_data
152: );

Line 153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
155: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157: FND_MSG_PUB.Count_And_Get

Line 155: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

151: p_data => x_msg_data
152: );
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
155: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

152: );
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
155: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );

Line 162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );
161: WHEN OTHERS THEN
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
163: IF FND_MSG_PUB.Check_Msg_Level
164: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN
166: FND_MSG_PUB.Add_Exc_Msg

Line 264: -- DEFAULT = FND_API.G_FALSE

260: -- Parameters:
261: -- IN : p_api_version IN NUMBER (required)
262: -- API Version of this procedure
263: -- p_init_msg_level IN VARCHAR2 (optional)
264: -- DEFAULT = FND_API.G_FALSE
265: -- Indicates whether the message stack needs to be cleared
266: -- p_commit IN VARCHAR2 (optional)
267: -- DEFAULT = FND_API.G_FALSE
268: -- Indicates whether the data should be committed

Line 267: -- DEFAULT = FND_API.G_FALSE

263: -- p_init_msg_level IN VARCHAR2 (optional)
264: -- DEFAULT = FND_API.G_FALSE
265: -- Indicates whether the message stack needs to be cleared
266: -- p_commit IN VARCHAR2 (optional)
267: -- DEFAULT = FND_API.G_FALSE
268: -- Indicates whether the data should be committed
269: -- p_group_id IN NUMBER (required)
270: -- Group to which the member is being added
271: -- Eg., A Group

Line 278: -- FND_API.G_RET_STS_SUCCESS if success

274: -- Eg., PERSON
275: --
276: -- OUT : x_return_status OUT NUMBER
277: -- Result of all the operations
278: -- FND_API.G_RET_STS_SUCCESS if success
279: -- FND_API.G_RET_STS_ERROR if error
280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
281: -- x_msg_count OUT NUMBER
282: -- number of messages in the message list

Line 279: -- FND_API.G_RET_STS_ERROR if error

275: --
276: -- OUT : x_return_status OUT NUMBER
277: -- Result of all the operations
278: -- FND_API.G_RET_STS_SUCCESS if success
279: -- FND_API.G_RET_STS_ERROR if error
280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
281: -- x_msg_count OUT NUMBER
282: -- number of messages in the message list
283: -- x_msg_data OUT VARCHAR2

Line 280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

276: -- OUT : x_return_status OUT NUMBER
277: -- Result of all the operations
278: -- FND_API.G_RET_STS_SUCCESS if success
279: -- FND_API.G_RET_STS_ERROR if error
280: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
281: -- x_msg_count OUT NUMBER
282: -- number of messages in the message list
283: -- x_msg_data OUT VARCHAR2
284: -- if number of messages is 1, then this parameter

Line 326: IF NOT FND_API.Compatible_API_Call (l_api_version,

322:
323: BEGIN
324: -- Standard Start of API savepoint
325: mdebug('. ADD_OFO_GROUP_MEMBER: ADD_OFO_GROUP_MEMBER .....1...... ');
326: IF NOT FND_API.Compatible_API_Call (l_api_version,
327: p_api_version,
328: l_api_name,
329: G_PKG_NAME)
330: THEN

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: p_api_version,
328: l_api_name,
329: G_PKG_NAME)
330: THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: -- Initialize API message list if necessary.
334: -- Initialize message list if p_init_msg_list is set to TRUE.
335: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 335: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: -- Initialize API message list if necessary.
334: -- Initialize message list if p_init_msg_list is set to TRUE.
335: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: mdebug(' in DOM WS interface ' || p_group_id || ' ' || p_member_id);

Line 399: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)

395: l_param_query_string VARCHAR2(2000);
396:
397: BEGIN
398: -- Standard Start of API savepoint
399: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
400: THEN
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

397: BEGIN
398: -- Standard Start of API savepoint
399: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
400: THEN
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404:
405: l_param_query_string:='opName=updateDocStatus&docId='||p_document_id||'&status='||p_status||'&serviceUrl='||p_service_Url||'&loggedInUser='||p_login_user_name;

Line 447: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)

443:
444: BEGIN
445:
446: -- Standard Start of API savepoint
447: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445:
446: -- Standard Start of API savepoint
447: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: -- code_debug('YSIREESH: User id: '+FND_PROFILE.Value('USER_ID'));
453: l_param_query_string:='opName=grantAttachmentsOCSRole&familyId='||p_family_id||'&role='||p_role||'&serviceUrl=' || p_service_url || '&userToRole='||p_user_name||'&loggedInUser='||p_user_login;

Line 491: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)

487: l_param_query_string VARCHAR2(2000);
488:
489: BEGIN
490: -- Standard Start of API savepoint
491: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
492: THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495:

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: BEGIN
490: -- Standard Start of API savepoint
491: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
492: THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495:
496:
497: l_param_query_string:='opName=grantAttachmentsOCSRole&familyId='||p_family_id||'&role='||p_role||'&serviceUrl=' || p_service_url || '&userToRole='||p_user_name||'&loggedInUser='||p_user_login||'&addOrRemove=REMOVE';