DBA Data[Home] [Help]

APPS.PO_ACKNOWLEDGE_PO_PVT dependencies on FND_API

Line 70: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

66:
67:
68: BEGIN
69:
70: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 74: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

70: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
75: l_api_name, g_pkg_name)
76: THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73:
74: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
75: l_api_name, g_pkg_name)
76: THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: If (p_po_release_id is not null) then
81: OPEN l_rel_ship_not_acked_csr;

Line 105: return FND_API.G_FALSE;

101:
102: END IF;
103:
104: If (L_ship_not_acked_flag = 'Y') THEN
105: return FND_API.G_FALSE;
106: ELSE
107: return FND_API.G_TRUE;
108: END IF;
109:

Line 107: return FND_API.G_TRUE;

103:
104: If (L_ship_not_acked_flag = 'Y') THEN
105: return FND_API.G_FALSE;
106: ELSE
107: return FND_API.G_TRUE;
108: END IF;
109:
110: EXCEPTION
111: WHEN OTHERS THEN

Line 243: FND_API.G_FALSE,

239:
240: /* If all shipments were either changed or acknowledged. */
241: IF (PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Responded (
242: 1.0,
243: FND_API.G_FALSE,
244: null,
245: p_po_release_id,
246: l_arch_revision_num ) = FND_API.G_TRUE AND
247: l_change_requested_by = 'SUPPLIER' ) THEN

Line 246: l_arch_revision_num ) = FND_API.G_TRUE AND

242: 1.0,
243: FND_API.G_FALSE,
244: null,
245: p_po_release_id,
246: l_arch_revision_num ) = FND_API.G_TRUE AND
247: l_change_requested_by = 'SUPPLIER' ) THEN
248: return 'SUPPLIER_CHANGE_PENDING';
249:
250: /* return partially acknowledged when changes are made to shipments */

Line 374: FND_API.G_FALSE,

370:
371: /* If all shipments were either changed or acknowledged. */
372: ELSIF (PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Responded (
373: 1.0,
374: FND_API.G_FALSE,
375: p_po_header_id,
376: null,
377: l_arch_revision_num) = FND_API.G_TRUE AND
378: l_change_requested_by = 'SUPPLIER' ) THEN

Line 377: l_arch_revision_num) = FND_API.G_TRUE AND

373: 1.0,
374: FND_API.G_FALSE,
375: p_po_header_id,
376: null,
377: l_arch_revision_num) = FND_API.G_TRUE AND
378: l_change_requested_by = 'SUPPLIER' ) THEN
379: return 'SUPPLIER_CHANGE_PENDING';
380:
381: /* return partially acknowledged when changes are made to shipments */

Line 607: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

603: and initiator = 'SUPPLIER';
604:
605: BEGIN
606:
607: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 611: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

607: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
612: l_api_name, g_pkg_name)
613: THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610:
611: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
612: l_api_name, g_pkg_name)
613: THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
618: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||

Line 809: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

805:
806:
807: BEGIN
808:
809: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812:
813: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 813: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

809: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812:
813: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
814: l_api_name, g_pkg_name) THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

811: END IF;
812:
813: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
814: l_api_name, g_pkg_name) THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||

Line 1053: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1049:
1050:
1051: BEGIN
1052:
1053: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 1057: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1053: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1058: l_api_name, g_pkg_name)
1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1056:
1057: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1058: l_api_name, g_pkg_name)
1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: x_return_status := FND_API.G_RET_STS_SUCCESS;
1064:

Line 1063: x_return_status := FND_API.G_RET_STS_SUCCESS;

1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: x_return_status := FND_API.G_RET_STS_SUCCESS;
1064:
1065: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1066: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||
1067: l_api_name || '.invoked', 'Line_location_id: ' ||

Line 1117: WHEN FND_API.g_exc_error THEN

1113: END IF;
1114:
1115:
1116: EXCEPTION
1117: WHEN FND_API.g_exc_error THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: WHEN FND_API.g_exc_unexpected_error THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error;
1121: WHEN OTHERS THEN

Line 1118: x_return_status := FND_API.g_ret_sts_error;

1114:
1115:
1116: EXCEPTION
1117: WHEN FND_API.g_exc_error THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: WHEN FND_API.g_exc_unexpected_error THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error;
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1119: WHEN FND_API.g_exc_unexpected_error THEN

1115:
1116: EXCEPTION
1117: WHEN FND_API.g_exc_error THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: WHEN FND_API.g_exc_unexpected_error THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error;
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1120: x_return_status := FND_API.g_ret_sts_unexp_error;

1116: EXCEPTION
1117: WHEN FND_API.g_exc_error THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: WHEN FND_API.g_exc_unexpected_error THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error;
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1124: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1122: x_return_status := FND_API.g_ret_sts_unexp_error;

1118: x_return_status := FND_API.g_ret_sts_error;
1119: WHEN FND_API.g_exc_unexpected_error THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error;
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1124: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1125: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1126: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 1143: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

1139: * Effects: Carry over the shipment_level acknowledgement results from the
1140: * previous revision, it is called before launching PO approval
1141: * workflow after supplier's change has been accepted by buyer.
1142: * Returns:
1143: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1144: * FND_API.G_RET_STS_ERROR if an error occurs
1145: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1146: */
1147: PROCEDURE Carry_Over_Acknowledgement (

Line 1144: * FND_API.G_RET_STS_ERROR if an error occurs

1140: * previous revision, it is called before launching PO approval
1141: * workflow after supplier's change has been accepted by buyer.
1142: * Returns:
1143: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1144: * FND_API.G_RET_STS_ERROR if an error occurs
1145: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1146: */
1147: PROCEDURE Carry_Over_Acknowledgement (
1148: p_api_version IN NUMBER,

Line 1145: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1141: * workflow after supplier's change has been accepted by buyer.
1142: * Returns:
1143: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1144: * FND_API.G_RET_STS_ERROR if an error occurs
1145: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1146: */
1147: PROCEDURE Carry_Over_Acknowledgement (
1148: p_api_version IN NUMBER,
1149: p_Init_Msg_List IN VARCHAR2,

Line 1251: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1247: -- End of Bug 2850566
1248:
1249: BEGIN
1250:
1251: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255:

Line 1256: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255:
1256: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1257: l_api_name, g_pkg_name)
1258: THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;

Line 1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1255:
1256: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1257: l_api_name, g_pkg_name)
1258: THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261:
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:

Line 1262: x_return_status := FND_API.G_RET_STS_SUCCESS;

1258: THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261:
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:
1264: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1265: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||
1266: l_api_name || '.invoked', 'po_header_id: ' ||

Line 1414: FND_API.G_FALSE,

1410: /* If all shipments are acknowledged after carryover, post header-level
1411: acknowledgement. */
1412: IF (PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Acknowledged(
1413: 1.0,
1414: FND_API.G_FALSE,
1415: p_po_header_id,
1416: p_po_release_id,
1417: p_revision_num ) = FND_API.G_TRUE ) THEN
1418:

Line 1417: p_revision_num ) = FND_API.G_TRUE ) THEN

1413: 1.0,
1414: FND_API.G_FALSE,
1415: p_po_header_id,
1416: p_po_release_id,
1417: p_revision_num ) = FND_API.G_TRUE ) THEN
1418:
1419: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1420: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||
1421: l_api_name || '.All_Shipments_Acknowledged. ', 'Log');

Line 1478: WHEN FND_API.g_exc_error THEN

1474: END IF;
1475:
1476:
1477: EXCEPTION
1478: WHEN FND_API.g_exc_error THEN
1479: x_return_status := FND_API.g_ret_sts_error;
1480: WHEN FND_API.g_exc_unexpected_error THEN
1481: x_return_status := FND_API.g_ret_sts_unexp_error;
1482: WHEN OTHERS THEN

Line 1479: x_return_status := FND_API.g_ret_sts_error;

1475:
1476:
1477: EXCEPTION
1478: WHEN FND_API.g_exc_error THEN
1479: x_return_status := FND_API.g_ret_sts_error;
1480: WHEN FND_API.g_exc_unexpected_error THEN
1481: x_return_status := FND_API.g_ret_sts_unexp_error;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1480: WHEN FND_API.g_exc_unexpected_error THEN

1476:
1477: EXCEPTION
1478: WHEN FND_API.g_exc_error THEN
1479: x_return_status := FND_API.g_ret_sts_error;
1480: WHEN FND_API.g_exc_unexpected_error THEN
1481: x_return_status := FND_API.g_ret_sts_unexp_error;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.g_ret_sts_unexp_error;
1484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1481: x_return_status := FND_API.g_ret_sts_unexp_error;

1477: EXCEPTION
1478: WHEN FND_API.g_exc_error THEN
1479: x_return_status := FND_API.g_ret_sts_error;
1480: WHEN FND_API.g_exc_unexpected_error THEN
1481: x_return_status := FND_API.g_ret_sts_unexp_error;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.g_ret_sts_unexp_error;
1484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1483: x_return_status := FND_API.g_ret_sts_unexp_error;

1479: x_return_status := FND_API.g_ret_sts_error;
1480: WHEN FND_API.g_exc_unexpected_error THEN
1481: x_return_status := FND_API.g_ret_sts_unexp_error;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.g_ret_sts_unexp_error;
1484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1486: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1487: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 1587: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1583:
1584:
1585: BEGIN
1586:
1587: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1588: FND_MSG_PUB.initialize;
1589: END IF;
1590:
1591: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 1591: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1587: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1588: FND_MSG_PUB.initialize;
1589: END IF;
1590:
1591: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1592: l_api_name, g_pkg_name)
1593: THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1590:
1591: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1592: l_api_name, g_pkg_name)
1593: THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;
1596:
1597: If (p_po_release_id is not null) then
1598: OPEN l_rel_ship_not_responded_csr;

Line 1622: return FND_API.G_FALSE;

1618:
1619: END IF;
1620:
1621: If (L_ship_not_responded_flag = 'Y') THEN
1622: return FND_API.G_FALSE;
1623: ELSE
1624: return FND_API.G_TRUE;
1625: END IF;
1626:

Line 1624: return FND_API.G_TRUE;

1620:
1621: If (L_ship_not_responded_flag = 'Y') THEN
1622: return FND_API.G_FALSE;
1623: ELSE
1624: return FND_API.G_TRUE;
1625: END IF;
1626:
1627: EXCEPTION
1628: WHEN OTHERS THEN

Line 1651: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

1647: * satisfied, post the header level acknowledgement record.
1648: * This API should be called after supplier submits the change requests and
1649: * after buyer responds to all supplier changes without revision increase.
1650: * Returns:
1651: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1652: * FND_API.G_RET_STS_ERROR if an error occurs
1653: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1654: */
1655: PROCEDURE Set_Header_Acknowledgement (

Line 1652: * FND_API.G_RET_STS_ERROR if an error occurs

1648: * This API should be called after supplier submits the change requests and
1649: * after buyer responds to all supplier changes without revision increase.
1650: * Returns:
1651: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1652: * FND_API.G_RET_STS_ERROR if an error occurs
1653: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1654: */
1655: PROCEDURE Set_Header_Acknowledgement (
1656: p_api_version IN NUMBER,

Line 1653: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1649: * after buyer responds to all supplier changes without revision increase.
1650: * Returns:
1651: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1652: * FND_API.G_RET_STS_ERROR if an error occurs
1653: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1654: */
1655: PROCEDURE Set_Header_Acknowledgement (
1656: p_api_version IN NUMBER,
1657: p_Init_Msg_List IN VARCHAR2,

Line 1688: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1684: AND po_line_location_id is not null;
1685:
1686: BEGIN
1687:
1688: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1689: FND_MSG_PUB.initialize;
1690: END IF;
1691:
1692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 1692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1688: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1689: FND_MSG_PUB.initialize;
1690: END IF;
1691:
1692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1693: l_api_name, g_pkg_name)
1694: THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;

Line 1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1691:
1692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1693: l_api_name, g_pkg_name)
1694: THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:
1698: x_return_status := FND_API.G_RET_STS_SUCCESS;
1699:

Line 1698: x_return_status := FND_API.G_RET_STS_SUCCESS;

1694: THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:
1698: x_return_status := FND_API.G_RET_STS_SUCCESS;
1699:
1700: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1701: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||
1702: l_api_name || '.invoked', 'po_header_id: ' ||

Line 1746: FND_API.G_FALSE,

1742: acknowledged. */
1743: IF (NVL(l_change_requested_by, ' ') <> 'SUPPLIER' AND
1744: PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Acknowledged (
1745: 1.0,
1746: FND_API.G_FALSE,
1747: P_po_header_id,
1748: p_po_release_id,
1749: l_revision_num ) = FND_API.G_TRUE ) THEN
1750:

Line 1749: l_revision_num ) = FND_API.G_TRUE ) THEN

1745: 1.0,
1746: FND_API.G_FALSE,
1747: P_po_header_id,
1748: p_po_release_id,
1749: l_revision_num ) = FND_API.G_TRUE ) THEN
1750:
1751: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1752: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix ||
1753: l_api_name || '.All_Shipments_Acknowledged', 'po_header_id: ' ||

Line 1836: WHEN FND_API.g_exc_error THEN

1832:
1833: END IF; -- End if all_shipments_acknowledged
1834:
1835: EXCEPTION
1836: WHEN FND_API.g_exc_error THEN
1837: x_return_status := FND_API.g_ret_sts_error;
1838: WHEN FND_API.g_exc_unexpected_error THEN
1839: x_return_status := FND_API.g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN

Line 1837: x_return_status := FND_API.g_ret_sts_error;

1833: END IF; -- End if all_shipments_acknowledged
1834:
1835: EXCEPTION
1836: WHEN FND_API.g_exc_error THEN
1837: x_return_status := FND_API.g_ret_sts_error;
1838: WHEN FND_API.g_exc_unexpected_error THEN
1839: x_return_status := FND_API.g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN
1841: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1838: WHEN FND_API.g_exc_unexpected_error THEN

1834:
1835: EXCEPTION
1836: WHEN FND_API.g_exc_error THEN
1837: x_return_status := FND_API.g_ret_sts_error;
1838: WHEN FND_API.g_exc_unexpected_error THEN
1839: x_return_status := FND_API.g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN
1841: x_return_status := FND_API.g_ret_sts_unexp_error;
1842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1839: x_return_status := FND_API.g_ret_sts_unexp_error;

1835: EXCEPTION
1836: WHEN FND_API.g_exc_error THEN
1837: x_return_status := FND_API.g_ret_sts_error;
1838: WHEN FND_API.g_exc_unexpected_error THEN
1839: x_return_status := FND_API.g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN
1841: x_return_status := FND_API.g_ret_sts_unexp_error;
1842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1843: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1841: x_return_status := FND_API.g_ret_sts_unexp_error;

1837: x_return_status := FND_API.g_ret_sts_error;
1838: WHEN FND_API.g_exc_unexpected_error THEN
1839: x_return_status := FND_API.g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN
1841: x_return_status := FND_API.g_ret_sts_unexp_error;
1842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1843: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1844: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1845: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||