APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on WF_NOTIFICATION

Line 1088: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');

1084: ,x_msg_data => l_msg_data
1085: );
1086:
1087: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1088: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
1089: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
1090: end if;
1091:
1092: --debug_msg_s1 ('total copy size' || l_copy_size);

Line 1111: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');

1107:
1108: --debug_msg_s1('Error '||TO_CHAR(SQLCODE)||': '||substr(Sqlerrm, 255));
1109:
1110:
1111: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
1112: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
1113:
1114: END show_clob_content;
1115:

Line 2693: WF_NOTIFICATION.CANCEL

2689: BEGIN
2690: x_return_status := FND_API.G_RET_STS_SUCCESS;
2691: for nid in get_open_notification(to_char(p_ci_action_id))
2692: loop
2693: WF_NOTIFICATION.CANCEL
2694: ( nid => to_number(nid.notification_id),
2695: cancel_comment => null
2696: );
2697:

Line 2757: wf_notification.setAttrText(p_nid, 'SIGN_OFF',p_sign_off_flag);

2753: aname => 'SIGN_OFF_REQUESTED_FLAG');
2754:
2755:
2756: if l_sign_off_requested = 'Y' then
2757: wf_notification.setAttrText(p_nid, 'SIGN_OFF',p_sign_off_flag);
2758: end if;
2759:
2760: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);
2761:

Line 2760: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);

2756: if l_sign_off_requested = 'Y' then
2757: wf_notification.setAttrText(p_nid, 'SIGN_OFF',p_sign_off_flag);
2758: end if;
2759:
2760: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);
2761:
2762: if p_action in ('C','R') then
2763: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');
2764: else

Line 2763: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');

2759:
2760: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);
2761:
2762: if p_action in ('C','R') then
2763: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');
2764: else
2765: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2766: end if;
2767:

Line 2765: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');

2761:
2762: if p_action in ('C','R') then
2763: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');
2764: else
2765: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2766: end if;
2767:
2768: wf_notification.respond(p_nid, null, fnd_global.user_name);
2769:

Line 2768: wf_notification.respond(p_nid, null, fnd_global.user_name);

2764: else
2765: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2766: end if;
2767:
2768: wf_notification.respond(p_nid, null, fnd_global.user_name);
2769:
2770:
2771: EXCEPTION
2772: