APPS.CSP_PARTS_ORDER dependencies on FND_LOG

Line 512: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

508:
509: BEGIN
510: l_org_id := mo_global.get_current_org_id;
511:
512: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
514: 'l_org_id = ' || l_org_id);
515: end if;
516:

Line 513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

509: BEGIN
510: l_org_id := mo_global.get_current_org_id;
511:
512: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
514: 'l_org_id = ' || l_org_id);
515: end if;
516:
517: if l_org_id is null then

Line 522: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

518: po_moac_utils_pvt.INITIALIZE;
519: l_org_id := mo_global.get_current_org_id;
520: end if;
521:
522: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
523: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
524: 'l_org_id = ' || l_org_id);
525: end if;
526:

Line 523: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

519: l_org_id := mo_global.get_current_org_id;
520: end if;
521:
522: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
523: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
524: 'l_org_id = ' || l_org_id);
525: end if;
526:
527: po_moac_utils_pvt.set_org_context(l_org_id);

Line 536: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

532:
533: l_oe_header_id := p_header_rec.order_header_id;
534: l_line_tbl := p_line_table;
535:
536: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
538: 'l_oe_header_id = ' || l_oe_header_id);
539: end if;
540:

Line 537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

533: l_oe_header_id := p_header_rec.order_header_id;
534: l_line_tbl := p_line_table;
535:
536: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
538: 'l_oe_header_id = ' || l_oe_header_id);
539: end if;
540:
541: IF (p_process_type = 'REQUISITION') THEN

Line 584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

580: WHEN NO_DATA_FOUND THEN
581: RAISE NO_DATA_FOUND;
582: END;
583:
584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
586: 'l_source_operating_unit = ' || l_source_operating_unit);
587: end if;
588:

Line 585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

581: RAISE NO_DATA_FOUND;
582: END;
583:
584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
586: 'l_source_operating_unit = ' || l_source_operating_unit);
587: end if;
588:
589: IF (l_source_operating_unit <> l_org_id) THEN

Line 669: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

665: WHEN NO_DATA_FOUND THEN
666: RAISE NO_DATA_FOUND;
667: END;
668:
669: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
670: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
671: 'l_source_operating_unit = ' || l_source_operating_unit);
672: end if;
673:

Line 670: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

666: RAISE NO_DATA_FOUND;
667: END;
668:
669: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
670: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
671: 'l_source_operating_unit = ' || l_source_operating_unit);
672: end if;
673:
674: IF (l_source_operating_unit <> l_org_id) THEN

Line 756: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

752: -- Instruct API to retain its caches
753: l_oe_control_rec.clear_api_cache := FALSE;
754: l_oe_control_rec.clear_api_requests := FALSE;
755:
756: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
758: 'Starting OW Debug...');
759:
760: oe_debug_pub.G_FILE := NULL;

Line 757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

753: l_oe_control_rec.clear_api_cache := FALSE;
754: l_oe_control_rec.clear_api_requests := FALSE;
755:
756: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
758: 'Starting OW Debug...');
759:
760: oe_debug_pub.G_FILE := NULL;
761: oe_debug_pub.debug_on;

Line 765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

761: oe_debug_pub.debug_on;
762: oe_debug_pub.initialize;
763: oe_debug_pub.setdebuglevel(5);
764:
765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
766: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
767: end if;
768:
769: -- Call to Process Order

Line 807: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

803: ,x_msg_count => l_msg_count
804: ,x_msg_data => l_msg_data
805: );
806:
807: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
808: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
809: 'done ... with l_return_status = ' || l_return_status);
810: -- Stopping OE Debug...
811: oe_debug_pub.debug_off;

Line 808: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

804: ,x_msg_data => l_msg_data
805: );
806:
807: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
808: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
809: 'done ... with l_return_status = ' || l_return_status);
810: -- Stopping OE Debug...
811: oe_debug_pub.debug_off;
812: end if;

Line 915: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

911: l_oe_line_old_tbl(I).operation := null;
912: l_oe_line_Tbl(i).operation := null;
913: END LOOP;
914:
915: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
917: 'Starting OW Debug...');
918:
919: oe_debug_pub.G_FILE := NULL;

Line 916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

912: l_oe_line_Tbl(i).operation := null;
913: END LOOP;
914:
915: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
917: 'Starting OW Debug...');
918:
919: oe_debug_pub.G_FILE := NULL;
920: oe_debug_pub.debug_on;

Line 924: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

920: oe_debug_pub.debug_on;
921: oe_debug_pub.initialize;
922: oe_debug_pub.setdebuglevel(5);
923:
924: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
925: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
926: end if;
927:
928: -- call to Process Order

Line 966: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

962: ,x_msg_count => l_msg_count
963: ,x_msg_data => l_msg_data
964: );
965:
966: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
968: 'done ... with l_return_status = ' || l_return_status);
969: -- Stopping OE Debug...
970: oe_debug_pub.debug_off;

Line 967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

963: ,x_msg_data => l_msg_data
964: );
965:
966: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
968: 'done ... with l_return_status = ' || l_return_status);
969: -- Stopping OE Debug...
970: oe_debug_pub.debug_off;
971: end if;

Line 1012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1008: fnd_msg_pub.count_and_get
1009: ( p_count => x_msg_count
1010: , p_data => x_msg_data);
1011:
1012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1014: 'exiting with x_return_status = ' || x_return_status);
1015: end if;
1016:

Line 1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1009: ( p_count => x_msg_count
1010: , p_data => x_msg_data);
1011:
1012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1014: 'exiting with x_return_status = ' || x_return_status);
1015: end if;
1016:
1017: EXCEPTION

Line 1595: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1591: l_is_valid_order_type number;
1592:
1593: BEGIN
1594:
1595: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1597: 'csp.plsql.csp_parts_order.process_order',
1598: 'Begin');
1599: end if;

Line 1596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1592:
1593: BEGIN
1594:
1595: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1597: 'csp.plsql.csp_parts_order.process_order',
1598: 'Begin');
1599: end if;
1600:

Line 1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1620: l_user_id := nvl(fnd_global.user_id, 0) ;
1621: fnd_profile.get('RESP_ID',orig_resp_id);
1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1623:
1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1626: 'csp.plsql.csp_parts_order.process_order',
1627: 'l_user_id = ' || l_user_id
1628: || ', orig_resp_id = ' || orig_resp_id

Line 1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1621: fnd_profile.get('RESP_ID',orig_resp_id);
1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1623:
1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1626: 'csp.plsql.csp_parts_order.process_order',
1627: 'l_user_id = ' || l_user_id
1628: || ', orig_resp_id = ' || orig_resp_id
1629: || ', orig_resp_appl_id = ' || orig_resp_appl_id);

Line 1665: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1661:
1662: l_org_id := mo_global.get_current_org_id;
1663: l_first_org_id := l_org_id;
1664:
1665: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1667: 'csp.plsql.csp_parts_order.process_order',
1668: 'Original l_org_id from context = ' || l_org_id);
1669: end if;

Line 1666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1662: l_org_id := mo_global.get_current_org_id;
1663: l_first_org_id := l_org_id;
1664:
1665: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1667: 'csp.plsql.csp_parts_order.process_order',
1668: 'Original l_org_id from context = ' || l_org_id);
1669: end if;
1670:

Line 1684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1680: FND_MSG_PUB.ADD;
1681: RAISE EXCP_USER_DEFINED;
1682: END;
1683:
1684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1686: 'csp.plsql.csp_parts_order.process_order',
1687: 'l_dest_operating_unit = ' || l_dest_operating_unit);
1688: end if;

Line 1685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1681: RAISE EXCP_USER_DEFINED;
1682: END;
1683:
1684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1686: 'csp.plsql.csp_parts_order.process_order',
1687: 'l_dest_operating_unit = ' || l_dest_operating_unit);
1688: end if;
1689:

Line 1695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1691: and l_dest_operating_unit <> nvl(l_org_id, -999) then
1692:
1693: l_org_id := l_dest_operating_unit;
1694:
1695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1697: 'csp.plsql.csp_parts_order.process_order',
1698: 'l_org_id changed to = ' || l_org_id);
1699: end if;

Line 1696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1692:
1693: l_org_id := l_dest_operating_unit;
1694:
1695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1697: 'csp.plsql.csp_parts_order.process_order',
1698: 'l_org_id changed to = ' || l_org_id);
1699: end if;
1700:

Line 1706: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1702:
1703: po_moac_utils_pvt.set_org_context(l_org_id);
1704: l_sr_org_id := l_org_id;
1705:
1706: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1708: 'csp.plsql.csp_parts_order.process_order',
1709: 'Setting org context for l_org_id = ' || l_org_id);
1710: end if;

Line 1707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1703: po_moac_utils_pvt.set_org_context(l_org_id);
1704: l_sr_org_id := l_org_id;
1705:
1706: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1708: 'csp.plsql.csp_parts_order.process_order',
1709: 'Setting org context for l_org_id = ' || l_org_id);
1710: end if;
1711:

Line 1723: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1719: OPEN set_of_books_cur (l_org_id);
1720: FETCH set_of_books_cur INTO l_set_of_books_id;
1721: CLOSE set_of_books_cur;
1722:
1723: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1725: 'csp.plsql.csp_parts_order.process_order',
1726: 'l_header_rec.operation = ' || l_header_rec.operation);
1727: end if;

Line 1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1720: FETCH set_of_books_cur INTO l_set_of_books_id;
1721: CLOSE set_of_books_cur;
1722:
1723: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1725: 'csp.plsql.csp_parts_order.process_order',
1726: 'l_header_rec.operation = ' || l_header_rec.operation);
1727: end if;
1728:

Line 1743: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;
1741: ELSE
1742:
1743: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1745: 'csp.plsql.csp_parts_order.process_order',
1746: 'p_process_Type = ' || p_process_Type);
1747: end if;

Line 1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1740: END IF;
1741: ELSE
1742:
1743: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1745: 'csp.plsql.csp_parts_order.process_order',
1746: 'p_process_Type = ' || p_process_Type);
1747: end if;
1748:

Line 1757: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1753: OPEN address_type_cur(l_header_rec.requirement_header_id);
1754: FETCH address_type_cur INTO l_address_type, l_ship_to_location_id, l_resource_id, l_resource_type;
1755: CLOSE address_type_cur;
1756:
1757: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1759: 'csp.plsql.csp_parts_order.process_order',
1760: 'l_address_type = ' || l_address_type
1761: || ', l_ship_to_location_id = ' || l_ship_to_location_id

Line 1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1754: FETCH address_type_cur INTO l_address_type, l_ship_to_location_id, l_resource_id, l_resource_type;
1755: CLOSE address_type_cur;
1756:
1757: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1759: 'csp.plsql.csp_parts_order.process_order',
1760: 'l_address_type = ' || l_address_type
1761: || ', l_ship_to_location_id = ' || l_ship_to_location_id
1762: || ', l_resource_id = ' || l_resource_id

Line 1773: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1769:
1770: l_address_type := nvl(l_header_rec.address_type, l_address_type);
1771: l_ship_to_location_id := nvl(l_header_rec.ship_to_location_id, l_ship_to_location_id);
1772:
1773: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1774: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1775: 'csp.plsql.csp_parts_order.process_order',
1776: 'l_address_type = ' || l_address_type
1777: || ', l_ship_to_location_id = ' || l_ship_to_location_id);

Line 1774: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1770: l_address_type := nvl(l_header_rec.address_type, l_address_type);
1771: l_ship_to_location_id := nvl(l_header_rec.ship_to_location_id, l_ship_to_location_id);
1772:
1773: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1774: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1775: 'csp.plsql.csp_parts_order.process_order',
1776: 'l_address_type = ' || l_address_type
1777: || ', l_ship_to_location_id = ' || l_ship_to_location_id);
1778: end if;

Line 1872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1868: csp_requirement_headers_v req
1869: WHERE req.requirement_header_id = l_header_rec.requirement_header_id
1870: AND cia.incident_id = req.incident_id;
1871:
1872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1874: 'csp.plsql.csp_parts_order.process_order',
1875: 'l_sr_org_id = ' || l_sr_org_id);
1876: end if;

Line 1873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1869: WHERE req.requirement_header_id = l_header_rec.requirement_header_id
1870: AND cia.incident_id = req.incident_id;
1871:
1872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1874: 'csp.plsql.csp_parts_order.process_order',
1875: 'l_sr_org_id = ' || l_sr_org_id);
1876: end if;
1877:

Line 1926: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1922: WHERE CURRENT of req_number_cur;
1923: CLOSE req_number_cur;
1924: END IF;
1925:
1926: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1927: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1928: 'csp.plsql.csp_parts_order.process_order',
1929: 'l_header_rec.requisition_header_id = ' || l_header_rec.requisition_header_id
1930: || ', l_header_rec.requisition_number = ' || l_header_rec.requisition_number);

Line 1927: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1923: CLOSE req_number_cur;
1924: END IF;
1925:
1926: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1927: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1928: 'csp.plsql.csp_parts_order.process_order',
1929: 'l_header_rec.requisition_header_id = ' || l_header_rec.requisition_header_id
1930: || ', l_header_rec.requisition_number = ' || l_header_rec.requisition_number);
1931: end if;

Line 1939: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1935: OPEN employee_id_cur;
1936: FETCH employee_id_cur into l_employee_id;
1937: CLOSE employee_id_cur;
1938:
1939: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1940: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1941: 'csp.plsql.csp_parts_order.process_order',
1942: 'l_employee_id = ' || l_employee_id);
1943: end if;

Line 1940: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1936: FETCH employee_id_cur into l_employee_id;
1937: CLOSE employee_id_cur;
1938:
1939: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1940: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1941: 'csp.plsql.csp_parts_order.process_order',
1942: 'l_employee_id = ' || l_employee_id);
1943: end if;
1944:

Line 1951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1947: IF l_employee_id is null then
1948: FND_PROFILE.GET('CSP_EMPLOYEE_ID', l_employee_id);
1949: end if;
1950:
1951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1953: 'csp.plsql.csp_parts_order.process_order',
1954: 'l_employee_id = ' || l_employee_id);
1955: end if;

Line 1952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1948: FND_PROFILE.GET('CSP_EMPLOYEE_ID', l_employee_id);
1949: end if;
1950:
1951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1953: 'csp.plsql.csp_parts_order.process_order',
1954: 'l_employee_id = ' || l_employee_id);
1955: end if;
1956:

Line 1982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1978: po_message_s.sql_error('check_unique','010',sqlcode);
1979: raise;
1980: END;
1981:
1982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1984: 'csp.plsql.csp_parts_order.process_order',
1985: 'Inserting data into PO_REQUISITION_HEADERS');
1986: end if;

Line 1983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1979: raise;
1980: END;
1981:
1982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1984: 'csp.plsql.csp_parts_order.process_order',
1985: 'Inserting data into PO_REQUISITION_HEADERS');
1986: end if;
1987: -- create approved requisition headers

Line 2096: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2092: null,
2093: null
2094: );
2095:
2096: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2098: 'csp.plsql.csp_parts_order.process_order',
2099: 'Inserting data into PO_ACTION_HISTORY');
2100: end if;

Line 2097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2093: null
2094: );
2095:
2096: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2098: 'csp.plsql.csp_parts_order.process_order',
2099: 'Inserting data into PO_ACTION_HISTORY');
2100: end if;
2101: -- insert 2 lines of history, one for SUBMIT and one for APPROVE

Line 2145: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2141: '',
2142: null,
2143: '' );
2144:
2145: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2147: 'csp.plsql.csp_parts_order.process_order',
2148: 'Inserting data into PO_ACTION_HISTORY');
2149: end if;

Line 2146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2142: null,
2143: '' );
2144:
2145: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2147: 'csp.plsql.csp_parts_order.process_order',
2148: 'Inserting data into PO_ACTION_HISTORY');
2149: end if;
2150:

Line 2211: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2207: FND_MSG_PUB.ADD;
2208: RAISE EXCP_USER_DEFINED;
2209: END;
2210:
2211: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2213: 'csp.plsql.csp_parts_order.process_order',
2214: 'l_org_id = ' || l_org_id
2215: || ', l_source_operating_unit = ' || l_source_operating_unit);

Line 2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2208: RAISE EXCP_USER_DEFINED;
2209: END;
2210:
2211: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2213: 'csp.plsql.csp_parts_order.process_order',
2214: 'l_org_id = ' || l_org_id
2215: || ', l_source_operating_unit = ' || l_source_operating_unit);
2216: end if;

Line 2236: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2232: l_ship_to_contact_id := null;
2233: l_invoice_to_contact_id := null;
2234: END IF;
2235:
2236: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2238: 'csp.plsql.csp_parts_order.process_order',
2239: 'l_bill_to_site_use_id = ' || l_bill_to_site_use_id);
2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2233: l_invoice_to_contact_id := null;
2234: END IF;
2235:
2236: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2238: 'csp.plsql.csp_parts_order.process_order',
2239: 'l_bill_to_site_use_id = ' || l_bill_to_site_use_id);
2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2241: 'csp.plsql.csp_parts_order.process_order',

Line 2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2236: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2238: 'csp.plsql.csp_parts_order.process_order',
2239: 'l_bill_to_site_use_id = ' || l_bill_to_site_use_id);
2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2241: 'csp.plsql.csp_parts_order.process_order',
2242: 'l_ship_to_contact_id = ' || l_ship_to_contact_id);
2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2244: 'csp.plsql.csp_parts_order.process_order',

Line 2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2239: 'l_bill_to_site_use_id = ' || l_bill_to_site_use_id);
2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2241: 'csp.plsql.csp_parts_order.process_order',
2242: 'l_ship_to_contact_id = ' || l_ship_to_contact_id);
2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2244: 'csp.plsql.csp_parts_order.process_order',
2245: 'l_invoice_to_contact_id = ' || l_invoice_to_contact_id);
2246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2247: 'csp.plsql.csp_parts_order.process_order',

Line 2246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2242: 'l_ship_to_contact_id = ' || l_ship_to_contact_id);
2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2244: 'csp.plsql.csp_parts_order.process_order',
2245: 'l_invoice_to_contact_id = ' || l_invoice_to_contact_id);
2246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2247: 'csp.plsql.csp_parts_order.process_order',
2248: 'original l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
2249: end if;
2250:

Line 2263: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2259: FROM PO_SYSTEM_PARAMETERS_ALL
2260: WHERE ORG_ID = l_source_operating_unit;
2261: end if;
2262:
2263: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2265: 'csp.plsql.csp_parts_order.process_order',
2266: 'after validation l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
2267: end if;

Line 2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2260: WHERE ORG_ID = l_source_operating_unit;
2261: end if;
2262:
2263: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2265: 'csp.plsql.csp_parts_order.process_order',
2266: 'after validation l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
2267: end if;
2268:

Line 2297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2293: -- exception handler
2294: null;
2295: END;
2296:
2297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2299: 'csp.plsql.csp_parts_order.process_order',
2300: 'l_price_list_id = ' || l_price_list_id
2301: || ', l_currency_code = ' || l_currency_code

Line 2298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2294: null;
2295: END;
2296:
2297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2299: 'csp.plsql.csp_parts_order.process_order',
2300: 'l_price_list_id = ' || l_price_list_id
2301: || ', l_currency_code = ' || l_currency_code
2302: || ', l_order_line_type_id = ' || l_order_line_type_id

Line 2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2322:
2323: END;
2324: END IF;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2328: 'csp.plsql.csp_parts_order.process_order',
2329: 'l_currency_code = ' || l_currency_code);
2330: end if;

Line 2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2323: END;
2324: END IF;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2328: 'csp.plsql.csp_parts_order.process_order',
2329: 'l_currency_code = ' || l_currency_code);
2330: end if;
2331:

Line 2337: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2333: OPEN cust_site_cur;
2334: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
2335: CLOSE cust_site_cur;
2336:
2337: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2339: 'csp.plsql.csp_parts_order.process_order',
2340: 'l_customer_id = ' || l_customer_id
2341: || ', l_site_use_id = ' || l_site_use_id

Line 2338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2334: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
2335: CLOSE cust_site_cur;
2336:
2337: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2339: 'csp.plsql.csp_parts_order.process_order',
2340: 'l_customer_id = ' || l_customer_id
2341: || ', l_site_use_id = ' || l_site_use_id
2342: || ', l_cust_acct_id = ' || l_cust_acct_id);

Line 2353: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2349: OPEN get_cust_site_id;
2350: FETCH get_cust_site_id INTO l_cust_site_id, l_customer_id, l_party_site_id, l_tmp_org_id;
2351: CLOSE get_cust_site_id;
2352:
2353: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2355: 'csp.plsql.csp_parts_order.process_order',
2356: 'l_cust_site_id=' || l_cust_site_id
2357: || ', l_customer_id=' || l_customer_id

Line 2354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2350: FETCH get_cust_site_id INTO l_cust_site_id, l_customer_id, l_party_site_id, l_tmp_org_id;
2351: CLOSE get_cust_site_id;
2352:
2353: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2355: 'csp.plsql.csp_parts_order.process_order',
2356: 'l_cust_site_id=' || l_cust_site_id
2357: || ', l_customer_id=' || l_customer_id
2358: || ', l_party_site_id=' || l_party_site_id

Line 2369: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2365: open get_cust_site_id2;
2366: fetch get_cust_site_id2 into l_cust_site_id, l_customer_id, l_party_site_id, l_tmp_org_id, x_cust_acct_site_id;
2367: close get_cust_site_id2;
2368:
2369: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'csp.plsql.csp_parts_order.process_order',
2372: 'l_cust_site_id=' || l_cust_site_id
2373: || ', l_customer_id=' || l_customer_id

Line 2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2366: fetch get_cust_site_id2 into l_cust_site_id, l_customer_id, l_party_site_id, l_tmp_org_id, x_cust_acct_site_id;
2367: close get_cust_site_id2;
2368:
2369: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'csp.plsql.csp_parts_order.process_order',
2372: 'l_cust_site_id=' || l_cust_site_id
2373: || ', l_customer_id=' || l_customer_id
2374: || ', l_party_site_id=' || l_party_site_id

Line 2407: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2403: --dbms_application_info.set_client_info(l_org_id);
2404: RAISE FND_API.G_EXC_ERROR;
2405: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2406:
2407: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2409: 'csp.plsql.csp_parts_order.process_order',
2410: 'populated v_cust_acct_site_rec');
2411: end if;

Line 2408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2404: RAISE FND_API.G_EXC_ERROR;
2405: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2406:
2407: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2409: 'csp.plsql.csp_parts_order.process_order',
2410: 'populated v_cust_acct_site_rec');
2411: end if;
2412:

Line 2444: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2440: x_return_status := FND_API.G_RET_STS_ERROR;
2441: RAISE FND_API.G_EXC_ERROR;
2442: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2443:
2444: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2445: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2446: 'csp.plsql.csp_parts_order.process_order',
2447: 'x_cust_acct_site_id=' || x_cust_acct_site_id);
2448: end if;

Line 2445: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2441: RAISE FND_API.G_EXC_ERROR;
2442: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2443:
2444: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2445: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2446: 'csp.plsql.csp_parts_order.process_order',
2447: 'x_cust_acct_site_id=' || x_cust_acct_site_id);
2448: end if;
2449:

Line 2484: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2480: --dbms_application_info.set_client_info(l_org_id);
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2483:
2484: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2486: 'csp.plsql.csp_parts_order.process_order',
2487: 'populated v_cust_site_use_rec');
2488: end if;

Line 2485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2483:
2484: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2486: 'csp.plsql.csp_parts_order.process_order',
2487: 'populated v_cust_site_use_rec');
2488: end if;
2489:

Line 2505: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2501: open get_bill_site_id;
2502: fetch get_bill_site_id into v_bill_site_id;
2503: close get_bill_site_id;
2504:
2505: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2507: 'csp.plsql.csp_parts_order.process_order',
2508: 'v_bill_site_id = ' || v_bill_site_id);
2509: end if;

Line 2506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2502: fetch get_bill_site_id into v_bill_site_id;
2503: close get_bill_site_id;
2504:
2505: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2507: 'csp.plsql.csp_parts_order.process_order',
2508: 'v_bill_site_id = ' || v_bill_site_id);
2509: end if;
2510:

Line 2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RAISE FND_API.G_EXC_ERROR;
2540: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541:
2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2544: 'csp.plsql.csp_parts_order.process_order',
2545: 'populated v_bill_acct_site_rec');
2546: end if;

Line 2543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2539: RAISE FND_API.G_EXC_ERROR;
2540: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541:
2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2544: 'csp.plsql.csp_parts_order.process_order',
2545: 'populated v_bill_acct_site_rec');
2546: end if;
2547:

Line 2577: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576:
2577: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2579: 'csp.plsql.csp_parts_order.process_order',
2580: 'x_bill_acct_site_id=' || x_bill_acct_site_id);
2581: end if;

Line 2578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576:
2577: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2579: 'csp.plsql.csp_parts_order.process_order',
2580: 'x_bill_acct_site_id=' || x_bill_acct_site_id);
2581: end if;
2582:

Line 2613: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2612:
2613: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2615: 'csp.plsql.csp_parts_order.process_order',
2616: 'populated v_bill_site_use_rec');
2617: end if;

Line 2614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2612:
2613: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2615: 'csp.plsql.csp_parts_order.process_order',
2616: 'populated v_bill_site_use_rec');
2617: end if;
2618:

Line 2652: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2648: po_moac_utils_pvt.set_org_context(l_org_id);
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2651:
2652: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2654: 'csp.plsql.csp_parts_order.process_order',
2655: 'x_site_use_id=' || x_site_use_id);
2656: end if;

Line 2653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2651:
2652: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2654: 'csp.plsql.csp_parts_order.process_order',
2655: 'x_site_use_id=' || x_site_use_id);
2656: end if;
2657:

Line 2670: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2666: end if;
2667: end if;
2668: end if;
2669:
2670: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2672: 'csp.plsql.csp_parts_order.process_order',
2673: 'v_cust_site_use_rec.site_use_code=' || v_cust_site_use_rec.site_use_code
2674: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);

Line 2671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2667: end if;
2668: end if;
2669:
2670: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2672: 'csp.plsql.csp_parts_order.process_order',
2673: 'v_cust_site_use_rec.site_use_code=' || v_cust_site_use_rec.site_use_code
2674: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);
2675: end if;

Line 2714: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2710: if v_cust_site_use_rec.site_use_code = 'SHIP_TO' then
2711: temp_ship_to_use_id := x_site_use_id;
2712: end if;
2713:
2714: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2716: 'csp.plsql.csp_parts_order.process_order',
2717: 'x_site_use_id=' || x_site_use_id);
2718: end if;

Line 2715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2711: temp_ship_to_use_id := x_site_use_id;
2712: end if;
2713:
2714: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2716: 'csp.plsql.csp_parts_order.process_order',
2717: 'x_site_use_id=' || x_site_use_id);
2718: end if;
2719:

Line 2733: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2729: open get_new_cust_ids;
2730: fetch get_new_cust_ids into x_cust_acct_site_id, temp_ship_to_use_id;
2731: close get_new_cust_ids;
2732:
2733: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2735: 'csp.plsql.csp_parts_order.process_order',
2736: 'x_cust_acct_site_id=' || x_cust_acct_site_id
2737: || ', temp_ship_to_use_id=' || temp_ship_to_use_id);

Line 2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2730: fetch get_new_cust_ids into x_cust_acct_site_id, temp_ship_to_use_id;
2731: close get_new_cust_ids;
2732:
2733: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2735: 'csp.plsql.csp_parts_order.process_order',
2736: 'x_cust_acct_site_id=' || x_cust_acct_site_id
2737: || ', temp_ship_to_use_id=' || temp_ship_to_use_id);
2738: end if;

Line 2759: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2755: OPEN cust_site_cur;
2756: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
2757: CLOSE cust_site_cur;
2758:
2759: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2761: 'csp.plsql.csp_parts_order.process_order',
2762: 'l_customer_id=' || l_customer_id
2763: || ', l_site_use_id=' || l_site_use_id

Line 2760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2756: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
2757: CLOSE cust_site_cur;
2758:
2759: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2761: 'csp.plsql.csp_parts_order.process_order',
2762: 'l_customer_id=' || l_customer_id
2763: || ', l_site_use_id=' || l_site_use_id
2764: || ', l_cust_acct_id=' || l_cust_acct_id);

Line 2779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2775: fetch get_primary_bill_to into v_primary_bill_site_use_id, v_primary_bill_site_id;
2776: if get_primary_bill_to%notfound then
2777: close get_primary_bill_to;
2778:
2779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2781: 'csp.plsql.csp_parts_order.process_order',
2782: 'Primary Bill To is not available for source OU... Creating...');
2783: end if;

Line 2780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2776: if get_primary_bill_to%notfound then
2777: close get_primary_bill_to;
2778:
2779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2781: 'csp.plsql.csp_parts_order.process_order',
2782: 'Primary Bill To is not available for source OU... Creating...');
2783: end if;
2784:

Line 2793: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2789: open get_primary_bill_to(l_tmp_org_id);
2790: fetch get_primary_bill_to into v_primary_bill_site_use_id, v_primary_bill_site_id;
2791: close get_primary_bill_to;
2792:
2793: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2795: 'csp.plsql.csp_parts_order.process_order',
2796: 'v_primary_bill_site_use_id = ' || v_primary_bill_site_use_id
2797: || ', v_primary_bill_site_id = ' || v_primary_bill_site_id);

Line 2794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2790: fetch get_primary_bill_to into v_primary_bill_site_use_id, v_primary_bill_site_id;
2791: close get_primary_bill_to;
2792:
2793: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2795: 'csp.plsql.csp_parts_order.process_order',
2796: 'v_primary_bill_site_use_id = ' || v_primary_bill_site_use_id
2797: || ', v_primary_bill_site_id = ' || v_primary_bill_site_id);
2798: end if;

Line 2823: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2819: x_return_status := FND_API.G_RET_STS_ERROR;
2820: RAISE FND_API.G_EXC_ERROR;
2821: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2822:
2823: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2825: 'csp.plsql.csp_parts_order.process_order',
2826: 'populated v_pri_bill_acct_site_rec');
2827: end if;

Line 2824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2820: RAISE FND_API.G_EXC_ERROR;
2821: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2822:
2823: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2825: 'csp.plsql.csp_parts_order.process_order',
2826: 'populated v_pri_bill_acct_site_rec');
2827: end if;
2828:

Line 2858: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: RAISE FND_API.G_EXC_ERROR;
2856: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2857:
2858: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2860: 'csp.plsql.csp_parts_order.process_order',
2861: 'x_bill_acct_site_id=' || x_pri_bill_acct_site_id);
2862: end if;

Line 2859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2855: RAISE FND_API.G_EXC_ERROR;
2856: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2857:
2858: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2860: 'csp.plsql.csp_parts_order.process_order',
2861: 'x_bill_acct_site_id=' || x_pri_bill_acct_site_id);
2862: end if;
2863:

Line 2888: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2884: x_return_status := FND_API.G_RET_STS_ERROR;
2885: RAISE FND_API.G_EXC_ERROR;
2886: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2887:
2888: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2890: 'csp.plsql.csp_parts_order.process_order',
2891: 'populated v_pri_bill_site_use_rec');
2892: end if;

Line 2889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2885: RAISE FND_API.G_EXC_ERROR;
2886: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2887:
2888: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2890: 'csp.plsql.csp_parts_order.process_order',
2891: 'populated v_pri_bill_site_use_rec');
2892: end if;
2893:

Line 2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2923: po_moac_utils_pvt.set_org_context(l_org_id);
2924: RAISE FND_API.G_EXC_ERROR;
2925: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2929: 'csp.plsql.csp_parts_order.process_order',
2930: 'x_site_use_id=' || x_site_use_id);
2931: end if;

Line 2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2924: RAISE FND_API.G_EXC_ERROR;
2925: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2929: 'csp.plsql.csp_parts_order.process_order',
2930: 'x_site_use_id=' || x_site_use_id);
2931: end if;
2932: else

Line 2945: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2941: into l_header_rec.order_header_id
2942: from dual;
2943: END IF;
2944:
2945: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2947: 'csp.plsql.csp_parts_order.process_order',
2948: 'l_header_rec.order_header_id = ' || l_header_rec.order_header_id);
2949: end if;

Line 2946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2942: from dual;
2943: END IF;
2944:
2945: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2947: 'csp.plsql.csp_parts_order.process_order',
2948: 'l_header_rec.order_header_id = ' || l_header_rec.order_header_id);
2949: end if;
2950:

Line 2978: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2974: l_oe_header_rec.ship_to_contact_id := l_ship_to_contact_id_final;
2975: end if;
2976: end if;
2977:
2978: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2980: 'csp.plsql.csp_parts_order.process_order',
2981: 'l_oe_header_rec.ship_to_contact_id = ' || l_oe_header_rec.ship_to_contact_id);
2982: end if;

Line 2979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2975: end if;
2976: end if;
2977:
2978: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2980: 'csp.plsql.csp_parts_order.process_order',
2981: 'l_oe_header_rec.ship_to_contact_id = ' || l_oe_header_rec.ship_to_contact_id);
2982: end if;
2983:

Line 2995: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2991: l_oe_header_rec.INVOICE_TO_CONTACT_ID := l_invoice_to_contact_id_final;
2992: end if;
2993: end if;
2994:
2995: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2997: 'csp.plsql.csp_parts_order.process_order',
2998: 'l_oe_header_rec.INVOICE_TO_CONTACT_ID = ' || l_oe_header_rec.INVOICE_TO_CONTACT_ID);
2999: end if;

Line 2996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2992: end if;
2993: end if;
2994:
2995: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2997: 'csp.plsql.csp_parts_order.process_order',
2998: 'l_oe_header_rec.INVOICE_TO_CONTACT_ID = ' || l_oe_header_rec.INVOICE_TO_CONTACT_ID);
2999: end if;
3000:

Line 3022: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3018: -- bug 8220079
3019: l_oe_header_rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
3020:
3021:
3022: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3023: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3024: 'csp.plsql.csp_parts_order.process_order',
3025: 'l_oe_header_rec.shipping_method_code = ' || l_oe_header_rec.shipping_method_code);
3026: end if;

Line 3023: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3019: l_oe_header_rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
3020:
3021:
3022: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3023: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3024: 'csp.plsql.csp_parts_order.process_order',
3025: 'l_oe_header_rec.shipping_method_code = ' || l_oe_header_rec.shipping_method_code);
3026: end if;
3027:

Line 3147: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3143: OPEN unit_of_measure_cur(l_line_tbl(i).unit_of_measure);
3144: FETCH unit_of_measure_cur INTO l_unit_meas_lookup_code;
3145: CLOSE unit_of_measure_cur;
3146:
3147: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3149: 'csp.plsql.csp_parts_order.process_order',
3150: 'Getting Unit Price...');
3151: end if;

Line 3148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3144: FETCH unit_of_measure_cur INTO l_unit_meas_lookup_code;
3145: CLOSE unit_of_measure_cur;
3146:
3147: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3149: 'csp.plsql.csp_parts_order.process_order',
3150: 'Getting Unit Price...');
3151: end if;
3152:

Line 3163: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3159: ,l_currency_code
3160: ,l_unit_price
3161: ,l_item_cost );
3162:
3163: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3165: 'csp.plsql.csp_parts_order.process_order',
3166: 'Inserting data into PO_REQUISITION_LINES...');
3167: end if;

Line 3164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3160: ,l_unit_price
3161: ,l_item_cost );
3162:
3163: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3165: 'csp.plsql.csp_parts_order.process_order',
3166: 'Inserting data into PO_REQUISITION_LINES...');
3167: end if;
3168:

Line 3265: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3261: l_dist_rec.gl_encumbered_date := l_today;
3262: l_dist_rec.prevent_encumbrance_flag := 'N';
3263: --s_chart_of_accounts_id := 101;
3264:
3265: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3267: 'csp.plsql.csp_parts_order.process_order',
3268: 'l_header_rec.dest_organization_id = ' || l_header_rec.dest_organization_id);
3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3262: l_dist_rec.prevent_encumbrance_flag := 'N';
3263: --s_chart_of_accounts_id := 101;
3264:
3265: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3267: 'csp.plsql.csp_parts_order.process_order',
3268: 'l_header_rec.dest_organization_id = ' || l_header_rec.dest_organization_id);
3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3270: 'csp.plsql.csp_parts_order.process_order',

Line 3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3265: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3267: 'csp.plsql.csp_parts_order.process_order',
3268: 'l_header_rec.dest_organization_id = ' || l_header_rec.dest_organization_id);
3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3270: 'csp.plsql.csp_parts_order.process_order',
3271: 'l_line_tbl(i).inventory_item_id = ' || l_line_tbl(i).inventory_item_id);
3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3273: 'csp.plsql.csp_parts_order.process_order',

Line 3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3268: 'l_header_rec.dest_organization_id = ' || l_header_rec.dest_organization_id);
3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3270: 'csp.plsql.csp_parts_order.process_order',
3271: 'l_line_tbl(i).inventory_item_id = ' || l_line_tbl(i).inventory_item_id);
3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3273: 'csp.plsql.csp_parts_order.process_order',
3274: 'l_line_Tbl(i).dest_subinventory = ' || l_line_Tbl(i).dest_subinventory);
3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.csp_parts_order.process_order',

Line 3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3271: 'l_line_tbl(i).inventory_item_id = ' || l_line_tbl(i).inventory_item_id);
3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3273: 'csp.plsql.csp_parts_order.process_order',
3274: 'l_line_Tbl(i).dest_subinventory = ' || l_line_Tbl(i).dest_subinventory);
3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.csp_parts_order.process_order',
3277: 'l_header_rec.dest_subinventory = ' || l_header_rec.dest_subinventory);
3278: end if;
3279:

Line 3287: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3283: l_line_tbl(i).inventory_item_id,
3284: nvl(l_line_Tbl(i).dest_subinventory, l_header_rec.dest_subinventory)); -- bug # 12433536 scheduler does not pass l_line_Tbl(i).dest_subinventory
3285:
3286:
3287: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.csp_parts_order.process_order',
3290: 'Checking Valid Account Id...');
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3284: nvl(l_line_Tbl(i).dest_subinventory, l_header_rec.dest_subinventory)); -- bug # 12433536 scheduler does not pass l_line_Tbl(i).dest_subinventory
3285:
3286:
3287: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.csp_parts_order.process_order',
3290: 'Checking Valid Account Id...');
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.csp_parts_order.process_order',

Line 3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3287: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.csp_parts_order.process_order',
3290: 'Checking Valid Account Id...');
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.csp_parts_order.process_order',
3293: 'l_dist_rec.code_combination_id = '
3294: || l_dist_rec.code_combination_id);
3295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.csp_parts_order.process_order',
3293: 'l_dist_rec.code_combination_id = '
3294: || l_dist_rec.code_combination_id);
3295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3296: 'csp.plsql.csp_parts_order.process_order',
3297: 'l_dist_rec.gl_encumbered_date = '
3298: || to_char(l_dist_rec.gl_encumbered_date, 'DD-MON-YYYY HH24:MI:SS'));
3299: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3299: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3296: 'csp.plsql.csp_parts_order.process_order',
3297: 'l_dist_rec.gl_encumbered_date = '
3298: || to_char(l_dist_rec.gl_encumbered_date, 'DD-MON-YYYY HH24:MI:SS'));
3299: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3300: 'csp.plsql.csp_parts_order.process_order',
3301: 'l_chart_of_accounts_id = '
3302: || l_chart_of_accounts_id);
3303: end if;

Line 3368: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3364: ELSE
3365: l_dist_rec.gl_encumbered_date := '';
3366: END IF;
3367:
3368: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3370: 'csp.plsql.csp_parts_order.process_order',
3371: 'prevent_encumbrance_flag = ' || l_dist_rec.prevent_encumbrance_flag
3372: || ', encumbered_flag = ' || l_dist_rec.encumbered_flag);

Line 3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3365: l_dist_rec.gl_encumbered_date := '';
3366: END IF;
3367:
3368: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3370: 'csp.plsql.csp_parts_order.process_order',
3371: 'prevent_encumbrance_flag = ' || l_dist_rec.prevent_encumbrance_flag
3372: || ', encumbered_flag = ' || l_dist_rec.encumbered_flag);
3373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3370: 'csp.plsql.csp_parts_order.process_order',
3371: 'prevent_encumbrance_flag = ' || l_dist_rec.prevent_encumbrance_flag
3372: || ', encumbered_flag = ' || l_dist_rec.encumbered_flag);
3373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3374: 'csp.plsql.csp_parts_order.process_order',
3375: 'Inserting data into po_req_distributions ...');
3376: end if;
3377:

Line 3526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3522: into l_line_tbl(i).order_line_id
3523: from dual;
3524: END IF;
3525:
3526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3528: 'csp.plsql.csp_parts_order.process_order',
3529: 'l_line_tbl(i).order_line_id ('
3530: || to_char(i) || ') = ' || l_line_tbl(i).order_line_id);

Line 3527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3523: from dual;
3524: END IF;
3525:
3526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3528: 'csp.plsql.csp_parts_order.process_order',
3529: 'l_line_tbl(i).order_line_id ('
3530: || to_char(i) || ') = ' || l_line_tbl(i).order_line_id);
3531: end if;

Line 3559: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3555: END IF;
3556: l_oe_line_rec.request_date := nvl(l_header_rec.need_by_date,sysdate);
3557:
3558:
3559: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3561: 'csp.plsql.csp_parts_order.process_order',
3562: 'l_line_tbl(i).arrival_date = ' || l_line_tbl(i).arrival_date);
3563: end if;

Line 3560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3556: l_oe_line_rec.request_date := nvl(l_header_rec.need_by_date,sysdate);
3557:
3558:
3559: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3561: 'csp.plsql.csp_parts_order.process_order',
3562: 'l_line_tbl(i).arrival_date = ' || l_line_tbl(i).arrival_date);
3563: end if;
3564:

Line 3571: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3567: l_oe_line_rec.actual_arrival_date := l_line_tbl(i).arrival_date;
3568: --l_oe_line_rec.request_date := l_line_tbl(i).arrival_date;
3569: end if;
3570:
3571: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3573: 'csp.plsql.csp_parts_order.process_order',
3574: 'l_oe_line_rec.promise_date = ' || l_oe_line_rec.promise_date);
3575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3568: --l_oe_line_rec.request_date := l_line_tbl(i).arrival_date;
3569: end if;
3570:
3571: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3573: 'csp.plsql.csp_parts_order.process_order',
3574: 'l_oe_line_rec.promise_date = ' || l_oe_line_rec.promise_date);
3575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3576: 'csp.plsql.csp_parts_order.process_order',

Line 3575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3571: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3573: 'csp.plsql.csp_parts_order.process_order',
3574: 'l_oe_line_rec.promise_date = ' || l_oe_line_rec.promise_date);
3575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3576: 'csp.plsql.csp_parts_order.process_order',
3577: 'l_oe_line_rec.request_date = ' || l_oe_line_rec.request_date);
3578: end if;
3579:

Line 3604: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3600: l_oe_line_rec.source_document_line_id := l_line_tbl(i).requisition_line_id;
3601: l_oe_line_rec.ship_set := l_line_tbl(i).ship_complete;
3602: l_oe_line_Rec.shipping_method_code := nvl(l_line_tbl(i).shipping_method_code, FND_API.G_MISS_CHAR);
3603:
3604: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3606: 'csp.plsql.csp_parts_order.process_order',
3607: 'l_oe_line_Rec.shipping_method_code = ' || l_oe_line_Rec.shipping_method_code);
3608: end if;

Line 3605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3601: l_oe_line_rec.ship_set := l_line_tbl(i).ship_complete;
3602: l_oe_line_Rec.shipping_method_code := nvl(l_line_tbl(i).shipping_method_code, FND_API.G_MISS_CHAR);
3603:
3604: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3606: 'csp.plsql.csp_parts_order.process_order',
3607: 'l_oe_line_Rec.shipping_method_code = ' || l_oe_line_Rec.shipping_method_code);
3608: end if;
3609:

Line 3717: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3713: END IF;
3714: */
3715: BEGIN
3716:
3717: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3719: 'csp.plsql.csp_parts_order.process_order',
3720: 'Deleting record from mtl_supply...');
3721: end if;

Line 3718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3714: */
3715: BEGIN
3716:
3717: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3719: 'csp.plsql.csp_parts_order.process_order',
3720: 'Deleting record from mtl_supply...');
3721: end if;
3722:

Line 3736: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3732: AND pl.line_location_id IS NULL
3733: )
3734: AND ms1.supply_type_code = 'REQ';
3735:
3736: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3738: 'csp.plsql.csp_parts_order.process_order',
3739: 'Inserting data into mtl_supply...');
3740: end if;

Line 3737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3733: )
3734: AND ms1.supply_type_code = 'REQ';
3735:
3736: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3738: 'csp.plsql.csp_parts_order.process_order',
3739: 'Inserting data into mtl_supply...');
3740: end if;
3741:

Line 3842: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3838: new_user := substr(ltrim(new_user, new_user_id), 3);
3839: new_resp_id := substr(new_user, 1, instr(new_user, '~') - 1);
3840: new_resp_appl_id := substr(ltrim(new_user, new_resp_id), 3);
3841:
3842: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3844: 'csp.plsql.csp_parts_order.process_order',
3845: 'new_user = ' || new_user
3846: || ', new_user_id = ' || new_user_id

Line 3843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3839: new_resp_id := substr(new_user, 1, instr(new_user, '~') - 1);
3840: new_resp_appl_id := substr(ltrim(new_user, new_resp_id), 3);
3841:
3842: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3844: 'csp.plsql.csp_parts_order.process_order',
3845: 'new_user = ' || new_user
3846: || ', new_user_id = ' || new_user_id
3847: || ', new_resp_id = ' || new_resp_id

Line 3875: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3871: -- Use the default settings
3872: l_oe_control_rec.controlled_operation := FALSE;
3873: l_oe_control_rec.default_Attributes := TRUE;
3874:
3875: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3877: 'csp.plsql.csp_parts_order.process_order',
3878: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
3879: || l_oe_header_rec.operation);

Line 3876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3872: l_oe_control_rec.controlled_operation := FALSE;
3873: l_oe_control_rec.default_Attributes := TRUE;
3874:
3875: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3877: 'csp.plsql.csp_parts_order.process_order',
3878: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
3879: || l_oe_header_rec.operation);
3880: end if;

Line 3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3887:
3888: if nvl(p_book_order, 'Y') = 'Y' then
3889: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3890: end if;
3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
3893: 'start calling requirement order dff hook...');
3894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3895: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

Line 3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

3888: if nvl(p_book_order, 'Y') = 'Y' then
3889: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3890: end if;
3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
3893: 'start calling requirement order dff hook...');
3894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3895: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3896: 'Values of before calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||

Line 3894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3890: end if;
3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
3893: 'start calling requirement order dff hook...');
3894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3895: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3896: 'Values of before calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||
3897: 'Attribute 2 : ' || px_header_rec.ATTRIBUTE2 || ' , ' ||
3898: 'Attribute 3 : ' || px_header_rec.ATTRIBUTE3 || ' , ' ||

Line 3911: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3907: 'Attribute 12: ' || px_header_rec.ATTRIBUTE12 || ' , ' ||
3908: 'Attribute 13: ' || px_header_rec.ATTRIBUTE13 || ' , ' ||
3909: 'Attribute 14: ' || px_header_rec.ATTRIBUTE14 || ' , ' ||
3910: 'Attribute 15: ' || px_header_rec.ATTRIBUTE15);
3911: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3912: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3913: 'Values of before calling the hook api OE Header : Attribute 1: ' || l_oe_header_rec.ATTRIBUTE1 || ' , ' ||
3914: 'Attribute 2: ' || l_oe_header_rec.ATTRIBUTE2 || ' , ' ||
3915: 'Attribute 3: ' || l_oe_header_rec.ATTRIBUTE3 || ' , ' ||

Line 3929: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3925: 'Attribute 13:' || l_oe_header_rec.ATTRIBUTE13 || ' , ' ||
3926: 'Attribute 14: ' || l_oe_header_rec.ATTRIBUTE14 || ' , ' ||
3927: 'Attribute 15: ' || l_oe_header_rec.ATTRIBUTE15);
3928: for k in 1..px_line_table.count loop
3929: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3930: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3931: 'Values of before calling the hook api PR Line' || k || ': Attribute 1: ' || px_line_table(k).ATTRIBUTE1 || ' , ' ||
3932: 'Attribute 2: ' || px_line_table(k).ATTRIBUTE2 || ' , ' ||
3933: 'Attribute 3: ' || px_line_table(k).ATTRIBUTE3 || ' , ' ||

Line 3948: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3944: 'Attribute 14: ' || px_line_table(k).ATTRIBUTE14 || ' , ' ||
3945: 'Attribute 15: ' || px_line_table(k).ATTRIBUTE15);
3946: end loop;
3947: for k in 1..l_oe_line_tbl.count loop
3948: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3949: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3950: 'Values of before calling the hook api OE Line' || k || ': Attribute 1: ' || l_oe_line_tbl(k).ATTRIBUTE1 || ' , ' ||
3951: 'Attribute 2: ' || l_oe_line_tbl(k).ATTRIBUTE2 || ' , ' ||
3952: 'Attribute 3: ' || l_oe_line_tbl(k).ATTRIBUTE3 || ' , ' ||

Line 3973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3969: px_req_header_rec => px_header_rec
3970: ,px_req_line_table => px_line_table
3971: ,px_oe_header_rec => l_oe_header_rec
3972: ,px_oe_line_table => l_oe_line_tbl);
3973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3975: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3976: 'Values of after calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||
3977: 'Attribute 2 : ' || px_header_rec.ATTRIBUTE2 || ' , ' ||

Line 3974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3970: ,px_req_line_table => px_line_table
3971: ,px_oe_header_rec => l_oe_header_rec
3972: ,px_oe_line_table => l_oe_line_tbl);
3973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3975: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3976: 'Values of after calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||
3977: 'Attribute 2 : ' || px_header_rec.ATTRIBUTE2 || ' , ' ||
3978: 'Attribute 3 : ' || px_header_rec.ATTRIBUTE3 || ' , ' ||

Line 3991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3987: 'Attribute 12: ' || px_header_rec.ATTRIBUTE12 || ' , ' ||
3988: 'Attribute 13: ' || px_header_rec.ATTRIBUTE13 || ' , ' ||
3989: 'Attribute 14: ' || px_header_rec.ATTRIBUTE14 || ' , ' ||
3990: 'Attribute 15: ' || px_header_rec.ATTRIBUTE15);
3991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3992: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3993: 'Values of after calling the hook api OE Header : Attribute 1: ' || l_oe_header_rec.ATTRIBUTE1 || ' , ' ||
3994: 'Attribute 2: ' || l_oe_header_rec.ATTRIBUTE2 || ' , ' ||
3995: 'Attribute 3: ' || l_oe_header_rec.ATTRIBUTE3 || ' , ' ||

Line 4009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4005: 'Attribute 13:' || l_oe_header_rec.ATTRIBUTE13 || ' , ' ||
4006: 'Attribute 14: ' || l_oe_header_rec.ATTRIBUTE14 || ' , ' ||
4007: 'Attribute 15: ' || l_oe_header_rec.ATTRIBUTE15);
4008: for k in 1..px_line_table.count loop
4009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4010: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
4011: 'Values of after calling the hook api PR Line' || k || ': Attribute 1: ' || px_line_table(k).ATTRIBUTE1 || ' , ' ||
4012: 'Attribute 2: ' || px_line_table(k).ATTRIBUTE2 || ' , ' ||
4013: 'Attribute 3: ' || px_line_table(k).ATTRIBUTE3 || ' , ' ||

Line 4028: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4024: 'Attribute 14: ' || px_line_table(k).ATTRIBUTE14 || ' , ' ||
4025: 'Attribute 15: ' || px_line_table(k).ATTRIBUTE15);
4026: end loop;
4027: for k in 1..l_oe_line_tbl.count loop
4028: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4029: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
4030: 'Values of after calling the hook api OE Line' || k || ': Attribute 1: ' || l_oe_line_tbl(k).ATTRIBUTE1 || ' , ' ||
4031: 'Attribute 2: ' || l_oe_line_tbl(k).ATTRIBUTE2 || ' , ' ||
4032: 'Attribute 3: ' || l_oe_line_tbl(k).ATTRIBUTE3 || ' , ' ||

Line 4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4042: 'Attribute 13: ' || l_oe_line_tbl(k).ATTRIBUTE13 || ' , ' ||
4043: 'Attribute 14: ' || l_oe_line_tbl(k).ATTRIBUTE14 || ' , ' ||
4044: 'Attribute 15: ' || l_oe_line_tbl(k).ATTRIBUTE15);
4045: end loop;
4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4047: 'end of calling requirement order dff hook...');
4048: end if;
4049: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

Line 4049: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4045: end loop;
4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4047: 'end of calling requirement order dff hook...');
4048: end if;
4049: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4051: 'Starting OW Debug...');
4052:
4053: oe_debug_pub.G_FILE := NULL;

Line 4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4047: 'end of calling requirement order dff hook...');
4048: end if;
4049: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4051: 'Starting OW Debug...');
4052:
4053: oe_debug_pub.G_FILE := NULL;
4054: oe_debug_pub.debug_on;

Line 4058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4054: oe_debug_pub.debug_on;
4055: oe_debug_pub.initialize;
4056: oe_debug_pub.setdebuglevel(5);
4057:
4058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4059: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
4060:
4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4062: 'l_line_tbl.count = '|| l_line_tbl.count);

Line 4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4057:
4058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4059: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
4060:
4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4062: 'l_line_tbl.count = '|| l_line_tbl.count);
4063: end if;
4064:
4065: OE_Order_PUB.Process_Order(

Line 4139: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4135: ,x_msg_data => l_msg_data
4136: );
4137: END IF;
4138:
4139: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4141: 'Stopping OE debug ...');
4142: oe_debug_pub.debug_off;
4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

Line 4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4136: );
4137: END IF;
4138:
4139: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4141: 'Stopping OE debug ...');
4142: oe_debug_pub.debug_off;
4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4144: 'l_return_status = ' || l_return_status);

Line 4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4139: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4141: 'Stopping OE debug ...');
4142: oe_debug_pub.debug_off;
4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4144: 'l_return_status = ' || l_return_status);
4145: end if;
4146:
4147: -- dbms_application_info.set_client_info(l_org_id);

Line 4168: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4164: , p_data => x_msg_data);
4165: End loop;
4166: x_return_status := FND_API.G_RET_STS_ERROR;
4167:
4168: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4169: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4170: 'csp.plsql.csp_parts_order.process_order',
4171: 'Error in OE_Order_PUB.Process_Order API... Message = '
4172: || l_msg);

Line 4169: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4165: End loop;
4166: x_return_status := FND_API.G_RET_STS_ERROR;
4167:
4168: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4169: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4170: 'csp.plsql.csp_parts_order.process_order',
4171: 'Error in OE_Order_PUB.Process_Order API... Message = '
4172: || l_msg);
4173: end if;

Line 4253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4249: if x_return_status is null then
4250: x_return_status := FND_API.G_RET_STS_SUCCESS;
4251: end if;
4252:
4253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4255: 'csp.plsql.csp_parts_order.process_order',
4256: 'process_order API returning with x_return_status = ' || x_return_status);
4257: end if;

Line 4254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4250: x_return_status := FND_API.G_RET_STS_SUCCESS;
4251: end if;
4252:
4253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4255: 'csp.plsql.csp_parts_order.process_order',
4256: 'process_order API returning with x_return_status = ' || x_return_status);
4257: end if;
4258:

Line 4429: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4425: -- changed for bug 11847583
4426: BEGIN
4427: l_org_id := mo_global.get_current_org_id;
4428:
4429: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4431: 'Original l_org_id from context = ' || l_org_id);
4432: end if;
4433:

Line 4430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',

4426: BEGIN
4427: l_org_id := mo_global.get_current_org_id;
4428:
4429: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4431: 'Original l_org_id from context = ' || l_org_id);
4432: end if;
4433:
4434: BEGIN

Line 4447: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4443: FND_MSG_PUB.ADD;
4444: RAISE EXCP_USER_DEFINED;
4445: END;
4446:
4447: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4449: 'l_dest_operating_unit = ' || l_dest_operating_unit);
4450: end if;
4451:

Line 4448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',

4444: RAISE EXCP_USER_DEFINED;
4445: END;
4446:
4447: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4449: 'l_dest_operating_unit = ' || l_dest_operating_unit);
4450: end if;
4451:
4452: if l_dest_operating_unit is not null and l_dest_operating_unit <> nvl(l_org_id, -999) then

Line 4455: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4451:
4452: if l_dest_operating_unit is not null and l_dest_operating_unit <> nvl(l_org_id, -999) then
4453: l_org_id := l_dest_operating_unit;
4454:
4455: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4457: 'l_org_id changed to = ' || l_org_id);
4458: end if;
4459: end if;

Line 4456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',

4452: if l_dest_operating_unit is not null and l_dest_operating_unit <> nvl(l_org_id, -999) then
4453: l_org_id := l_dest_operating_unit;
4454:
4455: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4457: 'l_org_id changed to = ' || l_org_id);
4458: end if;
4459: end if;
4460: po_moac_utils_pvt.set_org_context(l_org_id);

Line 4772: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4768: lx_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4769:
4770: begin
4771:
4772: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4773: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4774: 'Begin...');
4775: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4776: 'p_oe_header_id = ' || p_oe_header_id);

Line 4773: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4769:
4770: begin
4771:
4772: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4773: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4774: 'Begin...');
4775: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4776: 'p_oe_header_id = ' || p_oe_header_id);
4777: end if;

Line 4775: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4771:
4772: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4773: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4774: 'Begin...');
4775: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4776: 'p_oe_header_id = ' || p_oe_header_id);
4777: end if;
4778:
4779: select org_id into l_org_id from oe_order_headers_all where header_id = p_oe_header_id;

Line 4782: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4778:
4779: select org_id into l_org_id from oe_order_headers_all where header_id = p_oe_header_id;
4780: l_org_org_id := mo_global.get_current_org_id;
4781:
4782: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4784: 'l_org_id = ' || l_org_id);
4785: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4786: 'l_org_org_id = ' || l_org_org_id);

Line 4783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4779: select org_id into l_org_id from oe_order_headers_all where header_id = p_oe_header_id;
4780: l_org_org_id := mo_global.get_current_org_id;
4781:
4782: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4784: 'l_org_id = ' || l_org_id);
4785: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4786: 'l_org_org_id = ' || l_org_org_id);
4787: end if;

Line 4785: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4781:
4782: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4784: 'l_org_id = ' || l_org_id);
4785: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4786: 'l_org_org_id = ' || l_org_org_id);
4787: end if;
4788:
4789: if l_org_org_id is null then

Line 4794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4790: po_moac_utils_pvt.INITIALIZE;
4791: l_org_org_id := mo_global.get_current_org_id;
4792: end if;
4793:
4794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4796: 'l_org_id = ' || l_org_id);
4797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4798: 'l_org_org_id = ' || l_org_org_id);

Line 4795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4791: l_org_org_id := mo_global.get_current_org_id;
4792: end if;
4793:
4794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4796: 'l_org_id = ' || l_org_id);
4797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4798: 'l_org_org_id = ' || l_org_org_id);
4799: end if;

Line 4797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4793:
4794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4796: 'l_org_id = ' || l_org_id);
4797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4798: 'l_org_org_id = ' || l_org_org_id);
4799: end if;
4800:
4801: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then

Line 4802: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4798: 'l_org_org_id = ' || l_org_org_id);
4799: end if;
4800:
4801: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then
4802: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4803: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4804: 'changing context to l_org_id = ' || l_org_id);
4805: end if;
4806: po_moac_utils_pvt.set_org_context(l_org_id);

Line 4803: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4799: end if;
4800:
4801: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then
4802: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4803: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4804: 'changing context to l_org_id = ' || l_org_id);
4805: end if;
4806: po_moac_utils_pvt.set_org_context(l_org_id);
4807: end if;

Line 4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4845: x_action_request_tbl => lx_action_request_tbl
4846: );
4847:
4848: if l_org_id <> l_org_org_id then
4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4851: 'changing context to l_org_org_id = ' || l_org_org_id);
4852: end if;
4853: po_moac_utils_pvt.set_org_context(l_org_org_id);

Line 4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4846: );
4847:
4848: if l_org_id <> l_org_org_id then
4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4851: 'changing context to l_org_org_id = ' || l_org_org_id);
4852: end if;
4853: po_moac_utils_pvt.set_org_context(l_org_org_id);
4854: end if;

Line 4856: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4852: end if;
4853: po_moac_utils_pvt.set_org_context(l_org_org_id);
4854: end if;
4855:
4856: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4858: 'After calling OE_ORDER_PUB.process_order ...');
4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4860: 'x_return_status = ' || x_return_status);

Line 4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4853: po_moac_utils_pvt.set_org_context(l_org_org_id);
4854: end if;
4855:
4856: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4858: 'After calling OE_ORDER_PUB.process_order ...');
4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4860: 'x_return_status = ' || x_return_status);
4861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4855:
4856: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4858: 'After calling OE_ORDER_PUB.process_order ...');
4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4860: 'x_return_status = ' || x_return_status);
4861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4862: 'x_msg_count = ' || x_msg_count);
4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4858: 'After calling OE_ORDER_PUB.process_order ...');
4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4860: 'x_return_status = ' || x_return_status);
4861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4862: 'x_msg_count = ' || x_msg_count);
4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4864: 'x_msg_data = ' || x_msg_data);
4865: end if;

Line 4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4860: 'x_return_status = ' || x_return_status);
4861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4862: 'x_msg_count = ' || x_msg_count);
4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4864: 'x_msg_data = ' || x_msg_data);
4865: end if;
4866:
4867: if x_return_status = FND_API.G_RET_STS_SUCCESS then

Line 4927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4923: AND csp.location_source = 'HR';
4924:
4925: BEGIN
4926:
4927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4929: 'Begin...');
4930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4931: 'p_oe_line_id = ' || p_oe_line_id

Line 4928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4924:
4925: BEGIN
4926:
4927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4929: 'Begin...');
4930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4931: 'p_oe_line_id = ' || p_oe_line_id
4932: || ', p_ship_method = ' || p_ship_method);

Line 4930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4926:
4927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4929: 'Begin...');
4930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4931: 'p_oe_line_id = ' || p_oe_line_id
4932: || ', p_ship_method = ' || p_ship_method);
4933: end if;
4934:

Line 4938: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4934:
4935: select org_id into l_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4936: l_org_org_id := mo_global.get_current_org_id;
4937:
4938: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4940: 'l_org_id = ' || l_org_id);
4941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4942: 'l_org_org_id = ' || l_org_org_id);

Line 4939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4935: select org_id into l_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4936: l_org_org_id := mo_global.get_current_org_id;
4937:
4938: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4940: 'l_org_id = ' || l_org_id);
4941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4942: 'l_org_org_id = ' || l_org_org_id);
4943: end if;

Line 4941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4937:
4938: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4940: 'l_org_id = ' || l_org_id);
4941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4942: 'l_org_org_id = ' || l_org_org_id);
4943: end if;
4944:
4945: if l_org_org_id is null then

Line 4950: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4946: po_moac_utils_pvt.INITIALIZE;
4947: l_org_org_id := mo_global.get_current_org_id;
4948: end if;
4949:
4950: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4951: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4952: 'l_org_id = ' || l_org_id);
4953: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4954: 'l_org_org_id = ' || l_org_org_id);

Line 4951: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4947: l_org_org_id := mo_global.get_current_org_id;
4948: end if;
4949:
4950: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4951: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4952: 'l_org_id = ' || l_org_id);
4953: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4954: 'l_org_org_id = ' || l_org_org_id);
4955: end if;

Line 4953: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4949:
4950: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4951: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4952: 'l_org_id = ' || l_org_id);
4953: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4954: 'l_org_org_id = ' || l_org_org_id);
4955: end if;
4956:
4957: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then

Line 4958: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4954: 'l_org_org_id = ' || l_org_org_id);
4955: end if;
4956:
4957: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then
4958: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4959: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4960: 'changing context to l_org_id = ' || l_org_id);
4961: end if;
4962: po_moac_utils_pvt.set_org_context(l_org_id);

Line 4959: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4955: end if;
4956:
4957: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then
4958: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4959: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4960: 'changing context to l_org_id = ' || l_org_id);
4961: end if;
4962: po_moac_utils_pvt.set_org_context(l_org_id);
4963: end if;

Line 4973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4969:
4970: -- bug # 12664116
4971: select ship_from_org_id into l_ship_from_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4972:
4973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4975: 'l_ship_from_org_id = ' || l_ship_from_org_id);
4976: end if;
4977:

Line 4974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4970: -- bug # 12664116
4971: select ship_from_org_id into l_ship_from_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4972:
4973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4975: 'l_ship_from_org_id = ' || l_ship_from_org_id);
4976: end if;
4977:
4978: open c_get_arrival_date;

Line 4982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4978: open c_get_arrival_date;
4979: fetch c_get_arrival_date into l_arrival_date;
4980: close c_get_arrival_date;
4981:
4982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4984: 'l_arrival_date = ' || to_char(nvl(l_arrival_date, sysdate), 'DD-MON-YYYY HH24:MI:SS'));
4985: end if;
4986:

Line 4983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4979: fetch c_get_arrival_date into l_arrival_date;
4980: close c_get_arrival_date;
4981:
4982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4984: 'l_arrival_date = ' || to_char(nvl(l_arrival_date, sysdate), 'DD-MON-YYYY HH24:MI:SS'));
4985: end if;
4986:
4987: if l_arrival_date is not null then

Line 4994: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4990: --l_line_tbl(1).request_date := l_arrival_date;
4991: end if;
4992:
4993:
4994: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4996: 'Starting OW Debug...');
4997:
4998: oe_debug_pub.G_FILE := NULL;

Line 4995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4991: end if;
4992:
4993:
4994: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4996: 'Starting OW Debug...');
4997:
4998: oe_debug_pub.G_FILE := NULL;
4999: oe_debug_pub.debug_on;

Line 5003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

4999: oe_debug_pub.debug_on;
5000: oe_debug_pub.initialize;
5001: oe_debug_pub.setdebuglevel(5);
5002:
5003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5004: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
5005:
5006: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5007: 'l_line_tbl.count = '|| l_line_tbl.count);

Line 5006: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5002:
5003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5004: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
5005:
5006: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5007: 'l_line_tbl.count = '|| l_line_tbl.count);
5008: end if;
5009:
5010: OE_ORDER_PUB.process_order(

Line 5047: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5043: x_action_request_tbl => lx_action_request_tbl
5044: );
5045:
5046: if l_org_id <> l_org_org_id then
5047: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5049: 'changing context to l_org_org_id = ' || l_org_org_id);
5050: end if;
5051: po_moac_utils_pvt.set_org_context(l_org_org_id);

Line 5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5044: );
5045:
5046: if l_org_id <> l_org_org_id then
5047: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5049: 'changing context to l_org_org_id = ' || l_org_org_id);
5050: end if;
5051: po_moac_utils_pvt.set_org_context(l_org_org_id);
5052: end if;

Line 5054: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5050: end if;
5051: po_moac_utils_pvt.set_org_context(l_org_org_id);
5052: end if;
5053:
5054: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5056: 'After calling OE_ORDER_PUB.process_order ...');
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5058: 'x_return_status = ' || x_return_status);

Line 5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5051: po_moac_utils_pvt.set_org_context(l_org_org_id);
5052: end if;
5053:
5054: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5056: 'After calling OE_ORDER_PUB.process_order ...');
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5058: 'x_return_status = ' || x_return_status);
5059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5053:
5054: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5056: 'After calling OE_ORDER_PUB.process_order ...');
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5058: 'x_return_status = ' || x_return_status);
5059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5060: 'x_msg_count = ' || x_msg_count);
5061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5056: 'After calling OE_ORDER_PUB.process_order ...');
5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5058: 'x_return_status = ' || x_return_status);
5059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5060: 'x_msg_count = ' || x_msg_count);
5061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5062: 'x_msg_data = ' || x_msg_data);
5063:

Line 5061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5058: 'x_return_status = ' || x_return_status);
5059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5060: 'x_msg_count = ' || x_msg_count);
5061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5062: 'x_msg_data = ' || x_msg_data);
5063:
5064: -- Stopping OE Debug...
5065: oe_debug_pub.debug_off;

Line 5155: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5151: WHERE source_type= 'IO'
5152: AND source_id = v_oe_line_id;
5153:
5154: BEGIN
5155: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5157: 'Begin...');
5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5159: 'p_req_header_id = ' || p_req_header_id

Line 5156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5152: AND source_id = v_oe_line_id;
5153:
5154: BEGIN
5155: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5157: 'Begin...');
5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5159: 'p_req_header_id = ' || p_req_header_id
5160: || ', p_new_hr_loc_id = ' || p_new_hr_loc_id

Line 5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5154: BEGIN
5155: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5157: 'Begin...');
5158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5159: 'p_req_header_id = ' || p_req_header_id
5160: || ', p_new_hr_loc_id = ' || p_new_hr_loc_id
5161: || ', p_update_req_header = ' || p_update_req_header
5162: || ', p_new_add_type = ' || p_new_add_type);

Line 5170: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5166: open check_io_status;
5167: fetch check_io_status into l_booked_orders;
5168: close check_io_status;
5169:
5170: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5172: 'l_booked_orders = ' || l_booked_orders);
5173: end if;
5174:

Line 5171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5167: fetch check_io_status into l_booked_orders;
5168: close check_io_status;
5169:
5170: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5172: 'l_booked_orders = ' || l_booked_orders);
5173: end if;
5174:
5175: if l_booked_orders > 0 then

Line 5180: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5176: open get_booked_order_num;
5177: fetch get_booked_order_num into l_booked_orders;
5178: close get_booked_order_num;
5179:
5180: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5182: 'Raising error as l_booked_orders > 0 ');
5183: end if;
5184:

Line 5181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5177: fetch get_booked_order_num into l_booked_orders;
5178: close get_booked_order_num;
5179:
5180: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5182: 'Raising error as l_booked_orders > 0 ');
5183: end if;
5184:
5185: FND_MESSAGE.SET_NAME('CSP', 'CSP_NO-SHIP_CNG_BOOK_IO');

Line 5206: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5202: open get_req_header_data;
5203: fetch get_req_header_data into l_dest_org_id, l_dest_subinv, l_need_by_date;
5204: close get_req_header_data;
5205:
5206: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5208: 'Fetched data from req header... ');
5209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5210: 'l_dest_org_id = ' || l_dest_org_id

Line 5207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5203: fetch get_req_header_data into l_dest_org_id, l_dest_subinv, l_need_by_date;
5204: close get_req_header_data;
5205:
5206: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5208: 'Fetched data from req header... ');
5209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5210: 'l_dest_org_id = ' || l_dest_org_id
5211: || ', l_dest_subinv = ' || l_dest_subinv

Line 5209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5205:
5206: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5208: 'Fetched data from req header... ');
5209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5210: 'l_dest_org_id = ' || l_dest_org_id
5211: || ', l_dest_subinv = ' || l_dest_subinv
5212: || ', l_need_by_date = ' || l_need_by_date);
5213: end if;

Line 5217: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5213: end if;
5214:
5215: -- lets get orders which we need to cancel
5216:
5217: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5219: 'fetching orders to be cancelled...');
5220: end if;
5221:

Line 5218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5214:
5215: -- lets get orders which we need to cancel
5216:
5217: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5219: 'fetching orders to be cancelled...');
5220: end if;
5221:
5222: for cr in get_order_header_ids loop

Line 5231: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5227: -- value will be picked from the profile CSP_CANCEL_REASON
5228: fnd_profile.get('CSP_CANCEL_REASON', l_cancel_reason);
5229: l_header_can_rec.change_reason := l_cancel_reason;
5230:
5231: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5233: 'processing l_header_can_rec.order_header_id = ' || l_header_can_rec.order_header_id);
5234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5235: 'l_header_can_rec.change_reason = ' || l_header_can_rec.change_reason);

Line 5232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5228: fnd_profile.get('CSP_CANCEL_REASON', l_cancel_reason);
5229: l_header_can_rec.change_reason := l_cancel_reason;
5230:
5231: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5233: 'processing l_header_can_rec.order_header_id = ' || l_header_can_rec.order_header_id);
5234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5235: 'l_header_can_rec.change_reason = ' || l_header_can_rec.change_reason);
5236: end if;

Line 5234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5230:
5231: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5233: 'processing l_header_can_rec.order_header_id = ' || l_header_can_rec.order_header_id);
5234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5235: 'l_header_can_rec.change_reason = ' || l_header_can_rec.change_reason);
5236: end if;
5237:
5238: oe_header_util.Query_Row(

Line 5242: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5238: oe_header_util.Query_Row(
5239: p_header_id => cr.header_id,
5240: x_header_rec => l_oe_header_rec);
5241:
5242: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5244: 'fetched l_oe_header_rec...');
5245: end if;
5246:

Line 5243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5239: p_header_id => cr.header_id,
5240: x_header_rec => l_oe_header_rec);
5241:
5242: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5244: 'fetched l_oe_header_rec...');
5245: end if;
5246:
5247: l_header_rec.dest_organization_id := l_dest_org_id;

Line 5261: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5257: oe_line_util.Query_Rows(
5258: p_header_id => cr.header_id,
5259: x_line_tbl => l_oe_line_tbl);
5260:
5261: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5263: 'fetched l_oe_line_tbl...');
5264: end if;
5265:

Line 5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5258: p_header_id => cr.header_id,
5259: x_line_tbl => l_oe_line_tbl);
5260:
5261: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5263: 'fetched l_oe_line_tbl...');
5264: end if;
5265:
5266: l_req_line_dtl_rec := CSP_REQ_LINE_DETAILS_PVT.G_MISS_Req_Line_Details_TBL;

Line 5269: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5265:
5266: l_req_line_dtl_rec := CSP_REQ_LINE_DETAILS_PVT.G_MISS_Req_Line_Details_TBL;
5267: for i in 1..l_oe_line_tbl.count loop
5268:
5269: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5271: 'processing line # ' || i
5272: || ' for item_id = ' || l_oe_line_tbl(i).inventory_item_id);
5273: end if;

Line 5270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5266: l_req_line_dtl_rec := CSP_REQ_LINE_DETAILS_PVT.G_MISS_Req_Line_Details_TBL;
5267: for i in 1..l_oe_line_tbl.count loop
5268:
5269: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5270: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5271: 'processing line # ' || i
5272: || ' for item_id = ' || l_oe_line_tbl(i).inventory_item_id);
5273: end if;
5274:

Line 5288: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5284: l_lines_tbl(i).unit_of_measure := l_oe_line_tbl(i).order_quantity_uom;
5285: --l_lines_tbl(i).arrival_date := l_oe_line_tbl(i).request_date;
5286: l_lines_tbl(i).line_num := i;
5287:
5288: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5290: 'l_oe_line_tbl(i).line_id = ' || l_oe_line_tbl(i).line_id);
5291: end if;
5292:

Line 5289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5285: --l_lines_tbl(i).arrival_date := l_oe_line_tbl(i).request_date;
5286: l_lines_tbl(i).line_num := i;
5287:
5288: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5290: 'l_oe_line_tbl(i).line_id = ' || l_oe_line_tbl(i).line_id);
5291: end if;
5292:
5293: open get_req_line_id(l_oe_line_tbl(i).line_id);

Line 5297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5293: open get_req_line_id(l_oe_line_tbl(i).line_id);
5294: fetch get_req_line_id into l_req_line_id, l_req_line_dtl_id;
5295: close get_req_line_id;
5296:
5297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5299: 'l_req_line_id = ' || l_req_line_id);
5300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5301: 'l_req_line_dtl_id = ' || l_req_line_dtl_id);

Line 5298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5294: fetch get_req_line_id into l_req_line_id, l_req_line_dtl_id;
5295: close get_req_line_id;
5296:
5297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5299: 'l_req_line_id = ' || l_req_line_id);
5300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5301: 'l_req_line_dtl_id = ' || l_req_line_dtl_id);
5302: end if;

Line 5300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5296:
5297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5299: 'l_req_line_id = ' || l_req_line_id);
5300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5301: 'l_req_line_dtl_id = ' || l_req_line_dtl_id);
5302: end if;
5303:
5304: l_lines_tbl(i).requirement_line_id := l_req_line_id;

Line 5311: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5307: l_req_line_dtl_rec(i).REQUIREMENT_LINE_ID := l_req_line_id;
5308: l_req_line_dtl_rec(i).SOURCE_TYPE := 'IO';
5309: end loop;
5310:
5311: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5313: 'Before trying to cancel the order...');
5314: end if;
5315:

Line 5312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5308: l_req_line_dtl_rec(i).SOURCE_TYPE := 'IO';
5309: end loop;
5310:
5311: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5313: 'Before trying to cancel the order...');
5314: end if;
5315:
5316: Cancel_Order(

Line 5325: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5321: x_msg_count => x_msg_count,
5322: x_msg_data => x_msg_data
5323: );
5324:
5325: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5326: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5327: 'after cancel the order... x_return_status = ' || x_return_status);
5328: end if;
5329:

Line 5326: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5322: x_msg_data => x_msg_data
5323: );
5324:
5325: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5326: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5327: 'after cancel the order... x_return_status = ' || x_return_status);
5328: end if;
5329:
5330: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 5333: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5329:
5330: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5331: rollback to csp_upd_oe_ship_to_add;
5332:
5333: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5335: 'x_return_status = ' || x_return_status);
5336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5337: 'x_msg_count = ' || x_msg_count);

Line 5334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5330: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5331: rollback to csp_upd_oe_ship_to_add;
5332:
5333: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5335: 'x_return_status = ' || x_return_status);
5336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5337: 'x_msg_count = ' || x_msg_count);
5338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5332:
5333: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5335: 'x_return_status = ' || x_return_status);
5336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5337: 'x_msg_count = ' || x_msg_count);
5338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5339: 'x_msg_data = ' || x_msg_data);
5340: end if;

Line 5338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5335: 'x_return_status = ' || x_return_status);
5336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5337: 'x_msg_count = ' || x_msg_count);
5338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5339: 'x_msg_data = ' || x_msg_data);
5340: end if;
5341:
5342: else

Line 5344: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5340: end if;
5341:
5342: else
5343: -- try to create the order :)
5344: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5346: 'before calling process_order...');
5347: end if;
5348:

Line 5345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5341:
5342: else
5343: -- try to create the order :)
5344: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5346: 'before calling process_order...');
5347: end if;
5348:
5349: process_order(

Line 5362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5358: ,x_msg_count => x_msg_count
5359: ,x_msg_data => x_msg_data
5360: );
5361:
5362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5364: 'after calling process_order... x_return_status = ' || x_return_status);
5365: end if;
5366:

Line 5363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5359: ,x_msg_data => x_msg_data
5360: );
5361:
5362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5364: 'after calling process_order... x_return_status = ' || x_return_status);
5365: end if;
5366:
5367: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 5370: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5366:
5367: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5368: rollback to csp_upd_oe_ship_to_add;
5369:
5370: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5372: 'x_return_status = ' || x_return_status);
5373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5374: 'x_msg_count = ' || x_msg_count);

Line 5371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5367: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5368: rollback to csp_upd_oe_ship_to_add;
5369:
5370: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5372: 'x_return_status = ' || x_return_status);
5373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5374: 'x_msg_count = ' || x_msg_count);
5375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5369:
5370: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5372: 'x_return_status = ' || x_return_status);
5373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5374: 'x_msg_count = ' || x_msg_count);
5375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5376: 'x_msg_data = ' || x_msg_data);
5377: end if;

Line 5375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5372: 'x_return_status = ' || x_return_status);
5373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5374: 'x_msg_count = ' || x_msg_count);
5375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5376: 'x_msg_data = ' || x_msg_data);
5377: end if;
5378:
5379: else

Line 5381: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5377: end if;
5378:
5379: else
5380: -- update the csp_req_line_details
5381: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5382: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5383: 'populating l_req_line_dtl_rec...');
5384: end if;
5385:

Line 5382: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5378:
5379: else
5380: -- update the csp_req_line_details
5381: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5382: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5383: 'populating l_req_line_dtl_rec...');
5384: end if;
5385:
5386: for i in 1..l_lines_tbl.count loop

Line 5391: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5387: for j in 1..l_req_line_dtl_rec.count loop
5388: if l_req_line_dtl_rec(j).REQUIREMENT_LINE_ID = l_lines_tbl(i).requirement_line_id then
5389: l_req_line_dtl_rec(j).SOURCE_ID := l_lines_tbl(i).order_line_id;
5390:
5391: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5392: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5393: 'new SOURCE_ID for REQUIREMENT_LINE_ID is = '
5394: || l_req_line_dtl_rec(j).REQUIREMENT_LINE_ID
5395: || ' -> ' || l_req_line_dtl_rec(j).SOURCE_ID);

Line 5392: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5388: if l_req_line_dtl_rec(j).REQUIREMENT_LINE_ID = l_lines_tbl(i).requirement_line_id then
5389: l_req_line_dtl_rec(j).SOURCE_ID := l_lines_tbl(i).order_line_id;
5390:
5391: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5392: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5393: 'new SOURCE_ID for REQUIREMENT_LINE_ID is = '
5394: || l_req_line_dtl_rec(j).REQUIREMENT_LINE_ID
5395: || ' -> ' || l_req_line_dtl_rec(j).SOURCE_ID);
5396: end if;

Line 5402: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5398: end if;
5399: end loop;
5400: end loop;
5401:
5402: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5403: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5404: 'before calling update req line details...');
5405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5406: 'l_req_line_dtl_rec.count = ' || l_req_line_dtl_rec.count);

Line 5403: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5399: end loop;
5400: end loop;
5401:
5402: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5403: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5404: 'before calling update req line details...');
5405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5406: 'l_req_line_dtl_rec.count = ' || l_req_line_dtl_rec.count);
5407: end if;

Line 5405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5401:
5402: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5403: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5404: 'before calling update req line details...');
5405: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5406: 'l_req_line_dtl_rec.count = ' || l_req_line_dtl_rec.count);
5407: end if;
5408:
5409: CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details(

Line 5417: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5413: X_Msg_Count => x_msg_count,
5414: X_Msg_Data => x_msg_data
5415: );
5416:
5417: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5418: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5419: 'after CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details... x_return_status = ' || x_return_status);
5420: end if;
5421:

Line 5418: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5414: X_Msg_Data => x_msg_data
5415: );
5416:
5417: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5418: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5419: 'after CSP_REQ_LINE_DETAILS_PVT.Update_req_line_details... x_return_status = ' || x_return_status);
5420: end if;
5421:
5422: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 5425: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5421:
5422: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5423: rollback to csp_upd_oe_ship_to_add;
5424:
5425: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5427: 'x_return_status = ' || x_return_status);
5428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5429: 'x_msg_count = ' || x_msg_count);

Line 5426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5422: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5423: rollback to csp_upd_oe_ship_to_add;
5424:
5425: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5427: 'x_return_status = ' || x_return_status);
5428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5429: 'x_msg_count = ' || x_msg_count);
5430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5424:
5425: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5427: 'x_return_status = ' || x_return_status);
5428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5429: 'x_msg_count = ' || x_msg_count);
5430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5431: 'x_msg_data = ' || x_msg_data);
5432: end if;

Line 5430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5427: 'x_return_status = ' || x_return_status);
5428: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5429: 'x_msg_count = ' || x_msg_count);
5430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5431: 'x_msg_data = ' || x_msg_data);
5432: end if;
5433: end if;
5434:

Line 5442: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5438: end loop;
5439:
5440: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5441:
5442: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5443: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5444: 'p_update_req_header = ' || p_update_req_header);
5445: end if;
5446:

Line 5443: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5439:
5440: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5441:
5442: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5443: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5444: 'p_update_req_header = ' || p_update_req_header);
5445: end if;
5446:
5447: if nvl(p_update_req_header, 'N') = 'Y' then

Line 5453: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5449: l_req_hdr_pvt_rec.REQUIREMENT_HEADER_ID := p_req_header_id;
5450: l_req_hdr_pvt_rec.SHIP_TO_LOCATION_ID := p_new_hr_loc_id;
5451: l_req_hdr_pvt_rec.ADDRESS_TYPE := p_new_add_type;
5452:
5453: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5455: 'before calling CSP_Requirement_headers_PVT.Update_requirement_headers...');
5456: end if;
5457:

Line 5454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5450: l_req_hdr_pvt_rec.SHIP_TO_LOCATION_ID := p_new_hr_loc_id;
5451: l_req_hdr_pvt_rec.ADDRESS_TYPE := p_new_add_type;
5452:
5453: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5455: 'before calling CSP_Requirement_headers_PVT.Update_requirement_headers...');
5456: end if;
5457:
5458: CSP_Requirement_headers_PVT.Update_requirement_headers(

Line 5466: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5462: X_Msg_Count => x_msg_count,
5463: X_Msg_Data => x_msg_data
5464: );
5465:
5466: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5468: 'after calling CSP_Requirement_headers_PVT.Update_requirement_headers... x_return_status = ' || x_return_status);
5469: end if;
5470:

Line 5467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5463: X_Msg_Data => x_msg_data
5464: );
5465:
5466: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5468: 'after calling CSP_Requirement_headers_PVT.Update_requirement_headers... x_return_status = ' || x_return_status);
5469: end if;
5470:
5471: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 5474: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5470:
5471: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5472: rollback to csp_upd_oe_ship_to_add;
5473:
5474: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5476: 'x_return_status = ' || x_return_status);
5477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5478: 'x_msg_count = ' || x_msg_count);

Line 5475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5471: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5472: rollback to csp_upd_oe_ship_to_add;
5473:
5474: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5476: 'x_return_status = ' || x_return_status);
5477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5478: 'x_msg_count = ' || x_msg_count);
5479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5473:
5474: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5476: 'x_return_status = ' || x_return_status);
5477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5478: 'x_msg_count = ' || x_msg_count);
5479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5480: 'x_msg_data = ' || x_msg_data);
5481: end if;

Line 5479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5476: 'x_return_status = ' || x_return_status);
5477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5478: 'x_msg_count = ' || x_msg_count);
5479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5480: 'x_msg_data = ' || x_msg_data);
5481: end if;
5482: else
5483: if p_commit = FND_API.G_TRUE then

Line 5485: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5481: end if;
5482: else
5483: if p_commit = FND_API.G_TRUE then
5484: commit;
5485: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5487: 'transaction commited...');
5488: end if;
5489: end if;

Line 5486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5482: else
5483: if p_commit = FND_API.G_TRUE then
5484: commit;
5485: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5487: 'transaction commited...');
5488: end if;
5489: end if;
5490: end if;

Line 5495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5491: end if;
5492: end if;
5493: end if;
5494:
5495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5497: 'returning...');
5498: end if;
5499: END;

Line 5496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

5492: end if;
5493: end if;
5494:
5495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5497: 'returning...');
5498: end if;
5499: END;
5500: