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.CZ_MODELOPERATIONS_PUB dependencies on FND_API

Line 23: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

19: NOT_VALID_PROJECT_ID EXCEPTION;
20:
21: BEGIN
22: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
23: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
24: RAISE G_INCOMPATIBLE_API;
25: END IF;
26:
27: BEGIN

Line 124: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

120: BEGIN
121: SAVEPOINT create_ui_PUB;
122:
123: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
124: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE G_INCOMPATIBLE_API;
126: END IF;
127:
128: BEGIN

Line 348: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

344:
345: BEGIN
346: SAVEPOINT create_ui_PUB;
347:
348: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
349: RAISE G_INCOMPATIBLE_API;
350: END IF;
351:
352: BEGIN

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

382: END IF;
383:
384: EXCEPTION
385: WHEN G_INCOMPATIBLE_API THEN
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: FND_MESSAGE.SET_NAME('CZ', 'CZ_MOP_API_VERSION_ERR');
388: FND_MESSAGE.SET_TOKEN('CODE_VERSION', l_api_version);
389: FND_MESSAGE.SET_TOKEN('IN_VERSION', p_api_version);
390: FND_MSG_PUB.ADD;

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
392: p_data => x_msg_data);
393:
394: WHEN NOT_VALID_PROJECT_ID THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MESSAGE.SET_NAME('CZ', 'CZ_MOP_DEV_PRJ_ID_ERR');
397: FND_MESSAGE.SET_TOKEN('PROJID', p_devl_project_id);
398: FND_MSG_PUB.ADD;
399: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398: FND_MSG_PUB.ADD;
399: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
400: p_data => x_msg_data);
401: WHEN WRONG_SHOW_NODES THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: l_errbuf := CZ_UTILS.GET_TEXT('CZ_MOP_SHOW_ALL_NODES_ERR');
404:
405:
406: FND_MESSAGE.SET_NAME('CZ', 'CZ_MOP_SHOW_ALL_NODES_ERR');

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
409: p_data => x_msg_data);
410:
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: ROLLBACK TO create_ui_PUB;
414: l_errbuf := SQLERRM;
415: END create_jrad_ui;
416:

Line 464: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

460: -- Start of API savepoint
461: SAVEPOINT refresh_ui_PUB;
462:
463: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
464: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
465: RAISE G_INCOMPATIBLE_API;
466: END IF;
467:
468: BEGIN

Line 595: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

591: BEGIN
592: -- Start of API savepoint
593: SAVEPOINT refresh_ui_PUB;
594:
595: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
596: RAISE G_INCOMPATIBLE_API;
597: END IF;
598:
599: BEGIN

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: COMMIT WORK;
623:
624: EXCEPTION
625: WHEN G_INCOMPATIBLE_API THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('CZ', 'CZ_MOP_API_VERSION_ERR');
628: FND_MESSAGE.SET_TOKEN('CODE_VERSION', l_api_version);
629: FND_MESSAGE.SET_TOKEN('IN_VERSION', p_api_version);
630: FND_MSG_PUB.ADD;

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
632: p_data => x_msg_data);
633:
634: WHEN NOT_VALID_UI_DEF_ID THEN
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MESSAGE.SET_NAME('CZ', 'CZ_MOP_UI_DEF_ID_ERR');
637: FND_MSG_PUB.ADD;
638: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
639: p_data => x_msg_data);

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
639: p_data => x_msg_data);
640:
641: WHEN WRONG_UI_STYLE THEN
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: FND_MESSAGE.SET_NAME('CZ', 'CZ_UI_STYLE_ERR');
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
646: p_data => x_msg_data);

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
646: p_data => x_msg_data);
647:
648: WHEN OTHERS THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: ROLLBACK TO refresh_ui_PUB;
651: END refresh_jrad_ui;
652:
653: ------------------------------------------------------------------------------------------------

Line 699: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

695: SESS_NOT_INITIALIZED EXCEPTION;
696:
697: BEGIN
698:
699: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
700: RAISE G_INCOMPATIBLE_API;
701: END IF;
702:
703: l_user_id := FND_GLOBAL.user_id;

Line 863: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

859: lTop_Id CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
860:
861: BEGIN
862:
863: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
864: RAISE G_INCOMPATIBLE_API;
865: END IF;
866: l_user_id := FND_GLOBAL.user_id;
867: IF (l_user_id IS NULL) THEN

Line 1041: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1037:
1038: BEGIN
1039: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1040:
1041: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1042: RAISE G_INCOMPATIBLE_API;
1043: END IF;
1044:
1045:

Line 1103: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1099: NOT_VALID_PROJECT_ID EXCEPTION;
1100:
1101: BEGIN
1102: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1103: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1104: RAISE G_INCOMPATIBLE_API;
1105: END IF;
1106:
1107: BEGIN

Line 1192: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1188: BEGIN
1189: SAVEPOINT execute_populator_PUB;
1190:
1191: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1192: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1193: RAISE G_INCOMPATIBLE_API;
1194: END IF;
1195:
1196: BEGIN

Line 1276: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1272: BEGIN
1273: SAVEPOINT repopulate_PUB;
1274:
1275: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1276: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1277: RAISE G_INCOMPATIBLE_API;
1278: END IF;
1279:
1280: BEGIN

Line 1365: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1361: l_publication_id NUMBER;
1362: BEGIN
1363: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1364:
1365: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1366: RAISE G_INCOMPATIBLE_API;
1367: END IF;
1368:
1369: l_start_date := p_start_date;

Line 1454: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1450: x_msg_data VARCHAR2(2000);
1451: l_dummy_nbr NUMBER;
1452:
1453: BEGIN
1454: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1455: RAISE G_INCOMPATIBLE_API;
1456: END IF;
1457:
1458: IF p_encl_folder_id IS NOT NULL THEN

Line 1488: RAISE FND_API.G_EXC_ERROR;

1484: EXCEPTION
1485: WHEN G_INCOMPATIBLE_API THEN
1486: RAISE G_INCOMPATIBLE_API;
1487: WHEN OTHERS THEN
1488: RAISE FND_API.G_EXC_ERROR;
1489: END rp_folder_exists;
1490: ---------------------------------------------------------
1491: FUNCTION rp_folder_exists (
1492: p_api_version IN NUMBER,

Line 1533: IF (NOT FND_API.compatible_api_call(l_api_version

1529: l_count NUMBER;
1530:
1531: BEGIN
1532: -- standard call to check for call compatibility
1533: IF (NOT FND_API.compatible_api_call(l_api_version
1534: ,p_api_version
1535: ,l_api_name
1536: ,G_PKG_NAME
1537: )) THEN

Line 1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1534: ,p_api_version
1535: ,l_api_name
1536: ,G_PKG_NAME
1537: )) THEN
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540:
1541: BEGIN -- validate the encl_folder_id
1542: SELECT 1 INTO l_dummy_nbr

Line 1550: RAISE FND_API.G_EXC_ERROR;

1546: AND deleted_flag = '0';
1547: EXCEPTION
1548: WHEN NO_DATA_FOUND THEN
1549: x_msg_data := CZ_UTILS.GET_TEXT('CZ_RP_FLDR_NO_ENCL_FLDR');
1550: RAISE FND_API.G_EXC_ERROR;
1551: END;
1552:
1553: BEGIN -- check if folder already exists, if so return its id
1554: SELECT object_id INTO x_new_folder_id

Line 1588: x_return_status := FND_API.G_RET_STS_SUCCESS;

1584: COMMIT;
1585: x_new_folder_id := l_new_object_id;
1586: END;
1587:
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1591: WHEN FND_API.G_EXC_ERROR THEN

1587:
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1592: x_return_status := FND_API.G_RET_STS_ERROR;

1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1596: p_data => x_msg_data);

Line 1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: WHEN OTHERS THEN

Line 1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: WHEN OTHERS THEN
1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: WHEN OTHERS THEN
1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1600: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1601: END IF;
1602: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1685: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1681: WHERE rec_status IS NOT NULL AND Run_ID = x_run_id;
1682:
1683: BEGIN
1684:
1685: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1686: RAISE G_INCOMPATIBLE_API;
1687: END IF;
1688:
1689: l_user_id := FND_GLOBAL.user_id;

Line 1724: p_lock_child_models => FND_API.G_FALSE,

1720: l_locked_models_tbl.DELETE;
1721: cz_security_pvt.lock_model(
1722: p_api_version => 1.0,
1723: p_model_id => l_model_id_tbl(i),
1724: p_lock_child_models => FND_API.G_FALSE,
1725: p_commit_flag => FND_API.G_TRUE,
1726: x_locked_entities => l_locked_models_tbl,
1727: x_return_status => l_return_status,
1728: x_msg_count => l_msg_count,

Line 1725: p_commit_flag => FND_API.G_TRUE,

1721: cz_security_pvt.lock_model(
1722: p_api_version => 1.0,
1723: p_model_id => l_model_id_tbl(i),
1724: p_lock_child_models => FND_API.G_FALSE,
1725: p_commit_flag => FND_API.G_TRUE,
1726: x_locked_entities => l_locked_models_tbl,
1727: x_return_status => l_return_status,
1728: x_msg_count => l_msg_count,
1729: x_msg_data => l_msg_data);

Line 1730: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1726: x_locked_entities => l_locked_models_tbl,
1727: x_return_status => l_return_status,
1728: x_msg_count => l_msg_count,
1729: x_msg_data => l_msg_data);
1730: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1731: FOR k IN 1..l_msg_count LOOP
1732: l_msg_data := fnd_msg_pub.get(k,fnd_api.g_false);
1733: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_MODELOPERATIONS_PUB.IMPORT_GENERIC',20001,p_run_id);
1734: COMMIT;

Line 1732: l_msg_data := fnd_msg_pub.get(k,fnd_api.g_false);

1728: x_msg_count => l_msg_count,
1729: x_msg_data => l_msg_data);
1730: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1731: FOR k IN 1..l_msg_count LOOP
1732: l_msg_data := fnd_msg_pub.get(k,fnd_api.g_false);
1733: xERROR:=cz_utils.log_report(l_msg_data,1,'CZ_MODELOPERATIONS_PUB.IMPORT_GENERIC',20001,p_run_id);
1734: COMMIT;
1735: END LOOP;
1736: RAISE FAILED_TO_LOCK_MODEL_EXCP;

Line 1755: p_commit_flag => FND_API.G_TRUE,

1751:
1752: IF (l_all_locked_models_tbl.COUNT > 0) THEN
1753: cz_security_pvt.unlock_model(
1754: p_api_version => 1.0,
1755: p_commit_flag => FND_API.G_TRUE,
1756: p_models_to_unlock => l_all_locked_models_tbl,
1757: x_return_status => l_return_status,
1758: x_msg_count => l_msg_count,
1759: x_msg_data => l_msg_data);

Line 1817: p_commit_flag => FND_API.G_TRUE,

1813: COMMIT;
1814: IF (l_all_locked_models_tbl.COUNT > 0) THEN
1815: cz_security_pvt.unlock_model(
1816: p_api_version => 1.0,
1817: p_commit_flag => FND_API.G_TRUE,
1818: p_models_to_unlock => l_all_locked_models_tbl,
1819: x_return_status => l_return_status,
1820: x_msg_count => l_msg_count,
1821: x_msg_data => l_msg_data);

Line 1854: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be

1850: /*#
1851: * This is the public interface for force unlock operations on a model in Oracle Configurator
1852: * @param p_api_version Current version of the API is 1.0
1853: * @param p_model_id devl_project_id of the model from cz_devl_projects table
1854: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
1855: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
1856: * will be unlocked
1857: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
1858: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

Line 1855: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model

1851: * This is the public interface for force unlock operations on a model in Oracle Configurator
1852: * @param p_api_version Current version of the API is 1.0
1853: * @param p_model_id devl_project_id of the model from cz_devl_projects table
1854: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
1855: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
1856: * will be unlocked
1857: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
1858: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
1859: * @param x_msg_count number of messages on the stack.

Line 1857: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

1853: * @param p_model_id devl_project_id of the model from cz_devl_projects table
1854: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
1855: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
1856: * will be unlocked
1857: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
1858: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
1859: * @param x_msg_count number of messages on the stack.
1860: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
1861: * @rep:scope public

Line 1858: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

1854: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
1855: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
1856: * will be unlocked
1857: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
1858: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
1859: * @param x_msg_count number of messages on the stack.
1860: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
1861: * @rep:scope public
1862: * @rep:product CZ

Line 1921: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

1917: /*#
1918: * This is the public interface for force unlock operations on a UI content template in Oracle Configurator
1919: * @param p_api_version Current version of the API is 1.0
1920: * @param p_template_id Template_id of the template from cz_ui_templates table
1921: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
1922: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
1923: * @param x_msg_count number of messages on the stack.
1924: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
1925: * @rep:scope public

Line 1922: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

1918: * This is the public interface for force unlock operations on a UI content template in Oracle Configurator
1919: * @param p_api_version Current version of the API is 1.0
1920: * @param p_template_id Template_id of the template from cz_ui_templates table
1921: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
1922: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
1923: * @param x_msg_count number of messages on the stack.
1924: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
1925: * @rep:scope public
1926: * @rep:product CZ

Line 1988: IF (NOT FND_API.compatible_api_call(l_api_version

1984: l_api_version CONSTANT NUMBER := 1.0;
1985: l_api_name CONSTANT VARCHAR2(30) := 'usage_id_from_usage_name';
1986: BEGIN
1987: -- standard call to check for call compatibility
1988: IF (NOT FND_API.compatible_api_call(l_api_version
1989: ,p_api_version
1990: ,l_api_name
1991: ,G_PKG_NAME
1992: )) THEN

Line 1993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1989: ,p_api_version
1990: ,l_api_name
1991: ,G_PKG_NAME
1992: )) THEN
1993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1994: END IF;
1995: SELECT model_usage_id
1996: INTO v_usage_id
1997: FROM CZ_MODEL_USAGES

Line 2001: x_return_status := FND_API.G_RET_STS_SUCCESS;

1997: FROM CZ_MODEL_USAGES
1998: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
1999: AND cz_model_usages.in_use = '1';
2000:
2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
2002: RETURN v_usage_id;
2003: EXCEPTION
2004: WHEN NO_DATA_FOUND THEN
2005: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 2005: x_return_status:=FND_API.G_RET_STS_ERROR;

2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
2002: RETURN v_usage_id;
2003: EXCEPTION
2004: WHEN NO_DATA_FOUND THEN
2005: x_return_status:=FND_API.G_RET_STS_ERROR;
2006: FND_MESSAGE.SET_NAME('CZ', 'CZ_USG_NO_USAGE_FOUND');
2007: FND_MSG_PUB.ADD;
2008: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2009: p_data => x_msg_data);

Line 2012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2008: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2009: p_data => x_msg_data);
2010: RETURN NULL;
2011:
2012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: RETURN NULL;

Line 2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2009: p_data => x_msg_data);
2010: RETURN NULL;
2011:
2012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: RETURN NULL;
2017: END usage_id_from_usage_name;

Line 2078: IF(NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME))THEN

2074: l_api_version CONSTANT NUMBER := 1.0;
2075: l_errbuf VARCHAR2(2000);
2076: BEGIN
2077:
2078: IF(NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME))THEN
2079:
2080: RAISE G_INCOMPATIBLE_API;
2081: END IF;
2082:

Line 2119: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2115: l_errbuf VARCHAR2(2000);
2116:
2117: BEGIN
2118:
2119: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2120: RAISE G_INCOMPATIBLE_API;
2121: END IF;
2122: cz_pb_mgr.create_publication_request(
2123: p_model_id,

Line 2137: IF l_status = FND_API.G_RET_STS_SUCCESS THEN

2133: l_status,
2134: x_msg_count,
2135: x_msg_data
2136: );
2137: IF l_status = FND_API.G_RET_STS_SUCCESS THEN
2138: x_return_status := G_STATUS_SUCCESS;
2139: ELSE
2140: x_return_status := G_STATUS_ERROR;
2141: END IF;