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.OCM_ADD_DATA_POINTS dependencies on AR_CMGT_UTIL

Line 4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;

1: Package Body OCM_ADD_DATA_POINTS AS
2: /* $Header: OCMGTDPB.pls 120.15 2012/05/18 11:55:09 kgnanase ship $ */
3:
4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:
6: PROCEDURE GenarateCaseFolderDetails (
7: p_case_folder_id IN NUMBER,
8: p_data_point_id IN NUMBER,

Line 84: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');

80: p_function_name IS NOT NULL
81: THEN
82: IF pg_wf_debug = 'Y'
83: THEN
84: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
85: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
86: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
87: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
88: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

Line 85: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||

81: THEN
82: IF pg_wf_debug = 'Y'
83: THEN
84: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
85: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
86: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
87: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
88: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
89: END IF;

Line 87: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||

83: THEN
84: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
85: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
86: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
87: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
88: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
89: END IF;
90:
91: -- first clear the global pl/sql table

Line 113: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id, p_error_msg);

109: THEN
110: p_resultout := 1;
111: p_error_msg := 'Package '||p_package_name|| ' Function '||p_function_name ||
112: ' Failed. Error '|| x_errormsg;
113: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id, p_error_msg);
114: return;
115: END IF;
116: ELSE
117: p_result_value := NULL;

Line 126: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id, p_error_msg);

122: p_resultout := 1;
123: p_error_msg := 'Sql Error While Calling Sql Function '||sqlerrm ||
124: 'Package Name:'
125: || p_package_name ||' Function Name:'|| p_function_name;
126: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id, p_error_msg);
127: END;
128:
129:
130: PROCEDURE GetChildDataPoints (

Line 177: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

173:
174: BEGIN
175: IF pg_wf_debug = 'Y'
176: THEN
177: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
178: 'ocm_add_data_points_pkg.getchilddatapoints()+');
179: END IF;
180:
181: FOR getChildDataPointsRec IN getChildDataPointsC

Line 205: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

201: getAllParentValuesRec.data_point_value_id;
202: l_case_folder_detail_id := null;
203: IF pg_wf_debug = 'Y'
204: THEN
205: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
206: 'par_dp_id=' || getChildDataPointsRec.parent_data_point_id ||
207: ' dp_id=' || getChildDataPointsRec.data_point_id ||
208: ' pkg.fun()=' || getChildDataPointsRec.package_name ||
209: '.' || getChildDataPointsRec.function_name);

Line 210: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');

206: 'par_dp_id=' || getChildDataPointsRec.parent_data_point_id ||
207: ' dp_id=' || getChildDataPointsRec.data_point_id ||
208: ' pkg.fun()=' || getChildDataPointsRec.package_name ||
209: '.' || getChildDataPointsRec.function_name);
210: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
211: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
212: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
213: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
214: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

Line 211: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||

207: ' dp_id=' || getChildDataPointsRec.data_point_id ||
208: ' pkg.fun()=' || getChildDataPointsRec.package_name ||
209: '.' || getChildDataPointsRec.function_name);
210: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
211: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
212: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
213: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
214: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
215: END IF;

Line 213: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||

209: '.' || getChildDataPointsRec.function_name);
210: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
211: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
212: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
213: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
214: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
215: END IF;
216:
217: BuildExecuteSql (

Line 226: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

222: p_resultout => p_resultout ) ;
223:
224: IF pg_wf_debug = 'Y'
225: THEN
226: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
227: ' return_value = ' || l_return_value || ' p_resultout = ' || p_resultout);
228: END IF;
229:
230: IF p_resultout <> 0

Line 300: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

296: FOR i in 1 .. pg_ocm_dp_values_tbl.count
297: LOOP
298: IF pg_wf_debug = 'Y'
299: THEN
300: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
301: ' return_value(' || i || ') = ' ||
302: pg_ocm_dp_values_tbl(i).p_data_point_value);
303: END IF;
304:

Line 329: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');

325: END IF;
326:
327: IF pg_wf_debug = 'Y'
328: THEN
329: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');
330: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
332: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
333: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

Line 330: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||

326:
327: IF pg_wf_debug = 'Y'
328: THEN
329: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');
330: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
332: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
333: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
334: END IF;

Line 332: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||

328: THEN
329: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');
330: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
332: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
333: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
334: END IF;
335:
336: END LOOP; -- end of getAllParentValuesRec

Line 340: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

336: END LOOP; -- end of getAllParentValuesRec
337: END LOOP;
338: IF pg_wf_debug = 'Y'
339: THEN
340: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
341: 'ocm_add_data_points_pkg.getchilddatapoints()-');
342: END IF;
343: END;
344:

Line 379: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

375: l_dp_exists VARCHAR2(1) := 'N';
376: BEGIN
377: IF pg_wf_debug = 'Y'
378: THEN
379: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
380: 'ocm_add_data_points_pkg.getparentdatapoints()+');
381: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
382: ' p_mode = ' || p_mode);
383: END IF;

Line 381: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

377: IF pg_wf_debug = 'Y'
378: THEN
379: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
380: 'ocm_add_data_points_pkg.getparentdatapoints()+');
381: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
382: ' p_mode = ' || p_mode);
383: END IF;
384:
385:

Line 404: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

400: pg_ocm_dp_values_tbl.delete;
401:
402: IF pg_wf_debug = 'Y'
403: THEN
404: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
405: 'app_id=' || getParentDataPointsRec.application_id ||
406: ' dp_id=' || getParentDataPointsRec.data_point_id ||
407: ' pkg.fun()=' || getParentDataPointsRec.package_name ||
408: '.' || getParentDataPointsRec.function_name);

Line 409: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');

405: 'app_id=' || getParentDataPointsRec.application_id ||
406: ' dp_id=' || getParentDataPointsRec.data_point_id ||
407: ' pkg.fun()=' || getParentDataPointsRec.package_name ||
408: '.' || getParentDataPointsRec.function_name);
409: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
410: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
411: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
412: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
413: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

Line 410: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||

406: ' dp_id=' || getParentDataPointsRec.data_point_id ||
407: ' pkg.fun()=' || getParentDataPointsRec.package_name ||
408: '.' || getParentDataPointsRec.function_name);
409: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
410: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
411: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
412: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
413: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
414: END IF;

Line 412: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||

408: '.' || getParentDataPointsRec.function_name);
409: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'before call:');
410: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value = ' ||
411: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
412: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_value_id = ' ||
413: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
414: END IF;
415:
416: BuildExecuteSql (

Line 425: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

421: p_resultout => p_resultout );
422:
423: IF pg_wf_debug = 'Y'
424: THEN
425: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
426: ' return_value = ' || l_return_value || ' p_resultout = ' || p_resultout);
427: END IF;
428:
429: IF p_resultout <> 0

Line 496: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

492: END IF;
493:
494: IF pg_wf_debug = 'Y'
495: THEN
496: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
497: ' l_dp_exists = ' || l_dp_exists);
498: END IF;
499:
500: IF l_dp_exists = 'N'

Line 530: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

526: LOOP
527:
528: IF pg_wf_debug = 'Y'
529: THEN
530: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
531: ' return_value(' || i || ') = ' ||
532: pg_ocm_dp_values_tbl(i).p_data_point_value);
533: END IF;
534:

Line 580: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');

576: END IF;
577:
578: IF pg_wf_debug = 'Y'
579: THEN
580: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');
581: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
582: 'p_data_point_value = ' ||
583: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
584: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

Line 581: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

577:
578: IF pg_wf_debug = 'Y'
579: THEN
580: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');
581: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
582: 'p_data_point_value = ' ||
583: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
584: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
585: 'p_data_point_value_id = ' ||

Line 584: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

580: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'after call:');
581: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
582: 'p_data_point_value = ' ||
583: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value);
584: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
585: 'p_data_point_value_id = ' ||
586: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
587: END IF;
588:

Line 593: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

589: END LOOP; /* get parents loop */
590:
591: IF pg_wf_debug = 'Y'
592: THEN
593: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
594: 'ocm_add_data_points_pkg.getparentdatapoints()-');
595: END IF;
596: END;
597:

Line 615: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

611:
612: BEGIN
613: IF pg_wf_debug = 'Y'
614: THEN
615: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
616: 'ocm_add_data_points_pkg.getadditionaldatapoints()+');
617: END IF;
618:
619: p_resultout := 0;

Line 651: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

647: END LOOP;
648:
649: IF pg_wf_debug = 'Y'
650: THEN
651: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
652: 'content of pg_ocm_add_dp_param_rec');
653: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_credit_request_id = ' ||
654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_credit_request_id);
655: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_case_folder_id = ' ||

Line 653: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_credit_request_id = ' ||

649: IF pg_wf_debug = 'Y'
650: THEN
651: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
652: 'content of pg_ocm_add_dp_param_rec');
653: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_credit_request_id = ' ||
654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_credit_request_id);
655: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_case_folder_id = ' ||
656: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_case_folder_id);
657: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_application_number = ' ||

Line 655: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_case_folder_id = ' ||

651: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
652: 'content of pg_ocm_add_dp_param_rec');
653: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_credit_request_id = ' ||
654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_credit_request_id);
655: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_case_folder_id = ' ||
656: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_case_folder_id);
657: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_application_number = ' ||
658: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_application_number);
659: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column1 = ' ||

Line 657: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_application_number = ' ||

653: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_credit_request_id = ' ||
654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_credit_request_id);
655: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_case_folder_id = ' ||
656: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_case_folder_id);
657: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_application_number = ' ||
658: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_application_number);
659: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column1 = ' ||
660: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
661: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column2 = ' ||

Line 659: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column1 = ' ||

655: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_case_folder_id = ' ||
656: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_case_folder_id);
657: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_application_number = ' ||
658: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_application_number);
659: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column1 = ' ||
660: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
661: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column2 = ' ||
662: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column2);
663: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column3 = ' ||

Line 661: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column2 = ' ||

657: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_application_number = ' ||
658: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_application_number);
659: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column1 = ' ||
660: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
661: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column2 = ' ||
662: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column2);
663: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column3 = ' ||
664: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column3);
665: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_application_id = ' ||

Line 663: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column3 = ' ||

659: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column1 = ' ||
660: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
661: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column2 = ' ||
662: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column2);
663: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column3 = ' ||
664: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column3);
665: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_application_id = ' ||
666: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_application_id);
667: END IF;

Line 665: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_application_id = ' ||

661: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column2 = ' ||
662: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column2);
663: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_source_column3 = ' ||
664: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column3);
665: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,'p_data_point_application_id = ' ||
666: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_application_id);
667: END IF;
668:
669: BEGIN

Line 726: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,

722: END IF;
723:
724: IF pg_wf_debug = 'Y'
725: THEN
726: ar_cmgt_util.wf_debug(pg_ocm_add_dp_param_rec.p_case_folder_id,
727: 'ocm_add_data_points_pkg.getadditionaldatapoints()-');
728: END IF;
729:
730: EXCEPTION