DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIM_UTILITY_PVT

Line 974: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

970: ,x_msg_data OUT NOCOPY VARCHAR2
971: ,x_msg_count OUT NOCOPY NUMBER
972:
973: ,p_claim_line_tbl IN claim_line_tbl_type
974: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
975:
976: ,x_error_index OUT NOCOPY NUMBER
977: ) IS
978: l_api_version CONSTANT NUMBER := 1.0;

Line 1042: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN

1038:
1039: l_claim_line_tbl := p_claim_line_tbl;
1040:
1041: ---------------------- check claim access ------------------------
1042: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN
1043: FOR j IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP
1044: IF p_claim_line_tbl.EXISTS(j) THEN
1045: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
1046: P_Api_Version_Number => 1.0

Line 1045: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

1041: ---------------------- check claim access ------------------------
1042: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN
1043: FOR j IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP
1044: IF p_claim_line_tbl.EXISTS(j) THEN
1045: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
1046: P_Api_Version_Number => 1.0
1047: , P_Init_Msg_List => FND_API.G_FALSE
1048: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1049: , P_Commit => FND_API.G_FALSE

Line 1193: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

1189: , x_return_status => l_return_status
1190: , x_msg_data => x_msg_data
1191: , x_msg_count => x_msg_count
1192: , p_claim_line_rec => l_claim_line_rec
1193: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
1194: , x_claim_line_id => l_claim_line_id
1195: );
1196: IF l_return_status = fnd_api.g_ret_sts_error THEN
1197: x_error_index := i;

Line 1284: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

1280: ,x_msg_count OUT NOCOPY NUMBER
1281: ,x_msg_data OUT NOCOPY VARCHAR2
1282:
1283: ,p_claim_line_rec IN claim_line_rec_type
1284: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
1285: ,x_claim_line_id OUT NOCOPY NUMBER
1286: )
1287: IS
1288: -- Cursor to get the sequence for claim_line_id

Line 1403: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

1399:
1400: l_claim_line_rec := p_claim_line_rec;
1401:
1402: ----------------- check claim access -------------------
1403: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
1404: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
1405: P_Api_Version_Number => 1.0
1406: , P_Init_Msg_List => FND_API.G_FALSE
1407: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1404: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

1400: l_claim_line_rec := p_claim_line_rec;
1401:
1402: ----------------- check claim access -------------------
1403: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
1404: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
1405: P_Api_Version_Number => 1.0
1406: , P_Init_Msg_List => FND_API.G_FALSE
1407: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1408: , P_Commit => FND_API.G_FALSE

Line 1975: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

1971: ,x_msg_count OUT NOCOPY NUMBER
1972:
1973: ,p_claim_line_tbl IN claim_line_tbl_type
1974: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
1975: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
1976: ,x_error_index OUT NOCOPY NUMBER
1977: ) IS
1978: l_api_version CONSTANT NUMBER := 1.0;
1979: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Claim_Line_Tbl';

Line 2041: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN

2037:
2038: x_return_status := FND_API.g_ret_sts_success;
2039:
2040: ---------------------- check claim access ------------------------
2041: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN
2042: FOR j IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP
2043: IF p_claim_line_tbl.EXISTS(j) THEN
2044: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2045: P_Api_Version_Number => 1.0

Line 2044: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2040: ---------------------- check claim access ------------------------
2041: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN
2042: FOR j IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP
2043: IF p_claim_line_tbl.EXISTS(j) THEN
2044: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2045: P_Api_Version_Number => 1.0
2046: , P_Init_Msg_List => FND_API.G_FALSE
2047: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2048: , P_Commit => FND_API.G_FALSE

Line 2136: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

2132: , x_msg_data => x_msg_data
2133: , x_msg_count => x_msg_count
2134: , p_claim_line_id => l_claim_line_id
2135: , p_object_version => l_object_version
2136: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2137: );
2138: IF l_return_status = fnd_api.g_ret_sts_error THEN
2139: x_error_index := i;
2140: RAISE FND_API.g_exc_error;

Line 2223: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

2219: ,x_msg_data OUT NOCOPY VARCHAR2
2220:
2221: ,p_claim_line_id IN NUMBER
2222: ,p_object_version IN NUMBER
2223: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2224: )
2225: IS
2226: l_api_version CONSTANT NUMBER := 1.0;
2227: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Claim_Line';

Line 2294: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

2290: FETCH csr_claim_id INTO l_claim_id;
2291: CLOSE csr_claim_id;
2292:
2293: ---------------------- check claim access ------------------------
2294: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
2295: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2296: P_Api_Version_Number => 1.0
2297: , P_Init_Msg_List => FND_API.G_FALSE
2298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2295: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2291: CLOSE csr_claim_id;
2292:
2293: ---------------------- check claim access ------------------------
2294: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
2295: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2296: P_Api_Version_Number => 1.0
2297: , P_Init_Msg_List => FND_API.G_FALSE
2298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2299: , P_Commit => FND_API.G_FALSE

Line 2361: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

2357: ,x_return_status => l_return_status
2358: ,x_msg_data => x_msg_data
2359: ,x_msg_count => x_msg_count
2360: ,p_line_util_tbl => l_line_util_tbl
2361: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2362: ,x_error_index => l_error_index
2363: );
2364: IF l_return_status = fnd_api.g_ret_sts_error THEN
2365: RAISE FND_API.g_exc_error;

Line 2716: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

2712: ,x_msg_count OUT NOCOPY NUMBER
2713:
2714: ,p_claim_line_tbl IN claim_line_tbl_type
2715: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
2716: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2717:
2718: ,x_error_index OUT NOCOPY NUMBER
2719: ) IS
2720: l_api_version CONSTANT NUMBER := 1.0;

Line 2794: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN

2790:
2791: l_claim_line_tbl := p_claim_line_tbl;
2792:
2793: ---------------------- check claim access ------------------------
2794: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN
2795: FOR j IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP
2796: IF p_claim_line_tbl.EXISTS(j) THEN
2797: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2798: P_Api_Version_Number => 1.0

Line 2797: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2793: ---------------------- check claim access ------------------------
2794: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_claim_line_tbl.count > 0 THEN
2795: FOR j IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP
2796: IF p_claim_line_tbl.EXISTS(j) THEN
2797: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2798: P_Api_Version_Number => 1.0
2799: , P_Init_Msg_List => FND_API.G_FALSE
2800: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2801: , P_Commit => FND_API.G_FALSE

Line 2914: IF p_mode <> OZF_CLAIM_UTILITY_PVT.g_request_mode OR

2910: RAISE FND_API.g_exc_error;
2911: END IF;
2912: END IF;
2913: -- Skip this check if the Claim line is updated from Request.
2914: IF p_mode <> OZF_CLAIM_UTILITY_PVT.g_request_mode OR
2915: l_claim_class <> 'GROUP' THEN
2916: IF ABS(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) > ABS(l_claim_amount) THEN
2917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2918: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');

Line 2949: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

2945: , x_return_status => l_return_status
2946: , x_msg_data => x_msg_data
2947: , x_msg_count => x_msg_count
2948: , p_claim_line_rec => l_claim_line_rec
2949: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2950: , x_object_version => l_object_version
2951: );
2952: IF l_return_status = fnd_api.g_ret_sts_error THEN
2953: x_error_index := i;

Line 3040: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

3036: ,x_msg_count OUT NOCOPY NUMBER
3037: ,x_msg_data OUT NOCOPY VARCHAR2
3038:
3039: ,p_claim_line_rec IN claim_line_rec_type
3040: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3041:
3042: ,x_object_version OUT NOCOPY NUMBER
3043: )
3044: IS

Line 3160: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

3156:
3157: x_return_status := FND_API.g_ret_sts_success;
3158:
3159: ---------------------- check claim access ------------------------
3160: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
3161: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3162: P_Api_Version_Number => 1.0
3163: , P_Init_Msg_List => FND_API.G_FALSE
3164: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3161: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

3157: x_return_status := FND_API.g_ret_sts_success;
3158:
3159: ---------------------- check claim access ------------------------
3160: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
3161: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3162: P_Api_Version_Number => 1.0
3163: , P_Init_Msg_List => FND_API.G_FALSE
3164: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3165: , P_Commit => FND_API.G_FALSE

Line 3453: IF p_mode <> OZF_claim_Utility_pvt.G_AUTO_MODE

3449: -- Changed by : (Uday Poluri) Date: 03-Jun-2003
3450: -- Comments : Add p_mode check, If it is AUTO then allow amount change on claim.
3451: -- PLEASE check with Michelle about this
3452: -- -------------------------------------------------------------------------------------------
3453: IF p_mode <> OZF_claim_Utility_pvt.G_AUTO_MODE
3454: AND p_mode <> OZF_claim_Utility_pvt.G_REQUEST_MODE
3455: AND l_claim_class <> 'GROUP'
3456: THEN --Bug:2781186
3457: -- comparison of claim amount and line amount

Line 3454: AND p_mode <> OZF_claim_Utility_pvt.G_REQUEST_MODE

3450: -- Comments : Add p_mode check, If it is AUTO then allow amount change on claim.
3451: -- PLEASE check with Michelle about this
3452: -- -------------------------------------------------------------------------------------------
3453: IF p_mode <> OZF_claim_Utility_pvt.G_AUTO_MODE
3454: AND p_mode <> OZF_claim_Utility_pvt.G_REQUEST_MODE
3455: AND l_claim_class <> 'GROUP'
3456: THEN --Bug:2781186
3457: -- comparison of claim amount and line amount
3458: IF l_line_sum_amt IS NOT NULL THEN

Line 3501: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

3497: ,x_return_status => l_return_status
3498: ,x_msg_data => x_msg_data
3499: ,x_msg_count => x_msg_count
3500: ,p_line_util_tbl => l_line_util_tbl
3501: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
3502: ,x_error_index => l_error_index
3503: );
3504: IF l_return_status = fnd_api.g_ret_sts_error THEN
3505: RAISE FND_API.g_exc_error;

Line 5305: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

5301: , x_return_status => x_return_status
5302: , x_msg_data => x_msg_data
5303: , x_msg_count => x_msg_count
5304: , p_claim_line_rec => l_claim_line_rec
5305: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
5306: , x_claim_line_id => l_claim_line_id
5307: );
5308: IF x_return_status = fnd_api.g_ret_sts_error THEN
5309: RAISE FND_API.g_exc_error;