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 2194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2190: l_strm_lvl_tbl_in(1).uom_per_period := p_strm_lvl_tbl(l_tbl_count).uom_per_period;
2191: l_strm_lvl_tbl_in(1).uom_code := p_strm_lvl_tbl(l_tbl_count).uom_code;
2192:
2193:
2194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2195:
2196: fnd_log.STRING (fnd_log.level_statement,
2197: G_MODULE_CURRENT || '.create_stream_level.sll_dtls',
2198: ' line id = ' || l_strm_lvl_tbl_in(1).cle_id

Line 2196: fnd_log.STRING (fnd_log.level_statement,

2192:
2193:
2194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2195:
2196: fnd_log.STRING (fnd_log.level_statement,
2197: G_MODULE_CURRENT || '.create_stream_level.sll_dtls',
2198: ' line id = ' || l_strm_lvl_tbl_in(1).cle_id
2199: || ', chr_id = ' || l_strm_lvl_tbl_in(1).chr_id
2200: || ', start date = ' || l_strm_lvl_tbl_in(1).start_date

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

2219: x_msg_data => l_msg_data,
2220: p_sllv_tbl => l_strm_lvl_tbl_in,
2221: x_sllv_tbl => l_strm_lvl_tbl_out);
2222:
2223: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2224: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',
2225: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
2226: ||', sll id created = '||l_strm_lvl_tbl_out(1).id ||')');
2227: END IF;

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

2220: p_sllv_tbl => l_strm_lvl_tbl_in,
2221: x_sllv_tbl => l_strm_lvl_tbl_out);
2222:
2223: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2224: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.insert',
2225: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
2226: ||', sll id created = '||l_strm_lvl_tbl_out(1).id ||')');
2227: END IF;
2228:

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

2248: x_msg_data => l_msg_data,
2249: p_sllv_tbl => l_strm_lvl_tbl_in,
2250: x_sllv_tbl => l_strm_lvl_tbl_out);
2251:
2252: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2253: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',
2254: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status
2255: ||', sll id updated = '||l_strm_lvl_tbl_out(1).id ||')');
2256: END IF;

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

2249: p_sllv_tbl => l_strm_lvl_tbl_in,
2250: x_sllv_tbl => l_strm_lvl_tbl_out);
2251:
2252: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2253: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.update',
2254: 'OKS_SLL_PVT.update_row(x_return_status = '||x_return_status
2255: ||', sll id updated = '||l_strm_lvl_tbl_out(1).id ||')');
2256: END IF;
2257:

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

2279: x_sll_out_tbl(l_tbl_count).Amount := l_strm_lvl_tbl_out(1).level_amount;
2280: x_sll_out_tbl(l_tbl_count).invoice_offset_days := l_strm_lvl_tbl_out(1).invoice_offset_days;
2281: x_sll_out_tbl(l_tbl_count).Interface_offset_days := l_strm_lvl_tbl_out(1).interface_offset_days;
2282:
2283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2284:
2285: fnd_log.STRING (fnd_log.level_statement,
2286: G_MODULE_CURRENT || '.create_stream_level.top_sll_dtls',
2287: ' sll id = ' || x_sll_out_tbl(l_tbl_count).Id

Line 2285: fnd_log.STRING (fnd_log.level_statement,

2281: x_sll_out_tbl(l_tbl_count).Interface_offset_days := l_strm_lvl_tbl_out(1).interface_offset_days;
2282:
2283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2284:
2285: fnd_log.STRING (fnd_log.level_statement,
2286: G_MODULE_CURRENT || '.create_stream_level.top_sll_dtls',
2287: ' sll id = ' || x_sll_out_tbl(l_tbl_count).Id
2288: || ', start date = ' || x_sll_out_tbl(l_tbl_count).Dt_start
2289: );

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

2330: p_period_type => p_period_type,
2331: p_sll_prorated_tab => l_sll_prorate_tbl,
2332: x_return_status => x_return_status);
2333:
2334: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2335: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.prorate',
2336: 'Calculate_sll_amount(x_return_status = '||x_return_status
2337: ||', l_sll_prorate_tbl count = '|| l_sll_prorate_tbl.count ||')');
2338: END IF;

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

2331: p_sll_prorated_tab => l_sll_prorate_tbl,
2332: x_return_status => x_return_status);
2333:
2334: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2335: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_stream_level.prorate',
2336: 'Calculate_sll_amount(x_return_status = '||x_return_status
2337: ||', l_sll_prorate_tbl count = '|| l_sll_prorate_tbl.count ||')');
2338: END IF;
2339:

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

2361:
2362:
2363: EXCEPTION
2364: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2365: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2366: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_stream_level.EXCEPTION',
2367: 'G_EXCEPTION_HALT_VALIDATION');
2368: END IF;
2369: x_return_status := 'E';

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

2362:
2363: EXCEPTION
2364: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2365: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2366: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_stream_level.EXCEPTION',
2367: 'G_EXCEPTION_HALT_VALIDATION');
2368: END IF;
2369: x_return_status := 'E';
2370:

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

2368: END IF;
2369: x_return_status := 'E';
2370:
2371: WHEN OTHERS THEN
2372: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2373: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',
2374: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2375: END IF;
2376:

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

2369: x_return_status := 'E';
2370:
2371: WHEN OTHERS THEN
2372: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2373: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Stream_Level.UNEXPECTED',
2374: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2375: END IF;
2376:
2377: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

2509: -- End partial period computation logic
2510: -- Date 09-MAY-2005
2511: -------------------------------------------------------------------------
2512:
2513: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2514: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.sll',
2515: 'Create_Stream_Level(x_return_status = '||x_return_status
2516: ||', l_cp_sll_out_tbl count = '|| l_cp_sll_out_tbl.count ||')');
2517: END IF;

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

2510: -- Date 09-MAY-2005
2511: -------------------------------------------------------------------------
2512:
2513: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2514: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.sll',
2515: 'Create_Stream_Level(x_return_status = '||x_return_status
2516: ||', l_cp_sll_out_tbl count = '|| l_cp_sll_out_tbl.count ||')');
2517: END IF;
2518:

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

2541: p_period_start => p_period_start,
2542: p_period_type => p_period_type,
2543: x_return_status => x_return_status);
2544:
2545: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2546: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.lvl_ele',
2547: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
2548: ||', p_term_dt passed = '|| p_term_dt ||')');
2549: END IF;

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

2542: p_period_type => p_period_type,
2543: x_return_status => x_return_status);
2544:
2545: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2546: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.bill_sch_cp.lvl_ele',
2547: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
2548: ||', p_term_dt passed = '|| p_term_dt ||')');
2549: END IF;
2550:

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

2553: END IF;
2554:
2555: EXCEPTION
2556: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2557: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2558: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',
2559: 'G_EXCEPTION_HALT_VALIDATION');
2560: END IF;
2561:

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

2554:
2555: EXCEPTION
2556: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2557: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
2558: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.bill_sch_cp.EXCEPTION',
2559: 'G_EXCEPTION_HALT_VALIDATION');
2560: END IF;
2561:
2562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2565: RAISE OKC_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: WHEN OTHERS THEN
2568:
2569: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2570: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',
2571: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2572: END IF;
2573:

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

2566: END IF;
2567: WHEN OTHERS THEN
2568:
2569: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2570: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.bill_sch_Cp.UNEXPECTED',
2571: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2572: END IF;
2573:
2574: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

2772: x_last_cycle_dt := NULL;
2773: x_next_cycle_dt := p_sll_dt_start;
2774: l_index := 0;
2775:
2776: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2777:
2778: fnd_log.STRING (fnd_log.level_statement,
2779: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.dtls',
2780: 'sll id = ' || p_sll_id

Line 2778: fnd_log.STRING (fnd_log.level_statement,

2774: l_index := 0;
2775:
2776: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2777:
2778: fnd_log.STRING (fnd_log.level_statement,
2779: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.dtls',
2780: 'sll id = ' || p_sll_id
2781: ||', sll st dt = ' || p_sll_dt_start
2782: );

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

2943: x_next_cycle_dt := l_cp_bs_tbl(l_cp_bs_tbl.LAST ).date_end + 1;
2944: -----errorout_ad('NEXT DATE = ' || x_next_cycle_dt);
2945: END IF;
2946:
2947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2948:
2949: fnd_log.STRING (fnd_log.level_statement,
2950: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.out',
2951: 'x_next_cycle_dt = ' || x_next_cycle_dt);

Line 2949: fnd_log.STRING (fnd_log.level_statement,

2945: END IF;
2946:
2947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2948:
2949: fnd_log.STRING (fnd_log.level_statement,
2950: G_MODULE_CURRENT || '.Check_Existing_Lvlelement.out',
2951: 'x_next_cycle_dt = ' || x_next_cycle_dt);
2952: END IF;
2953:

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

2953:
2954: Exception
2955:
2956: WHEN OTHERS then
2957: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2958: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Check_Existing_Lvlelement.UNEXPECTED',
2959: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2960: END IF;
2961: x_return_status := 'E';

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

2954: Exception
2955:
2956: WHEN OTHERS then
2957: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
2958: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Check_Existing_Lvlelement.UNEXPECTED',
2959: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2960: END IF;
2961: x_return_status := 'E';
2962:

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

3044: ELSE
3045: l_adjusted_amount := l_round_cycle_amt;
3046: END IF;
3047:
3048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3049:
3050: fnd_log.STRING (fnd_log.level_statement,
3051: G_MODULE_CURRENT || '.Find_Adjusted_Amount.info',
3052: 'l_adjusted_amount = ' || l_adjusted_amount

Line 3050: fnd_log.STRING (fnd_log.level_statement,

3046: END IF;
3047:
3048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3049:
3050: fnd_log.STRING (fnd_log.level_statement,
3051: G_MODULE_CURRENT || '.Find_Adjusted_Amount.info',
3052: 'l_adjusted_amount = ' || l_adjusted_amount
3053: ||', line id = ' || p_line_id
3054: );

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

3161: ELSE
3162: l_line_end_date := TRUNC(nvl((p_term_dt - 1), p_line_rec.line_end_dt));
3163: END IF;
3164:
3165: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3166:
3167: fnd_log.STRING (fnd_log.level_statement,
3168: G_MODULE_CURRENT || '.Create_Level_elements.info',
3169: 'l_chk_round_adjustment = ' || l_chk_round_adjustment

Line 3167: fnd_log.STRING (fnd_log.level_statement,

3163: END IF;
3164:
3165: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3166:
3167: fnd_log.STRING (fnd_log.level_statement,
3168: G_MODULE_CURRENT || '.Create_Level_elements.info',
3169: 'l_chk_round_adjustment = ' || l_chk_round_adjustment
3170: ||', l_line_end_date (up to lvl ele) = ' || l_line_end_date
3171: ||', l_bill_type = ' || l_bill_type

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

3178:
3179: Delete_lvl_element(p_cle_id => p_line_rec.id,
3180: x_return_status => x_return_status);
3181:
3182: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3183: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.del_ele',
3184: 'Delete_lvl_element(x_return_status = '||x_return_status
3185: ||', line id passed = '|| p_line_rec.id ||')');
3186: END IF;

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

3179: Delete_lvl_element(p_cle_id => p_line_rec.id,
3180: x_return_status => x_return_status);
3181:
3182: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3183: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.del_ele',
3184: 'Delete_lvl_element(x_return_status = '||x_return_status
3185: ||', line id passed = '|| p_line_rec.id ||')');
3186: END IF;
3187:

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

3197: ---if (line terminated - 1) < line_start_dt
3198: IF TRUNC(p_line_rec.line_start_dt) > TRUNC(l_line_end_date) or
3199: TRUNC( p_line_rec.line_start_dt) > trunc(nvl((p_term_dt - 1),p_line_rec.line_end_dt)) THEN
3200:
3201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3202:
3203: fnd_log.STRING (fnd_log.level_statement,
3204: G_MODULE_CURRENT || '.Create_Level_elements.chk',
3205: 'BS not created as line start dt > line en dt');

Line 3203: fnd_log.STRING (fnd_log.level_statement,

3199: TRUNC( p_line_rec.line_start_dt) > trunc(nvl((p_term_dt - 1),p_line_rec.line_end_dt)) THEN
3200:
3201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3202:
3203: fnd_log.STRING (fnd_log.level_statement,
3204: G_MODULE_CURRENT || '.Create_Level_elements.chk',
3205: 'BS not created as line start dt > line en dt');
3206: END IF;
3207:

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

3276:
3277: l_next_cycle_dt := l_next_cycle_dt + 1;
3278: END IF; --next cycle dt is null
3279:
3280: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3281:
3282: fnd_log.STRING (fnd_log.level_statement,
3283: G_MODULE_CURRENT || '.Create_Level_elements.loop_info',
3284: 'L_next_cycle_dt = ' || L_next_cycle_dt

Line 3282: fnd_log.STRING (fnd_log.level_statement,

3278: END IF; --next cycle dt is null
3279:
3280: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3281:
3282: fnd_log.STRING (fnd_log.level_statement,
3283: G_MODULE_CURRENT || '.Create_Level_elements.loop_info',
3284: 'L_next_cycle_dt = ' || L_next_cycle_dt
3285: ||', last date = ' || l_last_cycle_dt
3286: ||', uom = ' || p_sll_tbl(l_line_sll_counter).uom

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

3298: x_return_status => x_return_status,
3299: x_quantity => l_uom_quantity ,
3300: x_timeunit => l_tce_code);
3301:
3302: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3303: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',
3304: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status
3305: ||', x_timeunit = ' || l_tce_code
3306: ||', x_quantity = '|| l_uom_quantity ||')');

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

3299: x_quantity => l_uom_quantity ,
3300: x_timeunit => l_tce_code);
3301:
3302: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3303: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.seed_time',
3304: 'OKS_BILL_UTIL_PUB.get_seeded_timeunit(x_return_status = '||x_return_status
3305: ||', x_timeunit = ' || l_tce_code
3306: ||', x_quantity = '|| l_uom_quantity ||')');
3307: END IF;

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

3323:
3324: --errorout_ad('shd not enter Get_Constant_sll_Amount = ' || x_return_status);
3325:
3326:
3327: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3328: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.sll_amt',
3329: 'Get_Constant_sll_Amount(x_return_status = '||x_return_status
3330: ||', sll amt = ' || l_constant_sll_amt
3331: ||', l_remaining_amt passed = '|| l_remaining_amt ||')');

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

3324: --errorout_ad('shd not enter Get_Constant_sll_Amount = ' || x_return_status);
3325:
3326:
3327: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3328: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.sll_amt',
3329: 'Get_Constant_sll_Amount(x_return_status = '||x_return_status
3330: ||', sll amt = ' || l_constant_sll_amt
3331: ||', l_remaining_amt passed = '|| l_remaining_amt ||')');
3332: END IF;

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

3378: -- Developer Mani Choudhary
3379: -- Date 09-MAY-2005
3380: -- Added two new parameters p_period_start and p_period_type
3381: -- Start - Modified by PMALLARA - Bug #3992530
3382: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
3383: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3384: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
3385: ||'period start = ' || p_period_start
3386: ||', period type = ' || p_period_type);

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

3379: -- Date 09-MAY-2005
3380: -- Added two new parameters p_period_start and p_period_type
3381: -- Start - Modified by PMALLARA - Bug #3992530
3382: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
3383: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3384: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
3385: ||'period start = ' || p_period_start
3386: ||', period type = ' || p_period_type);
3387: END IF;

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

3399: Strm_Start_Date => Strm_Start_Date);
3400: -- End - Modified by PMALLARA - Bug #3992530
3401:
3402:
3403: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3404: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3405: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3406: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3407: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period

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

3400: -- End - Modified by PMALLARA - Bug #3992530
3401:
3402:
3403: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3404: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.lvl_loop',
3405: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3406: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3407: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3408: ||', cycle_start_date = '|| l_next_cycle_dt ||')');

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

3479: p_source_uom => l_fnd_lvl_in_rec.tuom ,
3480: p_period_type => p_period_type,
3481: p_period_start => p_period_start);
3482:
3483: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3484: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3485: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start
3486: ||' result l_quantity = ' || l_quantity);
3487: END IF;

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

3480: p_period_type => p_period_type,
3481: p_period_start => p_period_start);
3482:
3483: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3484: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3485: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start
3486: ||' result l_quantity = ' || l_quantity);
3487: END IF;
3488:

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

3492:
3493:
3494: l_adjusted_amount :=p_sll_tbl(l_line_sll_counter).amount*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
3495:
3496: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3497: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3498: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '
3499: ||' result l_adjusted_amount = ' || l_adjusted_amount);
3500: END IF;

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

3493:
3494: l_adjusted_amount :=p_sll_tbl(l_line_sll_counter).amount*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
3495:
3496: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3497: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3498: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '
3499: ||' result l_adjusted_amount = ' || l_adjusted_amount);
3500: END IF;
3501: --mchoudha fix for bug#5200003

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

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

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

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

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

3608: p_term_dt => p_term_dt,
3609: p_cycle_end_dt => l_fnd_lvl_out_rec.next_cycle_date - 1,
3610: p_amount => nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0));
3611:
3612: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3613: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',
3614: 'find_term_amt(x_return_status = '||x_return_status
3615: ||', l_term_amt = ' || l_term_amt
3616: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start

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

3609: p_cycle_end_dt => l_fnd_lvl_out_rec.next_cycle_date - 1,
3610: p_amount => nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0));
3611:
3612: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3613: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.term_period',
3614: 'find_term_amt(x_return_status = '||x_return_status
3615: ||', l_term_amt = ' || l_term_amt
3616: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start
3617: ||', p_term_dt = ' || p_Line_rec.line_end_dt

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

3616: ||', p_cycle_st_dt = ' || l_lvl_ele_tbl_in(l_tbl_seq).date_start
3617: ||', p_term_dt = ' || p_Line_rec.line_end_dt
3618: ||', lvl amt = ' || nvl(l_lvl_ele_tbl_in(l_tbl_seq).amount,0)
3619: ||', p_cycle_end_dt = '|| l_fnd_lvl_out_rec.next_cycle_date - 1 ||')');
3620: END IF; -- fnd_log.level_event >= fnd_log.g_current_runtime_level
3621: END IF; -- TRUNC(l_fnd_lvl_out_rec.next_cycle_date - 1 ) > p_Line_rec.line_end_dt
3622:
3623:
3624: l_lvl_ele_tbl_in(l_tbl_seq).amount := l_term_amt;

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

3666: x_msg_data => l_msg_data,
3667: p_letv_tbl => l_lvl_ele_tbl_in,
3668: x_letv_tbl => l_lvl_ele_tbl_out);
3669:
3670: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3671: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',
3672: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3673: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3674: END IF;

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

3667: p_letv_tbl => l_lvl_ele_tbl_in,
3668: x_letv_tbl => l_lvl_ele_tbl_out);
3669:
3670: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3671: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Level_elements.insert',
3672: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3673: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3674: END IF;
3675:

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

3690: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3691: x_return_status := G_RET_STS_ERROR;
3692: WHEN OTHERS THEN
3693:
3694: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3695: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',
3696: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3697: END IF;
3698: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

3691: x_return_status := G_RET_STS_ERROR;
3692: WHEN OTHERS THEN
3693:
3694: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3695: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Create_Level_elements.UNEXPECTED',
3696: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3697: END IF;
3698: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3699: p_msg_name => G_UNEXPECTED_ERROR,

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

3763: Del_hdr_lvl_element(p_hdr_id => p_hdr_rec.id,
3764: x_return_status => x_return_status);
3765:
3766:
3767: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3768: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Hdr_Level_elements.del_ele',
3769: 'Del_hdr_lvl_element(x_return_status = '||x_return_status
3770: ||', p_hdr_id passed = '||p_hdr_rec.id ||')');
3771: END IF;

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

3764: x_return_status => x_return_status);
3765:
3766:
3767: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3768: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Create_Hdr_Level_elements.del_ele',
3769: 'Del_hdr_lvl_element(x_return_status = '||x_return_status
3770: ||', p_hdr_id passed = '||p_hdr_rec.id ||')');
3771: END IF;
3772:

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

3827: p_period_type => p_period_type,
3828: Strm_Start_Date => Strm_Start_Date);
3829: -- End - Modified by PMALLARA - Bug #3992530
3830:
3831: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3832: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',
3833: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3834: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3835: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period

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

3828: Strm_Start_Date => Strm_Start_Date);
3829: -- End - Modified by PMALLARA - Bug #3992530
3830:
3831: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3832: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.lvl_loop',
3833: 'oks_bill_util_pub.Get_next_bill_sch(x_return_status = '||x_return_status
3834: ||', next date = ' || l_fnd_lvl_out_rec.next_cycle_date
3835: ||', tuom per period = ' || l_fnd_lvl_in_rec.tuom_per_period
3836: ||', cycle_start_date = '|| l_next_cycle_dt ||')');

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

3916: x_msg_data => l_msg_data,
3917: p_letv_tbl => l_lvl_ele_tbl_in,
3918: x_letv_tbl => l_lvl_ele_tbl_out);
3919:
3920: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3921: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',
3922: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3923: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3924: END IF;

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

3917: p_letv_tbl => l_lvl_ele_tbl_in,
3918: x_letv_tbl => l_lvl_ele_tbl_out);
3919:
3920: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
3921: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_hdr_level_elements.insert',
3922: 'oks_bill_level_elements_pvt.insert_row(x_return_status = '||x_return_status
3923: ||', l_lvl_ele_tbl_out = '|| l_lvl_ele_tbl_out.count ||')');
3924: END IF;
3925:

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

3939:
3940:
3941: EXCEPTION
3942: WHEN OTHERS THEN
3943: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3944: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',
3945: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3946: END IF;
3947: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

3940:
3941: EXCEPTION
3942: WHEN OTHERS THEN
3943: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
3944: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_hdr_level_elements.UNEXPECTED',
3945: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
3946: END IF;
3947: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
3948: p_msg_name => G_UNEXPECTED_ERROR,

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

4274: UPDATE oks_stream_levels_b
4275: set level_amount = l_strm_lvl_tbl_in(i).level_amount
4276: WHERE id = l_strm_lvl_tbl_in(i).id;
4277:
4278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4279:
4280: fnd_log.STRING (fnd_log.level_statement,
4281: G_MODULE_CURRENT || '.update_sll_amount.update',
4282: 'update sll id = ' || l_strm_lvl_tbl_in(i).id

Line 4280: fnd_log.STRING (fnd_log.level_statement,

4276: WHERE id = l_strm_lvl_tbl_in(i).id;
4277:
4278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4279:
4280: fnd_log.STRING (fnd_log.level_statement,
4281: G_MODULE_CURRENT || '.update_sll_amount.update',
4282: 'update sll id = ' || l_strm_lvl_tbl_in(i).id
4283: ||', amt = ' || l_strm_lvl_tbl_in(i).level_amount
4284: );

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

4287: END IF; ---sll tbl count chk
4288:
4289: EXCEPTION
4290: WHEN OTHERS THEN
4291: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4292: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',
4293: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4294: END IF;
4295: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

4288:
4289: EXCEPTION
4290: WHEN OTHERS THEN
4291: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4292: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_sll_amount.UNEXPECTED',
4293: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4294: END IF;
4295: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4296: p_msg_name => G_UNEXPECTED_ERROR,

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

4347: -- Developer Mani Choudhary
4348: -- Date 31-MAY-2005
4349: -- Proration to consider period start and period type
4350: -------------------------------------------------------------------------
4351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4352: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4353: 'input parameters period start '||p_period_start
4354: ||' p_period_type = ' || p_period_type);
4355: END IF;

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

4348: -- Date 31-MAY-2005
4349: -- Proration to consider period start and period type
4350: -------------------------------------------------------------------------
4351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4352: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4353: 'input parameters period start '||p_period_start
4354: ||' p_period_type = ' || p_period_type);
4355: END IF;
4356:

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

4375: p_source_uom => l_uom_code,
4376: p_period_type => p_period_type,
4377: p_period_start => p_period_start
4378: );
4379: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4380: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4381: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4382: ||' result l_temp '||l_temp);
4383: END IF;

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

4376: p_period_type => p_period_type,
4377: p_period_start => p_period_start
4378: );
4379: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4380: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4381: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4382: ||' result l_temp '||l_temp);
4383: END IF;
4384:

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

4387: END IF;
4388:
4389: l_next_frequency :=l_next_frequency + l_temp;
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_next_frequency '||l_next_frequency);
4395: END IF;

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

4388:
4389: l_next_frequency :=l_next_frequency + l_temp;
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_next_frequency '||l_next_frequency);
4395: END IF;
4396:

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

4404: p_source_uom => l_uom_code,
4405: p_period_type => p_period_type,
4406: p_period_start => p_period_start
4407: );
4408: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4409: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4410: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4411: ||' result l_curr_frequency '||l_curr_frequency);
4412: END IF;

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

4405: p_period_type => p_period_type,
4406: p_period_start => p_period_start
4407: );
4408: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4409: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4410: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4411: ||' result l_curr_frequency '||l_curr_frequency);
4412: END IF;
4413:

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

4433:
4434:
4435: -- l_tot_frequency := l_tot_frequency + l_curr_frequency + l_next_frequency;
4436:
4437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4438: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4439: ' result l_tot_frequency '||l_tot_frequency);
4440: END IF;
4441:

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

4434:
4435: -- l_tot_frequency := l_tot_frequency + l_curr_frequency + l_next_frequency;
4436:
4437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4438: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4439: ' result l_tot_frequency '||l_tot_frequency);
4440: END IF;
4441:
4442: --errorout_ad('l_tot_frequency '||l_tot_frequency);

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

4446: l_period_sll_amt := ( l_sll_remain_amount /( nvl(l_tot_frequency,1) * nvl(l_sll_period,1))) * nvl(l_curr_frequency,0) ;
4447:
4448: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4449:
4450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4451: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4452: ' result l_period_sll_amt '||l_period_sll_amt);
4453: END IF;
4454:

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

4447:
4448: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4449:
4450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4451: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4452: ' result l_period_sll_amt '||l_period_sll_amt);
4453: END IF;
4454:
4455:

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

4454:
4455:
4456: l_sll_remain_amount := l_sll_remain_amount - (l_period_sll_amt * nvl(l_sll_period,1)) ;
4457:
4458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4459: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4460: ' result l_sll_remain_amount '||l_sll_remain_amount);
4461: END IF;
4462:

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

4455:
4456: l_sll_remain_amount := l_sll_remain_amount - (l_period_sll_amt * nvl(l_sll_period,1)) ;
4457:
4458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4459: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4460: ' result l_sll_remain_amount '||l_sll_remain_amount);
4461: END IF;
4462:
4463: --errorout_ad('l_period_sll_amt '||l_period_sll_amt);

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

4894: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4895: -----errorout_ad('p_tce_code = ' || p_tce_code);
4896: -----errorout_ad('p_uom_quantity = ' || p_uom_quantity);
4897:
4898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4899:
4900: fnd_log.STRING (fnd_log.level_statement,
4901: G_MODULE_CURRENT || '.get_constant_sll_amount.info',
4902: 'p_tce_code = ' || p_tce_code

Line 4900: fnd_log.STRING (fnd_log.level_statement,

4896: -----errorout_ad('p_uom_quantity = ' || p_uom_quantity);
4897:
4898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4899:
4900: fnd_log.STRING (fnd_log.level_statement,
4901: G_MODULE_CURRENT || '.get_constant_sll_amount.info',
4902: 'p_tce_code = ' || p_tce_code
4903: ||', p_uom_quantity = ' || p_uom_quantity
4904: ||', p_remaining_amount = ' || p_remaining_amount

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

4923: x_return_status => x_return_status);
4924:
4925: END IF;
4926:
4927: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4928: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',
4929: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4930: ||', l_frequency = '|| l_frequency ||')');
4931: END IF;

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

4924:
4925: END IF;
4926:
4927: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
4928: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_constant_sll_amount.freq',
4929: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
4930: ||', l_frequency = '|| l_frequency ||')');
4931: END IF;
4932:

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

4944: -----errorout_ad('x_constant_sll_amt = ' || x_constant_sll_amt);
4945: EXCEPTION
4946: WHEN OTHERS THEN
4947:
4948: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4949: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',
4950: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4951: END IF;
4952: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

4945: EXCEPTION
4946: WHEN OTHERS THEN
4947:
4948: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
4949: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_constant_sll_amount.UNEXPECTED',
4950: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
4951: END IF;
4952: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
4953: p_msg_name => G_UNEXPECTED_ERROR,

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

4995:
4996: End If;
4997:
4998:
4999: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5000: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',
5001: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
5002: ||', x_period_freq = '|| x_period_freq ||')');
5003: END IF;

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

4996: End If;
4997:
4998:
4999: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5000: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.get_period_frequency.freq',
5001: 'oks_bill_util_pub.get_frequency(x_return_status = '||x_return_status
5002: ||', x_period_freq = '|| x_period_freq ||')');
5003: END IF;
5004:

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

5010:
5011: EXCEPTION
5012: WHEN OTHERS THEN
5013:
5014: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5015: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',
5016: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5017: END IF;
5018: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

5011: EXCEPTION
5012: WHEN OTHERS THEN
5013:
5014: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5015: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.get_period_frequency.UNEXPECTED',
5016: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5017: END IF;
5018: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5019: p_msg_name => G_UNEXPECTED_ERROR,

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

5162: Fetch l_Line_Csr Into l_Line_Csr_Rec;
5163:
5164: If l_Line_Csr%Notfound then
5165: Close l_Line_Csr;
5166: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5167: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5168: 'top line not found = ' || p_top_line_id );
5169: END IF;
5170: x_return_status := 'E';

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

5163:
5164: If l_Line_Csr%Notfound then
5165: Close l_Line_Csr;
5166: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5167: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5168: 'top line not found = ' || p_top_line_id );
5169: END IF;
5170: x_return_status := 'E';
5171: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'LINE NOT FOUND');

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

5239: FETCH l_line_amt_csr INTO l_line_rec.line_amt;
5240: CLOSE l_line_amt_csr;
5241: END IF;
5242:
5243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5244:
5245: fnd_log.STRING (fnd_log.level_statement,
5246: G_MODULE_CURRENT || '.create_bill_sch_cp.line_dtls',
5247: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 5245: fnd_log.STRING (fnd_log.level_statement,

5241: END IF;
5242:
5243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5244:
5245: fnd_log.STRING (fnd_log.level_statement,
5246: G_MODULE_CURRENT || '.create_bill_sch_cp.line_dtls',
5247: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
5248: || ', id = ' || l_line_rec.id
5249: || ', lse_id = ' || l_line_rec.lse_id

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

5297:
5298: l_index := l_index + 1;
5299: END LOOP;
5300:
5301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5302:
5303: fnd_log.STRING (fnd_log.level_statement,
5304: G_MODULE_CURRENT || '.create_bill_sch_cp.sll_tbl',
5305: 'top line sll tbl count = ' || l_sll_tbl.count

Line 5303: fnd_log.STRING (fnd_log.level_statement,

5299: END LOOP;
5300:
5301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5302:
5303: fnd_log.STRING (fnd_log.level_statement,
5304: G_MODULE_CURRENT || '.create_bill_sch_cp.sll_tbl',
5305: 'top line sll tbl count = ' || l_sll_tbl.count
5306: );
5307: END IF;

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

5374:
5375: l_cp_rec.cp_amt := l_amount;
5376: END IF;
5377:
5378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5379:
5380: fnd_log.STRING (fnd_log.level_statement,
5381: G_MODULE_CURRENT || '.create_bill_sch_cp.cp_dtls',
5382: 'p_cp_new = ' || p_cp_new

Line 5380: fnd_log.STRING (fnd_log.level_statement,

5376: END IF;
5377:
5378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5379:
5380: fnd_log.STRING (fnd_log.level_statement,
5381: G_MODULE_CURRENT || '.create_bill_sch_cp.cp_dtls',
5382: 'p_cp_new = ' || p_cp_new
5383: || ', id = ' || l_cp_rec.cp_id
5384: || ', start dt = ' || l_cp_rec.cp_start_dt

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

5421:
5422: l_index := l_index + 1;
5423: END LOOP; --top line lvl element
5424:
5425: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5426:
5427: fnd_log.STRING (fnd_log.level_statement,
5428: G_MODULE_CURRENT || '.create_bill_sch_cp.bs_tbl',
5429: 'top line bs tbl count = ' || l_top_bs_tbl.count

Line 5427: fnd_log.STRING (fnd_log.level_statement,

5423: END LOOP; --top line lvl element
5424:
5425: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5426:
5427: fnd_log.STRING (fnd_log.level_statement,
5428: G_MODULE_CURRENT || '.create_bill_sch_cp.bs_tbl',
5429: 'top line bs tbl count = ' || l_top_bs_tbl.count
5430: );
5431: END IF;

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

5440: p_invoice_rule_id => l_line_csr_rec.inv_id,
5441: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
5442: x_return_status => x_return_status);
5443:
5444: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5445: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.call_bs',
5446: 'Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
5447: END IF;
5448:

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

5441: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
5442: x_return_status => x_return_status);
5443:
5444: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5445: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.call_bs',
5446: 'Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
5447: END IF;
5448:
5449: IF x_return_status <> 'S' THEN

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

5460: p_SubLine_rec => l_cp_Rec,
5461: p_top_line_bs => l_top_bs_tbl,
5462: x_return_status => x_return_status);
5463:
5464: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5465: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.adjust',
5466: 'adjust_top_bs_amt(x_return_status = '||x_return_status ||')');
5467: END IF;
5468:

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

5461: p_top_line_bs => l_top_bs_tbl,
5462: x_return_status => x_return_status);
5463:
5464: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5465: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.adjust',
5466: 'adjust_top_bs_amt(x_return_status = '||x_return_status ||')');
5467: END IF;
5468:
5469:

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

5491: p_period_start => l_period_start,
5492: p_period_type => l_period_type,
5493: x_return_status => x_return_status);
5494:
5495: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5496: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.cp_bs',
5497: 'Bill_Sch_Cp(x_return_status = '||x_return_status ||')');
5498: END IF;
5499:

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

5492: p_period_type => l_period_type,
5493: x_return_status => x_return_status);
5494:
5495: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5496: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.cp_bs',
5497: 'Bill_Sch_Cp(x_return_status = '||x_return_status ||')');
5498: END IF;
5499:
5500:

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

5509: x_msg_data => x_msg_data,
5510: p_letv_tbl => l_top_bs_tbl,
5511: x_letv_tbl => l_lvl_ele_tbl_out);
5512:
5513: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5514: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',
5515: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');
5516: END IF;
5517: else

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

5510: p_letv_tbl => l_top_bs_tbl,
5511: x_letv_tbl => l_lvl_ele_tbl_out);
5512:
5513: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5514: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_bill_sch_cp.update_top_bs',
5515: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status ||')');
5516: END IF;
5517: else
5518:

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

5522: END IF;
5523:
5524: EXCEPTION
5525: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5526: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5527: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5528: 'G_EXCEPTION_HALT_VALIDATION');
5529: END IF;
5530:

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

5523:
5524: EXCEPTION
5525: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5526: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
5527: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_bill_sch_cp.EXCEPTION',
5528: 'G_EXCEPTION_HALT_VALIDATION');
5529: END IF;
5530:
5531: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

5533: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5534: RAISE OKC_API.G_EXCEPTION_ERROR;
5535: END IF;
5536: WHEN OTHERS THEN
5537: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5538: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',
5539: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5540: END IF;
5541: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

5534: RAISE OKC_API.G_EXCEPTION_ERROR;
5535: END IF;
5536: WHEN OTHERS THEN
5537: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
5538: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_bill_sch_cp.UNEXPECTED',
5539: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
5540: END IF;
5541: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
5542: p_msg_name => G_UNEXPECTED_ERROR,

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

5649: --it adjusts the sll and lvl element according to new line start and end date.
5650:
5651: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5652:
5653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5654:
5655: fnd_log.STRING (fnd_log.level_statement,
5656: G_MODULE_CURRENT || '.cascade_dates_sll.line_passed',
5657: 'top line id passed = ' || p_top_line_id );

Line 5655: fnd_log.STRING (fnd_log.level_statement,

5651: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5652:
5653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5654:
5655: fnd_log.STRING (fnd_log.level_statement,
5656: G_MODULE_CURRENT || '.cascade_dates_sll.line_passed',
5657: 'top line id passed = ' || p_top_line_id );
5658: END IF;
5659:

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

5710: FETCH Get_price_uom into l_price_uom;
5711: CLOSE Get_price_uom;
5712: END IF;
5713:
5714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5715:
5716: fnd_log.STRING (fnd_log.level_statement,
5717: G_MODULE_CURRENT || '.cascade_dates_sll.line_dtls',
5718: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 5716: fnd_log.STRING (fnd_log.level_statement,

5712: END IF;
5713:
5714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5715:
5716: fnd_log.STRING (fnd_log.level_statement,
5717: G_MODULE_CURRENT || '.cascade_dates_sll.line_dtls',
5718: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
5719: || ', id = ' || l_line_rec.id
5720: || ', lse_id = ' || l_line_rec.lse_id

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

5813:
5814: l_index := l_index + 1;
5815: END LOOP; --sll csr end loop
5816:
5817: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5818:
5819: fnd_log.STRING (fnd_log.level_statement,
5820: G_MODULE_CURRENT || '.cascade_dates_sll.sll_tbl',
5821: 'top line sll tbl count = ' || l_sll_tbl.count

Line 5819: fnd_log.STRING (fnd_log.level_statement,

5815: END LOOP; --sll csr end loop
5816:
5817: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5818:
5819: fnd_log.STRING (fnd_log.level_statement,
5820: G_MODULE_CURRENT || '.cascade_dates_sll.sll_tbl',
5821: 'top line sll tbl count = ' || l_sll_tbl.count
5822: );
5823: END IF;

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

5853: x_return_status => x_return_status,
5854: x_msg_count => x_msg_count,
5855: x_msg_data => x_msg_data);
5856:
5857: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5858: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_lvl_ele',
5859: 'Del_sll_lvlelement(x_return_status = '||x_return_status
5860: ||', line passed = '|| p_top_line_id ||')');
5861: END IF;

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

5854: x_msg_count => x_msg_count,
5855: x_msg_data => x_msg_data);
5856:
5857: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5858: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_lvl_ele',
5859: 'Del_sll_lvlelement(x_return_status = '||x_return_status
5860: ||', line passed = '|| p_top_line_id ||')');
5861: END IF;
5862:

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

5868:
5869: IF TRUNC(l_sll_start_date) > l_line_rec.line_start_dt THEN
5870: ---add one sll in the starting with uom code got from timeutil pub
5871:
5872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5873:
5874: fnd_log.STRING (fnd_log.level_statement,
5875: G_MODULE_CURRENT || '.cascade_dates_sll.if_stat',
5876: 'sll st dt > line st dt'

Line 5874: fnd_log.STRING (fnd_log.level_statement,

5870: ---add one sll in the starting with uom code got from timeutil pub
5871:
5872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5873:
5874: fnd_log.STRING (fnd_log.level_statement,
5875: G_MODULE_CURRENT || '.cascade_dates_sll.if_stat',
5876: 'sll st dt > line st dt'
5877: || ', sll st dt = ' || l_sll_start_date
5878: );

Line 5929: --fnd_log statement

5925: x_timeunit => l_timeunit,
5926: x_return_status => x_return_status);
5927:
5928: --mchoudha bug#5076095 added to_char for the dates in the following
5929: --fnd_log statement
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.sll_duration',
5932: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5933: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')

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

5926: x_return_status => x_return_status);
5927:
5928: --mchoudha bug#5076095 added to_char for the dates in the following
5929: --fnd_log statement
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.sll_duration',
5932: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5933: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')
5934: ||', st date MM/DD/YYYY HH24:MI:SS ='|| to_char(l_line_rec.line_start_dt,'MM/DD/YYYY HH24:MI:SS')

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

5927:
5928: --mchoudha bug#5076095 added to_char for the dates in the following
5929: --fnd_log statement
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.sll_duration',
5932: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
5933: ||', end date in MM/DD/YYYY HH24:MI:SS = ' || to_char(l_sll_start_date - 1,'MM/DD/YYYY HH24:MI:SS')
5934: ||', st date MM/DD/YYYY HH24:MI:SS ='|| to_char(l_line_rec.line_start_dt,'MM/DD/YYYY HH24:MI:SS')
5935: ||', returned timeunit and duration = ' ||l_duration || '-' || l_timeunit ||')');

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

5946: x_return_status => x_return_status,
5947: x_quantity => l_uom_quantity ,
5948: x_timeunit => l_tce_code);
5949:
5950: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5951: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5952: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5953: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5954: END IF;

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

5947: x_quantity => l_uom_quantity ,
5948: x_timeunit => l_tce_code);
5949:
5950: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5951: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5952: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5953: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5954: END IF;
5955:

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

5978: x_return_status => x_return_status,
5979: x_quantity => l_uom_quantity ,
5980: x_timeunit => l_tce_code);
5981:
5982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5984: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5985: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5986: END IF;

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

5979: x_quantity => l_uom_quantity ,
5980: x_timeunit => l_tce_code);
5981:
5982: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
5983: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seeded',
5984: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
5985: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
5986: END IF;
5987:

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

6061: l_sll_tbl(0).level_periods := l_period_freq;
6062: l_sll_tbl(0).uom_per_period := l_duration;
6063: l_sll_tbl(0).uom_code := l_timeunit;
6064:
6065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6066:
6067: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6068: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status
6069: ||', l_period_freq = '|| l_period_freq

Line 6067: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',

6063: l_sll_tbl(0).uom_code := l_timeunit;
6064:
6065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6066:
6067: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6068: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status
6069: ||', l_period_freq = '|| l_period_freq
6070: ||', l_duration = ' || l_duration ||',l_timeunit = '||l_timeunit ||')');
6071:

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

6132:
6133:
6134: ELSIF TRUNC(l_sll_start_date) < l_line_rec.line_start_dt THEN ---LINE START DATE is pushed forward
6135:
6136: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6137:
6138: fnd_log.STRING (fnd_log.level_statement,
6139: G_MODULE_CURRENT || '.cascade_dates_sll.chk_sll_dt',
6140: 'sll st dt < line st dt - line start date is pushed forward'

Line 6138: fnd_log.STRING (fnd_log.level_statement,

6134: ELSIF TRUNC(l_sll_start_date) < l_line_rec.line_start_dt THEN ---LINE START DATE is pushed forward
6135:
6136: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6137:
6138: fnd_log.STRING (fnd_log.level_statement,
6139: G_MODULE_CURRENT || '.cascade_dates_sll.chk_sll_dt',
6140: 'sll st dt < line st dt - line start date is pushed forward'
6141: || ', sll st dt = ' || l_sll_start_date
6142: );

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

6169:
6170: END IF;
6171: END LOOP; --while end loop
6172:
6173: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6174:
6175: fnd_log.STRING (fnd_log.level_statement,
6176: G_MODULE_CURRENT || '.cascade_dates_sll.sll_after_delete',
6177: 'sll count after deleting sll where sll end date < line start date'

Line 6175: fnd_log.STRING (fnd_log.level_statement,

6171: END LOOP; --while end loop
6172:
6173: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6174:
6175: fnd_log.STRING (fnd_log.level_statement,
6176: G_MODULE_CURRENT || '.cascade_dates_sll.sll_after_delete',
6177: 'sll count after deleting sll where sll end date < line start date'
6178: || ', sll count = ' || l_sll_tbl.count
6179: );

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

6189: x_msg_count => x_msg_count,
6190: x_msg_data => x_msg_data,
6191: p_sllv_tbl => l_strm_lvl_tbl_in);
6192:
6193: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6194: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',
6195: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status
6196: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6197: END IF;

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

6190: x_msg_data => x_msg_data,
6191: p_sllv_tbl => l_strm_lvl_tbl_in);
6192:
6193: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6194: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_sll',
6195: 'oks_sll_pvt.delete_row(x_return_status = '||x_return_status
6196: ||', sll passed for delete = '|| l_strm_lvl_tbl_in.count ||')');
6197: END IF;
6198:

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

6214: -----errorout_ad('first sll st dt = ' || l_sll_start_date || ' and line st dt = ' || l_line_rec.line_start_dt);
6215:
6216: IF l_line_rec.line_start_dt > TRUNC(l_sll_start_date) THEN
6217:
6218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6219:
6220: fnd_log.STRING (fnd_log.level_statement,
6221: G_MODULE_CURRENT || '.cascade_dates_sll.after_sll_del',
6222: 'after sll delete line start date > sll start date'

Line 6220: fnd_log.STRING (fnd_log.level_statement,

6216: IF l_line_rec.line_start_dt > TRUNC(l_sll_start_date) THEN
6217:
6218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6219:
6220: fnd_log.STRING (fnd_log.level_statement,
6221: G_MODULE_CURRENT || '.cascade_dates_sll.after_sll_del',
6222: 'after sll delete line start date > sll start date'
6223: || ', sll dt = ' || l_sll_start_date
6224: );

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

6281: x_return_status => x_return_status,
6282: x_quantity => l_uom_quantity ,
6283: x_timeunit => l_tce_code);
6284:
6285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',
6287: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6288: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6289: END IF;

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

6282: x_quantity => l_uom_quantity ,
6283: x_timeunit => l_tce_code);
6284:
6285: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6286: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.cascade_dates_sll.seed',
6287: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6288: ||', returned timeunit and qty = ' ||l_tce_code || '-' || l_uom_quantity ||')');
6289: END IF;
6290:

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

6330:
6331:
6332: -- END IF; -------not day
6333:
6334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6335:
6336: fnd_log.STRING (fnd_log.level_statement,
6337: G_MODULE_CURRENT || '.cascade_dates_sll.sll_add',
6338: 'sll added after deleting sll where sll_end_dt < line_start_dt');

Line 6336: fnd_log.STRING (fnd_log.level_statement,

6332: -- END IF; -------not day
6333:
6334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6335:
6336: fnd_log.STRING (fnd_log.level_statement,
6337: G_MODULE_CURRENT || '.cascade_dates_sll.sll_add',
6338: 'sll added after deleting sll where sll_end_dt < line_start_dt');
6339: END IF;
6340:

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

6397:
6398:
6399: ELSE ---sll tbl count = 0 after deletion
6400:
6401: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6402:
6403: fnd_log.STRING (fnd_log.level_statement,
6404: G_MODULE_CURRENT || '.cascade_dates_sll.sll_cnt',
6405: 'sll count zero after deleting sll where sll_end_dt < line_start_dt');

Line 6403: fnd_log.STRING (fnd_log.level_statement,

6399: ELSE ---sll tbl count = 0 after deletion
6400:
6401: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6402:
6403: fnd_log.STRING (fnd_log.level_statement,
6404: G_MODULE_CURRENT || '.cascade_dates_sll.sll_cnt',
6405: 'sll count zero after deleting sll where sll_end_dt < line_start_dt');
6406: END IF;
6407:

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

6413: x_duration => l_duration,
6414: x_timeunit => l_timeunit,
6415: x_return_status => x_return_status);
6416:
6417: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6418: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',
6419: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6420: ||', l_duration = '|| l_duration
6421: ||', l_timeunit = ' || l_timeunit ||')');

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

6414: x_timeunit => l_timeunit,
6415: x_return_status => x_return_status);
6416:
6417: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6418: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.duration',
6419: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6420: ||', l_duration = '|| l_duration
6421: ||', l_timeunit = ' || l_timeunit ||')');
6422: END IF;

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

6430: x_return_status => x_return_status,
6431: x_quantity => l_uom_quantity ,
6432: x_timeunit => l_tce_code);
6433:
6434: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6435: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',
6436: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6437: ||', l_uom_quantity = '|| l_uom_quantity
6438: ||', l_tce_code = ' || l_tce_code ||')');

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

6431: x_quantity => l_uom_quantity ,
6432: x_timeunit => l_tce_code);
6433:
6434: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6435: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_seed',
6436: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6437: ||', l_uom_quantity = '|| l_uom_quantity
6438: ||', l_tce_code = ' || l_tce_code ||')');
6439: END IF;

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

6490: l_sll_tbl(1).level_amount := NULL;
6491: l_sll_tbl(1).invoice_offset_days := NULL ;
6492: l_sll_tbl(1).interface_offset_days := NULL ;
6493:
6494: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6495:
6496: fnd_log.STRING (fnd_log.level_statement,
6497: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one',
6498: 'sll added count one');

Line 6496: fnd_log.STRING (fnd_log.level_statement,

6492: l_sll_tbl(1).interface_offset_days := NULL ;
6493:
6494: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6495:
6496: fnd_log.STRING (fnd_log.level_statement,
6497: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one',
6498: 'sll added count one');
6499: END IF;
6500: END IF; --period start and period type not null

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

6521:
6522:
6523: IF TRUNC(l_sll_END_date) < l_line_rec.line_END_dt THEN ---LINE date extended
6524:
6525: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6526:
6527: fnd_log.STRING (fnd_log.level_statement,
6528: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6529: 'sll end dt < line_end_dt'

Line 6527: fnd_log.STRING (fnd_log.level_statement,

6523: IF TRUNC(l_sll_END_date) < l_line_rec.line_END_dt THEN ---LINE date extended
6524:
6525: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6526:
6527: fnd_log.STRING (fnd_log.level_statement,
6528: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6529: 'sll end dt < line_end_dt'
6530: || ', sl end dt = ' || l_sll_END_date);
6531: END IF;

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

6580: x_return_status => x_return_status,
6581: x_quantity => l_uom_quantity ,
6582: x_timeunit => l_tce_code);
6583:
6584: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6585: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6586: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6587: ||', l_uom_quantity = '|| l_uom_quantity
6588: ||', l_tce_code = ' || l_tce_code ||')');

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

6581: x_quantity => l_uom_quantity ,
6582: x_timeunit => l_tce_code);
6583:
6584: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6585: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6586: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6587: ||', l_uom_quantity = '|| l_uom_quantity
6588: ||', l_tce_code = ' || l_tce_code ||')');
6589: END IF;

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

6687: l_sll_tbl(l_sll_tbl_index + 1).level_periods := l_period_freq;
6688: l_sll_tbl(l_sll_tbl_index + 1).uom_per_period := l_duration;
6689: l_sll_tbl(l_sll_tbl_index + 1).uom_code := l_timeunit;
6690:
6691: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6692:
6693: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6694: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status
6695: ||', l_period_freq = '|| l_period_freq

Line 6693: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',

6689: l_sll_tbl(l_sll_tbl_index + 1).uom_code := l_timeunit;
6690:
6691: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6692:
6693: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.create_dates_sll.st_end_seed',
6694: 'After okc_time_util_pub.get_frequency(x_return_status = '||x_return_status
6695: ||', l_period_freq = '|| l_period_freq
6696: ||', l_duration = ' || l_duration ||',l_timeunit = '||l_timeunit ||')');
6697:

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

6709: l_sll_tbl(l_sll_tbl_index + 1).cle_id := l_sll_tbl(l_sll_tbl_index ).cle_id ;
6710: l_sll_tbl(l_sll_tbl_index + 1).chr_id := l_sll_tbl(l_sll_tbl_index ).chr_id ;
6711: l_sll_tbl(l_sll_tbl_index + 1).dnz_chr_id := l_sll_tbl(l_sll_tbl_index ).dnz_chr_id;
6712:
6713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6714:
6715: fnd_log.STRING (fnd_log.level_statement,
6716: G_MODULE_CURRENT || '.cascade_dates_sll.all_sll_end',
6717: 'added sll when sll end dt < line_end_dt');

Line 6715: fnd_log.STRING (fnd_log.level_statement,

6711: l_sll_tbl(l_sll_tbl_index + 1).dnz_chr_id := l_sll_tbl(l_sll_tbl_index ).dnz_chr_id;
6712:
6713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6714:
6715: fnd_log.STRING (fnd_log.level_statement,
6716: G_MODULE_CURRENT || '.cascade_dates_sll.all_sll_end',
6717: 'added sll when sll end dt < line_end_dt');
6718: END IF;
6719:

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

6720: END IF; --period start and period type are not null
6721: ELSE ---sll tbl count = 0
6722:
6723:
6724: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6725:
6726: fnd_log.STRING (fnd_log.level_statement,
6727: G_MODULE_CURRENT || '.cascade_dates_sll.sll_zero',
6728: 'sll count zero');

Line 6726: fnd_log.STRING (fnd_log.level_statement,

6722:
6723:
6724: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6725:
6726: fnd_log.STRING (fnd_log.level_statement,
6727: G_MODULE_CURRENT || '.cascade_dates_sll.sll_zero',
6728: 'sll count zero');
6729: END IF;
6730:

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

6735: x_duration => l_duration,
6736: x_timeunit => l_timeunit,
6737: x_return_status => x_return_status);
6738:
6739: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6740: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',
6741: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6742: ||', l_duration = '|| l_duration
6743: ||', l_timeunit = ' || l_timeunit ||')');

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

6736: x_timeunit => l_timeunit,
6737: x_return_status => x_return_status);
6738:
6739: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6740: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.sll_duration',
6741: 'okc_time_util_pub.get_duration(x_return_status = '||x_return_status
6742: ||', l_duration = '|| l_duration
6743: ||', l_timeunit = ' || l_timeunit ||')');
6744: END IF;

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

6753: x_return_status => x_return_status,
6754: x_quantity => l_uom_quantity ,
6755: x_timeunit => l_tce_code);
6756:
6757: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6758: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',
6759: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6760: ||', l_uom_quantity = '|| l_uom_quantity
6761: ||', l_tce_code = ' || l_tce_code ||')');

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

6754: x_quantity => l_uom_quantity ,
6755: x_timeunit => l_tce_code);
6756:
6757: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6758: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.end_seed',
6759: 'okc_time_util_pub.get_seeded_timeunit(x_return_status = '||x_return_status
6760: ||', l_uom_quantity = '|| l_uom_quantity
6761: ||', l_tce_code = ' || l_tce_code ||')');
6762: END IF;

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

6820: l_sll_tbl(l_sll_tbl_index).cle_id := l_line_rec.id ;
6821: l_sll_tbl(l_sll_tbl_index).chr_id := null;
6822: l_sll_tbl(l_sll_tbl_index).dnz_chr_id := l_line_rec.dnz_chr_id;
6823:
6824: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6825:
6826: fnd_log.STRING (fnd_log.level_statement,
6827: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one_end',
6828: 'sll added count one');

Line 6826: fnd_log.STRING (fnd_log.level_statement,

6822: l_sll_tbl(l_sll_tbl_index).dnz_chr_id := l_line_rec.dnz_chr_id;
6823:
6824: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6825:
6826: fnd_log.STRING (fnd_log.level_statement,
6827: G_MODULE_CURRENT || '.cascade_dates_sll.sll_one_end',
6828: 'sll added count one');
6829: END IF;
6830:

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

6834:
6835: --no changes for partial period calendar in this case
6836: ELSIF TRUNC(l_sll_END_date) > l_line_rec.line_END_dt THEN ---LINE END DATE SHRINKED.
6837:
6838: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6839:
6840: fnd_log.STRING (fnd_log.level_statement,
6841: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6842: 'sll end dt > line end dt'

Line 6840: fnd_log.STRING (fnd_log.level_statement,

6836: ELSIF TRUNC(l_sll_END_date) > l_line_rec.line_END_dt THEN ---LINE END DATE SHRINKED.
6837:
6838: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6839:
6840: fnd_log.STRING (fnd_log.level_statement,
6841: G_MODULE_CURRENT || '.cascade_dates_sll.chk_end_dt',
6842: 'sll end dt > line end dt'
6843: ||', sll end dt = ' || l_sll_END_date );
6844: END IF;

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

6876: x_msg_count => x_msg_count,
6877: x_msg_data => x_msg_data,
6878: x_return_status => x_return_status );
6879:
6880: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6881: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',
6882: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status
6883: ||', sll id passed = '|| l_strm_lvl_tbl_in(l_sll_ind).id ||')');
6884: END IF;

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

6877: x_msg_data => x_msg_data,
6878: x_return_status => x_return_status );
6879:
6880: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6881: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.del_last_sll',
6882: 'oks_bill_util_pub.delete_level_elements(x_return_status = '||x_return_status
6883: ||', sll id passed = '|| l_strm_lvl_tbl_in(l_sll_ind).id ||')');
6884: END IF;
6885:

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

6912: p_invoice_rule_id => l_line_csr_rec.inv_id,
6913: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
6914: x_return_status => x_return_status);
6915:
6916: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6917: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',
6918: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
6919: END IF;
6920:

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

6913: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
6914: x_return_status => x_return_status);
6915:
6916: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
6917: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.create_dates_sll.call_bs',
6918: 'oks_bill_sch.Create_Bill_Sch_Rules(x_return_status = '||x_return_status ||')');
6919: END IF;
6920:
6921: IF x_return_status <> 'S' THEN

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

6927:
6928: EXCEPTION
6929: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6930:
6931: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
6932: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',
6933: 'G_EXCEPTION_HALT_VALIDATION');
6934: END IF;
6935:

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

6928: EXCEPTION
6929: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6930:
6931: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
6932: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.create_dates_sll.EXCEPTION',
6933: 'G_EXCEPTION_HALT_VALIDATION');
6934: END IF;
6935:
6936: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: WHEN OTHERS THEN
6942:
6943: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6944: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',
6945: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6946: END IF;
6947:

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

6940: END IF;
6941: WHEN OTHERS THEN
6942:
6943: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
6944: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.create_dates_sll.UNEXPECTED',
6945: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
6946: END IF;
6947:
6948: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

6999:
7000: EXCEPTION
7001: WHEN OTHERS THEN
7002:
7003: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7004: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',
7005: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7006: END IF;
7007: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

7000: EXCEPTION
7001: WHEN OTHERS THEN
7002:
7003: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7004: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_sll_lvlelement.UNEXPECTED',
7005: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7006: END IF;
7007: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
7008: p_msg_name => G_UNEXPECTED_ERROR,

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

7104:
7105:
7106: EXCEPTION
7107: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7108: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
7109: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',
7110: 'G_EXCEPTION_HALT_VALIDATION');
7111: END IF;
7112:

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

7105:
7106: EXCEPTION
7107: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7108: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
7109: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_top_bs_amt.EXCEPTION',
7110: 'G_EXCEPTION_HALT_VALIDATION');
7111: END IF;
7112:
7113: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

7116: RAISE OKC_API.G_EXCEPTION_ERROR;
7117: END IF;
7118: WHEN OTHERS THEN
7119:
7120: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7121: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',
7122: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7123: END IF;
7124:

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

7117: END IF;
7118: WHEN OTHERS THEN
7119:
7120: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7121: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_top_bs_amt.UNEXPECTED',
7122: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7123: END IF;
7124:
7125: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

7301:
7302:
7303: EXCEPTION
7304: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7305: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
7306: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',
7307: 'G_EXCEPTION_HALT_VALIDATION');
7308: END IF;
7309:

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

7302:
7303: EXCEPTION
7304: WHEN G_EXCEPTION_HALT_VALIDATION THEN
7305: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
7306: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.update_om_sll_date.EXCEPTION',
7307: 'G_EXCEPTION_HALT_VALIDATION');
7308: END IF;
7309:
7310: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

7312: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7313: RAISE OKC_API.G_EXCEPTION_ERROR;
7314: END IF;
7315: WHEN OTHERS THEN
7316: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7317: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',
7318: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7319: END IF;
7320:

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

7313: RAISE OKC_API.G_EXCEPTION_ERROR;
7314: END IF;
7315: WHEN OTHERS THEN
7316: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7317: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.update_om_sll_date.UNEXPECTED',
7318: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7319: END IF;
7320:
7321: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

7384:
7385:
7386: EXCEPTION
7387: WHEN OTHERS THEN
7388: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7389: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',
7390: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7391: END IF;
7392:

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

7385:
7386: EXCEPTION
7387: WHEN OTHERS THEN
7388: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
7389: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.del_rul_elements.UNEXPECTED',
7390: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
7391: END IF;
7392:
7393: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

9137: -------------------------------------------------------------------------
9138: -- End partial period computation logic
9139: -- Date 09-MAY-2005
9140: -------------------------------------------------------------------------
9141: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9142:
9143: fnd_log.STRING (fnd_log.level_statement,
9144: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
9145: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id

Line 9143: fnd_log.STRING (fnd_log.level_statement,

9139: -- Date 09-MAY-2005
9140: -------------------------------------------------------------------------
9141: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9142:
9143: fnd_log.STRING (fnd_log.level_statement,
9144: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
9145: 'dnz_chr_id = ' || l_line_rec.dnz_chr_id
9146: || ', id = ' || l_line_rec.id
9147: || ', lse_id = ' || l_line_rec.lse_id

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

9160: l_currency_code := Find_Currency_Code(
9161: p_cle_id => p_top_line_id,
9162: p_chr_id => NULL);
9163:
9164: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9165:
9166: fnd_log.STRING (fnd_log.level_statement,
9167: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
9168: 'l_currency_code = ' || l_currency_code);

Line 9166: fnd_log.STRING (fnd_log.level_statement,

9162: p_chr_id => NULL);
9163:
9164: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9165:
9166: fnd_log.STRING (fnd_log.level_statement,
9167: G_MODULE_CURRENT || '.terminate_bill_sch.line_dtls',
9168: 'l_currency_code = ' || l_currency_code);
9169: END IF;
9170:

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

9193: x_sll_tbl => l_sll_in_tbl,
9194: x_sll_db_tbl => l_sll_db_tbl,
9195: x_return_status => x_return_status );
9196:
9197: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9198: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.line_sll',
9199: 'Get_SLL_info(x_return_status = '||x_return_status
9200: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9201: END IF;

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

9194: x_sll_db_tbl => l_sll_db_tbl,
9195: x_return_status => x_return_status );
9196:
9197: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9198: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.line_sll',
9199: 'Get_SLL_info(x_return_status = '||x_return_status
9200: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9201: END IF;
9202:

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

9224: p_period_start => l_period_start,
9225: p_period_type => l_period_type,
9226: x_return_status => x_return_status );
9227:
9228: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9229: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.top_lvl_ele',
9230: 'Create_Level_elements(x_return_status = '||x_return_status
9231: ||')');
9232: END IF;

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

9225: p_period_type => l_period_type,
9226: x_return_status => x_return_status );
9227:
9228: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9229: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.top_lvl_ele',
9230: 'Create_Level_elements(x_return_status = '||x_return_status
9231: ||')');
9232: END IF;
9233:

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

9250: l_top_bs_tbl(l_index).date_to_interface := l_line_BS_rec.date_to_interface;
9251:
9252: l_index := l_index + 1;
9253: END LOOP;
9254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9255:
9256: fnd_log.STRING (fnd_log.level_statement,
9257: G_MODULE_CURRENT || '.terminate_bill_sch.top_bs',
9258: 'top bs tbl count = ' || l_top_bs_tbl.count);

Line 9256: fnd_log.STRING (fnd_log.level_statement,

9252: l_index := l_index + 1;
9253: END LOOP;
9254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9255:
9256: fnd_log.STRING (fnd_log.level_statement,
9257: G_MODULE_CURRENT || '.terminate_bill_sch.top_bs',
9258: 'top bs tbl count = ' || l_top_bs_tbl.count);
9259: END IF;
9260: END IF; -----end of 'T'

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

9278: OPEN l_subline_amt_csr(l_all_SubLine_rec.subline_id);
9279: FETCH l_subline_amt_csr INTO l_cp_rec.cp_amt;
9280: CLOSE l_subline_amt_csr;
9281: END IF;
9282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9283:
9284: fnd_log.STRING (fnd_log.level_statement,
9285: G_MODULE_CURRENT || '.terminate_bill_sch.loop_cp_dtl',
9286: 'id = ' || l_all_SubLine_rec.subline_id

Line 9284: fnd_log.STRING (fnd_log.level_statement,

9280: CLOSE l_subline_amt_csr;
9281: END IF;
9282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9283:
9284: fnd_log.STRING (fnd_log.level_statement,
9285: G_MODULE_CURRENT || '.terminate_bill_sch.loop_cp_dtl',
9286: 'id = ' || l_all_SubLine_rec.subline_id
9287: || ', start dt = ' || l_all_SubLine_rec.cp_start_dt
9288: || ', end dt = ' || l_all_SubLine_rec.cp_end_dt

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

9301: p_SubLine_rec => l_cp_rec,
9302: p_top_line_bs => l_top_bs_tbl,
9303: x_return_status => x_return_status);
9304:
9305: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9306: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adj_lvl_amt',
9307: 'Rollup_lvl_amt(x_return_status = '||x_return_status
9308: ||')');
9309: END IF;

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

9302: p_top_line_bs => l_top_bs_tbl,
9303: x_return_status => x_return_status);
9304:
9305: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9306: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adj_lvl_amt',
9307: 'Rollup_lvl_amt(x_return_status = '||x_return_status
9308: ||')');
9309: END IF;
9310:

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

9323: x_sll_tbl => l_sll_in_tbl,
9324: x_sll_db_tbl => l_sll_db_tbl,
9325: x_return_status => x_return_status );
9326:
9327: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9328: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9329: 'Get_SLL_info(x_return_status = '||x_return_status
9330: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9331: END IF;

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

9324: x_sll_db_tbl => l_sll_db_tbl,
9325: x_return_status => x_return_status );
9326:
9327: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9328: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9329: 'Get_SLL_info(x_return_status = '||x_return_status
9330: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9331: END IF;
9332:

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

9371: p_period_start => l_period_start,
9372: p_period_type => l_period_type,
9373: x_return_status => x_return_status);
9374:
9375: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9376: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_lvl_ele',
9377: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
9378: ||', l_prev_term_dt = '||l_prev_term_dt
9379: ||', p_term_dt = ' || p_term_dt ||' , l_period_start '||l_period_start||', l_period_type '||l_period_type||')');

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

9372: p_period_type => l_period_type,
9373: x_return_status => x_return_status);
9374:
9375: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9376: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_lvl_ele',
9377: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
9378: ||', l_prev_term_dt = '||l_prev_term_dt
9379: ||', p_term_dt = ' || p_term_dt ||' , l_period_start '||l_period_start||', l_period_type '||l_period_type||')');
9380: END IF;

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

9397: x_msg_data => x_msg_data,
9398: p_letv_tbl => l_top_bs_tbl,
9399: x_letv_tbl => l_lvl_ele_tbl_out);
9400:
9401: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9402: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9403: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9404: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9405: END IF;

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

9398: p_letv_tbl => l_top_bs_tbl,
9399: x_letv_tbl => l_lvl_ele_tbl_out);
9400:
9401: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9402: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9403: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9404: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9405: END IF;
9406:

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

9431: OPEN l_subline_amt_csr(l_SubLine_rec.subline_id);
9432: FETCH l_subline_amt_csr INTO l_cp_rec.cp_amt;
9433: CLOSE l_subline_amt_csr;
9434: END IF;
9435: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9436:
9437: fnd_log.STRING (fnd_log.level_statement,
9438: G_MODULE_CURRENT || '.terminate_bill_sch.cp_dtl',
9439: 'id = ' || l_all_SubLine_rec.subline_id

Line 9437: fnd_log.STRING (fnd_log.level_statement,

9433: CLOSE l_subline_amt_csr;
9434: END IF;
9435: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9436:
9437: fnd_log.STRING (fnd_log.level_statement,
9438: G_MODULE_CURRENT || '.terminate_bill_sch.cp_dtl',
9439: 'id = ' || l_all_SubLine_rec.subline_id
9440: || ', start dt = ' || l_SubLine_rec.cp_start_dt
9441: || ', end dt = ' || l_SubLine_rec.cp_end_dt

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

9456: x_sll_tbl => l_sll_in_tbl,
9457: x_sll_db_tbl => l_sll_db_tbl,
9458: x_return_status => x_return_status );
9459:
9460: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9461: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9462: 'Get_SLL_info(x_return_status = '||x_return_status
9463: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9464: END IF;

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

9457: x_sll_db_tbl => l_sll_db_tbl,
9458: x_return_status => x_return_status );
9459:
9460: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9461: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_sll',
9462: 'Get_SLL_info(x_return_status = '||x_return_status
9463: ||', sll tbl count = '||l_sll_in_tbl.count||')');
9464: END IF;
9465:

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

9495: p_SubLine_rec => l_cp_Rec,
9496: p_top_line_bs => l_top_bs_tbl,
9497: x_return_status => x_return_status);
9498:
9499: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9500: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adjust_cp_amt',
9501: 'Adjust_top_BS_Amt(x_return_status = '||x_return_status ||')');
9502: END IF;
9503:

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

9496: p_top_line_bs => l_top_bs_tbl,
9497: x_return_status => x_return_status);
9498:
9499: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9500: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.adjust_cp_amt',
9501: 'Adjust_top_BS_Amt(x_return_status = '||x_return_status ||')');
9502: END IF;
9503:
9504: IF x_return_status <> 'S' THEN

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

9525: p_period_start => l_period_start,
9526: p_period_type => l_period_type,
9527: x_return_status => x_return_status);
9528:
9529: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9530: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_bs',
9531: 'Create_cp_lvl_elements(x_return_status = '||x_return_status ||')');
9532: END IF;
9533:

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

9526: p_period_type => l_period_type,
9527: x_return_status => x_return_status);
9528:
9529: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9530: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.cp_bs',
9531: 'Create_cp_lvl_elements(x_return_status = '||x_return_status ||')');
9532: END IF;
9533:
9534: IF x_return_status <> 'S' THEN

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

9544: x_msg_data => x_msg_data,
9545: p_letv_tbl => l_top_bs_tbl,
9546: x_letv_tbl => l_lvl_ele_tbl_out);
9547:
9548: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9549: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9550: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9551: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9552: END IF;

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

9545: p_letv_tbl => l_top_bs_tbl,
9546: x_letv_tbl => l_lvl_ele_tbl_out);
9547:
9548: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
9549: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.terminate_bill_sch.update_bs',
9550: 'oks_bill_level_elements_pvt.update_row(x_return_status = '||x_return_status
9551: ||', top bs count = '||l_lvl_ele_tbl_out.count ||')');
9552: END IF;
9553:

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

9886: p_cp_sll_tbl(l_cp_sll_counter).uom_per_period,
9887: l_end_date,
9888: p_term_dt);
9889:
9890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9891: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9892: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
9893: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
9894: END IF;

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

9887: l_end_date,
9888: p_term_dt);
9889:
9890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9891: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9892: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
9893: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
9894: END IF;
9895: IF l_constant_sll_amt IS NULL THEN

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

9964: -------------------------------------------------------------------------
9965: IF p_subline_rec.cp_lse_id in (8,10,11,35) THEN
9966: l_uom := p_cp_sll_tbl(l_cp_sll_counter).uom;
9967:
9968: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9969: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9970: ' result l_uom = ' || l_uom);
9971: END IF;
9972:

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

9965: IF p_subline_rec.cp_lse_id in (8,10,11,35) THEN
9966: l_uom := p_cp_sll_tbl(l_cp_sll_counter).uom;
9967:
9968: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9969: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements',
9970: ' result l_uom = ' || l_uom);
9971: END IF;
9972:
9973: END IF;

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

10029: -- Added two new parameters p_period_start and p_period_type
10030: -------------------------------------------------------------------------
10031:
10032: -- Start - Modified by PMALLARA - Bug #3992530
10033: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
10034: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',
10035: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
10036: ||'period start = ' || p_period_start
10037: ||', period type = ' || p_period_type);

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

10030: -------------------------------------------------------------------------
10031:
10032: -- Start - Modified by PMALLARA - Bug #3992530
10033: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
10034: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Create_cp_Lvl_elements.lvl_loop',
10035: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
10036: ||'period start = ' || p_period_start
10037: ||', period type = ' || p_period_type);
10038: END IF;

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

10099: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
10100: p_period_type => p_period_type ,
10101: p_period_start => p_period_start);
10102:
10103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10104: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
10105: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10106: ||' result l_quantity = ' || l_quantity);
10107: END IF;

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

10100: p_period_type => p_period_type ,
10101: p_period_start => p_period_start);
10102:
10103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10104: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
10105: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10106: ||' result l_quantity = ' || l_quantity);
10107: END IF;
10108:

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

10112: END IF;
10113:
10114: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
10115:
10116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
10118: ' result l_lvl_amt = ' || l_lvl_amt);
10119: END IF;
10120: --mchoudha added else logic for WEEK kind of uoms

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

10113:
10114: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
10115:
10116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
10118: ' result l_lvl_amt = ' || l_lvl_amt);
10119: END IF;
10120: --mchoudha added else logic for WEEK kind of uoms
10121: ELSE

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

10146: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
10147: p_period_type => p_period_type,
10148: p_period_start => p_period_start);
10149:
10150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10151: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
10152: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10153: ||' result l_quantity = ' || l_quantity);
10154: END IF;

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

10147: p_period_type => p_period_type,
10148: p_period_start => p_period_start);
10149:
10150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10151: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
10152: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10153: ||' result l_quantity = ' || l_quantity);
10154: END IF;
10155:

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

10162:
10163:
10164: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
10165:
10166: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10167: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
10168: ' result l_lvl_amt = ' || l_lvl_amt);
10169: END IF;
10170:

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

10163:
10164: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
10165:
10166: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10167: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
10168: ' result l_lvl_amt = ' || l_lvl_amt);
10169: END IF;
10170:
10171: --mchoudha added else logic for WEEK kind of uoms

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

10176: --errorout_ad(' l_lvl_amt '||l_lvl_amt);
10177:
10178: ELSE
10179: l_lvl_amt := nvl(l_constant_sll_amt,0);
10180: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10181: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.full-period',
10182: ' l_lvl_amt = ' || l_lvl_amt);
10183: END IF;
10184:

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

10177:
10178: ELSE
10179: l_lvl_amt := nvl(l_constant_sll_amt,0);
10180: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10181: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.full-period',
10182: ' l_lvl_amt = ' || l_lvl_amt);
10183: END IF;
10184:
10185: --errorout_ad(' l_lvl_amt in else '||l_lvl_amt);

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

10227: p_source_uom => l_fnd_lvl_in_rec.tuom, --line price uom
10228: p_period_type => p_period_type,
10229: p_period_start => p_period_start);
10230:
10231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10232: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10233: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10234: ||' result l_quantity = ' || l_quantity);
10235: END IF;

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

10228: p_period_type => p_period_type,
10229: p_period_start => p_period_start);
10230:
10231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10232: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10233: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10234: ||' result l_quantity = ' || l_quantity);
10235: END IF;
10236:

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

10244:
10245: 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
10246:
10247:
10248: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10249: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10250: ' result l_lvl_amt = ' || l_lvl_amt);
10251: END IF;
10252: --mchoudha added else logic for WEEK kind of uoms

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

10245: 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
10246:
10247:
10248: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10249: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10250: ' result l_lvl_amt = ' || l_lvl_amt);
10251: END IF;
10252: --mchoudha added else logic for WEEK kind of uoms
10253: ELSE

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

11670: x_return_status := 'S';
11671:
11672:
11673:
11674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11675:
11676: fnd_log.STRING (fnd_log.level_statement,
11677: G_MODULE_CURRENT || '.adjust_replace_product_bs.line_details',
11678: 'old sub line id passed = ' || p_old_cp_id

Line 11676: fnd_log.STRING (fnd_log.level_statement,

11672:
11673:
11674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11675:
11676: fnd_log.STRING (fnd_log.level_statement,
11677: G_MODULE_CURRENT || '.adjust_replace_product_bs.line_details',
11678: 'old sub line id passed = ' || p_old_cp_id
11679: || ', new sub line id passed = ' || p_new_cp_id
11680: );

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

11687: l_old_bill_type := 'T';
11688: END IF;
11689: CLOSE l_old_bill_type_csr;
11690:
11691: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11692:
11693: fnd_log.STRING (fnd_log.level_statement,
11694: G_MODULE_CURRENT || '.adjust_replace_product_bs.billing_sch_type',
11695: 'old line billing scheduel type = ' || l_old_bill_type

Line 11693: fnd_log.STRING (fnd_log.level_statement,

11689: CLOSE l_old_bill_type_csr;
11690:
11691: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11692:
11693: fnd_log.STRING (fnd_log.level_statement,
11694: G_MODULE_CURRENT || '.adjust_replace_product_bs.billing_sch_type',
11695: 'old line billing scheduel type = ' || l_old_bill_type
11696: );
11697: END IF;

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

11731: l_strm_lvl_tbl_in(l_sll_index).creation_date := SYSDATE;
11732: l_strm_lvl_tbl_in(l_sll_index).last_updated_by := OKC_API.G_MISS_NUM;
11733: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11734:
11735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11736:
11737: fnd_log.STRING (fnd_log.level_statement,
11738: G_MODULE_CURRENT || '.adjust_replace_product_bs.new_sll_tbl_dtls',
11739: 'sll num = ' || l_sll_index

Line 11737: fnd_log.STRING (fnd_log.level_statement,

11733: l_strm_lvl_tbl_in(l_sll_index).last_update_date := SYSDATE;
11734:
11735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11736:
11737: fnd_log.STRING (fnd_log.level_statement,
11738: G_MODULE_CURRENT || '.adjust_replace_product_bs.new_sll_tbl_dtls',
11739: 'sll num = ' || l_sll_index
11740: || ', sll start date = ' || l_strm_lvl_tbl_in(l_sll_index).start_date
11741: || ', sll end date = ' || l_strm_lvl_tbl_in(l_sll_index).end_date

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

11759: x_msg_data => x_msg_data,
11760: p_sllv_tbl => l_strm_lvl_tbl_in,
11761: x_sllv_tbl => l_strm_lvl_tbl_out);
11762:
11763: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11764: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',
11765: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11766: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11767: END IF;

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

11760: p_sllv_tbl => l_strm_lvl_tbl_in,
11761: x_sllv_tbl => l_strm_lvl_tbl_out);
11762:
11763: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11764: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.insert_sll',
11765: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
11766: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
11767: END IF;
11768:

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

11773: OPEN l_new_cp_csr;
11774: FETCH l_new_cp_csr INTO l_new_cp_rec;
11775: IF l_new_cp_csr%NOTFOUND THEN
11776: CLOSE l_new_cp_csr;
11777: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11778: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11779: 'new cp not found = ' || p_new_cp_id);
11780: END IF;
11781: RAISE G_EXCEPTION_HALT_VALIDATION;

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

11774: FETCH l_new_cp_csr INTO l_new_cp_rec;
11775: IF l_new_cp_csr%NOTFOUND THEN
11776: CLOSE l_new_cp_csr;
11777: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11778: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11779: 'new cp not found = ' || p_new_cp_id);
11780: END IF;
11781: RAISE G_EXCEPTION_HALT_VALIDATION;
11782:

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

11795: ELSE
11796: l_sll_end_date := l_strm_lvl_tbl_out(l_sll_index).end_date;
11797: END IF;
11798:
11799: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11800: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_elements',
11801: 'sll rule id = ' || l_strm_lvl_tbl_out(l_sll_index).id
11802: ||', sll end date = '|| l_sll_end_date);
11803: END IF;

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

11796: l_sll_end_date := l_strm_lvl_tbl_out(l_sll_index).end_date;
11797: END IF;
11798:
11799: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11800: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_elements',
11801: 'sll rule id = ' || l_strm_lvl_tbl_out(l_sll_index).id
11802: ||', sll end date = '|| l_sll_end_date);
11803: END IF;
11804:

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

11808: WHERE TRUNC(date_start) <= TRUNC(l_sll_end_date)
11809: AND TRUNC(date_start) >= TRUNC(l_strm_lvl_tbl_out(l_sll_index).start_date)
11810: AND cle_id = p_old_cp_id;
11811:
11812: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11813: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_amt',
11814: 'updated level elements = ' || sql%rowcount);
11815: END IF;
11816:

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

11809: AND TRUNC(date_start) >= TRUNC(l_strm_lvl_tbl_out(l_sll_index).start_date)
11810: AND cle_id = p_old_cp_id;
11811:
11812: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11813: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_lvl_amt',
11814: 'updated level elements = ' || sql%rowcount);
11815: END IF;
11816:
11817:

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

11822: UPDATE oks_k_lines_b
11823: SET billing_schedule_type = l_old_bill_type
11824: WHERE cle_id = p_new_cp_id;
11825:
11826: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11827: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bill_type',
11828: 'update bill schedule type of new line to = ' || l_old_bill_type);
11829: END IF;
11830:

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

11823: SET billing_schedule_type = l_old_bill_type
11824: WHERE cle_id = p_new_cp_id;
11825:
11826: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11827: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bill_type',
11828: 'update bill schedule type of new line to = ' || l_old_bill_type);
11829: END IF;
11830:
11831:

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

11836: UPDATE oks_stream_levels_b
11837: SET level_amount = 0
11838: WHERE cle_id = p_old_cp_id;
11839:
11840: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11841: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_oldsll_amt',
11842: 'update lvl amt of old line to zero = ' || sql%rowcount );
11843: END IF;
11844:

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

11837: SET level_amount = 0
11838: WHERE cle_id = p_old_cp_id;
11839:
11840: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11841: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_oldsll_amt',
11842: 'update lvl amt of old line to zero = ' || sql%rowcount );
11843: END IF;
11844:
11845: END IF; ----chk for bill type E and P

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

11851: SET cle_id = p_new_cp_id
11852: WHERE cle_id = p_old_cp_id;
11853:
11854:
11855: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11856: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bcl',
11857: 'updated bcl count = ' || sql%rowcount );
11858: END IF;
11859:

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

11852: WHERE cle_id = p_old_cp_id;
11853:
11854:
11855: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
11856: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_replace_product_bs.update_bcl',
11857: 'updated bcl count = ' || sql%rowcount );
11858: END IF;
11859:
11860: END IF; ----chk for sll count for old line

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

11862:
11863:
11864: EXCEPTION
11865: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11866: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11867: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11868: 'G_EXCEPTION_HALT_VALIDATION');
11869: END IF;
11870:

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

11863:
11864: EXCEPTION
11865: WHEN G_EXCEPTION_HALT_VALIDATION THEN
11866: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
11867: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_replace_product_bs.EXCEPTION',
11868: 'G_EXCEPTION_HALT_VALIDATION');
11869: END IF;
11870:
11871: WHEN OTHERS THEN

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

11868: 'G_EXCEPTION_HALT_VALIDATION');
11869: END IF;
11870:
11871: WHEN OTHERS THEN
11872: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
11873: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',
11874: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
11875: END IF;
11876:

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

11869: END IF;
11870:
11871: WHEN OTHERS THEN
11872: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
11873: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_replace_product_bs.UNEXPECTED',
11874: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
11875: END IF;
11876:
11877: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

11996:
11997: If l_Line_Csr%Notfound then
11998: Close l_Line_Csr;
11999: x_return_status := 'E';
12000: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12001: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12002: 'old sub line not found = ' || p_old_cp_id );
12003: END IF;
12004:

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

11997: If l_Line_Csr%Notfound then
11998: Close l_Line_Csr;
11999: x_return_status := 'E';
12000: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12001: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12002: 'old sub line not found = ' || p_old_cp_id );
12003: END IF;
12004:
12005: End If;

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

12071: END IF;
12072: l_top_line_id := l_line_rec.parent_id;
12073:
12074:
12075: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12076:
12077: fnd_log.STRING (fnd_log.level_statement,
12078: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_dtls',
12079: 'old subline id = ' || l_old_cp_rec.cp_id

Line 12077: fnd_log.STRING (fnd_log.level_statement,

12073:
12074:
12075: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12076:
12077: fnd_log.STRING (fnd_log.level_statement,
12078: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_dtls',
12079: 'old subline id = ' || l_old_cp_rec.cp_id
12080: || ', start date = ' || l_old_cp_rec.cp_start_dt
12081: || ', end date = ' || l_old_cp_rec.cp_end_dt

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

12091:
12092: If l_Line_Csr%Notfound then
12093: Close l_Line_Csr;
12094: x_return_status := 'E';
12095: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12096: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12097: 'top line not found = ' || l_top_line_id );
12098: END IF;
12099:

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

12092: If l_Line_Csr%Notfound then
12093: Close l_Line_Csr;
12094: x_return_status := 'E';
12095: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12096: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12097: 'top line not found = ' || l_top_line_id );
12098: END IF;
12099:
12100: End If;

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

12117: l_inv_rule_id := l_line_rec.inv_rule_id;
12118: l_billing_type := l_line_rec.billing_schedule_type;
12119:
12120:
12121: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12122:
12123: fnd_log.STRING (fnd_log.level_statement,
12124: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_line_dtls',
12125: 'top line id = ' || l_top_line_rec.id

Line 12123: fnd_log.STRING (fnd_log.level_statement,

12119:
12120:
12121: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12122:
12123: fnd_log.STRING (fnd_log.level_statement,
12124: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_line_dtls',
12125: 'top line id = ' || l_top_line_rec.id
12126: || ', start date = ' || l_top_line_rec.line_start_dt
12127: || ', end date = ' || l_top_line_rec.line_start_dt

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

12138:
12139: IF l_currency_code IS NULL THEN
12140: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
12141: x_return_status := 'E';
12142: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12143: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12144: 'currency not found for contract id = ' || l_top_line_rec.dnz_chr_id );
12145: END IF;
12146: RETURN;

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

12139: IF l_currency_code IS NULL THEN
12140: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'CURRENCY CODE NOT FOUND.');
12141: x_return_status := 'E';
12142: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12143: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12144: 'currency not found for contract id = ' || l_top_line_rec.dnz_chr_id );
12145: END IF;
12146: RETURN;
12147: END IF;

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

12166: l_index := l_index + 1;
12167: END LOOP;
12168:
12169:
12170: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12171:
12172: fnd_log.STRING (fnd_log.level_statement,
12173: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_bs_tbl',
12174: 'top line lvl elements count = ' || l_top_bs_tbl.count

Line 12172: fnd_log.STRING (fnd_log.level_statement,

12168:
12169:
12170: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12171:
12172: fnd_log.STRING (fnd_log.level_statement,
12173: G_MODULE_CURRENT || '.adjust_split_bill_sch.top_bs_tbl',
12174: 'top line lvl elements count = ' || l_top_bs_tbl.count
12175: );
12176: END IF;

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

12195: l_index := l_index + 1;
12196: END LOOP;
12197:
12198:
12199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12200:
12201: fnd_log.STRING (fnd_log.level_statement,
12202: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_bs_tbl',
12203: 'old cp lvl elements count = ' || l_cp_old_bs_tbl.count

Line 12201: fnd_log.STRING (fnd_log.level_statement,

12197:
12198:
12199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12200:
12201: fnd_log.STRING (fnd_log.level_statement,
12202: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_bs_tbl',
12203: 'old cp lvl elements count = ' || l_cp_old_bs_tbl.count
12204: );
12205: END IF;

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

12213: LOOP
12214: l_top_bs_ind := l_top_bs_tbl.NEXT(l_top_bs_ind);
12215: END LOOP;
12216:
12217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12218:
12219: fnd_log.STRING (fnd_log.level_statement,
12220: G_MODULE_CURRENT || '.Adjust_split_bill_sch.while_top_bs',
12221: 'after while loop in top bs index = ' || l_top_bs_ind

Line 12219: fnd_log.STRING (fnd_log.level_statement,

12215: END LOOP;
12216:
12217: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12218:
12219: fnd_log.STRING (fnd_log.level_statement,
12220: G_MODULE_CURRENT || '.Adjust_split_bill_sch.while_top_bs',
12221: 'after while loop in top bs index = ' || l_top_bs_ind
12222: || ' , date start = ' || l_top_bs_tbl(l_top_bs_ind ).DATE_START
12223: );

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

12267: l_cp_old_bs_tbl(l_index).date_completed := l_line_BS_rec.date_completed;
12268: l_index := l_index + 1;
12269: END LOOP;
12270:
12271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12272: fnd_log.STRING (fnd_log.level_statement,
12273: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_bs_tbl',
12274: 'old cp lvl elements count = ' || l_cp_old_bs_tbl.count
12275: );

Line 12272: fnd_log.STRING (fnd_log.level_statement,

12268: l_index := l_index + 1;
12269: END LOOP;
12270:
12271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12272: fnd_log.STRING (fnd_log.level_statement,
12273: G_MODULE_CURRENT || '.adjust_split_bill_sch.old_cp_bs_tbl',
12274: 'old cp lvl elements count = ' || l_cp_old_bs_tbl.count
12275: );
12276: END IF;

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

12289: x_sll_tbl => l_sll_in_tbl,
12290: x_sll_db_tbl => l_sll_db_tbl,
12291: x_return_status => x_return_status );
12292:
12293: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12294: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.get_old_cp_sll',
12295: 'Get_SLL_info(x_return_status = '||x_return_status
12296: ||', sll tbl out count = '||l_sll_db_tbl.count||')');
12297: END IF;

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

12290: x_sll_db_tbl => l_sll_db_tbl,
12291: x_return_status => x_return_status );
12292:
12293: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12294: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.get_old_cp_sll',
12295: 'Get_SLL_info(x_return_status = '||x_return_status
12296: ||', sll tbl out count = '||l_sll_db_tbl.count||')');
12297: END IF;
12298:

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

12327:
12328: If l_Line_Csr%Notfound then
12329: Close l_Line_Csr;
12330: x_return_status := 'E';
12331: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12332: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12333: 'new sub line not found = ' || p_new_cp_tbl(i).id );
12334: END IF;
12335:

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

12328: If l_Line_Csr%Notfound then
12329: Close l_Line_Csr;
12330: x_return_status := 'E';
12331: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12332: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12333: 'new sub line not found = ' || p_new_cp_tbl(i).id );
12334: END IF;
12335:
12336: End If;

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

12347: FETCH l_line_amt_csr INTO l_new_cp_rec.cp_amt;
12348: CLOSE l_line_amt_csr;
12349: END IF;
12350:
12351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12352:
12353: fnd_log.STRING (fnd_log.level_statement,
12354: G_MODULE_CURRENT || '.adjust_split_bill_sch.new_cp_dtls',
12355: 'new subline id = ' || l_new_cp_rec.cp_id

Line 12353: fnd_log.STRING (fnd_log.level_statement,

12349: END IF;
12350:
12351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12352:
12353: fnd_log.STRING (fnd_log.level_statement,
12354: G_MODULE_CURRENT || '.adjust_split_bill_sch.new_cp_dtls',
12355: 'new subline id = ' || l_new_cp_rec.cp_id
12356: || ', start date = ' || l_new_cp_rec.cp_start_dt
12357: || ', end date = ' || l_new_cp_rec.cp_end_dt

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

12367: UPDATE OKS_K_LINES_B SET billing_schedule_type = l_billing_type
12368: WHERE cle_id = l_new_cp_rec.cp_id;
12369:
12370:
12371: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12372: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.update_bill_type',
12373: 'updated new sub line billing type = ' || sql%rowcount);
12374:
12375: END IF;

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

12368: WHERE cle_id = l_new_cp_rec.cp_id;
12369:
12370:
12371: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12372: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.update_bill_type',
12373: 'updated new sub line billing type = ' || sql%rowcount);
12374:
12375: END IF;
12376: END IF;

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

12383: p_new_sll_tbl => l_new_sll_tbl,
12384: p_old_sll_tbl => l_sll_db_tbl,
12385: x_return_status => x_return_status);
12386:
12387: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12388: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.prorate_sll_amt',
12389: 'Prorate_sll_amt status = ' || x_return_status
12390: );
12391:

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

12384: p_old_sll_tbl => l_sll_db_tbl,
12385: x_return_status => x_return_status);
12386:
12387: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12388: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.prorate_sll_amt',
12389: 'Prorate_sll_amt status = ' || x_return_status
12390: );
12391:
12392: END IF;

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

12436: x_msg_data => x_msg_data,
12437: p_sllv_tbl => l_strm_lvl_tbl_in,
12438: x_sllv_tbl => l_strm_lvl_tbl_out);
12439:
12440: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12441: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',
12442: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12443: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12444: END IF;

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

12437: p_sllv_tbl => l_strm_lvl_tbl_in,
12438: x_sllv_tbl => l_strm_lvl_tbl_out);
12439:
12440: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12441: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.insert_sll',
12442: 'OKS_SLL_PVT.insert_row(x_return_status = '||x_return_status
12443: ||', sll tbl out count = '||l_strm_lvl_tbl_out.count||')');
12444: END IF;
12445:

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

12467: l_cp_sll_out_tbl(l_tbl_index).Interface_offset_days := l_strm_lvl_tbl_out(l_tbl_index).interface_offset_days;
12468:
12469: END LOOP;
12470:
12471: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12472:
12473: fnd_log.STRING (fnd_log.level_statement,
12474: G_MODULE_CURRENT || '.adjust_split_bill_sch.before_new_lvl_ele',
12475: 'sll count passed to Create_cp_lvl_elements = ' || l_cp_sll_out_tbl.count);

Line 12473: fnd_log.STRING (fnd_log.level_statement,

12469: END LOOP;
12470:
12471: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12472:
12473: fnd_log.STRING (fnd_log.level_statement,
12474: G_MODULE_CURRENT || '.adjust_split_bill_sch.before_new_lvl_ele',
12475: 'sll count passed to Create_cp_lvl_elements = ' || l_cp_sll_out_tbl.count);
12476: END IF;
12477:

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

12494: p_period_type => l_period_type,
12495: x_return_status => x_return_status);
12496:
12497:
12498: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12499: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Create_cp_lvl_elements',
12500: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12501: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12502: END IF;

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

12495: x_return_status => x_return_status);
12496:
12497:
12498: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12499: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Create_cp_lvl_elements',
12500: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12501: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12502: END IF;
12503:

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

12512: x_new_cp_bs_tbl => l_cp_new_bs_tbl,
12513: x_return_status => x_return_status);
12514:
12515:
12516: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12517: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Adjust_billed_lvl_element',
12518: 'Adjust_billed_lvl_element(x_return_status = '||x_return_status
12519: ||', l_cp_old_bs_tbl count = '||l_cp_old_bs_tbl.count||')');
12520: END IF;

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

12513: x_return_status => x_return_status);
12514:
12515:
12516: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12517: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.Adjust_billed_lvl_element',
12518: 'Adjust_billed_lvl_element(x_return_status = '||x_return_status
12519: ||', l_cp_old_bs_tbl count = '||l_cp_old_bs_tbl.count||')');
12520: END IF;
12521:

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

12536: x_msg_count => x_msg_count,
12537: x_msg_data => x_msg_data);
12538:
12539:
12540: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12541: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',
12542: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12543: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12544: END IF;

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

12537: x_msg_data => x_msg_data);
12538:
12539:
12540: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12541: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.bill_rec',
12542: 'oks_bill_util_pub.adjust_split_bill_rec(x_return_status = '||x_return_status
12543: ||'old line id = ' || l_old_cp_rec.cp_id || ')');
12544: END IF;
12545:

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

12566: SET level_amount = l_sll_db_tbl(l_index).level_amount
12567: WHERE id = l_sll_db_tbl(l_index).id;
12568:
12569:
12570: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12571: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.old_sll_amt_update',
12572: 'old sll amount update = '|| l_sll_db_tbl(l_index).level_amount
12573: ||', sll id = '|| l_sll_db_tbl(l_index).id );
12574: END IF;

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

12567: WHERE id = l_sll_db_tbl(l_index).id;
12568:
12569:
12570: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12571: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.old_sll_amt_update',
12572: 'old sll amount update = '|| l_sll_db_tbl(l_index).level_amount
12573: ||', sll id = '|| l_sll_db_tbl(l_index).id );
12574: END IF;
12575: END IF;

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

12610: p_period_start => l_period_start, --mchoudha fix for bug#4998167 added l_period_start
12611: p_period_type => l_period_type, --mchoudha fix for bug#4998167 added l_period_type
12612: x_return_status => x_return_status);
12613:
12614: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12615: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.refresh_old_cp_lvl',
12616: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12617: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12618: END IF;

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

12611: p_period_type => l_period_type, --mchoudha fix for bug#4998167 added l_period_type
12612: x_return_status => x_return_status);
12613:
12614: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12615: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.adjust_split_bill_sch.refresh_old_cp_lvl',
12616: 'Create_cp_lvl_elements(x_return_status = '||x_return_status
12617: ||', l_top_bs_tbl count = '||l_top_bs_tbl.count||')');
12618: END IF;
12619:

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

12630: UPDATE OKS_LEVEL_ELEMENTS
12631: SET amount = l_top_bs_tbl(l_index).amount
12632: WHERE id = l_top_bs_tbl(l_index).id;
12633:
12634: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12635: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_split_bill_sch.update_top_lvl_amt',
12636: 'updated level elemnets of top line= ' || sql%rowcount
12637: || ' , id = ' || l_top_bs_tbl(l_index).id
12638: || ' , amt = ' || l_top_bs_tbl(l_index).amount );

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

12631: SET amount = l_top_bs_tbl(l_index).amount
12632: WHERE id = l_top_bs_tbl(l_index).id;
12633:
12634: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12635: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_split_bill_sch.update_top_lvl_amt',
12636: 'updated level elemnets of top line= ' || sql%rowcount
12637: || ' , id = ' || l_top_bs_tbl(l_index).id
12638: || ' , amt = ' || l_top_bs_tbl(l_index).amount );
12639: END IF;

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

12645: WHEN L_EXCEPTION_END THEN
12646: x_return_status := 'S';
12647: WHEN G_EXCEPTION_HALT_VALIDATION THEN
12648: x_return_status := 'E';
12649: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12650: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12651: 'G_EXCEPTION_HALT_VALIDATION');
12652: END IF;
12653:

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

12646: x_return_status := 'S';
12647: WHEN G_EXCEPTION_HALT_VALIDATION THEN
12648: x_return_status := 'E';
12649: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
12650: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.adjust_split_bill_sch.EXCEPTION',
12651: 'G_EXCEPTION_HALT_VALIDATION');
12652: END IF;
12653:
12654: WHEN OTHERS THEN

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

12651: 'G_EXCEPTION_HALT_VALIDATION');
12652: END IF;
12653:
12654: WHEN OTHERS THEN
12655: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12656: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',
12657: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12658: END IF;
12659:

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

12652: END IF;
12653:
12654: WHEN OTHERS THEN
12655: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12656: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.adjust_split_bill_sch.UNEXPECTED',
12657: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12658: END IF;
12659:
12660: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

12684: BEGIN
12685:
12686: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12687:
12688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12689:
12690: fnd_log.STRING (fnd_log.level_statement,
12691: G_MODULE_CURRENT || '.Prorate_sll_amt.passed_val',
12692: 'p_total_amt = ' || p_total_amt

Line 12690: fnd_log.STRING (fnd_log.level_statement,

12686: x_return_status := OKC_API.G_RET_STS_SUCCESS;
12687:
12688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12689:
12690: fnd_log.STRING (fnd_log.level_statement,
12691: G_MODULE_CURRENT || '.Prorate_sll_amt.passed_val',
12692: 'p_total_amt = ' || p_total_amt
12693: ||', p_new_cp_amt = ' || p_new_cp_amt);
12694: END IF;

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

12711:
12712: p_old_sll_tbl(l_index).level_amount := nvl(p_old_sll_tbl(l_index).level_amount,0) -
12713: p_new_sll_tbl(l_index).level_amount;
12714:
12715: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12716: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Prorate_sll_amt.lvl_amt',
12717: 'sll seq = ' || p_old_sll_tbl(l_index).sequence_no
12718: ||', old sll amt = '|| p_old_sll_tbl(l_index).level_amount
12719: ||', new sll amt = '|| p_new_sll_tbl(l_index).level_amount

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

12712: p_old_sll_tbl(l_index).level_amount := nvl(p_old_sll_tbl(l_index).level_amount,0) -
12713: p_new_sll_tbl(l_index).level_amount;
12714:
12715: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12716: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Prorate_sll_amt.lvl_amt',
12717: 'sll seq = ' || p_old_sll_tbl(l_index).sequence_no
12718: ||', old sll amt = '|| p_old_sll_tbl(l_index).level_amount
12719: ||', new sll amt = '|| p_new_sll_tbl(l_index).level_amount
12720: ||', total amt = '|| l_tot_amt

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

12725:
12726: EXCEPTION
12727:
12728: WHEN OTHERS THEN
12729: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12730: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',
12731: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12732: END IF;
12733:

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

12726: EXCEPTION
12727:
12728: WHEN OTHERS THEN
12729: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12730: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Prorate_sll_amt.UNEXPECTED',
12731: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12732: END IF;
12733:
12734: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

12779: l_index := l_index + 1;
12780: END LOOP;
12781:
12782:
12783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12784:
12785: fnd_log.STRING (fnd_log.level_statement,
12786: G_MODULE_CURRENT || '.Adjust_billed_lvl_element.new_bs_tbl',
12787: 'new sub line lvl elements count = ' || x_new_cp_bs_tbl.count);

Line 12785: fnd_log.STRING (fnd_log.level_statement,

12781:
12782:
12783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12784:
12785: fnd_log.STRING (fnd_log.level_statement,
12786: G_MODULE_CURRENT || '.Adjust_billed_lvl_element.new_bs_tbl',
12787: 'new sub line lvl elements count = ' || x_new_cp_bs_tbl.count);
12788: END IF;
12789:

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

12804: UPDATE OKS_LEVEL_ELEMENTS
12805: SET amount = p_old_cp_bs_tbl(l_index).amount
12806: WHERE id = p_old_cp_bs_tbl(l_index).id;
12807:
12808: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12809: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.update_old_lvl_amt',
12810: 'updated level elemnets = ' || sql%rowcount
12811: || ' , id = ' || p_old_cp_bs_tbl(l_index).id
12812: || ' , amt = ' || p_old_cp_bs_tbl(l_index).amount );

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

12805: SET amount = p_old_cp_bs_tbl(l_index).amount
12806: WHERE id = p_old_cp_bs_tbl(l_index).id;
12807:
12808: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
12809: fnd_log.string(fnd_log.level_event,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.update_old_lvl_amt',
12810: 'updated level elemnets = ' || sql%rowcount
12811: || ' , id = ' || p_old_cp_bs_tbl(l_index).id
12812: || ' , amt = ' || p_old_cp_bs_tbl(l_index).amount );
12813:

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

12818:
12819: EXCEPTION
12820:
12821: WHEN OTHERS THEN
12822: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12823: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
12824: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12825: END IF;
12826:

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

12819: EXCEPTION
12820:
12821: WHEN OTHERS THEN
12822: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
12823: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Adjust_billed_lvl_element.UNEXPECTED',
12824: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
12825: END IF;
12826:
12827: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

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

13351: l_constant_sll_amt :=nvl(l_unit_price*l_duration,0);
13352:
13353: /*Added for bug 16293821 */
13354:
13355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13356: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13357: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
13358: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
13359: END IF;

Line 13356: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',

13352:
13353: /*Added for bug 16293821 */
13354:
13355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13356: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13357: 'after calling OKS_BILL_SCH.Get_Unit_Price_Per_Uom '
13358: ||' result l_constant_sll_amt = ' || l_constant_sll_amt);
13359: END IF;
13360: IF l_constant_sll_amt IS NULL THEN

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

13367: IF p_item_type = 'SUBSCRIPTION' then
13368: l_constant_sll_amt := ( p_total_amount /nvl(l_level_periods,1));
13369: l_constant_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt, p_currency_code);
13370:
13371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13372: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',
13373: ' Get_Constant_sll_Amount for subscription '
13374: ||' l_constant_sll_amt = ' || l_constant_sll_amt);
13375: END IF;

Line 13372: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',

13368: l_constant_sll_amt := ( p_total_amount /nvl(l_level_periods,1));
13369: l_constant_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt, p_currency_code);
13370:
13371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13372: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',
13373: ' Get_Constant_sll_Amount for subscription '
13374: ||' l_constant_sll_amt = ' || l_constant_sll_amt);
13375: END IF;
13376:

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

13384: P_uom_quantity => l_uom_quantity,
13385: P_tce_code => l_tce_code,
13386: x_constant_sll_amt => l_constant_sll_amt,
13387: x_return_status => l_return_status);
13388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13389: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',
13390: ' Get_Constant_sll_Amount '
13391: ||' l_constant_sll_amt = ' || l_constant_sll_amt);
13392: END IF;

Line 13389: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',

13385: P_tce_code => l_tce_code,
13386: x_constant_sll_amt => l_constant_sll_amt,
13387: x_return_status => l_return_status);
13388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13389: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',
13390: ' Get_Constant_sll_Amount '
13391: ||' l_constant_sll_amt = ' || l_constant_sll_amt);
13392: END IF;
13393: END IF; /*Added for bug 16685173 */

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

13403: l_fnd_lvl_in_rec.invoice_offset_days := l_billing_profile_Csr_Rec.invoice_offset;
13404: l_fnd_lvl_in_rec.interface_offset_days := l_billing_profile_Csr_Rec.Interface_offset;
13405: l_fnd_lvl_in_rec.uom_per_period := l_level_periods;
13406:
13407: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
13408: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Get_Billed_Amount',
13409: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
13410: ||'period start = ' || l_period_start
13411: ||', period type = ' || l_period_type);

Line 13408: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Get_Billed_Amount',

13404: l_fnd_lvl_in_rec.interface_offset_days := l_billing_profile_Csr_Rec.Interface_offset;
13405: l_fnd_lvl_in_rec.uom_per_period := l_level_periods;
13406:
13407: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
13408: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.Get_Billed_Amount',
13409: 'Calling oks_bill_util_pub.Get_next_bill_sch with parameters '
13410: ||'period start = ' || l_period_start
13411: ||', period type = ' || l_period_type);
13412: END IF;

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

13424: p_period_start => l_period_start,
13425: p_period_type => l_period_type,
13426: Strm_Start_Date => trunc(to_date(p_start_date)));
13427:
13428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13429: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13430: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type
13431: ||' l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date);
13432: END IF;

Line 13429: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',

13425: p_period_type => l_period_type,
13426: Strm_Start_Date => trunc(to_date(p_start_date)));
13427:
13428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13429: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13430: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type
13431: ||' l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date);
13432: END IF;
13433:

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

13444: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
13445: p_period_type => l_period_type ,
13446: p_period_start => l_period_start);
13447:
13448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13449: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13450: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type
13451: ||' result l_quantity = ' || l_quantity);
13452: END IF;

Line 13449: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',

13445: p_period_type => l_period_type ,
13446: p_period_start => l_period_start);
13447:
13448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13449: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13450: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type
13451: ||' result l_quantity = ' || l_quantity);
13452: END IF;
13453:

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

13455: l_return_status := G_RET_STS_ERROR;
13456: RAISE G_EXCEPTION_HALT_VALIDATION;
13457: END IF;
13458: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
13459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13460: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13461: ' result l_lvl_amt = ' || l_lvl_amt);
13462: END IF; --mchoudha added else logic for WEEK kind of uoms
13463: ELSE

Line 13460: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',

13456: RAISE G_EXCEPTION_HALT_VALIDATION;
13457: END IF;
13458: l_lvl_amt := nvl(l_constant_sll_amt*l_quantity/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442
13459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13460: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13461: ' result l_lvl_amt = ' || l_lvl_amt);
13462: END IF; --mchoudha added else logic for WEEK kind of uoms
13463: ELSE
13464: l_lvl_amt := nvl(l_constant_sll_amt*((TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-TRUNC(trunc(to_date(p_start_date))))/l_uom_quantity)/l_fnd_lvl_in_rec.uom_per_period,0); --bugfix 5485442

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

13465: END IF;
13466: ELSE
13467: */
13468: l_lvl_amt := nvl(l_constant_sll_amt,0);
13469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13471: ' l_lvl_amt = ' || l_lvl_amt);
13472: END IF;
13473: ELSE

Line 13470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',

13466: ELSE
13467: */
13468: l_lvl_amt := nvl(l_constant_sll_amt,0);
13469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13470: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13471: ' l_lvl_amt = ' || l_lvl_amt);
13472: END IF;
13473: ELSE
13474:

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

13510: EXCEPTION
13511:
13512: WHEN G_EXCEPTION_HALT_VALIDATION THEN
13513:
13514: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
13515: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.Get_Billed_Amount.EXCEPTION',
13516: 'G_EXCEPTION_HALT_VALIDATION');
13517: END IF;
13518:

Line 13515: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.Get_Billed_Amount.EXCEPTION',

13511:
13512: WHEN G_EXCEPTION_HALT_VALIDATION THEN
13513:
13514: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
13515: fnd_log.string(fnd_log.level_exception,G_MODULE_CURRENT||'.Get_Billed_Amount.EXCEPTION',
13516: 'G_EXCEPTION_HALT_VALIDATION');
13517: END IF;
13518:
13519: x_bill_amount := NULL;

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

13520: x_bill_enddate := NULL;
13521:
13522: WHEN OTHERS THEN
13523:
13524: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
13525: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Get_Billed_Amount.UNEXPECTED',
13526: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
13527: END IF;
13528: x_bill_amount := NULL;

Line 13525: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Get_Billed_Amount.UNEXPECTED',

13521:
13522: WHEN OTHERS THEN
13523:
13524: IF FND_LOG.LEVEL_UNEXPECTED >= fnd_log.g_current_runtime_level THEN
13525: fnd_log.string(fnd_log.level_unexpected,G_MODULE_CURRENT||'.Get_Billed_Amount.UNEXPECTED',
13526: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
13527: END IF;
13528: x_bill_amount := NULL;
13529: x_bill_enddate := NULL;