DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on FND_MSG_PUB

Line 106: FND_MSG_PUB.Get(

102: END IF;
103:
104: EXCEPTION
105: WHEN SEND_ACKN_ERROR THEN
106: FND_MSG_PUB.Get(
107: p_msg_index => 1,
108: p_data => l_msg_data,
109: p_encoded => FND_API.G_FALSE,
110: p_msg_index_out => l_dummy_cnt);

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

1396: EXCEPTION
1397:
1398: WHEN OTHERS THEN
1399: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1401: THEN
1402: l_err_text := G_PKG_NAME ||' : Utility (Component Replicate) '
1403: || SUBSTR(SQLERRM, 1, 200);
1404: Error_Handler.Add_Error_Token

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

1914: WHEN OTHERS THEN
1915: --dbms_output.put_line(' SQL Error '||SQLERRM);
1916: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1917:
1918: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1919: THEN
1920: l_err_text := G_PKG_NAME ||' : Utility (Related Component Insert) '
1921: ||SUBSTR(SQLERRM, 1, 200);
1922: Error_Handler.Add_Error_Token

Line 1929: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1925: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1926: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1927: );
1928: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1929: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1930: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
1931: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1932:
1933: END Insert_Related_Components;

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

2369:
2370: EXCEPTION
2371:
2372: WHEN OTHERS THEN
2373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2374: THEN
2375: l_err_text := G_PKG_NAME ||' : Utility (Related Component Update) '
2376: ||SUBSTR(SQLERRM, 1, 200);
2377: Error_Handler.Add_Error_Token

Line 2384: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2380: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2381: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2382: );
2383: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2384: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2385: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2386: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2387: END Update_Related_Components;
2388:

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

2511: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2512: EXCEPTION
2513: WHEN OTHERS THEN
2514: --dbms_output.put_line(' Error '||SQLERRM);
2515: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2516: THEN
2517: l_err_text := G_PKG_NAME ||' : Common BOM (Ref Desg Replicate) '
2518: ||SUBSTR(SQLERRM, 1, 200);
2519: Error_Handler.Add_Error_Token

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

2669: end loop;--for ref_desg in get_ref_desg_details(p_component_sequence_id, p_ref_desg)
2670: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2671: EXCEPTION
2672: WHEN OTHERS THEN
2673: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2674: THEN
2675: l_err_text := G_PKG_NAME ||' : Common BOM (Related Ref Desg Insert) '
2676: ||SUBSTR(SQLERRM, 1, 200);
2677: Error_Handler.Add_Error_Token

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

2946:
2947: EXCEPTION
2948:
2949: WHEN OTHERS THEN
2950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2951: THEN
2952: l_err_text := G_PKG_NAME ||'Utility (Substitute Component Replicate)'
2953: ||SUBSTR(SQLERRM, 1, 100);
2954: Error_Handler.Add_Error_Token

Line 2960: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2956: , p_Message_text => l_err_text
2957: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2958: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2959: );
2960: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2961: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2962: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
2963: --arudresh_debug('error in replicate sub comp '||SQLERRM);
2964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3107:
3108: EXCEPTION
3109:
3110: WHEN OTHERS THEN
3111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3112: THEN
3113: l_err_text := G_PKG_NAME ||'Utility (Related Substitute Component Insert)'
3114: ||SUBSTR(SQLERRM, 1, 100);
3115: Error_Handler.Add_Error_Token

Line 3121: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3117: , p_Message_text => l_err_text
3118: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3119: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3120: );
3121: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3122: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3123: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: END Insert_Related_Sub_Comp;

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

3223: x_return_status := FND_API.G_RET_STS_SUCCESS;
3224: EXCEPTION
3225:
3226: WHEN OTHERS THEN
3227: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3228: THEN
3229: l_err_text := G_PKG_NAME ||'Utility (Related Substitute Component Insert)'
3230: ||SUBSTR(SQLERRM, 1, 100);
3231: Error_Handler.Add_Error_Token

Line 3237: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3233: , p_Message_text => l_err_text
3234: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3235: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3236: );
3237: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3238: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3239: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3241: END Update_Related_Sub_Comp;

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

3430:
3431: EXCEPTION
3432:
3433: WHEN OTHERS THEN
3434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3435: THEN
3436: l_err_text := G_PKG_NAME ||'Utility (Component Operations Replicate)'
3437: ||SUBSTR(SQLERRM, 1, 100);
3438: Error_Handler.Add_Error_Token

Line 3444: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3440: , p_Message_text => l_err_text
3441: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3442: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3443: );
3444: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3445: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3446: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
3447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3448: END Replicate_Comp_Ops;

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

3570:
3571: EXCEPTION
3572:
3573: WHEN OTHERS THEN
3574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3575: THEN
3576: l_err_text := G_PKG_NAME ||'Utility (Related Component Operation Insert)'
3577: ||SUBSTR(SQLERRM, 1, 100);
3578: Error_Handler.Add_Error_Token

Line 3584: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3580: , p_Message_text => l_err_text
3581: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3582: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3583: );
3584: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3585: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3586: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3588: END Insert_Related_Comp_Ops;

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

3686: x_return_status := FND_API.G_RET_STS_SUCCESS;
3687: EXCEPTION
3688:
3689: WHEN OTHERS THEN
3690: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3691: THEN
3692: l_err_text := G_PKG_NAME ||'Utility (Related Component Operation Insert)'
3693: ||SUBSTR(SQLERRM, 1, 100);
3694: Error_Handler.Add_Error_Token

Line 3700: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3696: , p_Message_text => l_err_text
3697: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3698: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3699: );
3700: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3701: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3702: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3704: END Update_Related_Comp_Ops;