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: BEGIN

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

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

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

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

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

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

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

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

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

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

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

2306: raise;
2307: END;
2308:
2309: if (p_debug_mode = 'Y') then
2310: pa_debug.debug('Update_classifications PUB: Checking Class Category / Codes Pair');
2311: end if;
2312:
2313: -- Validate that the Class category / code pair is valid
2314: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

2938: End if;
2939:
2940:
2941: if (p_debug_mode = 'Y') then
2942: pa_debug.debug('update_project_staffing_info PUB : Calling private API update_project_staffing_info');
2943: end if;
2944:
2945:
2946: PA_PROJECTS_MAINT_PVT.UPDATE_PROJECT_STAFFING_INFO

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

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

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

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

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

3116: BEGIN
3117: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.Create_Org_Role');
3118:
3119: if (p_debug_mode = 'Y') then
3120: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role BEGIN');
3121: end if;
3122:
3123: if p_commit = FND_API.G_TRUE then
3124: savepoint create_org_role;

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

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

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

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

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

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

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

3305: commit work;
3306: end if;
3307:
3308: if (p_debug_mode = 'Y') then
3309: pa_debug.debug('PA_PROJECTS_MAINT_PUB.Create_Org_Role END');
3310: end if;
3311:
3312: EXCEPTION
3313: when FND_API.G_EXC_ERROR then

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

3420: BEGIN
3421:
3422: x_msg_count := 0;
3423: x_return_status := FND_API.G_RET_STS_SUCCESS;
3424: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3425:
3426: IF (p_commit = FND_API.G_TRUE) THEN
3427: SAVEPOINT project_status_change;
3428: END IF;

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

3431: FND_MSG_PUB.initialize;
3432: END IF;
3433:
3434: IF l_debug_mode = 'Y' THEN
3435: PA_DEBUG.set_curr_function( p_function => 'project_status_change',
3436: p_debug_mode => l_debug_mode );
3437: END IF;
3438:
3439: IF l_debug_mode = 'Y' THEN

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

3436: p_debug_mode => l_debug_mode );
3437: END IF;
3438:
3439: IF l_debug_mode = 'Y' THEN
3440: Pa_Debug.g_err_stage:= 'Printing Input parameters';
3441: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3442: l_debug_level3);
3443:
3444: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,

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

3437: END IF;
3438:
3439: IF l_debug_mode = 'Y' THEN
3440: Pa_Debug.g_err_stage:= 'Printing Input parameters';
3441: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3442: l_debug_level3);
3443:
3444: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,
3445: l_debug_level3);

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

3440: Pa_Debug.g_err_stage:= 'Printing Input parameters';
3441: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3442: l_debug_level3);
3443:
3444: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,
3445: l_debug_level3);
3446:
3447: Pa_Debug.WRITE(G_PKG_NAME,'p_new_status_code'||':'||p_new_status_code,
3448: l_debug_level3);

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

3443:
3444: Pa_Debug.WRITE(G_PKG_NAME,'p_project_id'||':'||p_project_id,
3445: l_debug_level3);
3446:
3447: Pa_Debug.WRITE(G_PKG_NAME,'p_new_status_code'||':'||p_new_status_code,
3448: l_debug_level3);
3449: END IF;
3450:
3451: IF l_debug_mode = 'Y' THEN

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

3448: l_debug_level3);
3449: END IF;
3450:
3451: IF l_debug_mode = 'Y' THEN
3452: Pa_Debug.g_err_stage:= 'Validating Input parameters';
3453: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3454: l_debug_level3);
3455: END IF;
3456:

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

3449: END IF;
3450:
3451: IF l_debug_mode = 'Y' THEN
3452: Pa_Debug.g_err_stage:= 'Validating Input parameters';
3453: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3454: l_debug_level3);
3455: END IF;
3456:
3457: IF ( ( p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM ) AND

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

3458: ( p_new_status_code IS NULL OR p_new_status_code = FND_API.G_MISS_CHAR )
3459: )
3460: THEN
3461: IF l_debug_mode = 'Y' THEN
3462: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :
3463: p_project_id, p_new_status_code are NULL';
3464: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3465: l_debug_level3);
3466: END IF;

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

3460: THEN
3461: IF l_debug_mode = 'Y' THEN
3462: Pa_Debug.g_err_stage:= 'PA_PROJECTS_MAINT_PUB : project_status_change :
3463: p_project_id, p_new_status_code are NULL';
3464: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3465: l_debug_level3);
3466: END IF;
3467: RAISE Invalid_Arg_Exc;
3468: END IF;

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

3498: /* <**A**> End Bug 4364878 */
3499:
3500: -- Bug 4565023: Begin
3501: IF (l_debug_mode = 'Y') THEN
3502: Pa_Debug.WRITE(G_PKG_NAME,'Calling ALLOW_STATUS_CHANGE', l_debug_level3);
3503: END IF;
3504:
3505: IF (PA_PROJECT_STUS_UTILS.ALLOW_STATUS_CHANGE(l_old_project_status,p_new_status_code) = 'N') THEN
3506: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3509: END IF;
3510: -- Bug 4565023: End
3511:
3512: IF (l_debug_mode = 'Y') THEN
3513: Pa_Debug.WRITE(G_PKG_NAME,'Calling HANDLE_PROJECT_STATUS_CHANGE', l_debug_level3);
3514: END IF;
3515:
3516: --The following API call will verify the projects status change
3517: PA_PROJECT_STUS_UTILS.HANDLE_PROJECT_STATUS_CHANGE

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

3543: ,x_err_msg_count => l_msg_count
3544: ,x_warnings_only_flag => l_warnings_only_flag );
3545:
3546: IF (l_debug_mode = 'Y') THEN
3547: Pa_Debug.WRITE(G_PKG_NAME,'l_verify_ok_flag ='||l_verify_ok_flag||' l_wf_enabled_flag ='||l_wf_enabled_flag,
3548: l_debug_level3);
3549: END IF;
3550:
3551: IF l_verify_ok_flag <> 'Y' THEN

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

3566: CLOSE cur_get_system_status;
3567: Moved this code to Block tagged with <**A**> */
3568:
3569: IF (l_debug_mode = 'Y') THEN
3570: pa_debug.debug('Calling PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW');
3571: END IF;
3572:
3573: --For inserting status change comment into the status history table
3574: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW

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

3588: X_LAST_UPDATE_DATE => sysdate,
3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3590:
3591: IF (l_debug_mode = 'Y') THEN
3592: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3593: END IF;
3594:
3595: /*Stubbed Out Auto Initiate Demand On Project Approval Functionality
3596: Bug 3819086 */

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

3620: FROM PA_PROJECTS_ALL
3621: WHERE project_id = p_project_id;
3622:
3623: IF (l_debug_mode = 'Y') THEN
3624: Pa_Debug.WRITE(G_PKG_NAME,'l_wf_status_code ='||l_wf_status_code,
3625: l_debug_level3);
3626: END IF;
3627:
3628: IF (l_abort_flag='Y') THEN -- for BUG# 6661144

Line 3769: Pa_Debug.reset_curr_function;

3765: x_msg_count := l_msg_count;
3766: END IF;
3767:
3768: IF l_debug_mode = 'Y' THEN
3769: Pa_Debug.reset_curr_function;
3770: END IF;
3771:
3772: WHEN Invalid_Arg_Exc THEN
3773: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

3783: , p_procedure_name => 'project_status_change'
3784: , p_error_text => x_msg_data);
3785:
3786: IF l_debug_mode = 'Y' THEN
3787: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3788: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3789: l_debug_level5);
3790: Pa_Debug.reset_curr_function;
3791: END IF;

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

3784: , p_error_text => x_msg_data);
3785:
3786: IF l_debug_mode = 'Y' THEN
3787: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3788: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3789: l_debug_level5);
3790: Pa_Debug.reset_curr_function;
3791: END IF;
3792: RAISE;

Line 3790: Pa_Debug.reset_curr_function;

3786: IF l_debug_mode = 'Y' THEN
3787: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3788: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3789: l_debug_level5);
3790: Pa_Debug.reset_curr_function;
3791: END IF;
3792: RAISE;
3793:
3794: WHEN OTHERS THEN

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

3805: , p_procedure_name => 'project_status_change'
3806: , p_error_text => x_msg_data);
3807:
3808: IF l_debug_mode = 'Y' THEN
3809: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3810: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3811: l_debug_level5);
3812: Pa_Debug.reset_curr_function;
3813: END IF;

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

3806: , p_error_text => x_msg_data);
3807:
3808: IF l_debug_mode = 'Y' THEN
3809: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3810: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3811: l_debug_level5);
3812: Pa_Debug.reset_curr_function;
3813: END IF;
3814: RAISE;

Line 3812: Pa_Debug.reset_curr_function;

3808: IF l_debug_mode = 'Y' THEN
3809: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3810: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,
3811: l_debug_level5);
3812: Pa_Debug.reset_curr_function;
3813: END IF;
3814: RAISE;
3815:
3816: END project_status_change;