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_COVERAGES_PVT dependencies on OKC_DEBUG

Line 892: okc_debug.Set_Indentation('Create_Actual_Coverage');

888: -----------------------------------------
889: BEGIN
890:
891: IF (G_DEBUG_ENABLED = 'Y') THEN
892: okc_debug.Set_Indentation('Create_Actual_Coverage');
893: okc_debug.log('Entered Create_Actual_Coverage', 2);
894: END IF;
895:
896: l_Service_Line_Id:=P_Ac_Rec_In.SVc_Cle_Id;

Line 893: okc_debug.log('Entered Create_Actual_Coverage', 2);

889: BEGIN
890:
891: IF (G_DEBUG_ENABLED = 'Y') THEN
892: okc_debug.Set_Indentation('Create_Actual_Coverage');
893: okc_debug.log('Entered Create_Actual_Coverage', 2);
894: END IF;
895:
896: l_Service_Line_Id:=P_Ac_Rec_In.SVc_Cle_Id;
897: l_Template_Line_Id:=P_Ac_Rec_In.Tmp_Cle_Id;

Line 1047: okc_debug.log('After okc_contract_pub create_contract_line', 2);

1043: );
1044:
1045:
1046: IF (G_DEBUG_ENABLED = 'Y') THEN
1047: okc_debug.log('After okc_contract_pub create_contract_line', 2);
1048: END IF;
1049:
1050: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1051: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1090: okc_debug.log('After OKS_CONTRACT_LINE_PUB.CREATE_LINE', 2);

1086:
1087:
1088:
1089: IF (G_DEBUG_ENABLED = 'Y') THEN
1090: okc_debug.log('After OKS_CONTRACT_LINE_PUB.CREATE_LINE', 2);
1091: END IF;
1092:
1093:
1094: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 1176: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);

1172:
1173:
1174:
1175: IF (G_DEBUG_ENABLED = 'Y') THEN
1176: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
1177: END IF;
1178:
1179:
1180: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 1358: okc_debug.log('After OKS_CTZ_PVT insert_row'||l_return_status, 2);

1354: x_oks_coverage_timezones_v_tbl => l_covtz_tbl_out);
1355:
1356:
1357: IF (G_DEBUG_ENABLED = 'Y') THEN
1358: okc_debug.log('After OKS_CTZ_PVT insert_row'||l_return_status, 2);
1359: END IF;
1360:
1361:
1362: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 1406: okc_debug.log('After OKS_CVT_PVT insert_row'||l_return_status, 2);

1402: END LOOP;
1403:
1404:
1405: IF (G_DEBUG_ENABLED = 'Y') THEN
1406: okc_debug.log('After OKS_CVT_PVT insert_row'||l_return_status, 2);
1407: END IF;
1408:
1409:
1410: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 1531: okc_debug.log('After OKS_ACT_PVT INSERT_ROW'||l_return_status, 2);

1527: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
1528: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
1529:
1530: IF (G_DEBUG_ENABLED = 'Y') THEN
1531: okc_debug.log('After OKS_ACT_PVT INSERT_ROW'||l_return_status, 2);
1532: END IF;
1533:
1534:
1535:

Line 1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);

1566: p_oks_action_times_v_tbl => l_act_time_tbl_in,
1567: x_oks_action_times_v_tbl => l_act_time_tbl_out);
1568:
1569: IF (G_DEBUG_ENABLED = 'Y') THEN
1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
1571: END IF;
1572:
1573: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1574: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1922: okc_debug.log('Exiting Create_Actual_Coverage', 2);

1918: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
1919: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
1920:
1921: IF (G_DEBUG_ENABLED = 'Y') THEN
1922: okc_debug.log('Exiting Create_Actual_Coverage', 2);
1923: okc_debug.Reset_Indentation;
1924: END IF;
1925:
1926: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 1923: okc_debug.Reset_Indentation;

1919: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
1920:
1921: IF (G_DEBUG_ENABLED = 'Y') THEN
1922: okc_debug.log('Exiting Create_Actual_Coverage', 2);
1923: okc_debug.Reset_Indentation;
1924: END IF;
1925:
1926: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1927: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1939: okc_debug.log('Exiting Create_Actual_Coverage', 2);

1935:
1936: END LOOP;
1937:
1938: IF (G_DEBUG_ENABLED = 'Y') THEN
1939: okc_debug.log('Exiting Create_Actual_Coverage', 2);
1940: okc_debug.Reset_Indentation;
1941: END IF;
1942:
1943: x_actual_coverage_id :=c_cle_id;

Line 1940: okc_debug.Reset_Indentation;

1936: END LOOP;
1937:
1938: IF (G_DEBUG_ENABLED = 'Y') THEN
1939: okc_debug.log('Exiting Create_Actual_Coverage', 2);
1940: okc_debug.Reset_Indentation;
1941: END IF;
1942:
1943: x_actual_coverage_id :=c_cle_id;
1944: x_return_status := l_return_status ;

Line 1989: okc_debug.log('Exiting Create_Actual_Coverage'||l_return_Status, 2);

1985: );
1986: */
1987:
1988: IF (G_DEBUG_ENABLED = 'Y') THEN
1989: okc_debug.log('Exiting Create_Actual_Coverage'||l_return_Status, 2);
1990: okc_debug.Reset_Indentation;
1991: END IF;
1992:
1993:

Line 1990: okc_debug.Reset_Indentation;

1986: */
1987:
1988: IF (G_DEBUG_ENABLED = 'Y') THEN
1989: okc_debug.log('Exiting Create_Actual_Coverage'||l_return_Status, 2);
1990: okc_debug.Reset_Indentation;
1991: END IF;
1992:
1993:
1994: WHEN OTHERS THEN

Line 2007: okc_debug.log('Exiting Create_Actual_Coverage'||SQLERRM, 2);

2003: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2004: x_msg_count :=l_msg_count;
2005:
2006: IF (G_DEBUG_ENABLED = 'Y') THEN
2007: okc_debug.log('Exiting Create_Actual_Coverage'||SQLERRM, 2);
2008: okc_debug.Reset_Indentation;
2009: END IF;
2010:
2011: END create_actual_coverage;

Line 2008: okc_debug.Reset_Indentation;

2004: x_msg_count :=l_msg_count;
2005:
2006: IF (G_DEBUG_ENABLED = 'Y') THEN
2007: okc_debug.log('Exiting Create_Actual_Coverage'||SQLERRM, 2);
2008: okc_debug.Reset_Indentation;
2009: END IF;
2010:
2011: END create_actual_coverage;
2012:

Line 2455: okc_debug.Set_Indentation('Undo_Line');

2451:
2452: BEGIN
2453:
2454: IF (G_DEBUG_ENABLED = 'Y') THEN
2455: okc_debug.Set_Indentation('Undo_Line');
2456: okc_debug.log('Entered Undo_Line', 2);
2457: END IF;
2458:
2459:

Line 2456: okc_debug.log('Entered Undo_Line', 2);

2452: BEGIN
2453:
2454: IF (G_DEBUG_ENABLED = 'Y') THEN
2455: okc_debug.Set_Indentation('Undo_Line');
2456: okc_debug.log('Entered Undo_Line', 2);
2457: END IF;
2458:
2459:
2460:

Line 2519: okc_debug.log('Before BRS_REC', 2);

2515:
2516: -- End of Bug:4535339 by Jvorugan
2517:
2518: IF (G_DEBUG_ENABLED = 'Y') THEN
2519: okc_debug.log('Before BRS_REC', 2);
2520: END IF;
2521:
2522:
2523: FOR BRS_REC IN CUR_GET_BRS_ID(l_line_id) LOOP

Line 2549: okc_debug.log('After OKS_BRS_PVT delete_row', 2);

2545:
2546: END LOOP ;
2547:
2548: IF (G_DEBUG_ENABLED = 'Y') THEN
2549: okc_debug.log('After OKS_BRS_PVT delete_row', 2);
2550: END IF;
2551:
2552: OPEN Child_Cur(P_line_id);
2553:

Line 2695: okc_debug.log('BEFORE OKS_PM_PROGRAMS_PVT UNDO_PM_LINE', 2);

2691:
2692: /*
2693:
2694: IF (G_DEBUG_ENABLED = 'Y') THEN
2695: okc_debug.log('BEFORE OKS_PM_PROGRAMS_PVT UNDO_PM_LINE', 2);
2696:
2697: END IF;
2698:
2699:

Line 2794: okc_debug.log('AFTER OKS_CTZ_PVT delete_row', 2);

2790:
2791: END IF;
2792:
2793: IF (G_DEBUG_ENABLED = 'Y') THEN
2794: okc_debug.log('AFTER OKS_CTZ_PVT delete_row', 2);
2795:
2796: END IF;
2797:
2798:

Line 2817: okc_debug.log('AFTER OKS_ACM_PVT delete_row', 2);

2813: END IF;
2814:
2815:
2816: IF (G_DEBUG_ENABLED = 'Y') THEN
2817: okc_debug.log('AFTER OKS_ACM_PVT delete_row', 2);
2818:
2819: END IF;
2820:
2821: IF l_actv_tbl_in.COUNT > 0 THEN

Line 2838: okc_debug.log('AFTER OKS_ACT_PVT delete_row', 2);

2834: return;
2835: END IF;
2836:
2837: IF (G_DEBUG_ENABLED = 'Y') THEN
2838: okc_debug.log('AFTER OKS_ACT_PVT delete_row', 2);
2839:
2840: END IF;
2841:
2842: END IF;

Line 2919: okc_debug.log('AFTER OKS_ORDER_CONTACTS_PUB delete_order_contract', 2);

2915: END IF;
2916:
2917:
2918: IF (G_DEBUG_ENABLED = 'Y') THEN
2919: okc_debug.log('AFTER OKS_ORDER_CONTACTS_PUB delete_order_contract', 2);
2920:
2921: END IF;
2922:
2923:

Line 2943: okc_debug.log('AFTER OKS_ORDER_DETAILS_PUB delete_order_detail', 2);

2939: END IF;
2940:
2941:
2942: IF (G_DEBUG_ENABLED = 'Y') THEN
2943: okc_debug.log('AFTER OKS_ORDER_DETAILS_PUB delete_order_detail', 2);
2944:
2945: END IF;
2946:
2947:

Line 2968: okc_debug.log('AFTER OKS_SALES_CREDIT_PUB Delete_Sales_Credit', 2);

2964:
2965:
2966:
2967: IF (G_DEBUG_ENABLED = 'Y') THEN
2968: okc_debug.log('AFTER OKS_SALES_CREDIT_PUB Delete_Sales_Credit', 2);
2969:
2970: END IF;
2971:
2972:

Line 2991: okc_debug.log('AFTER OKC_K_REL_OBJS_PUB Delete_Row', 2);

2987: end if;
2988: END IF;
2989:
2990: IF (G_DEBUG_ENABLED = 'Y') THEN
2991: okc_debug.log('AFTER OKC_K_REL_OBJS_PUB Delete_Row', 2);
2992:
2993: END IF;
2994:
2995:

Line 3112: okc_debug.log('AFTER okc_contract_ITEM_pub.delete_Contract_ITEM', 2);

3108: END IF;
3109:
3110:
3111: IF (G_DEBUG_ENABLED = 'Y') THEN
3112: okc_debug.log('AFTER okc_contract_ITEM_pub.delete_Contract_ITEM', 2);
3113:
3114: END IF;
3115:
3116: IF NOT l_clev_tbl_in.COUNT=0

Line 3149: okc_debug.log('End of Undo Line', 2);

3145: end if;
3146: x_Return_status:=l_Return_status;
3147:
3148: IF (G_DEBUG_ENABLED = 'Y') THEN
3149: okc_debug.log('End of Undo Line', 2);
3150: okc_debug.Reset_Indentation;
3151: END IF;
3152:
3153:

Line 3150: okc_debug.Reset_Indentation;

3146: x_Return_status:=l_Return_status;
3147:
3148: IF (G_DEBUG_ENABLED = 'Y') THEN
3149: okc_debug.log('End of Undo Line', 2);
3150: okc_debug.Reset_Indentation;
3151: END IF;
3152:
3153:
3154:

Line 3159: okc_debug.log('Exception of Undo Line e_Error'||SQLERRM, 2);

3155: EXCEPTION
3156: WHEN e_Error THEN
3157:
3158: IF (G_DEBUG_ENABLED = 'Y') THEN
3159: okc_debug.log('Exception of Undo Line e_Error'||SQLERRM, 2);
3160: okc_debug.Reset_Indentation;
3161: END IF;
3162:
3163:

Line 3160: okc_debug.Reset_Indentation;

3156: WHEN e_Error THEN
3157:
3158: IF (G_DEBUG_ENABLED = 'Y') THEN
3159: okc_debug.log('Exception of Undo Line e_Error'||SQLERRM, 2);
3160: okc_debug.Reset_Indentation;
3161: END IF;
3162:
3163:
3164: x_msg_count :=l_msg_count;

Line 3171: okc_debug.log('Exception of Undo Line when_others'||SQLERRM, 2);

3167:
3168: WHEN OTHERS THEN
3169:
3170: IF (G_DEBUG_ENABLED = 'Y') THEN
3171: okc_debug.log('Exception of Undo Line when_others'||SQLERRM, 2);
3172: okc_debug.Reset_Indentation;
3173: END IF;
3174:
3175: x_msg_count :=l_msg_count;

Line 3172: okc_debug.Reset_Indentation;

3168: WHEN OTHERS THEN
3169:
3170: IF (G_DEBUG_ENABLED = 'Y') THEN
3171: okc_debug.log('Exception of Undo Line when_others'||SQLERRM, 2);
3172: okc_debug.Reset_Indentation;
3173: END IF;
3174:
3175: x_msg_count :=l_msg_count;
3176: OKC_API.SET_MESSAGE(

Line 3511: okc_debug.Set_Indentation('Update Coverage Effectivity');

3507:
3508: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
3509:
3510: IF (G_DEBUG_ENABLED = 'Y') THEN
3511: okc_debug.Set_Indentation('Update Coverage Effectivity');
3512: okc_debug.log('Entered Update Coverage Effectivity', 2);
3513: END IF;
3514:
3515: OPEN dnz_Cur;

Line 3512: okc_debug.log('Entered Update Coverage Effectivity', 2);

3508: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
3509:
3510: IF (G_DEBUG_ENABLED = 'Y') THEN
3511: okc_debug.Set_Indentation('Update Coverage Effectivity');
3512: okc_debug.log('Entered Update Coverage Effectivity', 2);
3513: END IF;
3514:
3515: OPEN dnz_Cur;
3516: FETCH dnz_Cur INTO g_chr_Id;

Line 3646: okc_debug.log('Before okc_contract_pub.Update_Contract_Line', 2);

3642:
3643: -- Update Line with all the data for Coverage, Business process, React Times, Bill Types, Bill Rate
3644:
3645: IF (G_DEBUG_ENABLED = 'Y') THEN
3646: okc_debug.log('Before okc_contract_pub.Update_Contract_Line', 2);
3647: END IF;
3648: IF l_clev_tbl_in.COUNT > 0 Then
3649:
3650: okc_contract_pub.Update_Contract_Line(

Line 3662: okc_debug.log('After okc_contract_pub.Update_Contract_Line'||l_return_status, 2);

3658: x_clev_tbl => l_clev_tbl_out);
3659:
3660:
3661: IF (G_DEBUG_ENABLED = 'Y') THEN
3662: okc_debug.log('After okc_contract_pub.Update_Contract_Line'||l_return_status, 2);
3663: END IF;
3664:
3665: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3666:

Line 3687: okc_debug.log('End of Update_Coverage_Effectivity'||l_return_status, 2);

3683: x_return_status := l_return_status;
3684:
3685:
3686: IF (G_DEBUG_ENABLED = 'Y') THEN
3687: okc_debug.log('End of Update_Coverage_Effectivity'||l_return_status, 2);
3688: okc_debug.Reset_Indentation;
3689: END IF;
3690:
3691:

Line 3688: okc_debug.Reset_Indentation;

3684:
3685:
3686: IF (G_DEBUG_ENABLED = 'Y') THEN
3687: okc_debug.log('End of Update_Coverage_Effectivity'||l_return_status, 2);
3688: okc_debug.Reset_Indentation;
3689: END IF;
3690:
3691:
3692: EXCEPTION

Line 3696: okc_debug.log('Exp of Update_Coverage_Effectivity'||SQLERRM, 2);

3692: EXCEPTION
3693: WHEN NO_COV_ERROR THEN
3694:
3695: IF (G_DEBUG_ENABLED = 'Y') THEN
3696: okc_debug.log('Exp of Update_Coverage_Effectivity'||SQLERRM, 2);
3697: okc_debug.Reset_Indentation;
3698: END IF;
3699:
3700:

Line 3697: okc_debug.Reset_Indentation;

3693: WHEN NO_COV_ERROR THEN
3694:
3695: IF (G_DEBUG_ENABLED = 'Y') THEN
3696: okc_debug.log('Exp of Update_Coverage_Effectivity'||SQLERRM, 2);
3697: okc_debug.Reset_Indentation;
3698: END IF;
3699:
3700:
3701: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

Line 3709: okc_debug.log('Exp of Update_Coverage_Effectivity e_Error'||SQLERRM, 2);

3705:
3706: WHEN e_Error THEN
3707:
3708: IF (G_DEBUG_ENABLED = 'Y') THEN
3709: okc_debug.log('Exp of Update_Coverage_Effectivity e_Error'||SQLERRM, 2);
3710: okc_debug.Reset_Indentation;
3711: END IF;
3712:
3713: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

Line 3710: okc_debug.Reset_Indentation;

3706: WHEN e_Error THEN
3707:
3708: IF (G_DEBUG_ENABLED = 'Y') THEN
3709: okc_debug.log('Exp of Update_Coverage_Effectivity e_Error'||SQLERRM, 2);
3710: okc_debug.Reset_Indentation;
3711: END IF;
3712:
3713: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3714: --ROLLBACK ;

Line 3722: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);

3718:
3719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3720:
3721: IF (G_DEBUG_ENABLED = 'Y') THEN
3722: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3723: okc_debug.Reset_Indentation;
3724: END IF;
3725: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3726: --ROLLBACK ;

Line 3723: okc_debug.Reset_Indentation;

3719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3720:
3721: IF (G_DEBUG_ENABLED = 'Y') THEN
3722: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3723: okc_debug.Reset_Indentation;
3724: END IF;
3725: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3726: --ROLLBACK ;
3727: x_msg_count :=l_msg_count;

Line 3735: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);

3731:
3732: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3733:
3734: IF (G_DEBUG_ENABLED = 'Y') THEN
3735: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3736: okc_debug.Reset_Indentation;
3737: END IF;
3738: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3739: --ROLLBACK ;

Line 3736: okc_debug.Reset_Indentation;

3732: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3733:
3734: IF (G_DEBUG_ENABLED = 'Y') THEN
3735: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3736: okc_debug.Reset_Indentation;
3737: END IF;
3738: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3739: --ROLLBACK ;
3740: x_msg_count :=l_msg_count;

Line 3747: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);

3743:
3744: WHEN OTHERS THEN
3745:
3746: IF (G_DEBUG_ENABLED = 'Y') THEN
3747: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3748: okc_debug.Reset_Indentation;
3749: END IF;
3750:
3751: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );

Line 3748: okc_debug.Reset_Indentation;

3744: WHEN OTHERS THEN
3745:
3746: IF (G_DEBUG_ENABLED = 'Y') THEN
3747: okc_debug.log('Exp of Update_Coverage_Effectivity '||SQLERRM, 2);
3748: okc_debug.Reset_Indentation;
3749: END IF;
3750:
3751: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name );
3752: --ROLLBACK ;

Line 5498: okc_debug.Set_Indentation('Create_Adjusted_Coverage');

5494: BEGIN
5495:
5496:
5497: IF (G_DEBUG_ENABLED = 'Y') THEN
5498: okc_debug.Set_Indentation('Create_Adjusted_Coverage');
5499: okc_debug.log('Entered Create_Adjusted_Coverage', 2);
5500: END IF;
5501:
5502: l_ac_rec_in.svc_cle_id := l_Target_contract_Line_Id;

Line 5499: okc_debug.log('Entered Create_Adjusted_Coverage', 2);

5495:
5496:
5497: IF (G_DEBUG_ENABLED = 'Y') THEN
5498: okc_debug.Set_Indentation('Create_Adjusted_Coverage');
5499: okc_debug.log('Entered Create_Adjusted_Coverage', 2);
5500: END IF;
5501:
5502: l_ac_rec_in.svc_cle_id := l_Target_contract_Line_Id;
5503:

Line 5533: okc_debug.log('Before create_actual_coverage', 2);

5529: END IF;
5530: CLOSE Cur_LineDet1;
5531:
5532: IF (G_DEBUG_ENABLED = 'Y') THEN
5533: okc_debug.log('Before create_actual_coverage', 2);
5534: END IF;
5535:
5536: OKS_COVERAGES_PVT.CREATE_ACTUAL_COVERAGE(
5537: p_api_version => l_api_version,

Line 5547: okc_debug.log('After create_actual_coverage '||l_return_status, 2);

5543: p_restricted_update => 'T', -- 'F', modified based on bug 5493713
5544: x_Actual_coverage_id => l_Actual_coverage_id);
5545:
5546: IF (G_DEBUG_ENABLED = 'Y') THEN
5547: okc_debug.log('After create_actual_coverage '||l_return_status, 2);
5548: END IF;
5549:
5550: /* IF nvl(l_return_status,'*') <> 'S'
5551: THEN

Line 5573: okc_debug.log('End of CREATE_ADJUSTED_COVERAGE'||l_return_status, 2);

5569:
5570:
5571:
5572: IF (G_DEBUG_ENABLED = 'Y') THEN
5573: okc_debug.log('End of CREATE_ADJUSTED_COVERAGE'||l_return_status, 2);
5574: okc_debug.Reset_Indentation;
5575: END IF;
5576:
5577: EXCEPTION

Line 5574: okc_debug.Reset_Indentation;

5570:
5571:
5572: IF (G_DEBUG_ENABLED = 'Y') THEN
5573: okc_debug.log('End of CREATE_ADJUSTED_COVERAGE'||l_return_status, 2);
5574: okc_debug.Reset_Indentation;
5575: END IF;
5576:
5577: EXCEPTION
5578: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 5581: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);

5577: EXCEPTION
5578: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5579:
5580: IF (G_DEBUG_ENABLED = 'Y') THEN
5581: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);
5582: okc_debug.Reset_Indentation;
5583: END IF;
5584: x_return_status := l_return_status ;
5585: /* x_msg_count :=l_msg_count;

Line 5582: okc_debug.Reset_Indentation;

5578: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5579:
5580: IF (G_DEBUG_ENABLED = 'Y') THEN
5581: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);
5582: okc_debug.Reset_Indentation;
5583: END IF;
5584: x_return_status := l_return_status ;
5585: /* x_msg_count :=l_msg_count;
5586: x_msg_data:=l_msg_data;

Line 5625: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);

5621:
5622: WHEN OTHERS THEN
5623:
5624: IF (G_DEBUG_ENABLED = 'Y') THEN
5625: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);
5626: okc_debug.Reset_Indentation;
5627: END IF;
5628:
5629: OKC_API.SET_MESSAGE(

Line 5626: okc_debug.Reset_Indentation;

5622: WHEN OTHERS THEN
5623:
5624: IF (G_DEBUG_ENABLED = 'Y') THEN
5625: okc_debug.log('Exp of CREATE_ADJUSTED_COVERAGE'||SQLERRM, 2);
5626: okc_debug.Reset_Indentation;
5627: END IF;
5628:
5629: OKC_API.SET_MESSAGE(
5630: p_app_name => g_app_name,

Line 7475: okc_debug.Set_Indentation('Create_Actual_Coverage');

7471:
7472: BEGIN
7473:
7474: IF (G_DEBUG_ENABLED = 'Y') THEN
7475: okc_debug.Set_Indentation('Create_Actual_Coverage');
7476: okc_debug.log('Entered Copy_Coverage', 2);
7477: END IF;
7478:
7479:

Line 7476: okc_debug.log('Entered Copy_Coverage', 2);

7472: BEGIN
7473:
7474: IF (G_DEBUG_ENABLED = 'Y') THEN
7475: okc_debug.Set_Indentation('Create_Actual_Coverage');
7476: okc_debug.log('Entered Copy_Coverage', 2);
7477: END IF;
7478:
7479:
7480: l_new_contract_line_id:= p_contract_line_id ;

Line 7548: okc_debug.log('AFTER CHECK_OKSLINE_EXIST1'||l_return_status, 2);

7544: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7545: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_new_cov_line_id,
7546: x_oks_exist =>l_oks_exist);
7547: IF (G_DEBUG_ENABLED = 'Y') THEN
7548: okc_debug.log('AFTER CHECK_OKSLINE_EXIST1'||l_return_status, 2);
7549: END IF;
7550:
7551: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7552: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7586: okc_debug.log('After OKS_CONTRACT_LINE_PUB.CREATE_LINE'||l_return_status, 2);

7582: p_validate_yn => l_validate_yn);
7583:
7584:
7585: IF (G_DEBUG_ENABLED = 'Y') THEN
7586: okc_debug.log('After OKS_CONTRACT_LINE_PUB.CREATE_LINE'||l_return_status, 2);
7587: END IF;
7588:
7589:
7590: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 7607: okc_debug.log('AFTER CALLING OKS_PM_PROGRAMS_PVT.Copy_pm_template'||l_return_status, 2);

7603: x_msg_data => x_msg_data,
7604: p_old_coverage_id => l_old_cov_line_id,
7605: p_new_coverage_id => l_new_cov_line_id);
7606: IF (G_DEBUG_ENABLED = 'Y') THEN
7607: okc_debug.log('AFTER CALLING OKS_PM_PROGRAMS_PVT.Copy_pm_template'||l_return_status, 2);
7608: END IF;
7609:
7610: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7611: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7642: okc_debug.log('AFTER CHECK_OKSLINE_EXIST2'||l_return_status, 2);

7638: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7639: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_new_Bp_line_Id,
7640: x_oks_exist =>l_oks_exist);
7641: IF (G_DEBUG_ENABLED = 'Y') THEN
7642: okc_debug.log('AFTER CHECK_OKSLINE_EXIST2'||l_return_status, 2);
7643: END IF;
7644:
7645: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7646: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7726: okc_debug.log('After OKS_CTZ_PVT INSERT_ROW'||l_return_status, 2);

7722: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);
7723:
7724:
7725: IF (G_DEBUG_ENABLED = 'Y') THEN
7726: okc_debug.log('After OKS_CTZ_PVT INSERT_ROW'||l_return_status, 2);
7727: END IF;
7728:
7729: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7730: IF l_timezone_tbl_out.COUNT > 0 THEN

Line 7810: okc_debug.log('AFTER CHECK_OKSLINE_EXIST3'||l_return_status, 2);

7806: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(l).CLE_ID,
7807: x_oks_exist =>l_oks_exist);
7808:
7809: IF (G_DEBUG_ENABLED = 'Y') THEN
7810: okc_debug.log('AFTER CHECK_OKSLINE_EXIST3'||l_return_status, 2);
7811: END IF;
7812:
7813: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7814: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);

7883: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,
7884: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);
7885:
7886: IF (G_DEBUG_ENABLED = 'Y') THEN
7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);
7888: END IF;
7889:
7890: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7891: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7929: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);

7925: p_oks_action_times_v_tbl => l_acm_pvt_tbl_in,
7926: x_oks_action_times_v_tbl => l_acm_pvt_tbl_out);
7927:
7928: IF (G_DEBUG_ENABLED = 'Y') THEN
7929: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
7930: END IF;
7931:
7932: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7933: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 7980: okc_debug.log('AFTER CHECK_OKSLINE_EXIST4'||l_return_status, 2);

7976: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7977: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(i).cle_id,
7978: x_oks_exist =>l_oks_exist);
7979: IF (G_DEBUG_ENABLED = 'Y') THEN
7980: okc_debug.log('AFTER CHECK_OKSLINE_EXIST4'||l_return_status, 2);
7981: END IF;
7982:
7983: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7984: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 8101: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);

8097: x_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_out);
8098:
8099:
8100: IF (G_DEBUG_ENABLED = 'Y') THEN
8101: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);
8102: END IF;
8103:
8104: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8105: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 8133: okc_debug.log('AFTER COPY_NOTES'||l_return_status, 2);

8129: x_return_status => l_return_status,
8130: x_msg_count => l_msg_count,
8131: x_msg_data => l_msg_data);
8132: IF (G_DEBUG_ENABLED = 'Y') THEN
8133: okc_debug.log('AFTER COPY_NOTES'||l_return_status, 2);
8134: END IF;
8135:
8136:
8137: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 8160: okc_debug.log('After RENEW_PM_PROGRAM_SCHEDULE'||l_return_status, 2);

8156: p_contract_line_id => l_new_contract_line_id);
8157:
8158:
8159: IF (G_DEBUG_ENABLED = 'Y') THEN
8160: okc_debug.log('After RENEW_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
8161: END IF;
8162:
8163:
8164: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 8179: okc_debug.log('End of Copy_Coverage'||l_return_status, 2);

8175: l_cover_time_tbl_in.DELETE;
8176:
8177:
8178: IF (G_DEBUG_ENABLED = 'Y') THEN
8179: okc_debug.log('End of Copy_Coverage'||l_return_status, 2);
8180: okc_debug.Reset_Indentation;
8181: END IF;
8182:
8183: EXCEPTION

Line 8180: okc_debug.Reset_Indentation;

8176:
8177:
8178: IF (G_DEBUG_ENABLED = 'Y') THEN
8179: okc_debug.log('End of Copy_Coverage'||l_return_status, 2);
8180: okc_debug.Reset_Indentation;
8181: END IF;
8182:
8183: EXCEPTION
8184:

Line 8188: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);

8184:
8185: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8186:
8187: IF (G_DEBUG_ENABLED = 'Y') THEN
8188: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8189: okc_debug.Reset_Indentation;
8190: END IF;
8191: x_return_status := l_return_status ;
8192: x_msg_count :=l_msg_count;

Line 8189: okc_debug.Reset_Indentation;

8185: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8186:
8187: IF (G_DEBUG_ENABLED = 'Y') THEN
8188: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8189: okc_debug.Reset_Indentation;
8190: END IF;
8191: x_return_status := l_return_status ;
8192: x_msg_count :=l_msg_count;
8193: x_msg_data:=l_msg_data;

Line 8205: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);

8201: '_PVT'
8202: );
8203: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8204: IF (G_DEBUG_ENABLED = 'Y') THEN
8205: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8206: okc_debug.Reset_Indentation;
8207: END IF;
8208: x_msg_count :=l_msg_count;
8209: x_msg_data:=l_msg_data;

Line 8206: okc_debug.Reset_Indentation;

8202: );
8203: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8204: IF (G_DEBUG_ENABLED = 'Y') THEN
8205: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8206: okc_debug.Reset_Indentation;
8207: END IF;
8208: x_msg_count :=l_msg_count;
8209: x_msg_data:=l_msg_data;
8210: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 8222: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);

8218: );
8219: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8220:
8221: IF (G_DEBUG_ENABLED = 'Y') THEN
8222: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8223: okc_debug.Reset_Indentation;
8224: END IF;
8225: x_msg_count :=l_msg_count;
8226: x_msg_data:=l_msg_data;

Line 8223: okc_debug.Reset_Indentation;

8219: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8220:
8221: IF (G_DEBUG_ENABLED = 'Y') THEN
8222: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8223: okc_debug.Reset_Indentation;
8224: END IF;
8225: x_msg_count :=l_msg_count;
8226: x_msg_data:=l_msg_data;
8227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 8240: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);

8236:
8237: WHEN OTHERS THEN
8238:
8239: IF (G_DEBUG_ENABLED = 'Y') THEN
8240: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8241: okc_debug.Reset_Indentation;
8242: END IF;
8243: OKC_API.SET_MESSAGE(
8244: p_app_name => g_app_name,

Line 8241: okc_debug.Reset_Indentation;

8237: WHEN OTHERS THEN
8238:
8239: IF (G_DEBUG_ENABLED = 'Y') THEN
8240: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8241: okc_debug.Reset_Indentation;
8242: END IF;
8243: OKC_API.SET_MESSAGE(
8244: p_app_name => g_app_name,
8245: p_msg_name => g_unexpected_error,

Line 10187: okc_debug.Set_Indentation('Create_K_Coverage_Ext');

10183:
10184: BEGIN
10185: l_return_status := 'S';
10186: IF (G_DEBUG_ENABLED = 'Y') THEN
10187: okc_debug.Set_Indentation('Create_K_Coverage_Ext');
10188: okc_debug.log('BEGIN CREATE_K_COVERAGE_EXT'||l_return_status, 2);
10189: END IF;
10190:
10191: SAVEPOINT Create_K_coverage_ext_PVT;

Line 10188: okc_debug.log('BEGIN CREATE_K_COVERAGE_EXT'||l_return_status, 2);

10184: BEGIN
10185: l_return_status := 'S';
10186: IF (G_DEBUG_ENABLED = 'Y') THEN
10187: okc_debug.Set_Indentation('Create_K_Coverage_Ext');
10188: okc_debug.log('BEGIN CREATE_K_COVERAGE_EXT'||l_return_status, 2);
10189: END IF;
10190:
10191: SAVEPOINT Create_K_coverage_ext_PVT;
10192:

Line 10220: okc_debug.log('BEFORE CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);

10216: end LOOP;
10217: -- create notes for actual coverage from the template
10218: -- pass coverage_template_id as (p_source_object_id IN parameter )in the cursor below
10219: IF (G_DEBUG_ENABLED = 'Y') THEN
10220: okc_debug.log('BEFORE CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10221: END IF;
10222:
10223: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10224: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP

Line 10268: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);

10264: p_context => notes_rec.CONTEXT,
10265: p_note_type => notes_rec.NOTE_TYPE);
10266:
10267: IF (G_DEBUG_ENABLED = 'Y') THEN
10268: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10269: END IF;
10270:
10271:
10272: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 10303: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);

10299: p_cov_end_date => l_end_date);
10300: --errorout_ad('after'||l_return_status);
10301:
10302: IF (G_DEBUG_ENABLED = 'Y') THEN
10303: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
10304: END IF;
10305:
10306:
10307: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 10316: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);

10312: EXCEPTION
10313:
10314: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10315: IF (G_DEBUG_ENABLED = 'Y') THEN
10316: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10317: okc_debug.Reset_Indentation;
10318: END IF;
10319: x_return_status := l_return_status ;
10320: x_msg_count :=l_msg_count;

Line 10317: okc_debug.Reset_Indentation;

10313:
10314: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10315: IF (G_DEBUG_ENABLED = 'Y') THEN
10316: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10317: okc_debug.Reset_Indentation;
10318: END IF;
10319: x_return_status := l_return_status ;
10320: x_msg_count :=l_msg_count;
10321: x_msg_data:=l_msg_data;

Line 10333: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);

10329: '_PVT'
10330: );
10331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
10332: IF (G_DEBUG_ENABLED = 'Y') THEN
10333: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10334: okc_debug.Reset_Indentation;
10335: END IF;
10336: x_msg_count :=l_msg_count;
10337: x_msg_data:=l_msg_data;

Line 10334: okc_debug.Reset_Indentation;

10330: );
10331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
10332: IF (G_DEBUG_ENABLED = 'Y') THEN
10333: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10334: okc_debug.Reset_Indentation;
10335: END IF;
10336: x_msg_count :=l_msg_count;
10337: x_msg_data:=l_msg_data;
10338: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 10350: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);

10346: );
10347: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10348:
10349: IF (G_DEBUG_ENABLED = 'Y') THEN
10350: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10351: okc_debug.Reset_Indentation;
10352: END IF;
10353: x_msg_count :=l_msg_count;
10354: x_msg_data:=l_msg_data;

Line 10351: okc_debug.Reset_Indentation;

10347: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10348:
10349: IF (G_DEBUG_ENABLED = 'Y') THEN
10350: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10351: okc_debug.Reset_Indentation;
10352: END IF;
10353: x_msg_count :=l_msg_count;
10354: x_msg_data:=l_msg_data;
10355: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 10367: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);

10363: );
10364: WHEN OTHERS THEN
10365:
10366: IF (G_DEBUG_ENABLED = 'Y') THEN
10367: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10368: okc_debug.Reset_Indentation;
10369: END IF;
10370: OKC_API.SET_MESSAGE(
10371: p_app_name => g_app_name,

Line 10368: okc_debug.Reset_Indentation;

10364: WHEN OTHERS THEN
10365:
10366: IF (G_DEBUG_ENABLED = 'Y') THEN
10367: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10368: okc_debug.Reset_Indentation;
10369: END IF;
10370: OKC_API.SET_MESSAGE(
10371: p_app_name => g_app_name,
10372: p_msg_name => g_unexpected_error,

Line 11074: okc_debug.Set_Indentation('Copy_Standard_Coverage');

11070: SAVEPOINT copy_standard_coverage;
11071: l_old_coverage_id := P_old_coverage_id;
11072:
11073: IF (G_DEBUG_ENABLED = 'Y') THEN
11074: okc_debug.Set_Indentation('Copy_Standard_Coverage');
11075: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);
11076: END IF;
11077:
11078: -- Create Coverage line

Line 11075: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);

11071: l_old_coverage_id := P_old_coverage_id;
11072:
11073: IF (G_DEBUG_ENABLED = 'Y') THEN
11074: okc_debug.Set_Indentation('Copy_Standard_Coverage');
11075: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);
11076: END IF;
11077:
11078: -- Create Coverage line
11079: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());

Line 11083: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);

11079: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());
11080: l_cov_flag :=1;
11081: l_return_status := CREATE_OKC_LINE(l_new_coverage_id,l_old_coverage_id,l_cov_flag);
11082: IF (G_DEBUG_ENABLED = 'Y') THEN
11083: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);
11084: END IF;
11085:
11086: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11087: THEN

Line 11099: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);

11095: l_new_bp_id := okc_p_util.raw_to_number(sys_guid());
11096: l_cov_flag := 2;
11097: l_return_status := CREATE_OKC_LINE(l_new_bp_id,l_old_bp_id,l_cov_flag,l_new_coverage_id);
11098: IF (G_DEBUG_ENABLED = 'Y') THEN
11099: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);
11100: END IF;
11101:
11102: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11103: THEN

Line 11114: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);

11110: close CUR_ItemDet;
11111: l_new_bp_item_id :=okc_p_util.raw_to_number(sys_guid());
11112: l_return_status := CREATE_OKC_ITEM(l_new_bp_item_id,l_old_bp_item_id,l_new_bp_id);
11113: IF (G_DEBUG_ENABLED = 'Y') THEN
11114: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);
11115: END IF;
11116:
11117: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11118: THEN

Line 11131: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);

11127: l_new_rt_id := okc_p_util.raw_to_number(sys_guid());
11128: l_cov_flag := 3;
11129: l_return_status := CREATE_OKC_LINE(l_new_rt_id,l_old_rt_id,l_cov_flag,l_new_bp_id);
11130: IF (G_DEBUG_ENABLED = 'Y') THEN
11131: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);
11132: END IF;
11133:
11134: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11135: THEN

Line 11147: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);

11143: close CUR_ItemDet;
11144: l_new_rt_item_id :=okc_p_util.raw_to_number(sys_guid());
11145: l_return_status := CREATE_OKC_ITEM(l_new_rt_item_id,l_old_rt_item_id,l_new_rt_id);
11146: IF (G_DEBUG_ENABLED = 'Y') THEN
11147: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);
11148: END IF;
11149:
11150: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11151: THEN

Line 11164: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);

11160: l_new_br_id := okc_p_util.raw_to_number(sys_guid());
11161: l_cov_flag := 4;
11162: l_return_status := CREATE_OKC_LINE(l_new_br_id,l_old_br_id,l_cov_flag,l_new_rt_id);
11163: IF (G_DEBUG_ENABLED = 'Y') THEN
11164: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);
11165: END IF;
11166:
11167: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11168: THEN

Line 11186: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);

11182: l_old_party_id := cr_ptrl_det.id;
11183: l_new_party_id :=okc_p_util.raw_to_number(sys_guid());
11184: l_return_status := CREATE_OKC_PARTY(l_new_party_id,l_old_party_id,l_new_bp_id);
11185: IF (G_DEBUG_ENABLED = 'Y') THEN
11186: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);
11187: END IF;
11188:
11189: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11190: THEN

Line 11196: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);

11192: END IF;
11193: -- okc_contacts
11194: l_return_status := CREATE_OKC_CONTACT(l_new_party_id,l_old_party_id);
11195: IF (G_DEBUG_ENABLED = 'Y') THEN
11196: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);
11197: END IF;
11198:
11199: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11200: THEN

Line 11220: okc_debug.log('AFTER Copy_Coverage'||l_return_status, 2);

11216: x_msg_data => x_msg_data,
11217: p_contract_line_id => l_new_coverage_id);
11218:
11219: IF (G_DEBUG_ENABLED = 'Y') THEN
11220: okc_debug.log('AFTER Copy_Coverage'||l_return_status, 2);
11221: END IF;
11222:
11223:
11224: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN