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 265: l_return_status := FND_API.G_RET_STS_SUCCESS;

261: -- Standard Start of API savepoint
262: SAVEPOINT CREATE_STRATEGY_PUB;
263:
264: -- Initialize API return status to SUCCESS
265: l_return_status := FND_API.G_RET_STS_SUCCESS;
266:
267: /*
268: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
269: return;

Line 328: IF FND_API.to_Boolean( l_init_msg_list ) THEN

324: l_objectType := UPPER(p_ObjectType);
325:
326:
327: -- Initialize message list IF p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean( l_init_msg_list ) THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: print_date => 'Y');
342: END IF;
343:
344: -- Initialize API return status to SUCCESS
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: --Start bug 6798118 gnramasa 05 Feb 08
348: If l_ObjectType in ('PARTY','ACCOUNT','BILL_TO','DELINQUENT') THEN
349: if (l_ObjectType = 'PARTY') then

Line 441: RAISE FND_API.G_EXC_ERROR;

437: FND_MESSAGE.Set_Name('IEX', 'IEX_UNKNOWN_OBJTYPE');
438: FND_MESSAGE.Set_Token('OBJECT_TYPE', l_ObjectType);
439: FND_MSG_PUB.Add;
440:
441: RAISE FND_API.G_EXC_ERROR;
442: return;
443: end if;
444:
445: EXCEPTION

Line 455: RAISE FND_API.G_EXC_ERROR;

451: FND_MESSAGE.Set_Name('IEX', 'IEX_OBJECT_NOT_EXISTS');
452: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
453: FND_MSG_PUB.Add;
454:
455: RAISE FND_API.G_EXC_ERROR;
456: return;
457:
458: END;
459: elsif p_ObjectID IS NOT NULL then

Line 511: RAISE FND_API.G_EXC_ERROR;

507: FND_MESSAGE.Set_Name('IEX', 'IEX_UNKNOWN_OBJTYPE');
508: FND_MESSAGE.Set_Token('OBJECT_TYPE', l_ObjectType);
509: FND_MSG_PUB.Add;
510:
511: RAISE FND_API.G_EXC_ERROR;
512: return;
513: end if;
514:
515: EXCEPTION

Line 527: RAISE FND_API.G_EXC_ERROR;

523: FND_MESSAGE.Set_Name('IEX', 'IEX_OBJECT_NOT_EXISTS');
524: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
525: FND_MSG_PUB.Add;
526:
527: RAISE FND_API.G_EXC_ERROR;
528: return;
529:
530: END;
531:

Line 806: p_commit => FND_API.G_FALSE,

802: Begin
803:
804: iex_strategy_pvt.create_strategy(
805: P_Api_Version_Number=>2.0,
806: p_commit => FND_API.G_FALSE,
807: P_Init_Msg_List =>FND_API.G_FALSE,
808: p_strategy_rec => l_strategy_rec,
809: x_return_status=>l_return_status,
810: x_msg_count=>l_msg_count,

Line 807: P_Init_Msg_List =>FND_API.G_FALSE,

803:
804: iex_strategy_pvt.create_strategy(
805: P_Api_Version_Number=>2.0,
806: p_commit => FND_API.G_FALSE,
807: P_Init_Msg_List =>FND_API.G_FALSE,
808: p_strategy_rec => l_strategy_rec,
809: x_return_status=>l_return_status,
810: x_msg_count=>l_msg_count,
811: x_msg_data=>l_msg_data,

Line 820: RAISE FND_API.G_EXC_ERROR;

816: IEX_DEBUG_PUB.LogMessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
817: END IF;
818:
819: if (x_return_status <> 'S') then
820: RAISE FND_API.G_EXC_ERROR;
821: end if;
822:
823: l_strategy_rec.strategy_id := l_strategy_id;
824:

Line 839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

835: FND_MESSAGE.Set_Name('IEX', 'IEX_STRATEGY_CREATE_FAILED');
836: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
837: FND_MSG_PUB.Add;
838:
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840:
841: END;
842:
843:

Line 852: P_Init_Msg_List => FND_API.G_FALSE,

848: BEGIN
849:
850: iex_strategy_wf_pub.start_workflow(
851: P_Api_Version =>2.0,
852: P_Init_Msg_List => FND_API.G_FALSE,
853: p_commit => FND_API.G_FALSE,
854: p_strategy_rec => l_strategy_rec,
855: x_return_status=>l_return_status,
856: x_msg_count=>l_msg_count,

Line 853: p_commit => FND_API.G_FALSE,

849:
850: iex_strategy_wf_pub.start_workflow(
851: P_Api_Version =>2.0,
852: P_Init_Msg_List => FND_API.G_FALSE,
853: p_commit => FND_API.G_FALSE,
854: p_strategy_rec => l_strategy_rec,
855: x_return_status=>l_return_status,
856: x_msg_count=>l_msg_count,
857: x_msg_data=>l_msg_data,

Line 867: RAISE FND_API.G_EXC_ERROR;

863: END IF;
864: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
865:
866: if (x_return_status <> 'S') then
867: RAISE FND_API.G_EXC_ERROR;
868: end if;
869:
870: EXCEPTION
871: WHEN OTHERS THEN

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: FND_MESSAGE.Set_Name('IEX', 'IEX_LAUNCH_WORKFLOW_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: -- Standard check for p_commit

Line 885: IF FND_API.to_Boolean(l_commit) THEN

881:
882: END;
883:
884: -- Standard check for p_commit
885: IF FND_API.to_Boolean(l_commit) THEN
886: COMMIT WORK;
887: END IF;
888:
889: ELSE

Line 920: WHEN FND_API.G_EXC_ERROR THEN

916: IEX_DEBUG_PUB.LogMessage('Delinquency cursor ends' );
917:
918: EXCEPTION
919:
920: WHEN FND_API.G_EXC_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 921: x_return_status := FND_API.G_RET_STS_ERROR;

917:
918: EXCEPTION
919:
920: WHEN FND_API.G_EXC_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

920: WHEN FND_API.G_EXC_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927:
928: WHEN OTHERS THEN

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

921: x_return_status := FND_API.G_RET_STS_ERROR;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927:
928: WHEN OTHERS THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927:
928: WHEN OTHERS THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
931: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
932: END IF;
933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1230: l_Init_Msg_List := FND_API.G_FALSE;

1226: l_Init_Msg_List := P_Init_Msg_List;
1227: l_Commit := P_Commit;
1228: l_validation_level := p_validation_level;
1229: if (l_Init_msg_List is null) then
1230: l_Init_Msg_List := FND_API.G_FALSE;
1231: end if;
1232: if (l_Commit is null) then
1233: l_Commit := FND_API.G_FALSE;
1234: end if;

Line 1233: l_Commit := FND_API.G_FALSE;

1229: if (l_Init_msg_List is null) then
1230: l_Init_Msg_List := FND_API.G_FALSE;
1231: end if;
1232: if (l_Commit is null) then
1233: l_Commit := FND_API.G_FALSE;
1234: end if;
1235: if (l_validation_level is null) then
1236: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1237: end if;

Line 1236: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1232: if (l_Commit is null) then
1233: l_Commit := FND_API.G_FALSE;
1234: end if;
1235: if (l_validation_level is null) then
1236: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1237: end if;
1238:
1239: l_api_name := 'SET_STRATEGY';
1240:

Line 1244: x_return_status := FND_API.G_RET_STS_SUCCESS;

1240:
1241: fStrategyVersionNumber := 2.0;
1242: l_object_version_number := 2.0;
1243:
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245: -- Standard Start of API savepoint
1246:
1247:
1248: -- Initialize API return status to SUCCESS

Line 1249: l_return_status := FND_API.G_RET_STS_SUCCESS;

1245: -- Standard Start of API savepoint
1246:
1247:
1248: -- Initialize API return status to SUCCESS
1249: l_return_status := FND_API.G_RET_STS_SUCCESS;
1250: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1251: return;
1252: end if;
1253: l_objectType := UPPER(p_ObjectType);

Line 1264: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1260:
1261: SAVEPOINT SET_STRATEGY;
1262:
1263: -- Initialize message list IF p_init_msg_list is set to TRUE.
1264: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1265: FND_MSG_PUB.initialize;
1266: END IF;
1267:
1268: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1285: x_return_status := FND_API.G_RET_STS_SUCCESS;

1281: print_date => 'Y');
1282: END IF;
1283:
1284: -- Initialize API return status to SUCCESS
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286: -- Debug Message
1287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1288: IEX_DEBUG_PUB.LogMessage(
1289: debug_msg => '2. CHECK VALID STATUS => ' || p_Status,

Line 1299: RAISE FND_API.G_EXC_ERROR;

1295: FND_MESSAGE.Set_Name('IEX', 'IEX_UNKNOWN_STATUS');
1296: FND_MESSAGE.Set_Token('STATUS', p_Status);
1297: FND_MSG_PUB.Add;
1298:
1299: RAISE FND_API.G_EXC_ERROR;
1300: return;
1301:
1302: end if;
1303:

Line 1349: p_commit => FND_API.G_FALSE,

1345: Begin
1346:
1347: iex_strategy_pvt.update_strategy(
1348: P_Api_Version_Number=>2.0,
1349: p_commit => FND_API.G_FALSE,
1350: P_Init_Msg_List =>FND_API.G_FALSE,
1351: p_strategy_rec => l_strategy_rec,
1352: x_return_status=>l_return_status,
1353: x_msg_count=>l_msg_count,

Line 1350: P_Init_Msg_List =>FND_API.G_FALSE,

1346:
1347: iex_strategy_pvt.update_strategy(
1348: P_Api_Version_Number=>2.0,
1349: p_commit => FND_API.G_FALSE,
1350: P_Init_Msg_List =>FND_API.G_FALSE,
1351: p_strategy_rec => l_strategy_rec,
1352: x_return_status=>l_return_status,
1353: x_msg_count=>l_msg_count,
1354: x_msg_data=>l_msg_data,

Line 1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1355: xo_object_version_number => l_object_version_number
1356: );
1357:
1358: if (x_return_status <> 'S') then
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: end if;
1361:
1362: EXCEPTION
1363: WHEN OTHERS THEN

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: END IF;
1369:
1370: FND_MESSAGE.Set_Name('IEX', 'IEX_STRATEGY_UPDATE_FAILED');
1371: FND_MSG_PUB.ADD;
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373:
1374: END;
1375:
1376: -- Standard check for p_commit

Line 1377: IF FND_API.to_Boolean(l_commit) THEN

1373:
1374: END;
1375:
1376: -- Standard check for p_commit
1377: IF FND_API.to_Boolean(l_commit) THEN
1378: COMMIT WORK;
1379: END IF;
1380:
1381: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',

Line 1403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1399: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_STRATEGIES_EXIST');
1400: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(fObjectID));
1401: FND_MSG_PUB.ADD;
1402:
1403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1404:
1405: end if;
1406:
1407: -- Standard call to get message count and if count is 1, get message info.

Line 1418: WHEN FND_API.G_EXC_ERROR THEN

1414:
1415:
1416: EXCEPTION
1417:
1418: WHEN FND_API.G_EXC_ERROR THEN
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1419: x_return_status := FND_API.G_RET_STS_ERROR;

1415:
1416: EXCEPTION
1417:
1418: WHEN FND_API.G_EXC_ERROR THEN
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1418: WHEN FND_API.G_EXC_ERROR THEN
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1425:
1426: WHEN OTHERS THEN

Line 1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1425:
1426: WHEN OTHERS THEN
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1425:
1426: WHEN OTHERS THEN
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1429: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1430: END IF;
1431: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1542: x_return_status := FND_API.G_RET_STS_SUCCESS;

1538: print_date => 'Y');
1539: END IF;
1540:
1541: -- Initialize API return status to SUCCESS
1542: x_return_status := FND_API.G_RET_STS_SUCCESS;
1543:
1544: --Start bug 6723540 gnramasa 02 Jan 08
1545: if p_delinquencyid is not null then
1546: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1593: RAISE FND_API.G_EXC_ERROR;

1589: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_STRATEGIES_EXIST');
1590: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(p_DelinquencyID));
1591: FND_MSG_PUB.ADD;
1592:
1593: RAISE FND_API.G_EXC_ERROR;
1594:
1595: end if;
1596:
1597: EXCEPTION

Line 1608: x_return_status := FND_API.G_RET_STS_ERROR;

1604: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_STRATEGIES_EXIST');
1605: FND_MESSAGE.Set_Token('OBJECT_ID', to_char(p_DelinquencyID));
1606: FND_MSG_PUB.ADD;
1607:
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1610:
1611: WHEN FND_API.G_EXC_ERROR THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1611: WHEN FND_API.G_EXC_ERROR THEN

1607:
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1610:
1611: WHEN FND_API.G_EXC_ERROR THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1614:
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1612: x_return_status := FND_API.G_RET_STS_ERROR;

1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1610:
1611: WHEN FND_API.G_EXC_ERROR THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1614:
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1611: WHEN FND_API.G_EXC_ERROR THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1614:
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1618:
1619: WHEN OTHERS THEN

Line 1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1614:
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1618:
1619: WHEN OTHERS THEN
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1618:
1619: WHEN OTHERS THEN
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1622: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1623: END IF;
1624: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1690: l_Init_Msg_List := FND_API.G_FALSE;

1686: l_Init_Msg_List := P_Init_Msg_List;
1687: l_Commit := P_Commit;
1688: l_validation_level := p_validation_level;
1689: if (l_Init_msg_List is null) then
1690: l_Init_Msg_List := FND_API.G_FALSE;
1691: end if;
1692: if (l_Commit is null) then
1693: l_Commit := FND_API.G_FALSE;
1694: end if;

Line 1693: l_Commit := FND_API.G_FALSE;

1689: if (l_Init_msg_List is null) then
1690: l_Init_Msg_List := FND_API.G_FALSE;
1691: end if;
1692: if (l_Commit is null) then
1693: l_Commit := FND_API.G_FALSE;
1694: end if;
1695: if (l_validation_level is null) then
1696: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1697: end if;

Line 1696: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1692: if (l_Commit is null) then
1693: l_Commit := FND_API.G_FALSE;
1694: end if;
1695: if (l_validation_level is null) then
1696: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1697: end if;
1698:
1699: l_api_name := 'CLOSE_STRATEGY';
1700:

Line 1704: x_return_status := FND_API.G_RET_STS_SUCCESS;

1700:
1701: fStrategyVersionNumber := 2.0;
1702: l_object_version_number := 2.0;
1703:
1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1706: return;
1707: end if;
1708: -- Standard Start of API savepoint

Line 1712: l_return_status := FND_API.G_RET_STS_SUCCESS;

1708: -- Standard Start of API savepoint
1709: SAVEPOINT SET_STRATEGY;
1710:
1711: -- Initialize API return status to SUCCESS
1712: l_return_status := FND_API.G_RET_STS_SUCCESS;
1713: l_objectType := UPPER(p_ObjectType);
1714:
1715:
1716: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 1717: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1713: l_objectType := UPPER(p_ObjectType);
1714:
1715:
1716: -- Initialize message list IF p_init_msg_list is set to TRUE.
1717: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1718: FND_MSG_PUB.initialize;
1719: END IF;
1720:
1721: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1734: x_return_status := FND_API.G_RET_STS_SUCCESS;

1730: print_date => 'Y');
1731: END IF;
1732:
1733: -- Initialize API return status to SUCCESS
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736: l_object_version_number := 1;
1737: vStrategyStatus := NULL;
1738:

Line 1792: p_commit => FND_API.G_FALSE,

1788: Begin
1789:
1790: iex_strategy_pvt.update_strategy(
1791: P_Api_Version_Number=>2.0,
1792: p_commit => FND_API.G_FALSE,
1793: P_Init_Msg_List =>FND_API.G_FALSE,
1794: p_strategy_rec => l_strategy_rec,
1795: x_return_status=>l_return_status,
1796: x_msg_count=>l_msg_count,

Line 1793: P_Init_Msg_List =>FND_API.G_FALSE,

1789:
1790: iex_strategy_pvt.update_strategy(
1791: P_Api_Version_Number=>2.0,
1792: p_commit => FND_API.G_FALSE,
1793: P_Init_Msg_List =>FND_API.G_FALSE,
1794: p_strategy_rec => l_strategy_rec,
1795: x_return_status=>l_return_status,
1796: x_msg_count=>l_msg_count,
1797: x_msg_data=>l_msg_data,

Line 1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1798: xo_object_version_number => l_object_version_number
1799: );
1800:
1801: if (x_return_status <> 'S') then
1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1803: end if;
1804:
1805: EXCEPTION
1806: WHEN OTHERS THEN

Line 1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1812:
1813: FND_MESSAGE.Set_Name('IEX', 'IEX_STRATEGY_UPDATE_FAILED');
1814: FND_MSG_PUB.ADD;
1815:
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817:
1818: END;
1819:
1820: -- Standard check for p_commit

Line 1821: IF FND_API.to_Boolean(l_commit) THEN

1817:
1818: END;
1819:
1820: -- Standard check for p_commit
1821: IF FND_API.to_Boolean(l_commit) THEN
1822: COMMIT WORK;
1823: END IF;
1824:
1825: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',

Line 1841: WHEN FND_API.G_EXC_ERROR THEN

1837:
1838:
1839: EXCEPTION
1840:
1841: WHEN FND_API.G_EXC_ERROR THEN
1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1844:
1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1842: x_return_status := FND_API.G_RET_STS_ERROR;

1838:
1839: EXCEPTION
1840:
1841: WHEN FND_API.G_EXC_ERROR THEN
1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1844:
1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1841: WHEN FND_API.G_EXC_ERROR THEN
1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1844:
1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1848: WHEN OTHERS THEN
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1844:
1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1848: WHEN OTHERS THEN
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1850: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1848: WHEN OTHERS THEN
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1850: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1851: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1852: END IF;
1853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);