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_AUTO_REMINDER dependencies on OKC_API

Line 68: := okc_api.g_miss_char;

64: FROM okx_contact_points_v
65: WHERE contact_point_id = p_contactpoint_id;
66:
67: l_email_address VARCHAR2 (2000)
68: := okc_api.g_miss_char;
69: l_contact_id NUMBER;
70: l_api_name CONSTANT VARCHAR2 (30) := 'get_QTO_email';
71: BEGIN
72: OPEN l_qto_details_csr (p_chr_id);

Line 86: l_email_address := okc_api.g_miss_char;

82: INTO l_email_address;
83:
84: IF l_emailaddress_csr%NOTFOUND
85: THEN
86: l_email_address := okc_api.g_miss_char;
87: END IF;
88:
89: CLOSE l_emailaddress_csr;
90: END IF;

Line 258: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

254: x_return_status => x_return_status,
255: x_err_msg => l_err_msg
256: );
257:
258: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
259:
260: l_counter := l_err_msg.FIRST;
261: IF l_counter > 0 THEN
262: LOOP

Line 273: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

269: END IF;
270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
274: OKC_API.set_message ( G_APP_NAME,
275: G_UNEXPECTED_ERROR,
276: G_SQLCODE_TOKEN,
277: SQLCODE,

Line 274: OKC_API.set_message ( G_APP_NAME,

270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
274: OKC_API.set_message ( G_APP_NAME,
275: G_UNEXPECTED_ERROR,
276: G_SQLCODE_TOKEN,
277: SQLCODE,
278: G_SQLERRM_TOKEN,

Line 385: := okc_api.g_ret_sts_success;

381: ROUND (DBMS_RANDOM.VALUE (100, 999)))
382: FROM DUAL;
383:
384: l_return_status VARCHAR2 (1)
385: := okc_api.g_ret_sts_success;
386: l_user_name VARCHAR2 (100);
387: l_user_id NUMBER (15);
388: l_temp_user_id NUMBER (15);
389: l_responsibility_id NUMBER (15);

Line 646: x_return_status := okc_api.g_ret_sts_unexp_error;

642: l_api_name
643: );
644: END IF;
645:
646: x_return_status := okc_api.g_ret_sts_unexp_error;
647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
648: END create_user;
649:
650: PROCEDURE update_contract_status (

Line 696: x_return_status := okc_api.g_ret_sts_unexp_error;

692:
693: EXCEPTION
694: WHEN OTHERS
695: THEN
696: x_return_status := okc_api.g_ret_sts_unexp_error;
697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
698: END;
699:
700: PROCEDURE update_contract_status (

Line 714: := okc_api.g_ret_sts_success;

710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;
715: l_msg_data VARCHAR2 (2000);
716: l_msg_count NUMBER;
717: l_status_code VARCHAR2(40);
718:

Line 784: p_init_msg_list => okc_api.g_false,

780: END IF;
781:
782: okc_contract_pub.update_contract_header
783: (p_api_version => l_api_version,
784: p_init_msg_list => okc_api.g_false,
785: x_return_status => l_return_status,
786: x_msg_count => l_msg_count,
787: x_msg_data => l_msg_data,
788: p_restricted_update => okc_api.g_false,

Line 788: p_restricted_update => okc_api.g_false,

784: p_init_msg_list => okc_api.g_false,
785: x_return_status => l_return_status,
786: x_msg_count => l_msg_count,
787: x_msg_data => l_msg_data,
788: p_restricted_update => okc_api.g_false,
789: p_chrv_rec => l_chrv_rec,
790: x_chrv_rec => x_chrv_rec
791: );
792:

Line 848: p_init_msg_list => okc_api.g_false,

844: END IF;
845:
846: okc_contract_pub.update_contract_line
847: (p_api_version => l_api_version,
848: p_init_msg_list => okc_api.g_false,
849: x_return_status => l_return_status,
850: x_msg_count => l_msg_count,
851: x_msg_data => l_msg_data,
852: p_restricted_update => okc_api.g_false,

Line 852: p_restricted_update => okc_api.g_false,

848: p_init_msg_list => okc_api.g_false,
849: x_return_status => l_return_status,
850: x_msg_count => l_msg_count,
851: x_msg_data => l_msg_data,
852: p_restricted_update => okc_api.g_false,
853: p_clev_rec => l_clev_rec,
854: x_clev_rec => x_clev_rec
855: );
856:

Line 892: p_init_msg_list => okc_api.g_false,

888: END IF;
889:
890: okc_contract_pub.update_contract_line
891: (p_api_version => l_api_version,
892: p_init_msg_list => okc_api.g_false,
893: x_return_status => l_return_status,
894: x_msg_count => l_msg_count,
895: x_msg_data => l_msg_data,
896: p_restricted_update => okc_api.g_false,

Line 896: p_restricted_update => okc_api.g_false,

892: p_init_msg_list => okc_api.g_false,
893: x_return_status => l_return_status,
894: x_msg_count => l_msg_count,
895: x_msg_data => l_msg_data,
896: p_restricted_update => okc_api.g_false,
897: p_clev_rec => l_clev_rec,
898: x_clev_rec => x_clev_rec
899: );
900:

Line 1028: := okc_api.g_ret_sts_success;

1024: := 'get_time_stats';
1025: l_duration NUMBER;
1026: l_period VARCHAR2 (10);
1027: l_return_status VARCHAR2 (1)
1028: := okc_api.g_ret_sts_success;
1029: BEGIN
1030: IF p_start_date > p_end_date
1031: THEN
1032: okc_time_util_pub.get_duration (p_start_date => p_end_date,

Line 1050: IF l_return_status <> okc_api.g_ret_sts_success

1046: x_duration := l_duration *
1047: -1;
1048: END IF;
1049:
1050: IF l_return_status <> okc_api.g_ret_sts_success
1051: THEN
1052: x_duration := okc_api.g_miss_num;
1053: x_period := okc_api.g_miss_char;
1054: ELSE

Line 1052: x_duration := okc_api.g_miss_num;

1048: END IF;
1049:
1050: IF l_return_status <> okc_api.g_ret_sts_success
1051: THEN
1052: x_duration := okc_api.g_miss_num;
1053: x_period := okc_api.g_miss_char;
1054: ELSE
1055: x_period := l_period;
1056: END IF;

Line 1053: x_period := okc_api.g_miss_char;

1049:
1050: IF l_return_status <> okc_api.g_ret_sts_success
1051: THEN
1052: x_duration := okc_api.g_miss_num;
1053: x_period := okc_api.g_miss_char;
1054: ELSE
1055: x_period := l_period;
1056: END IF;
1057:

Line 1062: x_return_status := okc_api.g_ret_sts_error;

1058: x_return_status := l_return_status;
1059: EXCEPTION
1060: WHEN OTHERS
1061: THEN
1062: x_return_status := okc_api.g_ret_sts_error;
1063: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1064: END;
1065:
1066: PROCEDURE get_duration (

Line 1097: x_duration := okc_api.g_miss_num;

1093: END IF;
1094: EXCEPTION
1095: WHEN OTHERS
1096: THEN
1097: x_duration := okc_api.g_miss_num;
1098: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1099: END;
1100:
1101: PROCEDURE update_renewal_status (

Line 1118: l_return_status := okc_api.g_ret_sts_success;

1114: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
1115: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1116: l_kdetails_rec oks_qp_int_pvt.k_details_rec;
1117: BEGIN
1118: l_return_status := okc_api.g_ret_sts_success;
1119: oks_qp_int_pvt.get_k_details (p_id => p_chr_id,
1120: p_type => 'KHR',
1121: x_k_det_rec => l_kdetails_rec
1122: );

Line 1138: IF (l_return_status <> okc_api.g_ret_sts_success)

1134: x_khrv_rec => l_khdr_rec_out,
1135: p_validate_yn => 'N'
1136: );
1137:
1138: IF (l_return_status <> okc_api.g_ret_sts_success)
1139: THEN
1140: RAISE g_exception_halt_validation;
1141: END IF;
1142:

Line 1568: x_return_status := okc_api.g_ret_sts_unexp_error;

1564: );
1565: EXCEPTION
1566: WHEN OTHERS
1567: THEN
1568: x_return_status := okc_api.g_ret_sts_unexp_error;
1569: okc_api.set_message (g_app_name,
1570: g_unexpected_error,
1571: g_sqlcode_token,
1572: SQLCODE,

Line 1569: okc_api.set_message (g_app_name,

1565: EXCEPTION
1566: WHEN OTHERS
1567: THEN
1568: x_return_status := okc_api.g_ret_sts_unexp_error;
1569: okc_api.set_message (g_app_name,
1570: g_unexpected_error,
1571: g_sqlcode_token,
1572: SQLCODE,
1573: g_sqlerrm_token,

Line 1812: IF l_qto_email = okc_api.g_miss_char

1808: THEN
1809: oks_auto_reminder.get_qto_email (p_chr_id => p_chr_id,
1810: x_qto_email => l_qto_email);
1811:
1812: IF l_qto_email = okc_api.g_miss_char
1813: THEN
1814: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_EMAIL');
1815: fnd_msg_pub.ADD;
1816: RAISE fnd_api.g_exc_error;

Line 2439: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN

2435: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2436: 'oks_auto_reminder.get_qto_email(x_qto_email= '||
2437: x_qto_email||')');
2438: END IF;
2439: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN
2440: x_is_eligible := 'N';
2441: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QTO_EMAIL');
2442: FND_MSG_PUB.add;
2443: END IF;