DBA Data[Home] [Help]

APPS.ASO_WFNOTIFICATION_PVT dependencies on FND_API

Line 8: p_commit IN VARCHAR2 := FND_API.g_false,

4: /* For notifying a user/role */
5:
6: PROCEDURE Notify_User (
7: p_api_version IN NUMBER,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
10: p_user_name IN VARCHAR2,
11: p_subject IN VARCHAR2,
12: p_body IN VARCHAR2,

Line 9: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

5:
6: PROCEDURE Notify_User (
7: p_api_version IN NUMBER,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
10: p_user_name IN VARCHAR2,
11: p_subject IN VARCHAR2,
12: p_body IN VARCHAR2,
13: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 24: x_return_status := FND_API.g_ret_sts_success;

20: wf_itemkey VARCHAR2(30);
21:
22: BEGIN
23:
24: x_return_status := FND_API.g_ret_sts_success;
25:
26: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
27: aso_debug_pub.add('user_name: ' || p_user_name , 1, 'N' );
28: aso_debug_pub.add('subject: ' || p_subject , 1, 'N' );

Line 68: x_return_status := FND_API.g_ret_sts_error;

64:
65:
66: EXCEPTION
67: When others then
68: x_return_status := FND_API.g_ret_sts_error;
69: x_msg_count := 0;
70: wf_core.context('ASO_WFNOTIFICATION_PVT', 'Notify_User', p_user_name, p_subject, p_body);
71: raise;
72:

Line 78: p_commit IN VARCHAR2 := FND_API.g_false,

74:
75: /* For sending email to one or more email addresses */
76:
77: PROCEDURE Send_Email ( p_api_version IN NUMBER,
78: p_commit IN VARCHAR2 := FND_API.g_false,
79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
80: p_email_list IN VARCHAR2,
81: p_subject IN VARCHAR2,
82: p_body IN VARCHAR2,

Line 79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

75: /* For sending email to one or more email addresses */
76:
77: PROCEDURE Send_Email ( p_api_version IN NUMBER,
78: p_commit IN VARCHAR2 := FND_API.g_false,
79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
80: p_email_list IN VARCHAR2,
81: p_subject IN VARCHAR2,
82: p_body IN VARCHAR2,
83: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 96: x_return_status := FND_API.g_ret_sts_success;

92: role_display_name VARCHAR2(30);
93:
94: BEGIN
95:
96: x_return_status := FND_API.g_ret_sts_success;
97:
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('email_list: ' || p_email_list , 1, 'N' );
100: aso_debug_pub.add('subject: ' || p_subject , 1, 'N' );

Line 150: x_return_status := FND_API.g_ret_sts_error;

146:
147: EXCEPTION
148:
149: When others then
150: x_return_status := FND_API.g_ret_sts_error;
151: x_msg_count := 0;
152: wf_core.context('ASO_WFNOTIFICATION_PVT', 'Send_Email', p_email_list, p_subject, p_body );
153: raise;
154: