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

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

465: --duration based uom if pricelist is not present
466: okc_time_util_pub.get_duration(lin_det_rec.start_date,p_end_date,l_duration,l_uom,x_return_status);
467: --errorout_ad(' l_uom '||l_uom);
468: --errorout_ad(' l_duration '||l_duration);
469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.price_uom_is_null',
471: 'after calling okc_time_util_pub.get_duration '
472: ||' result l_duration = ' || l_duration||',l_uom = '||l_uom);
473: END IF;

Line 470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.price_uom_is_null',

466: okc_time_util_pub.get_duration(lin_det_rec.start_date,p_end_date,l_duration,l_uom,x_return_status);
467: --errorout_ad(' l_uom '||l_uom);
468: --errorout_ad(' l_duration '||l_duration);
469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.price_uom_is_null',
471: 'after calling okc_time_util_pub.get_duration '
472: ||' result l_duration = ' || l_duration||',l_uom = '||l_uom);
473: END IF;
474:

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

537: p_source_uom => P_billing_uom,--nvl(lin_det_rec.price_uom,l_uom), --target uom
538: p_period_type => p_period_type,
539: p_period_start => p_period_start
540: );
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',
543: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
544: ||' result l_duration = ' || l_duration);
545: END IF;

Line 542: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',

538: p_period_type => p_period_type,
539: p_period_start => p_period_start
540: );
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',
543: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
544: ||' result l_duration = ' || l_duration);
545: END IF;
546:

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

548: RAISE G_EXCEPTION_HALT_VALIDATION;
549: END IF;
550: l_unit_price := l_amount/l_duration; -- recalculaing unit price
551: l_start_date := total_billed_rec.date_billed_to+1;
552: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
553: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',
554: ' recalculated unit price l_unit_price = ' || l_unit_price);
555: END IF;
556:

Line 553: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',

549: END IF;
550: l_unit_price := l_amount/l_duration; -- recalculaing unit price
551: l_start_date := total_billed_rec.date_billed_to+1;
552: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
553: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',
554: ' recalculated unit price l_unit_price = ' || l_unit_price);
555: END IF;
556:
557: ELSE -- billed to => l end date, 100% billed cases

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

575: ELSE
576: l_unit_price := l_source_unit_price;
577: END IF;
578: l_start_date := lin_det_rec.start_date;
579: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
580: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.unbilled_case',
581: ' l_unit_price = ' || l_unit_price);
582: END IF;
583:

Line 580: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.unbilled_case',

576: l_unit_price := l_source_unit_price;
577: END IF;
578: l_start_date := lin_det_rec.start_date;
579: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
580: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.unbilled_case',
581: ' l_unit_price = ' || l_unit_price);
582: END IF;
583:
584: END IF;

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

600: p_source_uom => p_billing_uom,
601: p_period_type => p_period_type,
602: p_period_start => p_period_start
603: );
604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
605: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partially_billed_cases',
606: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
607: ||' result l_duration = ' || l_duration);
608: END IF;

Line 605: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partially_billed_cases',

601: p_period_type => p_period_type,
602: p_period_start => p_period_start
603: );
604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
605: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partially_billed_cases',
606: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
607: ||' result l_duration = ' || l_duration);
608: END IF;
609: IF nvl(l_duration,0) = 0 THEN

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

610: RAISE G_EXCEPTION_HALT_VALIDATION;
611: END IF;
612: --changed from l_quantity to l_duration
613: l_unit_price := l_amount/l_duration;
614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
615: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partailly_billed_cases',
616: ' returned unit price = ' || l_unit_price);
617: END IF;
618: Return nvl(l_unit_price*p_duration,0);

Line 615: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partailly_billed_cases',

611: END IF;
612: --changed from l_quantity to l_duration
613: l_unit_price := l_amount/l_duration;
614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
615: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partailly_billed_cases',
616: ' returned unit price = ' || l_unit_price);
617: END IF;
618: Return nvl(l_unit_price*p_duration,0);
619: ELSE -- billed to >= l end date, 100% billed cases

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

630: p_source_uom => p_billing_uom,
631: p_period_type => p_period_type,
632: p_period_start => p_period_start);
633:
634: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
635: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',
636: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
637: ||' result l_quantity = ' || l_quantity);
638: END IF;

Line 635: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',

631: p_period_type => p_period_type,
632: p_period_start => p_period_start);
633:
634: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
635: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',
636: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
637: ||' result l_quantity = ' || l_quantity);
638: END IF;
639:

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

643: --errorout_ad(' l_quantity '||l_quantity);
644: --errorout_ad(' l_amount '||l_amount);
645: l_unit_price := l_amount/l_quantity;
646: --errorout_ad(' l_unit_price '||l_unit_price);
647: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
648: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',
649: ' returned unit price = ' || l_unit_price);
650: END IF;
651:

Line 648: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',

644: --errorout_ad(' l_amount '||l_amount);
645: l_unit_price := l_amount/l_quantity;
646: --errorout_ad(' l_unit_price '||l_unit_price);
647: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
648: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',
649: ' returned unit price = ' || l_unit_price);
650: END IF;
651:
652: Return nvl(l_unit_price*p_duration,0);

Line 900: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

896:
897: IF p_invoice_rule_id IS NULL THEN
898: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'INVOICE ID NULL.');
899: x_return_status := 'E';
900: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
901: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
902: 'p_invoice_rule_id null');
903: END IF;
904: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 901: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',

897: IF p_invoice_rule_id IS NULL THEN
898: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'INVOICE ID NULL.');
899: x_return_status := 'E';
900: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
901: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
902: 'p_invoice_rule_id null');
903: END IF;
904: RAISE G_EXCEPTION_HALT_VALIDATION;
905: END IF;

Line 916: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

912:
913: If l_contract_Csr%Notfound then
914: Close l_contract_Csr;
915: x_return_status := 'E';
916: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
917: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
918: 'contract dtls not found. = ' || p_sll_tbl(p_sll_tbl.FIRST).chr_id);
919: END IF;
920: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 917: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',

913: If l_contract_Csr%Notfound then
914: Close l_contract_Csr;
915: x_return_status := 'E';
916: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
917: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
918: 'contract dtls not found. = ' || p_sll_tbl(p_sll_tbl.FIRST).chr_id);
919: END IF;
920: RAISE G_EXCEPTION_HALT_VALIDATION;
921: End If;

Line 930: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level

926: FETCH c_khr_csr INTO l_acct_rule_id;
927: IF c_khr_csr%NOTFOUND
928: THEN
929: CLOSE c_khr_csr;
930: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level
931: THEN
932: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
933: 'Accounting rule id not found for header id = ' || p_sll_tbl(p_sll_tbl.FIRST).chr_id);
934: END IF;

Line 932: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',

928: THEN
929: CLOSE c_khr_csr;
930: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level
931: THEN
932: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
933: 'Accounting rule id not found for header id = ' || p_sll_tbl(p_sll_tbl.FIRST).chr_id);
934: END IF;
935: RAISE G_EXCEPTION_HALT_VALIDATION;
936: END IF;

Line 947: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

943: p_chr_id => p_sll_tbl(p_sll_tbl.FIRST).chr_id);
944: IF l_currency_code IS NULL THEN
945: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
946: x_return_status := 'E';
947: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
948: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
949: 'currency code not found.');
950: END IF;
951: RETURN;

Line 948: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',

944: IF l_currency_code IS NULL THEN
945: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
946: x_return_status := 'E';
947: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
948: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
949: 'currency code not found.');
950: END IF;
951: RETURN;
952: END IF;

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

950: END IF;
951: RETURN;
952: END IF;
953:
954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
955:
956: fnd_log.STRING (fnd_log.level_statement,
957: G_MODULE_CURRENT || '.create_header_bill_sch.dtls',
958: 'currency_code = ' || l_currency_code

Line 956: fnd_log.STRING (fnd_log.level_statement,

952: END IF;
953:
954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
955:
956: fnd_log.STRING (fnd_log.level_statement,
957: G_MODULE_CURRENT || '.create_header_bill_sch.dtls',
958: 'currency_code = ' || l_currency_code
959: || ', p_invoice_rule_id = ' || p_invoice_rule_id
960: || ', p_billing_type = ' || p_billing_type

Line 997: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

993:
994: -----errorout_ad('Create_Stream_Level status = ' || x_return_status);
995: -----errorout_ad('TOTAL SLL COUNT for line'|| TO_CHAR(l_sll_out_tbl.COUNT));
996:
997: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
998: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_hdr_sll',
999: 'Create_Stream_Level(x_return_status = '||x_return_status
1000: ||', sll tbl out count = '||l_sll_out_tbl.count||')');
1001: END IF;

Line 998: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_hdr_sll',

994: -----errorout_ad('Create_Stream_Level status = ' || x_return_status);
995: -----errorout_ad('TOTAL SLL COUNT for line'|| TO_CHAR(l_sll_out_tbl.COUNT));
996:
997: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
998: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_hdr_sll',
999: 'Create_Stream_Level(x_return_status = '||x_return_status
1000: ||', sll tbl out count = '||l_sll_out_tbl.count||')');
1001: END IF;
1002:

Line 1027: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1023: x_return_status => x_return_status);
1024:
1025: -----errorout_ad('Create_Hdr_Level_elements status = ' || x_return_status);
1026:
1027: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1028: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_hdr_lvl',
1029: 'Create_Hdr_Level_elements(x_return_status = '||x_return_status
1030: ||', sll tbl out count passed = '||l_sll_out_tbl.count||')');
1031: END IF;

Line 1028: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_hdr_lvl',

1024:
1025: -----errorout_ad('Create_Hdr_Level_elements status = ' || x_return_status);
1026:
1027: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1028: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_hdr_lvl',
1029: 'Create_Hdr_Level_elements(x_return_status = '||x_return_status
1030: ||', sll tbl out count passed = '||l_sll_out_tbl.count||')');
1031: END IF;
1032:

Line 1098: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1094: p_invoice_rule_id => nvl(l_line_inv_id,p_invoice_rule_id),
1095: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
1096: x_return_status => x_return_status);
1097:
1098: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_line_bs',
1100: 'Create_Bill_Sch_Rules(x_return_status = '||x_return_status
1101: ||', line id = '||l_sll_tbl(l_sll_tbl.first).cle_id||')');
1102: END IF;

Line 1099: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_line_bs',

1095: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
1096: x_return_status => x_return_status);
1097:
1098: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.create_line_bs',
1100: 'Create_Bill_Sch_Rules(x_return_status = '||x_return_status
1101: ||', line id = '||l_sll_tbl(l_sll_tbl.first).cle_id||')');
1102: END IF;
1103:

Line 1125: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1121: p_cle_id => NULL,
1122: x_copy_bill_sch => x_bil_sch_out_tbl,
1123: x_return_status => x_return_status);
1124:
1125: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1126: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.hdr_bs_return',
1127: 'Copy_Bill_Sch(x_return_status = '||x_return_status
1128: ||', level element count = '|| x_bil_sch_out_tbl.count ||')');
1129: END IF;

Line 1126: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.hdr_bs_return',

1122: x_copy_bill_sch => x_bil_sch_out_tbl,
1123: x_return_status => x_return_status);
1124:
1125: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1126: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_header_bill_sch.hdr_bs_return',
1127: 'Copy_Bill_Sch(x_return_status = '||x_return_status
1128: ||', level element count = '|| x_bil_sch_out_tbl.count ||')');
1129: END IF;
1130:

Line 1135: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

1131: -----errorout_ad('Copy_Bill_Sch = ' || x_return_status);
1132:
1133: EXCEPTION
1134: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1135: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1136: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
1137: 'G_EXCEPTION_HALT_VALIDATION');
1138: END IF;
1139:

Line 1136: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',

1132:
1133: EXCEPTION
1134: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1135: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1136: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_header_bill_sch.EXCEPTION',
1137: 'G_EXCEPTION_HALT_VALIDATION');
1138: END IF;
1139:
1140: l_currency_code := NULL;

Line 1145: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

1141: l_header_billing := NULL;
1142:
1143: WHEN OTHERS THEN
1144:
1145: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
1146: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_header_bill_sch.UNEXPECTED',
1147: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1148: END IF;
1149: l_currency_code := NULL;

Line 1146: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_header_bill_sch.UNEXPECTED',

1142:
1143: WHEN OTHERS THEN
1144:
1145: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
1146: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_header_bill_sch.UNEXPECTED',
1147: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1148: END IF;
1149: l_currency_code := NULL;
1150: l_header_billing := NULL;

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

