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 1849: OE_MSG_PUB.Add;

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

Line 2270: Oe_Msg_Pub.Add;

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

Line 2698: OE_Msg_Pub.Set_Msg_Context

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

Line 2785: OE_Msg_Pub.Add;

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

Line 2791: OE_Msg_Pub.Add;

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

Line 2797: oe_msg_pub.count_and_get

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

Line 3198: OE_Msg_Pub.Add;

3194: --(p_caller => 'send_xml exc error, before call to SPC validate');
3195:
3196: x_return_status := FND_API.G_RET_STS_ERROR;
3197: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
3198: OE_Msg_Pub.Add;
3199:
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3201: --get_transaction_id
3202: --(p_caller => 'send_xml unxp, before call to SPC validate');

Line 3718: oe_msg_pub.add_text(L_MESSAGE_TEXT);

3714:
3715: END IF;
3716:
3717: IF L_MESSAGE_TEXT IS NOT NULL THEN
3718: oe_msg_pub.add_text(L_MESSAGE_TEXT);
3719: END IF;
3720:
3721: IF l_exit is NULL OR
3722: l_exit = 'ERROR' THEN

Line 3974: -- oe_msg_pub.add;

3970: END IF;
3971:
3972: -- girish from bom team told err_msg is msg name, track bug 1623728
3973: -- FND_MESSAGE.Set_Name('BOM', x_msg_data);
3974: -- oe_msg_pub.add;
3975: -- After BOM ER 2700606, BOM is sending a complete message
3976: oe_msg_pub.add_text(p_message_text => x_msg_data);
3977:
3978: END IF;

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

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

Line 4746: oe_msg_pub.count_and_get

4742: p_top_model_line_id => l_parent_line_rec.top_model_line_id,
4743: x_return_status => l_return_status);
4744: END IF;
4745:
4746: oe_msg_pub.count_and_get
4747: ( p_count => l_msg_count
4748: ,p_data => l_msg_data );
4749:
4750: END IF; -- count > 0

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

4772:
4773: EXCEPTION
4774: WHEN FND_API.G_EXC_ERROR THEN
4775: -- bug 4683857
4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4777: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4778: END IF;
4779: RETURN FND_API.G_RET_STS_ERROR;
4780:

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

4773: EXCEPTION
4774: WHEN FND_API.G_EXC_ERROR THEN
4775: -- bug 4683857
4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4777: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4778: END IF;
4779: RETURN FND_API.G_RET_STS_ERROR;
4780:
4781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

4780:
4781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4783: THEN
4784: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4785: END IF;
4786: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4787: WHEN OTHERS THEN
4788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

4784: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4785: END IF;
4786: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4787: WHEN OTHERS 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: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4787: WHEN OTHERS 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: END Process_Included_Items;
4794:

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

5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705:
5706: WHEN OTHERS THEN
5707:
5708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5709: THEN
5710: IF l_debug_level > 0 THEN
5711: oe_debug_pub.add('OTHERS IN QUERY_CONFIG' , 1);
5712: END IF;

Line 5713: OE_MSG_PUB.Add_Exc_Msg

5709: THEN
5710: IF l_debug_level > 0 THEN
5711: oe_debug_pub.add('OTHERS IN QUERY_CONFIG' , 1);
5712: END IF;
5713: OE_MSG_PUB.Add_Exc_Msg
5714: ( G_PKG_NAME
5715: , 'Query_Config'
5716: );
5717: END IF;

Line 5943: oe_msg_pub.add;

5939:
5940: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_IN_BILL');
5941: FND_MESSAGE.Set_Token('COMPONENT', nvl(line_rec.ordered_item,line_rec.inventory_item_id));
5942: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_top_item_id));
5943: oe_msg_pub.add;
5944: RETURN;
5945:
5946: WHEN TOO_MANY_ROWS THEN
5947: IF l_debug_level > 0 THEN

Line 5957: oe_msg_pub.add;

5953:
5954: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
5955: FND_MESSAGE.Set_Token('COMPONENT', nvl(line_rec.ordered_item,line_rec.inventory_item_id));
5956: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_top_item_id));
5957: oe_msg_pub.add;
5958: RETURN;
5959:
5960: WHEN OTHERS THEN
5961: IF l_debug_level > 0 THEN

Line 6084: OE_Msg_Pub.Add;

6080: x_error_msg_name => l_message_name);
6081:
6082: IF l_message_name IS NOT NULL THEN
6083: FND_MESSAGE.Set_Name('BOM', l_message_name);
6084: OE_Msg_Pub.Add;
6085: END IF;
6086: END IF;
6087: ELSE -- if config_id null
6088: FND_MESSAGE.Set_Name('BOM', l_message_name);

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

6085: END IF;
6086: END IF;
6087: ELSE -- if config_id null
6088: FND_MESSAGE.Set_Name('BOM', l_message_name);
6089: OE_Msg_Pub.Add; -- config_id is null
6090: END IF;
6091:
6092: ELSE -- if cto return true for match
6093: FND_MESSAGE.Set_Name('BOM', l_message_name);

Line 6094: OE_Msg_Pub.Add;

6090: END IF;
6091:
6092: ELSE -- if cto return true for match
6093: FND_MESSAGE.Set_Name('BOM', l_message_name);
6094: OE_Msg_Pub.Add;
6095: END IF; -- if match found
6096:
6097: x_return_status := l_return_status;
6098: IF l_debug_level > 0 THEN

Line 6243: OE_MSG_PUB.Add;

6239: IF(nvl(l_autorization_status,'z')= 'APPROVED') THEN
6240: FND_MESSAGE.Set_Name('ONT', 'ONT_DELINK_NOT_ALLOWED');
6241: FND_MESSAGE.Set_Token('LINE_NUM', l_line_num);
6242: FND_MESSAGE.Set_Token('MODEL', l_ordered_item);
6243: OE_MSG_PUB.Add;
6244: RETURN;
6245: END IF;
6246:
6247: END IF;

Line 6277: oe_msg_pub.add;

6273: oe_debug_pub.add('CTO RESULT NOT 1' , 2 );
6274: END IF;
6275: IF l_message_name IS NOT NULL THEN
6276: FND_MESSAGE.Set_Name('BOM', l_message_name);
6277: oe_msg_pub.add;
6278: ELSE
6279: IF l_debug_level > 0 THEN
6280: oe_debug_pub.add('CTO MESSAGE NAME NULL' , 2 );
6281: END IF;

Line 6290: oe_msg_pub.add;

6286: oe_debug_pub.add('DELINK_CONFIG_ITEM ALLOWED ONLY FROM ATO MODEL',1);
6287: END IF;
6288: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_INVALID_ACTION');
6289: FND_MESSAGE.Set_Token('ACTION', 'Delink Config');
6290: oe_msg_pub.add;
6291: END IF;
6292:
6293: IF l_debug_level > 0 THEN
6294: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.DELINK_CONFIG' , 1);

Line 6303: oe_msg_pub.add;

6299: EXCEPTION
6300: WHEN NO_DATA_FOUND THEN
6301: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_NO_ITEM_TO_DELINK');
6302: FND_MESSAGE.Set_Token('MODEL', nvl(l_ordered_item,l_inv_item_id));
6303: oe_msg_pub.add;
6304: x_return_status := FND_API.G_RET_STS_ERROR;
6305:
6306: WHEN OTHERS THEN
6307: IF l_debug_level > 0 THEN

Line 6461: oe_msg_pub.add();

6457: x_message_name => l_message_name );
6458:
6459: IF NOT (l_result) THEN
6460: FND_MESSAGE.Set_Name('BOM', l_message_name);
6461: oe_msg_pub.add();
6462: END IF;
6463:
6464: ELSE
6465: IF l_debug_level > 0 THEN

Line 6470: oe_msg_pub.add;

6466: oe_debug_pub.add('LINK_CONFIG_ITEM ALLOWED ONLY FROM ATO MODEL', 2 );
6467: END IF;
6468: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_INVALID_ACTION');
6469: FND_MESSAGE.Set_Token('ACTION', 'Link Config');
6470: oe_msg_pub.add;
6471: END IF;
6472:
6473: IF l_debug_level > 0 THEN
6474: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.LINK_CONFIG' , 1);

Line 6487: OE_Msg_Pub.add;

6483: END IF;
6484:
6485: IF l_valid = 0 THEN
6486: FND_MESSAGE.Set_Name('BOM', 'CTO_INVALID_LINK_ERROR');
6487: OE_Msg_Pub.add;
6488: END IF;
6489:
6490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6491: END Link_Config;

Line 6996: OE_Msg_Pub.Add;

6992:
6993: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
6994: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
6995:
6996: OE_Msg_Pub.Add;
6997:
6998: IF l_debug_level > 0 THEN
6999: oe_debug_pub.add('LEAVING DECIMAL_RATIO_CHECK' , 3 );
7000: END IF;

Line 7122: OE_Msg_Pub.add();

7118: END IF;
7119: FND_Message.Set_Name('ONT', 'OE_CONFIG_WRONG_MODEL_LINK');
7120: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_x_child_line_rec.ordered_item
7121: ,p_x_child_line_rec.inventory_item_id));
7122: OE_Msg_Pub.add();
7123: x_return_status := FND_API.G_RET_STS_ERROR;
7124: RAISE FND_API.G_EXC_ERROR;
7125: END IF;
7126:

Line 8351: OE_Msg_Pub.Add_Text(l_msg);

8347: LOOP
8348: FETCH messages into l_constraint,l_msg;
8349: EXIT when messages%notfound;
8350:
8351: OE_Msg_Pub.Add_Text(l_msg);
8352: oe_debug_pub.add('msg from spc: '||messages%rowcount , 2);
8353: oe_debug_pub.add('msg from spc: '|| substr(l_msg, 1, 250) , 3);
8354:
8355: END LOOP;

Line 8360: OE_Msg_Pub.Add;

8356:
8357: IF nvl(p_valid_config, 'FALSE') = 'FALSE' THEN
8358:
8359: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
8360: OE_Msg_Pub.Add;
8361: END IF;
8362:
8363: IF nvl(p_complete_config, 'FALSE') = 'FALSE' THEN
8364:

Line 8379: OE_Msg_Pub.Add;

8375: END;
8376:
8377: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_INCOMPLETE_MODEL');
8378: FND_MESSAGE.SET_TOKEN('MODEL',l_message_text);
8379: OE_Msg_Pub.Add;
8380:
8381: END IF;
8382:
8383: EXCEPTION

Line 8709: OE_MSG_PUB.Transfer_Msg_Stack;

8705: END IF;
8706:
8707: IF l_msg_count > 0 THEN
8708:
8709: OE_MSG_PUB.Transfer_Msg_Stack;
8710:
8711: END IF;
8712:
8713: