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

Line 207: , P_INIT_MSG_LIST => FND_API.G_TRUE

203: END IF;
204:
205: CSP_PARTS_REQUIREMENT.Process_Requirement
206: ( P_API_VERSION => 1
207: , P_INIT_MSG_LIST => FND_API.G_TRUE
208: , PX_HEADER_REC => l_header_rec
209: , PX_LINE_TABLE => p_line_table
210: , P_CREATE_ORDER_FLAG => l_create_order
211: , X_RETURN_STATUS => l_return_status

Line 216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

212: , X_MSG_COUNT => l_msg_count
213: , X_MSG_DATA => l_msg_data
214: );
215:
216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
217: /*** exception occurred in API -> return errmsg ***/
218: CSM_UTIL_PKG.LOG ( 'Requirement Creation failed for for req_header_id: '||p_req_hid || 'with error -'||l_msg_data
219: , 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_PROCEDURE );
220: p_error_msg := fnd_msg_pub.get(l_msg_count,'F');

Line 221: l_return_status := FND_API.G_RET_STS_ERROR;

217: /*** exception occurred in API -> return errmsg ***/
218: CSM_UTIL_PKG.LOG ( 'Requirement Creation failed for for req_header_id: '||p_req_hid || 'with error -'||l_msg_data
219: , 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_PROCEDURE );
220: p_error_msg := fnd_msg_pub.get(l_msg_count,'F');
221: l_return_status := FND_API.G_RET_STS_ERROR;
222:
223: ELSIF is_html5 THEN
224:
225: SELECT user_id,responsibility_id, app_id

Line 233: ,p_Init_Msg_List => FND_API.G_TRUE

229: MO_GLOBAL.INIT ('CSM');
230:
231: CSP_PARTS_REQUIREMENT.csptrreq_order_res(
232: p_api_version =>1
233: ,p_Init_Msg_List => FND_API.G_TRUE
234: ,px_header_rec => l_header_rec
235: ,px_line_table => l_line_tbl
236: ,X_Return_Status => l_return_status
237: ,X_Msg_Count => l_msg_count

Line 241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

237: ,X_Msg_Count => l_msg_count
238: ,X_Msg_Data => l_msg_data
239: );
240:
241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
242: CSM_UTIL_PKG.LOG ( 'Order creation failed for for req_header_id: '||p_req_hid || 'with error -'||l_msg_data
243: , 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_PROCEDURE );
244: p_error_msg := fnd_msg_pub.get(l_msg_count,'F');
245: l_return_status := FND_API.G_RET_STS_ERROR;

Line 245: l_return_status := FND_API.G_RET_STS_ERROR;

241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
242: CSM_UTIL_PKG.LOG ( 'Order creation failed for for req_header_id: '||p_req_hid || 'with error -'||l_msg_data
243: , 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_PROCEDURE );
244: p_error_msg := fnd_msg_pub.get(l_msg_count,'F');
245: l_return_status := FND_API.G_RET_STS_ERROR;
246: ROLLBACK TO save_rec2; --all req lines deferred
247: END IF;
248: END IF;
249:

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_INSERT for req_header_id: '||p_req_hid || FND_GLOBAL.LOCAL_CHR(10) || substr(sqlerrm,0,2000),
261: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
262: FND_LOG.LEVEL_EXCEPTION );
263: p_error_msg := substr(sqlerrm,0,2000);
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: END APPLY_INSERT;
266:
267: /***
268: This procedure is called by APPLY_CLIENT_CHANGES and deletes all requirement headers from the inqueue,

Line 334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

330: x_return_status
331: );
332:
333: /*** was delete successful? ***/
334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
335: /*** no -> rollback ***/
336:
337: CSM_UTIL_PKG.LOG
338: ( 'Deleting from inqueue failed, rolling back to savepoinT for req header id: '||r_get_req_headers_from_inq.requirement_header_id,

Line 368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

364: , r_get_req_headers_from_inq.dmltype$$
365: );
366:
367: /*** Was defer successful? ***/
368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
369: /*** no -> rollback ***/
370:
371: CSM_UTIL_PKG.LOG( 'Defer record failed, rolling back to savepoint for req header id: '
372: ||r_get_req_headers_from_inq.requirement_header_id,'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', FND_LOG.LEVEL_PROCEDURE);

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: /*** catch and log exceptions ***/
384: CSM_UTIL_PKG.LOG
385: ( 'Exception occurred in DELETE_REQ_HEADERS_FROM_INQ: '|| FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
386: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', FND_LOG.LEVEL_EXCEPTION);
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: END DELETE_REQ_HEADERS_FROM_INQ;
389:
390: /***
391: This procedure is called by APPLY_CLIENT_CHANGES and processes all inqueue requirement lines,

Line 477: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

473: , l_error_msg
474: , x_return_status
475: );
476: /*** was record processed successfully? ***/
477: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
478:
479: FOR r_requirements IN c_requirement_lines ( p_user_name, p_tranid,p_req_hid)
480: LOOP
481: /*** Yes -> delete record from inqueue ***/

Line 499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

495: l_return_status
496: );
497:
498: /*** was delete successful? ***/
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: /*** no -> rollback ***/
501: CSM_UTIL_PKG.LOG( 'Deleting from inqueue failed, rolling back to savepoint for req_line_id ' || r_requirements.requirement_line_id,'CSM_REQUIREMENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE );
502:
503: ROLLBACK TO save_rec;

Line 529: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

525: );
526:
527:
528: /*** Was defer successful? ***/
529: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
530: /*** no -> rollback ***/
531: CSM_UTIL_PKG.LOG( 'Defer record failed, rolling back to savepoint for req_line_id: ' || r_requirements.requirement_line_id,
532: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_PROCEDURE );
533:

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: /*** catch and log exceptions ***/
544: CSM_UTIL_PKG.LOG( 'Exception occurred in APPLY_RECORD:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
545: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
546:
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END APPLY_RECORD;
549:
550: /***
551: This procedure is called by CSM_SERVICEP_WRAPPER_PKG when publication item CSM_REQ_LINES