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

Line 136: Raise FND_API.G_EXC_ERROR ;

132: END IF;
133:
134:
135: IF FND_MSG_PUB.check_msg_level( NVL(G_msg_count,0) ) THEN
136: Raise FND_API.G_EXC_ERROR ;
137: ELSE
138: NULL ;
139: END IF;
140:

Line 155: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then

151: begin
152:
153: IF p_type = 'B' THEN
154:
155: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then
156: X_return_status := FND_API.G_RET_STS_ERROR ;
157: END IF ;
158: ELSE
159:

Line 156: X_return_status := FND_API.G_RET_STS_ERROR ;

152:
153: IF p_type = 'B' THEN
154:
155: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then
156: X_return_status := FND_API.G_RET_STS_ERROR ;
157: END IF ;
158: ELSE
159:
160: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then

Line 160: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then

156: X_return_status := FND_API.G_RET_STS_ERROR ;
157: END IF ;
158: ELSE
159:
160: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then
161: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
162: END IF ;
163: END IF ;
164: END set_return_status ;

Line 161: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

157: END IF ;
158: ELSE
159:
160: IF NVL(X_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS then
161: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
162: END IF ;
163: END IF ;
164: END set_return_status ;
165:

Line 647: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in

643: -- ============
644: -- Initialize the return status.
645: -- ============
646:
647: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
648: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
649:
650: X_return_status := FND_API.G_RET_STS_SUCCESS ;
651:

Line 648: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

644: -- Initialize the return status.
645: -- ============
646:
647: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
648: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
649:
650: X_return_status := FND_API.G_RET_STS_SUCCESS ;
651:
652: END IF ;

Line 650: X_return_status := FND_API.G_RET_STS_SUCCESS ;

646:
647: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
648: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
649:
650: X_return_status := FND_API.G_RET_STS_SUCCESS ;
651:
652: END IF ;
653:
654:

Line 678: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

674: set_return_status ( X_return_status, 'U') ;
675:
676: END IF;
677:
678: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
679: RAISE FND_API.G_EXC_ERROR;
680: END IF ; */
681:
682:

Line 679: RAISE FND_API.G_EXC_ERROR;

675:
676: END IF;
677:
678: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
679: RAISE FND_API.G_EXC_ERROR;
680: END IF ; */
681:
682:
683: G_stage := 'FND_API.Compatible_API_Call' ;

Line 683: G_stage := 'FND_API.Compatible_API_Call' ;

679: RAISE FND_API.G_EXC_ERROR;
680: END IF ; */
681:
682:
683: G_stage := 'FND_API.Compatible_API_Call' ;
684:
685: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
686: p_api_version_number ,
687: l_api_name ,

Line 685: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

681:
682:
683: G_stage := 'FND_API.Compatible_API_Call' ;
684:
685: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
686: p_api_version_number ,
687: l_api_name ,
688: G_pkg_name )
689: THEN

Line 724: Raise fnd_api.g_exc_error ;

720:
721: add_message_to_stack( P_label => 'GMS_AWD_PRJ_MISSING' ) ;
722: set_return_status ( X_return_status, 'B') ;
723: close c_awd_project ;
724: Raise fnd_api.g_exc_error ;
725:
726: END IF ;
727:
728: close c_awd_project ;

Line 754: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

750:
751: -- =================
752: -- Make sure that X_return_status is success before continue.
753: -- =================
754: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
755:
756: Raise fnd_api.g_exc_error ;
757: END IF ;
758:

Line 756: Raise fnd_api.g_exc_error ;

752: -- Make sure that X_return_status is success before continue.
753: -- =================
754: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
755:
756: Raise fnd_api.g_exc_error ;
757: END IF ;
758:
759: -- ********* ERROR Return Here ********
760: -- =======

Line 771: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

767:
768: -- =================
769: -- Make sure that X_return_status is success before continue.
770: -- =================
771: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
772:
773: -- ********* ERROR Return Here ********
774: Raise fnd_api.g_exc_error ;
775: END IF ;

Line 774: Raise fnd_api.g_exc_error ;

770: -- =================
771: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
772:
773: -- ********* ERROR Return Here ********
774: Raise fnd_api.g_exc_error ;
775: END IF ;
776:
777: G_stage := 'Insert_award ' ;
778: insert_award_record ( X_return_status ) ;

Line 783: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

779:
780: -- =================
781: -- Make sure that X_return_status is success before continue.
782: -- =================
783: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
784:
785: -- ********* ERROR Return Here ********
786: Raise fnd_api.g_exc_error ;
787: END IF ;

Line 786: Raise fnd_api.g_exc_error ;

782: -- =================
783: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
784:
785: -- ********* ERROR Return Here ********
786: Raise fnd_api.g_exc_error ;
787: END IF ;
788:
789: -- ===============================================
790: -- Create Award Manger Personnel

Line 792: IF X_return_status = FND_API.G_RET_STS_SUCCESS THEN

788:
789: -- ===============================================
790: -- Create Award Manger Personnel
791: -- ===============================================
792: IF X_return_status = FND_API.G_RET_STS_SUCCESS THEN
793:
794: gms_award_manager_pkg.insert_award_manager_id ( g_award_rec.award_id,
795: g_award_rec.award_manager_id,
796: g_award_rec.start_date_active ) ;

Line 799: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

795: g_award_rec.award_manager_id,
796: g_award_rec.start_date_active ) ;
797: END IF ;
798:
799: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
800: Raise fnd_api.g_exc_error ;
801: END IF ;
802:
803: -- =============

Line 800: Raise fnd_api.g_exc_error ;

796: g_award_rec.start_date_active ) ;
797: END IF ;
798:
799: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
800: Raise fnd_api.g_exc_error ;
801: END IF ;
802:
803: -- =============
804: -- Creating Billing /Shipping contacts for award creation in progress.

Line 854: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

850:
851: -- =================
852: -- Make sure that X_return_status is success before continue.
853: -- =================
854: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
855: -- ********* ERROR Return Here ********
856: Raise fnd_api.g_exc_error ;
857: END IF;
858: END IF;

Line 856: Raise fnd_api.g_exc_error ;

852: -- Make sure that X_return_status is success before continue.
853: -- =================
854: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
855: -- ********* ERROR Return Here ********
856: Raise fnd_api.g_exc_error ;
857: END IF;
858: END IF;
859:
860: L_contact_rec.contact_id := G_bill_contact_rec.ship_to_contact_id ;

Line 885: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

881:
882: -- =================
883: -- Make sure that X_return_status is success before continue.
884: -- =================
885: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
886:
887: -- ********* ERROR Return Here ********
888: Raise fnd_api.g_exc_error ;
889: END IF ;

Line 888: Raise fnd_api.g_exc_error ;

884: -- =================
885: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
886:
887: -- ********* ERROR Return Here ********
888: Raise fnd_api.g_exc_error ;
889: END IF ;
890: END IF ;
891: reset_message_flag ;
892: x_award_id := G_award_rec.award_id ;

Line 905: WHEN FND_API.G_EXC_ERROR THEN

901: set_return_status(X_return_status, 'B' ) ;
902: x_msg_count := G_msg_count ;
903: x_msg_data := G_msg_data ;
904:
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO save_award_pvt ;
907: set_return_status(X_return_status, 'B' ) ;
908: x_msg_count := G_msg_count ;
909: x_msg_data := G_msg_data ;

Line 912: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

908: x_msg_count := G_msg_count ;
909: x_msg_data := G_msg_data ;
910: WHEN OTHERS THEN
911: ROLLBACK TO save_award_pvt;
912: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913:
914: FND_MSG_PUB.add_exc_msg
915: ( p_pkg_name => G_PKG_NAME
916: , p_procedure_name => l_api_name );

Line 2028: RAISE FND_API.G_EXC_ERROR;

2024: ,x_return_status => l_return_status );
2025:
2026:
2027: IF l_Return_Status <> 'S' then
2028: RAISE FND_API.G_EXC_ERROR;
2029: END IF;
2030:
2031: -- Create Options for the award project template.
2032: insert into pa_project_options

Line 2063: WHEN FND_API.G_EXC_ERROR then

2059:
2060: end if;
2061:
2062: EXCEPTION
2063: WHEN FND_API.G_EXC_ERROR then
2064: X_return_status := l_return_status;
2065:
2066: WHEN OTHERS then
2067: X_return_status := l_return_status;

Line 2104: p_init_msg_list => FND_API.G_TRUE,

2100: CLOSE c_bill_to_customer_overridable;
2101:
2102: IF l_project_id IS NULL AND x_field_name = 'BILL_TO_CUSTOMER' THEN
2103: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2104: p_init_msg_list => FND_API.G_TRUE,
2105: p_commit => FND_API.G_FALSE,
2106: p_validate_only => FND_API.G_FALSE,
2107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2108: p_calling_module => 'FORM',

Line 2105: p_commit => FND_API.G_FALSE,

2101:
2102: IF l_project_id IS NULL AND x_field_name = 'BILL_TO_CUSTOMER' THEN
2103: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2104: p_init_msg_list => FND_API.G_TRUE,
2105: p_commit => FND_API.G_FALSE,
2106: p_validate_only => FND_API.G_FALSE,
2107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2108: p_calling_module => 'FORM',
2109: p_debug_mode => 'N',

Line 2106: p_validate_only => FND_API.G_FALSE,

2102: IF l_project_id IS NULL AND x_field_name = 'BILL_TO_CUSTOMER' THEN
2103: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2104: p_init_msg_list => FND_API.G_TRUE,
2105: p_commit => FND_API.G_FALSE,
2106: p_validate_only => FND_API.G_FALSE,
2107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2108: p_calling_module => 'FORM',
2109: p_debug_mode => 'N',
2110: p_max_msg_count => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2103: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2104: p_init_msg_list => FND_API.G_TRUE,
2105: p_commit => FND_API.G_FALSE,
2106: p_validate_only => FND_API.G_FALSE,
2107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2108: p_calling_module => 'FORM',
2109: p_debug_mode => 'N',
2110: p_max_msg_count => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2111: p_project_id => x_award_project_id,

Line 2125: RAISE FND_API.G_EXC_ERROR;

2121: x_msg_data => l_msg_data);
2122:
2123:
2124: IF l_Return_Status < 'S' then
2125: RAISE FND_API.G_EXC_ERROR;
2126: END IF;
2127:
2128: END IF;
2129:

Line 2133: p_init_msg_list => FND_API.G_TRUE,

2129:
2130:
2131: IF l_project_id IS NULL AND x_field_name = 'SHIP_TO_CUSTOMER' THEN
2132: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2133: p_init_msg_list => FND_API.G_TRUE,
2134: p_commit => FND_API.G_FALSE,
2135: p_validate_only => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: p_calling_module => 'FORM',

Line 2134: p_commit => FND_API.G_FALSE,

2130:
2131: IF l_project_id IS NULL AND x_field_name = 'SHIP_TO_CUSTOMER' THEN
2132: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2133: p_init_msg_list => FND_API.G_TRUE,
2134: p_commit => FND_API.G_FALSE,
2135: p_validate_only => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: p_calling_module => 'FORM',
2138: p_debug_mode => 'N',

Line 2135: p_validate_only => FND_API.G_FALSE,

2131: IF l_project_id IS NULL AND x_field_name = 'SHIP_TO_CUSTOMER' THEN
2132: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2133: p_init_msg_list => FND_API.G_TRUE,
2134: p_commit => FND_API.G_FALSE,
2135: p_validate_only => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: p_calling_module => 'FORM',
2138: p_debug_mode => 'N',
2139: p_max_msg_count => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2132: PA_PROJ_TEMPLATE_SETUP_PUB.ADD_QUICK_ENTRY_FIELD( p_api_version => 1.0,
2133: p_init_msg_list => FND_API.G_TRUE,
2134: p_commit => FND_API.G_FALSE,
2135: p_validate_only => FND_API.G_FALSE,
2136: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2137: p_calling_module => 'FORM',
2138: p_debug_mode => 'N',
2139: p_max_msg_count => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2140: p_project_id => x_award_project_id,

Line 2154: RAISE FND_API.G_EXC_ERROR;

2150: x_msg_data => l_msg_data);
2151:
2152:
2153: IF l_Return_Status < 'S' then
2154: RAISE FND_API.G_EXC_ERROR;
2155: END IF;
2156:
2157: END IF;
2158: EXCEPTION

Line 2159: WHEN FND_API.G_EXC_ERROR then

2155: END IF;
2156:
2157: END IF;
2158: EXCEPTION
2159: WHEN FND_API.G_EXC_ERROR then
2160: X_Return_Status := l_return_status;
2161:
2162: WHEN OTHERS then
2163: X_Return_Status := l_return_status;

Line 2272: P_commit => FND_API.G_FALSE,

2268: p_class_categories => L_Class_Categories_IN_TBL,
2269: p_tasks_in => L_Tasks_IN_TBL,
2270: p_tasks_out => L_Tasks_OUT_TBL,
2271: p_workflow_started => L_Workflow_Started,
2272: P_commit => FND_API.G_FALSE,
2273: /** Bug 3576717 **/
2274: P_deliverables_in => L_Deliverable_IN_TBL,
2275: --P_deliverables_out => L_Deliverable_OUT_TBL, (3650374)
2276: P_deliverable_actions_in => L_Deliverable_Action_IN_TBL

Line 2279: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS then

2275: --P_deliverables_out => L_Deliverable_OUT_TBL, (3650374)
2276: P_deliverable_actions_in => L_Deliverable_Action_IN_TBL
2277: --P_deliverable_actions_out=> L_Deliverable_Action_OUT_TBL (3650374)
2278: );
2279: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS then
2280:
2281: -- -------------------------------------------------
2282: -- Create award project failed So return to the create
2283: -- award. Failure status is allready set by

Line 2513: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in

2509:
2510: -- ============
2511: -- Initialize the return status.
2512: -- ============
2513: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
2514: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
2515:
2516: X_return_status := FND_API.G_RET_STS_SUCCESS ;
2517:

Line 2514: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

2510: -- ============
2511: -- Initialize the return status.
2512: -- ============
2513: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
2514: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
2515:
2516: X_return_status := FND_API.G_RET_STS_SUCCESS ;
2517:
2518: END IF ;

Line 2516: X_return_status := FND_API.G_RET_STS_SUCCESS ;

2512: -- ============
2513: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
2514: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
2515:
2516: X_return_status := FND_API.G_RET_STS_SUCCESS ;
2517:
2518: END IF ;
2519:
2520: SAVEPOINT copy_award_pvt ;

Line 2522: G_stage := 'FND_API.Compatible_API_Call' ;

2518: END IF ;
2519:
2520: SAVEPOINT copy_award_pvt ;
2521:
2522: G_stage := 'FND_API.Compatible_API_Call' ;
2523:
2524: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
2525: p_api_version_number ,
2526: l_api_name ,

Line 2524: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

2520: SAVEPOINT copy_award_pvt ;
2521:
2522: G_stage := 'FND_API.Compatible_API_Call' ;
2523:
2524: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
2525: p_api_version_number ,
2526: l_api_name ,
2527: G_pkg_name )
2528: THEN

Line 2791: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2787:
2788: -- =================
2789: -- Make sure that X_return_status is success before continue.
2790: -- =================
2791: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2792:
2793: -- ********* ERROR Return Here ********
2794: Raise fnd_api.g_exc_error ;
2795: END IF ;

Line 2794: Raise fnd_api.g_exc_error ;

2790: -- =================
2791: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2792:
2793: -- ********* ERROR Return Here ********
2794: Raise fnd_api.g_exc_error ;
2795: END IF ;
2796:
2797: p_award_number := g_award_rec.award_number ;
2798:

Line 2858: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2854:
2855: -- =================
2856: -- Make sure that X_return_status is success before continue.
2857: -- =================
2858: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2859: Raise fnd_api.g_exc_error ;
2860: END IF ;
2861:
2862: END LOOP ;

Line 2859: Raise fnd_api.g_exc_error ;

2855: -- =================
2856: -- Make sure that X_return_status is success before continue.
2857: -- =================
2858: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2859: Raise fnd_api.g_exc_error ;
2860: END IF ;
2861:
2862: END LOOP ;
2863: end if;

Line 2921: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2917:
2918: -- =================
2919: -- Make sure that X_return_status is success before continue.
2920: -- =================
2921: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2922: Raise fnd_api.g_exc_error ;
2923: END IF ;
2924:
2925: END LOOP ;

Line 2922: Raise fnd_api.g_exc_error ;

2918: -- =================
2919: -- Make sure that X_return_status is success before continue.
2920: -- =================
2921: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2922: Raise fnd_api.g_exc_error ;
2923: END IF ;
2924:
2925: END LOOP ;
2926:

Line 2962: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2958:
2959: -- =================
2960: -- Make sure that X_return_status is success before continue.
2961: -- =================
2962: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2963: Raise fnd_api.g_exc_error ;
2964: END IF ;
2965:
2966: END LOOP ;

Line 2963: Raise fnd_api.g_exc_error ;

2959: -- =================
2960: -- Make sure that X_return_status is success before continue.
2961: -- =================
2962: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2963: Raise fnd_api.g_exc_error ;
2964: END IF ;
2965:
2966: END LOOP ;
2967:

Line 2999: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2995: l_refnum_rec ) ;
2996: -- =================
2997: -- Make sure that X_return_status is success before continue.
2998: -- =================
2999: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3000: Raise fnd_api.g_exc_error ;
3001: END IF ;
3002:
3003: END LOOP ;

Line 3000: Raise fnd_api.g_exc_error ;

2996: -- =================
2997: -- Make sure that X_return_status is success before continue.
2998: -- =================
2999: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3000: Raise fnd_api.g_exc_error ;
3001: END IF ;
3002:
3003: END LOOP ;
3004:

Line 3034: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

3030: l_termscond_rec ) ;
3031: -- =================
3032: -- Make sure that X_return_status is success before continue.
3033: -- =================
3034: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3035: Raise fnd_api.g_exc_error ;
3036: END IF ;
3037:
3038: END LOOP ;

Line 3035: Raise fnd_api.g_exc_error ;

3031: -- =================
3032: -- Make sure that X_return_status is success before continue.
3033: -- =================
3034: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3035: Raise fnd_api.g_exc_error ;
3036: END IF ;
3037:
3038: END LOOP ;
3039:

Line 3048: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

3044:
3045: -- =================
3046: -- Make sure that X_return_status is success before continue.
3047: -- =================
3048: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3049: Raise fnd_api.g_exc_error ;
3050: END IF ;
3051:
3052: reset_message_flag ;

Line 3049: Raise fnd_api.g_exc_error ;

3045: -- =================
3046: -- Make sure that X_return_status is success before continue.
3047: -- =================
3048: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3049: Raise fnd_api.g_exc_error ;
3050: END IF ;
3051:
3052: reset_message_flag ;
3053:

Line 3064: WHEN FND_API.G_EXC_ERROR THEN

3060: set_return_status(X_return_status, 'B' ) ;
3061: x_msg_count := G_msg_count ;
3062: x_msg_data := G_msg_data ;
3063:
3064: WHEN FND_API.G_EXC_ERROR THEN
3065: ROLLBACK TO copy_award_pvt ;
3066: set_return_status(X_return_status, 'B' ) ;
3067: x_msg_count := G_msg_count ;
3068: x_msg_data := G_msg_data ;

Line 3071: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3067: x_msg_count := G_msg_count ;
3068: x_msg_data := G_msg_data ;
3069: WHEN OTHERS THEN
3070: ROLLBACK TO copy_award_pvt ;
3071: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3072: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME
3073: , p_procedure_name => l_api_name );
3074: FND_MSG_PUB.Count_And_Get
3075: ( p_count => x_msg_count ,

Line 3259: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN

3255:
3256: -- ============
3257: -- Initialize the return status.
3258: -- ============
3259: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
3260: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
3261: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3262: END IF ;
3263:

Line 3260: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

3256: -- ============
3257: -- Initialize the return status.
3258: -- ============
3259: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
3260: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
3261: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3262: END IF ;
3263:
3264: SAVEPOINT create_installment_pvt ;

Line 3261: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3257: -- Initialize the return status.
3258: -- ============
3259: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
3260: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
3261: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3262: END IF ;
3263:
3264: SAVEPOINT create_installment_pvt ;
3265:

Line 3266: G_stage := 'FND_API.Compatible_API_Call' ;

3262: END IF ;
3263:
3264: SAVEPOINT create_installment_pvt ;
3265:
3266: G_stage := 'FND_API.Compatible_API_Call' ;
3267:
3268: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
3269: p_api_version_number ,
3270: l_api_name ,

Line 3268: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

3264: SAVEPOINT create_installment_pvt ;
3265:
3266: G_stage := 'FND_API.Compatible_API_Call' ;
3267:
3268: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
3269: p_api_version_number ,
3270: l_api_name ,
3271: G_pkg_name ) THEN
3272: RAISE e_ver_mismatch ;

Line 3315: G_stage := 'FND_API.Verify_Instal_start_date_with_Award_start_date';

3311: CLOSE l_installment_type_csr ;
3312:
3313:
3314:
3315: G_stage := 'FND_API.Verify_Instal_start_date_with_Award_start_date';
3316:
3317: IF G_installment_rec.start_date_active IS NOT NULL
3318: and l_award_start_date_active IS NOT NULL
3319: and G_installment_rec.start_date_active < l_award_start_date_active THEN

Line 3325: G_stage := 'FND_API.Verify_Instal_start_date_with_Instal_end_date';

3321: set_return_status ( X_return_status, 'B') ;
3322: END IF ;
3323:
3324:
3325: G_stage := 'FND_API.Verify_Instal_start_date_with_Instal_end_date';
3326:
3327: IF G_installment_rec.start_date_active IS NOT NULL
3328: and G_installment_rec.end_date_active IS NOT NULL
3329: and G_installment_rec.start_date_active > G_installment_rec.end_date_active THEN

Line 3334: G_stage := 'FND_API.Verify_Instal_end_date_with_Award_end_date';

3330: add_message_to_stack( P_label => 'GMS_INST_ENDATE_BEF_INS_STDATE');
3331: set_return_status ( X_return_status, 'B') ;
3332: END IF ;
3333:
3334: G_stage := 'FND_API.Verify_Instal_end_date_with_Award_end_date';
3335:
3336: IF G_installment_rec.start_date_active IS NOT NULL
3337: and G_installment_rec.end_date_active IS NOT NULL
3338: and G_installment_rec.end_date_active > l_award_end_date_active THEN

Line 3343: G_stage := 'FND_API.Verify_Instal_end_date_with_Instal_close_date';

3339: add_message_to_stack( P_label =>'GMS_INS_ENDATE_AFTER_AWENDATE');
3340: set_return_status ( X_return_status, 'B') ;
3341: END IF ;
3342:
3343: G_stage := 'FND_API.Verify_Instal_end_date_with_Instal_close_date';
3344:
3345: IF G_installment_rec.end_date_active IS NOT NULL
3346: and G_installment_rec.close_date IS NOT NULL
3347: and G_installment_rec.end_date_active > G_installment_rec.close_date THEN

Line 3352: G_stage := 'FND_API.Verify_Instal_close_date_with_Award_close_date';

3348: add_message_to_stack( P_label => 'GMS_INS_CLOSEDATE_BEF_ENDDATE') ;
3349: set_return_status ( X_return_status, 'B') ;
3350: END IF ;
3351:
3352: G_stage := 'FND_API.Verify_Instal_close_date_with_Award_close_date';
3353:
3354: IF G_installment_rec.close_date IS NOT NULL
3355: and l_award_close_date is NOT NULL
3356: and G_installment_rec.close_date > l_award_close_date THEN

Line 3363: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

3359: END IF ;
3360:
3361: -- If the return_status <> g_ret_sts_success then we don't proceed with the Inserts.
3362:
3363: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF ;
3366:
3367:

Line 3364: RAISE FND_API.G_EXC_ERROR;

3360:
3361: -- If the return_status <> g_ret_sts_success then we don't proceed with the Inserts.
3362:
3363: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF ;
3366:
3367:
3368: SELECT gms_installments_s.nextval

Line 3372: G_stage := 'FND_API.Create_Installment' ;

3368: SELECT gms_installments_s.nextval
3369: INTO G_installment_rec.installment_id
3370: FROM dual;
3371:
3372: G_stage := 'FND_API.Create_Installment' ;
3373:
3374: gms_installments_pkg.insert_row(
3375: X_ROWID => l_rowid,
3376: X_INSTALLMENT_ID => G_installment_rec.installment_id,

Line 3407: G_stage := 'FND_API.Create_Notification' ;

3403: X_ATTRIBUTE14 =>G_installment_rec.attribute14,
3404: X_ATTRIBUTE15 =>G_installment_rec.attribute15,
3405: X_MODE => 'R' );
3406:
3407: G_stage := 'FND_API.Create_Notification' ;
3408:
3409: IF G_installment_rec.active_flag = 'Y' THEN
3410: gms_wf_pkg.init_installment_wf(x_installment_id=> G_installment_rec.installment_id ,
3411: x_award_id => G_installment_rec.award_id);

Line 3433: WHEN FND_API.G_EXC_ERROR THEN

3429: set_return_status(X_return_status, 'B' ) ;
3430: x_msg_count := G_msg_count ;
3431: x_msg_data := G_msg_data ;
3432:
3433: WHEN FND_API.G_EXC_ERROR THEN
3434: G_installment_rec := NULL ; -- Resetting the record vaarible.
3435: ROLLBACK TO create_installment_pvt ;
3436: set_return_status(X_return_status, 'B' ) ;
3437: x_msg_count := G_msg_count ;

Line 3442: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3438: x_msg_data := G_msg_data ;
3439: WHEN OTHERS THEN
3440: G_installment_rec := NULL ; -- Resetting the record vaarible.
3441: ROLLBACK TO create_installment_pvt ;
3442: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3443:
3444: FND_MSG_PUB.add_exc_msg
3445: ( p_pkg_name => G_PKG_NAME
3446: , p_procedure_name => l_api_name );

Line 3713: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

3709: , X_MSG_DATA => x_msg_data
3710: );
3711:
3712:
3713: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
3714: set_return_status ( X_return_status, 'B') ;
3715:
3716: END IF ;
3717: END Create_Pa_Key_Member ;

Line 3734: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN

3730:
3731: -- =============================
3732: -- Initialize the return status.
3733: -- =============================
3734: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
3735: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
3736: X_return_status := FND_API.G_RET_STS_SUCCESS ;
3737: END IF ;
3738:

Line 3735: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

3731: -- =============================
3732: -- Initialize the return status.
3733: -- =============================
3734: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
3735: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
3736: X_return_status := FND_API.G_RET_STS_SUCCESS ;
3737: END IF ;
3738:
3739: SAVEPOINT create_personnel_pvt ;

Line 3736: X_return_status := FND_API.G_RET_STS_SUCCESS ;

3732: -- Initialize the return status.
3733: -- =============================
3734: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
3735: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
3736: X_return_status := FND_API.G_RET_STS_SUCCESS ;
3737: END IF ;
3738:
3739: SAVEPOINT create_personnel_pvt ;
3740:

Line 3741: G_stage := 'FND_API.Compatible_API_Call' ;

3737: END IF ;
3738:
3739: SAVEPOINT create_personnel_pvt ;
3740:
3741: G_stage := 'FND_API.Compatible_API_Call' ;
3742:
3743: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
3744: p_api_version_number ,
3745: l_api_name ,

Line 3743: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

3739: SAVEPOINT create_personnel_pvt ;
3740:
3741: G_stage := 'FND_API.Compatible_API_Call' ;
3742:
3743: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
3744: p_api_version_number ,
3745: l_api_name ,
3746: G_pkg_name )
3747: THEN

Line 3793: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

3789:
3790: -- =========================================================
3791: -- Make sure that X_return_status is success before continue.
3792: -- =========================================================
3793: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3794: Raise fnd_api.g_exc_error ;
3795: END IF ;
3796:
3797: -- ==================================================================

Line 3794: Raise fnd_api.g_exc_error ;

3790: -- =========================================================
3791: -- Make sure that X_return_status is success before continue.
3792: -- =========================================================
3793: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
3794: Raise fnd_api.g_exc_error ;
3795: END IF ;
3796:
3797: -- ==================================================================
3798: -- If the Start_Date_Active is NULL for PERSONNEL record then take the

Line 3806: G_stage := 'FND_API.Check_Start_Date_Active' ;

3802: If G_personnel_rec.start_date_active IS NULL THEN
3803: G_personnel_rec.start_date_active := l_start_date_active ;
3804: END IF ;
3805:
3806: G_stage := 'FND_API.Check_Start_Date_Active' ;
3807: Verify_dates(p_validate , X_return_status ) ;
3808:
3809: G_stage := 'FND_API.Verify_Award_Manager_Dates' ;
3810: Verify_Award_Manager_Dates (p_validate , X_return_status) ;

Line 3809: G_stage := 'FND_API.Verify_Award_Manager_Dates' ;

3805:
3806: G_stage := 'FND_API.Check_Start_Date_Active' ;
3807: Verify_dates(p_validate , X_return_status ) ;
3808:
3809: G_stage := 'FND_API.Verify_Award_Manager_Dates' ;
3810: Verify_Award_Manager_Dates (p_validate , X_return_status) ;
3811:
3812: G_stage := 'FND_API.Verify_User_Status' ;
3813: Verify_User_Status(p_validate , X_return_status) ;

