DBA Data[Home] [Help]

APPS.OE_CONFIG_UTIL dependencies on OE_MSG_PUB

Line 922: OE_MSG_PUB.Add;

918: l_line_rec.service_number,'.');
919: FND_MESSAGE.Set_Name('ONT', 'ONT_DELINK_NOT_ALLOWED');
920: FND_MESSAGE.Set_Token('LINE_NUM', l_line_num);
921: FND_MESSAGE.Set_Token('MODEL', l_line_rec.ordered_item);
922: OE_MSG_PUB.Add;
923: RETURN;
924: END IF;
925:
926: END IF; */

Line 995: oe_msg_pub.count_and_get

991: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: oe_msg_pub.count_and_get
996: ( p_count => l_msg_count
997: ,p_data => l_msg_data );
998:
999: -- if everything is OK.

Line 1013: oe_msg_pub.count_and_get

1009: WHEN FND_API.G_EXC_ERROR THEN
1010:
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: -- Get message count and data
1013: oe_msg_pub.count_and_get
1014: ( p_count => l_msg_count
1015: , p_data => l_msg_data
1016: );
1017:

Line 1022: oe_msg_pub.count_and_get

1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019:
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: -- Get message count and data
1022: oe_msg_pub.count_and_get
1023: ( p_count => l_msg_count
1024: , p_data => l_msg_data
1025: );
1026:

Line 1032: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add('ERROR: ' || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
1030: END IF;
1031:
1032: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: oe_msg_pub.Add_Exc_Msg
1035: ( G_PKG_NAME
1036: , 'Oe_Config_Util'

Line 1034: oe_msg_pub.Add_Exc_Msg

1030: END IF;
1031:
1032: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: oe_msg_pub.Add_Exc_Msg
1035: ( G_PKG_NAME
1036: , 'Oe_Config_Util'
1037: );
1038: END IF;

Line 1041: oe_msg_pub.count_and_get

1037: );
1038: END IF;
1039:
1040: -- Get message count and data
1041: oe_msg_pub.count_and_get
1042: ( p_count => l_msg_count
1043: , p_data => l_msg_data
1044: );
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1189: OE_MSG_PUB.Transfer_Msg_stack;

1185: IF l_debug_level > 0 THEN
1186: oe_debug_pub.add(' After calling CZ lock API ' || l_return_status || l_msg_data,2);
1187: END IF;
1188: IF l_msg_count > 0 THEN
1189: OE_MSG_PUB.Transfer_Msg_stack;
1190:
1191: END IF;
1192: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1193: RETURN l_return_status;

Line 1472: OE_Msg_Pub.Add;

1468: x_return_status => l_return_status);
1469:
1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1471: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1472: OE_Msg_Pub.Add;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1476: OE_Msg_Pub.Add;

Line 1476: OE_Msg_Pub.Add;

1472: OE_Msg_Pub.Add;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1476: OE_Msg_Pub.Add;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: IF l_debug_level > 0 THEN

Line 1851: OE_MSG_PUB.Add;

1847: END IF;
1848:
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NOT_IN_OPTIONS_WINDOW');
1851: OE_MSG_PUB.Add;
1852: RETURN;
1853: END IF;
1854:
1855: END IF;

Line 2272: Oe_Msg_Pub.Add;

2268: ELSE
2269: FND_MESSAGE.SET_NAME('ONT','ONT_CONFIG_INSERT_DELETE');
2270: FND_MESSAGE.Set_Token('CLASS',p_parent_item);
2271: FND_MESSAGE.Set_Token('ITEM',p_x_options_tbl(I).ordered_item);
2272: Oe_Msg_Pub.Add;
2273: IF l_debug_level > 0 THEN
2274: oe_debug_pub.add('OPERATION IS INSERT IN PROCEDURE DELETE_CHILDREN');
2275: oe_debug_pub.add('parent class : ' || p_parent_item);
2276: oe_debug_pub.add('child item : ' || p_x_options_tbl(I).ordered_item);

Line 2700: OE_Msg_Pub.Set_Msg_Context

2696: WHEN OTHERS THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END;
2699:
2700: OE_Msg_Pub.Set_Msg_Context
2701: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
2702: ,p_entity_id => p_model_line_id
2703: ,p_header_id => l_header_id
2704: ,p_line_id => p_model_line_id

Line 2787: OE_Msg_Pub.Add;

2783: END IF;
2784:
2785: IF l_configurator_was_used <> 0 AND l_use_configurator THEN
2786: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_USE_OPTIONS_WINDOW');
2787: OE_Msg_Pub.Add;
2788: x_return_status:= FND_API.G_RET_STS_ERROR;
2789: END IF;
2790:
2791: IF l_configurator_was_used <> 1 AND NOT (l_use_configurator) THEN

Line 2793: OE_Msg_Pub.Add;

2789: END IF;
2790:
2791: IF l_configurator_was_used <> 1 AND NOT (l_use_configurator) THEN
2792: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_USE_CONFIGURATOR');
2793: OE_Msg_Pub.Add;
2794: x_return_status:= FND_API.G_RET_STS_ERROR;
2795: END IF;
2796:
2797: --get_transaction_id(p_caller => ' leaving validate_config');

Line 2799: oe_msg_pub.count_and_get

2795: END IF;
2796:
2797: --get_transaction_id(p_caller => ' leaving validate_config');
2798:
2799: oe_msg_pub.count_and_get
2800: ( p_count => l_msg_count
2801: , p_data => l_msg_data );
2802:
2803:

Line 3204: OE_Msg_Pub.Add;

3200: --(p_caller => 'send_xml exc error, before call to SPC validate');
3201:
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
3204: OE_Msg_Pub.Add;
3205:
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3207: --get_transaction_id
3208: --(p_caller => 'send_xml unxp, before call to SPC validate');

Line 3724: oe_msg_pub.add_text(L_MESSAGE_TEXT);

3720:
3721: END IF;
3722:
3723: IF L_MESSAGE_TEXT IS NOT NULL THEN
3724: oe_msg_pub.add_text(L_MESSAGE_TEXT);
3725: END IF;
3726:
3727: IF l_exit is NULL OR
3728: l_exit = 'ERROR' THEN

Line 3980: -- oe_msg_pub.add;

3976: END IF;
3977:
3978: -- girish from bom team told err_msg is msg name, track bug 1623728
3979: -- FND_MESSAGE.Set_Name('BOM', x_msg_data);
3980: -- oe_msg_pub.add;
3981: -- After BOM ER 2700606, BOM is sending a complete message
3982: oe_msg_pub.add_text(p_message_text => x_msg_data);
3983:
3984: END IF;

Line 3982: oe_msg_pub.add_text(p_message_text => x_msg_data);

3978: -- girish from bom team told err_msg is msg name, track bug 1623728
3979: -- FND_MESSAGE.Set_Name('BOM', x_msg_data);
3980: -- oe_msg_pub.add;
3981: -- After BOM ER 2700606, BOM is sending a complete message
3982: oe_msg_pub.add_text(p_message_text => x_msg_data);
3983:
3984: END IF;
3985:
3986: RAISE FND_API.G_EXC_ERROR;

Line 4752: oe_msg_pub.count_and_get

4748: p_top_model_line_id => l_parent_line_rec.top_model_line_id,
4749: x_return_status => l_return_status);
4750: END IF;
4751:
4752: oe_msg_pub.count_and_get
4753: ( p_count => l_msg_count
4754: ,p_data => l_msg_data );
4755:
4756: END IF; -- count > 0

Line 4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4778:
4779: EXCEPTION
4780: WHEN FND_API.G_EXC_ERROR THEN
4781: -- bug 4683857
4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4783: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4784: END IF;
4785: RETURN FND_API.G_RET_STS_ERROR;
4786:

Line 4783: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');

4779: EXCEPTION
4780: WHEN FND_API.G_EXC_ERROR THEN
4781: -- bug 4683857
4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4783: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4784: END IF;
4785: RETURN FND_API.G_RET_STS_ERROR;
4786:
4787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4784: END IF;
4785: RETURN FND_API.G_RET_STS_ERROR;
4786:
4787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4789: THEN
4790: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4791: END IF;
4792: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

Line 4790: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');

4786:
4787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4789: THEN
4790: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4791: END IF;
4792: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4793: WHEN OTHERS THEN
4794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4790: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4791: END IF;
4792: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4793: WHEN OTHERS THEN
4794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4795: THEN
4796: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4797: END IF;
4798: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

Line 4796: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');

4792: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4793: WHEN OTHERS THEN
4794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4795: THEN
4796: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4797: END IF;
4798: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4799: END Process_Included_Items;
4800:

Line 5715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5712:
5713: WHEN OTHERS THEN
5714:
5715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5716: THEN
5717: IF l_debug_level > 0 THEN
5718: oe_debug_pub.add('OTHERS IN QUERY_CONFIG' , 1);
5719: END IF;

Line 5720: OE_MSG_PUB.Add_Exc_Msg

5716: THEN
5717: IF l_debug_level > 0 THEN
5718: oe_debug_pub.add('OTHERS IN QUERY_CONFIG' , 1);
5719: END IF;
5720: OE_MSG_PUB.Add_Exc_Msg
5721: ( G_PKG_NAME
5722: , 'Query_Config'
5723: );
5724: END IF;

Line 5950: oe_msg_pub.add;

5946:
5947: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_IN_BILL');
5948: FND_MESSAGE.Set_Token('COMPONENT', nvl(line_rec.ordered_item,line_rec.inventory_item_id));
5949: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_top_item_id));
5950: oe_msg_pub.add;
5951: RETURN;
5952:
5953: WHEN TOO_MANY_ROWS THEN
5954: IF l_debug_level > 0 THEN

Line 5964: oe_msg_pub.add;

5960:
5961: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
5962: FND_MESSAGE.Set_Token('COMPONENT', nvl(line_rec.ordered_item,line_rec.inventory_item_id));
5963: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_top_item_id));
5964: oe_msg_pub.add;
5965: RETURN;
5966:
5967: WHEN OTHERS THEN
5968: IF l_debug_level > 0 THEN

Line 6091: OE_Msg_Pub.Add;

6087: x_error_msg_name => l_message_name);
6088:
6089: IF l_message_name IS NOT NULL THEN
6090: FND_MESSAGE.Set_Name('BOM', l_message_name);
6091: OE_Msg_Pub.Add;
6092: END IF;
6093: END IF;
6094: ELSE -- if config_id null
6095: FND_MESSAGE.Set_Name('BOM', l_message_name);

Line 6096: OE_Msg_Pub.Add; -- config_id is null

6092: END IF;
6093: END IF;
6094: ELSE -- if config_id null
6095: FND_MESSAGE.Set_Name('BOM', l_message_name);
6096: OE_Msg_Pub.Add; -- config_id is null
6097: END IF;
6098:
6099: ELSE -- if cto return true for match
6100: FND_MESSAGE.Set_Name('BOM', l_message_name);

Line 6101: OE_Msg_Pub.Add;

6097: END IF;
6098:
6099: ELSE -- if cto return true for match
6100: FND_MESSAGE.Set_Name('BOM', l_message_name);
6101: OE_Msg_Pub.Add;
6102: END IF; -- if match found
6103:
6104: x_return_status := l_return_status;
6105: IF l_debug_level > 0 THEN

Line 6250: OE_MSG_PUB.Add;

6246: IF(nvl(l_autorization_status,'z')= 'APPROVED') THEN
6247: FND_MESSAGE.Set_Name('ONT', 'ONT_DELINK_NOT_ALLOWED');
6248: FND_MESSAGE.Set_Token('LINE_NUM', l_line_num);
6249: FND_MESSAGE.Set_Token('MODEL', l_ordered_item);
6250: OE_MSG_PUB.Add;
6251: RETURN;
6252: END IF;
6253:
6254: END IF;

Line 6284: oe_msg_pub.add;

6280: oe_debug_pub.add('CTO RESULT NOT 1' , 2 );
6281: END IF;
6282: IF l_message_name IS NOT NULL THEN
6283: FND_MESSAGE.Set_Name('BOM', l_message_name);
6284: oe_msg_pub.add;
6285: ELSE
6286: IF l_debug_level > 0 THEN
6287: oe_debug_pub.add('CTO MESSAGE NAME NULL' , 2 );
6288: END IF;

Line 6297: oe_msg_pub.add;

6293: oe_debug_pub.add('DELINK_CONFIG_ITEM ALLOWED ONLY FROM ATO MODEL',1);
6294: END IF;
6295: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_INVALID_ACTION');
6296: FND_MESSAGE.Set_Token('ACTION', 'Delink Config');
6297: oe_msg_pub.add;
6298: END IF;
6299:
6300: IF l_debug_level > 0 THEN
6301: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.DELINK_CONFIG' , 1);

Line 6310: oe_msg_pub.add;

6306: EXCEPTION
6307: WHEN NO_DATA_FOUND THEN
6308: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_NO_ITEM_TO_DELINK');
6309: FND_MESSAGE.Set_Token('MODEL', nvl(l_ordered_item,l_inv_item_id));
6310: oe_msg_pub.add;
6311: x_return_status := FND_API.G_RET_STS_ERROR;
6312:
6313: WHEN OTHERS THEN
6314: IF l_debug_level > 0 THEN

Line 6468: oe_msg_pub.add();

6464: x_message_name => l_message_name );
6465:
6466: IF NOT (l_result) THEN
6467: FND_MESSAGE.Set_Name('BOM', l_message_name);
6468: oe_msg_pub.add();
6469: END IF;
6470:
6471: ELSE
6472: IF l_debug_level > 0 THEN

Line 6477: oe_msg_pub.add;

6473: oe_debug_pub.add('LINK_CONFIG_ITEM ALLOWED ONLY FROM ATO MODEL', 2 );
6474: END IF;
6475: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_INVALID_ACTION');
6476: FND_MESSAGE.Set_Token('ACTION', 'Link Config');
6477: oe_msg_pub.add;
6478: END IF;
6479:
6480: IF l_debug_level > 0 THEN
6481: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.LINK_CONFIG' , 1);

Line 6494: OE_Msg_Pub.add;

6490: END IF;
6491:
6492: IF l_valid = 0 THEN
6493: FND_MESSAGE.Set_Name('BOM', 'CTO_INVALID_LINK_ERROR');
6494: OE_Msg_Pub.add;
6495: END IF;
6496:
6497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6498: END Link_Config;

Line 7003: OE_Msg_Pub.Add;

6999:
7000: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
7001: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
7002:
7003: OE_Msg_Pub.Add;
7004:
7005: IF l_debug_level > 0 THEN
7006: oe_debug_pub.add('LEAVING DECIMAL_RATIO_CHECK' , 3 );
7007: END IF;

Line 7129: OE_Msg_Pub.add();

7125: END IF;
7126: FND_Message.Set_Name('ONT', 'OE_CONFIG_WRONG_MODEL_LINK');
7127: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_x_child_line_rec.ordered_item
7128: ,p_x_child_line_rec.inventory_item_id));
7129: OE_Msg_Pub.add();
7130: x_return_status := FND_API.G_RET_STS_ERROR;
7131: RAISE FND_API.G_EXC_ERROR;
7132: END IF;
7133:

Line 8478: OE_Msg_Pub.Add_Text(l_msg);

8474: LOOP
8475: FETCH messages into l_constraint,l_msg;
8476: EXIT when messages%notfound;
8477:
8478: OE_Msg_Pub.Add_Text(l_msg);
8479: oe_debug_pub.add('msg from spc: '||messages%rowcount , 2);
8480: oe_debug_pub.add('msg from spc: '|| substr(l_msg, 1, 250) , 3);
8481:
8482: END LOOP;

Line 8487: OE_Msg_Pub.Add;

8483:
8484: IF nvl(p_valid_config, 'FALSE') = 'FALSE' THEN
8485:
8486: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
8487: OE_Msg_Pub.Add;
8488: END IF;
8489:
8490: IF nvl(p_complete_config, 'FALSE') = 'FALSE' THEN
8491:

Line 8506: OE_Msg_Pub.Add;

8502: END;
8503:
8504: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_INCOMPLETE_MODEL');
8505: FND_MESSAGE.SET_TOKEN('MODEL',l_message_text);
8506: OE_Msg_Pub.Add;
8507:
8508: END IF;
8509:
8510: EXCEPTION

Line 8879: OE_MSG_PUB.Transfer_Msg_Stack;

8875: END IF;
8876:
8877: IF l_msg_count > 0 THEN
8878:
8879: OE_MSG_PUB.Transfer_Msg_Stack;
8880:
8881: END IF;
8882:
8883:

Line 9162: oe_msg_pub.add;

9158: oe_debug_pub.add(' The count of Included Items are not same',5);
9159: end if;
9160: l_return_status := FND_API.G_RET_STS_ERROR;
9161: FND_MESSAGE.Set_Name('ONT', 'OE_DOO_INVALID_BOM');
9162: oe_msg_pub.add;
9163: RAISE FND_API.G_EXC_ERROR;
9164: END IF;
9165:
9166: IF l_Bom_Explosion_Tbl.COUNT > 0 THEN

Line 9199: oe_msg_pub.add;

9195: end if;
9196: l_validation_status := FALSE;
9197: l_return_status := FND_API.G_RET_STS_ERROR;
9198: FND_MESSAGE.Set_Name('ONT', 'OE_DOO_INVALID_QTY_RATIO');
9199: oe_msg_pub.add;
9200: END IF;
9201:
9202: -- Ordered Quantity UOM Check
9203: -- There is an assumption from DOO that DOO UOM, EBS OM UOM

Line 9216: oe_msg_pub.add;

9212: end if;
9213: l_validation_status := FALSE;
9214: l_return_status := FND_API.G_RET_STS_ERROR;
9215: FND_MESSAGE.Set_Name('ONT', 'OE_DOO_INVALID_UOM');
9216: oe_msg_pub.add;
9217: END IF;
9218:
9219: IF l_validation_status THEN
9220: if l_debug_level > 0 then

Line 9245: oe_msg_pub.add;

9241: oe_debug_pub.add(' Invalid Association between the Included Item and its immediate parent',1);
9242: end if;
9243: l_return_status := FND_API.G_RET_STS_ERROR;
9244: FND_MESSAGE.Set_Name('ONT', 'OE_DOO_INVALID_BOM');
9245: oe_msg_pub.add;
9246: RAISE FND_API.G_EXC_ERROR;
9247: END IF;
9248:
9249: -- Since there is a valid match found and updated

Line 9265: oe_msg_pub.add;

9261: end if;
9262: l_validation_status := FALSE;
9263: l_return_status := FND_API.G_RET_STS_ERROR;
9264: FND_MESSAGE.Set_Name('ONT', 'OE_DOO_INVALID_ITEM');
9265: oe_msg_pub.add;
9266: END IF;
9267:
9268: IF NOT(l_validation_status) THEN
9269: if l_debug_level > 0 then

Line 9274: oe_msg_pub.add;

9270: oe_debug_pub.add(' BOM Validation Failure',1);
9271: end if;
9272: l_return_status := FND_API.G_RET_STS_ERROR;
9273: FND_MESSAGE.Set_Name('ONT', 'OE_DOO_INVALID_BOM');
9274: oe_msg_pub.add;
9275: RAISE FND_API.G_EXC_ERROR;
9276: END IF;
9277:
9278: ELSE

Line 9326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9324: WHEN OTHERS THEN
9325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9327: OE_MSG_PUB.Add_Exc_Msg
9328: ( G_PKG_NAME
9329: , 'Process_Pre_Exploded_Kits'
9330: );

Line 9327: OE_MSG_PUB.Add_Exc_Msg

9323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9324: WHEN OTHERS THEN
9325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9327: OE_MSG_PUB.Add_Exc_Msg
9328: ( G_PKG_NAME
9329: , 'Process_Pre_Exploded_Kits'
9330: );
9331: END IF;