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;
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:
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;
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;
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;
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:
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;
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;