APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on WF_NOTIFICATION

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

984: ,x_msg_data => l_msg_data
985: );
986:
987: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
988: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
989: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
990: end if;
991:
992: --debug_msg_s1 ('total copy size' || l_copy_size);

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

1007:
1008: --debug_msg_s1('Error '||TO_CHAR(SQLCODE)||': '||substr(Sqlerrm, 255));
1009:
1010:
1011: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
1012: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
1013:
1014: END show_clob_content;
1015:

Line 2450: WF_NOTIFICATION.CANCEL

2446: BEGIN
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448: for nid in get_open_notification(to_char(p_ci_action_id))
2449: loop
2450: WF_NOTIFICATION.CANCEL
2451: ( nid => to_number(nid.notification_id),
2452: cancel_comment => null
2453: );
2454:

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

2510: aname => 'SIGN_OFF_REQUESTED_FLAG');
2511:
2512:
2513: if l_sign_off_requested = 'Y' then
2514: wf_notification.setAttrText(p_nid, 'SIGN_OFF',p_sign_off_flag);
2515: end if;
2516:
2517: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);
2518:

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

2513: if l_sign_off_requested = 'Y' then
2514: wf_notification.setAttrText(p_nid, 'SIGN_OFF',p_sign_off_flag);
2515: end if;
2516:
2517: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);
2518:
2519: if p_action in ('C','R') then
2520: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');
2521: else

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

2516:
2517: wf_notification.setAttrText(p_nid, 'COMMENT', p_response);
2518:
2519: if p_action in ('C','R') then
2520: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');
2521: else
2522: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2523: end if;
2524:

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

2518:
2519: if p_action in ('C','R') then
2520: wf_notification.setAttrText(p_nid, 'RESULT', 'BBB_CLOSE');
2521: else
2522: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2523: end if;
2524:
2525: wf_notification.respond(p_nid, null, fnd_global.user_name);
2526:

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

2521: else
2522: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2523: end if;
2524:
2525: wf_notification.respond(p_nid, null, fnd_global.user_name);
2526:
2527:
2528: EXCEPTION
2529: