DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on FND_MSG_PUB

Line 101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders'

97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: -- Set the excetption Message and the stack
101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Validate_approver_orders'
102: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
103: --
104: RAISE; -- This is optional depending on the needs
105: END Validate_approver_orders;

Line 178: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment'

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: -- Set the excetption Message and the stack
178: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment'
179: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
180: --
181: RAISE; -- This is optional depending on the needs
182:

Line 233: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id'

229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: -- Set the excetption Message and the stack
233: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id'
234: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
235: --
236: RAISE; -- This is optional depending on the needs
237:

Line 304: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required'

300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: -- Set the excetption Message and the stack
304: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required'
305: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: --
308: RAISE; -- This is optional depending on the needs

Line 369: l_error_count := FND_MSG_PUB.Count_Msg;

365: x_record_version_number := NULL;
366:
367: --Initialize local variables
368: l_record_version_number := p_record_version_number;
369: l_error_count := FND_MSG_PUB.Count_Msg;
370:
371: -- Get the current status code and record version number
372: OPEN get_status_and_rec_num;
373: FETCH get_status_and_rec_num INTO l_apprvl_status_code, l_record_version_number;

Line 528: x_msg_count := FND_MSG_PUB.Count_Msg - l_error_count;

524: END IF;
525: END IF;
526:
527:
528: x_msg_count := FND_MSG_PUB.Count_Msg - l_error_count;
529: IF x_msg_count = 1 THEN
530: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
531: ,p_msg_index => 1
532: ,p_data => x_msg_data

Line 548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status'

544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: -- Set the exception Message and the stack
548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status'
549: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
551:
552: RAISE; -- This is optional depending on the needs

Line 690: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action'

686: pa_debug.reset_err_stack; /* 3148857 */
687: EXCEPTION
688: WHEN OTHERS THEN
689: -- Set the exception Message and the stack
690: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action'
691: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693:
694: RAISE; -- This is optional depending on the needs

Line 944: IF (FND_MSG_PUB.Count_Msg = 0) THEN

940: AND last_approved_flag = 'Y';
941:
942:
943: --If no errors, insert the approved assignment record into the history table.
944: IF (FND_MSG_PUB.Count_Msg = 0) THEN
945: --Log Message
946: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
947: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.insert_row'
948: ,x_msg => 'insert last approved record into assignment history table.'

Line 1051: IF (FND_MSG_PUB.Count_Msg = 0) THEN

1047: END IF;
1048:
1049:
1050:
1051: IF (FND_MSG_PUB.Count_Msg = 0) THEN
1052: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1053: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History.schedule_history'
1054: ,x_msg => 'Updating Schedule history table.'
1055: ,x_log_level => 5);

Line 1078: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History'

1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: -- Set the exception Message and the stack
1078: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History'
1079: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1081:
1082: RAISE; -- This is optional depending on the needs

Line 1156: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval'

1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: -- Set the exception Message and the stack
1156: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval'
1157: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1159:
1160: RAISE; -- This is optional depending on the needs

Line 1187: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning'

1183: WHEN NO_DATA_FOUND THEN
1184: return null;
1185: WHEN OTHERS THEN
1186: -- Set the exception Message and the stack
1187: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning'
1188: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1189:
1190: RAISE; -- This is optional depending on the needs
1191:

Line 1354: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_asmt_and_asmt_history_rec'

1350:
1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: -- Set the exception Message and the stack
1354: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.get_asmt_and_asmt_history_rec'
1355: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1357:
1358: RAISE; -- This is optional depending on the needs