DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on RCV_DCP_PVT

Line 1: PACKAGE BODY rcv_dcp_pvt AS

1: PACKAGE BODY rcv_dcp_pvt AS
2: /* $Header: INVRDCPB.pls 120.14.12020000.2 2012/07/09 08:16:02 asugandh ship $ */
3: g_pkg_name CONSTANT VARCHAR2(50) := 'RCV_DCP_PVT';
4: g_userid NUMBER;
5: g_user_email VARCHAR2(32767);

Line 3: g_pkg_name CONSTANT VARCHAR2(50) := 'RCV_DCP_PVT';

1: PACKAGE BODY rcv_dcp_pvt AS
2: /* $Header: INVRDCPB.pls 120.14.12020000.2 2012/07/09 08:16:02 asugandh ship $ */
3: g_pkg_name CONSTANT VARCHAR2(50) := 'RCV_DCP_PVT';
4: g_userid NUMBER;
5: g_user_email VARCHAR2(32767);
6: g_user_name VARCHAR2(32767);
7: g_env VARCHAR2(32767);

Line 26: IF rcv_dcp_pvt.g_email_server IS NOT NULL THEN

22: IF l_debug_on THEN
23: asn_debug.put_line('Entering ' || l_module_name);
24: END IF;
25:
26: IF rcv_dcp_pvt.g_email_server IS NOT NULL THEN
27: IF l_debug_on THEN
28: asn_debug.put_line('Server name in cache:' || rcv_dcp_pvt.g_email_server);
29: END IF;
30:

Line 28: asn_debug.put_line('Server name in cache:' || rcv_dcp_pvt.g_email_server);

24: END IF;
25:
26: IF rcv_dcp_pvt.g_email_server IS NOT NULL THEN
27: IF l_debug_on THEN
28: asn_debug.put_line('Server name in cache:' || rcv_dcp_pvt.g_email_server);
29: END IF;
30:
31: RETURN rcv_dcp_pvt.g_email_server;
32: END IF;

Line 31: RETURN rcv_dcp_pvt.g_email_server;

27: IF l_debug_on THEN
28: asn_debug.put_line('Server name in cache:' || rcv_dcp_pvt.g_email_server);
29: END IF;
30:
31: RETURN rcv_dcp_pvt.g_email_server;
32: END IF;
33:
34: rcv_dcp_pvt.g_email_server := fnd_profile.VALUE('RCV_DCP_EMAIL_SERVER');
35:

Line 34: rcv_dcp_pvt.g_email_server := fnd_profile.VALUE('RCV_DCP_EMAIL_SERVER');

30:
31: RETURN rcv_dcp_pvt.g_email_server;
32: END IF;
33:
34: rcv_dcp_pvt.g_email_server := fnd_profile.VALUE('RCV_DCP_EMAIL_SERVER');
35:
36: IF l_debug_on THEN
37: asn_debug.put_line('Server name profile :' || rcv_dcp_pvt.g_email_server);
38: END IF;

Line 37: asn_debug.put_line('Server name profile :' || rcv_dcp_pvt.g_email_server);

33:
34: rcv_dcp_pvt.g_email_server := fnd_profile.VALUE('RCV_DCP_EMAIL_SERVER');
35:
36: IF l_debug_on THEN
37: asn_debug.put_line('Server name profile :' || rcv_dcp_pvt.g_email_server);
38: END IF;
39:
40: RETURN rcv_dcp_pvt.g_email_server;
41: EXCEPTION

Line 40: RETURN rcv_dcp_pvt.g_email_server;

36: IF l_debug_on THEN
37: asn_debug.put_line('Server name profile :' || rcv_dcp_pvt.g_email_server);
38: END IF;
39:
40: RETURN rcv_dcp_pvt.g_email_server;
41: EXCEPTION
42: WHEN OTHERS THEN
43: IF l_debug_on THEN
44: asn_debug.put_line('When others error has occurred. Oracle error message is ' || SQLERRM);

Line 65: IF rcv_dcp_pvt.g_email_address IS NOT NULL THEN

61: IF l_debug_on THEN
62: asn_debug.put_line('Entering:' || l_module_name);
63: END IF;
64:
65: IF rcv_dcp_pvt.g_email_address IS NOT NULL THEN
66: IF l_debug_on THEN
67: asn_debug.put_line('Email Address cache :' || rcv_dcp_pvt.g_email_address);
68: END IF;
69:

Line 67: asn_debug.put_line('Email Address cache :' || rcv_dcp_pvt.g_email_address);

63: END IF;
64:
65: IF rcv_dcp_pvt.g_email_address IS NOT NULL THEN
66: IF l_debug_on THEN
67: asn_debug.put_line('Email Address cache :' || rcv_dcp_pvt.g_email_address);
68: END IF;
69:
70: RETURN rcv_dcp_pvt.g_email_address;
71: END IF;

Line 70: RETURN rcv_dcp_pvt.g_email_address;

66: IF l_debug_on THEN
67: asn_debug.put_line('Email Address cache :' || rcv_dcp_pvt.g_email_address);
68: END IF;
69:
70: RETURN rcv_dcp_pvt.g_email_address;
71: END IF;
72:
73: rcv_dcp_pvt.g_email_address := fnd_profile.VALUE('RCV_DCP_EMAIL_ADDRESSES');
74:

Line 73: rcv_dcp_pvt.g_email_address := fnd_profile.VALUE('RCV_DCP_EMAIL_ADDRESSES');

69:
70: RETURN rcv_dcp_pvt.g_email_address;
71: END IF;
72:
73: rcv_dcp_pvt.g_email_address := fnd_profile.VALUE('RCV_DCP_EMAIL_ADDRESSES');
74:
75: IF l_debug_on THEN
76: asn_debug.put_line('Email Address profile :' || rcv_dcp_pvt.g_email_address);
77: END IF;

Line 76: asn_debug.put_line('Email Address profile :' || rcv_dcp_pvt.g_email_address);

72:
73: rcv_dcp_pvt.g_email_address := fnd_profile.VALUE('RCV_DCP_EMAIL_ADDRESSES');
74:
75: IF l_debug_on THEN
76: asn_debug.put_line('Email Address profile :' || rcv_dcp_pvt.g_email_address);
77: END IF;
78:
79: RETURN rcv_dcp_pvt.g_email_address;
80: EXCEPTION

Line 79: RETURN rcv_dcp_pvt.g_email_address;

75: IF l_debug_on THEN
76: asn_debug.put_line('Email Address profile :' || rcv_dcp_pvt.g_email_address);
77: END IF;
78:
79: RETURN rcv_dcp_pvt.g_email_address;
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF l_debug_on THEN
83: asn_debug.put_line('When others error has occurred. Oracle error message is ' || SQLERRM);

Line 257: IF rcv_dcp_pvt.g_check_dcp IS NOT NULL THEN

253: ===========================================================================*/
254: FUNCTION is_dcp_enabled
255: RETURN NUMBER IS
256: BEGIN
257: IF rcv_dcp_pvt.g_check_dcp IS NOT NULL THEN
258: RETURN(rcv_dcp_pvt.g_check_dcp);
259: END IF;
260:
261: rcv_dcp_pvt.g_check_dcp := NVL(fnd_profile.VALUE('RCV_ENABLE_DCP'), 0);

Line 258: RETURN(rcv_dcp_pvt.g_check_dcp);

254: FUNCTION is_dcp_enabled
255: RETURN NUMBER IS
256: BEGIN
257: IF rcv_dcp_pvt.g_check_dcp IS NOT NULL THEN
258: RETURN(rcv_dcp_pvt.g_check_dcp);
259: END IF;
260:
261: rcv_dcp_pvt.g_check_dcp := NVL(fnd_profile.VALUE('RCV_ENABLE_DCP'), 0);
262: RETURN rcv_dcp_pvt.g_check_dcp;

Line 261: rcv_dcp_pvt.g_check_dcp := NVL(fnd_profile.VALUE('RCV_ENABLE_DCP'), 0);

257: IF rcv_dcp_pvt.g_check_dcp IS NOT NULL THEN
258: RETURN(rcv_dcp_pvt.g_check_dcp);
259: END IF;
260:
261: rcv_dcp_pvt.g_check_dcp := NVL(fnd_profile.VALUE('RCV_ENABLE_DCP'), 0);
262: RETURN rcv_dcp_pvt.g_check_dcp;
263: EXCEPTION
264: WHEN OTHERS THEN
265: RETURN 0;

Line 262: RETURN rcv_dcp_pvt.g_check_dcp;

258: RETURN(rcv_dcp_pvt.g_check_dcp);
259: END IF;
260:
261: rcv_dcp_pvt.g_check_dcp := NVL(fnd_profile.VALUE('RCV_ENABLE_DCP'), 0);
262: RETURN rcv_dcp_pvt.g_check_dcp;
263: EXCEPTION
264: WHEN OTHERS THEN
265: RETURN 0;
266: END is_dcp_enabled;

Line 1120: END rcv_dcp_pvt;

1116: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1117: x_return_status := 'E';
1118: END IF;
1119: END validate_data;
1120: END rcv_dcp_pvt;