DBA Data[Home] [Help]

APPS.ASO_WFNOTIFICATION_PVT dependencies on ASO_DEBUG_PUB

Line 26: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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' );
29: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
30: END IF;

Line 27: aso_debug_pub.add('user_name: ' || p_user_name , 1, 'N' );

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' );
29: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
30: END IF;
31:

Line 28: aso_debug_pub.add('subject: ' || p_subject , 1, 'N' );

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' );
29: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
30: END IF;
31:
32: select ASO_WFNOTIFICATION_S1.NEXTVAL into wf_itemkey_seq from dual;

Line 29: aso_debug_pub.add('object: ' || p_body , 1, 'N' );

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' );
29: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
30: END IF;
31:
32: select ASO_WFNOTIFICATION_S1.NEXTVAL into wf_itemkey_seq from dual;
33: wf_itemkey := 'ASO_USER_' || wf_itemkey_seq;

Line 98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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' );
101: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
102: END IF;

Line 99: aso_debug_pub.add('email_list: ' || p_email_list , 1, 'N' );

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' );
101: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
102: END IF;
103:

Line 100: aso_debug_pub.add('subject: ' || p_subject , 1, 'N' );

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' );
101: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
102: END IF;
103:
104: select ASO_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;

Line 101: aso_debug_pub.add('object: ' || p_body , 1, 'N' );

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' );
101: aso_debug_pub.add('object: ' || p_body , 1, 'N' );
102: END IF;
103:
104: select ASO_WFNOTIFICATION_S2.NEXTVAL into wf_itemkey_seq from dual;
105: wf_itemkey := 'ASO_MAIL_' || wf_itemkey_seq;