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_COPY_CONTRACT_PVT

Line 1: Package body OKS_COPY_CONTRACT_PVT AS

1: Package body OKS_COPY_CONTRACT_PVT AS
2: /*$Header: OKSCOPYB.pls 120.113.12010000.2 2008/10/22 12:49:17 ssreekum ship $*/
3:
4: l_debug VARCHAR2(1) := 'Y'; -- NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_count NUMBER;

Line 133: oks_renew_pvt.Debug_Log(p_program_name => 'OKS_COPY_CONTRACT_PVT',

129: l_source_line_id := l_target_line_rec.orig_system_id1;
130:
131: If l_source_line_id is null Then
132: x_return_status := l_return_status;
133: oks_renew_pvt.Debug_Log(p_program_name => 'OKS_COPY_CONTRACT_PVT',
134: p_perf_msg => 'Exiting chk_line_effectivity because orig_system_id1 was null');
135: return;
136: End If;
137:

Line 205: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.printtemptable'

201: ,l_orig_system_id1;
202: EXIT WHEN gettemptablelines%NOTFOUND;
203: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
204: FND_LOG.string(FND_LOG.level_statement
205: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.printtemptable'
206: ,'ID:'||l_id||' : CLE_ID:'||l_cle_id||' : LSE_ID:'||l_lse_id||' : ORIG ID:'||l_orig_system_id1
207: );
208: END IF;
209: END LOOP;

Line 1051: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.copy_events'

1047: ELSE
1048: x_return_status := OKC_API.G_RET_STS_WARNING;
1049: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1050: FND_LOG.string(FND_LOG.level_statement
1051: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.copy_events'
1052: ,'After call to OKC_CONDITIONS_PUB.create_cond_hdrs'
1053: ||' x_return_status:'||l_return_status
1054: ||' x_err_msg='||fnd_msg_pub.get(p_encoded=>'F')
1055: );

Line 1364: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.instantiate_counters'

1360: x_ctr_grp_id_instance => l_ctr_grp_id_instance);
1361:
1362: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1363: FND_LOG.string(FND_LOG.level_statement
1364: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.instantiate_counters'
1365: ,'After call to CS_COUNTERS_PUB.AUTOINSTANTIATE_COUNTERS'
1366: ||'p_new_cle_id='||p_new_cle_id
1367: ||'x_ctr_grp_id_template='||l_ctr_grp_id_template
1368: ||'x_ctr_grp_id_instance='||l_ctr_grp_id_instance

Line 13782: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));

13778: EXCEPTION
13779: WHEN OTHERS THEN
13780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13781: l_stage := 'Looping through l_SourceStreams_tbl';
13782: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
13783: END; --End of looping through l_SourceStreams_tbl
13784: END IF; -- End of if check for l_SourceStreams_tbl.COUNT > 0
13785:
13786: EXIT WHEN GetStreamsForSourceTopLine%NOTFOUND;

Line 13795: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));

13791: EXCEPTION
13792: WHEN OTHERS THEN
13793: l_stage := 'Fetching from cursor GetStreamsForSourceTopLine';
13794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13795: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
13796:
13797: END; --End of Fetch from GetStreamsForSourceTopLine
13798:
13799: ---------Begin of BSCH Creation for Top Line----------

Line 13902: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));

13898: END LOOP; --End LOOP for looping through TargetLinesRecTab PLSQL table --2)
13899: EXCEPTION WHEN OTHERS THEN
13900: l_stage := 'Looping through TargetLinesRecTab';
13901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13902: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
13903: END; --End of Begin for looping through TargetLinesRecTab
13904: END IF; --End of If check for TargetLinesRecTab.LINE_ID.COUNT > 0
13905:
13906: IF (P_Partial_Copy_YN = 'Y') then

Line 14735: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));

14731: EXCEPTION
14732: WHEN OTHERS THEN
14733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14734: l_stage := 'Looping through l_TrgHdrStreams_Tbl';
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

Line 14762: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));

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:
14766: ELSIF (l_TrgHdrStreams_Exists_YN = 'N') THEN

Line 14829: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));

14825: EXCEPTION
14826: WHEN OTHERS THEN
14827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14828: l_stage := 'instantiate_bsch_using_PPSetup';
14829: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));
14830: RAISE;
14831: End;
14832: -- hkamdar 20-Apr-2006 Added based on Aaron's feedback on 07-Apr-2006. to PP CR03 ammendment.
14833: -- IF no target header bill schedule exists and no PP attributes are present on Target Header then

Line 14934: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));

14930: EXCEPTION
14931: WHEN OTHERS THEN
14932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14933: l_stage := 'Looping through l_SrcLnStreams_Tbl';
14934: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
14935: RAISE;
14936: END; --End of looping through l_TrgHdrStreams_Tbl
14937:
14938: END IF; -- check for l_SrcLnStreams_Exists_YN = 'Y'

Line 14962: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage,substr(SQLERRM,1,240));

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: --------------------------------------------------------------------
14966: END IF; -- l_duration_match check

Line 15040: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));

15036: END LOOP; --End LOOP for looping through TargetLinesRecTab PLSQL table --2)
15037: EXCEPTION WHEN OTHERS THEN
15038: l_stage := 'Looping through TargetLinesRecTab';
15039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15040: FND_MSG_PUB.add_exc_msg(g_pkg_name,'OKS_COPY_CONTRACT_PVT: '||l_stage , substr(SQLERRM,1,240));
15041: END; --End of Begin for looping through TargetLinesRecTab
15042: END IF; --End of If check for TargetLinesRecTab.LINE_ID.COUNT > 0
15043:
15044: EXIT WHEN GetTrgLines_K_EXISTS_P%NOTFOUND;

Line 15418: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.Update_BP'

15414: EXIT WHEN getBPOffsetInformation%NOTFOUND;
15415: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
15416: FND_LOG.string(FND_LOG.level_statement
15417: ,l_module_name
15418: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.Update_BP'
15419: ||' BP ID : '||l_BP_ID
15420: ||' BP Start Date: '||l_BP_Start_Date
15421: ||' BP End Date: '||l_BP_End_Date
15422: ||' BP Offset Duration: '||l_BP_Offset_Duration

Line 15445: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.Update_BP'

15441:
15442: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
15443: FND_LOG.string(FND_LOG.level_statement
15444: ,l_module_name
15445: ,'OKS.plsql.OKS_COPY_CONTRACT_PVT.Update_BP'
15446: ||' Resultant Date : '||l_Resultant_Start_Date
15447: );
15448: END IF;
15449:

Line 26878: OKC_DEBUG.log('10000 : Exiting Procedure OKS_COPY_CONTRACT_PVT.copy_components ', 2);

26874: END IF;
26875:
26876: --------------------------------------------------------------------
26877: IF (l_debug = 'Y') THEN
26878: OKC_DEBUG.log('10000 : Exiting Procedure OKS_COPY_CONTRACT_PVT.copy_components ', 2);
26879: OKC_DEBUG.ReSet_Indentation;
26880: END IF;
26881:
26882: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 26907: END OKS_COPY_CONTRACT_PVT;

26903:
26904: --===============================End Copy_Components=====================================
26905:
26906:
26907: END OKS_COPY_CONTRACT_PVT;