DBA Data[Home] [Help]

APPS.QPR_DEAL_ETL dependencies on FND_MESSAGE

Line 1295: FND_MESSAGE.Set_Name ('QPR','QPR_COMPLIACE_ERROR');

1291: l_return_status);
1292: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1293: retcode := 2;
1294: errbuf := sqlerrm;
1295: FND_MESSAGE.Set_Name ('QPR','QPR_COMPLIACE_ERROR');
1296: FND_MSG_PUB.Add;
1297: log_debug('Error checking compliance');
1298: exit;
1299: else

Line 1619: FND_MESSAGE.Set_Name ('QPR','QPR_NO_PSG');

1615: l_pr_segment_id,
1616: l_pol_importance_code );
1617: if nvl(l_pr_segment_id,0) = 0 then
1618: retcode := 2;
1619: FND_MESSAGE.Set_Name ('QPR','QPR_NO_PSG');
1620: FND_MESSAGE.Set_Token ('LINE_ID','int_lines_rec.source_ref_line_id');
1621: FND_MSG_PUB.Add;
1622: log_debug('No pricing segment found for line:'
1623: || int_lines_rec.source_ref_line_id);

Line 1620: FND_MESSAGE.Set_Token ('LINE_ID','int_lines_rec.source_ref_line_id');

1616: l_pol_importance_code );
1617: if nvl(l_pr_segment_id,0) = 0 then
1618: retcode := 2;
1619: FND_MESSAGE.Set_Name ('QPR','QPR_NO_PSG');
1620: FND_MESSAGE.Set_Token ('LINE_ID','int_lines_rec.source_ref_line_id');
1621: FND_MSG_PUB.Add;
1622: log_debug('No pricing segment found for line:'
1623: || int_lines_rec.source_ref_line_id);
1624: return;

Line 1655: FND_MESSAGE.Set_Name ('QPR','QPR_NO_DATAMART');

1651: l_aw_name);
1652:
1653: if l_datamart_id = 0 then
1654: retcode := 2;
1655: FND_MESSAGE.Set_Name ('QPR','QPR_NO_DATAMART');
1656: FND_MESSAGE.Set_Token ('LINE_ID','int_lines_rec.source_ref_line_id');
1657: FND_MSG_PUB.Add;
1658: log_debug('No datamart found for line:'
1659: || int_lines_rec.source_ref_line_id);

Line 1656: FND_MESSAGE.Set_Token ('LINE_ID','int_lines_rec.source_ref_line_id');

1652:
1653: if l_datamart_id = 0 then
1654: retcode := 2;
1655: FND_MESSAGE.Set_Name ('QPR','QPR_NO_DATAMART');
1656: FND_MESSAGE.Set_Token ('LINE_ID','int_lines_rec.source_ref_line_id');
1657: FND_MSG_PUB.Add;
1658: log_debug('No datamart found for line:'
1659: || int_lines_rec.source_ref_line_id);
1660: return;

Line 1879: errbuf := FND_MESSAGE.GET;

1875: end if;
1876: exception
1877: WHEN NO_DATA_FOUND THEN
1878: retcode := 2;
1879: errbuf := FND_MESSAGE.GET;
1880: fnd_file.put_line( fnd_file.log, 'Deal not found in Interface tables');
1881: when others then
1882: retcode := 2;
1883: errbuf := FND_MESSAGE.GET;

Line 1883: errbuf := FND_MESSAGE.GET;

1879: errbuf := FND_MESSAGE.GET;
1880: fnd_file.put_line( fnd_file.log, 'Deal not found in Interface tables');
1881: when others then
1882: retcode := 2;
1883: errbuf := FND_MESSAGE.GET;
1884: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));
1885: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1886: end process_deal;
1887:

Line 1935: FND_MESSAGE.Set_Name ('QPR','QPR_NO_LINES');

1931: and source_id = p_source_id
1932: and pn_req_line_status_flag = 'I' and rownum < 2;
1933: exception
1934: when NO_DATA_FOUND then
1935: FND_MESSAGE.Set_Name ('QPR','QPR_NO_LINES');
1936: FND_MESSAGE.Set_Token ('HEADER_ID','l_pn_int_hdr');
1937: FND_MSG_PUB.Add;
1938: log_debug('No lines exist for the Header: '||l_pn_int_hdr);
1939: retcode := 2;

Line 1936: FND_MESSAGE.Set_Token ('HEADER_ID','l_pn_int_hdr');

1932: and pn_req_line_status_flag = 'I' and rownum < 2;
1933: exception
1934: when NO_DATA_FOUND then
1935: FND_MESSAGE.Set_Name ('QPR','QPR_NO_LINES');
1936: FND_MESSAGE.Set_Token ('HEADER_ID','l_pn_int_hdr');
1937: FND_MSG_PUB.Add;
1938: log_debug('No lines exist for the Header: '||l_pn_int_hdr);
1939: retcode := 2;
1940: errbuf := 'No lines exist for quote';

Line 1984: errbuf := FND_MESSAGE.GET;

1980: end;
1981: exception
1982: when others then
1983: retcode := 2;
1984: errbuf := FND_MESSAGE.GET;
1985: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));
1986: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1987: end process_deal_api;
1988: