1516:
1517:
1518: --get notification id from wf_engine context
1519: l_nid := WF_ENGINE.CONTEXT_NID;
1520: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1521:
1522: IF l_ntf_result = 'NO' THEN
1523: l_sts_code := 'REJECTED';
1524: l_rjn_code := 'CUST';
1521:
1522: IF l_ntf_result = 'NO' THEN
1523: l_sts_code := 'REJECTED';
1524: l_rjn_code := 'CUST';
1525: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1526: ELSIF l_ntf_result = 'YES' THEN
1527: l_sts_code := 'CUSTAPPR';
1528: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1529: END IF;
1524: l_rjn_code := 'CUST';
1525: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1526: ELSIF l_ntf_result = 'YES' THEN
1527: l_sts_code := 'CUSTAPPR';
1528: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1529: END IF;
1530:
1531:
1532: l_tcnv_rec.id := l_trx_id;
1652:
1653:
1654: --get notification id from wf_engine context
1655: l_nid := WF_ENGINE.CONTEXT_NID;
1656: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1657:
1658: --rkuttiya changed for bug#5149488
1659: IF l_ntf_result = 'VND_REJECTED' THEN
1660: l_sts_code := 'REJECTED';
1658: --rkuttiya changed for bug#5149488
1659: IF l_ntf_result = 'VND_REJECTED' THEN
1660: l_sts_code := 'REJECTED';
1661: l_rjn_code := 'VND';
1662: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1663: ELSIF l_ntf_result = 'VND_APPROVED' THEN
1664: l_sts_code := 'VENDAPPR';
1665: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1666: END IF;
1661: l_rjn_code := 'VND';
1662: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1663: ELSIF l_ntf_result = 'VND_APPROVED' THEN
1664: l_sts_code := 'VENDAPPR';
1665: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1666: END IF;
1667:
1668:
1669: l_tcnv_rec.id := l_trx_id;
2124:
2125:
2126: --get notification id from wf_engine context
2127: l_nid := WF_ENGINE.CONTEXT_NID;
2128: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2129:
2130: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2131: l_sts_code := 'REJECTED';
2132: l_rjn_code := 'CRDPT';
2129:
2130: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2131: l_sts_code := 'REJECTED';
2132: l_rjn_code := 'CRDPT';
2133: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2134:
2135: ELSIF l_ntf_result = 'CREDIT_APPROVED' THEN
2136: l_sts_code := 'CREDAPPR';
2137: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2133: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2134:
2135: ELSIF l_ntf_result = 'CREDIT_APPROVED' THEN
2136: l_sts_code := 'CREDAPPR';
2137: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2138: END IF;
2139:
2140:
2141: l_tcnv_rec.id := l_trx_id;
2298:
2299:
2300: --get notification id from wf_engine context
2301: l_nid := WF_ENGINE.CONTEXT_NID;
2302: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2303:
2304: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2305: l_sts_code := 'REJECTED';
2306: l_rjn_code := 'CODPT';
2303:
2304: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2305: l_sts_code := 'REJECTED';
2306: l_rjn_code := 'CODPT';
2307: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2308: ELSE
2309: l_sts_code := 'COLLAPPR';
2310: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2311: END IF;
2306: l_rjn_code := 'CODPT';
2307: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2308: ELSE
2309: l_sts_code := 'COLLAPPR';
2310: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2311: END IF;
2312:
2313:
2314: l_tcnv_rec.id := l_trx_id;
3231:
3232: IF (funcmode = 'RESPOND') THEN
3233: --get notification id from wf_engine context
3234: l_nid := WF_ENGINE.CONTEXT_NID;
3235: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3236:
3237: resultout := 'COMPLETE:'|| l_ntf_result;
3238:
3239: --Run Mode
3280:
3281: IF (funcmode = 'RESPOND') THEN
3282: --get notification id from wf_engine context
3283: l_nid := WF_ENGINE.CONTEXT_NID;
3284: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3285:
3286: resultout := 'COMPLETE:'|| l_ntf_result;
3287:
3288: --Run Mode
3532:
3533: IF (funcmode = 'RESPOND') THEN
3534: --get notification id from wf_engine context
3535: l_nid := WF_ENGINE.CONTEXT_NID;
3536: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3537:
3538: resultout := 'COMPLETE:'|| l_ntf_result;
3539:
3540: --Run Mode