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.OKL_VP_CHANGE_REQUEST_PVT dependencies on FND_LOG

Line 181: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST_HEADER';

177: ,x_vcrv_rec OUT NOCOPY vcrv_rec_type
178: ) IS
179: l_api_version CONSTANT NUMBER DEFAULT 1.0;
180: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CHANGE_REQUEST_HDR';
181: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST_HEADER';
182: l_debug_enabled VARCHAR2(10);
183:
184: BEGIN
185: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 190: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call create_change_request_header');

186:
187: l_debug_enabled := okl_debug_pub.check_log_enabled;
188:
189: IF(l_debug_enabled='Y') THEN
190: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call create_change_request_header');
191: END IF;
192:
193: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
194: x_return_status := OKL_API.START_ACTIVITY(

Line 219: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

215: ,x_vcrv_rec => x_vcrv_rec
216: );
217: -- write to log
218: IF(NVL(l_debug_enabled,'N')='Y') THEN
219: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
220: l_module,
221: 'okl_vcr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
222: );
223: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 233: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call create_change_request_header');

229:
230: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
231:
232: IF(l_debug_enabled='Y') THEN
233: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call create_change_request_header');
234: END IF;
235: EXCEPTION
236: WHEN OKL_API.G_EXCEPTION_ERROR THEN
237: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 284: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_HEADER';

280: lv_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
281:
282: l_api_version CONSTANT NUMBER DEFAULT 1.0;
283: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_HDR';
284: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_HEADER';
285: l_debug_enabled VARCHAR2(10);
286:
287: BEGIN
288: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 293: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call update_change_request_header');

289:
290: l_debug_enabled := okl_debug_pub.check_log_enabled;
291:
292: IF(l_debug_enabled='Y') THEN
293: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call update_change_request_header');
294: END IF;
295:
296: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
297: x_return_status := OKL_API.START_ACTIVITY(

Line 329: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

325: ,x_vcrv_rec => x_vcrv_rec
326: );
327: -- write to log
328: IF(NVL(l_debug_enabled,'N')='Y') THEN
329: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
330: l_module,
331: 'okl_vcr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
332: );
333: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 344: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call update_change_request_header');

340:
341: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
342:
343: IF(l_debug_enabled='Y') THEN
344: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call update_change_request_header');
345: END IF;
346: EXCEPTION
347: WHEN OKL_API.G_EXCEPTION_ERROR THEN
348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 387: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST_LINES';

383: ) IS
384: lv_crs_id okl_vp_change_requests.id%TYPE;
385: l_api_version CONSTANT NUMBER DEFAULT 1.0;
386: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CHANGE_REQUEST_LNS';
387: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST_LINES';
388: l_debug_enabled VARCHAR2(10);
389:
390: BEGIN
391: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call create_change_request_lines');

392:
393: l_debug_enabled := okl_debug_pub.check_log_enabled;
394:
395: IF(l_debug_enabled='Y') THEN
396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call create_change_request_lines');
397: END IF;
398:
399: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
400: x_return_status := OKL_API.START_ACTIVITY(

Line 425: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

421: ,x_vrrv_tbl => x_vrrv_tbl
422: );
423: -- write to log
424: IF(NVL(l_debug_enabled,'N')='Y') THEN
425: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
426: l_module,
427: 'okl_vrr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
428: );
429: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 459: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call create_change_request_lines');

455:
456: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
457:
458: IF(l_debug_enabled='Y') THEN
459: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call create_change_request_lines');
460: END IF;
461: EXCEPTION
462: WHEN OKL_API.G_EXCEPTION_ERROR THEN
463: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 502: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_LINES';

498: ) IS
499: lv_crs_id okl_vp_change_requests.id%TYPE;
500: l_api_version CONSTANT NUMBER DEFAULT 1.0;
501: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_LNS';
502: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_LINES';
503: l_debug_enabled VARCHAR2(10);
504:
505: BEGIN
506: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 511: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call update_change_request_lines');

507:
508: l_debug_enabled := okl_debug_pub.check_log_enabled;
509:
510: IF(l_debug_enabled='Y') THEN
511: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call update_change_request_lines');
512: END IF;
513:
514: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
515: x_return_status := OKL_API.START_ACTIVITY(

Line 540: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

536: ,x_vrrv_tbl => x_vrrv_tbl
537: );
538: -- write to log
539: IF(NVL(l_debug_enabled,'N')='Y') THEN
540: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
541: l_module,
542: 'okl_vrr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
543: );
544: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 574: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call update_change_request_lines');

