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.

[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on FND_MSG_PUB

Line 277: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

273: WHEN OTHERS THEN
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: x_msg_count := 1;
276: x_msg_data := SQLERRM;
277: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
278: p_procedure_name => 'get_calendar_schedule');
279: raise;
280:
281: END get_calendar_schedule;

Line 701: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: x_msg_count := 1;
700: x_msg_data := SQLERRM;
701: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
702: p_procedure_name => 'get_assignment_schedule');
703: raise;
704:
705: END get_assignment_schedule;

Line 916: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

912:
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: x_msg_count := 1;
915: x_msg_data := SQLERRM;
916: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
917: p_procedure_name => 'get_assignment_schedule');
918: raise;
919:
920: END get_assignment_schedule;

Line 1750: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1746: WHEN l_invalid_source_id THEN
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1748: x_msg_count := 1;
1749: x_msg_data := 'l_invalid_source_id';
1750: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1751: p_procedure_name => 'get_resource_schedule');
1752: raise;
1753: WHEN OTHERS THEN
1754: x_msg_count := 1;

Line 1757: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1753: WHEN OTHERS THEN
1754: x_msg_count := 1;
1755: x_msg_data := SQLERRM;
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1758: p_procedure_name => 'get_resource_schedule');
1759: raise;
1760:
1761: END get_resource_schedule;

Line 1847: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1843: WHEN OTHERS THEN
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: x_msg_count := 1;
1846: x_msg_data := SQLERRM;
1847: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1848: p_procedure_name => 'apply_schedule_change');
1849: raise;
1850:
1851: END apply_schedule_change;

Line 1962: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1958: WHEN OTHERS THEN
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: x_msg_count := 1;
1961: x_msg_data := SQLERRM;
1962: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1963: p_procedure_name => 'create_new_schedule');
1964: raise;
1965:
1966: END create_new_schedule;

Line 2027: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2023: WHEN OTHERS THEN
2024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2025: x_msg_count := 1;
2026: x_msg_data := SQLERRM;
2027: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2028: p_procedure_name => 'create_new_calendar');
2029:
2030: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_schedule procedure ');
2031: raise;

Line 2300: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2296: WHEN OTHERS THEN
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: x_msg_count := 1;
2299: x_msg_data := SQLERRM;
2300: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2301: p_procedure_name => 'create_new_hours');
2302: raise;
2303:
2304: END create_new_hours;

Line 2418: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2414: WHEN OTHERS THEN
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: x_msg_count := 1;
2417: x_msg_data := SQLERRM;
2418: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2419: p_procedure_name => 'create_new_duration');
2420:
2421: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_duration procedure ');
2422: raise;

Line 2632: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2628: WHEN OTHERS THEN
2629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630: x_msg_count := 1;
2631: x_msg_data := SQLERRM;
2632: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2633: p_procedure_name => 'merge_work_pattern');
2634:
2635: PA_SCHEDULE_UTILS.log_message(1,'ERROR in merge_work_pattern procedure ');
2636: raise;

Line 2694: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2690: WHEN OTHERS THEN
2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2692: x_msg_count := 1;
2693: x_msg_data := SQLERRM;
2694: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2695: p_procedure_name => 'create_new_pattern');
2696: raise;
2697:
2698:

Line 2765: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2761: WHEN OTHERS THEN
2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: x_msg_count := 1;
2764: x_msg_data := SQLERRM;
2765: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2766: p_procedure_name => 'create_new_status');
2767: raise;
2768:
2769: END create_new_status;

Line 3122: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3118: WHEN OTHERS THEN
3119: x_return_status := FND_API.G_RET_STS_ERROR;
3120: x_msg_count := 1;
3121: x_msg_data := SQLERRM;
3122: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3123: p_procedure_name => 'apply_change_duration');
3124:
3125: PA_SCHEDULE_UTILS.log_message(1,'ERROR while running apply...');
3126: raise;

Line 3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3386: WHEN OTHERS THEN
3387: x_return_status := FND_API.G_RET_STS_ERROR;
3388: x_msg_count := 1;
3389: x_msg_data := SQLERRM;
3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3391: p_procedure_name => 'apply_other_change');
3392:
3393: PA_SCHEDULE_UTILS.log_message(2,'ERROR in apply_other_changes ....');
3394: PA_SCHEDULE_UTILS.log_message(2,sqlerrm);

Line 3606: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: x_msg_count := 1;
3605: x_msg_data := SQLERRM;
3606: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3607: p_procedure_name => 'apply_assignment_change');
3608: raise;
3609: END apply_assignment_change;
3610:

Line 3707: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3703: PA_SCHEDULE_UTILS.log_message(1, 'Error in get_periodic_start_end.....'||sqlerrm);
3704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3705: x_msg_count := 1;
3706: x_msg_data := SQLERRM;
3707: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3708: p_procedure_name => 'get_periodic_start_end');
3709: raise;
3710: END get_periodic_start_end;
3711:

Line 3815: FND_MSG_PUB.add;

3811: END;
3812:
3813: FND_MESSAGE.SET_NAME('PA','PA_PLAN_QTY_NULL');
3814: FND_MESSAGE.SET_TOKEN('TASK_ASSIG',l_alias_name);
3815: FND_MSG_PUB.add;
3816: RAISE FND_API.G_EXC_ERROR;
3817: END IF;
3818:
3819: /*End for 4996210 */

Line 3915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3911: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_oasgn_schedule API .....'||sqlerrm);
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913: x_msg_count := 1;
3914: x_msg_data := SQLERRM;
3915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3916: p_procedure_name => 'create_opn_asg_schedule');
3917: raise;
3918:
3919: END create_opn_asg_schedule;

Line 4219: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

4215: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_opn_asgn_schedule API .....'||sqlerrm);
4216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4217: x_msg_count := 1;
4218: x_msg_data := SQLERRM;
4219: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4220: p_procedure_name => 'create_opn_asg_schedule');
4221: raise;
4222:
4223: END create_opn_asg_schedule;

Line 4486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

4482: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_sasgn_schedule API ..'||sqlerrm);
4483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4484: x_msg_count := 1;
4485: x_msg_data := SQLERRM;
4486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4487: p_procedure_name => 'create_stf_asg_schedule');
4488: raise;
4489:
4490: END create_stf_asg_schedule;

Line 4549: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

4545: WHEN OTHERS THEN
4546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4547: x_msg_count := 1;
4548: x_msg_data := SQLERRM;
4549: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
4550: p_procedure_name => 'delete_asgn_schedules');
4551: raise;
4552:
4553: END delete_asgn_schedules;

Line 4858: x_msg_count := FND_MSG_PUB.Count_Msg;

4854: PA_SCHEDULE_UTILS.log_message(1,'End of the update_sch_wf_success API ... '
4855: || l_x_return_status);
4856:
4857: x_return_status := l_x_return_status;
4858: x_msg_count := FND_MSG_PUB.Count_Msg;
4859: If x_msg_count = 1 THEN
4860: pa_interface_utils_pub.get_messages
4861: (p_encoded => FND_API.G_TRUE ,
4862: p_msg_index => 1,

Line 4880: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

4876: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_success API ..'||sqlerrm);
4877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4878: x_msg_count := 1;
4879: x_msg_data := SQLERRM;
4880: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4881: p_procedure_name => 'update_sch_wf_success');
4882: END update_sch_wf_success;
4883:
4884: -- Effects: Changes the schedule statuses of the assignment to the

Line 5095: x_msg_count := FND_MSG_PUB.Count_Msg;

5091: CLOSE C1;
5092: /* End of code added for bug 2329948 */
5093:
5094:
5095: x_msg_count := FND_MSG_PUB.Count_Msg;
5096: If x_msg_count = 1 THEN
5097: pa_interface_utils_pub.get_messages
5098: (p_encoded => FND_API.G_TRUE ,
5099: p_msg_index => 1,

Line 5119: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5115: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_failure API ..'||sqlerrm);
5116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5117: x_msg_count := 1;
5118: x_msg_data := SQLERRM;
5119: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5120: p_procedure_name => 'update_sch_wf_failure');
5121: END update_sch_wf_failure;
5122:
5123: -- Effects: Reverts the schedule back to the last approved schedule.

Line 5212: x_msg_count := FND_MSG_PUB.Count_Msg;

5208: END IF;
5209:
5210: end if;
5211:
5212: x_msg_count := FND_MSG_PUB.Count_Msg;
5213: If x_msg_count = 1 THEN
5214: pa_interface_utils_pub.get_messages
5215: (p_encoded => FND_API.G_TRUE ,
5216: p_msg_index => 1,

Line 5236: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5232: PA_SCHEDULE_UTILS.log_message(1,'ERROR in revert_to_last_approved API ..'||sqlerrm);
5233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5234: x_msg_count := 1;
5235: x_msg_data := SQLERRM;
5236: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5237: p_procedure_name => 'revert_to_last_approved');
5238: END revert_to_last_approved;
5239:
5240: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history

Line 5320: x_msg_count := FND_MSG_PUB.Count_Msg;

5316: else
5317: close c1;
5318: end if;
5319:
5320: x_msg_count := FND_MSG_PUB.Count_Msg;
5321: If x_msg_count = 1 THEN
5322: pa_interface_utils_pub.get_messages
5323: (p_encoded => FND_API.G_TRUE ,
5324: p_msg_index => 1,

Line 5344: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5340: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_history_table API ..'||sqlerrm);
5341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5342: x_msg_count := 1;
5343: x_msg_data := SQLERRM;
5344: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5345: p_procedure_name => 'update_history_table');
5346: END update_history_table;
5347:
5348:

Line 5684: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5683:
5684: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5685: p_procedure_name => 'update_asgmt_changed_items_tab');
5686: RAISE;
5687:
5688: END update_asgmt_changed_items_tab;

Line 5877: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5873:
5874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5875: x_msg_count := 1;
5876: x_msg_data := SQLERRM;
5877: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5878: p_procedure_name => 'check_overcommitment_single');
5879: RAISE;
5880: END check_overcommitment_single;
5881:

Line 6152: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6148: x_conflict_group_id := NULL ;-- 4537865
6149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6150: x_msg_count := 1;
6151: x_msg_data := SQLERRM;
6152: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6153: p_procedure_name => 'check_overcommitment_mult');
6154: RAISE;
6155: END check_overcommitment_mult;
6156:

Line 6288: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6284: x_self_conflict_flag := NULL ; -- 4537865
6285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6286: x_msg_count := 1;
6287: x_msg_data := SQLERRM;
6288: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6289: p_procedure_name => 'check_self_conflict');
6290: RAISE;
6291: END check_self_conflict;
6292:

Line 6714: x_msg_count := FND_MSG_PUB.Count_Msg;

6710: WHEN l_remove_conflicts_failed THEN
6711: PA_UTILS.add_message('PA','PA_REMOVE_CONFLICTS_FAILED');
6712: x_return_status := FND_API.G_RET_STS_ERROR;
6713: x_msg_data := 'PA_REMOVE_CONFLICTS_FAILED';
6714: x_msg_count := FND_MSG_PUB.Count_Msg;
6715: IF x_msg_count = 1 THEN
6716: pa_interface_utils_pub.get_messages
6717: (p_encoded => FND_API.G_TRUE,
6718: p_msg_index => 1,

Line 6732: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6728: WHEN OTHERS THEN
6729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6730: x_msg_count := 1;
6731: x_msg_data := SQLERRM;
6732: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6733: p_procedure_name => 'resolve_conflicts');
6734: RAISE;
6735: END resolve_conflicts;
6736:

Line 6810: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6806: WHEN OTHERS THEN
6807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6808: x_msg_count := 1;
6809: x_msg_data := SQLERRM;
6810: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6811: p_procedure_name => 'insert_work_pattern_record');
6812: RAISE;
6813:
6814: END insert_work_pattern_record;

Line 6924: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6920: WHEN OTHERS THEN
6921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6922: x_msg_count := 1;
6923: x_msg_data := SQLERRM;
6924: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6925: p_procedure_name => 'insert_work_pattern_record');
6926: RAISE;
6927:
6928: END update_work_pattern_record;

Line 7016: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7012: WHEN OTHERS THEN
7013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7014: x_msg_count := 1;
7015: x_msg_data := SQLERRM;
7016: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7017: p_procedure_name => 'insert_work_pattern_tab');
7018: RAISE;
7019:
7020: END insert_work_pattern_tab;

Line 7391: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7387: WHEN OTHERS THEN
7388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7389: x_msg_count := 1;
7390: x_msg_data := SQLERRM;
7391: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7392: p_procedure_name => 'overcom_post_aprvl_processing');
7393: RAISE;
7394: END overcom_post_aprvl_processing;
7395:

Line 7437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7433:
7434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7435: x_msg_count := 1;
7436: x_msg_data := SQLERRM;
7437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7438: p_procedure_name => 'will_resolve_conflicts_by_rmvl');
7439: RAISE;
7440: END will_resolve_conflicts_by_rmvl;
7441:

Line 7481: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7477: x_resolve_conflicts_by_rmvl := NULL ;
7478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7479: x_msg_count := 1;
7480: x_msg_data := SQLERRM;
7481: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7482: p_procedure_name => 'has_resolved_conflicts_by_rmvl');
7483: RAISE;
7484: END has_resolved_conflicts_by_rmvl;
7485:

Line 7533: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7529: WHEN OTHERS THEN
7530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7531: x_msg_count := 1;
7532: x_msg_data := SQLERRM;
7533: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7534: p_procedure_name => 'cancel_overcom_txn_items');
7535: RAISE;
7536: END cancel_overcom_txn_items;
7537:

Line 7580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7576: WHEN OTHERS THEN
7577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7578: x_msg_count := 1;
7579: x_msg_data := SQLERRM;
7580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7581: p_procedure_name => 'revert_overcom_txn_items');
7582: RAISE;
7583: END revert_overcom_txn_items;
7584:

Line 7612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7608:
7609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7610: x_msg_count := 1;
7611: x_msg_data := SQLERRM;
7612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7613: p_procedure_name => 'get_conflicting_asgmt_count');
7614: RAISE;
7615: END get_conflicting_asgmt_count;
7616:

Line 7659: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7655:
7656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7657: x_msg_count := 1;
7658: x_msg_data := SQLERRM;
7659: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7660: p_procedure_name => 'has_action_taken_on_conflicts');
7661: RAISE;
7662: END has_action_taken_on_conflicts;
7663:

Line 7704: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7700:
7701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7702: x_msg_count := 1;
7703: x_msg_data := SQLERRM;
7704: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7705: p_procedure_name => 'check_asgmt_apprvl_working');
7706: RAISE;
7707: END check_asgmt_apprvl_working;
7708:

Line 8088: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8085: x_msg_count := 1;
8086: x_msg_data := SQLERRM;
8087: x_total_hours := 0; -- Bug 5126919
8088: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8089: p_procedure_name => 'sum_task_assignments');
8090: raise;
8091:
8092: END sum_task_assignments;

Line 8126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8122: END IF;
8123: -- 4537865
8124: EXCEPTION
8125: WHEN OTHERS THEN
8126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8127: p_procedure_name => 'set_hours_by_day_of_week',
8128: p_error_text => SUBSTRB(SQLERRM,1,240));
8129: RAISE;
8130: END set_hours_by_day_of_week;

Line 8813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8809: RETURN (l_count);
8810:
8811: EXCEPTION
8812: WHEN OTHERS THEN
8813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8814: p_procedure_name => 'get_num_days_of_conflict');
8815: RAISE;
8816: END get_num_days_of_conflict;
8817:

Line 8861: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8857: CLOSE c1;
8858:
8859: EXCEPTION
8860: WHEN OTHERS THEN
8861: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8862: p_procedure_name => 'column_val_conflict_exists');
8863: RAISE;
8864: END column_val_conflict_exists;
8865:

Line 8907: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8903: close c1;
8904:
8905: EXCEPTION
8906: WHEN OTHERS THEN
8907: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8908: p_procedure_name => 'column_val_conflict_action');
8909: RAISE;
8910: END column_val_conflict_action;
8911:

Line 8944: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8940: RETURN (l_affected);
8941:
8942: EXCEPTION
8943: WHEN OTHERS THEN
8944: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8945: p_procedure_name => 'check_conflict_proj_affected');
8946: RAISE;
8947: END check_conflict_proj_affected;
8948:

Line 8983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8979: RETURN (l_result);
8980:
8981: EXCEPTION
8982: WHEN OTHERS THEN
8983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8984: p_procedure_name => 'check_self_conflict_exist');
8985: RAISE;
8986: END check_self_conflict_exist;
8987:

Line 9010: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

9006: EXCEPTION
9007: WHEN NO_DATA_FOUND THEN
9008: RETURN null;
9009: WHEN OTHERS THEN
9010: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9011: p_procedure_name => 'get_ak_attribute_label');
9012: RAISE;
9013: END get_ak_attribute_label;
9014: