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

Line 366: okc_debug.Set_Indentation('Create_PM_Program_Schedule');

362: l_check_renew varchar2(1):='N';
363: l_periods NUMBER;
364: BEGIN
365: IF (G_DEBUG_ENABLED = 'Y') THEN
366: okc_debug.Set_Indentation('Create_PM_Program_Schedule');
367: okc_debug.log('Entered Create_PM_Program_Schedule', 3);
368: END IF;
369:
370: OPEN CU_CHECK_PM_PROGRAM_EXIST;

Line 367: okc_debug.log('Entered Create_PM_Program_Schedule', 3);

363: l_periods NUMBER;
364: BEGIN
365: IF (G_DEBUG_ENABLED = 'Y') THEN
366: okc_debug.Set_Indentation('Create_PM_Program_Schedule');
367: okc_debug.log('Entered Create_PM_Program_Schedule', 3);
368: END IF;
369:
370: OPEN CU_CHECK_PM_PROGRAM_EXIST;
371: FETCH CU_CHECK_PM_PROGRAM_EXIST INTO CR_CHECK_PM_PROGRAM_EXIST;

Line 528: okc_debug.log('After oks_pml_pvt insert_row', 3);

524: x_msg_data =>l_msg_data,
525: p_pmlv_rec =>l_pmlrulv_tbl(pml_ctr),
526: x_pmlv_rec =>l_pmlrulvrec_Out);
527: IF (G_DEBUG_ENABLED = 'Y') THEN
528: okc_debug.log('After oks_pml_pvt insert_row', 3);
529: END IF;
530:
531: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
532: THEN

Line 565: okc_debug.log('After OKS_PMS_PVT insert_row', 3);

561: x_msg_data => l_msg_data,
562: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,
563: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);
564: IF (G_DEBUG_ENABLED = 'Y') THEN
565: okc_debug.log('After OKS_PMS_PVT insert_row', 3);
566: END IF;
567: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
568: THEN
569: OKC_API.set_message

Line 594: okc_debug.log('After OKS_CONTRACT_LINE_PUB UPDATE_LINE', 3);

590: p_klnv_tbl => l_klnv_tbl_in,
591: x_klnv_tbl => l_klnv_tbl_out,
592: p_validate_yn => 'N');
593: IF (G_DEBUG_ENABLED = 'Y') THEN
594: okc_debug.log('After OKS_CONTRACT_LINE_PUB UPDATE_LINE', 3);
595: END IF;
596:
597: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
598: OKC_API.set_message

Line 695: okc_debug.log('After oks_pma_pvt insert_row', 3);

691: x_msg_data =>l_msg_data,
692: p_pmav_rec =>l_pmarulv_tbl(pma_ctr),
693: x_pmav_rec =>l_pmarulvrec_Out);
694: IF (G_DEBUG_ENABLED = 'Y') THEN
695: okc_debug.log('After oks_pma_pvt insert_row', 3);
696: END IF;
697: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
698: THEN
699: OKC_API.set_message

Line 839: okc_debug.log('After act oks_pml_pvt insert_row', 3);

835: x_msg_data =>l_msg_data,
836: p_pmlv_rec =>l_pmlrulv_tbl(pml_ctr),
837: x_pmlv_rec =>l_pmlrulvrec_Out);
838: IF (G_DEBUG_ENABLED = 'Y') THEN
839: okc_debug.log('After act oks_pml_pvt insert_row', 3);
840: END IF;
841: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
842: THEN
843: OKC_API.set_message

Line 876: okc_debug.log('After act OKS_PMS_PVT insert_row', 3);

872: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,
873: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);
874:
875: IF (G_DEBUG_ENABLED = 'Y') THEN
876: okc_debug.log('After act OKS_PMS_PVT insert_row', 3);
877: END IF;
878: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
879: THEN
880: OKC_API.set_message

Line 944: okc_debug.log('Exiting Create_PM_Program_Schedule', 3);

940:
941: */
942:
943: IF (G_DEBUG_ENABLED = 'Y') THEN
944: okc_debug.log('Exiting Create_PM_Program_Schedule', 3);
945: okc_debug.Reset_Indentation;
946: END IF;
947: x_return_status := l_return_status;
948: x_msg_count := l_msg_count;

Line 945: okc_debug.Reset_Indentation;

941: */
942:
943: IF (G_DEBUG_ENABLED = 'Y') THEN
944: okc_debug.log('Exiting Create_PM_Program_Schedule', 3);
945: okc_debug.Reset_Indentation;
946: END IF;
947: x_return_status := l_return_status;
948: x_msg_count := l_msg_count;
949: x_msg_data := l_msg_data;

Line 955: okc_debug.log('Exiting Create_PM_Program_Schedule'||l_return_Status, 3);

951: EXCEPTION
952: WHEN G_EXCEPTION_HALT_VALIDATION THEN
953: x_return_status := l_return_status ;
954: IF (G_DEBUG_ENABLED = 'Y') THEN
955: okc_debug.log('Exiting Create_PM_Program_Schedule'||l_return_Status, 3);
956: okc_debug.Reset_Indentation;
957: END IF;
958: WHEN OTHERS THEN
959: OKC_API.SET_MESSAGE(

Line 956: okc_debug.Reset_Indentation;

952: WHEN G_EXCEPTION_HALT_VALIDATION THEN
953: x_return_status := l_return_status ;
954: IF (G_DEBUG_ENABLED = 'Y') THEN
955: okc_debug.log('Exiting Create_PM_Program_Schedule'||l_return_Status, 3);
956: okc_debug.Reset_Indentation;
957: END IF;
958: WHEN OTHERS THEN
959: OKC_API.SET_MESSAGE(
960: p_app_name => g_app_name,

Line 970: okc_debug.log('Exiting Create_PM_Program_Schedule'||sqlerrm, 3);

966:
967: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
968: x_msg_count :=l_msg_count;
969: IF (G_DEBUG_ENABLED = 'Y') THEN
970: okc_debug.log('Exiting Create_PM_Program_Schedule'||sqlerrm, 3);
971: okc_debug.Reset_Indentation;
972: END IF;
973: END CREATE_PM_PROGRAM_SCHEDULE;
974:

Line 971: okc_debug.Reset_Indentation;

967: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
968: x_msg_count :=l_msg_count;
969: IF (G_DEBUG_ENABLED = 'Y') THEN
970: okc_debug.log('Exiting Create_PM_Program_Schedule'||sqlerrm, 3);
971: okc_debug.Reset_Indentation;
972: END IF;
973: END CREATE_PM_PROGRAM_SCHEDULE;
974:
975:

Line 1301: okc_debug.Set_Indentation('Renew_PM_Program_Schedule');

1297: l_cov_rec okc_contract_pub.clev_rec_type;
1298:
1299: BEGIN
1300: IF (G_DEBUG_ENABLED = 'Y') THEN
1301: okc_debug.Set_Indentation('Renew_PM_Program_Schedule');
1302: okc_debug.log('Entered Renew_PM_Program_Schedule', 3);
1303: END IF;
1304: --CK RUL
1305: FOR NewCovDet_Rec IN Cur_NewCovDet

Line 1302: okc_debug.log('Entered Renew_PM_Program_Schedule', 3);

1298:
1299: BEGIN
1300: IF (G_DEBUG_ENABLED = 'Y') THEN
1301: okc_debug.Set_Indentation('Renew_PM_Program_Schedule');
1302: okc_debug.log('Entered Renew_PM_Program_Schedule', 3);
1303: END IF;
1304: --CK RUL
1305: FOR NewCovDet_Rec IN Cur_NewCovDet
1306: LOOP

Line 1329: okc_debug.log('After CREATE_PM_PROGRAM_SCHEDULE', 3);

1325: p_cle_id =>l_cov_rec.id ,--p_contract_line_id, --pass coverage line id of new contract
1326: p_cov_start_date => l_cov_rec.Start_Date,
1327: p_cov_end_date => l_cov_rec.End_Date);
1328: IF (G_DEBUG_ENABLED = 'Y') THEN
1329: okc_debug.log('After CREATE_PM_PROGRAM_SCHEDULE', 3);
1330: END IF;
1331:
1332: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1333: THEN

Line 1344: okc_debug.log('Exiting Renew_PM_Program_Schedule', 3);

1340: Raise G_EXCEPTION_HALT_VALIDATION;
1341: END IF;
1342:
1343: IF (G_DEBUG_ENABLED = 'Y') THEN
1344: okc_debug.log('Exiting Renew_PM_Program_Schedule', 3);
1345: okc_debug.Reset_Indentation;
1346: END IF;
1347:
1348: x_return_status := l_return_status;

Line 1345: okc_debug.Reset_Indentation;

1341: END IF;
1342:
1343: IF (G_DEBUG_ENABLED = 'Y') THEN
1344: okc_debug.log('Exiting Renew_PM_Program_Schedule', 3);
1345: okc_debug.Reset_Indentation;
1346: END IF;
1347:
1348: x_return_status := l_return_status;
1349: x_msg_count := l_msg_count;

Line 1356: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);

1352: EXCEPTION
1353: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1354: x_return_status := l_return_status ;
1355: IF (G_DEBUG_ENABLED = 'Y') THEN
1356: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);
1357: okc_debug.Reset_Indentation;
1358: END IF;
1359:
1360: WHEN OTHERS THEN

Line 1357: okc_debug.Reset_Indentation;

1353: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1354: x_return_status := l_return_status ;
1355: IF (G_DEBUG_ENABLED = 'Y') THEN
1356: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);
1357: okc_debug.Reset_Indentation;
1358: END IF;
1359:
1360: WHEN OTHERS THEN
1361: OKC_API.SET_MESSAGE(

Line 1372: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);

1368:
1369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1370: x_msg_count :=l_msg_count;
1371: IF (G_DEBUG_ENABLED = 'Y') THEN
1372: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);
1373: okc_debug.Reset_Indentation;
1374: END IF;
1375:
1376: END RENEW_PM_PROGRAM_SCHEDULE;

Line 1373: okc_debug.Reset_Indentation;

1369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1370: x_msg_count :=l_msg_count;
1371: IF (G_DEBUG_ENABLED = 'Y') THEN
1372: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);
1373: okc_debug.Reset_Indentation;
1374: END IF;
1375:
1376: END RENEW_PM_PROGRAM_SCHEDULE;
1377:

Line 1947: okc_debug.Set_Indentation('Adjust_PM_Program_Schedule');

1943: l_pm_ctr NUMBER;
1944: l_cle_id NUMBER;
1945: BEGIN
1946: IF (G_DEBUG_ENABLED = 'Y') THEN
1947: okc_debug.Set_Indentation('Adjust_PM_Program_Schedule');
1948: okc_debug.log('Entered Adjust_PM_Program_Schedule', 3);
1949: END IF;
1950: --CK RUL
1951: OPEN CU_CLE_ID;

Line 1948: okc_debug.log('Entered Adjust_PM_Program_Schedule', 3);

1944: l_cle_id NUMBER;
1945: BEGIN
1946: IF (G_DEBUG_ENABLED = 'Y') THEN
1947: okc_debug.Set_Indentation('Adjust_PM_Program_Schedule');
1948: okc_debug.log('Entered Adjust_PM_Program_Schedule', 3);
1949: END IF;
1950: --CK RUL
1951: OPEN CU_CLE_ID;
1952: LOOP

Line 2291: okc_debug.log('After oks_pms_pvt delete_row', 3);

2287: x_msg_count => l_msg_count,
2288: x_msg_data => l_msg_data,
2289: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
2290: IF (G_DEBUG_ENABLED = 'Y') THEN
2291: okc_debug.log('After oks_pms_pvt delete_row', 3);
2292: END IF;
2293:
2294: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2295: OKC_API.set_message

Line 2313: okc_debug.log('After oks_pml_pvt delete_row', 3);

2309: x_msg_data => l_msg_data,
2310: p_pmlv_tbl => l_pmlrulv_tbl_del);
2311:
2312: IF (G_DEBUG_ENABLED = 'Y') THEN
2313: okc_debug.log('After oks_pml_pvt delete_row', 3);
2314: END IF;
2315:
2316: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2317: OKC_API.set_message

Line 2337: okc_debug.log('After oks_pms_pvt insert_row', 3);

2333: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2334: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2335:
2336: IF (G_DEBUG_ENABLED = 'Y') THEN
2337: okc_debug.log('After oks_pms_pvt insert_row', 3);
2338: END IF;
2339:
2340: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2341: OKC_API.set_message

Line 2360: okc_debug.log('After oks_pml_pvt insert_row', 3);

2356: p_pmlv_tbl => l_pmlrulv_tbl_ins,
2357: x_pmlv_tbl => l_pmlrulv_tbl_ins_out);
2358:
2359: IF (G_DEBUG_ENABLED = 'Y') THEN
2360: okc_debug.log('After oks_pml_pvt insert_row', 3);
2361: END IF;
2362: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2363: OKC_API.set_message
2364: (G_APP_NAME,

Line 2409: okc_debug.log('After oks_pms_pvt delete_row', 3);

2405: x_msg_count => l_msg_count,
2406: x_msg_data => l_msg_data,
2407: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
2408: IF (G_DEBUG_ENABLED = 'Y') THEN
2409: okc_debug.log('After oks_pms_pvt delete_row', 3);
2410: END IF;
2411: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2412: OKC_API.set_message
2413: (G_APP_NAME,

Line 2433: okc_debug.log('After oks_pml_pvt delete_row', 3);

2429: x_msg_data => l_msg_data,
2430: p_pmlv_tbl => l_pmlrulv_tbl_del);
2431:
2432: IF (G_DEBUG_ENABLED = 'Y') THEN
2433: okc_debug.log('After oks_pml_pvt delete_row', 3);
2434: END IF;
2435:
2436: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2437: OKC_API.set_message

Line 2595: okc_debug.log('After oks_pms_pvt insert_row', 3);

2591: x_msg_data => l_msg_data,
2592: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2593: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2594: IF (G_DEBUG_ENABLED = 'Y') THEN
2595: okc_debug.log('After oks_pms_pvt insert_row', 3);
2596: END IF;
2597:
2598: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2599: OKC_API.set_message

Line 2651: okc_debug.log('After oks_pms_pvt update_row', 3);

2647: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
2648: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
2649:
2650: IF (G_DEBUG_ENABLED = 'Y') THEN
2651: okc_debug.log('After oks_pms_pvt update_row', 3);
2652: END IF;
2653:
2654: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2655: OKC_API.set_message

Line 2827: okc_debug.log('After oks_pms_pvt insert_row', 3);

2823: x_msg_data => l_msg_data,
2824: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2825: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2826: IF (G_DEBUG_ENABLED = 'Y') THEN
2827: okc_debug.log('After oks_pms_pvt insert_row', 3);
2828: END IF;
2829: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2830: OKC_API.set_message
2831: (G_APP_NAME,

Line 2903: okc_debug.log('After oks_pms_pvt insert_row', 3);

2899: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2900: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2901:
2902: IF (G_DEBUG_ENABLED = 'Y') THEN
2903: okc_debug.log('After oks_pms_pvt insert_row', 3);
2904: END IF;
2905:
2906: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2907: OKC_API.set_message

Line 2950: okc_debug.log('After oks_pms_pvt update_row', 3);

2946: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
2947: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
2948:
2949: IF (G_DEBUG_ENABLED = 'Y') THEN
2950: okc_debug.log('After oks_pms_pvt update_row', 3);
2951: END IF;
2952:
2953: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2954: OKC_API.set_message

Line 3050: okc_debug.log('After oks_pms_pvt insert_row', 3);

3046: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
3047: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
3048:
3049: IF (G_DEBUG_ENABLED = 'Y') THEN
3050: okc_debug.log('After oks_pms_pvt insert_row', 3);
3051: END IF;
3052:
3053: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3054: OKC_API.set_message

Line 3106: okc_debug.log('After oks_pms_pvt update_row', 3);

3102: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3103: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3104:
3105: IF (G_DEBUG_ENABLED = 'Y') THEN
3106: okc_debug.log('After oks_pms_pvt update_row', 3);
3107: END IF;
3108: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3109: OKC_API.set_message
3110: (G_APP_NAME,

Line 3196: okc_debug.log('After oks_pms_pvt update_row', 3);

3192: x_msg_data => l_msg_data,
3193: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3194: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3195: IF (G_DEBUG_ENABLED = 'Y') THEN
3196: okc_debug.log('After oks_pms_pvt update_row', 3);
3197: END IF;
3198: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3199: OKC_API.set_message
3200: (G_APP_NAME,

Line 3264: okc_debug.log('After oks_pml_pvt update_row', 3);

3260: x_msg_data => l_msg_data,
3261: p_pmlv_tbl => l_pmlrulv_tbl_upd,
3262: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3263: IF (G_DEBUG_ENABLED = 'Y') THEN
3264: okc_debug.log('After oks_pml_pvt update_row', 3);
3265: END IF;
3266: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3267: OKC_API.set_message
3268: (G_APP_NAME,

Line 3310: okc_debug.log('After oks_pms_pvt delete_row', 3);

3306: x_msg_count => l_msg_count,
3307: x_msg_data => l_msg_data,
3308: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
3309: IF (G_DEBUG_ENABLED = 'Y') THEN
3310: okc_debug.log('After oks_pms_pvt delete_row', 3);
3311: END IF;
3312: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3313: OKC_API.set_message
3314: (G_APP_NAME,

Line 3334: okc_debug.log('After oks_pml_pvt delete_row', 3);

3330: x_msg_data => l_msg_data,
3331: p_pmlv_tbl => l_pmlrulv_tbl_del);
3332:
3333: IF (G_DEBUG_ENABLED = 'Y') THEN
3334: okc_debug.log('After oks_pml_pvt delete_row', 3);
3335: END IF;
3336:
3337: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3338: OKC_API.set_message

Line 3392: okc_debug.log('After oks_pms_pvt update_row', 3);

3388: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3389: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3390:
3391: IF (G_DEBUG_ENABLED = 'Y') THEN
3392: okc_debug.log('After oks_pms_pvt update_row', 3);
3393: END IF;
3394:
3395: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3396: OKC_API.set_message

Line 3558: okc_debug.log('After oks_pms_pvt insert_row', 3);

3554: x_msg_data => l_msg_data,
3555: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
3556: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
3557: IF (G_DEBUG_ENABLED = 'Y') THEN
3558: okc_debug.log('After oks_pms_pvt insert_row', 3);
3559: END IF;
3560: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3561: OKC_API.set_message
3562: (G_APP_NAME,

Line 3580: okc_debug.log('After oks_pms_pvt update_row', 3);

3576: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3577: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3578:
3579: IF (G_DEBUG_ENABLED = 'Y') THEN
3580: okc_debug.log('After oks_pms_pvt update_row', 3);
3581: END IF;
3582: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3583: OKC_API.set_message
3584: (G_APP_NAME,

Line 3619: okc_debug.log('After oks_pml_pvt update_row', 3);

3615: x_msg_data => l_msg_data,
3616: p_pmlv_tbl => l_pmlrulv_tbl_upd,
3617: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3618: IF (G_DEBUG_ENABLED = 'Y') THEN
3619: okc_debug.log('After oks_pml_pvt update_row', 3);
3620: END IF;
3621: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3622: OKC_API.set_message
3623: (G_APP_NAME,

Line 3666: okc_debug.log('After oks_pms_pvt update_row', 3);

3662: x_msg_data => l_msg_data,
3663: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3664: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3665: IF (G_DEBUG_ENABLED = 'Y') THEN
3666: okc_debug.log('After oks_pms_pvt update_row', 3);
3667: END IF;
3668:
3669: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3670: OKC_API.set_message

Line 3706: okc_debug.log('After oks_pml_pvt update_row', 3);

3702: p_pmlv_tbl => l_pmlrulv_tbl_upd,
3703: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3704:
3705: IF (G_DEBUG_ENABLED = 'Y') THEN
3706: okc_debug.log('After oks_pml_pvt update_row', 3);
3707: END IF;
3708:
3709: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3710: OKC_API.set_message

Line 3752: okc_debug.log('After oks_pms_pvt delete_row', 3);

3748: x_msg_data => l_msg_data,
3749: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
3750:
3751: IF (G_DEBUG_ENABLED = 'Y') THEN
3752: okc_debug.log('After oks_pms_pvt delete_row', 3);
3753: END IF;
3754:
3755: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3756: OKC_API.set_message

Line 3815: okc_debug.log('After oks_pms_pvt update_row', 3);

3811: x_msg_data => l_msg_data,
3812: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3813: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3814: IF (G_DEBUG_ENABLED = 'Y') THEN
3815: okc_debug.log('After oks_pms_pvt update_row', 3);
3816: END IF;
3817: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3818: OKC_API.set_message
3819: (G_APP_NAME,

Line 3909: okc_debug.log('After oks_pms_pvt insert_row', 3);

3905: x_msg_data => l_msg_data,
3906: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
3907: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
3908: IF (G_DEBUG_ENABLED = 'Y') THEN
3909: okc_debug.log('After oks_pms_pvt insert_row', 3);
3910: END IF;
3911:
3912: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3913: OKC_API.set_message

Line 3935: okc_debug.log('After oks_pml_pvt update_row', 3);

3931: p_pmlv_tbl => l_pmlrulv_tbl_upd,
3932: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3933:
3934: IF (G_DEBUG_ENABLED = 'Y') THEN
3935: okc_debug.log('After oks_pml_pvt update_row', 3);
3936: END IF;
3937:
3938: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3939: OKC_API.set_message

Line 3962: okc_debug.log('Exiting Adjust_PM_Program_Schedule', 3);

3958: end loop;
3959:
3960: end loop;
3961: IF (G_DEBUG_ENABLED = 'Y') THEN
3962: okc_debug.log('Exiting Adjust_PM_Program_Schedule', 3);
3963: okc_debug.Reset_Indentation;
3964: END IF;
3965:
3966: x_return_status := l_return_status;

Line 3963: okc_debug.Reset_Indentation;

3959:
3960: end loop;
3961: IF (G_DEBUG_ENABLED = 'Y') THEN
3962: okc_debug.log('Exiting Adjust_PM_Program_Schedule', 3);
3963: okc_debug.Reset_Indentation;
3964: END IF;
3965:
3966: x_return_status := l_return_status;
3967: x_msg_count := l_msg_count;

Line 3974: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||l_return_Status, 3);

3970: EXCEPTION
3971: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3972: x_return_status := l_return_status ;
3973: IF (G_DEBUG_ENABLED = 'Y') THEN
3974: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||l_return_Status, 3);
3975: okc_debug.Reset_Indentation;
3976: END IF;
3977: WHEN OTHERS THEN
3978: OKC_API.SET_MESSAGE(

Line 3975: okc_debug.Reset_Indentation;

3971: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3972: x_return_status := l_return_status ;
3973: IF (G_DEBUG_ENABLED = 'Y') THEN
3974: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||l_return_Status, 3);
3975: okc_debug.Reset_Indentation;
3976: END IF;
3977: WHEN OTHERS THEN
3978: OKC_API.SET_MESSAGE(
3979: p_app_name => g_app_name,

Line 3989: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||sqlerrm, 3);

3985: ------------dbms_output.put_line('Value of l_return_status6='||l_return_status||substr(sqlerrm,1,200));
3986: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3987: x_msg_count :=l_msg_count;
3988: IF (G_DEBUG_ENABLED = 'Y') THEN
3989: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||sqlerrm, 3);
3990: okc_debug.Reset_Indentation;
3991: END IF;
3992:
3993: END ADJUST_PM_PROGRAM_SCHEDULE;

Line 3990: okc_debug.Reset_Indentation;

3986: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3987: x_msg_count :=l_msg_count;
3988: IF (G_DEBUG_ENABLED = 'Y') THEN
3989: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||sqlerrm, 3);
3990: okc_debug.Reset_Indentation;
3991: END IF;
3992:
3993: END ADJUST_PM_PROGRAM_SCHEDULE;
3994:

Line 4975: okc_debug.Set_Indentation('Undo_PM_Line');

4971: l_api_name CONSTANT VARCHAR2(30) := 'UNDO PM LINE';
4972:
4973: BEGIN
4974: IF (G_DEBUG_ENABLED = 'Y') THEN
4975: okc_debug.Set_Indentation('Undo_PM_Line');
4976: okc_debug.log('Entered Undo_PM_Line', 3);
4977: END IF;
4978: x_return_status:=OKC_API.G_Ret_Sts_Success;
4979: --Deleting activities

Line 4976: okc_debug.log('Entered Undo_PM_Line', 3);

4972:
4973: BEGIN
4974: IF (G_DEBUG_ENABLED = 'Y') THEN
4975: okc_debug.Set_Indentation('Undo_PM_Line');
4976: okc_debug.log('Entered Undo_PM_Line', 3);
4977: END IF;
4978: x_return_status:=OKC_API.G_Ret_Sts_Success;
4979: --Deleting activities
4980: FOR CR_GET_PMA IN CU_GET_PMA

Line 4996: okc_debug.log('After OKS_PMA_PVT delete_row', 3);

4992: x_msg_data => l_msg_data,
4993: p_pmav_tbl => l_pmav_tbl);
4994: END IF ;
4995: IF (G_DEBUG_ENABLED = 'Y') THEN
4996: okc_debug.log('After OKS_PMA_PVT delete_row', 3);
4997: END IF;
4998:
4999: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5000: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 5022: okc_debug.log('After OKS_PML_PVT delete_row', 3);

5018: p_pmlv_tbl => l_pmlv_tbl);
5019: END IF ;
5020:
5021: IF (G_DEBUG_ENABLED = 'Y') THEN
5022: okc_debug.log('After OKS_PML_PVT delete_row', 3);
5023: END IF;
5024:
5025: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5026: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 5048: okc_debug.log('After OKS_PMS_PVT delete_row', 3);

5044: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);
5045: END IF ;
5046:
5047: IF (G_DEBUG_ENABLED = 'Y') THEN
5048: okc_debug.log('After OKS_PMS_PVT delete_row', 3);
5049: END IF;
5050:
5051: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5052: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 5057: okc_debug.log('Exiting Undo_PM_Line', 3);

5053: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM_SCHEDULES');
5054: RETURN;
5055: END IF;
5056: IF (G_DEBUG_ENABLED = 'Y') THEN
5057: okc_debug.log('Exiting Undo_PM_Line', 3);
5058: okc_debug.Reset_Indentation;
5059: END IF;
5060:
5061: EXCEPTION

Line 5058: okc_debug.Reset_Indentation;

5054: RETURN;
5055: END IF;
5056: IF (G_DEBUG_ENABLED = 'Y') THEN
5057: okc_debug.log('Exiting Undo_PM_Line', 3);
5058: okc_debug.Reset_Indentation;
5059: END IF;
5060:
5061: EXCEPTION
5062: WHEN OTHERS THEN

Line 5074: okc_debug.log('Exiting Undo_PM_Line'||sqlerrm, 3);

5070: p_token2_value => sqlerrm);
5071: -- notify caller of an error as UNEXPETED error
5072: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5073: IF (G_DEBUG_ENABLED = 'Y') THEN
5074: okc_debug.log('Exiting Undo_PM_Line'||sqlerrm, 3);
5075: okc_debug.Reset_Indentation;
5076: END IF;
5077: END UNDO_PM_LINE;
5078:

Line 5075: okc_debug.Reset_Indentation;

5071: -- notify caller of an error as UNEXPETED error
5072: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5073: IF (G_DEBUG_ENABLED = 'Y') THEN
5074: okc_debug.log('Exiting Undo_PM_Line'||sqlerrm, 3);
5075: okc_debug.Reset_Indentation;
5076: END IF;
5077: END UNDO_PM_LINE;
5078:
5079: PROCEDURE INIT_OKS_K_LINE(x_klnv_tbl OUT NOCOPY OKS_KLN_PVT.klnv_tbl_type)

Line 5568: okc_debug.Set_Indentation('Copy_PM_Template');

5564:
5565: BEGIN
5566:
5567: IF (G_DEBUG_ENABLED = 'Y') THEN
5568: okc_debug.Set_Indentation('Copy_PM_Template');
5569: okc_debug.log('Entered Copy_PM_Template', 3);
5570: END IF;
5571: l_return_status := CREATE_OKS_PM_ACTIVITIES(p_new_coverage_id,p_old_coverage_id);
5572: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 5569: okc_debug.log('Entered Copy_PM_Template', 3);

5565: BEGIN
5566:
5567: IF (G_DEBUG_ENABLED = 'Y') THEN
5568: okc_debug.Set_Indentation('Copy_PM_Template');
5569: okc_debug.log('Entered Copy_PM_Template', 3);
5570: END IF;
5571: l_return_status := CREATE_OKS_PM_ACTIVITIES(p_new_coverage_id,p_old_coverage_id);
5572: IF (G_DEBUG_ENABLED = 'Y') THEN
5573: okc_debug.log('After CREATE_OKS_PM_ACTIVITIES'||l_return_status, 3);

Line 5573: okc_debug.log('After CREATE_OKS_PM_ACTIVITIES'||l_return_status, 3);

5569: okc_debug.log('Entered Copy_PM_Template', 3);
5570: END IF;
5571: l_return_status := CREATE_OKS_PM_ACTIVITIES(p_new_coverage_id,p_old_coverage_id);
5572: IF (G_DEBUG_ENABLED = 'Y') THEN
5573: okc_debug.log('After CREATE_OKS_PM_ACTIVITIES'||l_return_status, 3);
5574: END IF;
5575: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5576: THEN
5577: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 5581: okc_debug.log('After CREATE_OKS_PM_STREAM_LEVELS'||l_return_status, 3);

5577: RAISE G_EXCEPTION_HALT_VALIDATION;
5578: END IF;
5579: l_return_status := CREATE_OKS_PM_STREAM_LEVELS(p_new_coverage_id,p_old_coverage_id);
5580: IF (G_DEBUG_ENABLED = 'Y') THEN
5581: okc_debug.log('After CREATE_OKS_PM_STREAM_LEVELS'||l_return_status, 3);
5582: END IF;
5583:
5584: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5585: THEN