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_MSG_PUB

Line 276: FND_MSG_PUB.INITIALIZE;

272: END IF;
273:
274: -- Initialize Message list
275:
276: FND_MSG_PUB.INITIALIZE;
277:
278: t1 := DBMS_UTILITY.GET_TIME;
279:
280: ------ If no of records to be selected is not passed in the parameter

Line 430: fnd_msg_pub.ADD;

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;
431: fnd_msg_pub.Count_and_Get
432: (
433: p_count => x_msg_count,
434: p_data => x_msg_data

Line 431: fnd_msg_pub.Count_and_Get

427:
428: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_GET_NEXT_WORK_FAILED');
429:
430: fnd_msg_pub.ADD;
431: fnd_msg_pub.Count_and_Get
432: (
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );

Line 795: fnd_msg_pub.Count_and_Get

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,
798: p_data => x_msg_data
799: );

Line 805: fnd_msg_pub.Count_and_Get

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,
808: p_data => x_msg_data
809: );

Line 813: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

809: );
810:
811: WHEN OTHERS THEN
812:
813: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815:
816: fnd_msg_pub.Count_and_Get
817: (

Line 816: fnd_msg_pub.Count_and_Get

812:
813: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815:
816: fnd_msg_pub.Count_and_Get
817: (
818: p_count => x_msg_count,
819: p_data => x_msg_data
820: );

Line 1058: FND_MSG_PUB.INITIALIZE;

1054: END IF;
1055:
1056: -- Initialize Message list
1057:
1058: FND_MSG_PUB.INITIALIZE;
1059:
1060: LOOP
1061:
1062: exit when ((l_dist_item_ctr >= 2) or (l_num_of_items_distributed > 0));

Line 2024: FND_MSG_PUB.INITIALIZE;

2020: l_module := 'IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER';
2021: l_application_id := 696;
2022: l_ret_sts := 'E';
2023:
2024: FND_MSG_PUB.INITIALIZE;
2025: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
2026: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
2027: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
2028: fnd_msg_pub.ADD;

Line 2028: fnd_msg_pub.ADD;

2024: FND_MSG_PUB.INITIALIZE;
2025: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
2026: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
2027: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
2028: fnd_msg_pub.ADD;
2029:
2030: fnd_msg_pub.Count_and_Get
2031: (
2032: p_count => x_msg_count,

Line 2030: fnd_msg_pub.Count_and_Get

2026: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
2027: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
2028: fnd_msg_pub.ADD;
2029:
2030: fnd_msg_pub.Count_and_Get
2031: (
2032: p_count => x_msg_count,
2033: p_data => x_msg_data
2034: );

Line 2470: fnd_msg_pub.Count_and_Get

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,
2473: p_data => x_msg_data
2474: );

Line 2480: fnd_msg_pub.Count_and_Get

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,
2483: p_data => x_msg_data
2484: );

Line 2490: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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:
2493: fnd_msg_pub.Count_and_Get
2494: (

Line 2493: fnd_msg_pub.Count_and_Get

2489:
2490: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2491: THEN
2492:
2493: fnd_msg_pub.Count_and_Get
2494: (
2495: p_count => x_msg_count,
2496: p_data => x_msg_data
2497: );

Line 2550: FND_MSG_PUB.INITIALIZE;

2546: END IF;
2547:
2548: -- Initialize Message list
2549:
2550: FND_MSG_PUB.INITIALIZE;
2551:
2552: x_num_of_items_distributed := 0;
2553:
2554: loop

Line 2619: fnd_msg_pub.Count_and_Get

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,
2622: p_data => x_msg_data
2623: );

Line 2629: fnd_msg_pub.Count_and_Get

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,
2632: p_data => x_msg_data
2633: );

Line 2639: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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:
2642: fnd_msg_pub.Count_and_Get
2643: (

Line 2642: fnd_msg_pub.Count_and_Get

2638:
2639: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641:
2642: fnd_msg_pub.Count_and_Get
2643: (
2644: p_count => x_msg_count,
2645: p_data => x_msg_data
2646: );

Line 2791: FND_MSG_PUB.INITIALIZE;

2787: END IF;
2788:
2789: -- Initialize Message list
2790:
2791: FND_MSG_PUB.INITIALIZE;
2792:
2793: x_uwqm_workitem_data := SYSTEM.WR_ITEM_DATA_NST();
2794:
2795: -- Get the Where Clause

Line 3274: FND_MSG_PUB.INITIALIZE;

3270: --l_token_str := SQLERRM;
3271: --insert into p_temp('errcode: '||SQLCODE);
3272: --insert inot p_temp('errm: '||SQLERRM);
3273:
3274: FND_MSG_PUB.INITIALIZE;
3275: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
3276: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
3277: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
3278: fnd_msg_pub.ADD;

Line 3278: fnd_msg_pub.ADD;

3274: FND_MSG_PUB.INITIALIZE;
3275: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
3276: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
3277: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
3278: fnd_msg_pub.ADD;
3279:
3280: fnd_msg_pub.Count_and_Get
3281: (
3282: p_count => x_msg_count,

Line 3280: fnd_msg_pub.Count_and_Get

3276: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
3277: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
3278: fnd_msg_pub.ADD;
3279:
3280: fnd_msg_pub.Count_and_Get
3281: (
3282: p_count => x_msg_count,
3283: p_data => x_msg_data
3284: );

Line 3576: fnd_msg_pub.Count_and_Get

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,
3579: p_data => x_msg_data
3580: );

Line 3586: fnd_msg_pub.Count_and_Get

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,
3589: p_data => x_msg_data
3590: );

Line 3596: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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:
3599: fnd_msg_pub.Count_and_Get
3600: (

Line 3599: fnd_msg_pub.Count_and_Get

3595:
3596: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3597: THEN
3598:
3599: fnd_msg_pub.Count_and_Get
3600: (
3601: p_count => x_msg_count,
3602: p_data => x_msg_data
3603: );