DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_BILLING_PVT dependencies on FND_MSG_PUB

Line 485: FND_MSG_PUB.add;

481: IF ( Event_Level( BillInfoRec.Bill_Project_ID
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

Line 496: FND_MSG_PUB.add;

492:
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

Line 507: FND_MSG_PUB.add;

503:
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

Line 518: FND_MSG_PUB.add;

514:
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

Line 529: FND_MSG_PUB.add;

525:
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

Line 539: FND_MSG_PUB.add;

535: END IF;
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

Line 550: FND_MSG_PUB.add;

546:
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

Line 805: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

801: --
802: -- Standard call to get message count and if count is 1, get message
803: -- info
804: --
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

Line 812: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

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
816: ROLLBACK TO create_billing_event;

Line 818: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

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
822: ROLLBACK TO create_billing_event;

Line 824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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' );
828: END IF;

Line 825: FND_MSG_PUB.add_exc_msg

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' );
828: END IF;
829: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

Line 829: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

825: FND_MSG_PUB.add_exc_msg
826: ( p_pkg_name => G_Pkg_Name
827: , p_procedure_name => 'CREATE_BILLING_EVENT' );
828: END IF;
829: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
830: , P_Data => X_Msg_Data );
831: END Create_Billing_Event;
832:
833:

Line 1044: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

1040: --
1041: -- Standard call to get message count and if count is 1, get message
1042: -- info
1043: --
1044: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1045: , P_Data => X_Msg_Data );
1046:
1047: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Billing event created ...');

Line 1055: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

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
1059: ROLLBACK TO create_billing_event_pvt;

Line 1061: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

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
1065: ROLLBACK TO create_billing_event_pvt;

Line 1067: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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' );
1071: END IF;

Line 1068: FND_MSG_PUB.add_exc_msg

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' );
1071: END IF;
1072: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

Line 1072: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

1068: FND_MSG_PUB.add_exc_msg
1069: ( p_pkg_name => G_Pkg_Name
1070: , p_procedure_name => 'CREATE_BILLING_EVENT' );
1071: END IF;
1072: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count
1073: , P_Data => X_Msg_Data );
1074: END Create_Billing_Event;
1075:
1076:

Line 1210: FND_MSG_PUB.add;

1206: -- The credit memo event will cause draft invoice creation to fail.
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 ...');

Line 1413: FND_MSG_PUB.Count_And_Get( P_Count => X_Msg_Count

1409: --
1410: -- Standard call to get message count and if count is 1, get message
1411: -- info
1412: --
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

Line 1420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
1424: ROLLBACK TO update_billing_event_pvt;

Line 1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
1430: ROLLBACK TO update_billing_event_pvt;

Line 1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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' );
1436: END IF;

Line 1433: FND_MSG_PUB.add_exc_msg

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' );
1436: END IF;
1437: END Update_Billing_Event;

Line 1544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1540: , 'N');
1541:
1542: EXCEPTION
1543: WHEN OTHERS THEN
1544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1545: FND_MSG_PUB.add_exc_msg
1546: ( p_pkg_name => G_Pkg_Name
1547: , p_procedure_name => 'INSERT_BILLING_INFO' );
1548: END IF;

Line 1545: FND_MSG_PUB.add_exc_msg

1541:
1542: EXCEPTION
1543: WHEN OTHERS THEN
1544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
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;

Line 1620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1616: WHERE billing_event_id = P_Billing_Event_ID;
1617:
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1621: FND_MSG_PUB.add_exc_msg
1622: ( p_pkg_name => G_Pkg_Name
1623: , p_procedure_name => 'UPDATE_BILLING_INFO' );
1624: END IF;

Line 1621: FND_MSG_PUB.add_exc_msg

1617:
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
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;

Line 1671: FND_MSG_PUB.add;

1667: , L_Bill_Amount ) = 'Y')
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;

Line 1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1680: WHERE ROWID = L_oke_RowID;
1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1685: FND_MSG_PUB.add_exc_msg
1686: ( p_pkg_name => G_Pkg_Name
1687: , p_procedure_name => 'DELETE_BILLING_INFO' );
1688: END IF;

Line 1685: FND_MSG_PUB.add_exc_msg

1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
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;

Line 2002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1998: x_Inv_Gen_Rejection_Code := NULL;
1999:
2000: EXCEPTION
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2003: FND_MSG_PUB.add_exc_msg
2004: ( p_pkg_name => G_Pkg_Name
2005: , p_procedure_name => 'POPULATE_MC_COLUMNS' );
2006: END IF;

Line 2003: FND_MSG_PUB.add_exc_msg

1999:
2000: EXCEPTION
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2003: FND_MSG_PUB.add_exc_msg
2004: ( p_pkg_name => G_Pkg_Name
2005: , p_procedure_name => 'POPULATE_MC_COLUMNS' );
2006: END IF;
2007:

Line 2009: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2005: , p_procedure_name => 'POPULATE_MC_COLUMNS' );
2006: END IF;
2007:
2008: WHEN OTHERS THEN
2009: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2010: FND_MSG_PUB.add_exc_msg
2011: ( p_pkg_name => G_Pkg_Name
2012: , p_procedure_name => 'POPULATE_MC_COLUMNS' );
2013: END IF;

Line 2010: FND_MSG_PUB.add_exc_msg

2006: END IF;
2007:
2008: WHEN OTHERS THEN
2009: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2010: FND_MSG_PUB.add_exc_msg
2011: ( p_pkg_name => G_Pkg_Name
2012: , p_procedure_name => 'POPULATE_MC_COLUMNS' );
2013: END IF;
2014: