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 1195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1191: EXCEPTION
1192:
1193: WHEN OTHERS THEN
1194: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1196: THEN
1197: l_err_text := G_PKG_NAME ||' : Utility (Component Replicate) '
1198: || SUBSTR(SQLERRM, 1, 200);
1199: Error_Handler.Add_Error_Token

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

1709: WHEN OTHERS THEN
1710: --dbms_output.put_line(' SQL Error '||SQLERRM);
1711: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error occured in Insert . . .' || SQLERRM); END IF;
1712:
1713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1714: THEN
1715: l_err_text := G_PKG_NAME ||' : Utility (Related Component Insert) '
1716: ||SUBSTR(SQLERRM, 1, 200);
1717: Error_Handler.Add_Error_Token

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

1720: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1721: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1722: );
1723: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1724: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1725: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
1726: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1727:
1728: END Insert_Related_Components;

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

2077:
2078: EXCEPTION
2079:
2080: WHEN OTHERS THEN
2081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2082: THEN
2083: l_err_text := G_PKG_NAME ||' : Utility (Related Component Update) '
2084: ||SUBSTR(SQLERRM, 1, 200);
2085: Error_Handler.Add_Error_Token

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

2088: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2089: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2090: );
2091: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2092: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2093: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2094: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2095: END Update_Related_Components;
2096:

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

2219: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: --dbms_output.put_line(' Error '||SQLERRM);
2223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2224: THEN
2225: l_err_text := G_PKG_NAME ||' : Common BOM (Ref Desg Replicate) '
2226: ||SUBSTR(SQLERRM, 1, 200);
2227: Error_Handler.Add_Error_Token

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

2377: end loop;--for ref_desg in get_ref_desg_details(p_component_sequence_id, p_ref_desg)
2378: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2382: THEN
2383: l_err_text := G_PKG_NAME ||' : Common BOM (Related Ref Desg Insert) '
2384: ||SUBSTR(SQLERRM, 1, 200);
2385: Error_Handler.Add_Error_Token

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

2654:
2655: EXCEPTION
2656:
2657: WHEN OTHERS THEN
2658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2659: THEN
2660: l_err_text := G_PKG_NAME ||'Utility (Substitute Component Replicate)'
2661: ||SUBSTR(SQLERRM, 1, 100);
2662: Error_Handler.Add_Error_Token

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

2664: , p_Message_text => l_err_text
2665: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2666: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2667: );
2668: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2669: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2670: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
2671: --arudresh_debug('error in replicate sub comp '||SQLERRM);
2672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2815:
2816: EXCEPTION
2817:
2818: WHEN OTHERS THEN
2819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2820: THEN
2821: l_err_text := G_PKG_NAME ||'Utility (Related Substitute Component Insert)'
2822: ||SUBSTR(SQLERRM, 1, 100);
2823: Error_Handler.Add_Error_Token

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

2825: , p_Message_text => l_err_text
2826: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2827: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2828: );
2829: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2830: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2831: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833: END Insert_Related_Sub_Comp;

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

2931: x_return_status := FND_API.G_RET_STS_SUCCESS;
2932: EXCEPTION
2933:
2934: WHEN OTHERS THEN
2935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2936: THEN
2937: l_err_text := G_PKG_NAME ||'Utility (Related Substitute Component Insert)'
2938: ||SUBSTR(SQLERRM, 1, 100);
2939: Error_Handler.Add_Error_Token

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

2941: , p_Message_text => l_err_text
2942: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2943: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2944: );
2945: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2946: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2947: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2949: END Update_Related_Sub_Comp;

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

3138:
3139: EXCEPTION
3140:
3141: WHEN OTHERS THEN
3142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3143: THEN
3144: l_err_text := G_PKG_NAME ||'Utility (Component Operations Replicate)'
3145: ||SUBSTR(SQLERRM, 1, 100);
3146: Error_Handler.Add_Error_Token

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

3148: , p_Message_text => l_err_text
3149: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3150: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3151: );
3152: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3153: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3154: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3156: END Replicate_Comp_Ops;

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

3278:
3279: EXCEPTION
3280:
3281: WHEN OTHERS THEN
3282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3283: THEN
3284: l_err_text := G_PKG_NAME ||'Utility (Related Component Operation Insert)'
3285: ||SUBSTR(SQLERRM, 1, 100);
3286: Error_Handler.Add_Error_Token

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

3288: , p_Message_text => l_err_text
3289: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3290: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3291: );
3292: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3293: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3294: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3296: END Insert_Related_Comp_Ops;

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

3394: x_return_status := FND_API.G_RET_STS_SUCCESS;
3395: EXCEPTION
3396:
3397: WHEN OTHERS THEN
3398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3399: THEN
3400: l_err_text := G_PKG_NAME ||'Utility (Related Component Operation Insert)'
3401: ||SUBSTR(SQLERRM, 1, 100);
3402: Error_Handler.Add_Error_Token

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

3404: , p_Message_text => l_err_text
3405: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3406: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3407: );
3408: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3409: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3410: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3412: END Update_Related_Comp_Ops;