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 1496: x_err_buf := substr(FND_MESSAGE.GET, 1, 240);

1492: '',
1493: FALSE, p_pb_input_header_id);
1494:
1495: IF x_request_id = 0 THEN --Error occurred
1496: x_err_buf := substr(FND_MESSAGE.GET, 1, 240);
1497: x_retcode := 2;
1498: x_return_status := 'E';
1499: ELSE -- conc request submission successful
1500: x_err_buf := '';

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

1696: FROM qp_pb_input_headers_vl
1697: WHERE pb_input_header_id = p_pb_input_header_id;
1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
1701: l_message_text := FND_MESSAGE.GET;
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;

Line 1701: l_message_text := FND_MESSAGE.GET;

1697: WHERE pb_input_header_id = p_pb_input_header_id;
1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
1701: l_message_text := FND_MESSAGE.GET;
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;

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

1757: l_pb_input_header_rec.price_book_type_code
1758: AND price_book_name = l_pb_input_header_rec.price_book_name;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1762: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1763: l_pb_input_header_rec.price_book_name);
1764: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1765: l_pb_input_header_rec.price_book_type_code);

Line 1762: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1758: AND price_book_name = l_pb_input_header_rec.price_book_name;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1762: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1763: l_pb_input_header_rec.price_book_name);
1764: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1765: l_pb_input_header_rec.price_book_type_code);
1766: l_message_text := FND_MESSAGE.GET;

Line 1764: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',

1760: WHEN OTHERS THEN
1761: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1762: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1763: l_pb_input_header_rec.price_book_name);
1764: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1765: l_pb_input_header_rec.price_book_type_code);
1766: l_message_text := FND_MESSAGE.GET;
1767: l_price_book_messages_tbl(i).message_code :=
1768: 'QP_PRICE_BOOK_DOES_NOT_EXIST';

Line 1766: l_message_text := FND_MESSAGE.GET;

1762: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1763: l_pb_input_header_rec.price_book_name);
1764: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1765: l_pb_input_header_rec.price_book_type_code);
1766: l_message_text := FND_MESSAGE.GET;
1767: l_price_book_messages_tbl(i).message_code :=
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 :=

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

1973: fnd_file.put_line(FND_FILE.LOG, 'After inserting price book header'||
1974: to_char(l_publish_price_book_header_id));
1975: EXCEPTION
1976: WHEN FND_API.G_EXC_ERROR THEN
1977: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1978: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1979: l_pb_input_header_rec.price_book_name);
1980: l_message_text := FND_MESSAGE.GET;
1981: l_price_book_messages_tbl(i).message_code :=

Line 1978: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1974: to_char(l_publish_price_book_header_id));
1975: EXCEPTION
1976: WHEN FND_API.G_EXC_ERROR THEN
1977: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1978: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1979: l_pb_input_header_rec.price_book_name);
1980: l_message_text := FND_MESSAGE.GET;
1981: l_price_book_messages_tbl(i).message_code :=
1982: 'QP_PB_EXISTS_IN_ANOTHER_ORG';

Line 1980: l_message_text := FND_MESSAGE.GET;

1976: WHEN FND_API.G_EXC_ERROR THEN
1977: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1978: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1979: l_pb_input_header_rec.price_book_name);
1980: l_message_text := FND_MESSAGE.GET;
1981: l_price_book_messages_tbl(i).message_code :=
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 :=

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

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
2026: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2027: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2028: l_pb_input_header_rec.price_book_name);
2029: l_message_text := FND_MESSAGE.GET;
2030: l_price_book_messages_tbl(i).message_code :=

Line 2027: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

2023: x_price_book_header_id => l_publish_price_book_header_id);
2024: EXCEPTION
2025: WHEN FND_API.G_EXC_ERROR THEN
2026: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2027: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2028: l_pb_input_header_rec.price_book_name);
2029: l_message_text := FND_MESSAGE.GET;
2030: l_price_book_messages_tbl(i).message_code :=
2031: 'QP_PB_EXISTS_IN_ANOTHER_ORG';

Line 2029: l_message_text := FND_MESSAGE.GET;

2025: WHEN FND_API.G_EXC_ERROR THEN
2026: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2027: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2028: l_pb_input_header_rec.price_book_name);
2029: l_message_text := FND_MESSAGE.GET;
2030: l_price_book_messages_tbl(i).message_code :=
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 :=

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

2060: RETURN;
2061: END;
2062:
2063: ELSE
2064: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
2065: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2066: l_pb_input_header_rec.price_book_name);
2067: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2068: l_pb_input_header_rec.price_book_type_code);

Line 2065: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

2061: END;
2062:
2063: ELSE
2064: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
2065: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2066: l_pb_input_header_rec.price_book_name);
2067: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2068: l_pb_input_header_rec.price_book_type_code);
2069: l_message_text := FND_MESSAGE.GET;

Line 2067: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',

2063: ELSE
2064: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
2065: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2066: l_pb_input_header_rec.price_book_name);
2067: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2068: l_pb_input_header_rec.price_book_type_code);
2069: l_message_text := FND_MESSAGE.GET;
2070: l_price_book_messages_tbl(i).message_code :=
2071: 'QP_PRICE_BOOK_ALREADY_EXISTS';

Line 2069: l_message_text := FND_MESSAGE.GET;

2065: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2066: l_pb_input_header_rec.price_book_name);
2067: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
2068: l_pb_input_header_rec.price_book_type_code);
2069: l_message_text := FND_MESSAGE.GET;
2070: l_price_book_messages_tbl(i).message_code :=
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 :=

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

2361:
2362: --dbms_output.put_line('child request id = '||l_child_request_id);
2363:
2364: IF l_child_request_id = 0 THEN
2365: errbuf := substr(FND_MESSAGE.GET, 1, 240);
2366: retcode := 2;
2367: fnd_file.put_line(FND_FILE.LOG, errbuf);
2368: ELSE --submit request successful
2369: errbuf := '';

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

2414: EXCEPTION
2415: WHEN FND_API.G_EXC_ERROR THEN
2416: l_price_book_messages_tbl(i).message_code :=
2417: 'QP_NO_PB_LINES_TO_PRICE';
2418: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');
2419: l_message_text := FND_MESSAGE.GET;
2420: l_price_book_messages_tbl(i).message_text := l_message_text;
2421: l_price_book_messages_tbl(i).pb_input_header_id :=
2422: p_pb_input_header_id;

Line 2419: l_message_text := FND_MESSAGE.GET;

2415: WHEN FND_API.G_EXC_ERROR THEN
2416: l_price_book_messages_tbl(i).message_code :=
2417: 'QP_NO_PB_LINES_TO_PRICE';
2418: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');
2419: l_message_text := FND_MESSAGE.GET;
2420: l_price_book_messages_tbl(i).message_text := l_message_text;
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 :=