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.PO_DOCUMENT_CHECKS_PVT dependencies on FND_API

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345:
346:
347: BEGIN
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: -- contracts document type
352: l_contracts_document_type := p_document_type||'_'||p_document_subtype;
353:

Line 382: p_init_msg_list => FND_API.G_FALSE,

378:
379: -- call the contracts QA
380: OKC_TERMS_QA_GRP.qa_Doc(
381: p_api_version => 1.0,
382: p_init_msg_list => FND_API.G_FALSE,
383: x_return_status => l_return_status,
384: x_msg_data => l_msg_data,
385: x_msg_count => l_msg_count,
386: p_qa_mode => l_qa_mode,

Line 394: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

390: x_qa_result_tbl => l_qa_result_tbl,
391: x_qa_return_status => l_qa_return_status
392: );
393:
394: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: -- if successful update error table with the messages if qa returned errors

Line 395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

391: x_qa_return_status => l_qa_return_status
392: );
393:
394: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: -- if successful update error table with the messages if qa returned errors
399: IF (l_qa_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 399: IF (l_qa_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: -- if successful update error table with the messages if qa returned errors
399: IF (l_qa_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
400: l_progress := '002';
401: l_row_index := l_qa_result_tbl.FIRST;
402: LOOP
403: EXIT WHEN l_row_index IS NULL;

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: END LOOP;
434: END IF;
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: WHEN OTHERS THEN
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF ( g_debug_unexp ) THEN

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: END IF;
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: WHEN OTHERS THEN
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF ( g_debug_unexp ) THEN
442: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

436: EXCEPTION
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: WHEN OTHERS THEN
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF ( g_debug_unexp ) THEN
442: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
443: FND_LOG.string( FND_LOG.level_unexpected,
444: G_PKG_NAME||l_api_name|| '.others_exception',

Line 506: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds

502: * tables for processing
503: * Effects: This procedure runs the document submission checks on passed in
504: * document.
505: * Returns:
506: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
507: * FND_API.G_RET_STS_ERROR if API fails
508: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
510: * submission checks, even if warnings are found

Line 507: * FND_API.G_RET_STS_ERROR if API fails

503: * Effects: This procedure runs the document submission checks on passed in
504: * document.
505: * Returns:
506: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
507: * FND_API.G_RET_STS_ERROR if API fails
508: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
510: * submission checks, even if warnings are found
511: * FND_API.G_RET_STS_ERROR if document fails atleast one

Line 508: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

504: * document.
505: * Returns:
506: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
507: * FND_API.G_RET_STS_ERROR if API fails
508: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
510: * submission checks, even if warnings are found
511: * FND_API.G_RET_STS_ERROR if document fails atleast one
512: * submission check

Line 509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all

505: * Returns:
506: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
507: * FND_API.G_RET_STS_ERROR if API fails
508: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
510: * submission checks, even if warnings are found
511: * FND_API.G_RET_STS_ERROR if document fails atleast one
512: * submission check
513: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings

Line 511: * FND_API.G_RET_STS_ERROR if document fails atleast one

507: * FND_API.G_RET_STS_ERROR if API fails
508: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
510: * submission checks, even if warnings are found
511: * FND_API.G_RET_STS_ERROR if document fails atleast one
512: * submission check
513: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
514: * FND_API.G_FALSE if no warnings are found
515: * x_msg_data: Contains error msg in case x_return_status returned

Line 513: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings

509: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
510: * submission checks, even if warnings are found
511: * FND_API.G_RET_STS_ERROR if document fails atleast one
512: * submission check
513: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
514: * FND_API.G_FALSE if no warnings are found
515: * x_msg_data: Contains error msg in case x_return_status returned
516: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
517: * x_online_report_id: This id can be used to get all submission check errors

Line 514: * FND_API.G_FALSE if no warnings are found

510: * submission checks, even if warnings are found
511: * FND_API.G_RET_STS_ERROR if document fails atleast one
512: * submission check
513: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
514: * FND_API.G_FALSE if no warnings are found
515: * x_msg_data: Contains error msg in case x_return_status returned
516: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
517: * x_online_report_id: This id can be used to get all submission check errors
518: * for given document from online_report_text table

Line 516: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

512: * submission check
513: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
514: * FND_API.G_FALSE if no warnings are found
515: * x_msg_data: Contains error msg in case x_return_status returned
516: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
517: * x_online_report_id: This id can be used to get all submission check errors
518: * for given document from online_report_text table
519: * x_doc_check_error_record: If x_sub_check_status returned G_RET_STS_ERROR
520: * then this object of tables will contain information about

Line 587: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

583: SAVEPOINT PO_SUBMISSION_CHECK_SP;
584:
585: l_progress := '000';
586: -- Standard call to check for call compatibility
587: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
588: THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:

Line 589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

585: l_progress := '000';
586: -- Standard call to check for call compatibility
587: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
588: THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: l_progress := '001';
593:

Line 629: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

625: , p_doc_level => p_document_level
626: , p_doc_level_id => p_document_level_id
627: );
628:
629: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: l_progress := '002';

Line 630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

626: , p_doc_level_id => p_document_level_id
627: );
628:
629: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: l_progress := '002';
634: --if the p_requested_changes is NOT NULL then update the global temp

Line 651: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

647: l_document_id,
648: p_requested_changes,
649: l_return_status);
650:
651: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: END IF;

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: p_requested_changes,
649: l_return_status);
650:
651: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: END IF;
656:

Line 707: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

703: p_sequence => p_sequence,
704: x_return_status => l_return_status
705: );
706:
707: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
708: THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711: --

Line 709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

705: );
706:
707: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
708: THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711: --
712:
713: l_progress := '005';

Line 732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

728: l_login_id,
729: p_sequence,
730: l_return_status);
731:
732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: l_progress := '007';

Line 733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

729: p_sequence,
730: l_return_status);
731:
732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: l_progress := '007';
737: --CBC header check for REQ

Line 747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

743: l_login_id ,
744: p_sequence,
745: l_return_status);
746:
747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750:
751: ELSIF p_document_type = 'RELEASE' THEN

Line 748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

744: p_sequence,
745: l_return_status);
746:
747: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750:
751: ELSIF p_document_type = 'RELEASE' THEN
752:

Line 797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

793: , p_doc_level_id =>p_document_level_id
794: , p_sequence =>p_sequence
795: , x_return_status =>l_return_status);
796:
797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: END IF;
800:
801: --

Line 798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

794: , p_sequence =>p_sequence
795: , x_return_status =>l_return_status);
796:
797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: END IF;
800:
801: --
802:

Line 819: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

815: l_user_id,
816: l_login_id, p_sequence,
817: l_return_status);
818:
819: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: l_progress := '010';

Line 820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

816: l_login_id, p_sequence,
817: l_return_status);
818:
819: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: l_progress := '010';
824:

Line 840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

836: l_login_id, p_sequence,
837: l_return_status);
838: END IF;
839:
840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844: l_progress := '011';

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: l_return_status);
838: END IF;
839:
840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844: l_progress := '011';
845: --CBC header check for Releases

Line 855: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

851: l_login_id ,
852: p_sequence,
853: l_return_status);
854:
855: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: END IF; --check action requested

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: p_sequence,
853: l_return_status);
854:
855: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: END IF; --check action requested
860:

Line 906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

902: , p_doc_level_id =>p_document_level_id
903: , p_sequence =>p_sequence
904: , x_return_status =>l_return_status);
905:
906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909:
910: --

Line 907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

903: , p_sequence =>p_sequence
904: , x_return_status =>l_return_status);
905:
906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909:
910: --
911:

Line 928: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

924: l_user_id,
925: l_login_id, p_sequence,
926: l_return_status);
927:
928: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: l_progress := '014';

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925: l_login_id, p_sequence,
926: l_return_status);
927:
928: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: l_progress := '014';
933: --Do all checks common to Standard and PLanned POs

Line 942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

938: -- p_check_asl, -- <2757450>
939: p_sequence,
940: l_return_status);
941:
942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;
945:
946: l_progress := '015';

Line 943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939: p_sequence,
940: l_return_status);
941:
942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;
945:
946: l_progress := '015';
947: --CBC header check for POs

Line 957: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

953: l_login_id ,
954: p_sequence,
955: l_return_status);
956:
957: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961: l_progress := '016';

Line 958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: p_sequence,
955: l_return_status);
956:
957: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961: l_progress := '016';
962:

Line 978: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

974: l_login_id, p_sequence,
975: l_return_status);
976: END IF;
977:
978: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: --Do some additional checks if its PLANNED PO

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: l_return_status);
976: END IF;
977:
978: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: --Do some additional checks if its PLANNED PO
983: IF p_document_subtype = 'PLANNED' THEN

Line 999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

995: l_user_id,
996: l_login_id, p_sequence,
997: l_return_status);
998:
999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002:
1003: ELSIF p_document_subtype = 'STANDARD' THEN

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

996: l_login_id, p_sequence,
997: l_return_status);
998:
999: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002:
1003: ELSIF p_document_subtype = 'STANDARD' THEN
1004:

Line 1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1016: l_login_id,
1017: p_sequence,
1018: l_return_status);
1019:
1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: END IF; --check doc_subtype

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: p_sequence,
1018: l_return_status);
1019:
1020: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: END IF; --check doc_subtype
1025:

Line 1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1050: , p_doc_level_id =>p_document_level_id
1051: , p_sequence =>p_sequence
1052: , x_return_status =>l_return_status);
1053:
1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;
1057:
1058: ELSE

Line 1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1051: , p_sequence =>p_sequence
1052: , x_return_status =>l_return_status);
1053:
1054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;
1057:
1058: ELSE
1059: --

Line 1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1075: l_login_id,
1076: p_sequence,
1077: l_return_status);
1078:
1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;
1082:
1083: IF p_document_subtype = 'BLANKET' THEN

Line 1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1076: p_sequence,
1077: l_return_status);
1078:
1079: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;
1082:
1083: IF p_document_subtype = 'BLANKET' THEN
1084:

Line 1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1098: p_check_asl, -- <2757450>
1099: p_sequence,
1100: l_return_status);
1101:
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END IF;
1105:
1106: l_progress := '021';

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1099: p_sequence,
1100: l_return_status);
1101:
1102: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END IF;
1105:
1106: l_progress := '021';
1107: --Call checks common to Planned PO and Blanket PA

Line 1115: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1111: l_login_id,
1112: p_sequence,
1113: l_return_status);
1114:
1115: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: ELSIF p_document_subtype = 'CONTRACT' THEN

Line 1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1112: p_sequence,
1113: l_return_status);
1114:
1115: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: ELSIF p_document_subtype = 'CONTRACT' THEN
1120:

Line 1137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1133: l_login_id,
1134: p_sequence,
1135: l_return_status);
1136:
1137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF; --PA p_document_subtype
1141: END IF; -- PA p_action_requested

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1134: p_sequence,
1135: l_return_status);
1136:
1137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF; --PA p_document_subtype
1141: END IF; -- PA p_action_requested
1142:

Line 1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1176: p_login_id => l_login_id,
1177: p_sequence => p_sequence,
1178: x_return_status => l_return_status);
1179:
1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: END IF; --conterms exist
1184: END IF; -- document type is PO or PA

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1177: p_sequence => p_sequence,
1178: x_return_status => l_return_status);
1179:
1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: END IF; --conterms exist
1184: END IF; -- document type is PO or PA
1185:

Line 1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1214: FROM PO_RELEASES_ALL
1215: WHERE po_release_id = l_document_id;
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END;
1220: ELSE
1221: l_po_header_id := l_document_id;
1222: END IF;

Line 1233: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1229: p_login_id => l_login_id,
1230: p_sequence => p_sequence,
1231: x_return_status => l_return_status);
1232:
1233: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: END IF;
1236: END IF;
1237:

Line 1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1230: p_sequence => p_sequence,
1231: x_return_status => l_return_status);
1232:
1233: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: END IF;
1236: END IF;
1237:
1238: l_progress := '025';

Line 1271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1267: p_sequence => p_sequence,
1268: x_return_status => l_return_status
1269: );
1270:
1271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1272: THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275: --

Line 1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1269: );
1270:
1271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1272: THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275: --
1276:
1277:

Line 1308: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1304: -- 1) Return Error only if there are messages that are not warnings
1305: -- 2) Set x_has_warnings flag to TRUE if there are warnings reported
1306:
1307: IF (l_num_messages > l_num_warnings) THEN
1308: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1309: ELSE
1310: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
1311: END IF;
1312:

Line 1310: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;

1306:
1307: IF (l_num_messages > l_num_warnings) THEN
1308: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1309: ELSE
1310: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
1311: END IF;
1312:
1313: IF ( l_num_warnings > 0 ) THEN
1314: x_has_warnings := FND_API.G_TRUE;

Line 1314: x_has_warnings := FND_API.G_TRUE;

1310: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
1311: END IF;
1312:
1313: IF ( l_num_warnings > 0 ) THEN
1314: x_has_warnings := FND_API.G_TRUE;
1315: END IF;
1316:
1317: --Bulk update online_report_text table with errors
1318: INSERT INTO po_online_report_text(online_report_id,

Line 1365: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;

1361: FROM po_online_report_text_gt
1362: WHERE online_report_id = x_online_report_id;
1363:
1364: ELSE
1365: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
1366: END IF;
1367:
1368: l_progress := '027';
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1369: x_return_status := FND_API.G_RET_STS_SUCCESS;

1365: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
1366: END IF;
1367:
1368: l_progress := '027';
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1370:
1371: -- LCM ER start. If all the submission checks have been passed successfully then update the lcm_flag of po_line_locations_all and po_distributions_all.
1372: IF p_document_type in ('PO','RELEASE') THEN
1373:

Line 1380: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1376: LOOP
1377: set_lcm_flag(ship_rec.line_location_id,'AFTER',l_return_status);
1378: END LOOP;
1379:
1380: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382: END IF;
1383: END IF;
1384: --LCM ER end

Line 1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1377: set_lcm_flag(ship_rec.line_location_id,'AFTER',l_return_status);
1378: END LOOP;
1379:
1380: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382: END IF;
1383: END IF;
1384: --LCM ER end
1385:

Line 1400: WHEN FND_API.G_EXC_ERROR THEN

1396: END IF;
1397: END IF;
1398:
1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1404: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1402: x_return_status := FND_API.G_RET_STS_ERROR;

1398:
1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1404: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1405: p_encoded => 'F');
1406:

Line 1403: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1404: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1405: p_encoded => 'F');
1406:
1407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1403: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1404: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1405: p_encoded => 'F');
1406:
1407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1408: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1411: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1405: p_encoded => 'F');
1406:
1407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1408: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1411: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1412: p_encoded => 'F');
1413:

Line 1410: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1406:
1407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1408: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1411: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1412: p_encoded => 'F');
1413:
1414: WHEN OTHERS THEN

Line 1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1412: p_encoded => 'F');
1413:
1414: WHEN OTHERS THEN
1415: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1419: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
1420: END IF;

Line 1417: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1413:
1414: WHEN OTHERS THEN
1415: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1419: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
1420: END IF;
1421:

Line 1463: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1459:
1460: l_progress := '000';
1461:
1462: -- Standard call to check for call compatibility
1463: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1464: THEN
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: END IF;
1467:

Line 1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1461:
1462: -- Standard call to check for call compatibility
1463: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1464: THEN
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: END IF;
1467:
1468: l_progress := '001';
1469:

Line 1487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1483: , p_doc_level => g_document_level_HEADER
1484: , p_doc_level_id => p_document_id
1485: );
1486:
1487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: END IF;
1490:
1491: IF g_debug_stmt THEN

Line 1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1484: , p_doc_level_id => p_document_id
1485: );
1486:
1487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: END IF;
1490:
1491: IF g_debug_stmt THEN
1492: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1559: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1555: x_online_report_id := l_online_report_id;
1556:
1557: IF l_num_errors > 0 THEN
1558:
1559: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1560:
1561: --Bulk update online_report_text table with errors
1562: INSERT INTO po_online_report_text(
1563: online_report_id,

Line 1591: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;

1587:
1588: l_progress := '009';
1589:
1590: ELSE
1591: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
1592: END IF;
1593:
1594: l_progress := '010';
1595:

Line 1596: x_return_status := FND_API.G_RET_STS_SUCCESS;

1592: END IF;
1593:
1594: l_progress := '010';
1595:
1596: x_return_status := FND_API.G_RET_STS_SUCCESS;
1597:
1598: -- bug3413891
1599: -- Deletion of GT tables has been moved to populate_global_temp_tables procedure
1600:

Line 1613: WHEN FND_API.G_EXC_ERROR THEN

1609: END IF;
1610:
1611: EXCEPTION
1612:
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1617:

Line 1615: x_return_status := FND_API.G_RET_STS_ERROR;

1611: EXCEPTION
1612:
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO POST_SUBMISSION_CHECK_SP;

Line 1616: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1612:
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1614: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1622:

Line 1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1616: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO POST_SUBMISSION_CHECK_SP;

Line 1621: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1621: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1628: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
1629: END IF;

Line 1626: x_sub_check_status := FND_API.G_RET_STS_ERROR;

1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: x_sub_check_status := FND_API.G_RET_STS_ERROR;
1627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1628: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
1629: END IF;
1630:

Line 2125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2121: po_tax_interface_pvt.calculate_tax_requisition( x_return_status => l_return_status,
2122: p_requisition_header_id => p_document_id,
2123: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
2124:
2125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2126: l_progress := '011';
2127: IF g_debug_stmt THEN
2128: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||

Line 2171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2167: 'PO_TAX_CALCULATION_FAILED',
2168: 'E'
2169: );
2170: l_progress := '012';
2171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2172: l_progress := '013';
2173: IF g_debug_stmt THEN
2174: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2175: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||

Line 2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2186: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
2187: fnd_message.set_token('ERROR',l_textline);
2188: FND_MSG_PUB.Add;
2189: l_progress := '014';
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191: END IF;
2192: END IF;
2193:
2194: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 2200: x_return_status := FND_API.G_RET_STS_SUCCESS;

2196: -----------------------------------------------------------------------------
2197:
2198: l_progress := '015';
2199: --
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201: EXCEPTION
2202: WHEN FND_API.G_EXC_ERROR THEN
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204:

Line 2202: WHEN FND_API.G_EXC_ERROR THEN

2198: l_progress := '015';
2199: --
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201: EXCEPTION
2202: WHEN FND_API.G_EXC_ERROR THEN
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204:
2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2203: x_return_status := FND_API.G_RET_STS_ERROR;

2199: --
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201: EXCEPTION
2202: WHEN FND_API.G_EXC_ERROR THEN
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204:
2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207:

Line 2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2201: EXCEPTION
2202: WHEN FND_API.G_EXC_ERROR THEN
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204:
2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207:
2208: WHEN OTHERS THEN
2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2202: WHEN FND_API.G_EXC_ERROR THEN
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204:
2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207:
2208: WHEN OTHERS THEN
2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2210: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207:
2208: WHEN OTHERS THEN
2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2210: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2211: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
2212: END IF;
2213:

Line 3785: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3781: p_po_header_id => NULL,
3782: p_po_release_id => p_document_id,
3783: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
3784: l_progress := '022';
3785: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3786: IF g_debug_stmt THEN
3787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3788: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||
3789: l_api_name||'.' || l_progress,

Line 3831: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3827: 'PO_TAX_CALCULATION_FAILED',
3828: 'E'
3829: );
3830: l_progress := '024';
3831: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3832: IF g_debug_stmt THEN
3833: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3834: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||
3835: l_api_name||'.' || l_progress,

Line 3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3845: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
3846: fnd_message.set_token('ERROR',l_textline);
3847: FND_MSG_PUB.Add;
3848: l_progress := '025';
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3850: END IF;
3851: END IF;
3852:
3853: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 3950: x_return_status := FND_API.G_RET_STS_SUCCESS;

3946: --Increment the p_sequence with number of errors reported in last query
3947: p_sequence := p_sequence + SQL%ROWCOUNT;
3948: ----------------------------------------------------------------------------------------
3949:
3950: x_return_status := FND_API.G_RET_STS_SUCCESS;
3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: x_return_status := FND_API.G_RET_STS_ERROR;
3954:

Line 3952: WHEN FND_API.G_EXC_ERROR THEN

3948: ----------------------------------------------------------------------------------------
3949:
3950: x_return_status := FND_API.G_RET_STS_SUCCESS;
3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: x_return_status := FND_API.G_RET_STS_ERROR;
3954:
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3953: x_return_status := FND_API.G_RET_STS_ERROR;

3949:
3950: x_return_status := FND_API.G_RET_STS_SUCCESS;
3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: x_return_status := FND_API.G_RET_STS_ERROR;
3954:
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3957:

Line 3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3951: EXCEPTION
3952: WHEN FND_API.G_EXC_ERROR THEN
3953: x_return_status := FND_API.G_RET_STS_ERROR;
3954:
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3957:
3958: WHEN OTHERS THEN
3959:

Line 3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3952: WHEN FND_API.G_EXC_ERROR THEN
3953: x_return_status := FND_API.G_RET_STS_ERROR;
3954:
3955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3957:
3958: WHEN OTHERS THEN
3959:
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3957:
3958: WHEN OTHERS THEN
3959:
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3962: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
3963: END IF;
3964:

Line 4765: x_return_status := FND_API.G_RET_STS_SUCCESS;

4761:
4762: END LOOP; --for shipment_line
4763:
4764: l_progress := '013';
4765: x_return_status := FND_API.G_RET_STS_SUCCESS;
4766: EXCEPTION
4767: WHEN FND_API.G_EXC_ERROR THEN
4768: x_return_status := FND_API.G_RET_STS_ERROR;
4769:

Line 4767: WHEN FND_API.G_EXC_ERROR THEN

4763:
4764: l_progress := '013';
4765: x_return_status := FND_API.G_RET_STS_SUCCESS;
4766: EXCEPTION
4767: WHEN FND_API.G_EXC_ERROR THEN
4768: x_return_status := FND_API.G_RET_STS_ERROR;
4769:
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4768: x_return_status := FND_API.G_RET_STS_ERROR;

4764: l_progress := '013';
4765: x_return_status := FND_API.G_RET_STS_SUCCESS;
4766: EXCEPTION
4767: WHEN FND_API.G_EXC_ERROR THEN
4768: x_return_status := FND_API.G_RET_STS_ERROR;
4769:
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4772:

Line 4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4766: EXCEPTION
4767: WHEN FND_API.G_EXC_ERROR THEN
4768: x_return_status := FND_API.G_RET_STS_ERROR;
4769:
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4772:
4773: WHEN OTHERS THEN
4774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4767: WHEN FND_API.G_EXC_ERROR THEN
4768: x_return_status := FND_API.G_RET_STS_ERROR;
4769:
4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4772:
4773: WHEN OTHERS THEN
4774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4775: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 4774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4772:
4773: WHEN OTHERS THEN
4774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4775: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4776: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
4777: END IF;
4778:

Line 5549: x_return_status := FND_API.G_RET_STS_SUCCESS;

5545: p_sequence := p_sequence + SQL%ROWCOUNT;
5546: end if;
5547:
5548: l_progress := '050';
5549: x_return_status := FND_API.G_RET_STS_SUCCESS;
5550: EXCEPTION
5551: WHEN FND_API.G_EXC_ERROR THEN
5552: x_return_status := FND_API.G_RET_STS_ERROR;
5553:

Line 5551: WHEN FND_API.G_EXC_ERROR THEN

5547:
5548: l_progress := '050';
5549: x_return_status := FND_API.G_RET_STS_SUCCESS;
5550: EXCEPTION
5551: WHEN FND_API.G_EXC_ERROR THEN
5552: x_return_status := FND_API.G_RET_STS_ERROR;
5553:
5554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5552: x_return_status := FND_API.G_RET_STS_ERROR;

5548: l_progress := '050';
5549: x_return_status := FND_API.G_RET_STS_SUCCESS;
5550: EXCEPTION
5551: WHEN FND_API.G_EXC_ERROR THEN
5552: x_return_status := FND_API.G_RET_STS_ERROR;
5553:
5554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5556:

Line 5554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5550: EXCEPTION
5551: WHEN FND_API.G_EXC_ERROR THEN
5552: x_return_status := FND_API.G_RET_STS_ERROR;
5553:
5554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5556:
5557: WHEN OTHERS THEN
5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5551: WHEN FND_API.G_EXC_ERROR THEN
5552: x_return_status := FND_API.G_RET_STS_ERROR;
5553:
5554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5556:
5557: WHEN OTHERS THEN
5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5556:
5557: WHEN OTHERS THEN
5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5560: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
5561: END IF;
5562:

Line 6906: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6902: p_po_header_id => p_document_id,
6903: p_po_release_id => NULL,
6904: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
6905:
6906: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6907: IF g_debug_stmt THEN
6908: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6909: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head ||
6910: l_api_name||'.' || l_progress,

Line 6949: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6945: 'PO_TAX_CALCULATION_FAILED',
6946: 'E'
6947: );
6948: l_progress := '024';
6949: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6950: IF g_debug_stmt THEN
6951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head ||
6953: l_api_name||'.' || l_progress,

Line 6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6963: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
6964: fnd_message.set_token('ERROR',l_textline);
6965: FND_MSG_PUB.Add;
6966: l_progress := '025';
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END IF;
6969: END IF;
6970:
6971: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 7318: x_return_status := FND_API.G_RET_STS_SUCCESS;

7314: --Increment the p_sequence with number of errors reported in last query
7315: p_sequence := p_sequence + SQL%ROWCOUNT;
7316:
7317: -------------------------------------------------------------------------------------------------------
7318: x_return_status := FND_API.G_RET_STS_SUCCESS;
7319:
7320: EXCEPTION
7321: WHEN FND_API.G_EXC_ERROR THEN
7322: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7321: WHEN FND_API.G_EXC_ERROR THEN

7317: -------------------------------------------------------------------------------------------------------
7318: x_return_status := FND_API.G_RET_STS_SUCCESS;
7319:
7320: EXCEPTION
7321: WHEN FND_API.G_EXC_ERROR THEN
7322: x_return_status := FND_API.G_RET_STS_ERROR;
7323:
7324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7322: x_return_status := FND_API.G_RET_STS_ERROR;

7318: x_return_status := FND_API.G_RET_STS_SUCCESS;
7319:
7320: EXCEPTION
7321: WHEN FND_API.G_EXC_ERROR THEN
7322: x_return_status := FND_API.G_RET_STS_ERROR;
7323:
7324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7326:

Line 7324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7320: EXCEPTION
7321: WHEN FND_API.G_EXC_ERROR THEN
7322: x_return_status := FND_API.G_RET_STS_ERROR;
7323:
7324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7326:
7327: WHEN OTHERS THEN
7328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7321: WHEN FND_API.G_EXC_ERROR THEN
7322: x_return_status := FND_API.G_RET_STS_ERROR;
7323:
7324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7326:
7327: WHEN OTHERS THEN
7328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 7328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7326:
7327: WHEN OTHERS THEN
7328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7330: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
7331: END IF;
7332:

Line 7629: x_return_status := FND_API.G_RET_STS_SUCCESS;

7625:
7626: /* End Bug 3286940 */
7627:
7628:
7629: x_return_status := FND_API.G_RET_STS_SUCCESS;
7630: EXCEPTION
7631: WHEN FND_API.G_EXC_ERROR THEN
7632: x_return_status := FND_API.G_RET_STS_ERROR;
7633:

Line 7631: WHEN FND_API.G_EXC_ERROR THEN

7627:
7628:
7629: x_return_status := FND_API.G_RET_STS_SUCCESS;
7630: EXCEPTION
7631: WHEN FND_API.G_EXC_ERROR THEN
7632: x_return_status := FND_API.G_RET_STS_ERROR;
7633:
7634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7632: x_return_status := FND_API.G_RET_STS_ERROR;

7628:
7629: x_return_status := FND_API.G_RET_STS_SUCCESS;
7630: EXCEPTION
7631: WHEN FND_API.G_EXC_ERROR THEN
7632: x_return_status := FND_API.G_RET_STS_ERROR;
7633:
7634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636:

Line 7634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7630: EXCEPTION
7631: WHEN FND_API.G_EXC_ERROR THEN
7632: x_return_status := FND_API.G_RET_STS_ERROR;
7633:
7634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636:
7637: WHEN OTHERS THEN
7638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7631: WHEN FND_API.G_EXC_ERROR THEN
7632: x_return_status := FND_API.G_RET_STS_ERROR;
7633:
7634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636:
7637: WHEN OTHERS THEN
7638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 7638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636:
7637: WHEN OTHERS THEN
7638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7640: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
7641: END IF;
7642:

Line 7967: x_return_status := FND_API.G_RET_STS_SUCCESS;

7963: --
7964:
7965:
7966: l_progress := '008';
7967: x_return_status := FND_API.G_RET_STS_SUCCESS;
7968: EXCEPTION
7969: WHEN FND_API.G_EXC_ERROR THEN
7970: x_return_status := FND_API.G_RET_STS_ERROR;
7971:

Line 7969: WHEN FND_API.G_EXC_ERROR THEN

7965:
7966: l_progress := '008';
7967: x_return_status := FND_API.G_RET_STS_SUCCESS;
7968: EXCEPTION
7969: WHEN FND_API.G_EXC_ERROR THEN
7970: x_return_status := FND_API.G_RET_STS_ERROR;
7971:
7972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7970: x_return_status := FND_API.G_RET_STS_ERROR;

7966: l_progress := '008';
7967: x_return_status := FND_API.G_RET_STS_SUCCESS;
7968: EXCEPTION
7969: WHEN FND_API.G_EXC_ERROR THEN
7970: x_return_status := FND_API.G_RET_STS_ERROR;
7971:
7972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7974:

Line 7972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7968: EXCEPTION
7969: WHEN FND_API.G_EXC_ERROR THEN
7970: x_return_status := FND_API.G_RET_STS_ERROR;
7971:
7972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7974:
7975: WHEN OTHERS THEN
7976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7969: WHEN FND_API.G_EXC_ERROR THEN
7970: x_return_status := FND_API.G_RET_STS_ERROR;
7971:
7972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7974:
7975: WHEN OTHERS THEN
7976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 7976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7974:
7975: WHEN OTHERS THEN
7976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7978: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
7979: END IF;
7980:

Line 8075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8071: p_login_id ,
8072: p_sequence,
8073: l_return_status);
8074:
8075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8077: END IF;
8078:
8079: END IF;

Line 8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8072: p_sequence,
8073: l_return_status);
8074:
8075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8077: END IF;
8078:
8079: END IF;
8080:

Line 8100: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

8096: x_sequence => p_sequence,
8097: x_return_status => l_return_status
8098: );
8099:
8100: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8102: END IF;
8103: END IF;
8104:

Line 8101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8097: x_return_status => l_return_status
8098: );
8099:
8100: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8102: END IF;
8103: END IF;
8104:
8105: --

Line 8117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8113: p_login_id ,
8114: p_sequence,
8115: l_return_status);
8116:
8117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8119: END IF;
8120:
8121: l_progress := '003';

Line 8118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8114: p_sequence,
8115: l_return_status);
8116:
8117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8119: END IF;
8120:
8121: l_progress := '003';
8122:

Line 8127: x_return_status := FND_API.G_RET_STS_SUCCESS;

8123: -- Bug 3379488: Removed the Dest OU check for shipments with expense
8124: -- destinations with project-specified, because this scenario is prevented
8125: -- at an early stage and would not happen here
8126:
8127: x_return_status := FND_API.G_RET_STS_SUCCESS;
8128: EXCEPTION
8129: WHEN FND_API.G_EXC_ERROR THEN
8130: x_return_status := FND_API.G_RET_STS_ERROR;
8131:

Line 8129: WHEN FND_API.G_EXC_ERROR THEN

8125: -- at an early stage and would not happen here
8126:
8127: x_return_status := FND_API.G_RET_STS_SUCCESS;
8128: EXCEPTION
8129: WHEN FND_API.G_EXC_ERROR THEN
8130: x_return_status := FND_API.G_RET_STS_ERROR;
8131:
8132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8130: x_return_status := FND_API.G_RET_STS_ERROR;

8126:
8127: x_return_status := FND_API.G_RET_STS_SUCCESS;
8128: EXCEPTION
8129: WHEN FND_API.G_EXC_ERROR THEN
8130: x_return_status := FND_API.G_RET_STS_ERROR;
8131:
8132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8134:

Line 8132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8128: EXCEPTION
8129: WHEN FND_API.G_EXC_ERROR THEN
8130: x_return_status := FND_API.G_RET_STS_ERROR;
8131:
8132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8134:
8135: WHEN OTHERS THEN
8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8129: WHEN FND_API.G_EXC_ERROR THEN
8130: x_return_status := FND_API.G_RET_STS_ERROR;
8131:
8132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8134:
8135: WHEN OTHERS THEN
8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8134:
8135: WHEN OTHERS THEN
8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8138: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
8139: END IF;
8140:

Line 8456: x_return_status := FND_API.G_RET_STS_SUCCESS;

8452: --Increment the p_sequence with number of errors reported in last query
8453: p_sequence := p_sequence + l_line_num.COUNT;
8454:
8455: l_progress := '005';
8456: x_return_status := FND_API.G_RET_STS_SUCCESS;
8457: EXCEPTION
8458: WHEN FND_API.G_EXC_ERROR THEN
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460:

Line 8458: WHEN FND_API.G_EXC_ERROR THEN

8454:
8455: l_progress := '005';
8456: x_return_status := FND_API.G_RET_STS_SUCCESS;
8457: EXCEPTION
8458: WHEN FND_API.G_EXC_ERROR THEN
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460:
8461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8459: x_return_status := FND_API.G_RET_STS_ERROR;

8455: l_progress := '005';
8456: x_return_status := FND_API.G_RET_STS_SUCCESS;
8457: EXCEPTION
8458: WHEN FND_API.G_EXC_ERROR THEN
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460:
8461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8463:

Line 8461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8457: EXCEPTION
8458: WHEN FND_API.G_EXC_ERROR THEN
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460:
8461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8463:
8464: WHEN OTHERS THEN
8465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8458: WHEN FND_API.G_EXC_ERROR THEN
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460:
8461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8463:
8464: WHEN OTHERS THEN
8465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 8465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8463:
8464: WHEN OTHERS THEN
8465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8467: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
8468: END IF;
8469:

Line 9341: x_return_status := FND_API.G_RET_STS_SUCCESS;

9337:
9338: ------------------------------------
9339:
9340: l_progress := '012';
9341: x_return_status := FND_API.G_RET_STS_SUCCESS;
9342: EXCEPTION
9343: WHEN FND_API.G_EXC_ERROR THEN
9344: x_return_status := FND_API.G_RET_STS_ERROR;
9345:

Line 9343: WHEN FND_API.G_EXC_ERROR THEN

9339:
9340: l_progress := '012';
9341: x_return_status := FND_API.G_RET_STS_SUCCESS;
9342: EXCEPTION
9343: WHEN FND_API.G_EXC_ERROR THEN
9344: x_return_status := FND_API.G_RET_STS_ERROR;
9345:
9346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9344: x_return_status := FND_API.G_RET_STS_ERROR;

9340: l_progress := '012';
9341: x_return_status := FND_API.G_RET_STS_SUCCESS;
9342: EXCEPTION
9343: WHEN FND_API.G_EXC_ERROR THEN
9344: x_return_status := FND_API.G_RET_STS_ERROR;
9345:
9346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9348:

Line 9346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9342: EXCEPTION
9343: WHEN FND_API.G_EXC_ERROR THEN
9344: x_return_status := FND_API.G_RET_STS_ERROR;
9345:
9346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9348:
9349: WHEN OTHERS THEN
9350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9343: WHEN FND_API.G_EXC_ERROR THEN
9344: x_return_status := FND_API.G_RET_STS_ERROR;
9345:
9346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9348:
9349: WHEN OTHERS THEN
9350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 9350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9348:
9349: WHEN OTHERS THEN
9350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
9352: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
9353: END IF;
9354:

Line 9402: l_currency_mismatch VARCHAR2(1) := FND_API.G_FALSE;

9398:
9399: l_textline PO_ONLINE_REPORT_TEXT.text_line%TYPE := NULL;
9400: l_api_name CONSTANT VARCHAR2(40) := 'CHECK_STD_GC_REF';
9401: l_progress VARCHAR2(3);
9402: l_currency_mismatch VARCHAR2(1) := FND_API.G_FALSE;
9403:
9404: TYPE NumTab is TABLE of NUMBER INDEX BY BINARY_INTEGER;
9405: l_curr_doc_line_num NumTab;
9406: l_prev_doc_line_num NumTab;

Line 9731: x_return_status := FND_API.G_RET_STS_SUCCESS;

9727: x_sequence := x_sequence + l_rowcount;
9728:
9729:
9730: l_progress := '999';
9731: x_return_status := FND_API.G_RET_STS_SUCCESS;
9732:
9733: EXCEPTION
9734: WHEN FND_API.G_EXC_ERROR THEN
9735: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9734: WHEN FND_API.G_EXC_ERROR THEN

9730: l_progress := '999';
9731: x_return_status := FND_API.G_RET_STS_SUCCESS;
9732:
9733: EXCEPTION
9734: WHEN FND_API.G_EXC_ERROR THEN
9735: x_return_status := FND_API.G_RET_STS_ERROR;
9736:
9737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9735: x_return_status := FND_API.G_RET_STS_ERROR;

9731: x_return_status := FND_API.G_RET_STS_SUCCESS;
9732:
9733: EXCEPTION
9734: WHEN FND_API.G_EXC_ERROR THEN
9735: x_return_status := FND_API.G_RET_STS_ERROR;
9736:
9737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9739:

Line 9737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9733: EXCEPTION
9734: WHEN FND_API.G_EXC_ERROR THEN
9735: x_return_status := FND_API.G_RET_STS_ERROR;
9736:
9737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9739:
9740: WHEN OTHERS THEN
9741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9734: WHEN FND_API.G_EXC_ERROR THEN
9735: x_return_status := FND_API.G_RET_STS_ERROR;
9736:
9737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9739:
9740: WHEN OTHERS THEN
9741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 9741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9739:
9740: WHEN OTHERS THEN
9741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
9743: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
9744: END IF;
9745:

Line 9871: x_return_status := FND_API.G_RET_STS_SUCCESS;

9867: --Increment the p_sequence with number of errors reported in last query
9868: p_sequence := p_sequence + SQL%ROWCOUNT;
9869:
9870: l_progress := '002';
9871: x_return_status := FND_API.G_RET_STS_SUCCESS;
9872: EXCEPTION
9873: WHEN FND_API.G_EXC_ERROR THEN
9874: x_return_status := FND_API.G_RET_STS_ERROR;
9875:

Line 9873: WHEN FND_API.G_EXC_ERROR THEN

9869:
9870: l_progress := '002';
9871: x_return_status := FND_API.G_RET_STS_SUCCESS;
9872: EXCEPTION
9873: WHEN FND_API.G_EXC_ERROR THEN
9874: x_return_status := FND_API.G_RET_STS_ERROR;
9875:
9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9874: x_return_status := FND_API.G_RET_STS_ERROR;

9870: l_progress := '002';
9871: x_return_status := FND_API.G_RET_STS_SUCCESS;
9872: EXCEPTION
9873: WHEN FND_API.G_EXC_ERROR THEN
9874: x_return_status := FND_API.G_RET_STS_ERROR;
9875:
9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9878:

Line 9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9872: EXCEPTION
9873: WHEN FND_API.G_EXC_ERROR THEN
9874: x_return_status := FND_API.G_RET_STS_ERROR;
9875:
9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9878:
9879: WHEN OTHERS THEN
9880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9873: WHEN FND_API.G_EXC_ERROR THEN
9874: x_return_status := FND_API.G_RET_STS_ERROR;
9875:
9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9878:
9879: WHEN OTHERS THEN
9880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 9880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9878:
9879: WHEN OTHERS THEN
9880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
9882: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
9883: END IF;
9884:

Line 9944: p_init_msg_list => FND_API.G_FALSE,

9940: END IF;
9941: END IF;
9942:
9943: IGC_CBC_PO_GRP.IS_CBC_ENABLED ( p_api_version => 1.0,
9944: p_init_msg_list => FND_API.G_FALSE,
9945: p_commit => FND_API.G_FALSE,
9946: p_validation_level => 100,
9947: x_return_status => l_return_status,
9948: x_msg_count => l_msg_count,

Line 9945: p_commit => FND_API.G_FALSE,

9941: END IF;
9942:
9943: IGC_CBC_PO_GRP.IS_CBC_ENABLED ( p_api_version => 1.0,
9944: p_init_msg_list => FND_API.G_FALSE,
9945: p_commit => FND_API.G_FALSE,
9946: p_validation_level => 100,
9947: x_return_status => l_return_status,
9948: x_msg_count => l_msg_count,
9949: x_msg_data => l_msg_data,

Line 9952: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9948: x_msg_count => l_msg_count,
9949: x_msg_data => l_msg_data,
9950: x_cbc_enabled => l_cbc_enabled);
9951:
9952: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9954: END IF;
9955:
9956: l_progress := '001';

Line 9953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9949: x_msg_data => l_msg_data,
9950: x_cbc_enabled => l_cbc_enabled);
9951:
9952: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9954: END IF;
9955:
9956: l_progress := '001';
9957: IF g_debug_stmt THEN

Line 9968: p_init_msg_list => FND_API.G_FALSE,

9964: IF l_cbc_enabled = 'Y' THEN
9965:
9966: IGC_CBC_PO_GRP.CBC_HEADER_VALIDATIONS(
9967: p_api_version => 1.0,
9968: p_init_msg_list => FND_API.G_FALSE,
9969: p_commit => FND_API.G_FALSE,
9970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9971: x_return_status => l_return_status,
9972: x_msg_count => l_msg_count,

Line 9969: p_commit => FND_API.G_FALSE,

9965:
9966: IGC_CBC_PO_GRP.CBC_HEADER_VALIDATIONS(
9967: p_api_version => 1.0,
9968: p_init_msg_list => FND_API.G_FALSE,
9969: p_commit => FND_API.G_FALSE,
9970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9971: x_return_status => l_return_status,
9972: x_msg_count => l_msg_count,
9973: x_msg_data =>l_msg_data,

Line 9970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9966: IGC_CBC_PO_GRP.CBC_HEADER_VALIDATIONS(
9967: p_api_version => 1.0,
9968: p_init_msg_list => FND_API.G_FALSE,
9969: p_commit => FND_API.G_FALSE,
9970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9971: x_return_status => l_return_status,
9972: x_msg_count => l_msg_count,
9973: x_msg_data =>l_msg_data,
9974: p_document_id => p_document_id,

Line 9986: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9982: || l_progress,'CBC call returned '|| l_return_status);
9983: END IF;
9984: END IF;
9985:
9986: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9988: END IF;
9989:
9990: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 9987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9983: END IF;
9984: END IF;
9985:
9986: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9988: END IF;
9989:
9990: IF l_return_status = FND_API.G_RET_STS_ERROR
9991: THEN

Line 9990: IF l_return_status = FND_API.G_RET_STS_ERROR

9986: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9988: END IF;
9989:
9990: IF l_return_status = FND_API.G_RET_STS_ERROR
9991: THEN
9992: l_textline := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
9993: p_encoded => 'F');
9994:

Line 10034: x_return_status := FND_API.G_RET_STS_SUCCESS;

10030:
10031: END IF; --cbc is enabled
10032:
10033: l_progress := '004';
10034: x_return_status := FND_API.G_RET_STS_SUCCESS;
10035: EXCEPTION
10036: WHEN FND_API.G_EXC_ERROR THEN
10037: x_return_status := FND_API.G_RET_STS_ERROR;
10038:

Line 10036: WHEN FND_API.G_EXC_ERROR THEN

10032:
10033: l_progress := '004';
10034: x_return_status := FND_API.G_RET_STS_SUCCESS;
10035: EXCEPTION
10036: WHEN FND_API.G_EXC_ERROR THEN
10037: x_return_status := FND_API.G_RET_STS_ERROR;
10038:
10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10037: x_return_status := FND_API.G_RET_STS_ERROR;

10033: l_progress := '004';
10034: x_return_status := FND_API.G_RET_STS_SUCCESS;
10035: EXCEPTION
10036: WHEN FND_API.G_EXC_ERROR THEN
10037: x_return_status := FND_API.G_RET_STS_ERROR;
10038:
10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10041:

Line 10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10035: EXCEPTION
10036: WHEN FND_API.G_EXC_ERROR THEN
10037: x_return_status := FND_API.G_RET_STS_ERROR;
10038:
10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10041:
10042: WHEN OTHERS THEN
10043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10036: WHEN FND_API.G_EXC_ERROR THEN
10037: x_return_status := FND_API.G_RET_STS_ERROR;
10038:
10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10041:
10042: WHEN OTHERS THEN
10043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 10043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10041:
10042: WHEN OTHERS THEN
10043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10045: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10046: END IF;
10047:

Line 10171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10167:
10168: --populate the global REQ headers table
10169: populate_req_headers_gt(l_doc_id, l_return_status);
10170:
10171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10173: END IF;
10174:
10175: l_progress := '002';

Line 10172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10168: --populate the global REQ headers table
10169: populate_req_headers_gt(l_doc_id, l_return_status);
10170:
10171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10173: END IF;
10174:
10175: l_progress := '002';
10176: --populate the global REQ line table

Line 10179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10175: l_progress := '002';
10176: --populate the global REQ line table
10177: populate_req_lines_gt(l_doc_id, l_return_status);
10178:
10179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10181: END IF;
10182:
10183: ELSIF p_doc_type in ('PO', 'PA') THEN

Line 10180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10176: --populate the global REQ line table
10177: populate_req_lines_gt(l_doc_id, l_return_status);
10178:
10179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10181: END IF;
10182:
10183: ELSIF p_doc_type in ('PO', 'PA') THEN
10184: l_progress := '004';

Line 10195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10191:
10192: --populate the global headers table
10193: populate_po_headers_gt(l_doc_id, l_return_status);
10194:
10195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10197: END IF;
10198:
10199: l_progress := '005';

Line 10196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10192: --populate the global headers table
10193: populate_po_headers_gt(l_doc_id, l_return_status);
10194:
10195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10197: END IF;
10198:
10199: l_progress := '005';
10200:

Line 10212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10208: , p_doc_level_id => p_doc_level_id
10209: , x_return_status => l_return_status
10210: );
10211:
10212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10214: END IF;
10215:
10216: ELSIF p_doc_type = 'RELEASE' THEN

Line 10213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10209: , x_return_status => l_return_status
10210: );
10211:
10212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10214: END IF;
10215:
10216: ELSIF p_doc_type = 'RELEASE' THEN
10217: l_progress := '008';

Line 10228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10224:
10225: --populate the global release table
10226: populate_releases_gt(l_doc_id, l_return_status);
10227:
10228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10230: END IF;
10231:
10232: l_progress := '009';

Line 10229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10225: --populate the global release table
10226: populate_releases_gt(l_doc_id, l_return_status);
10227:
10228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10230: END IF;
10231:
10232: l_progress := '009';
10233: -- Get the header_id of the relevent Blanket

Line 10244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10240: --populate the global headers table with header of blanket/planned PO
10241: --for which this is a Release
10242: populate_po_headers_gt(l_blanket_header_id, l_return_status);
10243:
10244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10246: END IF;
10247:
10248: END IF;

Line 10245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10241: --for which this is a Release
10242: populate_po_headers_gt(l_blanket_header_id, l_return_status);
10243:
10244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10246: END IF;
10247:
10248: END IF;
10249:

Line 10286: x_return_status := FND_API.G_RET_STS_SUCCESS;

10282:
10283: --LCM ER end.
10284: l_progress := '900';
10285:
10286: x_return_status := FND_API.G_RET_STS_SUCCESS;
10287: EXCEPTION
10288: WHEN FND_API.G_EXC_ERROR THEN
10289: x_return_status := FND_API.G_RET_STS_ERROR;
10290:

Line 10288: WHEN FND_API.G_EXC_ERROR THEN

10284: l_progress := '900';
10285:
10286: x_return_status := FND_API.G_RET_STS_SUCCESS;
10287: EXCEPTION
10288: WHEN FND_API.G_EXC_ERROR THEN
10289: x_return_status := FND_API.G_RET_STS_ERROR;
10290:
10291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10289: x_return_status := FND_API.G_RET_STS_ERROR;

10285:
10286: x_return_status := FND_API.G_RET_STS_SUCCESS;
10287: EXCEPTION
10288: WHEN FND_API.G_EXC_ERROR THEN
10289: x_return_status := FND_API.G_RET_STS_ERROR;
10290:
10291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10293:

Line 10291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10287: EXCEPTION
10288: WHEN FND_API.G_EXC_ERROR THEN
10289: x_return_status := FND_API.G_RET_STS_ERROR;
10290:
10291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10293:
10294: WHEN OTHERS THEN
10295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10288: WHEN FND_API.G_EXC_ERROR THEN
10289: x_return_status := FND_API.G_RET_STS_ERROR;
10290:
10291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10293:
10294: WHEN OTHERS THEN
10295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10296: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 10295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10293:
10294: WHEN OTHERS THEN
10295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10296: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10297: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10298: END IF;
10299:

Line 10590: -- Use a sequence number rather than FND_API.G_MISS_NUM

10586: VALUE_BASIS --
10587: )
10588: SELECT
10589: -- bug3611217
10590: -- Use a sequence number rather than FND_API.G_MISS_NUM
10591: -- since we have added unique constraint on LINE_LOCATION_ID
10592: PO_LINE_LOCATIONS_S.nextval,
10593: poll.LAST_UPDATE_DATE ,
10594: poll.LAST_UPDATED_BY ,

Line 10687: FND_API.G_MISS_NUM),

10683:
10684: --
10685: --iSP is passing shipment_num now
10686: nvl(p_requested_changes.shipment_changes.split_shipment_num(i),
10687: FND_API.G_MISS_NUM),
10688: --SHIPMENT_NUM ,
10689: --
10690:
10691: poll.SOURCE_SHIPMENT_ID ,

Line 10799: x_return_status := FND_API.G_RET_STS_SUCCESS;

10795: WHERE po_distribution_id = p_requested_changes.distribution_changes.po_distribution_id(i);
10796: END IF;
10797:
10798: l_progress := '006';
10799: x_return_status := FND_API.G_RET_STS_SUCCESS;
10800: EXCEPTION
10801: WHEN FND_API.G_EXC_ERROR THEN
10802: x_return_status := FND_API.G_RET_STS_ERROR;
10803:

Line 10801: WHEN FND_API.G_EXC_ERROR THEN

10797:
10798: l_progress := '006';
10799: x_return_status := FND_API.G_RET_STS_SUCCESS;
10800: EXCEPTION
10801: WHEN FND_API.G_EXC_ERROR THEN
10802: x_return_status := FND_API.G_RET_STS_ERROR;
10803:
10804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10802: x_return_status := FND_API.G_RET_STS_ERROR;

10798: l_progress := '006';
10799: x_return_status := FND_API.G_RET_STS_SUCCESS;
10800: EXCEPTION
10801: WHEN FND_API.G_EXC_ERROR THEN
10802: x_return_status := FND_API.G_RET_STS_ERROR;
10803:
10804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10806:

Line 10804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10800: EXCEPTION
10801: WHEN FND_API.G_EXC_ERROR THEN
10802: x_return_status := FND_API.G_RET_STS_ERROR;
10803:
10804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10806:
10807: WHEN OTHERS THEN
10808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10801: WHEN FND_API.G_EXC_ERROR THEN
10802: x_return_status := FND_API.G_RET_STS_ERROR;
10803:
10804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10806:
10807: WHEN OTHERS THEN
10808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 10808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10806:
10807: WHEN OTHERS THEN
10808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10810: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10811: END IF;
10812:

Line 11139: x_return_status := FND_API.G_RET_STS_SUCCESS;

11135: END IF;
11136: END IF;
11137:
11138: l_progress := '002';
11139: x_return_status := FND_API.G_RET_STS_SUCCESS;
11140: EXCEPTION
11141: WHEN FND_API.G_EXC_ERROR THEN
11142: x_return_status := FND_API.G_RET_STS_ERROR;
11143:

Line 11141: WHEN FND_API.G_EXC_ERROR THEN

11137:
11138: l_progress := '002';
11139: x_return_status := FND_API.G_RET_STS_SUCCESS;
11140: EXCEPTION
11141: WHEN FND_API.G_EXC_ERROR THEN
11142: x_return_status := FND_API.G_RET_STS_ERROR;
11143:
11144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11142: x_return_status := FND_API.G_RET_STS_ERROR;

11138: l_progress := '002';
11139: x_return_status := FND_API.G_RET_STS_SUCCESS;
11140: EXCEPTION
11141: WHEN FND_API.G_EXC_ERROR THEN
11142: x_return_status := FND_API.G_RET_STS_ERROR;
11143:
11144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11146:

Line 11144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11140: EXCEPTION
11141: WHEN FND_API.G_EXC_ERROR THEN
11142: x_return_status := FND_API.G_RET_STS_ERROR;
11143:
11144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11146:
11147: WHEN OTHERS THEN
11148:

Line 11145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11141: WHEN FND_API.G_EXC_ERROR THEN
11142: x_return_status := FND_API.G_RET_STS_ERROR;
11143:
11144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11146:
11147: WHEN OTHERS THEN
11148:
11149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11146:
11147: WHEN OTHERS THEN
11148:
11149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11151: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11152: END IF;
11153:

Line 11491: x_return_status := FND_API.G_RET_STS_SUCCESS;

11487: WHERE pol.po_line_id = l_line_id_tbl(i)
11488: ;
11489:
11490: l_progress := '030';
11491: x_return_status := FND_API.G_RET_STS_SUCCESS;
11492:
11493: EXCEPTION
11494: WHEN FND_API.G_EXC_ERROR THEN
11495: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11494: WHEN FND_API.G_EXC_ERROR THEN

11490: l_progress := '030';
11491: x_return_status := FND_API.G_RET_STS_SUCCESS;
11492:
11493: EXCEPTION
11494: WHEN FND_API.G_EXC_ERROR THEN
11495: x_return_status := FND_API.G_RET_STS_ERROR;
11496:
11497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11495: x_return_status := FND_API.G_RET_STS_ERROR;

11491: x_return_status := FND_API.G_RET_STS_SUCCESS;
11492:
11493: EXCEPTION
11494: WHEN FND_API.G_EXC_ERROR THEN
11495: x_return_status := FND_API.G_RET_STS_ERROR;
11496:
11497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11499:

Line 11497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11493: EXCEPTION
11494: WHEN FND_API.G_EXC_ERROR THEN
11495: x_return_status := FND_API.G_RET_STS_ERROR;
11496:
11497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11499:
11500: WHEN OTHERS THEN
11501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11494: WHEN FND_API.G_EXC_ERROR THEN
11495: x_return_status := FND_API.G_RET_STS_ERROR;
11496:
11497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11499:
11500: WHEN OTHERS THEN
11501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 11501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11499:
11500: WHEN OTHERS THEN
11501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11503: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11504: END IF;
11505:

Line 11720: x_return_status := FND_API.G_RET_STS_SUCCESS;

11716: FROM po_releases
11717: WHERE po_release_id = p_document_id;
11718:
11719: l_progress := '001';
11720: x_return_status := FND_API.G_RET_STS_SUCCESS;
11721: EXCEPTION
11722: WHEN FND_API.G_EXC_ERROR THEN
11723: x_return_status := FND_API.G_RET_STS_ERROR;
11724:

Line 11722: WHEN FND_API.G_EXC_ERROR THEN

11718:
11719: l_progress := '001';
11720: x_return_status := FND_API.G_RET_STS_SUCCESS;
11721: EXCEPTION
11722: WHEN FND_API.G_EXC_ERROR THEN
11723: x_return_status := FND_API.G_RET_STS_ERROR;
11724:
11725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11723: x_return_status := FND_API.G_RET_STS_ERROR;

11719: l_progress := '001';
11720: x_return_status := FND_API.G_RET_STS_SUCCESS;
11721: EXCEPTION
11722: WHEN FND_API.G_EXC_ERROR THEN
11723: x_return_status := FND_API.G_RET_STS_ERROR;
11724:
11725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11727:

Line 11725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11721: EXCEPTION
11722: WHEN FND_API.G_EXC_ERROR THEN
11723: x_return_status := FND_API.G_RET_STS_ERROR;
11724:
11725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11727:
11728: WHEN OTHERS THEN
11729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11722: WHEN FND_API.G_EXC_ERROR THEN
11723: x_return_status := FND_API.G_RET_STS_ERROR;
11724:
11725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11727:
11728: WHEN OTHERS THEN
11729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 11729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11727:
11728: WHEN OTHERS THEN
11729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11731: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11732: END IF;
11733:

Line 11896: x_return_status := FND_API.G_RET_STS_SUCCESS;

11892: FROM po_requisition_headers
11893: WHERE requisition_header_id = p_document_id;
11894:
11895: l_progress := '001';
11896: x_return_status := FND_API.G_RET_STS_SUCCESS;
11897: EXCEPTION
11898: WHEN FND_API.G_EXC_ERROR THEN
11899: x_return_status := FND_API.G_RET_STS_ERROR;
11900:

Line 11898: WHEN FND_API.G_EXC_ERROR THEN

11894:
11895: l_progress := '001';
11896: x_return_status := FND_API.G_RET_STS_SUCCESS;
11897: EXCEPTION
11898: WHEN FND_API.G_EXC_ERROR THEN
11899: x_return_status := FND_API.G_RET_STS_ERROR;
11900:
11901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11899: x_return_status := FND_API.G_RET_STS_ERROR;

11895: l_progress := '001';
11896: x_return_status := FND_API.G_RET_STS_SUCCESS;
11897: EXCEPTION
11898: WHEN FND_API.G_EXC_ERROR THEN
11899: x_return_status := FND_API.G_RET_STS_ERROR;
11900:
11901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11903:

Line 11901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11897: EXCEPTION
11898: WHEN FND_API.G_EXC_ERROR THEN
11899: x_return_status := FND_API.G_RET_STS_ERROR;
11900:
11901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11903:
11904: WHEN OTHERS THEN
11905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11898: WHEN FND_API.G_EXC_ERROR THEN
11899: x_return_status := FND_API.G_RET_STS_ERROR;
11900:
11901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11903:
11904: WHEN OTHERS THEN
11905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 11905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11903:
11904: WHEN OTHERS THEN
11905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11907: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11908: END IF;
11909:

Line 12229: x_return_status := FND_API.G_RET_STS_SUCCESS;

12225: FROM po_requisition_lines
12226: WHERE requisition_header_id = p_document_id;
12227:
12228: l_progress := '001';
12229: x_return_status := FND_API.G_RET_STS_SUCCESS;
12230: EXCEPTION
12231: WHEN FND_API.G_EXC_ERROR THEN
12232: x_return_status := FND_API.G_RET_STS_ERROR;
12233:

Line 12231: WHEN FND_API.G_EXC_ERROR THEN

12227:
12228: l_progress := '001';
12229: x_return_status := FND_API.G_RET_STS_SUCCESS;
12230: EXCEPTION
12231: WHEN FND_API.G_EXC_ERROR THEN
12232: x_return_status := FND_API.G_RET_STS_ERROR;
12233:
12234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 12232: x_return_status := FND_API.G_RET_STS_ERROR;

12228: l_progress := '001';
12229: x_return_status := FND_API.G_RET_STS_SUCCESS;
12230: EXCEPTION
12231: WHEN FND_API.G_EXC_ERROR THEN
12232: x_return_status := FND_API.G_RET_STS_ERROR;
12233:
12234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12236:

Line 12234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12230: EXCEPTION
12231: WHEN FND_API.G_EXC_ERROR THEN
12232: x_return_status := FND_API.G_RET_STS_ERROR;
12233:
12234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12236:
12237: WHEN OTHERS THEN
12238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 12235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12231: WHEN FND_API.G_EXC_ERROR THEN
12232: x_return_status := FND_API.G_RET_STS_ERROR;
12233:
12234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12236:
12237: WHEN OTHERS THEN
12238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 12238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12236:
12237: WHEN OTHERS THEN
12238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
12240: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
12241: END IF;
12242:

Line 12438: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds

12434: * Modifies: None
12435: * Effects: This procedure builds dynamic WHERE clause fragments based on
12436: * document security parameters.
12437: * Returns:
12438: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
12439: * FND_API.G_RET_STS_ERROR if API fails
12440: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
12441: * x_msg_data: Contains error msg in case x_return_status returned
12442: * FND_API.G_RET_STS_ERROR or

Line 12439: * FND_API.G_RET_STS_ERROR if API fails

12435: * Effects: This procedure builds dynamic WHERE clause fragments based on
12436: * document security parameters.
12437: * Returns:
12438: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
12439: * FND_API.G_RET_STS_ERROR if API fails
12440: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
12441: * x_msg_data: Contains error msg in case x_return_status returned
12442: * FND_API.G_RET_STS_ERROR or
12443: * FND_API.G_RET_STS_UNEXP_ERROR

Line 12440: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

12436: * document security parameters.
12437: * Returns:
12438: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
12439: * FND_API.G_RET_STS_ERROR if API fails
12440: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
12441: * x_msg_data: Contains error msg in case x_return_status returned
12442: * FND_API.G_RET_STS_ERROR or
12443: * FND_API.G_RET_STS_UNEXP_ERROR
12444: * x_where_clause: The constructed where clause

Line 12442: * FND_API.G_RET_STS_ERROR or

12438: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
12439: * FND_API.G_RET_STS_ERROR if API fails
12440: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
12441: * x_msg_data: Contains error msg in case x_return_status returned
12442: * FND_API.G_RET_STS_ERROR or
12443: * FND_API.G_RET_STS_UNEXP_ERROR
12444: * x_where_clause: The constructed where clause
12445: */
12446:

Line 12443: * FND_API.G_RET_STS_UNEXP_ERROR

12439: * FND_API.G_RET_STS_ERROR if API fails
12440: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
12441: * x_msg_data: Contains error msg in case x_return_status returned
12442: * FND_API.G_RET_STS_ERROR or
12443: * FND_API.G_RET_STS_UNEXP_ERROR
12444: * x_where_clause: The constructed where clause
12445: */
12446:
12447: PROCEDURE PO_SECURITY_CHECK (p_api_version IN NUMBER,

Line 12473: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

12469: BEGIN
12470:
12471: l_progress := '000';
12472: -- Standard call to check for call compatibility
12473: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
12474: THEN
12475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12476: END IF;
12477:

Line 12475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12471: l_progress := '000';
12472: -- Standard call to check for call compatibility
12473: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
12474: THEN
12475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12476: END IF;
12477:
12478: l_progress := '010';
12479: IF g_debug_stmt THEN

Line 12591: x_return_status := FND_API.G_RET_STS_SUCCESS;

12587:
12588:
12589:
12590: l_progress := '070';
12591: x_return_status := FND_API.G_RET_STS_SUCCESS;
12592: x_msg_data := NULL;
12593:
12594: l_progress := '100';
12595: IF g_debug_stmt THEN

Line 12604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12600: END IF;
12601: END IF;
12602:
12603: EXCEPTION
12604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12605: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12606: p_encoded => 'F');
12607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12608: x_where_clause := NULL;

Line 12607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12603: EXCEPTION
12604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12605: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12606: p_encoded => 'F');
12607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12608: x_where_clause := NULL;
12609: WHEN FND_API.G_EXC_ERROR THEN
12610: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12611: p_encoded => 'F');

Line 12609: WHEN FND_API.G_EXC_ERROR THEN

12605: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12606: p_encoded => 'F');
12607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12608: x_where_clause := NULL;
12609: WHEN FND_API.G_EXC_ERROR THEN
12610: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12611: p_encoded => 'F');
12612: x_return_status := FND_API.G_RET_STS_ERROR;
12613: x_where_clause := NULL;

Line 12612: x_return_status := FND_API.G_RET_STS_ERROR;

12608: x_where_clause := NULL;
12609: WHEN FND_API.G_EXC_ERROR THEN
12610: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12611: p_encoded => 'F');
12612: x_return_status := FND_API.G_RET_STS_ERROR;
12613: x_where_clause := NULL;
12614: WHEN OTHERS THEN
12615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
12616: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

Line 12629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12625: END IF;
12626:
12627: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
12628: p_encoded => 'F');
12629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12630: x_where_clause := NULL;
12631:
12632: END PO_SECURITY_CHECK;
12633:

Line 12700: l_skip_cat_upload_chk VARCHAR2(1) := NVL(p_skip_cat_upload_chk, FND_API.G_FALSE);

12696: -- bug3592160 END
12697:
12698: --
12699: l_role PO_DRAFTS.owner_role%TYPE := NVL(p_role, PO_GLOBAL.g_ROLE_BUYER);
12700: l_skip_cat_upload_chk VARCHAR2(1) := NVL(p_skip_cat_upload_chk, FND_API.G_FALSE);
12701:
12702: l_update_allowed VARCHAR2(1);
12703: l_locking_applicable VARCHAR2(1);
12704: l_unlock_required VARCHAR2(1);

Line 12814: P_INIT_MSG_LIST => FND_API.G_FALSE,

12810: END IF;
12811: END IF;
12812: PO_DOCUMENT_LOCK_GRP.LOCK_DOCUMENT (
12813: p_api_version => 1.0,
12814: P_INIT_MSG_LIST => FND_API.G_FALSE,
12815: P_DOCUMENT_TYPE => l_document_type,
12816: P_DOCUMENT_ID => l_document_id,
12817: x_return_status => x_return_status);
12818:

Line 12819: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

12815: P_DOCUMENT_TYPE => l_document_type,
12816: P_DOCUMENT_ID => l_document_id,
12817: x_return_status => x_return_status);
12818:
12819: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12820: return;
12821: END IF;
12822: END IF;
12823: ELSE

Line 12855: IF (l_update_allowed = FND_API.G_FALSE) THEN

12851: x_unlock_required => l_unlock_required,
12852: x_message => l_message
12853: );
12854:
12855: IF (l_update_allowed = FND_API.G_FALSE) THEN
12856: x_po_status_rec.updatable_flag(i) := 'N';
12857: END IF;
12858: END IF;
12859: END LOOP;

Line 12864: x_return_status := FND_API.G_RET_STS_SUCCESS;

12860:
12861: --
12862:
12863:
12864: x_return_status := FND_API.G_RET_STS_SUCCESS;
12865:
12866: EXCEPTION
12867: WHEN FND_API.G_EXC_ERROR THEN
12868: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12867: WHEN FND_API.G_EXC_ERROR THEN

12863:
12864: x_return_status := FND_API.G_RET_STS_SUCCESS;
12865:
12866: EXCEPTION
12867: WHEN FND_API.G_EXC_ERROR THEN
12868: x_return_status := FND_API.G_RET_STS_ERROR;
12869: WHEN OTHERS THEN
12870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12871: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 12868: x_return_status := FND_API.G_RET_STS_ERROR;

12864: x_return_status := FND_API.G_RET_STS_SUCCESS;
12865:
12866: EXCEPTION
12867: WHEN FND_API.G_EXC_ERROR THEN
12868: x_return_status := FND_API.G_RET_STS_ERROR;
12869: WHEN OTHERS THEN
12870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12871: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
12872:

Line 12870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12866: EXCEPTION
12867: WHEN FND_API.G_EXC_ERROR THEN
12868: x_return_status := FND_API.G_RET_STS_ERROR;
12869: WHEN OTHERS THEN
12870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12871: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
12872:
12873: END check_updatable;
12874:

Line 13037: x_return_status := FND_API.G_RET_STS_SUCCESS;

13033: DELETE FROM po_session_gt
13034: WHERE key = l_procedure_id;
13035: -- bug3592160 END
13036:
13037: x_return_status := FND_API.G_RET_STS_SUCCESS;
13038:
13039: EXCEPTION
13040: WHEN FND_API.G_EXC_ERROR THEN
13041: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13040: WHEN FND_API.G_EXC_ERROR THEN

13036:
13037: x_return_status := FND_API.G_RET_STS_SUCCESS;
13038:
13039: EXCEPTION
13040: WHEN FND_API.G_EXC_ERROR THEN
13041: x_return_status := FND_API.G_RET_STS_ERROR;
13042: WHEN OTHERS THEN
13043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13044: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 13041: x_return_status := FND_API.G_RET_STS_ERROR;

13037: x_return_status := FND_API.G_RET_STS_SUCCESS;
13038:
13039: EXCEPTION
13040: WHEN FND_API.G_EXC_ERROR THEN
13041: x_return_status := FND_API.G_RET_STS_ERROR;
13042: WHEN OTHERS THEN
13043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13044: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13045:

Line 13043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13039: EXCEPTION
13040: WHEN FND_API.G_EXC_ERROR THEN
13041: x_return_status := FND_API.G_RET_STS_ERROR;
13042: WHEN OTHERS THEN
13043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13044: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13045:
13046: END check_reservable;
13047:

Line 13206: x_return_status := FND_API.G_RET_STS_SUCCESS;

13202: DELETE FROM po_session_gt
13203: WHERE key = l_procedure_id;
13204: -- bug3592160 END
13205:
13206: x_return_status := FND_API.G_RET_STS_SUCCESS;
13207:
13208: EXCEPTION
13209: WHEN FND_API.G_EXC_ERROR THEN
13210: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13209: WHEN FND_API.G_EXC_ERROR THEN

13205:
13206: x_return_status := FND_API.G_RET_STS_SUCCESS;
13207:
13208: EXCEPTION
13209: WHEN FND_API.G_EXC_ERROR THEN
13210: x_return_status := FND_API.G_RET_STS_ERROR;
13211: WHEN OTHERS THEN
13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13213: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 13210: x_return_status := FND_API.G_RET_STS_ERROR;

13206: x_return_status := FND_API.G_RET_STS_SUCCESS;
13207:
13208: EXCEPTION
13209: WHEN FND_API.G_EXC_ERROR THEN
13210: x_return_status := FND_API.G_RET_STS_ERROR;
13211: WHEN OTHERS THEN
13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13213: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13214:

Line 13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13208: EXCEPTION
13209: WHEN FND_API.G_EXC_ERROR THEN
13210: x_return_status := FND_API.G_RET_STS_ERROR;
13211: WHEN OTHERS THEN
13212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13213: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13214:
13215: END check_unreservable;
13216:

Line 13372: x_return_status := FND_API.G_RET_STS_SUCCESS;

13368: x_po_status_rec.cancel_flag, x_po_status_rec.frozen_flag, x_po_status_rec.hold_flag
13369: FROM po_headers_gt
13370: ORDER BY PO_HEADER_ID;
13371:
13372: x_return_status := FND_API.G_RET_STS_SUCCESS;
13373:
13374: EXCEPTION
13375: WHEN FND_API.G_EXC_ERROR THEN
13376: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13375: WHEN FND_API.G_EXC_ERROR THEN

13371:
13372: x_return_status := FND_API.G_RET_STS_SUCCESS;
13373:
13374: EXCEPTION
13375: WHEN FND_API.G_EXC_ERROR THEN
13376: x_return_status := FND_API.G_RET_STS_ERROR;
13377: WHEN OTHERS THEN
13378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13379: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 13376: x_return_status := FND_API.G_RET_STS_ERROR;

13372: x_return_status := FND_API.G_RET_STS_SUCCESS;
13373:
13374: EXCEPTION
13375: WHEN FND_API.G_EXC_ERROR THEN
13376: x_return_status := FND_API.G_RET_STS_ERROR;
13377: WHEN OTHERS THEN
13378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13379: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13380:

Line 13378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13374: EXCEPTION
13375: WHEN FND_API.G_EXC_ERROR THEN
13376: x_return_status := FND_API.G_RET_STS_ERROR;
13377: WHEN OTHERS THEN
13378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13379: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13380:
13381: END get_status;
13382:

Line 13432: -- FND_API.G_TRUE if catalog upload status check should not be performed

13428: -- To be used by updatalbe chk only.
13429: -- Role of the suer calling this API. (BUYER, SUPPLIER, CAT ADMIN, etc.)
13430: --p_skip_cat_upload_chk
13431: -- To be used by updatalbe chk only.
13432: -- FND_API.G_TRUE if catalog upload status check should not be performed
13433: -- FND_API.G_FALSE otherwise
13434: --OUT:
13435: --x_return_status
13436: -- Indicates API return status as 'S', 'E' or 'U'.

Line 13433: -- FND_API.G_FALSE otherwise

13429: -- Role of the suer calling this API. (BUYER, SUPPLIER, CAT ADMIN, etc.)
13430: --p_skip_cat_upload_chk
13431: -- To be used by updatalbe chk only.
13432: -- FND_API.G_TRUE if catalog upload status check should not be performed
13433: -- FND_API.G_FALSE otherwise
13434: --OUT:
13435: --x_return_status
13436: -- Indicates API return status as 'S', 'E' or 'U'.
13437: --x_po_status_rec

Line 13487: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

13483: END IF;
13484:
13485: -- Standard call to check for call compatibility
13486: l_progress := '010';
13487: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
13488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13489: END IF;
13490:
13491: l_progress := '020'; -- Initialize Local/Output Variables

Line 13488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13484:
13485: -- Standard call to check for call compatibility
13486: l_progress := '010';
13487: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
13488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13489: END IF;
13490:
13491: l_progress := '020'; -- Initialize Local/Output Variables
13492: l_count := p_header_id.count;

Line 13517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13513: p_skip_cat_upload_chk => p_skip_cat_upload_chk, -- PDOI Rewrite R12
13514: x_po_status_rec => x_po_status_rec,
13515: x_return_status => x_return_status);
13516:
13517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13518: return;
13519: END IF;
13520:
13521: END IF; --}END of IF INSTR(p_mode, G_CHECK_UPDATEABLE) > 0

Line 13542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13538: p_lock_flag => p_lock_flag,
13539: x_po_status_rec => x_po_status_rec,
13540: x_return_status => x_return_status);
13541:
13542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13543: return;
13544: END IF;
13545:
13546: END IF; --}END of IF INSTR(p_mode, G_CHECK_RESERVABLE) > 0

Line 13567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13563: p_lock_flag => p_lock_flag,
13564: x_po_status_rec => x_po_status_rec,
13565: x_return_status => x_return_status);
13566:
13567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13568: return;
13569: END IF;
13570:
13571: END IF; --}END of IF INSTR(p_mode, G_CHECK_UNRESERVABLE) > 0

Line 13591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13587: p_distribution_id => p_distribution_id,
13588: x_po_status_rec => x_po_status_rec,
13589: x_return_status => x_return_status);
13590:
13591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13592: return;
13593: END IF;
13594:
13595: END IF; --}END of IF INSTR(p_mode, G_GET_STATUS) > 0

Line 13603: RAISE FND_API.G_EXC_ERROR;

13599: IF x_return_status is null THEN -- no valid check status request specified
13600: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
13601: FND_MESSAGE.set_token('ERROR_TEXT', 'No Valid p_mode specified !');
13602: FND_MSG_PUB.Add;
13603: RAISE FND_API.G_EXC_ERROR;
13604: END IF;
13605:
13606: EXCEPTION
13607: WHEN FND_API.G_EXC_ERROR THEN

Line 13607: WHEN FND_API.G_EXC_ERROR THEN

13603: RAISE FND_API.G_EXC_ERROR;
13604: END IF;
13605:
13606: EXCEPTION
13607: WHEN FND_API.G_EXC_ERROR THEN
13608: x_return_status := FND_API.G_RET_STS_ERROR;
13609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13611: WHEN OTHERS THEN

Line 13608: x_return_status := FND_API.G_RET_STS_ERROR;

13604: END IF;
13605:
13606: EXCEPTION
13607: WHEN FND_API.G_EXC_ERROR THEN
13608: x_return_status := FND_API.G_RET_STS_ERROR;
13609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13611: WHEN OTHERS THEN
13612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 13609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

13605:
13606: EXCEPTION
13607: WHEN FND_API.G_EXC_ERROR THEN
13608: x_return_status := FND_API.G_RET_STS_ERROR;
13609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13611: WHEN OTHERS THEN
13612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13613: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 13610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13606: EXCEPTION
13607: WHEN FND_API.G_EXC_ERROR THEN
13608: x_return_status := FND_API.G_RET_STS_ERROR;
13609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13611: WHEN OTHERS THEN
13612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13613: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13614:

Line 13612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13608: x_return_status := FND_API.G_RET_STS_ERROR;
13609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13611: WHEN OTHERS THEN
13612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13613: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
13614:
13615: END po_status_check;
13616:

Line 13946: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

13942: , p_sequence => p_sequence
13943: , x_return_status => l_ret_sts
13944: );
13945:
13946: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
13947: --d_msg := 'check_unvalidated_invoices not successful';
13948: l_progress := 110;
13949: RAISE PO_CORE_S.g_early_return_exc;
13950: END IF;

Line 14853: IF (l_invalid_period_flag = FND_API.G_TRUE) THEN

14849: );
14850:
14851: l_progress := '210';
14852:
14853: IF (l_invalid_period_flag = FND_API.G_TRUE) THEN
14854:
14855: l_progress := '215';
14856: IF g_debug_stmt THEN
14857: PO_DEBUG.debug_stmt(l_log_head,l_progress,'invalid period');

Line 15163: -- FND_API.G_RET_STS_SUCCESS and FND_API.G_RET_STS_UNEXP_ERROR

15159: -- maintains a count of total number of submission check errors/warnings
15160: --OUT:
15161: --x_return_status
15162: -- return status of the procedure. Possible values are
15163: -- FND_API.G_RET_STS_SUCCESS and FND_API.G_RET_STS_UNEXP_ERROR
15164: --Notes:
15165: -- None
15166: --Testing:
15167: -- None

Line 15190: x_return_status := FND_API.G_RET_STS_SUCCESS;

15186:
15187: BEGIN
15188:
15189: l_progress := '000';
15190: x_return_status := FND_API.G_RET_STS_SUCCESS;
15191:
15192: IF g_debug_stmt THEN
15193: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
15194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

Line 15208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

15204: FROM po_headers_all
15205: WHERE po_header_id = p_document_id;
15206: EXCEPTION
15207: WHEN OTHERS THEN
15208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15209: END;
15210:
15211: l_progress := '010';
15212: IF g_debug_stmt THEN

Line 15286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

15282: END IF; -- l_valid_registration check
15283: END IF; -- l_vendor_id and l_vendor_site_id check
15284:
15285: EXCEPTION
15286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15288: WHEN OTHERS THEN
15289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15290: IF (g_debug_unexp) THEN

Line 15287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

15283: END IF; -- l_vendor_id and l_vendor_site_id check
15284:
15285: EXCEPTION
15286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15288: WHEN OTHERS THEN
15289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15290: IF (g_debug_unexp) THEN
15291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 15289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

15285: EXCEPTION
15286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15288: WHEN OTHERS THEN
15289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15290: IF (g_debug_unexp) THEN
15291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
15292: FND_LOG.string(FND_LOG.level_unexpected,
15293: G_PKG_NAME||l_api_name|| '.others_exception',

Line 15359: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15355: , p_sequence => p_sequence
15356: , x_return_status => l_ret_sts
15357: );
15358:
15359: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15360: d_msg := 'check_rcv_trans_interface not successful';
15361: d_progress := 30;
15362: RAISE PO_CORE_S.g_early_return_exc;
15363: END IF;

Line 15376: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15372: , p_sequence => p_sequence
15373: , x_return_status => l_ret_sts
15374: );
15375:
15376: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15377: d_msg := 'check_asn_not_fully_received not successful';
15378: d_progress := 50;
15379: RAISE PO_CORE_S.g_early_return_exc;
15380: END IF;

Line 15393: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15389: , p_sequence => p_sequence
15390: , x_return_status => l_ret_sts
15391: );
15392:
15393: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15394: d_msg := 'check_qty_rcv_but_not_deliv not successful';
15395: d_progress := 70;
15396: RAISE PO_CORE_S.g_early_return_exc;
15397: END IF;

Line 15410: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15406: , p_sequence => p_sequence
15407: , x_return_status => l_ret_sts
15408: );
15409:
15410: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15411: d_msg := 'check_amt_rcv_but_not_deliv not successful';
15412: d_progress := 90;
15413: RAISE PO_CORE_S.g_early_return_exc;
15414: END IF;

Line 15430: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15426: , p_sequence => p_sequence
15427: , x_return_status => l_ret_sts
15428: );
15429:
15430: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15431: d_msg := 'check_invalid_acct_flex not successful';
15432: d_progress := 110;
15433: RAISE PO_CORE_S.g_early_return_exc;
15434: END IF;

Line 15454: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15450: , p_sequence => p_sequence
15451: , x_return_status => l_ret_sts
15452: );
15453:
15454: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15455: d_msg := 'check_unvalidated_invoices not successful';
15456: d_progress := 110;
15457: RAISE PO_CORE_S.g_early_return_exc;
15458: END IF;

Line 15477: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15473: , p_sequence => p_sequence
15474: , x_return_status => l_ret_sts
15475: );
15476:
15477: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15478: d_msg := 'check_invalid_acct_flex not successful';
15479: d_progress := 210;
15480: RAISE PO_CORE_S.g_early_return_exc;
15481: END IF;

Line 15493: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15489: , p_sequence => p_sequence
15490: , x_return_status => l_ret_sts
15491: );
15492:
15493: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15494: d_msg := 'check_ppo_has_open_release not successful';
15495: d_progress := 230;
15496: RAISE PO_CORE_S.g_early_return_exc;
15497: END IF;

Line 15512: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15508: , p_sequence => p_sequence
15509: , x_return_status => l_ret_sts
15510: );
15511:
15512: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15513: d_msg := 'check_bpa_has_open_release not successful';
15514: d_progress := 310;
15515: RAISE PO_CORE_S.g_early_return_exc;
15516: END IF;

Line 15528: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15524: , p_sequence => p_sequence
15525: , x_return_status => l_ret_sts
15526: );
15527:
15528: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15529: d_msg := 'check_bpa_has_open_stdref not successful';
15530: d_progress := 330;
15531: RAISE PO_CORE_S.g_early_return_exc;
15532: END IF;

Line 15547: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

15543: , p_sequence => p_sequence
15544: , x_return_status => l_ret_sts
15545: );
15546:
15547: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15548: d_msg := 'check_cpa_has_open_stdref not successful';
15549: d_progress := 410;
15550: RAISE PO_CORE_S.g_early_return_exc;
15551: END IF;

Line 15555: l_ret_sts := FND_API.G_RET_STS_SUCCESS;

15551: END IF;
15552:
15553: END IF; -- p_document_type = ...
15554:
15555: l_ret_sts := FND_API.G_RET_STS_SUCCESS;
15556:
15557: EXCEPTION
15558: WHEN PO_CORE_S.g_early_return_exc THEN
15559: IF (PO_LOG.d_exc) THEN

Line 15562: l_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;

15558: WHEN PO_CORE_S.g_early_return_exc THEN
15559: IF (PO_LOG.d_exc) THEN
15560: PO_LOG.exc(d_module, d_progress, d_msg);
15561: END IF;
15562: l_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;
15563: END;
15564:
15565: x_return_status := l_ret_sts;
15566:

Line 15576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

15572:
15573: EXCEPTION
15574:
15575: WHEN others THEN
15576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15577:
15578: IF (PO_LOG.d_exc) THEN
15579: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
15580: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 15866: l_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;

15862: ELSE
15863:
15864: d_progress := 70;
15865: d_msg := 'Bad document level';
15866: l_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;
15867: RAISE PO_CORE_S.g_early_return_exc;
15868:
15869: END IF; -- if p_document_level = ...
15870:

Line 15872: l_ret_sts := FND_API.G_RET_STS_SUCCESS;

15868:
15869: END IF; -- if p_document_level = ...
15870:
15871: p_sequence := p_sequence + SQL%ROWCOUNT;
15872: l_ret_sts := FND_API.G_RET_STS_SUCCESS;
15873:
15874: EXCEPTION
15875: WHEN PO_CORE_S.g_early_return_exc THEN
15876: IF (PO_LOG.d_exc) THEN

Line 15893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

15889: RETURN;
15890:
15891: EXCEPTION
15892: WHEN others THEN
15893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15894:
15895: IF (PO_LOG.d_exc) THEN
15896: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
15897: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 15989: x_return_status := FND_API.G_RET_STS_SUCCESS;

15985:
15986: d_progress := 20;
15987:
15988: p_sequence := p_sequence + SQL%ROWCOUNT;
15989: x_return_status := FND_API.G_RET_STS_SUCCESS;
15990:
15991: IF (PO_LOG.d_proc) THEN
15992: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
15993: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

15997: RETURN;
15998:
15999: EXCEPTION
16000: WHEN others THEN
16001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16002:
16003: IF (PO_LOG.d_exc) THEN
16004: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16005: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16108: x_return_status := FND_API.G_RET_STS_SUCCESS;

16104:
16105: d_progress := 20;
16106:
16107: p_sequence := p_sequence + SQL%ROWCOUNT;
16108: x_return_status := FND_API.G_RET_STS_SUCCESS;
16109:
16110: IF (PO_LOG.d_proc) THEN
16111: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16112: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16116: RETURN;
16117:
16118: EXCEPTION
16119: WHEN others THEN
16120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16121:
16122: IF (PO_LOG.d_exc) THEN
16123: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16124: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16233: x_return_status := FND_API.G_RET_STS_SUCCESS;

16229:
16230: d_progress := 20;
16231:
16232: p_sequence := p_sequence + SQL%ROWCOUNT;
16233: x_return_status := FND_API.G_RET_STS_SUCCESS;
16234:
16235: IF (PO_LOG.d_proc) THEN
16236: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16237: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16241: RETURN;
16242:
16243: EXCEPTION
16244: WHEN others THEN
16245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16246:
16247: IF (PO_LOG.d_exc) THEN
16248: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16249: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16361: x_return_status := FND_API.G_RET_STS_SUCCESS;

16357:
16358: d_progress := 20;
16359:
16360: p_sequence := p_sequence + SQL%ROWCOUNT;
16361: x_return_status := FND_API.G_RET_STS_SUCCESS;
16362:
16363: IF (PO_LOG.d_proc) THEN
16364: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16365: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16369: RETURN;
16370:
16371: EXCEPTION
16372: WHEN others THEN
16373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16374:
16375: IF (PO_LOG.d_exc) THEN
16376: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16377: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16458: x_return_status := FND_API.G_RET_STS_SUCCESS;

16454:
16455: d_progress := 20;
16456:
16457: p_sequence := p_sequence + SQL%ROWCOUNT;
16458: x_return_status := FND_API.G_RET_STS_SUCCESS;
16459:
16460: IF (PO_LOG.d_proc) THEN
16461: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16462: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16466: RETURN;
16467:
16468: EXCEPTION
16469: WHEN others THEN
16470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16471:
16472: IF (PO_LOG.d_exc) THEN
16473: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16474: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16554: x_return_status := FND_API.G_RET_STS_SUCCESS;

16550:
16551: d_progress := 20;
16552:
16553: p_sequence := p_sequence + SQL%ROWCOUNT;
16554: x_return_status := FND_API.G_RET_STS_SUCCESS;
16555:
16556: IF (PO_LOG.d_proc) THEN
16557: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16558: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16562: RETURN;
16563:
16564: EXCEPTION
16565: WHEN others THEN
16566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16567:
16568: IF (PO_LOG.d_exc) THEN
16569: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16570: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16650: x_return_status := FND_API.G_RET_STS_SUCCESS;

16646:
16647: d_progress := 20;
16648:
16649: p_sequence := p_sequence + SQL%ROWCOUNT;
16650: x_return_status := FND_API.G_RET_STS_SUCCESS;
16651:
16652: IF (PO_LOG.d_proc) THEN
16653: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16654: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16658: RETURN;
16659:
16660: EXCEPTION
16661: WHEN others THEN
16662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16663:
16664: IF (PO_LOG.d_exc) THEN
16665: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16666: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 16751: x_return_status := FND_API.G_RET_STS_SUCCESS;

16747:
16748: d_progress := 20;
16749:
16750: p_sequence := p_sequence + SQL%ROWCOUNT;
16751: x_return_status := FND_API.G_RET_STS_SUCCESS;
16752:
16753: IF (PO_LOG.d_proc) THEN
16754: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
16755: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 16763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16759: RETURN;
16760:
16761: EXCEPTION
16762: WHEN others THEN
16763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16764:
16765: IF (PO_LOG.d_exc) THEN
16766: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
16767: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);

Line 17596: x_return_status := FND_API.G_RET_STS_SUCCESS;

17592:
17593: d_progress := 20;
17594:
17595: p_sequence := p_sequence + SQL%ROWCOUNT;
17596: x_return_status := FND_API.G_RET_STS_SUCCESS;
17597:
17598: IF (PO_LOG.d_proc) THEN
17599: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
17600: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 17608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17604: RETURN;
17605:
17606: EXCEPTION
17607: WHEN others THEN
17608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17609: IF (PO_LOG.d_exc) THEN
17610: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
17611: PO_LOG.proc_end(d_module, 'p_sequence', p_sequence);
17612: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 17719: x_return_status := FND_API.G_RET_STS_SUCCESS;

17715: x_message_name := l_message_name;
17716: x_text_line := l_textline;
17717: x_calling_sequence := l_calling_sequence;
17718: x_invoice_type := l_invoice_type;
17719: x_return_status := FND_API.G_RET_STS_SUCCESS;
17720:
17721: IF (PO_LOG.d_proc) THEN
17722: PO_LOG.proc_end(d_module, 'x_text_line', x_text_line);
17723: PO_LOG.proc_end(d_module, 'x_message_name', x_message_name);

Line 17732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17728: END IF;
17729:
17730: EXCEPTION
17731: WHEN OTHERS THEN
17732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17733: IF (PO_LOG.d_exc) THEN
17734: PO_LOG.exc(d_module, d_progress, SQLCODE || ': ' || SQLERRM);
17735: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
17736: PO_LOG.proc_end(d_module);

Line 17858: x_return_status := fnd_api.g_ret_sts_success;

17854: AND lcm_flag = 'Y';
17855:
17856: END IF;
17857:
17858: x_return_status := fnd_api.g_ret_sts_success;
17859:
17860: EXCEPTION
17861: WHEN others THEN
17862: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 17862: x_return_status := fnd_api.g_ret_sts_unexp_error;

17858: x_return_status := fnd_api.g_ret_sts_success;
17859:
17860: EXCEPTION
17861: WHEN others THEN
17862: x_return_status := fnd_api.g_ret_sts_unexp_error;
17863:
17864: IF (g_debug_unexp) THEN
17865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
17866: FND_LOG.string(FND_LOG.level_unexpected, l_log_head || '.others_exception', 'EXCEPTION: Location is '