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

Line 262: x_return_status := fnd_api.g_ret_sts_success;

258: begin
259:
260: l_owner_type_ind := 'RS_INDIVIDUAL';
261: l_owner_type_grp := 'RS_GROUP';
262: x_return_status := fnd_api.g_ret_sts_success;
263:
264: IF NOT fnd_api.compatible_api_call (
265: l_api_version,
266: p_api_version,

Line 264: IF NOT fnd_api.compatible_api_call (

260: l_owner_type_ind := 'RS_INDIVIDUAL';
261: l_owner_type_grp := 'RS_GROUP';
262: x_return_status := fnd_api.g_ret_sts_success;
263:
264: IF NOT fnd_api.compatible_api_call (
265: l_api_version,
266: p_api_version,
267: l_api_name,
268: g_pkg_name

Line 271: RAISE fnd_api.g_exc_unexpected_error;

267: l_api_name,
268: g_pkg_name
269: )
270: THEN
271: RAISE fnd_api.g_exc_unexpected_error;
272: END IF;
273:
274: -- Initialize Message list
275:

Line 426: x_return_status := fnd_api.g_ret_sts_error;

422: if (l_ctr = 0)
423: then
424: null;
425: /*
426: x_return_status := fnd_api.g_ret_sts_error;
427:
428: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_GET_NEXT_WORK_FAILED');
429:
430: fnd_msg_pub.ADD;

Line 437: RAISE fnd_api.g_exc_error;

433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );
436:
437: RAISE fnd_api.g_exc_error;
438: */
439: else
440:
441: -- Order the work items by priority level, due date and Object_code

Line 776: raise fnd_api.g_exc_unexpected_error;

772:
773: EXCEPTION
774: when no_data_found
775: then
776: raise fnd_api.g_exc_unexpected_error;
777: END;
778:
779: t2 := DBMS_UTILITY.GET_TIME;
780: l_time_spent := t2 - t1;

Line 791: WHEN fnd_api.g_exc_error THEN

787: end if;
788:
789: EXCEPTION
790:
791: WHEN fnd_api.g_exc_error THEN
792:
793: x_return_status := fnd_api.g_ret_sts_error;
794:
795: fnd_msg_pub.Count_and_Get

Line 793: x_return_status := fnd_api.g_ret_sts_error;

789: EXCEPTION
790:
791: WHEN fnd_api.g_exc_error THEN
792:
793: x_return_status := fnd_api.g_ret_sts_error;
794:
795: fnd_msg_pub.Count_and_Get
796: (
797: p_count => x_msg_count,

Line 801: WHEN fnd_api.g_exc_unexpected_error THEN

797: p_count => x_msg_count,
798: p_data => x_msg_data
799: );
800:
801: WHEN fnd_api.g_exc_unexpected_error THEN
802:
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804:
805: fnd_msg_pub.Count_and_Get

Line 803: x_return_status := fnd_api.g_ret_sts_unexp_error;

799: );
800:
801: WHEN fnd_api.g_exc_unexpected_error THEN
802:
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804:
805: fnd_msg_pub.Count_and_Get
806: (
807: p_count => x_msg_count,

Line 1044: x_return_status := fnd_api.g_ret_sts_success;

1040: l_distribute_from := 'GROUP_OWNED';
1041: l_not_valid_flag := 'N';
1042: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
1043:
1044: x_return_status := fnd_api.g_ret_sts_success;
1045:
1046: IF NOT fnd_api.compatible_api_call (
1047: l_api_version,
1048: p_api_version,

Line 1046: IF NOT fnd_api.compatible_api_call (

1042: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
1043:
1044: x_return_status := fnd_api.g_ret_sts_success;
1045:
1046: IF NOT fnd_api.compatible_api_call (
1047: l_api_version,
1048: p_api_version,
1049: l_api_name,
1050: g_pkg_name

Line 1053: RAISE fnd_api.g_exc_unexpected_error;

1049: l_api_name,
1050: g_pkg_name
1051: )
1052: THEN
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055:
1056: -- Initialize Message list
1057:

Line 1397: raise fnd_api.g_exc_error;

1393: l_delivery_only_flag := 'N';
1394: elsif (nvl(l_dist_items_flag,'Y') = 'N') AND (nvl(l_del_items_flag,'Y') = 'N')
1395: then
1396: l_delivery_only_flag := '-1';
1397: raise fnd_api.g_exc_error;
1398: end if; /* Check to see if Distributed or Distributable items are present */
1399:
1400: -- Audit Logging
1401: if (l_audit_log_val = 'DETAILED')

Line 2462: raise fnd_api.g_exc_error;

2458:
2459: if (x_uwqm_workitem_data.count < 1)
2460: then
2461:
2462: raise fnd_api.g_exc_error;
2463: end if;
2464: --commit;
2465: EXCEPTION
2466:

Line 2467: WHEN fnd_api.g_exc_error THEN

2463: end if;
2464: --commit;
2465: EXCEPTION
2466:
2467: WHEN fnd_api.g_exc_error THEN
2468: x_return_status := fnd_api.g_ret_sts_error;
2469:
2470: fnd_msg_pub.Count_and_Get
2471: (

Line 2468: x_return_status := fnd_api.g_ret_sts_error;

2464: --commit;
2465: EXCEPTION
2466:
2467: WHEN fnd_api.g_exc_error THEN
2468: x_return_status := fnd_api.g_ret_sts_error;
2469:
2470: fnd_msg_pub.Count_and_Get
2471: (
2472: p_count => x_msg_count,

Line 2476: WHEN fnd_api.g_exc_unexpected_error THEN

2472: p_count => x_msg_count,
2473: p_data => x_msg_data
2474: );
2475:
2476: WHEN fnd_api.g_exc_unexpected_error THEN
2477:
2478: x_return_status := fnd_api.g_ret_sts_unexp_error;
2479:
2480: fnd_msg_pub.Count_and_Get

Line 2478: x_return_status := fnd_api.g_ret_sts_unexp_error;

2474: );
2475:
2476: WHEN fnd_api.g_exc_unexpected_error THEN
2477:
2478: x_return_status := fnd_api.g_ret_sts_unexp_error;
2479:
2480: fnd_msg_pub.Count_and_Get
2481: (
2482: p_count => x_msg_count,

Line 2488: x_return_status := fnd_api.g_ret_sts_unexp_error;

2484: );
2485:
2486: WHEN OTHERS THEN
2487:
2488: x_return_status := fnd_api.g_ret_sts_unexp_error;
2489:
2490: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2491: THEN
2492:

Line 2534: x_return_status := fnd_api.g_ret_sts_success;

2530:
2531:
2532: BEGIN
2533:
2534: x_return_status := fnd_api.g_ret_sts_success;
2535:
2536:
2537:
2538: IF NOT fnd_api.compatible_api_call (

Line 2538: IF NOT fnd_api.compatible_api_call (

2534: x_return_status := fnd_api.g_ret_sts_success;
2535:
2536:
2537:
2538: IF NOT fnd_api.compatible_api_call (
2539: l_api_version,
2540: p_api_version,
2541: l_api_name,
2542: g_pkg_name

Line 2545: RAISE fnd_api.g_exc_unexpected_error;

2541: l_api_name,
2542: g_pkg_name
2543: )
2544: THEN
2545: RAISE fnd_api.g_exc_unexpected_error;
2546: END IF;
2547:
2548: -- Initialize Message list
2549:

Line 2615: WHEN fnd_api.g_exc_error THEN

2611:
2612:
2613: EXCEPTION
2614:
2615: WHEN fnd_api.g_exc_error THEN
2616:
2617: x_return_status := fnd_api.g_ret_sts_error;
2618:
2619: fnd_msg_pub.Count_and_Get

Line 2617: x_return_status := fnd_api.g_ret_sts_error;

2613: EXCEPTION
2614:
2615: WHEN fnd_api.g_exc_error THEN
2616:
2617: x_return_status := fnd_api.g_ret_sts_error;
2618:
2619: fnd_msg_pub.Count_and_Get
2620: (
2621: p_count => x_msg_count,

Line 2625: WHEN fnd_api.g_exc_unexpected_error THEN

2621: p_count => x_msg_count,
2622: p_data => x_msg_data
2623: );
2624:
2625: WHEN fnd_api.g_exc_unexpected_error THEN
2626:
2627: x_return_status := fnd_api.g_ret_sts_unexp_error;
2628:
2629: fnd_msg_pub.Count_and_Get

Line 2627: x_return_status := fnd_api.g_ret_sts_unexp_error;

2623: );
2624:
2625: WHEN fnd_api.g_exc_unexpected_error THEN
2626:
2627: x_return_status := fnd_api.g_ret_sts_unexp_error;
2628:
2629: fnd_msg_pub.Count_and_Get
2630: (
2631: p_count => x_msg_count,

Line 2637: x_return_status := fnd_api.g_ret_sts_unexp_error;

2633: );
2634:
2635: WHEN OTHERS THEN
2636:
2637: x_return_status := fnd_api.g_ret_sts_unexp_error;
2638:
2639: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641:

Line 2775: x_return_status := fnd_api.g_ret_sts_success;

2771: l_audit_log_id_list AUDIT_LOG_ID_TBL;
2772: v varchar2(1000);
2773: BEGIN
2774: l_not_valid_flag := 'N';
2775: x_return_status := fnd_api.g_ret_sts_success;
2776:
2777: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2778:
2779: IF NOT fnd_api.compatible_api_call (

Line 2779: IF NOT fnd_api.compatible_api_call (

2775: x_return_status := fnd_api.g_ret_sts_success;
2776:
2777: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2778:
2779: IF NOT fnd_api.compatible_api_call (
2780: l_api_version,
2781: p_api_version,
2782: l_api_name,
2783: g_pkg_name

Line 2786: RAISE fnd_api.g_exc_unexpected_error;

2782: l_api_name,
2783: g_pkg_name
2784: )
2785: THEN
2786: RAISE fnd_api.g_exc_unexpected_error;
2787: END IF;
2788:
2789: -- Initialize Message list
2790:

Line 3572: WHEN fnd_api.g_exc_error THEN

3568: -- commit;
3569: -- dbms_output.put_line('cnt: '||l_nw_item_list.count);
3570: EXCEPTION
3571:
3572: WHEN fnd_api.g_exc_error THEN
3573:
3574: x_return_status := fnd_api.g_ret_sts_error;
3575:
3576: fnd_msg_pub.Count_and_Get

Line 3574: x_return_status := fnd_api.g_ret_sts_error;

3570: EXCEPTION
3571:
3572: WHEN fnd_api.g_exc_error THEN
3573:
3574: x_return_status := fnd_api.g_ret_sts_error;
3575:
3576: fnd_msg_pub.Count_and_Get
3577: (
3578: p_count => x_msg_count,

Line 3582: WHEN fnd_api.g_exc_unexpected_error THEN

3578: p_count => x_msg_count,
3579: p_data => x_msg_data
3580: );
3581:
3582: WHEN fnd_api.g_exc_unexpected_error THEN
3583:
3584: x_return_status := fnd_api.g_ret_sts_unexp_error;
3585:
3586: fnd_msg_pub.Count_and_Get

Line 3584: x_return_status := fnd_api.g_ret_sts_unexp_error;

3580: );
3581:
3582: WHEN fnd_api.g_exc_unexpected_error THEN
3583:
3584: x_return_status := fnd_api.g_ret_sts_unexp_error;
3585:
3586: fnd_msg_pub.Count_and_Get
3587: (
3588: p_count => x_msg_count,

Line 3594: x_return_status := fnd_api.g_ret_sts_unexp_error;

3590: );
3591:
3592: WHEN OTHERS THEN
3593:
3594: x_return_status := fnd_api.g_ret_sts_unexp_error;
3595:
3596: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3597: THEN
3598:

Line 4844: x_return_status := FND_API.G_RET_STS_SUCCESS;

4840: l_last_update_date := sysdate - 10/1440;
4841:
4842: if ( p_resource_id is not null)
4843: then
4844: x_return_status := FND_API.G_RET_STS_SUCCESS;
4845:
4846: for grp_id in c_grp_id(p_resource_id)
4847: loop
4848: p_grp_id_list(z).group_id := grp_id.group_id;

Line 4896: x_return_status := FND_API.G_RET_STS_ERROR;

4892: end if;
4893:
4894: EXCEPTION
4895: WHEN OTHERS THEN
4896: x_return_status := FND_API.G_RET_STS_ERROR;
4897: x_msg_data := SQLCODE||' '||sqlerrm;
4898:
4899: END CLEANUP_DISTRIBUTING_STATUS;
4900: