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_DATA_SECURITY_PVT dependencies on FND_MSG_PUB

Line 423: FND_MSG_PUB.ADD;

419: l_api_name,
420: G_PKG_NAME)
421: THEN
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.ADD;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 428: FND_MSG_PUB.initialize;

424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: IF FND_API.to_Boolean( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Initialize API return status to success
432: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

484: COMMIT;
485: END IF;
486:
487: -- Standard call to get message count and if count=1, get the message
488: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
489: p_data => x_msg_data);
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: ROLLBACK TO svpt_set_inheritance_type;

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

490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: ROLLBACK TO svpt_set_inheritance_type;
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
496: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME

Line 499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

495: p_data => x_msg_data);
496: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
500: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
501: ,P_SQLCODE => SQLCODE
502: ,P_SQLERRM => SQLERRM
503: ,X_MSG_COUNT => X_MSG_COUNT

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

506: );
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: ROLLBACK TO svpt_set_inheritance_type;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
511: p_data => x_msg_data);
512: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME

Line 515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

511: p_data => x_msg_data);
512: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
516: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
517: ,P_SQLCODE => SQLCODE
518: ,P_SQLERRM => SQLERRM
519: ,X_MSG_COUNT => X_MSG_COUNT

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

522: );
523: WHEN OTHERS THEN
524: ROLLBACK TO svpt_set_inheritance_type;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
529: END IF;
530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

524: ROLLBACK TO svpt_set_inheritance_type;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
529: END IF;
530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
531: p_data => x_msg_data);
532: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
529: END IF;
530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
531: p_data => x_msg_data);
532: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
533: P_API_NAME => L_API_NAME
534: ,P_PKG_NAME => G_PKG_NAME

Line 614: FND_MSG_PUB.ADD;

610: l_api_name,
611: G_PKG_NAME)
612: THEN
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: FND_MSG_PUB.ADD;
615: RAISE FND_API.G_EXC_ERROR;
616: END IF;
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 619: FND_MSG_PUB.initialize;

615: RAISE FND_API.G_EXC_ERROR;
616: END IF;
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list ) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Initialize API return status to success
623: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

676: COMMIT;
677: END IF;
678:
679: -- Standard call to get message count and if count=1, get the message
680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
681: p_data => x_msg_data);
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN
684: ROLLBACK TO svpt_remove_instance;

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

682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN
684: ROLLBACK TO svpt_remove_instance;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
687: p_data => x_msg_data);
688: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME

Line 691: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

687: p_data => x_msg_data);
688: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
692: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
693: ,P_SQLCODE => SQLCODE
694: ,P_SQLERRM => SQLERRM
695: ,X_MSG_COUNT => X_MSG_COUNT

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

698: );
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO svpt_remove_instance;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
703: p_data => x_msg_data);
704: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
705: P_API_NAME => L_API_NAME
706: ,P_PKG_NAME => G_PKG_NAME

Line 707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

703: p_data => x_msg_data);
704: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
705: P_API_NAME => L_API_NAME
706: ,P_PKG_NAME => G_PKG_NAME
707: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
708: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
709: ,P_SQLCODE => SQLCODE
710: ,P_SQLERRM => SQLERRM
711: ,X_MSG_COUNT => X_MSG_COUNT

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

714: );
715: WHEN OTHERS THEN
716: ROLLBACK TO svpt_remove_instance;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
721: END IF;
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

716: ROLLBACK TO svpt_remove_instance;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
721: END IF;
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
723: p_data => x_msg_data);
724: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
721: END IF;
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
723: p_data => x_msg_data);
724: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
725: P_API_NAME => L_API_NAME
726: ,P_PKG_NAME => G_PKG_NAME

Line 831: FND_MSG_PUB.ADD;

827: l_api_name,
828: G_PKG_NAME)
829: THEN
830: x_return_status := FND_API.G_RET_STS_ERROR;
831: FND_MSG_PUB.ADD;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 836: FND_MSG_PUB.initialize;

832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF FND_API.to_Boolean( p_init_msg_list ) THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838:
839: -- Initialize API return status to success
840: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 931: FND_MSG_PUB.ADD;

927: p_inheritance_type <> 'WSFOLDER')
928: THEN
929: -- Error Inheritance Type not compatible with containers
930: FND_MESSAGE.Set_Name('IBC', 'IBC_INCOMPATIBLE_INHERITANCE_TYPE');
931: FND_MSG_PUB.ADD;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: -- Defaulting inheritance type based on container's inheritance type

Line 985: FND_MSG_PUB.ADD;

981: p_inheritance_type <> 'WSFOLDER')
982: THEN
983: -- Error Inheritance Type not compatible with containers
984: FND_MESSAGE.Set_Name('IBC', 'IBC_INCOMPATIBLE_INHERITANCE_TYPE');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988:
989: -- Actual UPDATE

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

1075: COMMIT;
1076: END IF;
1077:
1078: -- Standard call to get message count and if count=1, get the message
1079: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1080: p_data => x_msg_data);
1081: EXCEPTION
1082: WHEN FND_API.G_EXC_ERROR THEN
1083: ROLLBACK TO svpt_establish_inheritance;

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

1081: EXCEPTION
1082: WHEN FND_API.G_EXC_ERROR THEN
1083: ROLLBACK TO svpt_establish_inheritance;
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1086: p_data => x_msg_data);
1087: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1088: P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME

Line 1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1086: p_data => x_msg_data);
1087: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1088: P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME
1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1091: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1092: ,P_SQLCODE => SQLCODE
1093: ,P_SQLERRM => SQLERRM
1094: ,X_MSG_COUNT => X_MSG_COUNT

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

1097: );
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO svpt_establish_inheritance;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1102: p_data => x_msg_data);
1103: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME

Line 1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1102: p_data => x_msg_data);
1103: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1107: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1108: ,P_SQLCODE => SQLCODE
1109: ,P_SQLERRM => SQLERRM
1110: ,X_MSG_COUNT => X_MSG_COUNT

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

1113: );
1114: WHEN OTHERS THEN
1115: ROLLBACK TO svpt_establish_inheritance;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1118: THEN
1119: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1120: END IF;
1121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

1115: ROLLBACK TO svpt_establish_inheritance;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1118: THEN
1119: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1120: END IF;
1121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1122: p_data => x_msg_data);
1123: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

1117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1118: THEN
1119: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1120: END IF;
1121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1122: p_data => x_msg_data);
1123: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME

Line 1279: FND_MSG_PUB.ADD;

1275: l_api_name,
1276: G_PKG_NAME)
1277: THEN
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: -- Initialize message list if p_init_msg_list is set to TRUE.
1283: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1284: FND_MSG_PUB.initialize;

1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: -- Initialize message list if p_init_msg_list is set to TRUE.
1283: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1284: FND_MSG_PUB.initialize;
1285: END IF;
1286:
1287: -- Initialize API return status to success
1288: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1353: COMMIT;
1354: END IF;
1355:
1356: -- Standard call to get message count and if count=1, get the message
1357: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1358: p_data => x_msg_data);
1359:
1360: IF IBC_DEBUG_PVT.debug_enabled THEN
1361: IBC_DEBUG_PVT.end_process(

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

1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: ROLLBACK TO svpt_reset_permissions;
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data);
1379: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1380: P_API_NAME => L_API_NAME
1381: ,P_PKG_NAME => G_PKG_NAME

Line 1382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1378: p_data => x_msg_data);
1379: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1380: P_API_NAME => L_API_NAME
1381: ,P_PKG_NAME => G_PKG_NAME
1382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1383: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1384: ,P_SQLCODE => SQLCODE
1385: ,P_SQLERRM => SQLERRM
1386: ,X_MSG_COUNT => X_MSG_COUNT

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

1401: END IF;
1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1403: ROLLBACK TO svpt_reset_permissions;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1406: p_data => x_msg_data);
1407: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1408: P_API_NAME => L_API_NAME
1409: ,P_PKG_NAME => G_PKG_NAME

Line 1410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1406: p_data => x_msg_data);
1407: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1408: P_API_NAME => L_API_NAME
1409: ,P_PKG_NAME => G_PKG_NAME
1410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1411: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1412: ,P_SQLCODE => SQLCODE
1413: ,P_SQLERRM => SQLERRM
1414: ,X_MSG_COUNT => X_MSG_COUNT

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

1429: END IF;
1430: WHEN OTHERS THEN
1431: ROLLBACK TO svpt_reset_permissions;
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

1431: ROLLBACK TO svpt_reset_permissions;
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1438: p_data => x_msg_data);
1439: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

1433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1438: p_data => x_msg_data);
1439: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1440: P_API_NAME => L_API_NAME
1441: ,P_PKG_NAME => G_PKG_NAME

Line 1559: FND_MSG_PUB.ADD;

1555: l_api_name,
1556: G_PKG_NAME)
1557: THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: END IF;
1562: -- Initialize message list if p_init_msg_list is set to TRUE.
1563: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1564: FND_MSG_PUB.initialize;

1560: RAISE FND_API.G_EXC_ERROR;
1561: END IF;
1562: -- Initialize message list if p_init_msg_list is set to TRUE.
1563: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1564: FND_MSG_PUB.initialize;
1565: END IF;
1566:
1567: -- Initialize API return status to success
1568: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1715: COMMIT;
1716: END IF;
1717:
1718: -- Standard call to get message count and if count=1, get the message
1719: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1720: p_data => x_msg_data);
1721:
1722: IF IBC_DEBUG_PVT.debug_enabled THEN
1723: IBC_DEBUG_PVT.end_process(

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

1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: ROLLBACK TO svpt_override_permissions;
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1740: p_data => x_msg_data);
1741: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1742: P_API_NAME => L_API_NAME
1743: ,P_PKG_NAME => G_PKG_NAME

Line 1744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1740: p_data => x_msg_data);
1741: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1742: P_API_NAME => L_API_NAME
1743: ,P_PKG_NAME => G_PKG_NAME
1744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1745: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1746: ,P_SQLCODE => SQLCODE
1747: ,P_SQLERRM => SQLERRM
1748: ,X_MSG_COUNT => X_MSG_COUNT

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

1763: END IF;
1764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1765: ROLLBACK TO svpt_override_permissions;
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1767: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1768: p_data => x_msg_data);
1769: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1770: P_API_NAME => L_API_NAME
1771: ,P_PKG_NAME => G_PKG_NAME

Line 1772: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1768: p_data => x_msg_data);
1769: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1770: P_API_NAME => L_API_NAME
1771: ,P_PKG_NAME => G_PKG_NAME
1772: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1773: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
1774: ,P_SQLCODE => SQLCODE
1775: ,P_SQLERRM => SQLERRM
1776: ,X_MSG_COUNT => X_MSG_COUNT

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

1791: END IF;
1792: WHEN OTHERS THEN
1793: ROLLBACK TO svpt_override_permissions;
1794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1796: THEN
1797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

1793: ROLLBACK TO svpt_override_permissions;
1794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1796: THEN
1797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1796: THEN
1797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
1802: P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME

Line 1967: FND_MSG_PUB.ADD;

1963: l_api_name,
1964: G_PKG_NAME)
1965: THEN
1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970: -- Initialize message list if p_init_msg_list is set to TRUE.
1971: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1972: FND_MSG_PUB.initialize;

1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970: -- Initialize message list if p_init_msg_list is set to TRUE.
1971: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1972: FND_MSG_PUB.initialize;
1973: END IF;
1974:
1975: -- Initialize API return status to success
1976: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2015:
2016:
2017: -- Validate action
2018: IF p_action NOT IN ('ALLOW', 'RESTRICT') THEN
2019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2020: FND_MESSAGE.Set_Name('IBC', 'INVALID_PERMISSION_ACTION');
2021: FND_MSG_PUB.ADD;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;

Line 2021: FND_MSG_PUB.ADD;

2017: -- Validate action
2018: IF p_action NOT IN ('ALLOW', 'RESTRICT') THEN
2019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2020: FND_MESSAGE.Set_Name('IBC', 'INVALID_PERMISSION_ACTION');
2021: FND_MSG_PUB.ADD;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:

Line 2032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2028: p_permission_code);
2029: FETCH c_chk_permission_code INTO l_dummy;
2030: IF c_chk_permission_code%NOTFOUND THEN
2031: CLOSE c_chk_permission_code;
2032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2033: FND_MESSAGE.Set_Name('IBC', 'INVALID_PERMISSION_FOR_OBJECT');
2034: FND_MESSAGE.Set_token('PERMISSION_CODE', p_permission_code);
2035: FND_MESSAGE.Set_token('PERMISSION_OBJECT_ID', p_permission_object_id);
2036: FND_MSG_PUB.ADD;

Line 2036: FND_MSG_PUB.ADD;

2032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2033: FND_MESSAGE.Set_Name('IBC', 'INVALID_PERMISSION_FOR_OBJECT');
2034: FND_MESSAGE.Set_token('PERMISSION_CODE', p_permission_code);
2035: FND_MESSAGE.Set_token('PERMISSION_OBJECT_ID', p_permission_object_id);
2036: FND_MSG_PUB.ADD;
2037: END IF;
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040: CLOSE c_chk_permission_code;

Line 2062: FND_MSG_PUB.ADD;

2058: -- IF inheritance type is WSFOLDER then a grant is not allowed for this object
2059: -- it needs to be done at the container WORKSPACE
2060: IF l_inheritance_type = 'WSFOLDER' THEN
2061: FND_MESSAGE.Set_Name('IBC', 'IBC_WSFOLDER_NO_GRANT_ALLOWED');
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: END IF;
2065:
2066: IF l_object_grant_group_id IS NULL OR

Line 2104: FND_MSG_PUB.ADD;

2100: -- IF inheritance type is WSFOLDER then a grant is not allowed for this object
2101: -- it needs to be done at the container WORKSPACE
2102: IF l_c_inheritance_type IN ('WORKSPACE', 'WSFOLDER') THEN
2103: FND_MESSAGE.Set_Name('IBC', 'IBC_WSFOLDER_NO_GRANT_ALLOWED');
2104: FND_MSG_PUB.ADD;
2105: RAISE FND_API.G_EXC_ERROR;
2106: END IF;
2107:
2108: -- Copy all rows from container object

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

2305: COMMIT;
2306: END IF;
2307:
2308: -- Standard call to get message count and if count=1, get the message
2309: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2310: p_data => x_msg_data);
2311:
2312: IF IBC_DEBUG_PVT.debug_enabled THEN
2313: IBC_DEBUG_PVT.end_process(

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

2325: EXCEPTION
2326: WHEN FND_API.G_EXC_ERROR THEN
2327: ROLLBACK TO svpt_grant_permission;
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2330: p_data => x_msg_data);
2331: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2332: P_API_NAME => L_API_NAME
2333: ,P_PKG_NAME => G_PKG_NAME

Line 2334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

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

2353: END IF;
2354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2355: ROLLBACK TO svpt_grant_permission;
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2358: p_data => x_msg_data);
2359: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2360: P_API_NAME => L_API_NAME
2361: ,P_PKG_NAME => G_PKG_NAME

Line 2362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2358: p_data => x_msg_data);
2359: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2360: P_API_NAME => L_API_NAME
2361: ,P_PKG_NAME => G_PKG_NAME
2362: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2363: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
2364: ,P_SQLCODE => SQLCODE
2365: ,P_SQLERRM => SQLERRM
2366: ,X_MSG_COUNT => X_MSG_COUNT

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

2381: END IF;
2382: WHEN OTHERS THEN
2383: ROLLBACK TO svpt_grant_permission;
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2388: END IF;
2389: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

2383: ROLLBACK TO svpt_grant_permission;
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2388: END IF;
2389: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2390: p_data => x_msg_data);
2391: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

2385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2388: END IF;
2389: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2390: p_data => x_msg_data);
2391: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2392: P_API_NAME => L_API_NAME
2393: ,P_PKG_NAME => G_PKG_NAME

Line 2721: FND_MSG_PUB.ADD;

2717: l_api_name,
2718: G_PKG_NAME)
2719: THEN
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: FND_MSG_PUB.ADD;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724: -- Initialize message list if p_init_msg_list is set to TRUE.
2725: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2726: FND_MSG_PUB.initialize;

2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724: -- Initialize message list if p_init_msg_list is set to TRUE.
2725: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2726: FND_MSG_PUB.initialize;
2727: END IF;
2728:
2729: -- Initialize API return status to success
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3015: COMMIT;
3016: END IF;
3017:
3018: -- Standard call to get message count and if count=1, get the message
3019: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3020: p_data => x_msg_data);
3021:
3022: IF IBC_DEBUG_PVT.debug_enabled THEN
3023: IBC_DEBUG_PVT.end_process(

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

3035: EXCEPTION
3036: WHEN FND_API.G_EXC_ERROR THEN
3037: ROLLBACK TO svpt_revoke_permission;
3038: x_return_status := FND_API.G_RET_STS_ERROR;
3039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3040: p_data => x_msg_data);
3041: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3042: P_API_NAME => L_API_NAME
3043: ,P_PKG_NAME => G_PKG_NAME

Line 3044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3040: p_data => x_msg_data);
3041: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3042: P_API_NAME => L_API_NAME
3043: ,P_PKG_NAME => G_PKG_NAME
3044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3045: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3046: ,P_SQLCODE => SQLCODE
3047: ,P_SQLERRM => SQLERRM
3048: ,X_MSG_COUNT => X_MSG_COUNT

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

3063: END IF;
3064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3065: ROLLBACK TO svpt_revoke_permission;
3066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3067: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3068: p_data => x_msg_data);
3069: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3070: P_API_NAME => L_API_NAME
3071: ,P_PKG_NAME => G_PKG_NAME

Line 3072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3068: p_data => x_msg_data);
3069: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3070: P_API_NAME => L_API_NAME
3071: ,P_PKG_NAME => G_PKG_NAME
3072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3073: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3074: ,P_SQLCODE => SQLCODE
3075: ,P_SQLERRM => SQLERRM
3076: ,X_MSG_COUNT => X_MSG_COUNT

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

3091: END IF;
3092: WHEN OTHERS THEN
3093: ROLLBACK TO svpt_revoke_permission;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3096: THEN
3097: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3098: END IF;
3099: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

3093: ROLLBACK TO svpt_revoke_permission;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3096: THEN
3097: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3098: END IF;
3099: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3100: p_data => x_msg_data);
3101: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

3095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3096: THEN
3097: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3098: END IF;
3099: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3100: p_data => x_msg_data);
3101: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3102: P_API_NAME => L_API_NAME
3103: ,P_PKG_NAME => G_PKG_NAME

Line 3802: FND_MSG_PUB.ADD;

3798: l_api_name,
3799: G_PKG_NAME)
3800: THEN
3801: x_return_status := FND_API.G_RET_STS_ERROR;
3802: FND_MSG_PUB.ADD;
3803: RAISE FND_API.G_EXC_ERROR;
3804: END IF;
3805: -- Initialize message list if p_init_msg_list is set to TRUE.
3806: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3807: FND_MSG_PUB.initialize;

3803: RAISE FND_API.G_EXC_ERROR;
3804: END IF;
3805: -- Initialize message list if p_init_msg_list is set to TRUE.
3806: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3807: FND_MSG_PUB.initialize;
3808: END IF;
3809:
3810: -- Initialize API return status to success
3811: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3890: END LOOP;
3891: END IF;
3892:
3893: -- Standard call to get message count and if count=1, get the message
3894: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3895: p_data => x_msg_data);
3896: EXCEPTION
3897: WHEN FND_API.G_EXC_ERROR THEN
3898: x_return_status := FND_API.G_RET_STS_ERROR;

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

3895: p_data => x_msg_data);
3896: EXCEPTION
3897: WHEN FND_API.G_EXC_ERROR THEN
3898: x_return_status := FND_API.G_RET_STS_ERROR;
3899: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3900: p_data => x_msg_data);
3901: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3902: P_API_NAME => L_API_NAME
3903: ,P_PKG_NAME => G_PKG_NAME

Line 3904: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3900: p_data => x_msg_data);
3901: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3902: P_API_NAME => L_API_NAME
3903: ,P_PKG_NAME => G_PKG_NAME
3904: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3905: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3906: ,P_SQLCODE => SQLCODE
3907: ,P_SQLERRM => SQLERRM
3908: ,X_MSG_COUNT => X_MSG_COUNT

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

3910: ,X_RETURN_STATUS => X_RETURN_STATUS
3911: );
3912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3914: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3915: p_data => x_msg_data);
3916: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3917: P_API_NAME => L_API_NAME
3918: ,P_PKG_NAME => G_PKG_NAME

Line 3919: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3915: p_data => x_msg_data);
3916: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3917: P_API_NAME => L_API_NAME
3918: ,P_PKG_NAME => G_PKG_NAME
3919: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3920: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
3921: ,P_SQLCODE => SQLCODE
3922: ,P_SQLERRM => SQLERRM
3923: ,X_MSG_COUNT => X_MSG_COUNT

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

3925: ,X_RETURN_STATUS => X_RETURN_STATUS
3926: );
3927: WHEN OTHERS THEN
3928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3930: THEN
3931: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3932: END IF;
3933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

3927: WHEN OTHERS THEN
3928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3930: THEN
3931: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3932: END IF;
3933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3934: p_data => x_msg_data);
3935: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3930: THEN
3931: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3932: END IF;
3933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3934: p_data => x_msg_data);
3935: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
3936: P_API_NAME => L_API_NAME
3937: ,P_PKG_NAME => G_PKG_NAME

Line 4155: FND_MSG_PUB.ADD;

4151: l_api_name,
4152: G_PKG_NAME)
4153: THEN
4154: x_return_status := FND_API.G_RET_STS_ERROR;
4155: FND_MSG_PUB.ADD;
4156: RAISE FND_API.G_EXC_ERROR;
4157: END IF;
4158: -- Initialize message list if p_init_msg_list is set to TRUE.
4159: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4160: FND_MSG_PUB.initialize;

4156: RAISE FND_API.G_EXC_ERROR;
4157: END IF;
4158: -- Initialize message list if p_init_msg_list is set to TRUE.
4159: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4160: FND_MSG_PUB.initialize;
4161: END IF;
4162:
4163: -- Initialize API return status to success
4164: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4284:
4285: x_usernames := l_result;
4286:
4287: -- Standard call to get message count and if count=1, get the message
4288: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4289: p_data => x_msg_data);
4290:
4291: IF IBC_DEBUG_PVT.debug_enabled THEN
4292: IBC_DEBUG_PVT.end_process(

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

4304:
4305: EXCEPTION
4306: WHEN FND_API.G_EXC_ERROR THEN
4307: x_return_status := FND_API.G_RET_STS_ERROR;
4308: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4309: p_data => x_msg_data);
4310: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4311: P_API_NAME => L_API_NAME
4312: ,P_PKG_NAME => G_PKG_NAME

Line 4313: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4309: p_data => x_msg_data);
4310: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4311: P_API_NAME => L_API_NAME
4312: ,P_PKG_NAME => G_PKG_NAME
4313: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4314: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4315: ,P_SQLCODE => SQLCODE
4316: ,P_SQLERRM => SQLERRM
4317: ,X_MSG_COUNT => X_MSG_COUNT

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

4331: );
4332: END IF;
4333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4335: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4336: p_data => x_msg_data);
4337: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4338: P_API_NAME => L_API_NAME
4339: ,P_PKG_NAME => G_PKG_NAME

Line 4340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4336: p_data => x_msg_data);
4337: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4338: P_API_NAME => L_API_NAME
4339: ,P_PKG_NAME => G_PKG_NAME
4340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4341: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4342: ,P_SQLCODE => SQLCODE
4343: ,P_SQLERRM => SQLERRM
4344: ,X_MSG_COUNT => X_MSG_COUNT

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

4358: );
4359: END IF;
4360: WHEN OTHERS THEN
4361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4363: THEN
4364: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4365: END IF;
4366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

4360: WHEN OTHERS THEN
4361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4363: THEN
4364: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4365: END IF;
4366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4367: p_data => x_msg_data);
4368: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

4362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4363: THEN
4364: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4365: END IF;
4366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4367: p_data => x_msg_data);
4368: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4369: P_API_NAME => L_API_NAME
4370: ,P_PKG_NAME => G_PKG_NAME

Line 4500: FND_MSG_PUB.ADD;

4496: l_api_name,
4497: G_PKG_NAME)
4498: THEN
4499: x_return_status := FND_API.G_RET_STS_ERROR;
4500: FND_MSG_PUB.ADD;
4501: RAISE FND_API.G_EXC_ERROR;
4502: END IF;
4503: -- Initialize message list if p_init_msg_list is set to TRUE.
4504: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4505: FND_MSG_PUB.initialize;

4501: RAISE FND_API.G_EXC_ERROR;
4502: END IF;
4503: -- Initialize message list if p_init_msg_list is set to TRUE.
4504: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4505: FND_MSG_PUB.initialize;
4506: END IF;
4507:
4508: -- Initialize API return status to success
4509: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4590: END LOOP;
4591: END IF;
4592:
4593: -- Standard call to get message count and if count=1, get the message
4594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4595: p_data => x_msg_data);
4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;

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

4595: p_data => x_msg_data);
4596: EXCEPTION
4597: WHEN FND_API.G_EXC_ERROR THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4600: p_data => x_msg_data);
4601: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4602: P_API_NAME => L_API_NAME
4603: ,P_PKG_NAME => G_PKG_NAME

Line 4604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4600: p_data => x_msg_data);
4601: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4602: P_API_NAME => L_API_NAME
4603: ,P_PKG_NAME => G_PKG_NAME
4604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4605: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4606: ,P_SQLCODE => SQLCODE
4607: ,P_SQLERRM => SQLERRM
4608: ,X_MSG_COUNT => X_MSG_COUNT

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

4610: ,X_RETURN_STATUS => X_RETURN_STATUS
4611: );
4612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4615: p_data => x_msg_data);
4616: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4617: P_API_NAME => L_API_NAME
4618: ,P_PKG_NAME => G_PKG_NAME

Line 4619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4615: p_data => x_msg_data);
4616: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4617: P_API_NAME => L_API_NAME
4618: ,P_PKG_NAME => G_PKG_NAME
4619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4620: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4621: ,P_SQLCODE => SQLCODE
4622: ,P_SQLERRM => SQLERRM
4623: ,X_MSG_COUNT => X_MSG_COUNT

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

4625: ,X_RETURN_STATUS => X_RETURN_STATUS
4626: );
4627: WHEN OTHERS THEN
4628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4630: THEN
4631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4632: END IF;
4633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

4627: WHEN OTHERS THEN
4628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4630: THEN
4631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4632: END IF;
4633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4634: p_data => x_msg_data);
4635: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

4629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4630: THEN
4631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4632: END IF;
4633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4634: p_data => x_msg_data);
4635: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4636: P_API_NAME => L_API_NAME
4637: ,P_PKG_NAME => G_PKG_NAME

Line 4723: FND_MSG_PUB.ADD;

4719: l_api_name,
4720: G_PKG_NAME)
4721: THEN
4722: x_return_status := FND_API.G_RET_STS_ERROR;
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_ERROR;
4725: END IF;
4726: -- Initialize message list if p_init_msg_list is set to TRUE.
4727: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4728: FND_MSG_PUB.initialize;

4724: RAISE FND_API.G_EXC_ERROR;
4725: END IF;
4726: -- Initialize message list if p_init_msg_list is set to TRUE.
4727: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4728: FND_MSG_PUB.initialize;
4729: END IF;
4730:
4731: -- Initialize API return status to success
4732: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4769: x_inherited_flag := l_inherited_flag;
4770: x_inheritance_type := l_inheritance_type;
4771:
4772: -- Standard call to get message count and if count=1, get the message
4773: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4774: p_data => x_msg_data);
4775: EXCEPTION
4776: WHEN FND_API.G_EXC_ERROR THEN
4777: x_return_status := FND_API.G_RET_STS_ERROR;

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

4774: p_data => x_msg_data);
4775: EXCEPTION
4776: WHEN FND_API.G_EXC_ERROR THEN
4777: x_return_status := FND_API.G_RET_STS_ERROR;
4778: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4779: p_data => x_msg_data);
4780: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4781: P_API_NAME => L_API_NAME
4782: ,P_PKG_NAME => G_PKG_NAME

Line 4783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4779: p_data => x_msg_data);
4780: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4781: P_API_NAME => L_API_NAME
4782: ,P_PKG_NAME => G_PKG_NAME
4783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4784: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4785: ,P_SQLCODE => SQLCODE
4786: ,P_SQLERRM => SQLERRM
4787: ,X_MSG_COUNT => X_MSG_COUNT

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

4789: ,X_RETURN_STATUS => X_RETURN_STATUS
4790: );
4791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4793: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4794: p_data => x_msg_data);
4795: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4796: P_API_NAME => L_API_NAME
4797: ,P_PKG_NAME => G_PKG_NAME

Line 4798: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4794: p_data => x_msg_data);
4795: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4796: P_API_NAME => L_API_NAME
4797: ,P_PKG_NAME => G_PKG_NAME
4798: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4799: ,P_PACKAGE_TYPE => IBC_UTILITIES_PVT.G_PVT
4800: ,P_SQLCODE => SQLCODE
4801: ,P_SQLERRM => SQLERRM
4802: ,X_MSG_COUNT => X_MSG_COUNT

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

4804: ,X_RETURN_STATUS => X_RETURN_STATUS
4805: );
4806: WHEN OTHERS THEN
4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4809: THEN
4810: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4811: END IF;
4812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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

4806: WHEN OTHERS THEN
4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4809: THEN
4810: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4811: END IF;
4812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4813: p_data => x_msg_data);
4814: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(

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

4808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4809: THEN
4810: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4811: END IF;
4812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4813: p_data => x_msg_data);
4814: IBC_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4815: P_API_NAME => L_API_NAME
4816: ,P_PKG_NAME => G_PKG_NAME