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 107: FND_LOG.LEVEL_STATEMENT );

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:
111: IF p_get_inqueue_header THEN

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 254: FND_LOG.LEVEL_STATEMENT );

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
258:

Line 262: FND_LOG.LEVEL_EXCEPTION );

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;
266:

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 351: FND_LOG.LEVEL_PROCEDURE);

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

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 379: FND_LOG.LEVEL_STATEMENT);

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

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 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 570: FND_LOG.LEVEL_STATEMENT );

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 );
574: FOR rec IN c_headers_from_inq(p_user_name, p_tranid)

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 589: FND_LOG.LEVEL_STATEMENT );

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:
593: END;