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.12020000.2 2013/04/09 11:05:43 saradhak ship $*/
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: CURSOR c_requirement_lines ( b_user_name VARCHAR2, b_tranid NUMBER, b_req_hdr_id NUMBER) is

Line 105: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_INSERT for PK '||p_req_hid,

101: l_app_id NUMBER;
102: BEGIN
103:
104: CSM_UTIL_PKG.LOG
105: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_INSERT for PK '||p_req_hid,
106: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
107: FND_LOG.LEVEL_STATEMENT );
108:
109: SAVEPOINT save_rec2;

Line 106: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',

102: BEGIN
103:
104: CSM_UTIL_PKG.LOG
105: ( 'Entering CSM_REQUIREMENTS_PKG.APPLY_INSERT for PK '||p_req_hid,
106: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
107: FND_LOG.LEVEL_STATEMENT );
108:
109: SAVEPOINT save_rec2;
110:

Line 199: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_STATEMENT );

195: END IF;
196:
197: CSM_UTIL_PKG.LOG
198: ( 'REQ HEADER ' ||p_req_hid ||' is to be processed with '||p_line_table.COUNT||' req line records',
199: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_STATEMENT );
200:
201: IF NOT is_html5 THEN
202: l_create_order:='Y';
203: END IF;

Line 219: , 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_PROCEDURE );

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');
221: l_return_status := FND_API.G_RET_STS_ERROR;
222:
223: ELSIF is_html5 THEN

Line 243: , 'CSM_REQUIREMENTS_PKG.APPLY_INSERT', FND_LOG.LEVEL_PROCEDURE );

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;
246: ROLLBACK TO save_rec2; --all req lines deferred
247: END IF;

Line 252: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_INSERT for req_header_id: '||p_req_hid,

248: END IF;
249:
250: X_RETURN_STATUS := l_return_status;
251: CSM_UTIL_PKG.LOG
252: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_INSERT for req_header_id: '||p_req_hid,
253: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
254: FND_LOG.LEVEL_STATEMENT );
255:
256:

Line 253: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',

249:
250: X_RETURN_STATUS := l_return_status;
251: CSM_UTIL_PKG.LOG
252: ( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_INSERT for req_header_id: '||p_req_hid,
253: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',
254: FND_LOG.LEVEL_STATEMENT );
255:
256:
257: EXCEPTION WHEN OTHERS THEN

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

256:
257: EXCEPTION WHEN OTHERS THEN
258:
259: CSM_UTIL_PKG.LOG
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;

Line 261: 'CSM_REQUIREMENTS_PKG.APPLY_INSERT',

257: EXCEPTION WHEN OTHERS THEN
258:
259: CSM_UTIL_PKG.LOG
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;

Line 314: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', FND_LOG.LEVEL_STATEMENT);

310: AND SEQUENCE=h.seqno$$);
311:
312: BEGIN
313:
314: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', FND_LOG.LEVEL_STATEMENT);
315:
316: SAVEPOINT save_rec1;
317: -- Loop through this cursor to delete all requirement headers from the requirement header inqueue
318: FOR r_get_req_headers_from_inq IN c_get_req_headers_processed ( p_user_name, p_tranid) LOOP

Line 339: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',FND_LOG.LEVEL_PROCEDURE);

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,
339: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',FND_LOG.LEVEL_PROCEDURE);
340:
341: ROLLBACK TO save_rec1;
342: END IF;
343: END LOOP;

Line 350: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

346: FOR r_get_req_headers_from_inq IN c_get_req_headers_deferred ( p_user_name, p_tranid)
347: LOOP
348: CSM_UTIL_PKG.LOG
349: ( 'Record not processed successfully, deferring and rejecting record'|| 'for PK '||r_get_req_headers_from_inq.requirement_header_id,
350: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
351: FND_LOG.LEVEL_PROCEDURE);
352:
353:
354: CSM_UTIL_PKG.DEFER_RECORD

Line 372: ||r_get_req_headers_from_inq.requirement_header_id,'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', FND_LOG.LEVEL_PROCEDURE);

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);
373:
374: ROLLBACK TO save_rec1;
375: END IF;
376: END LOOP;

Line 378: CSM_UTIL_PKG.LOG( 'Leaving CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ ','CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',

374: ROLLBACK TO save_rec1;
375: END IF;
376: END LOOP;
377:
378: CSM_UTIL_PKG.LOG( 'Leaving CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ ','CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ',
379: FND_LOG.LEVEL_STATEMENT);
380:
381:
382: EXCEPTION WHEN OTHERS THEN

Line 386: 'CSM_REQUIREMENTS_PKG.DELETE_REQ_HEADERS_FROM_INQ', FND_LOG.LEVEL_EXCEPTION);

