DBA Data[Home] [Help]

APPS.PQP_GB_TP_EXT_PROCESS dependencies on FND_MESSAGE

Line 146: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');

142: OPEN csr_get_ext_rslt_id;
143: FETCH csr_get_ext_rslt_id INTO l_ext_rslt_id;
144:
145: IF csr_get_ext_rslt_id%NOTFOUND THEN
146: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
147: fnd_file.put_line(fnd_file.log, 'Error: '
148: || fnd_message.get);
149: fnd_file.put_line(fnd_file.log, ' ');
150: CLOSE csr_get_ext_rslt_id;

Line 148: || fnd_message.get);

144:
145: IF csr_get_ext_rslt_id%NOTFOUND THEN
146: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
147: fnd_file.put_line(fnd_file.log, 'Error: '
148: || fnd_message.get);
149: fnd_file.put_line(fnd_file.log, ' ');
150: CLOSE csr_get_ext_rslt_id;
151: fnd_message.raise_error;
152: END IF; -- End if of row not found check ...

Line 151: fnd_message.raise_error;

147: fnd_file.put_line(fnd_file.log, 'Error: '
148: || fnd_message.get);
149: fnd_file.put_line(fnd_file.log, ' ');
150: CLOSE csr_get_ext_rslt_id;
151: fnd_message.raise_error;
152: END IF; -- End if of row not found check ...
153: CLOSE csr_get_ext_rslt_id;
154:
155: IF g_debug

Line 383: fnd_message.raise_error;

379: THEN
380: DEBUG ( 'Leaving: '
381: || l_proc_name, -999);
382: END IF;
383: fnd_message.raise_error;
384: ELSE
385: RAISE;
386: END IF;
387:

Line 906: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');

902:
903: IF l_ext_rslt_info_rec.ext_rslt_id IS NULL THEN
904: -- Error
905: -- There is no result for master business group
906: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
907: fnd_file.put_line(fnd_file.log, 'Error: '
908: || fnd_message.get);
909: fnd_file.put_line(fnd_file.log, ' ');
910: fnd_message.raise_error;

Line 908: || fnd_message.get);

904: -- Error
905: -- There is no result for master business group
906: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
907: fnd_file.put_line(fnd_file.log, 'Error: '
908: || fnd_message.get);
909: fnd_file.put_line(fnd_file.log, ' ');
910: fnd_message.raise_error;
911: END IF; -- End if of ext rslt id null check ...
912:

Line 910: fnd_message.raise_error;

906: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
907: fnd_file.put_line(fnd_file.log, 'Error: '
908: || fnd_message.get);
909: fnd_file.put_line(fnd_file.log, ' ');
910: fnd_message.raise_error;
911: END IF; -- End if of ext rslt id null check ...
912:
913: --
914: -- Fetch the file id for the extract

Line 926: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');

922: OPEN csr_get_ext_param;
923: FETCH csr_get_ext_param INTO l_ext_param_rec;
924:
925: IF csr_get_ext_param%NOTFOUND THEN
926: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
927: fnd_file.put_line(fnd_file.log, 'Error: '
928: || fnd_message.get);
929: fnd_file.put_line(fnd_file.log, ' ');
930: CLOSE csr_get_ext_param;

Line 928: || fnd_message.get);

924:
925: IF csr_get_ext_param%NOTFOUND THEN
926: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
927: fnd_file.put_line(fnd_file.log, 'Error: '
928: || fnd_message.get);
929: fnd_file.put_line(fnd_file.log, ' ');
930: CLOSE csr_get_ext_param;
931: fnd_message.raise_error;
932: END IF; -- End if of row not found check ...

Line 931: fnd_message.raise_error;

927: fnd_file.put_line(fnd_file.log, 'Error: '
928: || fnd_message.get);
929: fnd_file.put_line(fnd_file.log, ' ');
930: CLOSE csr_get_ext_param;
931: fnd_message.raise_error;
932: END IF; -- End if of row not found check ...
933: CLOSE csr_get_ext_param;
934:
935: IF g_debug

Line 1529: fnd_message.set_name('PQP', 'PQP_230036_MULTIPLE_TP_EXT_ERR');

1525: -- can not submit a second one
1526: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1527:
1528: -- Exiting because another process is running and you can not submit twice
1529: fnd_message.set_name('PQP', 'PQP_230036_MULTIPLE_TP_EXT_ERR');
1530: fnd_file.put_line(fnd_file.log, fnd_message.get);
1531: fnd_message.raise_error;
1532: RETURN;
1533:

Line 1530: fnd_file.put_line(fnd_file.log, fnd_message.get);

1526: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1527:
1528: -- Exiting because another process is running and you can not submit twice
1529: fnd_message.set_name('PQP', 'PQP_230036_MULTIPLE_TP_EXT_ERR');
1530: fnd_file.put_line(fnd_file.log, fnd_message.get);
1531: fnd_message.raise_error;
1532: RETURN;
1533:
1534: END IF;

Line 1531: fnd_message.raise_error;

1527:
1528: -- Exiting because another process is running and you can not submit twice
1529: fnd_message.set_name('PQP', 'PQP_230036_MULTIPLE_TP_EXT_ERR');
1530: fnd_file.put_line(fnd_file.log, fnd_message.get);
1531: fnd_message.raise_error;
1532: RETURN;
1533:
1534: END IF;
1535:

Line 1810: fnd_message.set_name('PQP', 'PQP_230037_CURR_BG_NOT_LEA_ERR');

1806:
1807: -- Error out as the current BG is not set up as an LEA
1808: fail_current_extract_run(p_ext_dfn_id => p_ext_dfn_id);
1809:
1810: fnd_message.set_name('PQP', 'PQP_230037_CURR_BG_NOT_LEA_ERR');
1811: l_err_msg := fnd_message.get;
1812: errbuf := l_err_msg;
1813: retcode := PROGRAM_FAILURE;
1814: fnd_file.put_line(fnd_file.log, l_err_msg);

Line 1811: l_err_msg := fnd_message.get;

1807: -- Error out as the current BG is not set up as an LEA
1808: fail_current_extract_run(p_ext_dfn_id => p_ext_dfn_id);
1809:
1810: fnd_message.set_name('PQP', 'PQP_230037_CURR_BG_NOT_LEA_ERR');
1811: l_err_msg := fnd_message.get;
1812: errbuf := l_err_msg;
1813: retcode := PROGRAM_FAILURE;
1814: fnd_file.put_line(fnd_file.log, l_err_msg);
1815:

Line 1816: fnd_message.raise_error;

1812: errbuf := l_err_msg;
1813: retcode := PROGRAM_FAILURE;
1814: fnd_file.put_line(fnd_file.log, l_err_msg);
1815:
1816: fnd_message.raise_error;
1817:
1818: RETURN;
1819:
1820: END IF; -- Chk Lea number from BG Level

Line 1885: fnd_message.set_name('PQP', 'PQP_230037_CURR_BG_NOT_LEA_ERR');

1881: -- Bugfix 3671727:ENH1:ENH2 :Moved code from here into new proc
1882: -- as we need to call it from more than one places
1883: fail_current_extract_run(p_ext_dfn_id => p_ext_dfn_id);
1884:
1885: fnd_message.set_name('PQP', 'PQP_230037_CURR_BG_NOT_LEA_ERR');
1886: l_err_msg := fnd_message.get;
1887: errbuf := l_err_msg;
1888: retcode := PROGRAM_FAILURE;
1889: fnd_file.put_line(fnd_file.log, l_err_msg);

Line 1886: l_err_msg := fnd_message.get;

1882: -- as we need to call it from more than one places
1883: fail_current_extract_run(p_ext_dfn_id => p_ext_dfn_id);
1884:
1885: fnd_message.set_name('PQP', 'PQP_230037_CURR_BG_NOT_LEA_ERR');
1886: l_err_msg := fnd_message.get;
1887: errbuf := l_err_msg;
1888: retcode := PROGRAM_FAILURE;
1889: fnd_file.put_line(fnd_file.log, l_err_msg);
1890:

Line 1891: fnd_message.raise_error;

1887: errbuf := l_err_msg;
1888: retcode := PROGRAM_FAILURE;
1889: fnd_file.put_line(fnd_file.log, l_err_msg);
1890:
1891: fnd_message.raise_error;
1892:
1893: RETURN;
1894:
1895: END IF;

Line 1978: fnd_message.set_name('PQP', 'PQP_230038_EXT_PROC_SUBMIT_ERR');

1974: OPEN csr_bg_name(l_curr_bg_id);
1975: FETCH csr_bg_name INTO l_bg_name;
1976: CLOSE csr_bg_name;
1977:
1978: fnd_message.set_name('PQP', 'PQP_230038_EXT_PROC_SUBMIT_ERR');
1979: fnd_message.set_token('BGNAME', l_bg_name);
1980: l_err_msg := fnd_message.get;
1981: errbuf := l_err_msg;
1982: fnd_file.put_line(fnd_file.log, l_err_msg);

