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

Line 442: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

438: BEGIN
439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
440: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Creating Billing Event ...');
441: END IF;
442: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
443:
444: --
445: -- Standard Start of API savepoint
446: --

Line 486: X_Return_Status := FND_API.G_RET_STS_ERROR;

482: , BillInfoRec.Pa_Event_ID ) = 'PROJECT'
483: AND BillInfoRec.Bill_Task_ID IS NOT NULL ) THEN
484: FND_MESSAGE.set_name('PA' , 'PA_PR_EPR_EVENTS_AT_PROJ_LVL');
485: FND_MSG_PUB.add;
486: X_Return_Status := FND_API.G_RET_STS_ERROR;
487: END IF;
488:
489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Event Type = ' || BillInfoRec.Bill_Event_Type);

Line 497: X_Return_Status := FND_API.G_RET_STS_ERROR;

493: IF ( BillInfoRec.Bill_Event_Type IS NULL ) THEN
494: fnd_message.set_name('OKE' , 'OKE_API_MISSING_VALUE');
495: fnd_message.set_token('VALUE' , 'BILL_EVENT_TYPE');
496: FND_MSG_PUB.add;
497: X_Return_Status := FND_API.G_RET_STS_ERROR;
498: END IF;
499:
500: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Description = ' || BillInfoRec.Bill_Description);

Line 508: X_Return_Status := FND_API.G_RET_STS_ERROR;

504: IF ( BillInfoRec.Bill_Description IS NULL ) THEN
505: fnd_message.set_name('OKE' , 'OKE_API_MISSING_VALUE');
506: fnd_message.set_token('VALUE' , 'BILL_DESCRIPTION');
507: FND_MSG_PUB.add;
508: X_Return_Status := FND_API.G_RET_STS_ERROR;
509: END IF;
510:
511: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
512: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Bill Amount = ' || BillInfoRec.Bill_Amount);

Line 519: X_Return_Status := FND_API.G_RET_STS_ERROR;

515: IF ( BillInfoRec.Bill_Amount IS NULL ) THEN
516: fnd_message.set_name('OKE' , 'OKE_API_MISSING_VALUE');
517: fnd_message.set_token('VALUE' , 'BILL_AMOUNT');
518: FND_MSG_PUB.add;
519: X_Return_Status := FND_API.G_RET_STS_ERROR;
520: END IF;
521:
522: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
523: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Revenue Amount = ' || BillInfoRec.Revenue_Amount);

Line 530: X_Return_Status := FND_API.G_RET_STS_ERROR;

526: IF ( BillInfoRec.Revenue_Amount IS NULL ) THEN
527: fnd_message.set_name('OKE' , 'OKE_API_MISSING_VALUE');
528: fnd_message.set_token('VALUE' , 'REVENUE_AMOUNT');
529: FND_MSG_PUB.add;
530: X_Return_Status := FND_API.G_RET_STS_ERROR;
531: END IF;
532:
533: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Organization ID = ' || BillInfoRec.Bill_Organization_ID);

Line 540: X_Return_Status := FND_API.G_RET_STS_ERROR;

536: IF ( BillInfoRec.Bill_Organization_ID IS NULL ) THEN
537: fnd_message.set_name('OKE' , 'OKE_API_MISSING_VALUE');
538: fnd_message.set_token('VALUE' , 'BILL_ORGANIZATION_ID');
539: FND_MSG_PUB.add;
540: X_Return_Status := FND_API.G_RET_STS_ERROR;
541: END IF;
542:
543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Project ID = ' || BillInfoRec.Bill_Project_ID);

Line 551: X_Return_Status := FND_API.G_RET_STS_ERROR;

547: IF ( BillInfoRec.Bill_Project_ID IS NULL ) THEN
548: fnd_message.set_name('OKE' , 'OKE_API_MISSING_VALUE');
549: fnd_message.set_token('VALUE' , 'BILL_PROJECT_ID');
550: FND_MSG_PUB.add;
551: X_Return_Status := FND_API.G_RET_STS_ERROR;
552: END IF;
553:
554: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
555: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Task ID = ' || BillInfoRec.Bill_Task_ID);

Line 557: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN

553:
554: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
555: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Task ID = ' || BillInfoRec.Bill_Task_ID);
556: END IF;
557: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:
561: --

Line 558: RAISE FND_API.G_EXC_ERROR;

554: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
555: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Task ID = ' || BillInfoRec.Bill_Task_ID);
556: END IF;
557: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:
561: --
562: -- Addtional check to ensure the record hasn't been deleted from PA

Line 617: ( P_Commit => FND_API.G_FALSE

613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Event Previously Created ...');
614: END IF;
615:
616: Update_Billing_Event
617: ( P_Commit => FND_API.G_FALSE
618: , P_Deliverable_ID => BillInfoRec.Deliverable_ID
619: , P_Event_ID => BillInfoRec.Pa_Event_ID
620: , P_Event_Type => BillInfoRec.Bill_Event_Type
621: , P_Event_Date => BillInfoRec.Bill_Event_Date

Line 682: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

678: , X_Msg_Count => X_Msg_Count
679: , X_Msg_Data => X_Msg_Data
680: );
681:
682: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

679: , X_Msg_Data => X_Msg_Data
680: );
681:
682: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:

Line 684: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN

680: );
681:
682: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 685: RAISE FND_API.G_EXC_ERROR;

681:
682: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Updating deliverable with event info ...');

Line 706: ( P_Commit => FND_API.G_FALSE

702: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Event Not Previously Created ...');
704: END IF;
705: Create_Billing_Event
706: ( P_Commit => FND_API.G_FALSE
707: , P_Event_Type => BillInfoRec.Bill_Event_Type
708: , P_Event_Date => BillInfoRec.Bill_Event_Date
709: , P_Project_ID => BillInfoRec.Bill_Project_ID
710: , P_Task_ID => BillInfoRec.Bill_Task_ID

Line 772: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

768: , X_Msg_Count => X_Msg_Count
769: , X_Msg_Data => X_Msg_Data
770: );
771:
772: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

769: , X_Msg_Data => X_Msg_Data
770: );
771:
772: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777:

Line 774: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN

770: );
771:
772: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777:
778: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 775: RAISE FND_API.G_EXC_ERROR;

771:
772: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777:
778: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Updating deliverable with event info ...');

Line 797: IF FND_API.To_Boolean( p_commit ) THEN

793:
794: --
795: -- Standard commit check
796: --
797: IF FND_API.To_Boolean( p_commit ) THEN
798: COMMIT WORK;
799: END IF;
800:
801: --

Line 809: WHEN FND_API.G_EXC_ERROR THEN

805: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
806: , P_Data => X_Msg_Data );
807:
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: ROLLBACK TO create_billing_event;
811: X_Return_Status := FND_API.G_RET_STS_ERROR;
812: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
813: , P_Data => X_Msg_Data );

Line 811: X_Return_Status := FND_API.G_RET_STS_ERROR;

807:
808: EXCEPTION
809: WHEN FND_API.G_EXC_ERROR THEN
810: ROLLBACK TO create_billing_event;
811: X_Return_Status := FND_API.G_RET_STS_ERROR;
812: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
813: , P_Data => X_Msg_Data );
814:
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

811: X_Return_Status := FND_API.G_RET_STS_ERROR;
812: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
813: , P_Data => X_Msg_Data );
814:
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: ROLLBACK TO create_billing_event;
817: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
818: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
819: , P_Data => X_Msg_Data );

Line 817: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

813: , P_Data => X_Msg_Data );
814:
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: ROLLBACK TO create_billing_event;
817: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
818: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
819: , P_Data => X_Msg_Data );
820:
821: WHEN OTHERS THEN

Line 823: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