1279: x_return_status := 'S';
1280: RETURN;
1281: END IF;
1282:
1283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1284:
1285: fnd_log.STRING (fnd_log.level_statement,
1286: G_MODULE_CURRENT || '.create_bill_sch_rules.passed_val',
1287: 'p_sll_tbl count = ' || p_sll_tbl.count

Line 1285: fnd_log.STRING (fnd_log.level_statement,

1281: END IF;
1282:
1283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1284:
1285: fnd_log.STRING (fnd_log.level_statement,
1286: G_MODULE_CURRENT || '.create_bill_sch_rules.passed_val',
1287: 'p_sll_tbl count = ' || p_sll_tbl.count
1288: || ', p_invoice_rule_id = ' || p_invoice_rule_id
1289: || ', p_billing_type = ' || p_billing_type

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

1386: -- End partial period computation logic
1387: -- Date 09-MAY-2005
1388: -------------------------------------------------------------------------
1389:
1390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1391:
1392: fnd_log.STRING (fnd_log.level_statement,
1393: G_MODULE_CURRENT || '.create_bill_sch_rules.line_dtls',
1394: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 1392: fnd_log.STRING (fnd_log.level_statement,

1388: -------------------------------------------------------------------------
1389:
1390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1391:
1392: fnd_log.STRING (fnd_log.level_statement,
1393: G_MODULE_CURRENT || '.create_bill_sch_rules.line_dtls',
1394: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
1395: || ', id = ' || l_line_rec.id
1396: || ', lse_id = ' || l_line_rec.lse_id

Line 1449: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1445:
1446: -----errorout_ad('TOTAL SLL COUNT for line'|| TO_CHAR(l_sll_out_tbl.COUNT));
1447: -----errorout_ad('Create_Stream_Level = ' || x_return_status);
1448:
1449: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1450: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.line_sll',
1451: 'Create_Stream_Level(x_return_status = '||x_return_status
1452: ||', l_sll_out_tbl count = '||l_sll_out_tbl.count||')');
1453: END IF;

Line 1450: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.line_sll',

1446: -----errorout_ad('TOTAL SLL COUNT for line'|| TO_CHAR(l_sll_out_tbl.COUNT));
1447: -----errorout_ad('Create_Stream_Level = ' || x_return_status);
1448:
1449: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1450: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.line_sll',
1451: 'Create_Stream_Level(x_return_status = '||x_return_status
1452: ||', l_sll_out_tbl count = '||l_sll_out_tbl.count||')');
1453: END IF;
1454:

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

1462: x_return_status := 'E';
1463: RAISE G_EXCEPTION_HALT_VALIDATION;
1464: END IF;
1465:
1466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1467:
1468: fnd_log.STRING (fnd_log.level_statement,
1469: G_MODULE_CURRENT || '.create_bill_sch_rules.copy_flag',
1470: 'sll amt to be adjusted flag = ' || p_sll_tbl(p_sll_tbl.FIRST).comments

Line 1468: fnd_log.STRING (fnd_log.level_statement,

1464: END IF;
1465:
1466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1467:
1468: fnd_log.STRING (fnd_log.level_statement,
1469: G_MODULE_CURRENT || '.create_bill_sch_rules.copy_flag',
1470: 'sll amt to be adjusted flag = ' || p_sll_tbl(p_sll_tbl.FIRST).comments
1471: );
1472: END IF;

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

1503: WHERE date_completed IS NULL
1504: AND cle_id = l_Line_Csr_Rec.id;
1505:
1506:
1507: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1508:
1509: fnd_log.STRING (fnd_log.level_statement,
1510: G_MODULE_CURRENT || '.create_bill_sch_rules.del_lvl_ele',
1511: 'unbilled lvl element deleted = ' || sql%rowcount

Line 1509: fnd_log.STRING (fnd_log.level_statement,

1505:
1506:
1507: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1508:
1509: fnd_log.STRING (fnd_log.level_statement,
1510: G_MODULE_CURRENT || '.create_bill_sch_rules.del_lvl_ele',
1511: 'unbilled lvl element deleted = ' || sql%rowcount
1512: );
1513: END IF;

Line 1537: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1533: -------------------------------------------------------------------------
1534:
1535: -----errorout_ad('Create_Subcription_LvlEle status = ' || x_return_status);
1536:
1537: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1538: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.lvl_ele',
1539: 'Create_Subcription_LvlEle(x_return_status = '||x_return_status
1540: ||', l_sll_out_tbl passed = '||l_sll_out_tbl.count||')');
1541: END IF;

Line 1538: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.lvl_ele',

1534:
1535: -----errorout_ad('Create_Subcription_LvlEle status = ' || x_return_status);
1536:
1537: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1538: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.lvl_ele',
1539: 'Create_Subcription_LvlEle(x_return_status = '||x_return_status
1540: ||', l_sll_out_tbl passed = '||l_sll_out_tbl.count||')');
1541: END IF;
1542:

Line 1581: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1577: x_return_status => x_return_status);
1578:
1579: -----errorout_ad('Create_Level_elements status = ' || x_return_status);
1580:
1581: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1582: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.lvl_ele',
1583: 'Create_Level_elements(x_return_status = '||x_return_status
1584: ||', term dt passed = ' || l_line_term_dt
1585: ||', l_sll_out_tbl passed = '||l_sll_out_tbl.count||')');

Line 1582: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.lvl_ele',

1578:
1579: -----errorout_ad('Create_Level_elements status = ' || x_return_status);
1580:
1581: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1582: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.lvl_ele',
1583: 'Create_Level_elements(x_return_status = '||x_return_status
1584: ||', term dt passed = ' || l_line_term_dt
1585: ||', l_sll_out_tbl passed = '||l_sll_out_tbl.count||')');
1586: END IF;

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

1611: l_index := l_index + 1;
1612: -------errorout_ad('l_top_bs_tbl count = ' || l_top_bs_tbl.count);
1613: END LOOP;
1614:
1615: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1616:
1617: fnd_log.STRING (fnd_log.level_statement,
1618: G_MODULE_CURRENT || '.create_bill_sch_rules.top_bs_count',
1619: 'l_top_bs_tblcount = ' || l_top_bs_tbl.count

Line 1617: fnd_log.STRING (fnd_log.level_statement,

1613: END LOOP;
1614:
1615: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1616:
1617: fnd_log.STRING (fnd_log.level_statement,
1618: G_MODULE_CURRENT || '.create_bill_sch_rules.top_bs_count',
1619: 'l_top_bs_tblcount = ' || l_top_bs_tbl.count
1620: );
1621: END IF;

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

1654: else
1655: l_cp_term_dt := l_subline_csr_rec.cp_term_dt;
1656: END IF; ---end of full credit chk
1657:
1658: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1659:
1660: fnd_log.STRING (fnd_log.level_statement,
1661: G_MODULE_CURRENT || '.create_bill_sch_rules.cp_dtls',
1662: 'l_cp_term_dt = ' || l_cp_term_dt

Line 1660: fnd_log.STRING (fnd_log.level_statement,

1656: END IF; ---end of full credit chk
1657:
1658: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1659:
1660: fnd_log.STRING (fnd_log.level_statement,
1661: G_MODULE_CURRENT || '.create_bill_sch_rules.cp_dtls',
1662: 'l_cp_term_dt = ' || l_cp_term_dt
1663: || ', id = ' || l_cp_rec.cp_id
1664: || ', lse_id = ' || l_line_rec.lse_id

Line 1704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1700: x_return_status => x_return_status,
1701: x_msg_count => l_msg_count,
1702: x_msg_data => l_msg_data);
1703:
1704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.del_bs',
1706: 'Del_line_sll_lvl(x_return_status = '||x_return_status
1707: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1708: END IF;

Line 1705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.del_bs',

1701: x_msg_count => l_msg_count,
1702: x_msg_data => l_msg_data);
1703:
1704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.del_bs',
1706: 'Del_line_sll_lvl(x_return_status = '||x_return_status
1707: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1708: END IF;
1709:

Line 1738: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1734: p_period_start => l_period_start,
1735: p_period_type => l_period_type,
1736: x_return_status => x_return_status );
1737:
1738: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1739: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.cp_bs',
1740: 'Bill_Sch_Cp(x_return_status = '||x_return_status
1741: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1742: END IF;

Line 1739: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.cp_bs',

1735: p_period_type => l_period_type,
1736: x_return_status => x_return_status );
1737:
1738: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1739: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.cp_bs',
1740: 'Bill_Sch_Cp(x_return_status = '||x_return_status
1741: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1742: END IF;
1743:

Line 1767: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1763: x_return_status => x_return_status,
1764: x_msg_count => l_msg_count,
1765: x_msg_data => l_msg_data);
1766:
1767: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1768: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.del_bs',
1769: 'Del_line_sll_lvl(x_return_status = '||x_return_status
1770: ||'sll count >0 and not same effectivity'
1771: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');

Line 1768: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.del_bs',

1764: x_msg_count => l_msg_count,
1765: x_msg_data => l_msg_data);
1766:
1767: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1768: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.del_bs',
1769: 'Del_line_sll_lvl(x_return_status = '||x_return_status
1770: ||'sll count >0 and not same effectivity'
1771: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1772: END IF;

Line 1789: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1785: UPDATE oks_k_lines_b
1786: SET billing_schedule_type = 'P'
1787: WHERE cle_id = l_subline_csr_rec.subline_id;
1788:
1789: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1790: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_billtype',
1791: 'sll count >0 and not same effectivity'
1792: || 'updated sub line billing type to P = ' || sql%rowcount
1793: );

Line 1790: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_billtype',

1786: SET billing_schedule_type = 'P'
1787: WHERE cle_id = l_subline_csr_rec.subline_id;
1788:
1789: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1790: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_billtype',
1791: 'sll count >0 and not same effectivity'
1792: || 'updated sub line billing type to P = ' || sql%rowcount
1793: );
1794: END IF;

Line 1828: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1824: p_period_start => l_period_start,
1825: p_period_type => l_period_type,
1826: x_return_status => x_return_status );
1827:
1828: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1829: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.cp_bs',
1830: 'Bill_Sch_Cp(x_return_status = '||x_return_status
1831: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1832: END IF;

Line 1829: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.cp_bs',

1825: p_period_type => l_period_type,
1826: x_return_status => x_return_status );
1827:
1828: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1829: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.cp_bs',
1830: 'Bill_Sch_Cp(x_return_status = '||x_return_status
1831: ||', cp id passed = '||l_subline_csr_rec.subline_id ||')');
1832: END IF;
1833:

Line 1860: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

1856: x_msg_data => l_msg_data,
1857: p_letv_tbl => l_top_bs_tbl,
1858: x_letv_tbl => l_lvl_ele_tbl_out);
1859:
1860: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1861: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_top_bs',
1862: 'OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(x_return_status = '||x_return_status
1863: ||', tbl count = '||l_lvl_ele_tbl_out.count ||')');
1864: END IF;

Line 1861: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_top_bs',

1857: p_letv_tbl => l_top_bs_tbl,
1858: x_letv_tbl => l_lvl_ele_tbl_out);
1859:
1860: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
1861: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_rules.update_top_bs',
1862: 'OKS_BILL_LEVEL_ELEMENTS_PVT.update_row(x_return_status = '||x_return_status
1863: ||', tbl count = '||l_lvl_ele_tbl_out.count ||')');
1864: END IF;
1865:

Line 1876: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

1872:
1873: EXCEPTION
1874: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1875:
1876: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1877: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_rules.EXCEPTION',
1878: 'G_EXCEPTION_HALT_VALIDATION');
1879: END IF;
1880:

Line 1877: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_rules.EXCEPTION',

1873: EXCEPTION
1874: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1875:
1876: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1877: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_rules.EXCEPTION',
1878: 'G_EXCEPTION_HALT_VALIDATION');
1879: END IF;
1880:
1881: l_currency_code := NULL;

Line 1886: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

1882: l_header_billing := NULL;
1883:
1884: WHEN OTHERS THEN
1885:
1886: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
1887: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_rules.UNEXPECTED',
1888: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1889: END IF;
1890: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 1887: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_rules.UNEXPECTED',

1883:
1884: WHEN OTHERS THEN
1885:
1886: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
1887: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_rules.UNEXPECTED',
1888: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1889: END IF;
1890: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
1891: p_msg_name => G_UNEXPECTED_ERROR,

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

1968: --p_subline call can have 3 values Y for sub line, N - top line, H - header
1969:
1970: -----errorout_ad('p_subline_call = ' || p_subline_call);
1971:
1972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1973:
1974: fnd_log.STRING (fnd_log.level_statement,
1975: G_MODULE_CURRENT || '.create_stream_level.called',
1976: ' p_subline_call = ' || p_subline_call );

Line 1974: fnd_log.STRING (fnd_log.level_statement,

1970: -----errorout_ad('p_subline_call = ' || p_subline_call);
1971:
1972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1973:
1974: fnd_log.STRING (fnd_log.level_statement,
1975: G_MODULE_CURRENT || '.create_stream_level.called',
1976: ' p_subline_call = ' || p_subline_call );
1977: END IF;
1978:

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

2173: l_strm_lvl_tbl_in(1).creation_date := SYSDATE;
2174: l_strm_lvl_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
2175: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;
2176:
2177: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2178:
2179: fnd_log.STRING (fnd_log.level_statement,
2180: G_MODULE_CURRENT || '.create_stream_level.sll_dtls',
2181: ' line id = ' || l_strm_lvl_tbl_in(1).cle_id

Line 2179: fnd_log.STRING (fnd_log.level_statement,

2175: l_strm_lvl_tbl_in(1).last_update_date := SYSDATE;
2176:
2177: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2178:
2179: fnd_log.STRING (fnd_log.level_statement,
2180: G_MODULE_CURRENT || '.create_stream_level.sll_dtls',
2181: ' line id = ' || l_strm_lvl_tbl_in(1).cle_id
2182: || ', chr_id = ' || l_strm_lvl_tbl_in(1).chr_id
2183: || ', start date = ' || l_strm_lvl_tbl_in(1).start_date

Line 2206: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2202: x_msg_data => l_msg_data,
2203: p_sllv_tbl => l_strm_lvl_tbl_in,
2204: x_sllv_tbl => l_strm_lvl_tbl_out);
2205:
2206: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2207: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',
2208: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
2209: ||', sll id created = '||l_strm_lvl_tbl_out(1).id ||')');
2210: END IF;

Line 2207: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',

2203: p_sllv_tbl => l_strm_lvl_tbl_in,
2204: x_sllv_tbl => l_strm_lvl_tbl_out);
2205:
2206: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2207: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',
2208: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
2209: ||', sll id created = '||l_strm_lvl_tbl_out(1).id ||')');
2210: END IF;
2211:

Line 2235: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2231: x_msg_data => l_msg_data,
2232: p_sllv_tbl => l_strm_lvl_tbl_in,
2233: x_sllv_tbl => l_strm_lvl_tbl_out);
2234:
2235: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2236: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',
2237: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status
2238: ||', sll id updated = '||l_strm_lvl_tbl_out(1).id ||')');
2239: END IF;

Line 2236: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',

2232: p_sllv_tbl => l_strm_lvl_tbl_in,
2233: x_sllv_tbl => l_strm_lvl_tbl_out);
2234:
2235: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2236: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',
2237: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status
2238: ||', sll id updated = '||l_strm_lvl_tbl_out(1).id ||')');
2239: END IF;
2240:

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

2262: x_sll_out_tbl(l_tbl_count).Amount := l_strm_lvl_tbl_out(1).level_amount;
2263: x_sll_out_tbl(l_tbl_count).invoice_offset_days := l_strm_lvl_tbl_out(1).invoice_offset_days;
2264: x_sll_out_tbl(l_tbl_count).Interface_offset_days := l_strm_lvl_tbl_out(1).interface_offset_days;
2265:
2266: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2267:
2268: fnd_log.STRING (fnd_log.level_statement,
2269: G_MODULE_CURRENT || '.create_stream_level.top_sll_dtls',
2270: ' sll id = ' || x_sll_out_tbl(l_tbl_count).Id

Line 2268: fnd_log.STRING (fnd_log.level_statement,

2264: x_sll_out_tbl(l_tbl_count).Interface_offset_days := l_strm_lvl_tbl_out(1).interface_offset_days;
2265:
2266: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2267:
2268: fnd_log.STRING (fnd_log.level_statement,
2269: G_MODULE_CURRENT || '.create_stream_level.top_sll_dtls',
2270: ' sll id = ' || x_sll_out_tbl(l_tbl_count).Id
2271: || ', start date = ' || x_sll_out_tbl(l_tbl_count).Dt_start
2272: );

Line 2317: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2313: p_period_type => p_period_type,
2314: p_sll_prorated_tab => l_sll_prorate_tbl,
2315: x_return_status => x_return_status);
2316:
2317: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2318: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.prorate',
2319: 'Calculate_sll_amount(x_return_status = '||x_return_status
2320: ||', l_sll_prorate_tbl count = '|| l_sll_prorate_tbl.count ||')');
2321: END IF;

Line 2318: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.prorate',

2314: p_sll_prorated_tab => l_sll_prorate_tbl,
2315: x_return_status => x_return_status);
2316:
2317: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2318: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.prorate',
2319: 'Calculate_sll_amount(x_return_status = '||x_return_status
2320: ||', l_sll_prorate_tbl count = '|| l_sll_prorate_tbl.count ||')');
2321: END IF;
2322:

Line 2348: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

2344:
2345:
2346: EXCEPTION
2347: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2348: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2349: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_stream_level.EXCEPTION',
2350: 'G_EXCEPTION_HALT_VALIDATION');
2351: END IF;
2352: x_return_status := 'E';

Line 2349: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_stream_level.EXCEPTION',

2345:
2346: EXCEPTION
2347: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2348: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2349: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_stream_level.EXCEPTION',
2350: 'G_EXCEPTION_HALT_VALIDATION');
2351: END IF;
2352: x_return_status := 'E';
2353:

Line 2355: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

2351: END IF;
2352: x_return_status := 'E';
2353:
2354: WHEN OTHERS THEN
2355: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2356: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',
2357: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2358: END IF;
2359:

Line 2356: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',

2352: x_return_status := 'E';
2353:
2354: WHEN OTHERS THEN
2355: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2356: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',
2357: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2358: END IF;
2359:
2360: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 2496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2492: -- End partial period computation logic
2493: -- Date 09-MAY-2005
2494: -------------------------------------------------------------------------
2495:
2496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.sll',
2498: 'Create_Stream_Level(x_return_status = '||x_return_status
2499: ||', l_cp_sll_out_tbl count = '|| l_cp_sll_out_tbl.count ||')');
2500: END IF;

Line 2497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.sll',

2493: -- Date 09-MAY-2005
2494: -------------------------------------------------------------------------
2495:
2496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.sll',
2498: 'Create_Stream_Level(x_return_status = '||x_return_status
2499: ||', l_cp_sll_out_tbl count = '|| l_cp_sll_out_tbl.count ||')');
2500: END IF;
2501:

Line 2528: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2524: p_period_start => p_period_start,
2525: p_period_type => p_period_type,
2526: x_return_status => x_return_status);
2527:
2528: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2529: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.lvl_ele',
2530: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
2531: ||', p_term_dt passed = '|| p_term_dt ||')');
2532: END IF;

Line 2529: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.lvl_ele',

2525: p_period_type => p_period_type,
2526: x_return_status => x_return_status);
2527:
2528: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2529: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.lvl_ele',
2530: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
2531: ||', p_term_dt passed = '|| p_term_dt ||')');
2532: END IF;
2533:

Line 2540: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

2536: END IF;
2537:
2538: EXCEPTION
2539: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2540: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2541: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',
2542: 'G_EXCEPTION_HALT_VALIDATION');
2543: END IF;
2544:

Line 2541: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',

2537:
2538: EXCEPTION
2539: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2540: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2541: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',
2542: 'G_EXCEPTION_HALT_VALIDATION');
2543: END IF;
2544:
2545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2552: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

2548: RAISE OKC_API.G_EXCEPTION_ERROR;
2549: END IF;
2550: WHEN OTHERS THEN
2551:
2552: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2553: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',
2554: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2555: END IF;
2556:

Line 2553: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',

2549: END IF;
2550: WHEN OTHERS THEN
2551:
2552: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2553: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',
2554: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2555: END IF;
2556:
2557: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

2755: x_last_cycle_dt := NULL;
2756: x_next_cycle_dt := p_sll_dt_start;
2757: l_index := 0;
2758:
2759: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2760:
2761: fnd_log.STRING (fnd_log.level_statement,
2762: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.dtls',
2763: 'sll id = ' || p_sll_id

Line 2761: fnd_log.STRING (fnd_log.level_statement,

2757: l_index := 0;
2758:
2759: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2760:
2761: fnd_log.STRING (fnd_log.level_statement,
2762: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.dtls',
2763: 'sll id = ' || p_sll_id
2764: ||', sll st dt = ' || p_sll_dt_start
2765: );

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

2926: x_next_cycle_dt := l_cp_bs_tbl(l_cp_bs_tbl.LAST ).date_end + 1;
2927: -----errorout_ad('NEXT DATE = ' || x_next_cycle_dt);
2928: END IF;
2929:
2930: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2931:
2932: fnd_log.STRING (fnd_log.level_statement,
2933: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.out',
2934: 'x_next_cycle_dt = ' || x_next_cycle_dt);

Line 2932: fnd_log.STRING (fnd_log.level_statement,

2928: END IF;
2929:
2930: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2931:
2932: fnd_log.STRING (fnd_log.level_statement,
2933: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.out',
2934: 'x_next_cycle_dt = ' || x_next_cycle_dt);
2935: END IF;
2936:

Line 2940: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

2936:
2937: Exception
2938:
2939: WHEN OTHERS then
2940: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2941: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Check_Existing_Lvlelement.UNEXPECTED',
2942: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2943: END IF;
2944: x_return_status := 'E';

Line 2941: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Check_Existing_Lvlelement.UNEXPECTED',

2937: Exception
2938:
2939: WHEN OTHERS then
2940: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2941: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Check_Existing_Lvlelement.UNEXPECTED',
2942: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2943: END IF;
2944: x_return_status := 'E';
2945:

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

3027: ELSE
3028: l_adjusted_amount := l_round_cycle_amt;
3029: END IF;
3030:
3031: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3032:
3033: fnd_log.STRING (fnd_log.level_statement,
3034: G_MODULE_CURRENT || '.Find_Adjusted_Amount.info',
3035: 'l_adjusted_amount = ' || l_adjusted_amount

Line 3033: fnd_log.STRING (fnd_log.level_statement,

3029: END IF;
3030:
3031: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3032:
3033: fnd_log.STRING (fnd_log.level_statement,
3034: G_MODULE_CURRENT || '.Find_Adjusted_Amount.info',
3035: 'l_adjusted_amount = ' || l_adjusted_amount
3036: ||', line id = ' || p_line_id
3037: );

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

3144: ELSE
3145: l_line_end_date := TRUNC(nvl((p_term_dt - 1), p_line_rec.line_end_dt));
3146: END IF;
3147:
3148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3149:
3150: fnd_log.STRING (fnd_log.level_statement,
3151: G_MODULE_CURRENT || '.Create_Level_elements.info',
3152: 'l_chk_round_adjustment = ' || l_chk_round_adjustment

Line 3150: fnd_log.STRING (fnd_log.level_statement,

3146: END IF;
3147:
3148: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3149:
3150: fnd_log.STRING (fnd_log.level_statement,
3151: G_MODULE_CURRENT || '.Create_Level_elements.info',
3152: 'l_chk_round_adjustment = ' || l_chk_round_adjustment
3153: ||', l_line_end_date (up to lvl ele) = ' || l_line_end_date
3154: ||', l_bill_type = ' || l_bill_type

Line 3165: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3161:
3162: Delete_lvl_element(p_cle_id => p_line_rec.id,
3163: x_return_status => x_return_status);
3164:
3165: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3166: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.del_ele',
3167: 'Delete_lvl_element(x_return_status = '||x_return_status
3168: ||', line id passed = '|| p_line_rec.id ||')');
3169: END IF;

Line 3166: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.del_ele',

3162: Delete_lvl_element(p_cle_id => p_line_rec.id,
3163: x_return_status => x_return_status);
3164:
3165: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3166: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.del_ele',
3167: 'Delete_lvl_element(x_return_status = '||x_return_status
3168: ||', line id passed = '|| p_line_rec.id ||')');
3169: END IF;
3170:

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

3180: ---if (line terminated - 1) < line_start_dt
3181: IF TRUNC(p_line_rec.line_start_dt) > TRUNC(l_line_end_date) or
3182: TRUNC( p_line_rec.line_start_dt) > trunc(nvl((p_term_dt - 1),p_line_rec.line_end_dt)) THEN
3183:
3184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3185:
3186: fnd_log.STRING (fnd_log.level_statement,
3187: G_MODULE_CURRENT || '.Create_Level_elements.chk',
3188: 'BS not created as line start dt > line en dt');

Line 3186: fnd_log.STRING (fnd_log.level_statement,

3182: TRUNC( p_line_rec.line_start_dt) > trunc(nvl((p_term_dt - 1),p_line_rec.line_end_dt)) THEN
3183:
3184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3185:
3186: fnd_log.STRING (fnd_log.level_statement,
3187: G_MODULE_CURRENT || '.Create_Level_elements.chk',
3188: 'BS not created as line start dt > line en dt');
3189: END IF;
3190:

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

3259:
3260: l_next_cycle_dt := l_next_cycle_dt + 1;
3261: END IF; --next cycle dt is null
3262:
3263: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3264:
3265: fnd_log.STRING (fnd_log.level_statement,
3266: G_MODULE_CURRENT || '.Create_Level_elements.loop_info',
3267: 'L_next_cycle_dt = ' || L_next_cycle_dt

Line 3265: fnd_log.STRING (fnd_log.level_statement,

3261: END IF; --next cycle dt is null
3262:
3263: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3264:
3265: fnd_log.STRING (fnd_log.level_statement,
3266: G_MODULE_CURRENT || '.Create_Level_elements.loop_info',
3267: 'L_next_cycle_dt = ' || L_next_cycle_dt
3268: ||', last date = ' || l_last_cycle_dt
3269: ||', uom = ' || p_sll_tbl(l_line_sll_counter).uom

Line 3285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3281: x_return_status => x_return_status,
3282: x_quantity => l_uom_quantity ,
3283: x_timeunit => l_tce_code);
3284:
3285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',
3287: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status
3288: ||', x_timeunit = ' || l_tce_code
3289: ||', x_quantity = '|| l_uom_quantity ||')');

Line 3286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',

3282: x_quantity => l_uom_quantity ,
3283: x_timeunit => l_tce_code);
3284:
3285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',
3287: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status
3288: ||', x_timeunit = ' || l_tce_code
3289: ||', x_quantity = '|| l_uom_quantity ||')');
3290: END IF;

Line 3310: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3306:
3307: --errorout_ad('shd not enter Get_Constant_sll_Amount = ' || x_return_status);
3308:
3309:
3310: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3311: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.sll_amt',
3312: 'Get_Constant_sll_Amount(x_return_status = '||x_return_status
3313: ||', sll amt = ' || l_constant_sll_amt
3314: ||', l_remaining_amt passed = '|| l_remaining_amt ||')');

Line 3311: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.sll_amt',

3307: --errorout_ad('shd not enter Get_Constant_sll_Amount = ' || x_return_status);
3308:
3309:
3310: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3311: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.sll_amt',
3312: 'Get_Constant_sll_Amount(x_return_status = '||x_return_status
3313: ||', sll amt = ' || l_constant_sll_amt
3314: ||', l_remaining_amt passed = '|| l_remaining_amt ||')');
3315: END IF;

Line 3365: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

3361: -- Developer Mani Choudhary
3362: -- Date 09-MAY-2005
3363: -- Added two new parameters p_period_start and p_period_type
3364: -- Start - Modified by PMALLARA - Bug #3992530
3365: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
3366: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3367: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
3368: ||'period start = ' || p_period_start
3369: ||', period type = ' || p_period_type);

Line 3366: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',

3362: -- Date 09-MAY-2005
3363: -- Added two new parameters p_period_start and p_period_type
3364: -- Start - Modified by PMALLARA - Bug #3992530
3365: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
3366: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3367: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
3368: ||'period start = ' || p_period_start
3369: ||', period type = ' || p_period_type);
3370: END IF;

Line 3386: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3382: Strm_Start_Date => Strm_Start_Date);
3383: -- End - Modified by PMALLARA - Bug #3992530
3384:
3385:
3386: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3387: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3388: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3389: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3390: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period

Line 3387: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',

3383: -- End - Modified by PMALLARA - Bug #3992530
3384:
3385:
3386: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3387: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3388: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3389: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3390: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3391: ||', cycle_start_date = '|| l_next_cycle_dt ||')');

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

3462: p_source_uom => l_fnd_lvl_in_rec.tuom ,
3463: p_period_type => p_period_type,
3464: p_period_start => p_period_start);
3465:
3466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3467: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3468: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start
3469: ||' result l_quantity = ' || l_quantity);
3470: END IF;

Line 3467: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',

3463: p_period_type => p_period_type,
3464: p_period_start => p_period_start);
3465:
3466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3467: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3468: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start
3469: ||' result l_quantity = ' || l_quantity);
3470: END IF;
3471:

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

3475:
3476:
3477: l_adjusted_amount :=p_sll_tbl(l_line_sll_counter).amount*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
3478:
3479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3480: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3481: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '
3482: ||' result l_adjusted_amount = ' || l_adjusted_amount);
3483: END IF;

Line 3480: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',

3476:
3477: l_adjusted_amount :=p_sll_tbl(l_line_sll_counter).amount*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
3478:
3479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3480: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3481: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '
3482: ||' result l_adjusted_amount = ' || l_adjusted_amount);
3483: END IF;
3484: --mchoudha fix for bug#5200003

Line 3579: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3575: p_cycle_end_dt => p_Line_rec.line_end_dt,
3576: p_amount => nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0));
3577:
3578:
3579: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3580: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',
3581: 'find_term_amt(x_return_status = '||x_return_status
3582: ||', l_term_amt = ' || l_term_amt
3583: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start

Line 3580: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',

3576: p_amount => nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0));
3577:
3578:
3579: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3580: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',
3581: 'find_term_amt(x_return_status = '||x_return_status
3582: ||', l_term_amt = ' || l_term_amt
3583: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start
3584: ||', p_term_dt = ' || p_Line_rec.line_end_dt

Line 3595: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3591: p_term_dt => p_term_dt,
3592: p_cycle_end_dt => l_fnd_lvl_out_rec.next_cycle_date - 1,
3593: p_amount => nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0));
3594:
3595: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3596: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',
3597: 'find_term_amt(x_return_status = '||x_return_status
3598: ||', l_term_amt = ' || l_term_amt
3599: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start

Line 3596: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',

3592: p_cycle_end_dt => l_fnd_lvl_out_rec.next_cycle_date - 1,
3593: p_amount => nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0));
3594:
3595: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3596: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',
3597: 'find_term_amt(x_return_status = '||x_return_status
3598: ||', l_term_amt = ' || l_term_amt
3599: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start
3600: ||', p_term_dt = ' || p_Line_rec.line_end_dt

Line 3603: END IF; -- fnd_log.level_event >= fnd_log.g_current_runtime_level

3599: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start
3600: ||', p_term_dt = ' || p_Line_rec.line_end_dt
3601: ||', lvl amt = ' || nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0)
3602: ||', p_cycle_end_dt = '|| l_fnd_lvl_out_rec.next_cycle_date - 1 ||')');
3603: END IF; -- fnd_log.level_event >= fnd_log.g_current_runtime_level
3604: END IF; -- TRUNC(l_fnd_lvl_out_rec.next_cycle_date - 1 ) > p_Line_rec.line_end_dt
3605:
3606:
3607: l_lvl_ele_tbl_in(l_tbl_seq).amount := l_term_amt;

Line 3653: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3649: x_msg_data => l_msg_data,
3650: p_letv_tbl => l_lvl_ele_tbl_in,
3651: x_letv_tbl => l_lvl_ele_tbl_out);
3652:
3653: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3654: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',
3655: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3656: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3657: END IF;

Line 3654: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',

3650: p_letv_tbl => l_lvl_ele_tbl_in,
3651: x_letv_tbl => l_lvl_ele_tbl_out);
3652:
3653: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3654: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',
3655: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3656: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3657: END IF;
3658:

Line 3677: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

3673: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3674: x_return_status := G_RET_STS_ERROR;
3675: WHEN OTHERS THEN
3676:
3677: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3678: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',
3679: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3680: END IF;
3681: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 3678: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',

3674: x_return_status := G_RET_STS_ERROR;
3675: WHEN OTHERS THEN
3676:
3677: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3678: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',
3679: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3680: END IF;
3681: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3682: p_msg_name => G_UNEXPECTED_ERROR,

Line 3750: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3746: Del_hdr_lvl_element(p_hdr_id => p_hdr_rec.id,
3747: x_return_status => x_return_status);
3748:
3749:
3750: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3751: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Hdr_Level_elements.del_ele',
3752: 'Del_hdr_lvl_element(x_return_status = '||x_return_status
3753: ||', p_hdr_id passed = '||p_hdr_rec.id ||')');
3754: END IF;

Line 3751: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Hdr_Level_elements.del_ele',

3747: x_return_status => x_return_status);
3748:
3749:
3750: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3751: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Hdr_Level_elements.del_ele',
3752: 'Del_hdr_lvl_element(x_return_status = '||x_return_status
3753: ||', p_hdr_id passed = '||p_hdr_rec.id ||')');
3754: END IF;
3755:

Line 3814: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3810: p_period_type => p_period_type,
3811: Strm_Start_Date => Strm_Start_Date);
3812: -- End - Modified by PMALLARA - Bug #3992530
3813:
3814: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3815: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',
3816: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3817: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3818: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period

Line 3815: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',

3811: Strm_Start_Date => Strm_Start_Date);
3812: -- End - Modified by PMALLARA - Bug #3992530
3813:
3814: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3815: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',
3816: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3817: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3818: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3819: ||', cycle_start_date = '|| l_next_cycle_dt ||')');

Line 3903: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

3899: x_msg_data => l_msg_data,
3900: p_letv_tbl => l_lvl_ele_tbl_in,
3901: x_letv_tbl => l_lvl_ele_tbl_out);
3902:
3903: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3904: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',
3905: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3906: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3907: END IF;

Line 3904: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',

3900: p_letv_tbl => l_lvl_ele_tbl_in,
3901: x_letv_tbl => l_lvl_ele_tbl_out);
3902:
3903: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3904: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',
3905: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3906: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3907: END IF;
3908:

Line 3926: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

3922:
3923:
3924: EXCEPTION
3925: WHEN OTHERS THEN
3926: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3927: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',
3928: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3929: END IF;
3930: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 3927: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',

3923:
3924: EXCEPTION
3925: WHEN OTHERS THEN
3926: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3927: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',
3928: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3929: END IF;
3930: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3931: p_msg_name => G_UNEXPECTED_ERROR,

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

4257: UPDATE oks_stream_levels_b
4258: set level_amount = l_strm_lvl_tbl_in(i).level_amount
4259: WHERE id = l_strm_lvl_tbl_in(i).id;
4260:
4261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4262:
4263: fnd_log.STRING (fnd_log.level_statement,
4264: G_MODULE_CURRENT || '.update_sll_amount.update',
4265: 'update sll id = ' || l_strm_lvl_tbl_in(i).id

Line 4263: fnd_log.STRING (fnd_log.level_statement,

4259: WHERE id = l_strm_lvl_tbl_in(i).id;
4260:
4261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4262:
4263: fnd_log.STRING (fnd_log.level_statement,
4264: G_MODULE_CURRENT || '.update_sll_amount.update',
4265: 'update sll id = ' || l_strm_lvl_tbl_in(i).id
4266: ||', amt = ' || l_strm_lvl_tbl_in(i).level_amount
4267: );

Line 4274: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

4270: END IF; ---sll tbl count chk
4271:
4272: EXCEPTION
4273: WHEN OTHERS THEN
4274: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4275: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',
4276: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4277: END IF;
4278: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 4275: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',

4271:
4272: EXCEPTION
4273: WHEN OTHERS THEN
4274: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4275: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',
4276: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4277: END IF;
4278: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4279: p_msg_name => G_UNEXPECTED_ERROR,

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

4330: -- Developer Mani Choudhary
4331: -- Date 31-MAY-2005
4332: -- Proration to consider period start and period type
4333: -------------------------------------------------------------------------
4334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4335: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4336: 'input parameters period start '||p_period_start
4337: ||' p_period_type = ' || p_period_type);
4338: END IF;

Line 4335: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4331: -- Date 31-MAY-2005
4332: -- Proration to consider period start and period type
4333: -------------------------------------------------------------------------
4334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4335: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4336: 'input parameters period start '||p_period_start
4337: ||' p_period_type = ' || p_period_type);
4338: END IF;
4339:

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

4358: p_source_uom => l_uom_code,
4359: p_period_type => p_period_type,
4360: p_period_start => p_period_start
4361: );
4362: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4363: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4364: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4365: ||' result l_temp '||l_temp);
4366: END IF;

Line 4363: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4359: p_period_type => p_period_type,
4360: p_period_start => p_period_start
4361: );
4362: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4363: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4364: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4365: ||' result l_temp '||l_temp);
4366: END IF;
4367:

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

4370: END IF;
4371:
4372: l_next_frequency :=l_next_frequency + l_temp;
4373:
4374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4376: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4377: ||' result l_next_frequency '||l_next_frequency);
4378: END IF;

Line 4375: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4371:
4372: l_next_frequency :=l_next_frequency + l_temp;
4373:
4374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4376: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4377: ||' result l_next_frequency '||l_next_frequency);
4378: END IF;
4379:

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

4387: p_source_uom => l_uom_code,
4388: p_period_type => p_period_type,
4389: p_period_start => p_period_start
4390: );
4391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4392: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4393: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4394: ||' result l_curr_frequency '||l_curr_frequency);
4395: END IF;

Line 4392: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4388: p_period_type => p_period_type,
4389: p_period_start => p_period_start
4390: );
4391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4392: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4393: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4394: ||' result l_curr_frequency '||l_curr_frequency);
4395: END IF;
4396:

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

4416:
4417:
4418: -- l_tot_frequency := l_tot_frequency + l_curr_frequency + l_next_frequency;
4419:
4420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4421: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4422: ' result l_tot_frequency '||l_tot_frequency);
4423: END IF;
4424:

Line 4421: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4417:
4418: -- l_tot_frequency := l_tot_frequency + l_curr_frequency + l_next_frequency;
4419:
4420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4421: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4422: ' result l_tot_frequency '||l_tot_frequency);
4423: END IF;
4424:
4425: --errorout_ad('l_tot_frequency '||l_tot_frequency);

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

4429: l_period_sll_amt := ( l_sll_remain_amount /( nvl(l_tot_frequency,1) * nvl(l_sll_period,1))) * nvl(l_curr_frequency,0) ;
4430:
4431: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4432:
4433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4434: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4435: ' result l_period_sll_amt '||l_period_sll_amt);
4436: END IF;
4437:

Line 4434: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4430:
4431: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4432:
4433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4434: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4435: ' result l_period_sll_amt '||l_period_sll_amt);
4436: END IF;
4437:
4438:

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

4437:
4438:
4439: l_sll_remain_amount := l_sll_remain_amount - (l_period_sll_amt * nvl(l_sll_period,1)) ;
4440:
4441: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4442: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4443: ' result l_sll_remain_amount '||l_sll_remain_amount);
4444: END IF;
4445:

Line 4442: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',

4438:
4439: l_sll_remain_amount := l_sll_remain_amount - (l_period_sll_amt * nvl(l_sll_period,1)) ;
4440:
4441: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4442: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4443: ' result l_sll_remain_amount '||l_sll_remain_amount);
4444: END IF;
4445:
4446: --errorout_ad('l_period_sll_amt '||l_period_sll_amt);

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

4877: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4878: -----errorout_ad('p_tce_code = ' || p_tce_code);
4879: -----errorout_ad('p_uom_quantity = ' || p_uom_quantity);
4880:
4881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4882:
4883: fnd_log.STRING (fnd_log.level_statement,
4884: G_MODULE_CURRENT || '.get_constant_sll_amount.info',
4885: 'p_tce_code = ' || p_tce_code

Line 4883: fnd_log.STRING (fnd_log.level_statement,

4879: -----errorout_ad('p_uom_quantity = ' || p_uom_quantity);
4880:
4881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4882:
4883: fnd_log.STRING (fnd_log.level_statement,
4884: G_MODULE_CURRENT || '.get_constant_sll_amount.info',
4885: 'p_tce_code = ' || p_tce_code
4886: ||', p_uom_quantity = ' || p_uom_quantity
4887: ||', p_remaining_amount = ' || p_remaining_amount

Line 4910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4906: x_return_status => x_return_status);
4907:
4908: END IF;
4909:
4910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',
4912: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4913: ||', l_frequency = '|| l_frequency ||')');
4914: END IF;

Line 4911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',

4907:
4908: END IF;
4909:
4910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',
4912: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4913: ||', l_frequency = '|| l_frequency ||')');
4914: END IF;
4915:

Line 4931: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

4927: -----errorout_ad('x_constant_sll_amt = ' || x_constant_sll_amt);
4928: EXCEPTION
4929: WHEN OTHERS THEN
4930:
4931: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4932: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',
4933: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4934: END IF;
4935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 4932: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',

4928: EXCEPTION
4929: WHEN OTHERS THEN
4930:
4931: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4932: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',
4933: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4934: END IF;
4935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4936: p_msg_name => G_UNEXPECTED_ERROR,

Line 4982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

4978:
4979: End If;
4980:
4981:
4982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',
4984: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4985: ||', x_period_freq = '|| x_period_freq ||')');
4986: END IF;

Line 4983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',

4979: End If;
4980:
4981:
4982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',
4984: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4985: ||', x_period_freq = '|| x_period_freq ||')');
4986: END IF;
4987:

Line 4997: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

4993:
4994: EXCEPTION
4995: WHEN OTHERS THEN
4996:
4997: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4998: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',
4999: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5000: END IF;
5001: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 4998: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',

4994: EXCEPTION
4995: WHEN OTHERS THEN
4996:
4997: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4998: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',
4999: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5000: END IF;
5001: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5002: p_msg_name => G_UNEXPECTED_ERROR,

Line 5149: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

5145: Fetch l_Line_Csr Into l_Line_Csr_Rec;
5146:
5147: If l_Line_Csr%Notfound then
5148: Close l_Line_Csr;
5149: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5150: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5151: 'top line not found = ' || p_top_line_id );
5152: END IF;
5153: x_return_status := 'E';

Line 5150: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',

5146:
5147: If l_Line_Csr%Notfound then
5148: Close l_Line_Csr;
5149: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5150: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5151: 'top line not found = ' || p_top_line_id );
5152: END IF;
5153: x_return_status := 'E';
5154: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

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

5222: FETCH l_line_amt_csr INTO l_line_rec.line_amt;
5223: CLOSE l_line_amt_csr;
5224: END IF;
5225:
5226: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5227:
5228: fnd_log.STRING (fnd_log.level_statement,
5229: G_MODULE_CURRENT || '.create_bill_sch_cp.line_dtls',
5230: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 5228: fnd_log.STRING (fnd_log.level_statement,

5224: END IF;
5225:
5226: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5227:
5228: fnd_log.STRING (fnd_log.level_statement,
5229: G_MODULE_CURRENT || '.create_bill_sch_cp.line_dtls',
5230: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
5231: || ', id = ' || l_line_rec.id
5232: || ', lse_id = ' || l_line_rec.lse_id

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

5280:
5281: l_index := l_index + 1;
5282: END LOOP;
5283:
5284: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5285:
5286: fnd_log.STRING (fnd_log.level_statement,
5287: G_MODULE_CURRENT || '.create_bill_sch_cp.sll_tbl',
5288: 'top line sll tbl count = ' || l_sll_tbl.count

Line 5286: fnd_log.STRING (fnd_log.level_statement,

5282: END LOOP;
5283:
5284: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5285:
5286: fnd_log.STRING (fnd_log.level_statement,
5287: G_MODULE_CURRENT || '.create_bill_sch_cp.sll_tbl',
5288: 'top line sll tbl count = ' || l_sll_tbl.count
5289: );
5290: END IF;

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

5357:
5358: l_cp_rec.cp_amt := l_amount;
5359: END IF;
5360:
5361: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5362:
5363: fnd_log.STRING (fnd_log.level_statement,
5364: G_MODULE_CURRENT || '.create_bill_sch_cp.cp_dtls',
5365: 'p_cp_new = ' || p_cp_new

Line 5363: fnd_log.STRING (fnd_log.level_statement,

5359: END IF;
5360:
5361: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5362:
5363: fnd_log.STRING (fnd_log.level_statement,
5364: G_MODULE_CURRENT || '.create_bill_sch_cp.cp_dtls',
5365: 'p_cp_new = ' || p_cp_new
5366: || ', id = ' || l_cp_rec.cp_id
5367: || ', start dt = ' || l_cp_rec.cp_start_dt

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

5404:
5405: l_index := l_index + 1;
5406: END LOOP; --top line lvl element
5407:
5408: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5409:
5410: fnd_log.STRING (fnd_log.level_statement,
5411: G_MODULE_CURRENT || '.create_bill_sch_cp.bs_tbl',
5412: 'top line bs tbl count = ' || l_top_bs_tbl.count

Line 5410: fnd_log.STRING (fnd_log.level_statement,

5406: END LOOP; --top line lvl element
5407:
5408: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5409:
5410: fnd_log.STRING (fnd_log.level_statement,
5411: G_MODULE_CURRENT || '.create_bill_sch_cp.bs_tbl',
5412: 'top line bs tbl count = ' || l_top_bs_tbl.count
5413: );
5414: END IF;

Line 5427: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5423: p_invoice_rule_id => l_line_csr_rec.inv_id,
5424: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
5425: x_return_status => x_return_status);
5426:
5427: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5428: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.call_bs',
5429: 'Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
5430: END IF;
5431:

Line 5428: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.call_bs',

5424: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
5425: x_return_status => x_return_status);
5426:
5427: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5428: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.call_bs',
5429: 'Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
5430: END IF;
5431:
5432: IF x_return_status <> 'S' THEN

Line 5447: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5443: p_SubLine_rec => l_cp_Rec,
5444: p_top_line_bs => l_top_bs_tbl,
5445: x_return_status => x_return_status);
5446:
5447: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5448: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.adjust',
5449: 'adjust_top_bs_amt(x_return_status = '||x_return_status ||')');
5450: END IF;
5451:

Line 5448: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.adjust',

5444: p_top_line_bs => l_top_bs_tbl,
5445: x_return_status => x_return_status);
5446:
5447: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5448: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.adjust',
5449: 'adjust_top_bs_amt(x_return_status = '||x_return_status ||')');
5450: END IF;
5451:
5452:

Line 5478: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5474: p_period_start => l_period_start,
5475: p_period_type => l_period_type,
5476: x_return_status => x_return_status);
5477:
5478: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5479: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.cp_bs',
5480: 'Bill_Sch_Cp(x_return_status = '||x_return_status ||')');
5481: END IF;
5482:

Line 5479: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.cp_bs',

5475: p_period_type => l_period_type,
5476: x_return_status => x_return_status);
5477:
5478: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5479: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.cp_bs',
5480: 'Bill_Sch_Cp(x_return_status = '||x_return_status ||')');
5481: END IF;
5482:
5483:

Line 5496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5492: x_msg_data => x_msg_data,
5493: p_letv_tbl => l_top_bs_tbl,
5494: x_letv_tbl => l_lvl_ele_tbl_out);
5495:
5496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',
5498: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');
5499: END IF;
5500: else

Line 5497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',

5493: p_letv_tbl => l_top_bs_tbl,
5494: x_letv_tbl => l_lvl_ele_tbl_out);
5495:
5496: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5497: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',
5498: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');
5499: END IF;
5500: else
5501:

Line 5509: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

5505: END IF;
5506:
5507: EXCEPTION
5508: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5509: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5510: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5511: 'G_EXCEPTION_HALT_VALIDATION');
5512: END IF;
5513:

Line 5510: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',

5506:
5507: EXCEPTION
5508: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5509: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5510: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5511: 'G_EXCEPTION_HALT_VALIDATION');
5512: END IF;
5513:
5514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5520: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

5516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5517: RAISE OKC_API.G_EXCEPTION_ERROR;
5518: END IF;
5519: WHEN OTHERS THEN
5520: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5521: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',
5522: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5523: END IF;
5524: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 5521: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',

5517: RAISE OKC_API.G_EXCEPTION_ERROR;
5518: END IF;
5519: WHEN OTHERS THEN
5520: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5521: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',
5522: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5523: END IF;
5524: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5525: p_msg_name => G_UNEXPECTED_ERROR,

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

5630: --it adjusts the sll and lvl element according to new line start and end date.
5631:
5632: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5633:
5634: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5635:
5636: fnd_log.STRING (fnd_log.level_statement,
5637: G_MODULE_CURRENT || '.cascade_dates_sll.line_passed',
5638: 'top line id passed = ' || p_top_line_id );

Line 5636: fnd_log.STRING (fnd_log.level_statement,

5632: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5633:
5634: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5635:
5636: fnd_log.STRING (fnd_log.level_statement,
5637: G_MODULE_CURRENT || '.cascade_dates_sll.line_passed',
5638: 'top line id passed = ' || p_top_line_id );
5639: END IF;
5640:

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

5691: FETCH Get_price_uom into l_price_uom;
5692: CLOSE Get_price_uom;
5693: END IF;
5694:
5695: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5696:
5697: fnd_log.STRING (fnd_log.level_statement,
5698: G_MODULE_CURRENT || '.cascade_dates_sll.line_dtls',
5699: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 5697: fnd_log.STRING (fnd_log.level_statement,

5693: END IF;
5694:
5695: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5696:
5697: fnd_log.STRING (fnd_log.level_statement,
5698: G_MODULE_CURRENT || '.cascade_dates_sll.line_dtls',
5699: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
5700: || ', id = ' || l_line_rec.id
5701: || ', lse_id = ' || l_line_rec.lse_id

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

5794:
5795: l_index := l_index + 1;
5796: END LOOP; --sll csr end loop
5797:
5798: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5799:
5800: fnd_log.STRING (fnd_log.level_statement,
5801: G_MODULE_CURRENT || '.cascade_dates_sll.sll_tbl',
5802: 'top line sll tbl count = ' || l_sll_tbl.count

Line 5800: fnd_log.STRING (fnd_log.level_statement,

5796: END LOOP; --sll csr end loop
5797:
5798: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5799:
5800: fnd_log.STRING (fnd_log.level_statement,
5801: G_MODULE_CURRENT || '.cascade_dates_sll.sll_tbl',
5802: 'top line sll tbl count = ' || l_sll_tbl.count
5803: );
5804: END IF;

Line 5838: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5834: x_return_status => x_return_status,
5835: x_msg_count => x_msg_count,
5836: x_msg_data => x_msg_data);
5837:
5838: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5839: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_lvl_ele',
5840: 'Del_sll_lvlelement(x_return_status = '||x_return_status
5841: ||', line passed = '|| p_top_line_id ||')');
5842: END IF;

Line 5839: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_lvl_ele',

5835: x_msg_count => x_msg_count,
5836: x_msg_data => x_msg_data);
5837:
5838: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5839: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_lvl_ele',
5840: 'Del_sll_lvlelement(x_return_status = '||x_return_status
5841: ||', line passed = '|| p_top_line_id ||')');
5842: END IF;
5843:

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

5849:
5850: IF TRUNC(l_sll_start_date) > l_line_rec.line_start_dt THEN
5851: ---add one sll in the starting with uom code got from timeutil pub
5852:
5853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5854:
5855: fnd_log.STRING (fnd_log.level_statement,
5856: G_MODULE_CURRENT || '.cascade_dates_sll.if_stat',
5857: 'sll st dt > line st dt'

Line 5855: fnd_log.STRING (fnd_log.level_statement,

5851: ---add one sll in the starting with uom code got from timeutil pub
5852:
5853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5854:
5855: fnd_log.STRING (fnd_log.level_statement,
5856: G_MODULE_CURRENT || '.cascade_dates_sll.if_stat',
5857: 'sll st dt > line st dt'
5858: || ', sll st dt = ' || l_sll_start_date
5859: );

Line 5909: --fnd_log statement

5905: x_timeunit => l_timeunit,
5906: x_return_status => x_return_status);
5907:
5908: --mchoudha bug#5076095 added to_char for the dates in the following
5909: --fnd_log statement
5910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.sll_duration',
5912: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5913: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')

Line 5910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5906: x_return_status => x_return_status);
5907:
5908: --mchoudha bug#5076095 added to_char for the dates in the following
5909: --fnd_log statement
5910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.sll_duration',
5912: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5913: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')
5914: ||', st date MM/DD/YYYY HH24:MI:SS ='|| to_char(l_line_rec.line_start_dt,'MM/DD/YYYY HH24:MI:SS')

Line 5911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.sll_duration',

5907:
5908: --mchoudha bug#5076095 added to_char for the dates in the following
5909: --fnd_log statement
5910: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5911: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.sll_duration',
5912: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5913: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')
5914: ||', st date MM/DD/YYYY HH24:MI:SS ='|| to_char(l_line_rec.line_start_dt,'MM/DD/YYYY HH24:MI:SS')
5915: ||', returned timeunit and duration = ' ||l_duration || '-' || l_timeunit ||')');

Line 5930: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

5926: x_return_status => x_return_status,
5927: x_quantity => l_uom_quantity ,
5928: x_timeunit => l_tce_code);
5929:
5930: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5931: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5932: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5933: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5934: END IF;

Line 5931: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',

5927: x_quantity => l_uom_quantity ,
5928: x_timeunit => l_tce_code);
5929:
5930: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5931: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5932: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5933: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5934: END IF;
5935:

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

6009:
6010:
6011: ELSIF TRUNC(l_sll_start_date) < l_line_rec.line_start_dt THEN ---LINE START DATE is pushed forward
6012:
6013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6014:
6015: fnd_log.STRING (fnd_log.level_statement,
6016: G_MODULE_CURRENT || '.cascade_dates_sll.chk_sll_dt',
6017: 'sll st dt < line st dt - line start date is pushed forward'

Line 6015: fnd_log.STRING (fnd_log.level_statement,

6011: ELSIF TRUNC(l_sll_start_date) < l_line_rec.line_start_dt THEN ---LINE START DATE is pushed forward
6012:
6013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6014:
6015: fnd_log.STRING (fnd_log.level_statement,
6016: G_MODULE_CURRENT || '.cascade_dates_sll.chk_sll_dt',
6017: 'sll st dt < line st dt - line start date is pushed forward'
6018: || ', sll st dt = ' || l_sll_start_date
6019: );

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

6046:
6047: END IF;
6048: END LOOP; --while end loop
6049:
6050: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6051:
6052: fnd_log.STRING (fnd_log.level_statement,
6053: G_MODULE_CURRENT || '.cascade_dates_sll.sll_after_delete',
6054: 'sll count after deleting sll where sll end date < line start date'

Line 6052: fnd_log.STRING (fnd_log.level_statement,

6048: END LOOP; --while end loop
6049:
6050: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6051:
6052: fnd_log.STRING (fnd_log.level_statement,
6053: G_MODULE_CURRENT || '.cascade_dates_sll.sll_after_delete',
6054: 'sll count after deleting sll where sll end date < line start date'
6055: || ', sll count = ' || l_sll_tbl.count
6056: );

Line 6070: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6066: x_msg_count => x_msg_count,
6067: x_msg_data => x_msg_data,
6068: p_sllv_tbl => l_strm_lvl_tbl_in);
6069:
6070: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6071: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',
6072: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status
6073: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6074: END IF;

Line 6071: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',

6067: x_msg_data => x_msg_data,
6068: p_sllv_tbl => l_strm_lvl_tbl_in);
6069:
6070: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6071: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',
6072: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status
6073: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6074: END IF;
6075:

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

6091: -----errorout_ad('first sll st dt = ' || l_sll_start_date || ' and line st dt = ' || l_line_rec.line_start_dt);
6092:
6093: IF l_line_rec.line_start_dt > TRUNC(l_sll_start_date) THEN
6094:
6095: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6096:
6097: fnd_log.STRING (fnd_log.level_statement,
6098: G_MODULE_CURRENT || '.cascade_dates_sll.after_sll_del',
6099: 'after sll delete line start date > sll start date'

Line 6097: fnd_log.STRING (fnd_log.level_statement,

6093: IF l_line_rec.line_start_dt > TRUNC(l_sll_start_date) THEN
6094:
6095: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6096:
6097: fnd_log.STRING (fnd_log.level_statement,
6098: G_MODULE_CURRENT || '.cascade_dates_sll.after_sll_del',
6099: 'after sll delete line start date > sll start date'
6100: || ', sll dt = ' || l_sll_start_date
6101: );

Line 6162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6158: x_return_status => x_return_status,
6159: x_quantity => l_uom_quantity ,
6160: x_timeunit => l_tce_code);
6161:
6162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',
6164: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6165: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6166: END IF;

Line 6163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',

6159: x_quantity => l_uom_quantity ,
6160: x_timeunit => l_tce_code);
6161:
6162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',
6164: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6165: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6166: END IF;
6167:

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

6207:
6208:
6209: -- END IF; -------not day
6210:
6211: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6212:
6213: fnd_log.STRING (fnd_log.level_statement,
6214: G_MODULE_CURRENT || '.cascade_dates_sll.sll_add',
6215: 'sll added after deleting sll where sll_end_dt < line_start_dt');

Line 6213: fnd_log.STRING (fnd_log.level_statement,

6209: -- END IF; -------not day
6210:
6211: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6212:
6213: fnd_log.STRING (fnd_log.level_statement,
6214: G_MODULE_CURRENT || '.cascade_dates_sll.sll_add',
6215: 'sll added after deleting sll where sll_end_dt < line_start_dt');
6216: END IF;
6217:

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

6255:
6256:
6257: ELSE ---sll tbl count = 0 after deletion
6258:
6259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6260:
6261: fnd_log.STRING (fnd_log.level_statement,
6262: G_MODULE_CURRENT || '.cascade_dates_sll.sll_cnt',
6263: 'sll count zero after deleting sll where sll_end_dt < line_start_dt');

Line 6261: fnd_log.STRING (fnd_log.level_statement,

6257: ELSE ---sll tbl count = 0 after deletion
6258:
6259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6260:
6261: fnd_log.STRING (fnd_log.level_statement,
6262: G_MODULE_CURRENT || '.cascade_dates_sll.sll_cnt',
6263: 'sll count zero after deleting sll where sll_end_dt < line_start_dt');
6264: END IF;
6265:

Line 6275: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6271: x_duration => l_duration,
6272: x_timeunit => l_timeunit,
6273: x_return_status => x_return_status);
6274:
6275: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6276: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',
6277: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6278: ||', l_duration = '|| l_duration
6279: ||', l_timeunit = ' || l_timeunit ||')');

Line 6276: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',

6272: x_timeunit => l_timeunit,
6273: x_return_status => x_return_status);
6274:
6275: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6276: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',
6277: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6278: ||', l_duration = '|| l_duration
6279: ||', l_timeunit = ' || l_timeunit ||')');
6280: END IF;

Line 6292: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6288: x_return_status => x_return_status,
6289: x_quantity => l_uom_quantity ,
6290: x_timeunit => l_tce_code);
6291:
6292: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6293: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',
6294: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6295: ||', l_uom_quantity = '|| l_uom_quantity
6296: ||', l_tce_code = ' || l_tce_code ||')');

Line 6293: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',

6289: x_quantity => l_uom_quantity ,
6290: x_timeunit => l_tce_code);
6291:
6292: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6293: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',
6294: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6295: ||', l_uom_quantity = '|| l_uom_quantity
6296: ||', l_tce_code = ' || l_tce_code ||')');
6297: END IF;

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

6348: l_sll_tbl(1).level_amount := NULL;
6349: l_sll_tbl(1).invoice_offset_days := NULL ;
6350: l_sll_tbl(1).interface_offset_days := NULL ;
6351:
6352: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6353:
6354: fnd_log.STRING (fnd_log.level_statement,
6355: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one',
6356: 'sll added count one');

Line 6354: fnd_log.STRING (fnd_log.level_statement,

6350: l_sll_tbl(1).interface_offset_days := NULL ;
6351:
6352: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6353:
6354: fnd_log.STRING (fnd_log.level_statement,
6355: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one',
6356: 'sll added count one');
6357: END IF;
6358: END IF; --period start and period type not null

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

6379:
6380:
6381: IF TRUNC(l_sll_END_date) < l_line_rec.line_END_dt THEN ---LINE date extended
6382:
6383: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6384:
6385: fnd_log.STRING (fnd_log.level_statement,
6386: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6387: 'sll end dt < line_end_dt'

Line 6385: fnd_log.STRING (fnd_log.level_statement,

6381: IF TRUNC(l_sll_END_date) < l_line_rec.line_END_dt THEN ---LINE date extended
6382:
6383: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6384:
6385: fnd_log.STRING (fnd_log.level_statement,
6386: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6387: 'sll end dt < line_end_dt'
6388: || ', sl end dt = ' || l_sll_END_date);
6389: END IF;

Line 6442: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6438: x_return_status => x_return_status,
6439: x_quantity => l_uom_quantity ,
6440: x_timeunit => l_tce_code);
6441:
6442: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6443: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6444: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6445: ||', l_uom_quantity = '|| l_uom_quantity
6446: ||', l_tce_code = ' || l_tce_code ||')');

Line 6443: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',

6439: x_quantity => l_uom_quantity ,
6440: x_timeunit => l_tce_code);
6441:
6442: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6443: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6444: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6445: ||', l_uom_quantity = '|| l_uom_quantity
6446: ||', l_tce_code = ' || l_tce_code ||')');
6447: END IF;

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

6508: l_sll_tbl(l_sll_tbl_index + 1).cle_id := l_sll_tbl(l_sll_tbl_index ).cle_id ;
6509: l_sll_tbl(l_sll_tbl_index + 1).chr_id := l_sll_tbl(l_sll_tbl_index ).chr_id ;
6510: l_sll_tbl(l_sll_tbl_index + 1).dnz_chr_id := l_sll_tbl(l_sll_tbl_index ).dnz_chr_id;
6511:
6512: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6513:
6514: fnd_log.STRING (fnd_log.level_statement,
6515: G_MODULE_CURRENT || '.cascade_dates_sll.all_sll_end',
6516: 'added sll when sll end dt < line_end_dt');

Line 6514: fnd_log.STRING (fnd_log.level_statement,

6510: l_sll_tbl(l_sll_tbl_index + 1).dnz_chr_id := l_sll_tbl(l_sll_tbl_index ).dnz_chr_id;
6511:
6512: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6513:
6514: fnd_log.STRING (fnd_log.level_statement,
6515: G_MODULE_CURRENT || '.cascade_dates_sll.all_sll_end',
6516: 'added sll when sll end dt < line_end_dt');
6517: END IF;
6518:

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

6519: END IF; --period start and period type are not null
6520: ELSE ---sll tbl count = 0
6521:
6522:
6523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6524:
6525: fnd_log.STRING (fnd_log.level_statement,
6526: G_MODULE_CURRENT || '.cascade_dates_sll.sll_zero',
6527: 'sll count zero');

Line 6525: fnd_log.STRING (fnd_log.level_statement,

6521:
6522:
6523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6524:
6525: fnd_log.STRING (fnd_log.level_statement,
6526: G_MODULE_CURRENT || '.cascade_dates_sll.sll_zero',
6527: 'sll count zero');
6528: END IF;
6529:

Line 6538: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6534: x_duration => l_duration,
6535: x_timeunit => l_timeunit,
6536: x_return_status => x_return_status);
6537:
6538: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6539: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',
6540: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6541: ||', l_duration = '|| l_duration
6542: ||', l_timeunit = ' || l_timeunit ||')');

Line 6539: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',

6535: x_timeunit => l_timeunit,
6536: x_return_status => x_return_status);
6537:
6538: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6539: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',
6540: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6541: ||', l_duration = '|| l_duration
6542: ||', l_timeunit = ' || l_timeunit ||')');
6543: END IF;

Line 6556: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6552: x_return_status => x_return_status,
6553: x_quantity => l_uom_quantity ,
6554: x_timeunit => l_tce_code);
6555:
6556: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6557: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',
6558: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6559: ||', l_uom_quantity = '|| l_uom_quantity
6560: ||', l_tce_code = ' || l_tce_code ||')');

Line 6557: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',

6553: x_quantity => l_uom_quantity ,
6554: x_timeunit => l_tce_code);
6555:
6556: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6557: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',
6558: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6559: ||', l_uom_quantity = '|| l_uom_quantity
6560: ||', l_tce_code = ' || l_tce_code ||')');
6561: END IF;

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

6619: l_sll_tbl(l_sll_tbl_index).cle_id := l_line_rec.id ;
6620: l_sll_tbl(l_sll_tbl_index).chr_id := null;
6621: l_sll_tbl(l_sll_tbl_index).dnz_chr_id := l_line_rec.dnz_chr_id;
6622:
6623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6624:
6625: fnd_log.STRING (fnd_log.level_statement,
6626: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one_end',
6627: 'sll added count one');

Line 6625: fnd_log.STRING (fnd_log.level_statement,

6621: l_sll_tbl(l_sll_tbl_index).dnz_chr_id := l_line_rec.dnz_chr_id;
6622:
6623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6624:
6625: fnd_log.STRING (fnd_log.level_statement,
6626: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one_end',
6627: 'sll added count one');
6628: END IF;
6629:

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

6633:
6634: --no changes for partial period calendar in this case
6635: ELSIF TRUNC(l_sll_END_date) > l_line_rec.line_END_dt THEN ---LINE END DATE SHRINKED.
6636:
6637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6638:
6639: fnd_log.STRING (fnd_log.level_statement,
6640: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6641: 'sll end dt > line end dt'

Line 6639: fnd_log.STRING (fnd_log.level_statement,

6635: ELSIF TRUNC(l_sll_END_date) > l_line_rec.line_END_dt THEN ---LINE END DATE SHRINKED.
6636:
6637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6638:
6639: fnd_log.STRING (fnd_log.level_statement,
6640: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6641: 'sll end dt > line end dt'
6642: ||', sll end dt = ' || l_sll_END_date );
6643: END IF;

Line 6679: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6675: x_msg_count => x_msg_count,
6676: x_msg_data => x_msg_data,
6677: x_return_status => x_return_status );
6678:
6679: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6680: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',
6681: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status
6682: ||', sll id passed = '|| l_strm_lvl_tbl_in(l_sll_ind).id ||')');
6683: END IF;

Line 6680: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',

6676: x_msg_data => x_msg_data,
6677: x_return_status => x_return_status );
6678:
6679: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6680: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',
6681: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status
6682: ||', sll id passed = '|| l_strm_lvl_tbl_in(l_sll_ind).id ||')');
6683: END IF;
6684:

Line 6704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

6700: p_invoice_rule_id => l_line_csr_rec.inv_id,
6701: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
6702: x_return_status => x_return_status);
6703:
6704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',
6706: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
6707: END IF;
6708:

Line 6705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',

6701: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
6702: x_return_status => x_return_status);
6703:
6704: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6705: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',
6706: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
6707: END IF;
6708:
6709: IF x_return_status <> 'S' THEN

Line 6719: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

6715:
6716: EXCEPTION
6717: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6718:
6719: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
6720: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',
6721: 'G_EXCEPTION_HALT_VALIDATION');
6722: END IF;
6723:

Line 6720: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',

6716: EXCEPTION
6717: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6718:
6719: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
6720: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',
6721: 'G_EXCEPTION_HALT_VALIDATION');
6722: END IF;
6723:
6724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6731: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

6727: RAISE OKC_API.G_EXCEPTION_ERROR;
6728: END IF;
6729: WHEN OTHERS THEN
6730:
6731: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6732: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',
6733: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6734: END IF;
6735:

Line 6732: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',

6728: END IF;
6729: WHEN OTHERS THEN
6730:
6731: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6732: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',
6733: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6734: END IF;
6735:
6736: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 6791: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

6787:
6788: EXCEPTION
6789: WHEN OTHERS THEN
6790:
6791: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6792: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',
6793: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6794: END IF;
6795: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 6792: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',

6788: EXCEPTION
6789: WHEN OTHERS THEN
6790:
6791: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6792: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',
6793: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6794: END IF;
6795: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
6796: p_msg_name => G_UNEXPECTED_ERROR,

Line 6896: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

6892:
6893:
6894: EXCEPTION
6895: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6896: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
6897: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',
6898: 'G_EXCEPTION_HALT_VALIDATION');
6899: END IF;
6900:

Line 6897: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',

6893:
6894: EXCEPTION
6895: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6896: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
6897: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',
6898: 'G_EXCEPTION_HALT_VALIDATION');
6899: END IF;
6900:
6901: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6908: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

6904: RAISE OKC_API.G_EXCEPTION_ERROR;
6905: END IF;
6906: WHEN OTHERS THEN
6907:
6908: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6909: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',
6910: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6911: END IF;
6912:

Line 6909: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',

6905: END IF;
6906: WHEN OTHERS THEN
6907:
6908: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6909: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',
6910: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6911: END IF;
6912:
6913: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 7093: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

7089:
7090:
7091: EXCEPTION
7092: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7093: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
7094: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',
7095: 'G_EXCEPTION_HALT_VALIDATION');
7096: END IF;
7097:

Line 7094: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',

7090:
7091: EXCEPTION
7092: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7093: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
7094: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',
7095: 'G_EXCEPTION_HALT_VALIDATION');
7096: END IF;
7097:
7098: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 7104: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

7100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7101: RAISE OKC_API.G_EXCEPTION_ERROR;
7102: END IF;
7103: WHEN OTHERS THEN
7104: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7105: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',
7106: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7107: END IF;
7108:

Line 7105: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',

7101: RAISE OKC_API.G_EXCEPTION_ERROR;
7102: END IF;
7103: WHEN OTHERS THEN
7104: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7105: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',
7106: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7107: END IF;
7108:
7109: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 7176: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

7172:
7173:
7174: EXCEPTION
7175: WHEN OTHERS THEN
7176: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7177: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',
7178: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7179: END IF;
7180:

Line 7177: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',

7173:
7174: EXCEPTION
7175: WHEN OTHERS THEN
7176: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7177: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',
7178: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7179: END IF;
7180:
7181: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

8924: -------------------------------------------------------------------------
8925: -- End partial period computation logic
8926: -- Date 09-MAY-2005
8927: -------------------------------------------------------------------------
8928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8929:
8930: fnd_log.STRING (fnd_log.level_statement,
8931: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
8932: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 8930: fnd_log.STRING (fnd_log.level_statement,

8926: -- Date 09-MAY-2005
8927: -------------------------------------------------------------------------
8928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8929:
8930: fnd_log.STRING (fnd_log.level_statement,
8931: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
8932: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
8933: || ', id = ' || l_line_rec.id
8934: || ', lse_id = ' || l_line_rec.lse_id

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

8947: l_currency_code := Find_Currency_Code(
8948: p_cle_id => p_top_line_id,
8949: p_chr_id => NULL);
8950:
8951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8952:
8953: fnd_log.STRING (fnd_log.level_statement,
8954: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
8955: 'l_currency_code = ' || l_currency_code);

Line 8953: fnd_log.STRING (fnd_log.level_statement,

8949: p_chr_id => NULL);
8950:
8951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8952:
8953: fnd_log.STRING (fnd_log.level_statement,
8954: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
8955: 'l_currency_code = ' || l_currency_code);
8956: END IF;
8957:

Line 8984: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

8980: x_sll_tbl => l_sll_in_tbl,
8981: x_sll_db_tbl => l_sll_db_tbl,
8982: x_return_status => x_return_status );
8983:
8984: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
8985: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.line_sll',
8986: 'Get_SLL_info(x_return_status = '||x_return_status
8987: ||', sll tbl count = '||l_sll_in_tbl.count||')');
8988: END IF;

Line 8985: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.line_sll',

8981: x_sll_db_tbl => l_sll_db_tbl,
8982: x_return_status => x_return_status );
8983:
8984: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
8985: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.line_sll',
8986: 'Get_SLL_info(x_return_status = '||x_return_status
8987: ||', sll tbl count = '||l_sll_in_tbl.count||')');
8988: END IF;
8989:

Line 9015: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9011: p_period_start => l_period_start,
9012: p_period_type => l_period_type,
9013: x_return_status => x_return_status );
9014:
9015: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9016: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.top_lvl_ele',
9017: 'Create_Level_elements(x_return_status = '||x_return_status
9018: ||')');
9019: END IF;

Line 9016: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.top_lvl_ele',

9012: p_period_type => l_period_type,
9013: x_return_status => x_return_status );
9014:
9015: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9016: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.top_lvl_ele',
9017: 'Create_Level_elements(x_return_status = '||x_return_status
9018: ||')');
9019: END IF;
9020:

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

9037: l_top_bs_tbl(l_index).date_to_interface := l_line_BS_rec.date_to_interface;
9038:
9039: l_index := l_index + 1;
9040: END LOOP;
9041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9042:
9043: fnd_log.STRING (fnd_log.level_statement,
9044: G_MODULE_CURRENT || '.terminate_bill_sch.top_bs',
9045: 'top bs tbl count = ' || l_top_bs_tbl.count);

Line 9043: fnd_log.STRING (fnd_log.level_statement,

9039: l_index := l_index + 1;
9040: END LOOP;
9041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9042:
9043: fnd_log.STRING (fnd_log.level_statement,
9044: G_MODULE_CURRENT || '.terminate_bill_sch.top_bs',
9045: 'top bs tbl count = ' || l_top_bs_tbl.count);
9046: END IF;
9047: END IF; -----end of 'T'

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

9065: OPEN l_subline_amt_csr(l_all_SubLine_rec.subline_id);
9066: FETCH l_subline_amt_csr INTO l_cp_rec.cp_amt;
9067: CLOSE l_subline_amt_csr;
9068: END IF;
9069: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9070:
9071: fnd_log.STRING (fnd_log.level_statement,
9072: G_MODULE_CURRENT || '.terminate_bill_sch.loop_cp_dtl',
9073: 'id = ' || l_all_SubLine_rec.subline_id

Line 9071: fnd_log.STRING (fnd_log.level_statement,

9067: CLOSE l_subline_amt_csr;
9068: END IF;
9069: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9070:
9071: fnd_log.STRING (fnd_log.level_statement,
9072: G_MODULE_CURRENT || '.terminate_bill_sch.loop_cp_dtl',
9073: 'id = ' || l_all_SubLine_rec.subline_id
9074: || ', start dt = ' || l_all_SubLine_rec.cp_start_dt
9075: || ', end dt = ' || l_all_SubLine_rec.cp_end_dt

Line 9092: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9088: p_SubLine_rec => l_cp_rec,
9089: p_top_line_bs => l_top_bs_tbl,
9090: x_return_status => x_return_status);
9091:
9092: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9093: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adj_lvl_amt',
9094: 'Rollup_lvl_amt(x_return_status = '||x_return_status
9095: ||')');
9096: END IF;

Line 9093: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adj_lvl_amt',

9089: p_top_line_bs => l_top_bs_tbl,
9090: x_return_status => x_return_status);
9091:
9092: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9093: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adj_lvl_amt',
9094: 'Rollup_lvl_amt(x_return_status = '||x_return_status
9095: ||')');
9096: END IF;
9097:

Line 9114: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9110: x_sll_tbl => l_sll_in_tbl,
9111: x_sll_db_tbl => l_sll_db_tbl,
9112: x_return_status => x_return_status );
9113:
9114: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9115: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9116: 'Get_SLL_info(x_return_status = '||x_return_status
9117: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9118: END IF;

Line 9115: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',

9111: x_sll_db_tbl => l_sll_db_tbl,
9112: x_return_status => x_return_status );
9113:
9114: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9115: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9116: 'Get_SLL_info(x_return_status = '||x_return_status
9117: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9118: END IF;
9119:

Line 9162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9158: p_period_start => l_period_start,
9159: p_period_type => l_period_type,
9160: x_return_status => x_return_status);
9161:
9162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_lvl_ele',
9164: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
9165: ||', l_prev_term_dt = '||l_prev_term_dt
9166: ||', p_term_dt = ' || p_term_dt ||' , l_period_start '||l_period_start||', l_period_type '||l_period_type||')');

Line 9163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_lvl_ele',

9159: p_period_type => l_period_type,
9160: x_return_status => x_return_status);
9161:
9162: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9163: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_lvl_ele',
9164: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
9165: ||', l_prev_term_dt = '||l_prev_term_dt
9166: ||', p_term_dt = ' || p_term_dt ||' , l_period_start '||l_period_start||', l_period_type '||l_period_type||')');
9167: END IF;

Line 9188: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9184: x_msg_data => x_msg_data,
9185: p_letv_tbl => l_top_bs_tbl,
9186: x_letv_tbl => l_lvl_ele_tbl_out);
9187:
9188: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9189: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9190: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9191: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9192: END IF;

Line 9189: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',

9185: p_letv_tbl => l_top_bs_tbl,
9186: x_letv_tbl => l_lvl_ele_tbl_out);
9187:
9188: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9189: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9190: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9191: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9192: END IF;
9193:

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

9218: OPEN l_subline_amt_csr(l_SubLine_rec.subline_id);
9219: FETCH l_subline_amt_csr INTO l_cp_rec.cp_amt;
9220: CLOSE l_subline_amt_csr;
9221: END IF;
9222: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9223:
9224: fnd_log.STRING (fnd_log.level_statement,
9225: G_MODULE_CURRENT || '.terminate_bill_sch.cp_dtl',
9226: 'id = ' || l_all_SubLine_rec.subline_id

Line 9224: fnd_log.STRING (fnd_log.level_statement,

9220: CLOSE l_subline_amt_csr;
9221: END IF;
9222: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9223:
9224: fnd_log.STRING (fnd_log.level_statement,
9225: G_MODULE_CURRENT || '.terminate_bill_sch.cp_dtl',
9226: 'id = ' || l_all_SubLine_rec.subline_id
9227: || ', start dt = ' || l_SubLine_rec.cp_start_dt
9228: || ', end dt = ' || l_SubLine_rec.cp_end_dt

Line 9247: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9243: x_sll_tbl => l_sll_in_tbl,
9244: x_sll_db_tbl => l_sll_db_tbl,
9245: x_return_status => x_return_status );
9246:
9247: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9248: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9249: 'Get_SLL_info(x_return_status = '||x_return_status
9250: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9251: END IF;

Line 9248: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',

9244: x_sll_db_tbl => l_sll_db_tbl,
9245: x_return_status => x_return_status );
9246:
9247: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9248: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9249: 'Get_SLL_info(x_return_status = '||x_return_status
9250: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9251: END IF;
9252:

Line 9286: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9282: p_SubLine_rec => l_cp_Rec,
9283: p_top_line_bs => l_top_bs_tbl,
9284: x_return_status => x_return_status);
9285:
9286: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9287: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adjust_cp_amt',
9288: 'Adjust_top_BS_Amt(x_return_status = '||x_return_status ||')');
9289: END IF;
9290:

Line 9287: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adjust_cp_amt',

9283: p_top_line_bs => l_top_bs_tbl,
9284: x_return_status => x_return_status);
9285:
9286: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9287: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adjust_cp_amt',
9288: 'Adjust_top_BS_Amt(x_return_status = '||x_return_status ||')');
9289: END IF;
9290:
9291: IF x_return_status <> 'S' THEN

Line 9316: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9312: p_period_start => l_period_start,
9313: p_period_type => l_period_type,
9314: x_return_status => x_return_status);
9315:
9316: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9317: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_bs',
9318: 'Create_cp_lvl_elements(x_return_status = '||x_return_status ||')');
9319: END IF;
9320:

Line 9317: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_bs',

9313: p_period_type => l_period_type,
9314: x_return_status => x_return_status);
9315:
9316: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9317: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_bs',
9318: 'Create_cp_lvl_elements(x_return_status = '||x_return_status ||')');
9319: END IF;
9320:
9321: IF x_return_status <> 'S' THEN

Line 9335: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

9331: x_msg_data => x_msg_data,
9332: p_letv_tbl => l_top_bs_tbl,
9333: x_letv_tbl => l_lvl_ele_tbl_out);
9334:
9335: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9336: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9337: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9338: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9339: END IF;

Line 9336: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',

9332: p_letv_tbl => l_top_bs_tbl,
9333: x_letv_tbl => l_lvl_ele_tbl_out);
9334:
9335: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9336: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9337: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9338: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9339: END IF;
9340:

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

9669: p_cp_sll_tbl(l_cp_sll_counter).uom_per_period,
9670: l_end_date,
9671: p_term_dt);
9672:
9673: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9674: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9675: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
9676: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
9677: END IF;

Line 9674: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',

9670: l_end_date,
9671: p_term_dt);
9672:
9673: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9674: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9675: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
9676: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
9677: END IF;
9678: IF l_constant_sll_amt IS NULL THEN

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

9747: -------------------------------------------------------------------------
9748: IF p_subline_rec.cp_lse_id in (8,10,11,35) THEN
9749: l_uom := p_cp_sll_tbl(l_cp_sll_counter).uom;
9750:
9751: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9752: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9753: ' result l_uom = ' || l_uom);
9754: END IF;
9755:

Line 9752: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',

9748: IF p_subline_rec.cp_lse_id in (8,10,11,35) THEN
9749: l_uom := p_cp_sll_tbl(l_cp_sll_counter).uom;
9750:
9751: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9752: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9753: ' result l_uom = ' || l_uom);
9754: END IF;
9755:
9756: END IF;

Line 9816: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

9812: -- Added two new parameters p_period_start and p_period_type
9813: -------------------------------------------------------------------------
9814:
9815: -- Start - Modified by PMALLARA - Bug #3992530
9816: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
9817: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',
9818: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
9819: ||'period start = ' || p_period_start
9820: ||', period type = ' || p_period_type);

Line 9817: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',

9813: -------------------------------------------------------------------------
9814:
9815: -- Start - Modified by PMALLARA - Bug #3992530
9816: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
9817: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',
9818: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
9819: ||'period start = ' || p_period_start
9820: ||', period type = ' || p_period_type);
9821: END IF;

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

9882: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
9883: p_period_type => p_period_type ,
9884: p_period_start => p_period_start);
9885:
9886: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9887: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
9888: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
9889: ||' result l_quantity = ' || l_quantity);
9890: END IF;

Line 9887: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',

9883: p_period_type => p_period_type ,
9884: p_period_start => p_period_start);
9885:
9886: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9887: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
9888: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
9889: ||' result l_quantity = ' || l_quantity);
9890: END IF;
9891:

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

9895: END IF;
9896:
9897: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
9898:
9899: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9900: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
9901: ' result l_lvl_amt = ' || l_lvl_amt);
9902: END IF;
9903: --mchoudha added else logic for WEEK kind of uoms

Line 9900: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',

9896:
9897: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
9898:
9899: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9900: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
9901: ' result l_lvl_amt = ' || l_lvl_amt);
9902: END IF;
9903: --mchoudha added else logic for WEEK kind of uoms
9904: ELSE

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

9929: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
9930: p_period_type => p_period_type,
9931: p_period_start => p_period_start);
9932:
9933: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9934: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
9935: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
9936: ||' result l_quantity = ' || l_quantity);
9937: END IF;

Line 9934: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',

9930: p_period_type => p_period_type,
9931: p_period_start => p_period_start);
9932:
9933: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9934: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
9935: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
9936: ||' result l_quantity = ' || l_quantity);
9937: END IF;
9938:

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

9945:
9946:
9947: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
9948:
9949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9950: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
9951: ' result l_lvl_amt = ' || l_lvl_amt);
9952: END IF;
9953:

Line 9950: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',

9946:
9947: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
9948:
9949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9950: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
9951: ' result l_lvl_amt = ' || l_lvl_amt);
9952: END IF;
9953:
9954: --mchoudha added else logic for WEEK kind of uoms

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

9959: --errorout_ad(' l_lvl_amt '||l_lvl_amt);
9960:
9961: ELSE
9962: l_lvl_amt := nvl(l_constant_sll_amt,0);
9963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9964: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.full-period',
9965: ' l_lvl_amt = ' || l_lvl_amt);
9966: END IF;
9967:

Line 9964: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.full-period',

9960:
9961: ELSE
9962: l_lvl_amt := nvl(l_constant_sll_amt,0);
9963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9964: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.full-period',
9965: ' l_lvl_amt = ' || l_lvl_amt);
9966: END IF;
9967:
9968: --errorout_ad(' l_lvl_amt in else '||l_lvl_amt);

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

10010: p_source_uom => l_fnd_lvl_in_rec.tuom, --line price uom
10011: p_period_type => p_period_type,
10012: p_period_start => p_period_start);
10013:
10014: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10015: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10016: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10017: ||' result l_quantity = ' || l_quantity);
10018: END IF;

Line 10015: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',

10011: p_period_type => p_period_type,
10012: p_period_start => p_period_start);
10013:
10014: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10015: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10016: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10017: ||' result l_quantity = ' || l_quantity);
10018: END IF;
10019:

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

10027:
10028: l_lvl_amt := TO_NUMBER(p_cp_sll_tbl(l_cp_sll_counter).amount)*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
10029:
10030:
10031: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10032: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10033: ' result l_lvl_amt = ' || l_lvl_amt);
10034: END IF;
10035: --mchoudha added else logic for WEEK kind of uoms

Line 10032: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',

10028: l_lvl_amt := TO_NUMBER(p_cp_sll_tbl(l_cp_sll_counter).amount)*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
10029:
10030:
10031: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10032: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10033: ' result l_lvl_amt = ' || l_lvl_amt);
10034: END IF;
10035: --mchoudha added else logic for WEEK kind of uoms
10036: ELSE

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

11427: x_return_status := 'S';
11428:
11429:
11430:
11431: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11432:
11433: fnd_log.STRING (fnd_log.level_statement,
11434: G_MODULE_CURRENT || '.adjust_replace_product_bs.line_details',
11435: 'old sub line id passed = ' || p_old_cp_id

Line 11433: fnd_log.STRING (fnd_log.level_statement,

11429:
11430:
11431: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11432:
11433: fnd_log.STRING (fnd_log.level_statement,
11434: G_MODULE_CURRENT || '.adjust_replace_product_bs.line_details',
11435: 'old sub line id passed = ' || p_old_cp_id
11436: || ', new sub line id passed = ' || p_new_cp_id
11437: );

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

11444: l_old_bill_type := 'T';
11445: END IF;
11446: CLOSE l_old_bill_type_csr;
11447:
11448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11449:
11450: fnd_log.STRING (fnd_log.level_statement,
11451: G_MODULE_CURRENT || '.adjust_replace_product_bs.billing_sch_type',
11452: 'old line billing scheduel type = ' || l_old_bill_type

Line 11450: fnd_log.STRING (fnd_log.level_statement,

11446: CLOSE l_old_bill_type_csr;
11447:
11448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11449:
11450: fnd_log.STRING (fnd_log.level_statement,
11451: G_MODULE_CURRENT || '.adjust_replace_product_bs.billing_sch_type',
11452: 'old line billing scheduel type = ' || l_old_bill_type
11453: );
11454: END IF;

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

11488: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11489: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11490: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11491:
11492: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11493:
11494: fnd_log.STRING (fnd_log.level_statement,
11495: G_MODULE_CURRENT || '.adjust_replace_product_bs.new_sll_tbl_dtls',
11496: 'sll num = ' || l_sll_index

Line 11494: fnd_log.STRING (fnd_log.level_statement,

11490: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11491:
11492: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11493:
11494: fnd_log.STRING (fnd_log.level_statement,
11495: G_MODULE_CURRENT || '.adjust_replace_product_bs.new_sll_tbl_dtls',
11496: 'sll num = ' || l_sll_index
11497: || ', sll start date = ' || l_strm_lvl_tbl_in(l_sll_index).start_date
11498: || ', sll end date = ' || l_strm_lvl_tbl_in(l_sll_index).end_date

Line 11520: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

11516: x_msg_data => x_msg_data,
11517: p_sllv_tbl => l_strm_lvl_tbl_in,
11518: x_sllv_tbl => l_strm_lvl_tbl_out);
11519:
11520: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11521: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',
11522: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11523: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11524: END IF;

Line 11521: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',

11517: p_sllv_tbl => l_strm_lvl_tbl_in,
11518: x_sllv_tbl => l_strm_lvl_tbl_out);
11519:
11520: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11521: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',
11522: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11523: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11524: END IF;
11525:

Line 11534: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

11530: OPEN l_new_cp_csr;
11531: FETCH l_new_cp_csr INTO l_new_cp_rec;
11532: IF l_new_cp_csr%NOTFOUND THEN
11533: CLOSE l_new_cp_csr;
11534: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11535: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11536: 'new cp not found = ' || p_new_cp_id);
11537: END IF;
11538: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 11535: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',

11531: FETCH l_new_cp_csr INTO l_new_cp_rec;
11532: IF l_new_cp_csr%NOTFOUND THEN
11533: CLOSE l_new_cp_csr;
11534: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11535: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11536: 'new cp not found = ' || p_new_cp_id);
11537: END IF;
11538: RAISE G_EXCEPTION_HALT_VALIDATION;
11539:

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

11552: ELSE
11553: l_sll_end_date := l_strm_lvl_tbl_out(l_sll_index).end_date;
11554: END IF;
11555:
11556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11557: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_elements',
11558: 'sll rule id = ' || l_strm_lvl_tbl_out(l_sll_index).id
11559: ||', sll end date = '|| l_sll_end_date);
11560: END IF;

Line 11557: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_elements',

11553: l_sll_end_date := l_strm_lvl_tbl_out(l_sll_index).end_date;
11554: END IF;
11555:
11556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11557: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_elements',
11558: 'sll rule id = ' || l_strm_lvl_tbl_out(l_sll_index).id
11559: ||', sll end date = '|| l_sll_end_date);
11560: END IF;
11561:

Line 11569: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

11565: WHERE TRUNC(date_start) <= TRUNC(l_sll_end_date)
11566: AND TRUNC(date_start) >= TRUNC(l_strm_lvl_tbl_out(l_sll_index).start_date)
11567: AND cle_id = p_old_cp_id;
11568:
11569: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11570: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_amt',
11571: 'updated level elements = ' || sql%rowcount);
11572: END IF;
11573:

Line 11570: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_amt',

11566: AND TRUNC(date_start) >= TRUNC(l_strm_lvl_tbl_out(l_sll_index).start_date)
11567: AND cle_id = p_old_cp_id;
11568:
11569: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11570: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_amt',
11571: 'updated level elements = ' || sql%rowcount);
11572: END IF;
11573:
11574:

Line 11583: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

11579: UPDATE oks_k_lines_b
11580: SET billing_schedule_type = l_old_bill_type
11581: WHERE cle_id = p_new_cp_id;
11582:
11583: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11584: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bill_type',
11585: 'update bill schedule type of new line to = ' || l_old_bill_type);
11586: END IF;
11587:

Line 11584: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bill_type',

11580: SET billing_schedule_type = l_old_bill_type
11581: WHERE cle_id = p_new_cp_id;
11582:
11583: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11584: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bill_type',
11585: 'update bill schedule type of new line to = ' || l_old_bill_type);
11586: END IF;
11587:
11588:

Line 11597: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

11593: UPDATE oks_stream_levels_b
11594: SET level_amount = 0
11595: WHERE cle_id = p_old_cp_id;
11596:
11597: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11598: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_oldsll_amt',
11599: 'update lvl amt of old line to zero = ' || sql%rowcount );
11600: END IF;
11601:

Line 11598: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_oldsll_amt',

11594: SET level_amount = 0
11595: WHERE cle_id = p_old_cp_id;
11596:
11597: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11598: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_oldsll_amt',
11599: 'update lvl amt of old line to zero = ' || sql%rowcount );
11600: END IF;
11601:
11602: END IF; ----chk for bill type E and P

Line 11612: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

11608: SET cle_id = p_new_cp_id
11609: WHERE cle_id = p_old_cp_id;
11610:
11611:
11612: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11613: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bcl',
11614: 'updated bcl count = ' || sql%rowcount );
11615: END IF;
11616:

Line 11613: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bcl',

11609: WHERE cle_id = p_old_cp_id;
11610:
11611:
11612: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11613: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bcl',
11614: 'updated bcl count = ' || sql%rowcount );
11615: END IF;
11616:
11617: END IF; ----chk for sll count for old line

Line 11623: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

11619:
11620:
11621: EXCEPTION
11622: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11623: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11624: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11625: 'G_EXCEPTION_HALT_VALIDATION');
11626: END IF;
11627:

Line 11624: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',

11620:
11621: EXCEPTION
11622: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11623: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11624: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11625: 'G_EXCEPTION_HALT_VALIDATION');
11626: END IF;
11627:
11628: WHEN OTHERS THEN

Line 11629: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

11625: 'G_EXCEPTION_HALT_VALIDATION');
11626: END IF;
11627:
11628: WHEN OTHERS THEN
11629: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
11630: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',
11631: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
11632: END IF;
11633:

Line 11630: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',

11626: END IF;
11627:
11628: WHEN OTHERS THEN
11629: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
11630: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',
11631: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
11632: END IF;
11633:
11634: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 11757: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

11753:
11754: If l_Line_Csr%Notfound then
11755: Close l_Line_Csr;
11756: x_return_status := 'E';
11757: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11758: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11759: 'old sub line not found = ' || p_old_cp_id );
11760: END IF;
11761:

Line 11758: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',

11754: If l_Line_Csr%Notfound then
11755: Close l_Line_Csr;
11756: x_return_status := 'E';
11757: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11758: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11759: 'old sub line not found = ' || p_old_cp_id );
11760: END IF;
11761:
11762: End If;

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

11828: END IF;
11829: l_top_line_id := l_line_rec.parent_id;
11830:
11831:
11832: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11833:
11834: fnd_log.STRING (fnd_log.level_statement,
11835: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_dtls',
11836: 'old subline id = ' || l_old_cp_rec.cp_id

Line 11834: fnd_log.STRING (fnd_log.level_statement,

11830:
11831:
11832: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11833:
11834: fnd_log.STRING (fnd_log.level_statement,
11835: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_dtls',
11836: 'old subline id = ' || l_old_cp_rec.cp_id
11837: || ', start date = ' || l_old_cp_rec.cp_start_dt
11838: || ', end date = ' || l_old_cp_rec.cp_end_dt

Line 11852: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

11848:
11849: If l_Line_Csr%Notfound then
11850: Close l_Line_Csr;
11851: x_return_status := 'E';
11852: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11853: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11854: 'top line not found = ' || l_top_line_id );
11855: END IF;
11856:

Line 11853: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',

11849: If l_Line_Csr%Notfound then
11850: Close l_Line_Csr;
11851: x_return_status := 'E';
11852: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11853: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11854: 'top line not found = ' || l_top_line_id );
11855: END IF;
11856:
11857: End If;

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

11874: l_inv_rule_id := l_line_rec.inv_rule_id;
11875: l_billing_type := l_line_rec.billing_schedule_type;
11876:
11877:
11878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11879:
11880: fnd_log.STRING (fnd_log.level_statement,
11881: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_line_dtls',
11882: 'top line id = ' || l_top_line_rec.id

Line 11880: fnd_log.STRING (fnd_log.level_statement,

11876:
11877:
11878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11879:
11880: fnd_log.STRING (fnd_log.level_statement,
11881: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_line_dtls',
11882: 'top line id = ' || l_top_line_rec.id
11883: || ', start date = ' || l_top_line_rec.line_start_dt
11884: || ', end date = ' || l_top_line_rec.line_start_dt

Line 11899: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

11895:
11896: IF l_currency_code IS NULL THEN
11897: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
11898: x_return_status := 'E';
11899: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11900: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11901: 'currency not found for contract id = ' || l_top_line_rec.dnz_chr_id );
11902: END IF;
11903: RETURN;

Line 11900: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',

11896: IF l_currency_code IS NULL THEN
11897: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
11898: x_return_status := 'E';
11899: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11900: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
11901: 'currency not found for contract id = ' || l_top_line_rec.dnz_chr_id );
11902: END IF;
11903: RETURN;
11904: END IF;

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

11923: l_index := l_index + 1;
11924: END LOOP;
11925:
11926:
11927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11928:
11929: fnd_log.STRING (fnd_log.level_statement,
11930: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_bs_tbl',
11931: 'top line lvl elements count = ' || l_top_bs_tbl.count

Line 11929: fnd_log.STRING (fnd_log.level_statement,

11925:
11926:
11927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11928:
11929: fnd_log.STRING (fnd_log.level_statement,
11930: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_bs_tbl',
11931: 'top line lvl elements count = ' || l_top_bs_tbl.count
11932: );
11933: END IF;

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

11952: l_index := l_index + 1;
11953: END LOOP;
11954:
11955:
11956: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11957:
11958: fnd_log.STRING (fnd_log.level_statement,
11959: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_bs_tbl',
11960: 'old cp lvl elements count = ' || l_cp_old_bs_tbl.count

Line 11958: fnd_log.STRING (fnd_log.level_statement,

11954:
11955:
11956: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11957:
11958: fnd_log.STRING (fnd_log.level_statement,
11959: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_bs_tbl',
11960: 'old cp lvl elements count = ' || l_cp_old_bs_tbl.count
11961: );
11962: END IF;

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

11970: LOOP
11971: l_top_bs_ind := l_top_bs_tbl.NEXT(l_top_bs_ind);
11972: END LOOP;
11973:
11974: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11975:
11976: fnd_log.STRING (fnd_log.level_statement,
11977: G_MODULE_CURRENT || '.Adjust_split_bill_sch.while_top_bs',
11978: 'after while loop in top bs index = ' || l_top_bs_ind

Line 11976: fnd_log.STRING (fnd_log.level_statement,

11972: END LOOP;
11973:
11974: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11975:
11976: fnd_log.STRING (fnd_log.level_statement,
11977: G_MODULE_CURRENT || '.Adjust_split_bill_sch.while_top_bs',
11978: 'after while loop in top bs index = ' || l_top_bs_ind
11979: || ' , date start = ' || l_top_bs_tbl(l_top_bs_ind ).DATE_START
11980: );

Line 12027: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12023: x_sll_tbl => l_sll_in_tbl,
12024: x_sll_db_tbl => l_sll_db_tbl,
12025: x_return_status => x_return_status );
12026:
12027: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12028: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.get_old_cp_sll',
12029: 'Get_SLL_info(x_return_status = '||x_return_status
12030: ||', sll tbl out count = '||l_sll_db_tbl.count||')');
12031: END IF;

Line 12028: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.get_old_cp_sll',

12024: x_sll_db_tbl => l_sll_db_tbl,
12025: x_return_status => x_return_status );
12026:
12027: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12028: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.get_old_cp_sll',
12029: 'Get_SLL_info(x_return_status = '||x_return_status
12030: ||', sll tbl out count = '||l_sll_db_tbl.count||')');
12031: END IF;
12032:

Line 12065: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

12061:
12062: If l_Line_Csr%Notfound then
12063: Close l_Line_Csr;
12064: x_return_status := 'E';
12065: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12066: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12067: 'new sub line not found = ' || p_new_cp_tbl(i).id );
12068: END IF;
12069:

Line 12066: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',

12062: If l_Line_Csr%Notfound then
12063: Close l_Line_Csr;
12064: x_return_status := 'E';
12065: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12066: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12067: 'new sub line not found = ' || p_new_cp_tbl(i).id );
12068: END IF;
12069:
12070: End If;

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

12081: FETCH l_line_amt_csr INTO l_new_cp_rec.cp_amt;
12082: CLOSE l_line_amt_csr;
12083: END IF;
12084:
12085: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12086:
12087: fnd_log.STRING (fnd_log.level_statement,
12088: G_MODULE_CURRENT || '.adjust_split_bill_sch.new_cp_dtls',
12089: 'new subline id = ' || l_new_cp_rec.cp_id

Line 12087: fnd_log.STRING (fnd_log.level_statement,

12083: END IF;
12084:
12085: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12086:
12087: fnd_log.STRING (fnd_log.level_statement,
12088: G_MODULE_CURRENT || '.adjust_split_bill_sch.new_cp_dtls',
12089: 'new subline id = ' || l_new_cp_rec.cp_id
12090: || ', start date = ' || l_new_cp_rec.cp_start_dt
12091: || ', end date = ' || l_new_cp_rec.cp_end_dt

Line 12105: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12101: UPDATE OKS_K_LINES_B SET billing_schedule_type = l_billing_type
12102: WHERE cle_id = l_new_cp_rec.cp_id;
12103:
12104:
12105: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12106: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.update_bill_type',
12107: 'updated new sub line billing type = ' || sql%rowcount);
12108:
12109: END IF;

Line 12106: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.update_bill_type',

12102: WHERE cle_id = l_new_cp_rec.cp_id;
12103:
12104:
12105: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12106: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.update_bill_type',
12107: 'updated new sub line billing type = ' || sql%rowcount);
12108:
12109: END IF;
12110: END IF;

Line 12121: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12117: p_new_sll_tbl => l_new_sll_tbl,
12118: p_old_sll_tbl => l_sll_db_tbl,
12119: x_return_status => x_return_status);
12120:
12121: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12122: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.prorate_sll_amt',
12123: 'Prorate_sll_amt status = ' || x_return_status
12124: );
12125:

Line 12122: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.prorate_sll_amt',

12118: p_old_sll_tbl => l_sll_db_tbl,
12119: x_return_status => x_return_status);
12120:
12121: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12122: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.prorate_sll_amt',
12123: 'Prorate_sll_amt status = ' || x_return_status
12124: );
12125:
12126: END IF;

Line 12174: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12170: x_msg_data => x_msg_data,
12171: p_sllv_tbl => l_strm_lvl_tbl_in,
12172: x_sllv_tbl => l_strm_lvl_tbl_out);
12173:
12174: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12175: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',
12176: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12177: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12178: END IF;

Line 12175: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',

12171: p_sllv_tbl => l_strm_lvl_tbl_in,
12172: x_sllv_tbl => l_strm_lvl_tbl_out);
12173:
12174: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12175: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',
12176: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12177: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12178: END IF;
12179:

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

12201: l_cp_sll_out_tbl(l_tbl_index).Interface_offset_days := l_strm_lvl_tbl_out(l_tbl_index).interface_offset_days;
12202:
12203: END LOOP;
12204:
12205: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12206:
12207: fnd_log.STRING (fnd_log.level_statement,
12208: G_MODULE_CURRENT || '.adjust_split_bill_sch.before_new_lvl_ele',
12209: 'sll count passed to Create_cp_lvl_elements = ' || l_cp_sll_out_tbl.count);

Line 12207: fnd_log.STRING (fnd_log.level_statement,

12203: END LOOP;
12204:
12205: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12206:
12207: fnd_log.STRING (fnd_log.level_statement,
12208: G_MODULE_CURRENT || '.adjust_split_bill_sch.before_new_lvl_ele',
12209: 'sll count passed to Create_cp_lvl_elements = ' || l_cp_sll_out_tbl.count);
12210: END IF;
12211:

Line 12232: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12228: p_period_type => l_period_type,
12229: x_return_status => x_return_status);
12230:
12231:
12232: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12233: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Create_cp_lvl_elements',
12234: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12235: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12236: END IF;

Line 12233: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Create_cp_lvl_elements',

12229: x_return_status => x_return_status);
12230:
12231:
12232: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12233: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Create_cp_lvl_elements',
12234: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12235: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12236: END IF;
12237:

Line 12250: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12246: x_new_cp_bs_tbl => l_cp_new_bs_tbl,
12247: x_return_status => x_return_status);
12248:
12249:
12250: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12251: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Adjust_billed_lvl_element',
12252: 'Adjust_billed_lvl_element(x_return_status = '||x_return_status
12253: ||', l_cp_old_bs_tbl count = '||l_cp_old_bs_tbl.count||')');
12254: END IF;

Line 12251: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Adjust_billed_lvl_element',

12247: x_return_status => x_return_status);
12248:
12249:
12250: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12251: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Adjust_billed_lvl_element',
12252: 'Adjust_billed_lvl_element(x_return_status = '||x_return_status
12253: ||', l_cp_old_bs_tbl count = '||l_cp_old_bs_tbl.count||')');
12254: END IF;
12255:

Line 12274: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12270: x_msg_count => x_msg_count,
12271: x_msg_data => x_msg_data);
12272:
12273:
12274: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12275: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',
12276: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12277: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12278: END IF;

Line 12275: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',

12271: x_msg_data => x_msg_data);
12272:
12273:
12274: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12275: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',
12276: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12277: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12278: END IF;
12279:

Line 12304: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12300: SET level_amount = l_sll_db_tbl(l_index).level_amount
12301: WHERE id = l_sll_db_tbl(l_index).id;
12302:
12303:
12304: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12305: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.old_sll_amt_update',
12306: 'old sll amount update = '|| l_sll_db_tbl(l_index).level_amount
12307: ||', sll id = '|| l_sll_db_tbl(l_index).id );
12308: END IF;

Line 12305: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.old_sll_amt_update',

12301: WHERE id = l_sll_db_tbl(l_index).id;
12302:
12303:
12304: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12305: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.old_sll_amt_update',
12306: 'old sll amount update = '|| l_sll_db_tbl(l_index).level_amount
12307: ||', sll id = '|| l_sll_db_tbl(l_index).id );
12308: END IF;
12309: END IF;

Line 12348: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12344: p_period_start => l_period_start, --mchoudha fix for bug#4998167 added l_period_start
12345: p_period_type => l_period_type, --mchoudha fix for bug#4998167 added l_period_type
12346: x_return_status => x_return_status);
12347:
12348: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12349: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.refresh_old_cp_lvl',
12350: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12351: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12352: END IF;

Line 12349: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.refresh_old_cp_lvl',

12345: p_period_type => l_period_type, --mchoudha fix for bug#4998167 added l_period_type
12346: x_return_status => x_return_status);
12347:
12348: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12349: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.refresh_old_cp_lvl',
12350: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12351: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12352: END IF;
12353:

Line 12368: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12364: UPDATE OKS_LEVEL_ELEMENTS
12365: SET amount = l_top_bs_tbl(l_index).amount
12366: WHERE id = l_top_bs_tbl(l_index).id;
12367:
12368: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12369: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_split_bill_sch.update_top_lvl_amt',
12370: 'updated level elemnets of top line= ' || sql%rowcount
12371: || ' , id = ' || l_top_bs_tbl(l_index).id
12372: || ' , amt = ' || l_top_bs_tbl(l_index).amount );

Line 12369: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_split_bill_sch.update_top_lvl_amt',

12365: SET amount = l_top_bs_tbl(l_index).amount
12366: WHERE id = l_top_bs_tbl(l_index).id;
12367:
12368: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12369: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_split_bill_sch.update_top_lvl_amt',
12370: 'updated level elemnets of top line= ' || sql%rowcount
12371: || ' , id = ' || l_top_bs_tbl(l_index).id
12372: || ' , amt = ' || l_top_bs_tbl(l_index).amount );
12373: END IF;

Line 12383: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

12379: WHEN L_EXCEPTION_END THEN
12380: x_return_status := 'S';
12381: WHEN G_EXCEPTION_HALT_VALIDATION THEN
12382: x_return_status := 'E';
12383: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12384: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12385: 'G_EXCEPTION_HALT_VALIDATION');
12386: END IF;
12387:

Line 12384: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',

12380: x_return_status := 'S';
12381: WHEN G_EXCEPTION_HALT_VALIDATION THEN
12382: x_return_status := 'E';
12383: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12384: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12385: 'G_EXCEPTION_HALT_VALIDATION');
12386: END IF;
12387:
12388: WHEN OTHERS THEN

Line 12389: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

12385: 'G_EXCEPTION_HALT_VALIDATION');
12386: END IF;
12387:
12388: WHEN OTHERS THEN
12389: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12390: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',
12391: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12392: END IF;
12393:

Line 12390: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',

12386: END IF;
12387:
12388: WHEN OTHERS THEN
12389: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12390: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',
12391: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12392: END IF;
12393:
12394: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

12418: BEGIN
12419:
12420: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12421:
12422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12423:
12424: fnd_log.STRING (fnd_log.level_statement,
12425: G_MODULE_CURRENT || '.Prorate_sll_amt.passed_val',
12426: 'p_total_amt = ' || p_total_amt

Line 12424: fnd_log.STRING (fnd_log.level_statement,

12420: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12421:
12422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12423:
12424: fnd_log.STRING (fnd_log.level_statement,
12425: G_MODULE_CURRENT || '.Prorate_sll_amt.passed_val',
12426: 'p_total_amt = ' || p_total_amt
12427: ||', p_new_cp_amt = ' || p_new_cp_amt);
12428: END IF;

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

12445:
12446: p_old_sll_tbl(l_index).level_amount := nvl(p_old_sll_tbl(l_index).level_amount,0) -
12447: p_new_sll_tbl(l_index).level_amount;
12448:
12449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12450: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Prorate_sll_amt.lvl_amt',
12451: 'sll seq = ' || p_old_sll_tbl(l_index).sequence_no
12452: ||', old sll amt = '|| p_old_sll_tbl(l_index).level_amount
12453: ||', new sll amt = '|| p_new_sll_tbl(l_index).level_amount

Line 12450: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Prorate_sll_amt.lvl_amt',

12446: p_old_sll_tbl(l_index).level_amount := nvl(p_old_sll_tbl(l_index).level_amount,0) -
12447: p_new_sll_tbl(l_index).level_amount;
12448:
12449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12450: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Prorate_sll_amt.lvl_amt',
12451: 'sll seq = ' || p_old_sll_tbl(l_index).sequence_no
12452: ||', old sll amt = '|| p_old_sll_tbl(l_index).level_amount
12453: ||', new sll amt = '|| p_new_sll_tbl(l_index).level_amount
12454: ||', total amt = '|| l_tot_amt

Line 12463: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

12459:
12460: EXCEPTION
12461:
12462: WHEN OTHERS THEN
12463: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12464: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',
12465: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12466: END IF;
12467:

Line 12464: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',

12460: EXCEPTION
12461:
12462: WHEN OTHERS THEN
12463: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12464: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',
12465: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12466: END IF;
12467:
12468: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

12513: l_index := l_index + 1;
12514: END LOOP;
12515:
12516:
12517: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12518:
12519: fnd_log.STRING (fnd_log.level_statement,
12520: G_MODULE_CURRENT || '.Adjust_billed_lvl_element.new_bs_tbl',
12521: 'new sub line lvl elements count = ' || x_new_cp_bs_tbl.count);

Line 12519: fnd_log.STRING (fnd_log.level_statement,

12515:
12516:
12517: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12518:
12519: fnd_log.STRING (fnd_log.level_statement,
12520: G_MODULE_CURRENT || '.Adjust_billed_lvl_element.new_bs_tbl',
12521: 'new sub line lvl elements count = ' || x_new_cp_bs_tbl.count);
12522: END IF;
12523:

Line 12542: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

12538: UPDATE OKS_LEVEL_ELEMENTS
12539: SET amount = p_old_cp_bs_tbl(l_index).amount
12540: WHERE id = p_old_cp_bs_tbl(l_index).id;
12541:
12542: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12543: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.update_old_lvl_amt',
12544: 'updated level elemnets = ' || sql%rowcount
12545: || ' , id = ' || p_old_cp_bs_tbl(l_index).id
12546: || ' , amt = ' || p_old_cp_bs_tbl(l_index).amount );

Line 12543: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.update_old_lvl_amt',

12539: SET amount = p_old_cp_bs_tbl(l_index).amount
12540: WHERE id = p_old_cp_bs_tbl(l_index).id;
12541:
12542: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12543: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.update_old_lvl_amt',
12544: 'updated level elemnets = ' || sql%rowcount
12545: || ' , id = ' || p_old_cp_bs_tbl(l_index).id
12546: || ' , amt = ' || p_old_cp_bs_tbl(l_index).amount );
12547:

Line 12556: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN

12552:
12553: EXCEPTION
12554:
12555: WHEN OTHERS THEN
12556: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12557: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
12558: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12559: END IF;
12560:

Line 12557: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',

12553: EXCEPTION
12554:
12555: WHEN OTHERS THEN
12556: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12557: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
12558: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12559: END IF;
12560:
12561: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,