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 FND_MESSAGE

Line 1476: x_err_buf := substr(FND_MESSAGE.GET, 1, 240);

1472: '',
1473: FALSE, p_pb_input_header_id);
1474:
1475: IF x_request_id = 0 THEN --Error occurred
1476: x_err_buf := substr(FND_MESSAGE.GET, 1, 240);
1477: x_retcode := 2;
1478: x_return_status := 'E';
1479: ELSE -- conc request submission successful
1480: x_err_buf := '';

Line 1719: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');

1715: FROM qp_pb_input_headers_vl
1716: WHERE pb_input_header_id = p_pb_input_header_id;
1717: EXCEPTION
1718: WHEN OTHERS THEN
1719: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
1720: l_message_text := FND_MESSAGE.GET;
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;

Line 1720: l_message_text := FND_MESSAGE.GET;

1716: WHERE pb_input_header_id = p_pb_input_header_id;
1717: EXCEPTION
1718: WHEN OTHERS THEN
1719: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
1720: l_message_text := FND_MESSAGE.GET;
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;

Line 1780: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');

1776: l_pb_input_header_rec.price_book_type_code
1777: AND price_book_name = l_pb_input_header_rec.price_book_name;
1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1781: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1782: l_pb_input_header_rec.price_book_name);
1783: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1784: l_pb_input_header_rec.price_book_type_code);

Line 1781: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1777: AND price_book_name = l_pb_input_header_rec.price_book_name;
1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1781: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1782: l_pb_input_header_rec.price_book_name);
1783: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1784: l_pb_input_header_rec.price_book_type_code);
1785: l_message_text := FND_MESSAGE.GET;

Line 1783: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',

1779: WHEN OTHERS THEN
1780: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1781: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1782: l_pb_input_header_rec.price_book_name);
1783: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1784: l_pb_input_header_rec.price_book_type_code);
1785: l_message_text := FND_MESSAGE.GET;
1786: l_price_book_messages_tbl(i).message_code :=
1787: 'QP_PRICE_BOOK_DOES_NOT_EXIST';

Line 1785: l_message_text := FND_MESSAGE.GET;

1781: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1782: l_pb_input_header_rec.price_book_name);
1783: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1784: l_pb_input_header_rec.price_book_type_code);
1785: l_message_text := FND_MESSAGE.GET;
1786: l_price_book_messages_tbl(i).message_code :=
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 :=

Line 1996: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');

1992: fnd_file.put_line(FND_FILE.LOG, 'After inserting price book header'||
1993: to_char(l_publish_price_book_header_id));
1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1997: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1998: l_pb_input_header_rec.price_book_name);
1999: l_message_text := FND_MESSAGE.GET;
2000: l_price_book_messages_tbl(i).message_code :=

Line 1997: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1993: to_char(l_publish_price_book_header_id));
1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1997: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1998: l_pb_input_header_rec.price_book_name);
1999: l_message_text := FND_MESSAGE.GET;
2000: l_price_book_messages_tbl(i).message_code :=
2001: 'QP_PB_EXISTS_IN_ANOTHER_ORG';

Line 1999: l_message_text := FND_MESSAGE.GET;

1995: WHEN FND_API.G_EXC_ERROR THEN
1996: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1997: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1998: l_pb_input_header_rec.price_book_name);
1999: l_message_text := FND_MESSAGE.GET;
2000: l_price_book_messages_tbl(i).message_code :=
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 :=

Line 2045: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');

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
2045: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2046: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2047: l_pb_input_header_rec.price_book_name);
2048: l_message_text := FND_MESSAGE.GET;
2049: l_price_book_messages_tbl(i).message_code :=

Line 2046: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

2042: x_price_book_header_id => l_publish_price_book_header_id);
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN
2045: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2046: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2047: l_pb_input_header_rec.price_book_name);
2048: l_message_text := FND_MESSAGE.GET;
2049: l_price_book_messages_tbl(i).message_code :=
2050: 'QP_PB_EXISTS_IN_ANOTHER_ORG';

Line 2048: l_message_text := FND_MESSAGE.GET;

2044: WHEN FND_API.G_EXC_ERROR THEN
2045: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2046: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2047: l_pb_input_header_rec.price_book_name);
2048: l_message_text := FND_MESSAGE.GET;
2049: l_price_book_messages_tbl(i).message_code :=
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 :=

Line 2083: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');

2079: RETURN;
2080: END;
2081:
2082: ELSE
2083: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
2084: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2085: l_pb_input_header_rec.price_book_name);
2086: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2087: l_pb_input_header_rec.price_book_type_code);

Line 2084: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

2080: END;
2081:
2082: ELSE
2083: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
2084: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2085: l_pb_input_header_rec.price_book_name);
2086: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2087: l_pb_input_header_rec.price_book_type_code);
2088: l_message_text := FND_MESSAGE.GET;

Line 2086: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',

2082: ELSE
2083: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
2084: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2085: l_pb_input_header_rec.price_book_name);
2086: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2087: l_pb_input_header_rec.price_book_type_code);
2088: l_message_text := FND_MESSAGE.GET;
2089: l_price_book_messages_tbl(i).message_code :=
2090: 'QP_PRICE_BOOK_ALREADY_EXISTS';

Line 2088: l_message_text := FND_MESSAGE.GET;

2084: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2085: l_pb_input_header_rec.price_book_name);
2086: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2087: l_pb_input_header_rec.price_book_type_code);
2088: l_message_text := FND_MESSAGE.GET;
2089: l_price_book_messages_tbl(i).message_code :=
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 :=

Line 2386: errbuf := substr(FND_MESSAGE.GET, 1, 240);

2382:
2383: --dbms_output.put_line('child request id = '||l_child_request_id);
2384:
2385: IF l_child_request_id = 0 THEN
2386: errbuf := substr(FND_MESSAGE.GET, 1, 240);
2387: retcode := 2;
2388: fnd_file.put_line(FND_FILE.LOG, errbuf);
2389: ELSE --submit request successful
2390: errbuf := '';

Line 2439: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');

2435: EXCEPTION
2436: WHEN FND_API.G_EXC_ERROR THEN
2437: l_price_book_messages_tbl(i).message_code :=
2438: 'QP_NO_PB_LINES_TO_PRICE';
2439: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');
2440: l_message_text := FND_MESSAGE.GET;
2441: l_price_book_messages_tbl(i).message_text := l_message_text;
2442: l_price_book_messages_tbl(i).pb_input_header_id :=
2443: p_pb_input_header_id;

Line 2440: l_message_text := FND_MESSAGE.GET;

2436: WHEN FND_API.G_EXC_ERROR THEN
2437: l_price_book_messages_tbl(i).message_code :=
2438: 'QP_NO_PB_LINES_TO_PRICE';
2439: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');
2440: l_message_text := FND_MESSAGE.GET;
2441: l_price_book_messages_tbl(i).message_text := l_message_text;
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 :=