[Home] [Help]
99: Validate_Code_Conversion(
100: p_api_version_number => 1.0,
101: p_init_msg_list => FND_API.G_FALSE,
102: p_validation_level => p_validation_level,
103: p_validation_mode => JTF_PLSQL_API.G_CREATE,
104: p_code_conversion_tbl => p_code_conversion_tbl,
105: x_return_status => x_return_status,
106: x_msg_count => x_msg_count,
107: x_msg_data => x_msg_data);
539: Validate_Code_Conversion(
540: p_api_version_number => 1.0,
541: p_init_msg_list => FND_API.G_FALSE,
542: p_validation_level => p_validation_level,
543: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
544: p_code_conversion_tbl => p_code_conversion_tbl,
545: x_return_status => x_return_status,
546: x_msg_count => x_msg_count,
547: x_msg_data => x_msg_data);
1652: END Delete_Code_Conversion;
1653:
1654: PROCEDURE Check_uniq_code_conversion(
1655: p_code_conversion_rec IN code_conversion_rec_type,
1656: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1657: x_return_status OUT NOCOPY VARCHAR2
1658: )
1659: IS
1660: l_api_name CONSTANT VARCHAR2(30) := 'Check_uniq_code_conversion';
1726: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1727: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1728: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_org_dummy);
1729: END IF;
1730: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1731:
1732: IF p_code_conversion_rec.cust_account_id = FND_API.g_miss_num OR
1733: p_code_conversion_rec.cust_account_id IS NULL
1734: THEN
1841:
1842: PROCEDURE Check_Code_Conv_Req_Items
1843: (
1844: p_code_conversion_rec IN code_conversion_rec_type,
1845: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1846: x_return_status OUT NOCOPY VARCHAR2
1847: )
1848: IS
1849: l_api_name CONSTANT VARCHAR2(30) := 'Check_Code_Conv_Req_Items';
1883:
1884: PROCEDURE Check_Code_Conversion_Dt
1885: (
1886: p_code_conversion_rec IN code_conversion_rec_type,
1887: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1888: x_return_status OUT NOCOPY VARCHAR2
1889: )
1890: IS
1891: l_api_name CONSTANT VARCHAR2(30) := 'check_code_conversion_dt';
1898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1899: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1900: END IF;
1901:
1902: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1903:
1904: IF NVL(p_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
1905: THEN
1906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2046: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2047: END IF;
2048: x_return_status := FND_API.g_ret_sts_success;
2049:
2050: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2051:
2052: FOR i in 1 .. p_code_conversion_tbl.count
2053: LOOP
2054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2265: END Convert_Code;
2266:
2267: PROCEDURE Check_uniq_supp_code_conv(
2268: p_supp_code_conversion_rec IN supp_code_conversion_rec_type,
2269: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2270: x_return_status OUT NOCOPY VARCHAR2
2271: )
2272: IS
2273: l_api_name CONSTANT VARCHAR2(50) := 'Check_uniq_supp_code_conversion';
2310: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2311: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_dummy);
2312: END IF;
2313:
2314: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2315:
2316: OPEN csr_code_conv(p_supp_code_conversion_rec.supp_trade_profile_id,
2317: p_supp_code_conversion_rec.external_code,
2318: p_supp_code_conversion_rec.internal_code,
2319: p_supp_code_conversion_rec.start_date_active,
2320: p_supp_code_conversion_rec.end_date_active);
2321:
2322:
2323: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
2324: OPEN csr_code_conv(p_supp_code_conversion_rec.supp_trade_profile_id,
2325: p_supp_code_conversion_rec.external_code,
2326: p_supp_code_conversion_rec.internal_code,
2327: p_supp_code_conversion_rec.start_date_active,
2370:
2371: PROCEDURE Check_supp_code_Conv_Req_Items
2372: (
2373: p_supp_code_conversion_rec IN supp_code_conversion_rec_type,
2374: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2375: x_return_status OUT NOCOPY VARCHAR2
2376: )
2377: IS
2378: l_api_name CONSTANT VARCHAR2(50) := 'Check_supp_code_Conv_Req_Items';
2412:
2413: PROCEDURE Check_supp_code_Conversion_Dt
2414: (
2415: p_supp_code_conversion_rec IN supp_code_conversion_rec_type,
2416: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2417: x_return_status OUT NOCOPY VARCHAR2
2418: )
2419: IS
2420: l_api_name CONSTANT VARCHAR2(50) := 'check_supp_code_conversion_dt';
2427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2428: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2429: END IF;
2430:
2431: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2432:
2433: IF NVL(p_supp_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
2434: THEN
2435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2656: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2657: END IF;
2658: x_return_status := FND_API.g_ret_sts_success;
2659:
2660: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2661:
2662: FOR i in 1 .. p_supp_code_conversion_tbl.count
2663: LOOP
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2808: Validate_supp_code_Conv(
2809: p_api_version_number => 1.0,
2810: p_init_msg_list => FND_API.G_FALSE,
2811: p_validation_level => p_validation_level,
2812: p_validation_mode => JTF_PLSQL_API.G_CREATE,
2813: p_supp_code_conversion_tbl => p_supp_code_conversion_tbl,
2814: x_return_status => x_return_status,
2815: x_msg_count => x_msg_count,
2816: x_msg_data => x_msg_data);
3238: Validate_supp_code_Conv(
3239: p_api_version_number => 1.0,
3240: p_init_msg_list => FND_API.G_FALSE,
3241: p_validation_level => p_validation_level,
3242: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
3243: p_supp_code_conversion_tbl => p_supp_code_conversion_tbl,
3244: x_return_status => x_return_status,
3245: x_msg_count => x_msg_count,
3246: x_msg_data => x_msg_data);