DBA Data[Home] [Help]

APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on FND_MSG_PUB

Line 735: FND_MSG_PUB.ADD;

731: THEN
732: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
733: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
734: FND_MESSAGE.SET_TOKEN('VALUE2', g_primary_uom);
735: FND_MSG_PUB.ADD;
736:
737: x_return_status := FND_API.G_RET_STS_ERROR;
738:
739: WHEN e_currency_conversion_error

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

739: WHEN e_currency_conversion_error
740: THEN
741: print_debug('GMF_get_transfer_price_PUB.get_transfer_price: currency conversion error');
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
744: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
745:
746:
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

740: THEN
741: print_debug('GMF_get_transfer_price_PUB.get_transfer_price: currency conversion error');
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
744: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
745:
746:
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
748: THEN

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

747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
748: THEN
749: print_debug('Exc_Unexpected_Error in GMF_get_transfer_price_PUB.get_transfer_price');
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
752: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
753:
754: WHEN FND_API.G_EXC_ERROR
755: THEN

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

748: THEN
749: print_debug('Exc_Unexpected_Error in GMF_get_transfer_price_PUB.get_transfer_price');
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
752: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
753:
754: WHEN FND_API.G_EXC_ERROR
755: THEN
756: print_debug('EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price: ' || x_msg_data);

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

756: print_debug('EXC_ERROR in GMF_get_transfer_price_PUB.get_transfer_price: ' || x_msg_data);
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: IF x_msg_data IS NULL
759: THEN
760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
761: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
762: END IF;
763:
764: WHEN e_user_hook_error

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

757: x_return_status := FND_API.G_RET_STS_ERROR;
758: IF x_msg_data IS NULL
759: THEN
760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
761: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
762: END IF;
763:
764: WHEN e_user_hook_error
765: THEN

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

766: print_debug('user hook returned Error: ' || x_msg_data);
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: IF x_msg_data IS NULL
769: THEN
770: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
771: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
772: END IF;
773:
774:

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

767: x_return_status := FND_API.G_RET_STS_ERROR;
768: IF x_msg_data IS NULL
769: THEN
770: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
771: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
772: END IF;
773:
774:
775: WHEN e_transfer_price_null_error

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

777: print_debug('transfer price is null: ' || x_msg_data);
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: IF x_msg_data IS NULL
780: THEN
781: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
782: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
783: END IF;
784:
785: WHEN e_ignore_error

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

778: x_return_status := FND_API.G_RET_STS_ERROR;
779: IF x_msg_data IS NULL
780: THEN
781: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
782: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
783: END IF;
784:
785: WHEN e_ignore_error
786: THEN

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

788:
789:
790: WHEN OTHERS THEN
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
793: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);

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

789:
790: WHEN OTHERS THEN
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
793: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
797: end if;

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

791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
793: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
797: end if;
798: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (sqlerrm): ' || sqlerrm);
799: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (backtrace): ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

792: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
793: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
797: end if;
798: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (sqlerrm): ' || sqlerrm);
799: print_debug('When Other in GMF_get_transfer_price_PUB.get_transfer_price (backtrace): ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
800:

Line 986: FND_MSG_PUB.ADD;

982:
983: FND_MESSAGE.SET_NAME('GMF', 'IC-Price List Not Found');
984: FND_MESSAGE.SET_TOKEN('FROM_ORG', g_from_organization_id);
985: FND_MESSAGE.SET_TOKEN('TO_ORG', g_to_organization_id);
986: FND_MSG_PUB.ADD;
987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
988: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
989: RAISE FND_API.G_EXC_ERROR;
990:

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

983: FND_MESSAGE.SET_NAME('GMF', 'IC-Price List Not Found');
984: FND_MESSAGE.SET_TOKEN('FROM_ORG', g_from_organization_id);
985: FND_MESSAGE.SET_TOKEN('TO_ORG', g_to_organization_id);
986: FND_MSG_PUB.ADD;
987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
988: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
989: RAISE FND_API.G_EXC_ERROR;
990:
991: WHEN e_item_not_on_pricelist

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

984: FND_MESSAGE.SET_TOKEN('FROM_ORG', g_from_organization_id);
985: FND_MESSAGE.SET_TOKEN('TO_ORG', g_to_organization_id);
986: FND_MSG_PUB.ADD;
987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
988: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
989: RAISE FND_API.G_EXC_ERROR;
990:
991: WHEN e_item_not_on_pricelist
992: THEN

Line 1012: FND_MSG_PUB.ADD;

1008: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
1009: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
1010: FND_MESSAGE.SET_TOKEN('UNIT', g_primary_uom);
1011: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_pricelist_name);
1012: FND_MSG_PUB.ADD;
1013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1014: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1015: RAISE FND_API.G_EXC_ERROR;
1016:

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

1009: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
1010: FND_MESSAGE.SET_TOKEN('UNIT', g_primary_uom);
1011: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_pricelist_name);
1012: FND_MSG_PUB.ADD;
1013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1014: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1015: RAISE FND_API.G_EXC_ERROR;
1016:
1017: WHEN OTHERS then

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

1010: FND_MESSAGE.SET_TOKEN('UNIT', g_primary_uom);
1011: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_pricelist_name);
1012: FND_MSG_PUB.ADD;
1013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1014: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1015: RAISE FND_API.G_EXC_ERROR;
1016:
1017: WHEN OTHERS then
1018: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));

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

1016:
1017: WHEN OTHERS then
1018: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1021: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1022: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1023: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
1024: end if;

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

1017: WHEN OTHERS then
1018: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1021: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1022: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1023: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
1024: end if;
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1018: print_debug(' ' || l_api_name || ': in When Others (sqlerrm): ' || substr(sqlerrm, 1, 200));
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1021: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1022: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1023: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
1024: end if;
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026:

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

1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1021: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1022: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1023: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME, l_api_name);
1024: end if;
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026:
1027: /*

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

1026:
1027: /*
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1031: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;

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

1027: /*
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1031: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1031: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1036: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
1037: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1038: */
1039: END get_xfer_price_basic;

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

1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1036: print_debug('In EXC_ERROR ' || l_progress, 'Get_Transfer_Price');
1037: x_msg_data := fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false);
1038: */
1039: END get_xfer_price_basic;
1040:
1041: --