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_ASSIGNMENT_APPROVAL_PVT dependencies on FND_API

Line 31: l_return_status := FND_API.G_RET_STS_SUCCESS;

27: ,x_msg => 'Beginning of Validate_approver_orders'
28: ,x_log_level => 5);
29: END IF;
30: -- Initialize
31: l_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: --
34: --If table empty, then return error that at least one approver is needed.
35: --Else use bubble sort to put approvers according to their order, then check if any duplicate order exists.

Line 40: l_return_status := FND_API.G_RET_STS_ERROR;

36: --
37: IF PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST IS NULL AND PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST IS NULL THEN
38: PA_UTILS.Add_Message( p_app_short_name => 'PA'
39: ,p_msg_name => 'PA_NO_NON_EXCLUDED_APR');
40: l_return_status := FND_API.G_RET_STS_ERROR;
41: ELSE
42:
43: --Log Message
44: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 86: l_return_status := FND_API.G_RET_STS_ERROR;

82: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders =
83: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
84: PA_UTILS.Add_Message( p_app_short_name => 'PA'
85: ,p_msg_name => 'PA_DUPLICATE_APR_ORDERS');
86: l_return_status := FND_API.G_RET_STS_ERROR;
87: END IF;
88: END LOOP; -- end of check duplicate order
89: END IF;-- end of check only one item in the table
90: END IF; --End of check table.

Line 249: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

245: --
246: PROCEDURE Check_Approval_Required
247: (
248: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
249: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
250: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
251: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
252: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
253: ) IS

Line 250: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

246: PROCEDURE Check_Approval_Required
247: (
248: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
249: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
250: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
251: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
252: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
253: ) IS
254:

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: END IF;
267:
268:
269: -- Initialize
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: l_approval_required_flag := 'N';
272:
273: -- If the specified assignment has not been previously approved and the submitter has no resource authority
274: -- Then approval required.

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

288: END IF;
289:
290: l_approval_required_flag := PA_CLIENT_EXTN_ASGMT_APPRVL.Is_Asgmt_Appr_Items_Changed(p_assignment_id);
291: IF l_approval_required_flag NOT IN ('Y', 'N') THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: END IF;
294:
295: END IF; -- end of checking new assignment flag
296:

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
309:
310: END Check_Approval_Required;

Line 326: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

322: --
323: PROCEDURE Update_Approval_Status
324: (
325: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
326: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE
328: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
329: ,x_apprvl_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
330: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895

Line 328: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR

324: (
325: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
326: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE
328: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
329: ,x_apprvl_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
330: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
331: ,x_record_version_number OUT NOCOPY pa_project_assignments.record_version_number%TYPE --File.Sql.39 bug 4440895
332: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: ,x_msg => 'Beginning of Update_Approval_Status.'
360: ,x_log_level => 5);
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364: x_change_id := NULL;
365: x_record_version_number := NULL;
366:
367: --Initialize local variables

Line 393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

389:
390: PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History ( p_assignment_id => p_assignment_id
391: ,x_change_id => x_change_id
392: ,x_return_status => l_return_status);
393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: x_return_status := l_return_status;
395: END IF;
396: l_return_status := FND_API.G_MISS_CHAR;
397:

Line 396: l_return_status := FND_API.G_MISS_CHAR;

392: ,x_return_status => l_return_status);
393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: x_return_status := l_return_status;
395: END IF;
396: l_return_status := FND_API.G_MISS_CHAR;
397:
398: /* Changed bug 1635170*/
399: ELSE
400: x_change_id:=PA_ASSIGNMENT_APPROVAL_PVT.get_change_id(p_assignment_id);

Line 418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

414: ,x_status_code => x_apprvl_status_code
415: ,x_return_status => l_return_status);
416: --dbms_output.put_line('next status:'|| x_apprvl_status_code);
417:
418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: x_return_status := l_return_status;
420: END IF;
421: l_return_status := FND_API.G_MISS_CHAR;
422:

Line 421: l_return_status := FND_API.G_MISS_CHAR;

417:
418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: x_return_status := l_return_status;
420: END IF;
421: l_return_status := FND_API.G_MISS_CHAR;
422:
423: /* --moved after schedule success or failure
424:
425: --If no error, update the current assignment record with the new status and increment record_version_number

Line 426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

422:
423: /* --moved after schedule success or failure
424:
425: --If no error, update the current assignment record with the new status and increment record_version_number
426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
427: --dbms_output.put_line('calling update row');
428:
429: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row ( p_assignment_id => p_assignment_id
430: ,p_record_version_number => p_record_version_number

Line 434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

430: ,p_record_version_number => p_record_version_number
431: ,p_apprvl_status_code => x_apprvl_status_code
432: ,p_note_to_approver => p_note_to_approver
433: ,x_return_status => l_return_status );
434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
435: x_return_status := l_return_status;
436: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
437: x_record_version_number := p_record_version_number +1;
438: END IF;

Line 436: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

432: ,p_note_to_approver => p_note_to_approver
433: ,x_return_status => l_return_status );
434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
435: x_return_status := l_return_status;
436: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
437: x_record_version_number := p_record_version_number +1;
438: END IF;
439: l_return_status := FND_API.G_MISS_CHAR;
440: END IF;

Line 439: l_return_status := FND_API.G_MISS_CHAR;

435: x_return_status := l_return_status;
436: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
437: x_record_version_number := p_record_version_number +1;
438: END IF;
439: l_return_status := FND_API.G_MISS_CHAR;
440: END IF;
441:
442: */
443:

Line 446: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

442: */
443:
444:
445: --In the case of Approve or Reject, also call schedule's success/failure method to update schedule statuses.
446: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
447:
448: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
449: --call schedule's success method
450: --Log Message

Line 462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

458: ,p_record_version_number => l_record_version_number
459: ,x_return_status => l_return_status
460: ,x_msg_count => l_msg_count
461: ,x_msg_data => l_msg_data);
462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
463: x_return_status := l_return_status;
464: END IF;
465: l_record_version_number := NULL;
466: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN

Line 480: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

476: ,p_record_version_number => l_record_version_number
477: ,x_return_status => l_return_status
478: ,x_msg_count => l_msg_count
479: ,x_msg_data => l_msg_data);
480: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
481: x_return_status := l_return_status;
482: END IF;
483: l_record_version_number := NULL;
484: END IF; -- end of calling success/failure

Line 485: l_return_status := FND_API.G_MISS_CHAR;

481: x_return_status := l_return_status;
482: END IF;
483: l_record_version_number := NULL;
484: END IF; -- end of calling success/failure
485: l_return_status := FND_API.G_MISS_CHAR;
486: l_msg_count := FND_API.G_MISS_NUM;
487: l_msg_data := FND_API.G_MISS_CHAR;
488: END IF;
489:

Line 486: l_msg_count := FND_API.G_MISS_NUM;

482: END IF;
483: l_record_version_number := NULL;
484: END IF; -- end of calling success/failure
485: l_return_status := FND_API.G_MISS_CHAR;
486: l_msg_count := FND_API.G_MISS_NUM;
487: l_msg_data := FND_API.G_MISS_CHAR;
488: END IF;
489:
490:

Line 487: l_msg_data := FND_API.G_MISS_CHAR;

483: l_record_version_number := NULL;
484: END IF; -- end of calling success/failure
485: l_return_status := FND_API.G_MISS_CHAR;
486: l_msg_count := FND_API.G_MISS_NUM;
487: l_msg_data := FND_API.G_MISS_CHAR;
488: END IF;
489:
490:
491:

Line 496: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

492: --If no error, update the current assignment record with the new status and increment record_version_number
493: --The record_version_number passed in will be NULL if Schedule Sucess/failure API has already updated the record
494: --otherwise, use the p_record_version_number
495:
496: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
497:
498: --Log Message
499: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
500: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.update_status'

Line 508: IF (p_note_to_approver <> FND_API.G_MISS_CHAR AND p_note_to_approver IS NOT NULL) OR

504:
505: --Update record in assignment table Only if
506: --p_note_to_approver exists OR
507: --apprvl_status_code has been changed.
508: IF (p_note_to_approver <> FND_API.G_MISS_CHAR AND p_note_to_approver IS NOT NULL) OR
509: ((x_apprvl_status_code IS NOT NULL AND l_apprvl_status_code IS NULL) OR
510: (x_apprvl_status_code <> l_apprvl_status_code)) THEN
511: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row ( p_assignment_id => p_assignment_id
512: ,p_record_version_number => l_record_version_number

Line 516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

512: ,p_record_version_number => l_record_version_number
513: ,p_apprvl_status_code => x_apprvl_status_code
514: ,p_note_to_approver => p_note_to_approver
515: ,x_return_status => l_return_status );
516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;
518: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
519: IF l_record_version_number IS NOT NULL THEN
520: x_record_version_number := l_record_version_number +1;

Line 518: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

514: ,p_note_to_approver => p_note_to_approver
515: ,x_return_status => l_return_status );
516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;
518: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
519: IF l_record_version_number IS NOT NULL THEN
520: x_record_version_number := l_record_version_number +1;
521: END IF;
522: END IF;

Line 523: l_return_status := FND_API.G_MISS_CHAR;

519: IF l_record_version_number IS NOT NULL THEN
520: x_record_version_number := l_record_version_number +1;
521: END IF;
522: END IF;
523: l_return_status := FND_API.G_MISS_CHAR;
524: END IF;
525: END IF;
526:
527:

Line 530: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

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
533: ,p_msg_index_out => l_msg_index_out
534: );

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: );
535: END IF;
536:
537: IF x_msg_count > 0 THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: END IF;
540:
541: -- Reset the error stack when returning to the calling program
542:

Line 550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
553:
554:

Line 567: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

563: --After bug 6625421, 'SAVE_AND_SUBMIT' action also allowed.
564: --
565: PROCEDURE Get_Next_Status_After_Action
566: (
567: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
568: ,p_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
569: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ) IS

Line 568: ,p_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

564: --
565: PROCEDURE Get_Next_Status_After_Action
566: (
567: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
568: ,p_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
569: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ) IS
572:

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

586: ,x_msg => 'Beginning of Get_Next_Status_After_Action.'
587: ,x_log_level => 5);
588: END IF;
589:
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:
592:
593: --Check only valid action is passed in.
594: IF p_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
598: PA_UTILS.Add_Message( p_app_short_name => 'PA'
599: ,p_msg_name => 'PA_UNEXP_APPRVL_ACTION');
600: --dbms_output.put_line('unexpected action code');
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: END IF;
603:
604:
605:

Line 615: x_return_status := FND_API.G_RET_STS_ERROR;

611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN
612: PA_UTILS.Add_Message( p_app_short_name => 'PA'
613: ,p_msg_name => 'PA_INVALID_APPRVL_STUS');
614: --dbms_output.put_line('unexpected apprvl status');
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: END IF;
617:
618: IF (p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action
619: OR

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: ELSIF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
639: /*
640: PA_UTILS.Add_Message( p_app_short_name => 'PA'
641: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: */
644: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
645:
646: ELSIF p_status_code IS NULL THEN

Line 673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

669: ,x_error_message_code => l_error_message_code) ;
670:
671:
672:
673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
674: x_return_status := l_return_status;
675: PA_UTILS.Add_Message( p_app_short_name => 'PA'
676: ,p_msg_name => l_error_message_code);
677: ELSE

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
695: END Get_Next_Status_After_Action;
696:

Line 736: x_return_status := FND_API.G_RET_STS_SUCCESS;

732: ,x_msg => 'Beginning of Insert_Into_Assignment_History'
733: ,x_log_level => 5);
734: END IF;
735:
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737: x_change_id := NULL;
738:
739: --
740: -- Get the current assignment record details

Line 1043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1039: ,x_change_id => l_change_id
1040: ,x_return_status => l_return_status);
1041:
1042: --dbms_output.put_line('x_change_id: '|| l_change_id);
1043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: x_return_status := l_return_status;
1045: END IF;
1046: l_return_status := FND_API.G_MISS_CHAR;
1047: END IF;

Line 1046: l_return_status := FND_API.G_MISS_CHAR;

1042: --dbms_output.put_line('x_change_id: '|| l_change_id);
1043: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: x_return_status := l_return_status;
1045: END IF;
1046: l_return_status := FND_API.G_MISS_CHAR;
1047: END IF;
1048:
1049:
1050:

Line 1064: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1060: ,P_CHANGE_ID => l_change_id
1061: ,X_RETURN_STATUS => l_return_status
1062: ,X_MSG_COUNT => l_msg_count
1063: ,X_MSG_DATA => l_msg_data);
1064: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1065: x_return_status := l_return_status;
1066: END IF;
1067: ELSE
1068: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR;

1064: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1065: x_return_status := l_return_status;
1066: END IF;
1067: ELSE
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;
1070:
1071: x_change_id := l_change_id;
1072:

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1083:
1084: END Insert_Into_Assignment_History;

Line 1126: x_return_status := FND_API.G_RET_STS_SUCCESS;

1122: ,x_msg => 'Beginning of Abort_Assignment_Approval'
1123: ,x_log_level => 5);
1124: END IF;
1125:
1126: x_return_status := FND_API.G_RET_STS_SUCCESS;
1127:
1128:
1129: --Get the item key of the workflow process
1130: OPEN get_item_key;

Line 1136: x_return_status := FND_API.G_RET_STS_ERROR;

1132:
1133: IF get_item_key%NOTFOUND THEN
1134: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1135: ,p_msg_name => 'PA_NO_WF_TO_ABORT');
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: END IF;
1138:
1139: CLOSE get_item_key;
1140:

Line 1141: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1137: END IF;
1138:
1139: CLOSE get_item_key;
1140:
1141: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1142: --Abort the process
1143: wf_engine.abortprocess (itemtype => l_item_type,
1144: itemkey => l_item_key);
1145:

Line 1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1161:
1162: END Abort_Assignment_Approval;

Line 1259: x_return_status := FND_API.G_RET_STS_SUCCESS;

1255: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
1256: l_change_id NUMBER;
1257:
1258: BEGIN
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;
1260:
1261: ------------------------------------------------------
1262: -- Get saved_asmt_rec
1263: ------------------------------------------------------

Line 1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1359: END get_asmt_and_asmt_history_rec;
1360: