DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on FND_MESSAGE

Line 331: FND_MESSAGE.set_name('IGC','IGC_CC_CBC_RESULT_CODE_'||x_batch_result_code);

327: FND_API.G_FALSE);
328:
329: IF x_batch_result_code IN ('H00','H04','H12') THEN
330:
331: FND_MESSAGE.set_name('IGC','IGC_CC_CBC_RESULT_CODE_'||x_batch_result_code);
332: errbuf := FND_MESSAGE.get;
333: retcode := 1;
334:
335: END IF;

Line 332: errbuf := FND_MESSAGE.get;

328:
329: IF x_batch_result_code IN ('H00','H04','H12') THEN
330:
331: FND_MESSAGE.set_name('IGC','IGC_CC_CBC_RESULT_CODE_'||x_batch_result_code);
332: errbuf := FND_MESSAGE.get;
333: retcode := 1;
334:
335: END IF;
336:

Line 1222: --fnd_message.retrieve;

1218: commit;
1219: -- Verify that the concurrent request was launched
1220: -- successfully.
1221: IF (req_id = 0) THEN
1222: --fnd_message.retrieve;
1223: -- fnd_message.error;
1224: Raise User_Exception;
1225: ELSE
1226: COMMIT;

Line 1223: -- fnd_message.error;

1219: -- Verify that the concurrent request was launched
1220: -- successfully.
1221: IF (req_id = 0) THEN
1222: --fnd_message.retrieve;
1223: -- fnd_message.error;
1224: Raise User_Exception;
1225: ELSE
1226: COMMIT;
1227: l_request_status := check_request(req_id);

Line 1270: --fnd_message.retrieve;

1266: commit;
1267: -- Verify that the concurrent request was launched
1268: -- successfully.
1269: IF (v_req_id = 0) THEN
1270: --fnd_message.retrieve;
1271: --fnd_message.error;
1272: Raise User_Exception;
1273: ELSE
1274: COMMIT;

Line 1271: --fnd_message.error;

1267: -- Verify that the concurrent request was launched
1268: -- successfully.
1269: IF (v_req_id = 0) THEN
1270: --fnd_message.retrieve;
1271: --fnd_message.error;
1272: Raise User_Exception;
1273: ELSE
1274: COMMIT;
1275: l_request_status := check_request(v_req_id);

Line 1488: --fnd_message.retrieve;

1484:
1485: -- Verify that the concurrent request was launched
1486: -- successfully.
1487: IF (req_id = 0) THEN
1488: --fnd_message.retrieve;
1489: --fnd_message.error;
1490: Raise user_exception;
1491: ELSE
1492: COMMIT;

Line 1489: --fnd_message.error;

1485: -- Verify that the concurrent request was launched
1486: -- successfully.
1487: IF (req_id = 0) THEN
1488: --fnd_message.retrieve;
1489: --fnd_message.error;
1490: Raise user_exception;
1491: ELSE
1492: COMMIT;
1493: l_request_status := check_request(req_id);

Line 1647: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');

1643: AND bud.ledger_id = g_cbc_ledger_id
1644: )
1645: );
1646: IF l_dummy = '1' THEN
1647: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');
1648: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);
1649: l_error := FND_MESSAGE.get;
1650: add_error (l_error);
1651: return;

Line 1648: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);

1644: )
1645: );
1646: IF l_dummy = '1' THEN
1647: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');
1648: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);
1649: l_error := FND_MESSAGE.get;
1650: add_error (l_error);
1651: return;
1652: END IF;

Line 1649: l_error := FND_MESSAGE.get;

1645: );
1646: IF l_dummy = '1' THEN
1647: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');
1648: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);
1649: l_error := FND_MESSAGE.get;
1650: add_error (l_error);
1651: return;
1652: END IF;
1653: EXCEPTION

Line 1904: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');

1900: FROM igi_lookups
1901: WHERE lookup_code = 'CBC'
1902: AND lookup_type = 'GCC_DESCRIPTION';
1903:
1904: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1905: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1906: l_error := fnd_message.get;
1907: add_error (l_error);
1908: x_msg_buf := l_error;

Line 1905: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);

1901: WHERE lookup_code = 'CBC'
1902: AND lookup_type = 'GCC_DESCRIPTION';
1903:
1904: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1905: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1906: l_error := fnd_message.get;
1907: add_error (l_error);
1908: x_msg_buf := l_error;
1909: x_return_code := 2;

Line 1906: l_error := fnd_message.get;

1902: AND lookup_type = 'GCC_DESCRIPTION';
1903:
1904: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
1905: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
1906: l_error := fnd_message.get;
1907: add_error (l_error);
1908: x_msg_buf := l_error;
1909: x_return_code := 2;
1910: return;

Line 1920: FND_MESSAGE.set_name('IGC','IGC_NO_CBC_LEDGER');

1916: Put_Debug_Msg(l_full_path, 'Secondary Ledger Name: ' || g_cbc_ledger_name);
1917: END IF;
1918: */
1919: IF (g_cbc_ledger_id <= 0) THEN
1920: FND_MESSAGE.set_name('IGC','IGC_NO_CBC_LEDGER');
1921: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_sob_name);
1922: x_return_code := 2;
1923: l_error := FND_MESSAGE.get;
1924: add_error (l_error);

Line 1921: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_sob_name);

1917: END IF;
1918: */
1919: IF (g_cbc_ledger_id <= 0) THEN
1920: FND_MESSAGE.set_name('IGC','IGC_NO_CBC_LEDGER');
1921: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_sob_name);
1922: x_return_code := 2;
1923: l_error := FND_MESSAGE.get;
1924: add_error (l_error);
1925: x_msg_buf := l_error ;

Line 1923: l_error := FND_MESSAGE.get;

1919: IF (g_cbc_ledger_id <= 0) THEN
1920: FND_MESSAGE.set_name('IGC','IGC_NO_CBC_LEDGER');
1921: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_sob_name);
1922: x_return_code := 2;
1923: l_error := FND_MESSAGE.get;
1924: add_error (l_error);
1925: x_msg_buf := l_error ;
1926: return;
1927: END IF;

Line 1940: FND_MESSAGE.set_name('IGC','IGC_CBC_MIG_CLOSE_PERIOD');

1936: AND period_year = p_fin_year
1937: AND ledger_id = g_cbc_ledger_id
1938: AND adjustment_period_flag = 'N';
1939: IF nvl(l_tot_count,0) = 0 OR (l_open_count <> l_tot_count) THEN
1940: FND_MESSAGE.set_name('IGC','IGC_CBC_MIG_CLOSE_PERIOD');
1941: FND_MESSAGE.SET_TOKEN('YEAR',p_fin_year);
1942: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1943: l_error := FND_MESSAGE.get;
1944: add_error (l_error);

Line 1941: FND_MESSAGE.SET_TOKEN('YEAR',p_fin_year);

1937: AND ledger_id = g_cbc_ledger_id
1938: AND adjustment_period_flag = 'N';
1939: IF nvl(l_tot_count,0) = 0 OR (l_open_count <> l_tot_count) THEN
1940: FND_MESSAGE.set_name('IGC','IGC_CBC_MIG_CLOSE_PERIOD');
1941: FND_MESSAGE.SET_TOKEN('YEAR',p_fin_year);
1942: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1943: l_error := FND_MESSAGE.get;
1944: add_error (l_error);
1945: x_msg_buf := l_error ;

Line 1942: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);

1938: AND adjustment_period_flag = 'N';
1939: IF nvl(l_tot_count,0) = 0 OR (l_open_count <> l_tot_count) THEN
1940: FND_MESSAGE.set_name('IGC','IGC_CBC_MIG_CLOSE_PERIOD');
1941: FND_MESSAGE.SET_TOKEN('YEAR',p_fin_year);
1942: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1943: l_error := FND_MESSAGE.get;
1944: add_error (l_error);
1945: x_msg_buf := l_error ;
1946: x_return_code := 2;

Line 1943: l_error := FND_MESSAGE.get;

1939: IF nvl(l_tot_count,0) = 0 OR (l_open_count <> l_tot_count) THEN
1940: FND_MESSAGE.set_name('IGC','IGC_CBC_MIG_CLOSE_PERIOD');
1941: FND_MESSAGE.SET_TOKEN('YEAR',p_fin_year);
1942: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1943: l_error := FND_MESSAGE.get;
1944: add_error (l_error);
1945: x_msg_buf := l_error ;
1946: x_return_code := 2;
1947: return;

Line 1966: FND_MESSAGE.set_name('IGC','IGC_CBC_LEDG_ACCESS');

1962: AND acc.access_privilege_code in ('B','F')
1963: AND lgr.ledger_id = g_cbc_ledger_id;
1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN
1966: FND_MESSAGE.set_name('IGC','IGC_CBC_LEDG_ACCESS');
1967: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1968: l_error := FND_MESSAGE.get;
1969: add_error (l_error);
1970: x_msg_buf := l_error ;

Line 1967: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);

1963: AND lgr.ledger_id = g_cbc_ledger_id;
1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN
1966: FND_MESSAGE.set_name('IGC','IGC_CBC_LEDG_ACCESS');
1967: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1968: l_error := FND_MESSAGE.get;
1969: add_error (l_error);
1970: x_msg_buf := l_error ;
1971: x_return_code := 2;

Line 1968: l_error := FND_MESSAGE.get;

1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN
1966: FND_MESSAGE.set_name('IGC','IGC_CBC_LEDG_ACCESS');
1967: FND_MESSAGE.SET_TOKEN('LEDGER_NAME',g_cbc_ledger_name);
1968: l_error := FND_MESSAGE.get;
1969: add_error (l_error);
1970: x_msg_buf := l_error ;
1971: x_return_code := 2;
1972: END;

Line 2012: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');

2008: AND bud.ledger_id = g_cbc_ledger_id
2009: )
2010: );
2011: IF l_dummy = '1' THEN
2012: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');
2013: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);
2014: l_error := FND_MESSAGE.get;
2015: add_error (l_error);
2016: END IF;

Line 2013: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);

2009: )
2010: );
2011: IF l_dummy = '1' THEN
2012: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');
2013: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);
2014: l_error := FND_MESSAGE.get;
2015: add_error (l_error);
2016: END IF;
2017: EXCEPTION

Line 2014: l_error := FND_MESSAGE.get;

2010: );
2011: IF l_dummy = '1' THEN
2012: FND_MESSAGE.set_name('IGC','IGC_CBC_BUD_DATA_MISS');
2013: FND_MESSAGE.SET_TOKEN('PROGRAM_NAME',g_conc_pr_user);
2014: l_error := FND_MESSAGE.get;
2015: add_error (l_error);
2016: END IF;
2017: EXCEPTION
2018: WHEN NO_DATA_FOUND THEN

Line 2060: FND_MESSAGE.set_name('IGC','IGC_CBC_CONC_FAIL');

2056: IF l_return >= 0 THEN
2057: l_return := 1;
2058: END IF;
2059: ELSE
2060: FND_MESSAGE.set_name('IGC','IGC_CBC_CONC_FAIL');
2061: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_other_request);
2062: l_error := FND_MESSAGE.get;
2063: add_error (l_error);
2064: l_return := -1;

Line 2061: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_other_request);

2057: l_return := 1;
2058: END IF;
2059: ELSE
2060: FND_MESSAGE.set_name('IGC','IGC_CBC_CONC_FAIL');
2061: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_other_request);
2062: l_error := FND_MESSAGE.get;
2063: add_error (l_error);
2064: l_return := -1;
2065: END IF;

Line 2062: l_error := FND_MESSAGE.get;

2058: END IF;
2059: ELSE
2060: FND_MESSAGE.set_name('IGC','IGC_CBC_CONC_FAIL');
2061: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_other_request);
2062: l_error := FND_MESSAGE.get;
2063: add_error (l_error);
2064: l_return := -1;
2065: END IF;
2066: END LOOP;