eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_DEBUG

Line 264: PO_DEBUG.put_line ('Start update of line/creation of price breaks');

260:
261: Begin
262:
263: IF (g_po_pdoi_write_to_file = 'Y') THEN
264: PO_DEBUG.put_line ('Start update of line/creation of price breaks');
265: PO_DEBUG.put_line ('header id:'|| to_char(X_current_po_header_id));
266: PO_DEBUG.put_line ('line id:'|| to_char(X_po_line_id ));
267: PO_DEBUG.put_line ('X_update_po_line_flag:' || X_update_po_line_flag );
268: PO_DEBUG.put_line ('X_price_tolerance_flag:' || X_price_tolerance_flag);

Line 265: PO_DEBUG.put_line ('header id:'|| to_char(X_current_po_header_id));

261: Begin
262:
263: IF (g_po_pdoi_write_to_file = 'Y') THEN
264: PO_DEBUG.put_line ('Start update of line/creation of price breaks');
265: PO_DEBUG.put_line ('header id:'|| to_char(X_current_po_header_id));
266: PO_DEBUG.put_line ('line id:'|| to_char(X_po_line_id ));
267: PO_DEBUG.put_line ('X_update_po_line_flag:' || X_update_po_line_flag );
268: PO_DEBUG.put_line ('X_price_tolerance_flag:' || X_price_tolerance_flag);
269: END IF;

Line 266: PO_DEBUG.put_line ('line id:'|| to_char(X_po_line_id ));

262:
263: IF (g_po_pdoi_write_to_file = 'Y') THEN
264: PO_DEBUG.put_line ('Start update of line/creation of price breaks');
265: PO_DEBUG.put_line ('header id:'|| to_char(X_current_po_header_id));
266: PO_DEBUG.put_line ('line id:'|| to_char(X_po_line_id ));
267: PO_DEBUG.put_line ('X_update_po_line_flag:' || X_update_po_line_flag );
268: PO_DEBUG.put_line ('X_price_tolerance_flag:' || X_price_tolerance_flag);
269: END IF;
270:

Line 267: PO_DEBUG.put_line ('X_update_po_line_flag:' || X_update_po_line_flag );

263: IF (g_po_pdoi_write_to_file = 'Y') THEN
264: PO_DEBUG.put_line ('Start update of line/creation of price breaks');
265: PO_DEBUG.put_line ('header id:'|| to_char(X_current_po_header_id));
266: PO_DEBUG.put_line ('line id:'|| to_char(X_po_line_id ));
267: PO_DEBUG.put_line ('X_update_po_line_flag:' || X_update_po_line_flag );
268: PO_DEBUG.put_line ('X_price_tolerance_flag:' || X_price_tolerance_flag);
269: END IF;
270:
271: x_line_updated_flag := 'N';

Line 268: PO_DEBUG.put_line ('X_price_tolerance_flag:' || X_price_tolerance_flag);

264: PO_DEBUG.put_line ('Start update of line/creation of price breaks');
265: PO_DEBUG.put_line ('header id:'|| to_char(X_current_po_header_id));
266: PO_DEBUG.put_line ('line id:'|| to_char(X_po_line_id ));
267: PO_DEBUG.put_line ('X_update_po_line_flag:' || X_update_po_line_flag );
268: PO_DEBUG.put_line ('X_price_tolerance_flag:' || X_price_tolerance_flag);
269: END IF;
270:
271: x_line_updated_flag := 'N';
272:

Line 321: PO_DEBUG.put_line('Skip line validation process for line update');

317:
318: IF ((X_update_po_line_flag = 'Y') and (X_header_processable_flag = 'Y')) THEN
319:
320: IF (g_po_pdoi_write_to_file = 'Y') THEN
321: PO_DEBUG.put_line('Skip line validation process for line update');
322: END IF;
323:
324: X_progress := '020';
325:

Line 343: PO_DEBUG.put_line('Item description is:' || x_item_description);

339: -- val_item_interface()
340: -- these are for inventory interface.
341:
342: IF (g_po_pdoi_write_to_file = 'Y') THEN
343: PO_DEBUG.put_line('Item description is:' || x_item_description);
344: END IF;
345: /*
346: Bug 2696413
347: While updating we do not need to check the item description. If it

Line 472: PO_DEBUG.put_line ('Updating the desc to:' || x_item_description);

468:
469: if (X_update_item = 'Y') then
470:
471: IF (g_po_pdoi_write_to_file = 'Y') THEN
472: PO_DEBUG.put_line ('Updating the desc to:' || x_item_description);
473: END IF;
474:
475: UPDATE po_lines
476: SET item_description = x_item_description,

Line 516: PO_DEBUG.put_line ('Unit price update - unit_price:' || to_char(X_unit_price));

512: X_cancel_flag := NULL;
513: END IF;
514:
515: IF (g_po_pdoi_write_to_file = 'Y') THEN
516: PO_DEBUG.put_line ('Unit price update - unit_price:' || to_char(X_unit_price));
517: END IF;
518:
519: select unit_price, retroactive_date,price_break_lookup_code -- 2722795
520: into x_doc_line_unit_price,l_retroactive_date,l_price_break_lookup_code --2722795

Line 559: PO_DEBUG.put_line('X_price_break_lookup_code '||X_price_break_lookup_code);

555: * be updated with the timestamp. This has to be done
556: * for non-cumulative blanket lines only.
557: */
558: IF (g_po_pdoi_write_to_file = 'Y') THEN
559: PO_DEBUG.put_line('X_price_break_lookup_code '||X_price_break_lookup_code);
560: PO_DEBUG.put_line('X_document_type '||X_document_type);
561: END IF;
562: IF ((X_document_type = 'BLANKET') and
563: (nvl(l_price_break_lookup_code,'NON CUMULATIVE') =

Line 560: PO_DEBUG.put_line('X_document_type '||X_document_type);

556: * for non-cumulative blanket lines only.
557: */
558: IF (g_po_pdoi_write_to_file = 'Y') THEN
559: PO_DEBUG.put_line('X_price_break_lookup_code '||X_price_break_lookup_code);
560: PO_DEBUG.put_line('X_document_type '||X_document_type);
561: END IF;
562: IF ((X_document_type = 'BLANKET') and
563: (nvl(l_price_break_lookup_code,'NON CUMULATIVE') =
564: 'NON CUMULATIVE')) THEN

Line 569: PO_DEBUG.put_line ('Updating the unit price');

565: l_retroactive_date := sysdate;
566: END IF;
567:
568: IF (g_po_pdoi_write_to_file = 'Y') THEN
569: PO_DEBUG.put_line ('Updating the unit price');
570: END IF;
571:
572:
573: UPDATE po_lines

Line 643: PO_DEBUG.put_line ('UOM update - current uom on line :' || x_current_line_uom_code);

639: if (x_unit_of_measure is not null and
640: upper(x_unit_of_measure) <> nvl(upper(x_current_line_uom_code),upper(x_unit_of_measure))) then
641:
642: IF (g_po_pdoi_write_to_file = 'Y') THEN
643: PO_DEBUG.put_line ('UOM update - current uom on line :' || x_current_line_uom_code);
644: PO_DEBUG.put_line ('UOM update - new uom :' ||x_unit_of_measure );
645: PO_DEBUG.put_line ('UOM update - new price :' ||X_unit_price );
646: END IF;
647:

Line 644: PO_DEBUG.put_line ('UOM update - new uom :' ||x_unit_of_measure );

640: upper(x_unit_of_measure) <> nvl(upper(x_current_line_uom_code),upper(x_unit_of_measure))) then
641:
642: IF (g_po_pdoi_write_to_file = 'Y') THEN
643: PO_DEBUG.put_line ('UOM update - current uom on line :' || x_current_line_uom_code);
644: PO_DEBUG.put_line ('UOM update - new uom :' ||x_unit_of_measure );
645: PO_DEBUG.put_line ('UOM update - new price :' ||X_unit_price );
646: END IF;
647:
648: select fnd.precision

Line 645: PO_DEBUG.put_line ('UOM update - new price :' ||X_unit_price );

641:
642: IF (g_po_pdoi_write_to_file = 'Y') THEN
643: PO_DEBUG.put_line ('UOM update - current uom on line :' || x_current_line_uom_code);
644: PO_DEBUG.put_line ('UOM update - new uom :' ||x_unit_of_measure );
645: PO_DEBUG.put_line ('UOM update - new price :' ||X_unit_price );
646: END IF;
647:
648: select fnd.precision
649: into l_precision

Line 700: PO_DEBUG.put_line ('Updating the UOM to:' || x_unit_of_measure);

696:
697: -- update uom and converted price on the doc.
698:
699: IF (g_po_pdoi_write_to_file = 'Y') THEN
700: PO_DEBUG.put_line ('Updating the UOM to:' || x_unit_of_measure);
701: PO_DEBUG.put_line ('Updating the price to:' || X_unit_price);
702: END IF;
703:
704: IF (X_header_processable_flag = 'Y') THEN

Line 701: PO_DEBUG.put_line ('Updating the price to:' || X_unit_price);

697: -- update uom and converted price on the doc.
698:
699: IF (g_po_pdoi_write_to_file = 'Y') THEN
700: PO_DEBUG.put_line ('Updating the UOM to:' || x_unit_of_measure);
701: PO_DEBUG.put_line ('Updating the price to:' || X_unit_price);
702: END IF;
703:
704: IF (X_header_processable_flag = 'Y') THEN
705:

Line 780: PO_DEBUG.put_line ('Updating the URL to:' || X_line_attribute14);

776: If (X_line_attribute14 is not NULL) then
777:
778: -- Note that URL changes do not require archiving hence x_line_updated_flag is not set to 'Y'
779: IF (g_po_pdoi_write_to_file = 'Y') THEN
780: PO_DEBUG.put_line ('Updating the URL to:' || X_line_attribute14);
781: END IF;
782:
783: UPDATE po_lines
784: SET ATTRIBUTE14 = X_line_attribute14,

Line 801: PO_DEBUG.put_line ('Start updating amount');

797: --
798: X_progress := '030';
799:
800: IF (g_po_pdoi_write_to_file = 'Y') THEN
801: PO_DEBUG.put_line ('Start updating amount');
802: END IF;
803:
804: IF (NVL(p_amount, 0) <> 0) THEN
805: UPDATE PO_LINES

Line 828: PO_DEBUG.put_line ('Start create price differentials for the line');

824: --Add price differential records to an existing blanket line
825: X_progress := '040';
826:
827: IF (g_po_pdoi_write_to_file = 'Y') THEN
828: PO_DEBUG.put_line ('Start create price differentials for the line');
829: PO_DEBUG.put_line('**update_po_line_flag: '||x_update_po_line_flag
830: || ' header_processable_flag: '||x_header_processable_flag
831: || 'order_type_lookup_code: '||p_order_type_lookup_code);
832:

Line 829: PO_DEBUG.put_line('**update_po_line_flag: '||x_update_po_line_flag

825: X_progress := '040';
826:
827: IF (g_po_pdoi_write_to_file = 'Y') THEN
828: PO_DEBUG.put_line ('Start create price differentials for the line');
829: PO_DEBUG.put_line('**update_po_line_flag: '||x_update_po_line_flag
830: || ' header_processable_flag: '||x_header_processable_flag
831: || 'order_type_lookup_code: '||p_order_type_lookup_code);
832:
833: END IF;

Line 847: PO_DEBUG.put_line ('interface_line_id: '||x_interface_line_id||

843: p_entity_id => X_po_line_id,
844: p_header_processable_flag => X_header_processable_flag);
845:
846: IF (g_po_pdoi_write_to_file = 'Y') THEN
847: PO_DEBUG.put_line ('interface_line_id: '||x_interface_line_id||
848: ' entity_id: ' ||x_po_line_id);
849: END IF;
850:
851: --create price differential records

Line 881: PO_DEBUG.put_line ('Start Creating Price Break/ Shipment Line - X_price_breaks_deleted:' || X_price_breaks_deleted);

877: end if;
878: /* */
879:
880: IF (g_po_pdoi_write_to_file = 'Y') THEN
881: PO_DEBUG.put_line ('Start Creating Price Break/ Shipment Line - X_price_breaks_deleted:' || X_price_breaks_deleted);
882: END IF;
883:
884: X_progress := '055';
885: x_line_updated_flag := 'Y';

Line 887: PO_DEBUG.put_line('Start validate po_line_coordination process');

883:
884: X_progress := '055';
885: x_line_updated_flag := 'Y';
886: IF (g_po_pdoi_write_to_file = 'Y') THEN
887: PO_DEBUG.put_line('Start validate po_line_coordination process');
888: END IF;
889:
890: /* call this procedure to make sure that for each po_line_location
891: record that we are going to create, we will always be able to

Line 948: PO_DEBUG.put_line('Start validate line locations');

944: X_progress := '060';
945: /* if after line default, the create_po_line_location_flag
946: is 'Y', then we will go ahead and validate line location */
947: IF (g_po_pdoi_write_to_file = 'Y') THEN
948: PO_DEBUG.put_line('Start validate line locations');
949: END IF;
950:
951: --
952: -- DO WE perform a complete validation. YES as we are creating a new line

Line 1071: PO_DEBUG.put_line('Start insert new record into line location');

1067: then insert a new rec in line_locaiton table */
1068:
1069: X_progress := '070';
1070: IF (g_po_pdoi_write_to_file = 'Y') THEN
1071: PO_DEBUG.put_line('Start insert new record into line location');
1072: END IF;
1073:
1074: --
1075: -- UPDATE THE PRICE BREAK INFORMATION HERE - note that any old price breaks,if any,

Line 1225: PO_DEBUG.put_line('Start insert price differentials '||

1221: AND (X_header_processable_flag = 'Y')) THEN
1222:
1223: X_progress := '080';
1224: IF (g_po_pdoi_write_to_file = 'Y') THEN
1225: PO_DEBUG.put_line('Start insert price differentials '||
1226: 'for the price break');
1227: END IF;
1228:
1229: If (p_order_type_lookup_code = 'RATE') then

Line 1404: PO_DEBUG.put_line ('Start Notifications Workflow');

1400: l_document_num VARCHAR2(20);
1401: Begin
1402:
1403: IF (g_po_pdoi_write_to_file = 'Y') THEN
1404: PO_DEBUG.put_line ('Start Notifications Workflow');
1405: END IF;
1406:
1407: begin
1408: select count(*) into l_number_of_items

Line 1415: PO_DEBUG.put_line('number of line items failing tolerance :' || to_char(l_number_of_items));

1411: and process_code = 'NOTIFIED'
1412: and nvl(price_break_flag,'N') = 'N';
1413:
1414: IF (g_po_pdoi_write_to_file = 'Y') THEN
1415: PO_DEBUG.put_line('number of line items failing tolerance :' || to_char(l_number_of_items));
1416: END IF;
1417: exception
1418: when others then
1419: l_number_of_items := NULL;

Line 1545: PO_DEBUG.put_line ('Done setting workflow attributes');

1541: itemkey => X_itemkey,
1542: owner => l_agent_username );
1543:
1544: IF (g_po_pdoi_write_to_file = 'Y') THEN
1545: PO_DEBUG.put_line ('Done setting workflow attributes');
1546: END IF;
1547:
1548: -- Start Workflow
1549:

Line 1554: PO_DEBUG.put_line ('Workflow started');

1550: wf_engine.startprocess ( itemtype => X_ItemType,
1551: itemkey => X_itemkey );
1552:
1553: IF (g_po_pdoi_write_to_file = 'Y') THEN
1554: PO_DEBUG.put_line ('Workflow started');
1555: END IF;
1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN

Line 1619: PO_DEBUG.put_line ('$ Checking price tolerance');

1615: x_asl_rows C1%ROWTYPE;
1616:
1617: begin
1618: IF (g_po_pdoi_write_to_file = 'Y') THEN
1619: PO_DEBUG.put_line ('$ Checking price tolerance');
1620: END IF;
1621:
1622: select process_code into l_process_code
1623: from po_headers_interface

Line 1632: PO_DEBUG.put_line ('p_vendor_id:' || to_char(p_vendor_id));

1628: where interface_header_id = p_interface_header_id
1629: and interface_line_id = p_interface_line_id;
1630:
1631: IF (g_po_pdoi_write_to_file = 'Y') THEN
1632: PO_DEBUG.put_line ('p_vendor_id:' || to_char(p_vendor_id));
1633: PO_DEBUG.put_line ('p_category_id:' || to_char(p_category_id));
1634: PO_DEBUG.put_line ('p_def_master_org_id' || to_char(p_def_master_org_id));
1635: PO_DEBUG.put_line ('l_process_code:' || l_process_code);
1636: PO_DEBUG.put_line ('l_acceptance_flag:' || l_acceptance_flag);

Line 1633: PO_DEBUG.put_line ('p_category_id:' || to_char(p_category_id));

1629: and interface_line_id = p_interface_line_id;
1630:
1631: IF (g_po_pdoi_write_to_file = 'Y') THEN
1632: PO_DEBUG.put_line ('p_vendor_id:' || to_char(p_vendor_id));
1633: PO_DEBUG.put_line ('p_category_id:' || to_char(p_category_id));
1634: PO_DEBUG.put_line ('p_def_master_org_id' || to_char(p_def_master_org_id));
1635: PO_DEBUG.put_line ('l_process_code:' || l_process_code);
1636: PO_DEBUG.put_line ('l_acceptance_flag:' || l_acceptance_flag);
1637: END IF;

Line 1634: PO_DEBUG.put_line ('p_def_master_org_id' || to_char(p_def_master_org_id));

1630:
1631: IF (g_po_pdoi_write_to_file = 'Y') THEN
1632: PO_DEBUG.put_line ('p_vendor_id:' || to_char(p_vendor_id));
1633: PO_DEBUG.put_line ('p_category_id:' || to_char(p_category_id));
1634: PO_DEBUG.put_line ('p_def_master_org_id' || to_char(p_def_master_org_id));
1635: PO_DEBUG.put_line ('l_process_code:' || l_process_code);
1636: PO_DEBUG.put_line ('l_acceptance_flag:' || l_acceptance_flag);
1637: END IF;
1638:

Line 1635: PO_DEBUG.put_line ('l_process_code:' || l_process_code);

1631: IF (g_po_pdoi_write_to_file = 'Y') THEN
1632: PO_DEBUG.put_line ('p_vendor_id:' || to_char(p_vendor_id));
1633: PO_DEBUG.put_line ('p_category_id:' || to_char(p_category_id));
1634: PO_DEBUG.put_line ('p_def_master_org_id' || to_char(p_def_master_org_id));
1635: PO_DEBUG.put_line ('l_process_code:' || l_process_code);
1636: PO_DEBUG.put_line ('l_acceptance_flag:' || l_acceptance_flag);
1637: END IF;
1638:
1639: if NVL(l_process_code, 'UPDATE') = 'NOTIFIED' and NVL(l_acceptance_flag, 'N') = 'Y' then

Line 1636: PO_DEBUG.put_line ('l_acceptance_flag:' || l_acceptance_flag);

1632: PO_DEBUG.put_line ('p_vendor_id:' || to_char(p_vendor_id));
1633: PO_DEBUG.put_line ('p_category_id:' || to_char(p_category_id));
1634: PO_DEBUG.put_line ('p_def_master_org_id' || to_char(p_def_master_org_id));
1635: PO_DEBUG.put_line ('l_process_code:' || l_process_code);
1636: PO_DEBUG.put_line ('l_acceptance_flag:' || l_acceptance_flag);
1637: END IF;
1638:
1639: if NVL(l_process_code, 'UPDATE') = 'NOTIFIED' and NVL(l_acceptance_flag, 'N') = 'Y' then
1640: return TRUE;

Line 1662: PO_DEBUG.put_line ('ASL tolerance' || to_char(l_price_update_tolerance));

1658: l_price_update_tolerance := x_asl_rows.price_update_tolerance;
1659: Close C1;
1660:
1661: IF (g_po_pdoi_write_to_file = 'Y') THEN
1662: PO_DEBUG.put_line ('ASL tolerance' || to_char(l_price_update_tolerance));
1663: END IF;
1664:
1665: exception
1666: when others then

Line 1669: PO_DEBUG.put_line ('ASL tolerance - exception');

1665: exception
1666: when others then
1667: null;
1668: IF (g_po_pdoi_write_to_file = 'Y') THEN
1669: PO_DEBUG.put_line ('ASL tolerance - exception');
1670: END IF;
1671: end;
1672:
1673: if l_price_update_tolerance is null then

Line 1705: PO_DEBUG.put_line('Price_update_tolerance_percent specified:' || to_char(l_price_update_tolerance));

1701: return TRUE;
1702: else
1703:
1704: IF (g_po_pdoi_write_to_file = 'Y') THEN
1705: PO_DEBUG.put_line('Price_update_tolerance_percent specified:' || to_char(l_price_update_tolerance));
1706: END IF;
1707:
1708: -- need to save the tolerance value at the line level as we would have to display it in the PRICAT form
1709:

Line 1722: PO_DEBUG.put_line('Price_update_tolerance_percent exceeded');

1718: and po_line_id = p_po_line_id;
1719:
1720: If (((1 + (l_price_update_tolerance/100)) * l_original_price) >= p_unit_price) then
1721: IF (g_po_pdoi_write_to_file = 'Y') THEN
1722: PO_DEBUG.put_line('Price_update_tolerance_percent exceeded');
1723: END IF;
1724: return TRUE;
1725: else
1726: IF (g_po_pdoi_write_to_file = 'Y') THEN

Line 1727: PO_DEBUG.put_line('Price_update_tolerance_percent NOT exceeded');

1723: END IF;
1724: return TRUE;
1725: else
1726: IF (g_po_pdoi_write_to_file = 'Y') THEN
1727: PO_DEBUG.put_line('Price_update_tolerance_percent NOT exceeded');
1728: END IF;
1729: return FALSE;
1730: end if;
1731: end if;

Line 1757: PO_DEBUG.put_line ('Deleting price breaks on original catalog/blanket');

1753:
1754: BEGIN
1755:
1756: IF (g_po_pdoi_write_to_file = 'Y') THEN
1757: PO_DEBUG.put_line ('Deleting price breaks on original catalog/blanket');
1758: PO_DEBUG.put_line ('x_po_header_id:' || to_char(x_po_header_id));
1759: PO_DEBUG.put_line ('x_po_line_id:' || to_char(x_po_line_id));
1760: END IF;
1761:

Line 1758: PO_DEBUG.put_line ('x_po_header_id:' || to_char(x_po_header_id));

1754: BEGIN
1755:
1756: IF (g_po_pdoi_write_to_file = 'Y') THEN
1757: PO_DEBUG.put_line ('Deleting price breaks on original catalog/blanket');
1758: PO_DEBUG.put_line ('x_po_header_id:' || to_char(x_po_header_id));
1759: PO_DEBUG.put_line ('x_po_line_id:' || to_char(x_po_line_id));
1760: END IF;
1761:
1762: -- delete all price breaks for this line.

Line 1759: PO_DEBUG.put_line ('x_po_line_id:' || to_char(x_po_line_id));

1755:
1756: IF (g_po_pdoi_write_to_file = 'Y') THEN
1757: PO_DEBUG.put_line ('Deleting price breaks on original catalog/blanket');
1758: PO_DEBUG.put_line ('x_po_header_id:' || to_char(x_po_header_id));
1759: PO_DEBUG.put_line ('x_po_line_id:' || to_char(x_po_line_id));
1760: END IF;
1761:
1762: -- delete all price breaks for this line.
1763: -- Bug: 1588445 While deleting price breaks take into consideration shipment