1723:
1724: create_org_relations(p_name, p_org_id, l_return_status, l_msg_count, l_msg_data);
1725:
1726: if l_person_id <> 0 then
1727: fnd_message.set_name('AMW', 'AMW_PROC_ADD_HEAD');
1728: l_header := fnd_message.get;
1729:
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1724: create_org_relations(p_name, p_org_id, l_return_status, l_msg_count, l_msg_data);
1725:
1726: if l_person_id <> 0 then
1727: fnd_message.set_name('AMW', 'AMW_PROC_ADD_HEAD');
1728: l_header := fnd_message.get;
1729:
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1732: fnd_message.set_token('PARENT', l_parent_disp_name);
1726: if l_person_id <> 0 then
1727: fnd_message.set_name('AMW', 'AMW_PROC_ADD_HEAD');
1728: l_header := fnd_message.get;
1729:
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1732: fnd_message.set_token('PARENT', l_parent_disp_name);
1733: fnd_message.set_token('ORG', l_org_name);
1734: l_body := fnd_message.get;
1727: fnd_message.set_name('AMW', 'AMW_PROC_ADD_HEAD');
1728: l_header := fnd_message.get;
1729:
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1732: fnd_message.set_token('PARENT', l_parent_disp_name);
1733: fnd_message.set_token('ORG', l_org_name);
1734: l_body := fnd_message.get;
1735:
1728: l_header := fnd_message.get;
1729:
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1732: fnd_message.set_token('PARENT', l_parent_disp_name);
1733: fnd_message.set_token('ORG', l_org_name);
1734: l_body := fnd_message.get;
1735:
1736: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
1729:
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1732: fnd_message.set_token('PARENT', l_parent_disp_name);
1733: fnd_message.set_token('ORG', l_org_name);
1734: l_body := fnd_message.get;
1735:
1736: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
1737: p_body => l_body,
1730: fnd_message.set_name('AMW', 'AMW_PROC_ADD_BODY');
1731: fnd_message.set_token('CHILD', l_child_disp_name);
1732: fnd_message.set_token('PARENT', l_parent_disp_name);
1733: fnd_message.set_token('ORG', l_org_name);
1734: l_body := fnd_message.get;
1735:
1736: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
1737: p_body => l_body,
1738: p_send_to_person_id => l_person_id,
1743: elsif (p_mode = 'DEL') then
1744: delete_org_relation(p_parent_process_id, p_child_process_id, p_org_id);
1745:
1746: if l_person_id <> 0 then
1747: fnd_message.set_name('AMW', 'AMW_PROC_DEL_HEAD');
1748: l_header := fnd_message.get;
1749:
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1744: delete_org_relation(p_parent_process_id, p_child_process_id, p_org_id);
1745:
1746: if l_person_id <> 0 then
1747: fnd_message.set_name('AMW', 'AMW_PROC_DEL_HEAD');
1748: l_header := fnd_message.get;
1749:
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1752: fnd_message.set_token('PARENT', l_parent_disp_name);
1746: if l_person_id <> 0 then
1747: fnd_message.set_name('AMW', 'AMW_PROC_DEL_HEAD');
1748: l_header := fnd_message.get;
1749:
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1752: fnd_message.set_token('PARENT', l_parent_disp_name);
1753: fnd_message.set_token('ORG', l_org_name);
1754: l_body := fnd_message.get;
1747: fnd_message.set_name('AMW', 'AMW_PROC_DEL_HEAD');
1748: l_header := fnd_message.get;
1749:
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1752: fnd_message.set_token('PARENT', l_parent_disp_name);
1753: fnd_message.set_token('ORG', l_org_name);
1754: l_body := fnd_message.get;
1755:
1748: l_header := fnd_message.get;
1749:
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1752: fnd_message.set_token('PARENT', l_parent_disp_name);
1753: fnd_message.set_token('ORG', l_org_name);
1754: l_body := fnd_message.get;
1755:
1756: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
1749:
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1752: fnd_message.set_token('PARENT', l_parent_disp_name);
1753: fnd_message.set_token('ORG', l_org_name);
1754: l_body := fnd_message.get;
1755:
1756: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
1757: p_body => l_body,
1750: fnd_message.set_name('AMW', 'AMW_PROC_DEL_BODY');
1751: fnd_message.set_token('CHILD', l_child_disp_name);
1752: fnd_message.set_token('PARENT', l_parent_disp_name);
1753: fnd_message.set_token('ORG', l_org_name);
1754: l_body := fnd_message.get;
1755:
1756: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
1757: p_body => l_body,
1758: p_send_to_person_id => l_person_id,