APPS.OKS_MASS_UPD_PVT dependencies on FND_LOG

Line 87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

83:
84: IF p_old_ste_code = 'HOLD' THEN
85: IF p_new_ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED') THEN
86: return_status := 'S';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
89: G_MODULE || l_api_name,
90: 'p_new_ste_code ' || p_new_ste_code ||
91: ' is a valid status type for the current status ' ||

Line 88: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

84: IF p_old_ste_code = 'HOLD' THEN
85: IF p_new_ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED') THEN
86: return_status := 'S';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
89: G_MODULE || l_api_name,
90: 'p_new_ste_code ' || p_new_ste_code ||
91: ' is a valid status type for the current status ' ||
92: p_old_ste_code);

Line 97: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

93: END IF;
94:
95: ELSE
96: return_status := 'E';
97: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
99: G_MODULE || l_api_name,
100: 'p_new_ste_code ' || p_new_ste_code ||
101: ' is not a valid status type for the current status ' ||

Line 98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

94:
95: ELSE
96: return_status := 'E';
97: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
99: G_MODULE || l_api_name,
100: 'p_new_ste_code ' || p_new_ste_code ||
101: ' is not a valid status type for the current status ' ||
102: p_old_ste_code);

Line 108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

104: END IF;
105: ELSIF p_old_ste_code = 'CANCELLED' THEN
106: IF p_new_ste_code IN ('ENTERED', 'CANCELLED') THEN
107: return_status := 'S';
108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
110: G_MODULE || l_api_name,
111: 'p_new_ste_code ' || p_new_ste_code ||
112: ' is a valid status type for the current status ' ||

Line 109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

105: ELSIF p_old_ste_code = 'CANCELLED' THEN
106: IF p_new_ste_code IN ('ENTERED', 'CANCELLED') THEN
107: return_status := 'S';
108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
110: G_MODULE || l_api_name,
111: 'p_new_ste_code ' || p_new_ste_code ||
112: ' is a valid status type for the current status ' ||
113: p_old_ste_code);

Line 118: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

114: END IF;
115:
116: ELSE
117: return_status := 'E';
118: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
120: G_MODULE || l_api_name,
121: 'Status type ' || p_new_ste_code ||
122: ' is not a valid status type for the current status ' ||

Line 119: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

115:
116: ELSE
117: return_status := 'E';
118: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
120: G_MODULE || l_api_name,
121: 'Status type ' || p_new_ste_code ||
122: ' is not a valid status type for the current status ' ||
123: p_old_ste_code);

Line 135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

131: INTO l_valid_status;
132: EXIT WHEN get_statuses%NOTFOUND;
133: IF p_new_ste_code = l_valid_status THEN
134: return_status := 'S';
135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
137: G_MODULE || l_api_name,
138: 'Status type ' || l_valid_status ||
139: ' is a valid status type for the current status ' ||

Line 136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

132: EXIT WHEN get_statuses%NOTFOUND;
133: IF p_new_ste_code = l_valid_status THEN
134: return_status := 'S';
135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
137: G_MODULE || l_api_name,
138: 'Status type ' || l_valid_status ||
139: ' is a valid status type for the current status ' ||
140: p_old_ste_code);

Line 145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

141: END IF;
142: EXIT;
143: ELSE
144: return_status := 'E';
145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
147: G_MODULE || l_api_name,
148: 'Status type ' || l_valid_status ||
149: ' is not a valid status type for the current status ' ||

Line 146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

142: EXIT;
143: ELSE
144: return_status := 'E';
145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
147: G_MODULE || l_api_name,
148: 'Status type ' || l_valid_status ||
149: ' is not a valid status type for the current status ' ||
150: p_old_ste_code);

Line 600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

596: l_err_idx NUMBER:=0;
597: l_success_count NUMBER;
598:
599: begin
600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
602: G_MODULE || l_api_name,
603: 'Entered mass_update_price_prc');
604: END IF;

Line 601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

597: l_success_count NUMBER;
598:
599: begin
600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
602: G_MODULE || l_api_name,
603: 'Entered mass_update_price_prc');
604: END IF;
605:

Line 633: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

629: l_input_details.line_id := l_mu_price_tbl(i).line_id;
630: l_input_details.subline_id := l_mu_price_tbl(i).sub_line_id;
631: l_input_details.intent := 'OA';
632:
633: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
635: G_MODULE || l_api_name,
636: ' l_input_details.line_id ' ||
637: l_input_details.line_id ||

Line 634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

630: l_input_details.subline_id := l_mu_price_tbl(i).sub_line_id;
631: l_input_details.intent := 'OA';
632:
633: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
635: G_MODULE || l_api_name,
636: ' l_input_details.line_id ' ||
637: l_input_details.line_id ||
638: ' l_input_details.subline_id ' ||

Line 653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

649: CLOSE check_line_status;
650:
651: IF Nvl(l_line_eligible,'N') <> 'Y' THEN
652:
653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
655: G_MODULE || l_api_name,
656: 'line is not eligible for price change ');
657: END IF;

Line 654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

650:
651: IF Nvl(l_line_eligible,'N') <> 'Y' THEN
652:
653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
655: G_MODULE || l_api_name,
656: 'line is not eligible for price change ');
657: END IF;
658:

Line 682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

678: x_k_det_rec => l_k_det_rec);
679: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
680:
681: --update the new price amount
682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: G_MODULE || l_api_name,
685: 'before call to okc_contract_pub.update_contract_line ');
686: END IF;

Line 683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

679: l_clev_rec_in.object_version_number := l_k_det_rec.object_version_number;
680:
681: --update the new price amount
682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: G_MODULE || l_api_name,
685: 'before call to okc_contract_pub.update_contract_line ');
686: END IF;
687: okc_contract_pub.update_contract_line(p_api_version => l_api_version,

Line 695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

691: x_msg_data => l_msg_data,
692: p_clev_rec => l_clev_rec_in,
693: x_clev_rec => l_clev_rec_out);
694:
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
697: G_MODULE || l_api_name,
698: 'after call to okc_contract_pub.update_contract_line ' ||
699: 'l_return_status -' || l_return_status);

Line 696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

692: p_clev_rec => l_clev_rec_in,
693: x_clev_rec => l_clev_rec_out);
694:
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
697: G_MODULE || l_api_name,
698: 'after call to okc_contract_pub.update_contract_line ' ||
699: 'l_return_status -' || l_return_status);
700: END IF;

Line 715: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

711: RAISE l_exc_error;
712: END IF;
713:
714: ----call oks_qp_int_pvt to compute the new price
715: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
717: G_MODULE || l_api_name,
718: 'before call to oks_qp_int_pvt.compute_Price ');
719: END IF;

Line 716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

712: END IF;
713:
714: ----call oks_qp_int_pvt to compute the new price
715: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
717: G_MODULE || l_api_name,
718: 'before call to oks_qp_int_pvt.compute_Price ');
719: END IF;
720: oks_qp_int_pvt.compute_Price(p_api_version => 1.0,

Line 730: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

726: x_return_status => l_return_status,
727: x_msg_count => l_msg_count,
728: x_msg_data => l_msg_data);
729:
730: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
732: G_MODULE || l_api_name,
733: 'after call to oks_qp_int_pvt.compute_Price ' ||
734: 'l_return_status ' || l_return_status);

Line 731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

727: x_msg_count => l_msg_count,
728: x_msg_data => l_msg_data);
729:
730: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
732: G_MODULE || l_api_name,
733: 'after call to oks_qp_int_pvt.compute_Price ' ||
734: 'l_return_status ' || l_return_status);
735: END IF;

Line 751: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

747: RAISE l_exc_error;
748: END IF;
749:
750: ----call oks_bill_sch.Create_Bill_Sch_CP
751: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
753: G_MODULE || l_api_name,
754: 'before call to oks_bill_sch.Create_Bill_Sch_CP ');
755: END IF;

Line 752: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

748: END IF;
749:
750: ----call oks_bill_sch.Create_Bill_Sch_CP
751: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
753: G_MODULE || l_api_name,
754: 'before call to oks_bill_sch.Create_Bill_Sch_CP ');
755: END IF;
756: ---- call create bill sch to refresh the level elements

Line 764: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

760: x_return_status => l_return_status,
761: x_msg_count => l_msg_count,
762: x_msg_data => l_msg_data);
763:
764: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
766: G_MODULE || l_api_name,
767: ' after call to oks_bill_sch.Create_Bill_Sch_CP ' ||
768: 'l_return_status ' || l_return_status);

Line 765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

761: x_msg_count => l_msg_count,
762: x_msg_data => l_msg_data);
763:
764: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
766: G_MODULE || l_api_name,
767: ' after call to oks_bill_sch.Create_Bill_Sch_CP ' ||
768: 'l_return_status ' || l_return_status);
769: END IF;

Line 798: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

794: fetch toplinetax_cur
795: into l_kln_rec_in.tax_amount;
796: close toplinetax_cur;
797:
798: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
800: G_MODULE || l_api_name,
801: 'before call to oks_contract_line_pub.update_line ');
802: END IF;

Line 799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

795: into l_kln_rec_in.tax_amount;
796: close toplinetax_cur;
797:
798: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
800: G_MODULE || l_api_name,
801: 'before call to oks_contract_line_pub.update_line ');
802: END IF;
803:

Line 812: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

808: x_msg_data => l_msg_data,
809: p_klnv_rec => l_kln_rec_in,
810: x_klnv_rec => l_kln_rec_out,
811: p_validate_yn => 'N');
812: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
814: G_MODULE || l_api_name,
815: ' after call to oks_contract_line_pub.update_line ' ||
816: 'l_return_status ' || l_return_status);

Line 813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

809: p_klnv_rec => l_kln_rec_in,
810: x_klnv_rec => l_kln_rec_out,
811: p_validate_yn => 'N');
812: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
814: G_MODULE || l_api_name,
815: ' after call to oks_contract_line_pub.update_line ' ||
816: 'l_return_status ' || l_return_status);
817: END IF;

Line 847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

843: l_khrv_tbl_type_in(1).id := l_get_hdr_details.id;
844: l_khrv_tbl_type_in(1).chr_id := l_mu_price_tbl(i).chr_id;
845: l_khrv_tbl_type_in(1).object_version_number := l_get_hdr_details.object_version_number;
846:
847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
849: G_MODULE || l_api_name,
850: 'before call to oks_contract_hdr_pub.update_header ');
851: END IF;

Line 848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

844: l_khrv_tbl_type_in(1).chr_id := l_mu_price_tbl(i).chr_id;
845: l_khrv_tbl_type_in(1).object_version_number := l_get_hdr_details.object_version_number;
846:
847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
849: G_MODULE || l_api_name,
850: 'before call to oks_contract_hdr_pub.update_header ');
851: END IF;
852:

Line 862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

858: p_khrv_tbl => l_khrv_tbl_type_in,
859: x_khrv_tbl => l_khrv_tbl_type_out,
860: p_validate_yn => 'N');
861:
862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
864: G_MODULE || l_api_name,
865: ' after call to oks_contract_hdr_pub.update_header ' ||
866: 'l_return_status ' || l_return_status);

Line 863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

859: x_khrv_tbl => l_khrv_tbl_type_out,
860: p_validate_yn => 'N');
861:
862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
864: G_MODULE || l_api_name,
865: ' after call to oks_contract_hdr_pub.update_header ' ||
866: 'l_return_status ' || l_return_status);
867: END IF;

Line 925: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

921:
922: END LOOP;
923: END IF;
924:
925: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
927: G_MODULE || l_api_name,
928: 'Leaving mass_update_price_prc');
929: END IF;

Line 926: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

922: END LOOP;
923: END IF;
924:
925: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
927: G_MODULE || l_api_name,
928: 'Leaving mass_update_price_prc');
929: END IF;
930: IF x_overall_status IS NOT NULL THEN

Line 937: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

933: EXCEPTION
934:
935: WHEN OTHERS THEN
936:
937: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
938: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
939: G_MODULE || l_api_name,
940: 'Leaving mass_update_price_prc because of EXCEPTION: ' ||
941: sqlerrm);

Line 938: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

934:
935: WHEN OTHERS THEN
936:
937: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
938: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
939: G_MODULE || l_api_name,
940: 'Leaving mass_update_price_prc because of EXCEPTION: ' ||
941: sqlerrm);
942: END IF;

Line 1326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1322: l_success_count NUMBER;
1323: BEGIN
1324: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
1325:
1326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1328: G_MODULE || l_api_name,
1329: 'Entered Mass_Update_Status_Prc');
1330: END IF;

Line 1327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1323: BEGIN
1324: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
1325:
1326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1328: G_MODULE || l_api_name,
1329: 'Entered Mass_Update_Status_Prc');
1330: END IF;
1331:

Line 1369: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1365: p_lines_tbl(i).line_id := p_lines_tbl(i).sub_line_id;
1366:
1367: END IF;
1368:
1369: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1371: G_MODULE || l_api_name,
1372: 'Before Validate_Status' || 'Line Id is -' ||
1373: p_lines_tbl(i)

Line 1370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1366:
1367: END IF;
1368:
1369: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1371: G_MODULE || l_api_name,
1372: 'Before Validate_Status' || 'Line Id is -' ||
1373: p_lines_tbl(i)
1374: .line_id || 'Old_Ste_Code -' || l_old_ste_code ||

Line 1395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1391: p_cle_id => p_lines_tbl(i)
1392: .line_id,
1393: p_validate_status => 'Y');
1394:
1395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1397: G_MODULE || l_api_name,
1398: 'After Validate_Status' || 'l_return_status -' ||
1399: l_return_status);

Line 1396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1392: .line_id,
1393: p_validate_status => 'Y');
1394:
1395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1397: G_MODULE || l_api_name,
1398: 'After Validate_Status' || 'l_return_status -' ||
1399: l_return_status);
1400: END IF;

Line 1438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1434: p_comments => p_lines_tbl(i)
1435: .comments,
1436: p_validate_status => 'N');
1437:
1438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1440: G_MODULE || l_api_name,
1441: 'After Update_Line_Status' || 'l_return_status -' ||
1442: l_return_status);

Line 1439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1435: .comments,
1436: p_validate_status => 'N');
1437:
1438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1440: G_MODULE || l_api_name,
1441: 'After Update_Line_Status' || 'l_return_status -' ||
1442: l_return_status);
1443: END IF;

Line 1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1517: EXCEPTION
1518:
1519: WHEN OTHERS THEN
1520:
1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1523: G_MODULE || l_api_name,
1524: 'Leaving mass_update_status_prc because of EXCEPTION: ' ||
1525: sqlerrm);

Line 1522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1518:
1519: WHEN OTHERS THEN
1520:
1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1523: G_MODULE || l_api_name,
1524: 'Leaving mass_update_status_prc because of EXCEPTION: ' ||
1525: sqlerrm);
1526: END IF;

Line 1730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1726: fnd_file.put_line (fnd_file.log, l_api_name || ', Line Start/End Date is out of Contract''s Effectivity, p_line_number: ' || p_line_number);
1727: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;
1728: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Line Start/End Date is out of Contract''s Effectivity';
1729: l_err_eff_idx := l_err_eff_idx +1;
1730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1732: G_MODULE || l_api_name,
1733: 'Line Start/End Date is out of Contract''s Effectivity, line_number: ' || p_line_number);
1734: END IF;

Line 1731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1727: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;
1728: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Line Start/End Date is out of Contract''s Effectivity';
1729: l_err_eff_idx := l_err_eff_idx +1;
1730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1731: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1732: G_MODULE || l_api_name,
1733: 'Line Start/End Date is out of Contract''s Effectivity, line_number: ' || p_line_number);
1734: END IF;
1735: RETURN;

Line 1743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1739: when OTHERS then
1740: exception_yn := 'Y';
1741: fnd_file.put_line (fnd_file.log, l_api_name ||
1742: ' Error while validating data in check_new_line_effectivity for line_number: ' || p_line_number);
1743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1745: l_api_name,
1746: 'Error while fetching data for check_new_line_effectivity for line_number: ' || p_line_number);
1747: END IF;

Line 1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1740: exception_yn := 'Y';
1741: fnd_file.put_line (fnd_file.log, l_api_name ||
1742: ' Error while validating data in check_new_line_effectivity for line_number: ' || p_line_number);
1743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1745: l_api_name,
1746: 'Error while fetching data for check_new_line_effectivity for line_number: ' || p_line_number);
1747: END IF;
1748: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;

Line 1829: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1825:
1826: IF (exception_yn <> 'N') THEN
1827: fnd_file.put_line (fnd_file.log, l_api_name ||
1828: ', Subline Start/End Date is out of Contract''s or Contract Line''s Effectivity, subline number: ' || p_line_number);
1829: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1831: l_api_name,
1832: 'Subline Start/End Date is out of Contract''s or Contract Line''s Effectivity for Subline number: ' || p_line_number);
1833: END IF;

Line 1830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1826: IF (exception_yn <> 'N') THEN
1827: fnd_file.put_line (fnd_file.log, l_api_name ||
1828: ', Subline Start/End Date is out of Contract''s or Contract Line''s Effectivity, subline number: ' || p_line_number);
1829: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1831: l_api_name,
1832: 'Subline Start/End Date is out of Contract''s or Contract Line''s Effectivity for Subline number: ' || p_line_number);
1833: END IF;
1834: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;

Line 1847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1843: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for subline, Error: ' || SQLERRM;
1844: l_err_eff_idx := l_err_eff_idx +1;
1845: fnd_file.put_line (fnd_file.output, l_api_name ||
1846: ' Error while validating data in check_new_subline_effectivity for subline number: ' || p_line_number);
1847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1849: l_api_name,
1850: 'Error while validating data in check_new_subline_effectivity for subline number: ' || p_line_number);
1851: END IF;

Line 1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1844: l_err_eff_idx := l_err_eff_idx +1;
1845: fnd_file.put_line (fnd_file.output, l_api_name ||
1846: ' Error while validating data in check_new_subline_effectivity for subline number: ' || p_line_number);
1847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1849: l_api_name,
1850: 'Error while validating data in check_new_subline_effectivity for subline number: ' || p_line_number);
1851: END IF;
1852: END check_new_subline_effectivity;

Line 1929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1925: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
1926: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for line';
1927: l_err_eff_idx := l_err_eff_idx +1;
1928:
1929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1931: l_api_name,
1932: ' Error while fetching data from okc_k_lines_b, line number: ' || p_mass_update_effectivity_tbl(i).line_number);
1933: END IF;

Line 1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1926: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for line';
1927: l_err_eff_idx := l_err_eff_idx +1;
1928:
1929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1931: l_api_name,
1932: ' Error while fetching data from okc_k_lines_b, line number: ' || p_mass_update_effectivity_tbl(i).line_number);
1933: END IF;
1934: END;

Line 2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2066: when OTHERS THEN
2067: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2068: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for Subline';
2069: l_err_eff_idx := l_err_eff_idx +1;
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2072: l_api_name,
2073: ' Error while fetching data from okc_k_lines_b');
2074: END IF;

Line 2071: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2067: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2068: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for Subline';
2069: l_err_eff_idx := l_err_eff_idx +1;
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2071: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2072: l_api_name,
2073: ' Error while fetching data from okc_k_lines_b');
2074: END IF;
2075: END;

Line 2245: IF fnd_log.level_statement >=

2241: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2242: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error While updating line is' || X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION;
2243: l_err_eff_idx := l_err_eff_idx +1;
2244:
2245: IF fnd_log.level_statement >=
2246: fnd_log.g_current_runtime_level THEN
2247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2248: l_api_name,
2249: ' Error While updating line is: ' ||

Line 2246: fnd_log.g_current_runtime_level THEN

2242: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error While updating line is' || X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION;
2243: l_err_eff_idx := l_err_eff_idx +1;
2244:
2245: IF fnd_log.level_statement >=
2246: fnd_log.g_current_runtime_level THEN
2247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2248: l_api_name,
2249: ' Error While updating line is: ' ||
2250: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION);

Line 2247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2243: l_err_eff_idx := l_err_eff_idx +1;
2244:
2245: IF fnd_log.level_statement >=
2246: fnd_log.g_current_runtime_level THEN
2247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2248: l_api_name,
2249: ' Error While updating line is: ' ||
2250: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION);
2251: END IF;

Line 2261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2257:
2258: EXCEPTION
2259: when OTHERS THEN
2260: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2263: l_api_name,
2264: ' Error from okc_contract_pub.update_contract_line procedure' ||
2265: SQLERRM);

Line 2262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2258: EXCEPTION
2259: when OTHERS THEN
2260: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2263: l_api_name,
2264: ' Error from okc_contract_pub.update_contract_line procedure' ||
2265: SQLERRM);
2266: END IF;

Line 2302: IF fnd_log.level_statement >=

2298: p_msg_index_out => l_msg_index);
2299:
2300: X_MSG_TBL(L_TOT_MSG_COUNT).STATUS := L_RETURN_STATUS;
2301: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION := L_MSG_DATA;
2302: IF fnd_log.level_statement >=
2303: fnd_log.g_current_runtime_level THEN
2304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2305: l_api_name,
2306: ' Error While updating line is: ' ||

Line 2303: fnd_log.g_current_runtime_level THEN

2299:
2300: X_MSG_TBL(L_TOT_MSG_COUNT).STATUS := L_RETURN_STATUS;
2301: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION := L_MSG_DATA;
2302: IF fnd_log.level_statement >=
2303: fnd_log.g_current_runtime_level THEN
2304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2305: l_api_name,
2306: ' Error While updating line is: ' ||
2307: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION);

Line 2304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2300: X_MSG_TBL(L_TOT_MSG_COUNT).STATUS := L_RETURN_STATUS;
2301: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION := L_MSG_DATA;
2302: IF fnd_log.level_statement >=
2303: fnd_log.g_current_runtime_level THEN
2304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2305: l_api_name,
2306: ' Error While updating line is: ' ||
2307: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION);
2308: END IF;

Line 2318: IF fnd_log.level_statement >=

2314:
2315: EXCEPTION
2316: when OTHERS THEN
2317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2318: IF fnd_log.level_statement >=
2319: fnd_log.g_current_runtime_level THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2321: l_api_name,
2322: ' Error from OKS_BILL_SCH.Cascade_Dates_SLL: ' ||

Line 2319: fnd_log.g_current_runtime_level THEN

2315: EXCEPTION
2316: when OTHERS THEN
2317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2318: IF fnd_log.level_statement >=
2319: fnd_log.g_current_runtime_level THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2321: l_api_name,
2322: ' Error from OKS_BILL_SCH.Cascade_Dates_SLL: ' ||
2323: SQLERRM);

Line 2320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2316: when OTHERS THEN
2317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2318: IF fnd_log.level_statement >=
2319: fnd_log.g_current_runtime_level THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2321: l_api_name,
2322: ' Error from OKS_BILL_SCH.Cascade_Dates_SLL: ' ||
2323: SQLERRM);
2324: END IF;

Line 2422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2418:
2419:
2420: EXCEPTION
2421: when OTHERS THEN
2422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2424: l_api_name,
2425: ' Exception from okc_contract_pub.update_contract_line, Error is: ' ||
2426: SQLERRM);

Line 2423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2419:
2420: EXCEPTION
2421: when OTHERS THEN
2422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2424: l_api_name,
2425: ' Exception from okc_contract_pub.update_contract_line, Error is: ' ||
2426: SQLERRM);
2427: END IF;

Line 2450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2446: p_msg_index_out => l_msg_index);
2447:
2448: x_msg_tbl(l_tot_msg_count).status := l_return_status;
2449: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION := L_MSG_DATA;
2450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2452: l_api_name,
2453: ' Error message is: ' || x_msg_tbl(l_tot_msg_count).description);
2454: END IF;

Line 2451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2447:
2448: x_msg_tbl(l_tot_msg_count).status := l_return_status;
2449: X_MSG_TBL(L_TOT_MSG_COUNT).DESCRIPTION := L_MSG_DATA;
2450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2452: l_api_name,
2453: ' Error message is: ' || x_msg_tbl(l_tot_msg_count).description);
2454: END IF;
2455: l_tot_msg_count := l_tot_msg_count + 1;

Line 2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2568: END IF;
2569:
2570: EXCEPTION
2571: when OTHERS THEN
2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2574: l_api_name, ' Error while updating line' || SQLERRM);
2575:
2576: END IF;

Line 2573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2569:
2570: EXCEPTION
2571: when OTHERS THEN
2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2574: l_api_name, ' Error while updating line' || SQLERRM);
2575:
2576: END IF;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;