DBA Data[Home] [Help]

APPS.OKL_SO_CREDIT_APP_WF dependencies on FND_API

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

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

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

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

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

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

Line 778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 805: -- RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 836: * RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 971: -- RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1317: IF ( l_return_status = FND_API.G_RET_STS_ERROR )

1313: ,L_MODULE || ' Result of OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS'
1314: ,'l_return_status ' || l_return_status);
1315: END IF; -- end of statement level debug
1316:
1317: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1318: THEN
1319: resultout := 'ERROR:' || x_msg_data;
1320: RETURN;
1321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

Line 1321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1317: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1318: THEN
1319: resultout := 'ERROR:' || x_msg_data;
1320: RETURN;
1321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1322: THEN
1323: resultout := 'ERROR:' || x_msg_data;
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;

Line 1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1320: RETURN;
1321: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1322: THEN
1323: resultout := 'ERROR:' || x_msg_data;
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;
1326:
1327: -- Added for bug 7375141 - start
1328: l_exp_date := OKL_LEASE_APP_PVT.get_approval_exp_date(l_lap_id);

Line 1363: IF ( l_return_status = FND_API.G_RET_STS_ERROR )

1359: FND_LOG.LEVEL_STATEMENT
1360: ,L_MODULE || ' Result of POPULATE_LEASE_APP'
1361: ,'l_return_status ' || l_return_status);
1362: END IF; -- end of statement level debug
1363: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1364: THEN
1365: resultout := 'ERROR:' || x_msg_data;
1366: RETURN;
1367: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

Line 1367: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1363: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1364: THEN
1365: resultout := 'ERROR:' || x_msg_data;
1366: RETURN;
1367: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1368: THEN
1369: resultout := 'ERROR:' || x_msg_data;
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: END IF;

Line 1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1366: RETURN;
1367: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1368: THEN
1369: resultout := 'ERROR:' || x_msg_data;
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: END IF;
1372: l_lapv_rec := x_lapv_rec;
1373: l_lapv_rec.valid_to:= l_exp_date;
1374:

Line 1407: IF ( l_return_status = FND_API.G_RET_STS_ERROR )

1403: FND_LOG.LEVEL_STATEMENT
1404: ,L_MODULE || ' Result of OKL_LAP_PVT.UPDATE_ROW'
1405: ,'l_return_status ' || l_return_status);
1406: END IF; -- end of statement level debug
1407: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1408: THEN
1409: resultout := 'ERROR:' || x_msg_data;
1410: RETURN;
1411: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

Line 1411: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1407: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1408: THEN
1409: resultout := 'ERROR:' || x_msg_data;
1410: RETURN;
1411: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1412: THEN
1413: resultout := 'ERROR:' || x_msg_data;
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;

Line 1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1410: RETURN;
1411: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1412: THEN
1413: resultout := 'ERROR:' || x_msg_data;
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416: End if;
1417: -- Added for bug 7375141 - End
1418:

Line 1454: IF ( l_return_status = FND_API.G_RET_STS_ERROR )

1450: ,L_MODULE || ' Result of OKL_LEASE_APP_PVT.REVERT_TO_ORIG_STATUS'
1451: ,'l_return_status ' || l_return_status);
1452: END IF; -- end of statement level debug
1453:
1454: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1455: THEN
1456: resultout := 'ERROR:' || x_msg_data;
1457: RETURN;
1458: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

Line 1458: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1454: IF ( l_return_status = FND_API.G_RET_STS_ERROR )
1455: THEN
1456: resultout := 'ERROR:' || x_msg_data;
1457: RETURN;
1458: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1459: THEN
1460: resultout := 'ERROR:' || x_msg_data;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;

Line 1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1457: RETURN;
1458: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1459: THEN
1460: resultout := 'ERROR:' || x_msg_data;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463: END IF;-- For l_lap_status is not null condition
1464: -- Bug#4741121 - viselvar - Modified - Start
1465: -- raise the business event passing the lease application id added to the parameter list

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

1610: ,x_msg_data =>x_msg_data
1611: ,p_crqv_rec =>l_crqv_rec_type
1612: ,x_crqv_rec => x_crqv_rec_type);
1613:
1614: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1615: resultout := 'COMPLETE:N';
1616: return;
1617: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1618: resultout := 'COMPLETE:NO';

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

1613:
1614: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1615: resultout := 'COMPLETE:N';
1616: return;
1617: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1618: resultout := 'COMPLETE:NO';
1619: -- return;
1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621: END IF;

Line 1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1616: return;
1617: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1618: resultout := 'COMPLETE:NO';
1619: -- return;
1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621: END IF;
1622:
1623: -- 5. set approver role, REQUEST STATUS , CREDIT_AMOUNT , rEQUEST NUMBER
1624: wf_engine.SetItemAttrText (