DBA Data[Home] [Help]

APPS.OKL_SO_CREDIT_APP_WF dependencies on FND_API

Line 113: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

109: FOR I IN 1..J LOOP
110: wf_engine.SetItemAttrText (itemtype => itemtype,
111: itemkey => itemkey,
112: aname => 'MESSAGE'||i,
113: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
114: END LOOP;
115: end;
116:
117: -- sets requestor of credit request to the user who submitted the request.

Line 770: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

766: p_organization_id => l_inv_org_id,
767: p_source_chr_id => null,
768: x_chr_id => x_chr_id);
769:
770: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
771: resultout := 'ERROR:' || x_msg_data;
772: return;
773: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
774: resultout := 'ERROR:FALSE';

Line 773: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

769:
770: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
771: resultout := 'ERROR:' || x_msg_data;
772: return;
773: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
774: resultout := 'ERROR:FALSE';
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:

Line 775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

771: resultout := 'ERROR:' || x_msg_data;
772: return;
773: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
774: resultout := 'ERROR:FALSE';
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: /**** Customer Account rule now created on header ******************
779: *

Line 799: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

795: p_rgpv_rec => l_rgpv_rec,
796: x_rgpv_rec => x_rgpv_rec);
797:
798:
799: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
800: resultout := 'ERROR:' || x_msg_data;
801: return;
802: -- RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

Line 802: -- RAISE FND_API.G_EXC_ERROR;

798:
799: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
800: resultout := 'ERROR:' || x_msg_data;
801: return;
802: -- RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
804: resultout := 'ERROR:FALSE';
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;

Line 803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

799: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
800: resultout := 'ERROR:' || x_msg_data;
801: return;
802: -- RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
804: resultout := 'ERROR:FALSE';
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:

Line 805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801: return;
802: -- RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
804: resultout := 'ERROR:FALSE';
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: -- 6. CREATE RULE
809:

Line 828: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

824: x_msg_data =>x_msg_data,
825: p_rulv_rec =>l_rulv_rec,
826: x_rulv_rec =>x_rulv_rec);
827:
828: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
829: resultout := 'ERROR:' || x_msg_data;
830: return;
831: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
832: * resultout := 'ERROR:FALSE';

Line 831: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

827:
828: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
829: resultout := 'ERROR:' || x_msg_data;
830: return;
831: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
832: * resultout := 'ERROR:FALSE';
833: * RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: * END IF;
835: * END IF; -- create customer account

Line 833: * RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: resultout := 'ERROR:' || x_msg_data;
830: return;
831: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
832: * resultout := 'ERROR:FALSE';
833: * RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: * END IF;
835: * END IF; -- create customer account
836: *
837: *************************************************************************/

Line 871: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

867: p_klev_tbl => p_klev_tbl,
868: x_clev_tbl => x_clev_tbl,
869: x_klev_tbl => x_klev_tbl);
870:
871: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
872: resultout := 'ERROR:' || x_msg_data;
873: return;
874: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
875: resultout := 'ERROR:FALSE';

Line 874: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

870:
871: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
872: resultout := 'ERROR:' || x_msg_data;
873: return;
874: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
875: resultout := 'ERROR:FALSE';
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:

Line 876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

872: resultout := 'ERROR:' || x_msg_data;
873: return;
874: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
875: resultout := 'ERROR:FALSE';
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879: -- 7. Change Status of the credit request
880: l_okl_credit_req := wf_engine.GetItemAttrNumber (

Line 911: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

907: ,x_msg_data =>x_msg_data
908: ,p_crqv_rec =>l_crqv_rec_type
909: ,x_crqv_rec => x_crqv_rec_type);
910:
911: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
912: resultout := 'ERROR:' || x_msg_data;
913: return;
914: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
915: resultout := 'ERROR:NO';

Line 914: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

910:
911: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
912: resultout := 'ERROR:' || x_msg_data;
913: return;
914: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
915: resultout := 'ERROR:NO';
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918:

Line 916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

912: resultout := 'ERROR:' || x_msg_data;
913: return;
914: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
915: resultout := 'ERROR:NO';
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918:
919: -- create Interaction History.
920: l_login_id := fnd_global.login_id;

Line 965: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

961: x_msg_data => x_msg_data,
962: p_interaction_rec => l_interaction_rec,
963: x_interaction_id => lx_interaction_id);
964:
965: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
966: resultout := 'ERROR:NO';
967: return;
968: -- RAISE FND_API.G_EXC_ERROR;
969: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

Line 968: -- RAISE FND_API.G_EXC_ERROR;

964:
965: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
966: resultout := 'ERROR:NO';
967: return;
968: -- RAISE FND_API.G_EXC_ERROR;
969: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
970: resultout := 'ERROR:NO';
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972: END IF;

Line 969: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

965: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
966: resultout := 'ERROR:NO';
967: return;
968: -- RAISE FND_API.G_EXC_ERROR;
969: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
970: resultout := 'ERROR:NO';
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972: END IF;
973:

Line 971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

967: return;
968: -- RAISE FND_API.G_EXC_ERROR;
969: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
970: resultout := 'ERROR:NO';
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972: END IF;
973:
974: -- l_activity_rec.activity_id :=
975: --l_activity_rec.duration := 0;

Line 1010: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1006: x_msg_data => x_msg_data,
1007: p_activity_rec => l_activity_rec,
1008: x_activity_id => lx_activity_id);
1009:
1010: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: resultout := 'ERROR:NO';
1012: return;
1013: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1014: resultout := 'ERROR:NO';

Line 1013: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1009:
1010: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: resultout := 'ERROR:NO';
1012: return;
1013: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1014: resultout := 'ERROR:NO';
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: END IF;
1017:

Line 1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1011: resultout := 'ERROR:NO';
1012: return;
1013: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1014: resultout := 'ERROR:NO';
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: END IF;
1017:
1018: jtf_ih_pub.CLOSE_INTERACTION (
1019: p_api_version => l_api_version,

Line 1031: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1027: x_msg_count => x_msg_count,
1028: x_msg_data => x_msg_data,
1029: P_INTERACTION_ID => lx_interaction_id);
1030:
1031: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1032: resultout := 'ERROR:NO';
1033: return;
1034: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1035: resultout := 'ERROR:NO';

Line 1034: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1030:
1031: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1032: resultout := 'ERROR:NO';
1033: return;
1034: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1035: resultout := 'ERROR:NO';
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:

Line 1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1032: resultout := 'ERROR:NO';
1033: return;
1034: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1035: resultout := 'ERROR:NO';
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:
1039: resultout := 'COMPLETE:YES';
1040: return;

Line 1231: IF ( l_return_status = FND_API.G_RET_STS_ERROR )

1227: ,L_MODULE || ' Result of OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS'
1228: ,'l_return_status ' || l_return_status);
1229: END IF; -- end of statement level debug
1230:
1231: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1232: THEN
1233: resultout := 'ERROR:' || x_msg_data;
1234: RETURN;
1235: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

Line 1235: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1231: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1232: THEN
1233: resultout := 'ERROR:' || x_msg_data;
1234: RETURN;
1235: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1236: THEN
1237: resultout := 'ERROR:' || x_msg_data;
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;

Line 1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1234: RETURN;
1235: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1236: THEN
1237: resultout := 'ERROR:' || x_msg_data;
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;
1240:
1241: --Bug 4872271 PAGARG Call the API which will check if there is any Parent
1242: --to this Lease App and in status Appeal/Resubmit in Progress. If yes

Line 1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR )

1272: ,L_MODULE || ' Result of OKL_LEASE_APP_PVT.REVERT_TO_ORIG_STATUS'
1273: ,'l_return_status ' || l_return_status);
1274: END IF; -- end of statement level debug
1275:
1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1277: THEN
1278: resultout := 'ERROR:' || x_msg_data;
1279: RETURN;
1280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

Line 1280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1277: THEN
1278: resultout := 'ERROR:' || x_msg_data;
1279: RETURN;
1280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1281: THEN
1282: resultout := 'ERROR:' || x_msg_data;
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;

Line 1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1279: RETURN;
1280: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1281: THEN
1282: resultout := 'ERROR:' || x_msg_data;
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;
1285: END IF;-- For l_lap_status is not null condition
1286: -- Bug#4741121 - viselvar - Modified - Start
1287: -- raise the business event passing the lease application id added to the parameter list

Line 1436: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1432: ,x_msg_data =>x_msg_data
1433: ,p_crqv_rec =>l_crqv_rec_type
1434: ,x_crqv_rec => x_crqv_rec_type);
1435:
1436: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1437: resultout := 'COMPLETE:N';
1438: return;
1439: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1440: resultout := 'COMPLETE:NO';

Line 1439: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1435:
1436: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1437: resultout := 'COMPLETE:N';
1438: return;
1439: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1440: resultout := 'COMPLETE:NO';
1441: -- return;
1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1443: END IF;

Line 1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1438: return;
1439: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1440: resultout := 'COMPLETE:NO';
1441: -- return;
1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1443: END IF;
1444:
1445: -- 5. set approver role, REQUEST STATUS , CREDIT_AMOUNT , rEQUEST NUMBER
1446: wf_engine.SetItemAttrText (