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 806: p_init_msg_list => okc_api.g_false,

802: l_chrv_rec.new_ste_code := 'CANCELLED';
803: /*commented and modified for bug8345674
804: okc_contract_pub.update_contract_header
805: (p_api_version => l_api_version,
806: p_init_msg_list => okc_api.g_false,
807: x_return_status => l_return_status,
808: x_msg_count => l_msg_count,
809: x_msg_data => l_msg_data,
810: p_restricted_update => okc_api.g_true,

Line 810: p_restricted_update => okc_api.g_true,

806: p_init_msg_list => okc_api.g_false,
807: x_return_status => l_return_status,
808: x_msg_count => l_msg_count,
809: x_msg_data => l_msg_data,
810: p_restricted_update => okc_api.g_true,
811: p_chrv_rec => l_chrv_rec,
812: x_chrv_rec => x_chrv_rec
813: );
814: */

Line 841: p_init_msg_list => okc_api.g_false,

837: /*end of bug8345674*/
838: ELSE
839: okc_contract_pub.update_contract_header
840: (p_api_version => l_api_version,
841: p_init_msg_list => okc_api.g_false,
842: x_return_status => l_return_status,
843: x_msg_count => l_msg_count,
844: x_msg_data => l_msg_data,
845: p_restricted_update => okc_api.g_false,

Line 845: p_restricted_update => okc_api.g_false,

841: p_init_msg_list => okc_api.g_false,
842: x_return_status => l_return_status,
843: x_msg_count => l_msg_count,
844: x_msg_data => l_msg_data,
845: p_restricted_update => okc_api.g_false,
846: p_chrv_rec => l_chrv_rec,
847: x_chrv_rec => x_chrv_rec
848: );
849: END IF;

Line 904: p_init_msg_list => okc_api.g_false,

900: END IF;
901:
902: okc_contract_pub.update_contract_line
903: (p_api_version => l_api_version,
904: p_init_msg_list => okc_api.g_false,
905: x_return_status => l_return_status,
906: x_msg_count => l_msg_count,
907: x_msg_data => l_msg_data,
908: p_restricted_update => okc_api.g_false,

Line 908: p_restricted_update => okc_api.g_false,

904: p_init_msg_list => okc_api.g_false,
905: x_return_status => l_return_status,
906: x_msg_count => l_msg_count,
907: x_msg_data => l_msg_data,
908: p_restricted_update => okc_api.g_false,
909: p_clev_rec => l_clev_rec,
910: x_clev_rec => x_clev_rec
911: );
912:

Line 956: p_init_msg_list => okc_api.g_false,

952: l_clev_rec.trn_code := 'NFC';
953: l_clev_rec.new_ste_code := 'CANCELLED';
954: okc_contract_pub.update_contract_line
955: (p_api_version => l_api_version,
956: p_init_msg_list => okc_api.g_false,
957: x_return_status => l_return_status,
958: x_msg_count => l_msg_count,
959: x_msg_data => l_msg_data,
960: p_restricted_update => okc_api.g_true,

Line 960: p_restricted_update => okc_api.g_true,

956: p_init_msg_list => okc_api.g_false,
957: x_return_status => l_return_status,
958: x_msg_count => l_msg_count,
959: x_msg_data => l_msg_data,
960: p_restricted_update => okc_api.g_true,
961: p_clev_rec => l_clev_rec,
962: x_clev_rec => x_clev_rec
963: );
964: */

Line 969: p_init_msg_list => okc_api.g_false,

965: NULL;
966: ELSE
967: okc_contract_pub.update_contract_line
968: (p_api_version => l_api_version,
969: p_init_msg_list => okc_api.g_false,
970: x_return_status => l_return_status,
971: x_msg_count => l_msg_count,
972: x_msg_data => l_msg_data,
973: p_restricted_update => okc_api.g_false,

Line 973: p_restricted_update => okc_api.g_false,

969: p_init_msg_list => okc_api.g_false,
970: x_return_status => l_return_status,
971: x_msg_count => l_msg_count,
972: x_msg_data => l_msg_data,
973: p_restricted_update => okc_api.g_false,
974: p_clev_rec => l_clev_rec,
975: x_clev_rec => x_clev_rec
976: );
977: END IF;

Line 1105: := okc_api.g_ret_sts_success;

1101: := 'get_time_stats';
1102: l_duration NUMBER;
1103: l_period VARCHAR2 (10);
1104: l_return_status VARCHAR2 (1)
1105: := okc_api.g_ret_sts_success;
1106: BEGIN
1107: IF p_start_date > p_end_date
1108: THEN
1109: okc_time_util_pub.get_duration (p_start_date => p_end_date,

Line 1127: IF l_return_status <> okc_api.g_ret_sts_success

1123: x_duration := l_duration *
1124: -1;
1125: END IF;
1126:
1127: IF l_return_status <> okc_api.g_ret_sts_success
1128: THEN
1129: x_duration := okc_api.g_miss_num;
1130: x_period := okc_api.g_miss_char;
1131: ELSE

Line 1129: x_duration := okc_api.g_miss_num;

1125: END IF;
1126:
1127: IF l_return_status <> okc_api.g_ret_sts_success
1128: THEN
1129: x_duration := okc_api.g_miss_num;
1130: x_period := okc_api.g_miss_char;
1131: ELSE
1132: x_period := l_period;
1133: END IF;

Line 1130: x_period := okc_api.g_miss_char;

1126:
1127: IF l_return_status <> okc_api.g_ret_sts_success
1128: THEN
1129: x_duration := okc_api.g_miss_num;
1130: x_period := okc_api.g_miss_char;
1131: ELSE
1132: x_period := l_period;
1133: END IF;
1134:

Line 1139: x_return_status := okc_api.g_ret_sts_error;

1135: x_return_status := l_return_status;
1136: EXCEPTION
1137: WHEN OTHERS
1138: THEN
1139: x_return_status := okc_api.g_ret_sts_error;
1140: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1141: END;
1142:
1143: PROCEDURE get_duration (

Line 1174: x_duration := okc_api.g_miss_num;

1170: END IF;
1171: EXCEPTION
1172: WHEN OTHERS
1173: THEN
1174: x_duration := okc_api.g_miss_num;
1175: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1176: END;
1177:
1178: PROCEDURE update_renewal_status (

Line 1195: l_return_status := okc_api.g_ret_sts_success;

1191: l_khdr_rec_in oks_contract_hdr_pub.khrv_rec_type;
1192: l_khdr_rec_out oks_contract_hdr_pub.khrv_rec_type;
1193: l_kdetails_rec oks_qp_int_pvt.k_details_rec;
1194: BEGIN
1195: l_return_status := okc_api.g_ret_sts_success;
1196: oks_qp_int_pvt.get_k_details (p_id => p_chr_id,
1197: p_type => 'KHR',
1198: x_k_det_rec => l_kdetails_rec
1199: );

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

1211: x_khrv_rec => l_khdr_rec_out,
1212: p_validate_yn => 'N'
1213: );
1214:
1215: IF (l_return_status <> okc_api.g_ret_sts_success)
1216: THEN
1217: RAISE g_exception_halt_validation;
1218: END IF;
1219:

Line 1645: x_return_status := okc_api.g_ret_sts_unexp_error;

1641: );
1642: EXCEPTION
1643: WHEN OTHERS
1644: THEN
1645: x_return_status := okc_api.g_ret_sts_unexp_error;
1646: okc_api.set_message (g_app_name,
1647: g_unexpected_error,
1648: g_sqlcode_token,
1649: SQLCODE,

Line 1646: okc_api.set_message (g_app_name,

1642: EXCEPTION
1643: WHEN OTHERS
1644: THEN
1645: x_return_status := okc_api.g_ret_sts_unexp_error;
1646: okc_api.set_message (g_app_name,
1647: g_unexpected_error,
1648: g_sqlcode_token,
1649: SQLCODE,
1650: g_sqlerrm_token,

Line 1889: IF l_qto_email = okc_api.g_miss_char

1885: THEN
1886: oks_auto_reminder.get_qto_email (p_chr_id => p_chr_id,
1887: x_qto_email => l_qto_email);
1888:
1889: IF l_qto_email = okc_api.g_miss_char
1890: THEN
1891: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_EMAIL');
1892: fnd_msg_pub.ADD;
1893: RAISE fnd_api.g_exc_error;

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

2533: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2534: 'oks_auto_reminder.get_qto_email(x_qto_email= '||
2535: x_qto_email||')');
2536: END IF;
2537: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN
2538: x_is_eligible := 'N';
2539: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QTO_EMAIL');
2540: FND_MSG_PUB.add;
2541: END IF;