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 241: p_pb_input_lines_tbl IN QP_PRICE_BOOK_UTIL.pb_input_lines_tbl,

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

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 1480: QP_PRICE_BOOK_UTIL.Validate_PB_Inp_Criteria_Wrap(

1476:
1477: BEGIN
1478:
1479: --Perform validation of input criteria
1480: QP_PRICE_BOOK_UTIL.Validate_PB_Inp_Criteria_Wrap(
1481: p_pb_input_header_id => p_pb_input_header_id,
1482: x_return_status => x_return_status,
1483: x_return_text => x_return_text);
1484:

Line 1529: l_pb_input_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;

1525: p_price_book_header_id IN NUMBER := NULL,
1526: p_spawned_request IN VARCHAR2 := 'N')
1527: IS
1528: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
1529: l_pb_input_lines_tbl QP_PRICE_BOOK_UTIL.pb_input_lines_tbl;
1530: l_publish_price_book_header_id NUMBER := NULL;
1531: l_overwrite_pb_header_id NUMBER := NULL;
1532: l_item_validation_org_id NUMBER;
1533: l_child_request_id NUMBER;

Line 1639: l_price_book_messages_tbl QP_PRICE_BOOK_UTIL.price_book_messages_tbl;

1635:
1636: l_user_id NUMBER;
1637: l_login_id NUMBER;
1638:
1639: l_price_book_messages_tbl QP_PRICE_BOOK_UTIL.price_book_messages_tbl;
1640: l_message_text VARCHAR2(2000);
1641: i NUMBER :=1;
1642: m NUMBER;
1643: l_net_price NUMBER;

Line 1706: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);

1702: l_price_book_messages_tbl(i).message_code :=
1703: 'QP_INPUT_REC_NOT_FOUND';
1704: l_price_book_messages_tbl(i).message_text := l_message_text;
1705: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;
1706: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);
1707: l_price_book_messages_tbl.delete;
1708: commit;
1709: retcode := 2;
1710: errbuf := substr(l_message_text,1,240);

Line 1737: QP_PRICE_BOOK_UTIL.Get_Processing_BatchSize;

1733: -- G_pb_Processor_Batchsize
1734: --
1735: IF ( G_pb_Processor_Batchsize IS NULL ) THEN
1736: G_pb_Processor_Batchsize :=
1737: QP_PRICE_BOOK_UTIL.Get_Processing_BatchSize;
1738: END IF;
1739:
1740: rows := QP_PRICE_BOOK_PVT.G_pb_Processor_Batchsize;
1741:

Line 1772: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1768: 'QP_PRICE_BOOK_DOES_NOT_EXIST';
1769: l_price_book_messages_tbl(i).message_text := l_message_text;
1770: l_price_book_messages_tbl(i).pb_input_header_id :=
1771: p_pb_input_header_id;
1772: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1773: l_price_book_messages_tbl);
1774: l_price_book_messages_tbl.delete;
1775: commit;--inserted message with pb_input_header_id
1776: --since price_book_header_id not yet usable.

Line 1822: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1818: l_message_text := substr(sqlerrm, 1, 240);
1819: l_price_book_messages_tbl(i).message_text := l_message_text;
1820: l_price_book_messages_tbl(i).pb_input_header_id :=
1821: p_pb_input_header_id;
1822: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1823: l_price_book_messages_tbl);
1824: l_price_book_messages_tbl.delete;
1825: commit; --inserted message with pb_input_header_id
1826: --since price_book_header_id not yet usable.

Line 1906: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1902: l_message_text := substr(sqlerrm, 1, 240);
1903: l_price_book_messages_tbl(i).message_text := l_message_text;
1904: l_price_book_messages_tbl(i).pb_input_header_id :=
1905: p_pb_input_header_id;
1906: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1907: l_price_book_messages_tbl);
1908: l_price_book_messages_tbl.delete;
1909: commit; --inserted message with pb_input_header_id
1910: --since price_book_header_id not yet usable.

Line 1969: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(

1965: fnd_file.put_line(FND_FILE.LOG, 'Before inserting price book header');
1966:
1967: --Create Price Book Header
1968: BEGIN
1969: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(
1970: p_pb_input_header_rec => l_pb_input_header_rec,
1971: x_price_book_header_id => l_publish_price_book_header_id);
1972:
1973: fnd_file.put_line(FND_FILE.LOG, 'After inserting price book header'||

Line 1986: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1982: 'QP_PB_EXISTS_IN_ANOTHER_ORG';
1983: l_price_book_messages_tbl(i).message_text := l_message_text;
1984: l_price_book_messages_tbl(i).pb_input_header_id :=
1985: p_pb_input_header_id;
1986: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
1987: l_price_book_messages_tbl);
1988: l_price_book_messages_tbl.delete;
1989: commit; --inserted message with pb_input_header_id
1990: --since price_book_header_id not yet usable.

Line 2003: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

1999: l_message_text := substr(sqlerrm, 1, 240);
2000: l_price_book_messages_tbl(i).message_text := l_message_text;
2001: l_price_book_messages_tbl(i).pb_input_header_id :=
2002: p_pb_input_header_id;
2003: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2004: l_price_book_messages_tbl);
2005: l_price_book_messages_tbl.delete;
2006: commit; --inserted message with pb_input_header_id
2007: --since price_book_header_id not yet usable.

Line 2021: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(

2017: IF l_overwrite_pb_header_id IS NULL THEN
2018:
2019: BEGIN
2020: --Create Price Book Header
2021: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(
2022: p_pb_input_header_rec => l_pb_input_header_rec,
2023: x_price_book_header_id => l_publish_price_book_header_id);
2024: EXCEPTION
2025: WHEN FND_API.G_EXC_ERROR THEN

Line 2035: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2031: 'QP_PB_EXISTS_IN_ANOTHER_ORG';
2032: l_price_book_messages_tbl(i).message_text := l_message_text;
2033: l_price_book_messages_tbl(i).pb_input_header_id :=
2034: p_pb_input_header_id;
2035: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2036: l_price_book_messages_tbl);
2037: l_price_book_messages_tbl.delete;
2038: commit; --inserted message with pb_input_header_id
2039: --since price_book_header_id not yet usable.

Line 2052: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2048: l_message_text := substr(sqlerrm, 1, 240);
2049: l_price_book_messages_tbl(i).message_text := l_message_text;
2050: l_price_book_messages_tbl(i).pb_input_header_id :=
2051: p_pb_input_header_id;
2052: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2053: l_price_book_messages_tbl);
2054: l_price_book_messages_tbl.delete;
2055: commit; --inserted message with pb_input_header_id
2056: --since price_book_header_id not yet usable.

Line 2075: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2071: 'QP_PRICE_BOOK_ALREADY_EXISTS';
2072: l_price_book_messages_tbl(i).message_text := l_message_text;
2073: l_price_book_messages_tbl(i).pb_input_header_id :=
2074: p_pb_input_header_id;
2075: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2076: l_price_book_messages_tbl);
2077: l_price_book_messages_tbl.delete;
2078: commit; --inserted message with pb_input_header_id
2079: --since price_book_header_id not yet usable.

Line 2425: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2421: l_price_book_messages_tbl(i).pb_input_header_id :=
2422: p_pb_input_header_id;
2423: l_price_book_messages_tbl(i).price_book_header_id :=
2424: p_price_book_header_id;
2425: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2426: l_price_book_messages_tbl);
2427: l_price_book_messages_tbl.delete;
2428: commit;
2429: retcode := 0;

Line 2517: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(

2513: l_price_book_messages_tbl(i).pb_input_header_id :=
2514: p_pb_input_header_id;
2515: l_price_book_messages_tbl(i).price_book_header_id :=
2516: p_price_book_header_id;
2517: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(
2518: l_price_book_messages_tbl);
2519: l_price_book_messages_tbl.delete;
2520: commit;
2521: retcode := 2;

Line 2568: QP_PRICE_BOOK_UTIL.Publish_and_Deliver(

2564:
2565: --If a template has been specified
2566: IF l_pb_input_header_rec.pub_template_code IS NOT NULL
2567: THEN
2568: QP_PRICE_BOOK_UTIL.Publish_and_Deliver(
2569: p_pb_input_header_id => p_pb_input_header_id,
2570: p_price_book_header_id => p_price_book_header_id,
2571: x_return_status => l_return_status,
2572: x_return_status_text => l_return_status_text);

Line 2586: QP_PRICE_BOOK_UTIL.Send_Sync_Catalog(

2582: END IF;
2583:
2584: --If XML Message flag checked
2585: IF l_pb_input_header_rec.dlv_xml_flag = 'Y' THEN
2586: QP_PRICE_BOOK_UTIL.Send_Sync_Catalog(
2587: p_price_book_header_id => p_price_book_header_id,
2588: x_return_status => l_return_status,
2589: x_return_status_text => l_return_status_text);
2590: fnd_file.put_line(FND_FILE.LOG, 'XML Message return status '||l_return_status);

Line 2598: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);

2594: l_price_book_messages_tbl(i).message_code := 'SYNC_CATALOG_ERROR';
2595: l_price_book_messages_tbl(i).message_text := l_return_status_text;
2596: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;
2597: l_price_book_messages_tbl(i).price_book_header_id := p_price_book_header_id;
2598: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);
2599: l_price_book_messages_tbl.delete;
2600: commit;
2601: retcode := 1;
2602: errbuf := l_return_status_text;

Line 2635: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);

2631: l_price_book_messages_tbl(i).message_text := l_message_text;
2632: l_price_book_messages_tbl(i).pb_input_header_id :=
2633: l_pb_input_header_rec.pb_input_header_id;
2634: l_price_book_messages_tbl(i).price_book_header_id := p_price_book_header_id;
2635: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Messages(l_price_book_messages_tbl);
2636: l_price_book_messages_tbl.delete;
2637: commit;
2638: retcode := 2;
2639: errbuf := l_message_text;