[Home] [Help]
76: FROM amw_Controls_all_vl
77: WHERE control_rev_id = p_CTRL_rev_id;
78: BEGIN
79: IF G_DEBUG THEN
80: amw_utility_pvt.debug_message (
81: l_api_name
82: || 'Entering'
83: || 'document id '
84: || document_id
133: l_CTRL_name,
134: l_start_date,
135: l_requestor_id;
136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
257: FROM amw_controls_all_vl
258: WHERE control_rev_id = p_CTRL_rev_id;
259: BEGIN
260: IF G_DEBUG THEN
261: amw_utility_pvt.debug_message (
262: l_api_name
263: || 'Entering'
264: || 'document id '
265: || document_id
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
444: FROM amw_controls_all_vl
445: WHERE Control_rev_id = p_CTRL_rev_id;
446: BEGIN
447: IF G_DEBUG THEN
448: amw_utility_pvt.debug_message (
449: l_api_name
450: || 'Entering'
451: || 'document id '
452: || document_id
518: aname => 'REJECT_SUBJECT',
519: avalue=> l_string
520: );
521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
632: FROM amw_controls_all_vl
633: WHERE control_rev_id = p_CTRL_rev_id;
634: BEGIN
635: IF G_DEBUG THEN
636: amw_utility_pvt.debug_message (
637: l_api_name
638: || 'Entering'
639: || 'document id '
640: || document_id
681: itemkey=> l_item_key,
682: aname => 'AMW_REQUESTOR'
683: );
684: */
685: l_lookup_meaning := amw_utility_pvt.get_lookup_meaning('AMW_OBJECT_TYPE','CTRL');
686: OPEN c_CTRL_rec (l_CTRL_rev_id);
687: FETCH c_CTRL_rec INTO l_CTRL_id,
688: l_CTRL_name,
689: l_start_date,
700: aname => 'APP_SUBJECT',
701: avalue=> l_string
702: );
703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
820: FROM amw_controls_all_vl
821: WHERE control_rev_id = p_CTRL_rev_id;
822: BEGIN
823: IF G_DEBUG THEN
824: amw_utility_pvt.debug_message (
825: l_api_name
826: || 'Entering'
827: || 'document id '
828: || document_id
1036: FETCH c_CTRL_rec INTO l_CTRL_id,
1037: l_CTRL_name,
1038: l_start_date;
1039: CLOSE c_CTRL_rec;
1040: l_lookup_meaning := amw_utility_pvt.get_lookup_meaning('AMW_OBJECT_TYPE','CTRL');
1041: --- set all the subjects here
1042: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
1043: fnd_message.set_token (
1044: 'NAME',
1389: /*
1390: --amw_CTRLs_pkg.update_CTRL (
1391: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1392: IF G_DEBUG THEN
1393: amw_utility_pvt.debug_message(l_full_name || ' failed to update CTRL to status ' || l_status_code);
1394: END IF;
1395: amw_gen_approval_pvt.handle_err (
1396: p_itemtype=> itemtype,
1397: p_itemkey=> itemkey,
1434: p_count=> l_msg_count,
1435: p_data=> l_msg_data
1436: );
1437: IF G_DEBUG THEN
1438: amw_utility_pvt.debug_message (
1439: l_full_name
1440: || ': l_return_status'
1441: || l_return_status
1442: );