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_LOG

Line 100: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

96:
97: CSM_UTIL_PKG.LOG
98: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_INSERT'|| 'for PK '||p_record.requirement_line_id,
99: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
100: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
101:
102:
103: IF p_get_inqueue_header THEN
104:

Line 232: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

228:
229: CSM_UTIL_PKG.LOG
230: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_INSERT'|| 'for PK '||p_record.requirement_line_id,
231: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
232: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
233:
234:
235: EXCEPTION WHEN OTHERS THEN
236:

Line 240: FND_LOG.LEVEL_EXCEPTION ); -- put PK column here

236:
237: CSM_UTIL_PKG.LOG
238: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_INSERT'|| 'for PK '||p_record.requirement_line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
239: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
240: FND_LOG.LEVEL_EXCEPTION ); -- put PK column here
241:
242: fnd_msg_pub.Add_Exc_Msg( 'CSM_REQUIREMENTS_PKG', 'APPLY_INSERT', sqlerrm);
243:
244: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 266: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

262:
263: CSM_UTIL_PKG.LOG
264: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.requirement_line_id ,
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:

Line 282: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

278:
279: CSM_UTIL_PKG.LOG
280: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.requirement_line_id ,
281: 'CSM_REQUIREMENTS_PKG.APPLY_UPDATE',
282: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
283:
284:
285: EXCEPTION WHEN OTHERS THEN
286:

Line 290: FND_LOG.LEVEL_EXCEPTION); -- put PK column here

286:
287: CSM_UTIL_PKG.LOG
288: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.requirement_line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
289: 'CSM_REQUIREMENTS_PKG.APPLY_UPDATE',
290: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
291:
292:
293: fnd_msg_pub.Add_Exc_Msg( 'CSM_REQUIREMENTS_PKG', 'APPLY_UPDATE', sqlerrm);
294: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 321: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

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',
321: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
322:
323: CSM_UTIL_PKG.LOG
324: ( 'Processing requirement '|| 'for PK '||p_record.requirement_line_id ||'DMLTYPE = ' || p_record.dmltype$$,
325: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

Line 326: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

322:
323: CSM_UTIL_PKG.LOG
324: ( 'Processing requirement '|| 'for PK '||p_record.requirement_line_id ||'DMLTYPE = ' || p_record.dmltype$$,
325: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',
326: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
327:
328: IF p_record.dmltype$$='I' THEN
329: -- Process insert
330: APPLY_INSERT

Line 352: FND_LOG.LEVEL_ERROR ); -- put PK column here

348: -- Process delete; not supported for this entity
349: CSM_UTIL_PKG.LOG
350: ( 'Delete is not supported for this entity'|| 'for PK '||p_record.requirement_line_id,
351: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',
352: FND_LOG.LEVEL_ERROR ); -- put PK column here
353:
354:
355: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
356: (

Line 369: FND_LOG.LEVEL_ERROR ); -- put PK column here

365:
366: CSM_UTIL_PKG.LOG
367: ( 'Invalid DML type: ' || p_record.dmltype$$|| 'for PK '||p_record.requirement_line_id,
368: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',
369: FND_LOG.LEVEL_ERROR ); -- put PK column here
370:
371: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
372: (
373: p_message => 'CSM_DML_OPERATION'

Line 384: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

380:
381: CSM_UTIL_PKG.LOG
382: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id,
383: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',
384: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
385:
386: EXCEPTION WHEN OTHERS THEN
387: /*** defer record when any process exception occurs ***/
388: CSM_UTIL_PKG.LOG

Line 391: FND_LOG.LEVEL_EXCEPTION); -- put PK column here

387: /*** defer record when any process exception occurs ***/
388: CSM_UTIL_PKG.LOG
389: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
390: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',
391: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
392:
393:
394: fnd_msg_pub.Add_Exc_Msg( 'CSM_REQUIREMENTS_PKG', 'APPLY_RECORD', sqlerrm);
395: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 437: FND_LOG.LEVEL_STATEMENT); -- put PK column here

433:
434: CSM_UTIL_PKG.LOG
435: ( 'Entering CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
436: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
437: FND_LOG.LEVEL_STATEMENT); -- put PK column here
438:
439:
440: -- Loop through this cursor to delete all requirement headers from the requirement header inqueue
441: FOR r_get_req_headers_from_inq IN c_get_req_headers_from_inq ( p_user_name, p_tranid) LOOP

Line 463: FND_LOG.LEVEL_PROCEDURE); -- put PK column here

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,
462: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
463: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
464:
465: ROLLBACK TO save_rec;
466: END IF;
467:

Line 474: FND_LOG.LEVEL_PROCEDURE); -- put PK column here

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,
473: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
474: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
475:
476:
477: CSM_UTIL_PKG.DEFER_RECORD
478: (

Line 497: FND_LOG.LEVEL_PROCEDURE); -- put PK column here

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,
496: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
497: FND_LOG.LEVEL_PROCEDURE); -- put PK column here
498:
499: ROLLBACK TO save_rec;
500: END IF;
501: END IF;

Line 507: FND_LOG.LEVEL_STATEMENT); -- put PK column here

503:
504: CSM_UTIL_PKG.LOG
505: ( 'Leaving CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ ',
506: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
507: FND_LOG.LEVEL_STATEMENT); -- put PK column here
508:
509:
510: EXCEPTION WHEN OTHERS THEN
511: /*** catch and log exceptions ***/

Line 516: FND_LOG.LEVEL_EXCEPTION); -- put PK column here

512:
513: CSM_UTIL_PKG.LOG
514: ( 'Exception occurred in DELETE_REQ_HEADERS_FROM_INQ: '|| FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
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;

Line 540: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

536:
537: CSM_UTIL_PKG.LOG
538: ( 'Entering CSM_REQUIREMENTS_PKG.PROCESS_REQS',
539: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',
540: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
541:
542: /*** loop through c_requirements records in inqueue ***/
543: FOR r_requirements IN c_requirements ( p_user_name, p_tranid) LOOP
544: SAVEPOINT save_rec;

Line 563: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
563: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
564:
565:
566: -- Delete the requirement line from the requirement line inqueue.
567: CSM_UTIL_PKG.DELETE_RECORD

Line 585: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
585: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
586:
587: ROLLBACK TO save_rec;
588: END IF;
589: END IF;

Line 596: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
596: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
597:
598:
599: CSM_UTIL_PKG.DEFER_RECORD
600: (

Line 619: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
619: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
620:
621: ROLLBACK TO save_rec;
622: END IF;
623: END IF;

Line 632: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

628:
629: CSM_UTIL_PKG.LOG
630: ( 'Leaving CSM_REQUIREMENTS_PKG.PROCESS_REQS',
631: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',
632: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
633:
634:
635: EXCEPTION WHEN OTHERS THEN
636: /*** catch and log exceptions ***/

Line 640: FND_LOG.LEVEL_EXCEPTION ); -- put PK column here

636: /*** catch and log exceptions ***/
637: CSM_UTIL_PKG.LOG
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:

Line 663: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

659:
660: CSM_UTIL_PKG.LOG
661: ( 'Entering CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',
662: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',
663: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
664:
665: /*** loop through c_requirements_no_headers records in inqueue ***/
666: FOR r_requirements IN c_requirements_no_headers ( p_user_name, p_tranid) LOOP
667:

Line 687: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
687: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
688:
689:
690: CSM_UTIL_PKG.DELETE_RECORD
691: (

Line 708: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
708: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
709:
710: ROLLBACK TO save_rec;
711: END IF;
712: END IF;

Line 720: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

716:
717: CSM_UTIL_PKG.LOG
718: ( 'Record not processed successfully, deferring and rejecting record'|| ' for PK ' ||r_requirements.requirement_line_id,
719: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',
720: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
721:
722: CSM_UTIL_PKG.DEFER_RECORD
723: (
724: p_user_name

Line 741: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here

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',
741: FND_LOG.LEVEL_PROCEDURE ); -- put PK column here
742:
743: ROLLBACK TO save_rec;
744: END IF;
745: END IF;

Line 751: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

747:
748: CSM_UTIL_PKG.LOG
749: ( 'Leaving CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',
750: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',
751: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
752:
753:
754: EXCEPTION WHEN OTHERS THEN
755: /*** catch and log exceptions ***/

Line 760: FND_LOG.LEVEL_EXCEPTION ); -- put PK column here

756:
757: CSM_UTIL_PKG.LOG
758: ( 'Exception occurred in APPLY_CLIENT_CHANGES:'|| FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
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:

Line 790: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

786:
787: CSM_UTIL_PKG.LOG
788: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES',
789: 'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',
790: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
791:
792: -- First process all requirement lines that have a requirement header. Delete them after processing.
793: PROCESS_REQS (p_user_name, p_tranid, x_return_status);
794:

Line 801: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

797:
798: CSM_UTIL_PKG.LOG
799: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES',
800: 'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',
801: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
802:
803: END APPLY_CLIENT_CHANGES;
804:
805: