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 13718: l_TargetTopLineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

13714:
13715: TYPE l_SourceStreams_tbl_Type IS TABLE OF GetStreamsForSourceTopLine%ROWTYPE INDEX BY BINARY_INTEGER;
13716: l_SourceStreams_tbl l_SourceStreams_tbl_Type;
13717:
13718: l_TargetTopLineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13719: l_TargetTopLineStreams_tbl_Ctr NUMBER := 0;
13720: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
13721:
13722: l_stage varchar2(100) := null;

Line 13720: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

13716: l_SourceStreams_tbl l_SourceStreams_tbl_Type;
13717:
13718: l_TargetTopLineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
13719: l_TargetTopLineStreams_tbl_Ctr NUMBER := 0;
13720: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
13721:
13722: l_stage varchar2(100) := null;
13723:
13724: BEGIN --Main Begin

Line 13846: --OKS_BILL_SCH.create_bill_sch_rules

13842: END; --End of Fetch from GetStreamsForSourceTopLine
13843:
13844: ---------Begin of BSCH Creation for Top Line----------
13845: BEGIN
13846: --OKS_BILL_SCH.create_bill_sch_rules
13847: OKS_BILL_SCH.create_bill_sch_rules(
13848: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
13849: ,p_sll_tbl => l_TargetTopLineStreams_tbl
13850: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)

Line 13847: OKS_BILL_SCH.create_bill_sch_rules(

13843:
13844: ---------Begin of BSCH Creation for Top Line----------
13845: BEGIN
13846: --OKS_BILL_SCH.create_bill_sch_rules
13847: OKS_BILL_SCH.create_bill_sch_rules(
13848: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
13849: ,p_sll_tbl => l_TargetTopLineStreams_tbl
13850: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)
13851: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

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

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_rules'
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_rules', 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_rules', substr(SQLERRM,1,240));
13863: RETURN;
13864: END IF;
13865:
13866:

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

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

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

13873: ||'SQLERRM ='||SQLERRM
13874: );
13875: END IF;
13876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13877: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
13878: RAISE;
13879: END;
13880: --------End of BSCH Creation for Top Line
13881:

Line 13891: Oks_bill_sch.Create_Bill_Sch_CP(

13887: IF (TargetLinesRecTab.GEN_SUBLINE_BSCH_YN(i) = 'Y') then
13888: --------Begin of BSCH Creation for Subline------------
13889:
13890: BEGIN
13891: Oks_bill_sch.Create_Bill_Sch_CP(
13892: p_top_line_id => TargetLinesRecTab.CLE_ID(i)
13893: ,p_cp_line_id => TargetLinesRecTab.LINE_ID(i)
13894: ,p_cp_new => 'Y'
13895: ,x_return_status => x_return_status

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

13898: );
13899: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13900: FND_LOG.string(FND_LOG.level_statement
13901: ,l_module_name
13902: ,'After call to OKS_BILL_SCH.Create_Bill_Sch_CP'
13903: ||',x_return_status='||x_return_status
13904: );
13905: END IF;
13906: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

13903: ||',x_return_status='||x_return_status
13904: );
13905: END IF;
13906: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
13907: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_cp', substr(SQLERRM,1,240));
13908: RETURN;
13909: END IF;
13910:
13911:

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

13915: WHEN OTHERS THEN
13916: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
13917: FND_LOG.string(FND_LOG.level_unexpected
13918: ,l_module_name||'.EXCEPTION'
13919: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_cp, x_return_status ='||x_return_status
13920: ||'SQLERRM ='||SQLERRM
13921: );
13922: END IF;
13923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

13933: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
13934: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13935: FND_LOG.string(FND_LOG.level_statement
13936: ,l_module_name
13937: ,'Return status from OKS_BILL_SCH : x_return_status ='||x_return_status
13938: );
13939: END IF;
13940: RETURN;
13941: End If;

Line 14029: l_HdrStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

14025: l_api_name CONSTANT VARCHAR2(30) := 'instantiate_bsch_using_PPSetup';
14026: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
14027:
14028:
14029: l_HdrStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14030: l_HdrStreams_tbl_Ctr NUMBER := 0;
14031:
14032: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14033: l_LineStreams_tbl_Ctr NUMBER := 0;

Line 14032: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

14028:
14029: l_HdrStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14030: l_HdrStreams_tbl_Ctr NUMBER := 0;
14031:
14032: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14033: l_LineStreams_tbl_Ctr NUMBER := 0;
14034:
14035: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
14036: l_tce_code VARCHAR2(100);

Line 14035: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

14031:
14032: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14033: l_LineStreams_tbl_Ctr NUMBER := 0;
14034:
14035: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
14036: l_tce_code VARCHAR2(100);
14037: l_uom_quantity NUMBER;
14038: l_level_periods NUMBER;
14039:

Line 14126: OKS_BILL_SCH.Create_Header_Bill_Sch(

14122: END; --End of populating Stream table for Target Header
14123:
14124:
14125: --Generate Billing Schedule for Target Header--
14126: OKS_BILL_SCH.Create_Header_Bill_Sch(
14127: p_billing_type => BillingScheduleType
14128: ,p_sll_tbl => l_HdrStreams_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_hdr_bill_sch'

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_hdr_bill_sch'
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_hdr_bill_sch', 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_hdr_bill_sch', substr(SQLERRM,1,240));
14141: RETURN;
14142: END IF;
14143:
14144: ELSIF P_To_Line_ID IS NOT NULL then

Line 14171: OKS_BILL_SCH.create_bill_sch_rules(

14167: -- End NECHATUR Bug#5349539
14168: END; --End of populating Stream table for Target Top Line
14169:
14170: --Generate Billing Schedule for Top Line--
14171: OKS_BILL_SCH.create_bill_sch_rules(
14172: p_billing_type => BillingScheduleType
14173: ,p_sll_tbl => l_LineStreams_tbl
14174: ,p_invoice_rule_id => InvoiceRuleID
14175: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

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

14176: ,x_return_status => x_return_status);
14177: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14178: FND_LOG.string(FND_LOG.level_statement
14179: ,l_module_name
14180: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
14181: ||',x_return_status='||x_return_status
14182: );
14183: END IF;
14184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

14181: ||',x_return_status='||x_return_status
14182: );
14183: END IF;
14184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14185: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
14186: RETURN;
14187: END IF;
14188: END IF; --End of P_To_Line_ID check
14189:

Line 14419: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;

14415: l_tce_code VARCHAR2(100);
14416: l_uom_quantity NUMBER;
14417: l_level_periods NUMBER;
14418:
14419: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14420: l_LineStreams_tbl_Ctr NUMBER := 0;
14421: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
14422:
14423: -- hkamdar 20-Apr-2006

Line 14421: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

14417: l_level_periods NUMBER;
14418:
14419: l_LineStreams_tbl OKS_BILL_SCH.StreamLvl_tbl;
14420: l_LineStreams_tbl_Ctr NUMBER := 0;
14421: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
14422:
14423: -- hkamdar 20-Apr-2006
14424: -- added to incorporate Aaron's feedback on 07-Apr-2006 about partial copy
14425: l_duration_match VARCHAR2(1);

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

14780: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
14781: RAISE;
14782: END; --End of looping through l_TrgHdrStreams_Tbl
14783:
14784: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14785: --Generate Billing Schedule for Top Line--
14786: OKS_BILL_SCH.create_bill_sch_rules(
14787: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14788: ,p_sll_tbl => l_LineStreams_tbl

Line 14786: OKS_BILL_SCH.create_bill_sch_rules(

14782: END; --End of looping through l_TrgHdrStreams_Tbl
14783:
14784: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14785: --Generate Billing Schedule for Top Line--
14786: OKS_BILL_SCH.create_bill_sch_rules(
14787: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14788: ,p_sll_tbl => l_LineStreams_tbl
14789: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)
14790: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

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

14791: ,x_return_status => x_return_status);
14792: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14793: FND_LOG.string(FND_LOG.level_statement
14794: ,l_module_name
14795: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
14796: ||',x_return_status='||x_return_status
14797: );
14798: END IF;
14799: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

14796: ||',x_return_status='||x_return_status
14797: );
14798: END IF;
14799: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
14800: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
14801: RETURN;
14802: END IF;
14803: EXCEPTION
14804: WHEN OTHERS THEN

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

14802: END IF;
14803: EXCEPTION
14804: WHEN OTHERS THEN
14805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14806: l_stage := 'OKS_BILL_SCH.create_bill_sch_rules';
14807: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));
14808: RAISE;
14809: END;
14810:

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

14980: RAISE;
14981: END; --End of looping through l_TrgHdrStreams_Tbl
14982:
14983: END IF; -- check for l_SrcLnStreams_Exists_YN = 'Y'
14984: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14985: --Generate Billing Schedule for Top Line--
14986: OKS_BILL_SCH.create_bill_sch_rules(
14987: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14988: ,p_sll_tbl => l_LineStreams_tbl

Line 14986: OKS_BILL_SCH.create_bill_sch_rules(

14982:
14983: END IF; -- check for l_SrcLnStreams_Exists_YN = 'Y'
14984: BEGIN --Begin for calling OKS_BILL_SCH.Create_Bill_Sch_Rules
14985: --Generate Billing Schedule for Top Line--
14986: OKS_BILL_SCH.create_bill_sch_rules(
14987: p_billing_type => TargetLinesRecTab.BILLING_SCHEDULE_TYPE(i)
14988: ,p_sll_tbl => l_LineStreams_tbl
14989: ,p_invoice_rule_id => TargetLinesRecTab.INV_RULE_ID(i)
14990: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl

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

14991: ,x_return_status => x_return_status);
14992: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
14993: FND_LOG.string(FND_LOG.level_statement
14994: ,l_module_name
14995: ,'After call to OKS_BILL_SCH.create_bill_sch_rules'
14996: ||',x_return_status='||x_return_status
14997: );
14998: END IF;
14999: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

14996: ||',x_return_status='||x_return_status
14997: );
14998: END IF;
14999: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
15000: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_rules', substr(SQLERRM,1,240));
15001: RETURN;
15002: END IF;
15003: EXCEPTION
15004: WHEN OTHERS THEN

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

15002: END IF;
15003: EXCEPTION
15004: WHEN OTHERS THEN
15005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15006: l_stage := 'OKS_BILL_SCH.create_bill_sch_rules';
15007: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));
15008: RAISE;
15009: END;
15010: --------------------------------------------------------------------

Line 15023: Oks_bill_sch.Create_Bill_Sch_CP(

15019: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
15020: --------Begin of BSCH Creation for Subline--------------------------
15021: --------For sublines, use topline schedules to generate schedule-----
15022: BEGIN
15023: Oks_bill_sch.Create_Bill_Sch_CP(
15024: p_top_line_id => TargetLinesRecTab.CLE_ID(i)
15025: ,p_cp_line_id => TargetLinesRecTab.LINE_ID(i)
15026: ,p_cp_new => 'Y'
15027: ,x_return_status => x_return_status

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

15030: );
15031: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
15032: FND_LOG.string(FND_LOG.level_statement
15033: ,l_module_name
15034: ,'After call to OKS_BILL_SCH.Create_Bill_Sch_CP'
15035: ||',x_return_status='||x_return_status
15036: );
15037: END IF;
15038: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

15035: ||',x_return_status='||x_return_status
15036: );
15037: END IF;
15038: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
15039: FND_MSG_PUB.add_exc_msg(g_pkg_name, 'Exception in call to OKS_BILL_SCH.create_bill_sch_cp', substr(SQLERRM,1,240));
15040: RETURN;
15041: END IF;
15042:
15043: EXCEPTION

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

15044: WHEN OTHERS THEN
15045: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
15046: FND_LOG.string(FND_LOG.level_unexpected
15047: ,l_module_name||'.EXCEPTION'
15048: ,'Exception in call to OKS_BILL_SCH.create_bill_sch_cp, x_return_status ='||x_return_status
15049: ||'SQLERRM ='||SQLERRM
15050: );
15051: END IF;
15052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

15060: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
15061: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
15062: FND_LOG.string(FND_LOG.level_statement
15063: ,l_module_name
15064: ,'Return status from OKS_BILL_SCH : x_return_status ='||x_return_status
15065: );
15066: END IF;
15067: RETURN;
15068: END IF;