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.OKL_AM_UTIL_PVT dependencies on OKC_API

Line 1136: okc_api.end_activity (

1132: x_rulv_rec => x_rulv_rec,
1133: x_return_status => x_return_status,
1134: p_message_yn => p_message_yn);
1135:
1136: okc_api.end_activity (
1137: x_msg_count => x_msg_count,
1138: x_msg_data => x_msg_data);
1139:
1140: EXCEPTION

Line 1247: OKC_API.SET_MESSAGE (

1243: ,l_bto_values_rec.object1_id1
1244: ,l_bto_values_rec.object1_id2);
1245: -- Billing information is not found for party PARTY having role PARTY_ROLE.
1246: -- Set the message
1247: OKC_API.SET_MESSAGE (
1248: p_app_name => G_APP_NAME,
1249: p_msg_name => 'OKL_AM_NO_BILLING_INFO_NEW',
1250: p_token1 => 'PARTY',
1251: p_token1_value => l_party_name,

Line 1981: l_return_status := OKC_API.G_RET_STS_ERROR;

1977: p_msg_name => 'OKL_AM_MISSING_PTM_CODE',
1978: p_token1 => 'PTM_CODE',
1979: p_token1_value => get_lookup_meaning(p_lookup_type => 'OKL_PROCESSES',
1980: p_lookup_code => p_ptm_code));
1981: l_return_status := OKC_API.G_RET_STS_ERROR;
1982:
1983: END IF;
1984: CLOSE c_content_csr;
1985:

Line 2001: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1997: ,p_token1_value => sqlcode
1998: ,p_token2 => G_SQLERRM_TOKEN
1999: ,p_token2_value => sqlerrm);
2000:
2001: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2002:
2003: END get_content_id;
2004:
2005: ------------------------------------------------------------------------------

Line 2093: l_return_status := OKC_API.G_RET_STS_ERROR;

2089: p_msg_name => 'OKL_AM_FM_AGENT',
2090: p_token1 => 'USERNAME',
2091: p_token1_value => l_user_name);
2092:
2093: l_return_status := OKC_API.G_RET_STS_ERROR;
2094: END IF;
2095: END IF;
2096:
2097: IF l_server_id IS NULL THEN

Line 2110: l_return_status := OKC_API.G_RET_STS_ERROR;

2106:
2107: OKL_API.set_message( p_app_name => 'OKL',
2108: p_msg_name => 'OKL_AM_FM_SERVER_NOT_FOUND');
2109:
2110: l_return_status := OKC_API.G_RET_STS_ERROR;
2111:
2112: ELSE
2113:
2114: OPEN c_server_csr(p_agent_id, l_server_id);

Line 2138: l_return_status := OKC_API.G_RET_STS_ERROR;

2134: p_token1_value => l_user_name,
2135: p_token2 => 'SERVER_NAME',
2136: p_token2_value => l_server_name);
2137:
2138: l_return_status := OKC_API.G_RET_STS_ERROR;
2139: END IF;
2140: END IF;
2141:
2142: x_return_status := l_return_status;

Line 2159: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2155: ,p_token1_value => sqlcode
2156: ,p_token2 => G_SQLERRM_TOKEN
2157: ,p_token2_value => sqlerrm);
2158:
2159: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2160:
2161: END get_agent_details;
2162:
2163: ------------------------------------------------------------------------------

Line 2255: l_return_status := OKC_API.G_RET_STS_ERROR;

2251: p_token1_value => p_recipient_type,
2252: p_token2 => 'PARTY_ID',
2253: p_token2_value => p_recipient_id);
2254:
2255: l_return_status := OKC_API.G_RET_STS_ERROR;
2256: END IF;
2257:
2258: j := l_email_tbl.FIRST;
2259:

Line 2280: l_return_status := OKC_API.G_RET_STS_ERROR;

2276: p_token1_value => p_recipient_type,
2277: p_token2 => 'PARTY_ID',
2278: p_token2_value => p_recipient_id);
2279:
2280: l_return_status := OKC_API.G_RET_STS_ERROR;
2281: END IF;
2282:
2283: x_return_status := l_return_status;
2284:

Line 2297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2293: ,p_token1_value => sqlcode
2294: ,p_token2 => G_SQLERRM_TOKEN
2295: ,p_token2_value => sqlerrm);
2296:
2297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2298:
2299: END get_recipient_details;
2300:
2301: ------------------------------------------------------------------------------

Line 2335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2331: l_api_version CONSTANT NUMBER := G_API_VERSION;
2332: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
2333: l_msg_data VARCHAR2(8000);
2334:
2335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2336: l_agent_id NUMBER;
2337: l_content_id NUMBER;
2338: l_default_subject VARCHAR2(2000);
2339: l_default_sender VARCHAR2(2000);

Line 2378: OKC_API.SET_MESSAGE (

2374: END IF;
2375:
2376: -- Check all mandatory parameters have been passed
2377: IF p_ptm_code IS NULL OR p_ptm_code = OKL_API.G_MISS_CHAR THEN
2378: OKC_API.SET_MESSAGE (
2379: p_app_name => 'OKC'
2380: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2381: ,p_token1 => G_COL_NAME_TOKEN
2382: ,p_token1_value => 'P_PTM_CODE');

Line 2380: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2376: -- Check all mandatory parameters have been passed
2377: IF p_ptm_code IS NULL OR p_ptm_code = OKL_API.G_MISS_CHAR THEN
2378: OKC_API.SET_MESSAGE (
2379: p_app_name => 'OKC'
2380: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2381: ,p_token1 => G_COL_NAME_TOKEN
2382: ,p_token1_value => 'P_PTM_CODE');
2383:
2384: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2390: OKC_API.SET_MESSAGE (

2386: g_ptm_code := p_ptm_code;
2387: END IF;
2388:
2389: IF p_agent_id IS NULL OR p_agent_id = OKL_API.G_MISS_NUM THEN
2390: OKC_API.SET_MESSAGE (
2391: p_app_name => 'OKC'
2392: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2393: ,p_token1 => G_COL_NAME_TOKEN
2394: ,p_token1_value => 'P_AGENT_ID');

Line 2392: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2388:
2389: IF p_agent_id IS NULL OR p_agent_id = OKL_API.G_MISS_NUM THEN
2390: OKC_API.SET_MESSAGE (
2391: p_app_name => 'OKC'
2392: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2393: ,p_token1 => G_COL_NAME_TOKEN
2394: ,p_token1_value => 'P_AGENT_ID');
2395:
2396: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2406: OKC_API.SET_MESSAGE (

2402:
2403: IF p_recipient_email IS NULL OR p_recipient_email = OKL_API.G_MISS_CHAR THEN
2404:
2405: IF p_recipient_type IS NULL OR p_recipient_type = OKL_API.G_MISS_CHAR THEN
2406: OKC_API.SET_MESSAGE (
2407: p_app_name => 'OKC'
2408: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2409: ,p_token1 => G_COL_NAME_TOKEN
2410: ,p_token1_value => 'P_RECIPIENT_TYPE');

Line 2408: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2404:
2405: IF p_recipient_type IS NULL OR p_recipient_type = OKL_API.G_MISS_CHAR THEN
2406: OKC_API.SET_MESSAGE (
2407: p_app_name => 'OKC'
2408: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2409: ,p_token1 => G_COL_NAME_TOKEN
2410: ,p_token1_value => 'P_RECIPIENT_TYPE');
2411:
2412: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2416: OKC_API.SET_MESSAGE (

2412: l_return_status := OKL_API.G_RET_STS_ERROR;
2413: END IF;
2414:
2415: IF p_recipient_id IS NULL OR p_recipient_id = OKL_API.G_MISS_CHAR THEN
2416: OKC_API.SET_MESSAGE (
2417: p_app_name => 'OKC'
2418: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2419: ,p_token1 => G_COL_NAME_TOKEN
2420: ,p_token1_value => 'P_RECIPIENT_ID');

Line 2418: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2414:
2415: IF p_recipient_id IS NULL OR p_recipient_id = OKL_API.G_MISS_CHAR THEN
2416: OKC_API.SET_MESSAGE (
2417: p_app_name => 'OKC'
2418: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2419: ,p_token1 => G_COL_NAME_TOKEN
2420: ,p_token1_value => 'P_RECIPIENT_ID');
2421:
2422: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2430: OKC_API.SET_MESSAGE (

2426:
2427: IF p_pt_bind_names.COUNT > 0 THEN
2428:
2429: IF p_pt_bind_names(p_pt_bind_names.FIRST) IS NULL OR p_pt_bind_names(p_pt_bind_names.FIRST)= OKL_API.G_MISS_CHAR THEN
2430: OKC_API.SET_MESSAGE (
2431: p_app_name => 'OKC'
2432: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2433: ,p_token1 => G_COL_NAME_TOKEN
2434: ,p_token1_value => 'P_PT_BIND_NAMES');

Line 2432: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2428:
2429: IF p_pt_bind_names(p_pt_bind_names.FIRST) IS NULL OR p_pt_bind_names(p_pt_bind_names.FIRST)= OKL_API.G_MISS_CHAR THEN
2430: OKC_API.SET_MESSAGE (
2431: p_app_name => 'OKC'
2432: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2433: ,p_token1 => G_COL_NAME_TOKEN
2434: ,p_token1_value => 'P_PT_BIND_NAMES');
2435:
2436: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2440: OKC_API.SET_MESSAGE (

2436: l_return_status := OKL_API.G_RET_STS_ERROR;
2437: END IF;
2438: ELSE
2439:
2440: OKC_API.SET_MESSAGE (
2441: p_app_name => 'OKC'
2442: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2443: ,p_token1 => G_COL_NAME_TOKEN
2444: ,p_token1_value => 'P_TRANSACTION_ID');

Line 2442: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2438: ELSE
2439:
2440: OKC_API.SET_MESSAGE (
2441: p_app_name => 'OKC'
2442: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2443: ,p_token1 => G_COL_NAME_TOKEN
2444: ,p_token1_value => 'P_TRANSACTION_ID');
2445:
2446: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2450: OKC_API.SET_MESSAGE (

2446: l_return_status := OKL_API.G_RET_STS_ERROR;
2447: END IF;
2448:
2449: IF p_recipient_email IS NULL OR p_recipient_email = OKL_API.G_MISS_CHAR THEN
2450: OKC_API.SET_MESSAGE (
2451: p_app_name => 'OKC'
2452: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2453: ,p_token1 => G_COL_NAME_TOKEN
2454: ,p_token1_value => 'P_RECIPIENT_EMAIL');

Line 2452: ,p_msg_name => OKC_API.G_REQUIRED_VALUE

2448:
2449: IF p_recipient_email IS NULL OR p_recipient_email = OKL_API.G_MISS_CHAR THEN
2450: OKC_API.SET_MESSAGE (
2451: p_app_name => 'OKC'
2452: ,p_msg_name => OKC_API.G_REQUIRED_VALUE
2453: ,p_token1 => G_COL_NAME_TOKEN
2454: ,p_token1_value => 'P_RECIPIENT_EMAIL');
2455:
2456: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 2680: cursor av_csr is select table_name,Column_Name ,data_type,data_length,NVL(data_precision,OKC_API.G_MISS_NUM)

2676: ----------------------------------------------------------------------------
2677: Procedure add_view(
2678: p_view_name IN VARCHAR2,
2679: x_return_status OUT NOCOPY VARCHAR2) IS
2680: cursor av_csr is select table_name,Column_Name ,data_type,data_length,NVL(data_precision,OKC_API.G_MISS_NUM)
2681: data_precision,NVL(data_scale,0) data_scale
2682: FROM user_tab_columns
2683: WHERE table_name = UPPER( p_view_name) and (data_type='VARCHAR2' OR data_type='NUMBER');
2684: var1 av_csr%rowtype;

Line 2688: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

2684: var1 av_csr%rowtype;
2685: i number:=1;
2686: found Boolean:=FALSE;
2687: Begin
2688: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2689: i:=G_lenchk_tbl.First;
2690: If G_lenchk_tbl.Count>0 Then
2691: Loop
2692: if (UPPER(p_view_name)=UPPER(G_lenchk_tbl(i).vname)) Then

Line 2718: x_return_status:=OKC_API.G_RET_STS_ERROR;

2714: G_lenchk_tbl(i).clength:=var1.data_length;
2715: end if;
2716: END LOOP;
2717: If av_csr%ROWCOUNT<1 Then
2718: x_return_status:=OKC_API.G_RET_STS_ERROR;
2719: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2720: p_msg_name => G_NOTFOUND,
2721: p_token1 => G_VIEW_TOKEN,
2722: p_token1_value => UPPER(p_view_name));

Line 2719: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,

2715: end if;
2716: END LOOP;
2717: If av_csr%ROWCOUNT<1 Then
2718: x_return_status:=OKC_API.G_RET_STS_ERROR;
2719: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2720: p_msg_name => G_NOTFOUND,
2721: p_token1 => G_VIEW_TOKEN,
2722: p_token1_value => UPPER(p_view_name));
2723:

Line 2731: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;

2727: End If;
2728:
2729: Exception
2730: when others then
2731: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;
2732: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2733: p_msg_name => G_UNEXPECTED_ERROR,
2734: p_token1 => G_SQLCODE_TOKEN,
2735: p_token1_value => sqlcode,

Line 2732: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

2728:
2729: Exception
2730: when others then
2731: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;
2732: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2733: p_msg_name => G_UNEXPECTED_ERROR,
2734: p_token1 => G_SQLCODE_TOKEN,
2735: p_token1_value => sqlcode,
2736: p_token2 => G_SQLERRM_TOKEN,

Line 2765: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;

2761: -- get the character specified for decimal right now in the database
2762: open c1;
2763: fetch c1 into l_val;
2764: close c1;
2765: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;
2766: l_value:=NVL(p_col_value,0);
2767: IF (G_lenchk_tbl(i).clength=OKC_API.G_MISS_NUM) Then
2768: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2769: ELSE

Line 2767: IF (G_lenchk_tbl(i).clength=OKC_API.G_MISS_NUM) Then

2763: fetch c1 into l_val;
2764: close c1;
2765: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;
2766: l_value:=NVL(p_col_value,0);
2767: IF (G_lenchk_tbl(i).clength=OKC_API.G_MISS_NUM) Then
2768: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2769: ELSE
2770: l_pre:=G_lenchk_tbl(i).clength-ABS(G_lenchk_tbl(i).cscale);
2771: for j in 1..l_pre loop

Line 2768: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

2764: close c1;
2765: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;
2766: l_value:=NVL(p_col_value,0);
2767: IF (G_lenchk_tbl(i).clength=OKC_API.G_MISS_NUM) Then
2768: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2769: ELSE
2770: l_pre:=G_lenchk_tbl(i).clength-ABS(G_lenchk_tbl(i).cscale);
2771: for j in 1..l_pre loop
2772: l_str_pos:=l_str_pos||'9';

Line 2789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

2785: end if;
2786: l_pos:=to_number(l_str_pos);
2787: l_neg:=(-1)*l_pos;
2788: if l_value<=l_pos and l_value>=l_neg then
2789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2790: else
2791: x_return_status:=OKC_API.G_RET_STS_ERROR;
2792: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2793: p_msg_name => G_LEN_CHK,

Line 2791: x_return_status:=OKC_API.G_RET_STS_ERROR;

2787: l_neg:=(-1)*l_pos;
2788: if l_value<=l_pos and l_value>=l_neg then
2789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2790: else
2791: x_return_status:=OKC_API.G_RET_STS_ERROR;
2792: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2793: p_msg_name => G_LEN_CHK,
2794: p_token1 => G_COL_NAME_TOKEN,
2795: p_token1_value => p_col_name,

Line 2792: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,

2788: if l_value<=l_pos and l_value>=l_neg then
2789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2790: else
2791: x_return_status:=OKC_API.G_RET_STS_ERROR;
2792: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2793: p_msg_name => G_LEN_CHK,
2794: p_token1 => G_COL_NAME_TOKEN,
2795: p_token1_value => p_col_name,
2796: p_token2 => 'COL_LEN',

Line 2802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2798: end if;
2799: End If;
2800: EXCEPTION
2801: when others then
2802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2803: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2804: p_msg_name => G_UNEXPECTED_ERROR,
2805: p_token1 => G_SQLCODE_TOKEN,
2806: p_token1_value => sqlcode,

Line 2803: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

2799: End If;
2800: EXCEPTION
2801: when others then
2802: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2803: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2804: p_msg_name => G_UNEXPECTED_ERROR,
2805: p_token1 => G_SQLCODE_TOKEN,
2806: p_token1_value => sqlcode,
2807: p_token2 => G_SQLERRM_TOKEN,

Line 2828: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;

2824: x_return_status OUT NOCOPY VARCHAR2) IS
2825: i number:=0;
2826: col_len number:=0;
2827: Begin
2828: x_return_status:=OKC_API.G_RET_STS_UNEXP_ERROR;
2829: i:=G_lenchk_tbl.First;
2830: Loop
2831: if ((UPPER(p_view_name)=UPPER(G_lenchk_tbl(i).vname)) and
2832: (UPPER(p_col_name)=UPPER(G_lenchk_tbl(i).cname)) ) Then

Line 2836: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

2832: (UPPER(p_col_name)=UPPER(G_lenchk_tbl(i).cname)) ) Then
2833: If (UPPER(G_lenchk_tbl(i).cdtype)='VARCHAR2') Then
2834: col_len:=nvl(length(p_col_value),0);
2835: if col_len<=TRUNC((G_lenchk_tbl(i).CLength)/3) then
2836: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2837: else
2838: x_return_status:= OKC_API.G_RET_STS_ERROR;
2839: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2840: p_msg_name => G_LEN_CHK,

Line 2838: x_return_status:= OKC_API.G_RET_STS_ERROR;

2834: col_len:=nvl(length(p_col_value),0);
2835: if col_len<=TRUNC((G_lenchk_tbl(i).CLength)/3) then
2836: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2837: else
2838: x_return_status:= OKC_API.G_RET_STS_ERROR;
2839: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2840: p_msg_name => G_LEN_CHK,
2841: p_token1 => G_COL_NAME_TOKEN,
2842: p_token1_value => p_col_name,

Line 2839: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,

2835: if col_len<=TRUNC((G_lenchk_tbl(i).CLength)/3) then
2836: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
2837: else
2838: x_return_status:= OKC_API.G_RET_STS_ERROR;
2839: OKC_API.SET_MESSAGE(p_app_name => G_APP2_NAME,
2840: p_msg_name => G_LEN_CHK,
2841: p_token1 => G_COL_NAME_TOKEN,
2842: p_token1_value => p_col_name,
2843: p_token2 => 'COL_LEN',

Line 2858: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2854: End Loop;
2855:
2856: EXCEPTION
2857: when others then
2858: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2859:
2860: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2861: p_msg_name => G_UNEXPECTED_ERROR,
2862: p_token1 => G_SQLCODE_TOKEN,

Line 2860: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

2856: EXCEPTION
2857: when others then
2858: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2859:
2860: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2861: p_msg_name => G_UNEXPECTED_ERROR,
2862: p_token1 => G_SQLCODE_TOKEN,
2863: p_token1_value => sqlcode,
2864: p_token2 => G_SQLERRM_TOKEN,

Line 3527: OKC_API.set_message(p_app_name => 'OKC',

3523:
3524: EXCEPTION
3525: WHEN OTHERS THEN
3526: -- unexpected error
3527: OKC_API.set_message(p_app_name => 'OKC',
3528: p_msg_name => 'OKC_CONTRACTS_UNEXPECTED_ERROR',
3529: p_token1 => g_sqlcode_token,
3530: p_token1_value => sqlcode,
3531: p_token2 => g_sqlerrm_token,

Line 3558: OKC_API.set_message(p_app_name => 'OKC',

3554:
3555: EXCEPTION
3556: WHEN OTHERS THEN
3557: -- unexpected error
3558: OKC_API.set_message(p_app_name => 'OKC',
3559: p_msg_name => 'OKC_CONTRACTS_UNEXPECTED_ERROR',
3560: p_token1 => g_sqlcode_token,
3561: p_token1_value => sqlcode,
3562: p_token2 => g_sqlerrm_token,

Line 3842: OKC_API.set_message( p_app_name => 'OKC',

3838:
3839: OPEN l_oklheaders_csr(p_khr_id);
3840: FETCH l_oklheaders_csr INTO l_sts_code, l_deal_type; -- SECHAWLA 09-AUG-05 4304230 : added sts_code
3841: IF l_oklheaders_csr%NOTFOUND THEN
3842: OKC_API.set_message( p_app_name => 'OKC',
3843: p_msg_name => G_INVALID_VALUE,
3844: p_token1 => G_COL_NAME_TOKEN,
3845: p_token1_value => 'KHR_ID');
3846: x_return_status := OKL_API.G_RET_STS_ERROR;