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 1048: x_return_status := fnd_api.g_ret_sts_success;

1044: l_distribute_from := 'GROUP_OWNED';
1045: l_not_valid_flag := 'N';
1046: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
1047:
1048: x_return_status := fnd_api.g_ret_sts_success;
1049:
1050: IF NOT fnd_api.compatible_api_call (
1051: l_api_version,
1052: p_api_version,

Line 1050: IF NOT fnd_api.compatible_api_call (

1046: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
1047:
1048: x_return_status := fnd_api.g_ret_sts_success;
1049:
1050: IF NOT fnd_api.compatible_api_call (
1051: l_api_version,
1052: p_api_version,
1053: l_api_name,
1054: g_pkg_name

Line 1057: RAISE fnd_api.g_exc_unexpected_error;

1053: l_api_name,
1054: g_pkg_name
1055: )
1056: THEN
1057: RAISE fnd_api.g_exc_unexpected_error;
1058: END IF;
1059:
1060: -- Initialize Message list
1061:

Line 1433: raise fnd_api.g_exc_error;

1429: l_delivery_only_flag := 'N';
1430: elsif (nvl(l_dist_items_flag,'Y') = 'N') AND (nvl(l_del_items_flag,'Y') = 'N')
1431: then
1432: l_delivery_only_flag := '-1';
1433: raise fnd_api.g_exc_error;
1434: end if; /* Check to see if Distributed or Distributable items are present */
1435: -- Audit Logging
1436: if (l_audit_log_val = 'DETAILED')
1437: then

Line 2496: raise fnd_api.g_exc_error;

2492:
2493: if (x_uwqm_workitem_data.count < 1)
2494: then
2495:
2496: raise fnd_api.g_exc_error;
2497: end if;
2498: --commit;
2499: EXCEPTION
2500:

Line 2501: WHEN fnd_api.g_exc_error THEN

2497: end if;
2498: --commit;
2499: EXCEPTION
2500:
2501: WHEN fnd_api.g_exc_error THEN
2502: x_return_status := fnd_api.g_ret_sts_error;
2503:
2504: fnd_msg_pub.Count_and_Get
2505: (

Line 2502: x_return_status := fnd_api.g_ret_sts_error;

2498: --commit;
2499: EXCEPTION
2500:
2501: WHEN fnd_api.g_exc_error THEN
2502: x_return_status := fnd_api.g_ret_sts_error;
2503:
2504: fnd_msg_pub.Count_and_Get
2505: (
2506: p_count => x_msg_count,

Line 2510: WHEN fnd_api.g_exc_unexpected_error THEN

2506: p_count => x_msg_count,
2507: p_data => x_msg_data
2508: );
2509:
2510: WHEN fnd_api.g_exc_unexpected_error THEN
2511:
2512: x_return_status := fnd_api.g_ret_sts_unexp_error;
2513:
2514: fnd_msg_pub.Count_and_Get

Line 2512: x_return_status := fnd_api.g_ret_sts_unexp_error;

2508: );
2509:
2510: WHEN fnd_api.g_exc_unexpected_error THEN
2511:
2512: x_return_status := fnd_api.g_ret_sts_unexp_error;
2513:
2514: fnd_msg_pub.Count_and_Get
2515: (
2516: p_count => x_msg_count,

Line 2522: x_return_status := fnd_api.g_ret_sts_unexp_error;

2518: );
2519:
2520: WHEN OTHERS THEN
2521:
2522: x_return_status := fnd_api.g_ret_sts_unexp_error;
2523:
2524: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2525: THEN
2526:

Line 2568: x_return_status := fnd_api.g_ret_sts_success;

2564:
2565:
2566: BEGIN
2567:
2568: x_return_status := fnd_api.g_ret_sts_success;
2569:
2570:
2571:
2572: IF NOT fnd_api.compatible_api_call (

Line 2572: IF NOT fnd_api.compatible_api_call (

2568: x_return_status := fnd_api.g_ret_sts_success;
2569:
2570:
2571:
2572: IF NOT fnd_api.compatible_api_call (
2573: l_api_version,
2574: p_api_version,
2575: l_api_name,
2576: g_pkg_name

Line 2579: RAISE fnd_api.g_exc_unexpected_error;

2575: l_api_name,
2576: g_pkg_name
2577: )
2578: THEN
2579: RAISE fnd_api.g_exc_unexpected_error;
2580: END IF;
2581:
2582: -- Initialize Message list
2583:

Line 2649: WHEN fnd_api.g_exc_error THEN

2645:
2646:
2647: EXCEPTION
2648:
2649: WHEN fnd_api.g_exc_error THEN
2650:
2651: x_return_status := fnd_api.g_ret_sts_error;
2652:
2653: fnd_msg_pub.Count_and_Get

Line 2651: x_return_status := fnd_api.g_ret_sts_error;

2647: EXCEPTION
2648:
2649: WHEN fnd_api.g_exc_error THEN
2650:
2651: x_return_status := fnd_api.g_ret_sts_error;
2652:
2653: fnd_msg_pub.Count_and_Get
2654: (
2655: p_count => x_msg_count,

Line 2659: WHEN fnd_api.g_exc_unexpected_error THEN

2655: p_count => x_msg_count,
2656: p_data => x_msg_data
2657: );
2658:
2659: WHEN fnd_api.g_exc_unexpected_error THEN
2660:
2661: x_return_status := fnd_api.g_ret_sts_unexp_error;
2662:
2663: fnd_msg_pub.Count_and_Get

Line 2661: x_return_status := fnd_api.g_ret_sts_unexp_error;

2657: );
2658:
2659: WHEN fnd_api.g_exc_unexpected_error THEN
2660:
2661: x_return_status := fnd_api.g_ret_sts_unexp_error;
2662:
2663: fnd_msg_pub.Count_and_Get
2664: (
2665: p_count => x_msg_count,

Line 2671: x_return_status := fnd_api.g_ret_sts_unexp_error;

2667: );
2668:
2669: WHEN OTHERS THEN
2670:
2671: x_return_status := fnd_api.g_ret_sts_unexp_error;
2672:
2673: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2674: THEN
2675:

Line 2809: x_return_status := fnd_api.g_ret_sts_success;

2805: l_audit_log_id_list AUDIT_LOG_ID_TBL;
2806: v varchar2(1000);
2807: BEGIN
2808: l_not_valid_flag := 'N';
2809: x_return_status := fnd_api.g_ret_sts_success;
2810:
2811: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2812:
2813: IF NOT fnd_api.compatible_api_call (

Line 2813: IF NOT fnd_api.compatible_api_call (

2809: x_return_status := fnd_api.g_ret_sts_success;
2810:
2811: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2812:
2813: IF NOT fnd_api.compatible_api_call (
2814: l_api_version,
2815: p_api_version,
2816: l_api_name,
2817: g_pkg_name

Line 2820: RAISE fnd_api.g_exc_unexpected_error;

2816: l_api_name,
2817: g_pkg_name
2818: )
2819: THEN
2820: RAISE fnd_api.g_exc_unexpected_error;
2821: END IF;
2822:
2823: -- Initialize Message list
2824:

Line 3606: WHEN fnd_api.g_exc_error THEN

3602: -- commit;
3603: -- dbms_output.put_line('cnt: '||l_nw_item_list.count);
3604: EXCEPTION
3605:
3606: WHEN fnd_api.g_exc_error THEN
3607:
3608: x_return_status := fnd_api.g_ret_sts_error;
3609:
3610: fnd_msg_pub.Count_and_Get

Line 3608: x_return_status := fnd_api.g_ret_sts_error;

3604: EXCEPTION
3605:
3606: WHEN fnd_api.g_exc_error THEN
3607:
3608: x_return_status := fnd_api.g_ret_sts_error;
3609:
3610: fnd_msg_pub.Count_and_Get
3611: (
3612: p_count => x_msg_count,

Line 3616: WHEN fnd_api.g_exc_unexpected_error THEN

3612: p_count => x_msg_count,
3613: p_data => x_msg_data
3614: );
3615:
3616: WHEN fnd_api.g_exc_unexpected_error THEN
3617:
3618: x_return_status := fnd_api.g_ret_sts_unexp_error;
3619:
3620: fnd_msg_pub.Count_and_Get

Line 3618: x_return_status := fnd_api.g_ret_sts_unexp_error;

3614: );
3615:
3616: WHEN fnd_api.g_exc_unexpected_error THEN
3617:
3618: x_return_status := fnd_api.g_ret_sts_unexp_error;
3619:
3620: fnd_msg_pub.Count_and_Get
3621: (
3622: p_count => x_msg_count,

Line 3628: x_return_status := fnd_api.g_ret_sts_unexp_error;

3624: );
3625:
3626: WHEN OTHERS THEN
3627:
3628: x_return_status := fnd_api.g_ret_sts_unexp_error;
3629:
3630: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3631: THEN
3632:

Line 4908: x_return_status := FND_API.G_RET_STS_SUCCESS;

4904: l_last_update_date := sysdate - 10/1440;
4905:
4906: if ( p_resource_id is not null)
4907: then
4908: x_return_status := FND_API.G_RET_STS_SUCCESS;
4909:
4910: for grp_id in c_grp_id(p_resource_id)
4911: loop
4912: p_grp_id_list(z).group_id := grp_id.group_id;

Line 4960: x_return_status := FND_API.G_RET_STS_ERROR;

4956: end if;
4957:
4958: EXCEPTION
4959: WHEN OTHERS THEN
4960: x_return_status := FND_API.G_RET_STS_ERROR;
4961: x_msg_data := SQLCODE||' '||sqlerrm;
4962:
4963: END CLEANUP_DISTRIBUTING_STATUS;
4964: