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_RES_ACCUMS dependencies on PA_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

1: PACKAGE BODY PA_RES_ACCUMS AS
2: /* $Header: PARESACB.pls 120.3.12010000.2 2008/10/14 09:06:17 sugupta ship $ */
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
5:
6:
7: -- Initialize function
8:

Line 52: pa_debug.debug('old_map_txns: ' || x_err_stage);

48: x_resource_list_member_id := NULL;
49: x_resource_id := NULL;
50:
51: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
52: pa_debug.debug('old_map_txns: ' || x_err_stage);
53: END IF;
54:
55: /* Seperating Map Check for Expenditures based/Event based Txns */
56:

Line 166: pa_debug.debug('old_map_txns: ' || x_err_stage);

162: x_resource_list_member_id := NULL;
163: x_resource_id := NULL;
164:
165: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
166: pa_debug.debug('old_map_txns: ' || x_err_stage);
167: END IF;
168:
169: /* Seperating Map Check for Expenditures based/Event based Txns */
170:

Line 274: pa_debug.debug('old_map_txns: ' || x_err_stage);

270: x_err_code := 0;
271: x_err_stage := 'Deleting the resource map for given resource list assignment id';
272:
273:
274: pa_debug.debug('old_map_txns: ' || x_err_stage);
275:
276: Loop
277: IF (x_resource_list_assignment_id is null) THEN
278: DELETE

Line 298: pa_debug.debug('old_map_txns: ' || 'Numbers of Records Deleted = ' || TO_CHAR(tot_recs_processed));

294: end if;
295: End loop;
296:
297:
298: pa_debug.debug('old_map_txns: ' || 'Numbers of Records Deleted = ' || TO_CHAR(tot_recs_processed));
299:
300: Completely commented for bug# 1889671 */
301: Null;
302:

Line 328: pa_debug.debug('old_map_txns: ' || x_err_stage);

324: x_err_code := 0;
325: x_err_stage := 'Deleting the resource map for given project Id';
326:
327:
328: pa_debug.debug('old_map_txns: ' || x_err_stage);
329:
330: LOOP
331:
332: DELETE

Line 355: pa_debug.debug('old_map_txns: ' || 'Numbers of Records Deleted = ' || TO_CHAR(tot_recs_processed));

351: end if;
352: End loop;
353:
354:
355: pa_debug.debug('old_map_txns: ' || 'Numbers of Records Deleted = ' || TO_CHAR(tot_recs_processed));
356:
357: Completely commented for bug# 1889671 */
358: Null;
359: EXCEPTION

Line 395: pa_debug.debug('old_map_txns: ' || x_err_stage);

391: x_err_code :=0;
392: x_err_stage := 'Creating resource map';
393:
394: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
395: pa_debug.debug('old_map_txns: ' || x_err_stage);
396: END IF;
397:
398: INSERT INTO pa_resource_maps
399: (resource_list_id,

Line 468: pa_debug.debug('old_map_txns: ' || x_err_stage);

464: x_err_code := 0;
465: x_err_stage := 'Updating resource list assignment status';
466:
467: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
468: pa_debug.debug('old_map_txns: ' || x_err_stage);
469: END IF;
470:
471: UPDATE
472: pa_resource_list_assignments

Line 492: pa_debug.debug('old_map_txns: ' || 'Getting Resource List Status');

488: x_resource_list_changed_flag VARCHAR2(1);
489: BEGIN
490:
491: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
492: pa_debug.debug('old_map_txns: ' || 'Getting Resource List Status');
493: END IF;
494:
495: SELECT
496: NVL(resource_list_changed_flag,'N')

Line 526: pa_debug.debug('old_map_txns: ' || 'Getting Resource Rank');

522: x_rank NUMBER;
523: BEGIN
524:
525: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
526: pa_debug.debug('old_map_txns: ' || 'Getting Resource Rank');
527: END IF;
528:
529: SELECT
530: rank

Line 560: pa_debug.debug('old_map_txns: ' || 'Getting Resource Type Code');

556: x_group_resource_type_code VARCHAR2(20);
557: BEGIN
558:
559: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
560: pa_debug.debug('old_map_txns: ' || 'Getting Resource Type Code');
561: END IF;
562:
563: SELECT
564: rt.resource_type_code

Line 608: pa_debug.debug('old_map_txns: ' || x_err_stage);

604: x_err_code :=0;
605: x_err_stage := 'Creating resource accum details';
606:
607: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
608: pa_debug.debug('old_map_txns: ' || x_err_stage);
609: END IF;
610:
611: INSERT INTO pa_resource_accum_details
612: (resource_list_id,

Line 686: pa_debug.debug('old_map_txns: ' || x_err_stage);

682: x_err_code :=0;
683: x_err_stage := 'Deleting resource accum details';
684:
685: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
686: pa_debug.debug('old_map_txns: ' || x_err_stage);
687: END IF;
688:
689: LOOP
690: IF (x_resource_list_id IS NULL) THEN

Line 727: pa_debug.debug('old_map_txns: ' || 'Numbers of Records Deleted = ' || TO_CHAR(tot_recs_processed));

723: end if;
724: End loop;
725:
726: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
727: pa_debug.debug('old_map_txns: ' || 'Numbers of Records Deleted = ' || TO_CHAR(tot_recs_processed));
728: END IF;
729:
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN

Line 891: pa_debug.debug('old_map_txns: ' || x_err_stage);

887: x_index := 0;
888: x_err_stage := 'Getting Mappable Resources';
889:
890: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
891: pa_debug.debug('old_map_txns: ' || x_err_stage);
892: END IF;
893:
894: -- get the resource list assignments and process them one by one
895:

Line 939: pa_debug.debug('old_map_txns: ' || 'Number of resources found = ' || TO_CHAR(x_no_of_resources));

935:
936: END LOOP;
937:
938: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
939: pa_debug.debug('old_map_txns: ' || 'Number of resources found = ' || TO_CHAR(x_no_of_resources));
940: END IF;
941:
942: EXCEPTION
943: WHEN NO_DATA_FOUND THEN

Line 1071: pa_debug.debug('old_map_txns: ' || x_err_stage);

1067: x_err_stage := 'Maping Transaction to Resources - APR-28';
1068: commit_rows := 0;
1069:
1070: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1071: pa_debug.debug('old_map_txns: ' || x_err_stage);
1072: END IF;
1073:
1074: -- Get the mappable resource for this project
1075: get_mappable_resources

Line 1087: pa_debug.debug('old_map_txns: ' || 'List id= '|| to_char(x_resources_in(res_count).resource_list_id)||

1083: x_err_code);
1084:
1085: /* FOR res_count IN 1..x_no_of_resources LOOP
1086:
1087: pa_debug.debug('old_map_txns: ' || 'List id= '|| to_char(x_resources_in(res_count).resource_list_id)||
1088: ' Res id= '|| to_char(x_resources_in(res_count).resource_id) ||
1089: ' Asgn id= '|| to_char(x_resources_in(res_count).resource_list_assignment_id) ||
1090: ' Member id= '|| to_char(x_resources_in(res_count).resource_list_member_id));
1091:

Line 1111: /* pa_debug.debug('Rescount value is :' || TO_CHAR(res_count)); */

1107: res_count := res_count + 1;
1108: if res_count > x_no_of_resources then
1109: exit;
1110: end if;
1111: /* pa_debug.debug('Rescount value is :' || TO_CHAR(res_count)); */
1112: IF (current_rl_assignment_id <> x_resources_in(res_count).resource_list_assignment_id) THEN
1113:
1114: -- Mapping to the next resource list
1115: -- Check if resource mapping was done for last resource_list_assigment_id or not

Line 1135: pa_debug.debug('old_map_txns: ' || 'Resource mapping=' ||

1131:
1132: END IF; --- IF ( current_resource_id IS NULL )
1133:
1134: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1135: pa_debug.debug('old_map_txns: ' || 'Resource mapping=' ||
1136: to_char(current_rl_member_id)|| ' ' || to_char(current_resource_id));
1137: END IF;
1138:
1139: -- Create a map now

Line 1195: pa_debug.debug('old_map_txns: ' || 'asn id='||current_rl_assignment_id ||

1191: uncl_child_member_id := 0;
1192: uncl_resource_id := 0;
1193:
1194: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1195: pa_debug.debug('old_map_txns: ' || 'asn id='||current_rl_assignment_id ||
1196: ' list id='||current_rl_id ||
1197: ' changed flag='||current_rl_changed_flag ||
1198: ' type code ='||current_rl_type_code );
1199: END IF;

Line 1303: pa_debug.debug('old_map_txns: ' || 'an old MAP IS FOUND');

1299: res_count := x_resource_ind(ind_count).location - 1;
1300: end if;
1301: ------------------------------------------------------------------
1302: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1303: pa_debug.debug('old_map_txns: ' || 'an old MAP IS FOUND');
1304: END IF;
1305: else
1306: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1307: pa_debug.debug('old_map_txns: ' || 'old MAP IS not FOUND');

Line 1307: pa_debug.debug('old_map_txns: ' || 'old MAP IS not FOUND');

1303: pa_debug.debug('old_map_txns: ' || 'an old MAP IS FOUND');
1304: END IF;
1305: else
1306: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1307: pa_debug.debug('old_map_txns: ' || 'old MAP IS not FOUND');
1308: END IF;
1309: end if;
1310: END IF;
1311:

Line 1469: pa_debug.debug('old_map_txns: ' || 'This resource is eligible for mapping');

1465: IF (attr_match_found) THEN
1466:
1467: -- Get the resource rank now
1468: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1469: pa_debug.debug('old_map_txns: ' || 'This resource is eligible for mapping');
1470: END IF;
1471:
1472: IF ( txnaccumrec.event_type_classification IS NOT NULL ) THEN
1473:

Line 1485: pa_debug.debug('old_map_txns: ' || 'Rank for this resource=' || to_char(new_resource_rank));

1481: x_resources_in(res_count).resource_format_id,
1482: txnaccumrec.system_linkage_function);
1483: END IF; -- IF ( txnaccumrec.event_type_classification IS NOT NULL )
1484: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1485: pa_debug.debug('old_map_txns: ' || 'Rank for this resource=' || to_char(new_resource_rank));
1486: END IF;
1487:
1488: IF ( NVL(new_resource_rank,99) < NVL(current_resource_rank,99) ) THEN
1489:

Line 1569: pa_debug.debug('old_map_txns: ' || 'Exception Raised on Procedure map_txns');

1565: -- no records in pa_txn_accum table need to be rolled up
1566:
1567: WHEN NO_DATA_FOUND THEN
1568: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1569: pa_debug.debug('old_map_txns: ' || 'Exception Raised on Procedure map_txns');
1570: END IF;
1571: NULL;
1572: WHEN OTHERS THEN
1573: x_err_code := SQLCODE;

Line 1653: pa_debug.debug('map_txns: ' || x_err_stage);

1649: l_resource_list_assignment_id := c1rec.resource_list_assignment_id;
1650:
1651: x_err_stage := ('Processing for resource list ' || l_resource_list_id);
1652: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1653: pa_debug.debug('map_txns: ' || x_err_stage);
1654: END IF;
1655:
1656: delete from pa_mappable_txns_tmp;
1657:

Line 1794: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount|| ' rows in pa_mappable_txns_tmp ');*/

1790: /*Code Changes for Bug No.2984871 end */
1791:
1792: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1793: /* Commented for Bug 2984871
1794: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount|| ' rows in pa_mappable_txns_tmp ');*/
1795: /*Code Changes for Bug No.2984871 start */
1796: pa_debug.debug('map_txns: ' || 'Inserted ' || l_rowcount || ' rows in pa_mappable_txns_tmp ');
1797: /*Code Changes for Bug No.2984871 end*/
1798: END IF;

Line 1796: pa_debug.debug('map_txns: ' || 'Inserted ' || l_rowcount || ' rows in pa_mappable_txns_tmp ');

1792: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1793: /* Commented for Bug 2984871
1794: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount|| ' rows in pa_mappable_txns_tmp ');*/
1795: /*Code Changes for Bug No.2984871 start */
1796: pa_debug.debug('map_txns: ' || 'Inserted ' || l_rowcount || ' rows in pa_mappable_txns_tmp ');
1797: /*Code Changes for Bug No.2984871 end*/
1798: END IF;
1799: /* Commented for Bug 2984871
1800: IF sql%rowcount = 0 THEN*/

Line 1805: pa_debug.debug('NEW_MAP_TXNS is not called for this resource list since there ' ||

1801: /*Code Changes for Bug No.2984871 start */
1802: IF l_rowcount= 0 THEN
1803: /*Code Changes for Bug No.2984871 end*/
1804: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1805: pa_debug.debug('NEW_MAP_TXNS is not called for this resource list since there ' ||
1806: 'arent any records to process');
1807: END IF;
1808:
1809: ELSE /* PA_MAPPABLE_TXNS_TMP contains records to be processed */

Line 1812: pa_debug.debug('map_txns: ' || 'Calling new mapping api @ ' ||

1808:
1809: ELSE /* PA_MAPPABLE_TXNS_TMP contains records to be processed */
1810:
1811: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1812: pa_debug.debug('map_txns: ' || 'Calling new mapping api @ ' ||
1813: to_CHAR(sysdate,'DD-MON-RR::HH:MI:SS'));
1814: END IF;
1815:
1816: new_map_txns (x_resource_list_id => l_resource_list_id,

Line 1821: pa_debug.debug('map_txns: ' || 'Call returned from new mapping api @ ' ||

1817: x_error_stage => x_err_stage,
1818: x_error_code => x_err_code);
1819:
1820: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1821: pa_debug.debug('map_txns: ' || 'Call returned from new mapping api @ ' ||
1822: to_char(sysdate,'DD-MON-RR::HH:MI:SS'));
1823: END IF;
1824:
1825: DECLARE

Line 1833: pa_debug.debug('map_txns: ' || x_err_stage);

1829:
1830: BEGIN
1831: x_err_stage := 'Inserting into pa_resource_accum_details';
1832: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1833: pa_debug.debug('map_txns: ' || x_err_stage);
1834: END IF;
1835:
1836: INSERT INTO pa_resource_accum_details
1837: (resource_list_id,

Line 1881: pa_debug.debug('map_txns: ' || 'Trying to insert null into PA_RESORCE_ACCUM_DETAILS');

1877: );
1878: EXCEPTION
1879: WHEN NULL_INSERT THEN
1880: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1881: pa_debug.debug('map_txns: ' || 'Trying to insert null into PA_RESORCE_ACCUM_DETAILS');
1882: END IF;
1883: FOR c2rec IN c2 LOOP
1884: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));

Line 1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));

1881: pa_debug.debug('map_txns: ' || 'Trying to insert null into PA_RESORCE_ACCUM_DETAILS');
1882: END IF;
1883: FOR c2rec IN c2 LOOP
1884: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));
1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));
1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));

Line 1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));

1882: END IF;
1883: FOR c2rec IN c2 LOOP
1884: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));
1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));
1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));

Line 1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));

1883: FOR c2rec IN c2 LOOP
1884: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));
1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));
1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);

Line 1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));

1884: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));
1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));
1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);

Line 1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));

1885: pa_debug.debug('map_txns: ' || 'Resource id : ' || to_char(c2rec.resource_id));
1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));
1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);

Line 1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));

1886: pa_debug.debug('map_txns: ' || 'Resource list member id : ' || to_char(c2rec.resource_list_member_id));
1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);

Line 1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);

1887: pa_debug.debug('map_txns: ' || 'Person id : ' || to_char(c2rec.person_id));
1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);

Line 1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);

1888: pa_debug.debug('map_txns: ' || 'Job id : ' || to_char(c2rec.job_id));
1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));

Line 1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);

1889: pa_debug.debug('map_txns: ' || 'Organization id : ' || to_char(c2rec.organization_id));
1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);

Line 1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);

1890: pa_debug.debug('map_txns: ' || 'Vendor_id : ' || to_char(c2rec.vendor_id));
1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);

Line 1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);

1891: pa_debug.debug('map_txns: ' || 'Expenditure type : ' || c2rec.expenditure_type);
1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);

Line 1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));

1892: pa_debug.debug('map_txns: ' || 'Event type : ' || c2rec.event_type);
1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);
1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);

Line 1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);

1893: pa_debug.debug('map_txns: ' || 'Non labor resource : ' || c2rec.non_labor_resource);
1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);
1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);
1901: pa_debug.debug('map_txns: ' || 'System ref3 : task id : ' || c2rec.task_id);

Line 1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);

1894: pa_debug.debug('map_txns: ' || 'Expenditure category : ' || c2rec.expenditure_category);
1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);
1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);
1901: pa_debug.debug('map_txns: ' || 'System ref3 : task id : ' || c2rec.task_id);
1902: END IF;

Line 1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);

1895: pa_debug.debug('map_txns: ' || 'Revenue category : ' || c2rec.revenue_category);
1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);
1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);
1901: pa_debug.debug('map_txns: ' || 'System ref3 : task id : ' || c2rec.task_id);
1902: END IF;
1903: END LOOP;

Line 1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);

1896: pa_debug.debug('map_txns: ' || 'Non-labor Resource org id : ' || to_char(c2rec.non_labor_resource_org_id));
1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);
1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);
1901: pa_debug.debug('map_txns: ' || 'System ref3 : task id : ' || c2rec.task_id);
1902: END IF;
1903: END LOOP;
1904: RAISE;

Line 1901: pa_debug.debug('map_txns: ' || 'System ref3 : task id : ' || c2rec.task_id);

1897: pa_debug.debug('map_txns: ' || 'Event Type Classification : ' || c2rec.event_type_classification);
1898: pa_debug.debug('map_txns: ' || 'System Linkage Function : ' || c2rec.system_linkage_function);
1899: pa_debug.debug('map_txns: ' || 'System ref1 : txn accum id : ' || c2rec.txn_accum_id);
1900: pa_debug.debug('map_txns: ' || 'System ref2 : project id : ' || c2rec.project_id);
1901: pa_debug.debug('map_txns: ' || 'System ref3 : task id : ' || c2rec.task_id);
1902: END IF;
1903: END LOOP;
1904: RAISE;
1905: WHEN OTHERS THEN

Line 1910: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount || ' rows into PA_RESOURCE_ACCUM_DETAILS');

1906: RAISE;
1907: END;
1908:
1909: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1910: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount || ' rows into PA_RESOURCE_ACCUM_DETAILS');
1911: END IF;
1912:
1913: COMMIT;
1914: END IF; /* PA_MAPPABLE_TXNS_TMP%rowcount check */

Line 1923: pa_debug.debug('map_txns: ' || 'Error occurred at ' || x_err_stage || ' error code = ' || x_err_code);

1919: IF x_err_code IS NULL THEN
1920: x_err_code := SQLCODE;
1921: END IF;
1922: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1923: pa_debug.debug('map_txns: ' || 'Error occurred at ' || x_err_stage || ' error code = ' || x_err_code);
1924: END IF;
1925: RAISE;
1926: END map_txns;
1927:

Line 2041: pa_debug.debug('new_map_txns: ' || x_error_stage);

2037: x_error_stage := 'Start of new_map_txns : ' ||
2038: 'Selecting group_resource_type_id ' ||
2039: 'and list level unclassified member';
2040: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2041: pa_debug.debug('new_map_txns: ' || x_error_stage);
2042: END IF;
2043:
2044: /* The following select should always return just one row, i.e.,
2045: one and only one list level unclassified resource should be

Line 2072: pa_debug.debug('new_map_txns: ' || 'Resource List is UNCATEGORIZED');

2068: 'Y','UNCATEGORIZED','UNCLASSIFIED');
2069:
2070: IF l_uncategorized_Flag = 'Y' THEN
2071: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2072: pa_debug.debug('new_map_txns: ' || 'Resource List is UNCATEGORIZED');
2073: END IF;
2074:
2075: UPDATE pa_mappable_txns_tmp PMT
2076: SET resource_list_member_id = l_unclassified_rlm_id

Line 2080: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');

2076: SET resource_list_member_id = l_unclassified_rlm_id
2077: ,resource_id = l_unclassified_res_id
2078: WHERE PMT.resource_list_id = x_resource_list_id;
2079: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2080: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');
2081: END IF;
2082: x_error_stage := 'Mapping done';
2083: Return;
2084: END IF;

Line 2096: pa_debug.debug('new_map_txns: ' || x_error_stage);

2092: x_err_code => x_error_code);
2093:
2094: x_error_stage := 'In case no parent is determined assign list level unclassified';
2095: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2096: pa_debug.debug('new_map_txns: ' || x_error_stage);
2097: END IF;
2098:
2099: /* Point 1.3 : If PARENT_MEMBER_ID is NULL even after the above update, then
2100: those txns will be mapped to resource level UNCLASSIFIED resource.

Line 2112: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows with list level unclassified resource ');

2108: ,resource_id = l_unclassified_res_id
2109: WHERE pmt.parent_member_id is null;
2110:
2111: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2112: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows with list level unclassified resource ');
2113: END IF;
2114:
2115: /* Point 1.4 */
2116:

Line 2127: pa_debug.debug('new_map_txns: ' || x_error_stage);

2123:
2124: x_error_stage := 'Resource list is NOT grouped';
2125:
2126: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2127: pa_debug.debug('new_map_txns: ' || x_error_stage);
2128: END IF;
2129:
2130: /* Point 2.1 */
2131:

Line 2143: pa_debug.debug ('new_map_txns: ' || 'Update PA_MAPPABLE_TXNS_TMP table with resources assigned');

2139:
2140: /* following bulk update logic is irrespective of whether resource list is categorized or not */
2141:
2142: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2143: pa_debug.debug ('new_map_txns: ' || 'Update PA_MAPPABLE_TXNS_TMP table with resources assigned');
2144: END IF;
2145:
2146: /* Bulk update has very consistent time for updations. It takes precisely 30 secs for 50000
2147: updates. The time does not vary whether we do bulk updates in batches of 200 records or in

Line 2187: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');

2183: ,resource_id = l_resource_id_tbl(i)
2184: WHERE txn_id = l_txn_id_tbl(i);
2185:
2186: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2187: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');
2188: END IF;
2189:
2190: l_counter := 1;
2191: END IF;

Line 2208: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');

2204: ,resource_id = l_resource_id_tbl(i)
2205: WHERE txn_id = l_txn_id_tbl(i);
2206:
2207: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2208: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');
2209: END IF;
2210:
2211: END IF;
2212:

Line 2214: pa_debug.debug ('new_map_txns: ' || 'Bulk update done');

2210:
2211: END IF;
2212:
2213: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2214: pa_debug.debug ('new_map_txns: ' || 'Bulk update done');
2215: END IF;
2216:
2217: IF l_group_resource_type_id <> 0 THEN
2218:

Line 2223: pa_debug.debug('new_map_txns: ' || x_error_stage);

2219: /* Point 1.6 */
2220:
2221: x_error_stage := 'Now update with parent level unclassified resource';
2222: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2223: pa_debug.debug('new_map_txns: ' || x_error_stage);
2224: END IF;
2225:
2226: l_counter := 1;
2227:

Line 2255: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');

2251: SET resource_list_member_id = l_resource_member_id_tbl(i)
2252: ,resource_id = l_resource_id_tbl(i)
2253: WHERE txn_id = l_txn_id_tbl(i);
2254: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2255: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');
2256: END IF;
2257:
2258: END IF;
2259:

Line 2268: pa_debug.debug ('new_map_txns: ' || x_error_stage);

2264:
2265: x_error_stage := 'Updating resource_list_member_id with parent_member_id ' ||
2266: 'in case member_id is still null';
2267: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2268: pa_debug.debug ('new_map_txns: ' || x_error_stage);
2269: END IF;
2270:
2271: /* If the RESOURCE_LIST_MEMBER_ID is NULL even at this stage, then assign the
2272: PARENT_MEMBER_ID as the RESOURCE_LIST_MEMBER_ID. Reason being, this is a

Line 2283: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');

2279: WHERE pmt.resource_list_member_id is null
2280: AND pmt.parent_member_id is not null;
2281:
2282: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2283: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');
2284: END IF;
2285:
2286:
2287: ELSE /* if resource list is not grouped */

Line 2295: pa_debug.debug('new_map_txns: ' || x_error_stage);

2291: /* update all txns with resource list level unclassified resource */
2292:
2293: x_error_stage := 'Updating unassigned txns to list level unclassified';
2294: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2295: pa_debug.debug('new_map_txns: ' || x_error_stage);
2296: END IF;
2297:
2298: UPDATE pa_mappable_txns_tmp PMT
2299: SET resource_list_member_id = l_unclassified_rlm_id

Line 2304: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');

2300: ,resource_id = l_unclassified_res_id
2301: WHERE pmt.resource_list_member_id is null;
2302:
2303: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2304: pa_debug.debug('new_map_txns: ' || 'Updated ' || sql%rowcount || ' rows ');
2305: END IF;
2306:
2307: END IF;/* resource list is grouped */
2308:

Line 2321: pa_debug.debug('new_map_txns: ' || 'Error occurred at ' || x_error_stage || ' errcode = ' || x_error_code);

2317: IF x_error_code is null THEN
2318: x_error_code := sqlcode;
2319: END IF;
2320: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2321: pa_debug.debug('new_map_txns: ' || 'Error occurred at ' || x_error_stage || ' errcode = ' || x_error_code);
2322: END IF;
2323: RAISE;
2324: END new_map_txns;
2325:

Line 2334: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);

2330: BEGIN
2331:
2332: x_err_stage := 'Resource list is grouped : Deleting from resource list parents table';
2333: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2334: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);
2335: END IF;
2336:
2337: delete from pa_resource_list_parents_tmp;
2338:

Line 2348: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);

2344: /* Point 1.1 */
2345:
2346: x_err_stage := 'Inserting into pa_resource_list_parents_tmp table';
2347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2348: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);
2349: END IF;
2350:
2351: INSERT INTO pa_resource_list_parents_tmp
2352: (resource_list_id

Line 2374: pa_debug.debug('update_parents_mem_id: ' || 'Inserted ' || sql%rowcount || ' rows into pa_resource_list_parents_tmp');

2370: AND prlm.enabled_flag = 'Y'
2371: );
2372:
2373: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2374: pa_debug.debug('update_parents_mem_id: ' || 'Inserted ' || sql%rowcount || ' rows into pa_resource_list_parents_tmp');
2375: END IF;
2376:
2377: /* Determine parent for each transaction in PA_MAPPABLE_TXNS_TMP.
2378: As parents can be only organizations, expenditure category or revenue category,

Line 2387: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);

2383: /* Point 1.2 */
2384:
2385: x_err_stage := 'Updating the parent member details in PA_MAPPABLE_TXNS_TMP';
2386: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2387: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);
2388: END IF;
2389:
2390: UPDATE pa_mappable_txns_tmp PMT
2391: SET (parent_member_id, parent_resource_id) =

Line 2400: pa_debug.debug('update_parents_mem_id: ' || 'Updated ' || sql%rowcount || ' rows in pa_mappable_txns_tmp with parent member details');

2396: OR pmt.revenue_category = prlp.revenue_category)
2397: AND pmt.resource_list_id = prlp.resource_list_id);
2398:
2399: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2400: pa_debug.debug('update_parents_mem_id: ' || 'Updated ' || sql%rowcount || ' rows in pa_mappable_txns_tmp with parent member details');
2401: END IF;
2402:
2403:
2404: EXCEPTION

Line 2408: pa_debug.debug('Procedure Update_Parents_Mem_Id' || x_err_stage || ' error code = ' || x_err_code);

2404: EXCEPTION
2405: WHEN OTHERS THEN
2406: x_err_code := SQLCODE;
2407: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2408: pa_debug.debug('Procedure Update_Parents_Mem_Id' || x_err_stage || ' error code = ' || x_err_code);
2409: END IF;
2410: RAISE;
2411: END update_parents_mem_id;
2412:

Line 2435: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2431: BEGIN
2432:
2433: x_err_stage := 'Deleting from pa_temp_res_maps_tmp table';
2434: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2435: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2436: END IF;
2437:
2438: DELETE FROM pa_temp_res_maps_tmp;
2439:

Line 2455: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2451: IF C3REC.RESOURCE_TYPE_CODE = 'EMPLOYEE' THEN
2452:
2453: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2454: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2455: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2456: END IF;
2457:
2458: /* During prototyping it has been found that these 8 nuclear inserts work much faster than
2459: one insert having 8 conditions. The one single insert with all 8 conditions combined

Line 2484: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2480: AND temp.resource_list_member_id is null /* resource is not already determined */
2481: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2482:
2483: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2484: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2485: END IF;
2486:
2487: ELSIF C3REC.RESOURCE_TYPE_CODE = 'JOB' THEN
2488:

Line 2491: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2487: ELSIF C3REC.RESOURCE_TYPE_CODE = 'JOB' THEN
2488:
2489: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2490: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2491: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2492: END IF;
2493:
2494: INSERT INTO pa_temp_res_maps_tmp
2495: (SELECT txn_id

Line 2514: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2510: AND temp.resource_list_member_id is null /* resource is not already determined */
2511: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2512:
2513: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2514: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2515: END IF;
2516:
2517: ELSIF C3REC.RESOURCE_TYPE_CODE = 'ORGANIZATION' THEN
2518:

Line 2521: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2517: ELSIF C3REC.RESOURCE_TYPE_CODE = 'ORGANIZATION' THEN
2518:
2519: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2520: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2521: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2522: END IF;
2523:
2524: INSERT INTO pa_temp_res_maps_tmp
2525: (SELECT txn_id

Line 2544: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2540: AND temp.resource_list_member_id is null /* resource is not already determined */
2541: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2542:
2543: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2544: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2545: END IF;
2546:
2547: ELSIF C3REC.RESOURCE_TYPE_CODE = 'REVENUE_CATEGORY' THEN
2548:

Line 2551: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2547: ELSIF C3REC.RESOURCE_TYPE_CODE = 'REVENUE_CATEGORY' THEN
2548:
2549: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2550: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2551: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2552: END IF;
2553:
2554: INSERT INTO pa_temp_res_maps_tmp
2555: (SELECT txn_id

Line 2574: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2570: AND temp.resource_list_member_id is null /* resource is not already determined */
2571: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2572:
2573: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2574: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2575: END IF;
2576:
2577: ELSIF C3REC.RESOURCE_TYPE_CODE = 'VENDOR' THEN
2578:

Line 2581: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2577: ELSIF C3REC.RESOURCE_TYPE_CODE = 'VENDOR' THEN
2578:
2579: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2580: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2581: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2582: END IF;
2583:
2584: INSERT INTO pa_temp_res_maps_tmp
2585: (SELECT txn_id

Line 2604: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2600: AND temp.resource_list_member_id is null /* resource is not already determined */
2601: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2602:
2603: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2604: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2605: END IF;
2606:
2607: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_TYPE' THEN
2608:

Line 2611: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2607: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_TYPE' THEN
2608:
2609: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2610: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2611: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2612: END IF;
2613:
2614: INSERT INTO pa_temp_res_maps_tmp
2615: (SELECT txn_id

Line 2634: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2630: AND temp.resource_list_member_id is null /* resource is not already determined */
2631: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2632:
2633: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2634: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2635: END IF;
2636:
2637: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_CATEGORY' THEN
2638:

Line 2641: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2637: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_CATEGORY' THEN
2638:
2639: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2640: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2641: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2642: END IF;
2643:
2644: INSERT INTO pa_temp_res_maps_tmp
2645: (SELECT txn_id

Line 2664: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2660: AND temp.resource_list_member_id is null /* resource is not already determined */
2661: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2662:
2663: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2664: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2665: END IF;
2666:
2667: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EVENT_TYPE' THEN
2668:

Line 2671: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2667: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EVENT_TYPE' THEN
2668:
2669: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2670: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2671: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2672: END IF;
2673:
2674: INSERT INTO pa_temp_res_maps_tmp
2675: (SELECT txn_id

Line 2694: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2690: AND temp.resource_list_member_id is null /* resource is not already determined */
2691: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2692:
2693: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2694: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2695: END IF;
2696:
2697: ELSIF C3REC.RESOURCE_TYPE_CODE = 'PROJECT_ROLE' THEN
2698:

Line 2701: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);

2697: ELSIF C3REC.RESOURCE_TYPE_CODE = 'PROJECT_ROLE' THEN
2698:
2699: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2700: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2701: pa_debug.debug('ins_temp_res_map_grp: ' || x_err_stage);
2702: END IF;
2703:
2704: INSERT INTO pa_temp_res_maps_tmp
2705: (SELECT txn_id

Line 2724: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2720: AND temp.resource_list_member_id is null /* resource is not already determined */
2721: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2722:
2723: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2724: pa_debug.debug('ins_temp_res_map_grp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2725: END IF;
2726:
2727: END IF;
2728: END LOOP;

Line 2733: pa_debug.debug('Procedure Ins_Temp_Res_Map_Grp ' || x_err_stage || ' error code = ' || x_err_code);

2729: EXCEPTION
2730: WHEN OTHERS THEN
2731: x_err_code := SQLCODE;
2732: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2733: pa_debug.debug('Procedure Ins_Temp_Res_Map_Grp ' || x_err_stage || ' error code = ' || x_err_code);
2734: END IF;
2735: RAISE;
2736: END ins_temp_res_map_grp;
2737:

Line 2758: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2754:
2755: BEGIN
2756: x_err_stage := 'Deleting from pa_temp_res_maps_tmp table';
2757: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2758: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2759: END IF;
2760:
2761: DELETE FROM pa_temp_res_maps_tmp;
2762:

Line 2780: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2776: IF C3REC.RESOURCE_TYPE_CODE = 'EMPLOYEE' THEN
2777:
2778: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2780: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2781: END IF;
2782:
2783: INSERT INTO pa_temp_res_maps_tmp
2784: (SELECT txn_id

Line 2802: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2798: AND temp.resource_list_member_id is null /* resource is not already determined */
2799: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2800:
2801: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2802: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2803: END IF;
2804:
2805: ELSIF C3REC.RESOURCE_TYPE_CODE = 'JOB' THEN
2806:

Line 2809: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2805: ELSIF C3REC.RESOURCE_TYPE_CODE = 'JOB' THEN
2806:
2807: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2808: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2809: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2810: END IF;
2811:
2812: INSERT INTO pa_temp_res_maps_tmp
2813: (SELECT txn_id

Line 2831: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2827: AND temp.resource_list_member_id is null /* resource is not already determined */
2828: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2829:
2830: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2831: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2832: END IF;
2833:
2834: ELSIF C3REC.RESOURCE_TYPE_CODE = 'ORGANIZATION' THEN
2835:

Line 2838: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2834: ELSIF C3REC.RESOURCE_TYPE_CODE = 'ORGANIZATION' THEN
2835:
2836: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2837: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2838: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2839: END IF;
2840:
2841: INSERT INTO pa_temp_res_maps_tmp
2842: (SELECT txn_id

Line 2860: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2856: AND temp.resource_list_member_id is null /* resource is not already determined */
2857: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2858:
2859: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2860: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2861: END IF;
2862:
2863: ELSIF C3REC.RESOURCE_TYPE_CODE = 'REVENUE_CATEGORY' THEN
2864:

Line 2867: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2863: ELSIF C3REC.RESOURCE_TYPE_CODE = 'REVENUE_CATEGORY' THEN
2864:
2865: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2866: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2867: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2868: END IF;
2869:
2870: INSERT INTO pa_temp_res_maps_tmp
2871: (SELECT txn_id

Line 2889: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2885: AND temp.resource_list_member_id is null /* resource is not already determined */
2886: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2887:
2888: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2889: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2890: END IF;
2891:
2892: ELSIF C3REC.RESOURCE_TYPE_CODE = 'VENDOR' THEN
2893:

Line 2896: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2892: ELSIF C3REC.RESOURCE_TYPE_CODE = 'VENDOR' THEN
2893:
2894: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2895: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2896: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2897: END IF;
2898:
2899: INSERT INTO pa_temp_res_maps_tmp
2900: (SELECT txn_id

Line 2918: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2914: AND temp.resource_list_member_id is null /* resource is not already determined */
2915: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2916:
2917: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2918: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2919: END IF;
2920:
2921: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_TYPE' THEN
2922:

Line 2925: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2921: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_TYPE' THEN
2922:
2923: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2924: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2925: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2926: END IF;
2927:
2928: INSERT INTO pa_temp_res_maps_tmp
2929: (SELECT txn_id

Line 2947: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2943: AND temp.resource_list_member_id is null /* resource is not already determined */
2944: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2945:
2946: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2947: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2948: END IF;
2949:
2950: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_CATEGORY' THEN
2951:

Line 2954: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2950: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EXPENDITURE_CATEGORY' THEN
2951:
2952: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2953: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2954: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2955: END IF;
2956:
2957: INSERT INTO pa_temp_res_maps_tmp
2958: (SELECT txn_id

Line 2976: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

2972: AND temp.resource_list_member_id is null /* resource is not already determined */
2973: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
2974:
2975: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2976: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
2977: END IF;
2978:
2979: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EVENT_TYPE' THEN
2980:

Line 2983: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

2979: ELSIF C3REC.RESOURCE_TYPE_CODE = 'EVENT_TYPE' THEN
2980:
2981: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
2982: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2983: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
2984: END IF;
2985:
2986: INSERT INTO pa_temp_res_maps_tmp
2987: (SELECT txn_id

Line 3005: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

3001: AND temp.resource_list_member_id is null /* resource is not already determined */
3002: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
3003:
3004: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3005: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
3006: END IF;
3007:
3008: ELSIF C3REC.RESOURCE_TYPE_CODE = 'PROJECT_ROLE' THEN
3009:

Line 3012: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);

3008: ELSIF C3REC.RESOURCE_TYPE_CODE = 'PROJECT_ROLE' THEN
3009:
3010: x_err_stage := ('Inserting into pa_temp_res_maps_tmp for ' || C3REC.RESOURCE_TYPE_CODE);
3011: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3012: pa_debug.debug('ins_temp_res_map_ungrp: ' || x_err_stage);
3013: END IF;
3014:
3015: INSERT INTO pa_temp_res_maps_tmp
3016: (SELECT txn_id

Line 3034: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');

3030: AND temp.resource_list_member_id is null /* resource is not already determined */
3031: AND NVL(temp.event_type_classification,temp.system_linkage_function) = prfr.txn_class_code);
3032:
3033: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3034: pa_debug.debug('ins_temp_res_map_ungrp: ' || 'Inserted ' || sql%rowcount || ' rows ');
3035: END IF;
3036:
3037: END IF; /* If C3REC.RESOURCE_TYPE_CODE = 'EMPLOYEE' */
3038: END LOOP;

Line 3043: pa_debug.debug('Procedure Ins_Temp_Res_Map_Ungrp ' || x_err_stage || ' error code = ' || x_err_code);

3039: EXCEPTION
3040: WHEN OTHERS THEN
3041: x_err_code := SQLCODE;
3042: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3043: pa_debug.debug('Procedure Ins_Temp_Res_Map_Ungrp ' || x_err_stage || ' error code = ' || x_err_code);
3044: END IF;
3045: RAISE;
3046: END ins_temp_res_map_ungrp;
3047: