DBA Data[Home] [Help]

APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on FND_MSG_PUB

Line 651: FND_MSG_PUB.ADD;

647: THEN
648: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
649: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
650: FND_MESSAGE.SET_TOKEN('VALUE2', g_primary_uom);
651: FND_MSG_PUB.ADD;
652:
653: x_return_status := FND_API.G_RET_STS_ERROR;
654:
655: WHEN e_currency_conversion_error

Line 659: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

655: WHEN e_currency_conversion_error
656: THEN
657: print_debug('GMF_get_transfer_price_PUB.get_transfer_price: currency conversion error');
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
660: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
661:
662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 660: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

656: THEN
657: print_debug('GMF_get_transfer_price_PUB.get_transfer_price: currency conversion error');
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
660: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
661:
662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
664: THEN

Line 667: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
664: THEN
665: print_debug('Exc_Unexpected_Error in GMF_get_transfer_price_PUB.get_transfer_price');
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
668: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
669:
670: WHEN FND_API.G_EXC_ERROR
671: THEN

Line 668: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

664: THEN
665: print_debug('Exc_Unexpected_Error in GMF_get_transfer_price_PUB.get_transfer_price');
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
668: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
669:
670: WHEN FND_API.G_EXC_ERROR
671: THEN
672: print_debug('EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price: ' || x_msg_data);

Line 676: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

672: print_debug('EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price: ' || x_msg_data);
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: IF x_msg_data IS NULL
675: THEN
676: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
677: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
678: END IF;
679:
680: WHEN e_user_hook_error

Line 677: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

673: x_return_status := FND_API.G_RET_STS_ERROR;
674: IF x_msg_data IS NULL
675: THEN
676: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
677: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
678: END IF;
679:
680: WHEN e_user_hook_error
681: THEN

Line 686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

682: print_debug('user hook returned Error: ' || x_msg_data);
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: IF x_msg_data IS NULL
685: THEN
686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
687: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
688: END IF;
689:
690:

Line 687: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

683: x_return_status := FND_API.G_RET_STS_ERROR;
684: IF x_msg_data IS NULL
685: THEN
686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
687: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
688: END IF;
689:
690:
691: WHEN e_transfer_price_null_error

Line 697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

693: print_debug('transfer price is null: ' || x_msg_data);
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: IF x_msg_data IS NULL
696: THEN
697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
698: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
699: END IF;
700:
701: WHEN e_ignore_error

Line 698: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

694: x_return_status := FND_API.G_RET_STS_ERROR;
695: IF x_msg_data IS NULL
696: THEN
697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
698: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
699: END IF;
700:
701: WHEN e_ignore_error
702: THEN

Line 708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

704:
705:
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
709: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

Line 709: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

705:
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
709: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
713: end if;

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

707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
709: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
713: end if;
714: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (sqlerrm): ' || sqlerrm);
715: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (backtrace): ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 712: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
709: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
710:
711: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
713: end if;
714: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (sqlerrm): ' || sqlerrm);
715: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (backtrace): ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
716:

Line 902: FND_MSG_PUB.ADD;

898:
899: FND_MESSAGE.SET_NAME('GMF', 'IC-Price List Not Found');
900: FND_MESSAGE.SET_TOKEN('FROM_ORG', g_from_organization_id);
901: FND_MESSAGE.SET_TOKEN('TO_ORG', g_to_organization_id);
902: FND_MSG_PUB.ADD;
903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
904: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
905: RAISE FND_API.G_EXC_ERROR;
906:

Line 903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

899: FND_MESSAGE.SET_NAME('GMF', 'IC-Price List Not Found');
900: FND_MESSAGE.SET_TOKEN('FROM_ORG', g_from_organization_id);
901: FND_MESSAGE.SET_TOKEN('TO_ORG', g_to_organization_id);
902: FND_MSG_PUB.ADD;
903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
904: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
905: RAISE FND_API.G_EXC_ERROR;
906:
907: WHEN e_item_not_on_pricelist

Line 904: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

900: FND_MESSAGE.SET_TOKEN('FROM_ORG', g_from_organization_id);
901: FND_MESSAGE.SET_TOKEN('TO_ORG', g_to_organization_id);
902: FND_MSG_PUB.ADD;
903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
904: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
905: RAISE FND_API.G_EXC_ERROR;
906:
907: WHEN e_item_not_on_pricelist
908: THEN

Line 928: FND_MSG_PUB.ADD;

924: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
925: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
926: FND_MESSAGE.SET_TOKEN('UNIT', g_primary_uom);
927: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_pricelist_name);
928: FND_MSG_PUB.ADD;
929: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
930: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
931: RAISE FND_API.G_EXC_ERROR;
932:

Line 929: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

925: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
926: FND_MESSAGE.SET_TOKEN('UNIT', g_primary_uom);
927: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_pricelist_name);
928: FND_MSG_PUB.ADD;
929: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
930: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
931: RAISE FND_API.G_EXC_ERROR;
932:
933: WHEN OTHERS then

Line 930: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

926: FND_MESSAGE.SET_TOKEN('UNIT', g_primary_uom);
927: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_pricelist_name);
928: FND_MSG_PUB.ADD;
929: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
930: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
931: RAISE FND_API.G_EXC_ERROR;
932:
933: WHEN OTHERS then
934: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));

Line 936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

932:
933: WHEN OTHERS then
934: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
937: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
939: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
940: end if;

Line 937: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

933: WHEN OTHERS then
934: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
937: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
939: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
940: end if;
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

934: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
937: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
939: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
940: end if;
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942:

Line 939: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
937: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
939: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
940: end if;
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942:
943: /*

Line 946: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

942:
943: /*
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
947: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
948:
949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;

Line 947: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

943: /*
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
947: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
948:
949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

947: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
948:
949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
952: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
953: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
954: */
955: END get_xfer_price_basic;

Line 953: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);

949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
952: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
953: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
954: */
955: END get_xfer_price_basic;
956:
957: --