APPS.IGIDOSL dependencies on WF_NOTIFICATION

Line 16: ## copied FROM WF_NOTIFICATION package

12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
13:
14: /* ============== WORKFLOW VARAIBLES =================
15: ## Variables for framing and coloring the Table.
16: ## copied FROM WF_NOTIFICATION package
17: ## /fnddev/fnd/11.5/patch/115/sql/wfntfb.pls
18: ##
19: */
20:

Line 573: l_picked_role wf_notifications.responder%TYPE;

569: funcmode VARCHAR2,
570: result OUT NOCOPY VARCHAR2)
571: IS
572:
573: l_picked_role wf_notifications.responder%TYPE;
574:
575: BEGIN
576:
577: /* =============== START DEBUG LOG ================ */

Line 651: l_creator_name wf_notifications.responder%TYPE

647: funcmode VARCHAR2,
648: result OUT NOCOPY VARCHAR2)
649: IS
650:
651: l_creator_name wf_notifications.responder%TYPE
652: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'CREATOR_NAME');
655:

Line 671: l_picked_role wf_notifications.responder%TYPE;

667: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
668: itemkey => ItemKey,
669: aname => 'DOSSIER_ID');
670:
671: l_picked_role wf_notifications.responder%TYPE;
672: l_error VARCHAR2(1000) ;
673: l_position_structure_id per_position_structures.position_structure_id%TYPE ;
674: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
675: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;

Line 1492: l_creator_name wf_notifications.responder%TYPE

1488: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1489: itemkey => itemkey,
1490: aname => 'DOSSIER_NUM');
1491:
1492: l_creator_name wf_notifications.responder%TYPE
1493: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'CREATOR_NAME');
1496: BEGIN

Line 1564: l_creator_name wf_notifications.responder%TYPE

1560: funcmode IN VARCHAR2,
1561: result OUT NOCOPY VARCHAR2)
1562: IS
1563:
1564: l_creator_name wf_notifications.responder%TYPE
1565: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1566: itemkey => itemkey,
1567: aname => 'CREATOR_NAME');
1568:

Line 1595: l_nid := Wf_Notification.Send(

1591: result := 'COMPLETE' ;
1592: return;
1593: END IF ;
1594:
1595: l_nid := Wf_Notification.Send(
1596: l_creator_name
1597: , itemtype
1598: ,'ALL_APPROVED'
1599: , null

Line 1662: l_creator_name wf_notifications.responder%TYPE

1658: funcmode IN VARCHAR2,
1659: result OUT NOCOPY VARCHAR2)
1660: IS
1661:
1662: l_creator_name wf_notifications.responder%TYPE
1663: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1664: itemkey => itemkey,
1665: aname => 'CREATOR_NAME');
1666:

Line 1695: l_nid := Wf_Notification.Send(

1691: return;
1692: END IF ;
1693: -- start Commented for bug 9104180
1694: /*
1695: l_nid := Wf_Notification.Send(
1696: l_creator_name
1697: , itemtype
1698: ,'AUTHORISER_REJECTION'
1699: , null

Line 1960: l_next_authoriser wf_notifications.responder%TYPE ;

1956: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1957: itemkey => itemkey,
1958: aname => 'PARENT_POSITION_ID');
1959:
1960: l_next_authoriser wf_notifications.responder%TYPE ;
1961: l_pos NUMBER := 0;
1962:
1963: no_next_authoriser EXCEPTION ;
1964:

Line 2347: WF_NOTIFICATION.WriteToClob(Document,l_table_header);

2343: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg4',
2344: ' l_table_header --> ' || substr(l_table_header,1,3800));
2345: /* =============== END DEBUG LOG ================== */
2346:
2347: WF_NOTIFICATION.WriteToClob(Document,l_table_header);
2348:
2349: /* =============== START DEBUG LOG ================ */
2350: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg5',
2351: ' ** END FRAMEDOSTABLE ** ');

Line 2392: WF_NOTIFICATION.WriteToClob(Document,l_frame_total);

2388: DEBUG_LOG_STRING (l_proc_level, 'AddTotalToTable.Msg3',
2389: ' l_frame_total --> ' || substr(l_frame_total,1,3900));
2390: /* =============== END DEBUG LOG ================== */
2391:
2392: WF_NOTIFICATION.WriteToClob(Document,l_frame_total);
2393:
2394: /* =============== START DEBUG LOG ================ */
2395: DEBUG_LOG_STRING (l_proc_level, 'AddTotalToTable.Msg4',
2396: ' ** END ADDTOTALTOTABLE ** ');

Line 2670: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);

2666: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg22',
2667: ' dest_rec.amount --> ' || l_dest_formatted_amount);
2668: /* =============== END DEBUG LOG ================== */
2669:
2670: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);
2671:
2672: /* =============== START DEBUG LOG ================ */
2673: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg23',
2674: ' l_trx_detail updated to clob ');

Line 2711: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);

2707: ' Out of loop ' ) ;
2708: /* =============== END DEBUG LOG ================== */
2709:
2710: l_trx_detail := '
';
2711: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);
2712:
2713:
2714: /* =============== START DEBUG LOG ================ */
2715: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg26',