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

Line 173: pa_debug.debug('Create_Project PUB : Checking the api version number.');

169:
170: -- Standard call to check for call compatibility
171:
172: if (p_debug_mode = 'Y') then
173: pa_debug.debug('Create_Project PUB : Checking the api version number.');
174: end if;
175:
176: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PUB.CREATE_PROJECT ... ');
177:

Line 195: pa_debug.debug('CREATE_PROJECT PUB : Initializing message stack.');

191:
192: -- Initialize the message stack if required
193:
194: if (p_debug_mode = 'Y') then
195: pa_debug.debug('CREATE_PROJECT PUB : Initializing message stack.');
196: end if;
197:
198: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_PROJECT');
199:

Line 198: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_PROJECT');

194: if (p_debug_mode = 'Y') then
195: pa_debug.debug('CREATE_PROJECT PUB : Initializing message stack.');
196: end if;
197:
198: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_PROJECT');
199:
200: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
201: fnd_msg_pub.initialize;
202: end if;

Line 216: pa_debug.debug('Create_Project PUB : Checking Carrying out organization');

212: (p_organization_name is not null AND
213: p_organization_name <> FND_API.G_MISS_CHAR)
214: THEN
215: if (p_debug_mode = 'Y') then
216: pa_debug.debug('Create_Project PUB : Checking Carrying out organization');
217: end if;
218: pa_hr_org_utils.Check_OrgName_Or_Id
219: ( p_organization_id => p_carrying_out_organization_id
220: ,p_organization_name => p_organization_name

Line 250: pa_debug.debug('Create_Project PUB : Checking Project status');

246:
247: --dbms_output.put_line('IN p_project_status_code ... ');
248:
249: if (p_debug_mode = 'Y') then
250: pa_debug.debug('Create_Project PUB : Checking Project status');
251: end if;
252:
253: PA_PROJECTS_MAINT_UTILS.CHECK_PROJECT_STATUS_OR_ID
254: (p_project_status_code => p_project_status_code

Line 284: pa_debug.debug('Create_Project PUB : Checking Probability code');

280: (p_probability_percentage is not null AND
281: p_probability_percentage <> FND_API.G_MISS_NUM)
282: THEN
283: if (p_debug_mode = 'Y') then
284: pa_debug.debug('Create_Project PUB : Checking Probability code');
285: end if;
286: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CODE_OR_ID
287: ( p_probability_member_id => p_probability_member_id
288: ,p_probability_percentage => p_probability_percentage

Line 315: pa_debug.debug('Create_Project PUB : Checking Customer code');

311: AND p_customer_id <> FND_API.G_MISS_NUM) OR
312: (p_customer_name is not null AND p_customer_name <> FND_API.G_MISS_CHAR)
313: THEN
314: if (p_debug_mode = 'Y') then
315: pa_debug.debug('Create_Project PUB : Checking Customer code');
316: end if;
317: --dbms_output.put_line('Before check customer or customer call ... ');
318: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
319: ( p_customer_id => p_customer_id

Line 344: pa_debug.debug('Create_Project PUB : Checking Bill Customer');

340: AND p_bill_to_customer_id <> FND_API.G_MISS_NUM) OR
341: (p_bill_to_customer_name is not null AND p_bill_to_customer_name <> FND_API.G_MISS_CHAR)
342: THEN
343: if (p_debug_mode = 'Y') then
344: pa_debug.debug('Create_Project PUB : Checking Bill Customer');
345: end if;
346:
347: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
348: ( p_customer_id => p_bill_to_customer_id

Line 371: pa_debug.debug('Create_Project PUB : Checking Ship Customer');

367: AND p_ship_to_customer_id <> FND_API.G_MISS_NUM) OR
368: (p_ship_to_customer_name is not null AND p_ship_to_customer_name <> FND_API.G_MISS_CHAR)
369: THEN
370: if (p_debug_mode = 'Y') then
371: pa_debug.debug('Create_Project PUB : Checking Ship Customer');
372: end if;
373:
374: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
375: ( p_customer_id => p_ship_to_customer_id

Line 398: pa_debug.debug('Create_Project PUB : Checking team template ID');

394: if (p_team_template_id is not null AND p_team_template_id <> FND_API.G_MISS_NUM) OR
395: (p_team_template_name is not null AND p_team_template_name <> FND_API.G_MISS_CHAR)
396: then
397: if (p_debug_mode = 'Y') then
398: pa_debug.debug('Create_Project PUB : Checking team template ID');
399: end if;
400:
401: PA_TEAM_TEMPLATES_UTILS.CHECK_TEAM_TEMPLATE_NAME_OR_ID
402: ( p_team_template_id => p_team_template_id

Line 422: pa_debug.debug('Create_Project PUB : Checking country code');

418: if (p_country_code is not null AND p_country_code <> FND_API.G_MISS_CHAR) OR
419: (p_country_name is not null AND p_country_name <> FND_API.G_MISS_CHAR)
420: then
421: if (p_debug_mode = 'Y') then
422: pa_debug.debug('Create_Project PUB : Checking country code');
423: end if;
424:
425: PA_LOCATION_UTILS.CHECK_COUNTRY_NAME_OR_CODE
426: ( p_country_code => p_country_code

Line 446: pa_debug.debug('Create_Project PUB : Checking agreement currency');

442: if (p_agreement_currency is not null AND p_agreement_currency <> FND_API.G_MISS_CHAR) OR
443: (p_agreement_currency_name is not null AND p_agreement_currency_name <> FND_API.G_MISS_CHAR)
444: then
445: if (p_debug_mode = 'Y') then
446: pa_debug.debug('Create_Project PUB : Checking agreement currency');
447: end if;
448:
449: PA_PROJECTS_MAINT_UTILS.CHECK_CURRENCY_NAME_OR_CODE
450: ( p_agreement_currency => p_agreement_currency

Line 470: pa_debug.debug('Create_Project PUB : Checking Opportunity Value currency');

466: (p_opp_value_currency_name is not null AND p_opp_value_currency_name <> FND_API.G_MISS_CHAR
467: )
468: then
469: if (p_debug_mode = 'Y') then
470: pa_debug.debug('Create_Project PUB : Checking Opportunity Value currency');
471: end if;
472:
473: PA_PROJECTS_MAINT_UTILS.CHECK_CURRENCY_NAME_OR_CODE
474: ( p_agreement_currency => p_opp_value_currency_code

Line 495: pa_debug.debug('Create_Project PUB : Checking agreement org');

491: if (p_agreement_org_id is not null AND p_agreement_org_id <> FND_API.G_MISS_NUM) OR
492: (p_agreement_org_name is not null AND p_agreement_org_name <> FND_API.G_MISS_CHAR)
493: then
494: if (p_debug_mode = 'Y') then
495: pa_debug.debug('Create_Project PUB : Checking agreement org');
496: end if;
497:
498: PA_PROJECTS_MAINT_UTILS.CHECK_AGREEMENT_ORG_NAME_OR_ID
499: ( p_agreement_org_id => p_agreement_org_id

Line 516: pa_debug.debug('Create_Project PUB : checking message count');

512: end if;
513:
514:
515: if (p_debug_mode = 'Y') then
516: pa_debug.debug('Create_Project PUB : checking message count');
517: end if;
518:
519: l_msg_count := FND_MSG_PUB.count_msg;
520: If l_msg_count > 0 THEN

Line 555: pa_debug.debug('Create_Project PUB : Calling private api Create_project');

551: /* For Bug 2731449 modified p_bill_to_customer_id to l_bill_to_customer_id
552: and p_ship_to_customer_id to l_ship_to_customer_id */
553:
554: if (p_debug_mode = 'Y') then
555: pa_debug.debug('Create_Project PUB : Calling private api Create_project');
556: end if;
557:
558: PA_PROJECTS_MAINT_PVT.CREATE_PROJECT
559: (

Line 607: pa_debug.debug('Create_Project PUB : checking message count');

603: x_msg_count => l_msg_count,
604: x_msg_data => l_msg_data);
605:
606: if (p_debug_mode = 'Y') then
607: pa_debug.debug('Create_Project PUB : checking message count');
608: end if;
609: --dbms_output.put_line('After PRIVATE API call ... '||l_return_status);
610:
611: l_msg_count := FND_MSG_PUB.count_msg;

Line 755: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_CUSTOMER');

751: THEN
752: SAVEPOINT create_customer;
753: END IF;
754:
755: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_CUSTOMER');
756:
757: if (p_debug_mode = 'Y') then
758: pa_debug.debug('Create_Customer PUB : checking API compatibility');
759: end if;

Line 758: pa_debug.debug('Create_Customer PUB : checking API compatibility');

754:
755: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_CUSTOMER');
756:
757: if (p_debug_mode = 'Y') then
758: pa_debug.debug('Create_Customer PUB : checking API compatibility');
759: end if;
760: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
761: p_api_version,
762: l_api_name,

Line 785: pa_debug.debug('Create_Customer PUB : checking Customer code');

781: (p_customer_name is not null AND
782: p_customer_name <> FND_API.G_MISS_CHAR )
783: THEN
784: if (p_debug_mode = 'Y') then
785: pa_debug.debug('Create_Customer PUB : checking Customer code');
786: end if;
787: --dbms_output.put_line('Before check customer or id call ... ');
788: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CUSTOMER_NAME_OR_ID
789: ( p_customer_id => p_customer_id

Line 813: pa_debug.debug('Create_Customer PUB : calling Create_customer private API');

809: l_return_status := FND_API.G_MISS_CHAR;
810: l_error_msg_code := FND_API.G_MISS_CHAR;
811:
812: if (p_debug_mode = 'Y') then
813: pa_debug.debug('Create_Customer PUB : calling Create_customer private API');
814: end if;
815:
816: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER
817: ( p_commit => FND_API.G_FALSE ,

Line 856: pa_debug.debug('Create_Customer PUB : Checking Message Count');

852: x_msg_count := l_msg_count;
853: END IF;
854:
855: if (p_debug_mode = 'Y') then
856: pa_debug.debug('Create_Customer PUB : Checking Message Count');
857: end if;
858:
859: IF l_msg_count > 0 THEN
860: x_return_status := 'E';

Line 1032: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_basic_info');

1028: IF p_commit = FND_API.G_TRUE THEN
1029: SAVEPOINT update_project_basic_info;
1030: END IF;
1031:
1032: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_basic_info');
1033:
1034: --dbms_output.put_line('Starts here FND_API.COMPATIBLE_API_CALL ... ');
1035:
1036: if (p_debug_mode = 'Y') then

Line 1037: pa_debug.debug('Update_project_basic_info PUB : Checking API compatibility');

1033:
1034: --dbms_output.put_line('Starts here FND_API.COMPATIBLE_API_CALL ... ');
1035:
1036: if (p_debug_mode = 'Y') then
1037: pa_debug.debug('Update_project_basic_info PUB : Checking API compatibility');
1038: end if;
1039:
1040: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1041: p_api_version,

Line 1077: pa_debug.debug('Update_project_basic_info PUB : Checking Carrying out org');

1073: (p_organization_name is not null AND
1074: p_organization_name <> FND_API.G_MISS_CHAR)
1075: THEN
1076: if (p_debug_mode = 'Y') then
1077: pa_debug.debug('Update_project_basic_info PUB : Checking Carrying out org');
1078: end if;
1079: --dbms_output.put_line(' before check_org name or_id');
1080: pa_hr_org_utils.Check_OrgName_Or_Id
1081: (p_organization_id => p_carrying_out_organization_id

Line 1126: pa_debug.debug('Update_project_basic_info PUB : Checking message count');

1122: x_msg_count := l_msg_count;
1123: END IF;
1124:
1125: if (p_debug_mode = 'Y') then
1126: pa_debug.debug('Update_project_basic_info PUB : Checking message count');
1127: end if;
1128:
1129: IF l_msg_count > 0 THEN
1130: x_return_status := 'E';

Line 1136: pa_debug.debug('Update_project_basic_info PUB : Calling private API update_project_basic_info');

1132: END IF;
1133: */
1134: --dbms_output.put_line(' location **** '||to_char(p_location_id));
1135: if (p_debug_mode = 'Y') then
1136: pa_debug.debug('Update_project_basic_info PUB : Calling private API update_project_basic_info');
1137: end if;
1138: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_BASIC_INFO
1139: (
1140: p_commit => FND_API.G_FALSE,

Line 1191: pa_debug.debug('Update_project_basic_info PUB : Checking message count');

1187: x_msg_count => l_msg_count,
1188: x_msg_data => l_msg_data);
1189:
1190: if (p_debug_mode = 'Y') then
1191: pa_debug.debug('Update_project_basic_info PUB : Checking message count');
1192: end if;
1193: l_msg_count := FND_MSG_PUB.count_msg;
1194: If l_msg_count > 0 THEN
1195: x_msg_count := l_msg_count;

Line 1349: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_additional_info');

1345: IF p_commit = FND_API.G_TRUE THEN
1346: SAVEPOINT update_project_additional_info;
1347: END IF;
1348:
1349: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_additional_info');
1350:
1351: if (p_debug_mode = 'Y') then
1352: pa_debug.debug('Update_project_Additional_info PUB : Checking API Compatibility');
1353: end if;

Line 1352: pa_debug.debug('Update_project_Additional_info PUB : Checking API Compatibility');

1348:
1349: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_additional_info');
1350:
1351: if (p_debug_mode = 'Y') then
1352: pa_debug.debug('Update_project_Additional_info PUB : Checking API Compatibility');
1353: end if;
1354: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1355: p_api_version,
1356: l_api_name,

Line 1377: pa_debug.debug('Update_Project_additional_info PUB : Checking calendar');

1373: (p_calendar_name is not null AND
1374: p_calendar_name <> FND_API.G_MISS_CHAR)
1375: THEN
1376: if (p_debug_mode = 'Y') then
1377: pa_debug.debug('Update_Project_additional_info PUB : Checking calendar');
1378: end if;
1379: PA_CALENDAR_UTILS.CHECK_CALENDAR_NAME_OR_ID
1380: ( p_calendar_id => p_calendar_id
1381: ,p_calendar_name => p_calendar_name

Line 1440: pa_debug.debug('Update_project_Additional_info PUB : Calling private API Update_project_additional_info ');

1436: RAISE FND_API.G_EXC_ERROR;
1437: end if;
1438: */
1439: if (p_debug_mode = 'Y') then
1440: pa_debug.debug('Update_project_Additional_info PUB : Calling private API Update_project_additional_info ');
1441: end if;
1442:
1443: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
1444:

Line 1480: pa_debug.debug('Update_project_Additional_info PUB : Checking message count');

1476: x_msg_count => l_msg_count,
1477: x_msg_data => l_msg_data);
1478:
1479: if (p_debug_mode = 'Y') then
1480: pa_debug.debug('Update_project_Additional_info PUB : Checking message count');
1481: end if;
1482: l_msg_count := FND_MSG_PUB.count_msg;
1483: If l_msg_count > 0 THEN
1484: x_msg_count := l_msg_count;

Line 1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');

1629: IF p_commit = FND_API.G_TRUE THEN
1630: SAVEPOINT update_project_pipeline_info;
1631: END IF;
1632:
1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');
1634:
1635: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1636: if (p_debug_mode = 'Y') then
1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

Line 1635: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1631: END IF;
1632:
1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');
1634:
1635: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1636: if (p_debug_mode = 'Y') then
1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1638: ,x_msg => 'Beginning of update_project_pipeline_info'
1639: ,x_log_level => 3);

Line 1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1633: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_pipeline_info');
1634:
1635: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1636: if (p_debug_mode = 'Y') then
1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1638: ,x_msg => 'Beginning of update_project_pipeline_info'
1639: ,x_log_level => 3);
1640: end if;
1641: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1641: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1637: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1638: ,x_msg => 'Beginning of update_project_pipeline_info'
1639: ,x_log_level => 3);
1640: end if;
1641: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1642:
1643: if (p_debug_mode = 'Y') then
1644: pa_debug.debug('Update_project_pipeline_info PUB : Checking API Compatibility');
1645: end if;

Line 1644: pa_debug.debug('Update_project_pipeline_info PUB : Checking API Compatibility');

1640: end if;
1641: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1642:
1643: if (p_debug_mode = 'Y') then
1644: pa_debug.debug('Update_project_pipeline_info PUB : Checking API Compatibility');
1645: end if;
1646: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1647: p_api_version,
1648: l_api_name,

Line 1679: pa_debug.debug('Create_Project PUB : Checking Probability code');

1675: (p_probability_percentage is not null AND
1676: p_probability_percentage <> FND_API.G_MISS_NUM)
1677: THEN
1678: if (p_debug_mode = 'Y') then
1679: pa_debug.debug('Create_Project PUB : Checking Probability code');
1680: end if;
1681: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CODE_OR_ID
1682: ( p_probability_member_id => p_probability_member_id
1683: ,p_probability_percentage => p_probability_percentage

Line 1690: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1686: ,x_probability_member_id => l_probability_member_id
1687: ,x_return_status => l_return_status
1688: ,x_error_msg_code => l_error_msg_code);
1689:
1690: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1691: if (p_debug_mode = 'Y') then
1692: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1693: ,x_msg => 'AFTER check probablity ... '||l_return_status
1694: ,x_log_level => 3);

Line 1692: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1688: ,x_error_msg_code => l_error_msg_code);
1689:
1690: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1691: if (p_debug_mode = 'Y') then
1692: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1693: ,x_msg => 'AFTER check probablity ... '||l_return_status
1694: ,x_log_level => 3);
1695: end if;
1696: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1696: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1692: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1693: ,x_msg => 'AFTER check probablity ... '||l_return_status
1694: ,x_log_level => 3);
1695: end if;
1696: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1697:
1698: IF l_return_status = FND_API.G_RET_STS_ERROR
1699: THEN
1700: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1708: pa_debug.debug('Update_project_pipeline_info PUB : Checking message count');

1704: END IF;
1705: END IF;
1706:
1707: if (p_debug_mode = 'Y') then
1708: pa_debug.debug('Update_project_pipeline_info PUB : Checking message count');
1709: end if;
1710: l_msg_count := FND_MSG_PUB.count_msg;
1711: If l_msg_count > 0 THEN
1712: x_msg_count := l_msg_count;

Line 1729: pa_debug.debug('Update_project_pipeline_info PUB : Calling private API update_project_pipeline_info');

1725:
1726: -- write your program logic from here
1727:
1728: if (p_debug_mode = 'Y') then
1729: pa_debug.debug('Update_project_pipeline_info PUB : Calling private API update_project_pipeline_info');
1730: end if;
1731:
1732: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1733: if (p_debug_mode = 'Y') then

Line 1732: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1728: if (p_debug_mode = 'Y') then
1729: pa_debug.debug('Update_project_pipeline_info PUB : Calling private API update_project_pipeline_info');
1730: end if;
1731:
1732: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1733: if (p_debug_mode = 'Y') then
1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1735: ,x_msg => 'Before calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1736: ,x_log_level => 3);

Line 1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1730: end if;
1731:
1732: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1733: if (p_debug_mode = 'Y') then
1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1735: ,x_msg => 'Before calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1736: ,x_log_level => 3);
1737: end if;
1738: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1738: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1734: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1735: ,x_msg => 'Before calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1736: ,x_log_level => 3);
1737: end if;
1738: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1739:
1740: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO (
1741: p_commit => FND_API.G_FALSE,
1742: p_validate_only => p_validate_only,

Line 1756: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1752: x_return_status => l_return_status,
1753: x_msg_count => l_msg_count,
1754: x_msg_data => l_msg_data);
1755:
1756: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1757: if (p_debug_mode = 'Y') then
1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1759: ,x_msg => 'After calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1760: ,x_log_level => 3);

Line 1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'

1754: x_msg_data => l_msg_data);
1755:
1756: -- Start: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1757: if (p_debug_mode = 'Y') then
1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1759: ,x_msg => 'After calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1760: ,x_log_level => 3);
1761: end if;
1762: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

Line 1762: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE

1758: PA_DEBUG.write (x_module => 'pa.plsql.PA_PROJECTS_MAINT_PUB.update_project_pipeline_info'
1759: ,x_msg => 'After calling PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_PIPELINE_INFO'
1760: ,x_log_level => 3);
1761: end if;
1762: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1763:
1764:
1765: -- Call PA_OPPORTUNITY_MGT_PVT.modify_project_attributes to update and convert
1766: -- opportunity values.

Line 1780: pa_debug.debug('Update_project_pipeline_info PUB : Checking message count');

1776: x_msg_data => l_msg_data);
1777: END IF;
1778:
1779: if (p_debug_mode = 'Y') then
1780: pa_debug.debug('Update_project_pipeline_info PUB : Checking message count');
1781: end if;
1782: l_msg_count := FND_MSG_PUB.count_msg;
1783: If l_msg_count > 0 THEN
1784: x_msg_count := l_msg_count;

Line 1946: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.create_classifications');

1942: IF p_commit = FND_API.G_TRUE THEN
1943: SAVEPOINT create_classifications;
1944: END IF;
1945:
1946: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.create_classifications');
1947:
1948: if (p_debug_mode = 'Y') then
1949: pa_debug.debug('Create_classifications PUB : Checking API compatibility');
1950: end if;

Line 1949: pa_debug.debug('Create_classifications PUB : Checking API compatibility');

1945:
1946: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.create_classifications');
1947:
1948: if (p_debug_mode = 'Y') then
1949: pa_debug.debug('Create_classifications PUB : Checking API compatibility');
1950: end if;
1951: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1952: p_api_version,
1953: l_api_name,

Line 1968: pa_debug.debug('Create_classifications PUB : Calling Private API Create_classifications');

1964:
1965: -- write your program logic here
1966:
1967: if (p_debug_mode = 'Y') then
1968: pa_debug.debug('Create_classifications PUB : Calling Private API Create_classifications');
1969: end if;
1970:
1971: -- Checking Input Parameters
1972:

Line 1974: pa_debug.debug('Create_classifications PUB: Checking Class Cateogory ');

1970:
1971: -- Checking Input Parameters
1972:
1973: if (p_debug_mode = 'Y') then
1974: pa_debug.debug('Create_classifications PUB: Checking Class Cateogory ');
1975: end if;
1976:
1977: BEGIN
1978:

Line 1996: pa_debug.debug('Create_classifications PUB: Checking Class Category / Codes Pair');

1992: raise;
1993: END;
1994:
1995: if (p_debug_mode = 'Y') then
1996: pa_debug.debug('Create_classifications PUB: Checking Class Category / Codes Pair');
1997: end if;
1998:
1999: -- Validate that the Class category / code pair is valid
2000: -- Bug 14150391 - Added condition for END DATED CLASS CODES starts here

Line 2116: pa_debug.debug('Create_classifications PUB : Checking message count');

2112:
2113: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATIONS '||to_char(l_msg_count));
2114:
2115: if (p_debug_mode = 'Y') then
2116: pa_debug.debug('Create_classifications PUB : Checking message count');
2117: end if;
2118:
2119: --dbms_output.put_line('Before PA_PROJECTS_MAINT_PVT. '||l_data);
2120:

Line 2262: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_classifications');

2258: IF p_commit = FND_API.G_TRUE THEN
2259: SAVEPOINT update_classifications;
2260: END IF;
2261:
2262: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_classifications');
2263:
2264: if (p_debug_mode = 'Y') then
2265: pa_debug.debug('Update_classifications PUB : Checking API compatibility');
2266: end if;

Line 2265: pa_debug.debug('Update_classifications PUB : Checking API compatibility');

2261:
2262: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_classifications');
2263:
2264: if (p_debug_mode = 'Y') then
2265: pa_debug.debug('Update_classifications PUB : Checking API compatibility');
2266: end if;
2267: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2268: p_api_version,
2269: l_api_name,

Line 2284: pa_debug.debug('Update_classifications PUB : Calling Private API Update_classifications');

2280:
2281: -- write your program logic here
2282:
2283: if (p_debug_mode = 'Y') then
2284: pa_debug.debug('Update_classifications PUB : Calling Private API Update_classifications');
2285: end if;
2286:
2287: -- Checking Input Parameters
2288:

Line 2290: pa_debug.debug('Update_classifications PUB: Checking Class Cateogory ');

2286:
2287: -- Checking Input Parameters
2288:
2289: if (p_debug_mode = 'Y') then
2290: pa_debug.debug('Update_classifications PUB: Checking Class Cateogory ');
2291: end if;
2292:
2293: BEGIN
2294:

Line 2312: pa_debug.debug('Update_classifications PUB: Checking Class Category / Codes Pair');

2308: raise;
2309: END;
2310:
2311: if (p_debug_mode = 'Y') then
2312: pa_debug.debug('Update_classifications PUB: Checking Class Category / Codes Pair');
2313: end if;
2314:
2315: -- Validate that the Class category / code pair is valid
2316: -- Bug 14150391 - Added condition for END DATED CLASS CODES starts here

Line 2507: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.delete_classifications');

2503: IF p_commit = FND_API.G_TRUE THEN
2504: SAVEPOINT delete_classifications;
2505: END IF;
2506:
2507: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.delete_classifications');
2508:
2509: if (p_debug_mode = 'Y') then
2510: pa_debug.debug('delete_classifications PUB : Checking API Compatibility');
2511: end if;

Line 2510: pa_debug.debug('delete_classifications PUB : Checking API Compatibility');

2506:
2507: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.delete_classifications');
2508:
2509: if (p_debug_mode = 'Y') then
2510: pa_debug.debug('delete_classifications PUB : Checking API Compatibility');
2511: end if;
2512: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2513: p_api_version,
2514: l_api_name,

Line 2529: pa_debug.debug('delete_classifications PUB : Calling private API delete_classifcations');

2525:
2526: -- write program logic here
2527:
2528: if (p_debug_mode = 'Y') then
2529: pa_debug.debug('delete_classifications PUB : Calling private API delete_classifcations');
2530: end if;
2531: PA_PROJECTS_MAINT_PVT.DELETE_CLASSIFICATIONS
2532: (
2533: p_commit => FND_API.G_FALSE,

Line 2549: pa_debug.debug('delete_classifications PUB : Checking message count');

2545: x_msg_count => l_msg_count,
2546: x_msg_data => l_msg_data);
2547:
2548: if (p_debug_mode = 'Y') then
2549: pa_debug.debug('delete_classifications PUB : Checking message count');
2550: end if;
2551: l_msg_count := FND_MSG_PUB.count_msg;
2552: If l_msg_count > 0 THEN
2553: x_msg_count := l_msg_count;

Line 2704: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_staffing_info');

2700: IF p_commit = FND_API.G_TRUE THEN
2701: SAVEPOINT update_project_staffing_info;
2702: END IF;
2703:
2704: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_staffing_info');
2705:
2706: if (p_debug_mode = 'Y') then
2707: pa_debug.debug('Update_project_staffing_info PUB : Checking API Compatibility');
2708: end if;

Line 2707: pa_debug.debug('Update_project_staffing_info PUB : Checking API Compatibility');

2703:
2704: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.update_project_staffing_info');
2705:
2706: if (p_debug_mode = 'Y') then
2707: pa_debug.debug('Update_project_staffing_info PUB : Checking API Compatibility');
2708: end if;
2709: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2710: p_api_version,
2711: l_api_name,

Line 2946: pa_debug.debug('update_project_staffing_info PUB : Calling private API update_project_staffing_info');

2942: End if;
2943:
2944:
2945: if (p_debug_mode = 'Y') then
2946: pa_debug.debug('update_project_staffing_info PUB : Calling private API update_project_staffing_info');
2947: end if;
2948:
2949:
2950: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_STAFFING_INFO

Line 2974: pa_debug.debug('update_project_staffing_info PUB : Checking message count');

2970: x_msg_count => l_msg_count,
2971: x_msg_data => l_msg_data);
2972:
2973: if (p_debug_mode = 'Y') then
2974: pa_debug.debug('update_project_staffing_info PUB : Checking message count');
2975: end if;
2976: l_msg_count := FND_MSG_PUB.count_msg;
2977: If l_msg_count > 0 THEN
2978: x_msg_count := l_msg_count;

Line 3121: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');

3117: FROM pa_project_role_types_b /* Bug#2788814-Changed pa_project_role_types_vl to pa_project_role_types_b */
3118: WHERE project_role_id = c_project_role_id;
3119:
3120: BEGIN
3121: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');
3122:
3123: if (p_debug_mode = 'Y') then
3124: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');
3125: end if;

Line 3124: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');

3120: BEGIN
3121: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');
3122:
3123: if (p_debug_mode = 'Y') then
3124: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');
3125: end if;
3126:
3127: if p_commit = FND_API.G_TRUE then
3128: savepoint create_org_role;

Line 3140: pa_debug.debug('Check if the role to be created is in CUSTOMER role class...');

3136: FND_MSG_PUB.initialize;
3137: end if;
3138:
3139: if (p_debug_mode = 'Y') then
3140: pa_debug.debug('Check if the role to be created is in CUSTOMER role class...');
3141: end if;
3142:
3143: l_role_class := NULL;
3144:

Line 3158: pa_debug.debug('Name to ID conversion for the party...');

3154:
3155: if l_role_class = 'CUSTOMER' then
3156:
3157: if (p_debug_mode = 'Y') then
3158: pa_debug.debug('Name to ID conversion for the party...');
3159: end if;
3160:
3161: if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then
3162: l_start_date_active := trunc(sysdate);

Line 3199: pa_debug.debug('Check if there is an existing customer for this org...');

3195: raise FND_API.G_EXC_ERROR;
3196: end if;
3197:
3198: if (p_debug_mode = 'Y') then
3199: pa_debug.debug('Check if there is an existing customer for this org...');
3200: end if;
3201:
3202: l_customer_id := null;
3203: OPEN l_check_existing_customers_csr(l_resource_source_id);

Line 3313: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role END');

3309: commit work;
3310: end if;
3311:
3312: if (p_debug_mode = 'Y') then
3313: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role END');
3314: end if;
3315:
3316: EXCEPTION
3317: when FND_API.G_EXC_ERROR then

Line 3429: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

3425: BEGIN
3426:
3427: x_msg_count := 0;
3428: x_return_status := FND_API.G_RET_STS_SUCCESS;
3429: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3430:
3431: IF (p_commit = FND_API.G_TRUE) THEN
3432: SAVEPOINT project_status_change;
3433: END IF;

Line 3440: PA_DEBUG.set_curr_function( p_function => 'project_status_change',

3436: FND_MSG_PUB.initialize;
3437: END IF;
3438:
3439: IF l_debug_mode = 'Y' THEN
3440: PA_DEBUG.set_curr_function( p_function => 'project_status_change',
3441: p_debug_mode => l_debug_mode );
3442: END IF;
3443:
3444: IF l_debug_mode = 'Y' THEN

Line 3445: Pa_Debug.g_err_stage:= 'Printing Input parameters';

3441: p_debug_mode => l_debug_mode );
3442: END IF;
3443:
3444: IF l_debug_mode = 'Y' THEN
3445: Pa_Debug.g_err_stage:= 'Printing Input parameters';
3446: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3447: l_debug_level3);
3448:
3449: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,

Line 3446: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,

3442: END IF;
3443:
3444: IF l_debug_mode = 'Y' THEN
3445: Pa_Debug.g_err_stage:= 'Printing Input parameters';
3446: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3447: l_debug_level3);
3448:
3449: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,
3450: l_debug_level3);

Line 3449: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,

3445: Pa_Debug.g_err_stage:= 'Printing Input parameters';
3446: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3447: l_debug_level3);
3448:
3449: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,
3450: l_debug_level3);
3451:
3452: Pa_Debug.WRITE(G_PKG_NAME,'p_new_status_code'||':'||p_new_status_code,
3453: l_debug_level3);

Line 3452: Pa_Debug.WRITE(G_PKG_NAME,'p_new_status_code'||':'||p_new_status_code,

3448:
3449: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,
3450: l_debug_level3);
3451:
3452: Pa_Debug.WRITE(G_PKG_NAME,'p_new_status_code'||':'||p_new_status_code,
3453: l_debug_level3);
3454: END IF;
3455:
3456: IF l_debug_mode = 'Y' THEN

Line 3457: Pa_Debug.g_err_stage:= 'Validating Input parameters';

3453: l_debug_level3);
3454: END IF;
3455:
3456: IF l_debug_mode = 'Y' THEN
3457: Pa_Debug.g_err_stage:= 'Validating Input parameters';
3458: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3459: l_debug_level3);
3460: END IF;
3461:

Line 3458: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,

3454: END IF;
3455:
3456: IF l_debug_mode = 'Y' THEN
3457: Pa_Debug.g_err_stage:= 'Validating Input parameters';
3458: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3459: l_debug_level3);
3460: END IF;
3461:
3462: IF ( ( p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM ) AND

Line 3467: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :

3463: ( p_new_status_code IS NULL OR p_new_status_code = FND_API.G_MISS_CHAR )
3464: )
3465: THEN
3466: IF l_debug_mode = 'Y' THEN
3467: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :
3468: p_project_id, p_new_status_code are NULL';
3469: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3470: l_debug_level3);
3471: END IF;

Line 3469: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,

3465: THEN
3466: IF l_debug_mode = 'Y' THEN
3467: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :
3468: p_project_id, p_new_status_code are NULL';
3469: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3470: l_debug_level3);
3471: END IF;
3472: RAISE Invalid_Arg_Exc;
3473: END IF;

Line 3529: Pa_Debug.WRITE(G_PKG_NAME,'Calling ALLOW_STATUS_CHANGE', l_debug_level3);

3525: -- Bug 12809532 : End of changes
3526:
3527: -- Bug 4565023: Begin
3528: IF (l_debug_mode = 'Y') THEN
3529: Pa_Debug.WRITE(G_PKG_NAME,'Calling ALLOW_STATUS_CHANGE', l_debug_level3);
3530: END IF;
3531:
3532: IF (PA_PROJECT_STUS_UTILS.ALLOW_STATUS_CHANGE(l_old_project_status,p_new_status_code) = 'N') THEN
3533: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 3540: Pa_Debug.WRITE(G_PKG_NAME,'Calling HANDLE_PROJECT_STATUS_CHANGE', l_debug_level3);

3536: END IF;
3537: -- Bug 4565023: End
3538:
3539: IF (l_debug_mode = 'Y') THEN
3540: Pa_Debug.WRITE(G_PKG_NAME,'Calling HANDLE_PROJECT_STATUS_CHANGE', l_debug_level3);
3541: END IF;
3542:
3543: --The following API call will verify the projects status change
3544: PA_PROJECT_STUS_UTILS.HANDLE_PROJECT_STATUS_CHANGE

Line 3574: Pa_Debug.WRITE(G_PKG_NAME,'l_verify_ok_flag ='||l_verify_ok_flag||' l_wf_enabled_flag ='||l_wf_enabled_flag,

3570: ,x_err_msg_count => l_msg_count
3571: ,x_warnings_only_flag => l_warnings_only_flag );
3572:
3573: IF (l_debug_mode = 'Y') THEN
3574: Pa_Debug.WRITE(G_PKG_NAME,'l_verify_ok_flag ='||l_verify_ok_flag||' l_wf_enabled_flag ='||l_wf_enabled_flag,
3575: l_debug_level3);
3576: END IF;
3577:
3578: IF l_verify_ok_flag <> 'Y' THEN

Line 3597: pa_debug.debug('Calling PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW');

3593: CLOSE cur_get_system_status;
3594: Moved this code to Block tagged with <**A**> */
3595:
3596: IF (l_debug_mode = 'Y') THEN
3597: pa_debug.debug('Calling PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW');
3598: END IF;
3599:
3600: --For inserting status change comment into the status history table
3601: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW

Line 3619: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');

3615: X_LAST_UPDATE_DATE => sysdate,
3616: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3617:
3618: IF (l_debug_mode = 'Y') THEN
3619: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3620: END IF;
3621:
3622: /*Stubbed Out Auto Initiate Demand On Project Approval Functionality
3623: Bug 3819086 */

Line 3651: Pa_Debug.WRITE(G_PKG_NAME,'l_wf_status_code ='||l_wf_status_code,

3647: FROM PA_PROJECTS_ALL
3648: WHERE project_id = p_project_id;
3649:
3650: IF (l_debug_mode = 'Y') THEN
3651: Pa_Debug.WRITE(G_PKG_NAME,'l_wf_status_code ='||l_wf_status_code,
3652: l_debug_level3);
3653: END IF;
3654:
3655: IF (l_abort_flag='Y') THEN -- for BUG# 6661144

Line 3796: Pa_Debug.reset_curr_function;

3792: x_msg_count := l_msg_count;
3793: END IF;
3794:
3795: IF l_debug_mode = 'Y' THEN
3796: Pa_Debug.reset_curr_function;
3797: END IF;
3798:
3799: WHEN Invalid_Arg_Exc THEN
3800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3814: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3810: , p_procedure_name => 'project_status_change'
3811: , p_error_text => x_msg_data);
3812:
3813: IF l_debug_mode = 'Y' THEN
3814: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3815: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3816: l_debug_level5);
3817: Pa_Debug.reset_curr_function;
3818: END IF;

Line 3815: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,

3811: , p_error_text => x_msg_data);
3812:
3813: IF l_debug_mode = 'Y' THEN
3814: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3815: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3816: l_debug_level5);
3817: Pa_Debug.reset_curr_function;
3818: END IF;
3819: RAISE;

Line 3817: Pa_Debug.reset_curr_function;

3813: IF l_debug_mode = 'Y' THEN
3814: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3815: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3816: l_debug_level5);
3817: Pa_Debug.reset_curr_function;
3818: END IF;
3819: RAISE;
3820:
3821: WHEN OTHERS THEN

Line 3836: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3832: , p_procedure_name => 'project_status_change'
3833: , p_error_text => x_msg_data);
3834:
3835: IF l_debug_mode = 'Y' THEN
3836: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3837: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3838: l_debug_level5);
3839: Pa_Debug.reset_curr_function;
3840: END IF;

Line 3837: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,

3833: , p_error_text => x_msg_data);
3834:
3835: IF l_debug_mode = 'Y' THEN
3836: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3837: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3838: l_debug_level5);
3839: Pa_Debug.reset_curr_function;
3840: END IF;
3841: RAISE;

Line 3839: Pa_Debug.reset_curr_function;

3835: IF l_debug_mode = 'Y' THEN
3836: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3837: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3838: l_debug_level5);
3839: Pa_Debug.reset_curr_function;
3840: END IF;
3841: RAISE;
3842:
3843: END project_status_change;