819: , P_Data => X_Msg_Data );
820:
821: WHEN OTHERS THEN
822: ROLLBACK TO create_billing_event;
823: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
825: FND_MSG_PUB.add_exc_msg
826: ( p_pkg_name => G_Pkg_Name
827: , p_procedure_name => 'CREATE_BILLING_EVENT' );

Line 911: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

907: FROM dual;
908:
909: BEGIN
910:
911: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
912:
913: --
914: -- Standard Start of API savepoint
915: --

Line 1036: IF FND_API.To_Boolean( p_commit ) THEN

1032:
1033: --
1034: -- Standard commit check
1035: --
1036: IF FND_API.To_Boolean( p_commit ) THEN
1037: COMMIT WORK;
1038: END IF;
1039:
1040: --

Line 1052: WHEN FND_API.G_EXC_ERROR THEN

1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Billing event created ...');
1049: END IF;
1050:
1051: EXCEPTION
1052: WHEN FND_API.G_EXC_ERROR THEN
1053: ROLLBACK TO create_billing_event_pvt;
1054: X_Return_Status := FND_API.G_RET_STS_ERROR;
1055: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1056: , P_Data => X_Msg_Data );

Line 1054: X_Return_Status := FND_API.G_RET_STS_ERROR;

1050:
1051: EXCEPTION
1052: WHEN FND_API.G_EXC_ERROR THEN
1053: ROLLBACK TO create_billing_event_pvt;
1054: X_Return_Status := FND_API.G_RET_STS_ERROR;
1055: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1056: , P_Data => X_Msg_Data );
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1054: X_Return_Status := FND_API.G_RET_STS_ERROR;
1055: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1056: , P_Data => X_Msg_Data );
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059: ROLLBACK TO create_billing_event_pvt;
1060: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1062: , P_Data => X_Msg_Data );

Line 1060: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1056: , P_Data => X_Msg_Data );
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059: ROLLBACK TO create_billing_event_pvt;
1060: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1062: , P_Data => X_Msg_Data );
1063:
1064: WHEN OTHERS THEN

Line 1066: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1062: , P_Data => X_Msg_Data );
1063:
1064: WHEN OTHERS THEN
1065: ROLLBACK TO create_billing_event_pvt;
1066: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1068: FND_MSG_PUB.add_exc_msg
1069: ( p_pkg_name => G_Pkg_Name
1070: , p_procedure_name => 'CREATE_BILLING_EVENT' );

Line 1171: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

1167: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Updating Billing Event ...');
1169: END IF;
1170:
1171: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: --
1174: -- Standard Start of API savepoint
1175: --

Line 1211: RAISE FND_API.G_EXC_ERROR;

1207: --
1208: FND_MESSAGE.set_name('OKE' , 'OKE_BILL_EVENT_PROCESSED');
1209: FND_MESSAGE.set_token('EVENT' , L_Event_Num);
1210: FND_MSG_PUB.add;
1211: RAISE FND_API.G_EXC_ERROR;
1212:
1213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Reversing billed entry ...');
1215: END IF;

Line 1227: ( P_Commit => FND_API.G_FALSE

1223: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Creating revised entry ...');
1224: END IF;
1225:
1226: Create_Billing_Event
1227: ( P_Commit => FND_API.G_FALSE
1228: , P_Event_Type => P_Event_Type
1229: , P_Event_Date => P_Event_Date
1230: , P_Project_ID => P_Project_ID
1231: , P_Task_ID => P_Task_ID

Line 1293: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1289: , X_Msg_Count => X_Msg_Count
1290: , X_Msg_Data => X_Msg_Data
1291: );
1292:
1293: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1290: , X_Msg_Data => X_Msg_Data
1291: );
1292:
1293: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:

Line 1295: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN

1291: );
1292:
1293: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299: UPDATE oke_k_billing_events

Line 1296: RAISE FND_API.G_EXC_ERROR;

