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.OE_HOLDS_PUB dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.ADD;

91: -- org_id is null, raise an error.
92: oe_debug_pub.add('Org_Id is NULL',1);
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
95: FND_MSG_PUB.ADD;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 598: IF FND_MSG_PUB.Check_Msg_Level

594: END IF;
595: x_return_status := FND_API.G_RET_STS_ERROR;
596: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: IF FND_MSG_PUB.Check_Msg_Level
599: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME

Line 599: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

595: x_return_status := FND_API.G_RET_STS_ERROR;
596: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: IF FND_MSG_PUB.Check_Msg_Level
599: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME
603: , l_api_name

Line 601: FND_MSG_PUB.Add_Exc_Msg

597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: IF FND_MSG_PUB.Check_Msg_Level
599: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME
603: , l_api_name
604: );
605: END IF;

Line 650: FND_MSG_PUB.ADD;

646: -- org_id is null, raise an error.
647: oe_debug_pub.add('Org_Id is NULL',1);
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: -- Initialize API return status to success

Line 674: FND_MSG_PUB.Count_And_Get

670: IF l_debug_level > 0 THEN
671: oe_debug_pub.add( 'APPLY HOLD EXPECTED ERROR' ) ;
672: END IF;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: FND_MSG_PUB.Count_And_Get
675: ( p_count => x_msg_count
676: , p_data => x_msg_data
677: );
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 681: FND_MSG_PUB.Count_And_Get

677: );
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO APPLY_HOLDS_PUB; --11803186
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count
683: , p_data => x_msg_data
684: );
685: WHEN OTHERS THEN

Line 688: IF FND_MSG_PUB.Check_Msg_Level

684: );
685: WHEN OTHERS THEN
686: ROLLBACK TO APPLY_HOLDS_PUB; --11803186
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: IF FND_MSG_PUB.Check_Msg_Level
689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: FND_MSG_PUB.Add_Exc_Msg
692: ( G_PKG_NAME

Line 689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

685: WHEN OTHERS THEN
686: ROLLBACK TO APPLY_HOLDS_PUB; --11803186
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: IF FND_MSG_PUB.Check_Msg_Level
689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: FND_MSG_PUB.Add_Exc_Msg
692: ( G_PKG_NAME
693: , l_api_name

Line 691: FND_MSG_PUB.Add_Exc_Msg

687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: IF FND_MSG_PUB.Check_Msg_Level
689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: FND_MSG_PUB.Add_Exc_Msg
692: ( G_PKG_NAME
693: , l_api_name
694: );
695: END IF;

Line 696: FND_MSG_PUB.Count_And_Get

692: ( G_PKG_NAME
693: , l_api_name
694: );
695: END IF;
696: FND_MSG_PUB.Count_And_Get
697: ( p_count => x_msg_count
698: , p_data => x_msg_data
699: );
700:

Line 734: FND_MSG_PUB.ADD;

730: -- org_id is null, raise an error.
731: oe_debug_pub.add('Org_Id is NULL',1);
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
734: FND_MSG_PUB.ADD;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737:
738: -- Initialize API return status to success

Line 761: FND_MSG_PUB.Count_And_Get

757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'APPLY HOLD EXPECTED ERROR' ) ;
759: END IF;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_And_Get
762: ( p_count => x_msg_count
763: , p_data => x_msg_data
764: );
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 767: FND_MSG_PUB.Count_And_Get

763: , p_data => x_msg_data
764: );
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MSG_PUB.Count_And_Get
768: ( p_count => x_msg_count
769: , p_data => x_msg_data
770: );
771: WHEN OTHERS THEN

Line 773: IF FND_MSG_PUB.Check_Msg_Level

769: , p_data => x_msg_data
770: );
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME

Line 774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

770: );
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , l_api_name

Line 776: FND_MSG_PUB.Add_Exc_Msg

772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , l_api_name
779: );
780: END IF;

Line 781: FND_MSG_PUB.Count_And_Get

777: ( G_PKG_NAME
778: , l_api_name
779: );
780: END IF;
781: FND_MSG_PUB.Count_And_Get
782: ( p_count => x_msg_count
783: , p_data => x_msg_data
784: );
785:

Line 820: FND_MSG_PUB.ADD;

816: -- org_id is null, raise an error.
817: oe_debug_pub.add('Org_Id is NULL',1);
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
824: -- Initialize API return status to success

Line 842: FND_MSG_PUB.Count_And_Get

838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( 'RELEASE HOLD EXPECTED ERROR' ) ;
840: END IF;
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: FND_MSG_PUB.Count_And_Get
843: ( p_count => x_msg_count
844: , p_data => x_msg_data
845: );
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 848: FND_MSG_PUB.Count_And_Get

844: , p_data => x_msg_data
845: );
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count
850: , p_data => x_msg_data
851: );
852: WHEN OTHERS THEN

Line 854: IF FND_MSG_PUB.Check_Msg_Level

850: , p_data => x_msg_data
851: );
852: WHEN OTHERS THEN
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: IF FND_MSG_PUB.Check_Msg_Level
855: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: FND_MSG_PUB.Add_Exc_Msg
858: ( G_PKG_NAME

Line 855: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

851: );
852: WHEN OTHERS THEN
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: IF FND_MSG_PUB.Check_Msg_Level
855: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: FND_MSG_PUB.Add_Exc_Msg
858: ( G_PKG_NAME
859: , l_api_name

Line 857: FND_MSG_PUB.Add_Exc_Msg

853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: IF FND_MSG_PUB.Check_Msg_Level
855: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: FND_MSG_PUB.Add_Exc_Msg
858: ( G_PKG_NAME
859: , l_api_name
860: );
861: END IF;

Line 862: FND_MSG_PUB.Count_And_Get

858: ( G_PKG_NAME
859: , l_api_name
860: );
861: END IF;
862: FND_MSG_PUB.Count_And_Get
863: ( p_count => x_msg_count
864: , p_data => x_msg_data
865: );
866:

Line 906: FND_MSG_PUB.ADD;

902: -- org_id is null, raise an error.
903: oe_debug_pub.add('Org_Id is NULL',1);
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
906: FND_MSG_PUB.ADD;
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: -- Initialize API return status to success

Line 949: FND_MSG_PUB.Count_And_Get

945: IF l_debug_level > 0 THEN
946: oe_debug_pub.add( 'RELEASE HOLD EXPECTED ERROR' ) ;
947: END IF;
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count
951: , p_data => x_msg_data
952: );
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 955: FND_MSG_PUB.Count_And_Get

951: , p_data => x_msg_data
952: );
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: FND_MSG_PUB.Count_And_Get
956: ( p_count => x_msg_count
957: , p_data => x_msg_data
958: );
959: WHEN OTHERS THEN

Line 961: IF FND_MSG_PUB.Check_Msg_Level

957: , p_data => x_msg_data
958: );
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: ( G_PKG_NAME

Line 962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

958: );
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: ( G_PKG_NAME
966: , l_api_name

Line 964: FND_MSG_PUB.Add_Exc_Msg

960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: ( G_PKG_NAME
966: , l_api_name
967: );
968: END IF;

Line 969: FND_MSG_PUB.Count_And_Get

965: ( G_PKG_NAME
966: , l_api_name
967: );
968: END IF;
969: FND_MSG_PUB.Count_And_Get
970: ( p_count => x_msg_count
971: , p_data => x_msg_data
972: );
973:

Line 1038: FND_MSG_PUB.ADD;

1034: -- org_id is null, raise an error.
1035: oe_debug_pub.add('Org_Id is NULL',1);
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
1038: FND_MSG_PUB.ADD;
1039: RAISE FND_API.G_EXC_ERROR;
1040: END IF;
1041:
1042: IF l_debug_level > 0 THEN

Line 1247: FND_MSG_PUB.Count_And_Get

1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add( 'FROM DUPLICATE HOLD EXPECTED ERROR' ) ;
1245: END IF;
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: FND_MSG_PUB.Count_And_Get
1248: ( p_count => x_msg_count
1249: , p_data => x_msg_data
1250: );
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1254: FND_MSG_PUB.Count_And_Get

1250: );
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252: ROLLBACK TO APPLY_HOLDS_PUB;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: FND_MSG_PUB.Count_And_Get
1255: ( p_count => x_msg_count
1256: , p_data => x_msg_data
1257: );
1258: WHEN OTHERS THEN

Line 1261: IF FND_MSG_PUB.Check_Msg_Level

1257: );
1258: WHEN OTHERS THEN
1259: ROLLBACK TO APPLY_HOLDS_PUB;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: IF FND_MSG_PUB.Check_Msg_Level
1262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1263: THEN
1264: FND_MSG_PUB.Add_Exc_Msg
1265: ( G_PKG_NAME

Line 1262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1258: WHEN OTHERS THEN
1259: ROLLBACK TO APPLY_HOLDS_PUB;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: IF FND_MSG_PUB.Check_Msg_Level
1262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1263: THEN
1264: FND_MSG_PUB.Add_Exc_Msg
1265: ( G_PKG_NAME
1266: , l_api_name

Line 1264: FND_MSG_PUB.Add_Exc_Msg

1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: IF FND_MSG_PUB.Check_Msg_Level
1262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1263: THEN
1264: FND_MSG_PUB.Add_Exc_Msg
1265: ( G_PKG_NAME
1266: , l_api_name
1267: );
1268: END IF;

Line 1269: FND_MSG_PUB.Count_And_Get

1265: ( G_PKG_NAME
1266: , l_api_name
1267: );
1268: END IF;
1269: FND_MSG_PUB.Count_And_Get
1270: ( p_count => x_msg_count
1271: , p_data => x_msg_data
1272: );
1273: END Apply_Holds;

Line 1387: FND_MSG_PUB.Count_And_Get

1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_return_status := FND_API.G_RET_STS_ERROR;
1386: x_result_out := FND_API.G_FALSE;
1387: FND_MSG_PUB.Count_And_Get
1388: ( p_count => x_msg_count
1389: , p_data => x_msg_data
1390: );
1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1394: FND_MSG_PUB.Count_And_Get

1390: );
1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1393: x_result_out := FND_API.G_FALSE;
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_count => x_msg_count
1396: , p_data => x_msg_data
1397: );
1398: WHEN OTHERS THEN

Line 1401: IF FND_MSG_PUB.Check_Msg_Level

1397: );
1398: WHEN OTHERS THEN
1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400: x_result_out := FND_API.G_FALSE;
1401: IF FND_MSG_PUB.Check_Msg_Level
1402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1403: THEN
1404: FND_MSG_PUB.Add_Exc_Msg
1405: ( G_PKG_NAME

Line 1402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1398: WHEN OTHERS THEN
1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400: x_result_out := FND_API.G_FALSE;
1401: IF FND_MSG_PUB.Check_Msg_Level
1402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1403: THEN
1404: FND_MSG_PUB.Add_Exc_Msg
1405: ( G_PKG_NAME
1406: , l_api_name

Line 1404: FND_MSG_PUB.Add_Exc_Msg

1400: x_result_out := FND_API.G_FALSE;
1401: IF FND_MSG_PUB.Check_Msg_Level
1402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1403: THEN
1404: FND_MSG_PUB.Add_Exc_Msg
1405: ( G_PKG_NAME
1406: , l_api_name
1407: );
1408: END IF;

Line 1409: FND_MSG_PUB.Count_And_Get

1405: ( G_PKG_NAME
1406: , l_api_name
1407: );
1408: END IF;
1409: FND_MSG_PUB.Count_And_Get
1410: ( p_count => x_msg_count
1411: , p_data => x_msg_data
1412: );
1413:

Line 1514: FND_MSG_PUB.Count_And_Get

1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: x_result_out := FND_API.G_FALSE;
1514: FND_MSG_PUB.Count_And_Get
1515: ( p_count => x_msg_count
1516: , p_data => x_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1521: FND_MSG_PUB.Count_And_Get

1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: x_result_out := FND_API.G_FALSE;
1521: FND_MSG_PUB.Count_And_Get
1522: ( p_count => x_msg_count
1523: , p_data => x_msg_data
1524: );
1525: WHEN OTHERS THEN

Line 1528: IF FND_MSG_PUB.Check_Msg_Level

1524: );
1525: WHEN OTHERS THEN
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: x_result_out := FND_API.G_FALSE;
1528: IF FND_MSG_PUB.Check_Msg_Level
1529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: THEN
1531: FND_MSG_PUB.Add_Exc_Msg
1532: ( G_PKG_NAME

Line 1529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1525: WHEN OTHERS THEN
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: x_result_out := FND_API.G_FALSE;
1528: IF FND_MSG_PUB.Check_Msg_Level
1529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: THEN
1531: FND_MSG_PUB.Add_Exc_Msg
1532: ( G_PKG_NAME
1533: , l_api_name

Line 1531: FND_MSG_PUB.Add_Exc_Msg

1527: x_result_out := FND_API.G_FALSE;
1528: IF FND_MSG_PUB.Check_Msg_Level
1529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: THEN
1531: FND_MSG_PUB.Add_Exc_Msg
1532: ( G_PKG_NAME
1533: , l_api_name
1534: );
1535: END IF;

Line 1536: FND_MSG_PUB.Count_And_Get

1532: ( G_PKG_NAME
1533: , l_api_name
1534: );
1535: END IF;
1536: FND_MSG_PUB.Count_And_Get
1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data
1539: );
1540:

Line 1640: FND_MSG_PUB.Count_And_Get

1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639: x_result_out := FND_API.G_FALSE;
1640: FND_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count
1642: , p_data => x_msg_data
1643: );
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1647: FND_MSG_PUB.Count_And_Get

1643: );
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1646: x_result_out := FND_API.G_FALSE;
1647: FND_MSG_PUB.Count_And_Get
1648: ( p_count => x_msg_count
1649: , p_data => x_msg_data
1650: );
1651: WHEN OTHERS THEN

Line 1654: IF FND_MSG_PUB.Check_Msg_Level

1650: );
1651: WHEN OTHERS THEN
1652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: x_result_out := FND_API.G_FALSE;
1654: IF FND_MSG_PUB.Check_Msg_Level
1655: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1656: THEN
1657: FND_MSG_PUB.Add_Exc_Msg
1658: ( G_PKG_NAME

Line 1655: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1651: WHEN OTHERS THEN
1652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: x_result_out := FND_API.G_FALSE;
1654: IF FND_MSG_PUB.Check_Msg_Level
1655: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1656: THEN
1657: FND_MSG_PUB.Add_Exc_Msg
1658: ( G_PKG_NAME
1659: , l_api_name

Line 1657: FND_MSG_PUB.Add_Exc_Msg

1653: x_result_out := FND_API.G_FALSE;
1654: IF FND_MSG_PUB.Check_Msg_Level
1655: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1656: THEN
1657: FND_MSG_PUB.Add_Exc_Msg
1658: ( G_PKG_NAME
1659: , l_api_name
1660: );
1661: END IF;

Line 1662: FND_MSG_PUB.Count_And_Get

1658: ( G_PKG_NAME
1659: , l_api_name
1660: );
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get
1663: ( p_count => x_msg_count
1664: , p_data => x_msg_data
1665: );
1666:

Line 1744: FND_MSG_PUB.Count_And_Get

1740: EXCEPTION
1741: WHEN FND_API.G_EXC_ERROR THEN
1742: x_return_status := FND_API.G_RET_STS_ERROR;
1743: x_hold_rec.x_result_out := FND_API.G_FALSE;
1744: FND_MSG_PUB.Count_And_Get
1745: ( p_count => x_msg_count
1746: , p_data => x_msg_data
1747: );
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1751: FND_MSG_PUB.Count_And_Get

1747: );
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: x_hold_rec.x_result_out := FND_API.G_FALSE;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data
1754: );
1755: WHEN OTHERS THEN

Line 1758: IF FND_MSG_PUB.Check_Msg_Level

1754: );
1755: WHEN OTHERS THEN
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: x_hold_rec.x_result_out := FND_API.G_FALSE;
1758: IF FND_MSG_PUB.Check_Msg_Level
1759: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1760: THEN
1761: FND_MSG_PUB.Add_Exc_Msg
1762: ( G_PKG_NAME

Line 1759: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1755: WHEN OTHERS THEN
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: x_hold_rec.x_result_out := FND_API.G_FALSE;
1758: IF FND_MSG_PUB.Check_Msg_Level
1759: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1760: THEN
1761: FND_MSG_PUB.Add_Exc_Msg
1762: ( G_PKG_NAME
1763: , l_api_name

Line 1761: FND_MSG_PUB.Add_Exc_Msg

1757: x_hold_rec.x_result_out := FND_API.G_FALSE;
1758: IF FND_MSG_PUB.Check_Msg_Level
1759: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1760: THEN
1761: FND_MSG_PUB.Add_Exc_Msg
1762: ( G_PKG_NAME
1763: , l_api_name
1764: );
1765: END IF;

Line 1766: FND_MSG_PUB.Count_And_Get

1762: ( G_PKG_NAME
1763: , l_api_name
1764: );
1765: END IF;
1766: FND_MSG_PUB.Count_And_Get
1767: ( p_count => x_msg_count
1768: , p_data => x_msg_data
1769: );
1770:

Line 2269: FND_MSG_PUB.Count_And_Get

2265: EXCEPTION
2266: WHEN FND_API.G_EXC_ERROR THEN
2267: x_return_status := FND_API.G_RET_STS_ERROR;
2268: x_result_out := FND_API.G_FALSE;
2269: FND_MSG_PUB.Count_And_Get
2270: ( p_count => x_msg_count
2271: , p_data => x_msg_data
2272: );
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2276: FND_MSG_PUB.Count_And_Get

2272: );
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: x_result_out := FND_API.G_FALSE;
2276: FND_MSG_PUB.Count_And_Get
2277: ( p_count => x_msg_count
2278: , p_data => x_msg_data
2279: );
2280: WHEN OTHERS THEN

Line 2283: IF FND_MSG_PUB.Check_Msg_Level

2279: );
2280: WHEN OTHERS THEN
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: x_result_out := FND_API.G_FALSE;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( G_PKG_NAME

Line 2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2280: WHEN OTHERS THEN
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: x_result_out := FND_API.G_FALSE;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( G_PKG_NAME
2288: , l_api_name

Line 2286: FND_MSG_PUB.Add_Exc_Msg

2282: x_result_out := FND_API.G_FALSE;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( G_PKG_NAME
2288: , l_api_name
2289: );
2290: END IF;

Line 2291: FND_MSG_PUB.Count_And_Get

2287: ( G_PKG_NAME
2288: , l_api_name
2289: );
2290: END IF;
2291: FND_MSG_PUB.Count_And_Get
2292: ( p_count => x_msg_count
2293: , p_data => x_msg_data
2294: );
2295:

Line 2403: FND_MSG_PUB.Count_And_Get

2399: EXCEPTION
2400: WHEN FND_API.G_EXC_ERROR THEN
2401: x_return_status := FND_API.G_RET_STS_ERROR;
2402: x_result_out := FND_API.G_FALSE;
2403: FND_MSG_PUB.Count_And_Get
2404: ( p_count => x_msg_count
2405: , p_data => x_msg_data
2406: );
2407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2410: FND_MSG_PUB.Count_And_Get

2406: );
2407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2409: x_result_out := FND_API.G_FALSE;
2410: FND_MSG_PUB.Count_And_Get
2411: ( p_count => x_msg_count
2412: , p_data => x_msg_data
2413: );
2414: WHEN OTHERS THEN

Line 2417: IF FND_MSG_PUB.Check_Msg_Level

2413: );
2414: WHEN OTHERS THEN
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: x_result_out := FND_API.G_FALSE;
2417: IF FND_MSG_PUB.Check_Msg_Level
2418: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2419: THEN
2420: FND_MSG_PUB.Add_Exc_Msg
2421: ( G_PKG_NAME

Line 2418: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2414: WHEN OTHERS THEN
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: x_result_out := FND_API.G_FALSE;
2417: IF FND_MSG_PUB.Check_Msg_Level
2418: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2419: THEN
2420: FND_MSG_PUB.Add_Exc_Msg
2421: ( G_PKG_NAME
2422: , l_api_name

Line 2420: FND_MSG_PUB.Add_Exc_Msg

2416: x_result_out := FND_API.G_FALSE;
2417: IF FND_MSG_PUB.Check_Msg_Level
2418: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2419: THEN
2420: FND_MSG_PUB.Add_Exc_Msg
2421: ( G_PKG_NAME
2422: , l_api_name
2423: );
2424: END IF;

Line 2425: FND_MSG_PUB.Count_And_Get

2421: ( G_PKG_NAME
2422: , l_api_name
2423: );
2424: END IF;
2425: FND_MSG_PUB.Count_And_Get
2426: ( p_count => x_msg_count
2427: , p_data => x_msg_data
2428: );
2429:

Line 2515: FND_MSG_PUB.ADD;

2511: -- org_id is null, raise an error.
2512: oe_debug_pub.add('Org_Id is NULL',1);
2513: x_return_status := FND_API.G_RET_STS_ERROR;
2514: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: -- Standard Start of API savepoint

Line 2661: FND_MSG_PUB.Count_And_Get

2657: EXCEPTION
2658: WHEN FND_API.G_EXC_ERROR THEN
2659: ROLLBACK TO RELEASE_HOLDS_PUB;
2660: x_return_status := FND_API.G_RET_STS_ERROR;
2661: FND_MSG_PUB.Count_And_Get
2662: ( p_count => x_msg_count
2663: , p_data => x_msg_data
2664: );
2665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2668: FND_MSG_PUB.Count_And_Get

2664: );
2665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2666: ROLLBACK TO RELEASE_HOLDS_PUB;
2667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2668: FND_MSG_PUB.Count_And_Get
2669: ( p_count => x_msg_count
2670: , p_data => x_msg_data
2671: );
2672: WHEN OTHERS THEN

Line 2675: IF FND_MSG_PUB.Check_Msg_Level

2671: );
2672: WHEN OTHERS THEN
2673: ROLLBACK TO RELEASE_HOLDS_PUB;
2674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2675: IF FND_MSG_PUB.Check_Msg_Level
2676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2677: THEN
2678: FND_MSG_PUB.Add_Exc_Msg
2679: ( G_PKG_NAME

Line 2676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2672: WHEN OTHERS THEN
2673: ROLLBACK TO RELEASE_HOLDS_PUB;
2674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2675: IF FND_MSG_PUB.Check_Msg_Level
2676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2677: THEN
2678: FND_MSG_PUB.Add_Exc_Msg
2679: ( G_PKG_NAME
2680: , l_api_name

Line 2678: FND_MSG_PUB.Add_Exc_Msg

2674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2675: IF FND_MSG_PUB.Check_Msg_Level
2676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2677: THEN
2678: FND_MSG_PUB.Add_Exc_Msg
2679: ( G_PKG_NAME
2680: , l_api_name
2681: );
2682: END IF;

Line 2683: FND_MSG_PUB.Count_And_Get

2679: ( G_PKG_NAME
2680: , l_api_name
2681: );
2682: END IF;
2683: FND_MSG_PUB.Count_And_Get
2684: ( p_count => x_msg_count
2685: , p_data => x_msg_data
2686: );
2687:

Line 2754: FND_MSG_PUB.ADD;

2750: -- org_id is null, raise an error.
2751: oe_debug_pub.add('Org_Id is NULL',1);
2752: x_return_status := FND_API.G_RET_STS_ERROR;
2753: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2754: FND_MSG_PUB.ADD;
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758: --SAVEPOINT DELETE_HOLDS_PUB;

Line 2920: FND_MSG_PUB.Count_And_Get

2916: CLOSE line_hold;
2917: END IF;
2918: --ROLLBACK TO DELETE_HOLDS_PUB;
2919: x_return_status := FND_API.G_RET_STS_ERROR;
2920: FND_MSG_PUB.Count_And_Get
2921: ( p_count => x_msg_count
2922: , p_data => x_msg_data
2923: );
2924: WHEN OTHERS THEN

Line 2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2932: CLOSE line_hold;
2933: END IF;
2934: --ROLLBACK TO DELETE_HOLDS_PUB;
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2937: THEN
2938: FND_MSG_PUB.Add_Exc_Msg
2939: ( G_PKG_NAME
2940: , l_api_name

Line 2938: FND_MSG_PUB.Add_Exc_Msg

2934: --ROLLBACK TO DELETE_HOLDS_PUB;
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2937: THEN
2938: FND_MSG_PUB.Add_Exc_Msg
2939: ( G_PKG_NAME
2940: , l_api_name
2941: );
2942: END IF;

Line 2943: FND_MSG_PUB.Count_And_Get

2939: ( G_PKG_NAME
2940: , l_api_name
2941: );
2942: END IF;
2943: FND_MSG_PUB.Count_And_Get
2944: ( p_count => x_msg_count
2945: , p_data => x_msg_data
2946: );
2947: END Delete_Holds;

Line 5871: FND_MSG_PUB.Count_And_Get

5867: IF l_debug_level > 0 THEN
5868: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5869: END IF;
5870:
5871: FND_MSG_PUB.Count_And_Get
5872: ( p_count => x_msg_count
5873: , p_data => x_msg_data
5874: );
5875:

Line 6067: FND_MSG_PUB.Count_And_Get

6063: END IF;
6064: x_return_status := l_return_status;
6065: x_msg_count := l_msg_count;
6066: x_msg_data := l_msg_data;
6067: FND_MSG_PUB.Count_And_Get
6068: ( p_count => l_msg_count
6069: , p_data => l_msg_data
6070: );
6071: IF l_debug_level > 0 THEN