DBA Data[Home] [Help]

APPS.AMW_AP_APPROVAL_PVT dependencies on AMW_UTILITY_PVT

Line 73: amw_utility_pvt.debug_message ( l_api_name

69: FROM amw_audit_procedures_vl
70: WHERE audit_procedure_rev_id = p_ap_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: );

Line 119: amw_utility_pvt.get_employee_name (l_requestor_id);

115: FETCH c_ap_rec
116: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
117: CLOSE c_ap_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_ap_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);

Line 240: amw_utility_pvt.debug_message ( l_api_name

236: FROM amw_audit_procedures_vl
237: WHERE audit_procedure_rev_id = p_ap_rev_id;
238: BEGIN
239: IF g_debug THEN
240: amw_utility_pvt.debug_message ( l_api_name
241: || 'Entering'
242: || 'document id '
243: || document_id
244: );

Line 287: amw_utility_pvt.get_employee_name (l_requestor_id);

283: fnd_message.set_token ('NAME', l_ap_name, FALSE);
284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

Line 406: amw_utility_pvt.debug_message ( l_api_name

402: FROM amw_audit_procedures_vl
403: WHERE audit_procedure_rev_id = p_ap_rev_id;
404: BEGIN
405: IF g_debug THEN
406: amw_utility_pvt.debug_message ( l_api_name
407: || 'Entering'
408: || 'document id '
409: || document_id
410: );

Line 469: amw_utility_pvt.get_employee_name (l_requestor_id);

465: avalue=> l_string
466: );
467: */
468: l_requestor_name :=
469: amw_utility_pvt.get_employee_name (l_requestor_id);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 573: amw_utility_pvt.debug_message ( l_api_name

569: FROM amw_audit_procedures_vl
570: WHERE audit_procedure_rev_id = p_ap_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: );

Line 615: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');

611: aname => 'AMW_REQUESTOR'
612: );
613: */
614: l_lookup_meaning :=
615: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');
616: OPEN c_ap_rec (l_ap_rev_id);
617: FETCH c_ap_rec
618: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
619: CLOSE c_ap_rec;

Line 633: amw_utility_pvt.get_employee_name (l_requestor_id);

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_AP_REQ_INFO');
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 752: amw_utility_pvt.debug_message ( l_api_name

748: FROM amw_audit_procedures_vl
749: WHERE audit_procedure_rev_id = p_ap_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: );

Line 953: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');

949: FETCH c_ap_rec
950: INTO l_ap_id, l_ap_name, l_start_date;
951: CLOSE c_ap_rec;
952: l_lookup_meaning :=
953: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');
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_ap_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

Line 1234: amw_utility_pvt.debug_message(l_full_name || ' failed to update AP to status ' || l_status_code);

1230: /*
1231: --amw_APs_pkg.update_AP (
1232: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1233: IF G_DEBUG THEN
1234: amw_utility_pvt.debug_message(l_full_name || ' failed to update AP to status ' || l_status_code);
1235: END IF;
1236: amw_gen_approval_pvt.handle_err (
1237: p_itemtype=> itemtype,
1238: p_itemkey=> itemkey,

Line 1274: amw_utility_pvt.debug_message (

1270: p_count=> l_msg_count,
1271: p_data=> l_msg_data
1272: );
1273: IF G_DEBUG THEN
1274: amw_utility_pvt.debug_message (
1275: l_full_name
1276: || ': l_return_status'
1277: || l_return_status
1278: );