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.EGO_DATA_SECURITY dependencies on FND_API

Line 1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1122: ,p_message => 'Returning from set id''s '||l_has_priv
1123: );
1124: RETURN l_has_priv;
1125: ELSIF l_has_priv = G_RETURN_UNEXP_ERR THEN
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: ELSE
1128: l_instance_predicate_list :='(';
1129: l_set_id_cnt:=0;
1130: END IF;

Line 1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1146: p_dynamic_sql => l_dynamic_sql,
1147: p_instance_predicate_list => l_instance_predicate_list
1148: );
1149: IF l_has_priv = G_RETURN_UNEXP_ERR THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
1153: ,p_module => l_api_name
1154: ,p_message => 'Returning status '||l_has_priv

Line 1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1155: );
1156: RETURN l_has_priv;
1157: --bug 5027160.:END
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1160: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
1161: ,p_module => l_api_name
1162: ,p_message => 'Returning EXCEPTION '||SQLERRM
1163: );

Line 6231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

6227: ,p_child_obj_name IN VARCHAR2
6228: ,p_child_object_type IN VARCHAR2
6229: ,p_child_role_name IN VARCHAR2
6230: ,p_owner IN NUMBER
6231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6232: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6233: ,x_return_status OUT NOCOPY VARCHAR2
6234: ,x_errorcode OUT NOCOPY NUMBER
6235: ,x_msg_count OUT NOCOPY NUMBER

Line 6232: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE

6228: ,p_child_object_type IN VARCHAR2
6229: ,p_child_role_name IN VARCHAR2
6230: ,p_owner IN NUMBER
6231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6232: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6233: ,x_return_status OUT NOCOPY VARCHAR2
6234: ,x_errorcode OUT NOCOPY NUMBER
6235: ,x_msg_count OUT NOCOPY NUMBER
6236: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6271: IF FND_API.TO_BOOLEAN(p_commit) THEN

6267: ' - p_init_msg_list: '||p_init_msg_list||
6268: ' - p_commit: '||p_commit
6269: );
6270:
6271: IF FND_API.TO_BOOLEAN(p_commit) THEN
6272: -- Standard Start of API savepoint
6273: SAVEPOINT Create_Role_Mapping_PUB;
6274: END IF;
6275:

Line 6276: IF NOT FND_API.Compatible_API_Call (l_api_version,

6272: -- Standard Start of API savepoint
6273: SAVEPOINT Create_Role_Mapping_PUB;
6274: END IF;
6275:
6276: IF NOT FND_API.Compatible_API_Call (l_api_version,
6277: p_api_version,
6278: l_api_name,
6279: G_PKG_NAME)
6280: THEN

Line 6281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6277: p_api_version,
6278: l_api_name,
6279: G_PKG_NAME)
6280: THEN
6281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6282: END IF;
6283: -- Initialize API message list if necessary.
6284: -- Initialize message list if p_init_msg_list is set to TRUE.
6285: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 6285: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6282: END IF;
6283: -- Initialize API message list if necessary.
6284: -- Initialize message list if p_init_msg_list is set to TRUE.
6285: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6286: FND_MSG_PUB.initialize;
6287: END IF;
6288:
6289: IF (p_owner IS NULL OR p_owner = -1) THEN

Line 6328: IF FND_API.To_Boolean( p_commit ) THEN

6324: , FND_GLOBAL.Login_id
6325: );
6326:
6327: -- Standard check of p_commit.
6328: IF FND_API.To_Boolean( p_commit ) THEN
6329: COMMIT WORK;
6330: END IF;
6331:
6332: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6332: x_return_status := FND_API.G_RET_STS_SUCCESS;

6328: IF FND_API.To_Boolean( p_commit ) THEN
6329: COMMIT WORK;
6330: END IF;
6331:
6332: x_return_status := FND_API.G_RET_STS_SUCCESS;
6333:
6334: -----------------------------------
6335: -- Make a standard call to get message count
6336: -- and if count is 1, get message info.

Line 6357: WHEN FND_API.G_EXC_ERROR THEN

6353: ' - x_msg_data: '||x_msg_data
6354: );
6355:
6356: EXCEPTION
6357: WHEN FND_API.G_EXC_ERROR THEN
6358: IF FND_API.TO_BOOLEAN(p_commit) THEN
6359: ROLLBACK TO Create_Role_Mapping_PUB;
6360: END IF;
6361: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6358: IF FND_API.TO_BOOLEAN(p_commit) THEN

6354: );
6355:
6356: EXCEPTION
6357: WHEN FND_API.G_EXC_ERROR THEN
6358: IF FND_API.TO_BOOLEAN(p_commit) THEN
6359: ROLLBACK TO Create_Role_Mapping_PUB;
6360: END IF;
6361: x_return_status := FND_API.G_RET_STS_ERROR;
6362: FND_MSG_PUB.Count_And_Get

Line 6361: x_return_status := FND_API.G_RET_STS_ERROR;

6357: WHEN FND_API.G_EXC_ERROR THEN
6358: IF FND_API.TO_BOOLEAN(p_commit) THEN
6359: ROLLBACK TO Create_Role_Mapping_PUB;
6360: END IF;
6361: x_return_status := FND_API.G_RET_STS_ERROR;
6362: FND_MSG_PUB.Count_And_Get
6363: ( p_count => x_msg_count,
6364: p_data => x_msg_data
6365: );

Line 6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6371: ' - x_errorcode: '||x_errorcode||
6372: ' - x_msg_count: '||x_msg_count||
6373: ' - x_msg_data: '||x_msg_data
6374: );
6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6376: IF FND_API.TO_BOOLEAN(p_commit) THEN
6377: ROLLBACK TO Create_Function_PUB;
6378: END IF;
6379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6376: IF FND_API.TO_BOOLEAN(p_commit) THEN

6372: ' - x_msg_count: '||x_msg_count||
6373: ' - x_msg_data: '||x_msg_data
6374: );
6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6376: IF FND_API.TO_BOOLEAN(p_commit) THEN
6377: ROLLBACK TO Create_Function_PUB;
6378: END IF;
6379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6380: FND_MSG_PUB.Count_And_Get

Line 6379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6376: IF FND_API.TO_BOOLEAN(p_commit) THEN
6377: ROLLBACK TO Create_Function_PUB;
6378: END IF;
6379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6380: FND_MSG_PUB.Count_And_Get
6381: ( p_count => x_msg_count,
6382: p_data => x_msg_data
6383: );

Line 6394: IF FND_API.TO_BOOLEAN(p_commit) THEN

6390: ' - x_msg_count: '||x_msg_count||
6391: ' - x_msg_data: '||x_msg_data
6392: );
6393: WHEN OTHERS THEN
6394: IF FND_API.TO_BOOLEAN(p_commit) THEN
6395: ROLLBACK TO Create_Function_PUB;
6396: END IF;
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6398: IF FND_MSG_PUB.Check_Msg_Level

Line 6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6393: WHEN OTHERS THEN
6394: IF FND_API.TO_BOOLEAN(p_commit) THEN
6395: ROLLBACK TO Create_Function_PUB;
6396: END IF;
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6398: IF FND_MSG_PUB.Check_Msg_Level
6399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6400: THEN
6401: FND_MSG_PUB.Add_Exc_Msg

Line 6433: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

6429: ,p_parent_role_name IN VARCHAR2
6430: ,p_child_obj_name IN VARCHAR2
6431: ,p_child_object_type IN VARCHAR2
6432: ,p_child_role_name IN VARCHAR2
6433: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6434: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6435: ,x_return_status OUT NOCOPY VARCHAR2
6436: ,x_errorcode OUT NOCOPY NUMBER
6437: ,x_msg_count OUT NOCOPY NUMBER

Line 6434: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE

6430: ,p_child_obj_name IN VARCHAR2
6431: ,p_child_object_type IN VARCHAR2
6432: ,p_child_role_name IN VARCHAR2
6433: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6434: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6435: ,x_return_status OUT NOCOPY VARCHAR2
6436: ,x_errorcode OUT NOCOPY NUMBER
6437: ,x_msg_count OUT NOCOPY NUMBER
6438: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6493: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

6489: ,p_child_obj_name IN VARCHAR2
6490: ,p_child_object_type IN VARCHAR2
6491: ,p_child_role_name IN VARCHAR2
6492: ,p_owner IN NUMBER
6493: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6494: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6495: ,x_return_status OUT NOCOPY VARCHAR2
6496: ,x_errorcode OUT NOCOPY NUMBER
6497: ,x_msg_count OUT NOCOPY NUMBER

Line 6494: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE

6490: ,p_child_object_type IN VARCHAR2
6491: ,p_child_role_name IN VARCHAR2
6492: ,p_owner IN NUMBER
6493: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6494: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6495: ,x_return_status OUT NOCOPY VARCHAR2
6496: ,x_errorcode OUT NOCOPY NUMBER
6497: ,x_msg_count OUT NOCOPY NUMBER
6498: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6534: IF FND_API.TO_BOOLEAN(p_commit) THEN

6530: ' - p_owner: '||p_owner||
6531: ' - p_init_msg_list: '||p_init_msg_list||
6532: ' - p_commit: '||p_commit
6533: );
6534: IF FND_API.TO_BOOLEAN(p_commit) THEN
6535: -- Standard Start of API savepoint
6536: SAVEPOINT Update_Role_Mapping_PUB;
6537: END IF;
6538:

Line 6541: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6537: END IF;
6538:
6539: -- Initialize API message list if necessary.
6540: -- Initialize message list if p_init_msg_list is set to TRUE.
6541: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6542: FND_MSG_PUB.initialize;
6543: END IF;
6544:
6545: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 6545: IF NOT FND_API.Compatible_API_Call (l_api_version,

6541: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6542: FND_MSG_PUB.initialize;
6543: END IF;
6544:
6545: IF NOT FND_API.Compatible_API_Call (l_api_version,
6546: p_api_version,
6547: l_api_name,
6548: G_PKG_NAME)
6549: THEN

Line 6550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6546: p_api_version,
6547: l_api_name,
6548: G_PKG_NAME)
6549: THEN
6550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6551: END IF;
6552:
6553: IF (p_owner IS NULL OR p_owner = -1) THEN
6554: l_owner := EGO_SCTX.get_user_id();

Line 6605: IF FND_API.To_Boolean( p_commit ) THEN

6601: ,p_message => 'After updating role mappings'
6602: );
6603:
6604: -- Standard check of p_commit.
6605: IF FND_API.To_Boolean( p_commit ) THEN
6606: COMMIT WORK;
6607: END IF;
6608:
6609: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 6613: x_return_status := FND_API.G_RET_STS_SUCCESS;

6609: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT
6610: ,p_module => l_api_name
6611: ,p_message => 'After committing the data'
6612: );
6613: x_return_status := FND_API.G_RET_STS_SUCCESS;
6614:
6615: -- Make a standard call to get message count
6616: -- and if count is 1, get message info.
6617: -- The client will directly display the x_msg_data (which is already

Line 6638: WHEN FND_API.G_EXC_ERROR THEN

6634: ' - x_msg_data: '||x_msg_data
6635: );
6636:
6637: EXCEPTION
6638: WHEN FND_API.G_EXC_ERROR THEN
6639: IF FND_API.TO_BOOLEAN(p_commit) THEN
6640: ROLLBACK TO Update_Role_Mapping_PUB;
6641: END IF;
6642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6639: IF FND_API.TO_BOOLEAN(p_commit) THEN

6635: );
6636:
6637: EXCEPTION
6638: WHEN FND_API.G_EXC_ERROR THEN
6639: IF FND_API.TO_BOOLEAN(p_commit) THEN
6640: ROLLBACK TO Update_Role_Mapping_PUB;
6641: END IF;
6642: x_return_status := FND_API.G_RET_STS_ERROR;
6643: FND_MSG_PUB.Count_And_Get

Line 6642: x_return_status := FND_API.G_RET_STS_ERROR;

6638: WHEN FND_API.G_EXC_ERROR THEN
6639: IF FND_API.TO_BOOLEAN(p_commit) THEN
6640: ROLLBACK TO Update_Role_Mapping_PUB;
6641: END IF;
6642: x_return_status := FND_API.G_RET_STS_ERROR;
6643: FND_MSG_PUB.Count_And_Get
6644: ( p_count => x_msg_count,
6645: p_data => x_msg_data
6646: );

Line 6656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6652: ' - x_errorcode: '||x_errorcode||
6653: ' - x_msg_count: '||x_msg_count||
6654: ' - x_msg_data: '||x_msg_data
6655: );
6656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6657: IF FND_API.TO_BOOLEAN(p_commit) THEN
6658: ROLLBACK TO Update_Role_Mapping_PUB;
6659: END IF;
6660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6657: IF FND_API.TO_BOOLEAN(p_commit) THEN

6653: ' - x_msg_count: '||x_msg_count||
6654: ' - x_msg_data: '||x_msg_data
6655: );
6656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6657: IF FND_API.TO_BOOLEAN(p_commit) THEN
6658: ROLLBACK TO Update_Role_Mapping_PUB;
6659: END IF;
6660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6661: FND_MSG_PUB.Count_And_Get

Line 6660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6657: IF FND_API.TO_BOOLEAN(p_commit) THEN
6658: ROLLBACK TO Update_Role_Mapping_PUB;
6659: END IF;
6660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6661: FND_MSG_PUB.Count_And_Get
6662: ( p_count => x_msg_count,
6663: p_data => x_msg_data
6664: );

Line 6675: IF FND_API.TO_BOOLEAN(p_commit) THEN

6671: ' - x_msg_count: '||x_msg_count||
6672: ' - x_msg_data: '||x_msg_data
6673: );
6674: WHEN OTHERS THEN
6675: IF FND_API.TO_BOOLEAN(p_commit) THEN
6676: ROLLBACK TO Update_Role_Mapping_PUB;
6677: END IF;
6678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6679: IF FND_MSG_PUB.Check_Msg_Level

Line 6678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6674: WHEN OTHERS THEN
6675: IF FND_API.TO_BOOLEAN(p_commit) THEN
6676: ROLLBACK TO Update_Role_Mapping_PUB;
6677: END IF;
6678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6679: IF FND_MSG_PUB.Check_Msg_Level
6680: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6681: THEN
6682: FND_MSG_PUB.Add_Exc_Msg

Line 6713: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

6709: ,p_parent_role_name IN VARCHAR2
6710: ,p_child_obj_name IN VARCHAR2
6711: ,p_child_object_type IN VARCHAR2
6712: ,p_child_role_name IN VARCHAR2
6713: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6714: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6715: ,x_return_status OUT NOCOPY VARCHAR2
6716: ,x_errorcode OUT NOCOPY NUMBER
6717: ,x_msg_count OUT NOCOPY NUMBER

Line 6714: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE

6710: ,p_child_obj_name IN VARCHAR2
6711: ,p_child_object_type IN VARCHAR2
6712: ,p_child_role_name IN VARCHAR2
6713: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6714: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6715: ,x_return_status OUT NOCOPY VARCHAR2
6716: ,x_errorcode OUT NOCOPY NUMBER
6717: ,x_msg_count OUT NOCOPY NUMBER
6718: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6771: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

6767: ,p_parent_obj_name IN VARCHAR2
6768: ,p_parent_role_name IN VARCHAR2
6769: ,p_child_obj_name IN VARCHAR2
6770: ,p_child_object_type IN VARCHAR2
6771: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6772: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6773: ,x_return_status OUT NOCOPY VARCHAR2
6774: ,x_errorcode OUT NOCOPY NUMBER
6775: ,x_msg_count OUT NOCOPY NUMBER

Line 6772: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE

6768: ,p_parent_role_name IN VARCHAR2
6769: ,p_child_obj_name IN VARCHAR2
6770: ,p_child_object_type IN VARCHAR2
6771: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
6772: ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
6773: ,x_return_status OUT NOCOPY VARCHAR2
6774: ,x_errorcode OUT NOCOPY NUMBER
6775: ,x_msg_count OUT NOCOPY NUMBER
6776: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6809: IF FND_API.TO_BOOLEAN(p_commit) THEN

6805: ' - p_init_msg_list: '||p_init_msg_list||
6806: ' - p_commit: '||p_commit
6807: );
6808:
6809: IF FND_API.TO_BOOLEAN(p_commit) THEN
6810: -- Standard Start of API savepoint
6811: SAVEPOINT Delete_Role_Mapping_PUB;
6812: END IF;
6813:

Line 6816: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6812: END IF;
6813:
6814: -- Initialize API message list if necessary.
6815: -- Initialize message list if p_init_msg_list is set to TRUE.
6816: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6817: FND_MSG_PUB.initialize;
6818: END IF;
6819:
6820: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 6820: IF NOT FND_API.Compatible_API_Call (l_api_version,

6816: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6817: FND_MSG_PUB.initialize;
6818: END IF;
6819:
6820: IF NOT FND_API.Compatible_API_Call (l_api_version,
6821: p_api_version,
6822: l_api_name,
6823: G_PKG_NAME)
6824: THEN

Line 6825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6821: p_api_version,
6822: l_api_name,
6823: G_PKG_NAME)
6824: THEN
6825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6826: END IF;
6827:
6828: l_parent_obj_id := get_object_id(p_object_name => p_parent_obj_name);
6829: l_child_obj_id := get_object_id(p_object_name => p_child_obj_name);

Line 6857: IF FND_API.To_Boolean( p_commit ) THEN

6853: CHILD_OBJECT_TYPE is null;
6854: END IF;
6855:
6856: -- Standard check of p_commit.
6857: IF FND_API.To_Boolean( p_commit ) THEN
6858: COMMIT WORK;
6859: END IF;
6860:
6861: code_debug (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 6866: x_return_status := FND_API.G_RET_STS_SUCCESS;

6862: ,p_module => l_api_name
6863: ,p_message => 'After committing the data'
6864: );
6865:
6866: x_return_status := FND_API.G_RET_STS_SUCCESS;
6867:
6868: -- Make a standard call to get message count and if count is 1,
6869: -- get message info.
6870:

Line 6885: WHEN FND_API.G_EXC_ERROR THEN

6881: ' - x_msg_data: '||x_msg_data
6882: );
6883:
6884: EXCEPTION
6885: WHEN FND_API.G_EXC_ERROR THEN
6886: IF FND_API.TO_BOOLEAN(p_commit) THEN
6887: ROLLBACK TO Delete_Role_Mapping_PUB;
6888: END IF;
6889: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6886: IF FND_API.TO_BOOLEAN(p_commit) THEN

6882: );
6883:
6884: EXCEPTION
6885: WHEN FND_API.G_EXC_ERROR THEN
6886: IF FND_API.TO_BOOLEAN(p_commit) THEN
6887: ROLLBACK TO Delete_Role_Mapping_PUB;
6888: END IF;
6889: x_return_status := FND_API.G_RET_STS_ERROR;
6890: FND_MSG_PUB.Count_And_Get

Line 6889: x_return_status := FND_API.G_RET_STS_ERROR;

6885: WHEN FND_API.G_EXC_ERROR THEN
6886: IF FND_API.TO_BOOLEAN(p_commit) THEN
6887: ROLLBACK TO Delete_Role_Mapping_PUB;
6888: END IF;
6889: x_return_status := FND_API.G_RET_STS_ERROR;
6890: FND_MSG_PUB.Count_And_Get
6891: ( p_count => x_msg_count,
6892: p_data => x_msg_data
6893: );

Line 6903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6899: ' - x_errorcode: '||x_errorcode||
6900: ' - x_msg_count: '||x_msg_count||
6901: ' - x_msg_data: '||x_msg_data
6902: );
6903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6904: IF FND_API.TO_BOOLEAN(p_commit) THEN
6905: ROLLBACK TO Delete_Role_Mapping_PUB;
6906: END IF;
6907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6904: IF FND_API.TO_BOOLEAN(p_commit) THEN

6900: ' - x_msg_count: '||x_msg_count||
6901: ' - x_msg_data: '||x_msg_data
6902: );
6903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6904: IF FND_API.TO_BOOLEAN(p_commit) THEN
6905: ROLLBACK TO Delete_Role_Mapping_PUB;
6906: END IF;
6907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6908: FND_MSG_PUB.Count_And_Get

Line 6907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6904: IF FND_API.TO_BOOLEAN(p_commit) THEN
6905: ROLLBACK TO Delete_Role_Mapping_PUB;
6906: END IF;
6907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6908: FND_MSG_PUB.Count_And_Get
6909: ( p_count => x_msg_count,
6910: p_data => x_msg_data
6911: );

Line 6922: IF FND_API.TO_BOOLEAN(p_commit) THEN

6918: ' - x_msg_count: '||x_msg_count||
6919: ' - x_msg_data: '||x_msg_data
6920: );
6921: WHEN OTHERS THEN
6922: IF FND_API.TO_BOOLEAN(p_commit) THEN
6923: ROLLBACK TO Delete_Role_Mapping_PUB;
6924: END IF;
6925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6926: IF FND_MSG_PUB.Check_Msg_Level

Line 6925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6921: WHEN OTHERS THEN
6922: IF FND_API.TO_BOOLEAN(p_commit) THEN
6923: ROLLBACK TO Delete_Role_Mapping_PUB;
6924: END IF;
6925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6926: IF FND_MSG_PUB.Check_Msg_Level
6927: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6928: THEN
6929: FND_MSG_PUB.Add_Exc_Msg