eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_TRANSACTION_PVT dependencies on DPP_UTILITY_PVT

Line 841: dpp_utility_pvt.debug_message('Create Header G_EXC_ERROR '||x_msg_data);

837: END IF;
838: EXCEPTION
839: WHEN Fnd_Api.G_EXC_ERROR THEN
840: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
841: dpp_utility_pvt.debug_message('Create Header G_EXC_ERROR '||x_msg_data);
842: x_return_status := Fnd_Api.g_ret_sts_error ;
843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
845: dpp_utility_pvt.debug_message('Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);

Line 845: dpp_utility_pvt.debug_message('Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);

841: dpp_utility_pvt.debug_message('Create Header G_EXC_ERROR '||x_msg_data);
842: x_return_status := Fnd_Api.g_ret_sts_error ;
843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
845: dpp_utility_pvt.debug_message('Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);
846: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
847: WHEN OTHERS THEN
848: dpp_utility_pvt.debug_message('Create Header OTHERS'||sqlerrm);
849: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

Line 848: dpp_utility_pvt.debug_message('Create Header OTHERS'||sqlerrm);

844: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
845: dpp_utility_pvt.debug_message('Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);
846: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
847: WHEN OTHERS THEN
848: dpp_utility_pvt.debug_message('Create Header OTHERS'||sqlerrm);
849: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
850: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
851: THEN
852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 955: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case I');

951: OR p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
952: BEGIN
953: IF p_txn_lines_tbl_type(i).item_number IS NOT NULL
954: AND p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
955: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case I');
956: SELECT msi.inventory_item_id,
957: msi.concatenated_segments,
958: msi.primary_uom_code
959: INTO p_txn_lines_tbl_type(i).inventory_item_id

Line 973: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case II');

969: AND msi.concatenated_segments = p_txn_lines_tbl_type(i).item_number
970: AND msi.inventory_item_id = to_number(p_txn_lines_tbl_type(i).inventory_item_id)
971: AND msi.primary_uom_code = nvl(p_txn_lines_tbl_type(i).uom,msi.primary_uom_code);
972: ELSIF p_txn_lines_tbl_type(i).item_number IS NULL THEN
973: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case II');
974: SELECT msi.inventory_item_id,
975: msi.concatenated_segments,
976: msi.primary_uom_code
977: INTO p_txn_lines_tbl_type(i).inventory_item_id

Line 990: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case III');

986: AND msi.organization_id = p_txn_header_rec_type.inventory_organization_id
987: AND msi.inventory_item_id = to_number(p_txn_lines_tbl_type(i).inventory_item_id)
988: AND msi.primary_uom_code = nvl(p_txn_lines_tbl_type(i).uom,msi.primary_uom_code);
989: ELSIF p_txn_lines_tbl_type(i).inventory_item_id IS NULL THEN
990: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case III');
991: SELECT msi.inventory_item_id,
992: msi.concatenated_segments,
993: msi.primary_uom_code
994: INTO p_txn_lines_tbl_type(i).inventory_item_id

Line 1035: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case IV');

1031:
1032: BEGIN --to get supplier part number for the item number or inventory item id
1033: IF p_txn_lines_tbl_type(i).supplier_part_num IS NOT NULL THEN
1034: BEGIN
1035: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case IV');
1036: SELECT occ.external_code
1037: INTO p_txn_lines_tbl_type(i).supplier_part_num
1038: FROM ozf_supp_trd_prfls_all ostpa,
1039: ozf_supp_code_conversions_all occ

Line 1091: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case V');

1087: END IF;
1088:
1089: END;
1090: ELSE
1091: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case V');
1092: SELECT occ.external_code
1093: INTO p_txn_lines_tbl_type(i).supplier_part_num
1094: FROM ozf_supp_trd_prfls_all ostpa,
1095: ozf_supp_code_conversions_all occ

Line 1131: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case V line number '|| i );

1127: l_error_message := x_msg_data;
1128: END IF;
1129:
1130: END;
1131: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case V line number '|| i );
1132: ELSE
1133: BEGIN
1134: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case VI');
1135: SELECT occ.external_code

Line 1134: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case VI');

1130: END;
1131: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case V line number '|| i );
1132: ELSE
1133: BEGIN
1134: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case VI');
1135: SELECT occ.external_code
1136: ,occ.internal_code
1137: INTO p_txn_lines_tbl_type(i).supplier_part_num
1138: ,p_txn_lines_tbl_type(i).inventory_item_id

Line 1217: DPP_UTILITY_PVT.convert_currency(

1213:
1214:
1215: IF p_txn_header_rec_type.functional_currency <> p_txn_header_rec_type.trx_currency THEN
1216: --call procedure to get prior price in transaction currency
1217: DPP_UTILITY_PVT.convert_currency(
1218: p_from_currency => p_txn_header_rec_type.functional_currency
1219: ,p_to_currency => p_txn_header_rec_type.trx_currency
1220: ,p_conv_type => FND_API.G_MISS_CHAR
1221: ,p_conv_rate => FND_API.G_MISS_NUM

Line 1243: dpp_utility_pvt.debug_message('Prior Price:'||p_txn_lines_tbl_type(i).prior_price);

1239: l_error_message :=l_error_message|| x_msg_data;
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1241: END IF;
1242: END IF;
1243: dpp_utility_pvt.debug_message('Prior Price:'||p_txn_lines_tbl_type(i).prior_price);
1244: IF p_txn_lines_tbl_type(i).prior_price IS NULL THEN
1245: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1246: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1247: x_msg_data := fnd_message.get();

Line 1494: dpp_utility_pvt.debug_message('Validate Supplier part number Error: ' || sqlerrm);

1490: END IF;
1491: EXCEPTION
1492: WHEN Fnd_Api.G_EXC_ERROR THEN
1493: x_return_status := Fnd_Api.g_ret_sts_error ;
1494: dpp_utility_pvt.debug_message('Validate Supplier part number Error: ' || sqlerrm);
1495: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1496: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1497: WHEN OTHERS THEN
1498: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

Line 1548: dpp_utility_pvt.debug_message('Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);

1544: FND_FILE.PUT_LINE(FND_FILE.LOG,' Transaction Header Id'||p_txn_lines_tbl_type(i).transaction_header_id);
1545: FND_FILE.PUT_LINE(FND_FILE.LOG,' Supplier Part Num'||p_txn_lines_tbl_type(i).supplier_part_num);
1546: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inventory Item ID'||p_txn_lines_tbl_type(i).inventory_item_id);
1547: END IF;
1548: dpp_utility_pvt.debug_message('Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);
1549: -- Insert lines into dpp_transaction_lines_all table
1550: INSERT INTO dpp_transaction_lines_all(
1551: object_version_number
1552: , transaction_header_id

Line 1697: dpp_utility_pvt.debug_message('End Create Lines'|| sqlerrm);

1693: END LOOP; --FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
1694: IF DPP_DEBUG_HIGH_ON THEN
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Create Lines');
1696: END IF;
1697: dpp_utility_pvt.debug_message('End Create Lines'|| sqlerrm);
1698: EXCEPTION
1699: WHEN Fnd_Api.G_EXC_ERROR THEN
1700: x_return_status := Fnd_Api.g_ret_sts_error ;
1701: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 1704: dpp_utility_pvt.debug_message('Exception Create Lines'||sqlerrm);

1700: x_return_status := Fnd_Api.g_ret_sts_error ;
1701: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1702: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1703: WHEN OTHERS THEN
1704: dpp_utility_pvt.debug_message('Exception Create Lines'||sqlerrm);
1705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1708: fnd_message.set_token('ROUTINE', l_full_name);

Line 1763: --Form Line table to to get covered Inventory Details DPP_UTILITY_PVT.Get_CoveredInventory

1759: FND_FILE.PUT_LINE(FND_FILE.LOG,' Update_CoveredInv Rec type Org_ID'||l_header_rec_type.org_id);
1760: FND_FILE.PUT_LINE(FND_FILE.LOG,' Update_CoveredInv Rec type Effective Start Date'|| l_header_rec_type.effective_start_date);
1761: FND_FILE.PUT_LINE(FND_FILE.LOG,' Update_CoveredInv Rec type Effective End Date'||l_header_rec_type.effective_end_date);
1762: END IF;
1763: --Form Line table to to get covered Inventory Details DPP_UTILITY_PVT.Get_CoveredInventory
1764: FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
1765: LOOP
1766:
1767: l_line_tbl_type(i).transaction_line_id := p_txn_lines_tbl_type(i).transaction_line_id;

Line 1790: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);

1786: ,x_msg_data => x_msg_data
1787: ,p_inv_hdr_rec => l_header_rec_type
1788: ,p_covered_inv_tbl => l_line_tbl_type
1789: );
1790: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);
1791: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1792: RAISE Fnd_Api.g_exc_error;
1793: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1794: RAISE Fnd_Api.g_exc_unexpected_error;

Line 1808: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);

1804: ,x_msg_data => x_msg_data
1805: ,p_inv_hdr_rec => l_header_rec_type
1806: ,p_covered_inv_tbl => l_line_tbl_type
1807: );
1808: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);
1809: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1810: RAISE Fnd_Api.g_exc_error;
1811: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1812: RAISE Fnd_Api.g_exc_unexpected_error;

Line 1819: dpp_utility_pvt.debug_message('l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);

1815: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Update Covered Inventory');
1816: END IF;
1817: FOR i in l_line_tbl_type.FIRST..l_line_tbl_type.LAST
1818: LOOP
1819: dpp_utility_pvt.debug_message('l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
1820: dpp_utility_pvt.debug_message('l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
1821: dpp_utility_pvt.debug_message('l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
1822: dpp_utility_pvt.debug_message('l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
1823: IF DPP_DEBUG_HIGH_ON THEN

Line 1820: dpp_utility_pvt.debug_message('l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);

1816: END IF;
1817: FOR i in l_line_tbl_type.FIRST..l_line_tbl_type.LAST
1818: LOOP
1819: dpp_utility_pvt.debug_message('l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
1820: dpp_utility_pvt.debug_message('l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
1821: dpp_utility_pvt.debug_message('l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
1822: dpp_utility_pvt.debug_message('l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
1823: IF DPP_DEBUG_HIGH_ON THEN
1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'After get covered Inventory');

Line 1821: dpp_utility_pvt.debug_message('l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);

1817: FOR i in l_line_tbl_type.FIRST..l_line_tbl_type.LAST
1818: LOOP
1819: dpp_utility_pvt.debug_message('l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
1820: dpp_utility_pvt.debug_message('l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
1821: dpp_utility_pvt.debug_message('l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
1822: dpp_utility_pvt.debug_message('l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
1823: IF DPP_DEBUG_HIGH_ON THEN
1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'After get covered Inventory');
1825: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);

Line 1822: dpp_utility_pvt.debug_message('l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);

1818: LOOP
1819: dpp_utility_pvt.debug_message('l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
1820: dpp_utility_pvt.debug_message('l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
1821: dpp_utility_pvt.debug_message('l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
1822: dpp_utility_pvt.debug_message('l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
1823: IF DPP_DEBUG_HIGH_ON THEN
1824: FND_FILE.PUT_LINE(FND_FILE.LOG,'After get covered Inventory');
1825: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
1826: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);

Line 2801: dpp_utility_pvt.debug_message('Insert Transaction:'||l_transaction_type);

2797:
2798: l_transaction_type := 'APP';
2799: END IF;
2800:
2801: dpp_utility_pvt.debug_message('Insert Transaction:'||l_transaction_type);
2802:
2803: --Form header record type to populate header table
2804: l_txn_header_rec_type.transaction_int_header_id :=fetch_header_rec.transaction_int_header_id;
2805: l_txn_header_rec_type.ref_document_number := fetch_header_rec.ref_document_number;

Line 2875: dpp_utility_pvt.debug_message('Ref Doc Num Status :'||l_return_status);

2871: ,x_msg_count => x_msg_count
2872: ,x_msg_data => x_msg_data
2873: ,x_return_status => l_return_status
2874: );
2875: dpp_utility_pvt.debug_message('Ref Doc Num Status :'||l_return_status);
2876: IF DPP_DEBUG_HIGH_ON THEN
2877: fnd_file.put_line(fnd_file.log, 'Validate Ref Document Number Return Status: '||l_return_status ||'Error Msg: '||x_msg_data);
2878: END IF;
2879: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 2897: dpp_utility_pvt.debug_message('Operating Unit Status :'||l_return_status);

2893: ,x_msg_count => x_msg_count
2894: ,x_msg_data => x_msg_data
2895: ,x_return_status => l_return_status
2896: );
2897: dpp_utility_pvt.debug_message('Operating Unit Status :'||l_return_status);
2898: IF DPP_DEBUG_HIGH_ON THEN
2899: fnd_file.put_line(fnd_file.log, 'Validate Operating Unit Return Status: '||l_txn_header_rec_type.org_id ||l_return_status ||'Error Msg: '||x_msg_data);
2900: END IF;
2901:

Line 2919: dpp_utility_pvt.debug_message('Supplier Details Status :'||l_return_status);

2915: ,x_msg_count => x_msg_count
2916: ,x_msg_data => x_msg_data
2917: ,x_return_status => l_return_status
2918: );
2919: dpp_utility_pvt.debug_message('Supplier Details Status :'||l_return_status);
2920: IF DPP_DEBUG_HIGH_ON THEN
2921: fnd_file.put_line(fnd_file.log, 'Validate Supplier Details Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
2922: END IF;
2923: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 2939: dpp_utility_pvt.debug_message('Currency Status :'||l_return_status);

2935: ,x_msg_count => x_msg_count
2936: ,x_msg_data => x_msg_data
2937: ,x_return_status => l_return_status
2938: );
2939: dpp_utility_pvt.debug_message('Currency Status :'||l_return_status);
2940: IF DPP_DEBUG_HIGH_ON THEN
2941: fnd_file.put_line(fnd_file.log, 'Validate Currency Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
2942: END IF;
2943: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 2956: dpp_utility_pvt.debug_message('Validate Lines Status :'||l_return_status);

2952: ,x_msg_count => x_msg_count
2953: ,x_msg_data => x_msg_data
2954: ,x_return_status => l_return_status
2955: );
2956: dpp_utility_pvt.debug_message('Validate Lines Status :'||l_return_status);
2957: IF DPP_DEBUG_HIGH_ON THEN
2958: fnd_file.put_line(fnd_file.log, 'Validate Line Details Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
2959: END IF;
2960: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3027: dpp_utility_pvt.debug_message('New Transaction');

3023: IF l_transaction_status IS NULL OR l_transaction_status = l_status_cancelled THEN
3024: IF DPP_DEBUG_HIGH_ON THEN
3025: fnd_file.put_line(fnd_file.log, ' Inbound Price Protection Transaction ' );
3026: END IF;
3027: dpp_utility_pvt.debug_message('New Transaction');
3028:
3029: IF l_concatenated_error_message IS NOT NULL THEN
3030: RAISE Fnd_Api.g_exc_error;
3031: END IF;

Line 3038: dpp_utility_pvt.debug_message('Create Header Status :'||l_return_status);

3034: ,x_msg_count => x_msg_count
3035: ,x_msg_data => x_msg_data
3036: ,x_return_status => l_return_status
3037: );
3038: dpp_utility_pvt.debug_message('Create Header Status :'||l_return_status);
3039: IF DPP_DEBUG_HIGH_ON THEN
3040: fnd_file.put_line(fnd_file.log, 'Create Header Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3041: END IF;
3042: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3051: dpp_utility_pvt.debug_message('Create_Header');

3047: );
3048: RAISE Fnd_Api.g_exc_error;
3049: END IF;
3050:
3051: dpp_utility_pvt.debug_message('Create_Header');
3052: --Update Header history log
3053: IF l_log_enabled = 'Y' THEN
3054: Update_HeaderLog(p_txn_header_rec_type => l_txn_header_rec_type
3055: ,x_msg_count => x_msg_count

Line 3075: dpp_utility_pvt.debug_message('Form Line Tbl Status :'||l_return_status);

3071: ,x_msg_count => x_msg_count
3072: ,x_msg_data => x_msg_data
3073: ,x_return_status => l_return_status
3074: );
3075: dpp_utility_pvt.debug_message('Form Line Tbl Status :'||l_return_status);
3076: IF DPP_DEBUG_HIGH_ON THEN
3077: fnd_file.put_line(fnd_file.log, 'Form Line Tbl Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3078: END IF;
3079: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3087: dpp_utility_pvt.debug_message('Form line tbl');

3083: p_txn_lines_tbl_type => l_txn_lines_tbl_type
3084: ,x_return_status =>l_return_status
3085: );
3086: END IF;
3087: dpp_utility_pvt.debug_message('Form line tbl');
3088: --Validate the distributor Part Number
3089: Validate_SupplierPartNum(
3090: p_txn_header_rec_type =>l_txn_header_rec_type
3091: ,p_txn_lines_tbl_type => l_txn_lines_tbl_type

Line 3096: dpp_utility_pvt.debug_message('Supplier Part Num Status :'||l_return_status);

3092: ,x_msg_count => x_msg_count
3093: ,x_msg_data => x_msg_data
3094: ,x_return_status => l_return_status
3095: );
3096: dpp_utility_pvt.debug_message('Supplier Part Num Status :'||l_return_status);
3097: IF DPP_DEBUG_HIGH_ON THEN
3098: fnd_file.put_line(fnd_file.log, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3099: dpp_utility_pvt.debug_message('Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||substr(x_msg_data,1,1000));
3100: END IF;

Line 3099: dpp_utility_pvt.debug_message('Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||substr(x_msg_data,1,1000));

3095: );
3096: dpp_utility_pvt.debug_message('Supplier Part Num Status :'||l_return_status);
3097: IF DPP_DEBUG_HIGH_ON THEN
3098: fnd_file.put_line(fnd_file.log, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3099: dpp_utility_pvt.debug_message('Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||substr(x_msg_data,1,1000));
3100: END IF;
3101:
3102: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
3103: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;

Line 3115: dpp_utility_pvt.debug_message('Validate Supplier Part Number');

3111: IF l_concatenated_error_message IS NOT NULL THEN
3112: x_msg_data:= l_concatenated_error_message;
3113: RAISE Fnd_Api.g_exc_error;
3114: END IF;
3115: dpp_utility_pvt.debug_message('Validate Supplier Part Number');
3116: --Call Insert lines procedure
3117: Create_lines( p_txn_header_rec_type => l_txn_header_rec_type
3118: ,p_txn_lines_tbl_type => l_txn_lines_tbl_type
3119: ,x_msg_count => x_msg_count

Line 3123: dpp_utility_pvt.debug_message('Create Lines Status :'||l_return_status);

3119: ,x_msg_count => x_msg_count
3120: ,x_msg_data => x_msg_data
3121: ,x_return_status => l_return_status
3122: );
3123: dpp_utility_pvt.debug_message('Create Lines Status :'||l_return_status);
3124: IF DPP_DEBUG_HIGH_ON THEN
3125: fnd_file.put_line(fnd_file.log, 'Create Lines Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3126: END IF;
3127: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3169: dpp_utility_pvt.debug_message('Update CoveredInv Status :'||l_return_status);

3165: ,x_msg_count => x_msg_count
3166: ,x_msg_data =>x_msg_data
3167: ,x_return_status => l_return_status
3168: );
3169: dpp_utility_pvt.debug_message('Update CoveredInv Status :'||l_return_status);
3170: IF DPP_DEBUG_HIGH_ON THEN
3171: fnd_file.put_line(fnd_file.log, 'Update Covered Inventory Return Status:'||l_return_status);
3172: END IF;
3173: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3181: dpp_utility_pvt.debug_message('Status '||l_return_status|| ' Message '||x_msg_data);

3177: p_txn_header_rec_type => l_txn_header_rec_type,
3178: p_txn_lines_tbl_type => l_txn_lines_tbl_type
3179: ,x_return_status =>l_return_status
3180: );
3181: dpp_utility_pvt.debug_message('Status '||l_return_status|| ' Message '||x_msg_data);
3182: RAISE Fnd_Api.g_exc_error;
3183: END IF;
3184: ELSE
3185: --The transaction is in Active/.... Status

Line 3196: dpp_utility_pvt.debug_message('Transaction Exist Status :'||l_return_status);

3192: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
3193: IF DPP_DEBUG_HIGH_ON THEN
3194: fnd_file.put_line(fnd_file.log, 'Error:' || x_msg_data);
3195: END IF;
3196: dpp_utility_pvt.debug_message('Transaction Exist Status :'||l_return_status);
3197: Update_InterfaceErrSts(
3198: p_txn_header_rec_type => l_txn_header_rec_type
3199: ,x_return_status =>l_return_status
3200: );

Line 3432: dpp_utility_pvt.debug_message('DPP G_EXC_ERROR x_msg_data');

3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();
3431: x_msg_data := l_msg_data || l_concatenated_error_message;
3432: dpp_utility_pvt.debug_message('DPP G_EXC_ERROR x_msg_data');
3433: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);
3434:
3435:
3436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3433: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);

3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();
3431: x_msg_data := l_msg_data || l_concatenated_error_message;
3432: dpp_utility_pvt.debug_message('DPP G_EXC_ERROR x_msg_data');
3433: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);
3434:
3435:
3436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');

Line 3444: dpp_utility_pvt.debug_message('DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);

3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3441: x_msg_data := fnd_message.get();
3442: x_msg_data:= x_msg_data ||l_concatenated_error_message;
3443: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3444: dpp_utility_pvt.debug_message('DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);
3445:
3446: WHEN OTHERS THEN
3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

Line 3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);

3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3451: x_msg_data := fnd_message.get();
3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);
3453: x_msg_data := x_msg_data || l_concatenated_error_message;
3454: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3455: dpp_utility_pvt.debug_message('Error after assignment:' ||x_msg_data);
3456: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

Line 3455: dpp_utility_pvt.debug_message('Error after assignment:' ||x_msg_data);

3451: x_msg_data := fnd_message.get();
3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);
3453: x_msg_data := x_msg_data || l_concatenated_error_message;
3454: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3455: dpp_utility_pvt.debug_message('Error after assignment:' ||x_msg_data);
3456: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
3457: THEN
3458: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3459: END IF;

Line 3821: dpp_utility_pvt.debug_message('Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);

3817:
3818: EXCEPTION
3819: WHEN create_IntLines_exception THEN
3820: x_return_status := fnd_api.g_ret_sts_error;
3821: dpp_utility_pvt.debug_message('Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);
3822: WHEN others THEN
3823: dpp_utility_pvt.debug_message('Create IntLines : SQLERRM:'||SQLERRM);
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3823: dpp_utility_pvt.debug_message('Create IntLines : SQLERRM:'||SQLERRM);

3819: WHEN create_IntLines_exception THEN
3820: x_return_status := fnd_api.g_ret_sts_error;
3821: dpp_utility_pvt.debug_message('Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);
3822: WHEN others THEN
3823: dpp_utility_pvt.debug_message('Create IntLines : SQLERRM:'||SQLERRM);
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

Line 3946: dpp_utility_pvt.debug_message('DPP Entered OU in webadi api');

3942: --l_return_status := fnd_api.g_ret_sts_success;
3943:
3944:
3945: IF p_distributor_operating_unit IS NULL THEN
3946: dpp_utility_pvt.debug_message('DPP Entered OU in webadi api');
3947: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');
3948: l_error_message := fnd_message.get();
3949: l_message := l_message || l_error_message;
3950: --RAISE DPP_WEBADI_ERROR;

Line 4028: dpp_utility_pvt.debug_message('DPP Entered VALUE');

4024: --RAISE DPP_WEBADI_ERROR;
4025: END IF;
4026:
4027: IF p_change_value IS NULL OR p_change_value <= 0 THEN
4028: dpp_utility_pvt.debug_message('DPP Entered VALUE');
4029: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');
4030: l_error_message := fnd_message.get();
4031: l_message := l_message || l_error_message;
4032: --raise_application_error( -20000, l_error_message);

Line 4085: dpp_utility_pvt.debug_message('DPP Lines Assignment');

4081: l_transaction_header_rec.attribute29 := p_hdrattribute29;
4082: l_transaction_header_rec.attribute30 := p_hdrattribute30;
4083:
4084: --Assign to rec type l_transaction_header_rec
4085: dpp_utility_pvt.debug_message('DPP Lines Assignment');
4086: l_transaction_lines_rec.SUPPLIER_PART_NUM := p_supplier_part_num;
4087: l_transaction_lines_rec.ITEM_NUMBER := P_ITEM_NUMBER;
4088: l_transaction_lines_rec.CHANGE_TYPE := P_CHANGE_TYPE;
4089: l_transaction_lines_rec.CHANGE_VALUE := P_CHANGE_VALUE;

Line 4145: dpp_utility_pvt.debug_message('DPP SYSTEM ERROR');

4141: x_return_status => l_return_status);
4142:
4143:
4144: IF l_return_status = fnd_api.g_ret_sts_error THEN
4145: dpp_utility_pvt.debug_message('DPP SYSTEM ERROR');
4146: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4147: l_error_message := fnd_message.get();
4148: RAISE dpp_webadi_error;
4149: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4150: dpp_utility_pvt.debug_message('DPP UNEXPECTED ERROR');

4146: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4147: l_error_message := fnd_message.get();
4148: RAISE dpp_webadi_error;
4149: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4150: dpp_utility_pvt.debug_message('DPP UNEXPECTED ERROR');
4151: RAISE fnd_api.g_exc_unexpected_error;
4152: END IF;
4153:
4154: EXCEPTION

Line 4160: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);

4156: ROLLBACK TO inbound_transaction;
4157: if l_message is NULL then
4158: l_message := fnd_message.get();
4159: end if;
4160: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4161: raise_application_error( -20000, l_message);
4162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4163: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4164: ROLLBACK TO inbound_transaction;

Line 4163: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');

4159: end if;
4160: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4161: raise_application_error( -20000, l_message);
4162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4163: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4164: ROLLBACK TO inbound_transaction;
4165: IF length( SQLERRM) > 30 THEN
4166: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4167: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4166: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));

4162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4163: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4164: ROLLBACK TO inbound_transaction;
4165: IF length( SQLERRM) > 30 THEN
4166: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4167: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4168: ELSE
4169: fnd_message.set_name ('DPP', SQLERRM);
4170: END IF;

Line 4174: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');

4170: END IF;
4171: l_error_message := fnd_message.get();
4172: raise_application_error( -20000, l_error_message);
4173: WHEN OTHERS THEN
4174: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4175: ROLLBACK TO inbound_transaction;
4176: IF length( SQLERRM) > 30 THEN
4177: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4178: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4177: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));

4173: WHEN OTHERS THEN
4174: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4175: ROLLBACK TO inbound_transaction;
4176: IF length( SQLERRM) > 30 THEN
4177: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4178: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4179: ELSE
4180: fnd_message.set_name ('DPP', SQLERRM);
4181: END IF;

Line 4183: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);

4179: ELSE
4180: fnd_message.set_name ('DPP', SQLERRM);
4181: END IF;
4182: l_error_message := fnd_message.get();
4183: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);
4184: raise_application_error( -20000, l_error_message);
4185: END inbound_transaction;
4186:
4187: PROCEDURE create_webadi_transaction(p_document_reference_number IN VARCHAR2

Line 4223: dpp_utility_pvt.debug_message('DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());

4219: AND dthia.operating_unit_name = cv_operating_unit;
4220:
4221: BEGIN
4222:
4223: dpp_utility_pvt.debug_message('DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);
4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);

Line 4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);

4220:
4221: BEGIN
4222:
4223: dpp_utility_pvt.debug_message('DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);
4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);

Line 4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);

4221: BEGIN
4222:
4223: dpp_utility_pvt.debug_message('DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);
4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4229: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);

Line 4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);

4222:
4223: dpp_utility_pvt.debug_message('DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);
4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4229: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4230: -- Initialize API return status to sucess

Line 4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);

4223: dpp_utility_pvt.debug_message('DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);
4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4229: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4230: -- Initialize API return status to sucess
4231: x_return_status := fnd_api.g_ret_sts_success;

Line 4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);

4224: dpp_utility_pvt.debug_message('Start :'||l_api_name);
4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4229: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4230: -- Initialize API return status to sucess
4231: x_return_status := fnd_api.g_ret_sts_success;
4232: --open cursor

Line 4229: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);

4225: dpp_utility_pvt.debug_message('DPP Start :'||l_api_name);
4226: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4227: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4228: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4229: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4230: -- Initialize API return status to sucess
4231: x_return_status := fnd_api.g_ret_sts_success;
4232: --open cursor
4233: OPEN transaction_cur(p_document_reference_number,p_supplier_name,p_supplier_site,p_operating_unit);

Line 4255: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_error');

4251: ) ;
4252:
4253:
4254: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
4255: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_error');
4256: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4257: fnd_message.set_token('MESSAGE', x_msg_data);
4258: RAISE FND_API.G_EXC_ERROR;
4259: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 4260: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');

4256: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4257: fnd_message.set_token('MESSAGE', x_msg_data);
4258: RAISE FND_API.G_EXC_ERROR;
4259: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4260: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');
4261: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4262: fnd_message.set_token('MESSAGE', x_msg_data);
4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264: END IF;

Line 4267: dpp_utility_pvt.debug_message('DPP ---- EXCEPTION G_EXC_ERROR:');

4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264: END IF;
4265: EXCEPTION
4266: WHEN Fnd_Api.G_EXC_ERROR THEN
4267: dpp_utility_pvt.debug_message('DPP ***----*** EXCEPTION G_EXC_ERROR:');
4268: x_return_status := Fnd_Api.g_ret_sts_error;
4269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4270: dpp_utility_pvt.debug_message('DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);
4271: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 4270: dpp_utility_pvt.debug_message('DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);

4266: WHEN Fnd_Api.G_EXC_ERROR THEN
4267: dpp_utility_pvt.debug_message('DPP ***----*** EXCEPTION G_EXC_ERROR:');
4268: x_return_status := Fnd_Api.g_ret_sts_error;
4269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4270: dpp_utility_pvt.debug_message('DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);
4271: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4272: WHEN OTHERS THEN
4273: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);
4274: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 4273: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);

4269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4270: dpp_utility_pvt.debug_message('DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);
4271: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4272: WHEN OTHERS THEN
4273: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);
4274: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4275: --ROLLBACK TO dpp_create_webadi_transaction;
4276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4277: THEN

Line 4321: dpp_utility_pvt.debug_message('Event Key = ' || evtkey);

4317: -- Initialize API return status to sucess
4318: x_return_status := fnd_api.g_ret_sts_success;
4319: evtkey := dbms_utility.get_time();
4320: IF DPP_DEBUG_HIGH_ON THEN
4321: dpp_utility_pvt.debug_message('Event Key = ' || evtkey);
4322: END IF;
4323: l_event_test := wf_event.test(l_event_name);
4324: IF l_event_test = 'NONE' THEN
4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');

Line 4328: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');

4324: IF l_event_test = 'NONE' THEN
4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4326: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4327: x_msg_data := fnd_message.get();
4328: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
4329: RAISE FND_API.g_exc_error;
4330: END IF;
4331: -- DEFINE IN WF ATTRIBUTES
4332: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);

Line 4665: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error'||sqlerrm);

4661: x_return_status => l_return_status);
4662:
4663:
4664: IF l_return_status = fnd_api.g_ret_sts_error THEN
4665: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error'||sqlerrm);
4666: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4667: l_error_message := fnd_message.get();
4668: RAISE dpp_webadi_error;
4669: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4670: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error');

4666: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4667: l_error_message := fnd_message.get();
4668: RAISE dpp_webadi_error;
4669: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4670: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error');
4671: RAISE fnd_api.g_exc_unexpected_error;
4672: END IF;
4673:
4674: EXCEPTION

Line 4680: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error l_error_message is null');

4676: WHEN dpp_webadi_error THEN
4677: --x_return_status := FND_API.G_RET_STS_ERROR;
4678: ROLLBACK TO inbound_approval;
4679: if l_error_message is NULL then
4680: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error l_error_message is null');
4681: l_error_message := fnd_message.get();
4682: end if;
4683: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4684: raise_application_error( -20000, l_error_message);

Line 4683: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);

4679: if l_error_message is NULL then
4680: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error l_error_message is null');
4681: l_error_message := fnd_message.get();
4682: end if;
4683: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4684: raise_application_error( -20000, l_error_message);
4685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4686: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4687: ROLLBACK TO inbound_approval;

Line 4686: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');

4682: end if;
4683: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4684: raise_application_error( -20000, l_error_message);
4685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4686: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4687: ROLLBACK TO inbound_approval;
4688: IF length( SQLERRM) > 30 THEN
4689: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4690: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4689: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));

4685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4686: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4687: ROLLBACK TO inbound_approval;
4688: IF length( SQLERRM) > 30 THEN
4689: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4690: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4691: ELSE
4692: fnd_message.set_name ('DPP', SQLERRM);
4693: END IF;

Line 4697: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');

4693: END IF;
4694: l_error_message := fnd_message.get();
4695: raise_application_error( -20000, l_error_message);
4696: WHEN OTHERS THEN
4697: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4698: ROLLBACK TO inbound_approval;
4699: IF length( SQLERRM) > 30 THEN
4700: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4701: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4700: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));

4696: WHEN OTHERS THEN
4697: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4698: ROLLBACK TO inbound_approval;
4699: IF length( SQLERRM) > 30 THEN
4700: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4701: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4702: ELSE
4703: fnd_message.set_name ('DPP', SQLERRM);
4704: END IF;

Line 4707: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);

4703: fnd_message.set_name ('DPP', SQLERRM);
4704: END IF;
4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: l_error_message := fnd_message.get();
4707: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);
4708: raise_application_error( -20000, l_error_message);
4709: END inbound_approval;
4710:
4711: PROCEDURE Create_Transaction(

Line 4787: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name

4783: ||' Supplier Site:' || p_supplier_site
4784: ||' Ref Document Number:' || p_document_reference_number
4785: ||' Operating Unit: ' || p_operating_unit);
4786: END IF;
4787: dpp_utility_pvt.debug_message('DPP_INBOUND_PVT_BODY name:'||p_supplier_name
4788: ||'DPP_INBOUND_PVT_BODY site:'||p_supplier_site
4789: ||'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number
4790: ||'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4791: --BUG 6806974

Line 4855: dpp_utility_pvt.debug_message('Call Insert Transaction p_transaction_int_header_id:'||transaction_rec.transaction_int_header_id);

4851: EXCEPTION WHEN OTHERS THEN
4852: fnd_file.put_line(fnd_file.log, 'Error in updating request id into the table.');
4853: RAISE Fnd_Api.G_EXC_ERROR;
4854: END;
4855: dpp_utility_pvt.debug_message('Call Insert Transaction p_transaction_int_header_id:'||transaction_rec.transaction_int_header_id);
4856: DPP_TRANSACTION_PVT.Insert_Transaction(
4857: p_api_version =>l_api_version
4858: , p_init_msg_list =>l_init_msg_list
4859: , p_commit =>l_commit

Line 4884: dpp_utility_pvt.debug_message(' No of Records Processed : '||l_row_count

4880: fnd_file.put_line(fnd_file.log, ' No of Error Records : '||l_line_count);
4881: fnd_file.put_line(fnd_file.log, ' No of Success Records : '||(l_row_count-l_line_count));
4882:
4883:
4884: dpp_utility_pvt.debug_message(' No of Records Processed : '||l_row_count
4885: ||' No of Error Records : '||l_line_count
4886: ||' No of Success Records : '||(l_row_count-l_line_count));
4887:
4888: IF l_row_count = 0 THEN

Line 4901: dpp_utility_pvt.debug_message('DPP EXCEPTION l_msg_data:' ||l_msg_data);

4897: ELSE
4898: retcode := 1;
4899: errbuf :='Warning';
4900: END IF;
4901: dpp_utility_pvt.debug_message('DPP EXCEPTION l_msg_data:' ||l_msg_data);
4902:
4903: IF DPP_DEBUG_HIGH_ON THEN
4904: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Create Transaction');
4905: END IF;

Line 4909: dpp_utility_pvt.debug_message('DPP EXCEPTION G_EXC_ERROR');

4905: END IF;
4906:
4907: EXCEPTION
4908: WHEN Fnd_Api.G_EXC_ERROR THEN
4909: dpp_utility_pvt.debug_message('DPP EXCEPTION G_EXC_ERROR');
4910: ROLLBACK TO dpp_create_txn;
4911: Fnd_Msg_Pub.Count_AND_Get
4912: ( p_count => l_msg_count,
4913: p_data => l_msg_data,

Line 4917: dpp_utility_pvt.debug_message('DPP EXCEPTION G_EXC_UNEXPECTED_ERROR');

4913: p_data => l_msg_data,
4914: p_encoded => Fnd_Api.G_FALSE
4915: );
4916: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4917: dpp_utility_pvt.debug_message('DPP EXCEPTION G_EXC_UNEXPECTED_ERROR');
4918: ROLLBACK TO dpp_create_txn;
4919: Fnd_Msg_Pub.Count_AND_Get
4920: ( p_count => l_msg_count,
4921: p_data => l_msg_data,

Line 4925: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);

4921: p_data => l_msg_data,
4922: p_encoded => Fnd_Api.G_FALSE
4923: );
4924: WHEN OTHERS THEN
4925: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);
4926: ROLLBACK TO dpp_create_txn;
4927: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4928: THEN
4929: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);