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 1024: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_ERROR '||x_msg_data);

1020: END IF;
1021: EXCEPTION
1022: WHEN Fnd_Api.G_EXC_ERROR THEN
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1024: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_ERROR '||x_msg_data);
1025: x_return_status := Fnd_Api.g_ret_sts_error ;
1026: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1027: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);

Line 1028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);

1024: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_ERROR '||x_msg_data);
1025: x_return_status := Fnd_Api.g_ret_sts_error ;
1026: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1027: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);
1029: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1030: WHEN OTHERS THEN
1031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header OTHERS'||sqlerrm);
1032: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

Line 1031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header OTHERS'||sqlerrm);

1027: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header G_EXC_UNEXPECTED_ERROR' ||x_msg_data||sqlerrm);
1029: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1030: WHEN OTHERS THEN
1031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header OTHERS'||sqlerrm);
1032: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1033: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1034: THEN
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1138: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case I');

1134: OR p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
1135: BEGIN
1136: IF p_txn_lines_tbl_type(i).item_number IS NOT NULL
1137: AND p_txn_lines_tbl_type(i).inventory_item_id IS NOT NULL THEN
1138: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case I');
1139: SELECT msi.inventory_item_id,
1140: msi.concatenated_segments,
1141: msi.primary_uom_code
1142: INTO p_txn_lines_tbl_type(i).inventory_item_id

Line 1156: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case II');

1152: AND msi.concatenated_segments = p_txn_lines_tbl_type(i).item_number
1153: AND msi.inventory_item_id = to_number(p_txn_lines_tbl_type(i).inventory_item_id)
1154: AND msi.primary_uom_code = nvl(p_txn_lines_tbl_type(i).uom,msi.primary_uom_code);
1155: ELSIF p_txn_lines_tbl_type(i).item_number IS NULL THEN
1156: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case II');
1157: SELECT msi.inventory_item_id,
1158: msi.concatenated_segments,
1159: msi.primary_uom_code
1160: INTO p_txn_lines_tbl_type(i).inventory_item_id

Line 1173: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case III');

1169: AND msi.organization_id = p_txn_header_rec_type.inventory_organization_id
1170: AND msi.inventory_item_id = to_number(p_txn_lines_tbl_type(i).inventory_item_id)
1171: AND msi.primary_uom_code = nvl(p_txn_lines_tbl_type(i).uom,msi.primary_uom_code);
1172: ELSIF p_txn_lines_tbl_type(i).inventory_item_id IS NULL THEN
1173: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case III');
1174: SELECT msi.inventory_item_id,
1175: msi.concatenated_segments,
1176: msi.primary_uom_code
1177: INTO p_txn_lines_tbl_type(i).inventory_item_id

Line 1218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case IV');

1214:
1215: BEGIN --to get supplier part number for the item number or inventory item id
1216: IF p_txn_lines_tbl_type(i).supplier_part_num IS NOT NULL THEN
1217: BEGIN
1218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case IV');
1219: SELECT occ.external_code
1220: INTO p_txn_lines_tbl_type(i).supplier_part_num
1221: FROM ozf_supp_trd_prfls_all ostpa,
1222: ozf_supp_code_conversions_all occ

Line 1274: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case V');

1270: END IF;
1271:
1272: END;
1273: ELSE
1274: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case V');
1275: SELECT occ.external_code
1276: INTO p_txn_lines_tbl_type(i).supplier_part_num
1277: FROM ozf_supp_trd_prfls_all ostpa,
1278: ozf_supp_code_conversions_all occ

Line 1314: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case V line number '|| i );

1310: l_error_message := x_msg_data;
1311: END IF;
1312:
1313: END;
1314: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case V line number '|| i );
1315: ELSE
1316: BEGIN
1317: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case VI');
1318: SELECT occ.external_code

Line 1317: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case VI');

1313: END;
1314: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case V line number '|| i );
1315: ELSE
1316: BEGIN
1317: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case VI');
1318: SELECT occ.external_code
1319: ,occ.internal_code
1320: INTO p_txn_lines_tbl_type(i).supplier_part_num
1321: ,p_txn_lines_tbl_type(i).inventory_item_id

Line 1400: DPP_UTILITY_PVT.convert_currency(

1396:
1397:
1398: IF p_txn_header_rec_type.functional_currency <> p_txn_header_rec_type.trx_currency THEN
1399: --call procedure to get prior price in transaction currency
1400: DPP_UTILITY_PVT.convert_currency(
1401: p_from_currency => p_txn_header_rec_type.functional_currency
1402: ,p_to_currency => p_txn_header_rec_type.trx_currency
1403: ,p_conv_type => FND_API.G_MISS_CHAR
1404: ,p_conv_rate => FND_API.G_MISS_NUM

Line 1426: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Prior Price:'||p_txn_lines_tbl_type(i).prior_price);

1422: l_error_message :=l_error_message|| x_msg_data;
1423: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1424: END IF;
1425: END IF;
1426: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Prior Price:'||p_txn_lines_tbl_type(i).prior_price);
1427: IF p_txn_lines_tbl_type(i).prior_price IS NULL THEN
1428: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1429: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1430: x_msg_data := fnd_message.get();

Line 1699: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier part number Error: ' || sqlerrm);

1695: END IF;
1696: EXCEPTION
1697: WHEN Fnd_Api.G_EXC_ERROR THEN
1698: x_return_status := Fnd_Api.g_ret_sts_error ;
1699: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier part number Error: ' || sqlerrm);
1700: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1701: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1702: WHEN OTHERS THEN
1703: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

Line 1753: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);

1749: FND_FILE.PUT_LINE(FND_FILE.LOG,' Transaction Header Id'||p_txn_lines_tbl_type(i).transaction_header_id);
1750: FND_FILE.PUT_LINE(FND_FILE.LOG,' Supplier Part Num'||p_txn_lines_tbl_type(i).supplier_part_num);
1751: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inventory Item ID'||p_txn_lines_tbl_type(i).inventory_item_id);
1752: END IF;
1753: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Prior Price Create Lines:'||p_txn_lines_tbl_type(i).prior_price);
1754: -- Insert lines into dpp_transaction_lines_all table
1755: INSERT INTO dpp_transaction_lines_all(
1756: object_version_number
1757: , transaction_header_id

Line 1902: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'End Create Lines'|| sqlerrm);

1898: END LOOP; --FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
1899: IF DPP_DEBUG_HIGH_ON THEN
1900: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Create Lines');
1901: END IF;
1902: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'End Create Lines'|| sqlerrm);
1903: EXCEPTION
1904: WHEN Fnd_Api.G_EXC_ERROR THEN
1905: x_return_status := Fnd_Api.g_ret_sts_error ;
1906: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 1909: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception Create Lines'||sqlerrm);

1905: x_return_status := Fnd_Api.g_ret_sts_error ;
1906: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1907: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1908: WHEN OTHERS THEN
1909: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception Create Lines'||sqlerrm);
1910: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1913: fnd_message.set_token('ROUTINE', l_full_name);

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

1964: FND_FILE.PUT_LINE(FND_FILE.LOG,' Update_CoveredInv Rec type Org_ID'||l_header_rec_type.org_id);
1965: FND_FILE.PUT_LINE(FND_FILE.LOG,' Update_CoveredInv Rec type Effective Start Date'|| l_header_rec_type.effective_start_date);
1966: FND_FILE.PUT_LINE(FND_FILE.LOG,' Update_CoveredInv Rec type Effective End Date'||l_header_rec_type.effective_end_date);
1967: END IF;
1968: --Form Line table to to get covered Inventory Details DPP_UTILITY_PVT.Get_CoveredInventory
1969: FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
1970: LOOP
1971:
1972: l_line_tbl_type(i).transaction_line_id := p_txn_lines_tbl_type(i).transaction_line_id;

Line 1996: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);

1992: ,p_inv_hdr_rec => l_header_rec_type
1993: ,p_covered_inv_tbl => l_line_tbl_type
1994: );
1995:
1996: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);
1997:
1998: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1999: RAISE Fnd_Api.g_exc_error;
2000: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 2016: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);

2012: ,p_inv_hdr_rec => l_header_rec_type
2013: ,p_covered_inv_tbl => l_line_tbl_type
2014: );
2015:
2016: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);
2017:
2018: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
2019: RAISE Fnd_Api.g_exc_error;
2020: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 2028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);

2024: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Update Covered Inventory');
2025: END IF;
2026: FOR i in l_line_tbl_type.FIRST..l_line_tbl_type.LAST
2027: LOOP
2028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
2029: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
2030: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
2031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
2032: IF DPP_DEBUG_HIGH_ON THEN

Line 2029: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);

2025: END IF;
2026: FOR i in l_line_tbl_type.FIRST..l_line_tbl_type.LAST
2027: LOOP
2028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
2029: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
2030: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
2031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
2032: IF DPP_DEBUG_HIGH_ON THEN
2033: FND_FILE.PUT_LINE(FND_FILE.LOG,'After get covered Inventory');

Line 2030: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);

2026: FOR i in l_line_tbl_type.FIRST..l_line_tbl_type.LAST
2027: LOOP
2028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
2029: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
2030: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
2031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
2032: IF DPP_DEBUG_HIGH_ON THEN
2033: FND_FILE.PUT_LINE(FND_FILE.LOG,'After get covered Inventory');
2034: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);

Line 2031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);

2027: LOOP
2028: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
2029: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);
2030: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).onhand_quantity:'||l_line_tbl_type(i).onhand_quantity);
2031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'l_line_tbl_type(i).covered_quantity:'||l_line_tbl_type(i).covered_quantity);
2032: IF DPP_DEBUG_HIGH_ON THEN
2033: FND_FILE.PUT_LINE(FND_FILE.LOG,'After get covered Inventory');
2034: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).transaction_line_id:'||l_line_tbl_type(i).transaction_line_id);
2035: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_line_tbl_type(i).inventory_item_id:'||l_line_tbl_type(i).inventory_item_id);

Line 3011: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Insert Transaction:'||l_transaction_type);

3007: ELSE
3008: l_transaction_type := 'APP';
3009: END IF;
3010:
3011: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Insert Transaction:'||l_transaction_type);
3012:
3013: --Form header record type to populate header table
3014: l_txn_header_rec_type.transaction_int_header_id :=fetch_header_rec.transaction_int_header_id;
3015: l_txn_header_rec_type.ref_document_number := fetch_header_rec.ref_document_number;

Line 3085: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Ref Doc Num Status :'||l_return_status);

3081: ,x_msg_count => x_msg_count
3082: ,x_msg_data => x_msg_data
3083: ,x_return_status => l_return_status
3084: );
3085: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Ref Doc Num Status :'||l_return_status);
3086: IF DPP_DEBUG_HIGH_ON THEN
3087: fnd_file.put_line(fnd_file.log, 'Validate Ref Document Number Return Status: '||l_return_status ||'Error Msg: '||x_msg_data);
3088: END IF;
3089: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3104: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Operating Unit Status :'||l_return_status);

3100: ,x_msg_count => x_msg_count
3101: ,x_msg_data => x_msg_data
3102: ,x_return_status => l_return_status
3103: );
3104: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Operating Unit Status :'||l_return_status);
3105: IF DPP_DEBUG_HIGH_ON THEN
3106: 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);
3107: END IF;
3108:

Line 3127: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Details Status :'||l_return_status);

3123: ,x_msg_data => x_msg_data
3124: ,x_return_status => l_return_status
3125: );
3126:
3127: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Details Status :'||l_return_status);
3128:
3129: IF DPP_DEBUG_HIGH_ON THEN
3130: fnd_file.put_line(fnd_file.log, 'Validate Supplier Details Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3131: END IF;

Line 3152: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Trade Profile Status :' || l_return_status);

3148: ,x_msg_data => x_msg_data
3149: ,x_return_status => l_return_status
3150: );
3151:
3152: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Trade Profile Status :' || l_return_status);
3153: IF DPP_DEBUG_HIGH_ON THEN
3154: fnd_file.put_line(fnd_file.log, 'Validate Supplier Trade Profile Return Status:' || l_return_status || 'Error Msg ' || x_msg_data);
3155: END IF;
3156: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3175: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Execution Process Setup Status : ' || l_return_status);

3171: ,x_msg_data => x_msg_data
3172: ,x_return_status => l_return_status
3173: );
3174:
3175: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Execution Process Setup Status : ' || l_return_status);
3176:
3177: IF DPP_DEBUG_HIGH_ON THEN
3178: fnd_file.put_line(fnd_file.log, 'Validate Execution Process Setup Status : ' || l_return_status || 'Error Msg ' || x_msg_data);
3179: END IF;

Line 3198: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Currency Status :'||l_return_status);

3194: ,x_msg_data => x_msg_data
3195: ,x_return_status => l_return_status
3196: );
3197:
3198: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Currency Status :'||l_return_status);
3199:
3200: IF DPP_DEBUG_HIGH_ON THEN
3201: fnd_file.put_line(fnd_file.log, 'Validate Currency Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3202: END IF;

Line 3218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Lines Status :'||l_return_status);

3214: ,x_msg_data => x_msg_data
3215: ,x_return_status => l_return_status
3216: );
3217:
3218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Lines Status :'||l_return_status);
3219: IF DPP_DEBUG_HIGH_ON THEN
3220: fnd_file.put_line(fnd_file.log, 'Validate Line Details Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3221: END IF;
3222: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3289: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'New Transaction');

3285: IF l_transaction_status IS NULL OR l_transaction_status = l_status_cancelled THEN
3286: IF DPP_DEBUG_HIGH_ON THEN
3287: fnd_file.put_line(fnd_file.log, ' Inbound Price Protection Transaction ' );
3288: END IF;
3289: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'New Transaction');
3290: IF l_concatenated_error_message IS NOT NULL THEN
3291: RAISE Fnd_Api.g_exc_error;
3292: END IF;
3293: -- Create Header record in dpp_transaction_headers_all table

Line 3300: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create Header Status :'||l_return_status);

3296: ,x_msg_data => x_msg_data
3297: ,x_return_status => l_return_status
3298: );
3299:
3300: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create Header Status :'||l_return_status);
3301: IF DPP_DEBUG_HIGH_ON THEN
3302: fnd_file.put_line(fnd_file.log, 'Create Header Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3303: END IF;
3304: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3312: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create_Header');

3308: ,x_return_status =>l_return_status
3309: );
3310: RAISE Fnd_Api.g_exc_error;
3311: END IF;
3312: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create_Header');
3313: --Update Header history log
3314: IF l_log_enabled = 'Y' THEN
3315: Update_HeaderLog(p_txn_header_rec_type => l_txn_header_rec_type
3316: ,x_msg_count => x_msg_count

Line 3337: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Form Line Tbl Status :'||l_return_status);

3333: ,x_msg_data => x_msg_data
3334: ,x_return_status => l_return_status
3335: );
3336:
3337: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Form Line Tbl Status :'||l_return_status);
3338: IF DPP_DEBUG_HIGH_ON THEN
3339: fnd_file.put_line(fnd_file.log, 'Form Line Tbl Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3340: END IF;
3341: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3349: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Form line tbl');

3345: p_txn_lines_tbl_type => l_txn_lines_tbl_type
3346: ,x_return_status =>l_return_status
3347: );
3348: END IF;
3349: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Form line tbl');
3350: --Validate the distributor Part Number
3351: Validate_SupplierPartNum(
3352: p_txn_header_rec_type =>l_txn_header_rec_type
3353: ,p_txn_lines_tbl_type => l_txn_lines_tbl_type

Line 3358: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Part Num Status :'||l_return_status);

3354: ,x_msg_count => x_msg_count
3355: ,x_msg_data => x_msg_data
3356: ,x_return_status => l_return_status
3357: );
3358: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Part Num Status :'||l_return_status);
3359: IF G_DEBUG THEN
3360: fnd_file.put_line(fnd_file.log, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3361: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||substr(x_msg_data,1,1000));
3362: END IF;

Line 3361: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||substr(x_msg_data,1,1000));

3357: );
3358: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Supplier Part Num Status :'||l_return_status);
3359: IF G_DEBUG THEN
3360: fnd_file.put_line(fnd_file.log, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3361: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate SupplierPartNum Return Status:'||l_return_status ||'Error Msg'||substr(x_msg_data,1,1000));
3362: END IF;
3363:
3364: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
3365: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;

Line 3377: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number');

3373: IF l_concatenated_error_message IS NOT NULL THEN
3374: x_msg_data:= l_concatenated_error_message;
3375: RAISE Fnd_Api.g_exc_error;
3376: END IF;
3377: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number');
3378: --Call Insert lines procedure
3379: Create_lines( p_txn_header_rec_type => l_txn_header_rec_type
3380: ,p_txn_lines_tbl_type => l_txn_lines_tbl_type
3381: ,x_msg_count => x_msg_count

Line 3385: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create Lines Status :'||l_return_status);

3381: ,x_msg_count => x_msg_count
3382: ,x_msg_data => x_msg_data
3383: ,x_return_status => l_return_status
3384: );
3385: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create Lines Status :'||l_return_status);
3386: IF DPP_DEBUG_HIGH_ON THEN
3387: fnd_file.put_line(fnd_file.log, 'Create Lines Return Status:'||l_return_status ||'Error Msg'||x_msg_data);
3388: END IF;
3389: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3431: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Update CoveredInv Status :'||l_return_status);

3427: ,x_msg_count => x_msg_count
3428: ,x_msg_data =>x_msg_data
3429: ,x_return_status => l_return_status
3430: );
3431: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Update CoveredInv Status :'||l_return_status);
3432: IF DPP_DEBUG_HIGH_ON THEN
3433: fnd_file.put_line(fnd_file.log, 'Update Covered Inventory Return Status:'||l_return_status);
3434: END IF;
3435: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3443: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Status '||l_return_status|| ' Message '||x_msg_data);

3439: p_txn_header_rec_type => l_txn_header_rec_type,
3440: p_txn_lines_tbl_type => l_txn_lines_tbl_type
3441: ,x_return_status =>l_return_status
3442: );
3443: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Status '||l_return_status|| ' Message '||x_msg_data);
3444:
3445: RAISE Fnd_Api.g_exc_error;
3446: END IF;
3447: ELSE

Line 3459: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Transaction Exist Status :'||l_return_status);

3455: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
3456: IF DPP_DEBUG_HIGH_ON THEN
3457: fnd_file.put_line(fnd_file.log, 'Error:' || x_msg_data);
3458: END IF;
3459: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Transaction Exist Status :'||l_return_status);
3460: Update_InterfaceErrSts(
3461: p_txn_header_rec_type => l_txn_header_rec_type
3462: ,x_return_status =>l_return_status
3463: );

Line 3490: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Insert Execution Processes Status : ' || l_return_status);

3486: ,x_msg_count => x_msg_count
3487: ,x_msg_data => x_msg_data
3488: ,x_return_status => l_return_status
3489: );
3490: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Insert Execution Processes Status : ' || l_return_status);
3491: IF DPP_DEBUG_HIGH_ON THEN
3492: fnd_file.put_line(fnd_file.log, 'Populate Execution Processes based on Supplier Trade Profile or System Parameters Status : ' || l_return_status || 'Error Msg ' || x_msg_data);
3493: END IF;
3494: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 3719: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP G_EXC_ERROR x_msg_data');

3715: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3716: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3717: l_msg_data := fnd_message.get();
3718: x_msg_data := l_msg_data || l_concatenated_error_message;
3719: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP G_EXC_ERROR x_msg_data');
3720: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);
3721:
3722:
3723: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3720: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);

3716: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3717: l_msg_data := fnd_message.get();
3718: x_msg_data := l_msg_data || l_concatenated_error_message;
3719: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP G_EXC_ERROR x_msg_data');
3720: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Status '||x_return_status|| ' Message '||x_msg_data);
3721:
3722:
3723: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3724: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');

Line 3731: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);

3727: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3728: x_msg_data := fnd_message.get();
3729: x_msg_data:= x_msg_data ||l_concatenated_error_message;
3730: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3731: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);
3732:
3733: WHEN OTHERS THEN
3734: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3735: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

Line 3739: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error:' ||x_msg_data);

3735: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3736: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3737: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3738: x_msg_data := fnd_message.get();
3739: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error:' ||x_msg_data);
3740: x_msg_data := x_msg_data || l_concatenated_error_message;
3741: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3742: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error after assignment:' ||x_msg_data);
3743: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

Line 3742: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error after assignment:' ||x_msg_data);

3738: x_msg_data := fnd_message.get();
3739: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error:' ||x_msg_data);
3740: x_msg_data := x_msg_data || l_concatenated_error_message;
3741: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3742: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error after assignment:' ||x_msg_data);
3743: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
3744: THEN
3745: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3746: END IF;

Line 4111: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);

4107:
4108: EXCEPTION
4109: WHEN create_IntLines_exception THEN
4110: x_return_status := fnd_api.g_ret_sts_error;
4111: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);
4112: WHEN others THEN
4113: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines : SQLERRM:'||SQLERRM);
4114: x_return_status := fnd_api.g_ret_sts_unexp_error;
4115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4113: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines : SQLERRM:'||SQLERRM);

4109: WHEN create_IntLines_exception THEN
4110: x_return_status := fnd_api.g_ret_sts_error;
4111: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);
4112: WHEN others THEN
4113: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines : SQLERRM:'||SQLERRM);
4114: x_return_status := fnd_api.g_ret_sts_unexp_error;
4115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4116: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4117: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

Line 4236: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Entered OU in webadi api');

4232: --l_return_status := fnd_api.g_ret_sts_success;
4233:
4234:
4235: IF p_distributor_operating_unit IS NULL THEN
4236: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Entered OU in webadi api');
4237: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');
4238: l_error_message := fnd_message.get();
4239: l_message := l_message || l_error_message;
4240: --RAISE DPP_WEBADI_ERROR;

Line 4318: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Entered VALUE');

4314: --RAISE DPP_WEBADI_ERROR;
4315: END IF;
4316:
4317: IF p_change_value IS NULL OR p_change_value <= 0 THEN
4318: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Entered VALUE');
4319: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');
4320: l_error_message := fnd_message.get();
4321: l_message := l_message || l_error_message;
4322: --raise_application_error( -20000, l_error_message);

Line 4375: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Lines Assignment');

4371: l_transaction_header_rec.attribute29 := p_hdrattribute29;
4372: l_transaction_header_rec.attribute30 := p_hdrattribute30;
4373:
4374: --Assign to rec type l_transaction_header_rec
4375: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Lines Assignment');
4376: l_transaction_lines_rec.SUPPLIER_PART_NUM := p_supplier_part_num;
4377: l_transaction_lines_rec.ITEM_NUMBER := P_ITEM_NUMBER;
4378: l_transaction_lines_rec.CHANGE_TYPE := P_CHANGE_TYPE;
4379: l_transaction_lines_rec.CHANGE_VALUE := P_CHANGE_VALUE;

Line 4435: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP SYSTEM ERROR');

4431: x_return_status => l_return_status);
4432:
4433:
4434: IF l_return_status = fnd_api.g_ret_sts_error THEN
4435: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP SYSTEM ERROR');
4436: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4437: l_error_message := fnd_message.get();
4438: RAISE dpp_webadi_error;
4439: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4440: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP UNEXPECTED ERROR');

4436: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4437: l_error_message := fnd_message.get();
4438: RAISE dpp_webadi_error;
4439: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4440: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP UNEXPECTED ERROR');
4441: RAISE fnd_api.g_exc_unexpected_error;
4442: END IF;
4443:
4444: EXCEPTION

Line 4450: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);

4446: ROLLBACK TO inbound_transaction;
4447: if l_message is NULL then
4448: l_message := fnd_message.get();
4449: end if;
4450: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);
4451: raise_application_error( -20000, l_message);
4452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4453: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4454: ROLLBACK TO inbound_transaction;

Line 4453: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');

4449: end if;
4450: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);
4451: raise_application_error( -20000, l_message);
4452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4453: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4454: ROLLBACK TO inbound_transaction;
4455: IF length( SQLERRM) > 30 THEN
4456: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4457: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4456: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));

4452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4453: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4454: ROLLBACK TO inbound_transaction;
4455: IF length( SQLERRM) > 30 THEN
4456: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4457: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4458: ELSE
4459: fnd_message.set_name ('DPP', SQLERRM);
4460: END IF;

Line 4464: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN OTHERS BLOCK');

4460: END IF;
4461: l_error_message := fnd_message.get();
4462: raise_application_error( -20000, l_error_message);
4463: WHEN OTHERS THEN
4464: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN OTHERS BLOCK');
4465: ROLLBACK TO inbound_transaction;
4466: IF length( SQLERRM) > 30 THEN
4467: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4468: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4467: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));

4463: WHEN OTHERS THEN
4464: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN OTHERS BLOCK');
4465: ROLLBACK TO inbound_transaction;
4466: IF length( SQLERRM) > 30 THEN
4467: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4468: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4469: ELSE
4470: fnd_message.set_name ('DPP', SQLERRM);
4471: END IF;

Line 4473: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP l_error_message:'||l_error_message);

4469: ELSE
4470: fnd_message.set_name ('DPP', SQLERRM);
4471: END IF;
4472: l_error_message := fnd_message.get();
4473: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP l_error_message:'||l_error_message);
4474: raise_application_error( -20000, l_error_message);
4475: END inbound_transaction;
4476:
4477: PROCEDURE create_webadi_transaction(p_document_reference_number IN VARCHAR2

Line 4512: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());

4508: AND dthia.interface_status = 'N'
4509: AND dthia.operating_unit_name = cv_operating_unit;
4510:
4511: BEGIN
4512: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);
4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);

Line 4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);

4509: AND dthia.operating_unit_name = cv_operating_unit;
4510:
4511: BEGIN
4512: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);
4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);

Line 4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);

4510:
4511: BEGIN
4512: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);
4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4518: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);

Line 4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);

4511: BEGIN
4512: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);
4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4518: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4519: -- Initialize API return status to sucess

Line 4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);

4512: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start Time :'||sysdate || 'Time ' ||dbms_utility.get_time());
4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);
4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4518: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4519: -- Initialize API return status to sucess
4520: x_return_status := fnd_api.g_ret_sts_success;

Line 4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);

4513: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Start :'||l_api_name);
4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4518: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4519: -- Initialize API return status to sucess
4520: x_return_status := fnd_api.g_ret_sts_success;
4521: --open cursor

Line 4518: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);

4514: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP Start :'||l_api_name);
4515: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name);
4516: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY site:'||p_supplier_site);
4517: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number);
4518: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4519: -- Initialize API return status to sucess
4520: x_return_status := fnd_api.g_ret_sts_success;
4521: --open cursor
4522: OPEN transaction_cur(p_document_reference_number,p_supplier_name,p_supplier_site,p_operating_unit);

Line 4544: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create WebADI Transaction Fnd_Api.g_ret_sts_error');

4540: ) ;
4541:
4542:
4543: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
4544: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create WebADI Transaction Fnd_Api.g_ret_sts_error');
4545: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4546: fnd_message.set_token('MESSAGE', x_msg_data);
4547: RAISE FND_API.G_EXC_ERROR;
4548: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 4549: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');

4545: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4546: fnd_message.set_token('MESSAGE', x_msg_data);
4547: RAISE FND_API.G_EXC_ERROR;
4548: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4549: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');
4550: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4551: fnd_message.set_token('MESSAGE', x_msg_data);
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: END IF;

Line 4556: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ---- EXCEPTION G_EXC_ERROR:');

4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: END IF;
4554: EXCEPTION
4555: WHEN Fnd_Api.G_EXC_ERROR THEN
4556: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ***----*** EXCEPTION G_EXC_ERROR:');
4557: x_return_status := Fnd_Api.g_ret_sts_error;
4558: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4559: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);
4560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 4559: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);

4555: WHEN Fnd_Api.G_EXC_ERROR THEN
4556: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ***----*** EXCEPTION G_EXC_ERROR:');
4557: x_return_status := Fnd_Api.g_ret_sts_error;
4558: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4559: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);
4560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4561: WHEN OTHERS THEN
4562: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);
4563: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 4562: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);

4558: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4559: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP ************EXCEPTION G_EXC_UNEXPECTED_ERROR'||x_msg_data);
4560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4561: WHEN OTHERS THEN
4562: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);
4563: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4564: --ROLLBACK TO dpp_create_webadi_transaction;
4565: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4566: THEN

Line 4609: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Event Key = ' || evtkey);

4605: SAVEPOINT DPP_Raise_OutBoundEvent;
4606: -- Initialize API return status to sucess
4607: x_return_status := fnd_api.g_ret_sts_success;
4608: evtkey := dbms_utility.get_time();
4609: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Event Key = ' || evtkey);
4610: l_event_test := wf_event.test(l_event_name);
4611: IF l_event_test = 'NONE' THEN
4612: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4613: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);

Line 4615: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No enabled local subscriptions reference the event, or the event does not exist.');

4611: IF l_event_test = 'NONE' THEN
4612: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4613: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4614: x_msg_data := fnd_message.get();
4615: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No enabled local subscriptions reference the event, or the event does not exist.');
4616: RAISE FND_API.g_exc_error;
4617: END IF;
4618: -- DEFINE IN WF ATTRIBUTES
4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);

Line 4952: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create_Intlines fnd_api.g_ret_sts_error'||sqlerrm);

4948: x_return_status => l_return_status);
4949:
4950:
4951: IF l_return_status = fnd_api.g_ret_sts_error THEN
4952: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create_Intlines fnd_api.g_ret_sts_error'||sqlerrm);
4953: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4954: l_error_message := fnd_message.get();
4955: RAISE dpp_webadi_error;
4956: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4957: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create_Intlines fnd_api.g_ret_sts_error');

4953: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4954: l_error_message := fnd_message.get();
4955: RAISE dpp_webadi_error;
4956: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4957: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Create_Intlines fnd_api.g_ret_sts_error');
4958: RAISE fnd_api.g_exc_unexpected_error;
4959: END IF;
4960:
4961: EXCEPTION

Line 4967: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error l_error_message is null');

4963: WHEN dpp_webadi_error THEN
4964: --x_return_status := FND_API.G_RET_STS_ERROR;
4965: ROLLBACK TO inbound_approval;
4966: if l_error_message is NULL then
4967: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error l_error_message is null');
4968: l_error_message := fnd_message.get();
4969: end if;
4970: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);
4971: raise_application_error( -20000, l_error_message);

Line 4970: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);

4966: if l_error_message is NULL then
4967: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error l_error_message is null');
4968: l_error_message := fnd_message.get();
4969: end if;
4970: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);
4971: raise_application_error( -20000, l_error_message);
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4974: ROLLBACK TO inbound_approval;

Line 4973: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');

4969: end if;
4970: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP in DPP_webadi_error:'||l_error_message);
4971: raise_application_error( -20000, l_error_message);
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4974: ROLLBACK TO inbound_approval;
4975: IF length( SQLERRM) > 30 THEN
4976: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4977: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4976: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));

4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4974: ROLLBACK TO inbound_approval;
4975: IF length( SQLERRM) > 30 THEN
4976: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4977: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4978: ELSE
4979: fnd_message.set_name ('DPP', SQLERRM);
4980: END IF;

Line 4984: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN OTHERS BLOCK');

4980: END IF;
4981: l_error_message := fnd_message.get();
4982: raise_application_error( -20000, l_error_message);
4983: WHEN OTHERS THEN
4984: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN OTHERS BLOCK');
4985: ROLLBACK TO inbound_approval;
4986: IF length( SQLERRM) > 30 THEN
4987: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4988: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

Line 4987: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));

4983: WHEN OTHERS THEN
4984: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP IN OTHERS BLOCK');
4985: ROLLBACK TO inbound_approval;
4986: IF length( SQLERRM) > 30 THEN
4987: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(SQLERRM,12,30));
4988: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4989: ELSE
4990: fnd_message.set_name ('DPP', SQLERRM);
4991: END IF;

Line 4994: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP l_error_message:'||l_error_message);

4990: fnd_message.set_name ('DPP', SQLERRM);
4991: END IF;
4992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4993: l_error_message := fnd_message.get();
4994: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP l_error_message:'||l_error_message);
4995: raise_application_error( -20000, l_error_message);
4996: END inbound_approval;
4997:
4998: PROCEDURE Create_Transaction(

Line 5074: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name

5070: ||' Supplier Site:' || p_supplier_site
5071: ||' Ref Document Number:' || p_document_reference_number
5072: ||' Operating Unit: ' || p_operating_unit);
5073: END IF;
5074: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP_INBOUND_PVT_BODY name:'||p_supplier_name
5075: ||'DPP_INBOUND_PVT_BODY site:'||p_supplier_site
5076: ||'DPP_INBOUND_PVT_BODY ref:'||p_document_reference_number
5077: ||'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
5078: --BUG 6806974

Line 5142: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Call Insert Transaction p_transaction_int_header_id:'||transaction_rec.transaction_int_header_id);

5138: EXCEPTION WHEN OTHERS THEN
5139: fnd_file.put_line(fnd_file.log, 'Error in updating request id into the table.');
5140: RAISE Fnd_Api.G_EXC_ERROR;
5141: END;
5142: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Call Insert Transaction p_transaction_int_header_id:'||transaction_rec.transaction_int_header_id);
5143: DPP_TRANSACTION_PVT.Insert_Transaction(
5144: p_api_version =>l_api_version
5145: , p_init_msg_list =>l_init_msg_list
5146: , p_commit =>l_commit

Line 5170: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, ' No of Records Processed : '||l_row_count

5166: fnd_file.put_line(fnd_file.log, ' No of Records Processed : '||l_row_count);
5167: fnd_file.put_line(fnd_file.log, ' No of Error Records : '||l_line_count);
5168: fnd_file.put_line(fnd_file.log, ' No of Success Records : '||(l_row_count-l_line_count));
5169:
5170: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, ' No of Records Processed : '||l_row_count
5171: ||' No of Error Records : '||l_line_count
5172: ||' No of Success Records : '||(l_row_count-l_line_count));
5173:
5174: IF l_row_count = 0 THEN

Line 5187: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION l_msg_data:' ||l_msg_data);

5183: ELSE
5184: retcode := 1;
5185: errbuf :='Warning';
5186: END IF;
5187: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION l_msg_data:' ||l_msg_data);
5188:
5189: IF DPP_DEBUG_HIGH_ON THEN
5190: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Create Transaction');
5191: END IF;

Line 5195: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION G_EXC_ERROR');

5191: END IF;
5192:
5193: EXCEPTION
5194: WHEN Fnd_Api.G_EXC_ERROR THEN
5195: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION G_EXC_ERROR');
5196: ROLLBACK TO dpp_create_txn;
5197: Fnd_Msg_Pub.Count_AND_Get
5198: ( p_count => l_msg_count,
5199: p_data => l_msg_data,

Line 5203: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION G_EXC_UNEXPECTED_ERROR');

5199: p_data => l_msg_data,
5200: p_encoded => Fnd_Api.G_FALSE
5201: );
5202: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
5203: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION G_EXC_UNEXPECTED_ERROR');
5204: ROLLBACK TO dpp_create_txn;
5205: Fnd_Msg_Pub.Count_AND_Get
5206: ( p_count => l_msg_count,
5207: p_data => l_msg_data,

Line 5211: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);

5207: p_data => l_msg_data,
5208: p_encoded => Fnd_Api.G_FALSE
5209: );
5210: WHEN OTHERS THEN
5211: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);
5212: ROLLBACK TO dpp_create_txn;
5213: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
5214: THEN
5215: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);