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.AHL_VWP_MR_CST_PR_PVT dependencies on FND_LOG

Line 38: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

34: )
35: as
36: l_api_name varchar2(10);
37: begin
38: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
39: fnd_log.string
40: (
41: fnd_log.level_statement,
42: G_MODULE_NAME||p_api_name,

Line 39: fnd_log.string

35: as
36: l_api_name varchar2(10);
37: begin
38: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
39: fnd_log.string
40: (
41: fnd_log.level_statement,
42: G_MODULE_NAME||p_api_name,
43: p_message_text

Line 41: fnd_log.level_statement,

37: begin
38: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
39: fnd_log.string
40: (
41: fnd_log.level_statement,
42: G_MODULE_NAME||p_api_name,
43: p_message_text
44: );
45: END IF;

Line 268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

264:
265: l_cost_price_rec:= p_x_cost_price_rec;
266:
267:
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
269: THEN
270: FND_LOG.STRING
271: (
272: FND_LOG.LEVEL_PROCEDURE,

Line 270: FND_LOG.STRING

266:
267:
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
269: THEN
270: FND_LOG.STRING
271: (
272: FND_LOG.LEVEL_PROCEDURE,
273: G_MODULE_NAME||l_api_name,
274: 'START OF '||L_API_NAME

Line 272: FND_LOG.LEVEL_PROCEDURE,

268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
269: THEN
270: FND_LOG.STRING
271: (
272: FND_LOG.LEVEL_PROCEDURE,
273: G_MODULE_NAME||l_api_name,
274: 'START OF '||L_API_NAME
275: );
276: END IF;

Line 279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

275: );
276: END IF;
277:
278:
279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
280:
281: fnd_log.string
282:
283: (

Line 281: fnd_log.string

277:
278:
279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
280:
281: fnd_log.string
282:
283: (
284:
285: fnd_log.level_statement,

Line 285: fnd_log.level_statement,

281: fnd_log.string
282:
283: (
284:
285: fnd_log.level_statement,
286:
287: 'ahl.plsql.AHL_VWP_MR_CST_PR_PVT.estimate_MR_cost',
288:
289: 'Got request for estimating cost of Visit Task ID : ' || p_x_cost_price_rec.visit_task_id

Line 293: fnd_log.string

289: 'Got request for estimating cost of Visit Task ID : ' || p_x_cost_price_rec.visit_task_id
290:
291: );
292:
293: fnd_log.string
294:
295: (
296:
297: fnd_log.level_statement,

Line 297: fnd_log.level_statement,

293: fnd_log.string
294:
295: (
296:
297: fnd_log.level_statement,
298:
299: 'ahl.plsql.AHL_VWP_MR_CST_PR_PVT.estimate_MR_cost',
300:
301: 'input mr session id : ' || p_x_cost_price_rec.mr_session_id

Line 305: fnd_log.string

301: 'input mr session id : ' || p_x_cost_price_rec.mr_session_id
302:
303: );
304:
305: fnd_log.string
306:
307: (
308:
309: fnd_log.level_statement,

Line 309: fnd_log.level_statement,

305: fnd_log.string
306:
307: (
308:
309: fnd_log.level_statement,
310:
311: 'ahl.plsql.AHL_VWP_MR_CST_PR_PVT.estimate_MR_cost',
312:
313: 'input cost session id : ' || p_x_cost_price_rec.cost_session_id

Line 352: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

348:
349: -- Release visit if required
350: IF l_release_visit_required ='Y' THEN
351:
352: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
353: fnd_log.string
354: (
355: fnd_log.level_procedure,
356: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 353: fnd_log.string

349: -- Release visit if required
350: IF l_release_visit_required ='Y' THEN
351:
352: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
353: fnd_log.string
354: (
355: fnd_log.level_procedure,
356: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
357: 'Before calling ahl vwp proj prod pvt.release visit'

Line 355: fnd_log.level_procedure,

351:
352: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
353: fnd_log.string
354: (
355: fnd_log.level_procedure,
356: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
357: 'Before calling ahl vwp proj prod pvt.release visit'
358: );
359:

Line 373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

369: x_return_status => l_return_status,
370: x_msg_count => l_msg_count,
371: x_msg_data => l_msg_data);
372:
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.string
375: (
376: fnd_log.level_procedure,
377: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',

Line 374: fnd_log.string

370: x_msg_count => l_msg_count,
371: x_msg_data => l_msg_data);
372:
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.string
375: (
376: fnd_log.level_procedure,
377: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
378: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status

Line 376: fnd_log.level_procedure,

372:
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.string
375: (
376: fnd_log.level_procedure,
377: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
378: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status
379: );
380: END IF;

Line 394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

390: END IF; -- released required flag
391:
392: END IF; --- p_module type = 'JSP'
393:
394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
395: fnd_log.string
396: (
397: fnd_log.level_statement, G_MODULE_NAME||l_api_name,
398: 'Before Call to AHL_VWP_COST_PVT.estimate_wo_cost'

Line 395: fnd_log.string

391:
392: END IF; --- p_module type = 'JSP'
393:
394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
395: fnd_log.string
396: (
397: fnd_log.level_statement, G_MODULE_NAME||l_api_name,
398: 'Before Call to AHL_VWP_COST_PVT.estimate_wo_cost'
399: );

Line 397: fnd_log.level_statement, G_MODULE_NAME||l_api_name,

393:
394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
395: fnd_log.string
396: (
397: fnd_log.level_statement, G_MODULE_NAME||l_api_name,
398: 'Before Call to AHL_VWP_COST_PVT.estimate_wo_cost'
399: );
400: END IF;
401:

Line 424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

420: p_x_cost_price_rec.cost_session_id := l_cost_price_rec.cost_session_id;
421:
422: p_x_cost_price_rec.mr_session_id := l_cost_price_rec.mr_session_id;
423:
424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
425: THEN
426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
427: G_MODULE_NAME||l_api_name,
428: 'At the start of the procedure');

Line 426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

422: p_x_cost_price_rec.mr_session_id := l_cost_price_rec.mr_session_id;
423:
424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
425: THEN
426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
427: G_MODULE_NAME||l_api_name,
428: 'At the start of the procedure');
429: END IF;
430:

Line 595: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

591:
592: -- for task derivation
593: BEGIN
594:
595: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
597: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
598: 'At the start of the procedure');
599: END IF;

Line 596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

592: -- for task derivation
593: BEGIN
594:
595: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
597: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
598: 'At the start of the procedure');
599: END IF;
600:

Line 613: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

609: -- Initialize API return status to success
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:
612:
613: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
615: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
616: 'Request for Estimating Price for Task ID: '||l_cost_price_rec.visit_task_id);
617: END IF;

Line 614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:
612:
613: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
615: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
616: 'Request for Estimating Price for Task ID: '||l_cost_price_rec.visit_task_id);
617: END IF;
618:

Line 619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

615: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
616: 'Request for Estimating Price for Task ID: '||l_cost_price_rec.visit_task_id);
617: END IF;
618:
619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
621: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
622: 'Request for Estimating Price for Currency Code: '||l_cost_price_rec.currency);
623: END IF;

Line 620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

616: 'Request for Estimating Price for Task ID: '||l_cost_price_rec.visit_task_id);
617: END IF;
618:
619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
621: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
622: 'Request for Estimating Price for Currency Code: '||l_cost_price_rec.currency);
623: END IF;
624:

Line 633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

629: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_INPUT_MISS');
630: FND_MSG_PUB.ADD;
631:
632:
633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
635: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
636: 'Visit Task id is mandatory but found null in input ');
637: END IF;

Line 634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

630: FND_MSG_PUB.ADD;
631:
632:
633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
635: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
636: 'Visit Task id is mandatory but found null in input ');
637: END IF;
638: RAISE FND_API.G_EXC_ERROR;

Line 650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

646: IF c_task_csr%NOTFOUND THEN
647: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );
648: FND_MSG_PUB.add;
649:
650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
653: ' Visit Task not found in ahl_visit_tasks_b table ');
654: END IF;

Line 651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

647: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );
648: FND_MSG_PUB.add;
649:
650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
653: ' Visit Task not found in ahl_visit_tasks_b table ');
654: END IF;
655:

Line 663: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

659: CLOSE c_task_csr;
660:
661: -- Retrieve visit info
662:
663: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
665: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
666: 'After Task Rec ');
667: END IF;

Line 664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

660:
661: -- Retrieve visit info
662:
663: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
665: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
666: 'After Task Rec ');
667: END IF;
668:

Line 674: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

670: fetch c_visit_csr into l_visit_rec;
671: close c_visit_csr;
672:
673:
674: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
676: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
677: 'After Visit Rec ');
678:

Line 675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

671: close c_visit_csr;
672:
673:
674: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
676: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
677: 'After Visit Rec ');
678:
679: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 679: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
676: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
677: 'After Visit Rec ');
678:
679: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
680: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
681: 'p_module_type: '||p_module_type);
682: END IF;
683:

Line 688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

684: -- Need to release the visit only if this API is called from front-end direcly
685:
686: IF p_module_type = 'JSP' THEN
687:
688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
690: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
691: 'Before calling ahl vwp task cost.Estimate Task Cost');
692: END IF;

Line 689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

685:
686: IF p_module_type = 'JSP' THEN
687:
688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
689: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
690: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
691: 'Before calling ahl vwp task cost.Estimate Task Cost');
692: END IF;
693:

Line 707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

703: x_msg_count => l_msg_count,
704: x_msg_data => l_msg_data);
705:
706:
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
709: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
710: 'After calling ahl vwp task cost pvt.Estimate Task cost Return Status : '|| l_return_status
711: );

Line 708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

704: x_msg_data => l_msg_data);
705:
706:
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
709: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
710: 'After calling ahl vwp task cost pvt.Estimate Task cost Return Status : '|| l_return_status
711: );
712: END IF;

Line 733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

729: END IF; --Module type JSP
730:
731: --- Check job status
732:
733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
735: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
736: 'before check job status');
737: END IF;

Line 734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

730:
731: --- Check job status
732:
733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
735: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
736: 'before check job status');
737: END IF;
738:

Line 782: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

778: IF l_cost_price_rec.currency IS NULL THEN
779: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
780: FND_MSG_PUB.ADD;
781:
782: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
783: fnd_log.string(
784: fnd_log.level_error,
785: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
786: 'No curency is defined for the organization of the visit'

Line 783: fnd_log.string(

779: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
780: FND_MSG_PUB.ADD;
781:
782: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
783: fnd_log.string(
784: fnd_log.level_error,
785: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
786: 'No curency is defined for the organization of the visit'
787: );

Line 784: fnd_log.level_error,

780: FND_MSG_PUB.ADD;
781:
782: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
783: fnd_log.string(
784: fnd_log.level_error,
785: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
786: 'No curency is defined for the organization of the visit'
787: );
788: END IF;

Line 799: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

795: IF (l_visit_rec.price_list_id IS NULL OR
796: l_visit_rec.price_list_id = FND_API.G_MISS_NUM ) THEN
797: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
798: FND_MSG_PUB.add;
799: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
800: fnd_log.string
801: (
802: fnd_log.level_error,
803: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 800: fnd_log.string

796: l_visit_rec.price_list_id = FND_API.G_MISS_NUM ) THEN
797: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
798: FND_MSG_PUB.add;
799: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
800: fnd_log.string
801: (
802: fnd_log.level_error,
803: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
804: 'Price list not found for Visit'

Line 802: fnd_log.level_error,

798: FND_MSG_PUB.add;
799: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
800: fnd_log.string
801: (
802: fnd_log.level_error,
803: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
804: 'Price list not found for Visit'
805: );
806: END IF;

Line 814: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

810: l_cost_price_rec.PRICE_LIST_ID:=l_visit_rec.price_list_id;
811: l_cost_price_rec.Organization_Id:=l_visit_rec.organization_id;
812:
813:
814: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
815:
816: fnd_log.string
817: (
818: fnd_log.level_statement,

Line 816: fnd_log.string

812:
813:
814: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
815:
816: fnd_log.string
817: (
818: fnd_log.level_statement,
819: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
820: 'Customer Id : ' || l_cost_price_rec.customer_id

Line 818: fnd_log.level_statement,

814: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
815:
816: fnd_log.string
817: (
818: fnd_log.level_statement,
819: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
820: 'Customer Id : ' || l_cost_price_rec.customer_id
821: );
822:

Line 823: fnd_log.string

819: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
820: 'Customer Id : ' || l_cost_price_rec.customer_id
821: );
822:
823: fnd_log.string
824: (
825: fnd_log.level_statement,
826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
827: 'Visit Id : ' || l_task_rec.visit_id

Line 825: fnd_log.level_statement,

821: );
822:
823: fnd_log.string
824: (
825: fnd_log.level_statement,
826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
827: 'Visit Id : ' || l_task_rec.visit_id
828: );
829:

Line 830: fnd_log.string

826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
827: 'Visit Id : ' || l_task_rec.visit_id
828: );
829:
830: fnd_log.string
831: (
832: fnd_log.level_statement,
833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
834: 'Currency : ' || l_cost_price_rec.currency

Line 832: fnd_log.level_statement,

828: );
829:
830: fnd_log.string
831: (
832: fnd_log.level_statement,
833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
834: 'Currency : ' || l_cost_price_rec.currency
835: );
836:

Line 837: fnd_log.string

833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
834: 'Currency : ' || l_cost_price_rec.currency
835: );
836:
837: fnd_log.string
838: (
839: fnd_log.level_statement,
840: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
841: 'Price List Id : ' || l_cost_price_rec.PRICE_LIST_ID

Line 839: fnd_log.level_statement,

835: );
836:
837: fnd_log.string
838: (
839: fnd_log.level_statement,
840: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
841: 'Price List Id : ' || l_cost_price_rec.PRICE_LIST_ID
842: );
843:

Line 844: fnd_log.string

840: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
841: 'Price List Id : ' || l_cost_price_rec.PRICE_LIST_ID
842: );
843:
844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
848: 'Organization ID : ' || l_cost_price_rec.Organization_Id

Line 846: fnd_log.level_statement,

842: );
843:
844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
848: 'Organization ID : ' || l_cost_price_rec.Organization_Id
849: );
850:

Line 851: fnd_log.string

847: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
848: 'Organization ID : ' || l_cost_price_rec.Organization_Id
849: );
850:
851: fnd_log.string
852: (
853: fnd_log.level_statement,
854: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
855: 'MR ID : ' || l_task_rec.mr_id

Line 853: fnd_log.level_statement,

849: );
850:
851: fnd_log.string
852: (
853: fnd_log.level_statement,
854: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
855: 'MR ID : ' || l_task_rec.mr_id
856: );
857:

Line 858: fnd_log.string

854: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
855: 'MR ID : ' || l_task_rec.mr_id
856: );
857:
858: fnd_log.string
859: (
860: fnd_log.level_statement,
861: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
862: 'Task Start Time : ' || l_task_rec.START_DATE_TIME

Line 860: fnd_log.level_statement,

856: );
857:
858: fnd_log.string
859: (
860: fnd_log.level_statement,
861: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
862: 'Task Start Time : ' || l_task_rec.START_DATE_TIME
863: );
864:

Line 876: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

872:
873: if c_mr_csr%found
874: then -- billing item is associated to MR
875:
876: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
877: fnd_log.string
878: (fnd_log.level_statement,
879: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
880: 'billing item found' );

Line 877: fnd_log.string

873: if c_mr_csr%found
874: then -- billing item is associated to MR
875:
876: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
877: fnd_log.string
878: (fnd_log.level_statement,
879: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
880: 'billing item found' );
881: END IF;

Line 878: (fnd_log.level_statement,

874: then -- billing item is associated to MR
875:
876: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
877: fnd_log.string
878: (fnd_log.level_statement,
879: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
880: 'billing item found' );
881: END IF;
882:

Line 933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

929: --- If no billing item is associated then calculate price for all the immediate childen
930:
931: Else
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
934: fnd_log.string(
935: fnd_log.level_statement,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
937: 'Billing Item not found');

Line 934: fnd_log.string(

930:
931: Else
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
934: fnd_log.string(
935: fnd_log.level_statement,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
937: 'Billing Item not found');
938:

Line 935: fnd_log.level_statement,

931: Else
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
934: fnd_log.string(
935: fnd_log.level_statement,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
937: 'Billing Item not found');
938:
939:

Line 972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

968: fetch c_all_task_csr into l_all_task_rec;
969: exit when c_all_task_csr%notfound;
970:
971:
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
973: fnd_log.string
974: (
975: fnd_log.level_statement,
976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 973: fnd_log.string

969: exit when c_all_task_csr%notfound;
970:
971:
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
973: fnd_log.string
974: (
975: fnd_log.level_statement,
976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
977: 'Task ID: ' || l_all_task_rec.visit_task_id

Line 975: fnd_log.level_statement,

971:
972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
973: fnd_log.string
974: (
975: fnd_log.level_statement,
976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
977: 'Task ID: ' || l_all_task_rec.visit_task_id
978: );
979:

Line 981: fnd_log.string

977: 'Task ID: ' || l_all_task_rec.visit_task_id
978: );
979:
980:
981: fnd_log.string
982: (
983: fnd_log.level_statement,
984: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
985: 'Task Type Code: ' || l_all_task_rec.task_type_code

Line 983: fnd_log.level_statement,

979:
980:
981: fnd_log.string
982: (
983: fnd_log.level_statement,
984: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
985: 'Task Type Code: ' || l_all_task_rec.task_type_code
986: );
987:

Line 989: fnd_log.string

985: 'Task Type Code: ' || l_all_task_rec.task_type_code
986: );
987:
988:
989: fnd_log.string
990: (
991: fnd_log.level_statement,
992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
993: 'Task MR ID: ' || l_all_task_rec.MR_ID

Line 991: fnd_log.level_statement,

987:
988:
989: fnd_log.string
990: (
991: fnd_log.level_statement,
992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
993: 'Task MR ID: ' || l_all_task_rec.MR_ID
994: );
995:

Line 1002: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

998: l_temp_cost_price_rec.visit_task_id := l_all_task_rec.visit_task_id;
999: l_temp_cost_price_rec.Task_Start_Date := l_all_task_rec.START_DATE_TIME;
1000:
1001:
1002: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1003: fnd_log.string
1004: (
1005: fnd_log.level_statement,
1006: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1003: fnd_log.string

999: l_temp_cost_price_rec.Task_Start_Date := l_all_task_rec.START_DATE_TIME;
1000:
1001:
1002: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1003: fnd_log.string
1004: (
1005: fnd_log.level_statement,
1006: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1007: 'task_start_date : ' ||l_temp_cost_price_rec.task_start_date

Line 1005: fnd_log.level_statement,

1001:
1002: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1003: fnd_log.string
1004: (
1005: fnd_log.level_statement,
1006: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1007: 'task_start_date : ' ||l_temp_cost_price_rec.task_start_date
1008: );
1009: END IF;

Line 1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1013: then -- Child MRs
1014:
1015:
1016:
1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1018: fnd_log.string
1019: (
1020: fnd_log.level_statement,
1021: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1018: fnd_log.string

1014:
1015:
1016:
1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1018: fnd_log.string
1019: (
1020: fnd_log.level_statement,
1021: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1022: 'Before call to AHL_VWP_MR_CST_PR_PVT.estimate_mr_price'

Line 1020: fnd_log.level_statement,

1016:
1017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1018: fnd_log.string
1019: (
1020: fnd_log.level_statement,
1021: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1022: 'Before call to AHL_VWP_MR_CST_PR_PVT.estimate_mr_price'
1023: );
1024: END IF;

Line 1043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1039:
1040:
1041: else --- all other tasks
1042:
1043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1044:
1045: fnd_log.string
1046: (
1047: fnd_log.level_statement,

Line 1045: fnd_log.string

1041: else --- all other tasks
1042:
1043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1044:
1045: fnd_log.string
1046: (
1047: fnd_log.level_statement,
1048: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1049: 'Unplanned/Planned/Unassociated Tasks'

Line 1047: fnd_log.level_statement,

1043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1044:
1045: fnd_log.string
1046: (
1047: fnd_log.level_statement,
1048: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1049: 'Unplanned/Planned/Unassociated Tasks'
1050: );
1051:

Line 1055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1051:
1052: END IF;
1053:
1054:
1055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1056: fnd_log.string
1057: (
1058: fnd_log.level_statement,
1059: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1056: fnd_log.string

1052: END IF;
1053:
1054:
1055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1056: fnd_log.string
1057: (
1058: fnd_log.level_statement,
1059: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1060: 'Before call to AHL_VWP_TASK_CST_PR_PVT.estimate_task_price'

Line 1058: fnd_log.level_statement,

1054:
1055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1056: fnd_log.string
1057: (
1058: fnd_log.level_statement,
1059: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1060: 'Before call to AHL_VWP_TASK_CST_PR_PVT.estimate_task_price'
1061: );
1062: END IF;

Line 1147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1143: p_x_cost_price_rec.estimated_price:=l_cost_price_rec.estimated_price;
1144: p_x_cost_price_rec.actual_price:=l_cost_price_rec.actual_price;
1145:
1146:
1147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1148:
1149: fnd_log.string
1150: (
1151: fnd_log.level_statement,

Line 1149: fnd_log.string

1145:
1146:
1147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1148:
1149: fnd_log.string
1150: (
1151: fnd_log.level_statement,
1152: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1153: 'MR Estimated Price: ' || p_x_cost_price_rec.estimated_price

Line 1151: fnd_log.level_statement,

1147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1148:
1149: fnd_log.string
1150: (
1151: fnd_log.level_statement,
1152: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1153: 'MR Estimated Price: ' || p_x_cost_price_rec.estimated_price
1154: );
1155:

Line 1156: fnd_log.string

1152: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1153: 'MR Estimated Price: ' || p_x_cost_price_rec.estimated_price
1154: );
1155:
1156: fnd_log.string
1157: (
1158: fnd_log.level_statement,
1159: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1160: 'MR Actual Price: ' || p_x_cost_price_rec.actual_price

Line 1158: fnd_log.level_statement,

1154: );
1155:
1156: fnd_log.string
1157: (
1158: fnd_log.level_statement,
1159: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1160: 'MR Actual Price: ' || p_x_cost_price_rec.actual_price
1161: );
1162:

Line 1170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1166: IF FND_API.TO_BOOLEAN(p_commit) THEN
1167: COMMIT;
1168: END IF;
1169:
1170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1171: THEN
1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1173: G_MODULE_NAME||'.'||l_api_name,'At the end of the procedure');
1174: END IF;

Line 1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1168: END IF;
1169:
1170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1171: THEN
1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1173: G_MODULE_NAME||'.'||l_api_name,'At the end of the procedure');
1174: END IF;
1175:
1176:

Line 1407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1403:
1404:
1405: BEGIN
1406:
1407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1408: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1409: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1410: 'At the start of the procedure');
1411: END IF;

Line 1408: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1404:
1405: BEGIN
1406:
1407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1408: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1409: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1410: 'At the start of the procedure');
1411: END IF;
1412:

Line 1431: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1427: -- initialize return status
1428:
1429: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1430:
1431: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (
1434: fnd_log.level_statement,
1435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1432: fnd_log.string

1428:
1429: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1430:
1431: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (
1434: fnd_log.level_statement,
1435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1436: 'Request to get items without price for Task ID : ' || l_cost_price_rec.visit_task_id

Line 1434: fnd_log.level_statement,

1430:
1431: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (
1434: fnd_log.level_statement,
1435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1436: 'Request to get items without price for Task ID : ' || l_cost_price_rec.visit_task_id
1437: );
1438:

Line 1447: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1443: IF(l_cost_price_rec.visit_task_id IS NULL OR
1444: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1445: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
1446: FND_MSG_PUB.ADD;
1447: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1448: fnd_log.string
1449: (
1450: fnd_log.level_error,
1451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1448: fnd_log.string

1444: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1445: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
1446: FND_MSG_PUB.ADD;
1447: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1448: fnd_log.string
1449: (
1450: fnd_log.level_error,
1451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1452: 'Visit Task id is mandatory but found null in input '

Line 1450: fnd_log.level_error,

1446: FND_MSG_PUB.ADD;
1447: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1448: fnd_log.string
1449: (
1450: fnd_log.level_error,
1451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1452: 'Visit Task id is mandatory but found null in input '
1453: );
1454: END IF;

Line 1467: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1463:
1464: IF c_task_csr%NOTFOUND THEN
1465: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );
1466: FND_MSG_PUB.add;
1467: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1468: fnd_log.string
1469: (
1470: fnd_log.level_error,
1471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1468: fnd_log.string

1464: IF c_task_csr%NOTFOUND THEN
1465: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );
1466: FND_MSG_PUB.add;
1467: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1468: fnd_log.string
1469: (
1470: fnd_log.level_error,
1471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1472: 'Visit Task not found in ahl_visit_tasks_b table'

Line 1470: fnd_log.level_error,

1466: FND_MSG_PUB.add;
1467: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1468: fnd_log.string
1469: (
1470: fnd_log.level_error,
1471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1472: 'Visit Task not found in ahl_visit_tasks_b table'
1473: );
1474: END IF;

Line 1508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1504:
1505: -- Release visit if required
1506: IF l_release_visit_required ='Y' THEN
1507:
1508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string
1510: (
1511: fnd_log.level_statement,
1512: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1509: fnd_log.string

1505: -- Release visit if required
1506: IF l_release_visit_required ='Y' THEN
1507:
1508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string
1510: (
1511: fnd_log.level_statement,
1512: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1513: 'Before calling ahl vwp proj prod pvt.release visit'

Line 1511: fnd_log.level_statement,

1507:
1508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string
1510: (
1511: fnd_log.level_statement,
1512: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1513: 'Before calling ahl vwp proj prod pvt.release visit'
1514: );
1515:

Line 1531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1527: x_msg_data =>x_msg_data,
1528: p_visit_id =>l_task_rec.visit_id
1529: );
1530:
1531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1533: (
1534: fnd_log.level_statement,
1535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1532: fnd_log.string

1528: p_visit_id =>l_task_rec.visit_id
1529: );
1530:
1531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1533: (
1534: fnd_log.level_statement,
1535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1536: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status

Line 1534: fnd_log.level_statement,

1530:
1531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1533: (
1534: fnd_log.level_statement,
1535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1536: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status
1537: );
1538: END IF;

Line 1593: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1589:
1590: END IF;
1591:
1592:
1593: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1594: fnd_log.string
1595: (
1596: fnd_log.level_statement,
1597: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1594: fnd_log.string

1590: END IF;
1591:
1592:
1593: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1594: fnd_log.string
1595: (
1596: fnd_log.level_statement,
1597: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1598: 'Price List ID :' ||l_cost_price_rec.price_list_id

Line 1596: fnd_log.level_statement,

1592:
1593: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1594: fnd_log.string
1595: (
1596: fnd_log.level_statement,
1597: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1598: 'Price List ID :' ||l_cost_price_rec.price_list_id
1599: );
1600: END IF;

Line 1606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1602:
1603: l_cost_price_rec.organization_id:=l_visit_rec.organization_id;
1604:
1605:
1606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1607: fnd_log.string
1608: (
1609: fnd_log.level_statement,
1610: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1607: fnd_log.string

1603: l_cost_price_rec.organization_id:=l_visit_rec.organization_id;
1604:
1605:
1606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1607: fnd_log.string
1608: (
1609: fnd_log.level_statement,
1610: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1611: 'Organization ID :' ||l_cost_price_rec.organization_id

Line 1609: fnd_log.level_statement,

1605:
1606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1607: fnd_log.string
1608: (
1609: fnd_log.level_statement,
1610: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1611: 'Organization ID :' ||l_cost_price_rec.organization_id
1612: );
1613: END IF;

Line 1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1620: fetch c_customer_csr into l_cost_price_rec.customer_id;
1621: close c_customer_csr;
1622: END IF;
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string
1626: (
1627: fnd_log.level_statement,
1628: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1625: fnd_log.string

1621: close c_customer_csr;
1622: END IF;
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string
1626: (
1627: fnd_log.level_statement,
1628: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1629: 'Customer ID :' ||l_cost_price_rec.customer_id

Line 1627: fnd_log.level_statement,

1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string
1626: (
1627: fnd_log.level_statement,
1628: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1629: 'Customer ID :' ||l_cost_price_rec.customer_id
1630: );
1631: END IF;

Line 1646: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1642: -- Error handling
1643: IF l_cost_price_rec.currency IS NULL THEN
1644: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
1645: FND_MSG_PUB.ADD;
1646: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1647: fnd_log.string
1648: (
1649: fnd_log.level_error,
1650: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,

Line 1647: fnd_log.string

1643: IF l_cost_price_rec.currency IS NULL THEN
1644: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
1645: FND_MSG_PUB.ADD;
1646: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1647: fnd_log.string
1648: (
1649: fnd_log.level_error,
1650: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
1651: 'No curency is defined for the organization of the visit'

Line 1649: fnd_log.level_error,

1645: FND_MSG_PUB.ADD;
1646: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1647: fnd_log.string
1648: (
1649: fnd_log.level_error,
1650: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
1651: 'No curency is defined for the organization of the visit'
1652: );
1653: END IF;

Line 1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656: END IF; --If currency is null
1657:
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_statement,
1662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1659: fnd_log.string

1655: END IF;
1656: END IF; --If currency is null
1657:
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_statement,
1662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1663: 'Currency Code :' ||l_cost_price_rec.currency

Line 1661: fnd_log.level_statement,

1657:
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_statement,
1662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1663: 'Currency Code :' ||l_cost_price_rec.currency
1664: );
1665: END IF;

Line 1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1679: RAISE FND_API.G_EXC_ERROR;
1680: END IF;
1681: END IF;
1682:
1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1684: fnd_log.string
1685: (
1686: fnd_log.level_statement,
1687: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1684: fnd_log.string

1680: END IF;
1681: END IF;
1682:
1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1684: fnd_log.string
1685: (
1686: fnd_log.level_statement,
1687: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1688: 'Job Status :' ||l_job_status_code

Line 1686: fnd_log.level_statement,

1682:
1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1684: fnd_log.string
1685: (
1686: fnd_log.level_statement,
1687: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1688: 'Job Status :' ||l_job_status_code
1689: );
1690: fnd_log.string

Line 1690: fnd_log.string

1686: fnd_log.level_statement,
1687: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1688: 'Job Status :' ||l_job_status_code
1689: );
1690: fnd_log.string
1691: (
1692: fnd_log.level_statement,
1693: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1694: 'task start date passed in :' ||l_cost_price_rec.task_start_date

Line 1692: fnd_log.level_statement,

1688: 'Job Status :' ||l_job_status_code
1689: );
1690: fnd_log.string
1691: (
1692: fnd_log.level_statement,
1693: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1694: 'task start date passed in :' ||l_cost_price_rec.task_start_date
1695: );
1696: END IF;

Line 1705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1701:
1702: IF c_mr_csr%found
1703: then ---- billing item is associated to MR
1704:
1705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1706: fnd_log.string(fnd_log.level_statement,
1707: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1708: 'billing item found');
1709: END IF;

Line 1706: fnd_log.string(fnd_log.level_statement,

1702: IF c_mr_csr%found
1703: then ---- billing item is associated to MR
1704:
1705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1706: fnd_log.string(fnd_log.level_statement,
1707: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1708: 'billing item found');
1709: END IF;
1710:

Line 1729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1725:
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728:
1729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1730:
1731: fnd_log.string
1732: (
1733: fnd_log.level_statement,

Line 1731: fnd_log.string

1727: END IF;
1728:
1729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1730:
1731: fnd_log.string
1732: (
1733: fnd_log.level_statement,
1734: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1735: 'current task start date :' ||l_cost_price_rec.task_start_date

Line 1733: fnd_log.level_statement,

1729: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1730:
1731: fnd_log.string
1732: (
1733: fnd_log.level_statement,
1734: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1735: 'current task start date :' ||l_cost_price_rec.task_start_date
1736: );
1737: END IF;

Line 1739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1735: 'current task start date :' ||l_cost_price_rec.task_start_date
1736: );
1737: END IF;
1738:
1739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1740: fnd_log.string
1741: (
1742: fnd_log.level_statement,
1743: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1740: fnd_log.string

1736: );
1737: END IF;
1738:
1739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1740: fnd_log.string
1741: (
1742: fnd_log.level_statement,
1743: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1744: 'Before call to AHL_VWP_PRICE_PVT.get_item_price'

Line 1742: fnd_log.level_statement,

1738:
1739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1740: fnd_log.string
1741: (
1742: fnd_log.level_statement,
1743: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1744: 'Before call to AHL_VWP_PRICE_PVT.get_item_price'
1745: );
1746: END IF;

Line 1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1803: --- If no billing item is associated then check the item price for all the immediate childen
1804:
1805: Else
1806:
1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1808: fnd_log.string
1809: (
1810: fnd_log.level_statement,
1811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1808: fnd_log.string

1804:
1805: Else
1806:
1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1808: fnd_log.string
1809: (
1810: fnd_log.level_statement,
1811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1812: 'Billing Item not found'

Line 1810: fnd_log.level_statement,

1806:
1807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1808: fnd_log.string
1809: (
1810: fnd_log.level_statement,
1811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1812: 'Billing Item not found'
1813: );
1814: END IF;

Line 1837: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1833: fetch c_all_task_csr into l_all_task_rec;
1834: exit when c_all_task_csr%notfound;
1835:
1836:
1837: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1838: fnd_log.string
1839: (
1840: fnd_log.level_statement,
1841: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1838: fnd_log.string

1834: exit when c_all_task_csr%notfound;
1835:
1836:
1837: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1838: fnd_log.string
1839: (
1840: fnd_log.level_statement,
1841: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1842: 'Current Task ID: ' || l_all_task_rec.visit_task_id

Line 1840: fnd_log.level_statement,

1836:
1837: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1838: fnd_log.string
1839: (
1840: fnd_log.level_statement,
1841: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1842: 'Current Task ID: ' || l_all_task_rec.visit_task_id
1843: );
1844:

Line 1845: fnd_log.string

1841: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1842: 'Current Task ID: ' || l_all_task_rec.visit_task_id
1843: );
1844:
1845: fnd_log.string
1846: (
1847: fnd_log.level_statement,
1848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1849: 'Task Type Code: ' || l_all_task_rec.task_type_code

Line 1847: fnd_log.level_statement,

1843: );
1844:
1845: fnd_log.string
1846: (
1847: fnd_log.level_statement,
1848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1849: 'Task Type Code: ' || l_all_task_rec.task_type_code
1850: );
1851:

Line 1852: fnd_log.string

1848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1849: 'Task Type Code: ' || l_all_task_rec.task_type_code
1850: );
1851:
1852: fnd_log.string
1853: (
1854: fnd_log.level_statement,
1855: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1856: 'Task MR ID: ' || l_all_task_rec.MR_ID

Line 1854: fnd_log.level_statement,

1850: );
1851:
1852: fnd_log.string
1853: (
1854: fnd_log.level_statement,
1855: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1856: 'Task MR ID: ' || l_all_task_rec.MR_ID
1857: );
1858:

Line 1865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1861: --initialize input
1862: l_temp_cost_price_rec.visit_task_id := l_all_task_rec.visit_task_id;
1863: l_temp_cost_price_rec.Task_Start_Date := l_all_task_rec.START_DATE_TIME;
1864:
1865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1866: fnd_log.string
1867: (
1868: fnd_log.level_statement,
1869: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1866: fnd_log.string

1862: l_temp_cost_price_rec.visit_task_id := l_all_task_rec.visit_task_id;
1863: l_temp_cost_price_rec.Task_Start_Date := l_all_task_rec.START_DATE_TIME;
1864:
1865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1866: fnd_log.string
1867: (
1868: fnd_log.level_statement,
1869: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1870: 'task_start_date : ' ||l_temp_cost_price_rec.task_start_date

Line 1868: fnd_log.level_statement,

1864:
1865: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1866: fnd_log.string
1867: (
1868: fnd_log.level_statement,
1869: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1870: 'task_start_date : ' ||l_temp_cost_price_rec.task_start_date
1871: );
1872: END IF;

Line 1878: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1874: If l_all_task_rec.task_type_code = 'SUMMARY' and l_all_task_rec.MR_ID is not Null
1875: then -- Child MRs
1876:
1877:
1878: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1879: fnd_log.string
1880: (
1881: fnd_log.level_statement,
1882: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1879: fnd_log.string

1875: then -- Child MRs
1876:
1877:
1878: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1879: fnd_log.string
1880: (
1881: fnd_log.level_statement,
1882: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1883: 'Child MR'

Line 1881: fnd_log.level_statement,

1877:
1878: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1879: fnd_log.string
1880: (
1881: fnd_log.level_statement,
1882: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1883: 'Child MR'
1884: );
1885:

Line 1886: fnd_log.string

1882: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1883: 'Child MR'
1884: );
1885:
1886: fnd_log.string
1887: (
1888: fnd_log.level_statement,
1889: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1890: 'Before call to AHL_VWP_MR_CST_PR_PVT.get_mr_items_no_price'

Line 1888: fnd_log.level_statement,

1884: );
1885:
1886: fnd_log.string
1887: (
1888: fnd_log.level_statement,
1889: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1890: 'Before call to AHL_VWP_MR_CST_PR_PVT.get_mr_items_no_price'
1891: );
1892: END IF;

Line 1913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1909: END IF;
1910: else --- all other tasks
1911:
1912:
1913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: (
1916: fnd_log.level_statement,
1917: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1914: fnd_log.string

1910: else --- all other tasks
1911:
1912:
1913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: (
1916: fnd_log.level_statement,
1917: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1918: 'Unplanned/Planned/Unassociated Tasks'

Line 1916: fnd_log.level_statement,

1912:
1913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: (
1916: fnd_log.level_statement,
1917: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1918: 'Unplanned/Planned/Unassociated Tasks'
1919: );
1920: fnd_log.string

Line 1920: fnd_log.string

1916: fnd_log.level_statement,
1917: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1918: 'Unplanned/Planned/Unassociated Tasks'
1919: );
1920: fnd_log.string
1921: (
1922: fnd_log.level_statement,
1923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1924: 'Before call to AHL_VWP_TASK_CST_PR_PVT.GET_TASK_ITEMS_NO_PRICE'

Line 1922: fnd_log.level_statement,

1918: 'Unplanned/Planned/Unassociated Tasks'
1919: );
1920: fnd_log.string
1921: (
1922: fnd_log.level_statement,
1923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1924: 'Before call to AHL_VWP_TASK_CST_PR_PVT.GET_TASK_ITEMS_NO_PRICE'
1925: );
1926:

Line 1985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1981:
1982: x_cost_price_tbl:=l_cost_price_tbl;
1983:
1984:
1985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1986:
1987: fnd_log.string
1988: (
1989: fnd_log.level_statement,

Line 1987: fnd_log.string

1983:
1984:
1985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1986:
1987: fnd_log.string
1988: (
1989: fnd_log.level_statement,
1990: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1991: 'Total number of items w/o price for the MR: ' || x_cost_price_tbl.count

Line 1989: fnd_log.level_statement,

1985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1986:
1987: fnd_log.string
1988: (
1989: fnd_log.level_statement,
1990: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1991: 'Total number of items w/o price for the MR: ' || x_cost_price_tbl.count
1992: );
1993:

Line 2000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1996: IF FND_API.TO_BOOLEAN(p_commit) THEN
1997: COMMIT;
1998: END IF;
1999:
2000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2001: THEN
2002: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2003: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2004: 'At the end of the procedure');

Line 2002: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1998: END IF;
1999:
2000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2001: THEN
2002: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2003: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2004: 'At the end of the procedure');
2005: END IF;
2006:

Line 2119: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2115: END IF;
2116:
2117: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2118:
2119: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2120: THEN
2121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2122: G_MODULE_NAME||'.'||l_api_name,'At the start of the procedure');
2123: END IF;

Line 2121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2117: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2118:
2119: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2120: THEN
2121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2122: G_MODULE_NAME||'.'||l_api_name,'At the start of the procedure');
2123: END IF;
2124:
2125: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2125: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2122: G_MODULE_NAME||'.'||l_api_name,'At the start of the procedure');
2123: END IF;
2124:
2125: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2126: THEN
2127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2128: G_MODULE_NAME||'.'||l_api_name,'Visit Task ID:'||p_x_cost_price_rec.visit_task_id);
2129: END IF;

Line 2127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2123: END IF;
2124:
2125: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2126: THEN
2127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2128: G_MODULE_NAME||'.'||l_api_name,'Visit Task ID:'||p_x_cost_price_rec.visit_task_id);
2129: END IF;
2130:
2131: POPULATE_COST_PRICE_REC(l_cost_price_rec);

Line 2133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2129: END IF;
2130:
2131: POPULATE_COST_PRICE_REC(l_cost_price_rec);
2132:
2133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2134: THEN
2135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2136: G_MODULE_NAME||'.'||l_api_name,'Visit ID:'||l_cost_price_rec.visit_id);
2137: END IF;

Line 2135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2131: POPULATE_COST_PRICE_REC(l_cost_price_rec);
2132:
2133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2134: THEN
2135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2136: G_MODULE_NAME||'.'||l_api_name,'Visit ID:'||l_cost_price_rec.visit_id);
2137: END IF;
2138:
2139: OPEN visit_info_csr(l_cost_price_rec.visit_id);

Line 2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2142:
2143: IF (visit_info_csr%NOTFOUND)THEN
2144: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
2145: FND_MSG_PUB.ADD;
2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: G_MODULE_NAME||'.'||l_api_name,

Line 2147: fnd_log.string

2143: IF (visit_info_csr%NOTFOUND)THEN
2144: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
2145: FND_MSG_PUB.ADD;
2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: G_MODULE_NAME||'.'||l_api_name,
2151: 'Visit id not found in ahl_visits_b table'

Line 2149: fnd_log.level_exception,

2145: FND_MSG_PUB.ADD;
2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: G_MODULE_NAME||'.'||l_api_name,
2151: 'Visit id not found in ahl_visits_b table'
2152: );
2153: END IF;

Line 2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2285: p_x_cost_price_rec:=l_cost_price_rec;
2286: log_message('billing_item_id :'||l_mr_rec.billing_item_id,l_api_name);
2287:
2288:
2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2290: THEN
2291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2292: G_MODULE_NAME||'.'||l_api_name,'At the end of the procedure');
2293: END IF;

Line 2291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2287:
2288:
2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2290: THEN
2291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2292: G_MODULE_NAME||'.'||l_api_name,'At the end of the procedure');
2293: END IF;
2294:
2295: