APPS.GMS_RES_MAP dependencies on PA_DEBUG

Line 2064: -- pa_debug.debug(x_err_stage);

2060: x_resource_map_found := TRUE;
2061: x_resource_list_member_id := NULL;
2062: x_resource_id := NULL;
2063:
2064: -- pa_debug.debug(x_err_stage);
2065:
2066: /* Seperating Map Check for Expenditures based/Event based Txns */
2067:
2068: IF (x_expenditure_type IS NOT NULL) THEN

Line 2160: -- pa_debug.debug(x_err_stage);

2156:
2157: x_err_code := 0;
2158: -- x_err_stage := 'Deleting the resource map for given resource list assignment id';
2159:
2160: -- pa_debug.debug(x_err_stage);
2161: IF (x_resource_list_assignment_id is null) THEN
2162: DELETE
2163: pa_resource_maps;
2164: ELSE

Line 2171: pa_debug.debug('Numbers of Records Deleted = ' || TO_CHAR(SQL%ROWCOUNT));

2167: WHERE
2168: prm.resource_list_assignment_id = x_resource_list_assignment_id;
2169: END IF;
2170:
2171: pa_debug.debug('Numbers of Records Deleted = ' || TO_CHAR(SQL%ROWCOUNT));
2172:
2173: EXCEPTION
2174: WHEN NO_DATA_FOUND THEN
2175: NULL;

Line 2195: -- pa_debug.debug(x_err_stage);

2191:
2192: x_err_code := 0;
2193: -- x_err_stage := 'Deleting the resource map for given project Id';
2194:
2195: -- pa_debug.debug(x_err_stage);
2196:
2197: DELETE
2198: pa_resource_maps prm
2199: WHERE

Line 2209: pa_debug.debug('Numbers of Records Deleted = ' || TO_CHAR(SQL%ROWCOUNT));

2205: WHERE project_id = x_project_id
2206: AND resource_list_id = NVL(x_resource_list_id,resource_list_id)
2207: );
2208:
2209: pa_debug.debug('Numbers of Records Deleted = ' || TO_CHAR(SQL%ROWCOUNT));
2210:
2211: EXCEPTION
2212: WHEN NO_DATA_FOUND THEN
2213: NULL;

Line 2246: -- pa_debug.debug(x_err_stage);

2242:
2243: x_err_code :=0;
2244: --x_err_stage := 'Creating resource map';
2245:
2246: -- pa_debug.debug(x_err_stage);
2247:
2248: INSERT INTO pa_resource_maps
2249: (resource_list_id,
2250: resource_list_assignment_id,

Line 2317: -- pa_debug.debug(x_err_stage);

2313:
2314: x_err_code := 0;
2315: -- x_err_stage := 'Updating resource list assignment status';
2316:
2317: -- pa_debug.debug(x_err_stage);
2318:
2319: UPDATE
2320: pa_resource_list_assignments
2321: SET

Line 2339: pa_debug.debug('Getting Resource List Status');

2335: IS
2336: x_resource_list_changed_flag VARCHAR2(1);
2337: BEGIN
2338:
2339: pa_debug.debug('Getting Resource List Status');
2340:
2341: SELECT
2342: NVL(resource_list_changed_flag,'N')
2343: INTO

Line 2371: pa_debug.debug('Getting Resource Rank');

2367: IS
2368: x_rank NUMBER;
2369: BEGIN
2370:
2371: pa_debug.debug('Getting Resource Rank');
2372:
2373: SELECT
2374: rank
2375: INTO

Line 2403: pa_debug.debug('Getting Resource Type Code');

2399: IS
2400: x_group_resource_type_code VARCHAR2(20);
2401: BEGIN
2402:
2403: pa_debug.debug('Getting Resource Type Code');
2404:
2405: SELECT
2406: rt.resource_type_code
2407: INTO

Line 2447: -- pa_debug.debug(x_err_stage);

2443:
2444: x_err_code :=0;
2445: -- x_err_stage := 'Creating resource accum details';
2446:
2447: -- pa_debug.debug(x_err_stage);
2448:
2449: INSERT INTO pa_resource_accum_details
2450: (resource_list_id,
2451: resource_list_assignment_id,

Line 2522: -- pa_debug.debug(x_err_stage);

2518:
2519: x_err_code :=0;
2520: -- x_err_stage := 'Deleting resource accum details';
2521:
2522: -- pa_debug.debug(x_err_stage);
2523:
2524: IF (x_resource_list_id IS NULL) THEN
2525:
2526: DELETE

Line 2544: pa_debug.debug('Numbers of Records Deleted = ' || TO_CHAR(SQL%ROWCOUNT));

2540: AND project_id = x_project_id;
2541:
2542: END IF;
2543:
2544: pa_debug.debug('Numbers of Records Deleted = ' || TO_CHAR(SQL%ROWCOUNT));
2545:
2546: EXCEPTION
2547: WHEN NO_DATA_FOUND THEN
2548: NULL;

Line 2701: --pa_debug.debug(x_err_stage);

2697: x_no_of_resources := 0;
2698: -- x_err_stage := 'Getting Mappable Resources';
2699:
2700:
2701: --pa_debug.debug(x_err_stage);
2702:
2703: -- get the resource list assignments and process them one by one
2704:
2705: FOR memberrec IN selmembers LOOP

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

2737: x_resource_type_code (x_no_of_resources) := memberrec.resource_type_code;
2738:
2739: END LOOP;
2740:
2741: -- pa_debug.debug('Number of resources found = ' || TO_CHAR(x_no_of_resources));
2742:
2743: EXCEPTION
2744: WHEN NO_DATA_FOUND THEN
2745: NULL;

Line 2996: pa_debug.debug('an old MAP IS FOUND');

2992: return;
2993: END IF; -- IF (resource_map_found)
2994:
2995: if(resource_map_found) THEN
2996: pa_debug.debug('an old MAP IS FOUND');
2997: else
2998: pa_debug.debug('old MAP IS not FOUND');
2999: end if;
3000: END IF;

Line 2998: pa_debug.debug('old MAP IS not FOUND');

2994:
2995: if(resource_map_found) THEN
2996: pa_debug.debug('an old MAP IS FOUND');
2997: else
2998: pa_debug.debug('old MAP IS not FOUND');
2999: end if;
3000: END IF;
3001:
3002: END IF; -- IF (current_rl_assignment_id <> p_resource_list_assignment_id ....