DBA Data[Home] [Help]

APPS.OKS_MASS_UPD_PVT dependencies on OKC_API

Line 607: x_return_status := OKC_API.G_RET_STS_SUCCESS;

603: 'Entered mass_update_price_prc');
604: END IF;
605:
606: err_mu_price_tbl.DELETE;
607: x_return_status := OKC_API.G_RET_STS_SUCCESS;
608:
609: l_mu_price_tbl := p_mass_update_price_tbl;
610:
611: /*Fetch Org context details for the contract*/

Line 1324: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

1320: err_mu_status_tbl err_mu_status;
1321:
1322: l_success_count NUMBER;
1323: BEGIN
1324: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
1325:
1326: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1328: G_MODULE || l_api_name,

Line 1538: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1534:
1535: END;
1536:
1537: PROCEDURE validate_date(p_api_version IN NUMBER,
1538: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1539: p_hdr_id IN NUMBER,
1540: p_top_line_id IN NUMBER,
1541: p_sub_line_id IN NUMBER,
1542: x_return_status OUT NOCOPY VARCHAR2,

Line 1591: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1587: L_GET_TOP_LINE_DATES_REC L_GET_TOP_LINE_DATES_CSR%ROWTYPE;
1588:
1589: BEGIN
1590: x_flag := TRUE;
1591: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1592: -- Start of if for Header to Top line validation.
1593:
1594: If (p_hdr_id is not null and p_hdr_id > 0) and
1595: (p_top_line_id is not null and p_top_line_id > 0) and

Line 1676: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1672:
1673: EXCEPTION
1674: WHEN OTHERS THEN
1675:
1676: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1677: OKC_API.set_message('OKS',
1678: 'OKC_CONTRACTS_UNEXP_ERROR',
1679: 'SQLcode',
1680: SQLCODE,

Line 1677: OKC_API.set_message('OKS',

1673: EXCEPTION
1674: WHEN OTHERS THEN
1675:
1676: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1677: OKC_API.set_message('OKS',
1678: 'OKC_CONTRACTS_UNEXP_ERROR',
1679: 'SQLcode',
1680: SQLCODE,
1681: 'SQLerrm',

Line 1991: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1987: l_msg_data => x_msg_data);
1988: l_err_eff_idx := l_err_eff_idx +1;
1989: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number ;
1990: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
1991: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994:
1995: -- Bug 5227077 --

Line 2011: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2007: x_overall_status := l_return_status;
2008: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2009: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Validate_Date, Raised G_EXCEPTION_UNEXPECTED_ERROR';
2010: l_err_eff_idx := l_err_eff_idx +1;
2011: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: Else
2013: if L_FLAG <> true then
2014: fnd_msg_pub.initialize;
2015:

Line 2016: OKC_API.SET_MESSAGE(p_app_name => 'OKS', --G_APP_NAME_OKS,

2012: Else
2013: if L_FLAG <> true then
2014: fnd_msg_pub.initialize;
2015:
2016: OKC_API.SET_MESSAGE(p_app_name => 'OKS', --G_APP_NAME_OKS,
2017: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
2018: p_token1 => 'Line No ',
2019: p_token1_value => l_line_number);
2020:

Line 2030: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2026: l_msg_data := NULL;
2027: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2028: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Validate_Date L_FLAG is False, Raised G_EXCEPTION_UNEXPECTED_ERROR';
2029: l_err_eff_idx := l_err_eff_idx +1;
2030: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2031: End If;
2032: End If; */
2033:
2034: End If; --oks_extwar_util_pvt.check_already_billed

Line 2151: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2147: l_msg_data => x_msg_data);
2148: l_err_eff_idx := l_err_eff_idx +1;
2149: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number ;
2150: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2151: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: END IF;
2153: -- Bug 5227077 --
2154: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2155: FOR a in 1 .. fnd_msg_pub.count_msg Loop

Line 2169: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2165: x_overall_status := l_return_status;
2166: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2167: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Validate_date not success, Raised G_EXCEPTION_UNEXPECTED_ERROR';
2168: l_err_eff_idx := l_err_eff_idx +1;
2169: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2170: Else
2171: if L_FLAG <> true then
2172: fnd_msg_pub.initialize;
2173:

Line 2174: OKC_API.SET_MESSAGE(p_app_name => 'OKS', --G_APP_NAME_OKS,

2170: Else
2171: if L_FLAG <> true then
2172: fnd_msg_pub.initialize;
2173:
2174: OKC_API.SET_MESSAGE(p_app_name => 'OKS', --G_APP_NAME_OKS,
2175: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
2176: p_token1 => 'Line No ',
2177: p_token1_value => l_line_number);
2178:

Line 2188: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2184: l_msg_data := NULL;
2185: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_mass_update_effectivity_tbl(i).line_number;
2186: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Validate_date l_flag is FALSE, Raised G_EXCEPTION_UNEXPECTED_ERROR';
2187: l_err_eff_idx := l_err_eff_idx +1;
2188: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2189: End If;
2190: End If; */
2191:
2192: End If;

Line 2229: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2225: l_msg_data => x_msg_data);
2226: l_err_eff_idx := l_err_eff_idx +1;
2227: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_kl_out(j).line_number ;
2228: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2229: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: END IF;
2231:
2232: /* IF (l_return_status <> 'S') THEN
2233: FOR a in 1 .. fnd_msg_pub.count_msg Loop

Line 2289: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2285: l_msg_data => x_msg_data);
2286: l_err_eff_idx := l_err_eff_idx +1;
2287: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_kl_out(j).line_number ;
2288: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2289: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2290: END IF;
2291:
2292: /* If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2293:

Line 2292: /* If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

2288: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2289: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2290: END IF;
2291:
2292: /* If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2293:
2294: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2295: fnd_msg_pub.get(p_msg_index => a,
2296: p_encoded => 'F',

Line 2353: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2349: l_msg_data => x_msg_data);
2350: l_err_eff_idx := l_err_eff_idx +1;
2351: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_kl_out(j).line_number ;
2352: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2353: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2354: END IF;
2355:
2356: END IF;
2357:

Line 2383: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2379: l_msg_data => x_msg_data);
2380: l_err_eff_idx := l_err_eff_idx +1;
2381: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_kl_out(j).line_number ;
2382: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2383: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: END IF;
2385:
2386: End If;
2387: end if; --L_RETURN_STATUS = 'S'

Line 2437: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2433: l_msg_data => x_msg_data);
2434: l_err_eff_idx := l_err_eff_idx +1;
2435: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_sl_out(k).line_number ; --Modified for Bug#14335289
2436: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2437: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: END IF;
2439:
2440: /*if (L_RETURN_STATUS <> 'S') then
2441: l_tot_msg_count := 0;

Line 2491: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2487: l_msg_data => x_msg_data);
2488: l_err_eff_idx := l_err_eff_idx +1;
2489: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_sl_out(k).line_number ; --Modified for Bug#14335289
2490: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2491: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: END IF;
2493:
2494: END IF; --l_clev_tbl_sl_in(k).lse_id
2495: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling OKS_BILL_SCH.Cascade_Dates_SLL');

Line 2510: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2506: l_msg_data => x_msg_data);
2507: l_err_eff_idx := l_err_eff_idx +1;
2508: l_err_mu_eff_tbl(l_err_eff_idx).line_number := l_clev_tbl_sl_out(k).line_number ; --Modified for Bug#14335289
2509: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2510: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2511: END IF;
2512:
2513: /*If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2514:

Line 2513: /*If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

2509: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := x_msg_data ;
2510: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2511: END IF;
2512:
2513: /*If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2514:
2515: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2516: fnd_msg_pub.get(p_msg_index => a,
2517: p_encoded => 'F',

Line 2526: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2522: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2523: l_tot_msg_count := l_tot_msg_count + 1;
2524: l_msg_data := NULL;
2525: End Loop;
2526: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2527:
2528: End If;*/
2529: l_no_of_prcd_sln := l_no_of_prcd_sln +1 ;
2530: END IF; --l_clev_tbl_sl_in(k).exception_yn NOT IN ('E')