1292:
1293: IF ( X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299: UPDATE oke_k_billing_events
1300: SET pa_event_id = L_Event_ID

Line 1405: IF FND_API.To_Boolean( p_commit ) THEN

1401:
1402: --
1403: -- Standard commit check
1404: --
1405: IF FND_API.To_Boolean( p_commit ) THEN
1406: COMMIT WORK;
1407: END IF;
1408:
1409: --

Line 1417: WHEN FND_API.G_EXC_ERROR THEN

1413: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1414: , P_Data => X_Msg_Data );
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: ROLLBACK TO update_billing_event_pvt;
1419: X_Return_Status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1421: , p_data => x_msg_data );

Line 1419: X_Return_Status := FND_API.G_RET_STS_ERROR;

1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: ROLLBACK TO update_billing_event_pvt;
1419: X_Return_Status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1421: , p_data => x_msg_data );
1422:
1423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1419: X_Return_Status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1421: , p_data => x_msg_data );
1422:
1423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1424: ROLLBACK TO update_billing_event_pvt;
1425: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1427: , p_data => x_msg_data );

Line 1425: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1421: , p_data => x_msg_data );
1422:
1423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1424: ROLLBACK TO update_billing_event_pvt;
1425: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1427: , p_data => x_msg_data );
1428:
1429: WHEN OTHERS THEN

Line 1431: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1427: , p_data => x_msg_data );
1428:
1429: WHEN OTHERS THEN
1430: ROLLBACK TO update_billing_event_pvt;
1431: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1433: FND_MSG_PUB.add_exc_msg
1434: ( p_pkg_name => G_Pkg_Name
1435: , p_procedure_name => 'UPDATE_BILLING_EVENT' );

Line 1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1545: FND_MSG_PUB.add_exc_msg
1546: ( p_pkg_name => G_Pkg_Name
1547: , p_procedure_name => 'INSERT_BILLING_INFO' );
1548: END IF;
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550:
1551: END INSERT_BILLING_INFO;
1552:
1553:

Line 1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1621: FND_MSG_PUB.add_exc_msg
1622: ( p_pkg_name => G_Pkg_Name
1623: , p_procedure_name => 'UPDATE_BILLING_INFO' );
1624: END IF;
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1626: END Update_Billing_Info;
1627:
1628: PROCEDURE Delete_Billing_Info (
1629: P_Billing_Event_ID IN NUMBER

Line 1672: RAISE FND_API.G_EXC_ERROR;

1668: THEN
1669: FND_MESSAGE.set_name('OKE' , 'OKE_BILL_EVENT_PROCESSED');
1670: FND_MESSAGE.set_token('EVENT' , L_Event_Num);
1671: FND_MSG_PUB.add;
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSE
1674: PA_EVENTS_PKG.Delete_Row(X_Rowid => l_rowid);
1675: END IF;
1676: END IF;

Line 1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1685: FND_MSG_PUB.add_exc_msg
1686: ( p_pkg_name => G_Pkg_Name
1687: , p_procedure_name => 'DELETE_BILLING_INFO' );
1688: END IF;
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1690: END Delete_Billing_Info;
1691:
1692: PROCEDURE Lock_Billing_Info
1693: ( P_Deliverable_ID IN NUMBER

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

1915: , X_return_status => l_return_status
1916: , X_msg_count => l_msg_count
1917: , X_msg_data => l_msg_data);
1918:
1919: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922:
1923: x_Bill_Trans_Currency_Code := BillInfoRec.bill_currency_code;

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1916: , X_msg_count => l_msg_count
1917: , X_msg_data => l_msg_data);
1918:
1919: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922:
1923: x_Bill_Trans_Currency_Code := BillInfoRec.bill_currency_code;
1924: x_Bill_Trans_Bill_Amount := BillInfoRec.Bill_Amount;

Line 2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2003: END IF;
2004: x_Inv_Gen_Rejection_Code := NULL;
2005:
2006: EXCEPTION
2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2009: FND_MSG_PUB.add_exc_msg
2010: ( p_pkg_name => G_Pkg_Name
2011: , p_procedure_name => 'POPULATE_MC_COLUMNS' );