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 FND_MSG_PUB

Line 386: FND_MSG_PUB.ADD;

382: l_api_name,
383: G_PKG_NAME)
384: THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 391: FND_MSG_PUB.initialize;

387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393:
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 418: FND_MSG_PUB.ADD;

414: IF (c_component_not_status%FOUND) THEN
415: CLOSE c_component_not_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MESSAGE.Set_Name('IBC', 'COMPONENT_APPROVAL_REQUIRED');
418: FND_MSG_PUB.ADD;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: CLOSE c_component_not_status;
422:

Line 454: FND_MSG_PUB.ADD;

450: END IF;
451: IF l_user_list IS NULL THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
454: FND_MSG_PUB.ADD;
455: RAISE FND_API.G_EXC_ERROR;
456: ELSE
457: Create_Workflow_Role(
458: p_user_list => l_user_list

Line 730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

726: COMMIT;
727: END IF;
728:
729: -- Standard call to get message count and if count=1, get the message
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data);
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;

Line 735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

731: p_data => x_msg_data);
732: EXCEPTION
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

Line 740: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
742: ,P_SQLCODE => SQLCODE
743: ,P_SQLERRM => SQLERRM
744: ,X_MSG_COUNT => X_MSG_COUNT

Line 750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

746: ,X_RETURN_STATUS => X_RETURN_STATUS
747: );
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

Line 755: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
757: ,P_SQLCODE => SQLCODE
758: ,P_SQLERRM => SQLERRM
759: ,X_MSG_COUNT => X_MSG_COUNT

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

761: ,X_RETURN_STATUS => X_RETURN_STATUS
762: );
763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
766: THEN
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,

Line 767: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
766: THEN
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(

Line 769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

765: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
766: THEN
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

Line 1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||

1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||
1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP
1226: l_error_msg_stack := l_error_msg_stack || ' ... ' ||
1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||
1228: FND_GLOBAL.Newline();
1229: END LOOP;
1230: WF_ENGINE.SetItemAttrText(
1231: itemtype => itemtype,

Line 1297: FND_MSG_PUB.initialize;

1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1311: FND_MSG_PUB.ADD;

1307: IF c_chk_notification%NOTFOUND THEN
1308: CLOSE c_chk_notification;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: FND_MESSAGE.Set_Name('IBC', 'IBC_NOTIF_ALREADY_RESPONDED');
1311: FND_MSG_PUB.ADD;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;
1314: CLOSE c_chk_notification;
1315:

Line 1339: FND_MSG_PUB.ADD;

1335: ELSE
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
1338: FND_MESSAGE.Set_Token('INPUT', 'p_response', FALSE);
1339: FND_MSG_PUB.ADD;
1340: RAISE FND_API.G_EXC_ERROR;
1341: END IF;
1342:
1343: -- COMMIT?

Line 1349: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1345: COMMIT;
1346: END IF;
1347:
1348: -- Standard call to get message count and if count=1, get the message
1349: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1350: p_data => x_msg_data);
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1350: p_data => x_msg_data);
1351: EXCEPTION
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

Line 1359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1361: ,P_SQLCODE => SQLCODE
1362: ,P_SQLERRM => SQLERRM
1363: ,X_MSG_COUNT => X_MSG_COUNT

Line 1369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1365: ,X_RETURN_STATUS => X_RETURN_STATUS
1366: );
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

Line 1374: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1376: ,P_SQLCODE => SQLCODE
1377: ,P_SQLERRM => SQLERRM
1378: ,X_MSG_COUNT => X_MSG_COUNT

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

1380: ,X_RETURN_STATUS => X_RETURN_STATUS
1381: );
1382: WHEN OTHERS THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385: THEN
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,

Line 1386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1382: WHEN OTHERS THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385: THEN
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(

Line 1388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385: THEN
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

Line 1438: FND_MSG_PUB.initialize;

1434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1435: END IF;
1436: -- Initialize message list if p_init_msg_list is set to TRUE.
1437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1438: FND_MSG_PUB.initialize;
1439: END IF;
1440:
1441: -- Initialize API return status to success
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1453: COMMIT;
1454: END IF;
1455:
1456: -- Standard call to get message count and if count=1, get the message
1457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1458: p_data => x_msg_data);
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1458: p_data => x_msg_data);
1459: EXCEPTION
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

Line 1467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1469: ,P_SQLCODE => SQLCODE
1470: ,P_SQLERRM => SQLERRM
1471: ,X_MSG_COUNT => X_MSG_COUNT

Line 1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1473: ,X_RETURN_STATUS => X_RETURN_STATUS
1474: );
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

Line 1482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1484: ,P_SQLCODE => SQLCODE
1485: ,P_SQLERRM => SQLERRM
1486: ,X_MSG_COUNT => X_MSG_COUNT

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

1488: ,X_RETURN_STATUS => X_RETURN_STATUS
1489: );
1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1493: THEN
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,

Line 1494: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1493: THEN
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(

Line 1496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1493: THEN
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

Line 1569: FND_MSG_PUB.initialize;

1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1591: END LOOP;
1592: END IF;
1593:
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1596: p_data => x_msg_data);
1597: EXCEPTION
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

Line 1605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1607: ,P_SQLCODE => SQLCODE
1608: ,P_SQLERRM => SQLERRM
1609: ,X_MSG_COUNT => X_MSG_COUNT

Line 1615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1611: ,X_RETURN_STATUS => X_RETURN_STATUS
1612: );
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

Line 1620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1622: ,P_SQLCODE => SQLCODE
1623: ,P_SQLERRM => SQLERRM
1624: ,X_MSG_COUNT => X_MSG_COUNT

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

1626: ,X_RETURN_STATUS => X_RETURN_STATUS
1627: );
1628: WHEN OTHERS THEN
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
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,

Line 1632: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1628: WHEN OTHERS THEN
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
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(

Line 1634: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
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

Line 1705: FND_MSG_PUB.initialize;

1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: END IF;
1703: -- Initialize message list if p_init_msg_list is set to TRUE.
1704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1705: FND_MSG_PUB.initialize;
1706: END IF;
1707:
1708: -- Initialize API return status to success
1709: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1727: END LOOP;
1728: END IF;
1729:
1730: -- Standard call to get message count and if count=1, get the message
1731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1732: p_data => x_msg_data);
1733: EXCEPTION
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1736: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1732: p_data => x_msg_data);
1733: EXCEPTION
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

Line 1741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1743: ,P_SQLCODE => SQLCODE
1744: ,P_SQLERRM => SQLERRM
1745: ,X_MSG_COUNT => X_MSG_COUNT

Line 1751: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1747: ,X_RETURN_STATUS => X_RETURN_STATUS
1748: );
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

Line 1756: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
1758: ,P_SQLCODE => SQLCODE
1759: ,P_SQLERRM => SQLERRM
1760: ,X_MSG_COUNT => X_MSG_COUNT

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

1762: ,X_RETURN_STATUS => X_RETURN_STATUS
1763: );
1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
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,

Line 1768: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
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(

Line 1770: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
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

Line 1933: FND_MSG_PUB.ADD;

1929: l_api_name,
1930: G_PKG_NAME)
1931: THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1938: FND_MSG_PUB.initialize;

1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1941: -- Initialize API return status to success
1942: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1981: FND_MSG_PUB.ADD;

1977:
1978: IF l_user_list IS NULL THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
1981: FND_MSG_PUB.ADD;
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSE
1984: Create_Workflow_Role(p_user_list => l_user_list
1985: ,px_wf_role_name => l_wf_role_name

Line 2307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2303: COMMIT;
2304: END IF;
2305:
2306: -- Standard call to get message count and if count=1, get the message
2307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2308: p_data => x_msg_data);
2309: EXCEPTION
2310: WHEN FND_API.G_EXC_ERROR THEN
2311: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2308: p_data => x_msg_data);
2309: EXCEPTION
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

Line 2317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2319: ,P_SQLCODE => SQLCODE
2320: ,P_SQLERRM => SQLERRM
2321: ,X_MSG_COUNT => X_MSG_COUNT

Line 2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2323: ,X_RETURN_STATUS => X_RETURN_STATUS
2324: );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 2333: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
2335: ,P_SQLCODE => SQLCODE
2336: ,P_SQLERRM => SQLERRM
2337: ,X_MSG_COUNT => X_MSG_COUNT

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

2339: ,X_RETURN_STATUS => X_RETURN_STATUS
2340: );
2341: WHEN OTHERS THEN
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2346: END IF;
2347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 2345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2341: WHEN OTHERS THEN
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2346: END IF;
2347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2348: ,p_data => x_msg_data
2349: );

Line 2347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
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

Line 2873: --FND_MSG_PUB.ADD;

2869:
2870: IF l_user_list IS NULL THEN
2871: --x_return_status := FND_API.G_RET_STS_ERROR;
2872: --FND_MESSAGE.Set_Name('IBC', 'IBC_NOT_APPROVER_DEFINED');
2873: --FND_MSG_PUB.ADD;
2874: --RAISE FND_API.G_EXC_ERROR;
2875: return;
2876: ELSE
2877: Create_Workflow_Role(p_user_list => l_user_list

Line 2941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2937:
2938: EXCEPTION
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

Line 2946: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
2948: ,P_SQLCODE => SQLCODE
2949: ,P_SQLERRM => SQLERRM
2950: ,X_MSG_COUNT => X_MSG_COUNT

Line 3103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3099:
3100: EXCEPTION
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

Line 3108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
3110: ,P_SQLCODE => SQLCODE
3111: ,P_SQLERRM => SQLERRM
3112: ,X_MSG_COUNT => X_MSG_COUNT