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

Line 236: IF FND_API.To_Boolean ( p_commit )

232: ) ;
233:
234: END IF;
235: --
236: IF FND_API.To_Boolean ( p_commit )
237: THEN
238: COMMIT ;
239: END IF ;
240: --

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS ;

238: COMMIT ;
239: END IF ;
240: --
241: -- Initialize API return status to success
242: x_return_status := FND_API.G_RET_STS_SUCCESS ;
243: --
244: -- Commenting out the Exception block to
245: -- propogate the exact exception back to
246: -- Web ADI.

Line 249: WHEN FND_API.G_EXC_ERROR THEN

245: -- propogate the exact exception back to
246: -- Web ADI.
247: -- Needs discussion.
248: /*EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO Upload_Hierarchy_Header ;
251: --
252: x_return_status := FND_API.G_RET_STS_ERROR ;
253: --

Line 252: x_return_status := FND_API.G_RET_STS_ERROR ;

248: /*EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO Upload_Hierarchy_Header ;
251: --
252: x_return_status := FND_API.G_RET_STS_ERROR ;
253: --
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

255: ( p_count => x_msg_count,
256: p_data => x_msg_data
257: ) ;
258: --
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Upload_Hierarchy_Header ;
261: --
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263: --

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

258: --
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Upload_Hierarchy_Header ;
261: --
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263: --
264: FND_MSG_PUB.Count_And_Get
265: ( p_count => x_msg_count,
266: p_data => x_msg_data

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

268: --
269: WHEN OTHERS THEN
270: ROLLBACK TO Upload_Hierarchy_Header ;
271: --
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: --
274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: FND_MSG_PUB.Add_Exc_Msg

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS ;

566: --
567: END ;
568: --
569: -- Initialize API return status to success
570: x_return_status := FND_API.G_RET_STS_SUCCESS ;
571: --
572: -- Commenting out the Exception block to
573: -- propogate the exact exception back to
574: -- Web ADI.

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

577: --
578: WHEN OTHERS THEN
579: ROLLBACK TO Insert_HierInfo_forTime_Dim ;
580: --
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
582: --
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

873: --
874: WHEN OTHERS THEN
875: ROLLBACK TO Upload_Hierarchy_Details ;
876: --
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
878: --
879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
880: THEN
881: FND_MSG_PUB.Add_Exc_Msg

Line 1139: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1135: ) ;
1136: --
1137: END IF ;
1138: --
1139: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1140: THEN
1141: RAISE FND_API.G_EXC_ERROR ;
1142: END IF ;
1143: --

Line 1141: RAISE FND_API.G_EXC_ERROR ;

1137: END IF ;
1138: --
1139: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1140: THEN
1141: RAISE FND_API.G_EXC_ERROR ;
1142: END IF ;
1143: --
1144: IF ( FND_API.To_Boolean (p_commit) )
1145: THEN

Line 1144: IF ( FND_API.To_Boolean (p_commit) )

1140: THEN
1141: RAISE FND_API.G_EXC_ERROR ;
1142: END IF ;
1143: --
1144: IF ( FND_API.To_Boolean (p_commit) )
1145: THEN
1146: COMMIT ;
1147: END IF ;
1148: --

Line 1150: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1146: COMMIT ;
1147: END IF ;
1148: --
1149: -- Initialize API return status to success
1150: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1151: --
1152: -- Commenting out the Exception block to
1153: -- propogate the exact exception back to
1154: -- Web ADI.

Line 1157: WHEN FND_API.G_EXC_ERROR THEN

1153: -- propogate the exact exception back to
1154: -- Web ADI.
1155: -- Needs discussion.
1156: /*EXCEPTION
1157: WHEN FND_API.G_EXC_ERROR THEN
1158: ROLLBACK TO Upload_Hierarchy_Details ;
1159: --
1160: x_return_status := FND_API.G_RET_STS_ERROR ;
1161: --

Line 1160: x_return_status := FND_API.G_RET_STS_ERROR ;

1156: /*EXCEPTION
1157: WHEN FND_API.G_EXC_ERROR THEN
1158: ROLLBACK TO Upload_Hierarchy_Details ;
1159: --
1160: x_return_status := FND_API.G_RET_STS_ERROR ;
1161: --
1162: FND_MSG_PUB.Count_And_Get
1163: ( p_count => x_msg_count,
1164: p_data => x_msg_data

Line 1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1163: ( p_count => x_msg_count,
1164: p_data => x_msg_data
1165: ) ;
1166: --
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO Upload_Hierarchy_Details ;
1169: --
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: --

Line 1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1166: --
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO Upload_Hierarchy_Details ;
1169: --
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: --
1172: FND_MSG_PUB.Count_And_Get
1173: ( p_count => x_msg_count,
1174: p_data => x_msg_data

Line 1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1176: --
1177: WHEN OTHERS THEN
1178: ROLLBACK TO Upload_Hierarchy_Details ;
1179: --
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1181: --
1182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1183: THEN
1184: FND_MSG_PUB.Add_Exc_Msg

Line 1310: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1306: g_global_val_tbl(1).dim_grp_disp_code :=
1307: g_global_val_tbl(1).group_use_code ;
1308: END IF ;
1309: --
1310: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1311: --
1312: -- Commenting out the Exception block to
1313: -- propogate the exact exception back to
1314: -- Web ADI.

Line 1317: WHEN FND_API.G_EXC_ERROR THEN

1313: -- propogate the exact exception back to
1314: -- Web ADI.
1315: -- Needs discussion.
1316: /*EXCEPTION
1317: WHEN FND_API.G_EXC_ERROR THEN
1318: ROLLBACK TO Populate_Dim_Metadata_Info ;
1319: --
1320: x_return_status := FND_API.G_RET_STS_ERROR ;
1321: --

Line 1320: x_return_status := FND_API.G_RET_STS_ERROR ;

1316: /*EXCEPTION
1317: WHEN FND_API.G_EXC_ERROR THEN
1318: ROLLBACK TO Populate_Dim_Metadata_Info ;
1319: --
1320: x_return_status := FND_API.G_RET_STS_ERROR ;
1321: --
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: ROLLBACK TO Populate_Dim_Metadata_Info ;
1324: --

Line 1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1318: ROLLBACK TO Populate_Dim_Metadata_Info ;
1319: --
1320: x_return_status := FND_API.G_RET_STS_ERROR ;
1321: --
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: ROLLBACK TO Populate_Dim_Metadata_Info ;
1324: --
1325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1326: --

Line 1325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1321: --
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: ROLLBACK TO Populate_Dim_Metadata_Info ;
1324: --
1325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1326: --
1327: WHEN OTHERS THEN
1328: ROLLBACK TO Populate_Dim_Metadata_Info ;
1329: --

Line 1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1326: --
1327: WHEN OTHERS THEN
1328: ROLLBACK TO Populate_Dim_Metadata_Info ;
1329: --
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1331: --*/
1332: END Populate_Dim_Metadata_Info ;
1333:
1334: -----------------------------

Line 1421: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1417: ( x_return_status => l_return_status
1418: , p_dimension_varchar_label => p_dimension_varchar_label
1419: ) ;
1420:
1421: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1422: THEN
1423: RAISE FND_API.G_EXC_ERROR ;
1424: END IF ;
1425: --

Line 1423: RAISE FND_API.G_EXC_ERROR ;

1419: ) ;
1420:
1421: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1422: THEN
1423: RAISE FND_API.G_EXC_ERROR ;
1424: END IF ;
1425: --
1426: END IF ;
1427: --

Line 1438: , p_init_msg_list => FND_API.g_false

1434: ( x_return_status => l_return_status
1435: , x_msg_count => l_msg_count
1436: , x_msg_data => l_msg_data
1437: , p_api_version => 1.0
1438: , p_init_msg_list => FND_API.g_false
1439: , p_commit => FND_API.g_false
1440: , p_intf_hierarchy_table_name =>
1441: g_global_val_tbl(1).hierarchy_intf_table_name
1442: , p_value_set_required_flag =>

Line 1439: , p_commit => FND_API.g_false

1435: , x_msg_count => l_msg_count
1436: , x_msg_data => l_msg_data
1437: , p_api_version => 1.0
1438: , p_init_msg_list => FND_API.g_false
1439: , p_commit => FND_API.g_false
1440: , p_intf_hierarchy_table_name =>
1441: g_global_val_tbl(1).hierarchy_intf_table_name
1442: , p_value_set_required_flag =>
1443: g_global_val_tbl(1).value_set_required_flag

Line 1459: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1455: , p_effective_end_date => p_effective_end_date
1456: , p_language => USERENV('LANG')
1457: ) ;
1458: --
1459: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1460: THEN
1461: RAISE FND_API.G_EXC_ERROR ;
1462: END IF ;
1463: --

Line 1461: RAISE FND_API.G_EXC_ERROR ;

1457: ) ;
1458: --
1459: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1460: THEN
1461: RAISE FND_API.G_EXC_ERROR ;
1462: END IF ;
1463: --
1464: -- Upload_Hierarchy_Header Done.
1465: --

Line 1473: , p_init_msg_list => FND_API.g_false

1469: ( x_return_status => l_return_status
1470: , x_msg_count => l_msg_count
1471: , x_msg_data => l_msg_data
1472: , p_api_version => 1.0
1473: , p_init_msg_list => FND_API.g_false
1474: , p_commit => FND_API.g_false
1475: , p_language => USERENV('LANG')
1476: , p_hierarchy_object_name => p_hierarchy_object_name
1477: , p_hierarchy_obj_def_disp_name => p_hierarchy_obj_def_disp_name

Line 1474: , p_commit => FND_API.g_false

1470: , x_msg_count => l_msg_count
1471: , x_msg_data => l_msg_data
1472: , p_api_version => 1.0
1473: , p_init_msg_list => FND_API.g_false
1474: , p_commit => FND_API.g_false
1475: , p_language => USERENV('LANG')
1476: , p_hierarchy_object_name => p_hierarchy_object_name
1477: , p_hierarchy_obj_def_disp_name => p_hierarchy_obj_def_disp_name
1478: , p_sequence_enforced_code => p_group_seq_enforced_code

Line 1485: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1481: NVL( p_parent_display_code, p_child_display_code )
1482: , p_child_display_code => p_child_display_code
1483: ) ;
1484:
1485: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1486: THEN
1487: RAISE FND_API.G_EXC_ERROR ;
1488: END IF ;
1489: --

Line 1487: RAISE FND_API.G_EXC_ERROR ;

1483: ) ;
1484:
1485: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1486: THEN
1487: RAISE FND_API.G_EXC_ERROR ;
1488: END IF ;
1489: --
1490: -- Upload_Hierarchy_Details Done.
1491: --