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_OC_INT_KTO_PVT dependencies on FND_FILE

Line 243: FND_FILE.PUT_LINE( FND_FILE.LOG, '==EXCEPTION=================');

239: IF okc_util.l_trace_flag OR okc_util.l_log_flag THEN
240: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: FND_FILE.PUT_LINE( FND_FILE.LOG, '==EXCEPTION=================');
244: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
245: p_encoded => 'F'
246: );
247: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

Line 247: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

243: FND_FILE.PUT_LINE( FND_FILE.LOG, '==EXCEPTION=================');
244: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
245: p_encoded => 'F'
246: );
247: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
248: FND_FILE.PUT_LINE( FND_FILE.LOG, '============================');
249: END IF;
250: END print_error;
251:

Line 248: FND_FILE.PUT_LINE( FND_FILE.LOG, '============================');

244: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
245: p_encoded => 'F'
246: );
247: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
248: FND_FILE.PUT_LINE( FND_FILE.LOG, '============================');
249: END IF;
250: END print_error;
251:
252: Function is_jtf_source_table( p_object_code jtf_objects_b.object_code%type,

Line 761: FND_FILE.PUT_LINE( FND_FILE.LOG,'inventory_item_id ='|| r_cle.object_id1);

757:
758: l_line_info_tab(l_idx) := r_cle;
759: /*************************************************************/
760:
761: FND_FILE.PUT_LINE( FND_FILE.LOG,'inventory_item_id ='|| r_cle.object_id1);
762:
763: /*************************************************************/
764: select description into l_item_name
765: from okx_system_items_v

Line 781: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Details for Top Line No = '||r_cle.line_number ||' '||'Item Name='||l_item_name);

777: -- duration is quantity AND period uom for service line
778: l_line_info_tab(l_idx).qty := rtrim(ltrim(l_svc_duration));
779: l_line_info_tab(l_idx).uom_code := rtrim(ltrim(l_svc_period));
780:
781: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Details for Top Line No = '||r_cle.line_number ||' '||'Item Name='||l_item_name);
782: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Details for Top Line No = '||r_cle.line_number||' '||'Item Name='||l_item_name);
783:
784:
785: --

Line 782: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Details for Top Line No = '||r_cle.line_number||' '||'Item Name='||l_item_name);

778: l_line_info_tab(l_idx).qty := rtrim(ltrim(l_svc_duration));
779: l_line_info_tab(l_idx).uom_code := rtrim(ltrim(l_svc_period));
780:
781: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Details for Top Line No = '||r_cle.line_number ||' '||'Item Name='||l_item_name);
782: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Details for Top Line No = '||r_cle.line_number||' '||'Item Name='||l_item_name);
783:
784:
785: --
786: -- Check and populate the top lines rules table

Line 796: FND_FILE.PUT_LINE( FND_FILE.LOG, 'After top lines build rules return status = '||lx_return_status);

792: x_line_attr_tab => lx_kl_attr_tab,
793: x_bto_data_rec => lx_kl_bto_data_rec,
794: x_sto_data_rec => lx_kl_sto_data_rec,
795: x_return_status => lx_return_status );
796: FND_FILE.PUT_LINE( FND_FILE.LOG, 'After top lines build rules return status = '||lx_return_status);
797:
798: IF lx_return_status = OKC_API.G_RET_STS_SUCCESS THEN
799: IF lx_kl_attr_tab.FIRST IS NOT NULL THEN
800: FOR i IN lx_kl_attr_tab.FIRST..lx_kl_attr_tab.LAST LOOP

Line 821: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO LINES');

817:
818: CLOSE c_top_cle;
819:
820: IF l_lines = 0 THEN
821: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO LINES');
822: okc_api.set_message(OKC_API.G_APP_NAME,
823: 'OKS_K2O_NOLINES',
824: 'KNUMBER',
825: l_k_nbr);

Line 831: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO ORDERABLE LINES');

827: print_error(4);
828: RAISE e_exit;
829: END IF;
830: IF l_idx = 0 THEN
831: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO ORDERABLE LINES');
832:
833: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO orderable lines');
834: okc_api.set_message(OKC_API.G_APP_NAME,
835: 'OKS_K2O_NOORDLINES',

Line 833: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO orderable lines');

829: END IF;
830: IF l_idx = 0 THEN
831: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO ORDERABLE LINES');
832:
833: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO orderable lines');
834: okc_api.set_message(OKC_API.G_APP_NAME,
835: 'OKS_K2O_NOORDLINES',
836: 'KNUMBER',
837: l_k_nbr);

Line 912: FND_FILE.PUT_LINE( FND_FILE.LOG, 'After order header salescredit');

908: px_qte_hdr_rec.party_id := l_cust.object1_id1;
909: px_qte_hdr_rec.original_system_reference := l_k_nbr;
910:
911:
912: FND_FILE.PUT_LINE( FND_FILE.LOG, 'After order header salescredit');
913:
914: IF l_kh_attr_tab.first IS NOT NULL THEN
915: FOR i IN l_kh_attr_tab.first..l_kh_attr_tab.last LOOP
916: IF l_kh_attr_tab(i).CUST_ACCT_ID IS NOT NULL THEN

Line 946: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before populating order header shipmentrecords = ');

942: END IF;
943:
944: -- Populate the shipment record
945: --
946: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before populating order header shipmentrecords = ');
947: IF l_kh_sto_data_tab.FIRST IS NOT NULL THEN
948: FOR i IN l_kh_sto_data_tab.FIRST..l_kh_sto_data_tab.LAST LOOP
949:
950: px_hd_shipment_tbl(i).ship_to_party_id := NVL(l_kh_sto_data_tab(i).party_id,l_cust.object1_id1);

Line 1056: FND_FILE.PUT_LINE( FND_FILE.LOG, 'in build order lines ');

1052:
1053:
1054: IF l_line_info_tab.first is not NULL THEN
1055:
1056: FND_FILE.PUT_LINE( FND_FILE.LOG, 'in build order lines ');
1057: FOR i IN l_line_info_tab.first..l_line_info_tab.last LOOP
1058:
1059: l_ql:=l_ql+1;
1060: px_qte_line_tbl(l_ql).operation_code := g_aso_op_code_create;

Line 1126: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before order line shipment = ');

1122: END IF;
1123: END LOOP;
1124: END IF;
1125:
1126: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before order line shipment = ');
1127: --
1128: -- obtain the ship to rule and the operation code
1129: --
1130: IF l_kl_sto_data_tab.COUNT > 0 THEN

Line 1205: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Detail Lines');

1201:
1202: END IF;
1203: END LOOP;
1204: IF l_nb_qte_line_dtl = 0 THEN
1205: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Detail Lines');
1206: END IF;
1207: ELSE
1208: null;
1209: END IF;

Line 1213: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Item type code = '||px_k2q_line_tbl(i).q_item_type_code);

1209: END IF;
1210:
1211:
1212: IF px_k2q_line_tbl.EXISTS(i) THEN
1213: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Item type code = '||px_k2q_line_tbl(i).q_item_type_code);
1214: END IF;
1215: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1216:
1217: END LOOP; -- qteline

Line 1215: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

1211:
1212: IF px_k2q_line_tbl.EXISTS(i) THEN
1213: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Item type code = '||px_k2q_line_tbl(i).q_item_type_code);
1214: END IF;
1215: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1216:
1217: END LOOP; -- qteline
1218: ELSE
1219: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Lines');

Line 1219: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Lines');

1215: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1216:
1217: END LOOP; -- qteline
1218: ELSE
1219: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Lines');
1220: END IF;
1221: EXCEPTION
1222: WHEN e_exit THEN
1223: null;

Line 1460: --FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);

1456: l_quote_ln_price_attr_tab.DELETE;
1457:
1458:
1459: l_init_msg_count:=fnd_msg_pub.count_msg;
1460: --FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
1462:
1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);
1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);

Line 1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*Subscription Contract to Order Creation**** ');

1457:
1458:
1459: l_init_msg_count:=fnd_msg_pub.count_msg;
1460: --FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
1462:
1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);
1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);
1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);

Line 1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);

1459: l_init_msg_count:=fnd_msg_pub.count_msg;
1460: --FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
1462:
1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);
1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);
1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);
1466: -- Bug 4915691 --
1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');

Line 1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);

1460: --FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
1462:
1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);
1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);
1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);
1466: -- Bug 4915691 --
1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');
1468: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id lo = '||p_contract_line_id_lo);

Line 1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);

1461: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************Subscription Contract to Order Creation****************** ');
1462:
1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);
1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);
1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);
1466: -- Bug 4915691 --
1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');
1468: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id lo = '||p_contract_line_id_lo);
1469: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id high = '||p_contract_line_id_hi);

Line 1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');

1463: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id = '||p_contract_id);
1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);
1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);
1466: -- Bug 4915691 --
1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');
1468: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id lo = '||p_contract_line_id_lo);
1469: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id high = '||p_contract_line_id_hi);
1470: -- Bug 4915691 --
1471:

Line 1468: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id lo = '||p_contract_line_id_lo);

1464: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id lo = '||p_contract_hdr_id_lo);
1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);
1466: -- Bug 4915691 --
1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');
1468: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id lo = '||p_contract_line_id_lo);
1469: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id high = '||p_contract_line_id_hi);
1470: -- Bug 4915691 --
1471:
1472:

Line 1469: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id high = '||p_contract_line_id_hi);

1465: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract id high= '||p_contract_hdr_id_hi);
1466: -- Bug 4915691 --
1467: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Lines Details ');
1468: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id lo = '||p_contract_line_id_lo);
1469: -- FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Line id high = '||p_contract_line_id_hi);
1470: -- Bug 4915691 --
1471:
1472:
1473: --

Line 1487: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '************************ ');

1483: l_elements_found:='Y';
1484:
1485: OPEN c_chr(get_elements_rec.dnz_chr_id);
1486: FETCH c_chr INTO l_chr;
1487: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '************************ ');
1488: FND_FILE.PUT_LINE( FND_FILE.LOG, '************************ ');
1489: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Contract Number = '||l_chr.contract_number);
1490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1491: IF c_chr%NOTFOUND THEN

Line 1488: FND_FILE.PUT_LINE( FND_FILE.LOG, '************************ ');

1484:
1485: OPEN c_chr(get_elements_rec.dnz_chr_id);
1486: FETCH c_chr INTO l_chr;
1487: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '************************ ');
1488: FND_FILE.PUT_LINE( FND_FILE.LOG, '************************ ');
1489: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Contract Number = '||l_chr.contract_number);
1490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1491: IF c_chr%NOTFOUND THEN
1492: okc_api.set_message(OKC_API.G_APP_NAME,'OKS_K2O_NOKHDR');

Line 1489: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Contract Number = '||l_chr.contract_number);

1485: OPEN c_chr(get_elements_rec.dnz_chr_id);
1486: FETCH c_chr INTO l_chr;
1487: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '************************ ');
1488: FND_FILE.PUT_LINE( FND_FILE.LOG, '************************ ');
1489: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Contract Number = '||l_chr.contract_number);
1490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1491: IF c_chr%NOTFOUND THEN
1492: okc_api.set_message(OKC_API.G_APP_NAME,'OKS_K2O_NOKHDR');
1493: CLOSE c_chr;

Line 1490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);

1486: FETCH c_chr INTO l_chr;
1487: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '************************ ');
1488: FND_FILE.PUT_LINE( FND_FILE.LOG, '************************ ');
1489: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Contract Number = '||l_chr.contract_number);
1490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Contract Number = '||l_chr.contract_number);
1491: IF c_chr%NOTFOUND THEN
1492: okc_api.set_message(OKC_API.G_APP_NAME,'OKS_K2O_NOKHDR');
1493: CLOSE c_chr;
1494: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before header cursor');

1567: */
1568: okc_context.set_okc_org_context(p_chr_id => get_elements_rec.dnz_chr_id);
1569: /******************************************************************/
1570:
1571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before header cursor');
1572: OPEN c_k_header(get_elements_rec.dnz_chr_id);
1573: FETCH c_k_header INTO l_k_header_rec;
1574: CLOSE c_k_header;
1575:

Line 1577: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before validate_k_eligibility');

1573: FETCH c_k_header INTO l_k_header_rec;
1574: CLOSE c_k_header;
1575:
1576:
1577: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before validate_k_eligibility');
1578:
1579: validate_k_eligibility(get_elements_rec.dnz_chr_id,
1580: -- p_rel_type,
1581: l_k_header_rec,

Line 1594: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before build_k_structures');

1590: /******************************************************************/
1591: --
1592: -- get the contract information
1593: --
1594: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before build_k_structures');
1595:
1596: build_k_structures(p_chr_id => get_elements_rec.dnz_chr_id,
1597: p_cle_id => get_elements_rec.dnz_cle_id,
1598: p_k_header_rec => l_k_header_rec,

Line 1612: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before build_order_hdr');

1608:
1609: --
1610: -- populate Order header record
1611: --
1612: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before build_order_hdr');
1613: build_order_hdr(px_qte_hdr_rec => l_qte_header_rec,
1614: p_contract_id => get_elements_rec.dnz_chr_id,
1615: px_hd_shipment_tbl => l_quote_hd_shipment_tab,
1616: x_return_status => l_return_status);

Line 1629: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before build_order_line');

1625: --
1626: -- populate Order lines table, line details
1627: --
1628:
1629: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before build_order_line');
1630: build_order_line(px_qte_line_tbl => l_quote_line_tab
1631: ,px_qte_hdr_rec => l_qte_header_rec
1632: ,px_qte_ln_shipment_tbl => l_quote_ln_shipment_tab
1633: ,px_qte_line_dtl_tbl => l_qte_line_dtl_tab

Line 1654: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before create order');

1650: l_control_rec.book_flag := FND_API.G_FALSE;
1651:
1652:
1653: fnd_profile.put('UNIQUE:SEQ_NUMBERS','A');
1654: FND_FILE.PUT_LINE( FND_FILE.LOG, 'before create order');
1655:
1656: ASO_ORDER_INT.Create_order(
1657: P_Api_Version => l_aso_api_version,
1658: P_Init_Msg_List => P_Init_Msg_List,

Line 1698: FND_FILE.PUT_LINE( FND_FILE.LOG, '********************** '); FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);

1694: IF l_return_status<>'S' Then
1695: l_create_order_flag:='N';
1696: END IF;
1697:
1698: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** '); FND_FILE.PUT_LINE( FND_FILE.LOG, '********************Order Number = '||lx_order_header_rec.order_number);
1699: FND_FILE.PUT_LINE( FND_FILE.LOG,'order create return status = '||l_return_status);
1700: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');
1701:
1702: IF lx_order_line_tbl.first IS NOT NULL THEN

Line 1699: FND_FILE.PUT_LINE( FND_FILE.LOG,'order create return status = '||l_return_status);

1695: l_create_order_flag:='N';
1696: END IF;
1697:
1698: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** '); FND_FILE.PUT_LINE( FND_FILE.LOG, '********************Order Number = '||lx_order_header_rec.order_number);
1699: FND_FILE.PUT_LINE( FND_FILE.LOG,'order create return status = '||l_return_status);
1700: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');
1701:
1702: IF lx_order_line_tbl.first IS NOT NULL THEN
1703: FOR i IN lx_order_line_tbl.first..lx_order_line_tbl.last LOOP

Line 1700: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');

1696: END IF;
1697:
1698: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** '); FND_FILE.PUT_LINE( FND_FILE.LOG, '********************Order Number = '||lx_order_header_rec.order_number);
1699: FND_FILE.PUT_LINE( FND_FILE.LOG,'order create return status = '||l_return_status);
1700: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');
1701:
1702: IF lx_order_line_tbl.first IS NOT NULL THEN
1703: FOR i IN lx_order_line_tbl.first..lx_order_line_tbl.last LOOP
1704:

Line 1710: fnd_file.put_line(FND_FILE.LOG, 'Order Header Id = '||lx_order_line_tbl(i).order_header_id);

1706: set order_header_id = lx_order_line_tbl(i).order_header_id
1707: ,order_line_id = lx_order_line_tbl(i).order_line_id
1708: where id= get_elements_rec.id;
1709:
1710: fnd_file.put_line(FND_FILE.LOG, 'Order Header Id = '||lx_order_line_tbl(i).order_header_id);
1711: fnd_file.put_line(FND_FILE.LOG, 'Order Line Id = '||lx_order_line_tbl(i).order_line_id);
1712: fnd_file.put_line(FND_FILE.LOG, 'Order line status = '||ltrim(rtrim(lx_order_line_tbl(i).status)));
1713:
1714: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before calling OE_ORDER_BOOK_UTIL ');

Line 1711: fnd_file.put_line(FND_FILE.LOG, 'Order Line Id = '||lx_order_line_tbl(i).order_line_id);

1707: ,order_line_id = lx_order_line_tbl(i).order_line_id
1708: where id= get_elements_rec.id;
1709:
1710: fnd_file.put_line(FND_FILE.LOG, 'Order Header Id = '||lx_order_line_tbl(i).order_header_id);
1711: fnd_file.put_line(FND_FILE.LOG, 'Order Line Id = '||lx_order_line_tbl(i).order_line_id);
1712: fnd_file.put_line(FND_FILE.LOG, 'Order line status = '||ltrim(rtrim(lx_order_line_tbl(i).status)));
1713:
1714: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before calling OE_ORDER_BOOK_UTIL ');
1715:

Line 1712: fnd_file.put_line(FND_FILE.LOG, 'Order line status = '||ltrim(rtrim(lx_order_line_tbl(i).status)));

1708: where id= get_elements_rec.id;
1709:
1710: fnd_file.put_line(FND_FILE.LOG, 'Order Header Id = '||lx_order_line_tbl(i).order_header_id);
1711: fnd_file.put_line(FND_FILE.LOG, 'Order Line Id = '||lx_order_line_tbl(i).order_line_id);
1712: fnd_file.put_line(FND_FILE.LOG, 'Order line status = '||ltrim(rtrim(lx_order_line_tbl(i).status)));
1713:
1714: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before calling OE_ORDER_BOOK_UTIL ');
1715:
1716: OE_Order_Book_Util.Complete_Book_Eligible

Line 1714: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before calling OE_ORDER_BOOK_UTIL ');

1710: fnd_file.put_line(FND_FILE.LOG, 'Order Header Id = '||lx_order_line_tbl(i).order_header_id);
1711: fnd_file.put_line(FND_FILE.LOG, 'Order Line Id = '||lx_order_line_tbl(i).order_line_id);
1712: fnd_file.put_line(FND_FILE.LOG, 'Order line status = '||ltrim(rtrim(lx_order_line_tbl(i).status)));
1713:
1714: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before calling OE_ORDER_BOOK_UTIL ');
1715:
1716: OE_Order_Book_Util.Complete_Book_Eligible
1717: ( p_api_version_number => 1.0
1718: , p_init_msg_list => okc_api.g_false

Line 1724: FND_FILE.PUT_LINE( FND_FILE.LOG,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date);

1720: , x_return_status => l_return_status
1721: , x_msg_count => l_msg_count
1722: , x_msg_data => l_msg_data);
1723: IF l_return_status ='S' THen
1724: FND_FILE.PUT_LINE( FND_FILE.LOG,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date);
1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);
1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);

Line 1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);

1721: , x_msg_count => l_msg_count
1722: , x_msg_data => l_msg_data);
1723: IF l_return_status ='S' THen
1724: FND_FILE.PUT_LINE( FND_FILE.LOG,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date);
1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);
1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);

Line 1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);

1722: , x_msg_data => l_msg_data);
1723: IF l_return_status ='S' THen
1724: FND_FILE.PUT_LINE( FND_FILE.LOG,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date);
1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);
1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);
1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');

Line 1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);

1723: IF l_return_status ='S' THen
1724: FND_FILE.PUT_LINE( FND_FILE.LOG,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date);
1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);
1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);
1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1731: ELSE

Line 1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);

1724: FND_FILE.PUT_LINE( FND_FILE.LOG,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date);
1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);
1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);
1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1731: ELSE
1732:

Line 1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);

1725: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'Schedule Start Date = '||get_elements_rec.start_date||' '||'Schedule End Date = '||get_elements_rec.end_date||' '|| 'OM Interface Date = '||get_elements_rec.om_interface_date);
1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);
1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1731: ELSE
1732:
1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);

Line 1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '* ');

1726: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Order Number = '||lx_order_header_rec.order_number);
1727: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Order Number = '||lx_order_header_rec.order_number);
1728: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);
1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1731: ELSE
1732:
1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1734: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');

Line 1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);

1729: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'order book return status = '||l_return_status);
1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1731: ELSE
1732:
1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1734: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1735: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Unable to CREATE and BOOK the order, please check the log files for error details');
1736: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1737: END IF;

Line 1734: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');

1730: FND_FILE.PUT_LINE( FND_FILE.LOG, '****************************************** ');FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1731: ELSE
1732:
1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1734: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1735: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Unable to CREATE and BOOK the order, please check the log files for error details');
1736: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1737: END IF;
1738: /*

Line 1735: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Unable to CREATE and BOOK the order, please check the log files for error details');

1731: ELSE
1732:
1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1734: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1735: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Unable to CREATE and BOOK the order, please check the log files for error details');
1736: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1737: END IF;
1738: /*
1739: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1736: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');

1732:
1733: FND_FILE.PUT_LINE( FND_FILE.LOG,'order book return status = '||l_return_status);
1734: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1735: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Unable to CREATE and BOOK the order, please check the log files for error details');
1736: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '***************************************** ');
1737: END IF;
1738: /*
1739: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1749: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Lines');

1745:
1746: END LOOP ;
1747:
1748: ELSE
1749: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO Order Lines');
1750: END IF;
1751:
1752: --
1753: -- Contract updating with order information waiting for

Line 1759: FND_FILE.PUT_LINE( FND_FILE.LOG,l_msg_data);

1755: --
1756:
1757: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
1758: l_return_status = OKC_API.G_RET_STS_ERROR THEN
1759: FND_FILE.PUT_LINE( FND_FILE.LOG,l_msg_data);
1760: l_ord_creation_date:=SYSDATE;
1761: ELSE
1762:
1763: SELECT creation_date,

Line 1846: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

1842: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
1843: p_encoded => 'F'
1844: );
1845: IF x_msg_data IS NOT NULL THEN
1846: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
1847: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1848: IF okc_util.l_output_flag THEN
1849: okc_util.print_output(0, 'Message : '||x_msg_data);
1850: okc_util.print_output(0, ' ');

Line 1847: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

1843: p_encoded => 'F'
1844: );
1845: IF x_msg_data IS NOT NULL THEN
1846: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
1847: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1848: IF okc_util.l_output_flag THEN
1849: okc_util.print_output(0, 'Message : '||x_msg_data);
1850: okc_util.print_output(0, ' ');
1851: END IF;

Line 1854: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

1850: okc_util.print_output(0, ' ');
1851: END IF;
1852: END IF;
1853: END LOOP;
1854: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
1855:
1856:
1857: -- IF l_create_order_flag='N' THEN
1858: EXIT;

Line 1910: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

1906: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
1907: p_encoded => 'F'
1908: );
1909: IF x_msg_data IS NOT NULL THEN
1910: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
1911: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1912: IF okc_util.l_output_flag THEN
1913: okc_util.print_output(0, 'Message : '||x_msg_data);
1914: okc_util.print_output(0, ' ');

Line 1911: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

1907: p_encoded => 'F'
1908: );
1909: IF x_msg_data IS NOT NULL THEN
1910: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
1911: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
1912: IF okc_util.l_output_flag THEN
1913: okc_util.print_output(0, 'Message : '||x_msg_data);
1914: okc_util.print_output(0, ' ');
1915: END IF;

Line 1918: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

1914: okc_util.print_output(0, ' ');
1915: END IF;
1916: END IF;
1917: END LOOP;
1918: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
1919:
1920:
1921: -- IF l_create_order_flag='N' THEN
1922: EXIT;

Line 1993: /* fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number);

1989: END LOOP; -----------get_elements cursor
1990: IF
1991: l_elements_found='N' Then
1992: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1993: /* fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number);
1994: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1995: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */
1997:

Line 1994: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

1990: IF
1991: l_elements_found='N' Then
1992: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1993: /* fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number);
1994: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1995: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */
1997:
1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */

Line 1995: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

1991: l_elements_found='N' Then
1992: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1993: /* fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number);
1994: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1995: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */
1997:
1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');

Line 1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */

1992: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1993: /* fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number);
1994: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1995: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */
1997:
1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');
2000: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

Line 1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');

1995: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */
1997:
1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');
2000: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2001: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2002: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced ');
2003:

Line 2000: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

1996: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced for the given Contract number'||' '||get_header_id_rec.contract_number); */
1997:
1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');
2000: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2001: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2002: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced ');
2003:
2004: END IF;

Line 2001: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

1997:
1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');
2000: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2001: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2002: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced ');
2003:
2004: END IF;
2005: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */

Line 2002: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced ');

1998: /* Modified by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
1999: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements to be interfaced ');
2000: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2001: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2002: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements to be interfaced ');
2003:
2004: END IF;
2005: /* Commented by sjanakir for Bug# 5568285 (FP Bug for 5442268) */
2006: /* END LOOP; -----------get_header_id cursor */

Line 2011: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements for the given Contract number');

2007: /* Comment Ends */
2008: /*
2009: iF
2010: l_elements_found='N' Then
2011: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements for the given Contract number');
2012: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2013: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2014: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements for the given Contract number');
2015:

Line 2012: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

2008: /*
2009: iF
2010: l_elements_found='N' Then
2011: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements for the given Contract number');
2012: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2013: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2014: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements for the given Contract number');
2015:
2016: END IF;

Line 2013: fnd_file.put_line(FND_FILE.OUTPUT, ' ');

2009: iF
2010: l_elements_found='N' Then
2011: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements for the given Contract number');
2012: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2013: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2014: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements for the given Contract number');
2015:
2016: END IF;
2017: */

Line 2014: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements for the given Contract number');

2010: l_elements_found='N' Then
2011: fnd_file.put_line(FND_FILE.LOG, 'No subscription elements for the given Contract number');
2012: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2013: fnd_file.put_line(FND_FILE.OUTPUT, ' ');
2014: fnd_file.put_line(FND_FILE.OUTPUT, 'No subscription elements for the given Contract number');
2015:
2016: END IF;
2017: */
2018: EXCEPTION

Line 2065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

2061: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2062: p_encoded => 'F'
2063: );
2064: IF x_msg_data IS NOT NULL THEN
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
2066: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2067: IF okc_util.l_output_flag THEN
2068: okc_util.print_output(0, 'Message : '||x_msg_data);
2069: okc_util.print_output(0, ' ');

Line 2066: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

2062: p_encoded => 'F'
2063: );
2064: IF x_msg_data IS NOT NULL THEN
2065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
2066: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2067: IF okc_util.l_output_flag THEN
2068: okc_util.print_output(0, 'Message : '||x_msg_data);
2069: okc_util.print_output(0, ' ');
2070: END IF;

Line 2073: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

2069: okc_util.print_output(0, ' ');
2070: END IF;
2071: END IF;
2072: END LOOP;
2073: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2075: IF c_k_header%ISOPEN THEN
2076: CLOSE c_k_header;
2077: END IF;

Line 2088: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

2084: );
2085: END IF;
2086:
2087: --Error messages for the trace file
2088: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2089: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2090: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2092: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

Line 2089: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

2085: END IF;
2086:
2087: --Error messages for the trace file
2088: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2089: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2090: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2092: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2093: --Error messages for the output file

Line 2090: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');

2086:
2087: --Error messages for the trace file
2088: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2089: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2090: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2092: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2093: --Error messages for the output file
2094: IF okc_util.l_output_flag THEN

Line 2091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);

2087: --Error messages for the trace file
2088: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2089: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2090: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2092: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2093: --Error messages for the output file
2094: IF okc_util.l_output_flag THEN
2095: OKC_API.set_message(p_app_name => g_app_name,

Line 2092: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

2088: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2089: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2090: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2092: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2093: --Error messages for the output file
2094: IF okc_util.l_output_flag THEN
2095: OKC_API.set_message(p_app_name => g_app_name,
2096: p_msg_name => 'OKS_K2O_K2OOUTEMSG',

Line 2124: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

2120: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2121: p_encoded => 'F'
2122: );
2123: IF x_msg_data IS NOT NULL THEN
2124: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
2125: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2126: IF okc_util.l_output_flag THEN
2127: okc_util.print_output(0, 'Message : '||x_msg_data);
2128: okc_util.print_output(0, ' ');

Line 2125: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

2121: p_encoded => 'F'
2122: );
2123: IF x_msg_data IS NOT NULL THEN
2124: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
2125: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2126: IF okc_util.l_output_flag THEN
2127: okc_util.print_output(0, 'Message : '||x_msg_data);
2128: okc_util.print_output(0, ' ');
2129: END IF;

Line 2148: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

2144: ,G_SQLERRM_TOKEN
2145: ,SQLERRM);
2146:
2147: --Error messages for the trace file
2148: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2149: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2152: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

Line 2149: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

2145: ,SQLERRM);
2146:
2147: --Error messages for the trace file
2148: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2149: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2152: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2153: --Error messages for the output file

Line 2150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');

2146:
2147: --Error messages for the trace file
2148: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2149: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2152: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2153: --Error messages for the output file
2154: IF okc_util.l_output_flag THEN

Line 2151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);

2147: --Error messages for the trace file
2148: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2149: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2152: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2153: --Error messages for the output file
2154: IF okc_util.l_output_flag THEN
2155: OKC_API.set_message(p_app_name => g_app_name,

Line 2152: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');

2148: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2149: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error while creating order:');
2151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Return status: '||x_return_status);
2152: FND_FILE.PUT_LINE( FND_FILE.LOG, '==================================');
2153: --Error messages for the output file
2154: IF okc_util.l_output_flag THEN
2155: OKC_API.set_message(p_app_name => g_app_name,
2156: p_msg_name => 'OKS_K2O_K2OOUTEMSG',

Line 2184: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);

2180: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2181: p_encoded => 'F'
2182: );
2183: IF x_msg_data IS NOT NULL THEN
2184: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
2185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2186: IF okc_util.l_output_flag THEN
2187: okc_util.print_output(0, 'Message : '||x_msg_data);
2188: okc_util.print_output(0, ' ');

Line 2185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

2181: p_encoded => 'F'
2182: );
2183: IF x_msg_data IS NOT NULL THEN
2184: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Message : '||x_msg_data);
2185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
2186: IF okc_util.l_output_flag THEN
2187: okc_util.print_output(0, 'Message : '||x_msg_data);
2188: okc_util.print_output(0, ' ');
2189: END IF;