DBA Data[Home] [Help]

APPS.CZ_MODEL_MIGRATION_PVT dependencies on FND_API

Line 66: x_status := FND_API.G_RET_STS_SUCCESS;

62: IF(x_run_id IS NULL)THEN
63: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
64: END IF;
65:
66: x_status := FND_API.G_RET_STS_SUCCESS;
67:
68: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
69: WHERE migration_group_id = p_request_id AND deleted_flag = '0')LOOP
70:

Line 73: IF l_status <> 'OK' THEN x_status := FND_API.G_RET_STS_ERROR; END IF;

69: WHERE migration_group_id = p_request_id AND deleted_flag = '0')LOOP
70:
71: cz_pb_mgr.publish_model(c_pub.publication_id, x_run_id, l_status);
72:
73: IF l_status <> 'OK' THEN x_status := FND_API.G_RET_STS_ERROR; END IF;
74: END LOOP;
75: EXCEPTION
76: WHEN OTHERS THEN
77: x_status := FND_API.G_RET_STS_ERROR;

Line 77: x_status := FND_API.G_RET_STS_ERROR;

73: IF l_status <> 'OK' THEN x_status := FND_API.G_RET_STS_ERROR; END IF;
74: END LOOP;
75: EXCEPTION
76: WHEN OTHERS THEN
77: x_status := FND_API.G_RET_STS_ERROR;
78: l_errbuf := SQLERRM;
79: cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
80: END;
81: ---------------------------------------------------------------------------------------

Line 969: x_return_status := FND_API.G_RET_STS_SUCCESS;

965: BEGIN
966:
967:
968: FND_MSG_PUB.initialize;
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970:
971: --get the instance name(s) that has been converted
972: r_instance_name_tbl := get_target_name_if_converted();
973:

Line 1020: x_return_status := FND_API.G_RET_STS_ERROR;

1016: --if obselete exists
1017:
1018: IF (obselete_exists = '1') THEN
1019:
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021:
1022: --add message to the error stack
1023: CZ_UTILS.add_error_message_to_stack(p_message_name => 'CZ_OBSELETE_RECORDS_EXISTS',
1024: p_token_name1 => 'INSTANCE_NAME',

Line 1044: IF (p_commit_flag = FND_API.G_TRUE) THEN

1040: END LOOP;
1041:
1042: END IF;
1043:
1044: IF (p_commit_flag = FND_API.G_TRUE) THEN
1045: COMMIT;
1046: END IF;
1047:
1048: EXCEPTION