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

Line 719: okc_api.set_message (p_app_name => g_app_name,

715: END IF;
716:
717: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
718: x_return_status := g_ret_sts_unexp_error;
719: okc_api.set_message (p_app_name => g_app_name,
720: p_msg_name => g_unexpected_error,
721: p_token1 => g_sqlcode_token,
722: p_token1_value => SQLCODE,
723: p_token2 => g_sqlerrm_token,

Line 938: x_return_status := okc_api.g_ret_sts_warning;

934: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
935:
936: CLOSE l_line_csr;
937:
938: x_return_status := okc_api.g_ret_sts_warning;
939: END;
940:
941: FUNCTION is_subs_item (
942: p_subline_id NUMBER

Line 1260: okc_api.set_message (p_app_name => g_app_name,

1256: END IF;
1257:
1258: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1259: x_return_status := g_ret_sts_unexp_error;
1260: okc_api.set_message (p_app_name => g_app_name,
1261: p_msg_name => g_unexpected_error,
1262: p_token1 => g_sqlcode_token,
1263: p_token1_value => SQLCODE,
1264: p_token2 => g_sqlerrm_token,

Line 1419: x_return_status := okc_api.g_ret_sts_success;

1415: l_api_name
1416: );
1417: END IF;
1418:
1419: x_return_status := okc_api.g_ret_sts_success;
1420:
1421: UPDATE oks_qualifiers
1422: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1423: last_update_date = hz_utility_pub.last_update_date,

Line 2596: okc_api.set_message (p_app_name => g_app_name,

2592: END IF;
2593:
2594: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2595: x_return_status := g_ret_sts_unexp_error;
2596: okc_api.set_message (p_app_name => g_app_name,
2597: p_msg_name => g_unexpected_error,
2598: p_token1 => g_sqlcode_token,
2599: p_token1_value => SQLCODE,
2600: p_token2 => g_sqlerrm_token,

Line 2814: okc_api.set_message (p_app_name => g_app_name,

2810: );
2811: END IF;
2812:
2813: --errorout ('Override amount not present in Price Negotiated column');
2814: okc_api.set_message (p_app_name => g_app_name,
2815: p_msg_name => g_required_value,
2816: p_token1 => g_col_name_token,
2817: p_token1_value => 'PRICE_NEGOTIATED'
2818: );

Line 3292: okc_api.set_message (p_app_name => g_app_name,

3288: l_api_name
3289: );
3290: END IF;
3291:
3292: okc_api.set_message (p_app_name => g_app_name,
3293: p_msg_name => g_invalid_value,
3294: p_token1 => g_col_name_token,
3295: p_token1_value => 'Header ID'
3296: );

Line 3314: okc_api.set_message (p_app_name => g_app_name,

3310: END IF;
3311:
3312: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3313: x_return_status := g_ret_sts_unexp_error;
3314: okc_api.set_message (p_app_name => g_app_name,
3315: p_msg_name => g_unexpected_error,
3316: p_token1 => g_sqlcode_token,
3317: p_token1_value => SQLCODE,
3318: p_token2 => g_sqlerrm_token,

Line 3661: l_clev_rec_in.ID := okc_api.g_miss_num;

3657: RAISE g_skip_exception;
3658: END IF;
3659:
3660: -- Clear the record so as to reuse it
3661: l_clev_rec_in.ID := okc_api.g_miss_num;
3662: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3663: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3664: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3665: l_clev_rec_in.price_unit := okc_api.g_miss_num;

Line 3662: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;

3658: END IF;
3659:
3660: -- Clear the record so as to reuse it
3661: l_clev_rec_in.ID := okc_api.g_miss_num;
3662: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3663: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3664: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3665: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3666: -- Get covered line details

Line 3663: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;

3659:
3660: -- Clear the record so as to reuse it
3661: l_clev_rec_in.ID := okc_api.g_miss_num;
3662: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3663: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3664: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3665: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3666: -- Get covered line details
3667: get_line_details (p_line_id => l_input_detail_rec.subline_id,

Line 3664: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;

3660: -- Clear the record so as to reuse it
3661: l_clev_rec_in.ID := okc_api.g_miss_num;
3662: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3663: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3664: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3665: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3666: -- Get covered line details
3667: get_line_details (p_line_id => l_input_detail_rec.subline_id,
3668: x_name => l_clvl_name,

Line 3665: l_clev_rec_in.price_unit := okc_api.g_miss_num;

3661: l_clev_rec_in.ID := okc_api.g_miss_num;
3662: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3663: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3664: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3665: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3666: -- Get covered line details
3667: get_line_details (p_line_id => l_input_detail_rec.subline_id,
3668: x_name => l_clvl_name,
3669: x_description => l_clvl_desc,

Line 3877: okc_api.set_message (p_app_name => g_app_name,

3873: END IF;
3874:
3875: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3876: x_return_status := g_ret_sts_unexp_error;
3877: okc_api.set_message (p_app_name => g_app_name,
3878: p_msg_name => g_unexpected_error,
3879: p_token1 => g_sqlcode_token,
3880: p_token1_value => SQLCODE,
3881: p_token2 => g_sqlerrm_token,

Line 4060: p_restricted_update => okc_api.g_false,

4056: p_init_msg_list => l_init_msg_list,
4057: x_return_status => x_return_status,
4058: x_msg_count => x_msg_count,
4059: x_msg_data => x_msg_data,
4060: p_restricted_update => okc_api.g_false,
4061: p_chrv_rec => l_chrv_rec_in,
4062: x_chrv_rec => l_chrv_rec_out
4063: );
4064:

Line 4116: okc_api.set_message (p_app_name => g_app_name,

4112: END IF;
4113:
4114: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4115: x_return_status := g_ret_sts_unexp_error;
4116: okc_api.set_message (p_app_name => g_app_name,
4117: p_msg_name => g_unexpected_error,
4118: p_token1 => g_sqlcode_token,
4119: p_token1_value => SQLCODE,
4120: p_token2 => g_sqlerrm_token,

Line 4264: okc_api.set_message (p_app_name => g_app_name,

4260: THEN
4261: RAISE g_exc_error;
4262: END IF;
4263: ELSE
4264: okc_api.set_message (p_app_name => g_app_name,
4265: p_msg_name => g_required_value,
4266: p_token1 => g_invalid_value,
4267: p_token1_value => 'CHR_ID'
4268: );

Line 4364: p_restricted_update => okc_api.g_false,

4360: p_init_msg_list => l_init_msg_list,
4361: x_return_status => x_return_status,
4362: x_msg_count => x_msg_count,
4363: x_msg_data => x_msg_data,
4364: p_restricted_update => okc_api.g_false,
4365: p_chrv_rec => l_chrv_rec_in,
4366: x_chrv_rec => l_chrv_rec_out
4367: );
4368:

Line 4384: okc_api.set_message (p_app_name => g_app_name,

4380: );
4381: END IF;
4382:
4383: --errorout ('Top Line id is NULL');
4384: okc_api.set_message (p_app_name => g_app_name,
4385: p_msg_name => g_required_value,
4386: p_token1 => g_invalid_value,
4387: p_token1_value => 'CLE_ID'
4388: );

Line 4503: p_restricted_update => okc_api.g_false,

4499: p_init_msg_list => l_init_msg_list,
4500: x_return_status => x_return_status,
4501: x_msg_count => x_msg_count,
4502: x_msg_data => x_msg_data,
4503: p_restricted_update => okc_api.g_false,
4504: p_chrv_rec => l_chrv_rec_in,
4505: x_chrv_rec => l_chrv_rec_out
4506: );
4507:

Line 4523: okc_api.set_message (p_app_name => g_app_name,

4519: );
4520: END IF;
4521:
4522: --errorout ('Sub line id is NULL');
4523: okc_api.set_message (p_app_name => g_app_name,
4524: p_msg_name => g_required_value,
4525: p_token1 => g_invalid_value,
4526: p_token1_value => 'LINE_ID'
4527: );

Line 4647: p_restricted_update => okc_api.g_false,

4643: p_init_msg_list => l_init_msg_list,
4644: x_return_status => x_return_status,
4645: x_msg_count => x_msg_count,
4646: x_msg_data => x_msg_data,
4647: p_restricted_update => okc_api.g_false,
4648: p_chrv_rec => l_chrv_rec_in,
4649: x_chrv_rec => l_chrv_rec_out
4650: );
4651:

Line 4679: okc_api.set_message (p_app_name => g_app_name,

4675: );
4676: END IF;
4677:
4678: -- errorout ('Line id is NULL');
4679: okc_api.set_message (p_app_name => g_app_name,
4680: p_msg_name => g_required_value,
4681: p_token1 => g_invalid_value,
4682: p_token1_value => 'CLE_ID'
4683: );

Line 4786: p_restricted_update => okc_api.g_false,

4782: p_init_msg_list => l_init_msg_list,
4783: x_return_status => x_return_status,
4784: x_msg_count => x_msg_count,
4785: x_msg_data => x_msg_data,
4786: p_restricted_update => okc_api.g_false,
4787: p_chrv_rec => l_chrv_rec_in,
4788: x_chrv_rec => l_chrv_rec_out
4789: );
4790:

Line 4806: okc_api.set_message (p_app_name => g_app_name,

4802: );
4803: END IF;
4804:
4805: -- errorout ('Sub line id is NULL');
4806: okc_api.set_message (p_app_name => g_app_name,
4807: p_msg_name => g_required_value,
4808: p_token1 => g_invalid_value,
4809: p_token1_value => 'LINE_ID'
4810: );

Line 4825: okc_api.set_message (p_app_name => g_app_name,

4821: );
4822: END IF;
4823:
4824: -- errorout ('********** Invalid Intent ********');
4825: okc_api.set_message (p_app_name => g_app_name,
4826: p_msg_name => g_required_value,
4827: p_token1 => g_invalid_value,
4828: p_token1_value => 'INTENT'
4829: );

Line 4892: okc_api.set_message (p_app_name => g_app_name,

4888:
4889: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4890: DBMS_TRANSACTION.rollback_savepoint ('COMPUTE_PRICE');
4891: x_return_status := g_ret_sts_unexp_error;
4892: okc_api.set_message (p_app_name => g_app_name,
4893: p_msg_name => g_unexpected_error,
4894: p_token1 => g_sqlcode_token,
4895: p_token1_value => SQLCODE,
4896: p_token2 => g_sqlerrm_token,