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 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: END;
96:
97: UTL_HTTP.End_Response ( r => l_response );
98:
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101:
102: FND_MSG_PUB.Count_And_Get
103: ( p_count => x_msg_count,

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122: when UTL_HTTP.Http_Client_Error THEN
123: mdebug ( 'Http_Client_Error: ' || Utl_Http.Get_Detailed_Sqlerrm );
124: /* code for all the other defined exceptions you can recover from */
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
128: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get

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

124: /* code for all the other defined exceptions you can recover from */
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
128: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125:
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
128: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );

Line 134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
136: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: FND_MSG_PUB.Count_And_Get

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

132: p_data => x_msg_data
133: );
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
136: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

133: );
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
136: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data
141: );

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

139: ( p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: IF FND_MSG_PUB.Check_Msg_Level
145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
146: THEN
147: FND_MSG_PUB.Add_Exc_Msg

Line 189: -- DEFAULT = FND_API.G_FALSE

185: -- Parameters:
186: -- IN : p_api_version IN NUMBER (required)
187: -- API Version of this procedure
188: -- p_init_msg_level IN VARCHAR2 (optional)
189: -- DEFAULT = FND_API.G_FALSE
190: -- Indicates whether the message stack needs to be cleared
191: -- p_commit IN VARCHAR2 (optional)
192: -- DEFAULT = FND_API.G_FALSE
193: -- Indicates whether the data should be committed

Line 192: -- DEFAULT = FND_API.G_FALSE

188: -- p_init_msg_level IN VARCHAR2 (optional)
189: -- DEFAULT = FND_API.G_FALSE
190: -- Indicates whether the message stack needs to be cleared
191: -- p_commit IN VARCHAR2 (optional)
192: -- DEFAULT = FND_API.G_FALSE
193: -- Indicates whether the data should be committed
194: -- p_group_id IN NUMBER (required)
195: -- Group to which the member is being added
196: -- Eg., A Group

Line 203: -- FND_API.G_RET_STS_SUCCESS if success

199: -- Eg., PERSON
200: --
201: -- OUT : x_return_status OUT NUMBER
202: -- Result of all the operations
203: -- FND_API.G_RET_STS_SUCCESS if success
204: -- FND_API.G_RET_STS_ERROR if error
205: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
206: -- x_msg_count OUT NUMBER
207: -- number of messages in the message list

Line 204: -- FND_API.G_RET_STS_ERROR if error

200: --
201: -- OUT : x_return_status OUT NUMBER
202: -- Result of all the operations
203: -- FND_API.G_RET_STS_SUCCESS if success
204: -- FND_API.G_RET_STS_ERROR if error
205: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
206: -- x_msg_count OUT NUMBER
207: -- number of messages in the message list
208: -- x_msg_data OUT VARCHAR2

Line 205: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

201: -- OUT : x_return_status OUT NUMBER
202: -- Result of all the operations
203: -- FND_API.G_RET_STS_SUCCESS if success
204: -- FND_API.G_RET_STS_ERROR if error
205: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
206: -- x_msg_count OUT NUMBER
207: -- number of messages in the message list
208: -- x_msg_data OUT VARCHAR2
209: -- if number of messages is 1, then this parameter

Line 251: IF NOT FND_API.Compatible_API_Call (l_api_version,

247:
248: BEGIN
249: -- Standard Start of API savepoint
250: mdebug('. ADD_OFO_GROUP_MEMBER: ADD_OFO_GROUP_MEMBER .....1...... ');
251: IF NOT FND_API.Compatible_API_Call (l_api_version,
252: p_api_version,
253: l_api_name,
254: G_PKG_NAME)
255: THEN

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: p_api_version,
253: l_api_name,
254: G_PKG_NAME)
255: THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize API message list if necessary.
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

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

256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize API message list if necessary.
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: mdebug(' in DOM WS interface ' || p_group_id || ' ' || p_member_id);

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

320: l_param_query_string VARCHAR2(2000);
321:
322: BEGIN
323: -- Standard Start of API savepoint
324: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322: BEGIN
323: -- Standard Start of API savepoint
324: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329:
330: l_param_query_string:='opName=updateDocStatus&docId='||p_document_id||'&status='||p_status||'&serviceUrl='||p_service_Url||'&loggedInUser='||p_login_user_name;

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

368:
369: BEGIN
370:
371: -- Standard Start of API savepoint
372: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
373: THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:

Line 374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

370:
371: -- Standard Start of API savepoint
372: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
373: THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377: -- code_debug('YSIREESH: User id: '+FND_PROFILE.Value('USER_ID'));
378: 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 416: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)

412: l_param_query_string VARCHAR2(2000);
413:
414: BEGIN
415: -- Standard Start of API savepoint
416: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
417: THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: BEGIN
415: -- Standard Start of API savepoint
416: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)
417: THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:
421:
422: 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';