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 1062: FND_MSG_PUB.INITIALIZE;

1058: END IF;
1059:
1060: -- Initialize Message list
1061:
1062: FND_MSG_PUB.INITIALIZE;
1063:
1064: LOOP
1065:
1066: exit when ((l_dist_item_ctr >= 2) or (l_num_of_items_distributed > 0));

Line 2058: FND_MSG_PUB.INITIALIZE;

2054: l_module := 'IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER';
2055: l_application_id := 696;
2056: l_ret_sts := 'E';
2057:
2058: FND_MSG_PUB.INITIALIZE;
2059: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
2060: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
2061: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
2062: fnd_msg_pub.ADD;

Line 2062: fnd_msg_pub.ADD;

2058: FND_MSG_PUB.INITIALIZE;
2059: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
2060: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
2061: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
2062: fnd_msg_pub.ADD;
2063:
2064: fnd_msg_pub.Count_and_Get
2065: (
2066: p_count => x_msg_count,

Line 2064: fnd_msg_pub.Count_and_Get

2060: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
2061: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
2062: fnd_msg_pub.ADD;
2063:
2064: fnd_msg_pub.Count_and_Get
2065: (
2066: p_count => x_msg_count,
2067: p_data => x_msg_data
2068: );

Line 2504: fnd_msg_pub.Count_and_Get

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,
2507: p_data => x_msg_data
2508: );

Line 2514: fnd_msg_pub.Count_and_Get

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,
2517: p_data => x_msg_data
2518: );

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

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:
2527: fnd_msg_pub.Count_and_Get
2528: (

Line 2527: fnd_msg_pub.Count_and_Get

2523:
2524: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2525: THEN
2526:
2527: fnd_msg_pub.Count_and_Get
2528: (
2529: p_count => x_msg_count,
2530: p_data => x_msg_data
2531: );

Line 2584: FND_MSG_PUB.INITIALIZE;

2580: END IF;
2581:
2582: -- Initialize Message list
2583:
2584: FND_MSG_PUB.INITIALIZE;
2585:
2586: x_num_of_items_distributed := 0;
2587:
2588: loop

Line 2653: fnd_msg_pub.Count_and_Get

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,
2656: p_data => x_msg_data
2657: );

Line 2663: fnd_msg_pub.Count_and_Get

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,
2666: p_data => x_msg_data
2667: );

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

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:
2676: fnd_msg_pub.Count_and_Get
2677: (

Line 2676: fnd_msg_pub.Count_and_Get

2672:
2673: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2674: THEN
2675:
2676: fnd_msg_pub.Count_and_Get
2677: (
2678: p_count => x_msg_count,
2679: p_data => x_msg_data
2680: );

Line 2825: FND_MSG_PUB.INITIALIZE;

2821: END IF;
2822:
2823: -- Initialize Message list
2824:
2825: FND_MSG_PUB.INITIALIZE;
2826:
2827: x_uwqm_workitem_data := SYSTEM.WR_ITEM_DATA_NST();
2828:
2829: -- Get the Where Clause

Line 3308: FND_MSG_PUB.INITIALIZE;

3304: --l_token_str := SQLERRM;
3305: --insert into p_temp('errcode: '||SQLCODE);
3306: --insert inot p_temp('errm: '||SQLERRM);
3307:
3308: FND_MSG_PUB.INITIALIZE;
3309: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
3311: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
3312: fnd_msg_pub.ADD;

Line 3312: fnd_msg_pub.ADD;

3308: FND_MSG_PUB.INITIALIZE;
3309: FND_MESSAGE.SET_NAME('IEU', 'IEU_SQL_ERROR');
3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
3311: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
3312: fnd_msg_pub.ADD;
3313:
3314: fnd_msg_pub.Count_and_Get
3315: (
3316: p_count => x_msg_count,

Line 3314: fnd_msg_pub.Count_and_Get

3310: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER');
3311: FND_MESSAGE.SET_TOKEN('SQL_ERROR_MSG',l_token_str);
3312: fnd_msg_pub.ADD;
3313:
3314: fnd_msg_pub.Count_and_Get
3315: (
3316: p_count => x_msg_count,
3317: p_data => x_msg_data
3318: );

Line 3610: fnd_msg_pub.Count_and_Get

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,
3613: p_data => x_msg_data
3614: );

Line 3620: fnd_msg_pub.Count_and_Get

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,
3623: p_data => x_msg_data
3624: );

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

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:
3633: fnd_msg_pub.Count_and_Get
3634: (

Line 3633: fnd_msg_pub.Count_and_Get

3629:
3630: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3631: THEN
3632:
3633: fnd_msg_pub.Count_and_Get
3634: (
3635: p_count => x_msg_count,
3636: p_data => x_msg_data
3637: );