570:
571: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
572:
573: IF(l_debug_enabled='Y') THEN
574: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call update_change_request_lines');
575: END IF;
576: EXCEPTION
577: WHEN OKL_API.G_EXCEPTION_ERROR THEN
578: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 621: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.DELETE_CHANGE_REQUEST_LINES';

617: lv_dummy VARCHAR2(1);
618: lv_crs_id okl_vp_change_requests.id%TYPE;
619: l_api_version CONSTANT NUMBER DEFAULT 1.0;
620: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_CHANGE_REQUEST_LNS';
621: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.DELETE_CHANGE_REQUEST_LINES';
622: l_debug_enabled VARCHAR2(10);
623:
624: BEGIN
625: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 630: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call delete_change_request_lines');

626:
627: l_debug_enabled := okl_debug_pub.check_log_enabled;
628:
629: IF(l_debug_enabled='Y') THEN
630: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call delete_change_request_lines');
631: END IF;
632:
633: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
634: x_return_status := OKL_API.START_ACTIVITY(

Line 658: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

654: ,p_vrrv_tbl => p_vrrv_tbl
655: );
656: -- write to log
657: IF(NVL(l_debug_enabled,'N')='Y') THEN
658: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
659: l_module,
660: 'okl_vrr_pvt.delete_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
661: );
662: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 701: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call delete_change_request_lines');

697: END IF;
698: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
699:
700: IF(l_debug_enabled='Y') THEN
701: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call delete_change_request_lines');
702: END IF;
703: EXCEPTION
704: WHEN OKL_API.G_EXCEPTION_ERROR THEN
705: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 796: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST';

792: lv_vrrv_tbl vrrv_tbl_type;
793:
794: l_api_version CONSTANT NUMBER DEFAULT 1.0;
795: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CHANGE_REQUEST';
796: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST';
797: l_debug_enabled VARCHAR2(10);
798:
799: BEGIN
800: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 805: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call create_change_request');

801:
802: l_debug_enabled := okl_debug_pub.check_log_enabled;
803:
804: IF(l_debug_enabled='Y') THEN
805: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call create_change_request');
806: END IF;
807:
808: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
809: x_return_status := OKL_API.START_ACTIVITY(

Line 1044: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call create_change_request');

1040:
1041: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1042:
1043: IF(l_debug_enabled='Y') THEN
1044: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call create_change_request');
1045: END IF;
1046: EXCEPTION
1047: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1048: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1085: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.ABANDON_CHANGE_REQUEST';

1081: ,x_vcrv_rec OUT NOCOPY vcrv_rec_type
1082: ) IS
1083: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1084: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'ABANDON_CHANGE_REQUEST';
1085: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.ABANDON_CHANGE_REQUEST';
1086: l_debug_enabled VARCHAR2(10);
1087:
1088: BEGIN
1089: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1094: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call abandon_change_request');

1090:
1091: l_debug_enabled := okl_debug_pub.check_log_enabled;
1092:
1093: IF(l_debug_enabled='Y') THEN
1094: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call abandon_change_request');
1095: END IF;
1096:
1097: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1098: x_return_status := OKL_API.START_ACTIVITY(

Line 1123: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1119: ,p_status_code => G_ABANDONED_STS_CODE
1120: );
1121: -- write to log
1122: IF(NVL(l_debug_enabled,'N')='Y') THEN
1123: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1124: l_module,
1125: 'set_change_request_status for '||p_vcrv_rec.id||' from abandon_change_request returned with status '||x_return_status
1126: );
1127: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1141: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call abandon_change_request');

1137:
1138: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1139:
1140: IF(l_debug_enabled='Y') THEN
1141: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call abandon_change_request');
1142: END IF;
1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1145: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1204: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.SET_CHANGE_REQUEST_STATUS';

1200: lv_vcrv_rec vcrv_rec_type;
1201: x_vcrv_rec vcrv_rec_type;
1202: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1203: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SET_CHANGE_REQUEST_STS';
1204: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.SET_CHANGE_REQUEST_STATUS';
1205: l_debug_enabled VARCHAR2(10);
1206:
1207: BEGIN
1208: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1213: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call set_change_request_status');

1209:
1210: l_debug_enabled := okl_debug_pub.check_log_enabled;
1211:
1212: IF(l_debug_enabled='Y') THEN
1213: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call set_change_request_status');
1214: END IF;
1215:
1216: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1217: x_return_status := OKL_API.START_ACTIVITY(

Line 1289: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1285: ,p_chr_id => lv_creq_chr_id -- this is the id of the backup copy agmnt
1286: );
1287: -- write to log
1288: IF(NVL(l_debug_enabled,'N')='Y') THEN
1289: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1290: l_module,
1291: 'okl_contract_status_pub.update_contract_status returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
1292: );
1293: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1319: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1315: ,x_vcrv_rec => x_vcrv_rec
1316: );
1317: -- write to log
1318: IF(NVL(l_debug_enabled,'N')='Y') THEN
1319: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1320: l_module,
1321: 'update_change_request_header returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
1322: );
1323: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1333: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call set_change_request_status');

1329:
1330: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1331:
1332: IF(l_debug_enabled='Y') THEN
1333: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call set_change_request_status');
1334: END IF;
1335:
1336: EXCEPTION
1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1384: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CASCADE_REQUEST_STATUS_EDIT';

1380: lv_vcrv_rec vcrv_rec_type;
1381: x_vcrv_rec vcrv_rec_type;
1382: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1383: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CASCADE_REQUEST_STS';
1384: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CASCADE_REQUEST_STATUS_EDIT';
1385: l_debug_enabled VARCHAR2(10);
1386:
1387: BEGIN
1388: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1393: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call cascade_request_status_edit');

1389:
1390: l_debug_enabled := okl_debug_pub.check_log_enabled;
1391:
1392: IF(l_debug_enabled='Y') THEN
1393: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call cascade_request_status_edit');
1394: END IF;
1395:
1396: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1397: x_return_status := OKL_API.START_ACTIVITY(

Line 1432: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1428: ,p_status_code => G_INCOMPLETE_STS_CODE
1429: );
1430: -- write to log
1431: IF(NVL(l_debug_enabled,'N')='Y') THEN
1432: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1433: l_module,
1434: 'set_change_request_status returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
1435: );
1436: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1450: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call cascade_request_status_edit');

1446:
1447: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1448:
1449: IF(l_debug_enabled='Y') THEN
1450: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call cascade_request_status_edit');
1451: END IF;
1452:
1453: EXCEPTION
1454: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1510: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.SUBMIT_CR_FOR_APPROVAL';

1506:
1507: l_approval_process VARCHAR2(30);
1508: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1509: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_CR_FOR_APPROVAL';
1510: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.SUBMIT_CR_FOR_APPROVAL';
1511: l_debug_enabled VARCHAR2(10);
1512:
1513: BEGIN
1514: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1519: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call submit_cr_for_approval');

1515:
1516: l_debug_enabled := okl_debug_pub.check_log_enabled;
1517:
1518: IF(l_debug_enabled='Y') THEN
1519: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call submit_cr_for_approval');
1520: END IF;
1521:
1522: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1523: x_return_status := OKL_API.START_ACTIVITY(

Line 1558: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1554: END IF;
1555:
1556: -- write to log
1557: IF(NVL(l_debug_enabled,'N')='Y') THEN
1558: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1559: l_module,
1560: 'lv_change_request_id '||lv_change_request_id||' from cursor '
1561: );
1562: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1599: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1595: ,p_change_request_id => lv_change_request_id
1596: );
1597: -- write to log
1598: IF(NVL(l_debug_enabled,'N')='Y') THEN
1599: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1600: l_module,
1601: 'okl_vp_sync_cr_pvt.sync_change_request on change request id '||lv_change_request_id||' returned with status '||x_return_status
1602: );
1603: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1624: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1620: ,x_msg_data => x_msg_data
1621: ,p_vp_crq_id => lv_change_request_id);
1622: -- write to log
1623: IF(NVL(l_debug_enabled,'N')='Y') THEN
1624: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1625: l_module,
1626: 'okl_vp_cr_wf.raise_oa_event_approval on change request id '||lv_change_request_id||' returned with status '||x_return_status
1627: );
1628: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1642: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call submit_cr_for_approval');

1638:
1639: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1640:
1641: IF(l_debug_enabled='Y') THEN
1642: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call submit_cr_for_approval');
1643: END IF;
1644:
1645: EXCEPTION
1646: WHEN OKL_API.G_EXCEPTION_ERROR THEN