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_IBINT_PUB dependencies on FND_LOG

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: OKSPIBIB.pls 120.60.12020000.2 2012/07/23 07:45:49 spingali ship $ */
3:
4:
5: -- Constants used for Message Logging
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3:
4:
5: -- Constants used for Message Logging
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4:
5: -- Constants used for Message Logging
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: -- Constants used for Message Logging
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_int_ibint_pub';

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_int_ibint_pub';
14:

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_int_ibint_pub';
14:
15:

Line 12: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_int_ibint_pub';
14:
15:
16: -- created for bom issues

Line 59: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

55: IF ( l_k_exists%FOUND ) THEN
56: v_flag := TRUE;
57: ELSE
58: v_flag := FALSE;
59: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
60: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.CHECK_PARENT_AP_K',
61: 'Contract not created for parent item yet' );
62: END IF;
63:

Line 60: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.CHECK_PARENT_AP_K',

56: v_flag := TRUE;
57: ELSE
58: v_flag := FALSE;
59: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
60: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.CHECK_PARENT_AP_K',
61: 'Contract not created for parent item yet' );
62: END IF;
63:
64: END IF;

Line 169: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

165: x_msg_data => l_msg_data,
166: p_codv_tbl => l_codv_tbl_in,
167: x_codv_tbl => l_codv_tbl_out
168: );
169: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS',
171: 'oks_cod_pvt.update_row(Return status = '|| l_return_status || ')');
172: END IF;
173:

Line 170: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS',

166: p_codv_tbl => l_codv_tbl_in,
167: x_codv_tbl => l_codv_tbl_out
168: );
169: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS',
171: 'oks_cod_pvt.update_row(Return status = '|| l_return_status || ')');
172: END IF;
173:
174: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 206: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

202: p_codv_tbl => l_codv_tbl_in,
203: x_codv_tbl => l_codv_tbl_out
204: );
205:
206: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
207: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS',
208: 'oks_cod_pvt.update_row(Return status = '|| l_return_status || ')');
209: END IF;
210:

Line 207: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS',

203: x_codv_tbl => l_codv_tbl_out
204: );
205:
206: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
207: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS',
208: 'oks_cod_pvt.update_row(Return status = '|| l_return_status || ')');
209: END IF;
210:
211: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 229: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

225:
226: When Others Then
227: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
228: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
229: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
230: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS.UNEXPECTED',
231: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
232: END IF;
233:

Line 230: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS.UNEXPECTED',

226: When Others Then
227: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
228: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
229: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
230: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.UPDATE_CONTRACT_DETAILS.UNEXPECTED',
231: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
232: END IF;
233:
234: End;

Line 307: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

303:
304: Exception
305: When Others Then
306: x_return_status := OKC_API.G_RET_STS_ERROR;
307: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
308: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.GET_CONTRACT_DETAILS.UNEXPECTED',
309: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
310: END IF;
311: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);

Line 308: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.GET_CONTRACT_DETAILS.UNEXPECTED',

304: Exception
305: When Others Then
306: x_return_status := OKC_API.G_RET_STS_ERROR;
307: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
308: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.GET_CONTRACT_DETAILS.UNEXPECTED',
309: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
310: END IF;
311: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
312: End;

Line 514: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

510: -- Added: Vigandhi : 18-nov-2004
511: -- Get the renewal rules defined in GCD
512: p_party_id := Get_Party_id(p_instance_rec.old_CustomeR_acct_id);
513:
514: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
515: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
516: 'party id(Legacy) = ' ||p_party_id );
517: END IF;
518:

Line 515: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

511: -- Get the renewal rules defined in GCD
512: p_party_id := Get_Party_id(p_instance_rec.old_CustomeR_acct_id);
513:
514: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
515: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
516: 'party id(Legacy) = ' ||p_party_id );
517: END IF;
518:
519: OKS_RENEW_UTIL_PUB.GET_RENEW_RULES

Line 534: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

530: P_RNRL_Rec => null,
531: X_RNRL_Rec => l_rnrl_rec_out
532: );
533:
534: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
535: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
536: 'oks_renew_util_pub.get_renew_rules(Return status = ' ||l_return_status );
537: END IF;
538:

Line 535: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

531: X_RNRL_Rec => l_rnrl_rec_out
532: );
533:
534: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
535: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
536: 'oks_renew_util_pub.get_renew_rules(Return status = ' ||l_return_status );
537: END IF;
538:
539: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 574: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

570: Fetch l_Ord_Hdr_csr into l_Ord_hdr_rec;
571: If l_Ord_Hdr_csr%notfound then
572: Close l_Ord_Hdr_csr;
573: l_return_status := OKC_API.G_RET_STS_ERROR;
574: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
575: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
576: 'l_ord_hdr_csr failed. No details found for line id ' ||p_instance_rec.Order_line_id );
577: END IF;
578: OKC_API.set_message(G_APP_NAME, 'OKS_ORD_HDR_DTLS_NOT_FOUND','ORDER_HEADER_ID',p_instance_rec.Order_line_id);

Line 575: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

571: If l_Ord_Hdr_csr%notfound then
572: Close l_Ord_Hdr_csr;
573: l_return_status := OKC_API.G_RET_STS_ERROR;
574: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
575: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
576: 'l_ord_hdr_csr failed. No details found for line id ' ||p_instance_rec.Order_line_id );
577: END IF;
578: OKC_API.set_message(G_APP_NAME, 'OKS_ORD_HDR_DTLS_NOT_FOUND','ORDER_HEADER_ID',p_instance_rec.Order_line_id);
579: Raise G_EXCEPTION_HALT_VALIDATION;

Line 585: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

581: Close l_Ord_Hdr_csr;
582:
583: p_party_id := Get_Party_id(l_Ord_hdr_rec.Sold_to_Org_id);
584:
585: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
587: 'party id(OM Generated) = ' ||p_party_id );
588: END IF;
589:

Line 586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

582:
583: p_party_id := Get_Party_id(l_Ord_hdr_rec.Sold_to_Org_id);
584:
585: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
587: 'party id(OM Generated) = ' ||p_party_id );
588: END IF;
589:
590: OKS_RENEW_UTIL_PUB.GET_RENEW_RULES

Line 605: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

601: P_RNRL_Rec => null,
602: X_RNRL_Rec => l_rnrl_rec_out
603: );
604:
605: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
606: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
607: 'oks_renew_util_pub.get_renew_rules(Return status = ' ||l_return_status );
608: END IF;
609:

Line 606: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

602: X_RNRL_Rec => l_rnrl_rec_out
603: );
604:
605: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
606: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
607: 'oks_renew_util_pub.get_renew_rules(Return status = ' ||l_return_status );
608: END IF;
609:
610: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 620: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

616: Open l_org_csr( p_instance_rec.order_line_id);
617: fetch l_org_csr into l_org_rec ;
618: Close l_org_Csr ;
619:
620: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
621: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.l_org_csr',
622: 'Org id ='||l_org_rec.org_id ||
623: ',Sold from org id = '|| l_org_rec.sold_from_org_id ||
624: ',Ship from org id = '||l_org_rec.ship_from_org_id );

Line 621: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.l_org_csr',

617: fetch l_org_csr into l_org_rec ;
618: Close l_org_Csr ;
619:
620: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
621: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.l_org_csr',
622: 'Org id ='||l_org_rec.org_id ||
623: ',Sold from org id = '|| l_org_rec.sold_from_org_id ||
624: ',Ship from org id = '||l_org_rec.ship_from_org_id );
625: END IF;

Line 653: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

649:
650:
651: End If;
652:
653: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
654: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.after org setup',
655: 'Org id = '||okc_context.get_okc_org_id ||
656: ',Organization id = '|| okc_context.get_okc_organization_id );
657: END IF;

Line 654: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.after org setup',

650:
651: End If;
652:
653: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
654: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.after org setup',
655: 'Org id = '||okc_context.get_okc_org_id ||
656: ',Organization id = '|| okc_context.get_okc_organization_id );
657: END IF;
658:

Line 668: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

664: p_Ship_date => p_instance_rec.shipped_date,
665: p_installation_date => p_instance_rec.installation_date,
666: x_warranty_tbl => war_tbl
667: ) ;
668: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
670: 'oks_extwar_util_pvt.get_warranty_info(Return status = '||l_return_status ||',Count = '|| war_tbl.count ||')' );
671: END IF;
672:

Line 669: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

665: p_installation_date => p_instance_rec.installation_date,
666: x_warranty_tbl => war_tbl
667: ) ;
668: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
670: 'oks_extwar_util_pvt.get_warranty_info(Return status = '||l_return_status ||',Count = '|| war_tbl.count ||')' );
671: END IF;
672:
673: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 685: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

681:
682:
683: If war_tbl.count = 0 And p_instance_rec.order_line_id = okc_api.g_miss_num Then
684:
685: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
687: ' Legacy no order line ' );
688: END IF;
689: Raise G_EXCEPTION_HALT_VALIDATION;

Line 686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

682:
683: If war_tbl.count = 0 And p_instance_rec.order_line_id = okc_api.g_miss_num Then
684:
685: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
687: ' Legacy no order line ' );
688: END IF;
689: Raise G_EXCEPTION_HALT_VALIDATION;
690:

Line 693: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

689: Raise G_EXCEPTION_HALT_VALIDATION;
690:
691: ElsIf p_instance_rec.order_line_id <> okc_api.g_miss_num Then
692: p_order_header_id := Get_order_header_id(p_instance_rec.order_line_id);
693: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
694: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
695: ' Order Line Routine. '|| ';'|| 'Order header id = '||p_order_header_id ||'Before update statement' );
696: END IF;
697:

Line 694: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

690:
691: ElsIf p_instance_rec.order_line_id <> okc_api.g_miss_num Then
692: p_order_header_id := Get_order_header_id(p_instance_rec.order_line_id);
693: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
694: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
695: ' Order Line Routine. '|| ';'|| 'Order header id = '||p_order_header_id ||'Before update statement' );
696: END IF;
697:
698: /* Fix for Bug 2240584.

Line 713: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

709: -- Where header_id = p_order_header_id;
710: --
711: -- Commented out for the fix of bug# 5088409 (JVARGHES)
712:
713: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
714: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
715: ' After update statement' );
716: END IF;
717:

Line 714: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

710: --
711: -- Commented out for the fix of bug# 5088409 (JVARGHES)
712:
713: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
714: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
715: ' After update statement' );
716: END IF;
717:
718: OKS_INTEGRATION_UTIL_PUB.Create_K_Order_Details

Line 726: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

722: , x_msg_count => l_msg_count
723: , x_msg_data => l_msg_data
724: );
725:
726: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
727: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
728: 'oks_integration_util_pub.create_k_order_details(Return status = '||l_return_status ||')' );
729: END IF;
730:

Line 727: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

723: , x_msg_data => l_msg_data
724: );
725:
726: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
727: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
728: 'oks_integration_util_pub.create_k_order_details(Return status = '||l_return_status ||')' );
729: END IF;
730:
731: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 743: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

739:
740: If Not war_tbl.Count = 0 Then
741:
742: If p_instance_rec.order_line_id = okc_api.g_miss_num Then -- Legacy Warranty Routine
743: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
744: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
745: ' Legacy Warranty Routine' );
746: END IF;
747:

Line 744: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

740: If Not war_tbl.Count = 0 Then
741:
742: If p_instance_rec.order_line_id = okc_api.g_miss_num Then -- Legacy Warranty Routine
743: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
744: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
745: ' Legacy Warranty Routine' );
746: END IF;
747:
748: l_chr_id := null;

Line 756: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

752:
753: Open l_line_csr (war_tbl(l_ptr).service_item_id);
754: Fetch l_line_csr Into l_itm_rec;
755: Close l_line_csr;
756: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
757: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.l_line_csr',
758: ' Name = '||l_itm_rec.name ||',Description = '||l_itm_rec.description ||
759: ',Primary UOM code = '||l_itm_rec.Primary_UOM_Code ||',Service starting delay = '||l_itm_rec.Service_starting_delay);
760: END IF;

Line 757: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.l_line_csr',

753: Open l_line_csr (war_tbl(l_ptr).service_item_id);
754: Fetch l_line_csr Into l_itm_rec;
755: Close l_line_csr;
756: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
757: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.l_line_csr',
758: ' Name = '||l_itm_rec.name ||',Description = '||l_itm_rec.description ||
759: ',Primary UOM code = '||l_itm_rec.Primary_UOM_Code ||',Service starting delay = '||l_itm_rec.Service_starting_delay);
760: END IF;
761:

Line 776: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

772: -- If customer product has two or more warraties attached to it in BOM, only one contract will get created
773: -- with as many warranty lines.
774: -- profile option created for warranty consolidation --23-apr-2003
775:
776: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
778: ' Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
779: END IF;
780:

Line 777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

773: -- with as many warranty lines.
774: -- profile option created for warranty consolidation --23-apr-2003
775:
776: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
778: ' Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
779: END IF;
780:
781: If l_chr_id IS NOT NULL AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' Then

Line 877: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

873: , x_return_status => l_return_status
874: , x_msg_count => x_msg_count
875: ,x_msg_data => x_msg_data
876: );
877: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
879: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status ||
880: ',Chr_id = ' || l_chr_Id || ')');
881: END IF;

Line 878: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

874: , x_msg_count => x_msg_count
875: ,x_msg_data => x_msg_data
876: );
877: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
879: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status ||
880: ',Chr_id = ' || l_chr_Id || ')');
881: END IF;
882:

Line 894: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

890: p_encoded => 'F',
891: p_data => l_msg_data,
892: p_msg_index_out => l_index
893: );
894: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
895: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','Legacy warranty error : ' || l_msg_data);
896: END IF;
897:
898: If(G_FND_LOG_OPTION = 'Y') Then

Line 895: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','Legacy warranty error : ' || l_msg_data);

891: p_data => l_msg_data,
892: p_msg_index_out => l_index
893: );
894: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
895: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','Legacy warranty error : ' || l_msg_data);
896: END IF;
897:
898: If(G_FND_LOG_OPTION = 'Y') Then
899: FND_FILE.PUT_LINE (FND_FILE.LOG, 'LEGACY WARRANTY ERROR : ' || l_msg_data );

Line 898: If(G_FND_LOG_OPTION = 'Y') Then

894: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
895: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','Legacy warranty error : ' || l_msg_data);
896: END IF;
897:
898: If(G_FND_LOG_OPTION = 'Y') Then
899: FND_FILE.PUT_LINE (FND_FILE.LOG, 'LEGACY WARRANTY ERROR : ' || l_msg_data );
900: End If;
901: End Loop;
902:

Line 913: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

909:
910: Raise G_EXCEPTION_HALT_VALIDATION;
911:
912: End If; -- Legacy Warranty Routine End
913: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
914: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
915: 'Order based Warranty Routine' );
916: END IF;
917:

Line 914: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

910: Raise G_EXCEPTION_HALT_VALIDATION;
911:
912: End If; -- Legacy Warranty Routine End
913: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
914: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
915: 'Order based Warranty Routine' );
916: END IF;
917:
918: --OM Originated Warranty Routine Starts Here

Line 930: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

926: X_Return_Status => l_return_status,
927: X_Header_Rec => l_header_rec
928: );
929:
930: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
932: 'oks_extwar_util_pvt.get_contract_header_info(Return status = '||l_return_status || ')');
933: END IF;
934:

Line 931: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

927: X_Header_Rec => l_header_rec
928: );
929:
930: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
932: 'oks_extwar_util_pvt.get_contract_header_info(Return status = '||l_return_status || ')');
933: END IF;
934:
935: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 952: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

948: X_Return_Status => l_return_status,
949: X_Line_Rec => l_line_rec
950: );
951:
952: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
953: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
954: 'oks_extwar_util_pvt.get_contract_line_info(Return status = '||l_return_status || ')');
955: END IF;
956:

Line 953: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

949: X_Line_Rec => l_line_rec
950: );
951:
952: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
953: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
954: 'oks_extwar_util_pvt.get_contract_line_info(Return status = '||l_return_status || ')');
955: END IF;
956:
957: -- Exception to be written

Line 974: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

970: P_Serv_start_date => war_tbl(l_ptr).Warranty_start_date,
971: P_Serv_end_date => war_tbl(l_ptr).Warranty_end_date,
972: X_Service_Status =>l_service_status
973: );
974: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
975: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
976: 'oks_extwar_util_pvt.check_service_duplicate(Return status = '||l_return_status ||
977: 'Service status = ' || l_service_status || ')');
978: END IF;

Line 975: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

971: P_Serv_end_date => war_tbl(l_ptr).Warranty_end_date,
972: X_Service_Status =>l_service_status
973: );
974: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
975: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
976: 'oks_extwar_util_pvt.check_service_duplicate(Return status = '||l_return_status ||
977: 'Service status = ' || l_service_status || ')');
978: END IF;
979:

Line 1001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

997: Open get_chr_id_csr(p_order_header_id);
998: Fetch get_chr_id_csr into l_chr_id;
999: close get_chr_id_csr;
1000:
1001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1002: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
1003: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
1004: END IF;
1005:

Line 1002: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',

998: Fetch get_chr_id_csr into l_chr_id;
999: close get_chr_id_csr;
1000:
1001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1002: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
1003: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
1004: END IF;
1005:
1006: If l_chr_id Is not null AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' then

Line 1106: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1102: , x_return_status => l_return_status
1103: , x_msg_count => x_msg_count
1104: , x_msg_data => x_msg_data
1105: );
1106: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
1108: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status || ')');
1109: END IF;
1110:

Line 1107: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

1103: , x_msg_count => x_msg_count
1104: , x_msg_data => x_msg_data
1105: );
1106: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
1108: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status || ')');
1109: END IF;
1110:
1111: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 1123: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1119: p_data => l_msg_data,
1120: p_msg_index_out => l_index
1121: );
1122:
1123: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','OM WARRANTY ERROR : ' || l_msg_data);
1125: END IF;
1126:
1127: If(G_FND_LOG_OPTION = 'Y') Then

Line 1124: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','OM WARRANTY ERROR : ' || l_msg_data);

1120: p_msg_index_out => l_index
1121: );
1122:
1123: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','OM WARRANTY ERROR : ' || l_msg_data);
1125: END IF;
1126:
1127: If(G_FND_LOG_OPTION = 'Y') Then
1128: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OM WARRANTY ERROR : ' || l_msg_data );

Line 1127: If(G_FND_LOG_OPTION = 'Y') Then

1123: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW','OM WARRANTY ERROR : ' || l_msg_data);
1125: END IF;
1126:
1127: If(G_FND_LOG_OPTION = 'Y') Then
1128: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OM WARRANTY ERROR : ' || l_msg_data );
1129: End If;
1130: End Loop;
1131:

Line 2080: fnd_log_repository.init;

2076: fnd_profile.put('AFLOG_ENABLED', 'Y');
2077: fnd_profile.put('AFLOG_MODULE', '%');
2078: fnd_profile.put('AFLOG_LEVEL', '1');
2079: fnd_profile.put('AFLOG_FILENAME', '');
2080: fnd_log_repository.init;
2081:
2082: */
2083: x_return_status := l_return_status;
2084:

Line 2107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2103: OKC_API.set_message(G_APP_NAME,'OKS_SUBSCRIPTION_INST_ERR');
2104: Raise G_EXCEPTION_HALT_VALIDATION;
2105:
2106: End If;
2107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2109: 'Batch Id'||p_batch_id ||')' );
2110: End If;
2111: If p_batch_id Is not Null Then

Line 2108: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2104: Raise G_EXCEPTION_HALT_VALIDATION;
2105:
2106: End If;
2107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2109: 'Batch Id'||p_batch_id ||')' );
2110: End If;
2111: If p_batch_id Is not Null Then
2112:

Line 2125: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2121: x_msg_count => x_msg_count,
2122: x_msg_data => x_msg_data
2123: );
2124:
2125: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2126: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2127: 'OKS_MASS_UPDATE.update_contracts(Return status = ' ||l_return_status );
2128: END IF;
2129:

Line 2126: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2122: x_msg_data => x_msg_data
2123: );
2124:
2125: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2126: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2127: 'OKS_MASS_UPDATE.update_contracts(Return status = ' ||l_return_status );
2128: END IF;
2129:
2130: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2143: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2139: -- Get all the instances for new transaction
2140: Open get_instances_for_new_csr;
2141: Fetch get_instances_for_new_csr Bulk Collect into instance_tbl;
2142: Close get_instances_for_new_csr;
2143: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2145: 'Number of instances with transaction New =' ||instance_tbl.count);
2146: End If;
2147: If instance_tbl.count > 0 Then

Line 2144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2140: Open get_instances_for_new_csr;
2141: Fetch get_instances_for_new_csr Bulk Collect into instance_tbl;
2142: Close get_instances_for_new_csr;
2143: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2144: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2145: 'Number of instances with transaction New =' ||instance_tbl.count);
2146: End If;
2147: If instance_tbl.count > 0 Then
2148: For i in 1..instance_tbl.count

Line 2151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2147: If instance_tbl.count > 0 Then
2148: For i in 1..instance_tbl.count
2149: Loop
2150:
2151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2152:
2153: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameters',
2154: 'Transaction Type = '|| 'NEW'|| 'Transaction date = '|| instance_tbl(i).transaction_date
2155: ||'Bom explosion flag = '|| instance_tbl(i).bom_explosion_flag );

Line 2153: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameters',

2149: Loop
2150:
2151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2152:
2153: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameters',
2154: 'Transaction Type = '|| 'NEW'|| 'Transaction date = '|| instance_tbl(i).transaction_date
2155: ||'Bom explosion flag = '|| instance_tbl(i).bom_explosion_flag );
2156: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameter',
2157: 'Old Org = '||instance_tbl(i).org_id||',Old Customer Product Id = '||instance_tbl(i).old_customer_product_id

Line 2156: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameter',

2152:
2153: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameters',
2154: 'Transaction Type = '|| 'NEW'|| 'Transaction date = '|| instance_tbl(i).transaction_date
2155: ||'Bom explosion flag = '|| instance_tbl(i).bom_explosion_flag );
2156: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.IB_INTERFACE.Begin.parameter',
2157: 'Old Org = '||instance_tbl(i).org_id||',Old Customer Product Id = '||instance_tbl(i).old_customer_product_id
2158: ||',Old Order Line Id = '||instance_tbl(i).order_line_id ||',Old Shipped Date = '|| instance_tbl(i).shipped_date
2159: ||',Old Bill To = '|| instance_tbl(i).bill_to_site_use_id ||',Old Ship To = '||instance_tbl(i).ship_to_site_use_id
2160: ||',Old Quantity = '|| instance_tbl(i).old_quantity || ',Old Unit Of Measurement = '|| instance_tbl(i).old_unit_of_measure

Line 2177: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2173:
2174:
2175:
2176:
2177: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2178: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2179: 'Ib_new(Return status = '||l_return_status ||')' );
2180: End If;
2181: x_return_status := l_return_status;

Line 2178: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2174:
2175:
2176:
2177: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2178: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2179: 'Ib_new(Return status = '||l_return_status ||')' );
2180: End If;
2181: x_return_status := l_return_status;
2182: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2194: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2190: ------------------------------------------------------
2191:
2192: If l_inst_dtls_tbl.count = 0 OR l_return_status <> 'S' Then
2193:
2194: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2195: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2196: 'No records for history details or status invalid ' );
2197: End If;
2198: Null;

Line 2195: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2191:
2192: If l_inst_dtls_tbl.count = 0 OR l_return_status <> 'S' Then
2193:
2194: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2195: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2196: 'No records for history details or status invalid ' );
2197: End If;
2198: Null;
2199: Else

Line 2236: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2232: x_msg_data => x_msg_data,
2233: p_insv_rec => l_insthist_rec,
2234: x_insv_rec => x_insthist_rec
2235: );
2236: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2237: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE.instance history',
2238: 'oks_ins_pvt.insert_row(Return status = '||l_return_status ||')' );
2239: End If;
2240: x_return_status := l_return_status;

Line 2237: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE.instance history',

2233: p_insv_rec => l_insthist_rec,
2234: x_insv_rec => x_insthist_rec
2235: );
2236: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2237: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE.instance history',
2238: 'oks_ins_pvt.insert_row(Return status = '||l_return_status ||')' );
2239: End If;
2240: x_return_status := l_return_status;
2241: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2262: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2258: x_msg_data => x_msg_data,
2259: p_ihdv_tbl => l_inst_dtls_tbl,
2260: x_ihdv_tbl => x_inst_dtls_tbl
2261: );
2262: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2263: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE.instance history details',
2264: 'oks_ihd_pvt.insert_row(Return status = '||l_return_status ||')' );
2265: End If;
2266: x_return_status := l_return_status;

Line 2263: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE.instance history details',

2259: p_ihdv_tbl => l_inst_dtls_tbl,
2260: x_ihdv_tbl => x_inst_dtls_tbl
2261: );
2262: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2263: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE.instance history details',
2264: 'oks_ihd_pvt.insert_row(Return status = '||l_return_status ||')' );
2265: End If;
2266: x_return_status := l_return_status;
2267: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2283: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2279: -- Transfer transaction
2280: Open get_Contracts_for_transfer_csr;
2281: Fetch get_Contracts_for_transfer_csr Bulk Collect into k_trf_tbl;
2282: Close get_Contracts_for_transfer_csr;
2283: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2284: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2285: 'Number of instances with transaction Transfer=' ||k_trf_tbl.count);
2286: End If;
2287:

Line 2284: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2280: Open get_Contracts_for_transfer_csr;
2281: Fetch get_Contracts_for_transfer_csr Bulk Collect into k_trf_tbl;
2282: Close get_Contracts_for_transfer_csr;
2283: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2284: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2285: 'Number of instances with transaction Transfer=' ||k_trf_tbl.count);
2286: End If;
2287:
2288:

Line 2300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2296: x_return_status => l_return_status,
2297: x_msg_count => x_msg_count,
2298: x_msg_data => x_msg_data
2299: );
2300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2301: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2302: 'oks_extwarprgm_pvt .create_k_system_transfer(Return status = '||l_return_status ||')' );
2303: End If;
2304:

Line 2301: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2297: x_msg_count => x_msg_count,
2298: x_msg_data => x_msg_data
2299: );
2300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2301: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2302: 'oks_extwarprgm_pvt .create_k_system_transfer(Return status = '||l_return_status ||')' );
2303: End If;
2304:
2305: x_return_status := l_return_status;

Line 2317: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2313: -- Terminate transaction
2314: Open get_k_for_trm_csr;
2315: Fetch get_k_for_trm_csr Bulk Collect into k_trm_tbl;
2316: Close get_k_for_trm_csr;
2317: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2318: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2319: 'Number of instances with transaction Terminate=' ||k_trm_tbl.count);
2320: End If;
2321:

Line 2318: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2314: Open get_k_for_trm_csr;
2315: Fetch get_k_for_trm_csr Bulk Collect into k_trm_tbl;
2316: Close get_k_for_trm_csr;
2317: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2318: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2319: 'Number of instances with transaction Terminate=' ||k_trm_tbl.count);
2320: End If;
2321:
2322:

Line 2332: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2328: x_return_status => l_return_status,
2329: x_msg_count => x_msg_count,
2330: x_msg_data => x_msg_data
2331: );
2332: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2333: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2334: 'Create_contract_terminate(Return status = '||l_return_status ||')' );
2335: End If;
2336: x_return_status := l_return_status;

Line 2333: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2329: x_msg_count => x_msg_count,
2330: x_msg_data => x_msg_data
2331: );
2332: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2333: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2334: 'Create_contract_terminate(Return status = '||l_return_status ||')' );
2335: End If;
2336: x_return_status := l_return_status;
2337: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2348: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2344: Open get_k_for_ret_csr;
2345: Fetch get_k_for_ret_csr Bulk Collect into k_ret_tbl;
2346: Close get_k_for_ret_csr;
2347:
2348: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2349: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2350: 'Number of instances with transaction Return=' ||k_ret_tbl.count);
2351: End If;
2352:

Line 2349: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2345: Fetch get_k_for_ret_csr Bulk Collect into k_ret_tbl;
2346: Close get_k_for_ret_csr;
2347:
2348: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2349: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2350: 'Number of instances with transaction Return=' ||k_ret_tbl.count);
2351: End If;
2352:
2353: --errorout_n('in return count'||K_ret_tbl.count);

Line 2365: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2361: x_msg_count => x_msg_count,
2362: x_msg_data => x_msg_data
2363: );
2364:
2365: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2366: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2367: 'Create_Contract_IBreturn(Return status = '||l_return_status ||')' );
2368: End If;
2369: x_return_status := l_return_status;

Line 2366: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2362: x_msg_data => x_msg_data
2363: );
2364:
2365: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2366: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2367: 'Create_Contract_IBreturn(Return status = '||l_return_status ||')' );
2368: End If;
2369: x_return_status := l_return_status;
2370: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2376: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2372: Raise G_EXCEPTION_HALT_VALIDATION;
2373: End if;
2374: End If;
2375: -- Update transaction
2376: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2378: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));
2379: End If;
2380:

Line 2377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2373: End if;
2374: End If;
2375: -- Update transaction
2376: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2378: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));
2379: End If;
2380:
2381: If NVL(fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'),'N') = 'Y' Then

Line 2386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2382: Open get_k_for_upd_csr;
2383: Fetch get_k_for_upd_csr Bulk Collect into k_upd_tbl;
2384: Close get_k_for_upd_csr;
2385:
2386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2387: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2388: 'Number of instances with transaction Update=' ||k_upd_tbl.count);
2389: End If;
2390:

Line 2387: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2383: Fetch get_k_for_upd_csr Bulk Collect into k_upd_tbl;
2384: Close get_k_for_upd_csr;
2385:
2386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2387: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2388: 'Number of instances with transaction Update=' ||k_upd_tbl.count);
2389: End If;
2390:
2391:

Line 2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2397: x_return_status => l_return_status,
2398: x_msg_count => x_msg_count,
2399: x_msg_data => x_msg_data
2400: );
2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2403: 'Create_contract_IBupdate(Return status = '||l_return_status ||')' );
2404: End If;
2405: x_return_status := l_return_status;

Line 2402: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2398: x_msg_count => x_msg_count,
2399: x_msg_data => x_msg_data
2400: );
2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2403: 'Create_contract_IBupdate(Return status = '||l_return_status ||')' );
2404: End If;
2405: x_return_status := l_return_status;
2406: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2421: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2417: Fetch get_k_for_idc_csr Bulk Collect into k_idc_tbl;
2418: Close get_k_for_idc_csr;
2419: --errorout_n('idc'||k_idc_tbl.count );
2420:
2421: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2422: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2423: 'Number of instances with transaction Idc=' ||k_idc_tbl.count);
2424: End If;
2425:

Line 2422: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2418: Close get_k_for_idc_csr;
2419: --errorout_n('idc'||k_idc_tbl.count );
2420:
2421: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2422: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2423: 'Number of instances with transaction Idc=' ||k_idc_tbl.count);
2424: End If;
2425:
2426:

Line 2435: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2431: x_return_status => l_return_status,
2432: x_msg_count => x_msg_count,
2433: x_msg_data => x_msg_data
2434: );
2435: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2436: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2437: 'Update_contract_idc(Return status = '||l_return_status ||')' );
2438: End If;
2439: x_return_status := l_return_status;

Line 2436: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2432: x_msg_count => x_msg_count,
2433: x_msg_data => x_msg_data
2434: );
2435: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2436: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2437: 'Update_contract_idc(Return status = '||l_return_status ||')' );
2438: End If;
2439: x_return_status := l_return_status;
2440:

Line 2454: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2450:
2451: Open get_k_for_spl_csr;
2452: Fetch get_k_for_spl_csr Bulk Collect into k_spl_tbl;
2453: Close get_k_for_spl_csr;
2454: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2455: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2456: 'Number of instances with transaction Split=' ||k_spl_tbl.count);
2457: End If;
2458:

Line 2455: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2451: Open get_k_for_spl_csr;
2452: Fetch get_k_for_spl_csr Bulk Collect into k_spl_tbl;
2453: Close get_k_for_spl_csr;
2454: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2455: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2456: 'Number of instances with transaction Split=' ||k_spl_tbl.count);
2457: End If;
2458:
2459:

Line 2469: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2465: x_return_status => l_return_status,
2466: x_msg_count => x_msg_count,
2467: x_msg_data => x_msg_data
2468: );
2469: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2470: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2471: 'Create_contract_ibsplit(Return status = '||l_return_status ||')' );
2472: End If;
2473: x_return_status := l_return_status;

Line 2470: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2466: x_msg_count => x_msg_count,
2467: x_msg_data => x_msg_data
2468: );
2469: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2470: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2471: 'Create_contract_ibsplit(Return status = '||l_return_status ||')' );
2472: End If;
2473: x_return_status := l_return_status;
2474: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2486: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2482: Open get_k_for_rpl_csr;
2483: Fetch get_k_for_rpl_csr Bulk Collect into k_rpl_tbl;
2484: Close get_k_for_rpl_csr;
2485:
2486: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2487: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2488: 'Number of instances with transaction Replace=' ||k_rpl_tbl.count);
2489: End If;
2490:

Line 2487: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2483: Fetch get_k_for_rpl_csr Bulk Collect into k_rpl_tbl;
2484: Close get_k_for_rpl_csr;
2485:
2486: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2487: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2488: 'Number of instances with transaction Replace=' ||k_rpl_tbl.count);
2489: End If;
2490:
2491:

Line 2497: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2493: If K_rpl_tbl.count > 0 Then
2494: --Call out to Pre-Integration
2495: --This is done as part of License Migration
2496: --Call out starts here
2497: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2498: THEN
2499: fnd_log.string(FND_LOG.LEVEL_STATEMENT
2500: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2501: ,'Before OKS_OMIB_EXTNS_PUB.pre_integration call: ' ||

Line 2499: fnd_log.string(FND_LOG.LEVEL_STATEMENT

2495: --This is done as part of License Migration
2496: --Call out starts here
2497: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2498: THEN
2499: fnd_log.string(FND_LOG.LEVEL_STATEMENT
2500: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2501: ,'Before OKS_OMIB_EXTNS_PUB.pre_integration call: ' ||
2502: ' ,p_api_version = '|| p_api_version ||
2503: ' ,p_init_msg_list = ' || p_init_msg_list ||

Line 2527: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

2523: ,x_return_status => x_return_status
2524: ,x_msg_count => x_msg_count
2525: ,x_msg_data => x_msg_data);
2526:
2527: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
2528: THEN
2529: fnd_log.string(FND_LOG.LEVEL_EVENT
2530: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2531: ,'After OKS_OMIB_INT_EXTNS_PUB.pre_integration Call: ' ||

Line 2529: fnd_log.string(FND_LOG.LEVEL_EVENT

2525: ,x_msg_data => x_msg_data);
2526:
2527: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
2528: THEN
2529: fnd_log.string(FND_LOG.LEVEL_EVENT
2530: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2531: ,'After OKS_OMIB_INT_EXTNS_PUB.pre_integration Call: ' ||
2532: ' ,x_process_status = ' || l_process_status ||
2533: ' ,x_return_status = ' || x_return_status);

Line 2549: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2545: x_return_status => l_return_status,
2546: x_msg_count => x_msg_count,
2547: x_msg_data => x_msg_data
2548: );
2549: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2551: 'Update_Contract_IBReplace(Return status = '||l_return_status ||')' );
2552: End If;
2553: x_return_status := l_return_status;

Line 2550: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',

2546: x_msg_count => x_msg_count,
2547: x_msg_data => x_msg_data
2548: );
2549: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2551: 'Update_Contract_IBReplace(Return status = '||l_return_status ||')' );
2552: End If;
2553: x_return_status := l_return_status;
2554: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2560: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2556: Raise G_EXCEPTION_HALT_VALIDATION;
2557: End if;
2558: End If;
2559: --Call out to post integration starts here
2560: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2561: THEN
2562: fnd_log.string(FND_LOG.LEVEL_STATEMENT
2563: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2564: ,'Before OKS_OMIB_EXTNS_PUB.post_integration call: ' ||

Line 2562: fnd_log.string(FND_LOG.LEVEL_STATEMENT

2558: End If;
2559: --Call out to post integration starts here
2560: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2561: THEN
2562: fnd_log.string(FND_LOG.LEVEL_STATEMENT
2563: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2564: ,'Before OKS_OMIB_EXTNS_PUB.post_integration call: ' ||
2565: ' ,p_transaction_type = ' || 'RPL'||
2566: ' ,p_transaction_date = ' || K_rpl_tbl(1).transaction_date||

Line 2589: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

2585: ,p_subline_id => NULL
2586: ,x_return_status => x_return_status
2587: ,x_msg_count => x_msg_count
2588: ,x_msg_data => x_msg_data);
2589: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
2590: THEN
2591: fnd_log.string(FND_LOG.LEVEL_EVENT
2592: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2593: ,'After OKS_OMIB_INT_EXTNS_PUB.post_integration Call: ' ||

Line 2591: fnd_log.string(FND_LOG.LEVEL_EVENT

2587: ,x_msg_count => x_msg_count
2588: ,x_msg_data => x_msg_data);
2589: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
2590: THEN
2591: fnd_log.string(FND_LOG.LEVEL_EVENT
2592: ,G_MODULE_CURRENT||'.IB_INTERFACE'
2593: ,'After OKS_OMIB_INT_EXTNS_PUB.post_integration Call: ' ||
2594: ' ,x_return_status = ' || x_return_status);
2595: END IF;

Line 2613: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2609:
2610: Exception
2611: When G_EXCEPTION_HALT_VALIDATION Then
2612: x_return_status := l_return_status;
2613: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2614: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',
2615: 'Return status = '||x_return_status );
2616: END IF;
2617: --Fix for bug 4947476

Line 2614: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',

2610: Exception
2611: When G_EXCEPTION_HALT_VALIDATION Then
2612: x_return_status := l_return_status;
2613: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2614: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',
2615: 'Return status = '||x_return_status );
2616: END IF;
2617: --Fix for bug 4947476
2618: FND_MSG_PUB.Count_And_Get

Line 2626: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2622: );
2623:
2624: When Others Then
2625: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2626: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2627: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',
2628: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2629: END IF;
2630: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);

Line 2627: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',

2623:
2624: When Others Then
2625: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2626: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2627: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',
2628: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2629: END IF;
2630: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
2631: --Fix for bug 4947476

Line 2659: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2655: WHERE batch_ID = P_Batch_ID;
2656: Exception
2657: When Others Then
2658: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2659: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2660: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',
2661: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2662: END IF;
2663: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);

Line 2660: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',

2656: Exception
2657: When Others Then
2658: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2659: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2660: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.IB_INTERFACE.UNEXPECTED',
2661: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2662: END IF;
2663: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
2664:

Line 2699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2695:
2696: IF l_dummy_var = '?'
2697: THEN
2698: x_return_status := OKC_API.G_RET_STS_ERROR;
2699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
2701: 'Accounts mismatch ' ||p_batch_id ||'Account id'|| p_new_owner_id );
2702: END IF;
2703: OKC_API.set_message(G_APP_NAME, 'OKS_BATCH_RULES_MISMATCH');

Line 2700: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

2696: IF l_dummy_var = '?'
2697: THEN
2698: x_return_status := OKC_API.G_RET_STS_ERROR;
2699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
2701: 'Accounts mismatch ' ||p_batch_id ||'Account id'|| p_new_owner_id );
2702: END IF;
2703: OKC_API.set_message(G_APP_NAME, 'OKS_BATCH_RULES_MISMATCH');
2704: END IF;

Line 2719: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2715:
2716: If x_return_status <> OKC_API.G_RET_STS_SUCCESS
2717: THEN
2718: x_return_status := OKC_API.G_RET_STS_ERROR;
2719: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2720: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
2721: 'Error while deleting the batch ' ||p_batch_id);
2722: END IF;
2723: END IF;

Line 2720: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',

2716: If x_return_status <> OKC_API.G_RET_STS_SUCCESS
2717: THEN
2718: x_return_status := OKC_API.G_RET_STS_ERROR;
2719: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2720: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
2721: 'Error while deleting the batch ' ||p_batch_id);
2722: END IF;
2723: END IF;
2724: END IF;

Line 2784: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2780: x_msg_data => x_msg_data,
2781: p_oks_batch_rules_v_rec => l_batch_rule,
2782: x_oks_batch_rules_v_rec => x_batch_rule);
2783:
2784: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2785: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.CREATE_BATCH',
2786: 'oks_brl_pvt.insert_row(Return status = '|| l_return_status || ')');
2787: END IF;
2788:

Line 2785: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.CREATE_BATCH',

2781: p_oks_batch_rules_v_rec => l_batch_rule,
2782: x_oks_batch_rules_v_rec => x_batch_rule);
2783:
2784: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2785: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.CREATE_BATCH',
2786: 'oks_brl_pvt.insert_row(Return status = '|| l_return_status || ')');
2787: END IF;
2788:
2789: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2797: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2793: x_return_status := l_return_status;
2794: Exception
2795: When G_EXCEPTION_HALT_VALIDATION Then
2796: x_return_status := l_return_status;
2797: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2798: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.CARETE_BATCH_RULES.UNEXPECTED',
2799: 'No Batch rules created');
2800: END IF;
2801:

Line 2798: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.CARETE_BATCH_RULES.UNEXPECTED',

2794: Exception
2795: When G_EXCEPTION_HALT_VALIDATION Then
2796: x_return_status := l_return_status;
2797: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2798: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.CARETE_BATCH_RULES.UNEXPECTED',
2799: 'No Batch rules created');
2800: END IF;
2801:
2802: When Others Then

Line 2805: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2801:
2802: When Others Then
2803: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2804: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
2805: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2806: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.CARETE_BATCH_RULES.UNEXPECTED',
2807: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2808: END IF;
2809: End;

Line 2806: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.CARETE_BATCH_RULES.UNEXPECTED',

2802: When Others Then
2803: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2804: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
2805: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2806: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,G_MODULE_CURRENT||'.CARETE_BATCH_RULES.UNEXPECTED',
2807: 'sqlcode = '||sqlcode||', sqlerrm = '||sqlerrm);
2808: END IF;
2809: End;
2810:

Line 3129: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3125: x_return_status => x_return_status,
3126: x_msg_count => x_msg_count,
3127: x_msg_data => x_msg_data);
3128:
3129: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3130: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.Create_item_instance',
3131: 'Csi PAI status = ('|| x_return_status || ')');
3132: END IF;
3133:

Line 3130: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.Create_item_instance',

3126: x_msg_count => x_msg_count,
3127: x_msg_data => x_msg_data);
3128:
3129: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3130: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.Create_item_instance',
3131: 'Csi PAI status = ('|| x_return_status || ')');
3132: END IF;
3133:
3134: p_instance_rec.instance_id :=lp_instance_rec.instance_id;

Line 3725: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level

3721: CLOSE chk_sts;
3722: IF l_k_sts <> 'ENTERED'
3723: THEN
3724: /*Subline addition to contracts in non-entered status is not allowed.*/
3725: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3726: THEN
3727: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3728: g_module_current
3729: || '.create_webadi_covered_levels',

Line 3727: fnd_log.STRING (fnd_log.LEVEL_EVENT,

3723: THEN
3724: /*Subline addition to contracts in non-entered status is not allowed.*/
3725: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3726: THEN
3727: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3728: g_module_current
3729: || '.create_webadi_covered_levels',
3730: 'Cannot add sublines to contract'
3731: || ' in current status'

Line 3754: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level

3750: CLOSE prod_party_validity_csr;
3751:
3752: IF Nvl(l_valid1,'N') <> 'Y'
3753: THEN
3754: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3755: THEN
3756: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3757: g_module_current
3758: || '.create_webadi_covered_levels',

Line 3756: fnd_log.STRING (fnd_log.LEVEL_EVENT,

3752: IF Nvl(l_valid1,'N') <> 'Y'
3753: THEN
3754: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3755: THEN
3756: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3757: g_module_current
3758: || '.create_webadi_covered_levels',
3759: 'The Owner party of the contract subline and Owner party of the Instance are not the same.'
3760: );

Line 3776: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level

3772:
3773: IF Nvl(l_valid2,'N') <> 'Y'
3774: THEN
3775:
3776: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3777: THEN
3778: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3779: g_module_current
3780: || '.create_webadi_covered_levels',

Line 3778: fnd_log.STRING (fnd_log.LEVEL_EVENT,

3774: THEN
3775:
3776: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3777: THEN
3778: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3779: g_module_current
3780: || '.create_webadi_covered_levels',
3781: 'The product UOM code is invalid'
3782: );

Line 3798: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level

3794:
3795: IF Nvl(l_valid3,'N') <> 'Y'
3796: THEN
3797:
3798: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3799: THEN
3800: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3801: g_module_current
3802: || '.create_webadi_covered_levels',

Line 3800: fnd_log.STRING (fnd_log.LEVEL_EVENT,

3796: THEN
3797:
3798: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3799: THEN
3800: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3801: g_module_current
3802: || '.create_webadi_covered_levels',
3803: 'The contract subline cannot be associated to the Instance, with the specified Instance status.'
3804: );

Line 3820: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level

3816:
3817: IF Nvl(l_valid4,'N') <> 'Y'
3818: THEN
3819:
3820: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3821: THEN
3822: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3823: g_module_current
3824: || '.create_webadi_covered_levels',

Line 3822: fnd_log.STRING (fnd_log.LEVEL_EVENT,

3818: THEN
3819:
3820: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3821: THEN
3822: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3823: g_module_current
3824: || '.create_webadi_covered_levels',
3825: 'The Item is not a serviceable Item'
3826: );

Line 3844: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level

3840: l_lsl_id := 9;
3841: ELSIF kl_lse_id = 19 THEN
3842: l_lsl_id := 25;
3843: ELSE /*For any other line type the operation is not allowed.*/
3844: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3845: THEN
3846: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3847: g_module_current
3848: || '.create_webadi_covered_levels',

Line 3846: fnd_log.STRING (fnd_log.LEVEL_EVENT,

3842: l_lsl_id := 25;
3843: ELSE /*For any other line type the operation is not allowed.*/
3844: IF fnd_log.LEVEL_EVENT >= fnd_log.g_current_runtime_level
3845: THEN
3846: fnd_log.STRING (fnd_log.LEVEL_EVENT,
3847: g_module_current
3848: || '.create_webadi_covered_levels',
3849: 'Cannot add sublines to lines other than'
3850: || ' service/warranty lines.'

Line 3888: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3884: x_msg_data => x_msg_data,
3885: p_clev_tbl => l_clev_tbl_in,
3886: x_clev_tbl => l_clev_tbl_out
3887: );
3888: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3889: THEN
3890: fnd_log.STRING
3891: (fnd_log.level_event,
3892: g_module_current

Line 3890: fnd_log.STRING

3886: x_clev_tbl => l_clev_tbl_out
3887: );
3888: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3889: THEN
3890: fnd_log.STRING
3891: (fnd_log.level_event,
3892: g_module_current
3893: || '.Create_K_Covered_Levels.after_create.okc_subline',
3894: 'okc_contract_pub.create_contract_line(Return status = '

Line 3891: (fnd_log.level_event,

3887: );
3888: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3889: THEN
3890: fnd_log.STRING
3891: (fnd_log.level_event,
3892: g_module_current
3893: || '.Create_K_Covered_Levels.after_create.okc_subline',
3894: 'okc_contract_pub.create_contract_line(Return status = '
3895: || l_return_status

Line 3944: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3940: p_klnv_tbl => l_klnv_tbl_in,
3941: x_klnv_tbl => l_klnv_tbl_out,
3942: p_validate_yn => 'N'
3943: );
3944: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3945: THEN
3946: fnd_log.STRING
3947: (fnd_log.level_event,
3948: g_module_current

Line 3946: fnd_log.STRING

3942: p_validate_yn => 'N'
3943: );
3944: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3945: THEN
3946: fnd_log.STRING
3947: (fnd_log.level_event,
3948: g_module_current
3949: || '.Create_K_Covered_Levels.after_create.oks_subline',
3950: 'oks_contract_line_pub.create_line(Return status = '

Line 3947: (fnd_log.level_event,

3943: );
3944: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3945: THEN
3946: fnd_log.STRING
3947: (fnd_log.level_event,
3948: g_module_current
3949: || '.Create_K_Covered_Levels.after_create.oks_subline',
3950: 'oks_contract_line_pub.create_line(Return status = '
3951: || l_return_status

Line 3998: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3994: okc_cim_pvt.insert_row_upg (x_return_status => l_return_status,
3995: p_cimv_tbl => l_cimv_tbl
3996: );
3997:
3998: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3999: THEN
4000: fnd_log.STRING
4001: (fnd_log.level_event,
4002: g_module_current

Line 4000: fnd_log.STRING

3996: );
3997:
3998: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3999: THEN
4000: fnd_log.STRING
4001: (fnd_log.level_event,
4002: g_module_current
4003: || '.Create_K_Covered_Levels.after_create.contract_item',
4004: 'okc_cim_pvt.insert_row_upg(Return status = '

Line 4001: (fnd_log.level_event,

3997:
3998: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3999: THEN
4000: fnd_log.STRING
4001: (fnd_log.level_event,
4002: g_module_current
4003: || '.Create_K_Covered_Levels.after_create.contract_item',
4004: 'okc_cim_pvt.insert_row_upg(Return status = '
4005: || l_return_status