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 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

575: EXCEPTION
576: WHEN OTHERS THEN
577: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BILLING_WORKBENCH_BILL_PKG'
578: ,p_procedure_name => 'Get_Billing_Sum_Region_Amts' );
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: x_msg_count := 1;
581: x_msg_data := SUBSTR(SQLERRM,1,30);
582: RAISE;
583: END Get_Billing_Sum_Region_Amts;

Line 684: x_return_status := FND_API.G_RET_STS_SUCCESS;

680: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
681: )
682: IS
683: BEGIN
684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685:
686: DELETE pa_bill_workbench_temp;
687: INSERT
688: INTO pa_bill_workbench_temp(

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

771: EXCEPTION
772: WHEN OTHERS THEN
773: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BILLING_WORKBENCH_BILL_PKG'
774: ,p_procedure_name => 'Populat_Bill_Workbench_Data' );
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: x_msg_count := 1;
777: x_msg_data := SUBSTR(SQLERRM,1,30);
778: RAISE;
779: END Populat_Bill_Workbench_Data;

Line 812: x_return_status := FND_API.G_RET_STS_SUCCESS;

808: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
809: )
810: IS
811: BEGIN
812: x_return_status := FND_API.G_RET_STS_SUCCESS;
813:
814:
815: DELETE pa_bill_wrkbench_inv_temp;
816:

Line 1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BILLING_WORKBENCH_BILL_PKG'
1334: ,p_procedure_name => 'Populat_Inv_Summ_by_Cust_RN' );
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1336: x_msg_count := 1;
1337: x_msg_data := SUBSTR(SQLERRM,1,30);
1338: RAISE;
1339: END Populat_Inv_Summ_by_Cust_RN;

Line 1498: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

1494: l_project_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1495: l_project_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1496: l_prj_status_tab PA_PLSQL_DATATYPES.Char30TabTyp ;
1497: Begin
1498: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
1499:
1500: --FND_MSG_PUB.initialize;
1501:
1502: SELECT

Line 1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1580: End If;
1581: /* Handle Exceptions */
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1585: x_msg_count := 1;
1586: x_msg_data := SQLERRM;
1587:
1588: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_BILLING_WORKBENCH_BILL_PKG'