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.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_UTIL

Line 240: p_pb_input_lines_tbl IN QP_PRICE_BOOK_UTIL.pb_input_lines_tbl,

236: Internal API to Insert Price Book Lines, Attributes, Break Lines and Messages
237: ******************************************************************************/
238: PROCEDURE Insert_Price_Book_Content(
239: p_pb_input_header_rec IN qp_pb_input_headers_vl%ROWTYPE,
240: p_pb_input_lines_tbl IN QP_PRICE_BOOK_UTIL.pb_input_lines_tbl,
241: p_price_book_header_id IN NUMBER
242: )
243: IS
244:

Line 432: l_adhoc_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;

428: AND qpseg.segment_mapping_column = a_segment_mapping_column
429: AND rownum = 1;
430:
431: l_sql_stmt VARCHAR2(2000) := '';
432: l_adhoc_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;
433: k NUMBER;
434: l_blanket_number NUMBER;
435: l_bsa_hdr_price_list_id NUMBER;
436: l_bsa_line_price_list_id NUMBER;

Line 505: l_price_book_messages_tbl QP_PRICE_BOOK_UTIL.price_book_messages_tbl;

501: l_user_id NUMBER;
502: l_login_id NUMBER;
503:
504: l_pricing_events VARCHAR2(2000); --Check the datatype and length
505: l_price_book_messages_tbl QP_PRICE_BOOK_UTIL.price_book_messages_tbl;
506:
507: sql_exception EXCEPTION;
508: l_pb_line_count NUMBER := 0;
509:

Line 1459: QP_PRICE_BOOK_UTIL.Validate_PB_Inp_Criteria_Wrap(

1455:
1456: BEGIN
1457:
1458: --Perform validation of input criteria
1459: QP_PRICE_BOOK_UTIL.Validate_PB_Inp_Criteria_Wrap(
1460: p_pb_input_header_id => p_pb_input_header_id,
1461: x_return_status => x_return_status,
1462: x_return_text => x_return_text);
1463:

Line 1509: l_pb_input_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;

1505: p_price_book_header_id IN NUMBER := NULL,
1506: p_spawned_request IN VARCHAR2 := 'N')
1507: IS
1508: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
1509: l_pb_input_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;
1510: l_publish_price_book_header_id NUMBER := NULL;
1511: l_overwrite_pb_header_id NUMBER := NULL;
1512: l_item_validation_org_id NUMBER;
1513: l_child_request_id NUMBER;

Line 1658: l_price_book_messages_tbl QP_PRICE_BOOK_UTIL.price_book_messages_tbl;

1654:
1655: l_user_id NUMBER;
1656: l_login_id NUMBER;
1657:
1658: l_price_book_messages_tbl QP_PRICE_BOOK_UTIL.price_book_messages_tbl;
1659: l_message_text VARCHAR2(2000);
1660: i NUMBER :=1;
1661: m NUMBER;
1662: l_net_price NUMBER;

Line 1725: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);

1721: l_price_book_messages_tbl(i).message_code :=
1722: 'QP_INPUT_REC_NOT_FOUND';
1723: l_price_book_messages_tbl(i).message_text := l_message_text;
1724: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;
1725: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);
1726: l_price_book_messages_tbl.delete;
1727: commit;
1728: retcode := 2;
1729: errbuf := substr(l_message_text,1,240);

Line 1755: QP_PRICE_BOOK_UTIL.Get_Processing_BatchSize;

1751: -- G_pb_Processor_Batchsize
1752: --
1753: IF ( G_pb_Processor_Batchsize IS NULL ) THEN
1754: G_pb_Processor_Batchsize :=
1755: QP_PRICE_BOOK_UTIL.Get_Processing_BatchSize;
1756: END IF;
1757:
1758: rows := QP_PRICE_BOOK_PVT.G_pb_Processor_Batchsize;
1759:

Line 1791: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1787: 'QP_PRICE_BOOK_DOES_NOT_EXIST';
1788: l_price_book_messages_tbl(i).message_text := l_message_text;
1789: l_price_book_messages_tbl(i).pb_input_header_id :=
1790: p_pb_input_header_id;
1791: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1792: l_price_book_messages_tbl);
1793: l_price_book_messages_tbl.delete;
1794: commit;--inserted message with pb_input_header_id
1795: --since price_book_header_id not yet usable.

Line 1841: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1837: l_message_text := substr(sqlerrm, 1, 240);
1838: l_price_book_messages_tbl(i).message_text := l_message_text;
1839: l_price_book_messages_tbl(i).pb_input_header_id :=
1840: p_pb_input_header_id;
1841: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1842: l_price_book_messages_tbl);
1843: l_price_book_messages_tbl.delete;
1844: commit; --inserted message with pb_input_header_id
1845: --since price_book_header_id not yet usable.

Line 1925: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1921: l_message_text := substr(sqlerrm, 1, 240);
1922: l_price_book_messages_tbl(i).message_text := l_message_text;
1923: l_price_book_messages_tbl(i).pb_input_header_id :=
1924: p_pb_input_header_id;
1925: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1926: l_price_book_messages_tbl);
1927: l_price_book_messages_tbl.delete;
1928: commit; --inserted message with pb_input_header_id
1929: --since price_book_header_id not yet usable.

Line 1988: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(

1984: fnd_file.put_line(FND_FILE.LOG, 'Before inserting price book header');
1985:
1986: --Create Price Book Header
1987: BEGIN
1988: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(
1989: p_pb_input_header_rec => l_pb_input_header_rec,
1990: x_price_book_header_id => l_publish_price_book_header_id);
1991:
1992: fnd_file.put_line(FND_FILE.LOG, 'After inserting price book header'||

Line 2005: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2001: 'QP_PB_EXISTS_IN_ANOTHER_ORG';
2002: l_price_book_messages_tbl(i).message_text := l_message_text;
2003: l_price_book_messages_tbl(i).pb_input_header_id :=
2004: p_pb_input_header_id;
2005: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2006: l_price_book_messages_tbl);
2007: l_price_book_messages_tbl.delete;
2008: commit; --inserted message with pb_input_header_id
2009: --since price_book_header_id not yet usable.

Line 2022: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2018: l_message_text := substr(sqlerrm, 1, 240);
2019: l_price_book_messages_tbl(i).message_text := l_message_text;
2020: l_price_book_messages_tbl(i).pb_input_header_id :=
2021: p_pb_input_header_id;
2022: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2023: l_price_book_messages_tbl);
2024: l_price_book_messages_tbl.delete;
2025: commit; --inserted message with pb_input_header_id
2026: --since price_book_header_id not yet usable.

Line 2040: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(

2036: IF l_overwrite_pb_header_id IS NULL THEN
2037:
2038: BEGIN
2039: --Create Price Book Header
2040: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(
2041: p_pb_input_header_rec => l_pb_input_header_rec,
2042: x_price_book_header_id => l_publish_price_book_header_id);
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN

Line 2054: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2050: 'QP_PB_EXISTS_IN_ANOTHER_ORG';
2051: l_price_book_messages_tbl(i).message_text := l_message_text;
2052: l_price_book_messages_tbl(i).pb_input_header_id :=
2053: p_pb_input_header_id;
2054: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2055: l_price_book_messages_tbl);
2056: l_price_book_messages_tbl.delete;
2057: commit; --inserted message with pb_input_header_id
2058: --since price_book_header_id not yet usable.

Line 2071: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2067: l_message_text := substr(sqlerrm, 1, 240);
2068: l_price_book_messages_tbl(i).message_text := l_message_text;
2069: l_price_book_messages_tbl(i).pb_input_header_id :=
2070: p_pb_input_header_id;
2071: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2072: l_price_book_messages_tbl);
2073: l_price_book_messages_tbl.delete;
2074: commit; --inserted message with pb_input_header_id
2075: --since price_book_header_id not yet usable.

Line 2094: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2090: 'QP_PRICE_BOOK_ALREADY_EXISTS';
2091: l_price_book_messages_tbl(i).message_text := l_message_text;
2092: l_price_book_messages_tbl(i).pb_input_header_id :=
2093: p_pb_input_header_id;
2094: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2095: l_price_book_messages_tbl);
2096: l_price_book_messages_tbl.delete;
2097: commit; --inserted message with pb_input_header_id
2098: --since price_book_header_id not yet usable.

Line 2446: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2442: l_price_book_messages_tbl(i).pb_input_header_id :=
2443: p_pb_input_header_id;
2444: l_price_book_messages_tbl(i).price_book_header_id :=
2445: p_price_book_header_id;
2446: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2447: l_price_book_messages_tbl);
2448: l_price_book_messages_tbl.delete;
2449: commit;
2450: retcode := 0;

Line 2539: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2535: l_price_book_messages_tbl(i).pb_input_header_id :=
2536: p_pb_input_header_id;
2537: l_price_book_messages_tbl(i).price_book_header_id :=
2538: p_price_book_header_id;
2539: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2540: l_price_book_messages_tbl);
2541: l_price_book_messages_tbl.delete;
2542: commit;
2543: retcode := 2;

Line 2592: QP_PRICE_BOOK_UTIL.GENERATE_PRICE_BOOK_XML

2588: INTO l_document_type
2589: FROM QP_PB_INPUT_HEADERS_B
2590: WHERE pb_input_header_id = p_pb_input_header_id;
2591:
2592: QP_PRICE_BOOK_UTIL.GENERATE_PRICE_BOOK_XML
2593: (
2594: p_price_book_header_id,
2595: QP_PRICE_BOOK_UTIL.get_content_type(l_document_type),
2596: QP_PRICE_BOOK_UTIL.get_document_name(p_pb_input_header_id,l_document_type),

Line 2595: QP_PRICE_BOOK_UTIL.get_content_type(l_document_type),

2591:
2592: QP_PRICE_BOOK_UTIL.GENERATE_PRICE_BOOK_XML
2593: (
2594: p_price_book_header_id,
2595: QP_PRICE_BOOK_UTIL.get_content_type(l_document_type),
2596: QP_PRICE_BOOK_UTIL.get_document_name(p_pb_input_header_id,l_document_type),
2597: l_return_status,
2598: l_return_status_text
2599: );

Line 2596: QP_PRICE_BOOK_UTIL.get_document_name(p_pb_input_header_id,l_document_type),

2592: QP_PRICE_BOOK_UTIL.GENERATE_PRICE_BOOK_XML
2593: (
2594: p_price_book_header_id,
2595: QP_PRICE_BOOK_UTIL.get_content_type(l_document_type),
2596: QP_PRICE_BOOK_UTIL.get_document_name(p_pb_input_header_id,l_document_type),
2597: l_return_status,
2598: l_return_status_text
2599: );
2600:

Line 2610: QP_PRICE_BOOK_UTIL.Publish_and_Deliver(

2606: --If a template has been specified
2607: IF l_pb_input_header_rec.pub_template_code IS NOT NULL
2608: THEN
2609:
2610: QP_PRICE_BOOK_UTIL.Publish_and_Deliver(
2611: p_pb_input_header_id => p_pb_input_header_id,
2612: p_price_book_header_id => p_price_book_header_id,
2613: x_return_status => l_return_status,
2614: x_return_status_text => l_return_status_text);

Line 2628: QP_PRICE_BOOK_UTIL.Send_Sync_Catalog(

2624: END IF;
2625:
2626: --If XML Message flag checked
2627: IF l_pb_input_header_rec.dlv_xml_flag = 'Y' THEN
2628: QP_PRICE_BOOK_UTIL.Send_Sync_Catalog(
2629: p_price_book_header_id => p_price_book_header_id,
2630: x_return_status => l_return_status,
2631: x_return_status_text => l_return_status_text);
2632: fnd_file.put_line(FND_FILE.LOG, 'XML Message return status '||l_return_status);

Line 2640: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);

2636: l_price_book_messages_tbl(i).message_code := 'SYNC_CATALOG_ERROR';
2637: l_price_book_messages_tbl(i).message_text := l_return_status_text;
2638: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;
2639: l_price_book_messages_tbl(i).price_book_header_id := p_price_book_header_id;
2640: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);
2641: l_price_book_messages_tbl.delete;
2642: commit;
2643: retcode := 1;
2644: errbuf := l_return_status_text;

Line 2676: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);

2672: l_price_book_messages_tbl(i).message_text := l_message_text;
2673: l_price_book_messages_tbl(i).pb_input_header_id :=
2674: l_pb_input_header_rec.pb_input_header_id;
2675: l_price_book_messages_tbl(i).price_book_header_id := p_price_book_header_id;
2676: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);
2677: l_price_book_messages_tbl.delete;
2678: commit;
2679: retcode := 2;
2680: errbuf := l_message_text;