APPS.QP_LOCK_PRICELIST_PVT dependencies on FND_LOG

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

280: EXCEPTION
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
285: fnd_log.STRING (fnd_log.level_procedure,
286: g_pkg_name || 'Get_Price_List',
287: 'Others Exception: '||substr(sqlerrm, 1, 240));
288: END IF;

Line 285: fnd_log.STRING (fnd_log.level_procedure,

281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
285: fnd_log.STRING (fnd_log.level_procedure,
286: g_pkg_name || 'Get_Price_List',
287: 'Others Exception: '||substr(sqlerrm, 1, 240));
288: END IF;
289:

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

364: l_locked_price_list_id := null;
365:
366: END;
367:
368: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
369: fnd_log.STRING (fnd_log.level_procedure,
370: g_pkg_name || '.Lock_Price',
371: 'Entered procedure');
372: END IF;

Line 369: fnd_log.STRING (fnd_log.level_procedure,

365:
366: END;
367:
368: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
369: fnd_log.STRING (fnd_log.level_procedure,
370: g_pkg_name || '.Lock_Price',
371: 'Entered procedure');
372: END IF;
373:

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

370: g_pkg_name || '.Lock_Price',
371: 'Entered procedure');
372: END IF;
373:
374: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
375: fnd_log.STRING (fnd_log.level_procedure,
376: g_pkg_name || '.Lock_Price',
377: 'p_source_price_list_id = '||p_source_price_list_id ||
378: ' and ' ||

Line 375: fnd_log.STRING (fnd_log.level_procedure,

371: 'Entered procedure');
372: END IF;
373:
374: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
375: fnd_log.STRING (fnd_log.level_procedure,
376: g_pkg_name || '.Lock_Price',
377: 'p_source_price_list_id = '||p_source_price_list_id ||
378: ' and ' ||
379: 'p_source_list_line_id = ' || p_source_list_line_id);

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

390: x_return_status => x_return_status,
391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);
393:
394: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
395: fnd_log.STRING (fnd_log.level_procedure,
396: g_pkg_name || '.Lock_Price',
397: 'l_locked_price_list_id = '|| l_locked_price_list_id);
398: END IF;

Line 395: fnd_log.STRING (fnd_log.level_procedure,

391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);
393:
394: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
395: fnd_log.STRING (fnd_log.level_procedure,
396: g_pkg_name || '.Lock_Price',
397: 'l_locked_price_list_id = '|| l_locked_price_list_id);
398: END IF;
399:

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

399:
400: IF l_locked_price_list_id IS NULL THEN
401: --Create new locked_price_list, line, etc.
402:
403: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
404: fnd_log.STRING (fnd_log.level_procedure,
405: g_pkg_name || '.Lock_Price',
406: 'l_locked_price_list_id is null ');
407: END IF;

Line 404: fnd_log.STRING (fnd_log.level_procedure,

400: IF l_locked_price_list_id IS NULL THEN
401: --Create new locked_price_list, line, etc.
402:
403: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
404: fnd_log.STRING (fnd_log.level_procedure,
405: g_pkg_name || '.Lock_Price',
406: 'l_locked_price_list_id is null ');
407: END IF;
408:

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

530:
531: END LOOP; --Loop to copy p_source_list_line_id and its attributes
532:
533:
534: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
535: fnd_log.STRING (fnd_log.level_procedure,
536: g_pkg_name || '.Lock_Price',
537: 'After loop to copy p_source_list_line_id and attrs');
538: END IF;

Line 535: fnd_log.STRING (fnd_log.level_procedure,

531: END LOOP; --Loop to copy p_source_list_line_id and its attributes
532:
533:
534: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
535: fnd_log.STRING (fnd_log.level_procedure,
536: g_pkg_name || '.Lock_Price',
537: 'After loop to copy p_source_list_line_id and attrs');
538: END IF;
539:

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

580: END IF; --If list_line is a child of the source list line id
581:
582: END LOOP; --Loop to copy any price break child lines and its attributes
583:
584: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
585: fnd_log.STRING (fnd_log.level_procedure,
586: g_pkg_name || '.Lock_Price',
587: 'After loop to copy price break child lines and attrs');
588: END IF;

Line 585: fnd_log.STRING (fnd_log.level_procedure,

581:
582: END LOOP; --Loop to copy any price break child lines and its attributes
583:
584: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
585: fnd_log.STRING (fnd_log.level_procedure,
586: g_pkg_name || '.Lock_Price',
587: 'After loop to copy price break child lines and attrs');
588: END IF;
589:

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

593: -- Instruct API to retain its caches
594: p_control_rec.clear_api_cache := FALSE;
595: p_control_rec.clear_api_requests := FALSE;
596:
597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
598: fnd_log.STRING (fnd_log.level_procedure,
599: g_pkg_name || '.Lock_Price',
600: 'Before Process_Price_List 1');
601: END IF;

Line 598: fnd_log.STRING (fnd_log.level_procedure,

594: p_control_rec.clear_api_cache := FALSE;
595: p_control_rec.clear_api_requests := FALSE;
596:
597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
598: fnd_log.STRING (fnd_log.level_procedure,
599: g_pkg_name || '.Lock_Price',
600: 'Before Process_Price_List 1');
601: END IF;
602:

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

617: , x_QUALIFIERS_tbl => x_qualifiers_tbl
618: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
619: );
620:
621: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
622: fnd_log.STRING (fnd_log.level_procedure,
623: g_pkg_name || '.Lock_Price',
624: 'After Process_Price_List 1');
625: END IF;

Line 622: fnd_log.STRING (fnd_log.level_procedure,

618: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
619: );
620:
621: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
622: fnd_log.STRING (fnd_log.level_procedure,
623: g_pkg_name || '.Lock_Price',
624: 'After Process_Price_List 1');
625: END IF;
626:

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

623: g_pkg_name || '.Lock_Price',
624: 'After Process_Price_List 1');
625: END IF;
626:
627: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
628: fnd_log.STRING (fnd_log.level_procedure,
629: g_pkg_name || '.Lock_Price',
630: 'x_return_status = ' || x_return_status);
631: END IF;

Line 628: fnd_log.STRING (fnd_log.level_procedure,

624: 'After Process_Price_List 1');
625: END IF;
626:
627: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
628: fnd_log.STRING (fnd_log.level_procedure,
629: g_pkg_name || '.Lock_Price',
630: 'x_return_status = ' || x_return_status);
631: END IF;
632:

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

629: g_pkg_name || '.Lock_Price',
630: 'x_return_status = ' || x_return_status);
631: END IF;
632:
633: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
634: fnd_log.STRING (fnd_log.level_procedure,
635: g_pkg_name || '.Lock_Price',
636: 'x_return_status = ' || x_msg_data);
637: END IF;

Line 634: fnd_log.STRING (fnd_log.level_procedure,

630: 'x_return_status = ' || x_return_status);
631: END IF;
632:
633: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
634: fnd_log.STRING (fnd_log.level_procedure,
635: g_pkg_name || '.Lock_Price',
636: 'x_return_status = ' || x_msg_data);
637: END IF;
638:

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

645: --Set output variables.
646: x_locked_price_list_id := x_price_list_rec.list_header_id;
647: x_locked_list_line_id := x_price_list_line_tbl(1).list_line_id;
648:
649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
650: fnd_log.STRING (fnd_log.level_procedure,
651: g_pkg_name || '.Lock_Price',
652: 'x_locked_price_list_id = ' || x_locked_price_list_id ||
653: 'and ' ||

Line 650: fnd_log.STRING (fnd_log.level_procedure,

646: x_locked_price_list_id := x_price_list_rec.list_header_id;
647: x_locked_list_line_id := x_price_list_line_tbl(1).list_line_id;
648:
649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
650: fnd_log.STRING (fnd_log.level_procedure,
651: g_pkg_name || '.Lock_Price',
652: 'x_locked_price_list_id = ' || x_locked_price_list_id ||
653: 'and ' ||
654: 'x_locked_list_line_id = ' || x_locked_list_line_id);

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

681: p_pricing_attr_tbl(1).excluder_flag := 'N';
682: p_pricing_attr_tbl(1).price_list_line_index := 1;
683: p_pricing_attr_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
684:
685: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.STRING (fnd_log.level_procedure,
687: g_pkg_name || '.Lock_Price',
688: 'Before Process_Price_List 2');
689: END IF;

Line 686: fnd_log.STRING (fnd_log.level_procedure,

682: p_pricing_attr_tbl(1).price_list_line_index := 1;
683: p_pricing_attr_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
684:
685: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.STRING (fnd_log.level_procedure,
687: g_pkg_name || '.Lock_Price',
688: 'Before Process_Price_List 2');
689: END IF;
690:

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

703: , x_QUALIFIERS_tbl => x_qualifiers_tbl
704: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
705: );
706:
707: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.STRING (fnd_log.level_procedure,
709: g_pkg_name || '.Lock_Price',
710: 'After Process_Price_List 2');
711: END IF;

Line 708: fnd_log.STRING (fnd_log.level_procedure,

704: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
705: );
706:
707: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.STRING (fnd_log.level_procedure,
709: g_pkg_name || '.Lock_Price',
710: 'After Process_Price_List 2');
711: END IF;
712:

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

709: g_pkg_name || '.Lock_Price',
710: 'After Process_Price_List 2');
711: END IF;
712:
713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
714: fnd_log.STRING (fnd_log.level_procedure,
715: g_pkg_name || '.Lock_Price',
716: 'x_return_status = ' || x_return_status);
717: END IF;

Line 714: fnd_log.STRING (fnd_log.level_procedure,

710: 'After Process_Price_List 2');
711: END IF;
712:
713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
714: fnd_log.STRING (fnd_log.level_procedure,
715: g_pkg_name || '.Lock_Price',
716: 'x_return_status = ' || x_return_status);
717: END IF;
718:

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

715: g_pkg_name || '.Lock_Price',
716: 'x_return_status = ' || x_return_status);
717: END IF;
718:
719: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
720: fnd_log.STRING (fnd_log.level_procedure,
721: g_pkg_name || '.Lock_Price',
722: 'x_return_status = ' || x_msg_data);
723: END IF;

Line 720: fnd_log.STRING (fnd_log.level_procedure,

716: 'x_return_status = ' || x_return_status);
717: END IF;
718:
719: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
720: fnd_log.STRING (fnd_log.level_procedure,
721: g_pkg_name || '.Lock_Price',
722: 'x_return_status = ' || x_msg_data);
723: END IF;
724:

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

839: -- Instruct API to retain its caches
840: p_control_rec.clear_api_cache := FALSE;
841: p_control_rec.clear_api_requests := FALSE;
842:
843: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.STRING (fnd_log.level_procedure,
845: g_pkg_name || '.Lock_Price',
846: 'Before Process_Price_List 3');
847: END IF;

Line 844: fnd_log.STRING (fnd_log.level_procedure,

840: p_control_rec.clear_api_cache := FALSE;
841: p_control_rec.clear_api_requests := FALSE;
842:
843: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
844: fnd_log.STRING (fnd_log.level_procedure,
845: g_pkg_name || '.Lock_Price',
846: 'Before Process_Price_List 3');
847: END IF;
848:

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

863: , x_QUALIFIERS_tbl => x_qualifiers_tbl
864: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
865: );
866:
867: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
868: fnd_log.STRING (fnd_log.level_procedure,
869: g_pkg_name || '.Lock_Price',
870: 'After Process_Price_List 3');
871: END IF;

Line 868: fnd_log.STRING (fnd_log.level_procedure,

864: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
865: );
866:
867: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
868: fnd_log.STRING (fnd_log.level_procedure,
869: g_pkg_name || '.Lock_Price',
870: 'After Process_Price_List 3');
871: END IF;
872:

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

869: g_pkg_name || '.Lock_Price',
870: 'After Process_Price_List 3');
871: END IF;
872:
873: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
874: fnd_log.STRING (fnd_log.level_procedure,
875: g_pkg_name || '.Lock_Price',
876: 'x_return_status = ' || x_return_status);
877: END IF;

Line 874: fnd_log.STRING (fnd_log.level_procedure,

870: 'After Process_Price_List 3');
871: END IF;
872:
873: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
874: fnd_log.STRING (fnd_log.level_procedure,
875: g_pkg_name || '.Lock_Price',
876: 'x_return_status = ' || x_return_status);
877: END IF;
878:

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

875: g_pkg_name || '.Lock_Price',
876: 'x_return_status = ' || x_return_status);
877: END IF;
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
880: fnd_log.STRING (fnd_log.level_procedure,
881: g_pkg_name || '.Lock_Price',
882: 'x_return_status = ' || x_msg_data);
883: END IF;

Line 880: fnd_log.STRING (fnd_log.level_procedure,

876: 'x_return_status = ' || x_return_status);
877: END IF;
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
880: fnd_log.STRING (fnd_log.level_procedure,
881: g_pkg_name || '.Lock_Price',
882: 'x_return_status = ' || x_msg_data);
883: END IF;
884:

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

891: --Set output variables.
892: x_locked_price_list_id := l_locked_price_list_id;
893: x_locked_list_line_id := x_price_list_line_tbl(1).list_line_id;
894:
895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
896: fnd_log.STRING (fnd_log.level_procedure,
897: g_pkg_name || '.Lock_Price',
898: 'x_locked_price_list_id = ' || x_locked_price_list_id ||
899: 'and ' ||

Line 896: fnd_log.STRING (fnd_log.level_procedure,

892: x_locked_price_list_id := l_locked_price_list_id;
893: x_locked_list_line_id := x_price_list_line_tbl(1).list_line_id;
894:
895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
896: fnd_log.STRING (fnd_log.level_procedure,
897: g_pkg_name || '.Lock_Price',
898: 'x_locked_price_list_id = ' || x_locked_price_list_id ||
899: 'and ' ||
900: 'x_locked_list_line_id = ' || x_locked_list_line_id);

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

928: p_pricing_attr_tbl(1).excluder_flag := 'N';
929: p_pricing_attr_tbl(1).price_list_line_index := 1;
930: p_pricing_attr_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
931:
932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
933: fnd_log.STRING (fnd_log.level_procedure,
934: g_pkg_name || '.Lock_Price',
935: 'Before Process_Price_List 4');
936: END IF;

Line 933: fnd_log.STRING (fnd_log.level_procedure,

929: p_pricing_attr_tbl(1).price_list_line_index := 1;
930: p_pricing_attr_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
931:
932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
933: fnd_log.STRING (fnd_log.level_procedure,
934: g_pkg_name || '.Lock_Price',
935: 'Before Process_Price_List 4');
936: END IF;
937:

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

950: , x_QUALIFIERS_tbl => x_qualifiers_tbl
951: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
952: );
953:
954: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
955: fnd_log.STRING (fnd_log.level_procedure,
956: g_pkg_name || '.Lock_Price',
957: 'After Process_Price_List 4');
958: END IF;

Line 955: fnd_log.STRING (fnd_log.level_procedure,

951: , x_PRICING_ATTR_tbl => x_pricing_attr_tbl
952: );
953:
954: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
955: fnd_log.STRING (fnd_log.level_procedure,
956: g_pkg_name || '.Lock_Price',
957: 'After Process_Price_List 4');
958: END IF;
959:

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

956: g_pkg_name || '.Lock_Price',
957: 'After Process_Price_List 4');
958: END IF;
959:
960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
961: fnd_log.STRING (fnd_log.level_procedure,
962: g_pkg_name || '.Lock_Price',
963: 'x_return_status = ' || x_return_status);
964: END IF;

Line 961: fnd_log.STRING (fnd_log.level_procedure,

957: 'After Process_Price_List 4');
958: END IF;
959:
960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
961: fnd_log.STRING (fnd_log.level_procedure,
962: g_pkg_name || '.Lock_Price',
963: 'x_return_status = ' || x_return_status);
964: END IF;
965:

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

962: g_pkg_name || '.Lock_Price',
963: 'x_return_status = ' || x_return_status);
964: END IF;
965:
966: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
967: fnd_log.STRING (fnd_log.level_procedure,
968: g_pkg_name || '.Lock_Price',
969: 'x_return_status = ' || x_msg_data);
970: END IF;

Line 967: fnd_log.STRING (fnd_log.level_procedure,

963: 'x_return_status = ' || x_return_status);
964: END IF;
965:
966: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
967: fnd_log.STRING (fnd_log.level_procedure,
968: g_pkg_name || '.Lock_Price',
969: 'x_return_status = ' || x_msg_data);
970: END IF;
971:

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

1011: WHEN OTHERS THEN
1012:
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1014:
1015: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1016: fnd_log.STRING (fnd_log.level_procedure,
1017: g_pkg_name || '.Lock_Price',
1018: 'Others Exception : ' || substr(sqlerrm, 1, 240));
1019: END IF;

Line 1016: fnd_log.STRING (fnd_log.level_procedure,

1012:
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1014:
1015: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1016: fnd_log.STRING (fnd_log.level_procedure,
1017: g_pkg_name || '.Lock_Price',
1018: 'Others Exception : ' || substr(sqlerrm, 1, 240));
1019: END IF;
1020: