DBA Data[Home] [Help]

APPS.BIS_IMPL_DEV_PKG dependencies on FND_API

Line 47: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

43: P_CREATION_DATE in DATE := null,
44: P_LAST_UPDATED_BY in NUMBER := null,
45: P_LAST_UPDATE_LOGIN in NUMBER := null,
46: P_LAST_UPDATE_DATE in DATE := null,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
48: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_errorcode OUT NOCOPY NUMBER,
51: x_msg_count OUT NOCOPY NUMBER,

Line 48: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

44: P_LAST_UPDATED_BY in NUMBER := null,
45: P_LAST_UPDATE_LOGIN in NUMBER := null,
46: P_LAST_UPDATE_DATE in DATE := null,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
48: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_errorcode OUT NOCOPY NUMBER,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2

Line 73: IF FND_API.to_Boolean( p_init_msg_list ) THEN

69:
70: begin
71: -- Initialize API message list if necessary.
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.to_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: insert into bis_obj_prog_linkages (

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: end if;
125: close c_in_properties;
126: */
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: -----------------------------------
131: -- Make a standard call to get message count
132: -- and if count is 1, get message info.

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: exception
145: when no_data_found then
146: return;
147: when others then
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: IF FND_MSG_PUB.Check_Msg_Level
150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
151: THEN
152: FND_MSG_PUB.Add_Exc_Msg

Line 180: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

176: P_CREATION_DATE in DATE := null,
177: P_LAST_UPDATED_BY in NUMBER := null,
178: P_LAST_UPDATE_LOGIN in NUMBER := null,
179: P_LAST_UPDATE_DATE in DATE := null,
180: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
181: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_errorcode OUT NOCOPY NUMBER,
184: x_msg_count OUT NOCOPY NUMBER,

Line 181: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

177: P_LAST_UPDATED_BY in NUMBER := null,
178: P_LAST_UPDATE_LOGIN in NUMBER := null,
179: P_LAST_UPDATE_DATE in DATE := null,
180: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
181: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_errorcode OUT NOCOPY NUMBER,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2

Line 228: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

224: P_REFRESH_MODE in VARCHAR2,
225: P_LAST_UPDATED_BY in NUMBER := null,
226: P_LAST_UPDATE_LOGIN in NUMBER := null,
227: P_LAST_UPDATE_DATE in DATE := null,
228: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
229: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_errorcode OUT NOCOPY NUMBER,
232: x_msg_count OUT NOCOPY NUMBER,

Line 229: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

225: P_LAST_UPDATED_BY in NUMBER := null,
226: P_LAST_UPDATE_LOGIN in NUMBER := null,
227: P_LAST_UPDATE_DATE in DATE := null,
228: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
229: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_errorcode OUT NOCOPY NUMBER,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2

Line 243: IF FND_API.to_Boolean( p_init_msg_list ) THEN

239: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
240: begin
241: -- Initialize API message list if necessary.
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean( p_init_msg_list ) THEN
244: FND_MSG_PUB.initialize;
245: END IF;
246:
247: if (P_ROWID is not null) then

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: AND CONC_PROGRAM_NAME = P_CONC_PROGRAM_NAME
270: AND CONC_APP_ID = P_CONC_APP_ID;
271: END IF;
272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: -----------------------------------
276: -- Make a standard call to get message count
277: -- and if count is 1, get message info.

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

289: exception
290: when no_data_found then
291: return;
292: when others then
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: IF FND_MSG_PUB.Check_Msg_Level
295: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
296: THEN
297: FND_MSG_PUB.Add_Exc_Msg

Line 323: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

319: P_REFRESH_MODE in VARCHAR2,
320: P_LAST_UPDATED_BY in NUMBER := null,
321: P_LAST_UPDATE_LOGIN in NUMBER := null,
322: P_LAST_UPDATE_DATE in DATE := null,
323: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
324: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_errorcode OUT NOCOPY NUMBER,
327: x_msg_count OUT NOCOPY NUMBER,

Line 324: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

320: P_LAST_UPDATED_BY in NUMBER := null,
321: P_LAST_UPDATE_LOGIN in NUMBER := null,
322: P_LAST_UPDATE_DATE in DATE := null,
323: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
324: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_errorcode OUT NOCOPY NUMBER,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2

Line 908: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

904: P_CREATION_DATE in DATE := null,
905: P_LAST_UPDATED_BY in NUMBER := null,
906: P_LAST_UPDATE_LOGIN in NUMBER := null,
907: P_LAST_UPDATE_DATE in DATE := null,
908: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
909: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_errorcode OUT NOCOPY NUMBER,
912: x_msg_count OUT NOCOPY NUMBER,

Line 909: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

905: P_LAST_UPDATED_BY in NUMBER := null,
906: P_LAST_UPDATE_LOGIN in NUMBER := null,
907: P_LAST_UPDATE_DATE in DATE := null,
908: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
909: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_errorcode OUT NOCOPY NUMBER,
912: x_msg_count OUT NOCOPY NUMBER,
913: x_msg_data OUT NOCOPY VARCHAR2

Line 937: IF FND_API.to_Boolean( p_init_msg_list ) THEN

933: l_msg_data varchar2(4000);
934: begin
935: -- Initialize API message list if necessary.
936: -- Initialize message list if p_init_msg_list is set to TRUE.
937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
938: FND_MSG_PUB.initialize;
939: END IF;
940:
941: insert into bis_obj_dependency (

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: end if;
1006: close c_in_properties;
1007: end if;
1008:
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010:
1011: -----------------------------------
1012: -- Make a standard call to get message count
1013: -- and if count is 1, get message info.

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1024: exception
1025: when no_data_found then
1026: return;
1027: when others then
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: IF FND_MSG_PUB.Check_Msg_Level
1030: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1031: THEN
1032: FND_MSG_PUB.Add_Exc_Msg

Line 1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

1055: P_CREATION_DATE in DATE := null,
1056: P_LAST_UPDATED_BY in NUMBER := null,
1057: P_LAST_UPDATE_LOGIN in NUMBER := null,
1058: P_LAST_UPDATE_DATE in DATE := null,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1060: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1061: x_return_status OUT NOCOPY VARCHAR2,
1062: x_errorcode OUT NOCOPY NUMBER,
1063: x_msg_count OUT NOCOPY NUMBER,

Line 1060: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

1056: P_LAST_UPDATED_BY in NUMBER := null,
1057: P_LAST_UPDATE_LOGIN in NUMBER := null,
1058: P_LAST_UPDATE_DATE in DATE := null,
1059: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1060: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1061: x_return_status OUT NOCOPY VARCHAR2,
1062: x_errorcode OUT NOCOPY NUMBER,
1063: x_msg_count OUT NOCOPY NUMBER,
1064: x_msg_data OUT NOCOPY VARCHAR2

Line 1107: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

1103: P_FROM_UI in VARCHAR2,
1104: P_LAST_UPDATED_BY in NUMBER := null,
1105: P_LAST_UPDATE_LOGIN in NUMBER := null,
1106: P_LAST_UPDATE_DATE in DATE := null,
1107: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1108: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1109: x_return_status OUT NOCOPY VARCHAR2,
1110: x_errorcode OUT NOCOPY NUMBER,
1111: x_msg_count OUT NOCOPY NUMBER,

Line 1108: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

1104: P_LAST_UPDATED_BY in NUMBER := null,
1105: P_LAST_UPDATE_LOGIN in NUMBER := null,
1106: P_LAST_UPDATE_DATE in DATE := null,
1107: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1108: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1109: x_return_status OUT NOCOPY VARCHAR2,
1110: x_errorcode OUT NOCOPY NUMBER,
1111: x_msg_count OUT NOCOPY NUMBER,
1112: x_msg_data OUT NOCOPY VARCHAR2

Line 1134: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1130: l_msg_data varchar2(4000);
1131: begin
1132: -- Initialize API message list if necessary.
1133: -- Initialize message list if p_init_msg_list is set to TRUE.
1134: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1135: FND_MSG_PUB.initialize;
1136: END IF;
1137:
1138: if (P_ROWID IS NOT NULL) THEN

Line 1194: x_return_status := FND_API.G_RET_STS_SUCCESS;

1190: execute immediate 'update bis_obj_prog_linkages set object_owner = :1
1191: WHERE object_type = :2 AND object_name = :3'
1192: using P_DEPEND_OBJECT_OWNER, P_DEPEND_OBJECT_TYPE, P_DEPEND_OBJECT_NAME;
1193:
1194: x_return_status := FND_API.G_RET_STS_SUCCESS;
1195:
1196: -----------------------------------
1197: -- Make a standard call to get message count
1198: -- and if count is 1, get message info.

Line 1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1210: exception
1211: when no_data_found then
1212: return;
1213: when others then
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: IF FND_MSG_PUB.Check_Msg_Level
1216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg

Line 1244: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

1240: P_FROM_UI in VARCHAR2,
1241: P_LAST_UPDATED_BY in NUMBER := null,
1242: P_LAST_UPDATE_LOGIN in NUMBER := null,
1243: P_LAST_UPDATE_DATE in DATE := null,
1244: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1245: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1246: x_return_status OUT NOCOPY VARCHAR2,
1247: x_errorcode OUT NOCOPY NUMBER,
1248: x_msg_count OUT NOCOPY NUMBER,

Line 1245: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

1241: P_LAST_UPDATED_BY in NUMBER := null,
1242: P_LAST_UPDATE_LOGIN in NUMBER := null,
1243: P_LAST_UPDATE_DATE in DATE := null,
1244: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1245: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1246: x_return_status OUT NOCOPY VARCHAR2,
1247: x_errorcode OUT NOCOPY NUMBER,
1248: x_msg_count OUT NOCOPY NUMBER,
1249: x_msg_data OUT NOCOPY VARCHAR2

Line 1308: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

1304: P_CREATION_DATE in DATE,
1305: P_LAST_UPDATED_BY in NUMBER,
1306: P_LAST_UPDATE_LOGIN in NUMBER,
1307: P_LAST_UPDATE_DATE in DATE,
1308: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1309: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1310: x_return_status OUT NOCOPY VARCHAR2,
1311: x_errorcode OUT NOCOPY NUMBER,
1312: x_msg_count OUT NOCOPY NUMBER,

Line 1309: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

1305: P_LAST_UPDATED_BY in NUMBER,
1306: P_LAST_UPDATE_LOGIN in NUMBER,
1307: P_LAST_UPDATE_DATE in DATE,
1308: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1309: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1310: x_return_status OUT NOCOPY VARCHAR2,
1311: x_errorcode OUT NOCOPY NUMBER,
1312: x_msg_count OUT NOCOPY NUMBER,
1313: x_msg_data OUT NOCOPY VARCHAR2

Line 1326: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1322:
1323: begin
1324: -- Initialize API message list if necessary.
1325: -- Initialize message list if p_init_msg_list is set to TRUE.
1326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1327: FND_MSG_PUB.initialize;
1328: END IF;
1329:
1330: insert into bis_obj_properties (

Line 1357: x_return_status := FND_API.G_RET_STS_SUCCESS;

1353: L_LAST_UPDATED_BY,
1354: L_LAST_UPDATE_LOGIN,
1355: L_LAST_UPDATE_DATE);
1356:
1357: x_return_status := FND_API.G_RET_STS_SUCCESS;
1358:
1359: -----------------------------------
1360: -- Make a standard call to get message count
1361: -- and if count is 1, get message info.

Line 1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1372: exception
1373: when no_data_found then
1374: return;
1375: when others then
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF FND_MSG_PUB.Check_Msg_Level
1378: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: FND_MSG_PUB.Add_Exc_Msg

Line 1406: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

1402: P_CREATION_DATE in DATE,
1403: P_LAST_UPDATED_BY in NUMBER,
1404: P_LAST_UPDATE_LOGIN in NUMBER,
1405: P_LAST_UPDATE_DATE in DATE,
1406: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1407: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1408: x_return_status OUT NOCOPY VARCHAR2,
1409: x_errorcode OUT NOCOPY NUMBER,
1410: x_msg_count OUT NOCOPY NUMBER,

Line 1407: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

1403: P_LAST_UPDATED_BY in NUMBER,
1404: P_LAST_UPDATE_LOGIN in NUMBER,
1405: P_LAST_UPDATE_DATE in DATE,
1406: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
1407: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
1408: x_return_status OUT NOCOPY VARCHAR2,
1409: x_errorcode OUT NOCOPY NUMBER,
1410: x_msg_count OUT NOCOPY NUMBER,
1411: x_msg_data OUT NOCOPY VARCHAR2

Line 1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1478: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
1479: begin
1480: -- Initialize API message list if necessary.
1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1483: FND_MSG_PUB.initialize;
1484: END IF;
1485:
1486: update bis_obj_properties

Line 1499: x_return_status := FND_API.G_RET_STS_SUCCESS;

1495: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE
1496: WHERE OBJECT_TYPE = P_OBJECT_TYPE
1497: AND OBJECT_NAME = P_OBJECT_NAME ;
1498:
1499: x_return_status := FND_API.G_RET_STS_SUCCESS;
1500:
1501: -----------------------------------
1502: -- Make a standard call to get message count
1503: -- and if count is 1, get message info.

Line 1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1515: exception
1516: when no_data_found then
1517: return;
1518: when others then
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: IF FND_MSG_PUB.Check_Msg_Level
1521: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1522: THEN
1523: FND_MSG_PUB.Add_Exc_Msg

Line 1607: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1603: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
1604: begin
1605: -- Initialize API message list if necessary.
1606: -- Initialize message list if p_init_msg_list is set to TRUE.
1607: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1608: FND_MSG_PUB.initialize;
1609: END IF;
1610:
1611: update bis_obj_properties

Line 1623: x_return_status := FND_API.G_RET_STS_SUCCESS;

1619: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE
1620: WHERE OBJECT_TYPE = P_OBJECT_TYPE
1621: AND OBJECT_NAME = P_OBJECT_NAME ;
1622:
1623: x_return_status := FND_API.G_RET_STS_SUCCESS;
1624:
1625: -----------------------------------
1626: -- Make a standard call to get message count
1627: -- and if count is 1, get message info.

Line 1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1639: exception
1640: when no_data_found then
1641: return;
1642: when others then
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: IF FND_MSG_PUB.Check_Msg_Level
1645: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1646: THEN
1647: FND_MSG_PUB.Add_Exc_Msg