APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on FND_API

Line 123: l_return_status := FND_API.G_RET_STS_SUCCESS;

119: l_ubr_uer_msg_data VARCHAR2(30);
120: BEGIN
121:
122: -- Initilizing status variable with success status
123: l_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: -- Initilizing FND MSG stack, so that it can start storing messages from 0th index
126: FND_MSG_PUB.initialize;
127:

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

633: EXCEPTION
634: WHEN OTHERS THEN
635: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BILLING_WORKBENCH_BILL_PKG'
636: ,p_procedure_name => 'Get_Billing_Sum_Region_Amts' );
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
638: x_msg_count := 1;
639: x_msg_data := SUBSTR(SQLERRM,1,30);
640: RAISE;
641: END Get_Billing_Sum_Region_Amts;

Line 742: x_return_status := FND_API.G_RET_STS_SUCCESS;

738: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
739: )
740: IS
741: BEGIN
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743:
744: DELETE pa_bill_workbench_temp;
745: INSERT
746: INTO pa_bill_workbench_temp(

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

829: EXCEPTION
830: WHEN OTHERS THEN
831: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BILLING_WORKBENCH_BILL_PKG'
832: ,p_procedure_name => 'Populat_Bill_Workbench_Data' );
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834: x_msg_count := 1;
835: x_msg_data := SUBSTR(SQLERRM,1,30);
836: RAISE;
837: END Populat_Bill_Workbench_Data;

Line 870: x_return_status := FND_API.G_RET_STS_SUCCESS;

866: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
867: )
868: IS
869: BEGIN
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871:
872:
873: DELETE pa_bill_wrkbench_inv_temp;
874:

Line 1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1403: EXCEPTION
1404: WHEN OTHERS THEN
1405: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BILLING_WORKBENCH_BILL_PKG'
1406: ,p_procedure_name => 'Populat_Inv_Summ_by_Cust_RN' );
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1408: x_msg_count := 1;
1409: x_msg_data := SUBSTR(SQLERRM,1,30);
1410: RAISE;
1411: END Populat_Inv_Summ_by_Cust_RN;

Line 1570: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

1566: l_project_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1567: l_project_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1568: l_prj_status_tab PA_PLSQL_DATATYPES.Char30TabTyp ;
1569: Begin
1570: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
1571:
1572: --FND_MSG_PUB.initialize;
1573:
1574: SELECT

Line 1656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1652: End If;
1653: /* Handle Exceptions */
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1657: x_msg_count := 1;
1658: x_msg_data := SQLERRM;
1659:
1660: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_BILLING_WORKBENCH_BILL_PKG'