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.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_UTILITIES_PVT

Line 571: IBC_UTILITIES_PVT.check_current_user(NULL,l_owner_resource_id,l_owner_resource_type, l_creator_id) = 'FALSE'))

567: NVL(Fnd_Profile.Value_specific('IBC_USE_ACCESS_CONTROL',-999,-999,-999), 'N') = 'N' AND
568: l_owner_resource_id IS NOT NULL AND
569: ((l_owner_resource_type IS NULL AND l_owner_resource_id <> l_creator_id) OR
570: (l_owner_resource_type IS NOT NULL AND
571: IBC_UTILITIES_PVT.check_current_user(NULL,l_owner_resource_id,l_owner_resource_type, l_creator_id) = 'FALSE'))
572: THEN
573: l_wf_no_approver_defined := 'N';
574: IF l_owner_resource_type IS NOT NULL THEN -- Owner is a resource
575: Create_Workflow_Role(

Line 737: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

733: WHEN FND_API.G_EXC_ERROR THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
736: p_data => x_msg_data);
737: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
738: P_API_NAME => L_API_NAME
739: ,P_PKG_NAME => G_PKG_NAME
740: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
741: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 741: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

737: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
738: P_API_NAME => L_API_NAME
739: ,P_PKG_NAME => G_PKG_NAME
740: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
741: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
742: ,P_SQLCODE => SQLCODE
743: ,P_SQLERRM => SQLERRM
744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA

Line 752: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
751: p_data => x_msg_data);
752: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
753: P_API_NAME => L_API_NAME
754: ,P_PKG_NAME => G_PKG_NAME
755: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
756: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 756: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

752: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
753: P_API_NAME => L_API_NAME
754: ,P_PKG_NAME => G_PKG_NAME
755: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
756: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
757: ,P_SQLCODE => SQLCODE
758: ,P_SQLERRM => SQLERRM
759: ,X_MSG_COUNT => X_MSG_COUNT
760: ,X_MSG_DATA => X_MSG_DATA

Line 771: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

767: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
768: END IF;
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
770: p_data => x_msg_data);
771: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
772: P_API_NAME => L_API_NAME
773: ,P_PKG_NAME => G_PKG_NAME
774: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
775: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 774: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

770: p_data => x_msg_data);
771: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
772: P_API_NAME => L_API_NAME
773: ,P_PKG_NAME => G_PKG_NAME
774: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
775: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
776: ,P_SQLCODE => SQLCODE
777: ,P_SQLERRM => SQLERRM
778: ,X_MSG_COUNT => X_MSG_COUNT

Line 775: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

771: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
772: P_API_NAME => L_API_NAME
773: ,P_PKG_NAME => G_PKG_NAME
774: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
775: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
776: ,P_SQLCODE => SQLCODE
777: ,P_SQLERRM => SQLERRM
778: ,X_MSG_COUNT => X_MSG_COUNT
779: ,X_MSG_DATA => X_MSG_DATA

Line 876: IBC_UTILITIES_PVT.Get_Messages (

872:
873: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
874: -- IF l_return_status not successful then return 'N'
875: result := 'COMPLETE:N';
876: IBC_UTILITIES_PVT.Get_Messages (
877: p_message_count => l_msg_count,
878: x_msgs => l_error_msg_stack
879: );
880: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||

Line 995: IBC_UTILITIES_PVT.Get_Messages (

991: );
992: END IF;
993:
994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
995: IBC_UTILITIES_PVT.Get_Messages (
996: p_message_count => l_msg_count,
997: x_msgs => l_error_msg_stack
998: );
999: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||

Line 1356: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1352: WHEN FND_API.G_EXC_ERROR THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1355: p_data => x_msg_data);
1356: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1357: P_API_NAME => L_API_NAME
1358: ,P_PKG_NAME => G_PKG_NAME
1359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1360: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1360: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1356: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1357: P_API_NAME => L_API_NAME
1358: ,P_PKG_NAME => G_PKG_NAME
1359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1360: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1361: ,P_SQLCODE => SQLCODE
1362: ,P_SQLERRM => SQLERRM
1363: ,X_MSG_COUNT => X_MSG_COUNT
1364: ,X_MSG_DATA => X_MSG_DATA

Line 1371: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1370: p_data => x_msg_data);
1371: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1372: P_API_NAME => L_API_NAME
1373: ,P_PKG_NAME => G_PKG_NAME
1374: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1375: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1375: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1371: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1372: P_API_NAME => L_API_NAME
1373: ,P_PKG_NAME => G_PKG_NAME
1374: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1375: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1376: ,P_SQLCODE => SQLCODE
1377: ,P_SQLERRM => SQLERRM
1378: ,X_MSG_COUNT => X_MSG_COUNT
1379: ,X_MSG_DATA => X_MSG_DATA

Line 1390: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1387: END IF;
1388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1389: p_data => x_msg_data);
1390: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1391: P_API_NAME => L_API_NAME
1392: ,P_PKG_NAME => G_PKG_NAME
1393: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1394: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1393: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1389: p_data => x_msg_data);
1390: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1391: P_API_NAME => L_API_NAME
1392: ,P_PKG_NAME => G_PKG_NAME
1393: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1394: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1395: ,P_SQLCODE => SQLCODE
1396: ,P_SQLERRM => SQLERRM
1397: ,X_MSG_COUNT => X_MSG_COUNT

Line 1394: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1390: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1391: P_API_NAME => L_API_NAME
1392: ,P_PKG_NAME => G_PKG_NAME
1393: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1394: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1395: ,P_SQLCODE => SQLCODE
1396: ,P_SQLERRM => SQLERRM
1397: ,X_MSG_COUNT => X_MSG_COUNT
1398: ,X_MSG_DATA => X_MSG_DATA

Line 1464: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1460: WHEN FND_API.G_EXC_ERROR THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1463: p_data => x_msg_data);
1464: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1465: P_API_NAME => L_API_NAME
1466: ,P_PKG_NAME => G_PKG_NAME
1467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1468: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1468: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1464: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1465: P_API_NAME => L_API_NAME
1466: ,P_PKG_NAME => G_PKG_NAME
1467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1468: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1469: ,P_SQLCODE => SQLCODE
1470: ,P_SQLERRM => SQLERRM
1471: ,X_MSG_COUNT => X_MSG_COUNT
1472: ,X_MSG_DATA => X_MSG_DATA

Line 1479: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1478: p_data => x_msg_data);
1479: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1480: P_API_NAME => L_API_NAME
1481: ,P_PKG_NAME => G_PKG_NAME
1482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1483: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1483: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1479: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1480: P_API_NAME => L_API_NAME
1481: ,P_PKG_NAME => G_PKG_NAME
1482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1483: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1484: ,P_SQLCODE => SQLCODE
1485: ,P_SQLERRM => SQLERRM
1486: ,X_MSG_COUNT => X_MSG_COUNT
1487: ,X_MSG_DATA => X_MSG_DATA

Line 1498: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1494: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1495: END IF;
1496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1497: p_data => x_msg_data);
1498: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1499: P_API_NAME => L_API_NAME
1500: ,P_PKG_NAME => G_PKG_NAME
1501: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1502: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1501: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1497: p_data => x_msg_data);
1498: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1499: P_API_NAME => L_API_NAME
1500: ,P_PKG_NAME => G_PKG_NAME
1501: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1502: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1503: ,P_SQLCODE => SQLCODE
1504: ,P_SQLERRM => SQLERRM
1505: ,X_MSG_COUNT => X_MSG_COUNT

Line 1502: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1498: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1499: P_API_NAME => L_API_NAME
1500: ,P_PKG_NAME => G_PKG_NAME
1501: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1502: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1503: ,P_SQLCODE => SQLCODE
1504: ,P_SQLERRM => SQLERRM
1505: ,X_MSG_COUNT => X_MSG_COUNT
1506: ,X_MSG_DATA => X_MSG_DATA

Line 1602: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1601: p_data => x_msg_data);
1602: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1603: P_API_NAME => L_API_NAME
1604: ,P_PKG_NAME => G_PKG_NAME
1605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1606: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1606: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1602: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1603: P_API_NAME => L_API_NAME
1604: ,P_PKG_NAME => G_PKG_NAME
1605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1606: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1607: ,P_SQLCODE => SQLCODE
1608: ,P_SQLERRM => SQLERRM
1609: ,X_MSG_COUNT => X_MSG_COUNT
1610: ,X_MSG_DATA => X_MSG_DATA

Line 1617: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1616: p_data => x_msg_data);
1617: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1618: P_API_NAME => L_API_NAME
1619: ,P_PKG_NAME => G_PKG_NAME
1620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1621: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1621: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1617: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1618: P_API_NAME => L_API_NAME
1619: ,P_PKG_NAME => G_PKG_NAME
1620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1621: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1622: ,P_SQLCODE => SQLCODE
1623: ,P_SQLERRM => SQLERRM
1624: ,X_MSG_COUNT => X_MSG_COUNT
1625: ,X_MSG_DATA => X_MSG_DATA

Line 1636: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1632: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1633: END IF;
1634: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1635: p_data => x_msg_data);
1636: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1637: P_API_NAME => L_API_NAME
1638: ,P_PKG_NAME => G_PKG_NAME
1639: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1640: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1639: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1635: p_data => x_msg_data);
1636: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1637: P_API_NAME => L_API_NAME
1638: ,P_PKG_NAME => G_PKG_NAME
1639: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1640: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1641: ,P_SQLCODE => SQLCODE
1642: ,P_SQLERRM => SQLERRM
1643: ,X_MSG_COUNT => X_MSG_COUNT

Line 1640: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1636: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1637: P_API_NAME => L_API_NAME
1638: ,P_PKG_NAME => G_PKG_NAME
1639: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1640: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1641: ,P_SQLCODE => SQLCODE
1642: ,P_SQLERRM => SQLERRM
1643: ,X_MSG_COUNT => X_MSG_COUNT
1644: ,X_MSG_DATA => X_MSG_DATA

Line 1738: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1734: WHEN FND_API.G_EXC_ERROR THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;
1736: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1737: p_data => x_msg_data);
1738: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1739: P_API_NAME => L_API_NAME
1740: ,P_PKG_NAME => G_PKG_NAME
1741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1742: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1742: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1738: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1739: P_API_NAME => L_API_NAME
1740: ,P_PKG_NAME => G_PKG_NAME
1741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1742: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1743: ,P_SQLCODE => SQLCODE
1744: ,P_SQLERRM => SQLERRM
1745: ,X_MSG_COUNT => X_MSG_COUNT
1746: ,X_MSG_DATA => X_MSG_DATA

Line 1753: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1752: p_data => x_msg_data);
1753: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1754: P_API_NAME => L_API_NAME
1755: ,P_PKG_NAME => G_PKG_NAME
1756: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1757: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1757: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1753: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1754: P_API_NAME => L_API_NAME
1755: ,P_PKG_NAME => G_PKG_NAME
1756: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1757: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1758: ,P_SQLCODE => SQLCODE
1759: ,P_SQLERRM => SQLERRM
1760: ,X_MSG_COUNT => X_MSG_COUNT
1761: ,X_MSG_DATA => X_MSG_DATA

Line 1772: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

1768: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1769: END IF;
1770: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1771: p_data => x_msg_data);
1772: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1773: P_API_NAME => L_API_NAME
1774: ,P_PKG_NAME => G_PKG_NAME
1775: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1776: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 1775: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

1771: p_data => x_msg_data);
1772: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1773: P_API_NAME => L_API_NAME
1774: ,P_PKG_NAME => G_PKG_NAME
1775: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1776: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1777: ,P_SQLCODE => SQLCODE
1778: ,P_SQLERRM => SQLERRM
1779: ,X_MSG_COUNT => X_MSG_COUNT

Line 1776: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

1772: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1773: P_API_NAME => L_API_NAME
1774: ,P_PKG_NAME => G_PKG_NAME
1775: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
1776: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1777: ,P_SQLCODE => SQLCODE
1778: ,P_SQLERRM => SQLERRM
1779: ,X_MSG_COUNT => X_MSG_COUNT
1780: ,X_MSG_DATA => X_MSG_DATA

Line 2030: p_activity => Ibc_Utilities_Pvt.G_ALA_APPROVE

2026: x_wf_item_key := -1;
2027:
2028: --UI Logging
2029: IBC_AUDIT_LOG_GRP.log_action(
2030: p_activity => Ibc_Utilities_Pvt.G_ALA_APPROVE
2031: ,p_object_type => IBC_AUDIT_LOG_GRP.G_CITEM_VERSION
2032: ,p_object_value1 => p_citem_ver_id
2033: ,p_object_value2 => p_language
2034: ,p_parent_value => getCitemId(p_citem_ver_id)

Line 2074: p_activity => Ibc_Utilities_Pvt.G_ALA_SUBMIT

2070: END IF;
2071:
2072: --UI Logging
2073: IBC_AUDIT_LOG_GRP.log_action(
2074: p_activity => Ibc_Utilities_Pvt.G_ALA_SUBMIT
2075: ,p_object_type => IBC_AUDIT_LOG_GRP.G_CITEM_VERSION
2076: ,p_object_value1 => p_citem_ver_id
2077: ,p_object_value2 => p_language
2078: ,p_parent_value => getCitemId(p_citem_ver_id)

Line 2139: AND IBC_UTILITIES_PVT.check_current_user(NULL

2135: AND (( l_owner_resource_type IS NULL
2136: AND l_owner_resource_id <> l_creator_id)
2137: OR
2138: (l_owner_resource_type IS NOT NULL
2139: AND IBC_UTILITIES_PVT.check_current_user(NULL
2140: ,l_owner_resource_id
2141: ,l_owner_resource_type
2142: ,l_creator_id) = 'FALSE'))
2143: THEN

Line 2282: IBC_UTILITIES_PVT.Get_Language_Description(p_language_code => p_language

2278: ,aname => 'CITEM_LANGUAGE'
2279: ,avalue => p_language);
2280:
2281: -- Set the language description
2282: IBC_UTILITIES_PVT.Get_Language_Description(p_language_code => p_language
2283: ,p_language_description => l_language_description
2284: );
2285: --DBMS_OUTPUT.put_line('l_language_description =' || l_language_description);
2286: WF_ENGINE.SetItemAttrText(itemtype => l_ItemType

Line 2314: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2310: WHEN FND_API.G_EXC_ERROR THEN
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2313: p_data => x_msg_data);
2314: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2315: P_API_NAME => L_API_NAME
2316: ,P_PKG_NAME => G_PKG_NAME
2317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2318: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2318: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2314: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2315: P_API_NAME => L_API_NAME
2316: ,P_PKG_NAME => G_PKG_NAME
2317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2318: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2319: ,P_SQLCODE => SQLCODE
2320: ,P_SQLERRM => SQLERRM
2321: ,X_MSG_COUNT => X_MSG_COUNT
2322: ,X_MSG_DATA => X_MSG_DATA

Line 2330: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2328: ,p_data => x_msg_data
2329: );
2330: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2331: P_API_NAME => L_API_NAME
2332: ,P_PKG_NAME => G_PKG_NAME
2333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2334: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2334: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2330: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2331: P_API_NAME => L_API_NAME
2332: ,P_PKG_NAME => G_PKG_NAME
2333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2334: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2335: ,P_SQLCODE => SQLCODE
2336: ,P_SQLERRM => SQLERRM
2337: ,X_MSG_COUNT => X_MSG_COUNT
2338: ,X_MSG_DATA => X_MSG_DATA

Line 2350: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2346: END IF;
2347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2348: ,p_data => x_msg_data
2349: );
2350: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2351: P_API_NAME => L_API_NAME
2352: ,P_PKG_NAME => G_PKG_NAME
2353: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
2354: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2353: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS

2349: );
2350: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2351: P_API_NAME => L_API_NAME
2352: ,P_PKG_NAME => G_PKG_NAME
2353: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
2354: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2355: ,P_SQLCODE => SQLCODE
2356: ,P_SQLERRM => SQLERRM
2357: ,X_MSG_COUNT => X_MSG_COUNT

Line 2354: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2350: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2351: P_API_NAME => L_API_NAME
2352: ,P_PKG_NAME => G_PKG_NAME
2353: ,P_EXCEPTION_LEVEL => IBC_UTILITIES_PVT.G_EXC_OTHERS
2354: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2355: ,P_SQLCODE => SQLCODE
2356: ,P_SQLERRM => SQLERRM
2357: ,X_MSG_COUNT => X_MSG_COUNT
2358: ,X_MSG_DATA => X_MSG_DATA

Line 2454: p_activity => Ibc_Utilities_Pvt.G_ALA_REJECT

2450: ,aname => 'NOTES_TO_SUBMITTER'
2451: );
2452: -- Logging
2453: IBC_AUDIT_LOG_GRP.log_action(
2454: p_activity => Ibc_Utilities_Pvt.G_ALA_REJECT
2455: ,p_object_type => IBC_AUDIT_LOG_GRP.G_CITEM_VERSION
2456: ,p_object_value1 => l_citem_ver_id
2457: ,p_object_value2 => l_language
2458: ,p_parent_value => getCitemId(l_citem_ver_id)

Line 2477: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count

2473:
2474: END IF;
2475:
2476: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2477: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count
2478: ,x_msgs => l_error_msg_stack
2479: );
2480:
2481: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'

Line 2590: p_activity => Ibc_Utilities_Pvt.G_ALA_APPROVE

2586: END IF;
2587:
2588: -- Audit Log Action
2589: IBC_AUDIT_LOG_GRP.log_action(
2590: p_activity => Ibc_Utilities_Pvt.G_ALA_APPROVE
2591: ,p_object_type => IBC_AUDIT_LOG_GRP.G_CITEM_VERSION
2592: ,p_object_value1 => l_citem_ver_id
2593: ,p_object_value2 => l_language
2594: ,p_parent_value => getCitemId(l_citem_ver_id)

Line 2612: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count

2608:
2609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2610: -- IF l_return_status not successful then return 'N'
2611: result := 'COMPLETE:N';
2612: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count
2613: ,x_msgs => l_error_msg_stack
2614: );
2615:
2616: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'

Line 2943: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2939: WHEN FND_API.G_EXC_ERROR THEN
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2942: p_data => x_msg_data);
2943: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2944: P_API_NAME => L_API_NAME
2945: ,P_PKG_NAME => G_PKG_NAME
2946: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2947: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 2947: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

2943: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2944: P_API_NAME => L_API_NAME
2945: ,P_PKG_NAME => G_PKG_NAME
2946: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2947: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2948: ,P_SQLCODE => SQLCODE
2949: ,P_SQLERRM => SQLERRM
2950: ,X_MSG_COUNT => X_MSG_COUNT
2951: ,X_MSG_DATA => X_MSG_DATA

Line 3105: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

3101: WHEN FND_API.G_EXC_ERROR THEN
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3104: p_data => x_msg_data);
3105: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3106: P_API_NAME => L_API_NAME
3107: ,P_PKG_NAME => G_PKG_NAME
3108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3109: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

Line 3109: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT

3105: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3106: P_API_NAME => L_API_NAME
3107: ,P_PKG_NAME => G_PKG_NAME
3108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3109: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3110: ,P_SQLCODE => SQLCODE
3111: ,P_SQLERRM => SQLERRM
3112: ,X_MSG_COUNT => X_MSG_COUNT
3113: ,X_MSG_DATA => X_MSG_DATA