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 212: , P_INIT_MSG_LIST => FND_API.G_TRUE

208: l_line_table(1) := l_line_rec;
209:
210: CSP_PARTS_REQUIREMENT.Process_Requirement
211: ( P_API_VERSION => 1
212: , P_INIT_MSG_LIST => FND_API.G_TRUE
213: , PX_HEADER_REC => l_header_rec
214: , PX_LINE_TABLE => l_line_table
215: , P_CREATE_ORDER_FLAG => 'Y'
216: , X_RETURN_STATUS => x_return_status

Line 221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

217: , X_MSG_COUNT => l_msg_count
218: , X_MSG_DATA => l_msg_data
219: );
220:
221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
222: /*** exception occurred in API -> return errmsg ***/
223: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
224: (
225: p_api_error => TRUE

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: (
246: p_api_error => TRUE
247: );
248:
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: END APPLY_INSERT;
251:
252: /***
253: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: 'CSM_REQUIREMENTS_PKG.APPLY_UPDATE',
266: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
267:
268: -- No update possible so return success
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: /*** exception occurred in API -> return errmsg ***/
273: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

267:
268: -- No update possible so return success
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: /*** exception occurred in API -> return errmsg ***/
273: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
274: (
275: p_api_error => TRUE

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: (
296: p_api_error => TRUE
297: );
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: END APPLY_UPDATE;
301:
302: /***
303: This procedure is called by APPLY_CLIENT_CHANGES for every record in inqueue that needs to be processed.

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: , x_return_status IN OUT NOCOPY VARCHAR2
313: ) IS
314: BEGIN
315: /*** initialize return status and message list ***/
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: CSM_UTIL_PKG.LOG
319: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id,
320: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: , p_token_name1 => 'DML'
359: , p_token_value1 => p_record.dmltype$$
360: );
361:
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: ELSE
364: -- invalid dml type
365:
366: CSM_UTIL_PKG.LOG

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: , p_token_name1 => 'DML'
375: , p_token_value1 => p_record.dmltype$$
376: );
377:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: CSM_UTIL_PKG.LOG
382: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id,

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: (
397: p_api_error => TRUE
398: );
399:
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: END APPLY_RECORD;
402:
403: /***
404: This procedure is called by PROCESS_REQS and deletes all requirement headers from the inqueue,

Line 457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

453: x_return_status
454: );
455:
456: /*** was delete successful? ***/
457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: /*** no -> rollback ***/
459:
460: CSM_UTIL_PKG.LOG
461: ( 'Deleting from inqueue failed, rolling back to savepoinT'|| 'for PK '||r_get_req_headers_from_inq.requirement_header_id,

Line 468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

464:
465: ROLLBACK TO save_rec;
466: END IF;
467:
468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
469: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
470:
471: CSM_UTIL_PKG.LOG
472: ( 'Record not processed successfully, deferring and rejecting record'|| 'for PK '||r_get_req_headers_from_inq.requirement_header_id,

Line 491: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

487: , r_get_req_headers_from_inq.dmltype$$
488: );
489:
490: /*** Was defer successful? ***/
491: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: /*** no -> rollback ***/
493:
494: CSM_UTIL_PKG.LOG
495: ( 'Defer record failed, rolling back to savepoint'|| 'for PK '||r_get_req_headers_from_inq.requirement_header_id,

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
516: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
517:
518:
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: END DELETE_REQ_HEADERS_FROM_INQ;
521:
522: /***
523: This procedure is called by APPLY_CLIENT_CHANGES and processes all inqueue requirement lines,

Line 558: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

554: , x_return_status
555: );
556:
557: /*** was record processed successfully? ***/
558: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
559: /*** Yes -> delete record from inqueue ***/
560: CSM_UTIL_PKG.LOG
561: ( 'Record successfully processed, deleting from inqueue'|| ' for PK ' || r_requirements.requirement_line_id,
562: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

Line 580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

576: x_return_status
577: );
578:
579: /*** was delete successful? ***/
580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
581: /*** no -> rollback ***/
582: CSM_UTIL_PKG.LOG
583: ( 'Deleting from inqueue failed, rolling back to savepoint'|| ' for PK ' || r_requirements.requirement_line_id,
584: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

Line 591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

587: ROLLBACK TO save_rec;
588: END IF;
589: END IF;
590:
591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
592: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
593: CSM_UTIL_PKG.LOG
594: ( 'Record not processed successfully, deferring and rejecting record'|| ' for PK ' || r_requirements.requirement_line_id,
595: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

Line 614: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

610: );
611:
612:
613: /*** Was defer successful? ***/
614: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
615: /*** no -> rollback ***/
616: CSM_UTIL_PKG.LOG
617: ( 'Defer record failed, rolling back to savepoint'|| ' for PK ' || r_requirements.requirement_line_id,
618: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: ( 'Exception occurred in PROCESS_REQS:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
639: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',
640: FND_LOG.LEVEL_EXCEPTION ); -- put PK column here
641:
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: END PROCESS_REQS;
644:
645: /***
646: This procedure is called by APPLY_CLIENT_CHANGES and processes all inqueue requirement lines,

Line 682: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

678: , x_return_status
679: );
680:
681: /*** was record processed successfully? ***/
682: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
683: /*** Yes -> delete record from inqueue ***/
684: CSM_UTIL_PKG.LOG
685: ( 'Record successfully processed, deleting from inqueue'|| ' for PK ' ||r_requirements.requirement_line_id,
686: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

Line 703: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

699: x_return_status
700: );
701:
702: /*** was delete successful? ***/
703: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
704: /*** no -> rollback ***/
705: CSM_UTIL_PKG.LOG
706: ( 'Deleting from inqueue failed, rolling back to savepoint'|| ' for PK ' ||r_requirements.requirement_line_id,
707: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

Line 714: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

710: ROLLBACK TO save_rec;
711: END IF;
712: END IF;
713:
714: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
715: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
716:
717: CSM_UTIL_PKG.LOG
718: ( 'Record not processed successfully, deferring and rejecting record'|| ' for PK ' ||r_requirements.requirement_line_id,

Line 736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

732: , r_requirements.dmltype$$
733: );
734:
735: /*** Was defer successful? ***/
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: /*** no -> rollback ***/
738: CSM_UTIL_PKG.LOG
739: ( 'Defer record failed, rolling back to savepoint'|| ' for PK ' ||r_requirements.requirement_line_id,
740: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',
760: FND_LOG.LEVEL_EXCEPTION ); -- put PK column here
761:
762:
763: x_return_status := FND_API.G_RET_STS_ERROR;
764:
765: END PROCESS_REQS_NO_HEADERS;
766:
767: