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_SCHEDULE_PVT dependencies on FND_MSG_PUB

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

169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: x_msg_count := 1;
172: x_msg_data := SQLERRM;
173: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
174: p_procedure_name => 'get_existing_schedule');
175: raise;
176:
177: END get_existing_schedule;

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

443: WHEN OTHERS THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: x_msg_count := 1;
446: x_msg_data := SQLERRM;
447: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
448: p_procedure_name => 'get_calendar_schedule');
449: raise;
450:
451: END get_calendar_schedule;

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

867: WHEN OTHERS THEN
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: x_msg_count := 1;
870: x_msg_data := SQLERRM;
871: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
872: p_procedure_name => 'get_assignment_schedule');
873: raise;
874:
875: END get_assignment_schedule;

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

1082:
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084: x_msg_count := 1;
1085: x_msg_data := SQLERRM;
1086: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1087: p_procedure_name => 'get_assignment_schedule');
1088: raise;
1089:
1090: END get_assignment_schedule;

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

1916: WHEN l_invalid_source_id THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: x_msg_count := 1;
1919: x_msg_data := 'l_invalid_source_id';
1920: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1921: p_procedure_name => 'get_resource_schedule');
1922: raise;
1923: WHEN OTHERS THEN
1924: x_msg_count := 1;

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

1923: WHEN OTHERS THEN
1924: x_msg_count := 1;
1925: x_msg_data := SQLERRM;
1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1927: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1928: p_procedure_name => 'get_resource_schedule');
1929: raise;
1930:
1931: END get_resource_schedule;

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

2013: WHEN OTHERS THEN
2014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2015: x_msg_count := 1;
2016: x_msg_data := SQLERRM;
2017: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2018: p_procedure_name => 'apply_schedule_change');
2019: raise;
2020:
2021: END apply_schedule_change;

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

2133: WHEN OTHERS THEN
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135: x_msg_count := 1;
2136: x_msg_data := SQLERRM;
2137: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2138: p_procedure_name => 'create_new_schedule');
2139: raise;
2140:
2141: END create_new_schedule;

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

2198: WHEN OTHERS THEN
2199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2200: x_msg_count := 1;
2201: x_msg_data := SQLERRM;
2202: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2203: p_procedure_name => 'create_new_calendar');
2204:
2205: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_schedule procedure ');
2206: raise;

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

2491: WHEN OTHERS THEN
2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2493: x_msg_count := 1;
2494: x_msg_data := SQLERRM;
2495: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2496: p_procedure_name => 'create_new_hours');
2497: raise;
2498:
2499: END create_new_hours;

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

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

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

2840: WHEN OTHERS THEN
2841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2842: x_msg_count := 1;
2843: x_msg_data := SQLERRM;
2844: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2845: p_procedure_name => 'merge_work_pattern');
2846:
2847: PA_SCHEDULE_UTILS.log_message(1,'ERROR in merge_work_pattern procedure ');
2848: raise;

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

2902: WHEN OTHERS THEN
2903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2904: x_msg_count := 1;
2905: x_msg_data := SQLERRM;
2906: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2907: p_procedure_name => 'create_new_pattern');
2908: raise;
2909:
2910:

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

2973: WHEN OTHERS THEN
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: x_msg_count := 1;
2976: x_msg_data := SQLERRM;
2977: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2978: p_procedure_name => 'create_new_status');
2979: raise;
2980:
2981: END create_new_status;

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

3389: WHEN OTHERS THEN
3390: x_return_status := FND_API.G_RET_STS_ERROR;
3391: x_msg_count := 1;
3392: x_msg_data := SQLERRM;
3393: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3394: p_procedure_name => 'apply_change_duration');
3395:
3396: PA_SCHEDULE_UTILS.log_message(1,'ERROR while running apply...');
3397: raise;

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

3659: WHEN OTHERS THEN
3660: x_return_status := FND_API.G_RET_STS_ERROR;
3661: x_msg_count := 1;
3662: x_msg_data := SQLERRM;
3663: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3664: p_procedure_name => 'apply_other_change');
3665:
3666: PA_SCHEDULE_UTILS.log_message(2,'ERROR in apply_other_changes ....');
3667: PA_SCHEDULE_UTILS.log_message(2,sqlerrm);

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

3888: WHEN OTHERS THEN
3889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3890: x_msg_count := 1;
3891: x_msg_data := SQLERRM;
3892: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3893: p_procedure_name => 'apply_assignment_change');
3894: raise;
3895: END apply_assignment_change;
3896:

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

3989: PA_SCHEDULE_UTILS.log_message(1, 'Error in get_periodic_start_end.....'||sqlerrm);
3990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3991: x_msg_count := 1;
3992: x_msg_data := SQLERRM;
3993: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3994: p_procedure_name => 'get_periodic_start_end');
3995: raise;
3996: END get_periodic_start_end;
3997:

Line 4101: FND_MSG_PUB.add;

4097: END;
4098:
4099: FND_MESSAGE.SET_NAME('PA','PA_PLAN_QTY_NULL');
4100: FND_MESSAGE.SET_TOKEN('TASK_ASSIG',l_alias_name);
4101: FND_MSG_PUB.add;
4102: RAISE FND_API.G_EXC_ERROR;
4103: END IF;
4104:
4105: /*End for 4996210 */

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

4197: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_oasgn_schedule API .....'||sqlerrm);
4198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: x_msg_count := 1;
4200: x_msg_data := SQLERRM;
4201: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4202: p_procedure_name => 'create_opn_asg_schedule');
4203: raise;
4204:
4205: END create_opn_asg_schedule;

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

4501: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_opn_asgn_schedule API .....'||sqlerrm);
4502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4503: x_msg_count := 1;
4504: x_msg_data := SQLERRM;
4505: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4506: p_procedure_name => 'create_opn_asg_schedule');
4507: raise;
4508:
4509: END create_opn_asg_schedule;

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

4768: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_sasgn_schedule API ..'||sqlerrm);
4769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4770: x_msg_count := 1;
4771: x_msg_data := SQLERRM;
4772: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4773: p_procedure_name => 'create_stf_asg_schedule');
4774: raise;
4775:
4776: END create_stf_asg_schedule;

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

4831: WHEN OTHERS THEN
4832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4833: x_msg_count := 1;
4834: x_msg_data := SQLERRM;
4835: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
4836: p_procedure_name => 'delete_asgn_schedules');
4837: raise;
4838:
4839: END delete_asgn_schedules;

Line 5144: x_msg_count := FND_MSG_PUB.Count_Msg;

5140: PA_SCHEDULE_UTILS.log_message(1,'End of the update_sch_wf_success API ... '
5141: || l_x_return_status);
5142:
5143: x_return_status := l_x_return_status;
5144: x_msg_count := FND_MSG_PUB.Count_Msg;
5145: If x_msg_count = 1 THEN
5146: pa_interface_utils_pub.get_messages
5147: (p_encoded => FND_API.G_TRUE ,
5148: p_msg_index => 1,

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

5162: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_success API ..'||sqlerrm);
5163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5164: x_msg_count := 1;
5165: x_msg_data := SQLERRM;
5166: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5167: p_procedure_name => 'update_sch_wf_success');
5168: END update_sch_wf_success;
5169:
5170: -- Effects: Changes the schedule statuses of the assignment to the

Line 5381: x_msg_count := FND_MSG_PUB.Count_Msg;

5377: CLOSE C1;
5378: /* End of code added for bug 2329948 */
5379:
5380:
5381: x_msg_count := FND_MSG_PUB.Count_Msg;
5382: If x_msg_count = 1 THEN
5383: pa_interface_utils_pub.get_messages
5384: (p_encoded => FND_API.G_TRUE ,
5385: p_msg_index => 1,

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

5401: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_failure API ..'||sqlerrm);
5402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5403: x_msg_count := 1;
5404: x_msg_data := SQLERRM;
5405: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5406: p_procedure_name => 'update_sch_wf_failure');
5407: END update_sch_wf_failure;
5408:
5409: -- Effects: Reverts the schedule back to the last approved schedule.

Line 5498: x_msg_count := FND_MSG_PUB.Count_Msg;

5494: END IF;
5495:
5496: end if;
5497:
5498: x_msg_count := FND_MSG_PUB.Count_Msg;
5499: If x_msg_count = 1 THEN
5500: pa_interface_utils_pub.get_messages
5501: (p_encoded => FND_API.G_TRUE ,
5502: p_msg_index => 1,

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

5518: PA_SCHEDULE_UTILS.log_message(1,'ERROR in revert_to_last_approved API ..'||sqlerrm);
5519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5520: x_msg_count := 1;
5521: x_msg_data := SQLERRM;
5522: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5523: p_procedure_name => 'revert_to_last_approved');
5524: END revert_to_last_approved;
5525:
5526: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history

Line 5606: x_msg_count := FND_MSG_PUB.Count_Msg;

5602: else
5603: close c1;
5604: end if;
5605:
5606: x_msg_count := FND_MSG_PUB.Count_Msg;
5607: If x_msg_count = 1 THEN
5608: pa_interface_utils_pub.get_messages
5609: (p_encoded => FND_API.G_TRUE ,
5610: p_msg_index => 1,

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

5626: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_history_table API ..'||sqlerrm);
5627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5628: x_msg_count := 1;
5629: x_msg_data := SQLERRM;
5630: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5631: p_procedure_name => 'update_history_table');
5632: END update_history_table;
5633:
5634:

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

5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5971:
5972: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5973: p_procedure_name => 'update_asgmt_changed_items_tab');
5974: RAISE;
5975:
5976: END update_asgmt_changed_items_tab;

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

6166:
6167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6168: x_msg_count := 1;
6169: x_msg_data := SQLERRM;
6170: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6171: p_procedure_name => 'check_overcommitment_single');
6172: RAISE;
6173: END check_overcommitment_single;
6174:

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

6441: x_conflict_group_id := NULL ;-- 4537865
6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6443: x_msg_count := 1;
6444: x_msg_data := SQLERRM;
6445: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6446: p_procedure_name => 'check_overcommitment_mult');
6447: RAISE;
6448: END check_overcommitment_mult;
6449:

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

6577: x_self_conflict_flag := NULL ; -- 4537865
6578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6579: x_msg_count := 1;
6580: x_msg_data := SQLERRM;
6581: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6582: p_procedure_name => 'check_self_conflict');
6583: RAISE;
6584: END check_self_conflict;
6585:

Line 7007: x_msg_count := FND_MSG_PUB.Count_Msg;

7003: WHEN l_remove_conflicts_failed THEN
7004: PA_UTILS.add_message('PA','PA_REMOVE_CONFLICTS_FAILED');
7005: x_return_status := FND_API.G_RET_STS_ERROR;
7006: x_msg_data := 'PA_REMOVE_CONFLICTS_FAILED';
7007: x_msg_count := FND_MSG_PUB.Count_Msg;
7008: IF x_msg_count = 1 THEN
7009: pa_interface_utils_pub.get_messages
7010: (p_encoded => FND_API.G_TRUE,
7011: p_msg_index => 1,

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

7021: WHEN OTHERS THEN
7022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7023: x_msg_count := 1;
7024: x_msg_data := SQLERRM;
7025: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7026: p_procedure_name => 'resolve_conflicts');
7027: RAISE;
7028: END resolve_conflicts;
7029:

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

7099: WHEN OTHERS THEN
7100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7101: x_msg_count := 1;
7102: x_msg_data := SQLERRM;
7103: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7104: p_procedure_name => 'insert_work_pattern_record');
7105: RAISE;
7106:
7107: END insert_work_pattern_record;

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

7213: WHEN OTHERS THEN
7214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7215: x_msg_count := 1;
7216: x_msg_data := SQLERRM;
7217: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7218: p_procedure_name => 'insert_work_pattern_record');
7219: RAISE;
7220:
7221: END update_work_pattern_record;

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

7305: WHEN OTHERS THEN
7306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7307: x_msg_count := 1;
7308: x_msg_data := SQLERRM;
7309: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7310: p_procedure_name => 'insert_work_pattern_tab');
7311: RAISE;
7312:
7313: END insert_work_pattern_tab;

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

7680: WHEN OTHERS THEN
7681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7682: x_msg_count := 1;
7683: x_msg_data := SQLERRM;
7684: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7685: p_procedure_name => 'overcom_post_aprvl_processing');
7686: RAISE;
7687: END overcom_post_aprvl_processing;
7688:

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

7726:
7727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7728: x_msg_count := 1;
7729: x_msg_data := SQLERRM;
7730: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7731: p_procedure_name => 'will_resolve_conflicts_by_rmvl');
7732: RAISE;
7733: END will_resolve_conflicts_by_rmvl;
7734:

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

7770: x_resolve_conflicts_by_rmvl := NULL ;
7771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7772: x_msg_count := 1;
7773: x_msg_data := SQLERRM;
7774: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7775: p_procedure_name => 'has_resolved_conflicts_by_rmvl');
7776: RAISE;
7777: END has_resolved_conflicts_by_rmvl;
7778:

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

7822: WHEN OTHERS THEN
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7824: x_msg_count := 1;
7825: x_msg_data := SQLERRM;
7826: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7827: p_procedure_name => 'cancel_overcom_txn_items');
7828: RAISE;
7829: END cancel_overcom_txn_items;
7830:

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

7869: WHEN OTHERS THEN
7870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7871: x_msg_count := 1;
7872: x_msg_data := SQLERRM;
7873: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7874: p_procedure_name => 'revert_overcom_txn_items');
7875: RAISE;
7876: END revert_overcom_txn_items;
7877:

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

7901:
7902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7903: x_msg_count := 1;
7904: x_msg_data := SQLERRM;
7905: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7906: p_procedure_name => 'get_conflicting_asgmt_count');
7907: RAISE;
7908: END get_conflicting_asgmt_count;
7909:

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

7948:
7949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7950: x_msg_count := 1;
7951: x_msg_data := SQLERRM;
7952: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7953: p_procedure_name => 'has_action_taken_on_conflicts');
7954: RAISE;
7955: END has_action_taken_on_conflicts;
7956:

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

7993:
7994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7995: x_msg_count := 1;
7996: x_msg_data := SQLERRM;
7997: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7998: p_procedure_name => 'check_asgmt_apprvl_working');
7999: RAISE;
8000: END check_asgmt_apprvl_working;
8001:

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

8377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8378: x_msg_count := 1;
8379: x_msg_data := SQLERRM;
8380: x_total_hours := 0; -- Bug 5126919
8381: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8382: p_procedure_name => 'sum_task_assignments');
8383: raise;
8384:
8385: END sum_task_assignments;

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

8415: END IF;
8416: -- 4537865
8417: EXCEPTION
8418: WHEN OTHERS THEN
8419: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8420: p_procedure_name => 'set_hours_by_day_of_week',
8421: p_error_text => SUBSTRB(SQLERRM,1,240));
8422: RAISE;
8423: END set_hours_by_day_of_week;

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

9102: RETURN (l_count);
9103:
9104: EXCEPTION
9105: WHEN OTHERS THEN
9106: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9107: p_procedure_name => 'get_num_days_of_conflict');
9108: RAISE;
9109: END get_num_days_of_conflict;
9110:

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

9150: CLOSE c1;
9151:
9152: EXCEPTION
9153: WHEN OTHERS THEN
9154: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9155: p_procedure_name => 'column_val_conflict_exists');
9156: RAISE;
9157: END column_val_conflict_exists;
9158:

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

9196: close c1;
9197:
9198: EXCEPTION
9199: WHEN OTHERS THEN
9200: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9201: p_procedure_name => 'column_val_conflict_action');
9202: RAISE;
9203: END column_val_conflict_action;
9204:

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

9233: RETURN (l_affected);
9234:
9235: EXCEPTION
9236: WHEN OTHERS THEN
9237: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9238: p_procedure_name => 'check_conflict_proj_affected');
9239: RAISE;
9240: END check_conflict_proj_affected;
9241:

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

9272: RETURN (l_result);
9273:
9274: EXCEPTION
9275: WHEN OTHERS THEN
9276: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9277: p_procedure_name => 'check_self_conflict_exist');
9278: RAISE;
9279: END check_self_conflict_exist;
9280:

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

9299: EXCEPTION
9300: WHEN NO_DATA_FOUND THEN
9301: RETURN null;
9302: WHEN OTHERS THEN
9303: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9304: p_procedure_name => 'get_ak_attribute_label');
9305: RAISE;
9306: END get_ak_attribute_label;
9307: