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 7883: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);

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

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

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

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

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

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

8087: x_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_out);
8088:
8089:
8090: IF (G_DEBUG_ENABLED = 'Y') THEN
8091: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);
8092: END IF;
8093:
8094: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8095: RAISE G_EXCEPTION_HALT_VALIDATION;

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

8119: x_return_status => l_return_status,
8120: x_msg_count => l_msg_count,
8121: x_msg_data => l_msg_data);
8122: IF (G_DEBUG_ENABLED = 'Y') THEN
8123: okc_debug.log('AFTER COPY_NOTES'||l_return_status, 2);
8124: END IF;
8125:
8126:
8127: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

8146: p_contract_line_id => l_new_contract_line_id);
8147:
8148:
8149: IF (G_DEBUG_ENABLED = 'Y') THEN
8150: okc_debug.log('After RENEW_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
8151: END IF;
8152:
8153:
8154: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

8165: l_cover_time_tbl_in.DELETE;
8166:
8167:
8168: IF (G_DEBUG_ENABLED = 'Y') THEN
8169: okc_debug.log('End of Copy_Coverage'||l_return_status, 2);
8170: okc_debug.Reset_Indentation;
8171: END IF;
8172:
8173: EXCEPTION

Line 8170: okc_debug.Reset_Indentation;

8166:
8167:
8168: IF (G_DEBUG_ENABLED = 'Y') THEN
8169: okc_debug.log('End of Copy_Coverage'||l_return_status, 2);
8170: okc_debug.Reset_Indentation;
8171: END IF;
8172:
8173: EXCEPTION
8174:

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

8174:
8175: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8176:
8177: IF (G_DEBUG_ENABLED = 'Y') THEN
8178: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8179: okc_debug.Reset_Indentation;
8180: END IF;
8181: x_return_status := l_return_status ;
8182: x_msg_count :=l_msg_count;

Line 8179: okc_debug.Reset_Indentation;

8175: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8176:
8177: IF (G_DEBUG_ENABLED = 'Y') THEN
8178: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8179: okc_debug.Reset_Indentation;
8180: END IF;
8181: x_return_status := l_return_status ;
8182: x_msg_count :=l_msg_count;
8183: x_msg_data:=l_msg_data;

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

8191: '_PVT'
8192: );
8193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8194: IF (G_DEBUG_ENABLED = 'Y') THEN
8195: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8196: okc_debug.Reset_Indentation;
8197: END IF;
8198: x_msg_count :=l_msg_count;
8199: x_msg_data:=l_msg_data;

Line 8196: okc_debug.Reset_Indentation;

8192: );
8193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8194: IF (G_DEBUG_ENABLED = 'Y') THEN
8195: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8196: okc_debug.Reset_Indentation;
8197: END IF;
8198: x_msg_count :=l_msg_count;
8199: x_msg_data:=l_msg_data;
8200: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

8208: );
8209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8210:
8211: IF (G_DEBUG_ENABLED = 'Y') THEN
8212: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8213: okc_debug.Reset_Indentation;
8214: END IF;
8215: x_msg_count :=l_msg_count;
8216: x_msg_data:=l_msg_data;

Line 8213: okc_debug.Reset_Indentation;

8209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8210:
8211: IF (G_DEBUG_ENABLED = 'Y') THEN
8212: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8213: okc_debug.Reset_Indentation;
8214: END IF;
8215: x_msg_count :=l_msg_count;
8216: x_msg_data:=l_msg_data;
8217: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

8226:
8227: WHEN OTHERS THEN
8228:
8229: IF (G_DEBUG_ENABLED = 'Y') THEN
8230: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8231: okc_debug.Reset_Indentation;
8232: END IF;
8233: OKC_API.SET_MESSAGE(
8234: p_app_name => g_app_name,

Line 8231: okc_debug.Reset_Indentation;

8227: WHEN OTHERS THEN
8228:
8229: IF (G_DEBUG_ENABLED = 'Y') THEN
8230: okc_debug.log('Exp of Copy_Coverage'||SQLERRM, 2);
8231: okc_debug.Reset_Indentation;
8232: END IF;
8233: OKC_API.SET_MESSAGE(
8234: p_app_name => g_app_name,
8235: p_msg_name => g_unexpected_error,

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

10173:
10174: BEGIN
10175: l_return_status := 'S';
10176: IF (G_DEBUG_ENABLED = 'Y') THEN
10177: okc_debug.Set_Indentation('Create_K_Coverage_Ext');
10178: okc_debug.log('BEGIN CREATE_K_COVERAGE_EXT'||l_return_status, 2);
10179: END IF;
10180:
10181: SAVEPOINT Create_K_coverage_ext_PVT;

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

10174: BEGIN
10175: l_return_status := 'S';
10176: IF (G_DEBUG_ENABLED = 'Y') THEN
10177: okc_debug.Set_Indentation('Create_K_Coverage_Ext');
10178: okc_debug.log('BEGIN CREATE_K_COVERAGE_EXT'||l_return_status, 2);
10179: END IF;
10180:
10181: SAVEPOINT Create_K_coverage_ext_PVT;
10182:

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

10206: end LOOP;
10207: -- create notes for actual coverage from the template
10208: -- pass coverage_template_id as (p_source_object_id IN parameter )in the cursor below
10209: IF (G_DEBUG_ENABLED = 'Y') THEN
10210: okc_debug.log('BEFORE CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10211: END IF;
10212:
10213: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10214: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP

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

10254: p_context => notes_rec.CONTEXT,
10255: p_note_type => notes_rec.NOTE_TYPE);
10256:
10257: IF (G_DEBUG_ENABLED = 'Y') THEN
10258: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10259: END IF;
10260:
10261:
10262: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

10289: p_cov_end_date => l_end_date);
10290: --errorout_ad('after'||l_return_status);
10291:
10292: IF (G_DEBUG_ENABLED = 'Y') THEN
10293: okc_debug.log('After OKS_PM_PROGRAMS_PVT. CREATE_PM_PROGRAM_SCHEDULE'||l_return_status, 2);
10294: END IF;
10295:
10296:
10297: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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

10302: EXCEPTION
10303:
10304: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10305: IF (G_DEBUG_ENABLED = 'Y') THEN
10306: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10307: okc_debug.Reset_Indentation;
10308: END IF;
10309: x_return_status := l_return_status ;
10310: x_msg_count :=l_msg_count;

Line 10307: okc_debug.Reset_Indentation;

10303:
10304: WHEN G_EXCEPTION_HALT_VALIDATION THEN
10305: IF (G_DEBUG_ENABLED = 'Y') THEN
10306: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10307: okc_debug.Reset_Indentation;
10308: END IF;
10309: x_return_status := l_return_status ;
10310: x_msg_count :=l_msg_count;
10311: x_msg_data:=l_msg_data;

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

10319: '_PVT'
10320: );
10321: WHEN OKC_API.G_EXCEPTION_ERROR THEN
10322: IF (G_DEBUG_ENABLED = 'Y') THEN
10323: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10324: okc_debug.Reset_Indentation;
10325: END IF;
10326: x_msg_count :=l_msg_count;
10327: x_msg_data:=l_msg_data;

Line 10324: okc_debug.Reset_Indentation;

10320: );
10321: WHEN OKC_API.G_EXCEPTION_ERROR THEN
10322: IF (G_DEBUG_ENABLED = 'Y') THEN
10323: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10324: okc_debug.Reset_Indentation;
10325: END IF;
10326: x_msg_count :=l_msg_count;
10327: x_msg_data:=l_msg_data;
10328: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

10336: );
10337: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10338:
10339: IF (G_DEBUG_ENABLED = 'Y') THEN
10340: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10341: okc_debug.Reset_Indentation;
10342: END IF;
10343: x_msg_count :=l_msg_count;
10344: x_msg_data:=l_msg_data;

Line 10341: okc_debug.Reset_Indentation;

10337: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10338:
10339: IF (G_DEBUG_ENABLED = 'Y') THEN
10340: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10341: okc_debug.Reset_Indentation;
10342: END IF;
10343: x_msg_count :=l_msg_count;
10344: x_msg_data:=l_msg_data;
10345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

10353: );
10354: WHEN OTHERS THEN
10355:
10356: IF (G_DEBUG_ENABLED = 'Y') THEN
10357: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10358: okc_debug.Reset_Indentation;
10359: END IF;
10360: OKC_API.SET_MESSAGE(
10361: p_app_name => g_app_name,

Line 10358: okc_debug.Reset_Indentation;

10354: WHEN OTHERS THEN
10355:
10356: IF (G_DEBUG_ENABLED = 'Y') THEN
10357: okc_debug.log('Create_K_coverage_ext'||SQLERRM, 2);
10358: okc_debug.Reset_Indentation;
10359: END IF;
10360: OKC_API.SET_MESSAGE(
10361: p_app_name => g_app_name,
10362: p_msg_name => g_unexpected_error,

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

11056: SAVEPOINT copy_standard_coverage;
11057: l_old_coverage_id := P_old_coverage_id;
11058:
11059: IF (G_DEBUG_ENABLED = 'Y') THEN
11060: okc_debug.Set_Indentation('Copy_Standard_Coverage');
11061: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);
11062: END IF;
11063:
11064: -- Create Coverage line

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

11057: l_old_coverage_id := P_old_coverage_id;
11058:
11059: IF (G_DEBUG_ENABLED = 'Y') THEN
11060: okc_debug.Set_Indentation('Copy_Standard_Coverage');
11061: okc_debug.log('BEGIN COPY_STANDARD_COVERAGE'||l_return_status, 2);
11062: END IF;
11063:
11064: -- Create Coverage line
11065: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());

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

11065: l_new_coverage_id :=okc_p_util.raw_to_number(sys_guid());
11066: l_cov_flag :=1;
11067: l_return_status := CREATE_OKC_LINE(l_new_coverage_id,l_old_coverage_id,l_cov_flag);
11068: IF (G_DEBUG_ENABLED = 'Y') THEN
11069: okc_debug.log('AFTER CREATE_OKC_LINE FOR COVERAGE'||l_return_status, 2);
11070: END IF;
11071:
11072: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11073: THEN

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

11081: l_new_bp_id := okc_p_util.raw_to_number(sys_guid());
11082: l_cov_flag := 2;
11083: l_return_status := CREATE_OKC_LINE(l_new_bp_id,l_old_bp_id,l_cov_flag,l_new_coverage_id);
11084: IF (G_DEBUG_ENABLED = 'Y') THEN
11085: okc_debug.log('AFTER CREATE_OKC_LINE FOR BP'||l_return_status, 2);
11086: END IF;
11087:
11088: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11089: THEN

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

11096: close CUR_ItemDet;
11097: l_new_bp_item_id :=okc_p_util.raw_to_number(sys_guid());
11098: l_return_status := CREATE_OKC_ITEM(l_new_bp_item_id,l_old_bp_item_id,l_new_bp_id);
11099: IF (G_DEBUG_ENABLED = 'Y') THEN
11100: okc_debug.log('AFTER CREATE_OKC_ITEM'||l_return_status, 2);
11101: END IF;
11102:
11103: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11104: THEN

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

11113: l_new_rt_id := okc_p_util.raw_to_number(sys_guid());
11114: l_cov_flag := 3;
11115: l_return_status := CREATE_OKC_LINE(l_new_rt_id,l_old_rt_id,l_cov_flag,l_new_bp_id);
11116: IF (G_DEBUG_ENABLED = 'Y') THEN
11117: okc_debug.log('AFTER CREATE_OKC_LINE FOR RT'||l_return_status, 2);
11118: END IF;
11119:
11120: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11121: THEN

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

11129: close CUR_ItemDet;
11130: l_new_rt_item_id :=okc_p_util.raw_to_number(sys_guid());
11131: l_return_status := CREATE_OKC_ITEM(l_new_rt_item_id,l_old_rt_item_id,l_new_rt_id);
11132: IF (G_DEBUG_ENABLED = 'Y') THEN
11133: okc_debug.log('AFTER CREATE_OKC_ITEM FOR RT'||l_return_status, 2);
11134: END IF;
11135:
11136: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11137: THEN

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

11146: l_new_br_id := okc_p_util.raw_to_number(sys_guid());
11147: l_cov_flag := 4;
11148: l_return_status := CREATE_OKC_LINE(l_new_br_id,l_old_br_id,l_cov_flag,l_new_rt_id);
11149: IF (G_DEBUG_ENABLED = 'Y') THEN
11150: okc_debug.log('AFTER CREATE_OKC_LINE FOR BR'||l_return_status, 2);
11151: END IF;
11152:
11153: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11154: THEN

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

11168: l_old_party_id := cr_ptrl_det.id;
11169: l_new_party_id :=okc_p_util.raw_to_number(sys_guid());
11170: l_return_status := CREATE_OKC_PARTY(l_new_party_id,l_old_party_id,l_new_bp_id);
11171: IF (G_DEBUG_ENABLED = 'Y') THEN
11172: okc_debug.log('AFTER CREATE_OKC_PARTY'||l_return_status, 2);
11173: END IF;
11174:
11175: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11176: THEN

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

11178: END IF;
11179: -- okc_contacts
11180: l_return_status := CREATE_OKC_CONTACT(l_new_party_id,l_old_party_id);
11181: IF (G_DEBUG_ENABLED = 'Y') THEN
11182: okc_debug.log('AFTER CREATE_OKC_CONTACT'||l_return_status, 2);
11183: END IF;
11184:
11185: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
11186: THEN

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

11202: x_msg_data => x_msg_data,
11203: p_contract_line_id => l_new_coverage_id);
11204:
11205: IF (G_DEBUG_ENABLED = 'Y') THEN
11206: okc_debug.log('AFTER Copy_Coverage'||l_return_status, 2);
11207: END IF;
11208:
11209:
11210: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN