[Home] [Help]
94: Validate_Code_Conversion(
95: p_api_version_number => 1.0,
96: p_init_msg_list => FND_API.G_FALSE,
97: p_validation_level => p_validation_level,
98: p_validation_mode => JTF_PLSQL_API.G_CREATE,
99: p_code_conversion_tbl => p_code_conversion_tbl,
100: x_return_status => x_return_status,
101: x_msg_count => x_msg_count,
102: x_msg_data => x_msg_data);
526: Validate_Code_Conversion(
527: p_api_version_number => 1.0,
528: p_init_msg_list => FND_API.G_FALSE,
529: p_validation_level => p_validation_level,
530: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
531: p_code_conversion_tbl => p_code_conversion_tbl,
532: x_return_status => x_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data);
1639: END Delete_Code_Conversion;
1640:
1641: PROCEDURE Check_uniq_code_conversion(
1642: p_code_conversion_rec IN code_conversion_rec_type,
1643: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1644: x_return_status OUT NOCOPY VARCHAR2
1645: )
1646: IS
1647: l_api_name CONSTANT VARCHAR2(30) := 'Check_uniq_code_conversion';
1702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1703: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1704: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_org_dummy);
1705: END IF;
1706: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1707:
1708: IF p_code_conversion_rec.cust_account_id = FND_API.g_miss_num OR
1709: p_code_conversion_rec.cust_account_id IS NULL
1710: THEN
1810:
1811: PROCEDURE Check_Code_Conv_Req_Items
1812: (
1813: p_code_conversion_rec IN code_conversion_rec_type,
1814: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1815: x_return_status OUT NOCOPY VARCHAR2
1816: )
1817: IS
1818: l_api_name CONSTANT VARCHAR2(30) := 'Check_Code_Conv_Req_Items';
1852:
1853: PROCEDURE Check_Code_Conversion_Dt
1854: (
1855: p_code_conversion_rec IN code_conversion_rec_type,
1856: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1857: x_return_status OUT NOCOPY VARCHAR2
1858: )
1859: IS
1860: l_api_name CONSTANT VARCHAR2(30) := 'check_code_conversion_dt';
1867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1868: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1869: END IF;
1870:
1871: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1872:
1873: IF NVL(p_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
1874: THEN
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2015: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2016: END IF;
2017: x_return_status := FND_API.g_ret_sts_success;
2018:
2019: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2020:
2021: FOR i in 1 .. p_code_conversion_tbl.count
2022: LOOP
2023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2234: END Convert_Code;
2235:
2236: PROCEDURE Check_uniq_supp_code_conv(
2237: p_supp_code_conversion_rec IN supp_code_conversion_rec_type,
2238: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2239: x_return_status OUT NOCOPY VARCHAR2
2240: )
2241: IS
2242: l_api_name CONSTANT VARCHAR2(50) := 'Check_uniq_supp_code_conversion';
2279: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2280: OZF_UTILITY_PVT.debug_message('Dummy value ' || l_dummy);
2281: END IF;
2282:
2283: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2284:
2285: OPEN csr_code_conv(p_supp_code_conversion_rec.supp_trade_profile_id,
2286: p_supp_code_conversion_rec.external_code,
2287: p_supp_code_conversion_rec.internal_code,
2288: p_supp_code_conversion_rec.start_date_active,
2289: p_supp_code_conversion_rec.end_date_active);
2290:
2291:
2292: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
2293: OPEN csr_code_conv(p_supp_code_conversion_rec.supp_trade_profile_id,
2294: p_supp_code_conversion_rec.external_code,
2295: p_supp_code_conversion_rec.internal_code,
2296: p_supp_code_conversion_rec.start_date_active,
2339:
2340: PROCEDURE Check_supp_code_Conv_Req_Items
2341: (
2342: p_supp_code_conversion_rec IN supp_code_conversion_rec_type,
2343: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2344: x_return_status OUT NOCOPY VARCHAR2
2345: )
2346: IS
2347: l_api_name CONSTANT VARCHAR2(50) := 'Check_supp_code_Conv_Req_Items';
2381:
2382: PROCEDURE Check_supp_code_Conversion_Dt
2383: (
2384: p_supp_code_conversion_rec IN supp_code_conversion_rec_type,
2385: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2386: x_return_status OUT NOCOPY VARCHAR2
2387: )
2388: IS
2389: l_api_name CONSTANT VARCHAR2(50) := 'check_supp_code_conversion_dt';
2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2397: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
2398: END IF;
2399:
2400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2401:
2402: IF NVL(p_supp_code_conversion_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
2403: THEN
2404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2625: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
2626: END IF;
2627: x_return_status := FND_API.g_ret_sts_success;
2628:
2629: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2630:
2631: FOR i in 1 .. p_supp_code_conversion_tbl.count
2632: LOOP
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2777: Validate_supp_code_Conv(
2778: p_api_version_number => 1.0,
2779: p_init_msg_list => FND_API.G_FALSE,
2780: p_validation_level => p_validation_level,
2781: p_validation_mode => JTF_PLSQL_API.G_CREATE,
2782: p_supp_code_conversion_tbl => p_supp_code_conversion_tbl,
2783: x_return_status => x_return_status,
2784: x_msg_count => x_msg_count,
2785: x_msg_data => x_msg_data);
3207: Validate_supp_code_Conv(
3208: p_api_version_number => 1.0,
3209: p_init_msg_list => FND_API.G_FALSE,
3210: p_validation_level => p_validation_level,
3211: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
3212: p_supp_code_conversion_tbl => p_supp_code_conversion_tbl,
3213: x_return_status => x_return_status,
3214: x_msg_count => x_msg_count,
3215: x_msg_data => x_msg_data);