Line 1979: fnd_message.set_token('BGNAME', l_bg_name);

1975: FETCH csr_bg_name INTO l_bg_name;
1976: CLOSE csr_bg_name;
1977:
1978: fnd_message.set_name('PQP', 'PQP_230038_EXT_PROC_SUBMIT_ERR');
1979: fnd_message.set_token('BGNAME', l_bg_name);
1980: l_err_msg := fnd_message.get;
1981: errbuf := l_err_msg;
1982: fnd_file.put_line(fnd_file.log, l_err_msg);
1983: l_retcode := PROGRAM_FAILURE ;

Line 1980: l_err_msg := fnd_message.get;

1976: CLOSE csr_bg_name;
1977:
1978: fnd_message.set_name('PQP', 'PQP_230038_EXT_PROC_SUBMIT_ERR');
1979: fnd_message.set_token('BGNAME', l_bg_name);
1980: l_err_msg := fnd_message.get;
1981: errbuf := l_err_msg;
1982: fnd_file.put_line(fnd_file.log, l_err_msg);
1983: l_retcode := PROGRAM_FAILURE ;
1984: l_err_msg := NULL;

Line 2024: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');

2020: OPEN csr_bg_name(l_curr_bg_id);
2021: FETCH csr_bg_name INTO l_bg_name;
2022: CLOSE csr_bg_name;
2023:
2024: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');
2025: fnd_message.set_token('BGNAME', l_bg_name);
2026: l_err_msg := fnd_message.get;
2027: errbuf := l_err_msg;
2028: fnd_file.put_line(fnd_file.log, l_err_msg);

Line 2025: fnd_message.set_token('BGNAME', l_bg_name);

2021: FETCH csr_bg_name INTO l_bg_name;
2022: CLOSE csr_bg_name;
2023:
2024: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');
2025: fnd_message.set_token('BGNAME', l_bg_name);
2026: l_err_msg := fnd_message.get;
2027: errbuf := l_err_msg;
2028: fnd_file.put_line(fnd_file.log, l_err_msg);
2029: l_retcode := PROGRAM_FAILURE ;

Line 2026: l_err_msg := fnd_message.get;

2022: CLOSE csr_bg_name;
2023:
2024: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');
2025: fnd_message.set_token('BGNAME', l_bg_name);
2026: l_err_msg := fnd_message.get;
2027: errbuf := l_err_msg;
2028: fnd_file.put_line(fnd_file.log, l_err_msg);
2029: l_retcode := PROGRAM_FAILURE ;
2030: l_err_msg := NULL;

Line 2077: fnd_message.raise_error;

2073:
2074: COMMIT;
2075:
2076: retcode := l_retcode;
2077: fnd_message.raise_error;
2078: RETURN;
2079:
2080: END IF;
2081:

Line 2118: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');

2114: OPEN csr_bg_name(l_curr_bg_id);
2115: FETCH csr_bg_name INTO l_bg_name;
2116: CLOSE csr_bg_name;
2117:
2118: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');
2119: fnd_message.set_token('BGNAME', l_bg_name);
2120: l_err_msg := fnd_message.get;
2121: errbuf := l_err_msg;
2122: fnd_file.put_line(fnd_file.log, l_err_msg);

Line 2119: fnd_message.set_token('BGNAME', l_bg_name);

2115: FETCH csr_bg_name INTO l_bg_name;
2116: CLOSE csr_bg_name;
2117:
2118: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');
2119: fnd_message.set_token('BGNAME', l_bg_name);
2120: l_err_msg := fnd_message.get;
2121: errbuf := l_err_msg;
2122: fnd_file.put_line(fnd_file.log, l_err_msg);
2123: l_retcode := PROGRAM_FAILURE ;

Line 2120: l_err_msg := fnd_message.get;

2116: CLOSE csr_bg_name;
2117:
2118: fnd_message.set_name('PQP', 'PQP_230039_EXT_PROC_EXEC_ERR');
2119: fnd_message.set_token('BGNAME', l_bg_name);
2120: l_err_msg := fnd_message.get;
2121: errbuf := l_err_msg;
2122: fnd_file.put_line(fnd_file.log, l_err_msg);
2123: l_retcode := PROGRAM_FAILURE ;
2124: l_err_msg:= NULL;

Line 2160: fnd_message.raise_error;

2156:
2157: COMMIT;
2158:
2159: retcode := l_retcode;
2160: fnd_message.raise_error;
2161: RETURN;
2162: END IF;
2163:
2164: END IF; -- g_execution_mode = 'PARALLEL' THEN