Line 3812: G_stage := 'FND_API.Verify_User_Status' ;

3808:
3809: G_stage := 'FND_API.Verify_Award_Manager_Dates' ;
3810: Verify_Award_Manager_Dates (p_validate , X_return_status) ;
3811:
3812: G_stage := 'FND_API.Verify_User_Status' ;
3813: Verify_User_Status(p_validate , X_return_status) ;
3814:
3815:
3816: IF G_personnel_rec.award_role = 'AM'AND l_award_template_flag = 'DEFERRED' THEN

Line 3818: G_stage := 'FND_API.Create_Pa_Key_Member' ;

3814:
3815:
3816: IF G_personnel_rec.award_role = 'AM'AND l_award_template_flag = 'DEFERRED' THEN
3817:
3818: G_stage := 'FND_API.Create_Pa_Key_Member' ;
3819: Create_Pa_Key_Member( p_validate , X_return_status ) ;
3820: END IF ;
3821:
3822: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

Line 3822: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

3818: G_stage := 'FND_API.Create_Pa_Key_Member' ;
3819: Create_Pa_Key_Member( p_validate , X_return_status ) ;
3820: END IF ;
3821:
3822: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
3823: RAISE FND_API.G_EXC_ERROR;
3824: END IF ;
3825:
3826:

Line 3823: RAISE FND_API.G_EXC_ERROR;

3819: Create_Pa_Key_Member( p_validate , X_return_status ) ;
3820: END IF ;
3821:
3822: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
3823: RAISE FND_API.G_EXC_ERROR;
3824: END IF ;
3825:
3826:
3827: SELECT gms_personnel_s.nextval

Line 3831: G_stage := 'FND_API.Create_Personnel_Record' ;

3827: SELECT gms_personnel_s.nextval
3828: INTO G_personnel_rec.personnel_id
3829: FROM DUAL ;
3830:
3831: G_stage := 'FND_API.Create_Personnel_Record' ;
3832: gms_personnel_pkg.insert_row
3833: ( x_rowid => L_rowid,
3834: x_personnel_id => G_personnel_rec.personnel_id,
3835: x_award_id => G_personnel_rec.award_id,

Line 3844: G_stage := 'FND_API.Create_Person_Events' ;

3840: x_required_flag => G_personnel_rec.required_flag,
3841: x_mode => 'R'
3842: );
3843:
3844: G_stage := 'FND_API.Create_Person_Events' ;
3845: gms_notification_pkg.crt_default_person_events
3846: ( p_award_id => G_personnel_rec.award_id,
3847: p_person_id => G_personnel_rec.person_id,
3848: x_err_code => l_error_code,

Line 3864: WHEN FND_API.G_EXC_ERROR THEN

3860: set_return_status(X_return_status, 'B' ) ;
3861: x_msg_count := G_msg_count ;
3862: x_msg_data := G_msg_data ;
3863:
3864: WHEN FND_API.G_EXC_ERROR THEN
3865: G_personnel_rec := NULL ; -- Resetting the record vaarible.
3866: ROLLBACK TO create_personnel_pvt ;
3867: set_return_status(X_return_status, 'B' ) ;
3868: x_msg_count := G_msg_count ;

Line 3873: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3869: x_msg_data := G_msg_data ;
3870: WHEN OTHERS THEN
3871: G_personnel_rec := NULL ; -- Resetting the record vaarible.
3872: ROLLBACK TO create_personnel_pvt;
3873: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3874:
3875: FND_MSG_PUB.add_exc_msg
3876: ( p_pkg_name => G_PKG_NAME
3877: , p_procedure_name => l_api_name );

Line 4019: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN

4015:
4016: -- ============================
4017: -- Initialize the return status.
4018: -- ============================
4019: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
4020: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4021: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4022: END IF ;
4023:

Line 4020: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

4016: -- ============================
4017: -- Initialize the return status.
4018: -- ============================
4019: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
4020: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4021: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4022: END IF ;
4023:
4024: SAVEPOINT create_award_term_cond_pvt ;

Line 4021: x_return_status := FND_API.G_RET_STS_SUCCESS ;

4017: -- Initialize the return status.
4018: -- ============================
4019: IF NVL(x_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
4020: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4021: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4022: END IF ;
4023:
4024: SAVEPOINT create_award_term_cond_pvt ;
4025:

Line 4026: G_stage := 'FND_API.Compatible_API_Call' ;

4022: END IF ;
4023:
4024: SAVEPOINT create_award_term_cond_pvt ;
4025:
4026: G_stage := 'FND_API.Compatible_API_Call' ;
4027:
4028: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4029: p_api_version_number ,
4030: l_api_name ,

Line 4028: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

4024: SAVEPOINT create_award_term_cond_pvt ;
4025:
4026: G_stage := 'FND_API.Compatible_API_Call' ;
4027:
4028: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4029: p_api_version_number ,
4030: l_api_name ,
4031: G_pkg_name ) THEN
4032: RAISE e_ver_mismatch ;

Line 4082: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

4078: CLOSE l_check_duplicate_csr ;
4079:
4080: END IF ; -- end if for p_validate.
4081:
4082: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4083: RAISE fnd_api.g_exc_error ;
4084: END IF ; -- end if for nvl(x_return_status) .
4085:
4086: G_stage := 'FND_API.Creating_Award_term_condition_record ' ;

Line 4083: RAISE fnd_api.g_exc_error ;

4079:
4080: END IF ; -- end if for p_validate.
4081:
4082: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4083: RAISE fnd_api.g_exc_error ;
4084: END IF ; -- end if for nvl(x_return_status) .
4085:
4086: G_stage := 'FND_API.Creating_Award_term_condition_record ' ;
4087: gms_awards_tc_pkg.insert_row

Line 4086: G_stage := 'FND_API.Creating_Award_term_condition_record ' ;

4082: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4083: RAISE fnd_api.g_exc_error ;
4084: END IF ; -- end if for nvl(x_return_status) .
4085:
4086: G_stage := 'FND_API.Creating_Award_term_condition_record ' ;
4087: gms_awards_tc_pkg.insert_row
4088: ( X_ROWID => l_rowid,
4089: X_AWARD_ID => G_term_condition_rec.award_id,
4090: X_CATEGORY_ID => G_term_condition_rec.category_id,

Line 4098: G_stage := 'FND_API.Succefully_created_award_term_condition' ;

4094: X_MODE => 'R'
4095: ) ;
4096: G_term_condition_rec := NULL ; -- Resetting the record vaarible.
4097:
4098: G_stage := 'FND_API.Succefully_created_award_term_condition' ;
4099:
4100:
4101: EXCEPTION
4102: WHEN E_VER_MISMATCH THEN

Line 4110: WHEN FND_API.G_EXC_ERROR THEN

4106: set_return_status(x_return_status, 'B' ) ;
4107: X_msg_count := G_msg_count ;
4108: X_msg_data := G_msg_data ;
4109:
4110: WHEN FND_API.G_EXC_ERROR THEN
4111: G_term_condition_rec := NULL ; -- Resetting the record vaarible.
4112: ROLLBACK TO create_award_term_cond_pvt ;
4113: set_return_status(x_return_status, 'B' ) ;
4114: X_msg_count := G_msg_count ;

Line 4119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4115: X_msg_data := G_msg_data ;
4116: WHEN OTHERS THEN
4117: G_term_condition_rec := NULL ; -- Resetting the record vaarible.
4118: ROLLBACK TO create_award_term_cond_pvt ;
4119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4120:
4121: FND_MSG_PUB.add_exc_msg
4122: ( p_pkg_name => G_PKG_NAME
4123: , p_procedure_name => l_api_name );

Line 4215: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN

4211:
4212: -- =============================
4213: -- Initialize the return status.
4214: -- =============================
4215: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
4216: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4217: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4218: END IF ;
4219:

Line 4216: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

4212: -- =============================
4213: -- Initialize the return status.
4214: -- =============================
4215: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
4216: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4217: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4218: END IF ;
4219:
4220: SAVEPOINT create_reference_number_pvt ;

Line 4217: X_return_status := FND_API.G_RET_STS_SUCCESS ;

4213: -- Initialize the return status.
4214: -- =============================
4215: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) NOT IN
4216: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4217: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4218: END IF ;
4219:
4220: SAVEPOINT create_reference_number_pvt ;
4221:

Line 4222: G_stage := 'FND_API.Compatible_API_Call' ;

4218: END IF ;
4219:
4220: SAVEPOINT create_reference_number_pvt ;
4221:
4222: G_stage := 'FND_API.Compatible_API_Call' ;
4223:
4224: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4225: p_api_version_number ,
4226: l_api_name ,

Line 4224: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

4220: SAVEPOINT create_reference_number_pvt ;
4221:
4222: G_stage := 'FND_API.Compatible_API_Call' ;
4223:
4224: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4225: p_api_version_number ,
4226: l_api_name ,
4227: G_pkg_name ) THEN
4228: RAISE e_ver_mismatch ;

Line 4261: -- Here we check whether the return_staus <> FND_API.G_RET_STS_SUCCESS because of

4257: CLOSE l_duplicate_ref_type ;
4258: END IF ; -- end if for p_validate.
4259:
4260: -- ==============================================================================
4261: -- Here we check whether the return_staus <> FND_API.G_RET_STS_SUCCESS because of
4262: -- any above validations . If it is that means some error has happened and we don't
4263: -- insert the record but the control go to exception section.
4264: -- ==============================================================================
4265:

Line 4266: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

4262: -- any above validations . If it is that means some error has happened and we don't
4263: -- insert the record but the control go to exception section.
4264: -- ==============================================================================
4265:
4266: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4267: RAISE fnd_api.g_exc_error ;
4268: END IF ; -- end if for nvl(X_return_status) .
4269:
4270: -- Creating the Reference_number Record .

Line 4267: RAISE fnd_api.g_exc_error ;

4263: -- insert the record but the control go to exception section.
4264: -- ==============================================================================
4265:
4266: IF NVL(X_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
4267: RAISE fnd_api.g_exc_error ;
4268: END IF ; -- end if for nvl(X_return_status) .
4269:
4270: -- Creating the Reference_number Record .
4271:

Line 4272: G_stage := 'FND_API.Creating_reference_number' ;

4268: END IF ; -- end if for nvl(X_return_status) .
4269:
4270: -- Creating the Reference_number Record .
4271:
4272: G_stage := 'FND_API.Creating_reference_number' ;
4273: gms_reference_numbers_pkg.insert_row
4274: ( x_rowid => l_rowid,
4275: x_award_id => G_reference_number_rec.award_id,
4276: x_type => G_reference_number_rec.type,

Line 4284: G_stage := 'FND_API.Succefully_created_reference_number ' ;

4280: );
4281: G_reference_number_rec := NULL ; -- Resetting the record vaarible.
4282:
4283:
4284: G_stage := 'FND_API.Succefully_created_reference_number ' ;
4285:
4286: EXCEPTION
4287: WHEN E_VER_MISMATCH THEN
4288: add_message_to_stack( P_label => 'GMS_API_VER_MISMATCH',

Line 4295: WHEN FND_API.G_EXC_ERROR THEN

4291: set_return_status(X_return_status, 'B' ) ;
4292: x_msg_count := G_msg_count ;
4293: x_msg_data := G_msg_data ;
4294:
4295: WHEN FND_API.G_EXC_ERROR THEN
4296: G_reference_number_rec := NULL ; -- Resetting the record vaarible.
4297: ROLLBACK TO create_reference_number_pvt ;
4298: set_return_status(X_return_status, 'B' ) ;
4299: x_msg_count := G_msg_count ;

Line 4304: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4300: x_msg_data := G_msg_data ;
4301: WHEN OTHERS THEN
4302: G_reference_number_rec := NULL ; -- Resetting the record vaarible.
4303: ROLLBACK TO create_reference_number_pvt ;
4304: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4305:
4306: FND_MSG_PUB.add_exc_msg
4307: ( p_pkg_name => G_PKG_NAME
4308: , p_procedure_name => l_api_name );

Line 4388: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in

4384: -- =============================
4385: -- Initialize the return status.
4386: -- =============================
4387:
4388: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4389: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4390: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4391: END IF ;
4392:

Line 4389: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

4385: -- Initialize the return status.
4386: -- =============================
4387:
4388: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4389: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4390: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4391: END IF ;
4392:
4393: -- =========================

Line 4390: X_return_status := FND_API.G_RET_STS_SUCCESS ;

4386: -- =============================
4387:
4388: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4389: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4390: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4391: END IF ;
4392:
4393: -- =========================
4394: -- Establish the Save Point.

Line 4404: G_stage := 'FND_API.Compatible_API_Call' ;

4400: -- Compare the caller version number to the API version number in
4401: -- order to detect incompatible API calls.
4402: -- ==============================================================
4403:
4404: G_stage := 'FND_API.Compatible_API_Call' ;
4405:
4406: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4407: p_api_version_number ,
4408: l_api_name ,

Line 4406: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

4402: -- ==============================================================
4403:
4404: G_stage := 'FND_API.Compatible_API_Call' ;
4405:
4406: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4407: p_api_version_number ,
4408: l_api_name ,
4409: G_pkg_name )
4410: THEN

Line 4458: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4454: -- validations. There is no point in doing further validations as the
4455: -- required columns donot have values. So we raise an Error.
4456: -- ===================================================================
4457:
4458: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4459: RAISE FND_API.G_EXC_ERROR;
4460: END IF ;
4461:
4462: -- ======================================================================

Line 4459: RAISE FND_API.G_EXC_ERROR;

4455: -- required columns donot have values. So we raise an Error.
4456: -- ===================================================================
4457:
4458: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4459: RAISE FND_API.G_EXC_ERROR;
4460: END IF ;
4461:
4462: -- ======================================================================
4463: -- Verify the contacts for validity by cross checking with funding source

Line 4523: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4519:
4520: CLOSE l_dup_usage_csr ;
4521:
4522:
4523: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4524: RAISE FND_API.G_EXC_ERROR;
4525: END IF ;
4526:
4527:

Line 4524: RAISE FND_API.G_EXC_ERROR;

4520: CLOSE l_dup_usage_csr ;
4521:
4522:
4523: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4524: RAISE FND_API.G_EXC_ERROR;
4525: END IF ;
4526:
4527:
4528: -- ===========================================================================================

Line 4578: WHEN FND_API.G_EXC_ERROR THEN

4574: set_return_status(X_return_status, 'B' ) ;
4575: x_msg_count := G_msg_count ;
4576: x_msg_data := G_msg_data ;
4577:
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: ROLLBACK TO create_contact_pvt ;
4580: set_return_status(X_return_status, 'B' ) ;
4581: x_msg_count := G_msg_count ;
4582: x_msg_data := G_msg_data ;

Line 4585: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4581: x_msg_count := G_msg_count ;
4582: x_msg_data := G_msg_data ;
4583: WHEN OTHERS THEN
4584: ROLLBACK TO create_contact_pvt;
4585: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4586:
4587: FND_MSG_PUB.add_exc_msg
4588: ( p_pkg_name => G_PKG_NAME
4589: , p_procedure_name => l_api_name );

Line 4663: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in

4659: -- ============================
4660: -- Initialize the return status.
4661: -- ============================
4662:
4663: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4664: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4665: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4666: END IF ;
4667:

Line 4664: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

4660: -- Initialize the return status.
4661: -- ============================
4662:
4663: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4664: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4665: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4666: END IF ;
4667:
4668: -- =========================

Line 4665: X_return_status := FND_API.G_RET_STS_SUCCESS ;

4661: -- ============================
4662:
4663: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4664: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4665: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4666: END IF ;
4667:
4668: -- =========================
4669: -- Establish the Save Point.

Line 4679: G_stage := 'FND_API.Compatible_API_Call' ;

4675: -- Compare the caller version number to the API version number in
4676: -- order to detect incompatible API calls.
4677: -- ==============================================================
4678:
4679: G_stage := 'FND_API.Compatible_API_Call' ;
4680:
4681: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4682: p_api_version_number ,
4683: l_api_name ,

Line 4681: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

4677: -- ==============================================================
4678:
4679: G_stage := 'FND_API.Compatible_API_Call' ;
4680:
4681: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4682: p_api_version_number ,
4683: l_api_name ,
4684: G_pkg_name )
4685: THEN

Line 4738: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4734: -- validations. There is no point in doing further validations as the
4735: -- required columns donot have values. So we raise an Error.
4736: -- ===================================================================
4737:
4738: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4739: RAISE FND_API.G_EXC_ERROR;
4740: END IF ;
4741:
4742: -- =================================

Line 4739: RAISE FND_API.G_EXC_ERROR;

4735: -- required columns donot have values. So we raise an Error.
4736: -- ===================================================================
4737:
4738: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4739: RAISE FND_API.G_EXC_ERROR;
4740: END IF ;
4741:
4742: -- =================================
4743: -- Verify the frequency for validity

Line 4759: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4755:
4756: CLOSE l_valid_frequency_csr ;
4757:
4758:
4759: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4760: RAISE FND_API.G_EXC_ERROR;
4761: END IF ;
4762:
4763: -- =====================================

Line 4760: RAISE FND_API.G_EXC_ERROR;

4756: CLOSE l_valid_frequency_csr ;
4757:
4758:
4759: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4760: RAISE FND_API.G_EXC_ERROR;
4761: END IF ;
4762:
4763: -- =====================================
4764: -- Verify the Site Use Code for validity

Line 4783: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4779: CLOSE l_valid_site_code_csr ;
4780:
4781: END IF;
4782:
4783: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4784: RAISE FND_API.G_EXC_ERROR;
4785: END IF ;
4786:
4787: -- ==============================================

Line 4784: RAISE FND_API.G_EXC_ERROR;

4780:
4781: END IF;
4782:
4783: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4784: RAISE FND_API.G_EXC_ERROR;
4785: END IF ;
4786:
4787: -- ==============================================
4788: -- Verify the duplicate reports for a given award

Line 4804: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4800:
4801: CLOSE l_dup_reports_csr ;
4802:
4803:
4804: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4805: RAISE FND_API.G_EXC_ERROR;
4806: END IF ;
4807:
4808: -- ==================================================

Line 4805: RAISE FND_API.G_EXC_ERROR;

4801: CLOSE l_dup_reports_csr ;
4802:
4803:
4804: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4805: RAISE FND_API.G_EXC_ERROR;
4806: END IF ;
4807:
4808: -- ==================================================
4809: -- Sequence number is required for default report id.

Line 4878: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

4874: set_return_status ( X_return_status, 'B') ;
4875:
4876: END IF;
4877:
4878: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4879: RAISE FND_API.G_EXC_ERROR;
4880: END IF ;
4881:
4882: X_DEFAULT_REPORT_ID := G_report_rec.default_report_id ;

Line 4879: RAISE FND_API.G_EXC_ERROR;

4875:
4876: END IF;
4877:
4878: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
4879: RAISE FND_API.G_EXC_ERROR;
4880: END IF ;
4881:
4882: X_DEFAULT_REPORT_ID := G_report_rec.default_report_id ;
4883: G_stage := 'Report Created Successfully' ;

Line 4895: WHEN FND_API.G_EXC_ERROR THEN

4891: set_return_status(X_return_status, 'B' ) ;
4892: x_msg_count := G_msg_count ;
4893: x_msg_data := G_msg_data ;
4894:
4895: WHEN FND_API.G_EXC_ERROR THEN
4896: ROLLBACK TO create_report_pvt ;
4897: set_return_status(X_return_status, 'B' ) ;
4898: x_msg_count := G_msg_count ;
4899: x_msg_data := G_msg_data ;

Line 4902: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4898: x_msg_count := G_msg_count ;
4899: x_msg_data := G_msg_data ;
4900: WHEN OTHERS THEN
4901: ROLLBACK TO create_report_pvt;
4902: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4903:
4904: FND_MSG_PUB.add_exc_msg
4905: ( p_pkg_name => G_PKG_NAME
4906: , p_procedure_name => l_api_name );

Line 4971: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in

4967: -- ============
4968: -- Initialize the return status.
4969: -- ============
4970:
4971: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4972: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4973: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4974: END IF ;
4975:

Line 4972: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

4968: -- Initialize the return status.
4969: -- ============
4970:
4971: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4972: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4973: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4974: END IF ;
4975:
4976: SAVEPOINT create_notification_pvt ;

Line 4973: X_return_status := FND_API.G_RET_STS_SUCCESS ;

4969: -- ============
4970:
4971: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
4972: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
4973: X_return_status := FND_API.G_RET_STS_SUCCESS ;
4974: END IF ;
4975:
4976: SAVEPOINT create_notification_pvt ;
4977:

Line 4978: G_stage := 'FND_API.Compatible_API_Call' ;

4974: END IF ;
4975:
4976: SAVEPOINT create_notification_pvt ;
4977:
4978: G_stage := 'FND_API.Compatible_API_Call' ;
4979:
4980: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4981: p_api_version_number ,
4982: l_api_name ,

Line 4980: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

4976: SAVEPOINT create_notification_pvt ;
4977:
4978: G_stage := 'FND_API.Compatible_API_Call' ;
4979:
4980: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
4981: p_api_version_number ,
4982: l_api_name ,
4983: G_pkg_name )
4984: THEN

Line 5017: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5013: -- validations. There is no point in doing further validations as the
5014: -- required columns donot have values. So we raise an Error.
5015: -- ===================================================================
5016:
5017: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5018: RAISE FND_API.G_EXC_ERROR;
5019: END IF ;
5020:
5021: -- =============================================

Line 5018: RAISE FND_API.G_EXC_ERROR;

5014: -- required columns donot have values. So we raise an Error.
5015: -- ===================================================================
5016:
5017: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5018: RAISE FND_API.G_EXC_ERROR;
5019: END IF ;
5020:
5021: -- =============================================
5022: -- Verify the duplicate events for a given award

Line 5037: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5033: END IF;
5034: CLOSE l_dup_event_csr ;
5035:
5036:
5037: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5038: RAISE FND_API.G_EXC_ERROR;
5039: END IF ;
5040:
5041:

Line 5038: RAISE FND_API.G_EXC_ERROR;

5034: CLOSE l_dup_event_csr ;
5035:
5036:
5037: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5038: RAISE FND_API.G_EXC_ERROR;
5039: END IF ;
5040:
5041:
5042: G_stage := 'create_notification.Verify_report_existence' ;

Line 5072: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5068: CLOSE l_dup_event_csr ;
5069: END IF;
5070:
5071: END IF;
5072: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5073: RAISE FND_API.G_EXC_ERROR;
5074: END IF ;
5075:
5076: G_stage := 'gms_notification_pkg.insert_row' ;

Line 5073: RAISE FND_API.G_EXC_ERROR;

5069: END IF;
5070:
5071: END IF;
5072: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5073: RAISE FND_API.G_EXC_ERROR;
5074: END IF ;
5075:
5076: G_stage := 'gms_notification_pkg.insert_row' ;
5077:

Line 5097: WHEN FND_API.G_EXC_ERROR THEN

5093: set_return_status(X_return_status, 'B' ) ;
5094: x_msg_count := G_msg_count ;
5095: x_msg_data := G_msg_data ;
5096:
5097: WHEN FND_API.G_EXC_ERROR THEN
5098: ROLLBACK TO create_notification_pvt ;
5099: set_return_status(X_return_status, 'B' ) ;
5100: x_msg_count := G_msg_count ;
5101: x_msg_data := G_msg_data ;

Line 5104: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5100: x_msg_count := G_msg_count ;
5101: x_msg_data := G_msg_data ;
5102: WHEN OTHERS THEN
5103: ROLLBACK TO create_notification_pvt;
5104: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5105:
5106: FND_MSG_PUB.add_exc_msg
5107: ( p_pkg_name => G_PKG_NAME
5108: , p_procedure_name => l_api_name );

Line 5225: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in

5221: -- ============================
5222: -- Initialize the return status.
5223: -- ============================
5224:
5225: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
5226: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
5227: X_return_status := FND_API.G_RET_STS_SUCCESS ;
5228: END IF ;
5229:

Line 5226: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN

5222: -- Initialize the return status.
5223: -- ============================
5224:
5225: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
5226: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
5227: X_return_status := FND_API.G_RET_STS_SUCCESS ;
5228: END IF ;
5229:
5230: SAVEPOINT add_funding_pvt ;

Line 5227: X_return_status := FND_API.G_RET_STS_SUCCESS ;

5223: -- ============================
5224:
5225: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) not in
5226: ( FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR ) THEN
5227: X_return_status := FND_API.G_RET_STS_SUCCESS ;
5228: END IF ;
5229:
5230: SAVEPOINT add_funding_pvt ;
5231:

Line 5253: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5249: set_return_status ( X_return_status, 'U') ;
5250:
5251: END IF;
5252:
5253: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5254: RAISE FND_API.G_EXC_ERROR;
5255: END IF ;
5256:
5257: G_stage := 'FND_API.Compatible_API_Call' ;

Line 5254: RAISE FND_API.G_EXC_ERROR;

5250:
5251: END IF;
5252:
5253: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5254: RAISE FND_API.G_EXC_ERROR;
5255: END IF ;
5256:
5257: G_stage := 'FND_API.Compatible_API_Call' ;
5258:

Line 5257: G_stage := 'FND_API.Compatible_API_Call' ;

5253: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5254: RAISE FND_API.G_EXC_ERROR;
5255: END IF ;
5256:
5257: G_stage := 'FND_API.Compatible_API_Call' ;
5258:
5259: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
5260: p_api_version_number ,
5261: l_api_name ,

Line 5259: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

5255: END IF ;
5256:
5257: G_stage := 'FND_API.Compatible_API_Call' ;
5258:
5259: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
5260: p_api_version_number ,
5261: l_api_name ,
5262: G_pkg_name )
5263: THEN

Line 5313: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5309: -- validations. There is no point in doing further validations as the
5310: -- required columns donot have values. So we raise an Error.
5311: -- ===================================================================
5312:
5313: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5314: RAISE FND_API.G_EXC_ERROR;
5315: END IF ;
5316:
5317: -- ===================================================================

Line 5314: RAISE FND_API.G_EXC_ERROR;

5310: -- required columns donot have values. So we raise an Error.
5311: -- ===================================================================
5312:
5313: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5314: RAISE FND_API.G_EXC_ERROR;
5315: END IF ;
5316:
5317: -- ===================================================================
5318: -- Check for the Award Validity

Line 5546: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5542: add_message_to_stack( P_label => 'GMS_FUNDING_AMOUNT_EXCEEDED' ) ;
5543: set_return_status ( X_return_status, 'B') ;
5544: END IF ;
5545:
5546: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5547: RAISE FND_API.G_EXC_ERROR;
5548: END IF ;
5549:
5550: -- ======================================================

Line 5547: RAISE FND_API.G_EXC_ERROR;

5543: set_return_status ( X_return_status, 'B') ;
5544: END IF ;
5545:
5546: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5547: RAISE FND_API.G_EXC_ERROR;
5548: END IF ;
5549:
5550: -- ======================================================
5551: -- Sequence number is required for gms_project_funding_id

Line 5597: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5593: set_return_status ( X_return_status, 'B') ;
5594:
5595: END IF;
5596:
5597: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5598: RAISE FND_API.G_EXC_ERROR;
5599: END IF ;
5600:
5601: -- ============================================================

Line 5598: RAISE FND_API.G_EXC_ERROR;

5594:
5595: END IF;
5596:
5597: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5598: RAISE FND_API.G_EXC_ERROR;
5599: END IF ;
5600:
5601: -- ============================================================
5602: -- PA_PROJECT_FUNDINGS and PA_SUMMARY_PROJECT_FUNDINGS

Line 5629: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then

5625: set_return_status ( X_RETURN_STATUS, 'B') ;
5626:
5627: END IF;
5628:
5629: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5630: RAISE FND_API.G_EXC_ERROR;
5631: END IF ;
5632:
5633: G_stage := 'At the End of the ADD_FUNDING';

Line 5630: RAISE FND_API.G_EXC_ERROR;

5626:
5627: END IF;
5628:
5629: IF NVL(X_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS then
5630: RAISE FND_API.G_EXC_ERROR;
5631: END IF ;
5632:
5633: G_stage := 'At the End of the ADD_FUNDING';
5634:

Line 5645: WHEN FND_API.G_EXC_ERROR THEN

5641: set_return_status(X_RETURN_STATUS, 'B' ) ;
5642: x_msg_count := G_msg_count ;
5643: x_msg_data := G_msg_data ;
5644:
5645: WHEN FND_API.G_EXC_ERROR THEN
5646: ROLLBACK TO add_funding_pvt ;
5647: set_return_status(X_RETURN_STATUS, 'B' ) ;
5648: x_msg_count := G_msg_count ;
5649: x_msg_data := G_msg_data ;

Line 5652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5648: x_msg_count := G_msg_count ;
5649: x_msg_data := G_msg_data ;
5650: WHEN OTHERS THEN
5651: ROLLBACK TO add_funding_pvt;
5652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5653:
5654: FND_MSG_PUB.add_exc_msg
5655: ( P_PKG_NAME => G_PKG_NAME
5656: , P_PROCEDURE_NAME => l_api_name );