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

Line 77: OKC_API.init_msg_list(p_init_msg_list);

73: fnd_log.string(FND_LOG.LEVEL_PROCEDURE ,G_MODULE_CURRENT||'.create_default_schedule.begin'
74: ,'p_cle_id = '||p_cle_id||' ,p_intent = '||p_intent);
75: END IF;
76: x_return_status := 'S';
77: OKC_API.init_msg_list(p_init_msg_list);
78: l_status := 'I';
79: Open kl_cur;
80: Fetch kl_cur Into g_chr_id, l_start_date, l_end_date, l_qty, l_uom, l_itype, l_template_id, l_tangible;
81: IF kl_cur%NotFound THEN

Line 83: x_return_status := OKC_API.G_RET_STS_ERROR;

79: Open kl_cur;
80: Fetch kl_cur Into g_chr_id, l_start_date, l_end_date, l_qty, l_uom, l_itype, l_template_id, l_tangible;
81: IF kl_cur%NotFound THEN
82: Close kl_cur;
83: x_return_status := OKC_API.G_RET_STS_ERROR;
84: OKC_API.set_message
85: ( p_app_name => 'OKS',
86: p_msg_name => 'OKS_SUB_INVAL_LINE',
87: p_token1 => 'LINEID',

Line 84: OKC_API.set_message

80: Fetch kl_cur Into g_chr_id, l_start_date, l_end_date, l_qty, l_uom, l_itype, l_template_id, l_tangible;
81: IF kl_cur%NotFound THEN
82: Close kl_cur;
83: x_return_status := OKC_API.G_RET_STS_ERROR;
84: OKC_API.set_message
85: ( p_app_name => 'OKS',
86: p_msg_name => 'OKS_SUB_INVAL_LINE',
87: p_token1 => 'LINEID',
88: p_token1_value => p_cle_id

Line 111: x_return_status := OKC_API.G_RET_STS_ERROR;

107: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
108: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.create_default_schedule.subs','it is a subscription item');
109: END IF;
110: if l_template_id is null then
111: x_return_status := OKC_API.G_RET_STS_ERROR;
112: OKC_API.set_message
113: ( p_app_name => 'OKS',
114: p_msg_name => 'OKS_SUB_NO_TMPL'
115: );

Line 112: OKC_API.set_message

108: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.create_default_schedule.subs','it is a subscription item');
109: END IF;
110: if l_template_id is null then
111: x_return_status := OKC_API.G_RET_STS_ERROR;
112: OKC_API.set_message
113: ( p_app_name => 'OKS',
114: p_msg_name => 'OKS_SUB_NO_TMPL'
115: );
116: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 144: x_return_status := OKC_API.G_RET_STS_ERROR;

140: END IF;
141: Exit;
142: End Loop;
143: if NVL(l_status, 'A') <> 'A' then
144: x_return_status := OKC_API.G_RET_STS_ERROR;
145: OKC_API.set_message
146: ( p_app_name => 'OKS',
147: p_msg_name => 'OKS_SUB_INACT_TMPL',
148: p_token1 => 'TMPL',

Line 145: OKC_API.set_message

141: Exit;
142: End Loop;
143: if NVL(l_status, 'A') <> 'A' then
144: x_return_status := OKC_API.G_RET_STS_ERROR;
145: OKC_API.set_message
146: ( p_app_name => 'OKS',
147: p_msg_name => 'OKS_SUB_INACT_TMPL',
148: p_token1 => 'TMPL',
149: p_token1_value => l_hdr_tbl_in(1).name

Line 176: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

172: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
173: 'oks_auth_util_pub.create_cii_for_subscription(x_return_status = '||x_return_status
174: ||', x_instance_id = '||l_instance_id||')');
175: END IF;
176: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
177: Raise gen_exit;
178: End If;
179: l_hdr_tbl_in(1).instance_id := l_instance_id;
180: Else -- Tangible Non-Subscription Item

Line 210: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

206: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
207: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
208: 'oks_subscr_hdr_pub.insert_row(x_return_status = '||x_return_status||')');
209: END IF;
210: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
211: Raise gen_exit;
212: End If;
213:
214: -- FOR TANGIBLE ITEMS(SUBSCRIPTION OR NON-SUB), CREATE DEFAULT PATTERN --

Line 267: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

263: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
265: 'oks_subscr_ptrns_pub.insert_row(x_return_status = '||x_return_status||')');
266: END IF;
267: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
268: Raise gen_exit;
269: end if;
270:
271: -- CALCULATE DEFAULT DELIVERY SCHEDULE --

Line 295: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

291: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
293: 'oks_subscription_sch_pvt.calc_delivery_date(x_return_status = '||x_return_status||')');
294: END IF;
295: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
296: Raise gen_exit;
297: end if;
298:
299: -- CREATE SCHEDULE ELEMENTS --

Line 336: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

332: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
333: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
334: 'oks_subscr_elems_pub.insert_row(x_return_status = '||x_return_status||')');
335: END IF;
336: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
337: Raise gen_exit;
338: end if;
339: else
340: Null; -- No Schedule for this line. Handle exception here if needed

Line 378: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

374: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
375: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.create_default_schedule.external_call.after',
376: 'oks_qp_int_pvt.compute_price(x_return_status = '||x_return_status||')');
377: END IF;
378: IF NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
379: Raise gen_exit;
380: END IF;
381: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.create_default_schedule.end',' ');

Line 394: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

390: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
391: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.create_default_schedule.UNEXPECTED',
392: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
393: END IF;
394: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
395: OKC_API.set_message
396: ( p_app_name => 'OKS',
397: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
398: p_token1 => 'ERROR_CODE',

Line 395: OKC_API.set_message

391: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.create_default_schedule.UNEXPECTED',
392: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
393: END IF;
394: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
395: OKC_API.set_message
396: ( p_app_name => 'OKS',
397: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
398: p_token1 => 'ERROR_CODE',
399: p_token1_value => sqlcode,

Line 532: l_elems_tbl_upd_in(upd_idx).osh_id := OKC_API.G_MISS_NUM;

528: procedure create_update_rec Is
529: begin
530: upd_idx := upd_idx + 1;
531: l_elems_tbl_upd_in(upd_idx).id := tmp_elem_tbl(idx).id;
532: l_elems_tbl_upd_in(upd_idx).osh_id := OKC_API.G_MISS_NUM;
533: l_elems_tbl_upd_in(upd_idx).dnz_chr_id := OKC_API.G_MISS_NUM;
534: l_elems_tbl_upd_in(upd_idx).dnz_cle_id := OKC_API.G_MISS_NUM;
535: l_elems_tbl_upd_in(upd_idx).seq_no := 1;
536: l_elems_tbl_upd_in(upd_idx).om_interface_date := l_delivery_tbl(i).delivery_date;

Line 533: l_elems_tbl_upd_in(upd_idx).dnz_chr_id := OKC_API.G_MISS_NUM;

529: begin
530: upd_idx := upd_idx + 1;
531: l_elems_tbl_upd_in(upd_idx).id := tmp_elem_tbl(idx).id;
532: l_elems_tbl_upd_in(upd_idx).osh_id := OKC_API.G_MISS_NUM;
533: l_elems_tbl_upd_in(upd_idx).dnz_chr_id := OKC_API.G_MISS_NUM;
534: l_elems_tbl_upd_in(upd_idx).dnz_cle_id := OKC_API.G_MISS_NUM;
535: l_elems_tbl_upd_in(upd_idx).seq_no := 1;
536: l_elems_tbl_upd_in(upd_idx).om_interface_date := l_delivery_tbl(i).delivery_date;
537: l_elems_tbl_upd_in(upd_idx).start_date := l_delivery_tbl(i).start_date;

Line 534: l_elems_tbl_upd_in(upd_idx).dnz_cle_id := OKC_API.G_MISS_NUM;

530: upd_idx := upd_idx + 1;
531: l_elems_tbl_upd_in(upd_idx).id := tmp_elem_tbl(idx).id;
532: l_elems_tbl_upd_in(upd_idx).osh_id := OKC_API.G_MISS_NUM;
533: l_elems_tbl_upd_in(upd_idx).dnz_chr_id := OKC_API.G_MISS_NUM;
534: l_elems_tbl_upd_in(upd_idx).dnz_cle_id := OKC_API.G_MISS_NUM;
535: l_elems_tbl_upd_in(upd_idx).seq_no := 1;
536: l_elems_tbl_upd_in(upd_idx).om_interface_date := l_delivery_tbl(i).delivery_date;
537: l_elems_tbl_upd_in(upd_idx).start_date := l_delivery_tbl(i).start_date;
538: l_elems_tbl_upd_in(upd_idx).end_date := l_delivery_tbl(i).end_date;

Line 541: l_elems_tbl_upd_in(upd_idx).order_header_id := OKC_API.G_MISS_NUM;

537: l_elems_tbl_upd_in(upd_idx).start_date := l_delivery_tbl(i).start_date;
538: l_elems_tbl_upd_in(upd_idx).end_date := l_delivery_tbl(i).end_date;
539: l_elems_tbl_upd_in(upd_idx).quantity := l_qty;
540: l_elems_tbl_upd_in(upd_idx).uom_code := l_uom;
541: l_elems_tbl_upd_in(upd_idx).order_header_id := OKC_API.G_MISS_NUM;
542: l_elems_tbl_upd_in(upd_idx).order_line_id := OKC_API.G_MISS_NUM;
543: l_elems_tbl_upd_in(upd_idx).object_version_number := tmp_elem_tbl(idx).o_v_num;
544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;

Line 542: l_elems_tbl_upd_in(upd_idx).order_line_id := OKC_API.G_MISS_NUM;

538: l_elems_tbl_upd_in(upd_idx).end_date := l_delivery_tbl(i).end_date;
539: l_elems_tbl_upd_in(upd_idx).quantity := l_qty;
540: l_elems_tbl_upd_in(upd_idx).uom_code := l_uom;
541: l_elems_tbl_upd_in(upd_idx).order_header_id := OKC_API.G_MISS_NUM;
542: l_elems_tbl_upd_in(upd_idx).order_line_id := OKC_API.G_MISS_NUM;
543: l_elems_tbl_upd_in(upd_idx).object_version_number := tmp_elem_tbl(idx).o_v_num;
544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;
546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;

Line 544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;

540: l_elems_tbl_upd_in(upd_idx).uom_code := l_uom;
541: l_elems_tbl_upd_in(upd_idx).order_header_id := OKC_API.G_MISS_NUM;
542: l_elems_tbl_upd_in(upd_idx).order_line_id := OKC_API.G_MISS_NUM;
543: l_elems_tbl_upd_in(upd_idx).object_version_number := tmp_elem_tbl(idx).o_v_num;
544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;
546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;
547: l_elems_tbl_upd_in(upd_idx).last_update_date := OKC_API.G_MISS_DATE;
548: l_elems_tbl_upd_in(upd_idx).last_update_login := OKC_API.G_MISS_NUM;

Line 545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;

541: l_elems_tbl_upd_in(upd_idx).order_header_id := OKC_API.G_MISS_NUM;
542: l_elems_tbl_upd_in(upd_idx).order_line_id := OKC_API.G_MISS_NUM;
543: l_elems_tbl_upd_in(upd_idx).object_version_number := tmp_elem_tbl(idx).o_v_num;
544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;
546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;
547: l_elems_tbl_upd_in(upd_idx).last_update_date := OKC_API.G_MISS_DATE;
548: l_elems_tbl_upd_in(upd_idx).last_update_login := OKC_API.G_MISS_NUM;
549: If p_intent Is Null Then

Line 546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;

542: l_elems_tbl_upd_in(upd_idx).order_line_id := OKC_API.G_MISS_NUM;
543: l_elems_tbl_upd_in(upd_idx).object_version_number := tmp_elem_tbl(idx).o_v_num;
544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;
546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;
547: l_elems_tbl_upd_in(upd_idx).last_update_date := OKC_API.G_MISS_DATE;
548: l_elems_tbl_upd_in(upd_idx).last_update_login := OKC_API.G_MISS_NUM;
549: If p_intent Is Null Then
550: l_elems_tbl_upd_in(ins_idx).amount := l_elem_amount;

Line 547: l_elems_tbl_upd_in(upd_idx).last_update_date := OKC_API.G_MISS_DATE;

543: l_elems_tbl_upd_in(upd_idx).object_version_number := tmp_elem_tbl(idx).o_v_num;
544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;
546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;
547: l_elems_tbl_upd_in(upd_idx).last_update_date := OKC_API.G_MISS_DATE;
548: l_elems_tbl_upd_in(upd_idx).last_update_login := OKC_API.G_MISS_NUM;
549: If p_intent Is Null Then
550: l_elems_tbl_upd_in(ins_idx).amount := l_elem_amount;
551: End If;

Line 548: l_elems_tbl_upd_in(upd_idx).last_update_login := OKC_API.G_MISS_NUM;

544: l_elems_tbl_upd_in(upd_idx).created_by := OKC_API.G_MISS_NUM;
545: l_elems_tbl_upd_in(upd_idx).creation_date := OKC_API.G_MISS_DATE;
546: l_elems_tbl_upd_in(upd_idx).last_updated_by := OKC_API.G_MISS_NUM;
547: l_elems_tbl_upd_in(upd_idx).last_update_date := OKC_API.G_MISS_DATE;
548: l_elems_tbl_upd_in(upd_idx).last_update_login := OKC_API.G_MISS_NUM;
549: If p_intent Is Null Then
550: l_elems_tbl_upd_in(ins_idx).amount := l_elem_amount;
551: End If;
552: end create_update_rec;

Line 565: x_return_status := OKC_API.G_RET_STS_SUCCESS;

561: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
562: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.recreate_schedule.begin','p_cle_id = '||p_cle_id||
563: ' ,p_intent = '||p_intent);
564: END IF;
565: x_return_status := OKC_API.G_RET_STS_SUCCESS;
566: Open kl_cur;
567: Fetch kl_cur Into g_chr_id, l_start_date, l_end_date, l_price_nego, l_qty, l_uom, l_itype;
568: IF kl_cur%NotFound THEN
569: Close kl_cur;

Line 570: x_return_status := OKC_API.G_RET_STS_ERROR;

566: Open kl_cur;
567: Fetch kl_cur Into g_chr_id, l_start_date, l_end_date, l_price_nego, l_qty, l_uom, l_itype;
568: IF kl_cur%NotFound THEN
569: Close kl_cur;
570: x_return_status := OKC_API.G_RET_STS_ERROR;
571: OKC_API.set_message
572: ( p_app_name => 'OKS',
573: p_msg_name => 'OKS_SUB_INVAL_LINE',
574: p_token1 => 'LINEID',

Line 571: OKC_API.set_message

567: Fetch kl_cur Into g_chr_id, l_start_date, l_end_date, l_price_nego, l_qty, l_uom, l_itype;
568: IF kl_cur%NotFound THEN
569: Close kl_cur;
570: x_return_status := OKC_API.G_RET_STS_ERROR;
571: OKC_API.set_message
572: ( p_app_name => 'OKS',
573: p_msg_name => 'OKS_SUB_INVAL_LINE',
574: p_token1 => 'LINEID',
575: p_token1_value => p_cle_id

Line 682: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

678: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
679: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
680: 'oks_subscr_ptrns_pub.update_row(x_return_status = '||x_return_status||')');
681: END IF;
682: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
683: Raise gen_exit;
684: end if;
685: l_pattern_tbl(1).yr_pattern := to_char(l_start_date,'YYYY');
686: l_pattern_tbl(1).mth_pattern := to_char(l_start_date,'MM');

Line 708: If nvl(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

704: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
705: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
706: 'oks_subscription_sch_pvt.calc_delivery_date(x_return_status = '||x_return_status||')');
707: END IF;
708: If nvl(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
709: Raise gen_exit;
710: End If;
711: If l_delivery_tbl.COUNT <> 0 And p_intent Is Null And l_sch_found = FALSE Then
712: l_elem_amount := l_price_nego / l_delivery_tbl.COUNT;

Line 804: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

800: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
801: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
802: 'oks_subscr_elems_pub.delete_row(x_return_status = '||x_return_status||')');
803: END IF;
804: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
805: Raise gen_exit;
806: end if;
807: End If;
808:

Line 829: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

825: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
827: 'oks_subscr_elems_pub.update_row(x_return_status = '||x_return_status||')');
828: END IF;
829: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
830: Raise gen_exit;
831: end if;
832: End If;
833:

Line 854: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

850: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
851: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
852: 'oks_subscr_elems_pub.insert_row(x_return_status = '||x_return_status||')');
853: END IF;
854: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
855: Raise gen_exit;
856: end if;
857: End If;
858: Open tot_qty_cur;

Line 889: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

885: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
886: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_schedule.external_call.after',
887: 'oks_qp_int_pvt.compute_price(x_return_status = '||x_return_status||')');
888: END IF;
889: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
890: Raise gen_exit;
891: End If;
892: END IF;
893: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 902: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

898: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
899: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE_CURRENT||'.recreate_schedule.EXCEPTION','gen_exit');
900: END IF;
901: When OTHERS Then
902: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
903: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
904: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.recreate_schedule.UNEXPECTED',
905: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
906: END IF;

Line 907: OKC_API.set_message

903: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
904: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.recreate_schedule.UNEXPECTED',
905: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
906: END IF;
907: OKC_API.set_message
908: ( p_app_name => 'OKS',
909: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
910: p_token1 => 'ERROR_CODE',
911: p_token1_value => sqlcode,

Line 943: x_return_status := OKC_API.G_RET_STS_SUCCESS;

939: OPEN osh_cur;
940: FETCH osh_cur INTO l_osh_id,l_item_type;
941: IF osh_cur%NOTFOUND THEN
942: CLOSE osh_cur;
943: x_return_status := OKC_API.G_RET_STS_SUCCESS;
944: RAISE gen_exit;
945: END IF;
946: CLOSE osh_cur;
947: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 972: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

968: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.recreate_instance.external_call.after',
969: 'oks_auth_util_pub.create_cii_for_subscription(x_return_status = '||x_return_status
970: ||', x_instance_id = '||l_instance_id||')');
971: END IF;
972: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
973: Raise gen_exit;
974: End If;
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.recreate_instance.updhdr.before',

Line 986: x_return_status := OKC_API.G_RET_STS_SUCCESS;

982: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
983: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.recreate_instance.updhdr.after',' ');
984: END IF;
985: END IF;
986: x_return_status := OKC_API.G_RET_STS_SUCCESS;
987: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
988: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.recreate_instance.end',' ');
989: END IF;
990: EXCEPTION

Line 996: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

992: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
993: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE_CURRENT||'.recreate_instance.EXCEPTION','gen_exit');
994: END IF;
995: When OTHERS Then
996: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
998: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.recreate_instance.UNEXPECTED',
999: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1000: END IF;

Line 1001: OKC_API.set_message

997: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
998: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.recreate_instance.UNEXPECTED',
999: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1000: END IF;
1001: OKC_API.set_message
1002: ( p_app_name => 'OKS',
1003: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
1004: p_token1 => 'ERROR_CODE',
1005: p_token1_value => sqlcode,

Line 1092: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

1088: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.copy_subscription.copy_osh.external_call.after',
1089: 'oks_auth_util_pub.create_cii_for_subscription(x_return_status = '||x_return_status
1090: ||', x_instance_id = '||l_instance_id||')');
1091: END IF;
1092: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
1093: Raise gen_exit;
1094: end if;
1095: l_schv_tbl_in(1).instance_id := l_instance_id;
1096: End If;

Line 1114: If x_return_status = OKC_API.G_RET_STS_SUCCESS Then

1110: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1111: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.copy_subscription.copy_osh.external_call.after',
1112: 'oks_subscr_hdr_pub.insert_row(x_return_status = '||x_return_status||')');
1113: END IF;
1114: If x_return_status = OKC_API.G_RET_STS_SUCCESS Then
1115: g_osh_id := l_schv_tbl_out(1).id;
1116: End If;
1117: End Loop;
1118: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1178: x_return_status := OKC_API.G_RET_STS_ERROR;

1174: Open tgt_chr_cur;
1175: Fetch tgt_chr_cur Into g_chr_id;
1176: If tgt_chr_cur%NOTFOUND Then
1177: Close tgt_chr_cur;
1178: x_return_status := OKC_API.G_RET_STS_ERROR;
1179: OKC_API.set_message
1180: ( p_app_name => 'OKS',
1181: p_msg_name => 'OKS_SUB_INVAL_TGT',
1182: p_token1 => 'TARGET',

Line 1179: OKC_API.set_message

1175: Fetch tgt_chr_cur Into g_chr_id;
1176: If tgt_chr_cur%NOTFOUND Then
1177: Close tgt_chr_cur;
1178: x_return_status := OKC_API.G_RET_STS_ERROR;
1179: OKC_API.set_message
1180: ( p_app_name => 'OKS',
1181: p_msg_name => 'OKS_SUB_INVAL_TGT',
1182: p_token1 => 'TARGET',
1183: p_token1_value => p_target_cle_id

Line 1195: x_return_status := OKC_API.G_RET_STS_ERROR;

1191: Open src_line_cur;
1192: Fetch src_line_cur Into l_dummy;
1193: If src_line_cur%NOTFOUND Then
1194: Close src_line_cur;
1195: x_return_status := OKC_API.G_RET_STS_ERROR;
1196: OKC_API.set_message
1197: ( p_app_name => 'OKS',
1198: p_msg_name => 'OKS_SUB_INVAL_SRC',
1199: p_token1 => 'SOURCE',

Line 1196: OKC_API.set_message

1192: Fetch src_line_cur Into l_dummy;
1193: If src_line_cur%NOTFOUND Then
1194: Close src_line_cur;
1195: x_return_status := OKC_API.G_RET_STS_ERROR;
1196: OKC_API.set_message
1197: ( p_app_name => 'OKS',
1198: p_msg_name => 'OKS_SUB_INVAL_SRC',
1199: p_token1 => 'SOURCE',
1200: p_token1_value => p_source_cle_id

Line 1256: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then

1252: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1253: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.copy_subscription.external_call.after',
1254: 'oks_qp_int_pvt.compute_price(x_return_status = '||x_return_status||')');
1255: END IF;
1256: if NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS then
1257: Raise gen_exit;
1258: end if;
1259: End If;
1260: End If;

Line 1268: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1264: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1265: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE_CURRENT||'.copy_subscription.EXCEPTION','gen_exit');
1266: END IF;
1267: When OTHERS Then
1268: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1269: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1270: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.create_default_schedule.UNEXPECTED',
1271: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1272: END IF;

Line 1273: OKC_API.set_message

1269: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1270: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.create_default_schedule.UNEXPECTED',
1271: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
1272: END IF;
1273: OKC_API.set_message
1274: ( p_app_name => 'OKS',
1275: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
1276: p_token1 => 'ERROR_CODE',
1277: p_token1_value => sqlcode,

Line 1310: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1306: And cle_id <> p_cle_id;
1307: l_dummy Number;
1308: */
1309: Begin
1310: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1311: For schv_rec in schv_cur
1312: Loop
1313: l_osh_id := schv_rec.id;
1314: l_ff_chan := schv_rec.fulfillment_channel;

Line 1435: IF l_osh_id Is Null Or NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN

1431: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.undo_subscription.begin','p_cle_id = '||p_cle_id);
1433: END IF;
1434: delete_cii; -- (Delete the item instance if one exists and) Get the OSH.id and fulfillment channel
1435: IF l_osh_id Is Null Or NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS THEN
1436: return;
1437: END IF;
1438: IF l_ff_chan <> 'NONE' THEN -- If the item is tangible then ...
1439: delete_ose; -- delete the subscription elements

Line 1440: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

1436: return;
1437: END IF;
1438: IF l_ff_chan <> 'NONE' THEN -- If the item is tangible then ...
1439: delete_ose; -- delete the subscription elements
1440: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
1441: return;
1442: End If;
1443: delete_osp; -- delete the subscription patterns
1444: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

Line 1444: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then

1440: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
1441: return;
1442: End If;
1443: delete_osp; -- delete the subscription patterns
1444: If NVL(x_return_status,'!') <> OKC_API.G_RET_STS_SUCCESS Then
1445: return;
1446: End If;
1447: END IF;
1448: delete_osh; -- delete the subscription header (tangible or intangible)

Line 1454: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1450: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.undo_subscription.end',' ');
1451: END IF;
1452: Exception
1453: When OTHERS Then
1454: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1455: OKC_API.set_message
1456: ( p_app_name => 'OKS',
1457: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
1458: p_token1 => 'ERROR_CODE',

Line 1455: OKC_API.set_message

1451: END IF;
1452: Exception
1453: When OTHERS Then
1454: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1455: OKC_API.set_message
1456: ( p_app_name => 'OKS',
1457: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
1458: p_token1 => 'ERROR_CODE',
1459: p_token1_value => sqlcode,

Line 1533: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1529: l_modifstr := '*';
1530: End If;
1531: End MERGER;
1532: Begin
1533: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1534: OKC_API.init_msg_list(p_init_msg_list);
1535: l_string := p_instring;
1536: l_string := translate(l_string,'0 ','0');
1537: IF l_string = '*' THEN

Line 1534: OKC_API.init_msg_list(p_init_msg_list);

1530: End If;
1531: End MERGER;
1532: Begin
1533: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1534: OKC_API.init_msg_list(p_init_msg_list);
1535: l_string := p_instring;
1536: l_string := translate(l_string,'0 ','0');
1537: IF l_string = '*' THEN
1538: x_outtab(1).low := p_lowval;

Line 1543: x_return_status := OKC_API.G_RET_STS_ERROR;

1539: x_outtab(1).high := p_highval;
1540: l_modifstr := '*';
1541: ELSIF l_string IS NOT NULL THEN
1542: If translate(l_string,' 0123456789,-',' ') IS NOT NULL Then
1543: x_return_status := OKC_API.G_RET_STS_ERROR;
1544: OKC_API.set_message
1545: ( p_app_name => 'OKS',
1546: p_msg_name => 'OKS_SUB_INVAL_CHRS',
1547: p_token1 => 'CHRS',

Line 1544: OKC_API.set_message

1540: l_modifstr := '*';
1541: ELSIF l_string IS NOT NULL THEN
1542: If translate(l_string,' 0123456789,-',' ') IS NOT NULL Then
1543: x_return_status := OKC_API.G_RET_STS_ERROR;
1544: OKC_API.set_message
1545: ( p_app_name => 'OKS',
1546: p_msg_name => 'OKS_SUB_INVAL_CHRS',
1547: p_token1 => 'CHRS',
1548: p_token1_value => translate(l_string,' 0123456789,-',' ')

Line 1556: x_return_status := OKC_API.G_RET_STS_ERROR;

1552: If instr(l_string,',,') <> 0 or
1553: instr(l_string,'--') <> 0 or
1554: instr(l_string,',-') <> 0 or
1555: instr(l_string,'-,') <> 0 Then
1556: x_return_status := OKC_API.G_RET_STS_ERROR;
1557: OKC_API.set_message
1558: ( p_app_name => 'OKS',
1559: p_msg_name => 'OKS_SUB_CONT_DELIM'
1560: );

Line 1557: OKC_API.set_message

1553: instr(l_string,'--') <> 0 or
1554: instr(l_string,',-') <> 0 or
1555: instr(l_string,'-,') <> 0 Then
1556: x_return_status := OKC_API.G_RET_STS_ERROR;
1557: OKC_API.set_message
1558: ( p_app_name => 'OKS',
1559: p_msg_name => 'OKS_SUB_CONT_DELIM'
1560: );
1561: Raise gen_exit;

Line 1565: x_return_status := OKC_API.G_RET_STS_ERROR;

1561: Raise gen_exit;
1562: End If;
1563: If substr(l_string,1,1) in (',','-') or
1564: substr(l_string,length(l_string),1) in (',','-') then
1565: x_return_status := OKC_API.G_RET_STS_ERROR;
1566: OKC_API.set_message
1567: ( p_app_name => 'OKS',
1568: p_msg_name => 'OKS_SUB_SE_DELIM'
1569: );

Line 1566: OKC_API.set_message

1562: End If;
1563: If substr(l_string,1,1) in (',','-') or
1564: substr(l_string,length(l_string),1) in (',','-') then
1565: x_return_status := OKC_API.G_RET_STS_ERROR;
1566: OKC_API.set_message
1567: ( p_app_name => 'OKS',
1568: p_msg_name => 'OKS_SUB_SE_DELIM'
1569: );
1570: Raise gen_exit;

Line 1583: x_return_status := OKC_API.G_RET_STS_ERROR;

1579: range1 := substr(l_string,1,commaloc-1);
1580: l_string := substr(l_string,commaloc+1);
1581: End If;
1582: If instr(range1,'-',1,2) <> 0 Then
1583: x_return_status := OKC_API.G_RET_STS_ERROR;
1584: OKC_API.set_message
1585: ( p_app_name => 'OKS',
1586: p_msg_name => 'OKS_SUB_INVAL_RANGE',
1587: p_token1 => 'RANGE',

Line 1584: OKC_API.set_message

1580: l_string := substr(l_string,commaloc+1);
1581: End If;
1582: If instr(range1,'-',1,2) <> 0 Then
1583: x_return_status := OKC_API.G_RET_STS_ERROR;
1584: OKC_API.set_message
1585: ( p_app_name => 'OKS',
1586: p_msg_name => 'OKS_SUB_INVAL_RANGE',
1587: p_token1 => 'RANGE',
1588: p_token1_value => range1

Line 1602: x_return_status := OKC_API.G_RET_STS_ERROR;

1598: highval := substr(range1,hyphenloc+1);
1599: End If;
1600: If lowval < p_lowval or highval < p_lowval or
1601: lowval > p_highval or highval > p_highval Then
1602: x_return_status := OKC_API.G_RET_STS_ERROR;
1603: OKC_API.set_message
1604: ( p_app_name => 'OKS',
1605: p_msg_name => 'OKS_SUB_RANGE',
1606: p_token1 => 'LOW',

Line 1603: OKC_API.set_message

1599: End If;
1600: If lowval < p_lowval or highval < p_lowval or
1601: lowval > p_highval or highval > p_highval Then
1602: x_return_status := OKC_API.G_RET_STS_ERROR;
1603: OKC_API.set_message
1604: ( p_app_name => 'OKS',
1605: p_msg_name => 'OKS_SUB_RANGE',
1606: p_token1 => 'LOW',
1607: p_token1_value => p_lowval,

Line 1614: x_return_status := OKC_API.G_RET_STS_ERROR;

1610: );
1611: Raise gen_exit;
1612: End If;
1613: If lowval > highval Then
1614: x_return_status := OKC_API.G_RET_STS_ERROR;
1615: OKC_API.set_message
1616: ( p_app_name => 'OKS',
1617: p_msg_name => 'OKS_SUB_INVAL_RANGE',
1618: p_token1 => 'RANGE',

Line 1615: OKC_API.set_message

1611: Raise gen_exit;
1612: End If;
1613: If lowval > highval Then
1614: x_return_status := OKC_API.G_RET_STS_ERROR;
1615: OKC_API.set_message
1616: ( p_app_name => 'OKS',
1617: p_msg_name => 'OKS_SUB_INVAL_RANGE',
1618: p_token1 => 'RANGE',
1619: p_token1_value => range1

Line 1645: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1641: Exception
1642: When gen_exit Then
1643: Null;
1644: When OTHERS Then
1645: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1646: OKC_API.set_message
1647: ( p_app_name => 'OKS',
1648: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
1649: p_token1 => 'ERROR_CODE',

Line 1646: OKC_API.set_message

1642: When gen_exit Then
1643: Null;
1644: When OTHERS Then
1645: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1646: OKC_API.set_message
1647: ( p_app_name => 'OKS',
1648: p_msg_name => 'OKC_CONTRACTS_UNEXP_ERROR',
1649: p_token1 => 'ERROR_CODE',
1650: p_token1_value => sqlcode,

Line 1704: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1700: Begin
1701: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1702: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.get_subs_qty.begin','p_cle_id = '||p_cle_id);
1703: END IF;
1704: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1705: l_pricing_method:=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1706: Open k_item_cur;
1707: Fetch k_item_cur Into l_quantity, l_uom_code;
1708: Close k_item_cur;

Line 1749: x_return_status := OKC_API.G_RET_STS_ERROR;

1745: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1746: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.get_subs_qty.freq_uom','Frequency UOM = '||l_cal_uom);
1747: END IF;
1748: if l_cal_uom is Null then
1749: x_return_status := OKC_API.G_RET_STS_ERROR;
1750: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1751: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.get_subs_qty.ERROR','Invalid UOM Code');
1752: END IF;
1753: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

Line 1753: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

1749: x_return_status := OKC_API.G_RET_STS_ERROR;
1750: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1751: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.get_subs_qty.ERROR','Invalid UOM Code');
1752: END IF;
1753: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
1754: p_msg_name => 'OKS_INVD_UOM_CODE',
1755: p_token1 => 'OKS_API_NAME',
1756: p_token1_value => 'OKS_SUBSCRIPTION_PVT.get_subs_qty',
1757: p_token2 => 'UOM_CODE',

Line 1821: OKC_API.set_message(

1817: Exception
1818: WHEN EXC_ERROR THEN
1819: NULL;
1820: WHEN INVALID_HDR_ID_EXCEPTION THEN
1821: OKC_API.set_message(
1822: p_app_name => G_APP_NAME,
1823: p_msg_name => G_INVALID_VALUE,
1824: p_token1 => G_COL_NAME_TOKEN,
1825: p_token1_value => 'Header ID');

Line 1827: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1823: p_msg_name => G_INVALID_VALUE,
1824: p_token1 => G_COL_NAME_TOKEN,
1825: p_token1_value => 'Header ID');
1826: When Others Then
1827: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1828: End get_subs_qty;
1829:
1830: Procedure stretch_effectivity
1831: ( p_start_date IN DATE,

Line 2062: OKC_API.set_message(

2058: Exception
2059: WHEN EXC_ERROR THEN
2060: Return NULL;
2061: WHEN INVALID_HDR_ID_EXCEPTION THEN
2062: OKC_API.set_message(
2063: p_app_name => G_APP_NAME,
2064: p_msg_name => G_INVALID_VALUE,
2065: p_token1 => G_COL_NAME_TOKEN,
2066: p_token1_value => 'Header ID');