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

Line 186: pa_debug.debug('Create_Project PVT: Checking the api version number.');

182:
183: -- Standard call to check for call compatibility
184:
185: if (p_debug_mode = 'Y') then
186: pa_debug.debug('Create_Project PVT: Checking the api version number.');
187: end if;
188:
189: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
190:

Line 204: pa_debug.debug('Create_Project PVT: Calling copy project');

200:
201: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
202:
203: if (p_debug_mode = 'Y') then
204: pa_debug.debug('Create_Project PVT: Calling copy project');
205: end if;
206:
207: if p_project_Value = FND_API.G_MISS_NUM
208: then

Line 365: pa_debug.debug('Create_Project PVT: Checking error messages returned from copy project');

361: --End of changes.
362: );
363:
364: if (p_debug_mode = 'Y') then
365: pa_debug.debug('Create_Project PVT: Checking error messages returned from copy project');
366: end if;
367: IF l_err_code > 0
368: THEN
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 470: pa_debug.debug('Create_Project PVT: Calling create customer private API');

466: --dbms_output.put_line('*** Relationship ... '||l_relationship_type);
467: -- l_relationship_type := 'Primary';
468:
469: if (p_debug_mode = 'Y') then
470: pa_debug.debug('Create_Project PVT: Calling create customer private API');
471: end if;
472: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER
473: ( p_commit => FND_API.G_FALSE ,
474: p_validate_only => p_validate_only ,

Line 508: pa_debug.debug('Create_Project PVT: Calling copy retention API');

504: -- anlee
505: -- Copy rentention
506: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
507: if (p_debug_mode = 'Y') then
508: pa_debug.debug('Create_Project PVT: Calling copy retention API');
509: end if;
510:
511: /* Moved this code to before call to create customer to get enable top task customer flag
512: bug 5690529

Line 741: pa_debug.debug('Create_customer PVT: Calling get customer info API');

737:
738: if (nvl(l_proj_type_class_code,'NONE') = 'CONTRACT') then
739:
740: if (p_debug_mode = 'Y') then
741: pa_debug.debug('Create_customer PVT: Calling get customer info API');
742: end if;
743: pa_customer_info.get_customer_info
744: ( x_customer_id => p_customer_id
745: -- Customer Account Relationship

Line 760: pa_debug.debug('Create_customer PVT: Checking Erorr messages returned from get_customer_info API');

756:
757: -- For this API,error code 10 is a warning.Anything above 10 is an error
758:
759: if (p_debug_mode = 'Y') then
760: pa_debug.debug('Create_customer PVT: Checking Erorr messages returned from get_customer_info API');
761: end if;
762: IF l_err_code > 10
763: THEN
764:

Line 820: pa_debug.debug('Create_customer PVT: Calling create_customer_contacts API');

816: end if;
817: -- Bug 6166197: changes end
818:
819: if (p_debug_mode = 'Y') then
820: pa_debug.debug('Create_customer PVT: Calling create_customer_contacts API');
821: end if;
822: OPEN cur_pa_impl;
823: FETCH cur_pa_impl INTO l_inv_rate_type;
824: CLOSE cur_pa_impl;

Line 879: pa_debug.debug('Create_customer PVT: Checking errors returned from create_customer_contacts API');

875:
876: --dbms_output.put_line('ERROR CODE : CREATE_CUSTOMER : '||to_char(l_err_code));
877:
878: if (p_debug_mode = 'Y') then
879: pa_debug.debug('Create_customer PVT: Checking errors returned from create_customer_contacts API');
880: end if;
881: IF l_err_code > 0
882: THEN
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1227: pa_debug.debug('UPDATE_PROJECT_BASIC_INFO: Calling validate_project_details.');

1223:
1224: x_return_status := 'S';
1225:
1226: if (p_debug_mode = 'Y') then
1227: pa_debug.debug('UPDATE_PROJECT_BASIC_INFO: Calling validate_project_details.');
1228: end if;
1229:
1230: -- Checking Locking Procedures.
1231:

Line 1233: pa_debug.debug('Update_project_basic_info PVT: Locking record');

1229:
1230: -- Checking Locking Procedures.
1231:
1232: if (p_debug_mode = 'Y') then
1233: pa_debug.debug('Update_project_basic_info PVT: Locking record');
1234: end if;
1235: if p_validate_only <> FND_API.G_TRUE then
1236: BEGIN
1237: SELECT 'x' INTO l_dummy

Line 1303: pa_debug.G_err_stage := 'Calling Validate_Basic_Info';

1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301:
1302: if p_validation_level > 0 then
1303: pa_debug.G_err_stage := 'Calling Validate_Basic_Info';
1304:
1305: if (p_debug_mode = 'Y') then
1306: pa_debug.debug('Update_project_basic_info PVT: Calling validate project info API');
1307: end if;

Line 1306: pa_debug.debug('Update_project_basic_info PVT: Calling validate project info API');

1302: if p_validation_level > 0 then
1303: pa_debug.G_err_stage := 'Calling Validate_Basic_Info';
1304:
1305: if (p_debug_mode = 'Y') then
1306: pa_debug.debug('Update_project_basic_info PVT: Calling validate project info API');
1307: end if;
1308:
1309: --Code starts for bug 7204572
1310: l_calling_module := p_calling_module;

Line 1546: pa_debug.debug('Update_project_basic_info PVT: upating pa_projects table');

1542: CLOSE l_get_project_type_id;
1543: -- anlee end of changes
1544:
1545: if (p_debug_mode = 'Y') then
1546: pa_debug.debug('Update_project_basic_info PVT: upating pa_projects table');
1547: end if;
1548:
1549: UPDATE PA_PROJECTS
1550: SET name = l_project_name,

Line 1943: pa_debug.debug('Update_project_additional_info PVT: locking record');

1939:
1940: -- write your program logic from here
1941:
1942: if (p_debug_mode = 'Y') then
1943: pa_debug.debug('Update_project_additional_info PVT: locking record');
1944: end if;
1945:
1946: if p_validate_only <> FND_API.G_TRUE then
1947: BEGIN

Line 2022: pa_debug.G_err_stage := 'Calling validate additional Info';

2018:
2019: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO Project Data ');
2020:
2021: if p_validation_level > 0 then
2022: pa_debug.G_err_stage := 'Calling validate additional Info';
2023: if (p_debug_mode = 'Y') then
2024: pa_debug.debug('Update_project_additional_info PVT: Calling validate project info API');
2025: end if;
2026: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO

Line 2024: pa_debug.debug('Update_project_additional_info PVT: Calling validate project info API');

2020:
2021: if p_validation_level > 0 then
2022: pa_debug.G_err_stage := 'Calling validate additional Info';
2023: if (p_debug_mode = 'Y') then
2024: pa_debug.debug('Update_project_additional_info PVT: Calling validate project info API');
2025: end if;
2026: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO
2027: (
2028: p_validation_level => p_validation_level,

Line 2053: pa_debug.debug('Update_project_additional_info PVT: updating pa_projects table');

2049:
2050: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
2051: THEN
2052: if (p_debug_mode = 'Y') then
2053: pa_debug.debug('Update_project_additional_info PVT: updating pa_projects table');
2054: end if;
2055: /* if p_record_version_number = FND_API.G_MISS_NUM
2056: then
2057: l_record_version_number := 0;

Line 2397: pa_debug.debug('Update_project_pipeline_info PVT: locking record');

2393:
2394: x_return_status := FND_API.G_RET_STS_SUCCESS;
2395:
2396: if (p_debug_mode = 'Y') then
2397: pa_debug.debug('Update_project_pipeline_info PVT: locking record');
2398: end if;
2399: -- write your program logic from here
2400: if p_validate_only <> FND_API.G_TRUE then
2401: BEGIN

Line 2471: pa_debug.G_err_stage := 'Calling validate pipeline Info';

2467: RAISE FND_API.G_EXC_ERROR;
2468: END IF;
2469:
2470: if p_validation_level > 0 then
2471: pa_debug.G_err_stage := 'Calling validate pipeline Info';
2472: if (p_debug_mode = 'Y') then
2473: pa_debug.debug('Update_project_pipeline_info PVT: Calling validate project API');
2474: end if;
2475: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO

Line 2473: pa_debug.debug('Update_project_pipeline_info PVT: Calling validate project API');

2469:
2470: if p_validation_level > 0 then
2471: pa_debug.G_err_stage := 'Calling validate pipeline Info';
2472: if (p_debug_mode = 'Y') then
2473: pa_debug.debug('Update_project_pipeline_info PVT: Calling validate project API');
2474: end if;
2475: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO
2476: ( p_validation_level => p_validation_level,
2477: p_calling_module => 'PIPELINE',

Line 2498: pa_debug.debug('Update_project_pipeline_info PVT: update pa_projects table');

2494: END IF;
2495: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
2496: THEN
2497: if (p_debug_mode = 'Y') then
2498: pa_debug.debug('Update_project_pipeline_info PVT: update pa_projects table');
2499: end if;
2500: if p_probability_member_id = FND_API.G_MISS_NUM
2501: then
2502: l_probability_member_id := null;

Line 2673: pa_debug.debug('create_classification: Calling validate_classifications');

2669: x_return_status := FND_API.G_RET_STS_SUCCESS;
2670: if p_validation_level > 0 then
2671:
2672: if (p_debug_mode = 'Y') then
2673: pa_debug.debug('create_classification: Calling validate_classifications');
2674: end if;
2675:
2676: pa_debug.G_err_stage := 'Calling validate_classifications';
2677:

Line 2676: pa_debug.G_err_stage := 'Calling validate_classifications';

2672: if (p_debug_mode = 'Y') then
2673: pa_debug.debug('create_classification: Calling validate_classifications');
2674: end if;
2675:
2676: pa_debug.G_err_stage := 'Calling validate_classifications';
2677:
2678: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS Before ');
2679:
2680: if (p_debug_mode = 'Y') then

Line 2681: pa_debug.debug('Create classification PVT: Calling validate_classification API ');

2677:
2678: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS Before ');
2679:
2680: if (p_debug_mode = 'Y') then
2681: pa_debug.debug('Create classification PVT: Calling validate_classification API ');
2682: end if;
2683:
2684: l_code_percentage := p_code_percentage;
2685:

Line 2850: pa_debug.debug('Create classification PVT: Calling Table handler to insert new classification record ');

2846: End if;
2847:
2848: --dbms_output.put_line('Pa_project_classes_pkg.insert_row Project Data ');
2849: if (p_debug_mode = 'Y') then
2850: pa_debug.debug('Create classification PVT: Calling Table handler to insert new classification record ');
2851: end if;
2852: pa_project_classes_pkg.insert_row
2853: ( l_row_id
2854: ,p_object_id

Line 3038: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications BEGIN');

3034: -- anlee end of changes
3035:
3036: BEGIN
3037: if (p_debug_mode = 'Y') then
3038: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications BEGIN');
3039: end if;
3040:
3041: if p_commit = FND_API.G_TRUE then
3042: savepoint update_classifications_pvt;

Line 3046: pa_debug.debug('Locking record...');

3042: savepoint update_classifications_pvt;
3043: end if;
3044:
3045: if (p_debug_mode = 'Y') then
3046: pa_debug.debug('Locking record...');
3047: end if;
3048:
3049: if p_validate_only <> FND_API.G_TRUE then
3050: BEGIN

Line 3113: pa_debug.debug('Performing validation...');

3109: end if;
3110:
3111: if p_validation_level > 0 then
3112: if (p_debug_mode = 'Y') then
3113: pa_debug.debug('Performing validation...');
3114: end if;
3115:
3116: l_code_percentage := p_code_percentage;
3117:

Line 3329: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications END');

3325: commit work;
3326: end if;
3327:
3328: if (p_debug_mode = 'Y') then
3329: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications END');
3330: end if;
3331:
3332: EXCEPTION
3333: when FND_API.G_EXC_ERROR then

Line 3415: pa_debug.debug('Validate classification PVT: Calling API to check if catg code can be overridden');

3411:
3412: IF p_calling_module = 'QUICK_ENTRY'
3413: THEN
3414: if (p_debug_mode = 'Y') then
3415: pa_debug.debug('Validate classification PVT: Calling API to check if catg code can be overridden');
3416: end if;
3417: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_OVERRIDE(
3418: p_object_id,
3419: p_class_category,

Line 3434: pa_debug.debug('Validate classification PVT: Calling API to check if category is valid');

3430:
3431: --dbms_output.put_line('CHECK_CLASS_CATG_CAN_OVERRIDE '||l_error_msg_code||'Status :'||l_return_status);
3432:
3433: if (p_debug_mode = 'Y') then
3434: pa_debug.debug('Validate classification PVT: Calling API to check if category is valid');
3435: end if;
3436:
3437: if p_object_type = 'PA_PROJECTS' then
3438: SELECT ppta.project_type_id

Line 3515: pa_debug.debug('Validate classification PVT: Calling API to check if only one catg code can be entered');

3511: end if;
3512:
3513:
3514: if (p_debug_mode = 'Y') then
3515: pa_debug.debug('Validate classification PVT: Calling API to check if only one catg code can be entered');
3516: end if;
3517: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_ONE_ONLY_CODE(
3518: p_object_id,
3519: p_object_type,

Line 3533: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered is a duplicate');

3529:
3530: --dbms_output.put_line('CHECK_DUPLICATE_CLASS_CATG '||l_error_msg_code||'Status :'||l_return_status);
3531:
3532: if (p_debug_mode = 'Y') then
3533: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered is a duplicate');
3534: end if;
3535: PA_PROJECTS_MAINT_UTILS.CHECK_DUPLICATE_CLASS_CATG(
3536: p_object_id,
3537: p_object_type,

Line 3553: pa_debug.debug('Validate classification PVT: Calling API to check if category is valid');

3549:
3550: ELSIF p_action = 'UPDATE' then
3551:
3552: if (p_debug_mode = 'Y') then
3553: pa_debug.debug('Validate classification PVT: Calling API to check if category is valid');
3554: end if;
3555:
3556: if p_object_type = 'PA_PROJECTS' then
3557: SELECT ppta.project_type_id

Line 3641: pa_debug.debug('Validate classification PVT: Calling API to check if only one catg code can be entered');

3637: close C2;
3638:
3639: if l_class_category <> p_class_category then
3640: if (p_debug_mode = 'Y') then
3641: pa_debug.debug('Validate classification PVT: Calling API to check if only one catg code can be entered');
3642: end if;
3643: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_ONE_ONLY_CODE(
3644: p_object_id,
3645: p_object_type,

Line 3660: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered is a duplicate');

3656:
3657: --dbms_output.put_line('CHECK_DUPLICATE_CLASS_CATG '||l_error_msg_code||'Status :'||l_return_status);
3658:
3659: if (p_debug_mode = 'Y') then
3660: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered is a duplicate');
3661: end if;
3662: PA_PROJECTS_MAINT_UTILS.CHECK_DUPLICATE_CLASS_CATG(
3663: p_object_id,
3664: p_object_type,

Line 3680: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered can be deleted');

3676:
3677: ELSIF p_action = 'DELETE' then
3678:
3679: if (p_debug_mode = 'Y') then
3680: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered can be deleted');
3681: end if;
3682: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_DELETE
3683: (p_object_id,
3684: p_object_type,

Line 3793: pa_debug.debug('Delete classification PVT: locking record for deletion');

3789:
3790: x_return_status := FND_API.G_RET_STS_SUCCESS;
3791:
3792: if (p_debug_mode = 'Y') then
3793: pa_debug.debug('Delete classification PVT: locking record for deletion');
3794: end if;
3795: if p_validate_only <> FND_API.G_TRUE then
3796: BEGIN
3797: SELECT rowid INTO l_row_id

Line 3873: pa_debug.G_err_stage := 'Calling validate_classifications';

3869: RAISE FND_API.G_EXC_ERROR;
3870: END IF;
3871:
3872: if p_validation_level > 0 then
3873: pa_debug.G_err_stage := 'Calling validate_classifications';
3874: if (p_debug_mode = 'Y') then
3875: pa_debug.debug('Delete classification PVT: Calling API to validate classfications');
3876: end if;
3877: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

Line 3875: pa_debug.debug('Delete classification PVT: Calling API to validate classfications');

3871:
3872: if p_validation_level > 0 then
3873: pa_debug.G_err_stage := 'Calling validate_classifications';
3874: if (p_debug_mode = 'Y') then
3875: pa_debug.debug('Delete classification PVT: Calling API to validate classfications');
3876: end if;
3877: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
3878: (
3879: p_validation_level => p_validation_level,

Line 3902: pa_debug.debug('Delete classification PVT: Calling table handler to delete classfications record');

3898: END IF;
3899: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
3900: THEN
3901: if (p_debug_mode = 'Y') then
3902: pa_debug.debug('Delete classification PVT: Calling table handler to delete classfications record');
3903: end if;
3904: pa_project_classes_pkg.delete_row
3905: ( l_row_id);
3906:

Line 4335: pa_debug.debug('Validate_project_info PVT: Basic info validation');

4331: end if;
4332: -- anlee end of changes
4333:
4334: if (p_debug_mode = 'Y') then
4335: pa_debug.debug('Validate_project_info PVT: Basic info validation');
4336: end if;
4337: --PROJECT NUMBER
4338: -- Check for implementation defined Project number generation mode
4339: -- If project number generation is automatic then ignore the input

Line 4345: pa_debug.debug('Validate_project_info PVT: project number validation');

4341: -- checks will be done only if the mode was 'MANUAL'
4342:
4343: IF (p_debug_mode = 'Y')
4344: THEN
4345: pa_debug.debug('Validate_project_info PVT: project number validation');
4346: END IF;
4347:
4348: IF PA_PROJECT_UTILS.GetProjNumMode = 'MANUAL' THEN
4349: IF p_project_number IS NOT NULL

Line 4426: pa_debug.debug('Validate_project_info PVT: project name validation');

4422: --PROJECT NAME
4423:
4424: IF (p_debug_mode = 'Y')
4425: THEN
4426: pa_debug.debug('Validate_project_info PVT: project name validation');
4427: END IF;
4428:
4429: IF p_project_name IS NOT NULL
4430: THEN

Line 4456: pa_debug.debug('Validate_project_info PVT: project long name validation');

4452: -- Project Long Name changes
4453:
4454: IF (p_debug_mode = 'Y')
4455: THEN
4456: pa_debug.debug('Validate_project_info PVT: project long name validation');
4457: END IF;
4458:
4459: IF p_long_name IS NOT NULL
4460: THEN

Line 4500: pa_debug.debug('Validate_project_info PVT: project type validation');

4496: -- anlee
4497: -- Added validations for bug 2327927
4498: IF (p_debug_mode = 'Y')
4499: THEN
4500: pa_debug.debug('Validate_project_info PVT: project type validation');
4501: END IF;
4502:
4503: if p_project_Type is not null and p_project_type <> l_project_old_rec.project_type Then
4504:

Line 4888: pa_debug.debug('Validate_project_info PVT: Carrying out Organization validation');

4884: --dbms_output.put_line('Check CARRYING_OUT_ORGANIZATION_ID ... ');
4885:
4886: IF (p_debug_mode = 'Y')
4887: THEN
4888: pa_debug.debug('Validate_project_info PVT: Carrying out Organization validation');
4889: END IF;
4890: --CARRYING_OUT_ORGANIZATION_ID
4891: IF (p_carrying_out_organization_id <> FND_API.G_MISS_NUM
4892: AND p_carrying_out_organization_id IS NOT NULL)

Line 5084: pa_debug.debug('Validate_project_info PVT: Start and completion date validation');

5080: --dbms_output.put_line('Check pa_project_pvt.check_start_end_date ... ');
5081:
5082: IF (p_debug_mode = 'Y')
5083: THEN
5084: pa_debug.debug('Validate_project_info PVT: Start and completion date validation');
5085: END IF;
5086:
5087: l_project_start_date := p_start_date;
5088: l_project_completion_date := p_completion_date;

Line 5185: pa_debug.debug('Validate_project_info PVT: Public sector flag validation');

5181:
5182:
5183: IF (p_debug_mode = 'Y')
5184: THEN
5185: pa_debug.debug('Validate_project_info PVT: Public sector flag validation');
5186: END IF;
5187: IF p_public_sector_flag <> FND_API.G_MISS_CHAR AND
5188: p_public_sector_flag IS NOT NULL
5189: THEN

Line 5203: pa_debug.debug('Validate_project_info PVT: project status validation');

5199:
5200:
5201: IF (p_debug_mode = 'Y')
5202: THEN
5203: pa_debug.debug('Validate_project_info PVT: project status validation');
5204: END IF;
5205:
5206: IF p_project_status_code <> FND_API.G_MISS_CHAR AND
5207: p_project_status_code IS NOT NULL

Line 5361: pa_debug.debug('Validate_project_info PVT: location validation');

5357: close c1;
5358: */
5359: IF (p_debug_mode = 'Y')
5360: THEN
5361: pa_debug.debug('Validate_project_info PVT: location validation');
5362: END IF;
5363: -- Modified for bug 2038542
5364: -- If p_city is not null
5365: -- and p_state_region is not null

Line 5390: pa_debug.debug('Validate_project_info PVT: location

5386: If x_country_code is not null then
5387:
5388: IF (p_debug_mode = 'Y')
5389: THEN
5390: pa_debug.debug('Validate_project_info PVT: location
5391: table handler to insert new record');
5392: End if;
5393: pa_locations_pkg.INSERT_ROW(
5394: p_CITY => p_city,

Line 5418: pa_debug.debug('Validate_project_info PVT: Additional information validation');

5414: -- Cost job group defaulting logic.
5415:
5416: IF (p_debug_mode = 'Y')
5417: THEN
5418: pa_debug.debug('Validate_project_info PVT: Additional information validation');
5419: END IF;
5420: --dbms_output.put_line('INSDIE ADDITIONAL_INFORMATION PROCEDURE ... ');
5421:
5422: IF nvl(p_bill_job_group_id, -999) <>

Line 5428: pa_debug.debug('Validate_project_info PVT: Bill job group validation');

5424: THEN
5425:
5426: IF (p_debug_mode = 'Y')
5427: THEN
5428: pa_debug.debug('Validate_project_info PVT: Bill job group validation');
5429: END IF;
5430: --dbms_output.put_line('BEFORE PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');
5431:
5432: PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ(

Line 5454: pa_debug.debug('Validate_project_info PVT: pipeline validation');

5450: if (p_calling_module like ('PIPELINE')) then
5451:
5452: IF (p_debug_mode = 'Y')
5453: THEN
5454: pa_debug.debug('Validate_project_info PVT: pipeline validation');
5455: END IF;
5456: IF (p_debug_mode = 'Y')
5457: THEN
5458: pa_debug.debug('Validate_project_info PVT: probability member id validation');

Line 5458: pa_debug.debug('Validate_project_info PVT: probability member id validation');

5454: pa_debug.debug('Validate_project_info PVT: pipeline validation');
5455: END IF;
5456: IF (p_debug_mode = 'Y')
5457: THEN
5458: pa_debug.debug('Validate_project_info PVT: probability member id validation');
5459: END IF;
5460:
5461: If (p_project_value is not null and p_project_value < 0) then
5462: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 5591: pa_debug.debug('Update_project_staffing_info PVT: locking record');

5587:
5588: x_return_status := FND_API.G_RET_STS_SUCCESS;
5589:
5590: if (p_debug_mode = 'Y') then
5591: pa_debug.debug('Update_project_staffing_info PVT: locking record');
5592: end if;
5593: -- write your program logic from here
5594: if p_validate_only <> FND_API.G_TRUE then
5595: BEGIN

Line 5668: pa_debug.debug('Update_project_staffing_info PVT: update pa_projects table');

5664:
5665: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
5666: THEN
5667: if (p_debug_mode = 'Y') then
5668: pa_debug.debug('Update_project_staffing_info PVT: update pa_projects table');
5669: end if;
5670: if p_comp_match_weighting = FND_API.G_MISS_NUM then
5671: l_comp_match_weighting := null;
5672: else