DBA Data[Home] [Help]

APPS.XNP_MESSAGE dependencies on FND_MESSAGE

Line 815: l_fnd_message VARCHAR2(4000) ;

811: message_properties dbms_aq.message_properties_t ;
812: message_handle RAW(16) ;
813: l_timeout NUMBER ;
814: e_q_time_out EXCEPTION ;
815: l_fnd_message VARCHAR2(4000) ;
816:
817: l_count NUMBER;
818:
819: PRAGMA EXCEPTION_INIT ( e_q_time_out, -25228 ) ;

Line 940: FND_MESSAGE.set_name ('XNP', 'DEQUEUE_TIMEOUT') ;

936: EXCEPTION
937: WHEN e_q_time_out THEN
938: x_error_code := XNP_ERRORS.G_DEQUEUE_TIMEOUT ;
939:
940: FND_MESSAGE.set_name ('XNP', 'DEQUEUE_TIMEOUT') ;
941: l_fnd_message := FND_MESSAGE.get ;
942:
943: x_error_message := l_fnd_message ;
944:

Line 941: l_fnd_message := FND_MESSAGE.get ;

937: WHEN e_q_time_out THEN
938: x_error_code := XNP_ERRORS.G_DEQUEUE_TIMEOUT ;
939:
940: FND_MESSAGE.set_name ('XNP', 'DEQUEUE_TIMEOUT') ;
941: l_fnd_message := FND_MESSAGE.get ;
942:
943: x_error_message := l_fnd_message ;
944:
945: END pop;

Line 943: x_error_message := l_fnd_message ;

939:
940: FND_MESSAGE.set_name ('XNP', 'DEQUEUE_TIMEOUT') ;
941: l_fnd_message := FND_MESSAGE.get ;
942:
943: x_error_message := l_fnd_message ;
944:
945: END pop;
946:
947: /***************************************************************************

Line 1480: -- FND_MESSAGE.set_name ('XNP', 'MSG_FIX_FEEDBACK') ;

1476:
1477:
1478: -- Now this is not supported from HTML so commented out.
1479:
1480: -- FND_MESSAGE.set_name ('XNP', 'MSG_FIX_FEEDBACK') ;
1481: -- l_feedback := FND_MESSAGE.get ;
1482: --
1483: -- htp.htmlopen;
1484: -- htp.bodyopen;

Line 1481: -- l_feedback := FND_MESSAGE.get ;

1477:
1478: -- Now this is not supported from HTML so commented out.
1479:
1480: -- FND_MESSAGE.set_name ('XNP', 'MSG_FIX_FEEDBACK') ;
1481: -- l_feedback := FND_MESSAGE.get ;
1482: --
1483: -- htp.htmlopen;
1484: -- htp.bodyopen;
1485: -- htp.p(l_feedback) ;

Line 1789: fnd_message.set_name('XNP','XNP_RUNTIME_DATA_EXISTS');

1785: l_error_code,
1786: l_error_message);
1787:
1788: IF (l_error_code <> 0) THEN
1789: fnd_message.set_name('XNP','XNP_RUNTIME_DATA_EXISTS');
1790: app_exception.raise_exception;
1791: END IF;
1792:
1793: DELETE FROM xnp_msg_structures

Line 1860: FND_MESSAGE.set_name ('XNP', 'XNP_RUNTIME_DATA_EXISTS') ;

1856: FROM XNP_CALLBACK_EVENTS
1857: WHERE msg_code = p_msg_code);
1858:
1859: x_error_code := xnp_errors.g_run_time_data_exists ;
1860: FND_MESSAGE.set_name ('XNP', 'XNP_RUNTIME_DATA_EXISTS') ;
1861: x_error_message := FND_MESSAGE.get ;
1862: RETURN ;
1863: EXCEPTION
1864: WHEN NO_DATA_FOUND THEN

Line 1861: x_error_message := FND_MESSAGE.get ;

1857: WHERE msg_code = p_msg_code);
1858:
1859: x_error_code := xnp_errors.g_run_time_data_exists ;
1860: FND_MESSAGE.set_name ('XNP', 'XNP_RUNTIME_DATA_EXISTS') ;
1861: x_error_message := FND_MESSAGE.get ;
1862: RETURN ;
1863: EXCEPTION
1864: WHEN NO_DATA_FOUND THEN
1865: NULL;

Line 1880: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;

1876: FROM XNP_MSGS
1877: WHERE msg_code=p_msg_code);
1878:
1879: x_error_code := xnp_errors.g_run_time_data_exists ;
1880: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;
1881: x_error_message := FND_MESSAGE.get ;
1882: RETURN ;
1883: EXCEPTION
1884: WHEN NO_DATA_FOUND THEN

Line 1881: x_error_message := FND_MESSAGE.get ;

1877: WHERE msg_code=p_msg_code);
1878:
1879: x_error_code := xnp_errors.g_run_time_data_exists ;
1880: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;
1881: x_error_message := FND_MESSAGE.get ;
1882: RETURN ;
1883: EXCEPTION
1884: WHEN NO_DATA_FOUND THEN
1885: NULL;

Line 1899: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;

1895: FROM XNP_TIMER_REGISTRY
1896: WHERE p_msg_code=timer_message_code);
1897:
1898: x_error_code := xnp_errors.g_run_time_data_exists ;
1899: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;
1900: x_error_message := FND_MESSAGE.get ;
1901: RETURN ;
1902: EXCEPTION
1903: WHEN NO_DATA_FOUND THEN

Line 1900: x_error_message := FND_MESSAGE.get ;

1896: WHERE p_msg_code=timer_message_code);
1897:
1898: x_error_code := xnp_errors.g_run_time_data_exists ;
1899: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;
1900: x_error_message := FND_MESSAGE.get ;
1901: RETURN ;
1902: EXCEPTION
1903: WHEN NO_DATA_FOUND THEN
1904: NULL;

Line 1916: FND_MESSAGE.set_name ('XNP', 'XNP_RUNTIME_DATA_EXISTS') ;

1912: WHERE msg_code=p_msg_code;
1913:
1914: IF (l_count <> 0) THEN
1915: x_error_code := xnp_errors.g_run_time_data_exists ;
1916: FND_MESSAGE.set_name ('XNP', 'XNP_RUNTIME_DATA_EXISTS') ;
1917: x_error_message := FND_MESSAGE.get ;
1918: RETURN ;
1919: END IF;
1920:

Line 1917: x_error_message := FND_MESSAGE.get ;

1913:
1914: IF (l_count <> 0) THEN
1915: x_error_code := xnp_errors.g_run_time_data_exists ;
1916: FND_MESSAGE.set_name ('XNP', 'XNP_RUNTIME_DATA_EXISTS') ;
1917: x_error_message := FND_MESSAGE.get ;
1918: RETURN ;
1919: END IF;
1920:
1921: SELECT count(*) INTO l_count

Line 1927: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;

1923: WHERE msg_code=p_msg_code;
1924:
1925: IF (l_count <> 0) THEN
1926: x_error_code := xnp_errors.g_run_time_data_exists ;
1927: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;
1928: x_error_message := FND_MESSAGE.get ;
1929: RETURN ;
1930: END IF;
1931:

Line 1928: x_error_message := FND_MESSAGE.get ;

1924:
1925: IF (l_count <> 0) THEN
1926: x_error_code := xnp_errors.g_run_time_data_exists ;
1927: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;
1928: x_error_message := FND_MESSAGE.get ;
1929: RETURN ;
1930: END IF;
1931:
1932: SELECT count(*) INTO l_count

Line 1938: FND_MESSAGE.set_name ('XNP', 'RUN_TIME_DATA_EXISTS') ;

1934: WHERE p_msg_code=timer_message_code;
1935:
1936: IF (l_count <> 0) THEN
1937: x_error_code := xnp_errors.g_run_time_data_exists ;
1938: FND_MESSAGE.set_name ('XNP', 'RUN_TIME_DATA_EXISTS') ;
1939: x_error_message := FND_MESSAGE.get ;
1940: RETURN ;
1941: END IF;
1942: */

Line 1939: x_error_message := FND_MESSAGE.get ;

1935:
1936: IF (l_count <> 0) THEN
1937: x_error_code := xnp_errors.g_run_time_data_exists ;
1938: FND_MESSAGE.set_name ('XNP', 'RUN_TIME_DATA_EXISTS') ;
1939: x_error_message := FND_MESSAGE.get ;
1940: RETURN ;
1941: END IF;
1942: */
1943: