DBA Data[Home] [Help]

APPS.CZ_XML dependencies on FND_API

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132:
133: BEGIN
134: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;
135: x_run_id := G_RUN_ID;
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: x_msg_count := 0;
138: x_msg_data := NULL;
139: END Initialize;
140:

Line 216: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN

212: fnd_msg_pub.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
213: END IF;
214: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
215: p_data => g_MSG_DATA);
216: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
217: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
218: ELSE
219: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
220: END IF;

Line 217: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

213: END IF;
214: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
215: p_data => g_MSG_DATA);
216: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
217: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
218: ELSE
219: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
220: END IF;
221:

Line 219: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

215: p_data => g_MSG_DATA);
216: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
217: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
218: ELSE
219: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
220: END IF;
221:
222: LOG_REPORT(p_caller, p_message_name);
223:

Line 1183: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1179: BEGIN
1180:
1181: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1182:
1183: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1184: Open_Parser();
1185: handle_UIS_with_Bad_Attributes(p_ui_def_id => p_ui_def_id,
1186: p_remove_bad_attributes => FALSE);
1187: Close_Parser();

Line 1191: x_return_status := FND_API.G_RET_STS_ERROR;

1187: Close_Parser();
1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.G_RET_STS_ERROR;
1192: x_msg_count := 1;
1193: x_msg_data := 'Fatal error : '||SQLERRM;
1194: add_Error_Message(p_caller => 'CZ_XML.detect_UIS_with_Bad_Attributes',
1195: p_message_name => 'Close_Parser() : XML Parser can not be closed : '||SQLERRM,

Line 1210: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1206: x_msg_data OUT NOCOPY VARCHAR2) IS
1207:
1208: BEGIN
1209: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1210: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1211: Open_Parser();
1212: handle_UIS_with_Bad_Attributes(p_ui_def_id => p_ui_def_id,
1213: p_remove_bad_attributes => TRUE);
1214: Close_Parser();

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR;

1213: p_remove_bad_attributes => TRUE);
1214: Close_Parser();
1215: EXCEPTION
1216: WHEN OTHERS THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: x_msg_count := 1;
1219: x_msg_data := 'Fatal error : '||SQLERRM;
1220: Close_Parser();
1221: END remove_Bad_Attributes_in_UIS;

Line 1271: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1267: x_msg_data OUT NOCOPY VARCHAR2) IS
1268:
1269: BEGIN
1270: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1271: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1272: Open_Parser();
1273: handle_TMPLS_with_Bad_Attrs(p_template_id => p_template_id,
1274: p_remove_bad_attributes => FALSE);
1275: Close_Parser();

Line 1280: x_return_status := FND_API.G_RET_STS_ERROR;

1276:
1277: /*
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: x_msg_count := 1;
1282: x_msg_data := 'Fatal error : '||SQLERRM;
1283: Close_Parser();
1284: */

Line 1295: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1291: x_msg_count OUT NOCOPY NUMBER,
1292: x_msg_data OUT NOCOPY VARCHAR2) IS
1293: BEGIN
1294: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1296: Open_Parser();
1297: handle_TMPLS_with_Bad_Attrs(p_template_id => p_template_id,
1298: p_remove_bad_attributes => TRUE);
1299: Close_Parser();

Line 1302: x_return_status := FND_API.G_RET_STS_ERROR;

1298: p_remove_bad_attributes => TRUE);
1299: Close_Parser();
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: x_return_status := FND_API.G_RET_STS_ERROR;
1303: x_msg_count := 1;
1304: x_msg_data := 'Fatal error : '||SQLERRM;
1305: Close_Parser();
1306: END remove_Bad_Attributes_in_TMPLS;

Line 1346: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1342: x_msg_data OUT NOCOPY VARCHAR2) IS
1343:
1344: BEGIN
1345: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1347: Open_Parser();
1348: replace_Bad_Element_Ids(p_ui_def_id => p_ui_def_id);
1349: Close_Parser();
1350: /*

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: Close_Parser();
1350: /*
1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: x_msg_count := 1;
1355: x_msg_data := 'Fatal error in CZ_XML.replace_Element_Ids() : '||SQLERRM;
1356: Close_Parser();
1357: */

Line 1478: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1474: x_msg_data OUT NOCOPY VARCHAR2) IS
1475:
1476: BEGIN
1477: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1478: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1479:
1480: IF p_ui_def_id IS NULL THEN
1481: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0')
1482: LOOP

Line 1518: x_return_status := FND_API.G_RET_STS_ERROR;

1514: END IF;
1515:
1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: x_return_status := FND_API.G_RET_STS_ERROR;
1519: x_msg_count := 1;
1520: x_msg_data := 'Fatal error in CZ_XML.restore_Parent_Elements() : '||SQLERRM;
1521: Close_Parser();
1522: END restore_Parent_Elements;

Line 1689: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1685:
1686: BEGIN
1687: --dbms_output.enable(2000000);
1688: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1689: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1690:
1691: IF p_ui_def_id IS NULL THEN
1692: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND seeded_flag='0' AND deleted_flag='0')
1693: LOOP

Line 1729: x_return_status := FND_API.G_RET_STS_ERROR;

1725: END IF;
1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: x_msg_count := 1;
1731: x_msg_data := 'Fatal error in CZ_XML.restore_UI_Rule_ids() : '||SQLERRM;
1732: Close_Parser();
1733: END restore_UI_Rule_ids;

Line 1747: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1743:
1744: --dbms_output.enable(2000000);
1745:
1746: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1747: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1748:
1749: IF p_template_id IS NULL THEN
1750: FOR i IN(SELECT template_id FROM CZ_UI_TEMPLATES WHERE seeded_flag='0' AND deleted_flag='0')
1751: LOOP

Line 1782: x_return_status := FND_API.G_RET_STS_ERROR;

1778: END IF;
1779:
1780: EXCEPTION
1781: WHEN OTHERS THEN
1782: x_return_status := FND_API.G_RET_STS_ERROR;
1783: x_msg_count := 1;
1784: x_msg_data := 'Fatal error in CZ_XML.restore_TMPL_Rule_ids() : '||SQLERRM;
1785: Close_Parser();
1786: END restore_TMPL_Rule_ids;

Line 1896: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;

1892:
1893: BEGIN
1894:
1895: Initialize(x_run_id,x_return_status,x_msg_count,x_msg_data);
1896: x_return_status := FND_API.G_RET_STS_SUCCESS;x_msg_count:=0;
1897:
1898: Open_Parser();
1899:
1900: FOR i IN(SELECT a.ui_def_id FROM CZ_UI_DEFS a

Line 2040: x_return_status := FND_API.G_RET_STS_ERROR;

2036: Close_Parser();
2037:
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: x_return_status := FND_API.G_RET_STS_ERROR;
2041: x_msg_count := 1;
2042: x_msg_data := 'Fatal error in add_Template_References() : '||SQLERRM;
2043: END add_Template_References;
2044: