[Home] [Help]
69: FROM amw_risks_all_vl
70: WHERE risk_rev_id = p_risk_rev_id;
71: BEGIN
72: IF g_debug THEN
73: amw_utility_pvt.debug_message ( l_api_name
74: || 'Entering'
75: || 'document id '
76: || document_id
77: );
115: FETCH c_risk_rec
116: INTO l_risk_id, l_risk_name, l_start_date, l_requestor_id;
117: CLOSE c_risk_rec;
118: l_requestor_name :=
119: amw_utility_pvt.get_employee_name (l_requestor_id);
120: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
121: fnd_message.set_token ('NAME', l_risk_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);
237: FROM amw_risks_all_vl
238: WHERE risk_rev_id = p_risk_rev_id;
239: BEGIN
240: IF g_debug THEN
241: amw_utility_pvt.debug_message ( l_api_name
242: || 'Entering'
243: || 'document id '
244: || document_id
245: );
284: fnd_message.set_token ('NAME', l_risk_name, FALSE);
285: fnd_message.set_token ('OBJECT_TYPE', l_risk_name, FALSE);
286: l_string := SUBSTR (fnd_message.get, 1, 1000);
287: l_requestor_name :=
288: amw_utility_pvt.get_employee_name (l_requestor_id);
289: fnd_message.set_name ('AMW', 'AMW_WF_NTF_RISK_REQ_INFO');
290: fnd_message.set_token ('RISK_NAME', l_risk_name, FALSE);
291: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
292: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
403: FROM amw_risks_all_vl
404: WHERE risk_rev_id = p_risk_rev_id;
405: BEGIN
406: IF g_debug THEN
407: amw_utility_pvt.debug_message ( l_api_name
408: || 'Entering'
409: || 'document id '
410: || document_id
411: );
465: aname => 'REJECT_SUBJECT',
466: avalue=> l_string
467: );
468: */
469: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_RISK_REQ_INFO');
471: fnd_message.set_token ('RISK_NAME', l_risk_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
569: FROM amw_risks_all_vl
570: WHERE risk_rev_id = p_risk_rev_id;
571: BEGIN
572: IF g_debug THEN
573: amw_utility_pvt.debug_message ( l_api_name
574: || 'Entering'
575: || 'document id '
576: || document_id
577: );
611: aname => 'AMW_REQUESTOR'
612: );
613: */
614: l_lookup_meaning :=
615: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'RISK');
616: OPEN c_risk_rec (l_risk_rev_id);
617: FETCH c_risk_rec
618: INTO l_risk_id, l_risk_name, l_start_date, l_requestor_id;
619: CLOSE c_risk_rec;
629: avalue=> l_string
630: );
631: */
632: l_requestor_name :=
633: amw_utility_pvt.get_employee_name (l_requestor_id);
634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_RISK_REQ_INFO');
635: fnd_message.set_token ('RISK_NAME', l_risk_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
748: FROM amw_risks_all_vl
749: WHERE risk_rev_id = p_risk_rev_id;
750: BEGIN
751: IF g_debug THEN
752: amw_utility_pvt.debug_message ( l_api_name
753: || 'Entering'
754: || 'document id '
755: || document_id
756: );
949: FETCH c_risk_rec
950: INTO l_risk_id, l_risk_name, l_start_date;
951: CLOSE c_risk_rec;
952: l_lookup_meaning :=
953: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'RISK');
954: --- set all the subjects here
955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
956: fnd_message.set_token ('NAME', l_risk_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
1209: /*
1210: --amw_risks_pkg.update_RISK (
1211: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1212: IF G_DEBUG THEN
1213: amw_utility_pvt.debug_message(l_full_name || ' failed to update RISK to status ' || l_status_code);
1214: END IF;
1215: amw_gen_approval_pvt.handle_err (
1216: p_itemtype=> itemtype,
1217: p_itemkey=> itemkey,
1249: p_count=> l_msg_count,
1250: p_data=> l_msg_data
1251: );
1252: IF G_DEBUG THEN
1253: amw_utility_pvt.debug_message (
1254: l_full_name
1255: || ': l_return_status'
1256: || l_return_status
1257: );