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 CSM_REQUIREMENTS_PKG

Line 1: PACKAGE BODY CSM_REQUIREMENTS_PKG AS

1: PACKAGE BODY CSM_REQUIREMENTS_PKG AS
2: /* $Header: csmureqb.pls 120.4 2006/08/11 12:25:18 utekumal noship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 15: g_object_name CONSTANT VARCHAR2(30) := 'CSM_REQUIREMENTS_PKG'; -- package name

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: /*** Globals ***/
15: g_object_name CONSTANT VARCHAR2(30) := 'CSM_REQUIREMENTS_PKG'; -- package name
16: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES'; -- publication item name
17: g_pub_name2 CONSTANT VARCHAR2(30) := 'CSM_REQ_HEADERS'; -- publication item name
18:
19: /***

Line 98: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_INSERT'|| 'for PK '||p_record.requirement_line_id,

94:
95: BEGIN
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:

Line 99: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',

95: BEGIN
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

Line 230: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_INSERT'|| 'for PK '||p_record.requirement_line_id,

226: );
227: END IF;
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:

Line 231: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',

227: END IF;
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

Line 238: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_INSERT'|| 'for PK '||p_record.requirement_line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,

234:
235: EXCEPTION WHEN OTHERS THEN
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);

Line 239: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',

235: EXCEPTION WHEN OTHERS THEN
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:

Line 242: fnd_msg_pub.Add_Exc_Msg( 'CSM_REQUIREMENTS_PKG', 'APPLY_INSERT', sqlerrm);

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
245: (
246: p_api_error => TRUE

Line 264: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.requirement_line_id ,

260: ) IS
261: BEGIN
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

Line 265: 'CSM_REQUIREMENTS_PKG.APPLY_UPDATE',

261: BEGIN
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;

Line 280: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.requirement_line_id ,

276: );
277: END IF;
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:

Line 281: 'CSM_REQUIREMENTS_PKG.APPLY_UPDATE',

277: END IF;
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

Line 288: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.requirement_line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,

284:
285: EXCEPTION WHEN OTHERS THEN
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:

Line 289: 'CSM_REQUIREMENTS_PKG.APPLY_UPDATE',

285: EXCEPTION WHEN OTHERS THEN
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);

Line 293: fnd_msg_pub.Add_Exc_Msg( 'CSM_REQUIREMENTS_PKG', 'APPLY_UPDATE', 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
295: (
296: p_api_error => TRUE
297: );

Line 319: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id,

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',
321: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
322:
323: CSM_UTIL_PKG.LOG

Line 320: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

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',
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$$,

Line 325: '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',
326: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
327:
328: IF p_record.dmltype$$='I' THEN
329: -- Process insert

Line 351: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

347: ELSIF p_record.dmltype$$='D' THEN
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

Line 368: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

364: -- invalid dml type
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: (

Line 382: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id,

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,
383: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',
384: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
385:
386: EXCEPTION WHEN OTHERS THEN

Line 383: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

379: END IF;
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 ***/

Line 389: ( 'Exception occurred in CSM_REQUIREMENTS_PKG.APPLY_RECORD'|| 'for PK '||p_record.requirement_line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,

385:
386: EXCEPTION WHEN OTHERS THEN
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:

Line 390: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',

386: EXCEPTION WHEN OTHERS THEN
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);

Line 394: fnd_msg_pub.Add_Exc_Msg( 'CSM_REQUIREMENTS_PKG', 'APPLY_RECORD', 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
396: (
397: p_api_error => TRUE
398: );

Line 435: ( 'Entering CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

431:
432: BEGIN
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:

Line 436: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

432: BEGIN
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

Line 462: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

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,
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;

Line 473: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

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,
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

Line 496: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

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,
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;

Line 505: ( 'Leaving CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ ',

501: END IF;
502: END LOOP;
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:

Line 506: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

502: END LOOP;
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

Line 515: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

511: /*** catch and log exceptions ***/
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;

Line 538: ( 'Entering CSM_REQUIREMENTS_PKG.PROCESS_REQS',

534:
535: BEGIN
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 ***/

Line 539: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

535: BEGIN
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

Line 562: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

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

Line 584: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

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

Line 595: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

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

Line 618: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

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

Line 630: ( 'Leaving CSM_REQUIREMENTS_PKG.PROCESS_REQS',

626: -- Call delete procedure to delete all requirement headers from requirement header inqueue.
627: DELETE_REQ_HEADERS_FROM_INQ(p_user_name, p_tranid, x_return_status);
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:

Line 631: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

627: DELETE_REQ_HEADERS_FROM_INQ(p_user_name, p_tranid, x_return_status);
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

Line 639: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS',

635: EXCEPTION WHEN OTHERS THEN
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;

Line 661: ( 'Entering CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

657:
658: BEGIN
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 ***/

Line 662: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

658: BEGIN
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

Line 686: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

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

Line 707: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

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

Line 719: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

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,
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: (

Line 740: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

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

Line 749: ( 'Leaving CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

745: END IF;
746: END LOOP;
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:

Line 750: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

746: END LOOP;
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

Line 759: 'CSM_REQUIREMENTS_PKG.PROCESS_REQS_NO_HEADERS',

755: /*** catch and log exceptions ***/
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;

Line 788: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES',

784:
785: BEGIN
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.

Line 789: 'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',

785: BEGIN
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);

Line 799: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES',

795: -- Then process all remaining requirement lines (no requirement header). These already have a requirement header in Apps.
796: PROCESS_REQS_NO_HEADERS(p_user_name, p_tranid, x_return_status);
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;

Line 800: 'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',

796: PROCESS_REQS_NO_HEADERS(p_user_name, p_tranid, x_return_status);
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: