DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FND_MSG_PUB

Line 1678: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1674: EXCEPTION
1675:
1676: WHEN OTHERS THEN
1677:
1678: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1679: THEN
1680: FND_MSG_PUB.Add_Exc_Msg
1681: ( G_PKG_NAME
1682: , 'Update_Row'

Line 1680: FND_MSG_PUB.Add_Exc_Msg

1676: WHEN OTHERS THEN
1677:
1678: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1679: THEN
1680: FND_MSG_PUB.Add_Exc_Msg
1681: ( G_PKG_NAME
1682: , 'Update_Row'
1683: );
1684: END IF;

Line 1858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1854: EXCEPTION
1855:
1856: WHEN OTHERS THEN
1857:
1858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1859: THEN
1860: FND_MSG_PUB.Add_Exc_Msg
1861: ( G_PKG_NAME
1862: , 'Insert_Row'

Line 1860: FND_MSG_PUB.Add_Exc_Msg

1856: WHEN OTHERS THEN
1857:
1858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1859: THEN
1860: FND_MSG_PUB.Add_Exc_Msg
1861: ( G_PKG_NAME
1862: , 'Insert_Row'
1863: );
1864: END IF;

Line 1886: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1882: EXCEPTION
1883:
1884: WHEN OTHERS THEN
1885:
1886: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1887: THEN
1888: FND_MSG_PUB.Add_Exc_Msg
1889: ( G_PKG_NAME
1890: , 'Delete_Row'

Line 1888: FND_MSG_PUB.Add_Exc_Msg

1884: WHEN OTHERS THEN
1885:
1886: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1887: THEN
1888: FND_MSG_PUB.Add_Exc_Msg
1889: ( G_PKG_NAME
1890: , 'Delete_Row'
1891: );
1892: END IF;

Line 2055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2051: EXCEPTION
2052:
2053: WHEN OTHERS THEN
2054:
2055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2056: THEN
2057: FND_MSG_PUB.Add_Exc_Msg
2058: ( G_PKG_NAME
2059: , 'Query_Row'

Line 2057: FND_MSG_PUB.Add_Exc_Msg

2053: WHEN OTHERS THEN
2054:
2055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2056: THEN
2057: FND_MSG_PUB.Add_Exc_Msg
2058: ( G_PKG_NAME
2059: , 'Query_Row'
2060: );
2061: END IF;

Line 2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2582:
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2585:
2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2587: THEN
2588:
2589: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_CHANGED');
2590: FND_MSG_PUB.Add;

Line 2590: FND_MSG_PUB.Add;

2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2587: THEN
2588:
2589: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_CHANGED');
2590: FND_MSG_PUB.Add;
2591:
2592: END IF;
2593:
2594: END IF;

Line 2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2602:
2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:
2606: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_DELETED');
2607: FND_MSG_PUB.Add;

Line 2607: FND_MSG_PUB.Add;

2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:
2606: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_DELETED');
2607: FND_MSG_PUB.Add;
2608:
2609: END IF;
2610: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2611:

Line 2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2611:
2612: x_return_status := FND_API.G_RET_STS_ERROR;
2613: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2614:
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2616: THEN
2617:
2618: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_ALREADY_LOCKED');
2619: FND_MSG_PUB.Add;

Line 2619: FND_MSG_PUB.Add;

2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2616: THEN
2617:
2618: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_ALREADY_LOCKED');
2619: FND_MSG_PUB.Add;
2620:
2621: END IF;
2622: WHEN OTHERS THEN
2623:

Line 2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2623:
2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626:
2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2628: THEN
2629: FND_MSG_PUB.Add_Exc_Msg
2630: ( G_PKG_NAME
2631: , 'Lock_Row'

Line 2629: FND_MSG_PUB.Add_Exc_Msg

2625: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626:
2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2628: THEN
2629: FND_MSG_PUB.Add_Exc_Msg
2630: ( G_PKG_NAME
2631: , 'Lock_Row'
2632: );
2633: END IF;

Line 2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2752: IF p_flow_schedule_rec.completion_locator_id <> FND_API.G_MISS_NUM THEN
2753:
2754: l_flow_schedule_rec.completion_locator_id := p_flow_schedule_rec.completion_locator_id;
2755:
2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2757: THEN
2758:
2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');

Line 2761: FND_MSG_PUB.Add;

2757: THEN
2758:
2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
2761: FND_MSG_PUB.Add;
2762:
2763: END IF;
2764:
2765: ELSE

Line 2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2782: IF p_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM THEN
2783:
2784: l_flow_schedule_rec.line_id := p_flow_schedule_rec.line_id;
2785:
2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2787: THEN
2788:
2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');

Line 2791: FND_MSG_PUB.Add;

2787: THEN
2788:
2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
2791: FND_MSG_PUB.Add;
2792:
2793: END IF;
2794:
2795: ELSE

Line 2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2812: IF p_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
2813:
2814: l_flow_schedule_rec.organization_id := p_flow_schedule_rec.organization_id;
2815:
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 2821: FND_MSG_PUB.Add;

2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2821: FND_MSG_PUB.Add;
2822:
2823: END IF;
2824:
2825: ELSE

Line 2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2842: IF p_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM THEN
2843:
2844: l_flow_schedule_rec.primary_item_id := p_flow_schedule_rec.primary_item_id;
2845:
2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2847: THEN
2848:
2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');

Line 2851: FND_MSG_PUB.Add;

2847: THEN
2848:
2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
2851: FND_MSG_PUB.Add;
2852:
2853: END IF;
2854:
2855: ELSE

Line 2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2872: IF p_flow_schedule_rec.project_id <> FND_API.G_MISS_NUM THEN
2873:
2874: l_flow_schedule_rec.project_id := p_flow_schedule_rec.project_id;
2875:
2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2877: THEN
2878:
2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');

Line 2881: FND_MSG_PUB.Add;

2877: THEN
2878:
2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2881: FND_MSG_PUB.Add;
2882:
2883: END IF;
2884:
2885: ELSE

Line 2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2902: IF p_flow_schedule_rec.schedule_group_id <> FND_API.G_MISS_NUM THEN
2903:
2904: l_flow_schedule_rec.schedule_group_id := p_flow_schedule_rec.schedule_group_id;
2905:
2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2907: THEN
2908:
2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');

Line 2911: FND_MSG_PUB.Add;

2907: THEN
2908:
2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
2911: FND_MSG_PUB.Add;
2912:
2913: END IF;
2914:
2915: ELSE

Line 2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2932: IF p_flow_schedule_rec.task_id <> FND_API.G_MISS_NUM THEN
2933:
2934: l_flow_schedule_rec.task_id := p_flow_schedule_rec.task_id;
2935:
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2937: THEN
2938:
2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');

Line 2941: FND_MSG_PUB.Add;

2937: THEN
2938:
2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2941: FND_MSG_PUB.Add;
2942:
2943: END IF;
2944:
2945: ELSE

Line 2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2962: IF p_flow_schedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
2963:
2964: l_flow_schedule_rec.wip_entity_id := p_flow_schedule_rec.wip_entity_id;
2965:
2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2967: THEN
2968:
2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');

Line 2971: FND_MSG_PUB.Add;

2967: THEN
2968:
2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
2971: FND_MSG_PUB.Add;
2972:
2973: END IF;
2974:
2975: ELSE

Line 3153: FND_MSG_PUB.Initialize;

3149: END Calculate_Totals;
3150:
3151: BEGIN
3152:
3153: FND_MSG_PUB.Initialize;
3154:
3155: --start bug 3783650: TZ BOM Calendar bug 3832684
3156: IF flm_timezone.g_enabled THEN
3157: --fix bug#3170105

Line 3273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3269: WHEN OTHERS THEN
3270:
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272:
3273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3274:
3275: FND_MSG_PUB.Add_Exc_Msg
3276: ( G_PKG_NAME
3277: , 'populate_flow_summary'

Line 3275: FND_MSG_PUB.Add_Exc_Msg

3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272:
3273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3274:
3275: FND_MSG_PUB.Add_Exc_Msg
3276: ( G_PKG_NAME
3277: , 'populate_flow_summary'
3278: );
3279: END IF;

Line 3294: FND_MSG_PUB.Initialize;

3290: p_quantity IN NUMBER ) IS
3291:
3292: BEGIN
3293:
3294: FND_MSG_PUB.Initialize;
3295:
3296: UPDATE wip_flow_schedules
3297: SET planned_quantity = planned_quantity + p_quantity
3298: WHERE wip_entity_id = p_wip_entity_id;

Line 3304: FND_MSG_PUB.Count_And_Get

3300: x_return_status := FND_API.G_RET_STS_SUCCESS;
3301:
3302: -- Get message count and data
3303:
3304: FND_MSG_PUB.Count_And_Get
3305: ( p_count => x_msg_count
3306: , p_data => x_msg_data
3307: );
3308:

Line 3315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3311: WHEN OTHERS THEN
3312:
3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3314:
3315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3316:
3317: FND_MSG_PUB.Add_Exc_Msg
3318: ( G_PKG_NAME
3319: , 'update_quantity'

Line 3317: FND_MSG_PUB.Add_Exc_Msg

3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3314:
3315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3316:
3317: FND_MSG_PUB.Add_Exc_Msg
3318: ( G_PKG_NAME
3319: , 'update_quantity'
3320: );
3321: END IF;

Line 3329: FND_MSG_PUB.Count_And_Get

3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3326:
3327: -- Get message count and data
3328:
3329: FND_MSG_PUB.Count_And_Get
3330: ( p_count => x_msg_count
3331: , p_data => x_msg_data
3332: );
3333:

Line 3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3346: EXCEPTION
3347:
3348: WHEN OTHERS THEN
3349:
3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3351:
3352: FND_MSG_PUB.Add_Exc_Msg
3353: ( G_PKG_NAME
3354: , 'update_quantity'

Line 3352: FND_MSG_PUB.Add_Exc_Msg

3348: WHEN OTHERS THEN
3349:
3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3351:
3352: FND_MSG_PUB.Add_Exc_Msg
3353: ( G_PKG_NAME
3354: , 'update_quantity'
3355: );
3356: END IF;

Line 3371: FND_MSG_PUB.Initialize;

3367: )
3368: IS
3369: BEGIN
3370:
3371: FND_MSG_PUB.Initialize;
3372:
3373: DELETE FROM WIP_FLOW_SCHEDULES
3374: WHERE WIP_ENTITY_ID = p_wip_entity_id
3375: AND status = 1

Line 3384: FND_MSG_PUB.Count_And_Get

3380: x_return_status := FND_API.G_RET_STS_SUCCESS;
3381:
3382: -- Get message count and data
3383:
3384: FND_MSG_PUB.Count_And_Get
3385: ( p_count => x_msg_count
3386: , p_data => x_msg_data
3387: );
3388: EXCEPTION

Line 3392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3388: EXCEPTION
3389:
3390: WHEN OTHERS THEN
3391:
3392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3393: THEN
3394: FND_MSG_PUB.Add_Exc_Msg
3395: ( G_PKG_NAME
3396: , 'Delete_Flow_Row'

Line 3394: FND_MSG_PUB.Add_Exc_Msg

3390: WHEN OTHERS THEN
3391:
3392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3393: THEN
3394: FND_MSG_PUB.Add_Exc_Msg
3395: ( G_PKG_NAME
3396: , 'Delete_Flow_Row'
3397: );
3398: END IF;

Line 3406: FND_MSG_PUB.Count_And_Get

3402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3403:
3404: -- Get message count and data
3405:
3406: FND_MSG_PUB.Count_And_Get
3407: ( p_count => x_msg_count
3408: , p_data => x_msg_data
3409: );
3410:

Line 6352: l_log_message := fnd_msg_pub.get(i,'F');

6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE
6350: IF l_msg_count > 0 THEN
6351: FOR i in 1..l_msg_count LOOP
6352: l_log_message := fnd_msg_pub.get(i,'F');
6353: MRP_UTIL.MRP_LOG(l_log_message);
6354: END LOOP;
6355: END IF;
6356: END IF;

Line 6953: l_log_message := fnd_msg_pub.get(i,'F');

6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE
6951: IF l_msg_count > 0 THEN
6952: FOR i in 1..l_msg_count LOOP
6953: l_log_message := fnd_msg_pub.get(i,'F');
6954: MRP_UTIL.MRP_LOG(l_log_message);
6955: END LOOP;
6956: END IF;
6957: END IF;

Line 7430: FND_MSG_PUB.Count_And_Get

7426: x_return_status := FND_API.G_RET_STS_ERROR;
7427:
7428: -- Get message count and data
7429:
7430: FND_MSG_PUB.Count_And_Get
7431: ( p_count => x_msg_count
7432: , p_data => x_msg_data
7433: );
7434:

Line 7441: FND_MSG_PUB.Count_And_Get

7437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7438:
7439: -- Get message count and data
7440:
7441: FND_MSG_PUB.Count_And_Get
7442: ( p_count => x_msg_count
7443: , p_data => x_msg_data
7444: );
7445:

Line 7450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7446: WHEN OTHERS THEN
7447:
7448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7449:
7450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7451: THEN
7452: FND_MSG_PUB.Add_Exc_Msg
7453: ( G_PKG_NAME
7454: , 'Line_Schedule'

Line 7452: FND_MSG_PUB.Add_Exc_Msg

7448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7449:
7450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7451: THEN
7452: FND_MSG_PUB.Add_Exc_Msg
7453: ( G_PKG_NAME
7454: , 'Line_Schedule'
7455: );
7456: END IF;

Line 7460: FND_MSG_PUB.Count_And_Get

7456: END IF;
7457:
7458: -- Get message count and data
7459:
7460: FND_MSG_PUB.Count_And_Get
7461: ( p_count => x_msg_count
7462: , p_data => x_msg_data
7463: );
7464:

Line 7580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7576: IF l_error_code = 9998 THEN
7577: -- Do nothing, there was just no bill to explode
7578: NULL;
7579: ELSIF l_error_code <> 0 THEN
7580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7581: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7582: FND_MSG_PUB.Add;
7583: END IF;
7584: RAISE FND_API.G_EXC_ERROR;

Line 7582: FND_MSG_PUB.Add;

7578: NULL;
7579: ELSIF l_error_code <> 0 THEN
7580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7581: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7582: FND_MSG_PUB.Add;
7583: END IF;
7584: RAISE FND_API.G_EXC_ERROR;
7585: END IF;
7586: