DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FND_MSG_PUB

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

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

Line 1683: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1863: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1891: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2060: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2593: FND_MSG_PUB.Add;

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

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

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

Line 2610: FND_MSG_PUB.Add;

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

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

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

Line 2622: FND_MSG_PUB.Add;

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

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

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

Line 2632: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2764: FND_MSG_PUB.Add;

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

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

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

Line 2794: FND_MSG_PUB.Add;

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

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

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

Line 2824: FND_MSG_PUB.Add;

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

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

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

Line 2854: FND_MSG_PUB.Add;

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

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

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

Line 2884: FND_MSG_PUB.Add;

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

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

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

Line 2914: FND_MSG_PUB.Add;

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

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

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

Line 2944: FND_MSG_PUB.Add;

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

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

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

Line 2974: FND_MSG_PUB.Add;

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

Line 3156: FND_MSG_PUB.Initialize;

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

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

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

Line 3278: FND_MSG_PUB.Add_Exc_Msg

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

Line 3297: FND_MSG_PUB.Initialize;

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

Line 3307: FND_MSG_PUB.Count_And_Get

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

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

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

Line 3320: FND_MSG_PUB.Add_Exc_Msg

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

Line 3332: FND_MSG_PUB.Count_And_Get

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

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

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

Line 3355: FND_MSG_PUB.Add_Exc_Msg

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

Line 3374: FND_MSG_PUB.Initialize;

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

Line 3387: FND_MSG_PUB.Count_And_Get

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

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

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

Line 3397: FND_MSG_PUB.Add_Exc_Msg

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

Line 3409: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 7455: FND_MSG_PUB.Count_And_Get

7451: x_return_status := FND_API.G_RET_STS_ERROR;
7452:
7453: -- Get message count and data
7454:
7455: FND_MSG_PUB.Count_And_Get
7456: ( p_count => x_msg_count
7457: , p_data => x_msg_data
7458: );
7459:

Line 7466: FND_MSG_PUB.Count_And_Get

7462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7463:
7464: -- Get message count and data
7465:
7466: FND_MSG_PUB.Count_And_Get
7467: ( p_count => x_msg_count
7468: , p_data => x_msg_data
7469: );
7470:

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

7471: WHEN OTHERS THEN
7472:
7473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7474:
7475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7476: THEN
7477: FND_MSG_PUB.Add_Exc_Msg
7478: ( G_PKG_NAME
7479: , 'Line_Schedule'

Line 7477: FND_MSG_PUB.Add_Exc_Msg

7473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7474:
7475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7476: THEN
7477: FND_MSG_PUB.Add_Exc_Msg
7478: ( G_PKG_NAME
7479: , 'Line_Schedule'
7480: );
7481: END IF;

Line 7485: FND_MSG_PUB.Count_And_Get

7481: END IF;
7482:
7483: -- Get message count and data
7484:
7485: FND_MSG_PUB.Count_And_Get
7486: ( p_count => x_msg_count
7487: , p_data => x_msg_data
7488: );
7489:

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

7603: NULL;
7604: ELSIF l_error_code = 9996 THEN --Bug 10282308. No Exception when it's already being exploded in another session.
7605: NULL;
7606: ELSIF l_error_code <> 0 THEN
7607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7608: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7609: FND_MSG_PUB.Add;
7610: END IF;
7611: RAISE FND_API.G_EXC_ERROR;

Line 7609: FND_MSG_PUB.Add;

7605: NULL;
7606: ELSIF l_error_code <> 0 THEN
7607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7608: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7609: FND_MSG_PUB.Add;
7610: END IF;
7611: RAISE FND_API.G_EXC_ERROR;
7612: END IF;
7613: