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 741: okc_api.set_message (p_app_name => g_app_name,

737: END IF;
738:
739: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
740: x_return_status := g_ret_sts_unexp_error;
741: okc_api.set_message (p_app_name => g_app_name,
742: p_msg_name => g_unexpected_error,
743: p_token1 => g_sqlcode_token,
744: p_token1_value => SQLCODE,
745: p_token2 => g_sqlerrm_token,

Line 960: x_return_status := okc_api.g_ret_sts_warning;

956: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
957:
958: CLOSE l_line_csr;
959:
960: x_return_status := okc_api.g_ret_sts_warning;
961: END;
962:
963: FUNCTION is_subs_item (
964: p_subline_id NUMBER

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

1278: END IF;
1279:
1280: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1281: x_return_status := g_ret_sts_unexp_error;
1282: okc_api.set_message (p_app_name => g_app_name,
1283: p_msg_name => g_unexpected_error,
1284: p_token1 => g_sqlcode_token,
1285: p_token1_value => SQLCODE,
1286: p_token2 => g_sqlerrm_token,

Line 1441: x_return_status := okc_api.g_ret_sts_success;

1437: l_api_name
1438: );
1439: END IF;
1440:
1441: x_return_status := okc_api.g_ret_sts_success;
1442:
1443: UPDATE oks_qualifiers
1444: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1445: last_update_date = hz_utility_pub.last_update_date,

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

2628: END IF;
2629:
2630: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2631: x_return_status := g_ret_sts_unexp_error;
2632: okc_api.set_message (p_app_name => g_app_name,
2633: p_msg_name => g_unexpected_error,
2634: p_token1 => g_sqlcode_token,
2635: p_token1_value => SQLCODE,
2636: p_token2 => g_sqlerrm_token,

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

2846: );
2847: END IF;
2848:
2849: --errorout ('Override amount not present in Price Negotiated column');
2850: okc_api.set_message (p_app_name => g_app_name,
2851: p_msg_name => g_required_value,
2852: p_token1 => g_col_name_token,
2853: p_token1_value => 'PRICE_NEGOTIATED'
2854: );

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

3327: l_api_name
3328: );
3329: END IF;
3330:
3331: okc_api.set_message (p_app_name => g_app_name,
3332: p_msg_name => g_invalid_value,
3333: p_token1 => g_col_name_token,
3334: p_token1_value => 'Header ID'
3335: );

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

3349: END IF;
3350:
3351: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3352: x_return_status := g_ret_sts_unexp_error;
3353: okc_api.set_message (p_app_name => g_app_name,
3354: p_msg_name => g_unexpected_error,
3355: p_token1 => g_sqlcode_token,
3356: p_token1_value => SQLCODE,
3357: p_token2 => g_sqlerrm_token,

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

3696: RAISE g_skip_exception;
3697: END IF;
3698:
3699: -- Clear the record so as to reuse it
3700: l_clev_rec_in.ID := okc_api.g_miss_num;
3701: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3702: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3703: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3704: l_clev_rec_in.price_unit := okc_api.g_miss_num;

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

3697: END IF;
3698:
3699: -- Clear the record so as to reuse it
3700: l_clev_rec_in.ID := okc_api.g_miss_num;
3701: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3702: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3703: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3704: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3705: -- Get covered line details

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

3698:
3699: -- Clear the record so as to reuse it
3700: l_clev_rec_in.ID := okc_api.g_miss_num;
3701: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3702: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3703: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3704: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3705: -- Get covered line details
3706: get_line_details (p_line_id => l_input_detail_rec.subline_id,

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

3699: -- Clear the record so as to reuse it
3700: l_clev_rec_in.ID := okc_api.g_miss_num;
3701: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3702: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3703: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3704: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3705: -- Get covered line details
3706: get_line_details (p_line_id => l_input_detail_rec.subline_id,
3707: x_name => l_clvl_name,

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

3700: l_clev_rec_in.ID := okc_api.g_miss_num;
3701: --l_clev_rec_in.chr_id := OKC_API.G_MISS_NUM;
3702: --l_clev_rec_in.cle_id := OKC_API.G_MISS_NUM;
3703: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
3704: l_clev_rec_in.price_unit := okc_api.g_miss_num;
3705: -- Get covered line details
3706: get_line_details (p_line_id => l_input_detail_rec.subline_id,
3707: x_name => l_clvl_name,
3708: x_description => l_clvl_desc,

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

3912: END IF;
3913:
3914: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3915: x_return_status := g_ret_sts_unexp_error;
3916: okc_api.set_message (p_app_name => g_app_name,
3917: p_msg_name => g_unexpected_error,
3918: p_token1 => g_sqlcode_token,
3919: p_token1_value => SQLCODE,
3920: p_token2 => g_sqlerrm_token,

Line 5857: l_clev_rec_in.id := okc_api.g_miss_num;

5853: raise g_skip_exception;
5854: end if;
5855:
5856: -- clear the record so as to reuse it
5857: l_clev_rec_in.id := okc_api.g_miss_num;
5858: --l_clev_rec_in.chr_id := okc_api.g_miss_num;
5859: --l_clev_rec_in.cle_id := okc_api.g_miss_num;
5860: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
5861: l_clev_rec_in.price_unit := okc_api.g_miss_num;

Line 5858: --l_clev_rec_in.chr_id := okc_api.g_miss_num;

5854: end if;
5855:
5856: -- clear the record so as to reuse it
5857: l_clev_rec_in.id := okc_api.g_miss_num;
5858: --l_clev_rec_in.chr_id := okc_api.g_miss_num;
5859: --l_clev_rec_in.cle_id := okc_api.g_miss_num;
5860: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
5861: l_clev_rec_in.price_unit := okc_api.g_miss_num;
5862: -- get covered line details

Line 5859: --l_clev_rec_in.cle_id := okc_api.g_miss_num;

5855:
5856: -- clear the record so as to reuse it
5857: l_clev_rec_in.id := okc_api.g_miss_num;
5858: --l_clev_rec_in.chr_id := okc_api.g_miss_num;
5859: --l_clev_rec_in.cle_id := okc_api.g_miss_num;
5860: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
5861: l_clev_rec_in.price_unit := okc_api.g_miss_num;
5862: -- get covered line details
5863: get_line_details (p_line_id => l_input_detail_rec.subline_id,

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

5856: -- clear the record so as to reuse it
5857: l_clev_rec_in.id := okc_api.g_miss_num;
5858: --l_clev_rec_in.chr_id := okc_api.g_miss_num;
5859: --l_clev_rec_in.cle_id := okc_api.g_miss_num;
5860: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
5861: l_clev_rec_in.price_unit := okc_api.g_miss_num;
5862: -- get covered line details
5863: get_line_details (p_line_id => l_input_detail_rec.subline_id,
5864: x_name => l_clvl_name,

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

5857: l_clev_rec_in.id := okc_api.g_miss_num;
5858: --l_clev_rec_in.chr_id := okc_api.g_miss_num;
5859: --l_clev_rec_in.cle_id := okc_api.g_miss_num;
5860: l_clev_rec_in.price_negotiated := okc_api.g_miss_num;
5861: l_clev_rec_in.price_unit := okc_api.g_miss_num;
5862: -- get covered line details
5863: get_line_details (p_line_id => l_input_detail_rec.subline_id,
5864: x_name => l_clvl_name,
5865: x_description => l_clvl_desc,

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

6076: END IF;
6077:
6078: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6079: x_return_status := g_ret_sts_unexp_error;
6080: okc_api.set_message (p_app_name => g_app_name,
6081: p_msg_name => g_unexpected_error,
6082: p_token1 => g_sqlcode_token,
6083: p_token1_value => sqlcode,
6084: p_token2 => g_sqlerrm_token,

Line 6285: p_restricted_update => okc_api.g_false,

6281: p_init_msg_list => l_init_msg_list,
6282: x_return_status => x_return_status,
6283: x_msg_count => x_msg_count,
6284: x_msg_data => x_msg_data,
6285: p_restricted_update => okc_api.g_false,
6286: p_chrv_rec => l_chrv_rec_in,
6287: x_chrv_rec => l_chrv_rec_out
6288: );
6289:

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

6337: END IF;
6338:
6339: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6340: x_return_status := g_ret_sts_unexp_error;
6341: okc_api.set_message (p_app_name => g_app_name,
6342: p_msg_name => g_unexpected_error,
6343: p_token1 => g_sqlcode_token,
6344: p_token1_value => SQLCODE,
6345: p_token2 => g_sqlerrm_token,

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

6485: THEN
6486: RAISE g_exc_error;
6487: END IF;
6488: ELSE
6489: okc_api.set_message (p_app_name => g_app_name,
6490: p_msg_name => g_required_value,
6491: p_token1 => g_invalid_value,
6492: p_token1_value => 'CHR_ID'
6493: );

Line 6607: p_restricted_update => okc_api.g_false,

6603: p_init_msg_list => l_init_msg_list,
6604: x_return_status => x_return_status,
6605: x_msg_count => x_msg_count,
6606: x_msg_data => x_msg_data,
6607: p_restricted_update => okc_api.g_false,
6608: p_chrv_rec => l_chrv_rec_in,
6609: x_chrv_rec => l_chrv_rec_out
6610: );
6611:

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

6623: );
6624: END IF;
6625:
6626: --errorout ('Top Line id is NULL');
6627: okc_api.set_message (p_app_name => g_app_name,
6628: p_msg_name => g_required_value,
6629: p_token1 => g_invalid_value,
6630: p_token1_value => 'CLE_ID'
6631: );

Line 6746: p_restricted_update => okc_api.g_false,

6742: p_init_msg_list => l_init_msg_list,
6743: x_return_status => x_return_status,
6744: x_msg_count => x_msg_count,
6745: x_msg_data => x_msg_data,
6746: p_restricted_update => okc_api.g_false,
6747: p_chrv_rec => l_chrv_rec_in,
6748: x_chrv_rec => l_chrv_rec_out
6749: );
6750:

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

6762: );
6763: END IF;
6764:
6765: --errorout ('Sub line id is NULL');
6766: okc_api.set_message (p_app_name => g_app_name,
6767: p_msg_name => g_required_value,
6768: p_token1 => g_invalid_value,
6769: p_token1_value => 'LINE_ID'
6770: );

Line 6890: p_restricted_update => okc_api.g_false,

6886: p_init_msg_list => l_init_msg_list,
6887: x_return_status => x_return_status,
6888: x_msg_count => x_msg_count,
6889: x_msg_data => x_msg_data,
6890: p_restricted_update => okc_api.g_false,
6891: p_chrv_rec => l_chrv_rec_in,
6892: x_chrv_rec => l_chrv_rec_out
6893: );
6894:

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

6918: );
6919: END IF;
6920:
6921: -- errorout ('Line id is NULL');
6922: okc_api.set_message (p_app_name => g_app_name,
6923: p_msg_name => g_required_value,
6924: p_token1 => g_invalid_value,
6925: p_token1_value => 'CLE_ID'
6926: );

Line 7029: p_restricted_update => okc_api.g_false,

7025: p_init_msg_list => l_init_msg_list,
7026: x_return_status => x_return_status,
7027: x_msg_count => x_msg_count,
7028: x_msg_data => x_msg_data,
7029: p_restricted_update => okc_api.g_false,
7030: p_chrv_rec => l_chrv_rec_in,
7031: x_chrv_rec => l_chrv_rec_out
7032: );
7033:

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

7045: );
7046: END IF;
7047:
7048: -- errorout ('Sub line id is NULL');
7049: okc_api.set_message (p_app_name => g_app_name,
7050: p_msg_name => g_required_value,
7051: p_token1 => g_invalid_value,
7052: p_token1_value => 'LINE_ID'
7053: );

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

7064: );
7065: END IF;
7066:
7067: -- errorout ('********** Invalid Intent ********');
7068: okc_api.set_message (p_app_name => g_app_name,
7069: p_msg_name => g_required_value,
7070: p_token1 => g_invalid_value,
7071: p_token1_value => 'INTENT'
7072: );

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

7131:
7132: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
7133: DBMS_TRANSACTION.rollback_savepoint ('COMPUTE_PRICE');
7134: x_return_status := g_ret_sts_unexp_error;
7135: okc_api.set_message (p_app_name => g_app_name,
7136: p_msg_name => g_unexpected_error,
7137: p_token1 => g_sqlcode_token,
7138: p_token1_value => SQLCODE,
7139: p_token2 => g_sqlerrm_token,

Line 7188: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS

7184: x_msg_count => l_msg_count,
7185: x_msg_data => l_msg_data
7186: );
7187:
7188: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
7189: THEN
7190: retcode := 2;
7191: ELSE
7192: retcode := 0;