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_FUNDS_CONTROL_UTILS

Line 93: pa_funds_control_utils.print_message('Entering resource mapping');

89: x_err_stage varchar2(200);
90: x_err_code number;
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:

Line 98: pa_funds_control_utils.print_message('Parameters '|| p_project_id ||':RL-'||

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-'||
100: p_person_id ||':J-'||
101: p_job_id ||':O-'||
102: p_organization_id ||':V-'||

Line 143: pa_funds_control_utils.print_message('After get mappable resources ' || l_no_of_resources);

139: x_index => l_index,
140: x_err_stage => x_err_stage,
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:

Line 154: pa_funds_control_utils.print_message('Next resource -- ' || l_resources_in(res_count).resource_list_member_id);

150: mapping_done := TRUE;
151: current_rl_assignment_id :=0;
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

Line 164: pa_funds_control_utils.print_message('Mapping not done');

160: -- Mapping to the next resource list
161: -- Check if resource mapping was done for last resource_list_assigment_id or not
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:

Line 171: pa_funds_control_utils.print_message('Curr resourceid null');

167: END IF;
168:
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

Line 182: pa_funds_control_utils.print_message('Grp category found');

178:
179: current_resource_id := uncl_resource_id;
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;

Line 189: pa_funds_control_utils.print_message('Grp category not found');

185: END IF;
186: current_rl_member_id := uncl_child_member_id;
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;

Line 217: pa_funds_control_utils.print_message('Created resource map');

213: x_system_linkage_function => p_system_linkage_function,
214: x_err_stage => x_err_stage,
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 )

Line 247: pa_funds_control_utils.print_message('RList changed');

243: IF ( current_rl_changed_flag = 'Y' ) THEN -- This resource list assignmnet
244: -- has been 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(

Line 261: pa_funds_control_utils.print_message('RList not changed');

257: x_err_stage => x_err_stage,
258: x_err_code => x_err_code);
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

Line 287: pa_funds_control_utils.print_message('Resource map found RL:' || current_rl_id ||'P:'||

283: x_resource_map_found => resource_map_found,
284: x_err_stage => x_err_stage,
285: x_err_code => x_err_code);
286:
287: pa_funds_control_utils.print_message('Resource map found RL:' || current_rl_id ||'P:'||
288: p_person_id || 'O:' ||
289: p_organization_id || 'RLA:' ||
290: current_rl_assignment_id || 'J:' ||
291: p_job_id || 'V:' ||

Line 321: pa_funds_control_utils.print_message('Mapping done');

317: END IF;
318:
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;

Line 335: pa_funds_control_utils.print_message('Mapping not done 2');

331:
332: END IF; -- IF (current_rl_assignment_id <> p_resource_list_assignment_id ....
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

Line 345: pa_funds_control_utils.print_message('Unclassified');

341:
342: IF ((l_resources_in(res_count).resource_type_code = 'UNCLASSIFIED' OR
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;

Line 355: pa_funds_control_utils.print_message('Exp cat');

351: uncl_group_member_id := l_resources_in(res_count).resource_list_member_id;
352: END IF;
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

Line 367: pa_funds_control_utils.print_message('Rev cat');

363: attr_match_found := FALSE;
364: END IF; --IF ( l_expenditure_category(res_count).....
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

Line 379: pa_funds_control_utils.print_message('Organization');

375: attr_match_found := FALSE;
376: END IF; -- IF (l_revenue_category(res_count) ....
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

Line 393: pa_funds_control_utils.print_message('None');

389:
390: END IF; -- IF ( current_rl_type_code = 'EXPENDITURE_CATEGORY'...
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

Line 411: pa_funds_control_utils.print_message('Uncl');

407:
408: -- Do not match the attributes for an unclassified resource
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;

Line 418: pa_funds_control_utils.print_message('Group level');

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
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;

Line 424: pa_funds_control_utils.print_message('Non group');

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');
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;

Line 435: pa_funds_control_utils.print_message('Personid');

431:
432: IF (NOT (attr_match_found AND
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;

Line 444: pa_funds_control_utils.print_message('Job');

440: END IF;
441: IF (NOT (attr_match_found AND
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;

Line 453: pa_funds_control_utils.print_message('Org id');

449: END IF;
450: IF (NOT (attr_match_found AND
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;

Line 462: pa_funds_control_utils.print_message('Vendor');

458: END IF;
459: IF (NOT (attr_match_found AND
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;

Line 471: pa_funds_control_utils.print_message('Exp type');

467: END IF;
468: IF (NOT (attr_match_found AND
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;

Line 480: pa_funds_control_utils.print_message('Event type');

476: END IF;
477: IF (NOT (attr_match_found AND
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;

Line 489: pa_funds_control_utils.print_message('NLR');

485: END IF;
486: IF (NOT (attr_match_found AND
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;

Line 498: pa_funds_control_utils.print_message('Exp cat');

494: END IF;
495: IF (NOT (attr_match_found AND
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;

Line 508: pa_funds_control_utils.print_message('Rev cat');

504: IF (NOT (attr_match_found AND
505: (NVL(l_resources_in(res_count).revenue_category,NVL(p_revenue_category,'X')) =
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;

Line 517: pa_funds_control_utils.print_message('NLR prgid ');

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)) =
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;

Line 535: pa_funds_control_utils.print_message('Inside rank');

531: END IF;
532:
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

Line 613: pa_funds_control_utils.print_message('End of Resource Mapping, RLMI = ' || x_resource_list_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;
616: EXCEPTION
617: WHEN NO_DATA_FOUND THEN