eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_STRATEGY_PUB dependencies on FND_API

Line 121: l_Init_Msg_List := FND_API.G_FALSE;

117: l_Init_Msg_List := P_Init_Msg_List;
118: l_Commit := P_Commit;
119: l_validation_level := p_validation_level;
120: if (l_Init_msg_List is null) then
121: l_Init_Msg_List := FND_API.G_FALSE;
122: end if;
123: if (l_Commit is null) then
124: l_Commit := FND_API.G_FALSE;
125: end if;

Line 124: l_Commit := FND_API.G_FALSE;

120: if (l_Init_msg_List is null) then
121: l_Init_Msg_List := FND_API.G_FALSE;
122: end if;
123: if (l_Commit is null) then
124: l_Commit := FND_API.G_FALSE;
125: end if;
126: if (l_validation_level is null) then
127: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
128: end if;

Line 127: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

123: if (l_Commit is null) then
124: l_Commit := FND_API.G_FALSE;
125: end if;
126: if (l_validation_level is null) then
127: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
128: end if;
129:
130: l_api_name := 'CREATE_STRATEGY';
131:

Line 301: l_return_status := FND_API.G_RET_STS_SUCCESS;

297: -- Standard Start of API savepoint
298: SAVEPOINT CREATE_STRATEGY_PUB;
299:
300: -- Initialize API return status to SUCCESS
301: l_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: /*
304: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
305: return;

Line 364: IF FND_API.to_Boolean( l_init_msg_list ) THEN

360: l_objectType := UPPER(p_ObjectType);
361:
362:
363: -- Initialize message list IF p_init_msg_list is set to TRUE.
364: IF FND_API.to_Boolean( l_init_msg_list ) THEN
365: FND_MSG_PUB.initialize;
366: END IF;
367:
368: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: print_date => 'Y');
378: END IF;
379:
380: -- Initialize API return status to SUCCESS
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: --Start bug 6798118 gnramasa 05 Feb 08
384: If l_ObjectType in ('PARTY','ACCOUNT','BILL_TO','DELINQUENT') THEN
385: if (l_ObjectType = 'PARTY') then

Line 477: RAISE FND_API.G_EXC_ERROR;

473: FND_MESSAGE.Set_Name('IEX', 'IEX_UNKNOWN_OBJTYPE');
474: FND_MESSAGE.Set_Token('OBJECT_TYPE', l_ObjectType);
475: FND_MSG_PUB.Add;
476:
477: RAISE FND_API.G_EXC_ERROR;
478: return;
479: end if;
480:
481: EXCEPTION

Line 491: RAISE FND_API.G_EXC_ERROR;

487: FND_MESSAGE.Set_Name('IEX', 'IEX_OBJECT_NOT_EXISTS');
488: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
489: FND_MSG_PUB.Add;
490:
491: RAISE FND_API.G_EXC_ERROR;
492: return;
493:
494: END;
495: elsif p_ObjectID IS NOT NULL then

Line 547: RAISE FND_API.G_EXC_ERROR;

543: FND_MESSAGE.Set_Name('IEX', 'IEX_UNKNOWN_OBJTYPE');
544: FND_MESSAGE.Set_Token('OBJECT_TYPE', l_ObjectType);
545: FND_MSG_PUB.Add;
546:
547: RAISE FND_API.G_EXC_ERROR;
548: return;
549: end if;
550:
551: EXCEPTION

Line 563: RAISE FND_API.G_EXC_ERROR;

559: FND_MESSAGE.Set_Name('IEX', 'IEX_OBJECT_NOT_EXISTS');
560: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
561: FND_MSG_PUB.Add;
562:
563: RAISE FND_API.G_EXC_ERROR;
564: return;
565:
566: END;
567:

Line 847: p_commit => FND_API.G_FALSE,

843: Begin
844:
845: iex_strategy_pvt.create_strategy(
846: P_Api_Version_Number=>2.0,
847: p_commit => FND_API.G_FALSE,
848: P_Init_Msg_List =>FND_API.G_FALSE,
849: p_strategy_rec => l_strategy_rec,
850: x_return_status=>l_return_status,
851: x_msg_count=>l_msg_count,

Line 848: P_Init_Msg_List =>FND_API.G_FALSE,

844:
845: iex_strategy_pvt.create_strategy(
846: P_Api_Version_Number=>2.0,
847: p_commit => FND_API.G_FALSE,
848: P_Init_Msg_List =>FND_API.G_FALSE,
849: p_strategy_rec => l_strategy_rec,
850: x_return_status=>l_return_status,
851: x_msg_count=>l_msg_count,
852: x_msg_data=>l_msg_data,

Line 861: RAISE FND_API.G_EXC_ERROR;

857: IEX_DEBUG_PUB.LogMessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
858: END IF;
859:
860: if (x_return_status <> 'S') then
861: RAISE FND_API.G_EXC_ERROR;
862: end if;
863:
864: l_strategy_rec.strategy_id := l_strategy_id;
865:

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: FND_MESSAGE.Set_Name('IEX', 'IEX_STRATEGY_CREATE_FAILED');
877: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
878: FND_MSG_PUB.Add;
879:
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881:
882: END;
883:
884:

Line 893: P_Init_Msg_List => FND_API.G_FALSE,

889: BEGIN
890:
891: iex_strategy_wf_pub.start_workflow(
892: P_Api_Version =>2.0,
893: P_Init_Msg_List => FND_API.G_FALSE,
894: p_commit => FND_API.G_FALSE,
895: p_strategy_rec => l_strategy_rec,
896: x_return_status=>l_return_status,
897: x_msg_count=>l_msg_count,

Line 894: p_commit => FND_API.G_FALSE,

890:
891: iex_strategy_wf_pub.start_workflow(
892: P_Api_Version =>2.0,
893: P_Init_Msg_List => FND_API.G_FALSE,
894: p_commit => FND_API.G_FALSE,
895: p_strategy_rec => l_strategy_rec,
896: x_return_status=>l_return_status,
897: x_msg_count=>l_msg_count,
898: x_msg_data=>l_msg_data,

Line 908: RAISE FND_API.G_EXC_ERROR;

904: END IF;
905: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
906:
907: if (x_return_status <> 'S') then
908: RAISE FND_API.G_EXC_ERROR;
909: end if;
910:
911: EXCEPTION
912: WHEN OTHERS THEN

Line 921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

917: FND_MESSAGE.Set_Name('IEX', 'IEX_LAUNCH_WORKFLOW_FAILED');
918: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
919: FND_MSG_PUB.Add;
920:
921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
922:
923: END;
924:
925: -- Standard check for p_commit

Line 926: IF FND_API.to_Boolean(l_commit) THEN

922:
923: END;
924:
925: -- Standard check for p_commit
926: IF FND_API.to_Boolean(l_commit) THEN
927: COMMIT WORK;
928: END IF;
929:
930: ELSE

Line 961: WHEN FND_API.G_EXC_ERROR THEN

957: IEX_DEBUG_PUB.LogMessage('Delinquency cursor ends' );
958:
959: EXCEPTION
960:
961: WHEN FND_API.G_EXC_ERROR THEN
962: x_return_status := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 962: x_return_status := FND_API.G_RET_STS_ERROR;

958:
959: EXCEPTION
960:
961: WHEN FND_API.G_EXC_ERROR THEN
962: x_return_status := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

961: WHEN FND_API.G_EXC_ERROR THEN
962: x_return_status := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
968:
969: WHEN OTHERS THEN

Line 966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

962: x_return_status := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
968:
969: WHEN OTHERS THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
968:
969: WHEN OTHERS THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
972: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
973: END IF;
974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1300: l_Init_Msg_List := FND_API.G_FALSE;

1296: l_Init_Msg_List := P_Init_Msg_List;
1297: l_Commit := P_Commit;
1298: l_validation_level := p_validation_level;
1299: if (l_Init_msg_List is null) then
1300: l_Init_Msg_List := FND_API.G_FALSE;
1301: end if;
1302: if (l_Commit is null) then
1303: l_Commit := FND_API.G_FALSE;
1304: end if;

Line 1303: l_Commit := FND_API.G_FALSE;

1299: if (l_Init_msg_List is null) then
1300: l_Init_Msg_List := FND_API.G_FALSE;
1301: end if;
1302: if (l_Commit is null) then
1303: l_Commit := FND_API.G_FALSE;
1304: end if;
1305: if (l_validation_level is null) then
1306: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1307: end if;

Line 1306: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1302: if (l_Commit is null) then
1303: l_Commit := FND_API.G_FALSE;
1304: end if;
1305: if (l_validation_level is null) then
1306: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1307: end if;
1308:
1309: l_api_name := 'SET_STRATEGY';
1310:

Line 1332: x_return_status := FND_API.G_RET_STS_SUCCESS;

1328:
1329: fStrategyVersionNumber := 2.0;
1330: l_object_version_number := 2.0;
1331:
1332: x_return_status := FND_API.G_RET_STS_SUCCESS;
1333: -- Standard Start of API savepoint
1334:
1335:
1336: -- Initialize API return status to SUCCESS

Line 1337: l_return_status := FND_API.G_RET_STS_SUCCESS;

1333: -- Standard Start of API savepoint
1334:
1335:
1336: -- Initialize API return status to SUCCESS
1337: l_return_status := FND_API.G_RET_STS_SUCCESS;
1338: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1339: return;
1340: end if;
1341: l_objectType := UPPER(p_ObjectType);

Line 1352: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1348: -- end for bug 8864768
1349: SAVEPOINT SET_STRATEGY;
1350:
1351: -- Initialize message list IF p_init_msg_list is set to TRUE.
1352: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1353: FND_MSG_PUB.initialize;
1354: END IF;
1355:
1356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1373: x_return_status := FND_API.G_RET_STS_SUCCESS;

1369: print_date => 'Y');
1370: END IF;
1371:
1372: -- Initialize API return status to SUCCESS
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;
1374: -- Debug Message
1375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1376: IEX_DEBUG_PUB.LogMessage(
1377: debug_msg => '2. CHECK VALID STATUS => ' || p_Status,

Line 1387: RAISE FND_API.G_EXC_ERROR;

1383: FND_MESSAGE.Set_Name('IEX', 'IEX_UNKNOWN_STATUS');
1384: FND_MESSAGE.Set_Token('STATUS', p_Status);
1385: FND_MSG_PUB.Add;
1386:
1387: RAISE FND_API.G_EXC_ERROR;
1388: return;
1389:
1390: end if;
1391:

Line 1443: p_commit => FND_API.G_FALSE,

1439: Begin
1440:
1441: iex_strategy_pvt.update_strategy(
1442: P_Api_Version_Number=>2.0,
1443: p_commit => FND_API.G_FALSE,
1444: P_Init_Msg_List =>FND_API.G_FALSE,
1445: p_strategy_rec => l_strategy_rec,
1446: x_return_status=>l_return_status,
1447: x_msg_count=>l_msg_count,

Line 1444: P_Init_Msg_List =>FND_API.G_FALSE,

1440:
1441: iex_strategy_pvt.update_strategy(
1442: P_Api_Version_Number=>2.0,
1443: p_commit => FND_API.G_FALSE,
1444: P_Init_Msg_List =>FND_API.G_FALSE,
1445: p_strategy_rec => l_strategy_rec,
1446: x_return_status=>l_return_status,
1447: x_msg_count=>l_msg_count,
1448: x_msg_data=>l_msg_data,

Line 1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1449: xo_object_version_number => l_object_version_number
1450: );
1451:
1452: if (x_return_status <> 'S') then
1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1454: end if;
1455:
1456: EXCEPTION
1457: WHEN OTHERS THEN

Line 1466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1462: END IF;
1463:
1464: FND_MESSAGE.Set_Name('IEX', 'IEX_STRATEGY_UPDATE_FAILED');
1465: FND_MSG_PUB.ADD;
1466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1467:
1468: END;
1469:
1470: -- Standard check for p_commit

Line 1471: IF FND_API.to_Boolean(l_commit) THEN

1467:
1468: END;
1469:
1470: -- Standard check for p_commit
1471: IF FND_API.to_Boolean(l_commit) THEN
1472: COMMIT WORK;
1473: END IF;
1474:
1475: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',

Line 1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1499: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_STRATEGIES_EXIST');
1500: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
1501: FND_MSG_PUB.ADD;
1502:
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504:
1505: end if;
1506:
1507: -- Standard call to get message count and if count is 1, get message info.

Line 1518: WHEN FND_API.G_EXC_ERROR THEN

1514:
1515:
1516: EXCEPTION
1517:
1518: WHEN FND_API.G_EXC_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1519: x_return_status := FND_API.G_RET_STS_ERROR;

1515:
1516: EXCEPTION
1517:
1518: WHEN FND_API.G_EXC_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1518: WHEN FND_API.G_EXC_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1525:
1526: WHEN OTHERS THEN

Line 1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1519: x_return_status := FND_API.G_RET_STS_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1525:
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1525:
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1529: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1530: END IF;
1531: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1642: x_return_status := FND_API.G_RET_STS_SUCCESS;

1638: print_date => 'Y');
1639: END IF;
1640:
1641: -- Initialize API return status to SUCCESS
1642: x_return_status := FND_API.G_RET_STS_SUCCESS;
1643:
1644: --Start bug 6723540 gnramasa 02 Jan 08
1645: if p_delinquencyid is not null then
1646: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1693: RAISE FND_API.G_EXC_ERROR;

1689: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_STRATEGIES_EXIST');
1690: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(p_DelinquencyID));
1691: FND_MSG_PUB.ADD;
1692:
1693: RAISE FND_API.G_EXC_ERROR;
1694:
1695: end if;
1696:
1697: EXCEPTION

Line 1708: x_return_status := FND_API.G_RET_STS_ERROR;

1704: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_STRATEGIES_EXIST');
1705: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(p_DelinquencyID));
1706: FND_MSG_PUB.ADD;
1707:
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1710:
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1711: WHEN FND_API.G_EXC_ERROR THEN

1707:
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1710:
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1712: x_return_status := FND_API.G_RET_STS_ERROR;

1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1710:
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1718:
1719: WHEN OTHERS THEN

Line 1716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1718:
1719: WHEN OTHERS THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1718:
1719: WHEN OTHERS THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1722: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1723: END IF;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1790: l_Init_Msg_List := FND_API.G_FALSE;

1786: l_Init_Msg_List := P_Init_Msg_List;
1787: l_Commit := P_Commit;
1788: l_validation_level := p_validation_level;
1789: if (l_Init_msg_List is null) then
1790: l_Init_Msg_List := FND_API.G_FALSE;
1791: end if;
1792: if (l_Commit is null) then
1793: l_Commit := FND_API.G_FALSE;
1794: end if;

Line 1793: l_Commit := FND_API.G_FALSE;

1789: if (l_Init_msg_List is null) then
1790: l_Init_Msg_List := FND_API.G_FALSE;
1791: end if;
1792: if (l_Commit is null) then
1793: l_Commit := FND_API.G_FALSE;
1794: end if;
1795: if (l_validation_level is null) then
1796: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1797: end if;

Line 1796: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1792: if (l_Commit is null) then
1793: l_Commit := FND_API.G_FALSE;
1794: end if;
1795: if (l_validation_level is null) then
1796: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1797: end if;
1798:
1799: l_api_name := 'CLOSE_STRATEGY';
1800:

Line 1822: x_return_status := FND_API.G_RET_STS_SUCCESS;

1818:
1819: fStrategyVersionNumber := 2.0;
1820: l_object_version_number := 2.0;
1821:
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1824: return;
1825: end if;
1826: -- Standard Start of API savepoint

Line 1830: l_return_status := FND_API.G_RET_STS_SUCCESS;

1826: -- Standard Start of API savepoint
1827: SAVEPOINT SET_STRATEGY;
1828:
1829: -- Initialize API return status to SUCCESS
1830: l_return_status := FND_API.G_RET_STS_SUCCESS;
1831: l_objectType := UPPER(p_ObjectType);
1832:
1833:
1834: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 1835: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1831: l_objectType := UPPER(p_ObjectType);
1832:
1833:
1834: -- Initialize message list IF p_init_msg_list is set to TRUE.
1835: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1836: FND_MSG_PUB.initialize;
1837: END IF;
1838:
1839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1852: x_return_status := FND_API.G_RET_STS_SUCCESS;

1848: print_date => 'Y');
1849: END IF;
1850:
1851: -- Initialize API return status to SUCCESS
1852: x_return_status := FND_API.G_RET_STS_SUCCESS;
1853:
1854: l_object_version_number := 1;
1855: vStrategyStatus := NULL;
1856:

Line 1910: p_commit => FND_API.G_FALSE,

1906: Begin
1907:
1908: iex_strategy_pvt.update_strategy(
1909: P_Api_Version_Number=>2.0,
1910: p_commit => FND_API.G_FALSE,
1911: P_Init_Msg_List =>FND_API.G_FALSE,
1912: p_strategy_rec => l_strategy_rec,
1913: x_return_status=>l_return_status,
1914: x_msg_count=>l_msg_count,

Line 1911: P_Init_Msg_List =>FND_API.G_FALSE,

1907:
1908: iex_strategy_pvt.update_strategy(
1909: P_Api_Version_Number=>2.0,
1910: p_commit => FND_API.G_FALSE,
1911: P_Init_Msg_List =>FND_API.G_FALSE,
1912: p_strategy_rec => l_strategy_rec,
1913: x_return_status=>l_return_status,
1914: x_msg_count=>l_msg_count,
1915: x_msg_data=>l_msg_data,

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1916: xo_object_version_number => l_object_version_number
1917: );
1918:
1919: if (x_return_status <> 'S') then
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: end if;
1922:
1923: EXCEPTION
1924: WHEN OTHERS THEN

Line 1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1930:
1931: FND_MESSAGE.Set_Name('IEX', 'IEX_STRATEGY_UPDATE_FAILED');
1932: FND_MSG_PUB.ADD;
1933:
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935:
1936: END;
1937:
1938: -- Standard check for p_commit

Line 1939: IF FND_API.to_Boolean(l_commit) THEN

1935:
1936: END;
1937:
1938: -- Standard check for p_commit
1939: IF FND_API.to_Boolean(l_commit) THEN
1940: COMMIT WORK;
1941: END IF;
1942:
1943: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',

Line 1959: WHEN FND_API.G_EXC_ERROR THEN

1955:
1956:
1957: EXCEPTION
1958:
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1960: x_return_status := FND_API.G_RET_STS_ERROR;

1956:
1957: EXCEPTION
1958:
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1966: WHEN OTHERS THEN
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1966: WHEN OTHERS THEN
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1968: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1966: WHEN OTHERS THEN
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1968: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1969: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1970: END IF;
1971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);