382: EXCEPTION WHEN OTHERS THEN
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: /***

Line 414: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.APPLY_RECORD for PK req_header_id: '||p_req_hid,

410: l_line_num NUMBER:=1;
411:
412: BEGIN
413:
414: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.APPLY_RECORD for PK req_header_id: '||p_req_hid,
415: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_STATEMENT );
416:
417: SAVEPOINT save_rec;
418:

Line 415: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_STATEMENT );

411:
412: BEGIN
413:
414: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.APPLY_RECORD for PK req_header_id: '||p_req_hid,
415: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_STATEMENT );
416:
417: SAVEPOINT save_rec;
418:
419: /*** loop through c_requirements records in inqueue ***/

Line 482: CSM_UTIL_PKG.LOG( 'Record successfully processed, deleting from inqueue req line id :' || r_requirements.requirement_line_id,'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_PROCEDURE );

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 ***/
482: CSM_UTIL_PKG.LOG( 'Record successfully processed, deleting from inqueue req line id :' || r_requirements.requirement_line_id,'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_PROCEDURE );
483:
484:
485: -- Delete the requirement line from the requirement line inqueue.
486: CSM_UTIL_PKG.DELETE_RECORD

Line 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 );

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;
504: END IF;
505: END LOOP;

Line 511: ( 'Record not processed successfully, deferring and rejecting record for req_line_id:' || r_requirements.requirement_line_id,'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_PROCEDURE );

507: FOR r_requirements IN c_requirement_lines ( p_user_name, p_tranid,p_req_hid)
508: LOOP
509: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
510: CSM_UTIL_PKG.LOG
511: ( 'Record not processed successfully, deferring and rejecting record for req_line_id:' || r_requirements.requirement_line_id,'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_PROCEDURE );
512:
513:
514: CSM_UTIL_PKG.DEFER_RECORD
515: (

Line 532: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD', FND_LOG.LEVEL_PROCEDURE );

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:
534: ROLLBACK TO save_rec;
535: END IF;
536: END LOOP;

Line 539: CSM_UTIL_PKG.LOG( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_RECORD','CSM_REQUIREMENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_STATEMENT );

535: END IF;
536: END LOOP;
537: END IF;
538:
539: CSM_UTIL_PKG.LOG( 'Leaving CSM_REQUIREMENTS_PKG.APPLY_RECORD','CSM_REQUIREMENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_STATEMENT );
540:
541:
542: EXCEPTION WHEN OTHERS THEN
543: /*** catch and log exceptions ***/

Line 545: 'CSM_REQUIREMENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );

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

Line 569: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES','CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',

565: l_error_msg VARCHAR2(4000);
566:
567: BEGIN
568:
569: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES','CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',
570: FND_LOG.LEVEL_STATEMENT );
571:
572: -- First process all requirement lines that have a requirement header. Delete them after processing.
573: CSM_UTIL_PKG.LOG( 'Processing req headers from inq','CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_STATEMENT );

Line 573: CSM_UTIL_PKG.LOG( 'Processing req headers from inq','CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_STATEMENT );

569: CSM_UTIL_PKG.LOG( 'Entering CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES','CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',
570: FND_LOG.LEVEL_STATEMENT );
571:
572: -- First process all requirement lines that have a requirement header. Delete them after processing.
573: CSM_UTIL_PKG.LOG( 'Processing req headers from inq','CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_STATEMENT );
574: FOR rec IN c_headers_from_inq(p_user_name, p_tranid)
575: LOOP
576: APPLY_RECORD (p_user_name, p_tranid, true,rec.requirement_header_id,x_return_status);
577: END LOOP;

Line 581: ,'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_STATEMENT );

577: END LOOP;
578: DELETE_REQ_HEADERS_FROM_INQ(p_user_name, p_tranid, l_process_status);
579:
580: CSM_UTIL_PKG.LOG( 'Processing req headers from apps and not in inq'
581: ,'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_STATEMENT );
582:
583: FOR rec IN c_headers_from_apps(p_user_name, p_tranid)
584: LOOP
585: APPLY_RECORD (p_user_name, p_tranid, false,rec.requirement_header_id,x_return_status);

Line 588: CSM_UTIL_PKG.LOG( 'Leaving CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES', 'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',

584: LOOP
585: APPLY_RECORD (p_user_name, p_tranid, false,rec.requirement_header_id,x_return_status);
586: END LOOP;
587:
588: CSM_UTIL_PKG.LOG( 'Leaving CSM_REQUIREMENTS_PKG.APPLY CLIENT CHANGES', 'CSM_REQUIREMENTS_PKG.APPLY_CLIENT_CHANGES',
589: FND_LOG.LEVEL_STATEMENT );
590:
591: END APPLY_CLIENT_CHANGES;
592: