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_MEMBER_UTILS_PVT dependencies on FND_API

Line 137: IF NOT FND_API.Compatible_API_Call ( l_api_version,

133:
134: --
135: SAVEPOINT Dim_Intf_Common_Cols_Pvt ;
136: --
137: IF NOT FND_API.Compatible_API_Call ( l_api_version,
138: p_api_version,
139: l_api_name,
140: G_PKG_NAME )
141: THEN

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

138: p_api_version,
139: l_api_name,
140: G_PKG_NAME )
141: THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
143: END IF;
144: --
145:
146: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 146: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
143: END IF;
144: --
145:
146: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
147: FND_MSG_PUB.initialize ;
148: END IF;
149: --
150: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS ;

146: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
147: FND_MSG_PUB.initialize ;
148: END IF;
149: --
150: x_return_status := FND_API.G_RET_STS_SUCCESS ;
151: --
152:
153: -----------------------------------------------------------------------------
154: -- Set up plsql table for interface column definition

Line 566: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN

562: AND M2.LANGUAGE_CODE (+)= L.LANGUAGE_CODE;
563:
564: END LOOP;
565:
566: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN
567: COMMIT;
568: END IF;
569:
570:

Line 573: WHEN FND_API.G_EXC_ERROR THEN

569:
570:
571: EXCEPTION
572: --
573: WHEN FND_API.G_EXC_ERROR THEN
574: --
575: ROLLBACK TO Dim_Intf_Common_Cols_Pvt ;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 576: x_return_status := FND_API.G_RET_STS_ERROR;

572: --
573: WHEN FND_API.G_EXC_ERROR THEN
574: --
575: ROLLBACK TO Dim_Intf_Common_Cols_Pvt ;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
578: p_data => x_msg_data );
579: --
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

576: x_return_status := FND_API.G_RET_STS_ERROR;
577: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
578: p_data => x_msg_data );
579: --
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: --
582: ROLLBACK TO Dim_Intf_Common_Cols_Pvt ;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: --
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: --
582: ROLLBACK TO Dim_Intf_Common_Cols_Pvt ;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
585: p_data => x_msg_data );
586: --
587: WHEN OTHERS THEN

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

586: --
587: WHEN OTHERS THEN
588: --
589: ROLLBACK TO Dim_Intf_Common_Cols_Pvt ;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: --
592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
593: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
594: l_api_name);

Line 701: IF NOT FND_API.Compatible_API_Call ( l_api_version,

697:
698: --
699: SAVEPOINT Dim_Intf_Attr_Cols_Pvt ;
700: --
701: IF NOT FND_API.Compatible_API_Call ( l_api_version,
702: p_api_version,
703: l_api_name,
704: G_PKG_NAME )
705: THEN

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

702: p_api_version,
703: l_api_name,
704: G_PKG_NAME )
705: THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
707: END IF;
708: --
709:
710: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 710: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
707: END IF;
708: --
709:
710: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
711: FND_MSG_PUB.initialize ;
712: END IF;
713: --
714: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 714: x_return_status := FND_API.G_RET_STS_SUCCESS ;

710: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
711: FND_MSG_PUB.initialize ;
712: END IF;
713: --
714: x_return_status := FND_API.G_RET_STS_SUCCESS ;
715: --
716:
717: x_updated_flag := 'N';
718:

Line 1388: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN

1384: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1385:
1386: END LOOP;
1387:
1388: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN
1389: COMMIT;
1390: END IF;
1391:
1392: EXCEPTION

Line 1394: WHEN FND_API.G_EXC_ERROR THEN

1390: END IF;
1391:
1392: EXCEPTION
1393: --
1394: WHEN FND_API.G_EXC_ERROR THEN
1395: --
1396: ROLLBACK TO Dim_Intf_Attr_Cols_Pvt ;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393: --
1394: WHEN FND_API.G_EXC_ERROR THEN
1395: --
1396: ROLLBACK TO Dim_Intf_Attr_Cols_Pvt ;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1399: p_data => x_msg_data );
1400: --
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1399: p_data => x_msg_data );
1400: --
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: --
1403: ROLLBACK TO Dim_Intf_Attr_Cols_Pvt ;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1400: --
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: --
1403: ROLLBACK TO Dim_Intf_Attr_Cols_Pvt ;
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: --
1408: WHEN OTHERS THEN

Line 1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1407: --
1408: WHEN OTHERS THEN
1409: --
1410: ROLLBACK TO Dim_Intf_Attr_Cols_Pvt ;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: --
1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1415: l_api_name);

Line 1474: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1470: BEGIN
1471: --
1472: SAVEPOINT Dim_Layout_Pvt ;
1473: --
1474: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1475: p_api_version,
1476: l_api_name,
1477: G_PKG_NAME )
1478: THEN

Line 1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1475: p_api_version,
1476: l_api_name,
1477: G_PKG_NAME )
1478: THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1480: END IF;
1481: --
1482:
1483: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1483: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1480: END IF;
1481: --
1482:
1483: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1484: FND_MSG_PUB.initialize ;
1485: END IF;
1486: --
1487: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1487: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1483: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1484: FND_MSG_PUB.initialize ;
1485: END IF;
1486: --
1487: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1488: --
1489: l_layout_code := p_object_code || '_LAYOUT';
1490:
1491: BEGIN

Line 2239: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN

2235: AND LC.INTERFACE_CODE = IC.INTERFACE_CODE
2236: AND LC.INTERFACE_SEQ_NUM = IC. SEQUENCE_NUM
2237: );
2238:
2239: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN
2240: COMMIT;
2241: END IF;
2242:
2243: EXCEPTION

Line 2245: WHEN FND_API.G_EXC_ERROR THEN

2241: END IF;
2242:
2243: EXCEPTION
2244: --
2245: WHEN FND_API.G_EXC_ERROR THEN
2246: --
2247: ROLLBACK TO Dim_Layout_Pvt ;
2248: x_return_status := FND_API.G_RET_STS_ERROR;
2249: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2248: x_return_status := FND_API.G_RET_STS_ERROR;

2244: --
2245: WHEN FND_API.G_EXC_ERROR THEN
2246: --
2247: ROLLBACK TO Dim_Layout_Pvt ;
2248: x_return_status := FND_API.G_RET_STS_ERROR;
2249: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2250: p_data => x_msg_data );
2251: --
2252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2248: x_return_status := FND_API.G_RET_STS_ERROR;
2249: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2250: p_data => x_msg_data );
2251: --
2252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2253: --
2254: ROLLBACK TO Dim_Layout_Pvt ;
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2251: --
2252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2253: --
2254: ROLLBACK TO Dim_Layout_Pvt ;
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2257: p_data => x_msg_data );
2258: --
2259: WHEN OTHERS THEN

Line 2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2258: --
2259: WHEN OTHERS THEN
2260: --
2261: ROLLBACK TO Dim_Layout_Pvt ;
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2263: --
2264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2265: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2266: l_api_name);

Line 2326: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2322: BEGIN
2323: --
2324: SAVEPOINT Dim_WebADI_Metadata_Pvt ;
2325: --
2326: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2327: p_api_version,
2328: l_api_name,
2329: G_PKG_NAME )
2330: THEN

Line 2331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2327: p_api_version,
2328: l_api_name,
2329: G_PKG_NAME )
2330: THEN
2331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2332: END IF;
2333: --
2334:
2335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 2335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

2331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2332: END IF;
2333: --
2334:
2335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2336: FND_MSG_PUB.initialize ;
2337: END IF;
2338: --
2339: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2339: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2335: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2336: FND_MSG_PUB.initialize ;
2337: END IF;
2338: --
2339: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2340: --
2341:
2342: SELECT DIMENSION_ID
2343: , DIMENSION_NAME

Line 2468: p_init_msg_list => FND_API.G_TRUE,

2464: ( x_return_status => l_return_status,
2465: x_msg_count => l_msg_count,
2466: x_msg_data => l_msg_data,
2467: p_api_version => 1.0,
2468: p_init_msg_list => FND_API.G_TRUE,
2469: p_commit => FND_API.G_FALSE,
2470: p_dimension_varchar_label => p_dimension_varchar_label
2471: );
2472:

Line 2469: p_commit => FND_API.G_FALSE,

2465: x_msg_count => l_msg_count,
2466: x_msg_data => l_msg_data,
2467: p_api_version => 1.0,
2468: p_init_msg_list => FND_API.G_TRUE,
2469: p_commit => FND_API.G_FALSE,
2470: p_dimension_varchar_label => p_dimension_varchar_label
2471: );
2472:
2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2469: p_commit => FND_API.G_FALSE,
2470: p_dimension_varchar_label => p_dimension_varchar_label
2471: );
2472:
2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2474: RAISE FND_API.G_EXC_ERROR ;
2475: END IF;
2476:
2477: l_interface_code := l_object_code || '_INTF';

Line 2474: RAISE FND_API.G_EXC_ERROR ;

2470: p_dimension_varchar_label => p_dimension_varchar_label
2471: );
2472:
2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2474: RAISE FND_API.G_EXC_ERROR ;
2475: END IF;
2476:
2477: l_interface_code := l_object_code || '_INTF';
2478: l_existed_flag := NULL;

Line 2576: p_init_msg_list => FND_API.G_FALSE,

2572: ---------------------------------------------------------------------------
2573:
2574: Populate_Dim_Intf_Common_Cols (
2575: p_api_version => 1.0,
2576: p_init_msg_list => FND_API.G_FALSE,
2577: p_commit => FND_API.G_FALSE,
2578: x_return_status => l_return_status,
2579: x_msg_count => l_msg_count,
2580: x_msg_data => l_msg_data,

Line 2577: p_commit => FND_API.G_FALSE,

2573:
2574: Populate_Dim_Intf_Common_Cols (
2575: p_api_version => 1.0,
2576: p_init_msg_list => FND_API.G_FALSE,
2577: p_commit => FND_API.G_FALSE,
2578: x_return_status => l_return_status,
2579: x_msg_count => l_msg_count,
2580: x_msg_data => l_msg_data,
2581: p_interface_code => l_interface_code,

Line 2586: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2582: p_dimension_varchar_label => p_dimension_varchar_label,
2583: p_group_use_code => l_group_use_code
2584: );
2585:
2586: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2587: RAISE FND_API.G_EXC_ERROR ;
2588: END IF;
2589:
2590:

Line 2587: RAISE FND_API.G_EXC_ERROR ;

2583: p_group_use_code => l_group_use_code
2584: );
2585:
2586: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2587: RAISE FND_API.G_EXC_ERROR ;
2588: END IF;
2589:
2590:
2591: ---------------------------------------------------------------------------

Line 2597: p_init_msg_list => FND_API.G_FALSE,

2593: ---------------------------------------------------------------------------
2594:
2595: Populate_Dim_Intf_Attr_Cols (
2596: p_api_version => 1.0,
2597: p_init_msg_list => FND_API.G_FALSE,
2598: p_commit => FND_API.G_FALSE,
2599: x_return_status => l_return_status,
2600: x_msg_count => l_msg_count,
2601: x_msg_data => l_msg_data,

Line 2598: p_commit => FND_API.G_FALSE,

2594:
2595: Populate_Dim_Intf_Attr_Cols (
2596: p_api_version => 1.0,
2597: p_init_msg_list => FND_API.G_FALSE,
2598: p_commit => FND_API.G_FALSE,
2599: x_return_status => l_return_status,
2600: x_msg_count => l_msg_count,
2601: x_msg_data => l_msg_data,
2602: p_interface_code => l_interface_code,

Line 2608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2604: p_dimension_id => l_dimension_id,
2605: x_updated_flag => l_updated_flag
2606: );
2607:
2608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2609: RAISE FND_API.G_EXC_ERROR ;
2610: END IF;
2611:
2612: l_updated_flag := 'Y';

Line 2609: RAISE FND_API.G_EXC_ERROR ;

2605: x_updated_flag => l_updated_flag
2606: );
2607:
2608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2609: RAISE FND_API.G_EXC_ERROR ;
2610: END IF;
2611:
2612: l_updated_flag := 'Y';
2613:

Line 2622: p_init_msg_list => FND_API.G_FALSE,

2618: -- Populate the attribute related interface columns
2619: ---------------------------------------------------------------------------
2620: Populate_Dim_Intf_Attr_Cols (
2621: p_api_version => 1.0,
2622: p_init_msg_list => FND_API.G_FALSE,
2623: p_commit => FND_API.G_FALSE,
2624: x_return_status => l_return_status,
2625: x_msg_count => l_msg_count,
2626: x_msg_data => l_msg_data,

Line 2623: p_commit => FND_API.G_FALSE,

2619: ---------------------------------------------------------------------------
2620: Populate_Dim_Intf_Attr_Cols (
2621: p_api_version => 1.0,
2622: p_init_msg_list => FND_API.G_FALSE,
2623: p_commit => FND_API.G_FALSE,
2624: x_return_status => l_return_status,
2625: x_msg_count => l_msg_count,
2626: x_msg_data => l_msg_data,
2627: p_interface_code => l_interface_code,

Line 2633: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2629: p_dimension_id => l_dimension_id,
2630: x_updated_flag => l_updated_flag
2631: );
2632:
2633: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2634: RAISE FND_API.G_EXC_ERROR ;
2635: END IF;
2636:
2637: END IF;

Line 2634: RAISE FND_API.G_EXC_ERROR ;

2630: x_updated_flag => l_updated_flag
2631: );
2632:
2633: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2634: RAISE FND_API.G_EXC_ERROR ;
2635: END IF;
2636:
2637: END IF;
2638:

Line 2646: p_init_msg_list => FND_API.G_FALSE,

2642: IF (l_updated_flag = 'Y') THEN
2643:
2644: Populate_Dim_Layout (
2645: p_api_version => 1.0,
2646: p_init_msg_list => FND_API.G_FALSE,
2647: p_commit => FND_API.G_FALSE,
2648: x_return_status => l_return_status,
2649: x_msg_count => l_msg_count,
2650: x_msg_data => l_msg_data,

Line 2647: p_commit => FND_API.G_FALSE,

2643:
2644: Populate_Dim_Layout (
2645: p_api_version => 1.0,
2646: p_init_msg_list => FND_API.G_FALSE,
2647: p_commit => FND_API.G_FALSE,
2648: x_return_status => l_return_status,
2649: x_msg_count => l_msg_count,
2650: x_msg_data => l_msg_data,
2651: p_integrator_code => l_integrator_code,

Line 2662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2658: p_group_use_code => l_group_use_code
2659: );
2660:
2661:
2662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2663: RAISE FND_API.G_EXC_ERROR ;
2664: END IF;
2665:
2666: -- update the object version number in the bne_integrators_b table.

Line 2663: RAISE FND_API.G_EXC_ERROR ;

2659: );
2660:
2661:
2662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2663: RAISE FND_API.G_EXC_ERROR ;
2664: END IF;
2665:
2666: -- update the object version number in the bne_integrators_b table.
2667: -- This will fix the new interface caching issue.

Line 2677: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN

2673: AND INTEGRATOR_CODE = l_integrator_code;
2674:
2675: END IF;
2676:
2677: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN
2678: COMMIT;
2679: END IF;
2680:
2681:

Line 2684: WHEN FND_API.G_EXC_ERROR THEN

2680:
2681:
2682: EXCEPTION
2683: --
2684: WHEN FND_API.G_EXC_ERROR THEN
2685: --
2686: ROLLBACK TO Dim_WebADI_Metadata_Pvt ;
2687: x_return_status := FND_API.G_RET_STS_ERROR;
2688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2687: x_return_status := FND_API.G_RET_STS_ERROR;

2683: --
2684: WHEN FND_API.G_EXC_ERROR THEN
2685: --
2686: ROLLBACK TO Dim_WebADI_Metadata_Pvt ;
2687: x_return_status := FND_API.G_RET_STS_ERROR;
2688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2689: p_data => x_msg_data );
2690: --
2691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2687: x_return_status := FND_API.G_RET_STS_ERROR;
2688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2689: p_data => x_msg_data );
2690: --
2691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2692: --
2693: ROLLBACK TO Dim_WebADI_Metadata_Pvt ;
2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2695: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2690: --
2691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2692: --
2693: ROLLBACK TO Dim_WebADI_Metadata_Pvt ;
2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2695: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2696: p_data => x_msg_data );
2697: --
2698: WHEN OTHERS THEN

Line 2701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2697: --
2698: WHEN OTHERS THEN
2699: --
2700: ROLLBACK TO Dim_WebADI_Metadata_Pvt ;
2701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2702: --
2703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2704: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2705: l_api_name);

Line 2861: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2857: g_global_val_tbl(1).value_set_required_flag :=
2858: NVL( l_ret_dim_metadata_csr_rec.value_set_required_flag, 'N' ) ;
2859: END LOOP ;
2860: --
2861: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2862: --
2863: --
2864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2865: THEN

Line 2880: WHEN FND_API.G_EXC_ERROR THEN

2876: --
2877: END IF ;
2878: --
2879: EXCEPTION
2880: WHEN FND_API.G_EXC_ERROR THEN
2881: --
2882: x_return_status := FND_API.G_RET_STS_ERROR ;
2883: --
2884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 2882: x_return_status := FND_API.G_RET_STS_ERROR ;

2878: --
2879: EXCEPTION
2880: WHEN FND_API.G_EXC_ERROR THEN
2881: --
2882: x_return_status := FND_API.G_RET_STS_ERROR ;
2883: --
2884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2885: THEN
2886: -- Put exact error message into log.

Line 2894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2890: , message => 'SQL Error ' || sqlerrm
2891: ) ;
2892: END IF ;
2893: --
2894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2895: --
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2897: --
2898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2892: END IF ;
2893: --
2894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2895: --
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2897: --
2898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2899: THEN
2900: -- Put exact error message into log.

Line 2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2906: END IF ;
2907: --
2908: WHEN OTHERS THEN
2909: --
2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2911: --
2912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2913: THEN
2914: -- Put exact error message into log.

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

3315: --
3316: END IF ;
3317: END IF ;
3318: --
3319: IF ( FND_API.To_Boolean (p_commit) )
3320: THEN
3321: COMMIT ;
3322: END IF ;
3323: --

Line 3325: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3321: COMMIT ;
3322: END IF ;
3323: --
3324: -- Initialize API return status to success
3325: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3326: --
3327: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3328: THEN
3329: --

Line 3342: WHEN FND_API.G_EXC_ERROR THEN

3338: --
3339: END IF ;
3340: --
3341: EXCEPTION
3342: WHEN FND_API.G_EXC_ERROR THEN
3343: --
3344: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3345: --
3346: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3346: x_return_status := FND_API.G_RET_STS_ERROR ;

3342: WHEN FND_API.G_EXC_ERROR THEN
3343: --
3344: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3345: --
3346: x_return_status := FND_API.G_RET_STS_ERROR ;
3347: --
3348: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3349: THEN
3350: -- Put exact error message into log.

Line 3359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3355: ) ;
3356: --
3357: END IF ;
3358: --
3359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3360: --
3361: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3362: --
3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3360: --
3361: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3362: --
3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3364: --
3365: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3366: THEN
3367: -- Put exact error message into log.

Line 3380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3376: WHEN OTHERS THEN
3377: --
3378: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3379: --
3380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3381: --
3382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3383: THEN
3384: -- Put exact error message into log.

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

5100: ( x_return_status => l_return_status
5101: , p_dimension_varchar_label => p_dimension_varchar_label
5102: ) ;
5103: --
5104: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
5105: THEN
5106: RAISE FND_API.G_EXC_ERROR ;
5107: END IF ;
5108: --

Line 5106: RAISE FND_API.G_EXC_ERROR ;

5102: ) ;
5103: --
5104: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
5105: THEN
5106: RAISE FND_API.G_EXC_ERROR ;
5107: END IF ;
5108: --
5109: END IF ;
5110: --

Line 6078: , p_init_msg_list => FND_API.G_FALSE

6074: ( x_return_status => l_return_status
6075: , x_msg_count => l_msg_count
6076: , x_msg_data => l_msg_data
6077: , p_api_version => l_api_version
6078: , p_init_msg_list => FND_API.G_FALSE
6079: , p_commit => FND_API.G_TRUE
6080: , p_dimension_varchar_label => p_dimension_varchar_label
6081: ) ;
6082: --

Line 6079: , p_commit => FND_API.G_TRUE

6075: , x_msg_count => l_msg_count
6076: , x_msg_data => l_msg_data
6077: , p_api_version => l_api_version
6078: , p_init_msg_list => FND_API.G_FALSE
6079: , p_commit => FND_API.G_TRUE
6080: , p_dimension_varchar_label => p_dimension_varchar_label
6081: ) ;
6082: --
6083: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

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

6079: , p_commit => FND_API.G_TRUE
6080: , p_dimension_varchar_label => p_dimension_varchar_label
6081: ) ;
6082: --
6083: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
6084: THEN
6085: RAISE FND_API.G_EXC_ERROR ;
6086: END IF ;
6087: --

Line 6085: RAISE FND_API.G_EXC_ERROR ;

6081: ) ;
6082: --
6083: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
6084: THEN
6085: RAISE FND_API.G_EXC_ERROR ;
6086: END IF ;
6087: --
6088: retcode := 0;
6089: --

Line 6092: WHEN FND_API.G_EXC_ERROR THEN

6088: retcode := 0;
6089: --
6090: EXCEPTION
6091: --
6092: WHEN FND_API.G_EXC_ERROR THEN
6093: --
6094: retcode := 2 ;
6095: errbuf := l_msg_data ;
6096: --

Line 6097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6093: --
6094: retcode := 2 ;
6095: errbuf := l_msg_data ;
6096: --
6097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6098: --
6099: retcode := 2 ;
6100: errbuf := l_msg_data ;
6101: --

Line 6136: IF NOT FND_API.Compatible_API_Call ( l_api_version,

6132: BEGIN
6133:
6134: SAVEPOINT Delete_Fem_Webadi_Seed_Pvt;
6135:
6136: IF NOT FND_API.Compatible_API_Call ( l_api_version,
6137: p_api_version,
6138: l_api_name,
6139: G_PKG_NAME )
6140: THEN

Line 6141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

6137: p_api_version,
6138: l_api_name,
6139: G_PKG_NAME )
6140: THEN
6141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6142: END IF;
6143: --
6144:
6145: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 6145: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

6141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6142: END IF;
6143: --
6144:
6145: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
6146: FND_MSG_PUB.initialize ;
6147: END IF;
6148: --
6149: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 6149: x_return_status := FND_API.G_RET_STS_SUCCESS ;

6145: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
6146: FND_MSG_PUB.initialize ;
6147: END IF;
6148: --
6149: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6150: --
6151:
6152: FEM_ENGINES_PKG.User_Message (
6153: p_app_name => 'FEM'

Line 6224: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN

6220: FEM_ENGINES_PKG.User_Message (
6221: p_app_name => 'FEM'
6222: ,p_msg_text => 'Deleted...');
6223:
6224: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN
6225: COMMIT;
6226: END IF;
6227:
6228: EXCEPTION

Line 6231: WHEN FND_API.G_EXC_ERROR THEN

6227:
6228: EXCEPTION
6229:
6230:
6231: WHEN FND_API.G_EXC_ERROR THEN
6232: --
6233: ROLLBACK TO Delete_Fem_Webadi_Seed_pvt ;
6234: x_return_status := FND_API.G_RET_STS_ERROR;
6235: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 6234: x_return_status := FND_API.G_RET_STS_ERROR;

6230:
6231: WHEN FND_API.G_EXC_ERROR THEN
6232: --
6233: ROLLBACK TO Delete_Fem_Webadi_Seed_pvt ;
6234: x_return_status := FND_API.G_RET_STS_ERROR;
6235: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6236: p_data => x_msg_data );
6237: --
6238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6234: x_return_status := FND_API.G_RET_STS_ERROR;
6235: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6236: p_data => x_msg_data );
6237: --
6238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6239: --
6240: ROLLBACK TO Delete_Fem_Webadi_Seed_Pvt ;
6241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6242: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 6241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6237: --
6238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6239: --
6240: ROLLBACK TO Delete_Fem_Webadi_Seed_Pvt ;
6241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6242: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6243: p_data => x_msg_data );
6244:
6245: WHEN OTHERS THEN

Line 6248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6244:
6245: WHEN OTHERS THEN
6246: --
6247: ROLLBACK TO Delete_Fem_Webadi_Seed_Pvt;
6248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6249: --
6250: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6251: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6252: l_api_name);