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 528: IF FND_MSG_PUB.Check_Msg_Level

524: END IF;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: IF FND_MSG_PUB.Check_Msg_Level
529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg
532: ( G_PKG_NAME

Line 529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

525: x_return_status := FND_API.G_RET_STS_ERROR;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: IF FND_MSG_PUB.Check_Msg_Level
529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg
532: ( G_PKG_NAME
533: , l_api_name

Line 531: FND_MSG_PUB.Add_Exc_Msg

527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: IF FND_MSG_PUB.Check_Msg_Level
529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg
532: ( G_PKG_NAME
533: , l_api_name
534: );
535: END IF;

Line 576: FND_MSG_PUB.ADD;

572: -- org_id is null, raise an error.
573: oe_debug_pub.add('Org_Id is NULL',1);
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: -- Initialize API return status to success

Line 599: FND_MSG_PUB.Count_And_Get

595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add( 'APPLY HOLD EXPECTED ERROR' ) ;
597: END IF;
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: FND_MSG_PUB.Count_And_Get
600: ( p_count => x_msg_count
601: , p_data => x_msg_data
602: );
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 605: FND_MSG_PUB.Count_And_Get

601: , p_data => x_msg_data
602: );
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: FND_MSG_PUB.Count_And_Get
606: ( p_count => x_msg_count
607: , p_data => x_msg_data
608: );
609: WHEN OTHERS THEN

Line 611: IF FND_MSG_PUB.Check_Msg_Level

607: , p_data => x_msg_data
608: );
609: WHEN OTHERS THEN
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: IF FND_MSG_PUB.Check_Msg_Level
612: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg
615: ( G_PKG_NAME

Line 612: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

608: );
609: WHEN OTHERS THEN
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: IF FND_MSG_PUB.Check_Msg_Level
612: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg
615: ( G_PKG_NAME
616: , l_api_name

Line 614: FND_MSG_PUB.Add_Exc_Msg

610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: IF FND_MSG_PUB.Check_Msg_Level
612: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg
615: ( G_PKG_NAME
616: , l_api_name
617: );
618: END IF;

Line 619: FND_MSG_PUB.Count_And_Get

615: ( G_PKG_NAME
616: , l_api_name
617: );
618: END IF;
619: FND_MSG_PUB.Count_And_Get
620: ( p_count => x_msg_count
621: , p_data => x_msg_data
622: );
623:

Line 655: FND_MSG_PUB.ADD;

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

Line 681: FND_MSG_PUB.Count_And_Get

677: IF l_debug_level > 0 THEN
678: oe_debug_pub.add( 'APPLY HOLD EXPECTED ERROR' ) ;
679: END IF;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count
683: , p_data => x_msg_data
684: );
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 687: FND_MSG_PUB.Count_And_Get

683: , p_data => x_msg_data
684: );
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: FND_MSG_PUB.Count_And_Get
688: ( p_count => x_msg_count
689: , p_data => x_msg_data
690: );
691: WHEN OTHERS THEN

Line 693: IF FND_MSG_PUB.Check_Msg_Level

689: , p_data => x_msg_data
690: );
691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.Check_Msg_Level
694: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg
697: ( G_PKG_NAME

Line 694: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

690: );
691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.Check_Msg_Level
694: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg
697: ( G_PKG_NAME
698: , l_api_name

Line 696: FND_MSG_PUB.Add_Exc_Msg

692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.Check_Msg_Level
694: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg
697: ( G_PKG_NAME
698: , l_api_name
699: );
700: END IF;

Line 701: FND_MSG_PUB.Count_And_Get

697: ( G_PKG_NAME
698: , l_api_name
699: );
700: END IF;
701: FND_MSG_PUB.Count_And_Get
702: ( p_count => x_msg_count
703: , p_data => x_msg_data
704: );
705:

Line 738: FND_MSG_PUB.ADD;

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

Line 759: FND_MSG_PUB.Count_And_Get

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

Line 765: FND_MSG_PUB.Count_And_Get

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

Line 771: IF FND_MSG_PUB.Check_Msg_Level

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

Line 772: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 774: FND_MSG_PUB.Add_Exc_Msg

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

Line 779: FND_MSG_PUB.Count_And_Get

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

Line 821: FND_MSG_PUB.ADD;

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

Line 863: FND_MSG_PUB.Count_And_Get

859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'RELEASE HOLD EXPECTED ERROR' ) ;
861: END IF;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: FND_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count
865: , p_data => x_msg_data
866: );
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 869: FND_MSG_PUB.Count_And_Get

865: , p_data => x_msg_data
866: );
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: FND_MSG_PUB.Count_And_Get
870: ( p_count => x_msg_count
871: , p_data => x_msg_data
872: );
873: WHEN OTHERS THEN

Line 875: IF FND_MSG_PUB.Check_Msg_Level

871: , p_data => x_msg_data
872: );
873: WHEN OTHERS THEN
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF FND_MSG_PUB.Check_Msg_Level
876: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg
879: ( G_PKG_NAME

Line 876: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

872: );
873: WHEN OTHERS THEN
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF FND_MSG_PUB.Check_Msg_Level
876: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg
879: ( G_PKG_NAME
880: , l_api_name

Line 878: FND_MSG_PUB.Add_Exc_Msg

874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF FND_MSG_PUB.Check_Msg_Level
876: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg
879: ( G_PKG_NAME
880: , l_api_name
881: );
882: END IF;

Line 883: FND_MSG_PUB.Count_And_Get

879: ( G_PKG_NAME
880: , l_api_name
881: );
882: END IF;
883: FND_MSG_PUB.Count_And_Get
884: ( p_count => x_msg_count
885: , p_data => x_msg_data
886: );
887:

Line 950: FND_MSG_PUB.ADD;

946: -- org_id is null, raise an error.
947: oe_debug_pub.add('Org_Id is NULL',1);
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
950: FND_MSG_PUB.ADD;
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:
954: IF l_debug_level > 0 THEN

Line 1158: FND_MSG_PUB.Count_And_Get

1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'FROM DUPLICATE HOLD EXPECTED ERROR' ) ;
1156: END IF;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MSG_PUB.Count_And_Get
1159: ( p_count => x_msg_count
1160: , p_data => x_msg_data
1161: );
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1165: FND_MSG_PUB.Count_And_Get

1161: );
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163: ROLLBACK TO APPLY_HOLDS_PUB;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_count => x_msg_count
1167: , p_data => x_msg_data
1168: );
1169: WHEN OTHERS THEN

Line 1172: IF FND_MSG_PUB.Check_Msg_Level

1168: );
1169: WHEN OTHERS THEN
1170: ROLLBACK TO APPLY_HOLDS_PUB;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: ( G_PKG_NAME

Line 1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1169: WHEN OTHERS THEN
1170: ROLLBACK TO APPLY_HOLDS_PUB;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: ( G_PKG_NAME
1177: , l_api_name

Line 1175: FND_MSG_PUB.Add_Exc_Msg

1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: ( G_PKG_NAME
1177: , l_api_name
1178: );
1179: END IF;

Line 1180: FND_MSG_PUB.Count_And_Get

1176: ( G_PKG_NAME
1177: , l_api_name
1178: );
1179: END IF;
1180: FND_MSG_PUB.Count_And_Get
1181: ( p_count => x_msg_count
1182: , p_data => x_msg_data
1183: );
1184: END Apply_Holds;

Line 1298: FND_MSG_PUB.Count_And_Get

1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: x_result_out := FND_API.G_FALSE;
1298: FND_MSG_PUB.Count_And_Get
1299: ( p_count => x_msg_count
1300: , p_data => x_msg_data
1301: );
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1305: FND_MSG_PUB.Count_And_Get

1301: );
1302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304: x_result_out := FND_API.G_FALSE;
1305: FND_MSG_PUB.Count_And_Get
1306: ( p_count => x_msg_count
1307: , p_data => x_msg_data
1308: );
1309: WHEN OTHERS THEN

Line 1312: IF FND_MSG_PUB.Check_Msg_Level

1308: );
1309: WHEN OTHERS THEN
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: x_result_out := FND_API.G_FALSE;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1314: THEN
1315: FND_MSG_PUB.Add_Exc_Msg
1316: ( G_PKG_NAME

Line 1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1309: WHEN OTHERS THEN
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: x_result_out := FND_API.G_FALSE;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1314: THEN
1315: FND_MSG_PUB.Add_Exc_Msg
1316: ( G_PKG_NAME
1317: , l_api_name

Line 1315: FND_MSG_PUB.Add_Exc_Msg

1311: x_result_out := FND_API.G_FALSE;
1312: IF FND_MSG_PUB.Check_Msg_Level
1313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1314: THEN
1315: FND_MSG_PUB.Add_Exc_Msg
1316: ( G_PKG_NAME
1317: , l_api_name
1318: );
1319: END IF;

Line 1320: FND_MSG_PUB.Count_And_Get

1316: ( G_PKG_NAME
1317: , l_api_name
1318: );
1319: END IF;
1320: FND_MSG_PUB.Count_And_Get
1321: ( p_count => x_msg_count
1322: , p_data => x_msg_data
1323: );
1324:

Line 1425: FND_MSG_PUB.Count_And_Get

1421: EXCEPTION
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: x_result_out := FND_API.G_FALSE;
1425: FND_MSG_PUB.Count_And_Get
1426: ( p_count => x_msg_count
1427: , p_data => x_msg_data
1428: );
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1432: FND_MSG_PUB.Count_And_Get

1428: );
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431: x_result_out := FND_API.G_FALSE;
1432: FND_MSG_PUB.Count_And_Get
1433: ( p_count => x_msg_count
1434: , p_data => x_msg_data
1435: );
1436: WHEN OTHERS THEN

Line 1439: IF FND_MSG_PUB.Check_Msg_Level

1435: );
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: x_result_out := FND_API.G_FALSE;
1439: IF FND_MSG_PUB.Check_Msg_Level
1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME

Line 1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: x_result_out := FND_API.G_FALSE;
1439: IF FND_MSG_PUB.Check_Msg_Level
1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1444: , l_api_name

Line 1442: FND_MSG_PUB.Add_Exc_Msg

1438: x_result_out := FND_API.G_FALSE;
1439: IF FND_MSG_PUB.Check_Msg_Level
1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1444: , l_api_name
1445: );
1446: END IF;

Line 1447: FND_MSG_PUB.Count_And_Get

1443: ( G_PKG_NAME
1444: , l_api_name
1445: );
1446: END IF;
1447: FND_MSG_PUB.Count_And_Get
1448: ( p_count => x_msg_count
1449: , p_data => x_msg_data
1450: );
1451:

Line 1551: FND_MSG_PUB.Count_And_Get

1547: EXCEPTION
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: x_result_out := FND_API.G_FALSE;
1551: FND_MSG_PUB.Count_And_Get
1552: ( p_count => x_msg_count
1553: , p_data => x_msg_data
1554: );
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1558: FND_MSG_PUB.Count_And_Get

1554: );
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: x_result_out := FND_API.G_FALSE;
1558: FND_MSG_PUB.Count_And_Get
1559: ( p_count => x_msg_count
1560: , p_data => x_msg_data
1561: );
1562: WHEN OTHERS THEN

Line 1565: IF FND_MSG_PUB.Check_Msg_Level

1561: );
1562: WHEN OTHERS THEN
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: x_result_out := FND_API.G_FALSE;
1565: IF FND_MSG_PUB.Check_Msg_Level
1566: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg
1569: ( G_PKG_NAME

Line 1566: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1562: WHEN OTHERS THEN
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: x_result_out := FND_API.G_FALSE;
1565: IF FND_MSG_PUB.Check_Msg_Level
1566: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg
1569: ( G_PKG_NAME
1570: , l_api_name

Line 1568: FND_MSG_PUB.Add_Exc_Msg

1564: x_result_out := FND_API.G_FALSE;
1565: IF FND_MSG_PUB.Check_Msg_Level
1566: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg
1569: ( G_PKG_NAME
1570: , l_api_name
1571: );
1572: END IF;

Line 1573: FND_MSG_PUB.Count_And_Get

1569: ( G_PKG_NAME
1570: , l_api_name
1571: );
1572: END IF;
1573: FND_MSG_PUB.Count_And_Get
1574: ( p_count => x_msg_count
1575: , p_data => x_msg_data
1576: );
1577:

Line 1655: FND_MSG_PUB.Count_And_Get

1651: EXCEPTION
1652: WHEN FND_API.G_EXC_ERROR THEN
1653: x_return_status := FND_API.G_RET_STS_ERROR;
1654: x_hold_rec.x_result_out := FND_API.G_FALSE;
1655: FND_MSG_PUB.Count_And_Get
1656: ( p_count => x_msg_count
1657: , p_data => x_msg_data
1658: );
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1662: FND_MSG_PUB.Count_And_Get

1658: );
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: x_hold_rec.x_result_out := FND_API.G_FALSE;
1662: FND_MSG_PUB.Count_And_Get
1663: ( p_count => x_msg_count
1664: , p_data => x_msg_data
1665: );
1666: WHEN OTHERS THEN

Line 1669: IF FND_MSG_PUB.Check_Msg_Level

1665: );
1666: WHEN OTHERS THEN
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1668: x_hold_rec.x_result_out := FND_API.G_FALSE;
1669: IF FND_MSG_PUB.Check_Msg_Level
1670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1671: THEN
1672: FND_MSG_PUB.Add_Exc_Msg
1673: ( G_PKG_NAME

Line 1670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1666: WHEN OTHERS THEN
1667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1668: x_hold_rec.x_result_out := FND_API.G_FALSE;
1669: IF FND_MSG_PUB.Check_Msg_Level
1670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1671: THEN
1672: FND_MSG_PUB.Add_Exc_Msg
1673: ( G_PKG_NAME
1674: , l_api_name

Line 1672: FND_MSG_PUB.Add_Exc_Msg

1668: x_hold_rec.x_result_out := FND_API.G_FALSE;
1669: IF FND_MSG_PUB.Check_Msg_Level
1670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1671: THEN
1672: FND_MSG_PUB.Add_Exc_Msg
1673: ( G_PKG_NAME
1674: , l_api_name
1675: );
1676: END IF;

Line 1677: FND_MSG_PUB.Count_And_Get

1673: ( G_PKG_NAME
1674: , l_api_name
1675: );
1676: END IF;
1677: FND_MSG_PUB.Count_And_Get
1678: ( p_count => x_msg_count
1679: , p_data => x_msg_data
1680: );
1681:

Line 2180: FND_MSG_PUB.Count_And_Get

2176: EXCEPTION
2177: WHEN FND_API.G_EXC_ERROR THEN
2178: x_return_status := FND_API.G_RET_STS_ERROR;
2179: x_result_out := FND_API.G_FALSE;
2180: FND_MSG_PUB.Count_And_Get
2181: ( p_count => x_msg_count
2182: , p_data => x_msg_data
2183: );
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2187: FND_MSG_PUB.Count_And_Get

2183: );
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2186: x_result_out := FND_API.G_FALSE;
2187: FND_MSG_PUB.Count_And_Get
2188: ( p_count => x_msg_count
2189: , p_data => x_msg_data
2190: );
2191: WHEN OTHERS THEN

Line 2194: IF FND_MSG_PUB.Check_Msg_Level

2190: );
2191: WHEN OTHERS THEN
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: x_result_out := FND_API.G_FALSE;
2194: IF FND_MSG_PUB.Check_Msg_Level
2195: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2196: THEN
2197: FND_MSG_PUB.Add_Exc_Msg
2198: ( G_PKG_NAME

Line 2195: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2191: WHEN OTHERS THEN
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: x_result_out := FND_API.G_FALSE;
2194: IF FND_MSG_PUB.Check_Msg_Level
2195: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2196: THEN
2197: FND_MSG_PUB.Add_Exc_Msg
2198: ( G_PKG_NAME
2199: , l_api_name

Line 2197: FND_MSG_PUB.Add_Exc_Msg

2193: x_result_out := FND_API.G_FALSE;
2194: IF FND_MSG_PUB.Check_Msg_Level
2195: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2196: THEN
2197: FND_MSG_PUB.Add_Exc_Msg
2198: ( G_PKG_NAME
2199: , l_api_name
2200: );
2201: END IF;

Line 2202: FND_MSG_PUB.Count_And_Get

2198: ( G_PKG_NAME
2199: , l_api_name
2200: );
2201: END IF;
2202: FND_MSG_PUB.Count_And_Get
2203: ( p_count => x_msg_count
2204: , p_data => x_msg_data
2205: );
2206:

Line 2314: FND_MSG_PUB.Count_And_Get

2310: EXCEPTION
2311: WHEN FND_API.G_EXC_ERROR THEN
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: x_result_out := FND_API.G_FALSE;
2314: FND_MSG_PUB.Count_And_Get
2315: ( p_count => x_msg_count
2316: , p_data => x_msg_data
2317: );
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2321: FND_MSG_PUB.Count_And_Get

2317: );
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2320: x_result_out := FND_API.G_FALSE;
2321: FND_MSG_PUB.Count_And_Get
2322: ( p_count => x_msg_count
2323: , p_data => x_msg_data
2324: );
2325: WHEN OTHERS THEN

Line 2328: IF FND_MSG_PUB.Check_Msg_Level

2324: );
2325: WHEN OTHERS THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: x_result_out := FND_API.G_FALSE;
2328: IF FND_MSG_PUB.Check_Msg_Level
2329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2330: THEN
2331: FND_MSG_PUB.Add_Exc_Msg
2332: ( G_PKG_NAME

Line 2329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2325: WHEN OTHERS THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: x_result_out := FND_API.G_FALSE;
2328: IF FND_MSG_PUB.Check_Msg_Level
2329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2330: THEN
2331: FND_MSG_PUB.Add_Exc_Msg
2332: ( G_PKG_NAME
2333: , l_api_name

Line 2331: FND_MSG_PUB.Add_Exc_Msg

2327: x_result_out := FND_API.G_FALSE;
2328: IF FND_MSG_PUB.Check_Msg_Level
2329: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2330: THEN
2331: FND_MSG_PUB.Add_Exc_Msg
2332: ( G_PKG_NAME
2333: , l_api_name
2334: );
2335: END IF;

Line 2336: FND_MSG_PUB.Count_And_Get

2332: ( G_PKG_NAME
2333: , l_api_name
2334: );
2335: END IF;
2336: FND_MSG_PUB.Count_And_Get
2337: ( p_count => x_msg_count
2338: , p_data => x_msg_data
2339: );
2340:

Line 2424: FND_MSG_PUB.ADD;

2420: -- org_id is null, raise an error.
2421: oe_debug_pub.add('Org_Id is NULL',1);
2422: x_return_status := FND_API.G_RET_STS_ERROR;
2423: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2424: FND_MSG_PUB.ADD;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427:
2428: -- Standard Start of API savepoint

Line 2569: FND_MSG_PUB.Count_And_Get

2565: EXCEPTION
2566: WHEN FND_API.G_EXC_ERROR THEN
2567: ROLLBACK TO RELEASE_HOLDS_PUB;
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: FND_MSG_PUB.Count_And_Get
2570: ( p_count => x_msg_count
2571: , p_data => x_msg_data
2572: );
2573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2576: FND_MSG_PUB.Count_And_Get

2572: );
2573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2574: ROLLBACK TO RELEASE_HOLDS_PUB;
2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2576: FND_MSG_PUB.Count_And_Get
2577: ( p_count => x_msg_count
2578: , p_data => x_msg_data
2579: );
2580: WHEN OTHERS THEN

Line 2583: IF FND_MSG_PUB.Check_Msg_Level

2579: );
2580: WHEN OTHERS THEN
2581: ROLLBACK TO RELEASE_HOLDS_PUB;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level
2584: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2585: THEN
2586: FND_MSG_PUB.Add_Exc_Msg
2587: ( G_PKG_NAME

Line 2584: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2580: WHEN OTHERS THEN
2581: ROLLBACK TO RELEASE_HOLDS_PUB;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level
2584: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2585: THEN
2586: FND_MSG_PUB.Add_Exc_Msg
2587: ( G_PKG_NAME
2588: , l_api_name

Line 2586: FND_MSG_PUB.Add_Exc_Msg

2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level
2584: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2585: THEN
2586: FND_MSG_PUB.Add_Exc_Msg
2587: ( G_PKG_NAME
2588: , l_api_name
2589: );
2590: END IF;

Line 2591: FND_MSG_PUB.Count_And_Get

2587: ( G_PKG_NAME
2588: , l_api_name
2589: );
2590: END IF;
2591: FND_MSG_PUB.Count_And_Get
2592: ( p_count => x_msg_count
2593: , p_data => x_msg_data
2594: );
2595:

Line 2662: FND_MSG_PUB.ADD;

2658: -- org_id is null, raise an error.
2659: oe_debug_pub.add('Org_Id is NULL',1);
2660: x_return_status := FND_API.G_RET_STS_ERROR;
2661: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2662: FND_MSG_PUB.ADD;
2663: RAISE FND_API.G_EXC_ERROR;
2664: END IF;
2665:
2666: --SAVEPOINT DELETE_HOLDS_PUB;

Line 2828: FND_MSG_PUB.Count_And_Get

2824: CLOSE line_hold;
2825: END IF;
2826: --ROLLBACK TO DELETE_HOLDS_PUB;
2827: x_return_status := FND_API.G_RET_STS_ERROR;
2828: FND_MSG_PUB.Count_And_Get
2829: ( p_count => x_msg_count
2830: , p_data => x_msg_data
2831: );
2832: WHEN OTHERS THEN

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

2840: CLOSE line_hold;
2841: END IF;
2842: --ROLLBACK TO DELETE_HOLDS_PUB;
2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2844: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: FND_MSG_PUB.Add_Exc_Msg
2847: ( G_PKG_NAME
2848: , l_api_name

Line 2846: FND_MSG_PUB.Add_Exc_Msg

2842: --ROLLBACK TO DELETE_HOLDS_PUB;
2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2844: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: FND_MSG_PUB.Add_Exc_Msg
2847: ( G_PKG_NAME
2848: , l_api_name
2849: );
2850: END IF;

Line 2851: FND_MSG_PUB.Count_And_Get

2847: ( G_PKG_NAME
2848: , l_api_name
2849: );
2850: END IF;
2851: FND_MSG_PUB.Count_And_Get
2852: ( p_count => x_msg_count
2853: , p_data => x_msg_data
2854: );
2855: END Delete_Holds;

Line 5324: FND_MSG_PUB.Count_And_Get

5320: IF l_debug_level > 0 THEN
5321: oe_debug_pub.add( 'API G_EXC_UNEXPECTED_ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5322: END IF;
5323:
5324: FND_MSG_PUB.Count_And_Get
5325: ( p_count => x_msg_count
5326: , p_data => x_msg_data
5327: );
5328:

Line 5512: FND_MSG_PUB.Count_And_Get

5508: END IF;
5509: x_return_status := l_return_status;
5510: x_msg_count := l_msg_count;
5511: x_msg_data := l_msg_data;
5512: FND_MSG_PUB.Count_And_Get
5513: ( p_count => l_msg_count
5514: , p_data => l_msg_data
5515: );
5516: IF l_debug_level > 0 THEN