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_COPY_CONTRACT_PVT dependencies on OKS_BILL_SCH

Line 13673: l_TargetTopLineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

13669:
13670: TYPE l_SourceStreams_tbl_Type IS TABLE OF GetStreamsForSourceTopLine%ROWTYPE INDEX BY BINARY_INTEGER;
13671: l_SourceStreams_tbl l_SourceStreams_tbl_Type;
13672:
13673: l_TargetTopLineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13674: l_TargetTopLineStreams_tbl_Ctr NUMBER := 0;
13675: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
13676:
13677: l_stage varchar2(100) := null;

Line 13675: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

13671: l_SourceStreams_tbl l_SourceStreams_tbl_Type;
13672:
13673: l_TargetTopLineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13674: l_TargetTopLineStreams_tbl_Ctr NUMBER := 0;
13675: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
13676:
13677: l_stage varchar2(100) := null;
13678:
13679: BEGIN --Main Begin

Line 13801: --OKS_BILL_SCH.create_bill_sch_rules

13797: END; --End of Fetch from GetStreamsForSourceTopLine
13798:
13799: ---------Begin of BSCH Creation for Top Line----------
13800: BEGIN
13801: --OKS_BILL_SCH.create_bill_sch_rules
13802: OKS_BILL_SCH.create_bill_sch_rules(
13803: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
13804: ,p_sll_tbl => l_TargetTopLineStreams_tbl
13805: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)

Line 13802: OKS_BILL_SCH.create_bill_sch_rules(

13798:
13799: ---------Begin of BSCH Creation for Top Line----------
13800: BEGIN
13801: --OKS_BILL_SCH.create_bill_sch_rules
13802: OKS_BILL_SCH.create_bill_sch_rules(
13803: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
13804: ,p_sll_tbl => l_TargetTopLineStreams_tbl
13805: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)
13806: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

Line 13812: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'

13808:
13809: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13810: FND_LOG.string(FND_LOG.level_statement
13811: ,l_module_name
13812: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
13813: ||',x_return_status='||x_return_status
13814: );
13815: END IF;
13816: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 13817: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));

13813: ||',x_return_status='||x_return_status
13814: );
13815: END IF;
13816: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
13817: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
13818: RETURN;
13819: END IF;
13820:
13821:

Line 13827: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status ='||x_return_status

13823: WHEN OTHERS THEN
13824: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
13825: FND_LOG.string(FND_LOG.level_unexpected
13826: ,l_module_name||'.EXCEPTION'
13827: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status ='||x_return_status
13828: ||'SQLERRM ='||SQLERRM
13829: );
13830: END IF;
13831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 13832: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));

13828: ||'SQLERRM ='||SQLERRM
13829: );
13830: END IF;
13831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13832: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
13833: RAISE;
13834: END;
13835: --------End of BSCH Creation for Top Line
13836:

Line 13846: Oks_bill_sch.Create_Bill_Sch_CP(

13842: IF (TargetLinesRecTab.GEN_SUBLINE_BSCH_YN(i) = 'Y') then
13843: --------Begin of BSCH Creation for Subline------------
13844:
13845: BEGIN
13846: Oks_bill_sch.Create_Bill_Sch_CP(
13847: p_top_line_id => TargetLinesRecTab.CLE_ID(i)
13848: ,p_cp_line_id => TargetLinesRecTab.LINE_ID(i)
13849: ,p_cp_new => 'Y'
13850: ,x_return_status => x_return_status

Line 13857: ,'After call to OKS_BILL_SCH.Create_Bill_Sch_CP'

13853: );
13854: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13855: FND_LOG.string(FND_LOG.level_statement
13856: ,l_module_name
13857: ,'After call to OKS_BILL_SCH.Create_Bill_Sch_CP'
13858: ||',x_return_status='||x_return_status
13859: );
13860: END IF;
13861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 13862: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_cp', substr(SQLERRM,1,240));

13858: ||',x_return_status='||x_return_status
13859: );
13860: END IF;
13861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
13862: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_cp', substr(SQLERRM,1,240));
13863: RETURN;
13864: END IF;
13865:
13866:

Line 13874: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_cp, x_return_status ='||x_return_status

13870: WHEN OTHERS THEN
13871: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
13872: FND_LOG.string(FND_LOG.level_unexpected
13873: ,l_module_name||'.EXCEPTION'
13874: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_cp, x_return_status ='||x_return_status
13875: ||'SQLERRM ='||SQLERRM
13876: );
13877: END IF;
13878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 13892: ,'Return status from OKS_BILL_SCH : x_return_status ='||x_return_status

13888: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
13889: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13890: FND_LOG.string(FND_LOG.level_statement
13891: ,l_module_name
13892: ,'Return status from OKS_BILL_SCH : x_return_status ='||x_return_status
13893: );
13894: END IF;
13895: RETURN;
13896: End If;

Line 13984: l_HdrStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

13980: l_api_name CONSTANT VARCHAR2(30) := 'instantiate_bsch_using_PPSetup';
13981: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
13982:
13983:
13984: l_HdrStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13985: l_HdrStreams_tbl_Ctr NUMBER := 0;
13986:
13987: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13988: l_LineStreams_tbl_Ctr NUMBER := 0;

Line 13987: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

13983:
13984: l_HdrStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13985: l_HdrStreams_tbl_Ctr NUMBER := 0;
13986:
13987: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13988: l_LineStreams_tbl_Ctr NUMBER := 0;
13989:
13990: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
13991: l_tce_code VARCHAR2(100);

Line 13990: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

13986:
13987: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13988: l_LineStreams_tbl_Ctr NUMBER := 0;
13989:
13990: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
13991: l_tce_code VARCHAR2(100);
13992: l_uom_quantity NUMBER;
13993: l_level_periods NUMBER;
13994:

Line 14081: OKS_BILL_SCH.Create_Header_Bill_Sch(

14077: END; --End of populating Stream table for Target Header
14078:
14079:
14080: --Generate Billing Schedule for Target Header--
14081: OKS_BILL_SCH.Create_Header_Bill_Sch(
14082: p_billing_type => BillingScheduleType
14083: ,p_sll_tbl => l_HdrStreams_tbl
14084: ,p_invoice_rule_id => InvoiceRuleID
14085: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

Line 14090: ,'After call to OKS_BILL_SCH.create_hdr_bill_sch'

14086: ,x_return_status => x_return_status);
14087: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14088: FND_LOG.string(FND_LOG.level_statement
14089: ,l_module_name
14090: ,'After call to OKS_BILL_SCH.create_hdr_bill_sch'
14091: ||',x_return_status='||x_return_status
14092: );
14093: END IF;
14094: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 14095: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_hdr_bill_sch', substr(SQLERRM,1,240));

14091: ||',x_return_status='||x_return_status
14092: );
14093: END IF;
14094: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14095: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_hdr_bill_sch', substr(SQLERRM,1,240));
14096: RETURN;
14097: END IF;
14098:
14099: ELSIF P_To_Line_ID IS NOT NULL then

Line 14126: OKS_BILL_SCH.create_bill_sch_rules(

14122: -- End NECHATUR Bug#5349539
14123: END; --End of populating Stream table for Target Top Line
14124:
14125: --Generate Billing Schedule for Top Line--
14126: OKS_BILL_SCH.create_bill_sch_rules(
14127: p_billing_type => BillingScheduleType
14128: ,p_sll_tbl => l_LineStreams_tbl
14129: ,p_invoice_rule_id => InvoiceRuleID
14130: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

Line 14135: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'

14131: ,x_return_status => x_return_status);
14132: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14133: FND_LOG.string(FND_LOG.level_statement
14134: ,l_module_name
14135: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
14136: ||',x_return_status='||x_return_status
14137: );
14138: END IF;
14139: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 14140: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));

14136: ||',x_return_status='||x_return_status
14137: );
14138: END IF;
14139: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14140: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
14141: RETURN;
14142: END IF;
14143: END IF; --End of P_To_Line_ID check
14144:

Line 14374: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

14370: l_tce_code VARCHAR2(100);
14371: l_uom_quantity NUMBER;
14372: l_level_periods NUMBER;
14373:
14374: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14375: l_LineStreams_tbl_Ctr NUMBER := 0;
14376: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
14377:
14378: -- hkamdar 20-Apr-2006

Line 14376: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

14372: l_level_periods NUMBER;
14373:
14374: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14375: l_LineStreams_tbl_Ctr NUMBER := 0;
14376: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
14377:
14378: -- hkamdar 20-Apr-2006
14379: -- added to incorporate Aaron's feedback on 07-Apr-2006 about partial copy
14380: l_duration_match VARCHAR2(1);

Line 14739: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules

14735: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
14736: RAISE;
14737: END; --End of looping through l_TrgHdrStreams_Tbl
14738:
14739: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14740: --Generate Billing Schedule for Top Line--
14741: OKS_BILL_SCH.create_bill_sch_rules(
14742: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14743: ,p_sll_tbl => l_LineStreams_tbl

Line 14741: OKS_BILL_SCH.create_bill_sch_rules(

14737: END; --End of looping through l_TrgHdrStreams_Tbl
14738:
14739: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14740: --Generate Billing Schedule for Top Line--
14741: OKS_BILL_SCH.create_bill_sch_rules(
14742: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14743: ,p_sll_tbl => l_LineStreams_tbl
14744: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)
14745: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

Line 14750: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'

14746: ,x_return_status => x_return_status);
14747: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14748: FND_LOG.string(FND_LOG.level_statement
14749: ,l_module_name
14750: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
14751: ||',x_return_status='||x_return_status
14752: );
14753: END IF;
14754: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 14755: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));

14751: ||',x_return_status='||x_return_status
14752: );
14753: END IF;
14754: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14755: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
14756: RETURN;
14757: END IF;
14758: EXCEPTION
14759: WHEN OTHERS THEN

Line 14761: l_stage := 'OKS_BILL_SCH.create_bill_sch_rules';

14757: END IF;
14758: EXCEPTION
14759: WHEN OTHERS THEN
14760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14761: l_stage := 'OKS_BILL_SCH.create_bill_sch_rules';
14762: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));
14763: RAISE;
14764: END;
14765:

Line 14939: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules

14935: RAISE;
14936: END; --End of looping through l_TrgHdrStreams_Tbl
14937:
14938: END IF; -- check for l_SrcLnStreams_Exists_YN = 'Y'
14939: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14940: --Generate Billing Schedule for Top Line--
14941: OKS_BILL_SCH.create_bill_sch_rules(
14942: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14943: ,p_sll_tbl => l_LineStreams_tbl

Line 14941: OKS_BILL_SCH.create_bill_sch_rules(

14937:
14938: END IF; -- check for l_SrcLnStreams_Exists_YN = 'Y'
14939: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14940: --Generate Billing Schedule for Top Line--
14941: OKS_BILL_SCH.create_bill_sch_rules(
14942: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14943: ,p_sll_tbl => l_LineStreams_tbl
14944: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)
14945: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

Line 14950: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'

14946: ,x_return_status => x_return_status);
14947: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14948: FND_LOG.string(FND_LOG.level_statement
14949: ,l_module_name
14950: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
14951: ||',x_return_status='||x_return_status
14952: );
14953: END IF;
14954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 14955: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));

14951: ||',x_return_status='||x_return_status
14952: );
14953: END IF;
14954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14955: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
14956: RETURN;
14957: END IF;
14958: EXCEPTION
14959: WHEN OTHERS THEN

Line 14961: l_stage := 'OKS_BILL_SCH.create_bill_sch_rules';

14957: END IF;
14958: EXCEPTION
14959: WHEN OTHERS THEN
14960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14961: l_stage := 'OKS_BILL_SCH.create_bill_sch_rules';
14962: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));
14963: RAISE;
14964: END;
14965: --------------------------------------------------------------------

Line 14978: Oks_bill_sch.Create_Bill_Sch_CP(

14974: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
14975: --------Begin of BSCH Creation for Subline--------------------------
14976: --------For sublines, use topline schedules to generate schedule-----
14977: BEGIN
14978: Oks_bill_sch.Create_Bill_Sch_CP(
14979: p_top_line_id => TargetLinesRecTab.CLE_ID(i)
14980: ,p_cp_line_id => TargetLinesRecTab.LINE_ID(i)
14981: ,p_cp_new => 'Y'
14982: ,x_return_status => x_return_status

Line 14989: ,'After call to OKS_BILL_SCH.Create_Bill_Sch_CP'

14985: );
14986: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14987: FND_LOG.string(FND_LOG.level_statement
14988: ,l_module_name
14989: ,'After call to OKS_BILL_SCH.Create_Bill_Sch_CP'
14990: ||',x_return_status='||x_return_status
14991: );
14992: END IF;
14993: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 14994: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_cp', substr(SQLERRM,1,240));

14990: ||',x_return_status='||x_return_status
14991: );
14992: END IF;
14993: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14994: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_cp', substr(SQLERRM,1,240));
14995: RETURN;
14996: END IF;
14997:
14998: EXCEPTION

Line 15003: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_cp, x_return_status ='||x_return_status

14999: WHEN OTHERS THEN
15000: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
15001: FND_LOG.string(FND_LOG.level_unexpected
15002: ,l_module_name||'.EXCEPTION'
15003: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_cp, x_return_status ='||x_return_status
15004: ||'SQLERRM ='||SQLERRM
15005: );
15006: END IF;
15007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 15019: ,'Return status from OKS_BILL_SCH : x_return_status ='||x_return_status

15015: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
15016: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
15017: FND_LOG.string(FND_LOG.level_statement
15018: ,l_module_name
15019: ,'Return status from OKS_BILL_SCH : x_return_status ='||x_return_status
15020: );
15021: END IF;
15022: RETURN;
15023: END IF;