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.PA_FC_RES_MAP dependencies on PA_FCK_UTIL

Line 13: pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Entering - Delete Resource Maps');

9: x_return_status OUT NOCOPY VARCHAR2,
10: x_error_message_code OUT NOCOPY VARCHAR2) IS
11: BEGIN
12: IF P_DEBUG_MODE = 'Y' THEN
13: pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Entering - Delete Resource Maps');
14: END IF;
15: x_return_status := fnd_api.g_ret_sts_success;
16:
17: IF (p_resource_list_assignment_id is null) THEN

Line 24: pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Exiting - Delete Resource Maps');

20: DELETE pa_resource_maps prm
21: WHERE prm.resource_list_assignment_id = p_resource_list_assignment_id;
22: END IF;
23: IF P_DEBUG_MODE = 'Y' THEN
24: pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Exiting - Delete Resource Maps');
25: END IF;
26: EXCEPTION
27: WHEN NO_DATA_FOUND THEN
28: NULL;

Line 95: pa_fck_util.debug_msg('map_trans: ' || 'PB:Entering - Resource Mapping');

91:
92: BEGIN
93: pa_funds_control_utils.print_message('Entering resource mapping');
94: IF P_DEBUG_MODE = 'Y' THEN
95: pa_fck_util.debug_msg('map_trans: ' || 'PB:Entering - Resource Mapping');
96: END IF;
97:
98: pa_funds_control_utils.print_message('Parameters '|| p_project_id ||':RL-'||
99: p_res_list_id ||':P-'||

Line 114: pa_fck_util.debug_msg('map_trans: ' || 'PB:Parameters '|| p_project_id ||':RL-'||

110: p_event_type_classification ||':SYS-'||
111: p_system_linkage_function ||':EXP-'||
112: p_exptype );
113: IF P_DEBUG_MODE = 'Y' THEN
114: pa_fck_util.debug_msg('map_trans: ' || 'PB:Parameters '|| p_project_id ||':RL-'||
115: p_res_list_id ||':P-'||
116: p_person_id ||':J-'||
117: p_job_id ||':O-'||
118: p_organization_id ||':V-'||

Line 145: pa_fck_util.debug_msg('map_trans: ' || 'PB:After get mappable resources ' || l_no_of_resources);

141: x_err_code => x_err_code);
142:
143: pa_funds_control_utils.print_message('After get mappable resources ' || l_no_of_resources);
144: IF P_DEBUG_MODE = 'Y' THEN
145: pa_fck_util.debug_msg('map_trans: ' || 'PB:After get mappable resources ' || l_no_of_resources);
146: END IF;
147:
148: -- Now process the transaction
149: -- Get the txns for which mapping is to be done

Line 156: pa_fck_util.debug_msg('map_trans: ' || 'PB:Next resource -- ' || l_resources_in(res_count).resource_list_member_id);

152:
153: FOR res_count IN 1..l_no_of_resources LOOP
154: pa_funds_control_utils.print_message('Next resource -- ' || l_resources_in(res_count).resource_list_member_id);
155: IF P_DEBUG_MODE = 'Y' THEN
156: pa_fck_util.debug_msg('map_trans: ' || 'PB:Next resource -- ' || l_resources_in(res_count).resource_list_member_id);
157: END IF;
158: IF (current_rl_assignment_id <> l_resources_in(res_count).resource_list_assignment_id) THEN
159:
160: -- Mapping to the next resource list

Line 166: pa_fck_util.debug_msg('map_trans: ' || 'PB:Mapping not done');

162:
163: IF ( NOT mapping_done ) THEN
164: pa_funds_control_utils.print_message('Mapping not done');
165: IF P_DEBUG_MODE = 'Y' THEN
166: pa_fck_util.debug_msg('map_trans: ' || 'PB:Mapping not done');
167: END IF;
168:
169: IF ( current_resource_id IS NULL ) THEN -- The last txn_accum could not be mapped
170:

Line 173: pa_fck_util.debug_msg('map_trans: ' || 'PB:Curr resourceid null');

169: IF ( current_resource_id IS NULL ) THEN -- The last txn_accum could not be mapped
170:
171: pa_funds_control_utils.print_message('Curr resourceid null');
172: IF P_DEBUG_MODE = 'Y' THEN
173: pa_fck_util.debug_msg('map_trans: ' || 'PB:Curr resourceid null');
174: END IF;
175: -- Map to unclassified Resource
176: -- also if the group_category_found flag is true than map to unclassfied
177: -- category within the group

Line 184: pa_fck_util.debug_msg('map_trans: ' || 'PB:Grp category found');

180:
181: IF (group_category_found AND uncl_child_member_id <> 0) THEN
182: pa_funds_control_utils.print_message('Grp category found');
183: IF P_DEBUG_MODE = 'Y' THEN
184: pa_fck_util.debug_msg('map_trans: ' || 'PB:Grp category found');
185: END IF;
186: current_rl_member_id := uncl_child_member_id;
187: ELSE
188: current_rl_member_id := uncl_group_member_id;

Line 191: pa_fck_util.debug_msg('map_trans: ' || 'PB:Grp category not found');

187: ELSE
188: current_rl_member_id := uncl_group_member_id;
189: pa_funds_control_utils.print_message('Grp category not found');
190: IF P_DEBUG_MODE = 'Y' THEN
191: pa_fck_util.debug_msg('map_trans: ' || 'PB:Grp category not found');
192: END IF;
193: END IF;
194:
195: END IF; --- IF ( current_resource_id IS NULL )

Line 219: pa_fck_util.debug_msg('map_trans: ' || 'PB:Created resource map');

215: x_err_code => x_err_code);
216:
217: pa_funds_control_utils.print_message('Created resource map');
218: IF P_DEBUG_MODE = 'Y' THEN
219: pa_fck_util.debug_msg('map_trans: ' || 'PB:Created resource map');
220: END IF;
221: END IF; -- IF ( NOT mapping_done )
222:
223: --- Proceed to the next resource list now

Line 249: pa_fck_util.debug_msg('map_trans: ' || 'PB:RList changed');

245: -- delete all the old maps for this resource list assignments
246: -- for all the transactions
247: pa_funds_control_utils.print_message('RList changed');
248: IF P_DEBUG_MODE = 'Y' THEN
249: pa_fck_util.debug_msg('map_trans: ' || 'PB:RList changed');
250: END IF;
251: delete_res_maps_on_asgn_id(
252: p_resource_list_assignment_id => current_rl_assignment_id,
253: x_return_status => x_return_status,

Line 263: pa_fck_util.debug_msg('map_trans: ' || 'PB:RList not changed');

259:
260: ELSIF ( current_rl_changed_flag = 'N' ) THEN
261: pa_funds_control_utils.print_message('RList not changed');
262: IF P_DEBUG_MODE = 'Y' THEN
263: pa_fck_util.debug_msg('map_trans: ' || 'PB:RList not changed');
264: END IF;
265: -- Get the resource map status
266: PA_RES_ACCUMS.get_resource_map
267: (x_resource_list_id => current_rl_id,

Line 303: pa_fck_util.debug_msg('map_trans: ' || 'Resource map found RL:' || current_rl_id ||'P:'||

299: p_event_type_classification || 'SYS:' ||
300: p_system_linkage_function);
301:
302: IF P_DEBUG_MODE = 'Y' THEN
303: pa_fck_util.debug_msg('map_trans: ' || 'Resource map found RL:' || current_rl_id ||'P:'||
304: p_person_id || 'O:' ||
305: p_organization_id || 'RLA:' ||
306: current_rl_assignment_id || 'J:' ||
307: p_job_id || 'V:' ||

Line 323: pa_fck_util.debug_msg('map_trans: ' || 'PB:Mapping done');

319: -- check if a map exist for the given attributes in the map table
320: IF (resource_map_found) THEN
321: pa_funds_control_utils.print_message('Mapping done');
322: IF P_DEBUG_MODE = 'Y' THEN
323: pa_fck_util.debug_msg('map_trans: ' || 'PB:Mapping done');
324: END IF;
325: mapping_done := TRUE;
326: x_resource_list_member_id := old_rl_member_id;
327: return;

Line 337: pa_fck_util.debug_msg('map_trans: ' || 'PB:Mapping not done 2');

333:
334: IF ( NOT mapping_done ) THEN
335: pa_funds_control_utils.print_message('Mapping not done 2');
336: IF P_DEBUG_MODE = 'Y' THEN
337: pa_fck_util.debug_msg('map_trans: ' || 'PB:Mapping not done 2');
338: END IF;
339: -- Mapping still need to be done
340: attr_match_found := TRUE;
341:

Line 347: pa_fck_util.debug_msg('map_trans: ' || 'PB:Unclassified');

343: l_resources_in(res_count).resource_type_code = 'UNCATEGORIZED') AND
344: l_resources_in(res_count).member_level = 1 ) THEN
345: pa_funds_control_utils.print_message('Unclassified');
346: IF P_DEBUG_MODE = 'Y' THEN
347: pa_fck_util.debug_msg('map_trans: ' || 'PB:Unclassified');
348: END IF;
349: attr_match_found := FALSE;
350: uncl_resource_id := l_resources_in(res_count).resource_id;
351: uncl_group_member_id := l_resources_in(res_count).resource_list_member_id;

Line 357: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exp cat');

353:
354: IF ( current_rl_type_code = 'EXPENDITURE_CATEGORY') THEN
355: pa_funds_control_utils.print_message('Exp cat');
356: IF P_DEBUG_MODE = 'Y' THEN
357: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exp cat');
358: END IF;
359: -- The resource list is based on the expenditure category
360: IF ( l_resources_in(res_count).expenditure_category = p_expenditure_category) THEN
361: group_category_found := TRUE;

Line 369: pa_fck_util.debug_msg('map_trans: ' || 'PB:Rev cat');

365:
366: ELSIF ( current_rl_type_code = 'REVENUE_CATEGORY' ) THEN
367: pa_funds_control_utils.print_message('Rev cat');
368: IF P_DEBUG_MODE = 'Y' THEN
369: pa_fck_util.debug_msg('map_trans: ' || 'PB:Rev cat');
370: END IF;
371: -- The resource list is based on the revenue category
372: IF (l_resources_in(res_count).revenue_category = p_revenue_category) THEN
373: group_category_found := TRUE;

Line 381: pa_fck_util.debug_msg('map_trans: ' || 'PB:Organization');

377:
378: ELSIF ( current_rl_type_code = 'ORGANIZATION' ) THEN
379: pa_funds_control_utils.print_message('Organization');
380: IF P_DEBUG_MODE = 'Y' THEN
381: pa_fck_util.debug_msg('map_trans: ' || 'PB:Organization');
382: END IF;
383: -- The resource list is based on the organization
384: IF (l_resources_in(res_count).organization_id = p_organization_id) THEN
385: group_category_found := TRUE;

Line 395: pa_fck_util.debug_msg('map_trans: ' || 'PB:None');

391:
392: IF ( current_rl_type_code = 'NONE' OR attr_match_found ) THEN
393: pa_funds_control_utils.print_message('None');
394: IF P_DEBUG_MODE = 'Y' THEN
395: pa_fck_util.debug_msg('map_trans: ' || 'PB:None');
396: END IF;
397: -- The resource list is based on the none category
398: -- Now compare the txn attributes with resource attributes
399: -- The table given below determines if the resource is eligible

Line 413: pa_fck_util.debug_msg('map_trans: ' || 'PB:Uncl');

409:
410: IF (l_resources_in(res_count).resource_type_code = 'UNCLASSIFIED' ) THEN
411: pa_funds_control_utils.print_message('Uncl');
412: IF P_DEBUG_MODE = 'Y' THEN
413: pa_fck_util.debug_msg('map_trans: ' || 'PB:Uncl');
414: END IF;
415: attr_match_found := FALSE;
416: uncl_resource_id := l_resources_in(res_count).resource_id;
417: IF ( l_resources_in(res_count).member_level = 1 ) THEN -- group level unclassified

Line 420: pa_fck_util.debug_msg('map_trans: ' || 'PB:Group level');

416: uncl_resource_id := l_resources_in(res_count).resource_id;
417: IF ( l_resources_in(res_count).member_level = 1 ) THEN -- group level unclassified
418: pa_funds_control_utils.print_message('Group level');
419: IF P_DEBUG_MODE = 'Y' THEN
420: pa_fck_util.debug_msg('map_trans: ' || 'PB:Group level');
421: END IF;
422: uncl_group_member_id := l_resources_in(res_count).resource_list_member_id;
423: ELSE
424: pa_funds_control_utils.print_message('Non group');

Line 426: pa_fck_util.debug_msg('map_trans: ' || 'PB:Non group');

422: uncl_group_member_id := l_resources_in(res_count).resource_list_member_id;
423: ELSE
424: pa_funds_control_utils.print_message('Non group');
425: IF P_DEBUG_MODE = 'Y' THEN
426: pa_fck_util.debug_msg('map_trans: ' || 'PB:Non group');
427: END IF;
428: uncl_child_member_id := l_resources_in(res_count).resource_list_member_id;
429: END IF;
430: END IF;

Line 437: pa_fck_util.debug_msg('map_trans: ' || 'PB:Personid');

433: (NVL(l_resources_in(res_count).person_id,NVL(p_person_id,-1)) =
434: NVL(p_person_id, -1)))) THEN
435: pa_funds_control_utils.print_message('Personid');
436: IF P_DEBUG_MODE = 'Y' THEN
437: pa_fck_util.debug_msg('map_trans: ' || 'PB:Personid');
438: END IF;
439: attr_match_found := FALSE;
440: END IF;
441: IF (NOT (attr_match_found AND

Line 446: pa_fck_util.debug_msg('map_trans: ' || 'PB:Job');

442: (NVL(l_resources_in(res_count).job_id,NVL(p_job_id,-1)) =
443: NVL(p_job_id, -1)))) THEN
444: pa_funds_control_utils.print_message('Job');
445: IF P_DEBUG_MODE = 'Y' THEN
446: pa_fck_util.debug_msg('map_trans: ' || 'PB:Job');
447: END IF;
448: attr_match_found := FALSE;
449: END IF;
450: IF (NOT (attr_match_found AND

Line 455: pa_fck_util.debug_msg('map_trans: ' || 'PB:Org id');

451: (NVL(l_resources_in(res_count).organization_id,NVL(p_organization_id,-1)) =
452: NVL(p_organization_id, -1)))) THEN
453: pa_funds_control_utils.print_message('Org id');
454: IF P_DEBUG_MODE = 'Y' THEN
455: pa_fck_util.debug_msg('map_trans: ' || 'PB:Org id');
456: END IF;
457: attr_match_found := FALSE;
458: END IF;
459: IF (NOT (attr_match_found AND

Line 464: pa_fck_util.debug_msg('map_trans: ' || 'PB:Vendor');

460: (NVL(l_resources_in(res_count).vendor_id,NVL(p_vendor_id,-1)) =
461: NVL(p_vendor_id, -1)))) THEN
462: pa_funds_control_utils.print_message('Vendor');
463: IF P_DEBUG_MODE = 'Y' THEN
464: pa_fck_util.debug_msg('map_trans: ' || 'PB:Vendor');
465: END IF;
466: attr_match_found := FALSE;
467: END IF;
468: IF (NOT (attr_match_found AND

Line 473: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exp type');

469: (NVL(l_resources_in(res_count).expenditure_type,NVL(p_expenditure_type,'X')) =
470: NVL(p_expenditure_type, 'X')))) THEN
471: pa_funds_control_utils.print_message('Exp type');
472: IF P_DEBUG_MODE = 'Y' THEN
473: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exp type');
474: END IF;
475: attr_match_found := FALSE;
476: END IF;
477: IF (NOT (attr_match_found AND

Line 482: pa_fck_util.debug_msg('map_trans: ' || 'PB:Event type');

478: (NVL(l_resources_in(res_count).event_type,NVL(p_event_type,'X')) =
479: NVL(p_event_type, 'X')))) THEN
480: pa_funds_control_utils.print_message('Event type');
481: IF P_DEBUG_MODE = 'Y' THEN
482: pa_fck_util.debug_msg('map_trans: ' || 'PB:Event type');
483: END IF;
484: attr_match_found := FALSE;
485: END IF;
486: IF (NOT (attr_match_found AND

Line 491: pa_fck_util.debug_msg('map_trans: ' || 'PB:NLR');

487: (NVL(l_resources_in(res_count).non_labor_resource,NVL(p_non_labor_resource,'X')) =
488: NVL(p_non_labor_resource, 'X')))) THEN
489: pa_funds_control_utils.print_message('NLR');
490: IF P_DEBUG_MODE = 'Y' THEN
491: pa_fck_util.debug_msg('map_trans: ' || 'PB:NLR');
492: END IF;
493: attr_match_found := FALSE;
494: END IF;
495: IF (NOT (attr_match_found AND

Line 500: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exp cat');

496: (NVL(l_resources_in(res_count).expenditure_category,NVL(p_expenditure_category,'X')) =
497: NVL(p_expenditure_category, 'X')))) THEN
498: pa_funds_control_utils.print_message('Exp cat');
499: IF P_DEBUG_MODE = 'Y' THEN
500: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exp cat');
501: END IF;
502: attr_match_found := FALSE;
503: END IF;
504: IF (NOT (attr_match_found AND

Line 510: pa_fck_util.debug_msg('map_trans: ' || 'PB:Rev cat');

506: NVL(p_revenue_category,'X')))) THEN
507: attr_match_found := FALSE;
508: pa_funds_control_utils.print_message('Rev cat');
509: IF P_DEBUG_MODE = 'Y' THEN
510: pa_fck_util.debug_msg('map_trans: ' || 'PB:Rev cat');
511: END IF;
512: END IF;
513: IF (NOT (attr_match_found AND
514: (NVL(l_resources_in(res_count).non_labor_resource_org_id,NVL(p_non_labor_resource_org_id,-1)) =

Line 519: pa_fck_util.debug_msg('map_trans: ' || 'PB:NLR prgid ');

515: NVL(p_non_labor_resource_org_id,-1)))) THEN
516: attr_match_found := FALSE;
517: pa_funds_control_utils.print_message('NLR prgid ');
518: IF P_DEBUG_MODE = 'Y' THEN
519: pa_fck_util.debug_msg('map_trans: ' || 'PB:NLR prgid ');
520: END IF;
521: END IF;
522: IF (NOT (attr_match_found AND
523: (NVL(l_resources_in(res_count).event_type_classification,NVL(p_event_type_classification,'X')) =

Line 537: pa_fck_util.debug_msg('map_trans: ' || 'PB:Inside rank');

533: END IF; --IF ( current_rl_type_code = 'NONE'......
534: IF (attr_match_found) THEN
535: pa_funds_control_utils.print_message('Inside rank');
536: IF P_DEBUG_MODE = 'Y' THEN
537: pa_fck_util.debug_msg('map_trans: ' || 'PB:Inside rank');
538: END IF;
539: -- Get the resource rank now
540: IF ( p_event_type_classification IS NOT NULL ) THEN
541: -- determine the rank based on event_type_classification

Line 611: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exiting - Resource Mapping, RLMI = '|| x_resource_list_member_id);

607:
608: x_resource_list_member_id := current_rl_member_id;
609:
610: IF P_DEBUG_MODE = 'Y' THEN
611: pa_fck_util.debug_msg('map_trans: ' || 'PB:Exiting - Resource Mapping, RLMI = '|| x_resource_list_member_id);
612: END IF;
613: pa_funds_control_utils.print_message('End of Resource Mapping, RLMI = ' || x_resource_list_member_id);
614:
615: PA_DEBUG.reset_err_stack;