DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on WF_ENGINE

Line 582: result := wf_engine.eng_null;

578:
579: BEGIN
580:
581: if funcmode <> 'RUN' then
582: result := wf_engine.eng_null;
583: return;
584: end if;
585:
586: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

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

582: result := wf_engine.eng_null;
583: return;
584: end if;
585:
586: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
587: itemkey => itemkey,
588: aname => 'WRITEOFF_ID');
589: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
590: itemkey => itemkey,

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

585:
586: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
587: itemkey => itemkey,
588: aname => 'WRITEOFF_ID');
589: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
590: itemkey => itemkey,
591: aname => 'REQUEST_ID');
592: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,
593: itemkey => itemkey,

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

588: aname => 'WRITEOFF_ID');
589: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
590: itemkey => itemkey,
591: aname => 'REQUEST_ID');
592: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,
593: itemkey => itemkey,
594: aname => 'OBJECT_ID');
595: l_object_type := wf_engine.GetItemAttrText(itemtype => itemtype,
596: itemkey => itemkey,

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

591: aname => 'REQUEST_ID');
592: l_object_id := wf_engine.GetItemAttrText(itemtype => itemtype,
593: itemkey => itemkey,
594: aname => 'OBJECT_ID');
595: l_object_type := wf_engine.GetItemAttrText(itemtype => itemtype,
596: itemkey => itemkey,
597: aname => 'WRITEOFF_TYPE');
598: /** 1) insert into okl_trx_ar_adjst_b and tl
599: ** 2) insert into okl_txl_adjst_lns_b and tl

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

654: -- IF PG_DEBUG <11 THEN
655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
656: iex_debug_pub.logmessage('Error' ||l_message);
657: END IF;
658: wf_engine.SetItemAttrText(itemtype => itemtype,
659: itemkey => itemkey,
660: aname => 'ERROR_MESSAGE',
661: avalue => l_message);
662: --raise FND_API.G_EXC_ERROR;

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

659: itemkey => itemkey,
660: aname => 'ERROR_MESSAGE',
661: avalue => l_message);
662: --raise FND_API.G_EXC_ERROR;
663: result := wf_engine.eng_completed ||':'||wf_no;
664: return;
665:
666: ELSE
667: FND_MSG_PUB.initialize;

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

704: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
705: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
706: iex_debug_pub.logmessage('Error' ||l_message);
707: END IF;
708: wf_engine.SetItemAttrText(itemtype => itemtype,
709: itemkey => itemkey,
710: aname => 'ERROR_MESSAGE',
711: avalue => l_message);
712: result := wf_engine.eng_completed ||':'||wf_no;

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

708: wf_engine.SetItemAttrText(itemtype => itemtype,
709: itemkey => itemkey,
710: aname => 'ERROR_MESSAGE',
711: avalue => l_message);
712: result := wf_engine.eng_completed ||':'||wf_no;
713: return;
714:
715: END IF;
716:

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

742: -- IF PG_DEBUG <11 THEN
743: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
744: iex_debug_pub.logmessage('Error' ||l_message);
745: END IF;
746: wf_engine.SetItemAttrText(itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'ERROR_MESSAGE',
749: avalue => l_message);
750: --raise FND_API.G_EXC_ERROR;

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

747: itemkey => itemkey,
748: aname => 'ERROR_MESSAGE',
749: avalue => l_message);
750: --raise FND_API.G_EXC_ERROR;
751: result := wf_engine.eng_completed ||':'||wf_no;
752: return;
753: ELSE
754: -- IF PG_DEBUG <11 THEN
755: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

806: -- IF PG_DEBUG <11 THEN
807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
808: iex_debug_pub.logmessage('Error' ||l_message);
809: END IF;
810: wf_engine.SetItemAttrText(itemtype => itemtype,
811: itemkey => itemkey,
812: aname => 'ERROR_MESSAGE',
813: avalue => l_message);
814: --raise FND_API.G_EXC_ERROR;

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

811: itemkey => itemkey,
812: aname => 'ERROR_MESSAGE',
813: avalue => l_message);
814: --raise FND_API.G_EXC_ERROR;
815: result := wf_engine.eng_completed ||':'||wf_no;
816: return;
817: ELSE
818: FND_MSG_PUB.initialize;
819: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

836:
837: AddfailMsg(p_object => 'Adjustments ',
838: p_operation => 'CREATE' );
839: --raise FND_API.G_EXC_ERROR;
840: result := wf_engine.eng_completed ||':'||wf_no;
841: return;
842: end if;
843:
844: --update iex_writeoff_objects

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

861: -- IF PG_DEBUG <11 THEN
862: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
863: iex_debug_pub.logmessage('Error' ||l_message);
864: END IF;
865: wf_engine.SetItemAttrText(itemtype => itemtype,
866: itemkey => itemkey,
867: aname => 'ERROR_MESSAGE',
868: avalue => l_message);
869: --raise FND_API.G_EXC_ERROR;

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

866: itemkey => itemkey,
867: aname => 'ERROR_MESSAGE',
868: avalue => l_message);
869: --raise FND_API.G_EXC_ERROR;
870: result := wf_engine.eng_completed ||':'||wf_no;
871: return;
872: ELSE
873: FND_MSG_PUB.initialize;
874: -- IF PG_DEBUG <11 THEN

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

905: -- IF PG_DEBUG <11 THEN
906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
907: iex_debug_pub.logmessage('Error' ||l_message);
908: END IF;
909: wf_engine.SetItemAttrText(itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'ERROR_MESSAGE',
912: avalue => l_message);
913: --raise FND_API.G_EXC_ERROR;

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

910: itemkey => itemkey,
911: aname => 'ERROR_MESSAGE',
912: avalue => l_message);
913: --raise FND_API.G_EXC_ERROR;
914: result := wf_engine.eng_completed ||':'||wf_no;
915: return;
916: ELSE
917: FND_MSG_PUB.initialize;
918: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
945: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);
946: END IF;
947:
948: wf_engine.SetItemAttrText(itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'ERROR_MESSAGE',
951: avalue => l_message);
952: --raise FND_API.G_EXC_ERROR;

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

949: itemkey => itemkey,
950: aname => 'ERROR_MESSAGE',
951: avalue => l_message);
952: --raise FND_API.G_EXC_ERROR;
953: result := wf_engine.eng_completed ||':'||wf_no;
954: return;
955: ELSE
956: FND_MSG_PUB.initialize;
957: END IF;

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

957: END IF;
958: END IF; --object_type
959: END if ;--if l_ctr;
960:
961: result := wf_engine.eng_completed ||':'||wf_yes;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: --resultout := wf_engine.eng_completed ||':'||wf_no;

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

961: result := wf_engine.eng_completed ||':'||wf_yes;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: --resultout := wf_engine.eng_completed ||':'||wf_no;
966: -- IF PG_DEBUG < 11 THEN
967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
968: iex_debug_pub.logmessage('Error ' ||l_message);
969: END IF;

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

976: funcmode);
977: raise;
978:
979: when others then
980: --resultout := wf_engine.eng_completed ||':'||wf_no;
981: -- IF PG_DEBUG < 11 THEN
982: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
983: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);
984: END IF;

Line 1043: result := wf_engine.eng_null;

1039:
1040: BEGIN
1041:
1042: if funcmode <> 'RUN' then
1043: result := wf_engine.eng_null;
1044: return;
1045: end if;
1046: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');
1047: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,

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

1043: result := wf_engine.eng_null;
1044: return;
1045: end if;
1046: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');
1047: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
1048: itemkey => itemkey,
1049: aname => 'WRITEOFF_ID');
1050:
1051:

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

1048: itemkey => itemkey,
1049: aname => 'WRITEOFF_ID');
1050:
1051:
1052: l_REQUEST_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'REQUEST_ID');
1055:
1056: OPEN c_get_obj_ver(l_WRITEOFF_ID);

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

1084: -- IF PG_DEBUG <11 THEN
1085: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1086: iex_debug_pub.logmessage('Error' ||l_message);
1087: END IF;
1088: wf_engine.SetItemAttrText(itemtype => itemtype,
1089: itemkey => itemkey,
1090: aname => 'ERROR_MESSAGE',
1091: avalue => l_message);
1092: --raise FND_API.G_EXC_ERROR;

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

1089: itemkey => itemkey,
1090: aname => 'ERROR_MESSAGE',
1091: avalue => l_message);
1092: --raise FND_API.G_EXC_ERROR;
1093: result := wf_engine.eng_completed ||':'||wf_no;
1094: return;
1095: ELSE
1096: FND_MSG_PUB.initialize;
1097: END IF;

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

1124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1125: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);
1126: END IF;
1127:
1128: wf_engine.SetItemAttrText(itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'ERROR_MESSAGE',
1131: avalue => l_message);
1132: --raise FND_API.G_EXC_ERROR;

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

1129: itemkey => itemkey,
1130: aname => 'ERROR_MESSAGE',
1131: avalue => l_message);
1132: --raise FND_API.G_EXC_ERROR;
1133: result := wf_engine.eng_completed ||':'||wf_no;
1134: return;
1135:
1136: ELSE
1137: FND_MSG_PUB.initialize;

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

1136: ELSE
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139:
1140: result := wf_engine.eng_completed ||':'||wf_yes;
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: --resultout := wf_engine.eng_completed ||':'||wf_no;

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

1140: result := wf_engine.eng_completed ||':'||wf_yes;
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: --resultout := wf_engine.eng_completed ||':'||wf_no;
1145: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1146: 'reject_writeoffs',
1147: itemtype,
1148: itemkey,

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

1150: funcmode);
1151: raise;
1152:
1153: when others then
1154: --resultout := wf_engine.eng_completed ||':'||wf_no;
1155: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1156: 'reject_writeoffs',
1157: itemtype,
1158: itemkey,