DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on WF_ENGINE

Line 602: result := wf_engine.eng_null;

598:
599: BEGIN
600:
601: if funcmode <> 'RUN' then
602: result := wf_engine.eng_null;
603: return;
604: end if;
605:
606: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

Line 606: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

602: result := wf_engine.eng_null;
603: return;
604: end if;
605:
606: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'WRITEOFF_ID');
609: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
610: itemkey => itemkey,

Line 609: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

605:
606: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'WRITEOFF_ID');
609: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
610: itemkey => itemkey,
611: aname => 'REQUEST_ID');
612: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,
613: itemkey => itemkey,

Line 612: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,

608: aname => 'WRITEOFF_ID');
609: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
610: itemkey => itemkey,
611: aname => 'REQUEST_ID');
612: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,
613: itemkey => itemkey,
614: aname => 'OBJECT_ID');
615: l_object_type := wf_engine.GetItemAttrText(itemtype => itemtype,
616: itemkey => itemkey,

Line 615: l_object_type := wf_engine.GetItemAttrText(itemtype => itemtype,

611: aname => 'REQUEST_ID');
612: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,
613: itemkey => itemkey,
614: aname => 'OBJECT_ID');
615: l_object_type := wf_engine.GetItemAttrText(itemtype => itemtype,
616: itemkey => itemkey,
617: aname => 'WRITEOFF_TYPE');
618: /** 1) insert into okl_trx_ar_adjst_b and tl
619: ** 2) insert into okl_txl_adjst_lns_b and tl

Line 678: wf_engine.SetItemAttrText(itemtype => itemtype,

674: -- IF PG_DEBUG <11 THEN
675: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
676: iex_debug_pub.logmessage('Error' ||l_message);
677: END IF;
678: wf_engine.SetItemAttrText(itemtype => itemtype,
679: itemkey => itemkey,
680: aname => 'ERROR_MESSAGE',
681: avalue => l_message);
682: --raise FND_API.G_EXC_ERROR;

Line 683: result := wf_engine.eng_completed ||':'||wf_no;

679: itemkey => itemkey,
680: aname => 'ERROR_MESSAGE',
681: avalue => l_message);
682: --raise FND_API.G_EXC_ERROR;
683: result := wf_engine.eng_completed ||':'||wf_no;
684: return;
685:
686: ELSE
687: FND_MSG_PUB.initialize;

Line 728: wf_engine.SetItemAttrText(itemtype => itemtype,

724: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
725: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
726: iex_debug_pub.logmessage('Error' ||l_message);
727: END IF;
728: wf_engine.SetItemAttrText(itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'ERROR_MESSAGE',
731: avalue => l_message);
732: result := wf_engine.eng_completed ||':'||wf_no;

Line 732: result := wf_engine.eng_completed ||':'||wf_no;

728: wf_engine.SetItemAttrText(itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'ERROR_MESSAGE',
731: avalue => l_message);
732: result := wf_engine.eng_completed ||':'||wf_no;
733: return;
734:
735: END IF;
736:

Line 766: wf_engine.SetItemAttrText(itemtype => itemtype,

762: -- IF PG_DEBUG <11 THEN
763: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
764: iex_debug_pub.logmessage('Error' ||l_message);
765: END IF;
766: wf_engine.SetItemAttrText(itemtype => itemtype,
767: itemkey => itemkey,
768: aname => 'ERROR_MESSAGE',
769: avalue => l_message);
770: --raise FND_API.G_EXC_ERROR;

Line 771: result := wf_engine.eng_completed ||':'||wf_no;

767: itemkey => itemkey,
768: aname => 'ERROR_MESSAGE',
769: avalue => l_message);
770: --raise FND_API.G_EXC_ERROR;
771: result := wf_engine.eng_completed ||':'||wf_no;
772: return;
773: ELSE
774: -- IF PG_DEBUG <11 THEN
775: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 830: wf_engine.SetItemAttrText(itemtype => itemtype,

826: -- IF PG_DEBUG <11 THEN
827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
828: iex_debug_pub.logmessage('Error' ||l_message);
829: END IF;
830: wf_engine.SetItemAttrText(itemtype => itemtype,
831: itemkey => itemkey,
832: aname => 'ERROR_MESSAGE',
833: avalue => l_message);
834: --raise FND_API.G_EXC_ERROR;

Line 835: result := wf_engine.eng_completed ||':'||wf_no;

831: itemkey => itemkey,
832: aname => 'ERROR_MESSAGE',
833: avalue => l_message);
834: --raise FND_API.G_EXC_ERROR;
835: result := wf_engine.eng_completed ||':'||wf_no;
836: return;
837: ELSE
838: FND_MSG_PUB.initialize;
839: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 860: result := wf_engine.eng_completed ||':'||wf_no;

856:
857: AddfailMsg(p_object => 'Adjustments ',
858: p_operation => 'CREATE' );
859: --raise FND_API.G_EXC_ERROR;
860: result := wf_engine.eng_completed ||':'||wf_no;
861: return;
862: end if;
863:
864: --update iex_writeoff_objects

Line 885: wf_engine.SetItemAttrText(itemtype => itemtype,

881: -- IF PG_DEBUG <11 THEN
882: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
883: iex_debug_pub.logmessage('Error' ||l_message);
884: END IF;
885: wf_engine.SetItemAttrText(itemtype => itemtype,
886: itemkey => itemkey,
887: aname => 'ERROR_MESSAGE',
888: avalue => l_message);
889: --raise FND_API.G_EXC_ERROR;

Line 890: result := wf_engine.eng_completed ||':'||wf_no;

886: itemkey => itemkey,
887: aname => 'ERROR_MESSAGE',
888: avalue => l_message);
889: --raise FND_API.G_EXC_ERROR;
890: result := wf_engine.eng_completed ||':'||wf_no;
891: return;
892: ELSE
893: FND_MSG_PUB.initialize;
894: -- IF PG_DEBUG <11 THEN

Line 929: wf_engine.SetItemAttrText(itemtype => itemtype,

925: -- IF PG_DEBUG <11 THEN
926: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
927: iex_debug_pub.logmessage('Error' ||l_message);
928: END IF;
929: wf_engine.SetItemAttrText(itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'ERROR_MESSAGE',
932: avalue => l_message);
933: --raise FND_API.G_EXC_ERROR;

Line 934: result := wf_engine.eng_completed ||':'||wf_no;

930: itemkey => itemkey,
931: aname => 'ERROR_MESSAGE',
932: avalue => l_message);
933: --raise FND_API.G_EXC_ERROR;
934: result := wf_engine.eng_completed ||':'||wf_no;
935: return;
936: ELSE
937: FND_MSG_PUB.initialize;
938: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 968: wf_engine.SetItemAttrText(itemtype => itemtype,

964: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
965: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);
966: END IF;
967:
968: wf_engine.SetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'ERROR_MESSAGE',
971: avalue => l_message);
972: --raise FND_API.G_EXC_ERROR;

Line 973: result := wf_engine.eng_completed ||':'||wf_no;

969: itemkey => itemkey,
970: aname => 'ERROR_MESSAGE',
971: avalue => l_message);
972: --raise FND_API.G_EXC_ERROR;
973: result := wf_engine.eng_completed ||':'||wf_no;
974: return;
975: ELSE
976: FND_MSG_PUB.initialize;
977: END IF;

Line 981: result := wf_engine.eng_completed ||':'||wf_yes;

977: END IF;
978: END IF; --object_type
979: END if ;--if l_ctr;
980:
981: result := wf_engine.eng_completed ||':'||wf_yes;
982:
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: --resultout := wf_engine.eng_completed ||':'||wf_no;

Line 985: --resultout := wf_engine.eng_completed ||':'||wf_no;

981: result := wf_engine.eng_completed ||':'||wf_yes;
982:
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: --resultout := wf_engine.eng_completed ||':'||wf_no;
986: -- IF PG_DEBUG < 11 THEN
987: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
988: iex_debug_pub.logmessage('Error ' ||l_message);
989: END IF;

Line 1000: --resultout := wf_engine.eng_completed ||':'||wf_no;

996: funcmode);
997: raise;
998:
999: when others then
1000: --resultout := wf_engine.eng_completed ||':'||wf_no;
1001: -- IF PG_DEBUG < 11 THEN
1002: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1003: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);
1004: END IF;

Line 1063: result := wf_engine.eng_null;

1059:
1060: BEGIN
1061:
1062: if funcmode <> 'RUN' then
1063: result := wf_engine.eng_null;
1064: return;
1065: end if;
1066: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');
1067: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1067: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

1063: result := wf_engine.eng_null;
1064: return;
1065: end if;
1066: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');
1067: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'WRITEOFF_ID');
1070:
1071:

Line 1072: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

1068: itemkey => itemkey,
1069: aname => 'WRITEOFF_ID');
1070:
1071:
1072: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
1073: itemkey => itemkey,
1074: aname => 'REQUEST_ID');
1075:
1076: OPEN c_get_obj_ver(l_WRITEOFF_ID);

Line 1108: wf_engine.SetItemAttrText(itemtype => itemtype,

1104: -- IF PG_DEBUG <11 THEN
1105: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1106: iex_debug_pub.logmessage('Error' ||l_message);
1107: END IF;
1108: wf_engine.SetItemAttrText(itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'ERROR_MESSAGE',
1111: avalue => l_message);
1112: --raise FND_API.G_EXC_ERROR;

Line 1113: result := wf_engine.eng_completed ||':'||wf_no;

1109: itemkey => itemkey,
1110: aname => 'ERROR_MESSAGE',
1111: avalue => l_message);
1112: --raise FND_API.G_EXC_ERROR;
1113: result := wf_engine.eng_completed ||':'||wf_no;
1114: return;
1115: ELSE
1116: FND_MSG_PUB.initialize;
1117: END IF;

Line 1148: wf_engine.SetItemAttrText(itemtype => itemtype,

1144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1145: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);
1146: END IF;
1147:
1148: wf_engine.SetItemAttrText(itemtype => itemtype,
1149: itemkey => itemkey,
1150: aname => 'ERROR_MESSAGE',
1151: avalue => l_message);
1152: --raise FND_API.G_EXC_ERROR;

Line 1153: result := wf_engine.eng_completed ||':'||wf_no;

1149: itemkey => itemkey,
1150: aname => 'ERROR_MESSAGE',
1151: avalue => l_message);
1152: --raise FND_API.G_EXC_ERROR;
1153: result := wf_engine.eng_completed ||':'||wf_no;
1154: return;
1155:
1156: ELSE
1157: FND_MSG_PUB.initialize;

Line 1160: result := wf_engine.eng_completed ||':'||wf_yes;

1156: ELSE
1157: FND_MSG_PUB.initialize;
1158: END IF;
1159:
1160: result := wf_engine.eng_completed ||':'||wf_yes;
1161:
1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: --resultout := wf_engine.eng_completed ||':'||wf_no;

Line 1164: --resultout := wf_engine.eng_completed ||':'||wf_no;

1160: result := wf_engine.eng_completed ||':'||wf_yes;
1161:
1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: --resultout := wf_engine.eng_completed ||':'||wf_no;
1165: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1166: 'reject_writeoffs',
1167: itemtype,
1168: itemkey,

Line 1174: --resultout := wf_engine.eng_completed ||':'||wf_no;

1170: funcmode);
1171: raise;
1172:
1173: when others then
1174: --resultout := wf_engine.eng_completed ||':'||wf_no;
1175: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1176: 'reject_writeoffs',
1177: itemtype,
1178: itemkey,